Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18168

[Draft] Server crashed in general_log_write

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3
    • N/A
    • Server
    • None

    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.

      Attachments

        1. mysql.err
          95 kB
        2. mysql.log.gz
          1.82 MB
        3. threads
          48 kB
        4. threads_full
          77 kB
        5. trial.log
          257 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.