[MDEV-3853] Deadlock or assertion ret < srv_page_size failure on concurrent ALTER TABLE and SELECT from I_S Created: 2012-11-12  Updated: 2023-12-14

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1, 5.5.29, 5.3.10, 5.3.11, 5.2.13, 5.1.66
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File threads_5.5_90cb72127    
Issue Links:
Relates
relates to MDEV-344 InnoDB: Assertion failure ret < srv_p... Closed

 Description   

It's a recent regression which seems to have appeared after merge from Percona-Server 5.1.66-rel14.1.
A bug for Percona Server hasn't been filed yet as on some reason it's less reliably reproducible there, although I've seen it once.

On MariaDB, reproducible starting from maria/5.1 revno 3163, maria/5.3 revno 3592.

+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+----------+
| Id | User | Host            | db   | Command | Time | State             | Info                                                            | Progress |
+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+----------+
|  2 | root | 127.0.0.1:59063 | test | Sleep   |  115 |                   | NULL                                                            |    0.000 |
|  7 | root | 127.0.0.1:59068 | test | Query   |  106 | copy to tmp table | ALTER TABLE `E` ADD COLUMN o INTEGER                            |   54.524 |
|  8 | root | 127.0.0.1:59069 | test | Query   |  105 | executing         | SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1 |    0.000 |
|  9 | root | 127.0.0.1:59070 | test | Query   |  105 | executing         | SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1 |    0.000 |
| 13 | root | 127.0.0.1:59074 | NULL | Query   |    0 | NULL              | show full processlist                                           |    0.000 |
+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+----------+

Stacks of the three threads executing statements:

Thread 4 (Thread 0x7f818aa0f710 (LWP 3794)):
#0  0x00007f81a940e39c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000bdb882 in safe_cond_wait (cond=0x7f81990945f0, mp=0x7f8199094540,
    file=0xdfaa60 "os/os0sync.c", line=210) at thr_mutex.c:498
#2  0x0000000000ae990b in os_cond_wait (cond=0x7f81990945f0, mutex=0x7f8199094540)
    at os/os0sync.c:210
#3  0x0000000000aea131 in os_event_wait_low (event=0x7f8199094540, reset_sig_count=26)
    at os/os0sync.c:636
#4  0x0000000000b2b9d6 in sync_array_wait_event (arr=0x7f8198008e90, index=0)
    at sync/sync0arr.c:451
#5  0x0000000000b2cd93 in rw_lock_x_lock_wait (lock=0x7f818ffedd70,
    file_name=0xe05040 "trx/trx0rec.c", line=1270) at sync/sync0rw.c:520
#6  0x0000000000b2ce72 in rw_lock_x_lock_low (lock=0x7f818ffedd70, pass=0,
    file_name=0xe05040 "trx/trx0rec.c", line=1270) at sync/sync0rw.c:563
#7  0x0000000000b2cf47 in rw_lock_x_lock_func (lock=0x7f818ffedd70, pass=0,
    file_name=0xe05040 "trx/trx0rec.c", line=1270) at sync/sync0rw.c:622
#8  0x0000000000b62caf in buf_page_get_gen (space=0, zip_size=0, offset=46, rw_latch=2, guess=0x0,
    mode=10, file=0xe05040 "trx/trx0rec.c", line=1270, mtr=0x7f818aa0b060) at buf/buf0buf.c:2230
#9  0x0000000000b3454a in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7f81992cc630,
    index=0x7f819930b518, clust_entry=0x7f8199308df8, update=0x0, cmpl_info=0, rec=0x0,
    roll_ptr=0x7f818aa0b5c0) at trx/trx0rec.c:1268
#10 0x0000000000b51bed in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7f818aa0bbf0,
    entry=0x7f8199308df8, thr=0x7f81992cc630, mtr=0x7f818aa0b740, inherit=0x7f818aa0b640)
    at btr/btr0cur.c:1083
#11 0x0000000000b52092 in btr_cur_optimistic_insert (flags=0, cursor=0x7f818aa0bbf0,
    entry=0x7f8199308df8, rec=0x7f818aa0bbe8, big_rec=0x7f818aa0bbe0, n_ext=0, thr=0x7f81992cc630,
    mtr=0x7f818aa0b740) at btr/btr0cur.c:1284
#12 0x0000000000b06c08 in row_ins_index_entry_low (mode=2, index=0x7f819930b518,
    entry=0x7f8199308df8, n_ext=0, thr=0x7f81992cc630) at row/row0ins.c:2184
#13 0x0000000000b07053 in row_ins_index_entry (index=0x7f819930b518, entry=0x7f8199308df8,
    n_ext=0, foreign=1, thr=0x7f81992cc630) at row/row0ins.c:2296
#14 0x0000000000b07295 in row_ins_index_entry_step (node=0x7f8199451070, thr=0x7f81992cc630)
    at row/row0ins.c:2381
#15 0x0000000000b074e0 in row_ins (node=0x7f8199451070, thr=0x7f81992cc630) at row/row0ins.c:2513
#16 0x0000000000b076f3 in row_ins_step (thr=0x7f81992cc630) at row/row0ins.c:2623
#17 0x0000000000b0d460 in row_insert_for_mysql (mysql_rec=0x7f8199307230 "\f\374\210\003",
    prebuilt=0x7f819947c958) at row/row0mysql.c:1168
#18 0x0000000000aafe21 in ha_innobase::write_row (this=0x7f819944ff40,
    record=0x7f8199307230 "\f\374\210\003") at handler/ha_innodb.cc:5649
#19 0x0000000000862b85 in handler::ha_write_row (this=0x7f819944ff40,
    buf=0x7f8199307230 "\f\374\210\003") at handler.cc:4978
#20 0x0000000000890d3f in copy_data_between_tables (thd=0x7f8199297e38, from=0x7f818400c768,
    to=0x7f81992a9428, create=..., ignore=false, order_num=0, order=0x0, copied=0x7f818aa0db30,
    deleted=0x7f818aa0db28, keys_onoff=LEAVE_AS_IS, error_if_not_empty=false) at sql_table.cc:8118
#21 0x000000000088f000 in mysql_alter_table (thd=0x7f8199297e38, new_db=0x1c19148 "test",
    new_name=0x1c18d18 "E", create_info=0x7f818aa0e100, table_list=0x1c18d50,
    alter_info=0x7f818aa0e200, order_num=0, order=0x0, ignore=false, require_online=false)
    at sql_table.cc:7540
#22 0x00000000006e4002 in mysql_execute_command (thd=0x7f8199297e38) at sql_parse.cc:2974
#23 0x00000000006edc50 in mysql_parse (thd=0x7f8199297e38,
    rawbuf=0x1c18c50 "ALTER TABLE `E` ADD COLUMN o INTEGER", length=36,
    found_semicolon=0x7f818aa0ec98) at sql_parse.cc:6158
#24 0x00000000006dfa90 in dispatch_command (command=COM_QUERY, thd=0x7f8199297e38,
    packet=0x7f81992dbe59 "ALTER TABLE `E` ADD COLUMN o INTEGER", packet_length=36)
    at sql_parse.cc:1228
#25 0x00000000006dedc4 in do_command (thd=0x7f8199297e38) at sql_parse.cc:923
#26 0x00000000006dbc12 in handle_one_connection (arg=0x7f8199297e38) at sql_connect.cc:1218
#27 0x00007f81a9409a4f in start_thread () from /lib64/libpthread.so.0
#28 0x00007f81a87f382d in clone () from /lib64/libc.so.6
#29 0x0000000000000000 in ?? ()
 
Thread 3 (Thread 0x7f818a9c7710 (LWP 3796)):
#0  0x00007f81a940e39c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000bdb882 in safe_cond_wait (cond=0x7f8199086bf0, mp=0x7f8199086b40,
    file=0xdfaa60 "os/os0sync.c", line=210) at thr_mutex.c:498
#2  0x0000000000ae990b in os_cond_wait (cond=0x7f8199086bf0, mutex=0x7f8199086b40)
    at os/os0sync.c:210
#3  0x0000000000aea131 in os_event_wait_low (event=0x7f8199086b40, reset_sig_count=1)
    at os/os0sync.c:636
#4  0x0000000000b2b9d6 in sync_array_wait_event (arr=0x7f8198008e90, index=2)
    at sync/sync0arr.c:451
#5  0x0000000000b2d6a8 in mutex_spin_wait (mutex=0x7f818ffe65f8,
    file_name=0xe09b88 "./include/buf0buf.ic", line=347) at sync/sync0sync.c:621
#6  0x0000000000b2d22b in mutex_enter_func (mutex=0x7f818ffe65f8,
    file_name=0xe09b88 "./include/buf0buf.ic", line=347) at ./include/sync0sync.ic:221
#7  0x0000000000b5ee12 in buf_page_get_mutex_enter (bpage=0x7f818ffe6540)
    at ./include/buf0buf.ic:347
#8  0x0000000000ac72fc in i_s_innodb_fill_buffer_pool (thd=0x7f81992dfe98, tables=0x1ba1918)
    at handler/i_s.cc:5796
#9  0x0000000000ac74d7 in i_s_innodb_buffer_page_fill_table (thd=0x7f81992dfe98, tables=0x1ba1918)
    at handler/i_s.cc:5852
#10 0x00000000008b27ed in get_schema_tables_result (join=0x1e514e0,
    executed_place=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:7089
#11 0x0000000000763e67 in JOIN::exec (this=0x1e514e0) at sql_select.cc:2225
#12 0x00000000007668fd in mysql_select (thd=0x7f81992dfe98, rref_pointer_array=0x7f81992e2b88,
    tables=0x1ba1918, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
    having=0x0, proc_param=0x0, select_options=2684635648, result=0x1ba3410, unit=0x7f81992e2428,
    select_lex=0x7f81992e2930) at sql_select.cc:2983
#13 0x000000000075d449 in handle_select (thd=0x7f81992dfe98, lex=0x7f81992e2388, result=0x1ba3410,
    setup_tables_done_option=0) at sql_select.cc:286
#14 0x00000000006eb275 in execute_sqlcom_select (thd=0x7f81992dfe98, all_tables=0x1ba1918)
    at sql_parse.cc:5157
#15 0x00000000006e2332 in mysql_execute_command (thd=0x7f81992dfe98) at sql_parse.cc:2290
#16 0x00000000006edc50 in mysql_parse (thd=0x7f81992dfe98,
    rawbuf=0x1ba1670 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1", length=63,
    found_semicolon=0x7f818a9c6c98) at sql_parse.cc:6158
#17 0x00000000006dfa90 in dispatch_command (command=COM_QUERY, thd=0x7f81992dfe98,
    packet=0x7f81992e35c9 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1",
    packet_length=63) at sql_parse.cc:1228
#18 0x00000000006dedc4 in do_command (thd=0x7f81992dfe98) at sql_parse.cc:923
#19 0x00000000006dbc12 in handle_one_connection (arg=0x7f81992dfe98) at sql_connect.cc:1218
#20 0x00007f81a9409a4f in start_thread () from /lib64/libpthread.so.0
#21 0x00007f81a87f382d in clone () from /lib64/libc.so.6
#22 0x0000000000000000 in ?? ()
 
Thread 2 (Thread 0x7f818a97f710 (LWP 3798)):
#0  0x00007f81a940e39c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000bdb882 in safe_cond_wait (cond=0x7f8198ab38e0, mp=0x7f8198ab3830,
    file=0xdfaa60 "os/os0sync.c", line=210) at thr_mutex.c:498
#2  0x0000000000ae990b in os_cond_wait (cond=0x7f8198ab38e0, mutex=0x7f8198ab3830)
    at os/os0sync.c:210
#3  0x0000000000aea131 in os_event_wait_low (event=0x7f8198ab3830, reset_sig_count=16)
    at os/os0sync.c:636
#4  0x0000000000b2b9d6 in sync_array_wait_event (arr=0x7f8198008e90, index=3)
    at sync/sync0arr.c:451
#5  0x0000000000b2d6a8 in mutex_spin_wait (mutex=0x1a8b5e0, file_name=0xdf407f "handler/i_s.cc",
    line=5792) at sync/sync0sync.c:621
#6  0x0000000000b2d22b in mutex_enter_func (mutex=0x1a8b5e0, file_name=0xdf407f "handler/i_s.cc",
    line=5792) at ./include/sync0sync.ic:221
#7  0x0000000000ac72e6 in i_s_innodb_fill_buffer_pool (thd=0x7f81992f12f8, tables=0x1ea22e8)
    at handler/i_s.cc:5792
#8  0x0000000000ac74d7 in i_s_innodb_buffer_page_fill_table (thd=0x7f81992f12f8, tables=0x1ea22e8)
    at handler/i_s.cc:5852
#9  0x00000000008b27ed in get_schema_tables_result (join=0x7f818403d9b0,
    executed_place=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:7089
#10 0x0000000000763e67 in JOIN::exec (this=0x7f818403d9b0) at sql_select.cc:2225
#11 0x00000000007668fd in mysql_select (thd=0x7f81992f12f8, rref_pointer_array=0x7f81992f3fe8,
    tables=0x1ea22e8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
    having=0x0, proc_param=0x0, select_options=2684635648, result=0x1ea3de0, unit=0x7f81992f3888,
    select_lex=0x7f81992f3d90) at sql_select.cc:2983
#12 0x000000000075d449 in handle_select (thd=0x7f81992f12f8, lex=0x7f81992f37e8, result=0x1ea3de0,
    setup_tables_done_option=0) at sql_select.cc:286
#13 0x00000000006eb275 in execute_sqlcom_select (thd=0x7f81992f12f8, all_tables=0x1ea22e8)
    at sql_parse.cc:5157
#14 0x00000000006e2332 in mysql_execute_command (thd=0x7f81992f12f8) at sql_parse.cc:2290
#15 0x00000000006edc50 in mysql_parse (thd=0x7f81992f12f8,
    rawbuf=0x1ea2040 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1", length=63,
    found_semicolon=0x7f818a97ec98) at sql_parse.cc:6158
#16 0x00000000006dfa90 in dispatch_command (command=COM_QUERY, thd=0x7f81992f12f8,
    packet=0x7f81992f4a29 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1",
    packet_length=63) at sql_parse.cc:1228
#17 0x00000000006dedc4 in do_command (thd=0x7f81992f12f8) at sql_parse.cc:923
#18 0x00000000006dbc12 in handle_one_connection (arg=0x7f81992f12f8) at sql_connect.cc:1218
#19 0x00007f81a9409a4f in start_thread () from /lib64/libpthread.so.0
#20 0x00007f81a87f382d in clone () from /lib64/libc.so.6
#21 0x0000000000000000 in ?? ()

RQG grammar (mdev-3853.yy):

query:
        SELECT * FROM { $last_database = 'INFORMATION_SCHEMA' } . _table LIMIT 1 ;
 
thread1:
        ALTER TABLE _table ADD COLUMN _letter INTEGER |
        ALTER TABLE _table DROP COLUMN _letter ;

RQG command line, assuming you already have server up and running on port 3306:

 perl ./gentest.pl --threads=3 --duration=600 --queries=100M --grammar=mdev-3853.yy --engine=InnoDB --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test --gendata 

The deadlock is reproducible on maria/5.1 revno 3180, maria/5.2 revno 3204, maria/5.3 revno 3619.
I didn't see the deadlock on 5.5 and 10.0, but I'm getting the assertion failure instead (not every time, but often enough):

130128  2:39:35  InnoDB: Assertion failure in thread 140451356055296 in file page0page.ic line 934
InnoDB: Failing assertion: ret < srv_page_size

