an incident on the Alfresco database

[ALfreSara]

Hello,

An incident on the alfresco database. Since yesterday, base locks are present. I don't know what the source of the problem is?  here are the logs I found:

ERROR [alfresco.web.site] [http-bio-8443-exec-55] javax.servlet.ServletException: Possible CSRF attack noted when comparing token in session and request header

INFO [webscripts.connector.RemoteClient] [http-bio-8443-exec-54] Error status 408 Read timed out

DEBUG [impl.solr.DbOrIndexSwitchingQueryLanguage] [http-apr-8080-exec-1] DB query failed for db-afts for SearchParameters [language=fts-alfresco, ... org.alfresco.repo.search.impl.querymodel.QueryModelException: 092213619 The patch to add the indexes to support in-transactional metadata queries has not been applied

[afaust]

"The patch to add the indexes to support in-transactional metadata queries has not been applied"

I guess that is a clear message - the base patch required for TMQ has not been applied, controlled via the system.metadata-query-indexes.ignored property in alfresco-global.properties. Even if that patch has already been applied in the past, the code for TMQ in Alfresco actually checks this property instead of doing a low-level schema check. So the ignored property should never be set back to the default of true.

The other messages are also quite clear, but don't provide enough information for me to suggest what is causing them or how to solve them. I also don't know for sure which of these three are the actual problem that you are encountering, as your problem description is quite vague ("an incident on the Alfresco database" without description of how this manifests for end users).

[ALfreSara]

Thank you for your reply,
what do you propose as a solution?