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

Request to Improve Error Handling for Table Locks

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • None
    • Icebox
    • N/A
    • None

    Description

      This is a request to improve an error handling message when the following occurs:

      When trying to run multiple inserts in parallel, one can see an error like the following:

      SQLSTATE[HY000]: General error: 1030 Got error -1 "Internal error < 0 (Not system error)" from storage engine Columnstore
      

      Now this can be expected behavior, but is a little hard to figure out what is going on by the above message.

      In the error log, we see it is due to a table lock:

      Error: Failed to acquire Table Lock of schema_name.table_name; Table currently locked by process-cpimport; pid-1337; session--1....
      

      Thus it would be quite helpful if we could see some of the lock information in the returned error.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            ccalender Chris Calender (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.