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

innodb.innodb-page_compression_bzip2 and innodb.innodb-page_compression_tables fail (with assertion failure) in buildbot

Details

    Description

      The failure seems persistent.

      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4189/steps/test/logs/stdio

      InnoDB: Database page corruption on disk or a failed
      InnoDB: file read of page 3.
      InnoDB: You may have to recover from a backup.
      2014-11-22 19:13:18 11095e000 InnoDB: Page dump in ascii and hex (16384 bytes):
       
      ...
       
      2014-11-22 19:13:25 11095e000  InnoDB: Assertion failure in thread 4573224960 in file buf0buf.cc line 2746
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
      InnoDB: about forcing recovery.
      141122 19:13:25 [ERROR] mysqld got signal 6 ;
       
      ...
       
      Server version: 10.1.2-MariaDB-wsrep-log
      key_buffer_size=1048576
      read_buffer_size=131072
      max_used_connections=1
      max_threads=153
      thread_count=1
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63002 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
       
      Thread pointer: 0x0x7ff3108e6608
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x11095de60 thread_stack 0x48000
      0   mysqld                              0x00000001074253ce my_print_stacktrace + 46
      0   mysqld                              0x0000000106f0ab20 handle_fatal_signal + 644
      0   libsystem_c.dylib                   0x00007fff89ee5cfa _sigtramp + 26
      0   ???                                 0x0000000110955378 0x0 + 4573188984
      0   libsystem_c.dylib                   0x00007fff89e84a7a abort + 143
      0   ha_innodb.so                        0x000000010ddf26be _Z16buf_page_get_genmmmmP11buf_block_tmPKcmP5mtr_t + 3705
      0   ha_innodb.so                        0x000000010ddd1905 _ZL18btr_root_block_getPK12dict_index_tmP5mtr_t + 107
      0   ha_innodb.so                        0x000000010ddd763d _Z25btr_get_size_and_reservedP12dict_index_tmPmP5mtr_t + 80
      0   ha_innodb.so                        0x000000010ddd76d0 _Z12btr_get_sizeP12dict_index_tmP5mtr_t + 47
      0   ha_innodb.so                        0x000000010de24db3 _ZL37dict_stats_update_transient_for_indexP12dict_index_t + 186
      0   ha_innodb.so                        0x000000010de2500e _Z27dict_stats_update_transientP12dict_table_t + 167
      0   ha_innodb.so                        0x000000010de257a6 _Z17dict_stats_updateP12dict_table_t23dict_stats_upd_option_t + 1744
      0   ha_innodb.so                        0x000000010de641bd _ZN9ha_innodb4openEPKcij + 1393
      0   mysqld                              0x0000000106f0efd1 _ZN7handler7ha_openEP5TABLEPKcij + 49
      0   mysqld                              0x00000001070f91ce _Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb + 2599
      0   mysqld                              0x00000001070285bb _Z10open_tableP3THDP10TABLE_LISTP11st_mem_rootP18Open_table_context + 2237
      0   mysqld                              0x0000000107029969 _Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy + 1928
      0   mysqld                              0x00000001070edd47 _Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB_ + 276
      0   mysqld                              0x000000010706674d _Z21mysql_execute_commandP3THD + 11822
      0   mysqld                              0x000000010706b86d _Z11mysql_parseP3THDPcjP12Parser_state + 365
      0   mysqld                              0x000000010706d11a _Z16dispatch_command19enum_server_commandP3THDPcj + 2435
      0   mysqld                              0x000000010706e8e1 _Z10do_commandP3THD + 1361
      0   mysqld                              0x0000000107122238 _Z24do_handle_one_connectionP3THD + 544
      0   mysqld                              0x0000000107122337 handle_one_connection + 62
      0   mysqld                              0x000000010726e743 pfs_spawn_thread + 296
      0   libsystem_c.dylib                   0x00007fff89e918bf _pthread_start + 335
      0   libsystem_c.dylib                   0x00007fff89e94b75 thread_start + 13
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7ff311804e20): is an invalid pointer
      Connection ID (thread ID): 2
      Status: NOT_KILLED

      http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/861/steps/test/logs/stdio

      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab00d65]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2d35]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2ef1]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaaad2f73]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab35225]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab36cdd]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab3b71f]
      /usr/local/mariadb-10.1.2-linux-x86_64/lib/plugin/ha_innodb.so[0x2aaaaab95a5a]
      sql/handler.cc:2520(handler::ha_open(TABLE*, char const*, int, unsigned int))[0x7449fe]
      sql/table.cc:2864(open_table_from_share(THD*, TABLE_SHARE*, char const*, unsigned int, unsigned int, unsigned int, TABLE*, bool))[0x64df26]
      sql/sql_base.cc:2465(open_table(THD*, TABLE_LIST*, st_mem_root*, Open_table_context*))[0x55c45e]
      sql/sql_base.cc:3936(open_and_process_table)[0x55dbea]
      sql/sql_update.cc:286(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x63caf1]
      sql/sql_parse.cc:3672(mysql_execute_command(THD*))[0x5a5bc9]
      sql/sql_parse.cc:7049(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5a813a]
      sql/sql_parse.cc:1466(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5aad85]
      sql/sql_parse.cc:1097(do_command(THD*))[0x5ab027]
      sql/sql_connect.cc:1351(do_handle_one_connection(THD*))[0x675540]
      sql/sql_connect.cc:1264(handle_one_connection)[0x675752]
      perfschema/pfs.cc:1863(pfs_spawn_thread)[0xaa2459]

      Attachments

        Issue Links

          Activity

            revno: 4004
            committer: Jan Lindström <jplindst@mariadb.org>
            branch nick: 10.0-FusionIO-release
            timestamp: Mon 2014-11-24 12:08:45 +0200
            message:
            MDEV-7166: innodb.innodb-page_compression_zip fails in buildbot

            Analysis: If innodb_use_trim is not enabled or system does not
            support fallocate to make persistent trim, we should always
            write full page not only partial pages.

            jplindst Jan Lindström (Inactive) added a comment - revno: 4004 committer: Jan Lindström <jplindst@mariadb.org> branch nick: 10.0-FusionIO-release timestamp: Mon 2014-11-24 12:08:45 +0200 message: MDEV-7166 : innodb.innodb-page_compression_zip fails in buildbot Analysis: If innodb_use_trim is not enabled or system does not support fallocate to make persistent trim, we should always write full page not only partial pages.

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.