[MDEV-14805] federated.federated_bug_585688 failed in buildbot, server crashed Created: 2017-12-29  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated, Tests
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

MacOS


Issue Links:
Relates
relates to MDEV-12907 federated.federated_bug_585688 failed... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/labrador/builds/11764/steps/test/logs/stdio

federated.federated_bug_585688 'old'     [ fail ]
        Test ended at 2017-12-19 14:53:26
 
CURRENT_TEST: federated.federated_bug_585688
mysqltest: In included file "/private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/federated/include/federated_cleanup.inc": 
included from /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/federated/federated_bug_585688.test at line 52:
At line 3: query 'DROP TABLE IF EXISTS federated.t1' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
CREATE TABLE federated.t1(a TEXT) ENGINE=FEDERATED
CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1';
flush tables;
describe federated.t1;
Field	Type	Null	Key	Default	Extra
a	text	YES		NULL	
show table status from federated;
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t1	FEDERATED	10	Dynamic	5	20	X	X	X	X	X	X	X	X	latin1_swedish_ci	NULL		
show table status from federated;
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t1	FEDERATED	10	Dynamic	5	20	X	X	X	X	X	X	X	X	latin1_swedish_ci	NULL		
DROP TABLE federated.t1;
DROP TABLE federated.t1;
DROP TABLE IF EXISTS federated.t1;
 
More results from queries before failure can be found in /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/log/federated_bug_585688.log
 
 
Server [mysqld.1 - pid: 14377, winpid: 14377, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
171219 14:53:23 [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.1.30-MariaDB
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=4
max_threads=153
thread_count=2
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62941 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0x7fc3840d1408
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 = 0x111874e60 thread_stack 0x48400
0   mysqld                              0x0000000109622f2e my_print_stacktrace + 46
0   mysqld                              0x0000000109002a05 handle_fatal_signal + 709
0   libsystem_c.dylib                   0x00007fff8a671cfa _sigtramp + 26
0   ???                                 0x000000011186c700 0x0 + 4589012736
0   mysqld                              0x00000001092de576 _ZN10DsMrr_impl11dsmrr_closeEv + 20
0   mysqld                              0x00000001093db162 _ZN9ha_myisam5resetEv + 40
0   mysqld                              0x000000010917034e _Z18close_thread_tableP3THDPP5TABLE + 270
0   mysqld                              0x000000010917083b _Z19close_thread_tablesP3THD + 651
0   mysqld                              0x00000001091708a5 _Z19close_system_tablesP3THDP18Open_tables_backup + 21
0   mysqld                              0x0000000109235f8e _Z27delete_statistics_for_tableP3THDP19st_mysql_lex_stringS2_ + 1118
0   mysqld                              0x000000010924c83e _Z14mysql_rm_tableP3THDP10TABLE_LISTcc + 270
0   mysqld                              0x00000001091bdb11 _Z21mysql_execute_commandP3THD + 17665
0   mysqld                              0x00000001091c2444 _Z11mysql_parseP3THDPcjP12Parser_state + 388
0   mysqld                              0x00000001091c44f5 _Z16dispatch_command19enum_server_commandP3THDPcj + 2693
0   mysqld                              0x00000001091c5f6f _Z10do_commandP3THD + 1311
0   mysqld                              0x000000010929b94e _Z24do_handle_one_connectionP3THD + 718
0   mysqld                              0x000000010929ba2e handle_one_connection + 62
0   mysqld                              0x0000000109420e58 pfs_spawn_thread + 296
0   libsystem_c.dylib                   0x00007fff8a61d8bf _pthread_start + 335
0   libsystem_c.dylib                   0x00007fff8a620b75 thread_start + 13
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fc38481d220): is an invalid pointer
Connection ID (thread ID): 36
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=off
 
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
 
We think the query pointer is invalid, but we will try to print it anyway. 
Query: DROP TABLE IF EXISTS federated.t1
 
Writing a core file


Generated at Thu Feb 08 08:16:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.