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

[Alex Balashov]

Robert,

We use Postgres 8.4 as well with the permissions module, but have not  
had this problem...

--
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/

On Oct 12, 2010, at 10:30 AM, Robert Verspuy <robert at exa-omicron.nl>  
wrote:

> I've got a strange issue with the latest kamailio. I also had this  
> problem with kamailio 3.0.3 downloaded from the webpage.
>
> I can start kamailio, but after a while (sometimes within one  
> minuten, sometimes after an hour),
> I get the following log errors:
>
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core> [db.c: 
> 387]: invalid type (3) or nul (0) version columns for trusted
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core> [db.c: 
> 405]: querying version for table trusted
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: permissions  
> [trusted.c:249]: error during table version check.
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>  
> [sr_module.c:832]: init_mod_child(): Error while initializing module  
> permissions (//lib/kamailio/modules_k/permissions.so)
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core> [pt.c: 
> 481]: ERROR: fork_tcp_process(): init_child failed for process 10,  
> pid 26621, "tcp receiver child=0"
> Oct 12 15:46:24 sp01 /sbin/kamailio[26621]: ERROR: <core>  
> [tcp_main.c:4811]: ERROR: tcp_main: fork failed: Success
> Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core> [pass_fd.c: 
> 103]: ERROR: recv_all: 1st recv on 21 failed: Connection reset by peer
> Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core> [tcp_main.c: 
> 3323]: ERROR: handle_tcp_child: read from tcp child 0  (pid 26621,  
> no 10) Connection reset by peer [104]
> Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: : <core> [pass_fd.c: 
> 293]: ERROR: receive_fd: EOF on 19
> Oct 12 15:46:24 sp01 /sbin/kamailio[26611]: ALERT: <core>      
> [main.c:738]: child process 26621 exited normally, status=255
> Oct 12 15:46:24 sp01 /sbin/kamailio[26611]: INFO: <core> [main.c: 
> 756]: INFO: terminating due to SIGCHLD
> Oct 12 15:46:24 sp01 /sbin/kamailio[26625]: INFO: <core> [main.c: 
> 807]: INFO: signal 15 received
>
> Looking at the error message, it thinks that the column type of  
> table_version in the table version is a string (type 3), and it  
> should be an int (type 1).
> But in the database it really is an int.
>
> When I run kamailio with debugging on level 5, I see that it's  
> trying to run the "select table_version from version where  
> table_name='trusted'" several times when kamailio starts (for every  
> child thread).
> And then minutes, of even an hour later, it suddenly continues with  
> that check, but based on a database response from another query.
> This is the "select password from subscriber ....etc...".
> And that column is indeed an string.
>
> I'm using PostgreSQL 8.4 as server,
> but maybe someone has seen this before, or now where I have to start  
> looking?
> I first saw it yesterday when started to use the permissions module.
> I only see this with the trusted table,
> And always it uses the "select password from subscriber ... "  
> response when giving this error.
>
> So is this an error in the permissions module / trusted.c file?
> or something in auth_db that's not freeing the response correctly?
>
> Strange thing is, that is sometimes happens very quick, and  
> sometimes it can take an half hour or hour.
>
> I can mail the full log if anybody is interested and thinks he/she  
> can help me.
>
> With kind regards,
> Robert Verspuy
>
>
> -- 
> Exa-Omicron
> Patroonsweg 10
> 3892 DB Zeewolde
> Tel.: 088-OMICRON (66 427 66)
> http://www.exa-omicron.nl
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20101012/f66b4191/attachment.htm>