OS 6.0 Sleep and spinning wheel with Postgresql

[Doug Easterbrook]

hi Mats:

the problem is omnis, not postgres.  It always helps to know who is responsible.

postgres wakes up nicely after sleep.

omnis dam thinks it has a connection and doesn't recover nicely from the disconnect (a sleep is a disconect).     I havn't tried andy's solution - but we built something as best we could to reconnect to the server if we discovered that people disconnected.


big warning.    I don't think you ca do what andy suggests if you were in the middle of a transaction and expect to keep on going.      The failure in the middle of the transaction rolls things back -- and a reconnect and expectation to continue in the current code to finsh the transaction will kill you.

so you'll need some reconnect/restart the process or failover to some place where the user can restart what they were doing.


hope that helps.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 536-1205    Fax (403) 536-1210

On Aug 11, 2014, at 10:00 AM, omnisdev-en-request at lists.omnis-dev.com wrote:

> Using Studio 6.0.2 and Postgresql 9.1. And have about the same problem as with ODB. When the computer goes to sleep a ”spinning wheel” appear.
> 
> Note that the session is still alive so I get no error:
> 
> If pgsql.$state<>kSessionStateLoggedOn
> 	OK message  {logoff}
> 	Do login.$start
> End If