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

CAL0002: Delete Failed: IDB-2008: The version buffer overflowed. Increase VersionBufferFileSize or limit the rows to be processed but variable is 64G already

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.2.4, 1.2.5
    • Fix Version/s: 5.6.1
    • Component/s: writeengine
    • Labels:
      None

      Description

      One of our customer encountered the above error, trying to delete a 3 rows table and with the variable mentioned already set to 64 GB.

      A restartSystem has resolved the problem.

      System Info:

      getsysteminfo Mon Sep 9 06:17:59 2019
       
      System columnstore-1
       
      System and Module statuses
       
      Component Status Last Status Change
      ------------ -------------------------- ------------------------
      System ACTIVE Fri Aug 23 10:43:03 2019
       
      Module um1 ACTIVE Fri Aug 23 10:42:54 2019
      Module pm1 ACTIVE Fri Aug 23 10:42:36 2019
      Module pm2 ACTIVE Fri Aug 23 10:42:44 2019
       
      Active Parent OAM Performance Module is 'pm1'
      MariaDB ColumnStore Replication Feature is enabled
      MariaDB ColumnStore set for Distributed Install
       
       
      MariaDB ColumnStore Process statuses
       
      Process Module Status Last Status Change Process ID
      ------------------ ------ --------------- ------------------------ ----------
      ProcessMonitor um1 ACTIVE Fri Aug 23 10:42:00 2019 11832
      ServerMonitor um1 ACTIVE Fri Aug 23 10:42:22 2019 12484
      DBRMWorkerNode um1 ACTIVE Fri Aug 23 10:42:36 2019 12611
      ExeMgr um1 ACTIVE Fri Aug 23 10:42:47 2019 14097
      DDLProc um1 ACTIVE Fri Aug 23 10:42:51 2019 14147
      DMLProc um1 ACTIVE Fri Aug 23 10:43:01 2019 14193
      mysqld um1 ACTIVE Thu Aug 29 13:40:46 2019 2797
       
      ProcessMonitor pm1 ACTIVE Fri Aug 23 10:41:42 2019 9241
      ProcessManager pm1 ACTIVE Fri Aug 23 10:41:49 2019 9650
      DBRMControllerNode pm1 ACTIVE Fri Aug 23 10:42:30 2019 10507
      ServerMonitor pm1 ACTIVE Fri Aug 23 10:42:32 2019 10528
      DBRMWorkerNode pm1 ACTIVE Fri Aug 23 10:42:32 2019 10560
      PrimProc pm1 ACTIVE Fri Aug 23 10:42:36 2019 10630
      WriteEngineServer pm1 ACTIVE Fri Aug 23 10:42:37 2019 10654
       
      ProcessMonitor pm2 ACTIVE Fri Aug 23 10:42:08 2019 9241
      ProcessManager pm2 HOT_STANDBY Fri Aug 23 10:43:01 2019 9813
      DBRMControllerNode pm2 COLD_STANDBY Fri Aug 23 10:42:23 2019
      ServerMonitor pm2 ACTIVE Fri Aug 23 10:42:26 2019 9671
      DBRMWorkerNode pm2 ACTIVE Fri Aug 23 10:42:40 2019 9708
      PrimProc pm2 ACTIVE Fri Aug 23 10:42:44 2019 9725
      WriteEngineServer pm2 ACTIVE Fri Aug 23 10:42:45 2019 9735
       
      Active Alarm Counts: Critical = 1, Major = 4, Minor = 4, Warning = 0, Info = 0
      

        Attachments

          Activity

            People

            Assignee:
            drrtuy Roman
            Reporter:
            rpizzi Rick Pizzi
            Votes:
            1 Vote for this issue
            Watchers:
            9 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.