[MDEV-24930] CLONE - Server is down thourgh queries Created: 2021-02-20  Updated: 2021-03-29

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4.15
Fix Version/s: None

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

Attachments: HTML File requests    
Issue Links:
Relates
relates to MDEV-24309 Server is down thourgh queries Closed

 Description   

Server down when trying to run the script with queries.
The error is

Thread pointer: 0x7f5fbc0016e8
 
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 = 0x7f5fee718dd8 thread_stack 0x30000
 
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x56427746c67e]
 
/usr/sbin/mysqld(handle_fatal_signal+0x515)[0x564276ee7fc5]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x128a0)[0x7f5fed9688a0]
 
/usr/sbin/mysqld(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x162)[0x564276d08932]
 
/usr/sbin/mysqld(_ZN4JOIN25add_keyuses_for_splittingEv+0x552)[0x564276e3f482]
 
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x2290)[0x564276d302f0]
 
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0xab)[0x564276d315cb]
 
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe0)[0x564276d31780]
 
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x564276d32181]
 
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6e25)[0x564276cdca65]
 
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1ea)[0x564276cde08a]
 
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x13d5)[0x564276ce04e5]
 
/usr/sbin/mysqld(_Z10do_commandP3THD+0x104)[0x564276ce1c64]
 
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x25e)[0x564276dbec3e]
 
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x564276dbecfd]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f5fed95d6db]
 
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f5fec37fa3f]

When I try manuall run queries, it works, but trought script it is say server is gone away.

 Comments   
Comment by Denis Kostyanets [ 2021-02-20 ]

Information added to the FTP, please check.

Comment by Denis Kostyanets [ 2021-03-11 ]

Hi! Any news about this issue?

Comment by Elena Stepanova [ 2021-03-28 ]

The error log (from FTP) doesn't contain anything usable, unfortunately.
We need the crashing query and participating structures for the analysis.
The attached/uploaded requests file contains a number of queries from a single connection 402. But this connection quits normally at the end (the last record in requests), so the crash couldn't be coming from it. It doesn't happen on disconnect, it happens on SELECT, so there should still be an active connection performing it.

Comment by Denis Kostyanets [ 2021-03-29 ]

I can give you access to the DB and you can check anything that you need.

Generated at Thu Feb 08 09:33:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.