[MDEV-22996] Hang on galera_toi_truncate test case Created: 2020-06-24  Updated: 2023-07-21  Resolved: 2022-01-21

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: Text File stack_full.txt    

 Description   

galera.galera_toi_truncate 'innodb'      w4 [ fail ]  timeout after 900 seconds
        Test ended at 2020-06-24 09:40:02
 
Test case timeout after 900 seconds
 
== /home/jan/mysql/10.4/mysql-test/var/4/log/galera_toi_truncate.log == 
connection node_2;
connection node_1;
connection node_1;
CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
connection node_2;
SET SESSION wsrep_retry_autocommit = 0;
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6, ten AS a7, ten AS a8;
connection node_1;
TRUNCATE TABLE t1;;
connection node_2;



 Comments   
Comment by Jan Lindström (Inactive) [ 2020-06-24 ]

How to repeat (sometimes):

  • branch: 10.4 commit b80b52394d41a4c334642ae8b3af16f76f6fac57
  • galera library: 26.4.5
  • ./mtr --suite=wsrep,galera,galera_sr,galera_3nodes --force --parallel=4 --big-test
Comment by Marko Mäkelä [ 2020-07-02 ]

The test is taking quite a lot of time also on 10.3. I aborted the execution after the server had consumed 14 CPU minutes. Some observations:

  • INSERT…SELECT in InnoDB will acquire explicit locks on the source table, making it very slow.
  • The Cartesian product on InnoDB tables in the test should better be replaced with something like INSERT INTO t1 SELECT 1 FROM seq_1_to_100000000.
  • Does the test really have to insert 10⁸ rows? Which scenario is it attempting to cover?
  • MDEV-13564 in MariaDB 10.2.19 could have radically affected the test scenario. Do we really need this test in its current form?
Comment by Seppo Jaakola [ 2020-07-02 ]

a PR to fix the test will be submitted today

Comment by Julien Fritsch [ 2020-12-03 ]

Found in disabled.def that it was disabled, also I'm adding the missing label.

Comment by Julien Fritsch [ 2020-12-03 ]

Found in disabled.def for ES that it was disabled, also I'm adding the missing label.

Generated at Thu Feb 08 09:19:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.