postgres upgrade didnt work right in ddlutils

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