#5  0x00007fbd5fc5fb0b in __GI_abort () at abort.c:92
#6  0x0000000000b6f3fa in page_get_data_size (page=0x7fbd4d6ac000 "") at 10.0-base/storage/xtradb/include/page0page.ic:934
#7  0x0000000000a688ea in i_s_innodb_buffer_pool_pages_index_fill (thd=0x43bb0b8, tables=0x7fbd3c1662d0, cond=0x0) at 10.0-base/storage/xtradb/handler/i_s.cc:6564
#8  0x000000000069ec20 in do_fill_table (thd=0x43bb0b8, table_list=0x7fbd3c1662d0, join_table=0x7fbd3c284260) at 10.0-base/sql/sql_show.cc:7914
#9  0x000000000069f032 in get_schema_tables_result (join=0x7fbd3c1f2330, executed_place=PROCESSED_BY_JOIN_EXEC) at 10.0-base/sql/sql_show.cc:8021
#10 0x0000000000648560 in JOIN::exec_inner (this=0x7fbd3c1f2330) at 10.0-base/sql/sql_select.cc:2414
#11 0x0000000000647bbd in JOIN::exec (this=0x7fbd3c1f2330) at 10.0-base/sql/sql_select.cc:2258
#12 0x000000000064b1e5 in mysql_select (thd=0x43bb0b8, rref_pointer_array=0x43be040, tables=0x7fbd3c1662d0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7fbd3c0a7890, unit=0x43bd698, select_lex=0x43bdd90) at 10.0-base/sql/sql_select.cc:3194
#13 0x0000000000641a76 in handle_select (thd=0x43bb0b8, lex=0x43bd5e0, result=0x7fbd3c0a7890, setup_tables_done_option=0) at 10.0-base/sql/sql_select.cc:368
#14 0x00000000006192b1 in execute_sqlcom_select (thd=0x43bb0b8, all_tables=0x7fbd3c1662d0) at 10.0-base/sql/sql_parse.cc:4765
#15 0x0000000000611941 in mysql_execute_command (thd=0x43bb0b8) at 10.0-base/sql/sql_parse.cc:2245
#16 0x000000000061bb1b in mysql_parse (thd=0x43bb0b8, rawbuf=0x7fbd3c1c0680 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_PAGES_INDEX` LIMIT 1", length=75, parser_state=0x7fbd612f8540) at 10.0-base/sql/sql_parse.cc:5881
#17 0x000000000060ec8b in dispatch_command (command=COM_QUERY, thd=0x43bb0b8, packet=0x43c04d9 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_PAGES_INDEX` LIMIT 1", packet_length=75) at 10.0-base/sql/sql_parse.cc:1070
#18 0x000000000060df42 in do_command (thd=0x43bb0b8) at 10.0-base/sql/sql_parse.cc:809
#19 0x0000000000722735 in do_handle_one_connection (thd_arg=0x43bb0b8) at 10.0-base/sql/sql_connect.cc:1253
#20 0x0000000000722120 in handle_one_connection (arg=0x43bb0b8) at 10.0-base/sql/sql_connect.cc:1168
#21 0x00007fbd60998efc in start_thread (arg=0x7fbd612f9700) at pthread_create.c:304

The stack trace is from

revision-id: sergii@pisem.net-20130124165225-gczln6zrzi4lz4bx
revno: 3485
branch-nick: 10.0-base

In all cases the server was built with BUILD/compile-pentium-valgrind-max-no-ndb.



 Comments   
Comment by Sergei Golubchik [ 2013-01-25 ]

Cannot repeat on the latest 5.3 (neither on 5.2 or 5.1)

Comment by Elena Stepanova [ 2013-01-26 ]

Still reproducible for me on maria/5.1 revno 3180, Version: '5.1.67-MariaDB-valgrind-max-debug-log'

mysql> show processlist;
----------------------------------------------------------------------------------------------------------------------------+

Id User Host db Command Time State Info

----------------------------------------------------------------------------------------------------------------------------+

2 root 127.0.0.1:43458 test Sleep 442   NULL
7 root 127.0.0.1:43463 test Query 325 copy to tmp table ALTER TABLE `E` DROP COLUMN i
8 root 127.0.0.1:43464 test Query 325 executing SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_STATS` LIMIT 1
9 root 127.0.0.1:43465 test Query 325 executing SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1
11 root 127.0.0.1:43467 NULL Query 0 NULL show processlist

----------------------------------------------------------------------------------------------------------------------------+

But I'm running the full runall test, if you are using gentest instead, it might make the difference, since MTR1 adds lots of non-default options to the server. I will try gentest.

Comment by Elena Stepanova [ 2013-01-27 ]

If you just replaced basedir1 with dsn and runall with gentest, it's not going to work, because it also needs an extra option '--gendata' (it's assumed by default by runall, but not gentest). So, basically the test runs idle, on an empty datadir (ALTER TABLE doesn't work). The test produces a message about it on start, but it's easy to miss.

Here is the command line for gentest.pl:

perl ./gentest.pl --threads=3 --duration=600 --queries=100M --grammar=is.yy --engine=InnoDB --dsn=dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test --gendata

For me it hangs within a minute or so after start. It comes it two different forms: either the processlist shows hanging threads as described before, or I cannot connect to the server at all.

No special mysqld options are required, here is my server command line (no defaults file on the system):

./bin/mysqld --no-defaults --basedir=. --datadir=./data --log-error=./data/ubuntu11.err --pid-file=./data/ubuntu11.pid

maria/5.1 revno 3180, Version: '5.1.67-MariaDB-valgrind-max-debug-log'

I will also check on a faster machine, maybe it requires more threads there.

Upd: Checked on gentoo 8 GB / 3 cores. I finally managed to reproduce it, but it took much longer and wasn't reliable, and that's while my installation is not anyhow tuned. Increasing the number of threads doesn't help much. So, I suppose it will be more efficient if I set up a special VM to reproduce the problem.

Comment by Elena Stepanova [ 2013-01-27 ]

I've set up a kvm on terrier to reproduce the problem. It happens easily there.

To start kvm, run the wrapper script as usual, then do

runvm --user=buildbot --port=19304 --smp=2 --mem=4096 --cpu=qemu64 --kvm=-hdb --kvm=mdev-3853-spare-partition.qcow2 mdev-3853.qcow2 bash

(port of your choice, both mdev-3853* images live in buildbot home folder).

ssh to the machine
server is in /data/5.1 (built with BUILD/compile-pentium-valgrind-max-no-ndb).
There is a clean prepared datadir /data/5.1/data.clean in case you want to make sure you have a clean start.

cd /data/5.1
rm -rf data && cp -r data.clean data

Run server as

/data/5.1/sql/mysqld --datadir=/data/5.1/data/ --basedir=/data/5.1 --port=8306 --loose-language=/data/5.1/sql/share/english --socket=/tmp/master.sock &

cd /data/randgen

Run the test as

perl ./gentest.pl --threads=3 --duration=600 --queries=100M --grammar=mdev-3853.yy --engine=InnoDB --dsn=dbi:mysql:host=127.0.0.1:port=8306:user=root:database=test --gendata

Monitor the processlist in the process (from another console, of course):

 /data/5.1/client/mysql -uroot --protocol=tcp --port=8306 -e "show processlist"
 
+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+
| Id | User | Host            | db   | Command | Time | State             | Info                                                            |
+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+
|  5 | root | localhost:50837 | test | Query   |   89 | copy to tmp table | ALTER TABLE `E` ADD COLUMN c INTEGER                            |
|  6 | root | localhost:50838 | test | Query   |   89 | executing         | SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_PAGE` LIMIT 1 |
|  7 | root | localhost:50839 | test | Query   |   88 | NULL              | SELECT * FROM INFORMATION_SCHEMA . `STATISTICS` LIMIT 1         |
| 11 | root | localhost:50843 | NULL | Query   |    0 | NULL              | show processlist                                                |
+----+------+-----------------+------+---------+------+-------------------+-----------------------------------------------------------------+ 

Comment by Elena Stepanova [ 2013-01-28 ]

Added a part about assertion on 5.5 and 10.0; could not check if it's reproducible on Percona, since it seems to have bigger problems with the same flow at the moment, it aborts almost immediately with a different assertion failure.

Also updated the RQG line to gentest.

The VM described above only has setup for 5.1, please try to use it to reproduce the deadlock
If the assertion on 5.5/10.0 looks like a different problem, I will check it separately.

Comment by Sergei Golubchik [ 2013-06-03 ]

cannot repeat on 5.5, nothing bad happens.

Comment by Elena Stepanova [ 2013-06-03 ]

I'll check again, maybe Percona fixed it in XtraDB

Comment by Elena Stepanova [ 2014-06-23 ]

Getting the assertion failure again, on current 5.5 tree (after 5.5.38), with

perl runall-new.pl  --no-mask --seed=1339736060 --threads=8 --duration=3600 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --grammar=conf/runtime/information_schema.yy --engine=InnoDB  --mysqld=--log-output=FILE --mtr-build-thread=300  --basedir1=/home/elenst/bzr/5.5 --vardir1=/home/elenst/test_results/analyze3c

But it takes long time, over 30 min, is not reliable, and I cannot reproduce it on 10.0.
Given that, I'll keep observing – if it's gone in 10.0, maybe it's not worth fixing at all, otherwise we'll need a better test.

140622 20:24:36  InnoDB: Assertion failure in thread 139743704536832 in file page0page.ic line 934
InnoDB: Failing assertion: ret < srv_page_size

All threads:

