[OpenSIPS-Devel] [ opensips-Bugs-2823259 ] postgres insert into dialog generates error

SourceForge.net noreply at sourceforge.net
Mon Jul 20 13:43:27 CEST 2009


Bugs item #2823259, was opened at 2009-07-17 22:10
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2823259&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.5.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Patrick F. (padraigf65)
>Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: postgres insert into dialog generates error

Initial Comment:
postgres[38330]: [4-1] ERROR:  syntax error at end of input at character 446

This is the statement from postgres logfile
insert into dialog (hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,callee_sock,start_time,state,timeout,caller_cseq,callee_cseq,caller_route_
set,callee_route_set,caller_contact,callee_contact ) values (3192,901188333,'XXXXXXXXXXX-XXXX at XXXXXXXXXX','sip:5555551212 at 192.168.113.92','8a05ee72','sip:5555551313
@192.168.93.27','80380344-69E','udp:192.168.93.27:5060','udp:192.168.93.27:5060',1247856162,3,1247856161,'1','1',NULL


----------------------------------------------------------------------

>Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-07-20 14:43

Message:
Hi Patrick.

Do you get any other error in the opensips logs? like "error while
preparing insert operation" ?

Bogdan

----------------------------------------------------------------------

Comment By: Patrick F. (padraigf65)
Date: 2009-07-17 22:11

Message:
version: opensips 1.5.2-notls (x86_64/freebsd)
flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM,
SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
Version info:

ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,
MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, select, kqueue.
svnrevision: 2:5888M
@(#) $Id: main.c 5887 2009-07-16 11:47:46Z bogdan_iancu $
main.c compiled on 14:30:11 Jul 17 2009 with gcc 4.2.1



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2823259&group_id=232389



More information about the Devel mailing list