org.apache.manifoldcf.core.interfaces.ManifoldCFException

Database exception: Exception doing query: ERROR: out of shared memory Hint: You might need to increase max_pred_locks_per_transaction.

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web120

  • via manifoldcf-user by Erlend Garåsen, 9 months ago
    Database exception: Exception doing query: ERROR: out of shared memory Hint: You might need to increase max_pred_locks_per_transaction.
  • via manifoldcf-user by Erlend Garåsen, 9 months ago
    Database exception: Exception doing query: ERROR: out of shared memory Hint: You might need to increase max_pred_locks_per_transaction.
  • via manifoldcf-user by Markus Schuch, 1 year ago
    Database exception: SQLException doing query (HY0000): You need to set exactly 3 parameters on the prepared statement
  • Stack trace

    • org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: ERROR: out of shared memory Hint: You might need to increase max_pred_locks_per_transaction. at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:681) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:709) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1394) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performQuery(DBInterfacePostgreSQL.java:803) at org.apache.manifoldcf.crawler.jobs.JobManager.addDocuments(JobManager.java:4089) at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.processDocumentReferences(WorkerThread.java:1932) at org.apache.manifoldcf.crawler.system.WorkerThread$ProcessActivity.flush(WorkerThread.java:1863) at org.apache.manifoldcf.crawler.system.WorkerThread.run(WorkerThread.java:554) Caused by: org.postgresql.util.PSQLException: ERROR: out of shared memory Hint: You might need to increase max_pred_locks_per_transaction. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.manifoldcf.core.database.Database.execute(Database.java:826) at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:641)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    2 times, 5 months ago
    Unknown user
    Once, 1 year ago
    Once, 1 month ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    94 more bugmates