[New LWP 6316]
[New LWP 6284]
[New LWP 6269]
[New LWP 6271]
[New LWP 6268]
[New LWP 6270]
[New LWP 6272]
[New LWP 6312]
[New LWP 6266]
[New LWP 6286]
[New LWP 6308]
[New LWP 6304]
[New LWP 6273]
[New LWP 6278]
[New LWP 6310]
[New LWP 6277]
[New LWP 6276]
[New LWP 6290]
[New LWP 6275]
[New LWP 6281]
[New LWP 6283]
[New LWP 6285]
[New LWP 6282]
[New LWP 6280]
[New LWP 6274]
[New LWP 6306]
[New LWP 6314]
[New LWP 6302]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `/home/elenst/bzr/5.5/sql/mysqld --no-defaults --basedir=/home/elenst/bzr/5.5 --'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007f189eb34f8c in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
 
Thread 28 (Thread 0x7f189f876700 (LWP 6302)):
#0  0x00007f189e25625d in fdatasync () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x0000000000c3c191 in os_file_fsync (file=11, metadata=0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:2279
#2  0x0000000000c3c27c in os_file_flush_func (file=11, metadata=0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:2386
#3  0x0000000000bcdc8b in pfs_os_file_flush_func (file=11, metadata=0, src_file=0xeb9de8 "/home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c", src_line=5822) at /home/elenst/bzr/5.5/storage/xtradb/include/os0file.ic:385
#4  0x0000000000bdf9c1 in fil_flush (space_id=4294967280, metadata=0) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5822
#5  0x0000000000c217de in log_write_up_to (lsn=42772681, wait=92, flush_to_disk=1) at /home/elenst/bzr/5.5/storage/xtradb/log/log0log.c:1749
#6  0x0000000000b3ef89 in trx_commit_off_kernel (trx=0x7f1874875678) at /home/elenst/bzr/5.5/storage/xtradb/trx/trx0trx.c:1256
#7  0x0000000000b40a90 in trx_commit_for_mysql (trx=0x7f1874875678) at /home/elenst/bzr/5.5/storage/xtradb/trx/trx0trx.c:1931
#8  0x0000000000aea31a in row_rename_table_for_mysql (old_name=0x7f1875c6f0e0 "test/AA#P#p3", new_name=0x7f1875c6f020 "test/#sql2-187a-9#P#p3", trx=0x7f1874875678, commit=1) at /home/elenst/bzr/5.5/storage/xtradb/row/row0mysql.c:4330
#9  0x0000000000ab6ffc in innobase_rename_table (trx=0x7f1874875678, from=0x7f189f8716c0 "./test/AA#P#p3", to=0x7f189f8718c0 "./test/#sql2-187a-9#P#p3", lock_and_commit=1) at /home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc:8839
#10 0x0000000000ab710e in ha_innobase::rename_table (this=0x7f18755c5020, from=0x7f189f8716c0 "./test/AA#P#p3", to=0x7f189f8718c0 "./test/#sql2-187a-9#P#p3") at /home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc:8890
#11 0x00000000007dac53 in handler::ha_rename_table (this=0x7f18755c5020, from=0x7f189f8716c0 "./test/AA#P#p3", to=0x7f189f8718c0 "./test/#sql2-187a-9#P#p3") at /home/elenst/bzr/5.5/sql/handler.cc:3704
#12 0x0000000000cb0999 in ha_partition::del_ren_cre_table (this=0x7f18754271a8, from=0x7f189f8722c0 "./test/AA", to=0x7f189f8724d0 "./test/#sql2-187a-9", table_arg=0x0, create_info=0x0) at /home/elenst/bzr/5.5/sql/ha_partition.cc:2038
#13 0x0000000000cad0c7 in ha_partition::rename_table (this=0x7f18754271a8, from=0x7f189f8722c0 "./test/AA", to=0x7f189f8724d0 "./test/#sql2-187a-9") at /home/elenst/bzr/5.5/sql/ha_partition.cc:507
#14 0x00000000007dac53 in handler::ha_rename_table (this=0x7f18754271a8, from=0x7f189f8722c0 "./test/AA", to=0x7f189f8724d0 "./test/#sql2-187a-9") at /home/elenst/bzr/5.5/sql/handler.cc:3704
#15 0x00000000006b53fb in mysql_rename_table (base=0x7f189d491c60, old_db=0x7f18754be730 "test", old_name=0x7f18754be130 "AA", new_db=0x7f18754be730 "test", new_name=0x7f189f872d90 "#sql2-187a-9", flags=2) at /home/elenst/bzr/5.5/sql/sql_table.cc:4733
#16 0x00000000006bba66 in mysql_alter_table (thd=0x7f187b774060, new_db=0x7f18754be730 "test", new_name=0x7f18754be130 "AA", create_info=0x7f189f874510, table_list=0x7f18754be168, alter_info=0x7f189f874470, order_num=0, order=0x0, ignore=false, require_online=false) at /home/elenst/bzr/5.5/sql/sql_table.cc:7140
#17 0x0000000000950503 in Alter_table_statement::execute (this=0x7f18754be760, thd=0x7f187b774060) at /home/elenst/bzr/5.5/sql/sql_alter.cc:106
#18 0x000000000061aeb3 in mysql_execute_command (thd=0x7f187b774060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4513
#19 0x000000000061de85 in mysql_parse (thd=0x7f187b774060, rawbuf=0x7f18754be078 "ALTER TABLE `AA` DROP COLUMN f", length=30, parser_state=0x7f189f875620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#20 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b774060, packet=0x7f187b779061 "ALTER TABLE `AA` DROP COLUMN f", packet_length=30) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#21 0x0000000000610880 in do_command (thd=0x7f187b774060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#22 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b774060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#23 0x000000000071c40c in handle_one_connection (arg=0x7f187b774060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#24 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#25 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#26 0x0000000000000000 in ?? ()
 
Thread 27 (Thread 0x7f189de2e700 (LWP 6314)):
#0  0x00007f189eb36ccd in write () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000d352c6 in vio_write (vio=0x7f187b6bffe0, buf=0x7f187b7b8060 "\001", size=6285) at /home/elenst/bzr/5.5/vio/viosocket.c:158
#2  0x000000000056e18f in net_real_write (net=0x7f187b7b3370, packet=0x7f187b7b8060 "\001", len=6285) at /home/elenst/bzr/5.5/sql/net_serv.cc:643
#3  0x000000000056d8ef in net_flush (net=0x7f187b7b3370) at /home/elenst/bzr/5.5/sql/net_serv.cc:348
#4  0x0000000000573c14 in net_send_eof (thd=0x7f187b7b3060, server_status=34, statement_warn_count=0) at /home/elenst/bzr/5.5/sql/protocol.cc:300
#5  0x0000000000574363 in Protocol::send_eof (this=0x7f187b7b3628, server_status=34, statement_warn_count=0) at /home/elenst/bzr/5.5/sql/protocol.cc:560
#6  0x000000000057419a in Protocol::end_statement (this=0x7f187b7b3628) at /home/elenst/bzr/5.5/sql/protocol.cc:508
#7  0x0000000000612ac6 in dispatch_command (command=COM_QUERY, thd=0x7f187b7b3060, packet=0x7f187b7b8061 "", packet_length=207) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1472
#8  0x0000000000610880 in do_command (thd=0x7f187b7b3060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#9  0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b7b3060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#10 0x000000000071c40c in handle_one_connection (arg=0x7f187b7b3060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#11 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#12 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#13 0x0000000000000000 in ?? ()
 
Thread 26 (Thread 0x7f189df52700 (LWP 6306)):
#0  0x00007f189eb36ccd in write () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000d352c6 in vio_write (vio=0x7f187b6bf5e0, buf=0x7f187b760060 "\001", size=1107) at /home/elenst/bzr/5.5/vio/viosocket.c:158
#2  0x000000000056e18f in net_real_write (net=0x7f187b75b370, packet=0x7f187b760060 "\001", len=1107) at /home/elenst/bzr/5.5/sql/net_serv.cc:643
#3  0x000000000056d8ef in net_flush (net=0x7f187b75b370) at /home/elenst/bzr/5.5/sql/net_serv.cc:348
#4  0x0000000000573c14 in net_send_eof (thd=0x7f187b75b060, server_status=2, statement_warn_count=0) at /home/elenst/bzr/5.5/sql/protocol.cc:300
#5  0x0000000000574363 in Protocol::send_eof (this=0x7f187b75b628, server_status=2, statement_warn_count=0) at /home/elenst/bzr/5.5/sql/protocol.cc:560
#6  0x000000000057419a in Protocol::end_statement (this=0x7f187b75b628) at /home/elenst/bzr/5.5/sql/protocol.cc:508
#7  0x0000000000612ac6 in dispatch_command (command=COM_QUERY, thd=0x7f187b75b060, packet=0x7f187b760061 "", packet_length=430) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1472
#8  0x0000000000610880 in do_command (thd=0x7f187b75b060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#9  0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b75b060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#10 0x000000000071c40c in handle_one_connection (arg=0x7f187b75b060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#11 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#12 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#13 0x0000000000000000 in ?? ()
 
Thread 25 (Thread 0x7f187e7fa700 (LWP 6274)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff100, segment=3, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=5, message1=0x7f187e7f9e08, message2=0x7f187e7f9e10, type=0x7f187e7f9e18, space_id=0x7f187e7f9e20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=5) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b88 <n+40>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 24 (Thread 0x7f187afff700 (LWP 6280)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687bb0, mp=0x7f188b687b00, abstime=0x7f187affedc0, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687bb0, mutex=0x7f188b687b00, abstime=0x7f187affedc0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687b00, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b1153d in srv_lock_timeout_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:2808
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 23 (Thread 0x7f1879ffd700 (LWP 6282)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687cb0, mp=0x7f188b687c00, abstime=0x7f1879ffcdc0, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687cb0, mutex=0x7f188b687c00, abstime=0x7f1879ffcdc0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687c00, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b1115d in srv_monitor_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:2658
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 22 (Thread 0x7f18773fe700 (LWP 6285)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687eb0, mp=0x7f188b687e00, abstime=0x7f18773fddd0, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687eb0, mutex=0x7f188b687e00, abstime=0x7f18773fddd0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687e00, time_in_usec=911000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b14134 in srv_purge_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:4201
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 21 (Thread 0x7f18797fc700 (LWP 6283)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687eb0, mp=0x7f188b687e00, abstime=0x7f18797fbdf0, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687eb0, mutex=0x7f188b687e00, abstime=0x7f18797fbdf0) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687e00, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b11b0d in srv_LRU_dump_restore_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:3067
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 20 (Thread 0x7f187a7fe700 (LWP 6281)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687ab0, mp=0x7f188b687a00, abstime=0x7f187a7fdd90, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687ab0, mutex=0x7f188b687a00, abstime=0x7f187a7fdd90) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687a00, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b11a98 in srv_error_monitor_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:3021
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 19 (Thread 0x7f187dff9700 (LWP 6275)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff150, segment=0, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=6, message1=0x7f187dff8e08, message2=0x7f187dff8e10, type=0x7f187dff8e18, space_id=0x7f187dff8e20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=6) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b90 <n+48>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 18 (Thread 0x7f189f8bf700 (LWP 6290)):
#0  0x00007f189eb36d2d in read () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000d34f57 in vio_read (vio=0x7f189d453ee0, buf=0x7f187b76f060 "\a", size=4) at /home/elenst/bzr/5.5/vio/viosocket.c:72
#2  0x000000000056e4da in my_real_read (net=0x7f187b65b370, complen=0x7f189f8bed30) at /home/elenst/bzr/5.5/sql/net_serv.cc:840
#3  0x000000000056eb3d in my_net_read (net=0x7f187b65b370) at /home/elenst/bzr/5.5/sql/net_serv.cc:1026
#4  0x00000000006106b3 in do_command (thd=0x7f187b65b060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:739
#5  0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b65b060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#6  0x000000000071c40c in handle_one_connection (arg=0x7f187b65b060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#7  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#8  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#9  0x0000000000000000 in ?? ()
 
Thread 17 (Thread 0x7f187d7f8700 (LWP 6276)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff150, segment=1, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=7, message1=0x7f187d7f7e08, message2=0x7f187d7f7e10, type=0x7f187d7f7e18, space_id=0x7f187d7f7e20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=7) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b98 <n+56>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 16 (Thread 0x7f187cff7700 (LWP 6277)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff150, segment=2, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=8, message1=0x7f187cff6e08, message2=0x7f187cff6e10, type=0x7f187cff6e18, space_id=0x7f187cff6e20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=8) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82ba0 <n+64>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 15 (Thread 0x7f189dec0700 (LWP 6310)):
#0  0x00007f189e2b3a45 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x0000000000573460 in Protocol::net_store_data (this=0x7f187b79f628, from=0x7f189debdb50 "5454-09-03 14:19:35", length=1) at /home/elenst/bzr/5.5/sql/protocol.cc:60
#2  0x000000000057596e in Protocol::store_string_aux (this=0x7f187b79f628, from=0x7f189debdb50 "5454-09-03 14:19:35", length=1, fromcs=0x1492e00 <my_charset_latin1>, tocs=0x1492e00 <my_charset_latin1>) at /home/elenst/bzr/5.5/sql/protocol.cc:1016
#3  0x00000000005764f1 in Protocol_text::store (this=0x7f187b79f628, field=0x7f1874576d10) at /home/elenst/bzr/5.5/sql/protocol.cc:1175
#4  0x00000000007f3073 in Item_field::send (this=0x7f187428f990, protocol=0x7f187b79f628, buffer=0x7f189debded0) at /home/elenst/bzr/5.5/sql/item.cc:6616
#5  0x0000000000575576 in Protocol::send_result_set_row (this=0x7f187b79f628, row_items=0x7f187b7a2b70) at /home/elenst/bzr/5.5/sql/protocol.cc:903
#6  0x00000000005db920 in select_send::send_data (this=0x7f1874026040, items=...) at /home/elenst/bzr/5.5/sql/sql_class.cc:2370
#7  0x0000000000671b61 in end_send (join=0x7f187428f208, join_tab=0x7f1870c698b8, end_of_records=false) at /home/elenst/bzr/5.5/sql/sql_select.cc:17928
#8  0x000000000066fa01 in evaluate_join_record (join=0x7f187428f208, join_tab=0x7f1870c69598, error=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:17039
#9  0x000000000066f4f5 in sub_select (join=0x7f187428f208, join_tab=0x7f1870c69598, end_of_records=false) at /home/elenst/bzr/5.5/sql/sql_select.cc:16859
#10 0x000000000066ebdc in do_select (join=0x7f187428f208, fields=0x7f187b7a2b70, table=0x0, procedure=0x0) at /home/elenst/bzr/5.5/sql/sql_select.cc:16482
#11 0x000000000064c412 in JOIN::exec (this=0x7f187428f208) at /home/elenst/bzr/5.5/sql/sql_select.cc:2870
#12 0x000000000064cc1b in mysql_select (thd=0x7f187b79f060, rref_pointer_array=0x7f187b7a2cc8, tables=0x7f18740244a0, wild_num=1, fields=..., conds=0x7f1874025e88, og_num=1, order=0x7f1874025ff8, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f1874026040, unit=0x7f187b7a2380, select_lex=0x7f187b7a2a58) at /home/elenst/bzr/5.5/sql/sql_select.cc:3090
#13 0x00000000006432e3 in handle_select (thd=0x7f187b79f060, lex=0x7f187b7a22d0, result=0x7f1874026040, setup_tables_done_option=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:319
#14 0x000000000061b6b8 in execute_sqlcom_select (thd=0x7f187b79f060, all_tables=0x7f18740244a0) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4688
#15 0x0000000000614275 in mysql_execute_command (thd=0x7f187b79f060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2233
#16 0x000000000061de85 in mysql_parse (thd=0x7f187b79f060, rawbuf=0x7f1874024078 "SELECT * FROM test . `E` AS table1 WHERE  ( ( ( ( table1 . `col_varchar_nokey` != 5 AND table1 . `col_int_key` != table1 . `col_date_key`) AND table1 . `col_datetime_key` > 6) OR table1 . `col_int_nok"..., length=293, parser_state=0x7f189debf620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#17 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b79f060, packet=0x7f187b7a4061 "2004-01-15 07:01:15\001j\001j\373\373\373\373\373\373\373\373\373d", packet_length=294) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#18 0x0000000000610880 in do_command (thd=0x7f187b79f060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#19 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b79f060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#20 0x000000000071c40c in handle_one_connection (arg=0x7f187b79f060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#21 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#22 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#23 0x0000000000000000 in ?? ()
 
Thread 14 (Thread 0x7f187c7f6700 (LWP 6278)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff150, segment=3, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=9, message1=0x7f187c7f5e08, message2=0x7f187c7f5e10, type=0x7f187c7f5e18, space_id=0x7f187c7f5e20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=9) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82ba8 <n+72>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 13 (Thread 0x7f187effb700 (LWP 6273)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff100, segment=2, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=4, message1=0x7f187effae08, message2=0x7f187effae10, type=0x7f187effae18, space_id=0x7f187effae20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=4) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b80 <n+32>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 12 (Thread 0x7f189f82d700 (LWP 6304)):
#0  0x00007f189eb33d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf544f in safe_cond_wait (cond=0x7f1881c698b0, mp=0x7f1881c69800, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=207) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:493
#2  0x0000000000c411ca in os_cond_wait (cond=0x7f1881c698b0, mutex=0x7f1881c69800) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:207
#3  0x0000000000c419e1 in os_event_wait_low (event=0x7f1881c69800, reset_sig_count=5846) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:609
#4  0x0000000000b1a1b4 in sync_array_wait_event (arr=0x7f189d4eb2c0, index=0) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0arr.c:458
#5  0x0000000000b1cec4 in mutex_spin_wait (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=4598) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0sync.c:631
#6  0x0000000000ac41de in mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=4598) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:222
#7  0x0000000000ac42a4 in pfs_mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=4598) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:251
#8  0x0000000000acc661 in i_s_sys_columns_fill_table (thd=0x7f187b751060, tables=0x7f1875c24370, cond=0x7f1875c24b00) at /home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc:4598
#9  0x00000000006a35c4 in get_schema_tables_result (join=0x7f1875c254b8, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/elenst/bzr/5.5/sql/sql_show.cc:7766
#10 0x000000000064a1d5 in JOIN::exec (this=0x7f1875c254b8) at /home/elenst/bzr/5.5/sql/sql_select.cc:2357
#11 0x000000000064cc1b in mysql_select (thd=0x7f187b751060, rref_pointer_array=0x7f187b754cc8, tables=0x7f1875c24370, wild_num=1, fields=..., conds=0x7f1875c24b00, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f1875c25498, unit=0x7f187b754380, select_lex=0x7f187b754a58) at /home/elenst/bzr/5.5/sql/sql_select.cc:3090
#12 0x00000000006432e3 in handle_select (thd=0x7f187b751060, lex=0x7f187b7542d0, result=0x7f1875c25498, setup_tables_done_option=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:319
#13 0x000000000061b6b8 in execute_sqlcom_select (thd=0x7f187b751060, all_tables=0x7f1875c24370) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4688
#14 0x0000000000614275 in mysql_execute_command (thd=0x7f187b751060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2233
#15 0x000000000061de85 in mysql_parse (thd=0x7f187b751060, rawbuf=0x7f1875c24078 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_SYS_COLUMNS` AS table1 WHERE  table1 . `NAME` < 3   LIMIT 5", length=102, parser_state=0x7f189f82c620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#16 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b751060, packet=0x7f187b756061 " SELECT * FROM INFORMATION_SCHEMA . `INNODB_SYS_COLUMNS` AS table1 WHERE  table1 . `NAME` < 3   LIMIT 5", packet_length=103) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#17 0x0000000000610880 in do_command (thd=0x7f187b751060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#18 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b751060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#19 0x000000000071c40c in handle_one_connection (arg=0x7f187b751060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#20 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#21 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#22 0x0000000000000000 in ?? ()
 
Thread 11 (Thread 0x7f189df09700 (LWP 6308)):
#0  0x00007f189eb33d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf544f in safe_cond_wait (cond=0x7f1881c698b0, mp=0x7f1881c69800, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=207) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:493
#2  0x0000000000c411ca in os_cond_wait (cond=0x7f1881c698b0, mutex=0x7f1881c69800) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:207
#3  0x0000000000c419e1 in os_event_wait_low (event=0x7f1881c69800, reset_sig_count=5846) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:609
#4  0x0000000000b1a1b4 in sync_array_wait_event (arr=0x7f189d4eb2c0, index=1) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0arr.c:458
#5  0x0000000000b1cec4 in mutex_spin_wait (mutex=0x7f189d41f878, file_name=0xe7d020 "/home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc", line=10245) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0sync.c:631
#6  0x0000000000aa8584 in mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe7d020 "/home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc", line=10245) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:222
#7  0x0000000000aa864a in pfs_mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe7d020 "/home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc", line=10245) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:251
#8  0x0000000000aba215 in ha_innobase::get_foreign_key_list (this=0x7f1871a3d078, thd=0x7f187b765060, f_key_list=0x7f189df05d50) at /home/elenst/bzr/5.5/storage/xtradb/handler/ha_innodb.cc:10245
#9  0x000000000069d9e9 in get_schema_key_column_usage_record (thd=0x7f187b765060, tables=0x7f187104f140, table=0x7f187101d078, res=false, db_name=0x7f187466eb08, table_name=0x7f187104d570) at /home/elenst/bzr/5.5/sql/sql_show.cc:6245
#10 0x0000000000693a29 in fill_schema_table_by_open (thd=0x7f187b765060, is_show_fields_or_keys=false, table=0x7f187101d078, schema_table=0x140f8c0 <schema_tables+832>, orig_db_name=0x7f187466eb08, orig_table_name=0x7f187104d570, open_tables_state_backup=0x7f189df073c0, can_deadlock=true) at /home/elenst/bzr/5.5/sql/sql_show.cc:3931
#11 0x00000000006951a2 in get_all_tables (thd=0x7f187b765060, tables=0x7f1874425468, cond=0x7f187466daa8) at /home/elenst/bzr/5.5/sql/sql_show.cc:4565
#12 0x00000000006a35c4 in get_schema_tables_result (join=0x7f187446e910, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/elenst/bzr/5.5/sql/sql_show.cc:7766
#13 0x000000000064a1d5 in JOIN::exec (this=0x7f187446e910) at /home/elenst/bzr/5.5/sql/sql_select.cc:2357
#14 0x000000000064cc1b in mysql_select (thd=0x7f187b765060, rref_pointer_array=0x7f187b768cc8, tables=0x7f1874424de8, wild_num=1, fields=..., conds=0x7f187445ad88, og_num=0, order=0x0, group=0x0, having=0x7f187445b7c0, proc_param=0x0, select_options=2684619520, result=0x7f187446e8f0, unit=0x7f187b768380, select_lex=0x7f187b768a58) at /home/elenst/bzr/5.5/sql/sql_select.cc:3090
#15 0x00000000006432e3 in handle_select (thd=0x7f187b765060, lex=0x7f187b7682d0, result=0x7f187446e8f0, setup_tables_done_option=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:319
#16 0x000000000061b6b8 in execute_sqlcom_select (thd=0x7f187b765060, all_tables=0x7f1874424de8) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4688
#17 0x0000000000614275 in mysql_execute_command (thd=0x7f187b765060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2233
#18 0x000000000061de85 in mysql_parse (thd=0x7f187b765060, rawbuf=0x7f1874424078 "SELECT * FROM (test . `E` AS table1 INNER JOIN INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table2 ON ( table2 . `POSITION_IN_UNIQUE_CONSTRAINT` = table1 . `col_date_key` ) ) WHERE  ( (NOT ( ( ( ( ( (NO"..., length=681, parser_state=0x7f189df08620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#19 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b765060, packet=0x7f187b76a061 " SELECT * FROM (test . `E` AS table1 INNER JOIN INFORMATION_SCHEMA . `KEY_COLUMN_USAGE` AS table2 ON ( table2 . `POSITION_IN_UNIQUE_CONSTRAINT` = table1 . `col_date_key` ) ) WHERE  ( (NOT ( ( ( ( ( (N"..., packet_length=682) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#20 0x0000000000610880 in do_command (thd=0x7f187b765060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#21 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b765060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#22 0x000000000071c40c in handle_one_connection (arg=0x7f187b765060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#23 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#24 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#25 0x0000000000000000 in ?? ()
 
