I am looking at the xdb pools database on a 9.0.1 instance. I see 3 tables with data in them:
- GenericProcessingPools
- GenericProcessingPoolDefinitions
- InteractionLiveProcessingPool
The InteractionLiveProcessingPool
had a backlog of items to process. I have cleared the error that was preventing records from processing. The number of rows in this table is steadily going down, and should clear itself out after about 9 days; it's a long time, but it's better than where it was at.
The GenericProcessingPools
is still steadily increasing, and it looks like records aren't being processed at all. Attempts is 0 for most rows.
A few questions:
- What does the information in this table represent?
- Should it be going down like the other table(s)?
- Is there a good place to look to see why it's not decreasing?
I am monitoring the processing server logs, and have successfully cleared all errors. I am wondering where else I should be looking, or if I should just be ignoring that table.