Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.11
-
Can result in hang or crash
-
Q4/2025 Server Maintenance
Description
set sql_mode=''; |
CREATE TABLE t (c INT KEY,c2 BLOB UNIQUE)Engine=InnoDB; |
INSERT INTO t VALUES (0,''); |
REPLACE INTO t (c2) VALUES (0); |
Leads to:
CS 10.11.15 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a (Optimized, Clang) Build 07/08/2025 |
InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON
|
CS 10.11.15 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a (Optimized, Clang) Build 07/08/2025 |
Core was generated by `/test/MD070825-mariadb-10.11.15-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
 |
[Current thread is 1 (LWP 4186027)]
|
(gdb) bt
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
|
#3 0x0000744e6584527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x0000744e658288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x000063f742798aba in ut_dbg_assertion_failed (expr=0x63f7432a11fa "node->pcur->rel_pos == BTR_PCUR_ON", file=0x63f7432a0c87 "/test/10.11_opt/storage/innobase/row/row0mysql.cc", line=line@entry=1640) at /test/10.11_opt/storage/innobase/ut/ut0dbg.cc:60
|
#6 0x000063f742eaedc6 in row_update_for_mysql (prebuilt=0x744d78025c90)at /test/10.11_opt/storage/innobase/row/row0mysql.cc:1640
|
#7 0x000063f742df3c73 in ha_innobase::update_row (this=0x744d780211e8, old_row=0x744d78021a00 "p", new_row=0x744d780219e8 <incomplete sequence \374>)at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:8621
|
#8 0x000063f742b3ab23 in handler::ha_update_row (this=0x744d780211e8, old_data=0x744d78021a00 "p", new_data=0x744d780219e8 <incomplete sequence \374>)at /test/10.11_opt/sql/handler.cc:7832
|
#9 0x000063f7428aee31 in Write_record::replace_row (this=this@entry=0x744e645c7a60, inserted=inserted@entry=0x744e645c7a38, deleted=deleted@entry=0x744e645c7a40)at /test/10.11_opt/sql/sql_insert.cc:2117
|
#10 0x000063f7428ae20f in Write_record::write_record (this=this@entry=0x744e645c7a60) at /test/10.11_opt/sql/sql_insert.cc:2364
|
#11 0x000063f7428abf62 in mysql_insert (thd=thd@entry=0x744d78000c68, table_list=0x744d78010d38, fields=@0x744d78005e98: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x744d78011570, last = 0x744d78011570, elements = 1}, <No data fields>}, values_list=@0x744d78005ee0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x744d78011af0, last = 0x744d78011af0, elements = 1}, <No data fields>}, update_fields=@0x744d78005ec8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x63f743aad350 <end_of_list>, last = 0x744d78005ec8, elements = 0}, <No data fields>}, update_values=@0x744d78005eb0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x63f743aad350 <end_of_list>, last = 0x744d78005eb0, elements = 0}, <No data fields>}, duplic=DUP_REPLACE, ignore=<optimized out>, result=0x0)at /test/10.11_opt/sql/sql_insert.cc:1217
|
#12 0x000063f7428e80ee in mysql_execute_command (thd=thd@entry=0x744d78000c68, is_called_from_prepared_stmt=<optimized out>)at /test/10.11_opt/sql/sql_parse.cc:4628
|
#13 0x000063f7428e09b1 in mysql_parse (thd=thd@entry=0x744d78000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x744e645c8480)at /test/10.11_opt/sql/sql_parse.cc:8180
|
#14 0x000063f7428dee6c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x744d78000c68, packet=packet@entry=0x744d780086d9 "REPLACE INTO t (c2) VALUES (0)", packet_length=packet_length@entry=30, blocking=true)at /test/10.11_opt/sql/sql_parse.cc:1906
|
#15 0x000063f7428e0dc1 in do_command (thd=thd@entry=0x744d78000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1419
|
#16 0x000063f742a04e4d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x63f761ecc658, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1386
|
#17 0x000063f742a04c13 in handle_one_connection (arg=arg@entry=0x63f761ecc658)at /test/10.11_opt/sql/sql_connect.cc:1298
|
#18 0x000063f742d64e5e in pfs_spawn_thread (arg=0x63f761ef8298)at /test/10.11_opt/storage/perfschema/pfs.cc:2201
|
#19 0x0000744e6589caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#20 0x0000744e65929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 060825 df1eb3fbb2e27dd5b401ec349a72c39d221c0cb9 No bug found
|
CS 10.6 opt 060825 df1eb3fbb2e27dd5b401ec349a72c39d221c0cb9 No bug found
|
CS 10.11 dbg 070825 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::update_row|handler::ha_update_row
|
CS 10.11 opt 070825 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::update_row|handler::ha_update_row
|
CS 11.4 dbg 070725 dbeef00562dd7088a9f0163268f9eb5e5ba072fe No bug found
|
CS 11.4 opt 070725 dbeef00562dd7088a9f0163268f9eb5e5ba072fe No bug found
|
CS 11.8 dbg 070725 9a4a30aec003a8efdf9d35d3ac669385286ba4b4 No bug found
|
CS 11.8 opt 070725 9a4a30aec003a8efdf9d35d3ac669385286ba4b4 No bug found
|
CS 12.0 dbg 070725 107291bf980822fcc3c02bd4e01ecbc4db7fd192 No bug found
|
CS 12.0 opt 070725 107291bf980822fcc3c02bd4e01ecbc4db7fd192 No bug found
|
CS 12.1 dbg 070725 d4d0dd00b761b3e94454dff9aa93e2e17232339e No bug found
|
CS 12.1 opt 070725 d4d0dd00b761b3e94454dff9aa93e2e17232339e No bug found
|
ES 10.5 dbg 070725 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.5 opt 070725 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.6 dbg 070725 6879c0c0bcdd1b7a88de65dd581cf86195a2cd11 No bug found
|
ES 10.6 opt 070725 6879c0c0bcdd1b7a88de65dd581cf86195a2cd11 No bug found
|
ES 11.4 dbg 070725 6ac3c1547652a4391fe0b1210ec241a804293567 No bug found
|
ES 11.4 opt 070725 6ac3c1547652a4391fe0b1210ec241a804293567 No bug found
|
ES 11.8 dbg 070725 e09b21aaddefcf0d7ddd96eca5b1d48c1d688de5 No bug found
|
ES 11.8 opt 070725 e09b21aaddefcf0d7ddd96eca5b1d48c1d688de5 No bug found
|
Attachments
Issue Links
- is caused by
-
MDEV-15990 REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY)
-
- Closed
-