Thread 10 (Thread 0x7f189f908700 (LWP 6286)):
#0  0x00007f189eb379f7 in do_sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x00007f189eb37a79 in sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0
#2  0x0000000000563f9a in signal_hand (arg=0x0) at /home/elenst/bzr/5.5/sql/mysqld.cc:3058
#3  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#4  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#5  0x0000000000000000 in ?? ()
 
Thread 9 (Thread 0x7f189f9b5780 (LWP 6266)):
#0  0x00007f189e251303 in poll () from /lib/x86_64-linux-gnu/libc.so.6
#1  0x0000000000567fb3 in handle_connections_sockets () at /home/elenst/bzr/5.5/sql/mysqld.cc:5614
#2  0x00000000005672fe in mysqld_main (argc=17, argv=0x7f189d44d190) at /home/elenst/bzr/5.5/sql/mysqld.cc:5063
#3  0x000000000055f2d0 in main (argc=17, argv=0x7ffffa781d28) at /home/elenst/bzr/5.5/sql/main.cc:25
 
Thread 8 (Thread 0x7f189de77700 (LWP 6312)):
#0  0x00007f189eb33d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf544f in safe_cond_wait (cond=0x7f1881c698b0, mp=0x7f1881c69800, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=207) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:493
#2  0x0000000000c411ca in os_cond_wait (cond=0x7f1881c698b0, mutex=0x7f1881c69800) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:207
#3  0x0000000000c419e1 in os_event_wait_low (event=0x7f1881c69800, reset_sig_count=5846) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:609
#4  0x0000000000b1a1b4 in sync_array_wait_event (arr=0x7f189d4eb2c0, index=2) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0arr.c:458
#5  0x0000000000b1cec4 in mutex_spin_wait (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=3783) at /home/elenst/bzr/5.5/storage/xtradb/sync/sync0sync.c:631
#6  0x0000000000ac41de in mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=3783) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:222
#7  0x0000000000ac42a4 in pfs_mutex_enter_func (mutex=0x7f189d41f878, file_name=0xe86730 "/home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc", line=3783) at /home/elenst/bzr/5.5/storage/xtradb/include/sync0sync.ic:251
#8  0x0000000000acaf9a in i_s_sys_tables_fill_table (thd=0x7f187b7a9060, tables=0x7f18738245d0, cond=0x7f1873ae0588) at /home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc:3783
#9  0x00000000006a35c4 in get_schema_tables_result (join=0x7f1873adc760, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/elenst/bzr/5.5/sql/sql_show.cc:7766
#10 0x000000000064a1d5 in JOIN::exec (this=0x7f1873adc760) at /home/elenst/bzr/5.5/sql/sql_select.cc:2357
#11 0x000000000064cc1b in mysql_select (thd=0x7f187b7a9060, rref_pointer_array=0x7f187b7accc8, tables=0x7f18738245d0, wild_num=1, fields=..., conds=0x7f1873ae3d98, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f1873adc740, unit=0x7f187b7ac380, select_lex=0x7f187b7aca58) at /home/elenst/bzr/5.5/sql/sql_select.cc:3090
#12 0x00000000006432e3 in handle_select (thd=0x7f187b7a9060, lex=0x7f187b7ac2d0, result=0x7f1873adc740, setup_tables_done_option=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:319
#13 0x000000000061b6b8 in execute_sqlcom_select (thd=0x7f187b7a9060, all_tables=0x7f18738245d0) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4688
#14 0x0000000000614275 in mysql_execute_command (thd=0x7f187b7a9060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2233
#15 0x000000000061de85 in mysql_parse (thd=0x7f187b7a9060, rawbuf=0x7f1873824078 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_SYS_TABLES` AS table1 WHERE  ( ( ( (NOT (NOT (NOT ( table1 . `N_COLS` <> '2006-05-16 22:28:46.012403' OR table1 . `SPACE` > table1 . `TABLE_ID`) AND table1 ."..., length=405, parser_state=0x7f189de76620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#16 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b7a9060, packet=0x7f187b7ae061 " SELECT * FROM INFORMATION_SCHEMA . `INNODB_SYS_TABLES` AS table1 WHERE  ( ( ( (NOT (NOT (NOT ( table1 . `N_COLS` <> '2006-05-16 22:28:46.012403' OR table1 . `SPACE` > table1 . `TABLE_ID`) AND table1 "..., packet_length=409) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#17 0x0000000000610880 in do_command (thd=0x7f187b7a9060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#18 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b7a9060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#19 0x000000000071c40c in handle_one_connection (arg=0x7f187b7a9060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#20 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#21 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#22 0x0000000000000000 in ?? ()
 
Thread 7 (Thread 0x7f187f7fc700 (LWP 6272)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff100, segment=1, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=3, message1=0x7f187f7fbe08, message2=0x7f187f7fbe10, type=0x7f187f7fbe18, space_id=0x7f187f7fbe20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=3) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b78 <n+24>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 6 (Thread 0x7f18807fe700 (LWP 6270)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff0b0, segment=0, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=1, message1=0x7f18807fde08, message2=0x7f18807fde10, type=0x7f18807fde18, space_id=0x7f18807fde20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=1) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b68 <n+8>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 5 (Thread 0x7f189d3ff700 (LWP 6268)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x1d80680 <COND_checkpoint>, mp=0x1d805c0 <LOCK_checkpoint>, abstime=0x7f189d3fedb0, file=0xe69e50 "/home/elenst/bzr/5.5/storage/maria/ma_servicethread.c", line=119) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x00000000009bff14 in inline_mysql_cond_timedwait (that=0x1d80680 <COND_checkpoint>, mutex=0x1d805c0 <LOCK_checkpoint>, abstime=0x7f189d3fedb0, src_file=0xe69e50 "/home/elenst/bzr/5.5/storage/maria/ma_servicethread.c", src_line=119) at /home/elenst/bzr/5.5/include/mysql/psi/mysql_thread.h:1017
#3  0x00000000009c040c in my_service_thread_sleep (control=0x14206b0 <checkpoint_control>, sleep_time=30000000000) at /home/elenst/bzr/5.5/storage/maria/ma_servicethread.c:118
#4  0x00000000009b414a in ma_checkpoint_background (arg=0x1e) at /home/elenst/bzr/5.5/storage/maria/ma_checkpoint.c:705
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 4 (Thread 0x7f187fffd700 (LWP 6271)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff100, segment=0, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=2, message1=0x7f187fffce08, message2=0x7f187fffce10, type=0x7f187fffce18, space_id=0x7f187fffce20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=2) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b70 <n+16>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 3 (Thread 0x7f1880fff700 (LWP 6269)):
#0  0x00007f189f5a1644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x0000000000c3ea19 in os_aio_linux_collect (array=0x7f188b7ff060, segment=0, seg_size=2048) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4687
#2  0x0000000000c3ee11 in os_aio_linux_handle (global_seg=0, message1=0x7f1880ffee08, message2=0x7f1880ffee10, type=0x7f1880ffee18, space_id=0x7f1880ffee20) at /home/elenst/bzr/5.5/storage/xtradb/os/os0file.c:4833
#3  0x0000000000bdf63a in fil_aio_wait (segment=0) at /home/elenst/bzr/5.5/storage/xtradb/fil/fil0fil.c:5697
#4  0x0000000000b157e6 in io_handler_thread (arg=0x1d82b60 <n>) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0start.c:490
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 2 (Thread 0x7f1877bff700 (LWP 6284)):
#0  0x00007f189eb340fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000cf5749 in safe_cond_timedwait (cond=0x7f188b687eb0, mp=0x7f188b687e00, abstime=0x7f1877bfe650, file=0xed2800 "/home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c", line=171) at /home/elenst/bzr/5.5/mysys/thr_mutex.c:547
#2  0x0000000000c410cf in os_cond_wait_timed (cond=0x7f188b687eb0, mutex=0x7f188b687e00, abstime=0x7f1877bfe650) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:171
#3  0x0000000000c41ba0 in os_event_wait_time_low (event=0x7f188b687e00, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/bzr/5.5/storage/xtradb/os/os0sync.c:716
#4  0x0000000000b1251b in srv_master_thread (arg=0x0) at /home/elenst/bzr/5.5/storage/xtradb/srv/srv0srv.c:3509
#5  0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#6  0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x0000000000000000 in ?? ()
 
Thread 1 (Thread 0x7f189dde5700 (LWP 6316)):
#0  0x00007f189eb34f8c in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
#1  0x0000000000ced9a0 in my_write_core (sig=6) at /home/elenst/bzr/5.5/mysys/stacktrace.c:457
#2  0x00000000007d31af in handle_fatal_signal (sig=6) at /home/elenst/bzr/5.5/sql/signal_handler.cc:262
#3  <signal handler called>
#4  0x00007f189e19f425 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#5  0x00007f189e1a2b8b in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6  0x0000000000ac53e5 in page_get_data_size (page=0x7f188a6c8000 "") at /home/elenst/bzr/5.5/storage/xtradb/include/page0page.ic:934
#7  0x0000000000acf837 in i_s_innodb_buffer_pool_pages_index_fill (thd=0x7f187b36e060, tables=0x7f188b85a5c0, cond=0x7f188b85ae10) at /home/elenst/bzr/5.5/storage/xtradb/handler/i_s.cc:6592
#8  0x00000000006a35c4 in get_schema_tables_result (join=0x7f1871b94218, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/elenst/bzr/5.5/sql/sql_show.cc:7766
#9  0x000000000064a1d5 in JOIN::exec (this=0x7f1871b94218) at /home/elenst/bzr/5.5/sql/sql_select.cc:2357
#10 0x000000000064cc1b in mysql_select (thd=0x7f187b36e060, rref_pointer_array=0x7f187b371cc8, tables=0x7f188b85a5c0, wild_num=1, fields=..., conds=0x7f188b85ae10, og_num=7, order=0x7f188b85b8e0, group=0x0, having=0x7f188b85b688, proc_param=0x0, select_options=2684619520, result=0x7f1871b941f8, unit=0x7f187b371380, select_lex=0x7f187b371a58) at /home/elenst/bzr/5.5/sql/sql_select.cc:3090
#11 0x00000000006432e3 in handle_select (thd=0x7f187b36e060, lex=0x7f187b3712d0, result=0x7f1871b941f8, setup_tables_done_option=0) at /home/elenst/bzr/5.5/sql/sql_select.cc:319
#12 0x000000000061b6b8 in execute_sqlcom_select (thd=0x7f187b36e060, all_tables=0x7f188b85a5c0) at /home/elenst/bzr/5.5/sql/sql_parse.cc:4688
#13 0x0000000000614275 in mysql_execute_command (thd=0x7f187b36e060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:2233
#14 0x000000000061de85 in mysql_parse (thd=0x7f187b36e060, rawbuf=0x7f188b85a078 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_PAGES_INDEX` AS table1 WHERE  table1 . `lru_position` < table1 . `space_id`  HAVING  (table1 . `data_size` <> 2 IS NOT NULL AND table1 . `old` <="..., length=374, parser_state=0x7f189dde4620) at /home/elenst/bzr/5.5/sql/sql_parse.cc:5799
#15 0x000000000061172f in dispatch_command (command=COM_QUERY, thd=0x7f187b36e060, packet=0x7f187b386061 " SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_PAGES_INDEX` AS table1 WHERE  table1 . `lru_position` < table1 . `space_id`  HAVING  (table1 . `data_size` <> 2 IS NOT NULL AND table1 . `old` <"..., packet_length=375) at /home/elenst/bzr/5.5/sql/sql_parse.cc:1079
#16 0x0000000000610880 in do_command (thd=0x7f187b36e060) at /home/elenst/bzr/5.5/sql/sql_parse.cc:793
#17 0x000000000071c93a in do_handle_one_connection (thd_arg=0x7f187b36e060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1266
#18 0x000000000071c40c in handle_one_connection (arg=0x7f187b36e060) at /home/elenst/bzr/5.5/sql/sql_connect.cc:1181
#19 0x00007f189eb2fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#20 0x00007f189e25ccbd in clone () from /lib/x86_64-linux-gnu/libc.so.6
#21 0x0000000000000000 in ?? ()

Stack trace from:

revision-id: sergii@pisem.net-20140605172551-avr6i9us81bsin83
date: 2014-06-05 19:25:51 +0200
build-date: 2014-06-23 13:21:41 +0300
revno: 4214
branch-nick: 5.5

Comment by Daniel Black [ 2015-11-13 ]

looks so MDEV-344

Comment by Elena Stepanova [ 2018-07-10 ]

Same test on current 10.0 produced a different assertion failure:

10.0 a2c0376e08d

