[pgpool-general: 5638] Re: building pgpool RMP error

Tatsuo Ishii ishii at sraoss.co.jp
Sun Jul 23 22:21:34 JST 2017 

Can you please provide pgpool log with debug option enabled?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi Tatsuo Ishii,
> 
> I recompiled pgpool with the diff file that you send and ran some tests.  It seems like both problems still occur.   The probability of the exception queries (select 1/0) is much better but still every few thousands exceptions it get stuck.   The regular queries that do regular select or select count still get stuck when they run on a computer that does not have the VIP.  If it is run on the server with the VIP it does not get stuck.  This is similar to the behavior before your changes.
> 
> Please let me know if you need more info from me.  Now that I know how to create the rpm I hope to be able to check your fixes in a shorter cycle.
> 
> Thanks again for all your help,
> Avi
> 
> 
> 
> iteration 2339
> FE=> Query(query="SET statement_timeout = '4s'")
> <= BE CommandComplete(SET)
> <= BE ReadyForQuery(I)
> FE=> Parse(stmt="S1", query="SELECT 1/0")
> FE=> Bind(stmt="S1", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S1")
> FE=> Parse(stmt="S2", query="SELECT 1/0")
> FE=> Bind(stmt="S2", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S2")
> FE=> Sync
> <= BE ParseComplete
> <= BE ErrorResponse(S ERROR V ERROR C 22012 M division by zero F int.c L 719 R int4div )
> <= BE ReadyForQuery(I)
> FE=> Terminate
> iteration 2340
> FE=> Query(query="SET statement_timeout = '4s'")
> <= BE CommandComplete(SET)
> <= BE ReadyForQuery(I)
> FE=> Parse(stmt="S1", query="SELECT 1/0")
> FE=> Bind(stmt="S1", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S1")
> FE=> Parse(stmt="S2", query="SELECT 1/0")
> FE=> Bind(stmt="S2", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S2")
> FE=> Sync
> <= BE ParseComplete
> <= BE ErrorResponse(S ERROR V ERROR C 22012 M division by zero F int.c L 719 R int4div )
> <= BE ReadyForQuery(I)
> FE=> Terminate
> iteration 2341
> FE=> Query(query="SET statement_timeout = '4s'")
> <= BE CommandComplete(SET)
> <= BE ReadyForQuery(I)
> FE=> Parse(stmt="S1", query="SELECT 1/0")
> FE=> Bind(stmt="S1", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S1")
> FE=> Parse(stmt="S2", query="SELECT 1/0")
> FE=> Bind(stmt="S2", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S2")
> FE=> Sync
> <= BE ParseComplete
> <= BE ErrorResponse(S ERROR V ERROR C 22012 M division by zero F int.c L 719 R int4div )
> 
> ==================================================================================
> 
> 
> iteration 730
> FE=> Query(query="SET statement_timeout = '4s'")
> <= BE CommandComplete(SET)
> <= BE ReadyForQuery(I)
> FE=> Parse(stmt="S1", query="SELECT count(*) from pg_tables")
> FE=> Bind(stmt="S1", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S1")
> FE=> Parse(stmt="S2", query="SELECT * from pg_tables")
> FE=> Bind(stmt="S2", portal="")
> FE=> Execute(portal="")
> FE=> Close(stmt="S2")
> FE=> Sync
> <= BE ParseComplete
> <= BE BindComplete
> <= BE DataRow
> <= BE CommandComplete(SELECT 1)
> <= BE CloseComplete
> <= BE ParseComplete
> <= BE BindComplete
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE DataRow
> <= BE ()
> 
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Friday, July 21, 2017 12:00 AM
> To: Avi Weinberg <AviW at gilat.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: building pgpool RMP error
> 
> Great. I am looking forward to hearing from you.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> Hi,
>>
>> Thanks you for all your help.
>>
>> I compiled the rpm with your changes.  I will run some tests and hopefully I will be able to give you some feedback early next week.
>>
>> Avi
>>
>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
>> Sent: Tuesday, July 18, 2017 3:16 PM
>> To: Avi Weinberg <AviW at gilat.com>
>> Cc: pgpool-general at pgpool.net
>> Subject: Re: building pgpool RMP error
>>
>> You need the SGML doc build tool chain.
>>
>> yum install docbook-dtds docbook-style-xsl fop libxslt opensp
>>
>> Per PostgreSQL doc.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>>> Hi
>>>
>>> I took the existing 3.6.5 rpm.  Modified the source code and zipped
>>> it again.  Then tried to build pgpool RMP
>>>
>>> I ran the following command:
>>>
>>> rpmbuild -ba pgpool.spec --define="pgpool_version 3.6.5" --define="pg_version 96" --define="pghome /usr/pgsql-9.6" --define="dist rhel6"
>>>
>>>
>>> and got the following error:
>>>
>>> Making all in sgml
>>> make[2]: Entering directory `/var/lib/pgsql/rpmbuild/BUILD/pgpool-II-3.6.5/doc/src/sgml'
>>> /bin/mkdir -p html
>>> D. -x lower -i include-xslt-index pgpool.sgml >pgpool.xmltmp
>>> wall -wno-unused-param -wno-empty -wfully-tagged   -d stylesheet.dsl -t sgml -i output-html  -V html-index pgpool.sgml
>>> /bin/sh: D.: command not found
>>> wall: invalid option -- 'w'
>>> usage: wall [message]
>>> make[2]: [pgpool.xml] Error 127 (ignored) perl -p -e
>>> 's/\[(aacute|acirc|aelig|agrave|amp|aring|atilde|auml|bull|copy|eacute|egrave|gt|iacute|lt|mdash|nbsp|ntilde|oacute|ocirc|oslash|ouml|pi|quot|scaron|uuml) *\]/\&\1;/gi;' \
>>>                 -e '$_ .= qq{<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.2//EN" "http://www.oasis-open.org/docbook/xml/4.2/docbookx.dtd">\n} if $. == 1;' \
>>>                 <pgpool.xmltmp > pgpool.xml
>>> make[2]: [HTML.index] Error 1 (ignored) LC_ALL=C perl  -f -g -i
>>> 'bookindex' -o bookindex.sgml HTML.index rm pgpool.xmltmp
>>> Unrecognized
>>> switch: -g  (-h will show valid options).
>>> make[2]: *** [bookindex.sgml] Error 29
>>> make[2]: *** Waiting for unfinished jobs....
>>> make[2]: Leaving directory `/var/lib/pgsql/rpmbuild/BUILD/pgpool-II-3.6.5/doc/src/sgml'
>>> make[1]: *** [all-recursive] Error 1
>>> make[1]: Leaving directory `/var/lib/pgsql/rpmbuild/BUILD/pgpool-II-3.6.5/doc/src'
>>> make: *** [all-recursive] Error 1
>>> make: Leaving directory `/var/lib/pgsql/rpmbuild/BUILD/pgpool-II-3.6.5/doc'
>>> error: Bad exit status from /var/tmp/rpm-tmp.SN11bd (%build)
>>>
>>>
>>> RPM build errors:
>>>     Bad exit status from /var/tmp/rpm-tmp.SN11bd (%build) IMPORTANT -
>>> This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
>> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

More information about the pgpool-general mailing list