[MCOL-3487] When version buffer is overflowed, no error message returned Created: 2019-09-06  Updated: 2019-11-04  Resolved: 2019-11-04

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

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


 Description   

Build tested: 1.4.0-1

[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159

autopilot test case: systemTest.versionBuffer

No error message is returned. It returned a warning instead.

MariaDB [tpch100c]> select count from lineitem;
-----------

count

-----------

600037902

-----------
1 row in set (5.835 sec)

MariaDB [tpch100c]> update lineitem set l_orderkey=-1
-> ;
Query OK, 0 rows affected, 1 warning (9 min 18.166 sec)
Rows matched: 0 Changed: 0 Warnings: 1

MariaDB [tpch100c]> show warnings
-> ;
--------------------------------------------------------------------------------------------------------------------------------------------------------------

Level Code Message

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Error 1815 Internal error: CAL0002: Update Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed.

--------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.000 sec)



 Comments   
Comment by Jose Rojas (Inactive) [ 2019-10-09 ]

Doesn't appear to be an issue anymore. I was able to get the version buffer overflow error in the latest code on develop branch (1.4)

Comment by Daniel Lee (Inactive) [ 2019-10-11 ]

Build tested: 1.4.1-1

[dlee@master centos7]$ cat gitversionInfo.txt
engine commit:
5a4c406

I tested the latest build from buildbot today and the issue still exist.

MariaDB [mytest]> update lineitem set l_orderkey=-1;
Query OK, 0 rows affected, 1 warning (9 min 19.726 sec)
Rows matched: 0 Changed: 0 Warnings: 1

MariaDB [mytest]> show warnings;
--------------------------------------------------------------------------------------------------------------------------------------------------------------

Level Code Message

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Error 1815 Internal error: CAL0002: Update Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed.

--------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.001 sec)

MariaDB [mytest]>

Comment by Jose Rojas (Inactive) [ 2019-10-14 ]

I cannot reproduce. I believe I found a possible reason why i cannot reproduce and why you continue to see the issue.

Looking at the ticket description, it appears you were using mariadb-columnstore-server develop branch (commit 67452bc is in mariadb-columnstore-server). You should be using mariadb/server 10.4 branch.

Please let me know if this is the case, and if it is, please test using mariadb/server 10.4 branch and mariadb-columnstore-engine develop branch

Comment by Daniel Lee (Inactive) [ 2019-11-04 ]

Build verified: 1.4.1-1

engine commit:
3e7a964

The issue was discovered in 1.4.0-1 beta source code that I used to build the installation package. I don't know if ColumnStore was migrated to use the server code directly yet at that time. My last test was using 1.4.1-1 package from buildbot so the correct branch should have been used to produce the package, and that package still has the reported issue. I tested the latest packages from buildbot today and it is working correctly now.

MariaDB [tpch100]> select count from lineitem;
-----------

count

-----------

600037902

-----------
1 row in set (5.876 sec)

MariaDB [tpch100]> update lineitem set l_orderkey=-1;
ERROR 1815 (HY000): Internal error: CAL0002: Update Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed.

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