mysqld: /data/src/10.0/sql/handler.h:2664: int handler::ha_rnd_init(bool): Assertion `inited==NONE || (inited==RND && scan)' failed.
180710 17:17:31 [ERROR] mysqld got signal 6 ;
 
# 2018-07-10T17:17:40 [23616] #7  0x00007fac3d27aee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
# 2018-07-10T17:17:40 [23616] #8  0x00000000005e487e in handler::ha_rnd_init (this=0x7fac10526888, scan=false) at /data/src/10.0/sql/handler.h:2664
# 2018-07-10T17:17:40 [23616] #9  0x00000000008413ad in handler::ha_rnd_init_with_error (this=0x7fac10526888, scan=false) at /data/src/10.0/sql/handler.cc:2801
# 2018-07-10T17:17:40 [23616] #10 0x000000000094d35b in QUICK_ROR_INTERSECT_SELECT::init_ror_merged_scan (this=0x7fac10a4c080, reuse_handler=true, alloc=0x7fac10a4c0e0) at /data/src/10.0/sql/opt_range.cc:2221
# 2018-07-10T17:17:40 [23616] #11 0x000000000094d423 in QUICK_ROR_INTERSECT_SELECT::reset (this=0x7fac10a4c080) at /data/src/10.0/sql/opt_range.cc:2242
# 2018-07-10T17:17:40 [23616] #12 0x00000000006af9ea in join_init_read_record (tab=0x7fac10b878d8) at /data/src/10.0/sql/sql_select.cc:18880
# 2018-07-10T17:17:40 [23616] #13 0x00000000006af7f4 in join_init_quick_read_record (tab=0x7fac10b878d8) at /data/src/10.0/sql/sql_select.cc:18842
# 2018-07-10T17:17:40 [23616] #14 0x00000000006ad9cf in sub_select (join=0x7fac109d7390, join_tab=0x7fac10b878d8, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17981
# 2018-07-10T17:17:40 [23616] #15 0x00000000006ae134 in evaluate_join_record (join=0x7fac109d7390, join_tab=0x7fac10b875b0, error=0) at /data/src/10.0/sql/sql_select.cc:18204
# 2018-07-10T17:17:40 [23616] #16 0x00000000006adbc5 in sub_select (join=0x7fac109d7390, join_tab=0x7fac10b875b0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18023
# 2018-07-10T17:17:40 [23616] #17 0x00000000006ad2a4 in do_select (join=0x7fac109d7390, fields=0x7fac1afe3210, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17646
# 2018-07-10T17:17:40 [23616] #18 0x000000000068a01d in JOIN::exec_inner (this=0x7fac109d7390) at /data/src/10.0/sql/sql_select.cc:3116
# 2018-07-10T17:17:40 [23616] #19 0x00000000006874da in JOIN::exec (this=0x7fac109d7390) at /data/src/10.0/sql/sql_select.cc:2402
# 2018-07-10T17:17:40 [23616] #20 0x000000000068a87c in mysql_select (thd=0x7fac1afdf070, rref_pointer_array=0x7fac1afe33a0, tables=0x7fac10822c78, wild_num=1, fields=..., conds=0x7fac10a5ad30, og_num=0, order=0x0, group=0x0, having=0x7fac10a5ba00, proc_param=0x0, select_options=2684652288, result=0x7fac109d7370, unit=0x7fac1afe2a08, select_lex=0x7fac1afe30f8) at /data/src/10.0/sql/sql_select.cc:3341
# 2018-07-10T17:17:40 [23616] #21 0x0000000000680a86 in handle_select (thd=0x7fac1afdf070, lex=0x7fac1afe2940, result=0x7fac109d7370, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:377
# 2018-07-10T17:17:40 [23616] #22 0x0000000000654f79 in execute_sqlcom_select (thd=0x7fac1afdf070, all_tables=0x7fac10822c78) at /data/src/10.0/sql/sql_parse.cc:5298
# 2018-07-10T17:17:40 [23616] #23 0x000000000064d4cf in mysql_execute_command (thd=0x7fac1afdf070) at /data/src/10.0/sql/sql_parse.cc:2554
# 2018-07-10T17:17:40 [23616] #24 0x0000000000657dd6 in mysql_parse (thd=0x7fac1afdf070, rawbuf=0x7fac10822088 "SELECT * FROM (INFORMATION_SCHEMA.`XTRADB_RSEG` AS table1 INNER JOIN test.`E` AS table2 ON ( table2.`col_int_key` = table1.`rseg_id` ) ) WHERE ( ( (NOT table1.`zip_size` = table2.`col_int_key` AND table2.`col_datetime_key` <> table1.`rseg_id`) AND table1.`curr_size` <= table2.`pk`) AND table2.`col_datetime_key` <= table2.`col_varchar_nokey`) HAVING table2.`col_int_key` > '1983-01-17 09:55:20.012156' IS NULL LIMIT 1 /* QNO 13038 CON_ID 11 */", length=444, parser_state=0x7fac3f29a690) at /data/src/10.0/sql/sql_parse.cc:6634
# 2018-07-10T17:17:40 [23616] #25 0x000000000064a6f6 in dispatch_command (command=COM_QUERY, thd=0x7fac1afdf070, packet=0x7fac1afe5071 "", packet_length=446) at /data/src/10.0/sql/sql_parse.cc:1297
# 2018-07-10T17:17:40 [23616] #26 0x00000000006499f6 in do_command (thd=0x7fac1afdf070) at /data/src/10.0/sql/sql_parse.cc:1000
# 2018-07-10T17:17:40 [23616] #27 0x000000000076a872 in do_handle_one_connection (thd_arg=0x7fac1afdf070) at /data/src/10.0/sql/sql_connect.cc:1377
# 2018-07-10T17:17:40 [23616] #28 0x000000000076a5e4 in handle_one_connection (arg=0x7fac1afdf070) at /data/src/10.0/sql/sql_connect.cc:1292
# 2018-07-10T17:17:40 [23616] #29 0x00007fac3ef7e494 in start_thread (arg=0x7fac3f29b700) at pthread_create.c:333
# 2018-07-10T17:17:40 [23616] #30 0x00007fac3d33793f in clone () from /lib/x86_64-linux-gnu/libc.so.6

This one is probably MDEV-6453.


Current 5.5 still deadlocks: threads_5.5_90cb72127

Comment by Elena Stepanova [ 2019-01-27 ]

Observed again on 5.5: http://buildbot.askmonty.org/buildbot/builders/qa-win-debug/builds/2347/steps/crash_tests/logs/stdio

5.5 2175bfce3e9da8332f10ab0e0286dc93915533a2

190127 20:35:16  InnoDB: Assertion failure in thread 4636 in file page0page.ic line 933
InnoDB: Failing assertion: ret < srv_page_size
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
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.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
abort() has been called190127 23:35:16 [ERROR] mysqld got exception 0x80000003 ;
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 http://kb.askmonty.org/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: 5.5.63-MariaDB-debug
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=7
max_threads=501
thread_count=6
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 195830 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0xd2d3989dd0
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...
mysqld.exe!my_sigabrt_handler()[my_thr_init.c:516]
mysqld.exe!raise()[signal.cpp:522]
mysqld.exe!abort()[abort.cpp:71]
mysqld.exe!page_get_data_size()[page0page.ic:933]
mysqld.exe!i_s_innodb_buffer_pool_pages_index_fill()[i_s.cc:6609]

Loading Dump File [E:\buildbot\vardirs\qa-win-debug\5.5-2347\optim-crash-tests\current1_1\master-data\mysqld.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available
 
 
************* Symbol Path validation summary **************
Response                         Time (ms)     Location
OK                                             D:\qa-win-debug\install\bin
 
************* Symbol Path validation summary **************
Response                         Time (ms)     Location
OK                                             D:\qa-win-debug\install\bin
Deferred                                       srv*C:\cdb_symbols*http://msdl.microsoft.com/download/symbols
Symbol search path is: D:\qa-win-debug\install\bin;srv*C:\cdb_symbols*http://msdl.microsoft.com/download/symbols
Executable search path is: D:\qa-win-debug\install\bin
Windows 8.1 Version 9600 MP (4 procs) Free x64
Product: Server, suite: TerminalServer DataCenter SingleUserTS
Built by: 6.3.9600.17031 (winblue_gdr.140221-1952)
Machine Name:
Debug session time: Sun Jan 27 20:35:18.000 2019 (UTC + 0:00)
System Uptime: not available
Process Uptime: 0 days 0:01:43.000
.............................
This dump file has a breakpoint exception stored in it.
The stored exception information can be accessed via .ecxr.
*** ERROR: Symbol file could not be found.  Defaulted to export symbols for ntdll.dll - 
ntdll!NtGetContextThread+0xa:
00007ffa`28cf156a c3              ret
0:023> cdb: Reading initial command '!sym prompts off; !analyze -v; .ecxr; !for_each_frame dv /t;~*k;q'
quiet mode - symbol prompts off
*******************************************************************************
*                                                                             *
*                        Exception Analysis                                   *
*                                                                             *
*******************************************************************************
 
*************************************************************************
***                                                                   ***
***                                                                   ***
***    Either you specified an unqualified symbol, or your debugger   ***
***    doesn't have full symbol information.  Unqualified symbol      ***
***    resolution is turned off by default. Please either specify a   ***
***    fully qualified symbol module!symbolname, or enable resolution ***
***    of unqualified symbols by typing ".symopt- 100". Note that   ***
***    enabling unqualified symbol resolution with network symbol     ***
***    server shares in the symbol path may cause the debugger to     ***
***    appear to hang for long periods of time when an incorrect      ***
***    symbol name is typed or the network symbol server is down.     ***
***                                                                   ***
***    For some commands to work properly, your symbol path           ***
***    must point to .pdb files that have full type information.      ***
***                                                                   ***
***    Certain .pdb files (such as the public OS symbols) do not      ***
***    contain the required information.  Contact the group that      ***
***    provided you with these symbols if you need this command to    ***
***    work.                                                          ***
***                                                                   ***
***    Type referenced: $ntdllsym!_CONTEXT                            ***
***                                                                   ***
*************************************************************************
***** OS symbols are WRONG. Please fix symbols to do analysis.
 
*************************************************************************
***                                                                   ***
***                                                                   ***
***    Either you specified an unqualified symbol, or your debugger   ***
***    doesn't have full symbol information.  Unqualified symbol      ***
***    resolution is turned off by default. Please either specify a   ***
***    fully qualified symbol module!symbolname, or enable resolution ***
***    of unqualified symbols by typing ".symopt- 100". Note that   ***
***    enabling unqualified symbol resolution with network symbol     ***
***    server shares in the symbol path may cause the debugger to     ***
***    appear to hang for long periods of time when an incorrect      ***
***    symbol name is typed or the network symbol server is down.     ***
***                                                                   ***
***    For some commands to work properly, your symbol path           ***
***    must point to .pdb files that have full type information.      ***
***                                                                   ***
***    Certain .pdb files (such as the public OS symbols) do not      ***
***    contain the required information.  Contact the group that      ***
***    provided you with these symbols if you need this command to    ***
***    work.                                                          ***
***                                                                   ***
***    Type referenced: nt!_CONTEXT                                   ***
***                                                                   ***
*************************************************************************
*** ERROR: Symbol file could not be found.  Defaulted to export symbols for KERNELBASE.dll - 
 
DUMP_CLASS: 2
 
DUMP_QUALIFIER: 400
 
CONTEXT:  (.ecxr)
rax=00007ff6e80d16d0 rbx=00007ff6e7a472d0 rcx=0000000000000016
rdx=000000000000002d rsi=000000d2d4b8f710 rdi=000000d2d4b8c430
rip=00007ff6e80d16d5 rsp=000000d2d4b8c2d0 rbp=000000d2d37dafa0
 r8=000000d2d4b8c390  r9=000000d2d4b8c344 r10=0000000000000000
r11=0000000000000246 r12=000000007ffe0008 r13=000000d2d3802880
r14=000000d2d378d590 r15=000000d2d4b8f618
iopl=0         nv up ei pl nz ac pe nc
cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000212
mysqld!my_sigabrt_handler+0x5:
00007ff6`e80d16d5 cc              int     3
Resetting default scope
 
FAULTING_IP: 
mysqld!my_sigabrt_handler+5 [d:\qa-win-debug\build\mysys\my_thr_init.c @ 516]
00007ff6`e80d16d5 cc              int     3
 
EXCEPTION_RECORD:  (.exr -1)
ExceptionAddress: 00007ff6e80d16d5 (mysqld!my_sigabrt_handler+0x0000000000000005)
   ExceptionCode: 80000003 (Break instruction exception)
  ExceptionFlags: 00000000
NumberParameters: 1
   Parameter[0]: 0000000000000000
 
BUGCHECK_STR:  5B93FFA7
 
WRONG_SYMBOLS_TIMESTAMP: 5b93ffa7
 
WRONG_SYMBOLS_SIZE: 1ad000
 
FAULTING_MODULE: 00007ffa28c60000 ntdll
 
DEBUG_FLR_IMAGE_TIMESTAMP:  5b93ffa7
 
ADDITIONAL_DEBUG_TEXT:  
You can run '.symfix; .reload' to try to fix the symbol path and load symbols. ; Followup set based on attribute [Is_ChosenCrashFollowupThread] from Frame:[0] on thread:[PSEUDO_THREAD]
 
LAST_CONTROL_TRANSFER:  from 0000000000000000 to 0000000000000000
 
ANALYSIS_SESSION_HOST:  MARIADB-04
 
ANALYSIS_SESSION_TIME:  01-27-2019 20:35:26.0993
 
ANALYSIS_VERSION: 10.0.14321.1024 amd64fre
 
STACK_TEXT:  
00000000`00000000 00000000`00000000 WRONG_SYMBOLS!WRONG_SYMBOLS+0x0
 
 
STACK_COMMAND:  .ecxr ; kb ; ** Pseudo Context ** ; kb
 
THREAD_SHA1_HASH_MOD_FUNC:  2a06fe893fc51638e55bcc8ee02bcdf6f10cbc26
 
THREAD_SHA1_HASH_MOD_FUNC_OFFSET:  214d5e958d92c59434e5414a89d1e95c2f82d12a
 
THREAD_SHA1_HASH_MOD:  79d1e41e8e0e291e73ec18352c568efa4ef4b5ab
 
SYMBOL_STACK_INDEX:  0
 
FOLLOWUP_NAME:  MachineOwner
 
EXCEPTION_CODE: (NTSTATUS) 0x5b93ffa7 - <Unable to get error code text>
 
EXCEPTION_CODE_STR:  5B93FFA7
 
EXCEPTION_STR:  PRIVATE_SYMBOLS
 
PROCESS_NAME:  ntdll.wrong.symbols.dll
 
IMAGE_NAME:  ntdll.wrong.symbols.dll
 
MODULE_NAME: ntdll_wrong_symbols
 
SYMBOL_NAME:  ntdll_wrong_symbols!5B93FFA71AD000
 
BUCKET_ID:  PRIVATE_SYMBOLS_X64_6.3.9600.17415_(winblue_r4.141028-1500)_TIMESTAMP_180908-165815
 
DEFAULT_BUCKET_ID:  PRIVATE_SYMBOLS_X64_6.3.9600.17415_(winblue_r4.141028-1500)_TIMESTAMP_180908-165815
 
PRIMARY_PROBLEM_CLASS:  PRIVATE_SYMBOLS
 
FAILURE_EXCEPTION_CODE:  5B93FFA7
 
FAILURE_IMAGE_NAME:  ntdll.wrong.symbols.dll
 
BUCKET_ID_IMAGE_STR:  ntdll.wrong.symbols.dll
 
FAILURE_MODULE_NAME:  ntdll_wrong_symbols
 
BUCKET_ID_MODULE_STR:  ntdll_wrong_symbols
 
FAILURE_FUNCTION_NAME:  5B93FFA71AD000
 
BUCKET_ID_FUNCTION_STR:  5B93FFA71AD000
 
BUCKET_ID_OFFSET:  0
 
BUCKET_ID_MODTIMEDATESTAMP:  0
 
BUCKET_ID_MODCHECKSUM:  0
 
BUCKET_ID_MODVER_STR:  0.0.0.0
 
BUCKET_ID_PREFIX_STR:  PRIVATE_SYMBOLS_X64_6.3.9600.17415_(winblue_r4.141028-1500)_TIMESTAMP_180908-165815
 
FAILURE_PROBLEM_CLASS:  PRIVATE_SYMBOLS_X64_6.3.9600.17415_(winblue_r4.141028-1500)_TIMESTAMP_180908-165815
 
FAILURE_SYMBOL_NAME:  ntdll.wrong.symbols.dll!5B93FFA71AD000
 
