[ome-users] Beta 3.1.1 does not start

[Alexandre Cunha]

Howdy,

We were about to install the new 3.1.1 server but given the recent 
emails I was wondering if upgrading postgres to 8.3 would help in any 
way solve the reported problems. Please advise.

Thanks,
- Alex.

Paulo Almeida wrote:
> Hi,
> 
> I get the same error when upgrading, using PostgreSQL 8.1.11 :
> 
> CREATE VIEW
> ERROR:  syntax error at or near "," at character 975
> LINE 23:         FOR dup1, dup2 IN EXECUTE sql LOOP
>                          ^
> ERROR:  current transaction is aborted, commands ignored until end of 
> transaction block
> 
> 
> - Paulo
> 
> On Tuesday 14 October 2008 12:56, josh.moore at gmx.de wrote:
>> Hi Mario,
>>
>> Mario Valle writes:
>>  > Dear all,
>>  > inital testing of 3.0.1 were successful. Now upgraded to 3.1.1 and no
>>  > way to start the server.
>>  > OK, I was not able to upgrade the database due the SQL syntax error
>>  > (covered on another mail on the list).
>>  > I do not know if the hanging of the server during initialization is due
>>  > to the incomplete upgrade or not. But here it is.
>>
>> Yes, the server will refuse to start if the database does not have the
>> proper version. Can you clarify: you are having the same SQL upgrade
>> error as Oliver:
>>
>> CREATE VIEW
>>
>> FEHLER:  Fehler »syntax error« bei »,« bei Zeichen 975
>>
>> ZEILE 23:         FOR dup1, dup2 IN EXECUTE sql LOOP
>>
>>
>> (though probably without the German) ? What postgres version are you
>> working with?
>>
>> ~Josh
>>
>>  > The last line of the server log  is:
>>  >
>>  > 10:30:41,434 INFO  [Log4jService$URLWatchTimerTask] Configuring from
>>  > URL: resource:jboss-log4j.xml
>>  >
>>  > If I try to connect using the WebAdmin interface, the message is:
>>  >
>>  > Connection failure: Error creating bean with name 'init' defined in
>>  > class path resource [ome/client/spring.xml]: Cannot resolve reference to
>>  > bean 'managed-ome.api.ISession' while setting bean property
>>  > 'sessionService'; nested exception is
>>  > org.springframework.beans.factory.BeanCreationException: Error creating
>>  > bean with name 'managed-ome.api.ISession': FactoryBean threw exception
>>  > on object creation; nested exception is ome.client.OutOfService: Cannot
>>  > initialize service proxy
>>  >
>>  > Thanks for your help!
>>  >                                           mario
>>  >
>>  >
>>  > --
>>  > Mario Valle
>>  > Somewere @ Manno
>>  > http://www.cscs.ch/~mvalle/
>>  >
>>  > _______________________________________________
>>  > ome-users mailing list
>>  > ome-users at lists.openmicroscopy.org.uk
>>  > http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>>
>> _______________________________________________
>> ome-users mailing list
>> ome-users at lists.openmicroscopy.org.uk
>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>