300 lines
7.3 KiB
Plaintext
300 lines
7.3 KiB
Plaintext
--echo #
|
|
--echo # Bug #21025880 DUPLICATE UK VALUES IN READ-COMMITTED(AGAIN)
|
|
--echo #
|
|
|
|
--source include/have_debug.inc
|
|
--source include/have_debug_sync.inc
|
|
|
|
let i=0;
|
|
|
|
while ($i <=2 )
|
|
{
|
|
|
|
CREATE TABLE t1 (
|
|
a INT NOT NULL,
|
|
b INT NOT NULL,
|
|
PRIMARY KEY(b),
|
|
UNIQUE KEY(a))
|
|
ENGINE=INNODB;
|
|
|
|
SET @old_innodb_stats_auto_recalc = @@innodb_stats_auto_recalc;
|
|
SET GLOBAL innodb_stats_auto_recalc = OFF;
|
|
|
|
# Block purge
|
|
SET GLOBAL innodb_purge_stop_now = ON;
|
|
|
|
SET @old_transaction_isolation = @@transaction_isolation;
|
|
SET GLOBAL transaction_isolation = 'READ-COMMITTED';
|
|
|
|
SET @old_innodb_lock_wait_timeout = @@innodb_lock_wait_timeout;
|
|
SET GLOBAL innodb_lock_wait_timeout = 1;
|
|
|
|
--connect(con1,localhost,root,,)
|
|
--connect(con2,localhost,root,,)
|
|
|
|
--connection con1
|
|
|
|
# Create and delete-mark an index record
|
|
|
|
INSERT INTO t1 VALUES (1,1),(2,2);
|
|
DELETE FROM t1;
|
|
|
|
|
|
SET debug_sync = 'row_ins_sec_index_entry_dup_locks_created SIGNAL
|
|
con1_locks_done WAIT_FOR con1_go';
|
|
SET debug_sync = 'ha_commit_trans_after_acquire_commit_lock SIGNAL
|
|
con1_insert_done WAIT_FOR con1_finish';
|
|
--send
|
|
|
|
if ( $i == 0 )
|
|
{
|
|
REPLACE INTO t1 VALUES (1,2);
|
|
}
|
|
|
|
if ( $i == 1 )
|
|
{
|
|
INSERT INTO t1 values (1,2) ON DUPLICATE KEY UPDATE a=2;
|
|
}
|
|
|
|
if ( $i == 2 )
|
|
{
|
|
INSERT INTO t1 VALUES (1,2);
|
|
}
|
|
|
|
|
|
--connection con2
|
|
|
|
SET debug_sync = 'now WAIT_FOR con1_locks_done';
|
|
SET debug_sync = 'lock_wait_suspend_thread_enter SIGNAL con2_blocked
|
|
WAIT_FOR con2_go';
|
|
SET debug_sync = 'ha_commit_trans_after_acquire_commit_lock SIGNAL
|
|
con2_insert_done WAIT_FOR con2_finish';
|
|
SET debug_sync = 'ib_after_row_insert SIGNAL con2_insert_done';
|
|
|
|
--send
|
|
REPLACE INTO t1 VALUES (1,3);
|
|
|
|
--connection default
|
|
SET debug_sync = 'now WAIT_FOR con2_blocked';
|
|
|
|
SET GLOBAL innodb_purge_run_now=ON;
|
|
|
|
# Wait for purge to delete the delete-marked record
|
|
--source include/wait_innodb_all_purged.inc
|
|
|
|
SET debug_sync = 'now SIGNAL con2_go WAIT_FOR con2_insert_done';
|
|
SET debug_sync = 'now SIGNAL con1_go WAIT_FOR con1_insert_done';
|
|
SET debug_sync = 'now SIGNAL con1_finish';
|
|
SET debug_sync = 'now SIGNAL con2_finish';
|
|
|
|
--connection con1
|
|
--reap
|
|
|
|
--connection con2
|
|
--error 0,ER_LOCK_WAIT_TIMEOUT
|
|
--reap
|
|
|
|
--connection default
|
|
|
|
--disconnect con1
|
|
--disconnect con2
|
|
|
|
SELECT * FROM t1;
|
|
CHECK TABLE t1;
|
|
|
|
DROP TABLE t1;
|
|
|
|
SET GLOBAL innodb_stats_auto_recalc = @old_innodb_stats_auto_recalc;
|
|
SET GLOBAL transaction_isolation = @old_transaction_isolation;
|
|
SET GLOBAL innodb_lock_wait_timeout = @old_innodb_lock_wait_timeout;
|
|
|
|
# Clean up resources used in this test case.
|
|
--disable_warnings
|
|
SET DEBUG_SYNC= 'RESET';
|
|
--enable_warnings
|
|
|
|
--inc $i
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
--echo #
|
|
--echo # Bug#24344131 ASSERT !OTHER_LOCK IN LOCK_REC_ADD_TO_QUEUE AT LOCK0LOCK.CC:1641
|
|
--echo #
|
|
|
|
connect (con1,localhost,root,,);
|
|
connect (con2,localhost,root,,);
|
|
connect (con3,localhost,root,,);
|
|
|
|
connection con1;
|
|
CREATE TABLE t1(a INT, b INT, primary key(a));
|
|
INSERT INTO t1 VALUES(101, 20);
|
|
SET DEBUG_SYNC="before_lock_trx_release_locks SIGNAL s3 WAIT_FOR s5";
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES(10, 20);
|
|
|
|
connection con2;
|
|
SET DEBUG_SYNC="before_lock_rec_convert_impl_to_expl_for_trx SIGNAL s2 WAIT_FOR s4";
|
|
SET DEBUG_SYNC="before_lock_wait_suspend SIGNAL s5 WAIT_FOR s7";
|
|
--send UPDATE t1 SET b=25 WHERE a=10
|
|
|
|
connection con1;
|
|
SET DEBUG_SYNC="now WAIT_FOR s2";
|
|
--send COMMIT
|
|
|
|
connection con3;
|
|
SET DEBUG_SYNC="now WAIT_FOR s3";
|
|
SET DEBUG_SYNC="after_lock_clust_rec_read_check_and_lock SIGNAL s4 WAIT_FOR s6";
|
|
--send UPDATE t1 SET b=30 WHERE a=10
|
|
|
|
connection con1;
|
|
--reap
|
|
SET DEBUG_SYNC="now SIGNAL s6";
|
|
|
|
connection con3;
|
|
--reap
|
|
SET DEBUG_SYNC="now SIGNAL s7";
|
|
|
|
connection con2;
|
|
--reap
|
|
|
|
connection default;
|
|
|
|
DROP TABLE t1;
|
|
|
|
--disconnect con1
|
|
--disconnect con2
|
|
|
|
|
|
--echo #
|
|
--echo # Bug #29004362 LOCK->TRX->DUPLICATES CAN NOT BE USED TO DETERMINE IF
|
|
--echo # LOCK IS CREATED BY IODKU
|
|
--echo #
|
|
|
|
CREATE TABLE t1 (
|
|
a INT NOT NULL,
|
|
b INT NOT NULL,
|
|
c INT NOT NULL,
|
|
PRIMARY KEY(b),
|
|
UNIQUE KEY(a),
|
|
UNIQUE KEY(c))
|
|
ENGINE=INNODB;
|
|
|
|
SET @old_innodb_stats_auto_recalc = @@innodb_stats_auto_recalc;
|
|
SET GLOBAL innodb_stats_auto_recalc = OFF;
|
|
|
|
# Block purge
|
|
SET GLOBAL innodb_purge_stop_now = ON;
|
|
|
|
SET @old_transaction_isolation = @@transaction_isolation;
|
|
SET GLOBAL transaction_isolation = 'READ-COMMITTED';
|
|
|
|
SET @old_innodb_lock_wait_timeout = @@innodb_lock_wait_timeout;
|
|
SET GLOBAL innodb_lock_wait_timeout = 1;
|
|
|
|
# Create and delete-mark an index record
|
|
INSERT INTO t1 VALUES (1,1,1),(2,2,2);
|
|
DELETE FROM t1;
|
|
INSERT INTO t1 VALUES (5,5,5),(7,7,7);
|
|
|
|
--connect(con1,localhost,root,,)
|
|
--connect(con2,localhost,root,,)
|
|
|
|
--connection con1
|
|
|
|
BEGIN;
|
|
INSERT INTO t1 VALUES (1,4,7) ON DUPLICATE KEY UPDATE b=6;
|
|
|
|
--connection default
|
|
SELECT MAX(engine_transaction_id) INTO @con1_trx_id FROM performance_schema.data_locks WHERE object_schema='test' AND object_name = 't1';
|
|
--echo # LOCKS AFTER IODKU
|
|
SELECT IF(engine_transaction_id=@con1_trx_id, "con1", "other") as con,
|
|
index_name,lock_type,lock_mode,lock_status,lock_data
|
|
FROM performance_schema.data_locks
|
|
WHERE object_schema='test' AND object_name = 't1'
|
|
ORDER BY 1,2,3,4,5,6;
|
|
|
|
--connection con1
|
|
SET debug_sync = 'row_ins_sec_index_entry_dup_locks_created SIGNAL
|
|
con1_locks_done WAIT_FOR con1_go';
|
|
|
|
--send INSERT INTO t1 VALUES (1,2,3);COMMIT
|
|
|
|
--connection default
|
|
SET debug_sync = 'now WAIT_FOR con1_locks_done';
|
|
--echo # LOCKS AFTER con1_locks_done
|
|
SELECT IF(engine_transaction_id=@con1_trx_id, "con1", "other") as con,
|
|
index_name,lock_type,lock_mode,lock_status,lock_data
|
|
FROM performance_schema.data_locks
|
|
WHERE object_schema='test' AND object_name = 't1'
|
|
ORDER BY 1,2,3,4,5,6;
|
|
|
|
SELECT COUNT(*) FROM performance_schema.data_locks
|
|
WHERE object_schema='test'
|
|
AND object_name='t1'
|
|
AND index_name='a'
|
|
AND lock_type='RECORD'
|
|
AND lock_data='5, 5';
|
|
|
|
SET GLOBAL innodb_purge_run_now=ON;
|
|
|
|
# Wait for purge to delete the delete-marked record
|
|
let $wait_condition=
|
|
SELECT COUNT(*) = 1 FROM performance_schema.data_locks
|
|
WHERE object_schema='test'
|
|
AND object_name='t1'
|
|
AND index_name='a'
|
|
AND lock_type='RECORD'
|
|
AND lock_data='5, 5';
|
|
--source include/wait_condition.inc
|
|
|
|
--echo # LOCKS AFTER purge
|
|
SELECT IF(engine_transaction_id=@con1_trx_id, "con1", "other") as con,
|
|
index_name,lock_type,lock_mode,lock_status,lock_data
|
|
FROM performance_schema.data_locks
|
|
WHERE object_schema='test' AND object_name = 't1'
|
|
ORDER BY 1,2,3,4,5,6;
|
|
|
|
--connection con2
|
|
# We actually expect ER_LOCK_WAIT_TIMEOUT, but we let a buggy implementation
|
|
# continue, so that we can capture more information about locks and rows,
|
|
# and in particular if there are two rows with a=1 in the end.
|
|
--error 0, ER_LOCK_WAIT_TIMEOUT
|
|
INSERT t1 VALUES (1,10,4);
|
|
|
|
--connection default
|
|
|
|
--echo # LOCKS AFTER con2
|
|
SELECT IF(engine_transaction_id=@con1_trx_id, "con1", "other") as con,
|
|
index_name,lock_type,lock_mode,lock_status,lock_data
|
|
FROM performance_schema.data_locks
|
|
WHERE object_schema='test' AND object_name = 't1'
|
|
ORDER BY 1,2,3,4,5,6;
|
|
|
|
SET debug_sync = 'now SIGNAL con1_go';
|
|
|
|
|
|
--connection con1
|
|
--reap
|
|
|
|
--connection default
|
|
|
|
--disconnect con1
|
|
--disconnect con2
|
|
|
|
SELECT * FROM t1;
|
|
CHECK TABLE t1;
|
|
|
|
DROP TABLE t1;
|
|
|
|
SET GLOBAL innodb_stats_auto_recalc = @old_innodb_stats_auto_recalc;
|
|
SET GLOBAL transaction_isolation = @old_transaction_isolation;
|
|
SET GLOBAL innodb_lock_wait_timeout = @old_innodb_lock_wait_timeout;
|
|
|
|
# Clean up resources used in this test case.
|
|
--disable_warnings
|
|
SET DEBUG_SYNC= 'RESET';
|
|
--enable_warnings
|