[asterisk-bugs] [Asterisk 0017767]: [patch] Strange booting behavior depending on nice value

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17767 
====================================================================== 
Reported By:                elbriga
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17767
Category:                   Core/General
Reproducibility:            random
Severity:                   crash
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           1.6.2.10 
JIRA:                       SWP-1991 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-07-30 07:29 CDT
Last Modified:              2011-03-15 13:19 CDT
====================================================================== 
Summary:                    [patch] Strange booting behavior depending on nice
value
Description: 
We're having some weird issues here with asterisk 1.6.2.10 (wasn't on the
list of versions)

After many try-n-fail attempts we concluded that the problem is around the
res_config_pgsql and the nice value when starting asterisk trough
safe_asterisk.

when the nice value is 0 (default of safe_asterisk) or lower it wont boot
correctly (I assume that not all modules get loaded, since core commands
like "reload" doesn't work), but when we use a higher nice value (less
priority) like 10 or more it will boot correctly. Curious is that when it
is in the "hanged" CLI state and we perform a "/etc/init.d/postgresql-8.3
restart" asterisk will "un-hang" and continue normal boot, eventually
reconnecting with postgres in normal operation.

Other thing we did was poke around with the res_config_pgsql, because it
appeared to be executing querys without being connected (probably the cause
of the hang). What we did was put a call to "pgsql_reconnect" in the
"find_table" method (because this method will do querys without calling the
reconnect method that makes sure we're connected), and that seemed to
resolve the problem.
====================================================================== 

---------------------------------------------------------------------- 
 (0132941) elbriga (reporter) - 2011-03-15 13:19
 https://issues.asterisk.org/view.php?id=17767#c132941 
---------------------------------------------------------------------- 
Just uploaded a patch that fixes the issue on the 1.6.2.15 version 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-03-15 13:19 elbriga        Note Added: 0132941                          
======================================================================