connect.misc w3 [ fail ]
|
Test ended at 2022-02-03 13:06:12
|
|
CURRENT_TEST: connect.misc
|
mysqltest: At line 78: query 'insert into beers values('11','22','33')' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
1
|
drop table t;
|
create table beers (
|
`Name` char(16) xpath='brandName',
|
`Origin` char(16) xpath='origin',
|
`Description` char(32) xpath='details')
|
engine=CONNECT table_type=XML file_name='MYSQLTEST_VARDIR/tmp/beer.xml'
|
tabname='table' option_list='rownode=tr,colnode=td%n';
|
select * from beers;
|
Name Origin Description
|
NULL NULL NULL
|
NULL NULL NULL
|
drop table beers;
|
create table beers (
|
`Name` char(16) xpath='brandName',
|
`Origin` char(16) xpath='origin',
|
`Description` char(32) xpath='details')
|
engine=CONNECT table_type=XML file_name='MYSQLTEST_VARDIR/tmp/beer.xml'
|
tabname='table' option_list='rownode=tr,colnode=td';
|
insert into beers values('11','22','33');
|
|
More results from queries before failure can be found in /dev/shm/var/3/log/misc.log
|
|
|
Server [mysqld.1 - pid: 1644, winpid: 1644, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
OpenTable: MakeSQL: Wrong place holders specification
|
XPath error : Invalid expression
|
td%n/brandName
|
^
|
XPath error : Invalid expression
|
td%n/origin
|
^
|
XPath error : Invalid expression
|
td%n/details
|
^
|
XPath error : Invalid expression
|
td%n/brandName
|
^
|
XPath error : Invalid expression
|
td%n/origin
|
^
|
XPath error : Invalid expression
|
td%n/details
|
^
|
220203 13:06:12 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.2.42-MariaDB-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=3
|
max_threads=153
|
thread_count=3
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63021 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7fd86c0009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7fd88468ee00 thread_stack 0x49000
|
/usr/local/mariadb-10.2.42-linux-x86_64/bin/mysqld(my_print_stacktrace+0x2e)[0x7fd88cfb6b9e]
|
/usr/local/mariadb-10.2.42-linux-x86_64/bin/mysqld(handle_fatal_signal+0x30d)[0x7fd88ca0febd]
|
sigaction.c:0(__restore_rt)[0x7fd88bede4a0]
|
connect/libdoc.cpp:1197(XML2NODELIST::GetItem(_global*, int, XMLNODE*))[0x7fd885d01ca7]
|
connect/tabxml.cpp:1789(XMLCOL::WriteColumn(_global*))[0x7fd885d043b3]
|
/usr/local/mariadb-10.2.42-linux-x86_64/lib/plugin/ha_connect.so(_Z11CntWriteRowP7_globalP3TDB+0x4e)[0x7fd885c5f0fe]
|
connect/ha_connect.cc:3721(ha_connect::write_row(unsigned char*))[0x7fd885c53678]
|
sql/handler.cc:6118(handler::ha_write_row(unsigned char*))[0x7fd88ca1a7d3]
|
sql/sql_insert.cc:1951(write_record(THD*, TABLE*, st_copy_info*))[0x7fd88c85ad8f]
|
sql/sql_insert.cc:1066(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool))[0x7fd88c8611e2]
|
sql/sql_parse.cc:4219(mysql_execute_command(THD*))[0x7fd88c877e2b]
|
sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7fd88c87e265]
|
sql/sql_parse.cc:1891(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7fd88c8803ce]
|
sql/sql_parse.cc:1384(do_command(THD*))[0x7fd88c88182a]
|
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x7fd88c94d0e6]
|
sql/sql_connect.cc:1243(handle_one_connection)[0x7fd88c94d1fd]
|
:0(pfs_spawn_thread)[0x7fd88cf2c2ed]
|
pthread_create.c:0(start_thread)[0x7fd88bed67f1]
|
/lib64/libc.so.6(clone+0x6d)[0x7fd88ae56ccd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fd86c00f120): insert into beers values('11','22','33')
|
|
Connection ID (thread ID): 102
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /dev/shm/var/3/mysqld.1/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 10485760 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 1024 62852 processes
|
Max open files 1024 1024 files
|
Max locked memory 65536 65536 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 62852 62852 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
|
----------SERVER LOG END-------------
|
|
|
- found 'core.1645' (0/0)
|
|
Trying 'dbx' to get a backtrace
|
|
Trying 'gdb' to get a backtrace from coredump /dev/shm/var/3/log/connect.misc/mysqld.1/data/core.1645
|
Core generated by '/usr/local/mariadb-10.2.42-linux-x86_64/bin/mysqld'
|
Output from gdb follows. The first stack trace is from the failing thread.
|
The following stack traces are from all threads (so the failing one is
|
duplicated).
|
--------------------------
|
[New Thread 2139]
|
[New Thread 1645]
|
[New Thread 1689]
|
[New Thread 1658]
|
[New Thread 2140]
|
[New Thread 1661]
|
[New Thread 1665]
|
[New Thread 1662]
|
[Thread debugging using libthread_db enabled]
|
Core was generated by `/usr/local/mariadb-10.2.42-linux-x86_64/bin/mysqld --defaults-group-suffix=.1 -'.
|
Program terminated with signal 11, Segmentation fault.
|
#0 0x00007fd88bedb63c in pthread_kill () from /lib64/libpthread.so.0
|
#0 0x00007fd88bedb63c in pthread_kill () from /lib64/libpthread.so.0
|
#1 0x00007fd88ca0ff3e in handle_fatal_signal ()
|
#2 <signal handler called>
|
#3 0x00007fd885d01ca7 in XML2NODELIST::GetItem(_global*, int, XMLNODE*) () at /home/buildbot/buildbot/build/storage/connect/libdoc.cpp:1197
|
#4 0x00007fd885d043b3 in XMLCOL::WriteColumn(_global*) () at /home/buildbot/buildbot/build/storage/connect/tabxml.cpp:1784
|
#5 0x00007fd885c5f0fe in CntWriteRow(_global*, TDB*) () from /usr/local/mariadb-10.2.42-linux-x86_64/lib/plugin/ha_connect.so
|
#6 0x00007fd885c53678 in ha_connect::write_row(unsigned char*) () at /home/buildbot/buildbot/build/storage/connect/ha_connect.cc:3721
|
#7 0x00007fd88ca1a7d3 in handler::ha_write_row(unsigned char*) () at /home/buildbot/buildbot/build/sql/handler.cc:6118
|
#8 0x00007fd88c85ad8f in write_record(THD*, TABLE*, st_copy_info*) () at /home/buildbot/buildbot/build/sql/sql_insert.cc:1951
|
#9 0x00007fd88c8611e2 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) () at /home/buildbot/buildbot/build/sql/sql_insert.cc:1066
|
#10 0x00007fd88c877e2b in mysql_execute_command(THD*) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:4219
|
#11 0x00007fd88c87e265 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:7793
|
#12 0x00007fd88c8803ce in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:1828
|
#13 0x00007fd88c88182a in do_command(THD*) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:1382
|
#14 0x00007fd88c94d0e6 in do_handle_one_connection(CONNECT*) () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1336
|
#15 0x00007fd88c94d1fd in handle_one_connection () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1241
|
#16 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#17 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#18 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 8 (Thread 0x7fd88476d700 (LWP 1662)):
|
#0 0x00007fd88bede245 in sigwait () from /lib64/libpthread.so.0
|
#1 0x00007fd88c7d266b in signal_hand () at /home/buildbot/buildbot/build/sql/mysqld.cc:3559
|
#2 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#3 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#4 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 7 (Thread 0x7fd884723700 (LWP 1665)):
|
#0 0x00007fd88beda3dc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
#1 0x00007fd88c86d950 in handle_manager ()
|
#2 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#3 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#4 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 6 (Thread 0x7fd87ffff700 (LWP 1661)):
|
#0 0x00007fd88beda75b in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
#1 0x00007fd88ce5c33b in my_service_thread_sleep ()
|
#2 0x00007fd88ce5400a in ma_checkpoint_background ()
|
#3 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#4 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#5 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 5 (Thread 0x7fd884645700 (LWP 2140)):
|
#0 0x00007fd88beda75b in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
#1 0x00007fd88c7d3c3d in one_thread_per_connection_end(THD*, bool) () at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1182
|
#2 0x00007fd88c94d046 in do_handle_one_connection(CONNECT*) () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1355
|
#3 0x00007fd88c94d1fd in handle_one_connection () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1241
|
#4 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#5 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#6 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 4 (Thread 0x7fd8868b9700 (LWP 1658)):
|
#0 0x00007fd88beda75b in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
#1 0x00007fd88cfbb0fa in timer_handler ()
|
#2 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#3 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#4 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 3 (Thread 0x7fd8846d9700 (LWP 1689)):
|
#0 0x00007fd88beda75b in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
|
#1 0x00007fd88c7d3c3d in one_thread_per_connection_end(THD*, bool) () at /home/buildbot/buildbot/build/include/mysql/psi/mysql_thread.h:1182
|
#2 0x00007fd88c94d046 in do_handle_one_connection(CONNECT*) () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1355
|
#3 0x00007fd88c94d1fd in handle_one_connection () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1241
|
#4 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#5 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#6 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
Thread 2 (Thread 0x7fd88c2fd720 (LWP 1645)):
|
#0 0x00007fd88ae4d613 in poll () from /lib64/libc.so.6
|
#1 0x00007fd88c7dacda in handle_connections_sockets() () at /home/buildbot/buildbot/build/sql/mysqld.cc:6726
|
#2 0x00007fd88c7dc388 in mysqld_main(int, char**) () at /home/buildbot/buildbot/build/sql/mysqld.cc:6194
|
#3 0x00007fd88ad8fcdd in __libc_start_main () from /lib64/libc.so.6
|
#4 0x00007fd88c7cf921 in _start ()
|
|
Thread 1 (Thread 0x7fd88468f700 (LWP 2139)):
|
#0 0x00007fd88bedb63c in pthread_kill () from /lib64/libpthread.so.0
|
#1 0x00007fd88ca0ff3e in handle_fatal_signal ()
|
#2 <signal handler called>
|
#3 0x00007fd885d01ca7 in XML2NODELIST::GetItem(_global*, int, XMLNODE*) () at /home/buildbot/buildbot/build/storage/connect/libdoc.cpp:1197
|
#4 0x00007fd885d043b3 in XMLCOL::WriteColumn(_global*) () at /home/buildbot/buildbot/build/storage/connect/tabxml.cpp:1784
|
#5 0x00007fd885c5f0fe in CntWriteRow(_global*, TDB*) () from /usr/local/mariadb-10.2.42-linux-x86_64/lib/plugin/ha_connect.so
|
#6 0x00007fd885c53678 in ha_connect::write_row(unsigned char*) () at /home/buildbot/buildbot/build/storage/connect/ha_connect.cc:3721
|
#7 0x00007fd88ca1a7d3 in handler::ha_write_row(unsigned char*) () at /home/buildbot/buildbot/build/sql/handler.cc:6118
|
#8 0x00007fd88c85ad8f in write_record(THD*, TABLE*, st_copy_info*) () at /home/buildbot/buildbot/build/sql/sql_insert.cc:1951
|
#9 0x00007fd88c8611e2 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool) () at /home/buildbot/buildbot/build/sql/sql_insert.cc:1066
|
#10 0x00007fd88c877e2b in mysql_execute_command(THD*) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:4219
|
#11 0x00007fd88c87e265 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:7793
|
#12 0x00007fd88c8803ce in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:1828
|
#13 0x00007fd88c88182a in do_command(THD*) () at /home/buildbot/buildbot/build/sql/sql_parse.cc:1382
|
#14 0x00007fd88c94d0e6 in do_handle_one_connection(CONNECT*) () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1336
|
#15 0x00007fd88c94d1fd in handle_one_connection () at /home/buildbot/buildbot/build/sql/sql_connect.cc:1241
|
#16 0x00007fd88cf2c2ed in pfs_spawn_thread ()
|
#17 0x00007fd88bed67f1 in start_thread () from /lib64/libpthread.so.0
|
#18 0x00007fd88ae56ccd in clone () from /lib64/libc.so.6
|
|
- deleting it, already saved 0
|
- saving '/dev/shm/var/3/log/connect.misc/' to '/dev/shm/var/log/connect.misc/'
|