[ome-users] java omero update setup-db deploy fails

[Jason Swedlow]

Hi Markus-

This is a known bug, see

http://trac.openmicroscopy.org.uk/omero/ticket/758

This is fixed in beta-2.2, which we are now testing and will be out  
in the next couple of weeks.

Alternatively, upgrade your PostgreSQL to 8.1 and this problem should  
go away.

Cheers,

Jason

On 26 Sep 2007, at 12:47, Markus Dorn wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi list,
>
> I hope you can help me out.
>
> I have followed the great installation guide in the wiki, but when I
> try to:
>
> java omero update setup-db deploy
>
> I get the following:
>
> - --->8 schnipp 8<---
> Buildfile: build.xml
>
> update:
> Created dir: /usr/local/omero-3.0-Beta2/omero/omero2030538765
> Copying 1 file to /usr/local/omero-3.0-Beta2/omero/omero2030538765
> Updating jar: /usr/local/omero-3.0-Beta2/omero/omero.ear
> Deleting directory /usr/local/omero-3.0-Beta2/omero/omero2030538765
>
> reload-db:
> Copying 1 file to /usr/local/omero-3.0-Beta2/omero/target
> Copying 1 file to /usr/local/omero-3.0-Beta2/omero/target
> Executing file: /usr/local/omero-3.0-Beta2/omero/target/ddl.sql
> Executing file: /usr/local/omero-3.0-Beta2/omero/target/data.sql
> Failed to execute:   alter table dbpatch alter id set default
> nextval('seq_dbpatch'), alter permissions set default -35, alter
> message set default 'Updating'
>
> BUILD FAILED
> /usr/local/omero-3.0-Beta2/omero/build.xml:83: The following error
> occurred while executing this
> line: /usr/local/omero-3.0-Beta2/omero/components/server/build.xml:15:
> The following error occurred while executing this
> line: /usr/local/omero-3.0-Beta2/omero/components/antlib/resources/ 
> macros.xml:47:
> org.postgresql.util.PSQLException: ERROR: syntax error at or near ","
>
> Total time: 13 seconds
> - --->8 schnapp 8<---
>
> I have no experience with postgres sql and so I am lost!
>
> Versions:
> java -version
> java version "1.5.0_10"
> javac -version
> javac 1.5.0_10
> psql --version
> psql (PostgreSQL) 7.4.16
> Debian Etch
> (anything else important?)
>
> Thanks for help.
>
> Markus
> - --
> ****************************************************************
> * Markus Dorn                         PHONE : +49 6221 54 9149 *
> * ASIC Labor                            FAX : +49 6221 54 9112 *
> * Im Neuenheimer Feld 227    mailto:dorn at kip.uni-heidelberg.de *
> * D-69120 Heidelberg      http://wwwasic.kip.uni-heidelberg.de *
> ****************************************************************
>
> GPG Key: 0xEC5847C4 or finger -l mdorn at ix.urz.uni-heidelberg.de
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (SunOS)
>
> iD8DBQFG+kbmrgzVAOxYR8QRAkcQAKCpQ4/SS1BZc8JneM3PekT3gXKL1ACgsvwl
> AB2TIQncCajmQ2CJizNs72I=
> =989y
> -----END PGP SIGNATURE-----
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users


**************************
MSI/WTB Complex
The University of Dundee
Dow Street
Dundee  DD1 5EH
United Kingdom

phone (01382) 385819
Intl phone:  44 1382 385819
FAX   (01382) 388072
email: jason at lifesci.dundee.ac.uk

Lab Page: http://www.dundee.ac.uk/lifesciences/swedlow/
Open Microscopy Environment: http://openmicroscopy.org
**************************