Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.0.8
-
RHEL 6.6
Description
I installed MariaDB ColumnStore 1.0.8. I use 1 PM and the storage is internal. I'm dealing with bulk data. For instance, 'test_log' table has 100,000,000 rows.
It succeeded to delete 100,000 rows.
MariaDB [input_test]> delete from test_log where stime < '2017-03-31 00:00:00' limit 100000;
Query OK, 100000 rows affected (9.67 sec)
However, when I tried deleting 1,000,000 rows from test_log table, it shows an error as follows:
MariaDB [input_test]> delete from test_log where stime < '2017-03-31 00:00:00' limit 1000000;
ERROR 1815 (HY000): Internal error: ClientRotator caught exception: InetStreamSocket::write error: Broken pipe – write from InetStreamSocket: sd: 19 inet: 127.0.0.1 port: 8601
I performed the same query again, it succeeded!
MariaDB [input_test]> delete from test_log where stime < '2017-03-31 00:00:00' limit 1000000;
Query OK, 1000000 rows affected (1 min 28.25 sec)
Once I deleted 10,000,000 rows, another error occurred.
MariaDB [input_test]> delete from test_log where stime < '2017-03-31 00:00:00' limit 10000000;
ERROR 2013 (HY000): Lost connection to MySQL server during query
After the error occurred, I couldn't perform other queries with the table because it's locked.
MariaDB [input_test]> delete from test_log where stime < '2017-03-31 00:00:00' limit 10000000;
ERROR 1815 (HY000): Internal error: IDB-2009: Unable to perform the delete operation because DMLProc with PID 21714 is currently holding the table lock for session 2.
MariaDB [input_test]> truncate table test_log;
ERROR 1815 (HY000): Internal error: CAL0009: Truncate table failed: IDB-2009: Unable to perform the DMLProc operation because 21714 with PID 2 is currently holding the table lock for session .
Could you let me know what the problem is? Why do these errors occur? And how can I fix it?
Thank you.