[MDEV-18761] galera.galera_var_slave_threads: Test failure: mysql_socket.h:779: mysqld got signal 6 Created: 2019-02-27  Updated: 2020-03-09  Resolved: 2020-01-17

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

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Teemu Ollakka
Resolution: Cannot Reproduce Votes: 0
Labels: galera, galera_4
Environment:

OS: CentOS Linux release 7.6.1810 (Core).


Attachments: Zip Archive 190227_galera.galera_var_slave_threads-innodb.zip     Text File 190227_stdout_desktop.log     Text File 190403_galera_stdout.log    
Issue Links:
Relates
relates to MDEV-18111 Galera 4: run galera test suite Closed
relates to MDEV-21670 galera_var_slave_threads MTR failed: ... Closed

 Description   

MariaDB Server: 10.4.3-MariaDB-debug built from sources, branch=10.4, commit: c568e25379600db8af4bd39df4761ba0fbc1a14e.
Galera4 lib 26.4.0(r4477): debug built from sources, commit: 9bd47835d0fcdcf2f041da39dbe5b98ff738ff10.

Run:

./mtr --suite galera --force --big-test --max-test-fail=0 --parallel=auto

stdout.log: (attached 190227_stdout_desktop.log)

galera.galera_var_slave_threads 'innodb' w4 [ fail ]
 
mysqltest: At line 114: query 'SET GLOBAL wsrep_cluster_address=''' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
SET GLOBAL wsrep_slave_threads = 1;
connection node_1;
connection node_2;
SELECT COUNT(*) FROM t2;
COUNT(*)
64
SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%';
COUNT(*)
1
SET GLOBAL wsrep_slave_threads = 5;
SET GLOBAL wsrep_slave_threads = 1;
connection node_2;
Shutting down server ...
connection node_1;
show status like 'wsrep_cluster_size';
Variable_name	Value
wsrep_cluster_size	1
SET GLOBAL wsrep_slave_threads = 6;
SET GLOBAL wsrep_slave_threads = 1;
SET GLOBAL wsrep_cluster_address='';
 
mysqld: /home/stepan/galera/git/10.4/server/include/mysql/psi/mysql_socket.h:779: inline_mysql_socket_recv: Assertion `mysql_socket.fd != -1' failed.
190227 13:48:16 [ERROR] mysqld got signal 6 ;

See also attached 190227_galera.galera_var_slave_threads-innodb.zip.

Note: This test is failed sporadically.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-03-28 ]

It's not reproduced on my machines, but it is reproduced on buildbot:
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/1721/steps/mtr-galera/logs/stdio

Comment by Stepan Patryshev (Inactive) [ 2019-04-05 ]

It was reproduced occasionally again on my machine, see 190403_galera_stdout.log.

Comment by Jan Lindström (Inactive) [ 2019-10-16 ]

teemu.ollakka I have seen this assertion time to time, not repeatable most of time but sometimes when you run full mtr i.e. ./mtr --suite=wsrep,galera,sys_vars --force --big-test . Assertion means that we try to write a connection that has been already closed.

Comment by Stepan Patryshev (Inactive) [ 2019-12-19 ]

It fails on bb approximately about one time per month:
http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=10.4&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=&fail_variant=&fail_info_short=&fail_info_full=galera_var_slave_threads&limit=100

Comment by Stepan Patryshev (Inactive) [ 2020-01-17 ]

Closed since it is not failed on CI.

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