Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-688

Delete failed, several errors

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.0.8
    • Fix Version/s: Icebox
    • Component/s: ExeMgr
    • Labels:
    • Environment:
      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            yang459 Seungmin Yang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.