Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
Slightly modified reincarnation of MDEV-14684
CREATE OR REPLACE TABLE t (i INT); |
CREATE OR REPLACE VIEW v AS SELECT * FROM t; |
LOCK TABLE v WRITE; |
DELETE HISTORY FROM v BEFORE system_time NOW(6); |
|
# Cleanup
|
DROP VIEW v; |
DROP TABLE t; |
bb-10.3-release 7bed4877cb |
mysqld: /data/src/bb-10.3-release/sql/sql_delete.cc:312: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table' failed.
|
180224 0:41:00 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fb76fdcdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055e32a936ee8 in mysql_delete (thd=0x7fb758000b00, table_list=0x7fb758014da0, conds=0x0, order_list=0x7fb758005280, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-release/sql/sql_delete.cc:312
|
#9 0x000055e32a4a0e2f in mysql_execute_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:4902
|
#10 0x000055e32a4aa926 in mysql_parse (thd=0x7fb758000b00, rawbuf=0x7fb758014c98 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", length=47, parser_state=0x7fb76a03c5d0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7980
|
#11 0x000055e32a4980d5 in dispatch_command (command=COM_QUERY, thd=0x7fb758000b00, packet=0x7fb75808fac1 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1825
|
#12 0x000055e32a496b14 in do_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:1370
|
#13 0x000055e32a5fb2bf in do_handle_one_connection (connect=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1402
|
#14 0x000055e32a5fb04c in handle_one_connection (arg=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308
|
#15 0x000055e32aa9cf1f in pfs_spawn_thread (arg=0x55e32e306480) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862
|
#16 0x00007fb771aa4494 in start_thread (arg=0x7fb76a03d700) at pthread_create.c:333
|
#17 0x00007fb76fe8a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible (yet) on main 10.3 2732fcc608.
No visible effect on a non-debug build.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
_Slightly modified reincarnation of {code:sql} CREATE OR REPLACE TABLE t (i INT); CREATE OR REPLACE VIEW v AS SELECT * FROM t; LOCK TABLE v WRITE; DELETE HISTORY FROM v BEFORE system_time NOW(6); # Cleanup DROP VIEW v; DROP TABLE t; {code} {noformat:title=bb-10.3-release 7bed4877cb} mysqld: /data/src/bb-10.3-release/sql/sql_delete.cc:312: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table' failed. 180224 0:41:00 [ERROR] mysqld got signal 6 ; #7 0x00007fb76fdcdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055e32a936ee8 in mysql_delete (thd=0x7fb758000b00, table_list=0x7fb758014da0, conds=0x0, order_list=0x7fb758005280, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-release/sql/sql_delete.cc:312 #9 0x000055e32a4a0e2f in mysql_execute_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:4902 #10 0x000055e32a4aa926 in mysql_parse (thd=0x7fb758000b00, rawbuf=0x7fb758014c98 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", length=47, parser_state=0x7fb76a03c5d0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7980 #11 0x000055e32a4980d5 in dispatch_command (command=COM_QUERY, thd=0x7fb758000b00, packet=0x7fb75808fac1 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1825 #12 0x000055e32a496b14 in do_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:1370 #13 0x000055e32a5fb2bf in do_handle_one_connection (connect=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1402 #14 0x000055e32a5fb04c in handle_one_connection (arg=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308 #15 0x000055e32aa9cf1f in pfs_spawn_thread (arg=0x55e32e306480) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862 #16 0x00007fb771aa4494 in start_thread (arg=0x7fb76a03d700) at pthread_create.c:333 #17 0x00007fb76fe8a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Not reproducible (yet) on main 10.3 2732fcc608. |
_Slightly modified reincarnation of {code:sql} CREATE OR REPLACE TABLE t (i INT); CREATE OR REPLACE VIEW v AS SELECT * FROM t; LOCK TABLE v WRITE; DELETE HISTORY FROM v BEFORE system_time NOW(6); # Cleanup DROP VIEW v; DROP TABLE t; {code} {noformat:title=bb-10.3-release 7bed4877cb} mysqld: /data/src/bb-10.3-release/sql/sql_delete.cc:312: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table' failed. 180224 0:41:00 [ERROR] mysqld got signal 6 ; #7 0x00007fb76fdcdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055e32a936ee8 in mysql_delete (thd=0x7fb758000b00, table_list=0x7fb758014da0, conds=0x0, order_list=0x7fb758005280, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-release/sql/sql_delete.cc:312 #9 0x000055e32a4a0e2f in mysql_execute_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:4902 #10 0x000055e32a4aa926 in mysql_parse (thd=0x7fb758000b00, rawbuf=0x7fb758014c98 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", length=47, parser_state=0x7fb76a03c5d0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7980 #11 0x000055e32a4980d5 in dispatch_command (command=COM_QUERY, thd=0x7fb758000b00, packet=0x7fb75808fac1 "DELETE HISTORY FROM v BEFORE system_time NOW(6)", packet_length=47, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1825 #12 0x000055e32a496b14 in do_command (thd=0x7fb758000b00) at /data/src/bb-10.3-release/sql/sql_parse.cc:1370 #13 0x000055e32a5fb2bf in do_handle_one_connection (connect=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1402 #14 0x000055e32a5fb04c in handle_one_connection (arg=0x55e32e2f2be0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308 #15 0x000055e32aa9cf1f in pfs_spawn_thread (arg=0x55e32e306480) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862 #16 0x00007fb771aa4494 in start_thread (arg=0x7fb76a03d700) at pthread_create.c:333 #17 0x00007fb76fe8a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Not reproducible (yet) on main 10.3 2732fcc608. No visible effect on a non-debug build. |
Fix Version/s | 10.3.5 [ 22905 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 85725 ] | MariaDB v4 [ 153857 ] |