Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
5.5.2
-
None
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
- duplicates
-
-
- Closed
-
-
-
- Closed
-
-
MCOL-5163 Increase the stability of writing processes: WriteEngineServer, DMLProc, DDLProc
-
- Closed
-
- relates to
-
-
- Closed
-