---

Subject:	And to follow on to this,
Author:	[Not Specified]
Posted:	2014-11-18 07:49

And to follow on to this, after running zenossdbpack, often times poskeyerrors show up.
Just now I ran zenossdbpack by hand, it removed a bunch of things:

2014-11-18 08:27:26,620 [relstorage.adapters.packundo] INFO pack: removed 430300 (99.1%) state(s)
2014-11-18 08:27:27,571 [relstorage.adapters.packundo] INFO pack: cleaning up
2014-11-18 08:28:51,306 [relstorage.adapters.packundo] INFO pack: finished successfully

2014-11-18 08:29:01,058 [relstorage.adapters.packundo] INFO pack: removed 16500 (99.9%) state(s)
2014-11-18 08:29:01,065 [relstorage.adapters.packundo] INFO pack: cleaning up
2014-11-18 08:29:01,380 [relstorage.adapters.packundo] INFO pack: finished successfully

And now when I run zodbscan:

12 Dangling References

2014-11-18 08:44:28,286 CRITICAL zodbscan: DANGLING REFERENCE (POSKeyError) FOUND:
PATH: zport/dmd/Devices/Network/Router/Cisco/devices/MIGTORSW05/os/interfaces/FastEthernet0_1
TYPE:
OID: 0x006b7d5a '\x00\x00\x00\x00\x00k}Z' 7044442
Refers to a missing object:
NAME: None
TYPE:
OID: 0x006b7e22 '\x00\x00\x00\x00\x00k~"' 7044642
2014-11-18 08:44:28,302 CRITICAL zodbscan: DANGLING REFERENCE (POSKeyError) FOUND:
PATH: zport/dmd/Devices/Network/Router/Cisco/devices/MIGTORSW05/os/interfaces/FastEthernet0_1
TYPE:
OID: 0x006b7d5a '\x00\x00\x00\x00\x00k}Z' 7044442
Refers to a missing object:
NAME: None
TYPE:
OID: 0x006b7e23 '\x00\x00\x00\x00\x00k~#' 7044643

etc

There are serious database integrity issues with the tools here...

I am running 4.2.5 SP203

---

Subject:	Have you tried running
Author:	[Not Specified]
Posted:	2014-11-18 11:50

Have you tried running findposkeyerror -f and zenrelationscan -f from the toolbox Do those detect and/or address the PKE issues that you found

---

Subject:	No they don't, these only
Author:	[Not Specified]
Posted:	2014-11-18 12:37

No they don't, these only show up in zodbscan.

---

Subject:	Possible code segment to help (fails to format properly)
Author:	[Not Specified]
Posted:	2014-11-18 15:36

Dpirmann, here is a segment of code (shared with me from another) - perhaps you can adapt this for your instance

def fixRels(obj):
for name,relobj in obj._relations:
try:
getattr(obj, name)()
continue
except Exception:
try:
obj._delOb(name)
except Exception:
pass
obj._setObject(name, relobj.createRelation(name))
commit()

##################

for iface in dev.os.interfaces():
fixRels(iface)
try:
iface.index_object()
except POSKeyError:
dev.os.interfaces._delOb(iface.id)
commit()