---
** [tickets:#2527] imm: PBE is not regenerated on data inconsistency with sql
constraint error**
**Status:** accepted
**Milestone:** 5.17.08
**Created:** Wed Jul 12, 2017 11:48 AM UTC by Zoran Milinkovic
**Last Updated:** Wed Jul 12, 2017 11:48 AM UTC
**Owner:** Zoran Milinkovic
When PBE detects that the database is corrupted with SQL contraint error code,
PBE should regenerate the database instead of reataching to the existing
database.
PBE inconsistency was detected... PBE exit and reatached:
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[3617]: ER SQL
statement('INSERT INTO objects (obj_id, class_id, dn, last_ccb) VALUES (?, ?,
?, ?)') failed with error code: 19
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[3617]: ER objectToPBE failed
in sqlite_prepare_ccb. Handle is closed - exiting
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO Implementer locally
disconnected. Marking it as doomed 120 <1359, 2d80f> (OpenSafImmPBE)
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO Implementer
disconnected 120 <1359, 2d80f> (OpenSafImmPBE)
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmnd[1645]: WA Persistent back-end
process has apparently died.
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO STARTING PBE process.
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO
pbe-db-file-path:/cluster/storage/clear/coremw/etc/imm.db VETERAN:1 B:0
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: IN arg[0] ==
'/usr/lib64/opensaf/osafimmpbed'
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: IN arg[1] ==
'--recover'
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: IN arg[2] == '--pbe'
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: IN arg[3] ==
'/cluster/storage/clear/coremw/etc/imm.db'
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: NO Successfully
opened pre-existing sqlite pbe file /cluster/storage/clear/coremw/etc/imm.db
Jul 07 10:55:49 fi15-rc-bgf19-20170621 osafimmpbed[5629]: IN
saImmRepositoryInit: SA_IMM_KEEP_REPOSITORY - attaching to repository
.... PBE inconsistency detected again....
Jul 07 10:55:51 fi15-rc-bgf19-20170621 osafimmpbed[5629]: ER SQL
statement('INSERT INTO objects (obj_id, class_id, dn, last_ccb) VALUES (?, ?,
?, ?)') failed with error code: 19
Jul 07 10:55:51 fi15-rc-bgf19-20170621 osafimmpbed[5629]: ER objectToPBE failed
in sqlite_prepare_ccb. Handle is closed - exiting
Jul 07 10:55:51 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO Implementer locally
disconnected. Marking it as doomed 122 <5604, 2d80f> (OpenSafImmPBE)
Jul 07 10:55:51 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO Implementer
disconnected 122 <5604, 2d80f> (OpenSafImmPBE)
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmnd[1645]: WA Persistent back-end
process has apparently died.
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO STARTING PBE process.
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmnd[1645]: NO
pbe-db-file-path:/cluster/storage/clear/coremw/etc/imm.db VETERAN:1 B:0
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: IN arg[0] ==
'/usr/lib64/opensaf/osafimmpbed'
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: IN arg[1] ==
'--recover'
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: IN arg[2] == '--pbe'
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: IN arg[3] ==
'/cluster/storage/clear/coremw/etc/imm.db'
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: NO Successfully
opened pre-existing sqlite pbe file /cluster/storage/clear/coremw/etc/imm.db
Jul 07 10:55:52 fi15-rc-bgf19-20170621 osafimmpbed[6392]: IN
saImmRepositoryInit: SA_IMM_KEEP_REPOSITORY - attaching to repository
.... and the same situation was repeated 5 times until PBE was regenerated.
---
Sent from sourceforge.net because opensaf-tickets@lists.sourceforge.net is
subscribed to https://sourceforge.net/p/opensaf/tickets/
To unsubscribe from further messages, a project admin can change settings at
https://sourceforge.net/p/opensaf/admin/tickets/options. Or, if this is a
mailing list, you can unsubscribe from the mailing list.------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Opensaf-tickets mailing list
Opensaf-tickets@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/opensaf-tickets
