Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
SET sql_mode= 'STRICT_ALL_TABLES'; |
CREATE TABLE t1 (f1 INT DEFAULT 0, f2 INT); |
CREATE ALGORITHM = MERGE VIEW v1 AS SELECT f1, f2 FROM t1 WHERE f1 = '' WITH CHECK OPTION; |
REPLACE INTO v1 SET f2 = 1; |
|
# Cleanup
|
DROP VIEW v1; |
DROP TABLE t1; |
10.2 5ff2db7f67401511b30dbd3fc69a1ea87d7e8cc4 |
mysqld: /data/src/10.2/sql/sql_error.cc:380: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
|
170711 2:14:22 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1067baa312 in __GI___assert_fail (assertion=0x7f106aec3db0 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x7f106aec3ce8 "/data/src/10.2/sql/sql_error.cc", line=380, function=0x7f106aec4200 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
|
#8 0x00007f106a435d3d in Diagnostics_area::set_ok_status (this=0x7f1050005b18, affected_rows=1, last_insert_id=0, message=0x0) at /data/src/10.2/sql/sql_error.cc:380
|
#9 0x00007f106a3e914d in my_ok (thd=0x7f1050000b00, affected_rows=1, id=0, message=0x0) at /data/src/10.2/sql/sql_class.h:4334
|
#10 0x00007f106a43e28f in mysql_insert (thd=0x7f1050000b00, table_list=0x7f1050012460, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /data/src/10.2/sql/sql_insert.cc:1215
|
#11 0x00007f106a464d44 in mysql_execute_command (thd=0x7f1050000b00) at /data/src/10.2/sql/sql_parse.cc:4416
|
#12 0x00007f106a46fd88 in mysql_parse (thd=0x7f1050000b00, rawbuf=0x7f1050012378 "REPLACE INTO v1 SET f2 = 1", length=26, parser_state=0x7f1062059200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879
|
#13 0x00007f106a45de34 in dispatch_command (command=COM_QUERY, thd=0x7f1050000b00, packet=0x7f10501631c1 "REPLACE INTO v1 SET f2 = 1", packet_length=26, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817
|
#14 0x00007f106a45c775 in do_command (thd=0x7f1050000b00) at /data/src/10.2/sql/sql_parse.cc:1362
|
#15 0x00007f106a5a84e7 in do_handle_one_connection (connect=0x7f106d7b69f0) at /data/src/10.2/sql/sql_connect.cc:1354
|
#16 0x00007f106a5a8274 in handle_one_connection (arg=0x7f106d7b69f0) at /data/src/10.2/sql/sql_connect.cc:1260
|
#17 0x00007f106a8ef870 in pfs_spawn_thread (arg=0x7f106d8510a0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#18 0x00007f1069a7f064 in start_thread (arg=0x7f106205a700) at pthread_create.c:309
|
#19 0x00007f1067c6462d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
10.1 9e11e055ce1461caecbb30e8300dfdcd48af22f1 |
mysqld: /data/src/10.1/sql/sql_error.cc:378: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
|
170711 2:13:38 [ERROR] mysqld got signal 6 ;
|
|
#6 0x00007f155fcb8266 in __assert_fail_base (fmt=0x7f155fdf0f18 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f1562ddc6c0 "! is_set()", file=file@entry=0x7f1562ddc5f8 "/data/src/10.1/sql/sql_error.cc", line=line@entry=378, function=function@entry=0x7f1562ddcac0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
|
#7 0x00007f155fcb8312 in __GI___assert_fail (assertion=0x7f1562ddc6c0 "! is_set()", file=0x7f1562ddc5f8 "/data/src/10.1/sql/sql_error.cc", line=378, function=0x7f1562ddcac0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
|
#8 0x00007f156249a50a in Diagnostics_area::set_ok_status (this=0x7f1558ffee90, affected_rows=1, last_insert_id=0, message=0x0) at /data/src/10.1/sql/sql_error.cc:378
|
#9 0x00007f1562453c25 in my_ok (thd=0x7f1558ffa070, affected_rows=1, id=0, message=0x0) at /data/src/10.1/sql/sql_class.h:4071
|
#10 0x00007f15624a23ae in mysql_insert (thd=0x7f1558ffa070, table_list=0x7f1557043170, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /data/src/10.1/sql/sql_insert.cc:1196
|
#11 0x00007f15624c5ee1 in mysql_execute_command (thd=0x7f1558ffa070) at /data/src/10.1/sql/sql_parse.cc:3925
|
#12 0x00007f15624d0871 in mysql_parse (thd=0x7f1558ffa070, rawbuf=0x7f1557043088 "REPLACE INTO v1 SET f2 = 1", length=26, parser_state=0x7f15633db5e0) at /data/src/10.1/sql/sql_parse.cc:7339
|
#13 0x00007f15624bf85c in dispatch_command (command=COM_QUERY, thd=0x7f1558ffa070, packet=0x7f155a93e071 "REPLACE INTO v1 SET f2 = 1", packet_length=26) at /data/src/10.1/sql/sql_parse.cc:1490
|
#14 0x00007f15624be5bb in do_command (thd=0x7f1558ffa070) at /data/src/10.1/sql/sql_parse.cc:1109
|
#15 0x00007f15625f6125 in do_handle_one_connection (thd_arg=0x7f1558ffa070) at /data/src/10.1/sql/sql_connect.cc:1349
|
#16 0x00007f15625f5e89 in handle_one_connection (arg=0x7f1558ffa070) at /data/src/10.1/sql/sql_connect.cc:1261
|
#17 0x00007f15628da1bc in pfs_spawn_thread (arg=0x7f155f427ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1860
|
#18 0x00007f1561bba064 in start_thread (arg=0x7f15633dcb00) at pthread_create.c:309
|
#19 0x00007f155fd7262d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Not reproducible on 10.0, MySQL 5.6/5.7.
Note: there is MDEV-11779 which seems to have the same exact assertion failures; but there is also difference – MDEV-11779 is said to be reproducible on 10.0, it happens upon CREATE TABLE, and stack trace is also somewhat different. Given all that, I'm filing this one separately.