FAILURE_BUCKET_ID:  PRIVATE_SYMBOLS_X64_6.3.9600.17415_(winblue_r4.141028-1500)_TIMESTAMP_180908-165815_5B93FFA7_ntdll.wrong.symbols.dll!5B93FFA71AD000
 
TARGET_TIME:  2019-01-27T20:35:18.000Z
 
OSBUILD:  9600
 
OSSERVICEPACK:  17415
 
SERVICEPACK_NUMBER: 0
 
OS_REVISION: 0
 
SUITE_MASK:  400
 
PRODUCT_TYPE:  3
 
OSPLATFORM_TYPE:  x64
 
OSNAME:  Windows 8.1
 
OSEDITION:  Windows 8.1 Server TerminalServer DataCenter SingleUserTS
 
OS_LOCALE:  
 
USER_LCID:  0
 
OSBUILD_TIMESTAMP:  2014-10-29 02:45:30
 
BUILDDATESTAMP_STR:  141028-1500
 
BUILDLAB_STR:  winblue_r4
 
BUILDOSVER_STR:  6.3.9600.17415
 
ANALYSIS_SESSION_ELAPSED_TIME: 80a
 
ANALYSIS_SOURCE:  UM
 
FAILURE_ID_HASH_STRING:  um:private_symbols_x64_6.3.9600.17415_(winblue_r4.141028-1500)_timestamp_180908-165815_5b93ffa7_ntdll.wrong.symbols.dll!5b93ffa71ad000
 
FAILURE_ID_HASH:  {29596085-c49d-aa56-55ce-47798e7b67d2}
 
Followup:     MachineOwner
---------
 
rax=00007ff6e80d16d0 rbx=00007ff6e7a472d0 rcx=0000000000000016
rdx=000000000000002d rsi=000000d2d4b8f710 rdi=000000d2d4b8c430
rip=00007ff6e80d16d5 rsp=000000d2d4b8c2d0 rbp=000000d2d37dafa0
 r8=000000d2d4b8c390  r9=000000d2d4b8c344 r10=0000000000000000
r11=0000000000000246 r12=000000007ffe0008 r13=000000d2d3802880
r14=000000d2d378d590 r15=000000d2d4b8f618
iopl=0         nv up ei pl nz ac pe nc
cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00000212
mysqld!my_sigabrt_handler+0x5:
00007ff6`e80d16d5 cc              int     3
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
00 000000d2`d4b8c2d0 00007ff6`e81d8718 mysqld!my_sigabrt_handler+0x5 [d:\qa-win-debug\build\mysys\my_thr_init.c @ 516]
int sig = 0n22
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
01 000000d2`d4b8c2e0 00007ff6`e81fa649 mysqld!raise+0x468 [d:\th\minkernel\crts\ucrt\src\appcrt\misc\signal.cpp @ 522]
int signum = 0n22
int old_fpecode = 0n0
struct _EXCEPTION_POINTERS * old_pxcptinfoptrs = 0x00000000`00000000
bool return0 = false
bool action_is_global = true
<function> * action = 0x00007ff6`e80d16d0
struct __acrt_ptd * ptd = 0x00000000`00000000
<function> ** action_pointer = 0x00007ff6`e92e6f68
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
02 000000d2`d4b8c3b0 00007ff6`e7f762b1 mysqld!abort+0x39 [d:\th\minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 71]
<function> * sigabrt_action = 0x00007ff6`e80d16d0
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
03 000000d2`d4b8c3f0 00007ff6`e7fc8d14 mysqld!page_get_data_size+0xd1 [d:\qa-win-debug\build\storage\xtradb\include\page0page.ic @ 933]
unsigned char * page = 0x000000d2`cff68000 "--- memory read error at address 0x000000d2`cff68000 ---"
unsigned int64 ret = 0xffffffff`ffffff83
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
04 000000d2`d4b8c440 00007ff6`e79be92a mysqld!i_s_innodb_buffer_pool_pages_index_fill+0x374 [d:\qa-win-debug\build\storage\xtradb\handler\i_s.cc @ 6609]
unsigned char * frame = 0x000000d2`cff68000 "--- memory read error at address 0x000000d2`cff68000 ---"
struct buf_block_struct * block = 0x000000d2`c98ba960
unsigned int64 n_block = 0x1972
struct buf_pool_struct * buf_pool = 0x000000d2`beef71d8
class THD * thd = 0x000000d2`d3989dd0
struct TABLE_LIST * tables = 0x000000d2`d3907340
class Item * cond = 0x00000000`00000000
struct TABLE * table = 0x000000d2`d3df95b8
unsigned int64 i = 0
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
unsigned int64 index_id = 0
int status = 0n0
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
05 000000d2`d4b8c5a0 00007ff6`e7aaf97c mysqld!get_schema_tables_result+0x40a [d:\qa-win-debug\build\sql\sql_show.cc @ 7798]
bool is_subselect = false
struct TABLE_LIST * table_list = 0x000000d2`d3907340
class JOIN * join = 0x000000d2`d3dc2aa0
enum_schema_table_state executed_place = PROCESSED_BY_JOIN_EXEC (0n2)
char * old_proc_info = 0x00007ff6`e83911b8 "executing"
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
class Warnings_only_error_handler err_handler = class Warnings_only_error_handler
struct st_join_table * tab = 0x000000d2`d3dd3e38
class THD * thd = 0x000000d2`d3989dd0
struct LEX * lex = 0x000000d2`d398c720
bool result = false
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
06 000000d2`d4b8c6b0 00007ff6`e7ab9107 mysqld!JOIN::exec+0x9cc [d:\qa-win-debug\build\sql\sql_select.cc @ 2395]
class JOIN * this = 0x000000d2`d3dc2aa0
class List<Item> * columns_list = 0x000000d2`d398cfa8
struct TABLE * curr_tmp_table = 0xcccccccc`cccccccc
class List<Item> * curr_all_fields = 0xcccccccc`cccccccc
class List<Item> * curr_fields_list = 0xcccccccc`cccccccc
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
int tmp_error = 0n-858993460
class JOIN * curr_join = 0xcccccccc`cccccccc
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
07 000000d2`d4b8c910 00007ff6`e7ab8a4f mysqld!mysql_select+0x517 [d:\qa-win-debug\build\sql\sql_select.cc @ 3135]
class THD * thd = 0x000000d2`d3989dd0
class Item *** rref_pointer_array = 0x000000d2`d398d130
struct TABLE_LIST * tables = 0x000000d2`d3906ca0
unsigned int wild_num = 1
class List<Item> * fields = 0x000000d2`d398cfa8
class Item * conds = 0x00000000`00000000
unsigned int og_num = 1
struct st_order * order = 0x000000d2`d3907ed8
struct st_order * group = 0x00000000`00000000
class Item * having = 0x00000000`00000000
struct st_order * proc_param = 0x00000000`00000000
unsigned int64 select_options = 0xa0048b00
class select_result * result = 0x000000d2`d3dc2a80
class st_select_lex_unit * unit = 0x000000d2`d398c7c8
class st_select_lex * select_lex = 0x000000d2`d398ce90
bool err = false
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
bool free_join = true
class JOIN * join = 0x000000d2`d3dc2aa0
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
08 000000d2`d4b8ca20 00007ff6`e79b181e mysqld!handle_select+0x25f [d:\qa-win-debug\build\sql\sql_select.cc @ 311]
class st_select_lex_unit * unit = 0x000000d2`d398c7c8
class THD * thd = 0x000000d2`d3989dd0
struct LEX * lex = 0x000000d2`d398c720
class select_result * result = 0x000000d2`d3dc2a80
unsigned long setup_tables_done_option = 0
bool res = true
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
class st_select_lex * select_lex = 0x000000d2`d398ce90
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
09 000000d2`d4b8cb20 00007ff6`e79a3f4f mysqld!execute_sqlcom_select+0x38e [d:\qa-win-debug\build\sql\sql_parse.cc @ 4679]
class THD * thd = 0x000000d2`d3989dd0
struct TABLE_LIST * all_tables = 0x000000d2`d3906ca0
bool res = false
struct LEX * lex = 0x000000d2`d398c720
class select_result * result = 0x000000d2`d3dc2a80
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0a 000000d2`d4b8d040 00007ff6`e79a2e75 mysqld!mysql_execute_command+0x95f [d:\qa-win-debug\build\sql\sql_parse.cc @ 2225]
unsigned long privileges_requested = 1
class THD * thd = 0x000000d2`d3989dd0
struct TABLE_LIST * all_tables = 0x000000d2`d3906ca0
class st_select_lex_unit * unit = 0x000000d2`d398c7c8
bool have_table_map_for_update = false
int up_result = 0n0
int res = 0n0
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
struct LEX * lex = 0x000000d2`d398c720
class st_select_lex * select_lex = 0x000000d2`d398ce90
struct TABLE_LIST * first_table = 0x000000d2`d3906ca0
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0b 000000d2`d4b8e210 00007ff6`e79ac4b7 mysqld!mysql_parse+0x265 [d:\qa-win-debug\build\sql\sql_parse.cc @ 5924]
char * found_semicolon = 0x00000000`00000000 ""
bool err = false
struct LEX * lex = 0x000000d2`d398c720
class THD * thd = 0x000000d2`d3989dd0
char * rawbuf = 0x000000d2`d39061a8 "--- memory read error at address 0x000000d2`d39061a8 ---"
unsigned int length = 0x141
class Parser_state * parser_state = 0x000000d2`d4b8e7f0
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
int error = 0n-858993460
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0c 000000d2`d4b8e2c0 00007ff6`e79ab617 mysqld!dispatch_command+0xd27 [d:\qa-win-debug\build\sql\sql_parse.cc @ 1069]
char * packet_end = 0x000000d2`d39062e9 "--- memory read error at address 0x000000d2`d39062e9 ---"
class Parser_state parser_state = class Parser_state
enum_server_command command = COM_QUERY (0n3)
class THD * thd = 0x000000d2`d3989dd0
char * packet = 0x000000d2`d398ddd1 "--- memory read error at address 0x000000d2`d398ddd1 ---"
unsigned int packet_length = 0x143
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
bool error = false
struct st_net * net = 0x000000d2`d398a038
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0d 000000d2`d4b8f250 00007ff6`e78b984c mysqld!do_command+0x327 [d:\qa-win-debug\build\sql\sql_parse.cc @ 793]
class THD * thd = 0x000000d2`d3989dd0
bool return_value = true
unsigned long packet_length = 0x144
struct _db_stack_frame_ _db_stack_frame_ = struct _db_stack_frame_
enum_server_command command = COM_QUERY (0n3)
char * packet = 0x000000d2`d398ddd0 "--- memory read error at address 0x000000d2`d398ddd0 ---"
struct st_net * net = 0x000000d2`d398a038
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0e 000000d2`d4b8f300 00007ff6`e7a47365 mysqld!threadpool_process_request+0x7c [d:\qa-win-debug\build\sql\threadpool_common.cc @ 233]
struct st_vio * vio = 0xcccccccc`cccccccc
class THD * thd = 0x000000d2`d3989dd0
int retval = 0n0
struct Worker_thread_context worker_context = struct Worker_thread_context
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0f 000000d2`d4b8f370 00007ffa`28901d5d mysqld!io_completion_callback+0x95 [d:\qa-win-debug\build\sql\threadpool_win.cc @ 568]
struct _TP_CALLBACK_INSTANCE * instance = 0x000000d2`d4b8f618
void * context = 0x000000d2`d37daf90
void * overlapped = 0x000000d2`d37dafa0
unsigned long io_result = 0
unsigned int64 nbytes = 0
struct _TP_IO * io = 0x000000d2`d38027d0
struct connection_t * connection = 0x000000d2`d37daf90
class THD * thd = 0x000000d2`d3989dd0
unsigned int64 old_timeout = 0x01d4b6c2`de263d93
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
10 000000d2`d4b8f3c0 00007ffa`28c7c6f2 kernel32!BasepTpIoCallback+0x59
Unable to enumerate locals, HRESULT 0x80004005
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
11 000000d2`d4b8f410 00007ffa`28c992c4 ntdll!RtlGetActiveActivationContext+0x252
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
12 000000d2`d4b8f4a0 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1c24
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
13 000000d2`d4b8f880 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
Unable to enumerate locals, HRESULT 0x80004005
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
14 000000d2`d4b8f8b0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
Unable to enumerate locals, Win32 error 0n318
Private symbols (symbols.pri) are required for locals.
Type ".hh dbgerr005" for details.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
00 000000d2`d4b8c2d0 00007ff6`e81d8718 mysqld!my_sigabrt_handler+0x5 [d:\qa-win-debug\build\mysys\my_thr_init.c @ 516]
 
   0  Id: 1b4c.1b7c Suspend: 0 Teb: 00007ff6`e735d000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`a82df728 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`a82df730 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`a82df7a0 00007ff6`e80cf2d7 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`a82df7d0 00007ff6`e80cf265 mysqld!pthread_cond_timedwait+0x57 [d:\qa-win-debug\build\mysys\my_wincond.c @ 298]
