5.5.12 main.percona_xtradb_bug317074 - segfault
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Unassigned | ||
percona-projects-qa |
Invalid
|
High
|
Unassigned |
Bug Description
# ./sql/mysqld --version
./sql/mysqld Ver 5.5.12-debug-log for Linux on x86_64 (Source distribution)
main.percona_
Test ended at 2011-05-22 08:15:45
CURRENT_TEST: main.percona_
==22046== Memcheck, a memory error detector
==22046== Copyright (C) 2002-2009, and GNU GPL'd, by Julian Seward et al.
==22046== Using Valgrind-3.5.0 and LibVEX; rerun with -h for copyright info
==22046== Command: /root/Percona-
==22046==
mysqltest: At line 38: query 'call insert_
The result from queries just before the failure was:
SET @old_innodb_
SET @old_innodb_
SET @old_innodb_
SET GLOBAL innodb_
SET GLOBAL innodb_
==22046==
==22046== HEAP SUMMARY:
==22046== in use at exit: 56 bytes in 1 blocks
==22046== total heap usage: 248 allocs, 247 frees, 396,323 bytes allocated
==22046==
==22046== LEAK SUMMARY:
==22046== definitely lost: 0 bytes in 0 blocks
==22046== indirectly lost: 0 bytes in 0 blocks
==22046== possibly lost: 0 bytes in 0 blocks
==22046== still reachable: 0 bytes in 0 blocks
==22046== suppressed: 56 bytes in 1 blocks
==22046==
==22046== For counts of detected and suppressed errors, rerun with: -v
==22046== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 4 from 4)
Server [mysqld.1 - pid: 21401, winpid: 21401, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
InnoDB: DEBUG: update_statistics for test/test1.
<snip>
InnoDB: DEBUG: update_statistics for test/test1.
110522 7:15:40 InnoDB: Assertion failure in thread 68348224 in file buf0lru.c line 621
InnoDB: Failing assertion: mutex_own(
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
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://
InnoDB: about forcing recovery.
110522 7:15:40 - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
key_buffer_
read_buffer_
max_used_
max_threads=151
thread_count=1
connection_count=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x12f2ee80
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 = 0x412e078 thread_stack 0x40000
/root/Percona-
/root/Percona-
/lib64/
/lib64/
/lib64/
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/root/Percona-
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x1304b960): insert into test1 set b=1
Connection ID (thread ID): 191
Status: NOT_KILLED
The manual page at http://
information that should help you find out what is causing the crash.
Writing a core file
Related branches
- Oleg Tsarev (community): Needs Fixing (dev)
- Percona developers: Pending requested
-
Diff: 11671 lines (+7079/-693)63 files modifiedMakefile (+2/-2)
control_online_alter_index.patch (+1/-1)
innodb_adaptive_hash_index_partitions.patch (+45/-27)
innodb_admin_command_base.patch (+1/-1)
innodb_buffer_pool_pages_i_s.patch (+3/-3)
innodb_buffer_pool_shm.patch (+7/-7)
innodb_deadlock_count.patch (+3/-3)
innodb_dict_size_limit.patch (+10/-10)
innodb_expand_import.patch (+597/-87)
innodb_extend_slow.patch (+35/-34)
innodb_extra_rseg.patch (+1/-1)
innodb_fake_changes.patch (+614/-0)
innodb_fast_checksum.patch (+33/-46)
innodb_files_extend.patch (+15/-24)
innodb_fix_misc.patch (+39/-39)
innodb_io_patches.patch (+39/-38)
innodb_lru_dump_restore.patch (+8/-8)
innodb_overwrite_relay_log_info.patch (+17/-18)
innodb_pass_corrupt_table.patch (+106/-100)
innodb_recovery_patches.patch (+10/-10)
innodb_separate_doublewrite.patch (+34/-34)
innodb_show_lock_name.patch (+6/-6)
innodb_show_status.patch (+15/-15)
innodb_show_status_extend.patch (+8/-8)
innodb_show_sys_tables.patch (+1/-1)
innodb_split_buf_pool_mutex.patch (+37/-26)
innodb_stats.patch (+31/-25)
innodb_thread_concurrency_timer_based.patch (+7/-7)
install_tests.sh.THIS (+35/-0)
log_connection_error.patch (+3/-3)
log_warnings_suppress.patch (+3/-3)
memory_dynamic_rows.patch (+2865/-0)
microsec_process.patch (+1/-1)
mysql-test/memory_dynamic_rows.patch/percona_heap_blob.result (+952/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_blob.test.disabled (+642/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.result (+14/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug783366.test.disabled (+19/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.result (+132/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug783451.test.disabled (+16/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.result (+70/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug784464.test.disabled (+67/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.result (+15/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test.disabled (+16/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.result (+9/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788544.test.disabled (+15/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.result (+19/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788576.test.disabled (+19/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.result (+18/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug788722.test.disabled (+20/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.result (+7/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_bug789131.test.disabled (+14/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_var.result (+194/-0)
mysql-test/memory_dynamic_rows.patch/percona_heap_var.test.disabled (+84/-0)
normalize_patches.sh (+1/-1)
optimizer_fix.patch (+2/-2)
processlist_row_stats.patch (+2/-2)
query_cache_enhance.patch (+2/-2)
response_time_distribution.patch (+8/-8)
show_slave_status_nolock.patch (+1/-1)
show_temp.patch (+6/-6)
slow_extended.patch (+17/-17)
sql_no_fcache.patch (+8/-8)
userstat.patch (+58/-58)
Changed in percona-projects-qa: | |
milestone: | none → 5.5.12-20.3 |
description: | updated |
Changed in percona-projects-qa: | |
assignee: | Stewart Smith (stewart) → nobody |
Changed in percona-projects-qa: | |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
Changed in percona-projects-qa: | |
status: | Confirmed → Fix Committed |
Bug was reproduced on Fedora x86_64 release vesrsion dev/percona/ 5.5.12/ Percona- Server- release/ mysql-test$ ./mysql-test-run main.percona_ xtradb_ bug317074 --valgrind dev/percona/ 5.5.12/ Percona- Server/ mysql-test/ mysql-test- run.pl main.percona_ xtradb_ bug317074 --valgrind
oleg.tsarev (0) /storage/
Logging: /storage/
110602 18:25:11 [Note] Flashcache bypass: disabled
110602 18:25:11 [Note] Flashcache setup error is : open flash device failed
MySQL Version 5.5.12 reachable= yes " dev/percona/ 5.5.12/ Percona- Server- release/ mysql-test/ var dev/percona/ 5.5.12/ Percona- Server- release/ mysql-test/ var'...
Turning on valgrind for all executables
Running valgrind with options " --show-
Checking supported features...
- skipping ndbcluster
- skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /storage/
Removing old var directory...
Creating var directory '/storage/
Installing system database...
Using server port 48481
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= =
TEST RESULT TIME (ms) or COMMENT ------- ------- ------- ------- ------- ------- ------- ------- ------- ----
-------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 xtradb_ bug317074 [ pass ] 255714 dev/percona/ 5.5.12/ Percona- Server- release/ mysql-test/ var/log/ mysqld. 1.err after tests: xtradb_ bug317074 ------- ------- ------- ------- ------- ------- ------- ------- ------- ----
main.percona_
worker[1] Valgrind report from /storage/
main.percona_
-------
HEAP SUMMARY:
in use at exit: 30,570,344 bytes in 207 blocks
total heap usage: 1,464,025 allocs, 1,463,818 frees, 7,849,406,315 bytes allocated
128 bytes in 1 blocks are possibly lost in loss record 107 of 136 malloc. c:195) create_ block (mem0mem.c:333) sys_create (mem0mem.ic:443) start_or_ create_ for_mysql (srv0start.c:1511) init(void* ) (ha_innodb.cc:2858) handlerton( st_plugin_ int*) (handler.cc:462) initialize( st_plugin_ int*) (sql_plugin. cc:1063) cc:1349) components( ) (mysqld.cc:3962)
at 0x4A05E46: malloc (vg_replace_
by 0x932408: mem_area_alloc (mem0pool.c:385)
by 0x93168E: mem_heap_
by 0x89F23E: btr_search_
by 0x8A9B23: buf_pool_init (buf0buf.c:1902)
by 0x85D4DA: innobase_
by 0x82068C: innobase_
by 0x688197: ha_initialize_
by 0x58A889: plugin_
by 0x58FA87: plugin_init(int*, char**, int) (sql_plugin.
by 0x50EE25: init_server_
by 0x51259C: mysqld_main(int, char**) (mysqld.cc:4634)
by 0x37E701EE5C: (below main) (libc-start.c:226)
128 bytes in 1 blocks are definitely lost in loss record 109 of 136 malloc. c:195) create_ block (mem0mem.c:333) sys_create (mem0mem.ic:443) start_or_ create_ for_mysql (srv0start.c:1511) init(void* ) (ha_innodb.cc:2858) handlerton( st_plugin_ int*) (handler.cc:462) initialize( st_plugin_ int*) (sql_plugin. cc:1063) cc:1349) components. ..
at 0x4A05E46: malloc (vg_replace_
by 0x932408: mem_area_alloc (mem0pool.c:385)
by 0x93168E: mem_heap_
by 0x89F2CF: btr_search_
by 0x8A9B23: buf_pool_init (buf0buf.c:1902)
by 0x85D4DA: innobase_
by 0x82068C: innobase_
by 0x688197: ha_initialize_
by 0x58A889: plugin_
by 0x58FA87: plugin_init(int*, char**, int) (sql_plugin.
by 0x50EE25: init_server_