topic PCM+ 3.10 database tables crash in Switches, Hubs, and Modems

PCM+ 3.10 database tables crash

Massimo Poletti_1 — Mon, 12 Apr 2010 09:16:30 GMT

Today I was unable to log in to PCM+. A search for the manager server gave me no results.

Doing a mysqlcheck on netmgmt database on the manager server, the result was:

Repairing tables
netmgmt.customgrouptable
Error : Table 'netmgmt.customgrouptable' doesn't exist
error : Corrupt
netmgmt.implicitgrouptable
Error : Table 'netmgmt.implicitgrouptable' doesn't exist
error : Corrupt
netmgmt.nodeinfoentrytable
Error : Table 'netmgmt.nodeinfoentrytable' doesn't exist
error : Corrupt
netmgmt.radioclienttable
Error : Table 'netmgmt.radioclienttable' doesn't exist
error : Corrupt
netmgmt.radioneighbortable
Error : Table 'netmgmt.radioneighbortable' doesn't exist
error : Corrupt
netmgmt.radiossidtable
Error : Table 'netmgmt.radiossidtable' doesn't exist
error : Corrupt
netmgmt.segmentmapentrytable
Error : Table 'netmgmt.segmentmapentrytable' doesn't exist
error : Corrupt
netmgmt.trafficnodetable
Error : Table 'netmgmt.trafficnodetable' doesn't exist
error : Corrupt

Any suggestion for recreate the tables?
Why did they disappear?

Thanks
Massimo

Re: PCM+ 3.10 database tables crash

Javed Padinhakara — Tue, 13 Apr 2010 05:16:45 GMT

maybe giving some background might help?
- was this same installation up and running before?
- was there some AU applied recently?
- 3.1 was installed as part of migrating from older version or was it fresh install?

Re: PCM+ 3.10 database tables crash

Massimo Poletti_1 — Tue, 13 Apr 2010 05:37:08 GMT

I discovered that my server has some RAM problem.

I'm suspending my question until fixed.

Thanks for now

Re: PCM+ 3.10 database tables crash

Massimo Poletti_1 — Tue, 04 May 2010 11:51:45 GMT

RAM fixed, PCM OK!
Thanks anyway!

Re: PCM+ 3.10 database tables crash

Massimo Poletti_1 — Tue, 04 May 2010 11:52:42 GMT

RAM issues