[MDEV-7160] innodb.innodb-page_compression_bzip2 and innodb.innodb-page_compression_tables fail (with assertion failure) in buildbot Created: 2014-11-22  Updated: 2014-11-24  Resolved: 2014-11-24

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.1
Fix Version/s: 10.1.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: buildbot, innodb, tests

Issue Links:
Blocks
blocks MDEV-7172 Fix buildbot failures in 10.1 tree Closed

 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]



 Comments   
Comment by Jan Lindström (Inactive) [ 2014-11-24 ]

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.

Generated at Thu Feb 08 07:17:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.