Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.16
-
None
-
RHEL 8, with 2 DB nodes and 1 Arbitrator
Description
Got signal 6 error in 10.6.16 in the following scenario:
1. CREATE SEQUENCE s INCREMENT=0 cache 100;
2. CREATE TABLE t2 ( id int primary key default (next value for s), name varchar(50));
3. Create test.sql file like (see test.sql.zip attached):
insert into test.t2 (name) values ('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),(
'AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),
('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA')
,('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'
),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA
'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAA
A'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AA
AA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('A
AAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('
AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),(
'AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),
('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA'),('AAAA');
insert into test.t2 (name) values ('AAAA')....
[repeat above line for 1000000 times in the file]
4. Set autocommit=ON
5. On both nodes load the test.sql file by running the command:
mysql -h..... --port.... -u... -p... < test.sql
if exited with "Deadlock" error, run the it again.
6. After several tries, get signal 6 error on one of the DB server:
2024-04-05 14:50:52 4190 [ERROR] WSREP: FSM: no such a transition REPLICATING -> COMMITTED
240405 14:50:52 [ERROR] mysqld got signal 6 ;
Sorry, we probably made a mistake, and this is a bug.
Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
7. If CREATE SEQUENCE with cache 10000, it can load the test.sql file sucessfully.