[MDEV-24309] Server is down thourgh queries Created: 2020-11-30  Updated: 2021-02-20  Resolved: 2021-02-15

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Denis Kostyanets Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback

Attachments: HTML File requests    
Issue Links:
Relates
relates to MDEV-24930 CLONE - Server is down thourgh queries Open

 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 Alice Sherepa [ 2020-12-02 ]

Which version of MariaDB you are using? Could you please provide the complete sequence of steps you perform to reproduce the issue?

Comment by Denis Kostyanets [ 2020-12-25 ]

Hi Alice!
Sorry for delay with answer.
We use 10.4.15-MariaDB but it reproduced and in 10.5.
List of requests added requests
If you give me your IP and mail I can give you access to DB.

Comment by Alice Sherepa [ 2021-01-12 ]

Hi Denis! Could you please attach the script, .cnf file(s), and full error log? Also, we need the structure of tables, that are involved. You can upload it to our ftp in the private section: ftp://ftp.askmonty.org/private/ in case you want it to be hidden.
BR, Alice

Comment by Denis Kostyanets [ 2021-02-20 ]

Sorry for delay, information added to the FTP. Please check.

Comment by Denis Kostyanets [ 2021-02-20 ]

information added to the FTP

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