Skip to Content
0

Delta Merge Error in Hana 1.0 SP12

Jan 24 at 03:21 PM

179

avatar image

Hi All,

I am very new to hana from DB2 background and i have an issue please help

This query:

SELECT * FROM CTR_PARM WHERE CTR_PARM.PARM_SBJ IN ('BDV_AD_BH_PD_AC_TRSR','BDV_AD_BHS_PYMT_AC_RISK_CLASS') AND VAL_TP = 'S'

Delivers 2 rows while this query:

SELECT * FROM CTR_PARM WHERE CTR_PARM.PARM_SBJ IN ('BDV_AD_BH_PD_AC_TRSR','BDV_AD_BHS_PYMT_AC_RISK_CLASS') AND VAL_TP = 'S' AND PARM_CODE = 'FULL_LOAD'

Delivers 4 rows!!!!

We tried MERGE DELTA OF MD.CTR_PARM to make sure it was not a problem with the delta cache but this wasn’t successful:

MERGE DELTA OF MD.CTR_PARM

Could not execute 'MERGE DELTA OF MD.CTR_PARM' in 13 ms 467 µs . SAP DBTech JDBC: [2048]: column store error: merge delta index error: [2487] table optimization was not possible due to open metadata changes;delta merge

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dilip Deenadayalan Jan 24 at 03:39 PM
0

This is what i see in index server log ,

There are duplicate column ids for table MD:CTR_PARM (t 28387) in metadata: [210 (2 occurrences)]. Merge not possible.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

seems to be there is something wrong during creation/filling of this table. How do you created and filled it?

execute a consistency check on the table:

CALL CHECK_CATALOG('CHECK','MD','CTR_PARM',NULL);
CALL CHECK_TABLE_CONSISTENCY ('CHECK','MD','CTR_PARM');                          
0

Hi Jens ,

i tried your syntax and it failed with error

CALL CHECK_CATALOG('CHECK','MD','CTR_PARM',NULL);

Could not execute 'CALL CHECK_CATALOG('CHECK','MD','CTR_PARM',NULL)' in 4 ms 798 µs . SAP DBTech JDBC: [293]: argument type mismatch: could not execute without type

I tried CALL CHECK_CATALOG('CHECK','MD','CTR_PARM','TABLE') and this went fine and i dont see any output so hope it is fine and same for CALL CHECK_TABLE_CONSISTENCY ('CHECK','MD','CTR_PARM'); this went fine with no output .

Thanks

0
Dilip Deenadayalan

No, output is good for the consitency check.

Check Delta Merge stats for the table:

SELECT * FROM SYS.M_DELTA_MERGE_STATISTICS where table_name='CTR_PARM' ORDER BY START_TIME DESC;

Force a compression and try if this is working:

UPDATE “MD”.”CTR_PARM″ WITH PARAMETERS (‘OPTIMIZE_COMPRESSION’ = ‘FORCE’);

Check MVCC blockers:

SELECT CASE WHEN A.START_MVCC_TIMESTAMP = B.MIN_MVCC_SNAPSHOT_TIMESTAMP THEN 'GLOBAL' ELSE 'TABLE' END TYPE,             CASE WHEN A.START_MVCC_TIMESTAMP = B.MIN_MVCC_SNAPSHOT_TIMESTAMP THEN NULL ELSE 'check M_TABLE_SNAPSHOTS for details' END INFO,             SECONDS_BETWEEN(A.LAST_ACTION_TIME, CURRENT_TIMESTAMP) IDLE_TIME_SEC, A.*, C.ES_SNAPSHOT_COUNT, C.ES_SNAPSHOTS                 FROM SYS.M_ACTIVE_STATEMENTS AS A JOIN SYS.M_MVCC_OVERVIEW AS B ON A.HOST = B.HOST AND A.PORT = B.PORT                     JOIN SYS.M_TRANS_TOKENS AS C ON A.HOST = C.HOST AND A.PORT = C.PORT AND A.STATEMENT_ID = C.STATEMENT_ID                     JOIN SYS.M_MVCC_SNAPSHOTS AS V ON A.STATEMENT_ID = V.STATEMENT_ID                 WHERE A.START_MVCC_TIMESTAMP > 0 AND A.STATEMENT_STATUS <> 'NONE' AND V.MVCC_SNAPSHOT_TIMESTAMP > 0 AND V.MVCC_SNAPSHOT_TIMESTAMP <= B.MIN_MVCC_SNAPSHOT_TIMESTAMP                     ORDER BY IDLE_TIME_SEC DESC

