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

Assertion `!thd->spcont' failed in bool net_send_error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL), 10.3(EOL)
    • 10.2.17
    • Optimizer - CTE
    • None

    Description

      bb-10.2-marko 72689ee5c42fb8cfbc53cd1316bbd2e60c1ebb78

      2018-01-31  5:26:48 140168137496320 [Note] /home/elenst/bld/bb-10.2-marko/bin/mysqld (rqg[rqg] @ localhost [127.0.0.1]): Normal shutdown
      2018-01-31  5:26:48 140168036071168 [Note] InnoDB: FTS optimize thread exiting.
      2018-01-31  5:26:48 140168137496320 [Note] Event Scheduler: Purging the queue. 0 events
      2018-01-31  5:27:08 140168137496320 [Warning] /home/elenst/bld/bb-10.2-marko/bin/mysqld: Forcing close of thread 22  user: 'rqg'
       
      mysqld: /home/elenst/git/bb-10.2-marko/sql/protocol.cc:155: bool net_send_error(THD*, uint, const char*, const char*): Assertion `!thd->spcont' failed.
      180131  5:27:08 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f7b9a9a5c82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055a366b37b77 in net_send_error (thd=0x7f7afc000b00, sql_errno=1053, err=0x55a36a0b7489 "Server shutdown in progress", sqlstate=0x0) at /home/elenst/git/bb-10.2-marko/sql/protocol.cc:155
      #9  0x000055a366b221c1 in close_connection (thd=0x7f7afc000b00, sql_errno=1053) at /home/elenst/git/bb-10.2-marko/sql/mysqld.cc:2816
      #10 0x000055a366b1fc1b in close_connections () at /home/elenst/git/bb-10.2-marko/sql/mysqld.cc:1782
      #11 0x000055a366b203d4 in kill_server (sig_ptr=0x0) at /home/elenst/git/bb-10.2-marko/sql/mysqld.cc:2006
      #12 0x000055a366b2044f in kill_server_thread (arg=0x7f7b9805ae50) at /home/elenst/git/bb-10.2-marko/sql/mysqld.cc:2038
      #13 0x00007f7b9b5e96ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #14 0x00007f7b9aa7e82d in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      experimental 0bc930df82b107fc1a1a6eda10d340655b55fced

      perl /home/elenst/git/rqg/runall-new.pl --no-mask --seed=1517368777 --threads=6 --duration=400 --queries=100M --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --redefine=conf/mariadb/alter_table.yy --mysqld=--plugin-load-add=file_key_management --mysqld=--loose-file-key-management-filename=/home/elenst/git/rqg/data/file_key_management_keys.txt --mysqld=--loose-debug_assert_on_not_freed_memory=0 --rpl_mode=mixed-nosync --mysqld=--slave-skip-errors=1049,1305,1539,1505,1317,1568 --mysqld=--log_bin_trust_function_creators=1 --vcols --redefine=conf/mariadb/bulk_insert.yy --grammar=conf/runtime/metadata_stability.yy --gendata=conf/runtime/metadata_stability.zz --mysqld=--old-alter-table --engine=InnoDB --basedir=/home/elenst/bld/bb-10.2-marko --mtr-build-thread=72 --vardir1=/home/elenst/test_results/mdev11415-9/current1_1
      

      Not reproducible right away.

      Attachments

        1. alter_table.yy
          14 kB
        2. threads
          31 kB

        Activity

          People

            igor Igor Babaev
            elenst Elena Stepanova
            Votes:
            0 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.