Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.1.67, 5.2.14, 5.5.35, 10.0.8, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (a INT) PARTITION BY HASH(a) PARTITIONS 2; |
|
CREATE TABLE t2 (b INT); |
INSERT INTO t2 VALUES (1),(2); |
|
UPDATE t1 SET a = 7 WHERE a = ( SELECT b FROM t2 ) ORDER BY a LIMIT 6; |
On some reason, it does not fail on 5.3, but fails on 5.1, 5.2, 5.5 and 10.0 (and on all current branches of MySQL).
Stack trace from 5.5:
mysqld: 5.5/sql/sql_error.cc:362: void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
|
140207 23:42:49 [ERROR] mysqld got signal 6 ;
|
#6 0x00007f84cb4bb621 in *__GI___assert_fail (assertion=0xd68c86 "! is_set()", file=<optimized out>, line=362, function=0xd69740 "void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*)") at assert.c:81
|
#7 0x000000000060c8b5 in Diagnostics_area::set_ok_status (this=0x7f84c7ff26a0, thd=0x7f84c7fee060, affected_rows_arg=0, last_insert_id_arg=0, message_arg=0x0) at 5.5/sql/sql_error.cc:362
|
#8 0x00000000005c9d70 in my_ok (thd=0x7f84c7fee060, affected_rows=0, id=0, message=0x0) at 5.5/sql/sql_class.h:3168
|
#9 0x00000000006e1ce7 in mysql_update (thd=0x7f84c7fee060, table_list=0x7f84c615d1b0, fields=..., values=..., conds=0x7f84c615ed48, order_num=1, order=0x7f84c615efc0, limit=6, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f84c6bb5298, updated_return=0x7f84c6bb5290) at 5.5/sql/sql_update.cc:401
|
#10 0x0000000000630ea1 in mysql_execute_command (thd=0x7f84c7fee060) at 5.5/sql/sql_parse.cc:2847
|
#11 0x0000000000638cf6 in mysql_parse (thd=0x7f84c7fee060, rawbuf=0x7f84c615d078 "UPDATE t1 SET a = 7 WHERE a = ( SELECT b FROM t2 ) ORDER BY a LIMIT 6", length=69, parser_state=0x7f84c6bb5630) at 5.5/sql/sql_parse.cc:5799
|
#12 0x000000000062cd17 in dispatch_command (command=COM_QUERY, thd=0x7f84c7fee060, packet=0x7f84c72ff061 "UPDATE t1 SET a = 7 WHERE a = ( SELECT b FROM t2 ) ORDER BY a LIMIT 6", packet_length=69) at 5.5/sql/sql_parse.cc:1078
|
#13 0x000000000062beba in do_command (thd=0x7f84c7fee060) at 5.5/sql/sql_parse.cc:793
|
#14 0x000000000072d982 in do_handle_one_connection (thd_arg=0x7f84c7fee060) at 5.5/sql/sql_connect.cc:1266
|
#15 0x000000000072d441 in handle_one_connection (arg=0x7f84c7fee060) at 5.5/sql/sql_connect.cc:1181
|
#16 0x000000000098592d in pfs_spawn_thread (arg=0x7f84c7ff59e0) at 5.5/storage/perfschema/pfs.cc:1015
|
#17 0x00007f84cca1bb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#18 0x00007f84cb56aa7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
revision-id: elenst@wheezy-64.home-20140205102537-7ern5gfca6a6ojg3
|
revno: 4055
|
branch-nick: 5.5
|
Attachments
Issue Links
- duplicates
-
MDEV-11779 Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status upon UPDATE on partitioned table
-
- Closed
-
-
MDEV-17537 [Draft] Assertion `! is_set()' failed in Diagnostics_area::set_ok_status
-
- Closed
-
- relates to
-
MDEV-22783 Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status on DELETE on partitioned table
-
- Confirmed
-
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Link | This issue relates to TODO-60 [ TODO-60 ] |
Link | This issue relates to TODO-224 [ TODO-224 ] |
Remote Link | This issue links to "Bug #71630 - Assertion `! is_set()' fails on UPDATE on a partitioned table with subquery (Web Link)" [ 14600 ] |
Summary | Assertion `! is_set()' fails on UPDATE on a partitioned table with subquery | Assertion `! is_set()' fails on UPDATE on a partitioned table with subquery (MySQL:71630) |
Fix Version/s | 5.5.37 [ 15000 ] | |
Fix Version/s | 5.5.36 [ 14600 ] |
Fix Version/s | 10.0.10 [ 14500 ] | |
Fix Version/s | 10.0.9 [ 14400 ] |
Fix Version/s | 10.0.11 [ 15200 ] | |
Fix Version/s | 10.0.10 [ 14500 ] |
Fix Version/s | 5.5.38 [ 15400 ] | |
Fix Version/s | 5.5.37 [ 15000 ] |
Fix Version/s | 10.0.12 [ 15201 ] | |
Fix Version/s | 10.0.11 [ 15200 ] |
Fix Version/s | 5.5.39 [ 15800 ] | |
Fix Version/s | 5.5.38 [ 15400 ] |
Workflow | defaullt [ 34216 ] | MariaDB v2 [ 44605 ] |
Fix Version/s | 10.0.13 [ 16000 ] | |
Fix Version/s | 10.0.12 [ 15201 ] |
Workflow | MariaDB v2 [ 44605 ] | MariaDB v3 [ 61741 ] |
Component/s | Data Manipulation - Update [ 10805 ] | |
Component/s | Partitioning [ 10802 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 5.1.73 [ 12600 ] | |
Fix Version/s | 5.2.15 [ 12601 ] | |
Fix Version/s | 5.3.13 [ 12602 ] | |
Fix Version/s | 5.5 [ 15800 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 5.5 [ 15800 ] | |
Affects Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 10.1 [ 16100 ] | |
Affects Version/s | 10.2 [ 14601 ] | |
Affects Version/s | 10.3 [ 22126 ] | |
Labels | upstream | upstream-fixed |
Priority | Minor [ 4 ] | Major [ 3 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Link |
This issue duplicates |
Assignee | Sachin Setiya [ sachin.setiya.007 ] |
Summary | Assertion `! is_set()' fails on UPDATE on a partitioned table with subquery (MySQL:71630) | Assertion `! is_set()' or `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' fails on UPDATE on a partitioned table with subquery (MySQL:71630) |
Labels | upstream-fixed | affects-tests upstream-fixed |
Fix Version/s | 10.0 [ 16000 ] |
Link |
This issue relates to |
Link |
This issue duplicates |
Assignee | Sachin Setiya [ sachin.setiya.007 ] | Oleksandr Byelkin [ sanja ] |
Status | Confirmed [ 10101 ] | In Review [ 10002 ] |
Assignee | Oleksandr Byelkin [ sanja ] | Sachin Setiya [ sachin.setiya.007 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Link |
This issue relates to |
Fix Version/s | 10.4 [ 22408 ] |
Assignee | Sachin Setiya [ sachin.setiya.007 ] | Rucha Deodhar [ rucha174 ] |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 10.4 [ 22408 ] | |
Affects Version/s | 10.5 [ 23123 ] |
Link | This issue relates to MDEV-22783 [ MDEV-22783 ] |
Assignee | Rucha Deodhar [ rucha174 ] | Sergei Golubchik [ serg ] |
Status | Stalled [ 10000 ] | In Review [ 10002 ] |
Assignee | Sergei Golubchik [ serg ] | Rucha Deodhar [ rucha174 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
issue.field.resolutiondate | 2020-10-20 06:43:56.0 | 2020-10-20 06:43:56.448 |
Fix Version/s | 10.1.48 [ 25108 ] | |
Fix Version/s | 10.2.35 [ 25022 ] | |
Fix Version/s | 10.3.26 [ 25021 ] | |
Fix Version/s | 10.4.16 [ 25020 ] | |
Fix Version/s | 10.5.7 [ 25019 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 61741 ] | MariaDB v4 [ 147478 ] |
Still reproducible on all of MariaDB 5.5-10.3 and MySQL 5.6. Not reproducible on MySQL 5.7, although the public bug report does not show any signs of the bug being fixed; so, I'm changing the tag to upstream-fixed._
10.1 3627dd7f6a
mysqld: /data/src/10.1/sql/sql_error.cc:378: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
180610 17:43:22 [ERROR] mysqld got signal 6 ;
#7 0x00007faeb85a3ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x00005593bc128206 in Diagnostics_area::set_ok_status (this=0x7faeb14da008, affected_rows=0, last_insert_id=0, message=0x0) at /data/src/10.1/sql/sql_error.cc:378
#9 0x00005593bc0e0c97 in my_ok (thd=0x7faeb14d5070, affected_rows=0, id=0, message=0x0) at /data/src/10.1/sql/sql_class.h:4180
#10 0x00005593bc22d5cd in mysql_update (thd=0x7faeb14d5070, table_list=0x7faeaf8431c0, fields=..., values=..., conds=0x7faeaf844de0, order_num=1, order=0x7faeaf845048, limit=6, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7faeba626cc0, updated_return=0x7faeba626d50) at /data/src/10.1/sql/sql_update.cc:415
#11 0x00005593bc15394c in mysql_execute_command (thd=0x7faeb14d5070) at /data/src/10.1/sql/sql_parse.cc:3785
#12 0x00005593bc15ec75 in mysql_parse (thd=0x7faeb14d5070, rawbuf=0x7faeaf843088 "UPDATE t1 SET a = 7 WHERE a = ( SELECT b FROM t2 ) ORDER BY a LIMIT 6", length=69, parser_state=0x7faeba6275e0) at /data/src/10.1/sql/sql_parse.cc:7449
#13 0x00005593bc14d69d in dispatch_command (command=COM_QUERY, thd=0x7faeb14d5070, packet=0x7faeb3ff9071 "UPDATE t1 SET a = 7 WHERE a = ( SELECT b FROM t2 ) ORDER BY a LIMIT 6", packet_length=69) at /data/src/10.1/sql/sql_parse.cc:1492
#14 0x00005593bc14c422 in do_command (thd=0x7faeb14d5070) at /data/src/10.1/sql/sql_parse.cc:1121
#15 0x00005593bc285afd in do_handle_one_connection (thd_arg=0x7faeb14d5070) at /data/src/10.1/sql/sql_connect.cc:1330
#16 0x00005593bc285861 in handle_one_connection (arg=0x7faeb14d5070) at /data/src/10.1/sql/sql_connect.cc:1242
#17 0x00005593bc641f04 in pfs_spawn_thread (arg=0x7faeb7c3a170) at /data/src/10.1/storage/perfschema/pfs.cc:1861
#18 0x00007faeba2a7494 in start_thread (arg=0x7faeba628b00) at pthread_create.c:333
#19 0x00007faeb866093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Note: whoever ends up fixing it (if anyone, ever), feel free to fix in an earlier version than Fix Versions fields indicates.