PubSubPersistenceManager.purgeItems incompatibility with DB2
Description
From the forums;
This is related to .
It looks like the SQL used in the batch to select from OFPUBSUBITEM has a ‘LIMIT’ which is not supported by both Oracle DB and DB2. This makes the purging of OFPUBSUBITEM constantly fail.
Found in 3.9.3, but as far as I can see, it is present in newer versions as well.
Environment
Activity
Note; issue with Oracle was fixed in OF-1657, this issue covers off DB2.
Hello!
I have faced with about the same issue, log is attached below.
Technical details: Windows Server 2008 R2 Standard SP1, Open Fire 4.3.2 x64, DB2 NT64 10.5.5 Express-C
If you're able to provide working SQL for DB2 (it's not something I have ready access to) it may help us get this bug fixed quicker,
For reference, the SQL that is currently failing is:
values for other DBs are at https://github.com/igniterealtime/Openfire/blob/master/xmppserver/src/main/java/org/jivesoftware/openfire/pubsub/PubSubPersistenceManager.java#L64-L103
Greg
Hi,
DB2 doesn't have LIMIT, that's why the SQL is failing.
Assignee
Reporter
Labels
Expected Effort
Ignite Forum URL
Components
Priority
