<HTML><HEAD>
<META content="text/html; charset=ISO-8859-1" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV>should have sent this to list – sorry</DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=paul@crocodile-rcs.com
href="mailto:paul@crocodile-rcs.com">Paul Pankhurst</A> </DIV>
<DIV><B>Sent:</B> Tuesday, December 13, 2011 12:03 PM</DIV>
<DIV><B>To:</B> <A title=miconda@gmail.com
href="mailto:miconda@gmail.com">miconda@gmail.com</A> </DIV>
<DIV><B>Subject:</B> Re: [sr-dev] db_fetch_next problem with
Postgres?</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV>Hi Daniel,</DIV>
<DIV> </DIV>
<DIV>I have a bit more information...</DIV>
<DIV> </DIV>
<DIV>the outline pseudo code for what I am doing looks like this (removing non
relevant stuff)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>db_fetch_query( xcap_db )</DIV>
<DIV> </DIV>
<DIV>do</DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV><FONT size=3 face=Calibri>{</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>query( another_2nd_db )</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>} while ( db_fetch_next( xcap_db) ) </FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>it is the query to the second database that
breaks everything...if I remove it the problem goes away and db_fetch_next works
as expected.</FONT></DIV>
<DIV><FONT size=3 face=Calibri>The access to the 2nd database uses completely
different db_func_t and db1_cont_t structures to the xcap_db</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>I’ll try running it with extra debug shortly to
see if I can see what’s happening</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV><FONT size=3 face=Calibri>Paul</FONT></DIV>
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=miconda@gmail.com
href="mailto:miconda@gmail.com">Daniel-Constantin Mierla</A> </DIV>
<DIV><B>Sent:</B> Tuesday, December 13, 2011 11:10 AM</DIV>
<DIV><B>To:</B> <A title=sr-dev@lists.sip-router.org
href="mailto:sr-dev@lists.sip-router.org">Development mailing list of the
sip-router project</A> </DIV>
<DIV><B>Cc:</B> <A title=paul@crocodile-rcs.com
href="mailto:paul@crocodile-rcs.com">Paul Pankhurst</A> </DIV>
<DIV><B>Subject:</B> Re: [sr-dev] db_fetch_next problem with
Postgres?</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">Hello,<BR><BR>On
12/13/11 11:40 AM, Paul Pankhurst wrote:
<BLOCKQUOTE cite=mid:D3F2C658884F44B6882BA8DB016504E8@pjplaptop type="cite">
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: rgb(0,0,0); FONT-SIZE: 12pt">
<DIV>I am having problems with the db_fetch_next routine and
Postgres.</DIV>
<DIV> </DIV>
<DIV>I can’t see any problem with my code that calls it, and as far as I can
tell the problem appears to be in the db_postgres_fetch_result routine.</DIV>
<DIV>On the first invocation of db_postgres_fetch_result it allocates a
result structure and gives me the first 5 rows of the 198 that match my query
after calling db_postgres_convert_rows.</DIV>
<DIV>On the 2nd invocation it fails to retrieve the next 5 rows because
CON_RESULT(_con) is NULL !</DIV>
<DIV>Anyone got any suggestions? </DIV></DIV></DIV></BLOCKQUOTE>can you
doublecheck and see if you don't call free_result() before fetching the next
rows? If you run with debug=3, if there is a free_result, you should see the log
message from:<BR><BR>LM_DBG("PQclear(%p) result set\n",
CON_RESULT(_con))<BR><BR>Cheers,<BR>Daniel<BR><PRE class=moz-signature cols="72">--
Daniel-Constantin Mierla -- <A class=moz-txt-link-freetext href="http://www.asipto.com">http://www.asipto.com</A>
<A class=moz-txt-link-freetext href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</A> -- <A class=moz-txt-link-freetext href="http://twitter.com/miconda">http://twitter.com/miconda</A></PRE></DIV></DIV></DIV></DIV></DIV></DIV></BODY></HTML>