Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
6.1.1
-
None
Description
Create table fails with below error:
Error Code: 1815
Internal error: CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.
Drop table fails with below error:
Error Code: 1815
Internal error: CAL0009: Error in dropping table from systables.
-----------------------------------------------------------
Able to reproduce and issue is affecting create/drop for any table:
USE dm_temp;
CREATE TABLE bug
(
a INT
) ENGINE=Columnstore;
2 queries executed, 1 success, 1 errors, 0 warnings
Query: use dm_temp
0 row(s) affected
Execution Time : 0.002 sec
Transfer Time : 0 sec
Total Time : 0.002 sec
-----------------------------------------------------------
Query: Create table bug ( a int) ENGINE=Columnstore
Error Code: 1815
Internal error: CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 1.180 sec
USE dm_fait;
DROP TABLE fait_ra_temp;
2 queries executed, 1 success, 1 errors, 0 warnings
Query: use dm_fait
0 row(s) affected
Execution Time : 0.002 sec
Transfer Time : 0 sec
Total Time : 0.003 sec
-----------------------------------------------------------
Query: DROP TABLE fait_ra_temp
Error Code: 1815
Internal error: CAL0009: Error in dropping table from systables.
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.199 sec
in both cases the error message mentions "systables"
from debug.log
Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.036919 |459|89631|0| D 23 CAL0041: Start SQL statement: DROP TABLE `dm_fait`.`fait_ra_temp`;|dm_fait|
Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.132245 |459|89631|0| D 23 CAL0042: End SQL statement
Oct 8 06:13:59 pixid-csx2 ddlpackageproc[4772]: 59.133153 |0|0|0| E 23 CAL0009: Error in dropping table from systables.
...
Oct 8 08:07:06 pixid-csx2 ddlpackageproc[4772]: 06.458682 |53185|89640|0| D 23 CAL0041: Start SQL statement: CREATE TABLE bug#012(#012a INT#012) ENGINE=Columnstore;|dm_temp|
Oct 8 08:07:07 pixid-csx2 ddlpackageproc[4772]: 07.489148 |53185|89640|0| D 23 CAL0042: End SQL statement
Oct 8 08:07:07 pixid-csx2 ddlpackageproc[4772]: 07.490066 |0|0|0| E 23 CAL0009: (2)Create table failed due to WE: Error updating calpontsys.systable: a BRM Begin copy error.
Oct 8 08:07:28 pixid-csx2 ddlpackageproc[4772]: 28.601530 |53185|89641|0| D 23 CAL0041: Start SQL statement: CREATE TABLE bug ( a INT ) ENGINE=Columnstore;|dm_temp|