[
https://issues.apache.org/jira/browse/CONNECTORS-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190753#comment-17190753
]
DK commented on CONNECTORS-1648:
--------------------------------
getting this error from initialize script:
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception:
SQLException doing query (42703): ERROR: column pg_attrdef.adsrc does not exist
Position: 447
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:803)
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.performQuery(DBInterfacePostgreSQL.java:837)
at
org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.getTableSchema(DBInterfacePostgreSQL.java:696)
at
org.apache.manifoldcf.core.database.BaseTable.getTableSchema(BaseTable.java:185)
at
org.apache.manifoldcf.agents.agentmanager.AgentManager.install(AgentManager.java:67)
at
org.apache.manifoldcf.agents.system.ManifoldCF.installTables(ManifoldCF.java:112)
at
org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:39)
at
org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60)
Caused by: org.postgresql.util.PSQLException: ERROR: column pg_attrdef.adsrc
does not exist
Position: 447
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at
org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at
org.apache.manifoldcf.core.database.Database.execute(Database.java:902)
at
org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:696)
> PostgreSQL 10,11 and 12 support
> -------------------------------
>
> Key: CONNECTORS-1648
> URL: https://issues.apache.org/jira/browse/CONNECTORS-1648
> Project: ManifoldCF
> Issue Type: Improvement
> Affects Versions: ManifoldCF 2.11, ManifoldCF 2.12, ManifoldCF 2.13,
> ManifoldCF 2.14, ManifoldCF 2.15, ManifoldCF 2.16
> Reporter: DK
> Assignee: Karl Wright
> Priority: Major
> Fix For: ManifoldCF 2.17
>
>
> As per the current documentation, "ManifoldCF has been tested against version
> 8.3.7, 8.4.5 and 9.1 of PostgreSQL. "
> 9.1 release date is Sep 12 , 2011 and EOL on Oct 27 2016 already.
> No support for newer versions.
> This is important to deploy ManifoldCF in an enterprise environment where
> value added service such as HA, Backup and Recovery and Monitoring etc are
> provided by third party vendors. These vendors do not support postgreSql
> versions which are reaching end of life.
> Any plan to test and certify recent versions such as 10,11 and 12.3?
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
