Re: [Sqlgrey-users] Freezes, follow-up

[Lionel B. <lio...@bo...>]

Ed Shornock (sqlgrey list) wrote the following on 08.07.2005 20:56 :

>Ed Shornock (sqlgrey list) wrote:
>[snip]
>
>  
>
>>I did notice that on June 12 (by checking logs) that PGSQL was updated. 
>>
>>    
>>
>[snip]
>  
>
>>Let's see WTF the downgrading of the package does.  I'll post another
>>update if this fixes the problem (and I guess we'll figure out where to
>>go from there).
>>
>>    
>>
>
>Another hang with the patched 1.6.2 and a downloaded PostgreSQL.  No
>idea WTF is causing it (and why it's just Mr. Rees and myself having
>this problem).
>  
>

I'm still not sure myself. After a fork one needs to take precautions
with various things (file descriptors, sockets and so on...). The
current problem with SQLgrey is the amount of code in the
Net::Server::Multiplex module I'm not familiar with.
I already considered ditching it and replacing it with my own code
because there seems to be bugs in it (SIGHUP handling for example
doesn't work as documented and was pretty unusable when I tried to use
it). 1.6.3 'sync' clean_method should hopefully solve the problem for
the short time and I'll probably recode the socket handling in 1.7.x.

Lionel.