Table locks:

SELECT * FROM SYS.M_TABLE_LOCKS where table_name = 'CTR_PARM'

"merge delta index error: [2487] table optimization was not possible due to open metadata changes;delta merge"

=> seems to be strange if it happens more than one time

=> try the delta merge again and have a closer look at the indexserver*.trc

Regards,

Jens

0

hopefully application team created and filling it up with data and i dont have an idea about the past as i newly joined the organisation .

0

Hi jens ,

what i see now is

SELECT * FROM SYS.M_DELTA_MERGE_STATISTICS where table_name='CTR_PARM' ORDER BY START_TIME DESC;

HOST;PORT;TYPE;SCHEMA_NAME;TABLE_NAME;PART_ID;HISTORY;MEMORY_MERGE;PASSPORT;START_TIME;EXECUTION_TIME;MOTIVATION;SUCCESS;MERGED_DELTA_RECORDS;LAST_ERROR;ERROR_DESCRIPTION hanasot01;33.103;MERGE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 14:30:09.288;66;HARD;FALSE;0;2.048;column store error: [2487] table optimization was not possible due to open metadata changes hanasot01;33.103;SPARSE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 14:29:52.375;14;HARD;FALSE;-1;2.048;column store error: [6939] AttributeEngine: commit() or rollback() was called without calling prepare() first hanasot01;33.103;RECLAIM;MD;CTR_PARM;0;FALSE;TRUE;;30-jan-2018 14:05:48.357;3;AUTO;TRUE;5.142;0; hanasot01;33.103;MERGE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 14:04:48.022;5;AUTO;FALSE;0;2.048;column store error: [2487] table optimization was not possible due to open metadata changes hanasot01;33.103;SPARSE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 13:57:23.613;16;HARD;FALSE;-1;2.048;column store error: [6939] AttributeEngine: commit() or rollback() was called without calling prepare() first hanasot01;33.103;SPARSE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 13:18:37.476;20;HARD;FALSE;-1;2.048;column store error: [6939] AttributeEngine: commit() or rollback() was called without calling prepare() first hanasot01;33.103;RECLAIM;MD;CTR_PARM;0;FALSE;TRUE;;30-jan-2018 13:04:07.251;4;AUTO;TRUE;5.142;0; hanasot01;33.103;MERGE;MD;CTR_PARM;0;FALSE;FALSE;;30-jan-2018 13:03:06.903;6;AUTO;FALSE;0;2.048;column store error: [2487] table optimization was not possible due to open metadata changes

Could not execute 'UPDATE MD.CTR_PARM WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'FORCE')' in 23 ms 938 µs . SAP DBTech JDBC: [2048]: column store error: process parameters error: [6939] exception 6939: CS/OptimizeCompression/Helper.cpp:1059 AttributeEngine: commit() or rollback() was called without calling prepare() first

No table lock as well and when i tried delta merge again it is still the same error

Could not execute 'MERGE DELTA OF MD.CTR_PARM' in 9 ms 999 µs . SAP DBTech JDBC: [2048]: column store error: merge delta index error: [2487] table optimization was not possible due to open metadata changes;delta merge

This is what i see in index server log

[97330]{419348}[533/-1] 2018-01-30 14:29:52.389355 e optimize_compres Helper.cpp(01063) : changeRowOrder() failed with 'exception 6939: CS/OptimizeCompression/Helper.cpp:1059 AttributeEngine: commit() or rollback() was called without calling prepare() first (6939)' (table=MD:CTR_PARM (t 28387), passport=)

0
Michael Healy
Jan 25 at 12:41 PM
0

Did you recently import this table into HANA?

Share
10 |10000 characters needed characters left characters exceeded
Dilip Deenadayalan Jan 29 at 11:25 AM
0

Nope Michael but what i see from the Log file is it is happening for a long time , thanks

Share
10 |10000 characters needed characters left characters exceeded