000000d2`a82df810 00007ff6`e783177d mysqld!pthread_cond_wait+0x35 [d:\qa-win-debug\build\mysys\my_wincond.c @ 310]
000000d2`a82df840 00007ff6`e783c66d mysqld!inline_mysql_cond_wait+0x10d [d:\qa-win-debug\build\include\mysql\psi\mysql_thread.h @ 986]
000000d2`a82df8f0 00007ff6`e783d3ae mysqld!handle_connections_methods+0x22d [d:\qa-win-debug\build\sql\mysqld.cc @ 4572]
000000d2`a82df990 00007ff6`e783d522 mysqld!win_main+0x78e [d:\qa-win-debug\build\sql\mysqld.cc @ 5027]
000000d2`a82dfa40 00007ff6`e783de21 mysqld!mysql_service+0x62 [d:\qa-win-debug\build\sql\mysqld.cc @ 5091]
000000d2`a82dfa70 00007ff6`e782f9cf mysqld!mysqld_main+0x551 [d:\qa-win-debug\build\sql\mysqld.cc @ 5284]
000000d2`a82dfd10 00007ff6`e81872d4 mysqld!main+0x2f [d:\qa-win-debug\build\sql\main.cc @ 26]
000000d2`a82dfd40 00007ff6`e81871e7 mysqld!invoke_main+0x34 [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 65]
000000d2`a82dfd80 00007ff6`e81870ae mysqld!__scrt_common_main_seh+0x127 [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 253]
000000d2`a82dfde0 00007ff6`e81872e9 mysqld!__scrt_common_main+0xe [f:\dd\vctools\crt\vcstartup\src\startup\exe_common.inl @ 296]
000000d2`a82dfe10 00007ffa`289013d2 mysqld!mainCRTStartup+0x9 [f:\dd\vctools\crt\vcstartup\src\startup\exe_main.cpp @ 17]
000000d2`a82dfe40 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`a82dfe70 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   1  Id: 1b4c.1ac0 Suspend: 0 Teb: 00007ff6`e735b000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`c882f7a8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`c882f7b0 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`c882f820 00007ff6`e80cf2d7 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`c882f850 00007ff6`e7da0a2c mysqld!pthread_cond_timedwait+0x57 [d:\qa-win-debug\build\mysys\my_wincond.c @ 298]
000000d2`c882f890 00007ff6`e7da0fed mysqld!inline_mysql_cond_timedwait+0x11c [d:\qa-win-debug\build\include\mysql\psi\mysql_thread.h @ 1020]
000000d2`c882f940 00007ff6`e7d150c6 mysqld!my_service_thread_sleep+0x1ad [d:\qa-win-debug\build\storage\maria\ma_servicethread.c @ 119]
000000d2`c882fa10 00007ff6`e7e8cc21 mysqld!ma_checkpoint_background+0x396 [d:\qa-win-debug\build\storage\maria\ma_checkpoint.c @ 704]
000000d2`c882faf0 00007ff6`e80cf1b6 mysqld!pfs_spawn_thread+0xc1 [d:\qa-win-debug\build\storage\perfschema\pfs.cc @ 1017]
000000d2`c882fb50 00007ff6`e819b46c mysqld!pthread_start+0x56 [d:\qa-win-debug\build\mysys\my_winthread.c @ 61]
000000d2`c882fba0 00007ff6`e819b013 mysqld!invoke_thread_procedure+0x2c [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 92]
000000d2`c882fbe0 00007ffa`289013d2 mysqld!thread_start<unsigned int (__cdecl*)(void * __ptr64)>+0x93 [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115]
000000d2`c882fc30 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`c882fc60 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   2  Id: 1b4c.1274 Suspend: 0 Teb: 00007ff6`e7359000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`c892f5e8 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`c892f5f0 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`c892f650 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`c892f740 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`c892f810 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`c892f850 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`c892f880 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   3  Id: 1b4c.1664 Suspend: 0 Teb: 00007ff6`e7357000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d24df988 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d24df990 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d24df9f0 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d24dfae0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d24dfbb0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d24dfbf0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d24dfc20 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   4  Id: 1b4c.14b8 Suspend: 0 Teb: 00007ff6`e7355000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d25dfa08 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d25dfa10 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d25dfa70 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d25dfb60 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d25dfc30 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d25dfc70 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d25dfca0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   5  Id: 1b4c.ee8 Suspend: 0 Teb: 00007ff6`e7353000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d26dfc98 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d26dfca0 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d26dfd00 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d26dfdf0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d26dfec0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d26dff00 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d26dff30 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   6  Id: 1b4c.1914 Suspend: 0 Teb: 00007ff6`e722e000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d27df788 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d27df790 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d27df7f0 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d27df8e0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d27df9b0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d27df9f0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d27dfa20 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   7  Id: 1b4c.1004 Suspend: 0 Teb: 00007ff6`e722c000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d28df578 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d28df580 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d28df5e0 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d28df6d0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d28df7a0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d28df7e0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d28df810 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   8  Id: 1b4c.470 Suspend: 0 Teb: 00007ff6`e722a000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d29df518 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d29df520 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d29df580 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d29df670 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d29df740 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d29df780 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d29df7b0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
   9  Id: 1b4c.82c Suspend: 0 Teb: 00007ff6`e7228000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2adfa88 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d2adfa90 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d2adfaf0 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d2adfbe0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d2adfcb0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d2adfcf0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2adfd20 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  10  Id: 1b4c.1bf0 Suspend: 0 Teb: 00007ff6`e7226000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2bdfc28 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d2bdfc30 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d2bdfc90 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d2bdfd80 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d2bdfe50 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d2bdfe90 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2bdfec0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  11  Id: 1b4c.388 Suspend: 0 Teb: 00007ff6`e7224000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2cdf778 00007ffa`261d26b3 ntdll!ZwRemoveIoCompletion+0xa
000000d2`d2cdf780 00007ff6`e7f5fa8c KERNELBASE!GetQueuedCompletionStatus+0x43
000000d2`d2cdf7e0 00007ff6`e7ef3a47 mysqld!os_aio_windows_handle+0xbc [d:\qa-win-debug\build\storage\xtradb\os\os0file.c @ 4534]
000000d2`d2cdf8d0 00007ff6`e7f4f405 mysqld!fil_aio_wait+0xb7 [d:\qa-win-debug\build\storage\xtradb\fil\fil0fil.c @ 5713]
000000d2`d2cdf9a0 00007ffa`289013d2 mysqld!io_handler_thread+0x85 [d:\qa-win-debug\build\storage\xtradb\srv\srv0start.c @ 498]
000000d2`d2cdf9e0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2cdfa10 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  12  Id: 1b4c.1a4c Suspend: 0 Teb: 00007ff6`e7222000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2ddf6c8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d2ddf6d0 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d2ddf740 00007ff6`e7fcc8c6 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d2ddf770 00007ff6`e7fcbb3f mysqld!os_cond_wait_timed+0x96 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 150]
000000d2`d2ddf7b0 00007ff6`e7f21e4c mysqld!os_event_wait_time_low+0x1ff [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 698]
000000d2`d2ddf800 00007ffa`289013d2 mysqld!srv_lock_timeout_thread+0x8c [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 2835]
000000d2`d2ddf870 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2ddf8a0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  13  Id: 1b4c.1528 Suspend: 0 Teb: 00007ff6`e7220000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2edfcc8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d2edfcd0 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d2edfd40 00007ff6`e7fcc8c6 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d2edfd70 00007ff6`e7fcbb3f mysqld!os_cond_wait_timed+0x96 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 150]
000000d2`d2edfdb0 00007ff6`e7f227e7 mysqld!os_event_wait_time_low+0x1ff [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 698]
000000d2`d2edfe00 00007ffa`289013d2 mysqld!srv_error_monitor_thread+0x3f7 [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 3049]
000000d2`d2edfed0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2edff00 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  14  Id: 1b4c.14b4 Suspend: 0 Teb: 00007ff6`e721e000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d2fdf568 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d2fdf570 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d2fdf5e0 00007ff6`e7fcca48 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d2fdf610 00007ff6`e7fcb912 mysqld!os_cond_wait+0x108 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 205]
000000d2`d2fdf650 00007ff6`e7f341e6 mysqld!os_event_wait_low+0x142 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 596]
000000d2`d2fdf690 00007ff6`e7f28d0e mysqld!sync_array_wait_event+0x1a6 [d:\qa-win-debug\build\storage\xtradb\sync\sync0arr.c @ 461]
000000d2`d2fdf6e0 00007ff6`e7f28122 mysqld!mutex_spin_wait+0x24e [d:\qa-win-debug\build\storage\xtradb\sync\sync0sync.c @ 640]
000000d2`d2fdf740 00007ff6`e7f283de mysqld!mutex_enter_func+0x112 [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 225]
000000d2`d2fdf780 00007ff6`e7ecb602 mysqld!pfs_mutex_enter_func+0xce [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 255]
000000d2`d2fdf830 00007ff6`e7ecb424 mysqld!buf_stats_get_pool_info+0x102 [d:\qa-win-debug\build\storage\xtradb\buf\buf0buf.c @ 4970]
000000d2`d2fdf890 00007ff6`e7f233bd mysqld!buf_print_io+0x174 [d:\qa-win-debug\build\storage\xtradb\buf\buf0buf.c @ 5208]
000000d2`d2fdf8f0 00007ff6`e7f22200 mysqld!srv_printf_innodb_monitor+0x9cd [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 2272]
000000d2`d2fdfa80 00007ffa`289013d2 mysqld!srv_monitor_thread+0x220 [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 2719]
000000d2`d2fdfb10 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d2fdfb40 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  15  Id: 1b4c.1344 Suspend: 0 Teb: 00007ff6`e721c000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d30df9f8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d30dfa00 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d30dfa70 00007ff6`e7fcc8c6 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d30dfaa0 00007ff6`e7fcbb3f mysqld!os_cond_wait_timed+0x96 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 150]
000000d2`d30dfae0 00007ff6`e7f22886 mysqld!os_event_wait_time_low+0x1ff [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 698]
000000d2`d30dfb30 00007ffa`289013d2 mysqld!srv_LRU_dump_restore_thread+0x56 [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 3095]
000000d2`d30dfb80 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d30dfbb0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  16  Id: 1b4c.594 Suspend: 0 Teb: 00007ff6`e721a000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d343f378 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d343f380 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d343f3f0 00007ff6`e7fcca48 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d343f420 00007ff6`e7fcb912 mysqld!os_cond_wait+0x108 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 205]
000000d2`d343f460 00007ff6`e7f341e6 mysqld!os_event_wait_low+0x142 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 596]
000000d2`d343f4a0 00007ff6`e7f28d0e mysqld!sync_array_wait_event+0x1a6 [d:\qa-win-debug\build\storage\xtradb\sync\sync0arr.c @ 461]
000000d2`d343f4f0 00007ff6`e7f28122 mysqld!mutex_spin_wait+0x24e [d:\qa-win-debug\build\storage\xtradb\sync\sync0sync.c @ 640]
000000d2`d343f550 00007ff6`e7f283de mysqld!mutex_enter_func+0x112 [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 225]
000000d2`d343f590 00007ff6`e7fd947c mysqld!pfs_mutex_enter_func+0xce [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 255]
000000d2`d343f640 00007ff6`e7fd402d mysqld!buf_flush_start+0x3c [d:\qa-win-debug\build\storage\xtradb\buf\buf0flu.c @ 1905]
000000d2`d343f680 00007ff6`e7f1f5f1 mysqld!buf_flush_list+0xad [d:\qa-win-debug\build\storage\xtradb\buf\buf0flu.c @ 2049]
000000d2`d343f6e0 00007ffa`289013d2 mysqld!srv_master_thread+0xa61 [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 3688]
000000d2`d343ff40 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d343ff70 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  17  Id: 1b4c.eb0 Suspend: 0 Teb: 00007ff6`e7218000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d353f5f8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d353f600 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d353f670 00007ff6`e7fcc8c6 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d353f6a0 00007ff6`e7fcbb3f mysqld!os_cond_wait_timed+0x96 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 150]
000000d2`d353f6e0 00007ff6`e7f246fc mysqld!os_event_wait_time_low+0x1ff [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 698]
000000d2`d353f730 00007ffa`289013d2 mysqld!srv_purge_thread+0x2fc [d:\qa-win-debug\build\storage\xtradb\srv\srv0srv.c @ 4239]
000000d2`d353f7b0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d353f7e0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  18  Id: 1b4c.650 Suspend: 0 Teb: 00007ff6`e7216000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d363f418 00007ffa`28c99156 ntdll!ZwWaitForWorkViaWorkerFactory+0xa
000000d2`d363f420 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1ab6
000000d2`d363f800 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d363f830 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  19  Id: 1b4c.88 Suspend: 0 Teb: 00007ff6`e7214000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d470f7b8 00007ffa`261d1118 ntdll!ZwWaitForSingleObject+0xa
000000d2`d470f7c0 00007ff6`e783a69c KERNELBASE!WaitForSingleObjectEx+0x98
000000d2`d470f860 00007ff6`e7e8cc21 mysqld!handle_shutdown+0x5c [d:\qa-win-debug\build\sql\mysqld.cc @ 3163]
000000d2`d470f8f0 00007ff6`e80cf1b6 mysqld!pfs_spawn_thread+0xc1 [d:\qa-win-debug\build\storage\perfschema\pfs.cc @ 1017]
000000d2`d470f950 00007ff6`e819b46c mysqld!pthread_start+0x56 [d:\qa-win-debug\build\mysys\my_winthread.c @ 61]
000000d2`d470f9a0 00007ff6`e819b013 mysqld!invoke_thread_procedure+0x2c [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 92]
000000d2`d470f9e0 00007ffa`289013d2 mysqld!thread_start<unsigned int (__cdecl*)(void * __ptr64)>+0x93 [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115]
000000d2`d470fa30 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d470fa60 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  20  Id: 1b4c.b2c Suspend: 0 Teb: 00007ff6`e7212000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d480f278 00007ffa`255cccb4 ntdll!ZwWaitForSingleObject+0xa
000000d2`d480f280 00007ffa`255caec5 mswsock!SockWaitForSingleObject+0x65
000000d2`d480f300 00007ffa`26eaffd3 mswsock!WSPSelect+0x79c
000000d2`d480f4a0 00007ff6`e783687d ws2_32!select+0x1db
000000d2`d480f590 00007ff6`e7836d68 mysqld!handle_connections_sockets+0x30d [d:\qa-win-debug\build\sql\mysqld.cc @ 5577]
000000d2`d480fc90 00007ff6`e7e8cc21 mysqld!handle_connections_sockets_thread+0x28 [d:\qa-win-debug\build\sql\mysqld.cc @ 5767]
000000d2`d480fcc0 00007ff6`e80cf1b6 mysqld!pfs_spawn_thread+0xc1 [d:\qa-win-debug\build\storage\perfschema\pfs.cc @ 1017]
000000d2`d480fd20 00007ff6`e819b46c mysqld!pthread_start+0x56 [d:\qa-win-debug\build\mysys\my_winthread.c @ 61]
000000d2`d480fd70 00007ff6`e819b013 mysqld!invoke_thread_procedure+0x2c [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 92]
000000d2`d480fdb0 00007ffa`289013d2 mysqld!thread_start<unsigned int (__cdecl*)(void * __ptr64)>+0x93 [d:\th\minkernel\crts\ucrt\src\appcrt\startup\thread.cpp @ 115]
000000d2`d480fe00 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d480fe30 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  21  Id: 1b4c.328 Suspend: 0 Teb: 00007ff6`e7210000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d312c6f8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d312c700 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d312c770 00007ff6`e80cf2d7 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d312c7a0 00007ff6`e78d680c mysqld!pthread_cond_timedwait+0x57 [d:\qa-win-debug\build\mysys\my_wincond.c @ 298]
000000d2`d312c7e0 00007ff6`e78d7246 mysqld!inline_mysql_cond_timedwait+0x11c [d:\qa-win-debug\build\include\mysql\psi\mysql_thread.h @ 1020]
000000d2`d312c890 00007ff6`e78d78f4 mysqld!MDL_wait::timed_wait+0x126 [d:\qa-win-debug\build\sql\mdl.cc @ 1191]
000000d2`d312c920 00007ff6`e78d7d8f mysqld!MDL_context::acquire_lock+0x374 [d:\qa-win-debug\build\sql\mdl.cc @ 2106]
000000d2`d312ca70 00007ff6`e7a1241c mysqld!MDL_context::acquire_locks+0x1af [d:\qa-win-debug\build\sql\mdl.cc @ 2218]
000000d2`d312cb50 00007ff6`e7cde766 mysqld!lock_table_names+0x4ec [d:\qa-win-debug\build\sql\sql_base.cc @ 4864]
000000d2`d312cef0 00007ff6`e7cded2b mysqld!Truncate_statement::lock_table+0x1d6 [d:\qa-win-debug\build\sql\sql_truncate.cc @ 376]
000000d2`d312cf80 00007ff6`e7cde525 mysqld!Truncate_statement::truncate_table+0x19b [d:\qa-win-debug\build\sql\sql_truncate.cc @ 477]
000000d2`d312d050 00007ff6`e79aac23 mysqld!Truncate_statement::execute+0xb5 [d:\qa-win-debug\build\sql\sql_truncate.cc @ 557]
000000d2`d312d0d0 00007ff6`e79a2e75 mysqld!mysql_execute_command+0x7633 [d:\qa-win-debug\build\sql\sql_parse.cc @ 4504]
000000d2`d312e2a0 00007ff6`e79ac4b7 mysqld!mysql_parse+0x265 [d:\qa-win-debug\build\sql\sql_parse.cc @ 5924]
000000d2`d312e350 00007ff6`e79ab617 mysqld!dispatch_command+0xd27 [d:\qa-win-debug\build\sql\sql_parse.cc @ 1069]
000000d2`d312f2e0 00007ff6`e78b984c mysqld!do_command+0x327 [d:\qa-win-debug\build\sql\sql_parse.cc @ 793]
000000d2`d312f390 00007ff6`e7a47365 mysqld!threadpool_process_request+0x7c [d:\qa-win-debug\build\sql\threadpool_common.cc @ 233]
000000d2`d312f400 00007ffa`28901d5d mysqld!io_completion_callback+0x95 [d:\qa-win-debug\build\sql\threadpool_win.cc @ 568]
000000d2`d312f450 00007ffa`28c7c6f2 kernel32!BasepTpIoCallback+0x59
000000d2`d312f4a0 00007ffa`28c992c4 ntdll!RtlGetActiveActivationContext+0x252
000000d2`d312f530 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1c24
000000d2`d312f910 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d312f940 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  22  Id: 1b4c.1aac Suspend: 0 Teb: 00007ff6`e720e000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4b3fa08 00007ffa`28c99156 ntdll!ZwWaitForWorkViaWorkerFactory+0xa
000000d2`d4b3fa10 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1ab6
000000d2`d4b3fdf0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4b3fe20 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
# 23  Id: 1b4c.121c Suspend: 0 Teb: 00007ff6`e720c000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4b89c38 00000000`00000000 ntdll!NtGetContextThread+0xa
 
  24  Id: 1b4c.1ac8 Suspend: 0 Teb: 00007ff6`e720a000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4bdc138 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d4bdc140 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d4bdc1b0 00007ff6`e7fcca48 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d4bdc1e0 00007ff6`e7fcb912 mysqld!os_cond_wait+0x108 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 205]
