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

None

Activity

Show:
Greg Thomas
March 27, 2019, 10:20 AM

Note; issue with Oracle was fixed in OF-1657, this issue covers off DB2.

Alexander Metelkin
April 10, 2019, 10:28 AM
Edited

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

Greg Thomas
April 10, 2019, 10:52 AM

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

Davide Petilli
April 10, 2019, 11:53 AM

Hi,

DB2 doesn't have LIMIT, that's why the SQL is failing.

Assignee

Unassigned

Reporter

Greg Thomas

Labels

None

Expected Effort

None

Components

Affects versions

Priority

Major