column store error: search table error: [23017] Index syncpoint mismatch]

[former_member182302]

Hi Team,

Currently in production when we are running the procedures some times we are facing the below error message:

[2048] (range 3): column store error: search table error:  [23017] Index syncpoint mismatch]

Upon re-run of the procedure it is working fine.

Anyone else faced this issue? Any thoughts?

Regards,

Krishna Tangudu

[former_member182302 · Accepted solution]

Update:

We have raised an Support Incident and it is still "WIP". Meanwhile, I disabled Automatic merge on the Table and was doing a Manual merge from the procedure after the loading is done. It has solved the issue. Found the below trace :

[80414]{1601013}[155/108602087] 2014-11-08 22:00:56.191461 e euclid BwPopAggregateParallel.cpp(01064) : Index syncpoint mismatch;object=SCHEMA_NAME:_SYS_SPLIT_TABLENAME~3en(23017)
[80250]{237874}[95/108602134] 2014-11-08 22:00:58.114087 i TraceContext TraceContext.cpp(00702) : UserName=USERNAME

Still waiting for the message from SAP before checking in production.

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Krishna,

We are just now facing the same issue. Did you ever get any good information from SAP on how to resolve the issue?

Thanks

Freddy Castillo

[lbreddemann · Accepted solution]

SAP note

2062555

SAP HANA SPS 08 Database Revision 83

covers this

The error message is caused by different bugs in different revisions. If you face it in a newer version than rev. 83 please open a support incident.

- Lars

[Former Member]

Hey Krishna,

You can try two things.

I believe those tables has indexes.

Try to include the drop index and recreate index statements in the procedure and see.

like

drop index;

delete the data

insert the data

create index

the second method is manually stop the delta merge for that table,then insert the data and do the delta merge.

I believe this is because of delta merge problem.

Regards,

Venkat N

[former_member182302]

Hi Venkat,

Agreed it to be a delta merge problem. Will check if the tables have any indexes created manually . On the second one , you wanted me to make the delta merge manual? May not be so feasible even if it works as this is a production case.

Regards,

Krishna Tangudu

[patrickbachmann]

I'm not much help but searching briefly I see several mentions of delta merges when receiving this similar error.  Not that it helps you but i'm curious if you see delta merge process running when you receive this error?  I'm sure Lars the great will chime in soon.

-Patrick

[lbreddemann]

You know how to get me to reply

Plus: you seem to be very close with your assumed connection to the delta merge.

I'd guess that this occurs on a not-so-recent revision?

As of

1894285

SAP HANA Appliance: Revision 62 der SAP-HANA-Datenbank

the problem should be fixed.

In case it does still occur afterwards, it's time for a support incident.

- Lars

[patrickbachmann]

I have several methods to summons you Lars.  This is the gentle coax method.  The other is to post some preposterous problem or blatantly inefficient code that you just can't resist commenting on.  Incidentally telepathy never seems to work well for me but I digress. 

[former_member182302]

Thanks as always for your reply .

Currently the HANA Db version is 1.74. I saw the SAP note you shared . Currently the procedures are hitting more errors on delta merge as in the case on the other thread I have opened

seems like a case for sap support incident.

Regards,

Krishna Tangudu

[former_member182302]

Thanks Patrick. Will check today and will let update back here.

Regards,

Krishna Tangudu