Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-3970

A set of assorted crashes on inserting a row into a LevelDB table (does not involve drop table)

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • OpenSUSE 12.2 32-bit

    Description

      All stack traces below were received by running the same provided scenario, just starting it again through MTR.
      I also had similar crashes through a client, so it's not strictly MTR-specific, but with a client sometimes it required shutting down the server, and the crash would happen then, while sometimes it was right upon INSERT.

      let $dbname = `SELECT UUID_SHORT()`;
      eval CREATE DATABASE `$dbname`;
      eval USE `$dbname`;
       
      CREATE TABLE `t1` (
         `c` char(1) NOT NULL,
         `c0` char(0) NOT NULL,
         `c1` char(1) NOT NULL,
         `c20` char(20) NOT NULL,
         `c255` char(255) NOT NULL,
         PRIMARY KEY (`c255`)
       ) ENGINE=LevelDB DEFAULT CHARSET=latin1;
      INSERT INTO t1 VALUES ('a', '', 'c', REPEAT('a',20), REPEAT('x',255));

      mysqld: malloc.c:3795: _int_malloc: Assertion `victim->fd_nextsize->bk_nextsize == victim' failed.
       
      #7  0xb738fc03 in abort () from /lib/libc.so.6
      #8  0xb73d2079 in __malloc_assert () from /lib/libc.so.6
      #9  0xb73d4be3 in _int_malloc () from /lib/libc.so.6
      #10 0xb73d6ac8 in malloc () from /lib/libc.so.6
      #11 0xb75a0545 in operator new(unsigned int) () from /usr/lib/libstdc++.so.6
      #12 0xb7605265 in std::string::_Rep::_S_create(unsigned int, unsigned int, std::allocator<char> const&) () from /usr/lib/libstdc++.so.6
      #13 0xb76065cf in std::string::_Rep::_M_clone(std::allocator<char> const&, unsigned int) () from /usr/lib/libstdc++.so.6
      #14 0xb76066fd in std::string::reserve(unsigned int) () from /usr/lib/libstdc++.so.6
      #15 0xb76b3e25 in leveldb::WriteBatch::Put(leveldb::Slice const&, leveldb::Slice const&) () from leveldb-1.7.0/libleveldb.so.1
      #16 0x0891c1d7 in ha_leveldb::write_row (this=0xb6a550f0, buf=0xb6a554d8 "\377ac", 'a' <repeats 20 times>, 'x' <repeats 177 times>...) at mysql-5.6-leveldb/storage/leveldb/ha_leveldb.cc:760
      #17 0x0825730a in handler::ha_write_row (this=0xb6a550f0, buf=0xb6a554d8 "\377ac", 'a' <repeats 20 times>, 'x' <repeats 177 times>...) at mysql-5.6-leveldb/sql/handler.cc:7131
      #18 0x0838c0aa in write_record (thd=0xab4ce08, table=0xb6a54a18, info=0xaf7e79a0, update=0xaf7e79fc) at mysql-5.6-leveldb/sql/sql_insert.cc:1858
      #19 0x0838a24a in mysql_insert (thd=0xab4ce08, table_list=0xb6a2bb10, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at mysql-5.6-leveldb/sql/sql_insert.cc:1036
      #20 0x083a7373 in mysql_execute_command (thd=0xab4ce08) at mysql-5.6-leveldb/sql/sql_parse.cc:3344
      #21 0x083ae558 in mysql_parse (thd=0xab4ce08, rawbuf=0xb6a2ba00 "INSERT INTO t1 VALUES ('a', '', 'c', REPEAT('a',20), REPEAT('x',255))", length=69, parser_state=0xaf7e8758) at mysql-5.6-leveldb/sql/sql_parse.cc:6097
      #22 0x083a2f3e in dispatch_command (command=COM_QUERY, thd=0xab4ce08, packet=0xabec7c9 "INSERT INTO t1 VALUES ('a', '', 'c', REPEAT('a',20), REPEAT('x',255))", packet_length=69) at mysql-5.6-leveldb/sql/sql_parse.cc:1312
      #23 0x083a236e in do_command (thd=0xab4ce08) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #24 0x08371d29 in do_handle_one_connection (thd_arg=0xab4ce08) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #25 0x083718d2 in handle_one_connection (arg=0xab4ce08) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #26 0x08650747 in pfs_spawn_thread (arg=0xaad0938) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853

      #7  0xb7385c03 in abort () from /lib/libc.so.6
      #8  0xb73c8079 in __malloc_assert () from /lib/libc.so.6
      #9  0xb73cabe3 in _int_malloc () from /lib/libc.so.6
      #10 0xb73ccac8 in malloc () from /lib/libc.so.6
      #11 0x08605bc4 in my_malloc (size=20, my_flags=16) at mysql-5.6-leveldb/mysys/my_malloc.c:38
      #12 0x089339c2 in _lf_alloc_new (pins=0xb6a2ea80) at mysql-5.6-leveldb/mysys/lf_alloc-pin.c:513
      #13 0x08934840 in lf_hash_insert (hash=0x9075000 <digest_hash>, pins=0xb6a2ea80, data=0xaf7e85d8) at mysql-5.6-leveldb/mysys/lf_hash.c:373
      #14 0x08626888 in find_or_create_digest (thread=0xb4e34a40, digest_storage=0x96bced4) at mysql-5.6-leveldb/storage/perfschema/pfs_digest.cc:260
      #15 0x086563da in end_statement_v1 (locker=0x96bce6c, stmt_da=0x96bdfc0) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:4752
      #16 0x083a0997 in inline_mysql_end_statement (locker=0x96bce6c, stmt_da=0x96bdfc0) at mysql-5.6-leveldb/include/mysql/psi/mysql_statement.h:223
      #17 0x083a4065 in dispatch_command (command=COM_QUERY, thd=0x96bbe08, packet=0x975b7c9 "", packet_length=17) at mysql-5.6-leveldb/sql/sql_parse.cc:1714
      #18 0x083a236e in do_command (thd=0x96bbe08) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #19 0x08371d29 in do_handle_one_connection (thd_arg=0x96bbe08) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #20 0x083718d2 in handle_one_connection (arg=0x96bbe08) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #21 0x08650747 in pfs_spawn_thread (arg=0x963f938) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853

      #4  <signal handler called>
      #5  0xb73f43b2 in _int_malloc () from /lib/libc.so.6
      #6  0xb73f6ac8 in malloc () from /lib/libc.so.6
      #7  0x08605bc4 in my_malloc (size=16, my_flags=16) at mysql-5.6-leveldb/mysys/my_malloc.c:38
      #8  0x08934c46 in initialize_bucket (hash=0x9075000 <digest_hash>, node=0xb6a32a80, bucket=5, pins=0xb6a2ea80) at mysql-5.6-leveldb/mysys/lf_hash.c:479
      #9  0x08934cba in initialize_bucket (hash=0x9075000 <digest_hash>, node=0xb6a32aa0, bucket=13, pins=0xb6a2ea80) at mysql-5.6-leveldb/mysys/lf_hash.c:485
      #10 0x08934cba in initialize_bucket (hash=0x9075000 <digest_hash>, node=0xb6a32ae0, bucket=29, pins=0xb6a2ea80) at mysql-5.6-leveldb/mysys/lf_hash.c:485
      #11 0x08934cba in initialize_bucket (hash=0x9075000 <digest_hash>, node=0xb6a32ce0, bucket=157, pins=0xb6a2ea80) at mysql-5.6-leveldb/mysys/lf_hash.c:485
      #12 0x08934bad in lf_hash_search (hash=0x9075000 <digest_hash>, pins=0xb6a2ea80, key=0xb6b495dc, keylen=16) at mysql-5.6-leveldb/mysys/lf_hash.c:460
      #13 0x086266b7 in find_or_create_digest (thread=0xb4e34540, digest_storage=0x9c0aed4) at mysql-5.6-leveldb/storage/perfschema/pfs_digest.cc:207
      #14 0x086563da in end_statement_v1 (locker=0x9c0ae6c, stmt_da=0x9c0bfc0) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:4752
      #15 0x083a0997 in inline_mysql_end_statement (locker=0x9c0ae6c, stmt_da=0x9c0bfc0) at mysql-5.6-leveldb/include/mysql/psi/mysql_statement.h:223
      #16 0x083a4065 in dispatch_command (command=COM_QUERY, thd=0x9c09e08, packet=0x9ca97c9 "", packet_length=69) at mysql-5.6-leveldb/sql/sql_parse.cc:1714
      #17 0x083a236e in do_command (thd=0x9c09e08) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #18 0x08371d29 in do_handle_one_connection (thd_arg=0x9c09e08) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #19 0x083718d2 in handle_one_connection (arg=0x9c09e08) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #20 0x08650747 in pfs_spawn_thread (arg=0x9b8d938) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853
      #21 0xb76fbe32 in start_thread () from /lib/libpthread.so.0
      #22 0xb746a8ee in clone () from /lib/libc.so.6

      #7  0xb743cc03 in abort () from /lib/libc.so.6
      #8  0xb747f079 in __malloc_assert () from /lib/libc.so.6
      #9  0xb7481be3 in _int_malloc () from /lib/libc.so.6
      #10 0xb7483ac8 in malloc () from /lib/libc.so.6
      #11 0xb764d5d5 in operator new(unsigned int, std::nothrow_t const&) () from /usr/lib/libstdc++.so.6
      #12 0x083035df in MDL_ticket::create (ctx_arg=0xb040e90, type_arg=MDL_INTENTION_EXCLUSIVE, duration_arg=MDL_EXPLICIT) at mysql-5.6-leveldb/sql/mdl.cc:1188
      #13 0x0830435b in MDL_context::try_acquire_lock_impl (this=0xb040e90, mdl_request=0xaf8b67c8, out_ticket=0xaf8b673c) at mysql-5.6-leveldb/sql/mdl.cc:2004
      #14 0x08304804 in MDL_context::acquire_lock (this=0xb040e90, mdl_request=0xaf8b67c8, lock_wait_timeout=31536000) at mysql-5.6-leveldb/sql/mdl.cc:2172
      #15 0x0824ba68 in ha_commit_trans (thd=0xb040e08, all=false) at mysql-5.6-leveldb/sql/handler.cc:1395
      #16 0x084570c1 in trans_commit_stmt (thd=0xb040e08) at mysql-5.6-leveldb/sql/transaction.cc:373
      #17 0x083abd86 in mysql_execute_command (thd=0xb040e08) at mysql-5.6-leveldb/sql/sql_parse.cc:4895
      #18 0x083ae558 in mysql_parse (thd=0xb040e08, rawbuf=0xb6b2ba00 "INSERT INTO t1 VALUES ('a', '', 'c', REPEAT('a',20), REPEAT('x',255))", length=69, parser_state=0xaf8b7758) at mysql-5.6-leveldb/sql/sql_parse.cc:6097
      #19 0x083a2f3e in dispatch_command (command=COM_QUERY, thd=0xb040e08, packet=0xb0e07c9 "INSERT INTO t1 VALUES ('a', '', 'c', REPEAT('a',20), REPEAT('x',255))", packet_length=69) at mysql-5.6-leveldb/sql/sql_parse.cc:1312
      #20 0x083a236e in do_command (thd=0xb040e08) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #21 0x08371d29 in do_handle_one_connection (thd_arg=0xb040e08) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #22 0x083718d2 in handle_one_connection (arg=0xb040e08) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #23 0x08650747 in pfs_spawn_thread (arg=0xafc4938) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853
      #24 0xb7788e32 in start_thread () from /lib/libpthread.so.0
      #25 0xb74f78ee in clone () from /lib/libc.so.6

      #8  0xb740d079 in __malloc_assert () from /lib/libc.so.6
      #9  0xb740fbe3 in _int_malloc () from /lib/libc.so.6
      #10 0xb7410478 in _int_realloc () from /lib/libc.so.6
      #11 0xb74120e7 in realloc () from /lib/libc.so.6
      #12 0x08605e20 in my_realloc (oldpoint=0xb6ae8f20, size=16, my_flags=16) at mysql-5.6-leveldb/mysys/my_malloc.c:90
      #13 0x083f528a in String::realloc (this=0xa54aec0, alloc_length=12) at mysql-5.6-leveldb/sql/sql_string.cc:93
      #14 0x083f5c1e in String::append (this=0xa54aec0, s=0x8a2ae2c "SESSION ", arg_length=8) at mysql-5.6-leveldb/sql/sql_string.cc:424
      #15 0x083f5c95 in String::append (this=0xa54aec0, s=0x8a2ae2c "SESSION ") at mysql-5.6-leveldb/sql/sql_string.cc:438
      #16 0x08313af0 in set_var::print (this=0xb6a2bae8, thd=0xa54ae88, str=0xa54aec0) at mysql-5.6-leveldb/sql/set_var.cc:683
      #17 0x083cae78 in mysql_rewrite_set (thd=0xa54ae88, rlb=0xa54aec0) at mysql-5.6-leveldb/sql/sql_rewrite.cc:230
      #18 0x083cba00 in mysql_rewrite_query (thd=0xa54ae88) at mysql-5.6-leveldb/sql/sql_rewrite.cc:463
      #19 0x083ae2d9 in mysql_parse (thd=0xa54ae88, rawbuf=0xb6a2ba00 "set debug=\"\"", length=12, parser_state=0xb6b64758) at mysql-5.6-leveldb/sql/sql_parse.cc:6031
      #20 0x083a2f3e in dispatch_command (command=COM_QUERY, thd=0xa54ae88, packet=0xa5ea879 "set debug=\"\"", packet_length=12) at mysql-5.6-leveldb/sql/sql_parse.cc:1312
      #21 0x083a236e in do_command (thd=0xa54ae88) at mysql-5.6-leveldb/sql/sql_parse.cc:1036
      #22 0x08371d29 in do_handle_one_connection (thd_arg=0xa54ae88) at mysql-5.6-leveldb/sql/sql_connect.cc:969
      #23 0x083718d2 in handle_one_connection (arg=0xa54ae88) at mysql-5.6-leveldb/sql/sql_connect.cc:885
      #24 0x08650747 in pfs_spawn_thread (arg=0xa4d3668) at mysql-5.6-leveldb/storage/perfschema/pfs.cc:1853
      #25 0xb7716e32 in start_thread () from /lib/libpthread.so.0
      #26 0xb74858ee in clone () from /lib/libc.so.6

      revision-id: psergey@askmonty.org-20121221181426-m94ou0fykf40dfno
      date: 2012-12-21 22:14:26 +0400
      build-date: 2012-12-23 07:21:16 +0400
      revno: 4477
      branch: mysql-5.6-leveldb

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.