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

ROLLBACK of a long lasting DML left cluster in unusable state

    XMLWordPrintable

    Details

      Description

      customer execute a cpimport on a table (ok) and then update the rows which fail:

      Jun 30 11:34:11 pixid-csx2 cpimport.bin[10948]: 11.705544 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-6407; db-dm_fait
      Jun 30 11:34:15 pixid-csx2 cpimport.bin[10948]: 15.554126 |0|0|0| I 34 CAL0083: BulkLoad: JobId-6407; finished loading table dm_fait.fait_ra; 0 rows inserted
      Jun 30 11:34:15 pixid-csx2 cpimport.bin[10948]: 15.587454 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-6407; status-SUCCESS
      

      Jun 30 11:34:17 pixid-csx2 dmlpackageproc[8103]: 17.129134 |49785|27517|0| D 21 CAL0001: Start SQL statement:  UPDATE#012#011fait_ra RA#012#011INNER JOIN#012#011#011(#012#012#011#011SELECT#012#011#011#011RA.TIC_ID,#012#011#011#011RA.TII_ID,#012#011#011#011RA.`ORIGINE`,#012#011#011#011MIN(RA_A_SUPP.DATE_CREATION) AS DATE_CREATION_NEW#012#011#011FROM#012#011#011#011fait_ra AS RA#012#011#011#011INNER JOIN fait_ra AS RA_A_SUPP ON#012#011#011#011#011#011RA_A_SUPP.TIC_ID = RA.TIC_ID#012#011#011#011#011AND RA_A_SUPP.TII_ID = RA.TII_ID#012#011#011WHERE#012#011#011#011#011RA_A_SUPP.ENRG_A_SUPP = 1 #012#011#011#011AND RA.ENRG_A_SUPP = 0#012#011#011#011AND RA_A_SUPP.DATE_CREATION <> RA.DATE_CREATION#012#011#011GROUP BY 1,2,3#012#011#011) AS DERIVE ON#012#011#011#011#011RA.TIC_ID = DERIVE.TIC_ID#012#011#011#011AND RA.TII_ID = DERIVE.TII_ID#012#011#011#011AND RA.`ORIGINE` = DERIVE.ORIGINE#012SET#012#011RA.DATE_CREATION = DERIVE.DATE_CREATION_NEW#012WHERE#012#011#011RA.ENRG_A_SUPP = 0#012#011AND DERIVE.DATE_CREATION_NEW <> RA.DATE_CREATION;|dm_fait|
      Jun 30 11:34:17 pixid-csx2 ExeMgr[8071]: 17.200723 |49785|0|0| D 16 CAL0041: Start SQL statement: UPDATE#012#011fait_ra RA#012#011INNER JOIN#012#011#011(#012#012#011#011SELECT#012#011#011#011RA.TIC_ID,#012#011#011#011RA.TII_ID,#012#011#011#011RA.`ORIGINE`,#012#011#011#011MIN(RA_A_SUPP.DATE_CREATION) AS DATE_CREATION_NEW#012#011#011FROM#012#011#011#011fait_ra AS RA#012#011#011#011INNER JOIN fait_ra AS RA_A_SUPP ON#012#011#011#011#011#011RA_A_SUPP.TIC_ID = RA.TIC_ID#012#011#011#011#011AND RA_A_SUPP.TII_ID = RA.TII_ID#012#011#011WHERE#012#011#011#011#011RA_A_SUPP.ENRG_A_SUPP = 1 #012#011#011#011AND RA.ENRG_A_SUPP = 0#012#011#011#011AND RA_A_SUPP.DATE_CREATION <> RA.DATE_CREATION#012#011#011GROUP BY 1,2,3#012#011#011) AS DERIVE ON#012#011#011#011#011RA.TIC_ID = DERIVE.TIC_ID#012#011#011#011AND RA.TII_ID = DERIVE.TII_ID#012#011#011#011AND RA.`ORIGINE` = DERIVE.ORIGINE#012SET#012#011RA.DATE_CREATION = DERIVE.DATE_CREATION_NEW#012WHERE#012#011#011RA.ENRG_A_SUPP = 0#012#011AND DERIVE.DATE_CREATION_NEW <> RA.DATE_CREATION; ||
      Jun 30 11:34:17 pixid-csx2 dmlpackageproc[8103]: 17.291493 |49785|27517|0| D 21 CAL0001: End SQL statement with error
      Jun 30 11:34:17 pixid-csx2 dmlpackageproc[8103]: 17.312027 |0|0|0| E 21 CAL0002: Update Failed:  /home/jenkins/workspace/MariaDBE-Custom-RPM/label/rhel-7/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX_ON_ES_BACKUP_DEBUGSOURCE/storage/columnstore/columnstore/primitives/primproc/columncommand.cpp error on projectResultRG for oid 6409 lbid 111035448: input rids 312,  output rids 0
      Jun 30 11:34:17 pixid-csx2 ExeMgr[8071]: 17.314570 |49785|0|0| D 16 CAL0042: End SQL statement
      Jun 30 11:34:17 pixid-csx2 dmlpackageproc[8103]: 17.334862 |49785|27517|0| D 21 CAL0001: Start SQL statement:  ROLLBACK
      Jun 30 11:34:17 pixid-csx2 dmlpackageproc[8103]: 17.357685 |49785|27517|0| D 21 CAL0001: End SQL statement
      

      query in text:

      UPDATE dm_fait.fait_ra
      INNER JOIN dm_temp.cle_ra ON
      fait_ra.TIC_ID = cle_ra.TIC_ID AND fait_ra.ORIGINE= cle_ra.ORIGINE
      SET
      ENRG_A_SUPP = 1

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              drrtuy Roman
              Reporter:
              massimo.disaro Massimo
              Votes:
              2 Vote for this issue
              Watchers:
              7 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.