org.apache.manifoldcf.core.interfaces.ManifoldCFException

Database exception: SQLException doing query (23503): ERROR: insert or update on table "authconnections" violates foreign key constraint "authconnections_groupname_fkey" Detail: Key (groupname)=(DatafariAuthorityGroup) is not present in table "authgroups".

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 web113

  • Database exception: SQLException doing query (23503): ERROR: insert or update on table "authconnections" violates foreign key constraint "authconnections_groupname_fkey" Detail: Key (groupname)=(DatafariAuthorityGroup) is not present in table "authgroups".
  • via incubator-connectors-user by Erlend Garåsen, 1 year ago
    Database exception: Exception doing query: ERROR: insert or update on table "jobs" violates foreign key constraint "jobs_outputname_fkey" Detail: Key (outputname)=(Solr) is not present in table "outputconnections".
  • Database exception: Exception doing query: ERROR: multiple primary keys for table "filedata" are not allowed
  • Stack trace

    • org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (23503): ERROR: insert or update on table "authconnections" violates foreign key constraint "authconnections_groupname_fkey" Detail: Key (groupname)=(DatafariAuthorityGroup) is not present in table "authgroups". at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:715) at org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:741) at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:784) at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1457) at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146) at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:204) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performModification(DBInterfacePostgreSQL.java:661) at org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.performInsert(DBInterfacePostgreSQL.java:187) at org.apache.manifoldcf.core.database.BaseTable.performInsert(BaseTable.java:68) at org.apache.manifoldcf.authorities.authority.AuthorityConnectionManager.save(AuthorityConnectionManager.java:437) at org.apache.manifoldcf.crawler.system.ManifoldCF.apiWriteAuthorityConnection(ManifoldCF.java:3909) at org.apache.manifoldcf.crawler.system.ManifoldCF.executeWriteCommand(ManifoldCF.java:4172) at org.apache.manifoldcf.apiservlet.APIServlet.executeWrite(APIServlet.java:411) at org.apache.manifoldcf.apiservlet.APIServlet.doPut(APIServlet.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:653) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "authconnections" violates foreign key constraint "authconnections_groupname_fkey" Detail: Key (groupname)=(DatafariAuthorityGroup) is not present in table "authgroups". 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.executeUpdate(AbstractJdbc2Statement.java:334) at org.apache.manifoldcf.core.database.Database.execute(Database.java:916) at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:696)

    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
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    2 times, 1 month ago
    25 times, 7 months ago
    Unknown user
    Once, 10 months ago
    92 more bugmates