[MCOL-1621] Request to Improve Error Handling for Table Locks Created: 2018-08-02  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Chris Calender (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: 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.



 Comments   
Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:30:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.