000000d2`d4bdc220 00007ff6`e7f341e6 mysqld!os_event_wait_low+0x142 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 596]
000000d2`d4bdc260 00007ff6`e7f28d0e mysqld!sync_array_wait_event+0x1a6 [d:\qa-win-debug\build\storage\xtradb\sync\sync0arr.c @ 461]
000000d2`d4bdc2b0 00007ff6`e7f28122 mysqld!mutex_spin_wait+0x24e [d:\qa-win-debug\build\storage\xtradb\sync\sync0sync.c @ 640]
000000d2`d4bdc310 00007ff6`e7f283de mysqld!mutex_enter_func+0x112 [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 225]
000000d2`d4bdc350 00007ff6`e7fc45c8 mysqld!pfs_mutex_enter_func+0xce [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 255]
000000d2`d4bdc400 00007ff6`e79be92a mysqld!i_s_sys_tables_fill_table_stats+0x138 [d:\qa-win-debug\build\storage\xtradb\handler\i_s.cc @ 4104]
000000d2`d4bdcac0 00007ff6`e7aaf97c mysqld!get_schema_tables_result+0x40a [d:\qa-win-debug\build\sql\sql_show.cc @ 7798]
000000d2`d4bdcbd0 00007ff6`e7ab9107 mysqld!JOIN::exec+0x9cc [d:\qa-win-debug\build\sql\sql_select.cc @ 2395]
000000d2`d4bdce30 00007ff6`e7ab8a4f mysqld!mysql_select+0x517 [d:\qa-win-debug\build\sql\sql_select.cc @ 3135]
000000d2`d4bdcf40 00007ff6`e79b181e mysqld!handle_select+0x25f [d:\qa-win-debug\build\sql\sql_select.cc @ 311]
000000d2`d4bdd040 00007ff6`e79a3f4f mysqld!execute_sqlcom_select+0x38e [d:\qa-win-debug\build\sql\sql_parse.cc @ 4679]
000000d2`d4bdd560 00007ff6`e79a2e75 mysqld!mysql_execute_command+0x95f [d:\qa-win-debug\build\sql\sql_parse.cc @ 2225]
000000d2`d4bde730 00007ff6`e79ac4b7 mysqld!mysql_parse+0x265 [d:\qa-win-debug\build\sql\sql_parse.cc @ 5924]
000000d2`d4bde7e0 00007ff6`e79ab617 mysqld!dispatch_command+0xd27 [d:\qa-win-debug\build\sql\sql_parse.cc @ 1069]
000000d2`d4bdf770 00007ff6`e78b984c mysqld!do_command+0x327 [d:\qa-win-debug\build\sql\sql_parse.cc @ 793]
000000d2`d4bdf820 00007ff6`e7a47365 mysqld!threadpool_process_request+0x7c [d:\qa-win-debug\build\sql\threadpool_common.cc @ 233]
000000d2`d4bdf890 00007ffa`28901d5d mysqld!io_completion_callback+0x95 [d:\qa-win-debug\build\sql\threadpool_win.cc @ 568]
000000d2`d4bdf8e0 00007ffa`28c7c6f2 kernel32!BasepTpIoCallback+0x59
000000d2`d4bdf930 00007ffa`28c992c4 ntdll!RtlGetActiveActivationContext+0x252
000000d2`d4bdf9c0 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1c24
000000d2`d4bdfda0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4bdfdd0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  25  Id: 1b4c.1404 Suspend: 0 Teb: 00007ff6`e7208000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4c29da8 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d4c29db0 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d4c29e20 00007ff6`e7fcca48 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d4c29e50 00007ff6`e7fcb912 mysqld!os_cond_wait+0x108 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 205]
000000d2`d4c29e90 00007ff6`e7f341e6 mysqld!os_event_wait_low+0x142 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 596]
000000d2`d4c29ed0 00007ff6`e7f28d0e mysqld!sync_array_wait_event+0x1a6 [d:\qa-win-debug\build\storage\xtradb\sync\sync0arr.c @ 461]
000000d2`d4c29f20 00007ff6`e7f28122 mysqld!mutex_spin_wait+0x24e [d:\qa-win-debug\build\storage\xtradb\sync\sync0sync.c @ 640]
000000d2`d4c29f80 00007ff6`e7f283de mysqld!mutex_enter_func+0x112 [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 225]
000000d2`d4c29fc0 00007ff6`e7f8b419 mysqld!pfs_mutex_enter_func+0xce [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 255]
000000d2`d4c2a070 00007ff6`e7ea407b mysqld!row_mysql_lock_data_dictionary_func+0xd9 [d:\qa-win-debug\build\storage\xtradb\row\row0mysql.c @ 1853]
000000d2`d4c2a0b0 00007ff6`e786f679 mysqld!ha_innobase::create+0x7cb [d:\qa-win-debug\build\storage\xtradb\handler\ha_innodb.cc @ 8496]
000000d2`d4c2a630 00007ff6`e7874961 mysqld!handler::ha_create+0x59 [d:\qa-win-debug\build\sql\handler.cc @ 3755]
000000d2`d4c2a670 00007ff6`e7c622ae mysqld!ha_create_table+0x181 [d:\qa-win-debug\build\sql\handler.cc @ 4085]
000000d2`d4c2b510 00007ff6`e79e4d9b mysqld!rea_create_table+0x1ee [d:\qa-win-debug\build\sql\unireg.cc @ 524]
000000d2`d4c2b7e0 00007ff6`e7c03363 mysqld!mysql_create_table_no_lock+0x108b [d:\qa-win-debug\build\sql\sql_table.cc @ 4536]
000000d2`d4c2beb0 00007ff6`e7bf9a75 mysqld!create_table_from_items+0x493 [d:\qa-win-debug\build\sql\sql_insert.cc @ 3937]
000000d2`d4c2ccf0 00007ff6`e7aaaa01 mysqld!select_create::prepare+0x1e5 [d:\qa-win-debug\build\sql\sql_insert.cc @ 4101]
000000d2`d4c2ce10 00007ff6`e7ab8fda mysqld!JOIN::prepare+0x1651 [d:\qa-win-debug\build\sql\sql_select.cc @ 921]
000000d2`d4c2cfe0 00007ff6`e7ab8a4f mysqld!mysql_select+0x3ea [d:\qa-win-debug\build\sql\sql_select.cc @ 3111]
000000d2`d4c2d0f0 00007ff6`e79a4d26 mysqld!handle_select+0x25f [d:\qa-win-debug\build\sql\sql_select.cc @ 311]
000000d2`d4c2d1f0 00007ff6`e79a2e75 mysqld!mysql_execute_command+0x1736 [d:\qa-win-debug\build\sql\sql_parse.cc @ 2613]
000000d2`d4c2e3c0 00007ff6`e79ac4b7 mysqld!mysql_parse+0x265 [d:\qa-win-debug\build\sql\sql_parse.cc @ 5924]
000000d2`d4c2e470 00007ff6`e79ab617 mysqld!dispatch_command+0xd27 [d:\qa-win-debug\build\sql\sql_parse.cc @ 1069]
000000d2`d4c2f400 00007ff6`e78b984c mysqld!do_command+0x327 [d:\qa-win-debug\build\sql\sql_parse.cc @ 793]
000000d2`d4c2f4b0 00007ff6`e7a47365 mysqld!threadpool_process_request+0x7c [d:\qa-win-debug\build\sql\threadpool_common.cc @ 233]
000000d2`d4c2f520 00007ffa`28901d5d mysqld!io_completion_callback+0x95 [d:\qa-win-debug\build\sql\threadpool_win.cc @ 568]
000000d2`d4c2f570 00007ffa`28c7c6f2 kernel32!BasepTpIoCallback+0x59
000000d2`d4c2f5c0 00007ffa`28c992c4 ntdll!RtlGetActiveActivationContext+0x252
000000d2`d4c2f650 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1c24
000000d2`d4c2fa30 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4c2fa60 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  26  Id: 1b4c.18ac Suspend: 0 Teb: 00007ff6`e7206000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4c7ba58 00007ffa`28cca222 ntdll!ZwWaitForAlertByThreadId+0xa
000000d2`d4c7ba60 00007ffa`261f5038 ntdll!RtlSleepConditionVariableCS+0xc2
000000d2`d4c7bad0 00007ff6`e7fcca48 KERNELBASE!SleepConditionVariableCS+0x28
000000d2`d4c7bb00 00007ff6`e7fcb912 mysqld!os_cond_wait+0x108 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 205]
000000d2`d4c7bb40 00007ff6`e7f341e6 mysqld!os_event_wait_low+0x142 [d:\qa-win-debug\build\storage\xtradb\os\os0sync.c @ 596]
000000d2`d4c7bb80 00007ff6`e7f28d0e mysqld!sync_array_wait_event+0x1a6 [d:\qa-win-debug\build\storage\xtradb\sync\sync0arr.c @ 461]
000000d2`d4c7bbd0 00007ff6`e7f28122 mysqld!mutex_spin_wait+0x24e [d:\qa-win-debug\build\storage\xtradb\sync\sync0sync.c @ 640]
000000d2`d4c7bc30 00007ff6`e7f283de mysqld!mutex_enter_func+0x112 [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 225]
000000d2`d4c7bc70 00007ff6`e7ed3c77 mysqld!pfs_mutex_enter_func+0xce [d:\qa-win-debug\build\storage\xtradb\include\sync0sync.ic @ 255]
000000d2`d4c7bd20 00007ff6`e7eca4c4 mysqld!buf_pool_validate_instance+0x137 [d:\qa-win-debug\build\storage\xtradb\buf\buf0buf.c @ 4339]
000000d2`d4c7be40 00007ff6`e7ec54e8 mysqld!buf_validate+0x54 [d:\qa-win-debug\build\storage\xtradb\buf\buf0buf.c @ 4570]
000000d2`d4c7be80 00007ff6`e80043aa mysqld!buf_page_optimistic_get+0x4c8 [d:\qa-win-debug\build\storage\xtradb\buf\buf0buf.c @ 3069]
000000d2`d4c7bf60 00007ff6`e7fba559 mysqld!btr_pcur_restore_position_func+0x3aa [d:\qa-win-debug\build\storage\xtradb\btr\btr0pcur.c @ 272]
000000d2`d4c7c050 00007ff6`e7fc5a91 mysqld!dict_getnext_system+0x49 [d:\qa-win-debug\build\storage\xtradb\dict\dict0load.c @ 304]
000000d2`d4c7c0a0 00007ff6`e79be92a mysqld!i_s_sys_fields_fill_table+0x2a1 [d:\qa-win-debug\build\storage\xtradb\handler\i_s.cc @ 4824]
000000d2`d4c7c7b0 00007ff6`e7aaf97c mysqld!get_schema_tables_result+0x40a [d:\qa-win-debug\build\sql\sql_show.cc @ 7798]
000000d2`d4c7c8c0 00007ff6`e7b416aa mysqld!JOIN::exec+0x9cc [d:\qa-win-debug\build\sql\sql_select.cc @ 2395]
000000d2`d4c7cb20 00007ff6`e7b3f89e mysqld!st_select_lex_unit::exec+0x48a [d:\qa-win-debug\build\sql\sql_union.cc @ 697]
000000d2`d4c7ccd0 00007ff6`e7ab88d8 mysqld!mysql_union+0x8e [d:\qa-win-debug\build\sql\sql_union.cc @ 39]
000000d2`d4c7cd40 00007ff6`e79b181e mysqld!handle_select+0xe8 [d:\qa-win-debug\build\sql\sql_select.cc @ 301]
000000d2`d4c7ce40 00007ff6`e79a3f4f mysqld!execute_sqlcom_select+0x38e [d:\qa-win-debug\build\sql\sql_parse.cc @ 4679]
000000d2`d4c7d360 00007ff6`e79a2e75 mysqld!mysql_execute_command+0x95f [d:\qa-win-debug\build\sql\sql_parse.cc @ 2225]
000000d2`d4c7e530 00007ff6`e79ac4b7 mysqld!mysql_parse+0x265 [d:\qa-win-debug\build\sql\sql_parse.cc @ 5924]
000000d2`d4c7e5e0 00007ff6`e79ab617 mysqld!dispatch_command+0xd27 [d:\qa-win-debug\build\sql\sql_parse.cc @ 1069]
000000d2`d4c7f570 00007ff6`e78b984c mysqld!do_command+0x327 [d:\qa-win-debug\build\sql\sql_parse.cc @ 793]
000000d2`d4c7f620 00007ff6`e7a47365 mysqld!threadpool_process_request+0x7c [d:\qa-win-debug\build\sql\threadpool_common.cc @ 233]
000000d2`d4c7f690 00007ffa`28901d5d mysqld!io_completion_callback+0x95 [d:\qa-win-debug\build\sql\threadpool_win.cc @ 568]
000000d2`d4c7f6e0 00007ffa`28c7c6f2 kernel32!BasepTpIoCallback+0x59
000000d2`d4c7f730 00007ffa`28c992c4 ntdll!RtlGetActiveActivationContext+0x252
000000d2`d4c7f7c0 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1c24
000000d2`d4c7fba0 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4c7fbd0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  27  Id: 1b4c.1054 Suspend: 0 Teb: 00007ff6`e7204000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4d7f3a8 00007ffa`28c99156 ntdll!ZwWaitForWorkViaWorkerFactory+0xa
000000d2`d4d7f3b0 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1ab6
000000d2`d4d7f790 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4d7f7c0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
 
  28  Id: 1b4c.7cc Suspend: 0 Teb: 00007ff6`e7202000 Unfrozen
Child-SP          RetAddr           Call Site
000000d2`d4e7f488 00007ffa`28c99156 ntdll!ZwWaitForWorkViaWorkerFactory+0xa
000000d2`d4e7f490 00007ffa`289013d2 ntdll!RtlFreeUnicodeString+0x1ab6
000000d2`d4e7f870 00007ffa`28c754f4 kernel32!BaseThreadInitThunk+0x22
000000d2`d4e7f8a0 00000000`00000000 ntdll!RtlUserThreadStart+0x34
quit:

rqg 278627d5a1c toolbox 572674defc

E:\buildbot\rqg/runall.pl --no-mask --seed=1548621197 --threads=5 --duration=400 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=conf/mariadb/redefine_random_keys.yy --redefine=conf/mariadb/redefine_set_session_vars.yy --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,DisableOptimizations,EnableOptimizations,ExecuteAsCTE,ExecuteAsInsertSelect,ExecuteAsPreparedOnce,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,NullIf,OrderBy,StraightJoin,ExecuteAsExecuteImmediate --store-binaries --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --mtr-build-thread=150 --basedir1=D:\qa-win-debug\install --vardir1=E:\buildbot\vardirs\qa-win-debug\5.5-2347\optim-crash-tests/current1_1

Comment by Marko Mäkelä [ 2023-12-14 ]

This reminds me of MDEV-31386. I wonder if this is reproducible in 10.4, 10.5, and 10.6. Each of them could be different in this regard.

Generated at Thu Feb 08 06:51:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.