Issue with SQL query in the 'website' workspace

[Paul]

Has anyone experienced a situation where SQL queries (e.g. SELECT * FROM [mgnl:page]) in the 'website' workspace stopped working in the JCR Tools app on the author instance? They still work fine on the public instance.

[Christian Menzel]

Hi Paul,

“stopped working”? You mean the queries are not returning results?

Try recreating the index.

Best

Christian

On 18. April 2025 at 10:58:59, Paul (pawel.og...@gmail.com) wrote:

Has anyone experienced a situation where SQL queries (e.g. SELECT * FROM [mgnl:page]) in the 'website' workspace stopped working in the JCR Tools app on the author instance? They still work fine on the public instance.

--
You received this message because you are subscribed to the Google Groups "Magnolia User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to user-list+...@magnolia-cms.com.
To view this discussion, visit https://groups.google.com/a/magnolia-cms.com/d/msgid/user-list/9bc6c8ea-53f8-442d-a444-e421c0e1bf64n%40magnolia-cms.com.

[Paul]

Hi Christian, thanks for your reply.

This situation was due to an error:

ERROR che.jackrabbit.core.query.OnWorkspaceInconsistency: Node {path} (263f88e1-96b8-41ba-9ebb-131d977eae11) has missing child '{name}' (d0a4f676-a6dd-4bc0-b520-72cb036be62c)
2025-04-18 13:23:58 2025-04-18 11:23:58,637 ERROR org.apache.jackrabbit.core.RepositoryImpl : Unable to initialize workspace 'website'

This Jackrabbit configuration helped me:

<param name="forceConsistencyCheck" value="true" />
<param name="enableConsistencyCheck" value="true" />
<param name="consistencyCheck" value="true" />
<param name="consistencyFix" value="true" />