process hdbxsengine not running

[Former Member]

Hi everyone

My hana can't start because suse11 power off by inspection of the electric.

Error information : FAIL: process hdbxsengine HDB XSEnging not running

What information do you need to tell me that I will upload .

Thanks!

Message was edited by: Tom Flanagan

[former_member182967]

Hello Lion,

Please check the trace and alert files related to xsengine under directory /usr/sap/<SID>/HDB<instance numer>/<hostname>/trace to find the possible reason.

Regards,

Ning

[Former Member]

Hi Ning

The log had upload that says "log position inconsistency detected - plz contact to HANA dev support before clearing or throwing away your redo log files"

http://fanyi.baidu.com/translate?aldtype=16047&query=back+part+of&keyfrom=baidu&smartresult=dict&lan...

I have not changed the settings of the log,  can you see what the problem?

Thanks!

[former_member182967]

Hi Lion,

It is strange that the hostname in alert file and hostname in attached pic is not same. Please chech the reason. If neccessary, please open an incident to SAP support.

Regards,

Ning Tong

[former_member49369]

Hello Lion,

Could you find the solution? Because I'm having the same issue and I've tried many things, but anything is working.

Thanks,

AC

[Former Member]

I have the same issue occuring today after power stonith shutdown.

same log inconsistency.

[former_member183326]

Have you thought about reinitializing the Xsengine? This worked for me before on a test system. I Wouldn't recommend this if you have applications using it though. If they are log segments that are missing, You have to find where they moved. Check if  log segment is truncated, if it is then you could "touch" log segment to create a dummy but I would only do this if the log is truncated.

[Former Member]

Hi Lion

It looks like your OS got crashed. First please do a clean restart of DB after running following command if possible

HDB stop

cleanipc <SYS NR> remove

HDB start

If the same issue exists, you can upload xsengine_<hostname>*.trc from

/usr/sap/<SID>/HDBXX/<host>/trace to find the root cause.

Thanks

[Former Member]

Hi, Chinmaya

Attachment is the back part of the original I intercepted.

First    HDB stop , second cleanipc 00 remove ,last HDB start.

But the same issue exists

Read the log ,I only see the following question:

Possible root cause:

exception  1: no.2100002  (ptime/storage/recovery/RowStoreTransactionCallback.cc:418)

    log position inconsistency detected - plz contact to HANA dev support before clearing or throwing away your redo log files

Don't know  you hava any other suggestions.

xsengine_alert_vhcalhdbdb.txt.zip

xsengine_vhcalhdbdb.30207.044.txt.zip

[Former Member]

I did try the cleanipc which I saw in another post.  It didn't work. I eventually reinstalled my secondary, then my primary, then restored from a recent backup.  Oddly the backup had volumes 0_1, 1_1, 2_1 and 4_1.  I was fairly nervous, but it worked to get me to the state I was at prior to configuring pacemaker.  It's a short putt from there.

Thanks much for the support.