[MCOL-115] Auto rollback is not occur when update caused a version-buffer-full error (autocommit=1) Created: 2016-06-09  Updated: 2016-10-06  Resolved: 2016-10-06

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

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

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

 Description   

Build tested:

mscadmin> getsoft
getsoftwareinfo Thu Jun 9 16:41:20 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Wed 08 Jun 2016 09:45:36 AM CDT
Install Date: Thu 09 Jun 2016 08:12:14 AM CDT Build Host: srvbuilder

When autocommit=1, if Update (have not tested other DML commands) caused a version-buffer-full error, the updated data should be rolled back. In Columnstore, such rollback is not automatically triggered anymore.

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

dleeyh Please test this against 1.0.2 and update Affects Version - if it is still happening, other wise close it.

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

Please retest.

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

Build verified: 1.0.4-1

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 [tpch1c]> select count from lineitem where l_shipdate = '2016-10-07';
----------

count

----------

0

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

MariaDB [tpch1c]> update lineitem set l_shipdate='2016-10-07';
ERROR 1815 (HY000): Internal error: CAL0002: Update Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed.
MariaDB [tpch1c]> select count from lineitem where l_shipdate = '2016-10-07';
----------

count

----------

0

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

debug.log

Oct 6 18:15:33 mdbe dmlpackageproc[15311]: 33.829356 |4|63|0| D 21 CAL0001: SQL statement erroring out, received all messages from WES
Oct 6 18:15:33 mdbe dmlpackageproc[15311]: 33.829514 |4|63|0| D 21 CAL0001: End SQL statement with error
Oct 6 18:15:33 mdbe dmlpackageproc[15311]: 33.842353 |0|0|0| E 21 CAL0002: Update Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed.
Oct 6 18:15:33 mdbe messagequeue[15311]: 33.843168 |0|0|0| W 31 CAL0071: InetStreamSocket::read: timeout during readToMagic: socket read error: Success; InetStreamSocket: sd: 19 inet: 127.0.0.1 port: 8630; Will retry.
Oct 6 18:15:33 mdbe ExeMgr[15142]: 33.844413 |4|0|0| D 16 CAL0042: End SQL statement
Oct 6 18:15:33 mdbe dmlpackageproc[15311]: 33.849552 |4|63|0| D 21 CAL0001: Start SQL statement: ROLLBACK

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