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

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jul 24 09:03:09 JST 2017 

The log was not produced with -d option enabled while starting pgpool.

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

From: Avi Weinberg <AviW at gilat.com>
Subject: RE: building pgpool RMP error
Date: Sun, 23 Jul 2017 14:46:41 +0000
Message-ID: <AM4PR07MB3476729894E373346D67CC4BCBBA0 at AM4PR07MB3476.eurprd07.prod.outlook.com>

> Hi,
> 
> Attached please find the log file for the exception case (select 1/0) that got stuck.  I'm still trying to capture the error with regular queries, but I think maybe with the debug information it occurs more rarely.
> 
> Take care,
> Avi
> 
> -----Original Message-----
> From: Avi Weinberg
> Sent: Sunday, July 23, 2017 4:35 PM
> To: 'Tatsuo Ishii' <ishii at sraoss.co.jp>
> Subject: RE: building pgpool RMP error
> 
> Hi,
> 
> Thanks for the quick reply.
> 
> Can you please tell me which options I need to open in pgpool.conf (or is it only starting the service with -d option).
> Is the file that you need /var/log/messages or some other file
> 
> Thanks!
> Avi
> 
> 
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Sunday, July 23, 2017 4:22 PM
> To: Avi Weinberg <AviW at gilat.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: building pgpool RMP error
> 
> 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.
> 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