Bug #119554 CRASH SERVER after Truncate

• Submitted: 15 Dec 16:22
• Reporter: Alexis Amoudru
• Status: Open
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 8.043
• OS: CentOS ( 7.9.2009 (Core))
• CPU Architecture: Any

[15 Dec 16:22] Alexis Amoudru

Description:
CREATE TABLE `test_steph` (   `cp1` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into test_steph values (22);
select * from test_steph;
commit;
truncate test_steph;
Query OK, 0 rows affected (0.02 sec)

we restart server try to trucate same table and we get crashed server .
truncate test_steph;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/mysql/socket/mysql_testbase2.sock' (111)
ERROR:
Can't connect to the server

How to repeat:
we restart server try to trucate same table and we get crashed server .
truncate test_steph;

ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/mysql/socket/mysql_testbase2.sock' (111)
ERROR:
Can't connect to the server