[jira] [Resolved] (CONNECTORS-1642) PostgreSQL Version >= 12.2 DB Initialization Problems

["Karl Wright (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CONNECTORS-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-1642.
-------------------------------------
    Fix Version/s: ManifoldCF 2.16
       Resolution: Fixed

r1877648.

Worked fine on Postgresql 9, so I think we should be good.  I would appreciate it if [~wolfingeru] would try this against Postgresql 12.2 however.


> 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
>            Assignee: Karl Wright
>            Priority: Major
>             Fix For: ManifoldCF 2.16
>
>         Attachments: image-2020-05-12-14-34-45-754.png, image-2020-05-12-14-35-41-885.png
>
>
> 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)