<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>For a while now I have been seeing these messages on my testing
asterisk machine (running trunk) and have only just got around to looking into
them, these appear just after a sip registration.<o:p></o:p></p>
<p class=MsoNormal>“[Jan 23 00:50:05] WARNING[1373] res_config_pgsql.c:
PostgreSQL RealTime: Failed to query database. Check debug for more info.”<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Ok so I tried ODBC, With ODBC I get:<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] WARNING[1366] res_odbc.c: SQL Execute returned
an error -1: 22P02: ERROR: invalid input syntax for integer: "";<o:p></o:p></p>
<p class=MsoNormal>Error while executing the query (76)<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] WARNING[1366] res_odbc.c: SQL Execute
error -1! Attempting a reconnect...<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] WARNING[1366] res_odbc.c: Connection is
down attempting to reconnect...<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] NOTICE[1366] res_odbc.c: Connecting
PostgreSQL-asterisk<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] NOTICE[1366] res_odbc.c: res_odbc:
Connected to PostgreSQL-asterisk [asterisk-connector]<o:p></o:p></p>
<p class=MsoNormal>[Jan 23 02:41:30] WARNING[1366] res_odbc.c: SQL Execute
returned an error -1: 22P02: ERROR: invalid input syntax for integer:
"";<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>This is not preventing users from registering, and I have
narrowed it down to the Sip Peers table.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Matching entry from Postgresql Log (when these errors
happen):<o:p></o:p></p>
<p class=MsoNormal>GMT STATEMENT: UPDATE sip_conf SET fullcontact = '',
ipaddr = '', port = '', regseconds = '0', username = '', regserver = '',
useragent = '', lastms = '' WHERE name = '100' <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>My realtime sip table has lastms or type bigint and int (I
have tried both while I was scratching my head trying to find out if I had
configured something wrong, I have also tried nulls allowed and NOT NULL on
this field).<o:p></o:p></p>
<p class=MsoNormal>Shouldn’t the statement include lastms = 0 (rather
than '').<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Appologies if ive done somthing stupid and lastms should be
a character field, I dont think this is the case as I have seen several
expamples online with lastms as a int.<o:p></o:p></p>
<p class=MsoNormal>Any ideas, is this a bug?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks in advance. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Regards,<o:p></o:p></p>
<p class=MsoNormal>Dr. Nic Colledge<o:p></o:p></p>
<p class=MsoNormal><a href="mailto:nic@njcolledge.net">nic@njcolledge.net</a><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>