[MDEV-18168] [Draft] Server crashed in general_log_write Created: 2019-01-08  Updated: 2023-06-20  Resolved: 2023-06-20

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.3
Fix Version/s: N/A

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

Attachments: File mysql.err     File mysql.log.gz     HTML File threads     HTML File threads_full     File trial.log    

 Description   

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

10.3.12 release bintar

#2  <signal handler called>
#3  general_log_write (thd=thd@entry=0x7f0adc0f2d38, command=command@entry=COM_QUERY, query=0x7f0adc09f230 "DROP PROCEDURE IF EXISTS sp_grammar ; CREATE PROCEDURE IF NOT EXISTS sp_6191 () BEGIN UPDATE IGNORE `view_table1_innodb_int_autoinc` SET `col_char_latin1_default_null` = '' ORDER BY `col_set_latin1_de"..., query_length=251) at /home/buildbot/buildbot/build/sql/log.cc:6587
#4  0x000056335c32ea7a in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f0adc0f2d38, packet=0x7f0adc095249 "DROP PROCEDURE IF EXISTS sp_grammar ; CREATE PROCEDURE IF NOT EXISTS sp_6191 () BEGIN UPDATE IGNORE `view_table1_innodb_int_autoinc` SET `col_char_latin1_default_null` = '' ORDER BY `col_set_latin1_de"..., packet_length=packet_length@entry=252, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1834
#5  0x000056335c32ff1e in do_command (thd=0x7f0adc0f2d38) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1396
#6  0x000056335c3f780f in do_handle_one_connection (connect=connect@entry=0x563362242c18) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1402
#7  0x000056335c3f7934 in handle_one_connection (arg=0x563362242c18) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1308
#8  0x00007f0ae3f796ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#9  0x00007f0ae362441d in clone () from /lib/x86_64-linux-gnu/libc.so.6

Query (0x7f0adc09f230): DROP PROCEDURE IF EXISTS sp_grammar ; CREATE PROCEDURE IF NOT EXISTS sp_6191 () BEGIN UPDATE IGNORE `view_table1_innodb_int_autoinc` SET `col_char_latin1_default_null` = '' ORDER BY `col_set_latin1_default_null` LIMIT 1 ; END /* QNO 18796 CON_ID 20 */
Connection ID (thread ID): 20
Status: NOT_KILLED

elenst-jira-refs b65d4a39aeb

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=500 --threads=6 --seed=1546391759 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --vcols --views --grammar=conf/mariadb/generic-dml.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=10 --mysqld=--lock-wait-timeout=5 --mysqld=--loose-innodb-lock-wait-timeout=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --gendata=conf/replication/replication-6.0.zz --gendata=conf/replication/replication-6.0.zz --mysqld=--innodb_buffer_pool_size=2G --engine=InnoDB --transformers=ExecuteAsIntersect,ExecuteAsExcept,ExecuteAsCTE,ExecuteAsExecuteImmediate,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice --redefine=conf/mariadb/general-workarounds.yy

Not reproducible so far.
Logs, threads etc. are attached.


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