[sr-dev] invalid type (3) or nul (0) version columns for trusted (kamailio 3.1 latest from git)

[Alex Balashov]

On 10/21/2010 12:17 PM, Robert Verspuy wrote:

>   On 10/21/2010 06:12 PM, Alex Balashov wrote:
>> 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).

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/