[MDEV-16656] DROP DATABASE crashes Galera Cluster (all nodes) Created: 2018-07-02  Updated: 2018-10-09  Resolved: 2018-10-01

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Delete, Galera
Affects Version/s: 10.1.32
Fix Version/s: 10.3.11, 10.1.37, 10.2.19

Type: Bug Priority: Critical
Reporter: Aljoscha Dembowsky Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: assertion, crash, galera
Environment:

Ubuntu 16.04 LTS
Intel Xeon E5-2687Wv4 - 12/24t - 3GHz /3.5GHz
128GB DDR4 ECC 2400 MHz
10 Gbit/s Ethernet
2x450gb NVMe SSD RAID 1
MaxScale/HA-Proxy for load balancing

Attachments: Text File big-galera-01_crash.log     Text File big-galera-02_crash.log     Text File big-galera-03_crash.log     File my.conf    

 Description   

Hi,

I tried to delete a database from the cluster when the entire cluster suddenly crashes due to a DROP DATABASE operation. The crash appeared on all nodes at the same time as u can see in the logfiles.

I added all logfiles and our my.cnf which is the same on all three nodes.

If you have any advices for our configuration, please let me know.

Best Regards,

Aljoscha

 Comments   
Comment by Daniel Black [ 2018-07-02 ]

Do you have a list of table names in that database? In particular is there a table name that forms a extension of the database name, like bob and bobs_friends?

Comment by Aljoscha Dembowsky [ 2018-07-02 ]

There are and were no tables in the database, because the project never started and so I wanted to clean up the leftovers.

MariaDB [(none)]> use example-net-live;
 
Database changed
 
MariaDB [example-net-live]> show tables;
 
Empty set (0.00 sec)

Comment by Aljoscha Dembowsky [ 2018-07-19 ]

Another day another db...

Today the whole cluster just locked the query execution while a script tried to drop another database. This time the database was filled with data but still no tables formed like the db name. I had to stop the loadbalancer and kill all threads followed by quick service restart on the nodes. Afterwards the applications went online again.

DB-Name: example-com-dev
Tables: 

wp_*
 
user_*

(* as wildcard)

I will review the logs later and append them to the files above

Comment by Rasmus Johansson (Inactive) [ 2018-09-06 ]

sysprg Can you take a look at this during the next 10.1 sprint?

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