Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-1642

PostgreSQL Version >= 12.2 DB Initialization Problems

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • ManifoldCF 2.15
    • ManifoldCF 2.16
    • Framework core
    • None

    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

      Attachments

        1. image-2020-05-12-14-34-45-754.png
          7 kB
          Uwe Wolfinger
        2. image-2020-05-12-14-35-41-885.png
          8 kB
          Uwe Wolfinger

        Activity

          People

            kwright@metacarta.com Karl Wright
            wolfingeru Uwe Wolfinger
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: