| Bug #110733 | RESET statement assertion error | ||
|---|---|---|---|
| Submitted: | 19 Apr 2023 13:30 | Modified: | 20 Apr 2023 15:50 |
| Reporter: | Pedro Ferreira | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S6 (Debug Builds) |
| Version: | 8.0.32 | OS: | Ubuntu (22.04) |
| Assigned to: | CPU Architecture: | x86 (x86_64) | |
| Tags: | reset, transaction | ||
[19 Apr 2023 13:45]
MySQL Verification Team
Hi MR. Ferreira, Thank you for your bug report. However, you have not been specific whether this is a problem that occurs only in replication or not ??? If it is replication environment, we need more description of your setup.
[19 Apr 2023 13:46]
Pedro Ferreira
No replication, just a single server. These were the server parameters: mysqld --no-defaults --user=mysql --basedir=... --datadir=... --plugin-dir=... --log-error=... --log-error-verbosity=3 --pid-file=... --port=3306 --mysqlx-port=3307 --slave-parallel-type=LOGICAL_CLOCK --slave-parallel-workers=4 --slave-preserve-commit-order=ON --enforce-gtid-consistency --gtid-mode=ON --binlog-format=ROW --server-id=1 --core-file --default-authentication-plugin=mysql_native_password
[20 Apr 2023 11:49]
MySQL Verification Team
Hi Mr. Ferreira, There is RESET SLAVE as a part of the test case. Should the test case be executed on the master or on the slave ?? Also, there are many statements affecting binary log. Can you provide test case without those statements.
[20 Apr 2023 13:12]
Pedro Ferreira
I tested on a regular MySQL database, so the master node I think. I tried to reduce the statements, but it makes the issue no longer reproducible.
[20 Apr 2023 13:22]
MySQL Verification Team
Hi, This makes a category for this report a case for the replication.
[20 Apr 2023 15:50]
MySQL Verification Team
Hi, Not much point of running "reset slave" on a standalone server but on another hand it should not crash - but this is not happening on release version, only on debug version of mysql server so not really sure this can be considered a bug. I'll verify so that replication team can have a look but IMHO this is not a bug.
[24 Apr 2023 10:11]
Sven Sandberg
Posted by developer:
Thank you for the bug report. A failed assertion is always a bug, regardless of the scenario being artificial or not. However, I am unable to reproduce the assertion. I used the following test case based on the bug description:
--source include/master-slave.inc
#CREATE SCHEMA test;
USE test;
CREATE TABLE t3 (c0 LONGTEXT, c1 TIME(6) AS (TIME '-837:40:49.559755178')
VIRTUAL);
CREATE TABLE t4 (c1 TINYINT UNSIGNED, c2 BOOLEAN);
CREATE TABLE t5 LIKE t3;
INSERT INTO t5(c0) VALUES ('a');
SET GLOBAL MAX_BINLOG_SIZE = 4096;
SET GLOBAL BINLOG_ROW_METADATA = 'FULL';
CREATE TABLE t14 (c0 MEDIUMBLOB);
CREATE TABLE t22 (c1 DATETIME(3), c2 INT AUTO_INCREMENT UNIQUE KEY, c3 INT,
c4 TIME) AS (SELECT DISTINCT bit_and(CAST('4737-8-24 5:37:52.2630953745' AS
DATETIME)), ((14160800) * (12901880)), TIME '809:11:30.2555984973' WHERE (NOT
CASE database() WHEN CASE WHEN pi() THEN CAST(X'8E' AS CHAR) WHEN pi() THEN
curdate() END THEN (4062807366) END) HAVING (((390329) IS NOT FALSE) AND
((rand() BETWEEN NULL AND (233)) OR (CAST('9734-11-11 6:10:18.34499434' AS
DATETIME) IS FALSE))));
CREATE TABLE t23 (c0 FLOAT, c1 VARCHAR(2977), c2 VARBINARY(44988), c3
MEDIUMINT UNSIGNED);
CREATE TABLE t24 (c0 INT, c2 INT AUTO_INCREMENT UNIQUE KEY, c3 TIME(0), c4
LONGTEXT);
CREATE VIEW t28 (c0, c1) AS (SELECT 1,2);
perl;
system("$MYSQL_DUMP -u root --flush-logs --single-transaction test --tables t23 > /dev/null &");
EOF
INSERT INTO t4(c1,c2) VALUES (160,1),(134,1);
TRUNCATE t24;
OPTIMIZE TABLE t22;
INSERT INTO t24(c0,c3,c4) VALUES (9993328,TIME
'720:28:0',CAST(X'307D374972091F294D' AS CHAR)),(14478437,TIME
'-691:51:58',CAST(X'7F3D26030F7A0F3B01653E590A60745C06066F51304B5D48185841'
AS CHAR)),(8187001,TIME
'161:27:12',CAST(X'2462591226423A461203474F11351C526E4B1A5B1A20605368' AS
CHAR)),(9373951,TIME '57:41:12',CAST(X'46' AS CHAR)),(7655864,TIME
'692:4:6',CAST(X'0D11755E69397D1343' AS CHAR)),(14258997,TIME
'-633:20:59.11260235700910296633',CAST(X'36' AS CHAR)),(16167901,TIME
'133:4:7.11864337348653627943',NULL),(4671096,TIME
'177:25:30',CAST(X'5E5B5C0A2C2E512654023A0E6A2B364B0717284D' AS
CHAR)),(NULL,TIME '162:25:48',CAST(X'1327463830401E3318404D4621576B224356' AS
CHAR)),(4117755,TIME '-524:18:32',CAST(X'7A2E' AS CHAR));
INSERT INTO t22(c1,c3,c4,`bit_and(CAST('4737-8-24 5:37:52.2630953745' AS
DATETIME))`,`((14160800) * (12901880))`,`TIME '809:11:30.2555984973'`) VALUES
(CAST('8605-8-13 17:22:59.8140871434285202690' AS
DATETIME),4686929,NULL,3575567208313518224,7016833572234518404,TIME
'495:18:51.16998240439853240754'),(CAST('6786-8-1
19:52:16.17106067972269639775' AS DATETIME),14745653,TIME
'30:2:4.10615825136169652896',11979119966179920116,-4788936688015399946,TIME
'-590:9:14.13323652489493953067'),(CAST('2368-7-9
5:13:27.1882332505619044892' AS DATETIME),14766609,TIME
'120:31:13.3440830827342295787',16832836108674740857,-9098266137862409949,TIME
'-106:39:42.11474796471021902313'),(CAST('7499-6-11
9:56:51.7159470216465294756' AS DATETIME),2234381,TIME
'39:49:52.17152775860273485088',4049039516135694938,8341933056013943136,TIME
'608:30:50.1262868463566112599'),(CAST('9771-4-8 5:2:36.12749929769928062921'
AS DATETIME),5173486,TIME
'409:54:55.17374131276673875718',2812811918893116537,-7986128638813694360,TIME
'98:17:47.7481491761834607140'),(CAST('6088-8-8
21:10:50.11067005203307242041' AS DATETIME),14142405,TIME
'-78:13:42.16620565908352419195',16475013802683230374,-3605946863502226187,TIM
E '-538:28:49.16408854191101391976'),(CAST('4984-6-26
8:39:21.598760615975390565' AS
DATETIME),12660833,NULL,17490459864582291379,8136640988206216490,TIME
'798:52:28.4177260805708884920'),(NULL,12074981,TIME
'295:45:46.2151777115034119105',9747348209091581249,-6001307095759843828,TIME
'173:8:56.4522067281105262762'),(CAST('8778-9-19 13:4:41.8283752043497302774'
AS DATETIME),3996388,TIME
'-547:20:24.4216112189098988224',17066373801078447565,-5711281438784739013,TIM
E '17:37:38.10043337757669783659'),(CAST('9898-3-29
20:51:21.15014328802036678846' AS DATETIME),6517020,TIME
'715:42:48.5146719147078162246',16617332730946904379,4459992805484066526,TIME
'-106:17:52.4922545864669909499'),(CAST('3636-11-10
3:2:11.11846346806620956163' AS DATETIME),14582076,TIME
'541:48:30.10352980938419035116',9897092790199210056,7508680396464225512,TIME
'239:35:16.5945443281862664063'),(CAST('1129-8-12
16:18:29.17051489635684361668' AS DATETIME),11462760,TIME
'158:51:31.15104970787797478540',1638256464595805174,-7053627705102860771,TIME
'-321:14:15.17659063262366636595'),(CAST('4125-12-31
5:21:3.12883981922070177656' AS DATETIME),5220089,TIME
'-52:5:44.651878333203744797',1403145133104833478,-3557233636886451215,TIME
'564:42:49.15678898901895898506'),(CAST('6989-9-15
22:14:32.8719863552653744012' AS DATETIME),8956873,TIME
'-53:42:46.10306462846698615456',5969874227145737126,-2775703691220543361,TIME
'592:50:2.12360562227724855078'),(CAST('6984-8-26
21:11:47.14244081329949916367' AS DATETIME),13250080,TIME
'474:28:59.11079379834194555714',14290184657983532170,-7178291024104408438,TIM
E '195:4:39.1838280107033678186'),(CAST('3346-3-17
7:18:40.13312326777461432151' AS DATETIME),7337107,TIME
'-25:1:28.3915458697940879829',9894027012082821824,8876104692404975322,TIME
'-506:29:13.180284549816418515'),(NULL,867204,TIME
'809:7:10.16390150464504427063',11966802096495833780,5101565907780435264,TIME
'-784:26:26.5251506704386274949'),(CAST('6882-6-4
19:35:39.18070430095533821261' AS DATETIME),12104401,TIME
'-158:30:14.1633420554258849449',3532314811422578325,1369247332079517564,TIME
'-306:39:40.7543951201027102355'),(CAST('6393-12-10
1:44:18.8113860274842985789' AS DATETIME),2342619,TIME
'710:57:59.2550694126926225229',10093265014900217200,2607286370714211770,TIME
'-764:49:22.6892127795269655381'),(CAST('1470-9-14
8:59:4.12676338714340739785' AS DATETIME),8090727,TIME
'-568:59:56.5332531513953369119',7356866884398839331,8649610855336509047,TIME
'-100:7:25.17900870806069546478');
REPLACE INTO t5 (c0) (SELECT t5.c1 FROM t5);
ALTER VIEW t28 (c0, c1, c2) AS (SELECT t3.c1, 1, CAST((73) AS YEAR) FROM t3
HAVING (character_length(245.516) = CASE 1 WHEN (-12647) THEN CAST(.223E72 AS
SIGNED) END));
CREATE TABLE t29 LIKE t14;
CREATE TABLE t30 (c0 INT, c1 INT);
START TRANSACTION;
INSERT INTO t23(c0,c1,c2,c3) VALUES (1,CAST(X'39382D' AS
CHAR),CAST(X'0658693717F2723BE0622611AA35AEF2D18FBB2E' AS
BINARY),3912939),(1,CAST(X'3233632B5141686F4A6B5344072A3F054F795E051C07506E0F3
C1F' AS CHAR),CAST(X'4F150B7238B9400D7BAAE986D757F9956B661A1A' AS
BINARY),1643902);
RESET SLAVE;
[24 Apr 2023 12:17]
MySQL Verification Team
Thank you, Sven. It has been already noticed in this report, that this bug tangents only debug builds. We do not see from your report which binary have you used ......
Description: This issue is more difficult to reproduce than the previous ones. I was having a hard time reducing the query log, plus I am busy, so I leave with this rather long reproducible log. On a fresh database run these statements: CREATE SCHEMA test; USE test; CREATE TABLE t3 (c0 LONGTEXT, c1 TIME(6) AS (TIME '-837:40:49.559755178') VIRTUAL); CREATE TABLE t4 (c1 TINYINT UNSIGNED, c2 BOOLEAN); CREATE TABLE t5 LIKE t3; INSERT INTO t5(c0) VALUES ('a'); SET GLOBAL MAX_BINLOG_SIZE = 4096; SET GLOBAL BINLOG_ROW_METADATA = 'FULL'; CREATE TABLE t14 (c0 MEDIUMBLOB); CREATE TABLE t22 (c1 DATETIME(3), c2 INT AUTO_INCREMENT UNIQUE KEY, c3 INT, c4 TIME) AS (SELECT DISTINCT bit_and(CAST('4737-8-24 5:37:52.2630953745' AS DATETIME)), ((14160800) * (12901880)), TIME '809:11:30.2555984973' WHERE (NOT CASE database() WHEN CASE WHEN pi() THEN CAST(X'8E' AS CHAR) WHEN pi() THEN curdate() END THEN (4062807366) END) HAVING (((390329) IS NOT FALSE) AND ((rand() BETWEEN NULL AND (233)) OR (CAST('9734-11-11 6:10:18.34499434' AS DATETIME) IS FALSE)))); CREATE TABLE t23 (c0 FLOAT, c1 VARCHAR(2977), c2 VARBINARY(44988), c3 MEDIUMINT UNSIGNED); CREATE TABLE t24 (c0 INT, c2 INT AUTO_INCREMENT UNIQUE KEY, c3 TIME(0), c4 LONGTEXT); CREATE VIEW t28 (c0, c1) AS (SELECT 1,2); Then without leaving the current client, on the side run: mysqldump -u root --flush-logs --single-transaction test --tables t23 then back to the client: INSERT INTO t4(c1,c2) VALUES (160,1),(134,1); TRUNCATE t24; OPTIMIZE TABLE t22; INSERT INTO t24(c0,c3,c4) VALUES (9993328,TIME '720:28:0',CAST(X'307D374972091F294D' AS CHAR)),(14478437,TIME '-691:51:58',CAST(X'7F3D26030F7A0F3B01653E590A60745C06066F51304B5D48185841' AS CHAR)),(8187001,TIME '161:27:12',CAST(X'2462591226423A461203474F11351C526E4B1A5B1A20605368' AS CHAR)),(9373951,TIME '57:41:12',CAST(X'46' AS CHAR)),(7655864,TIME '692:4:6',CAST(X'0D11755E69397D1343' AS CHAR)),(14258997,TIME '-633:20:59.11260235700910296633',CAST(X'36' AS CHAR)),(16167901,TIME '133:4:7.11864337348653627943',NULL),(4671096,TIME '177:25:30',CAST(X'5E5B5C0A2C2E512654023A0E6A2B364B0717284D' AS CHAR)),(NULL,TIME '162:25:48',CAST(X'1327463830401E3318404D4621576B224356' AS CHAR)),(4117755,TIME '-524:18:32',CAST(X'7A2E' AS CHAR)); INSERT INTO t22(c1,c3,c4,`bit_and(CAST('4737-8-24 5:37:52.2630953745' AS DATETIME))`,`((14160800) * (12901880))`,`TIME '809:11:30.2555984973'`) VALUES (CAST('8605-8-13 17:22:59.8140871434285202690' AS DATETIME),4686929,NULL,3575567208313518224,7016833572234518404,TIME '495:18:51.16998240439853240754'),(CAST('6786-8-1 19:52:16.17106067972269639775' AS DATETIME),14745653,TIME '30:2:4.10615825136169652896',11979119966179920116,-4788936688015399946,TIME '-590:9:14.13323652489493953067'),(CAST('2368-7-9 5:13:27.1882332505619044892' AS DATETIME),14766609,TIME '120:31:13.3440830827342295787',16832836108674740857,-9098266137862409949,TIME '-106:39:42.11474796471021902313'),(CAST('7499-6-11 9:56:51.7159470216465294756' AS DATETIME),2234381,TIME '39:49:52.17152775860273485088',4049039516135694938,8341933056013943136,TIME '608:30:50.1262868463566112599'),(CAST('9771-4-8 5:2:36.12749929769928062921' AS DATETIME),5173486,TIME '409:54:55.17374131276673875718',2812811918893116537,-7986128638813694360,TIME '98:17:47.7481491761834607140'),(CAST('6088-8-8 21:10:50.11067005203307242041' AS DATETIME),14142405,TIME '-78:13:42.16620565908352419195',16475013802683230374,-3605946863502226187,TIME '-538:28:49.16408854191101391976'),(CAST('4984-6-26 8:39:21.598760615975390565' AS DATETIME),12660833,NULL,17490459864582291379,8136640988206216490,TIME '798:52:28.4177260805708884920'),(NULL,12074981,TIME '295:45:46.2151777115034119105',9747348209091581249,-6001307095759843828,TIME '173:8:56.4522067281105262762'),(CAST('8778-9-19 13:4:41.8283752043497302774' AS DATETIME),3996388,TIME '-547:20:24.4216112189098988224',17066373801078447565,-5711281438784739013,TIME '17:37:38.10043337757669783659'),(CAST('9898-3-29 20:51:21.15014328802036678846' AS DATETIME),6517020,TIME '715:42:48.5146719147078162246',16617332730946904379,4459992805484066526,TIME '-106:17:52.4922545864669909499'),(CAST('3636-11-10 3:2:11.11846346806620956163' AS DATETIME),14582076,TIME '541:48:30.10352980938419035116',9897092790199210056,7508680396464225512,TIME '239:35:16.5945443281862664063'),(CAST('1129-8-12 16:18:29.17051489635684361668' AS DATETIME),11462760,TIME '158:51:31.15104970787797478540',1638256464595805174,-7053627705102860771,TIME '-321:14:15.17659063262366636595'),(CAST('4125-12-31 5:21:3.12883981922070177656' AS DATETIME),5220089,TIME '-52:5:44.651878333203744797',1403145133104833478,-3557233636886451215,TIME '564:42:49.15678898901895898506'),(CAST('6989-9-15 22:14:32.8719863552653744012' AS DATETIME),8956873,TIME '-53:42:46.10306462846698615456',5969874227145737126,-2775703691220543361,TIME '592:50:2.12360562227724855078'),(CAST('6984-8-26 21:11:47.14244081329949916367' AS DATETIME),13250080,TIME '474:28:59.11079379834194555714',14290184657983532170,-7178291024104408438,TIME '195:4:39.1838280107033678186'),(CAST('3346-3-17 7:18:40.13312326777461432151' AS DATETIME),7337107,TIME '-25:1:28.3915458697940879829',9894027012082821824,8876104692404975322,TIME '-506:29:13.180284549816418515'),(NULL,867204,TIME '809:7:10.16390150464504427063',11966802096495833780,5101565907780435264,TIME '-784:26:26.5251506704386274949'),(CAST('6882-6-4 19:35:39.18070430095533821261' AS DATETIME),12104401,TIME '-158:30:14.1633420554258849449',3532314811422578325,1369247332079517564,TIME '-306:39:40.7543951201027102355'),(CAST('6393-12-10 1:44:18.8113860274842985789' AS DATETIME),2342619,TIME '710:57:59.2550694126926225229',10093265014900217200,2607286370714211770,TIME '-764:49:22.6892127795269655381'),(CAST('1470-9-14 8:59:4.12676338714340739785' AS DATETIME),8090727,TIME '-568:59:56.5332531513953369119',7356866884398839331,8649610855336509047,TIME '-100:7:25.17900870806069546478'); REPLACE INTO t5 (c0) (SELECT t5.c1 FROM t5); ALTER VIEW t28 (c0, c1, c2) AS (SELECT t3.c1, 1, CAST((73) AS YEAR) FROM t3 HAVING (character_length(245.516) = CASE 1 WHEN (-12647) THEN CAST(.223E72 AS SIGNED) END)); CREATE TABLE t29 LIKE t14; CREATE TABLE t30 (c0 INT, c1 INT); START TRANSACTION; INSERT INTO t23(c0,c1,c2,c3) VALUES (1,CAST(X'39382D' AS CHAR),CAST(X'0658693717F2723BE0622611AA35AEF2D18FBB2E' AS BINARY),3912939),(1,CAST(X'3233632B5141686F4A6B5344072A3F054F795E051C07506E0F3C1F' AS CHAR),CAST(X'4F150B7238B9400D7BAAE986D757F9956B661A1A' AS BINARY),1643902); RESET SLAVE; The RESET statement will trigger an assertion error at sql/sql_parse.cc:4877: assert(!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()); The compilation parameters are the same as issue 108148: -DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77 How to repeat: Run the statements above.