Problem:
There is a backlog of bucket table files located in $SPECROOT/MySQL/data/reporting directory.
These could be labeled as modelavailxxxxxx.MYI/MYD/FRM.
A Null Pointer Exception is thrown in the tomcat log file located in $SPECROOT/tomcat/logs
stdout.log on Windows and catalina.out on *nix.
Caused by: java.lang.NullPointerException
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.isClusterEntityType(AvailabilityHandler.java:1295)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.handleUnplannedOutageEvent(AvailabilityHandler.java:1234)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.handleEvent(AvailabilityHandler.java:891)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.doProcessResultSet(AvailabilityHandler.java:521)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler.access$000(AvailabilityHandler.java:70)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AvailabilityHandler$HistoricalUpdate.processBucketRecords(AvailabilityHandler.java:418)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.AbstractBucketReader.readBucket(AbstractBucketReader.java:149)
at com.aprisma.spectrum.app.repmgr.dc.event.handler.BucketReaderScheduler$ScheduledReader.run(BucketReaderScheduler.java:133)
at com.aprisma.util.thread.JobQueue.runJobThread(JobQueue.java:237)
at com.aprisma.util.thread.JobQueue.access$000(JobQueue.java:31)
at com.aprisma.util.thread.JobQueue$JobRunnable.run(JobQueue.java:40)
at java.lang.Thread.run(Thread.java:745)
Hypothesis:
This is caused by Spectrum Report Manager (SRM) database corruption.
SRM is looking for a model_key for deleted models but cannot find it.
This causes SRM to issue a null pointer exception (above) and stop processing those buckets.
Resolution:
CA Support and Engineering have a fix for this issue.
Patch H03_D97 is available for 9.3 H03.
Please contact CA Support if you require this patch or need it for another version.
Support will cross check to confirm this patch will resolve the issue.