21 Oct
2010
21 Oct
'10
7:19 p.m.
On 10/21/2010 12:17 PM, Robert Verspuy wrote:
On 10/21/2010 06:12 PM, Alex Balashov wrote:
I also use non-caching with permissions, but my number of threads is
considerably lower than yours; I usually keep them at about the
default 8 per core. I suspect less contention here probably accounts
for the differences in result; I've simply been fortunate that the
database returns queries fast enough and in the order in which they
are made within the timing tolerance demands of the non-reentrant
behaviour.
Thank you again for exploring it.
--
Alex Balashov - Principal
Evariste Systems LLC
1170 Peachtree Street
12th Floor, Suite 1200
Atlanta, GA 30309
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/
Personally, I have not had any issues. My setup
is with PostgreSQL
8.4 and lately PostgreSQL 9.0, and involves use of 'permissions', a
few other minor DB-backed modules, and also very heavy use of
sqlops. Some of these are very high-volume / concurrent call dense.
How many
threads do you have running?
And do you have the permissions module setup as cached or not?
I found that the cause is not in the permission module, but the
permissions module (without caching), together with "childeren = 32",
does help to get the problem happen more often.
I have now about 100 threads when kamailio is running ( with childeren
= 32 ) on a server with two quad-core processors (8 cores total).