[MCOL-21] Create table failed due to Error updating BRM block version buffer overflow error Created: 2016-05-03  Updated: 2016-10-07  Resolved: 2016-10-07

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

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

Issue Links:
PartOf
is part of MCOL-280 Beta issues Closed

 Description   

"MariaDB [mytest]> create table t1 (c1 int) engine=infinidb;
ERROR 1815 (HY000): Internal error: CAL0009: Create table failed due to WE: Error updating calpontsys.systable:BRM block version buffer overflow error.
"
I run an overnight test and found this. Normally, when a DML statement hits a version buffer limit, the statement would fail and rollback. Now there is nothing else running in the system and the system is still in the version buffer full state. I restarted InfiniDB and it worked fine.

 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-05-23 ]

dleeyhCan you retest it ?

Comment by Dipti Joshi (Inactive) [ 2016-05-31 ]

dleeyhThis was created as a result of Auto Pilot testing in February - please reproduce with latest build - if it is not reproducible close this.

Comment by Daniel Lee (Inactive) [ 2016-06-02 ]

It was still an issue earlier this week. If no fix applied this week, I assume it is still an issue.

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

dleeyh Please test this against 1.0.2 and close if it is fixed.

Comment by David Thompson (Inactive) [ 2016-09-21 ]

Please retest with 1.0.3

Comment by Daniel Lee (Inactive) [ 2016-10-07 ]

Build verified:

mcsadmin> getsoft
getsoftwareinfo Tue Oct 4 22:29:41 2016

Name : mariadb-columnstore-platform
Version : 1.0.4
Release : 1
Architecture: x86_64
Install Date: Tue 04 Oct 2016 01:38:36 PM CDT
Group : Applications/Databases
Size : 11506458
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.4-1.src.rpm
Build Date : Fri 30 Sep 2016 01:02:40 PM CDT

MariaDB [mytest]> create table t1 (c1 int) engine=infinidb;
Query OK, 0 rows affected (7.05 sec)

MariaDB [mytest]> desc t1;
---------------------------------+

Field Type Null Key Default Extra

---------------------------------+

c1 int(11) YES   NULL  

---------------------------------+
1 row in set (0.01 sec)

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