Uwe Wolfinger created CONNECTORS-1642:
-----------------------------------------
Summary: PostgreSQL Version >= 12.2 DB Initialization Problems
Key: CONNECTORS-1642
URL: https://issues.apache.org/jira/browse/CONNECTORS-1642
Project: ManifoldCF
Issue Type: Bug
Components: Framework core
Affects Versions: ManifoldCF 2.15
Reporter: Uwe Wolfinger
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|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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
