Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.3
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-focal-amd64/builds/1177/steps/mtr/logs/stdio
10.3 d4967659032b18a5504198b41dd3d
main.partition_innodb 'innodb' w2 [ fail ]
|
Test ended at 2020-08-05 07:08:56
|
|
|
CURRENT_TEST: main.partition_innodb
|
mysqltest: At line 964: query 'CREATE TABLE t1
|
(a INT,
|
b INT,
|
PRIMARY KEY (a))
|
ENGINE = InnoDB' failed: 2013: Lost connection to MySQL server during query
|
|
|
The result from queries just before the failure was:
|
< snip >
|
b INT,
|
PRIMARY KEY (a))
|
ENGINE = InnoDB
|
PARTITION BY HASH (a) PARTITIONS 3;
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
connect con1, localhost, root,,;
|
ALTER TABLE t1 ADD INDEX idx1 (b);
|
connection default;
|
SELECT b FROM t1 WHERE b = 0;
|
ERROR HY000: Table definition has changed, please retry transaction
|
SELECT b FROM t1 WHERE b = 0;
|
ERROR HY000: Table definition has changed, please retry transaction
|
disconnect con1;
|
DROP TABLE t1;
|
# Same test without partitioning
|
CREATE TABLE t1
|
(a INT,
|
b INT,
|
PRIMARY KEY (a))
|
ENGINE = InnoDB;
|
|
|
More results from queries before failure can be found in /dev/shm/var/2/log/partition_innodb.log
|
|
|
|
|
Server [mysqld.1 - pid: 118023, winpid: 118023, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
double free or corruption (fasttop)
|
200805 7:08:51 [ERROR] 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.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
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.
|
|
|
Server version: 10.3.24-MariaDB-1:10.3.24+maria~focal-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=153
|
thread_count=8
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63200 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x7f1b44000c48
|
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 = 0x7f1b8b335da8 thread_stack 0x49000
|
/usr/sbin/mysqld(my_print_stacktrace+0x32)[0x55f80f59a8a2]
|
/usr/sbin/mysqld(handle_fatal_signal+0x55d)[0x55f80f07a4fd]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0)[0x7f1b967f13c0]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f1b962fe18b]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f1b962dd859]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x903ee)[0x7f1b963483ee]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x9847c)[0x7f1b9635047c]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x99de5)[0x7f1b96351de5]
|
/usr/sbin/mysqld(+0xb34100)[0x55f80f3d4100]
|
/usr/sbin/mysqld(+0x4ee41c)[0x55f80ed8e41c]
|
/usr/sbin/mysqld(+0xb071cc)[0x55f80f3a71cc]
|
/usr/sbin/mysqld(+0xb086ba)[0x55f80f3a86ba]
|
/usr/sbin/mysqld(+0xb08cf1)[0x55f80f3a8cf1]
|
/usr/sbin/mysqld(+0xaef3bb)[0x55f80f38f3bb]
|
/usr/sbin/mysqld(+0x501e00)[0x55f80eda1e00]
|
/usr/sbin/mysqld(+0xb5cc99)[0x55f80f3fcc99]
|
/usr/sbin/mysqld(+0xb0efcd)[0x55f80f3aefcd]
|
/usr/sbin/mysqld(+0xb102b4)[0x55f80f3b02b4]
|
/usr/sbin/mysqld(+0xa13618)[0x55f80f2b3618]
|
/usr/sbin/mysqld(+0xa3f5b3)[0x55f80f2df5b3]
|
/usr/sbin/mysqld(+0x994338)[0x55f80f234338]
|
/usr/sbin/mysqld(+0x990124)[0x55f80f230124]
|
/usr/sbin/mysqld(+0x995a21)[0x55f80f235a21]
|
/usr/sbin/mysqld(_ZN7handler9ha_createEPKcP5TABLEP14HA_CREATE_INFO+0x34)[0x55f80f083a04]
|
/usr/sbin/mysqld(_Z15ha_create_tableP3THDPKcS2_S2_P14HA_CREATE_INFOP34st_mysql_const_unsigned_lex_string+0x1ca)[0x55f80f08434a]
|
/usr/sbin/mysqld(_Z16rea_create_tableP3THDP34st_mysql_const_unsigned_lex_stringPKcS4_S4_P14HA_CREATE_INFOP7handlerb+0x9c)[0x55f80ef5700c]
|
/usr/sbin/mysqld(+0x67e4e7)[0x55f80ef1e4e7]
|
/usr/sbin/mysqld(_Z26mysql_create_table_no_lockP3THDPK25st_mysql_const_lex_stringS3_P22Table_specification_stP10Alter_infoPbiP10TABLE_LIST+0xff)[0x55f80ef1eb8f]
|
/usr/sbin/mysqld(_Z18mysql_create_tableP3THDP10TABLE_LISTP22Table_specification_stP10Alter_info+0x110)[0x55f80ef1edc0]
|
/usr/sbin/mysqld(_ZN25Sql_cmd_create_table_like7executeEP3THD+0x5f8)[0x55f80ef1ffb8]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x15f8)[0x55f80ee81ff8]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1f3)[0x55f80ee895f3]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x104d)[0x55f80ee8b9dd]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0x12d)[0x55f80ee8d97d]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x246)[0x55f80ef742b6]
|
/usr/sbin/mysqld(handle_one_connection+0x3f)[0x55f80ef7448f]
|
/usr/sbin/mysqld(+0xca99e6)[0x55f80f5499e6]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x9609)[0x7f1b967e5609]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f1b963da103]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f1b44011760): CREATE TABLE t1 (a INT, b INT, PRIMARY KEY (a)) ENGINE = InnoDB
|
Connection ID (thread ID): 46
|
Status: NOT_KILLED
|
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
|
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /dev/shm/var/2/mysqld.1/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 23441 23441 processes
|
Max open files 1024 1024 files
|
Max locked memory 67108864 67108864 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 23441 23441 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: |/usr/share/apport/apport %p %s %c %d %P %E
|
|
|
----------SERVER LOG END-------------
|
|
|
|
|
- found 'core' (0/0)
|
|
|
Trying 'dbx' to get a backtrace
|
|
|
Trying 'gdb' to get a backtrace from coredump /dev/shm/var/2/log/main.partition_innodb-innodb/mysqld.1/data/core
|
|
|
Trying 'lldb' to get a backtrace from coredump /dev/shm/var/2/log/main.partition_innodb-innodb/mysqld.1/data/core
|
Compressed file /dev/shm/var/2/log/main.partition_innodb-innodb/mysqld.1/data/core
|
- saving '/dev/shm/var/2/log/main.partition_innodb-innodb/' to '/dev/shm/var/log/main.partition_innodb-innodb/'
|