[MCOL-64] Internal error: CAL0009: Error in dropping table from systables. Created: 2016-05-20  Updated: 2016-08-23  Resolved: 2016-08-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: None
Fix Version/s: 1.0.2

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-35 211 Concurrent Transactions Test failed Closed
Sprint: 1.0.2-2

 Description   

Build tested:

getcalpontsoftwareinfo Fri May 20 13:28:21 2016

Name : infinidb-platform Relocations: (not relocatable)
Version : 5.0 Vendor: MariaDB, Inc.
Release : 0 Build Date: Sun 15 May 2016 07:24:29 PM CDT
Install Date: Mon 16 May 2016 05:21:51 PM CDT Build Host: srvbuilder

This issue was identified autopilot, but it can happen in different tests and I was unable to reproduce it at will. It may have been a result of other issues that previously occurred, such as the issue in MCOL-63.

--------------
drop table update1brows
--------------

ERROR 1815 (HY000) at line 2: Internal error: CAL0009: Error in dropping table from systables.

By the messages, it seems that it had problem removing the table entry from the system catalog.

When dropping the same table after restarting the system, it was successful.

 Comments   
Comment by Daniel Lee (Inactive) [ 2016-05-25 ]

Build tested:

mscadmin> getsoftware
getsoftwareinfo Wed May 25 17:10:38 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Tue 24 May 2016 07:24:06 PM CDT
Install Date: Wed 25 May 2016 12:27:43 PM CDT Build Host: srvbuilder

Executed the same test case with the latest build and did not encounter the issue. As I mentioned in the bug description, restarting the system and trying the same test case again, it was successful. It is difficult to identify the root cause, or even a reproducible scenario, that caused the issue.

Comment by Daniel Lee (Inactive) [ 2016-05-26 ]

The Autopilot test run also showed this issue. Thinking that the concurDDL issue, as described in MCOL-14, occurred prior before this test may have something to do this error, I reran the test skipping concurDDL. The test passed.

Comment by Dipti Joshi (Inactive) [ 2016-08-02 ]

dleeyhCan you close this now ?

Comment by Dipti Joshi (Inactive) [ 2016-08-16 ]

dleeyh Can we closed this now ?

Comment by Daniel Lee (Inactive) [ 2016-08-23 ]

Have been working in the latest 1.0.2-1.

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