TRUNCATE TABLE Hangs in MariaDB

Question

Iam trying to migrate from mysql to mariadb. This time I can face another issue with mariadb.

Sometimes the TRUNCATE TABLE query becomes hang. But in MySQL, this issue doesn't occured.

Can anyone help me in this regard??? Iam a newone in MariaDB.

score 0 · Answer 1 · answered Nov 02 '12 at 07:00

0

Please use :
TRUNCATE [TABLE] tbl_name
If this one is hang means some dependencies is exists on these table.

answered Nov 02 '12 at 07:00

Vikram Jain

But the hang issue only seen in mariadb, why don't this seen in mysql? – Haseena Nov 02 '12 at 07:32
If this one is hang means some dependencies is exists on these table. – Vikram Jain Nov 02 '12 at 07:40

score 0 · Answer 2 · answered Nov 06 '12 at 17:54

0

The problem solved in MariaDB 5.5.27.

answered Nov 06 '12 at 17:54

Moshe L

Iam using the latest version 5.5.28 – Haseena Nov 07 '12 at 04:43
Issue now present in 5.5.28. Is this is an open bug? – Haseena Nov 07 '12 at 05:02
One of my servers has this problem, and the 5.5.27 fixed it. – Moshe L Nov 07 '12 at 14:53
But same issue present in 5.5.27. – Haseena Nov 12 '12 at 06:45
Sad to see. Can you check the 10.0.0 alpha, as they relased today? – Moshe L Nov 12 '12 at 21:52

2 Answers2