I think this issue can be solved at the DAL level. If pulling a connection form the pool and it is closed by the peer, re-establish the connection. I will try add this to the new DAL. Please remind me when the new DAL is out (in 2-3 weeks) so you test it.
Massimo On Dec 20, 8:56 am, KMax <[email protected]> wrote: > db = DAL('postgres://web2py:[email protected]/web2py', > pool_size=10) > Direct tcp connection. If db.host.local restarted or postgres > restarted. No way to restore connection unless restart apache who host > web2py. > > On 20 дек, 12:22, mdipierro <[email protected]> wrote: > > > I think I need to know more about settings. Who is losing connections > > to the db? Is there a ssh tunnel connection the two machines? Do you > > use connection pooling and one of the threads in the pool loses the > > connection? Is this a problem without connection pooling? > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
