[
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)
