[MDEV-18182] Galera test failure on galera.galera_many_tables_nopk Created: 2019-01-09  Updated: 2023-07-21  Resolved: 2022-05-16

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

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


 Description   

galera.galera_many_tables_nopk 'innodb'  w3 [ fail ]  timeout after 900 seconds
        Test ended at 2019-01-09 09:50:06
 
Test case timeout after 900 seconds
 
== /home/jan/mysql/10.4-galera-2/mysql-test/var/3/log/galera_many_tables_nopk.log == 
START TRANSACTION;
COMMIT;
connection node_2;
CREATE TABLE sum_table (f1 INTEGER);
SELECT SUM(f1) = 900 FROM sum_table;
SUM(f1) = 900
1
connection node_1;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
connection node_2;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
UPDATE t900 SET f1 = 3;
connection node_1;
COMMIT;
connection node_2;
COMMIT;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
DROP SCHEMA test;
 
 == /home/jan/mysql/10.4-galera-2/mysql-test/var/3/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/home/jan/mysql/10.4-galera-2/mysql-test/var/tmp/3/mysqld.1.sock' (111)
 
 == /home/jan/mysql/10.4-galera-2/mysql-test/var/3/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/home/jan/mysql/10.4-galera-2/mysql-test/var/tmp/3/mysqld.2.sock' (111)
 
 
 - saving '/home/jan/mysql/10.4-galera-2/mysql-test/var/3/log/galera.galera_many_tables_nopk-innodb/' to '/home/jan/mysql/10.4-galera-2/mysql-test/var/log/galera.galera_many_tables_nopk-innodb/'
***Warnings generated in error logs during shutdown after running tests: galera.galera_many_rows galera.galera_bf_lock_wait galera.galera_many_tables_nopk galera.galera_many_columns galera.galera_fulltext
 
Attempting backtrace. You can use the following information to find out
Attempting backtrace. You can use the following information to find out


Generated at Thu Feb 08 08:42:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.