[MDEV-17982] Restarting MariaDB service Created: 2018-12-12  Updated: 2018-12-13  Resolved: 2018-12-13

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

Type: Bug Priority: Major
Reporter: Shkemb Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Production

Attachments: Text File mysqld.log     Text File reindex log.log    
Issue Links:
Duplicate
duplicates MDEV-17839 Crash (pure virtual method called) in... Closed

 Description   

Dears,

we have sometimes a situation where MariaDB service is restarted in the middle of working.
In our production environment we are using one of the Percona Toolkit v3.0.12 (pt-online-schema-change) to reindex tables of our database. Sometime during this execution (not every time), MariaDB service is restarted during executing.
Last time that we faced in this problem was couple days ago and error that is appeared in MariaDB error log after 4 hours executing is:

2018-12-10 7:52:17 140406842615552 [ERROR] Got error 128 when reading table './newplatform/party_relationships'
pure virtual method called
terminate called without an active exception
181210 7:52:17 [ERROR] mysqld got signal 6 ;
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_
. . .

The error gives the idea that there is a problem with this table (party_relationships), but it is not because this table is reindex sucessfully (with this job and after that manually) and the system is working also properly.

In attachment you can find complete MariaDB error log for this case and the log from executing of Percona toolkit.

MariaDB server: 10.2.19
OS: Linux-CentOS: 7.5.x

Any help for this will be appreciated.

Thanks,
Shkemb

 Comments   
Comment by Alice Sherepa [ 2018-12-13 ]

from the log:

2018-12-10  7:52:17 140406842615552 [ERROR] Got error 128 when reading table './newplatform/party_relationships'
 
pure virtual method called
 
terminate called without an active exception
 
181210  7:52:17 [ERROR] mysqld got signal 6 ;
 
 
 
/lib64/libstdc++.so.6(_ZN9__gnu_cxx27__verbose_terminate_handlerEv+0x165)[0x7fb97090c7d5]
 
/lib64/libstdc++.so.6(+0x5e746)[0x7fb97090a746]
 
/lib64/libstdc++.so.6(+0x5e773)[0x7fb97090a773]
 
/lib64/libstdc++.so.6(+0x5f2df)[0x7fb97090b2df]
 
/usr/sbin/mysqld(_ZN7handler16ha_external_lockEP3THDi+0x133)[0x560a75a71b13]
 
/usr/sbin/mysqld(+0x75bb5b)[0x560a75b4fb5b]
 
/usr/sbin/mysqld(_Z24mysql_unlock_read_tablesP3THDP13st_mysql_lock+0x68)[0x560a75b503a8]
 
/usr/sbin/mysqld(_ZN4JOIN9join_freeEv+0x16b)[0x560a7590e5db]
 
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x9b5)[0x560a75925ba5]
 
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x560a75925e43]
 
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x560a75925f9a]
 
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x560a75926af4]
 
/usr/sbin/mysqld(+0x415562)[0x560a75809562]
 
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x68e2)[0x560a758d5342]
 
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x560a758d7fee]
 
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x20f6)[0x560a758db0c6]
 
/usr/sbin/mysqld(_Z10do_commandP3THD+0x165)[0x560a758dbcc5]
 
/usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0xbf)[0x560a759dff3f]
 
/usr/sbin/mysqld(+0x64cc40)[0x560a75a40c40]
 
/lib64/libpthread.so.0(+0x7e25)[0x7fb971f37e25]
 
/lib64/libc.so.6(clone+0x6d)[0x7fb9702dbbad]
 
 
 
Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x7fb2502e53d0): SELECT po.* FROM product_offers po, product_templates pt, product_types t, party_relationships pr, venues v  WHERE po.producttemplateid = pt.id AND pt.producttypeid = t.id AND po.party_id = pr.to_party_id AND v.party_id = pr.from_party_id AND pr.type = 'VENUE_PRODUCT_OFFER' AND v.id = 2876 AND t.name = 'type_free' AND po.active = 1
 
Connection ID (thread ID): 16175
 
Status: NOT_KILLED

Comment by Alice Sherepa [ 2018-12-13 ]

Thanks for the report!
This is a duplicate of MDEV-17839, please watch the progress there.

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