[MDEV-18285] [Draft] Assertion `! is_set()' failed in Diagnostics_area::disable_status upon DROP COLUMN Created: 2019-01-17  Updated: 2023-06-19  Resolved: 2023-06-19

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Prepared Statements
Affects Version/s: 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-16788 2nd execution of SP: ASAN heap-use-af... Closed
relates to MDEV-18082 Assertion `! is_set()' failed in Diag... Open

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/479996231

10.4 4bcd7da0768e938

mysqld: /home/travis/src/sql/sql_error.cc:484: void Diagnostics_area::disable_status(): Assertion `! is_set()' failed.
190116  2:52:43 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f25c55cfc82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x0000558b9b8b784c in Diagnostics_area::disable_status (this=0x7f2564006490) at /home/travis/src/sql/sql_error.cc:484
#9  0x0000558b9b925222 in send_prep_stmt (stmt=0x7f2564111030, columns=0) at /home/travis/src/sql/sql_prepare.cc:393
#10 0x0000558b9b9295f8 in check_prepared_statement (stmt=0x7f2564111030) at /home/travis/src/sql/sql_prepare.cc:2536
#11 0x0000558b9b92d04a in Prepared_statement::prepare (this=0x7f2564111030, packet=0x7f2564022041 "", packet_len=105) at /home/travis/src/sql/sql_prepare.cc:4011
#12 0x0000558b9b9298fa in mysqld_stmt_prepare (thd=0x7f2564000cd0, packet=0x7f2564022041 "", packet_length=105) at /home/travis/src/sql/sql_prepare.cc:2633
#13 0x0000558b9b8fdd77 in dispatch_command (command=COM_STMT_PREPARE, thd=0x7f2564000cd0, packet=0x7f2564022041 "", packet_length=105, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1809
#14 0x0000558b9b8fcad6 in do_command (thd=0x7f2564000cd0) at /home/travis/src/sql/sql_parse.cc:1397
#15 0x0000558b9ba68ad6 in do_handle_one_connection (connect=0x558ba002dd90) at /home/travis/src/sql/sql_connect.cc:1402
#16 0x0000558b9ba68827 in handle_one_connection (arg=0x558ba002dd90) at /home/travis/src/sql/sql_connect.cc:1308
#17 0x00007f25c62146ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#18 0x00007f25c56a941d in clone () from /lib/x86_64-linux-gnu/libc.so.6
 
Query (0x7f25642b4b98): ALTER TABLE t7 DROP COLUMN IF EXISTS vcol4, ALGORITHM=INPLACE, LOCK=EXCLUSIVE  /* QNO 21728 CON_ID 18 */
Connection ID (thread ID): 18
Status: NOT_KILLED

elenst-jira-refs 23f517b6dba9 Toolbox: c826c29aaab

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1547606925 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/userstat.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/modules/acl.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/modules/locks-10.4-extra.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--default-storage-engine=Aria --grammar=conf/partitioning/partitions.yy --ps-protocol --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff

Not reproducible right away, hitting MDEV-16788 instead.



 Comments   
Comment by Elena Stepanova [ 2019-01-30 ]

New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/485508101 [2620 28 3]

Comment by Elena Stepanova [ 2019-02-16 ]

On 10.3: https://travis-ci.org/elenst/travis-tests/jobs/494098694 [2759 12 3]

Comment by Elena Stepanova [ 2023-06-19 ]

Fails on other assertions in diagnostics area instead.

Generated at Thu Feb 08 08:42:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.