I have openfire pubsub db populated with 5 million subscriptions. now when I restart openfire, it randomly throws ‘node not found’ for some nodes. If I restart again a different set of nodes start throwing this error. Seems like a cache issue. Is there a way to increase the pubsub cache in openfire?
Shouldn’t it be looking up nodes from db when it is not found in cache instead of returning node not found? When I reduce the number of subscriptions to 3million, it seems to work fine. The number of nodes is around 100K in both these cases. I am using Oracle Enterprise Edition for the db. Any help is greatly appreciated.