Fixed Bug in "cm content-uuid-import'

Fixed a bug in the command-line tool to import content UUIDs (cm content-uuid-import) that could cause failures like IndexOutOfBoundsException.

(CMS-22464)

Third-Party Update: postgresql Driver

postgresql has been updated to version 42.4.3 to avoid reported security vulnerabilities of previous versions.

(CMS-22444)

Third-Party Update: Woodstox

FasterXML Woodstox has been updated to version 6.4.0 to avoid security vulnerabilities of previous versions.

(CMS-22314)

Improved BELOW Content Query Execution

The Content Server executes content queries with "BELOW" folder clause(s) more efficiently now. This is especially true, if the server is not maintaining a folder index. For details, see the description of the 'cm dbindex' tool in the Content Server Manual.

The server now uses more efficient SQL queries (recursive common table expressions) to query the database, if no folder index was created. The query performance for BELOW queries with enabled folder index will still be slightly better, but the performance difference got a lot smaller, and query performance without folder index can be acceptable for many use cases. In case of problems, the old less efficient implementation can still be enabled by setting Content Server configuration property sql.store.use-ctes-for-below-queries=false.

Some improvements have also been made for query execution with enabled folder index. In rare cases a content query never returned if PostgreSQL was used as database. This has been fixed.

If the folder index is enabled, queries have to wait for the index to be up-to-date, which may take some time after large folders have been moved. In rare cases, this can take quite a long time and block querying applications. A timeout has been added now, so that waiting queries will be executed without the folder index, if the folder index isn't available for some time. The timeout can be set with the Content Server configuration property sql.store.folder-index-timeout and defaults to 1 minute.

(CMS-21264)

Fixed CAE Feeder Possible Deadlock

Fixed a bug that could lead to a dead lock of the CAE Feeder in case of cyclic navigation structures.

(CMS-19571)