[CONNECTORS-1642] PostgreSQL Version >= 12.2 DB Initialization Problems

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 2.15
• Fix Version/s: ManifoldCF 2.16
• Component/s: Framework core
• Assignee: Karl Wright
• Reporter: Uwe Wolfinger
• Created: 12/May/20 11:48
• Updated: 12/May/20 13:21
• Resolved: 12/May/20 12:38

Description

when trying to run the "./executecommand.sh org.apache.manifoldcf.crawler.InitializeAndRegister" script, the following erro shows up and the initialization process stops:

{{ WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/home/suche/crawler/lib/postgresql-42.1.3.jar) to field java.util.TimeZone.defaultTimeZone}}
{{ WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils}}
{{ WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations}}
{{ WARNING: All illegal access operations will be denied in a future release}}
{{ org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: SQLException doing query (42703): FEHLER: Spalte pg_attrdef.adsrc existiert nicht}}
{{ 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)}}

 

the column "pg_attrdef.adsrc" no longer exists in PostgreSQL DB 12.2.

https://www.postgresql.org/docs/11/catalog-pg-attrdef.html

which means that it is impossible to initialize the core DB in a PostgreSQL  12.2