Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-223

postgres upgrade didnt work right in ddlutils

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • 1.4.0
    • None
    • API
    • None

    Description

      Debian 3.1 (Linux 2.6.22.1.dl380 #1 SMP Thu Aug 2 10:44:26 CEST 2007
      GNU/Linux)
      Postgres 8.4.2 (Debian 1:3.3.5-13)

      Here is the console output:

      $ ./bin/gsh.sh -registry -check
      Using
      GROUPER_HOME: /home/testwww/src/grouper/grouper.binary.1.4.1
      Using
      GROUPER_CONF: /home/testwww/src/grouper/grouper.binary.1.4.1/conf
      Using JAVA: /home/testwww/java/jdk/bin/java
      using MEMORY: 64m-512m
      Grouper starting up: version: 1.4.1, build date: 2009/02/02
      14:43:32, env: testing
      grouper.properties read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.properties
      Grouper current directory
      is: /home/testwww/src/grouper/grouper.binary.1.4.1
      log4j.properties read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/log4j.properties
      Grouper is logging to
      file: /home/testwww/src/grouper/grouper.binary.1.4.1/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
      grouper.hibernate.properties: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.hibernate.properties
      grouper.hibernate.properties:
      grouper@jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb
      sources.xml read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/sources.xml
      sources.xml groupersource id: g:gsa
      sources.xml jdbc source id: jdbc:
      GrouperJdbcConnectionProvider
      (note, might need to type in your response multiple times (Java
      stdin is flaky))
      (note, you can whitelist or blacklist db urls and users in the
      grouper.properties)
      Are you sure you want to schemaexport all tables
      (dropThenCreate=F,writeAndRunScript=F) in db user 'grouper', db
      url
      'jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb'? (y|n):
      y
      Continuing...
      Grouper ddl object type 'Grouper' has dbVersion: 12 and java
      version: 13
      org.apache.ddlutils.model.ModelException: There are multiple
      column with the name id in the table grouper_attributes
      at
      org.apache.ddlutils.model.Database.initialize(Database.java:295)
      at
      org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
      at
      org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
      at
      edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:488)
      at
      edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:155)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at
      edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:167)
      at
      edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:108)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
      at com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
      [com.dawidweiss.invoker.Invoker]
      edu.internet2.middleware.grouper.app.gsh.GrouperShell has thrown
      an exception.
      java.lang.RuntimeException:
      java.lang.reflect.InvocationTargetException
      at
      edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:172)
      at
      edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:108)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
      at com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
      Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at
      edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:167)
      ... 7 more
      Caused by: java.lang.RuntimeException:
      org.apache.ddlutils.model.ModelException: There are multiple
      column with the name id in the table grouper_attributes
      at
      edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:176)
      ... 12 more
      Caused by: org.apache.ddlutils.model.ModelException: There are
      multiple column with the name id in the table grouper_attributes
      at
      org.apache.ddlutils.model.Database.initialize(Database.java:295)
      at
      org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
      at
      org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
      at
      edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:488)
      at
      edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:155)
      ... 12 more

      and here is grouper_error.log:

      2009-02-09 15:50:26,049: [main] WARN
      ApiConfig.printConfigOnce(186) - Grouper starting up: version:
      1.4.1, build date: 2009/02/02 14:43:32, env: testing
      grouper.properties read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.properties
      Grouper current directory
      is: /home/testwww/src/grouper/grouper.binary.1.4.1
      log4j.properties read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/log4j.properties
      Grouper is logging to
      file: /home/testwww/src/grouper/grouper.binary.1.4.1/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties
      grouper.hibernate.properties: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.hibernate.properties
      grouper.hibernate.properties:
      grouper@jdbc:postgresql://identity-store.zedat.fu-berlin.de:5713/testfurzdb
      sources.xml read
      from: /home/testwww/src/grouper/grouper.binary.1.4.1/conf/sources.xml
      sources.xml groupersource id: g:gsa
      sources.xml jdbc source id: jdbc:
      GrouperJdbcConnectionProvider
      2009-02-09 15:50:35,664: [main] ERROR
      GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl object type
      'Grouper' has dbVersion: 12 and java version: 13

      HTH

      Loris

      On Mon, 2009-02-09 at 09:45 -0500, Chris Hyzer wrote:
      > How did you try to upgrade the DB? With:
      >
      > gsh -registry -check -runscript
      >
      > Can you send me the entire log?
      >
      > As a workaround, you can either:
      >
      > 1. export to xml, recreate the db from scratch (delete data) with:
      >
      > gsh -registry -check -drop -runscript
      >
      > Then import the xml
      >
      > or 2. Change the grouper_stems stem name index to be unique (drop and recreate index), and change the grouper_ddl row for grouper to be version 13...
      >
      > Thanks,
      > Chris
      >
      > > > > > > >
      > > > > > > –
      > > > > > > Dr. Loris Bennett (Mr.)
      > > > > –
      > > > > Dr. Loris Bennett (Mr.)
      > > > > Freie Universität Berlin
      > > >
      > > –
      > > Dr. Loris Bennett (Mr.)
      > > Freie Universität Berlin
      > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
      > > Compute & Media Service Fabeckstr. 32, Room 221
      > > D-14195 Berlin
      >

      Dr. Loris Bennett (Mr.)

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist