Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1581

CAL0000: VBBM::getBlocks(): version buffer overflow error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.9
    • Icebox
    • ?
    • None
    • RHEL 7.2

    Description

      Hi all,

      I have MariaDB CS 1.0.9 installed in a single node on RHEL7.2.

      One of my users recently tried to delete records from a ColumnStore table with the error below returned:

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

      I tried altering the table from ColumnStore to InnoDB but faced a similar error:

      {{Jul 18 23:01:44 ods workernode[47824]: 44.562315 |0|0|0| C 30 CAL0000: VBBM::getBlocks(): version buffer overflow. Increase VersionBufferFileSize. Overflow occured in aged blocks. Requested NumBlocks:VbOid:vbFBO:lastFBO = 1:0:27000:27099 lbid locked is 323416308
      Jul 18 23:01:44 ods ddlpackageproc[48579]: 44.566626 |0|0|0| E 23 CAL0001: Alter table Failed: WE: Update failed on: systable}}

      I get the same error when trying to drop the table.

      I've increased the VersionBufferFileSize value in Columnctore.xml to 2GB from 1GB but the problem still persists.

      Is there something else I can do?

      Thanks.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mikelok Mike Lok
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.