AnsweredAssumed Answered

[Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: Connections could not be acquired from the underlying database!

Question asked by Miller2012 on Jul 30, 2018
Latest reply on Jul 31, 2018 by Miller2012

Hi all.

 

I have been problems with SNMPC, in 2 occasitons the SNMPC db are corrupted.

 

Now, the procedure it's restore the SnmpCollector.mv, but my question is that this problem is reccurrent in 2 weeks only. This behavior is not normal.

 

I was checking the logs SNMPC and I can see this ------>

 

Starting problem ---->

 

Jul 29 03:01:46:420 [DiscoveryController2, snmpcollector] retry after sql exception General error: "java.lang.IllegalStateException: File corrupted in chunk 8721572, expected page length 4..768, got -775151292 [1.4.194/6]"; SQL statement:
SELECT A0.CONFIGITEMID,A0.DEFAULTINDEXLABEL,A0.DEFAULTLABEL,A0.DEVICEID,A0.METRICFAMILYID,B0.ATTRIBUTION_ID_OID,B0.ID,B0.INTERVALVALUE,A0.SEQUENCEID,A0.SNMPINDEX,C0.ID,C0.SPEEDINOVERRIDE,C0.SPEEDOUTOVERRIDE,A0.VENDORCERTIFICATIONNAME FROM COMPONENT A0 LEFT OUTER JOIN POLLINGINTERVAL B0 ON A0.POLLINGINTERVAL_ID_OID = B0.ID LEFT OUTER JOIN SPEEDOVERRIDE C0 ON A0.SPEEDOVERRIDE_ID_OID = C0.ID WHERE A0.ID = ? [50000-194]
Jul 29 03:01:46:439 [DiscoveryController2, snmpcollector] retry after sql exception General error: "java.lang.IllegalStateException: Reading from retry:D:/Program Files (x86)/Nimsoft/probes/network/snmpcollector/SnmpCollector.mv.db failed; file length 58308400 read length 768 at 139328001 [1.4.194/1]"; SQL statement:
SELECT A0.CONFIGITEMID,A0.DEFAULTINDEXLABEL,A0.DEFAULTLABEL,A0.DEVICEID,A0.METRICFAMILYID,B0.ATTRIBUTION_ID_OID,B0.ID,B0.INTERVALVALUE,A0.SEQUENCEID,A0.SNMPINDEX,C0.ID,C0.SPEEDINOVERRIDE,C0.SPEEDOUTOVERRIDE,A0.VENDORCERTIFICATIONNAME FROM COMPONENT A0 LEFT OUTER JOIN POLLINGINTERVAL B0 ON A0.POLLINGINTERVAL_ID_OID = B0.ID LEFT OUTER JOIN SPEEDOVERRIDE C0 ON A0.SPEEDOVERRIDE_ID_OID = C0.ID WHERE A0.ID = ? [50000-194]

 

Continue...

 

Jul 29 04:01:56:133 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: The database has been closed [90098-194]
Jul 29 04:11:57:174 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: The database has been closed [90098-194]
Jul 29 04:21:58:213 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: The database has been closed [90098-194]
Jul 29 04:31:59:241 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: The database has been closed [90098-194]
Jul 29 04:42:29:420 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: Connections could not be acquired from the underlying database!
Jul 29 04:52:59:570 [Thread-7, snmpcollector] DiscoveryController unable to query for devices in PENDING and FAILED states: Connections could not be acquired from the underlying database!

 

If you need, can check the logs file attached.

 

Why happen this?

 

Maybe? I don't know...

1- Two user open snmpcollector in the same time?

2- The virtual machine where the host running (hubs: s.owindows+snmpc) consume too resource caused that SNMPC corrupted the DB? but the report of health not indicated high consume.

 

Anyone know why happen this? my SNMPC only have "Device Inventory: 63667 components on 194 devices -- 49203 metrics enabled" the memoy is -Xms2048m -Xmx10240m, other keys enabled *DISCOVER_ALL_METRIC_FAMILIES = true, *DB_SERVER_MODE = true

 

Best Regards.

 

M.E

Attachments

Outcomes