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(EOL)
    • 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. trial.log
          257 kB
          Elena Stepanova
        2. threads_full
          77 kB
          Elena Stepanova
        3. threads
          48 kB
          Elena Stepanova
        4. mysql.log.gz
          1.82 MB
          Elena Stepanova
        5. mysql.err
          95 kB
          Elena Stepanova

        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.