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

Uwe Wolfinger updated CONNECTORS-1642:
--------------------------------------
    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|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

  was:
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


> 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
>            Priority: Major
>
> 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)

Reply via email to