[pgpool-general: 2076] Re: Using Pgpool: current transaction is aborted, commands ignored exception
Tatsuo Ishii
ishii at postgresql.org
Fri Aug 23 22:57:47 JST 2013
You need to download the full source code of pgpool-II first.
http://www.pgpool.net/download.php?f=pgpool-II-3.2.4.tar.gz
Then unpack it (assume pgpool-II-3.2.4.tar.gz is placed at /tmp).
tar xfz /tmp/pgpool-II-3.2.4.tar.gz
BTW, the latest version pgpool-II 3.2.x is 3.2.5. Many bugs of 3.2.4
are fixed in 3.2.5. If there's no particular reason, you should use
the latest 3.2.x.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> pool_proto_modules.c is not included in pgoool-II-3.2.4. where to include
> this file.
> I have copied from this link
> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=blob;f=pool_proto_modules.c;h=028b0d2964ae75369027ae347098fb729e7a5b17;hb=349d031b83a84038d497cd9d7b37df1a87e37c5e
>
> but header files are not there
>
> I have cheked all pgpool directory.
>
>
> On Fri, Aug 23, 2013 at 6:59 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>
>> Works for me.
>>
>> cd pgpool-II-3.2.4
>> patch -b -p1 <
>> ~/tmp/pgpool2.git-349d031b83a84038d497cd9d7b37df1a87e37c5e.patch
>> patching file pool_proto_modules.c
>> Hunk #1 succeeded at 1107 (offset -25 lines).
>>
>> I guess your pool_proto_modules.c is not the one included in
>> pgoool-II-3.2.4. Is the size of pool_proto_modules.c exactly 88008
>> bytes(before patching, of course)?
>>
>> ls -l pool_proto_modules.c
>> -rw-r--r-- 1 t-ishii t-ishii 88008 Apr 26 14:52 pool_proto_modules.c
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > I have followed the same instructions to insatll the pgpool.
>> > patch -p1 < pgpool2.git-349d031b83a84038d497cd9d7b37df1a87e37c5e.patch
>> >
>> > I am getting the errors like this
>> > I used the above commands to apply the patch.
>> > (Stripping trailing CRs from patch.)
>> > patching file pool_proto_modules.c
>> > Hunk #1 FAILED at 1132.
>> > 1 out of 1 hunk FAILED -- saving rejects to file pool_proto_modules.c.rej
>> >
>> > Sorry for disturbing you again and again ,I am new to all installation
>> > setup,Please help me out.
>> >
>> >
>> > On Fri, Aug 23, 2013 at 2:05 PM, Tatsuo Ishii <ishii at sraoss.co.jp>
>> wrote:
>> >
>> >> I suggest you read the pgpool manual to learn how to install pgpool
>> >> from the source code.
>> >>
>> >> http://www.pgpool.net/docs/latest/pgpool-en.html#install
>> >>
>> >> Then apply the patch. Just in case I attached the patch file.
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese: http://www.sraoss.co.jp
>> >>
>> >> > Hi,
>> >> >
>> >> > After copying the file
>> >> > cp /home/saritha1/pool_proto_modules.c
>> >> > /usr/local/src/pgpool-II-3.2.4/sql/pool_proto_modules.c
>> >> >
>> >> > gcc -o pool_proto_modules pool_proto_modules.c
>> >> >
>> >> > when I compile the file I am getting these exceptions
>> >> > pool_proto_modules.c:26:20: error: config.h: No such file or directory
>> >> > pool_proto_modules.c:46:18: error: pool.h: No such file or directory
>> >> > pool_proto_modules.c:47:25: error: pool_signal.h: No such file or
>> >> directory
>> >> > pool_proto_modules.c:48:28: error: pool_timestamp.h: No such file or
>> >> > directory
>> >> > pool_proto_modules.c:49:32: error: pool_proto_modules.h: No such file
>> or
>> >> > directory
>> >> > pool_proto_modules.c:50:32: error: pool_rewrite_query.h: No such file
>> or
>> >> > directory
>> >> > pool_proto_modules.c:51:27: error: pool_relcache.h: No such file or
>> >> > directory
>> >> > pool_proto_modules.c:52:25: error: pool_stream.h: No such file or
>> >> directory
>> >> > pool_proto_modules.c:53:25: error: pool_config.h: No such file or
>> >> directory
>> >> > pool_proto_modules.c:54:32: error: parser/pool_string.h: No such file
>> or
>> >> > directory
>> >> > pool_proto_modules.c:55:34: error: pool_session_context.h: No such
>> file
>> >> or
>> >> > directory
>> >> > pool_proto_modules.c:56:32: error: pool_query_context.h: No such file
>> or
>> >> > directory
>> >> > pool_proto_modules.c:57:23: error: pool_lobj.h: No such file or
>> directory
>> >> > pool_proto_modules.c:58:32: error: pool_select_walker.h: No such file
>> or
>> >> > directory
>> >> > pool_proto_modules.c:59:28: error: pool_memqcache.h: No such file or
>> >> > directory
>> >> > pool_proto_modules.c:76: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘is_parallel_table’
>> >> > pool_proto_modules.c:79: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘query’
>> >> > pool_proto_modules.c:84: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘string’
>> >> > pool_proto_modules.c:89: error: expected ‘)’ before ‘*’ token
>> >> > pool_proto_modules.c:91: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘parse_before_bind’
>> >> > pool_proto_modules.c:94: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘close_standby_transactions’
>> >> > pool_proto_modules.c:100: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘SimpleQuery’
>> >> > pool_proto_modules.c:646: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘Execute’
>> >> > pool_proto_modules.c:880: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘Parse’
>> >> > pool_proto_modules.c:1236: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘Bind’
>> >> > pool_proto_modules.c:1338: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘Describe’
>> >> > pool_proto_modules.c:1405: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘Close’
>> >> > pool_proto_modules.c:1473: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘FunctionCall3’
>> >> > pool_proto_modules.c:1503: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘ReadyForQuery’
>> >> > pool_proto_modules.c:1850: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘close_standby_transactions’
>> >> > pool_proto_modules.c:1874: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘ParseComplete’
>> >> > pool_proto_modules.c:1902: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘BindComplete’
>> >> > pool_proto_modules.c:1930: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘CloseComplete’
>> >> > pool_proto_modules.c:1962: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘CommandComplete’
>> >> > pool_proto_modules.c:2230: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘ErrorResponse3’
>> >> > pool_proto_modules.c:2301: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘FunctionCall’
>> >> > pool_proto_modules.c:2398: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘ProcessFrontendResponse’
>> >> > pool_proto_modules.c:2580: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘ProcessBackendResponse’
>> >> > pool_proto_modules.c:2788: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘CopyInResponse’
>> >> > pool_proto_modules.c:2809: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘CopyOutResponse’
>> >> > pool_proto_modules.c:2830: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘CopyDataRows’
>> >> > pool_proto_modules.c:3048: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘raise_intentional_error_if_need’
>> >> > pool_proto_modules.c:3127: error: expected declaration specifiers or
>> >> ‘...’
>> >> > before ‘POOL_CONNECTION’
>> >> > pool_proto_modules.c: In function ‘query_cache_register’:
>> >> > pool_proto_modules.c:3135: error: ‘parsed_query’ undeclared (first
>> use in
>> >> > this function)
>> >> > pool_proto_modules.c:3135: error: (Each undeclared identifier is
>> reported
>> >> > only once
>> >> > pool_proto_modules.c:3135: error: for each function it appears in.)
>> >> > pool_proto_modules.c:3137: error: ‘frontend’ undeclared (first use in
>> >> this
>> >> > function)
>> >> > pool_proto_modules.c: At top level:
>> >> > pool_proto_modules.c:3170: error: expected ‘)’ before ‘*’ token
>> >> > pool_proto_modules.c: In function ‘generate_error_message’:
>> >> > pool_proto_modules.c:3229: error: ‘POOL_SESSION_CONTEXT’ undeclared
>> >> (first
>> >> > use in this function)
>> >> > pool_proto_modules.c:3229: error: ‘session_context’ undeclared (first
>> use
>> >> > in this function)
>> >> > pool_proto_modules.c:3230: error: ‘POOL_MEMORY_POOL’ undeclared (first
>> >> use
>> >> > in this function)
>> >> > pool_proto_modules.c:3230: error: ‘old_context’ undeclared (first use
>> in
>> >> > this function)
>> >> > pool_proto_modules.c:3243: error: ‘String’ undeclared (first use in
>> this
>> >> > function)
>> >> > pool_proto_modules.c:3243: error: ‘msg’ undeclared (first use in this
>> >> > function)
>> >> > pool_proto_modules.c: At top level:
>> >> > pool_proto_modules.c:3269: error: expected ‘)’ before ‘*’ token
>> >> > pool_proto_modules.c:3281: error: expected ‘)’ before ‘*’ token
>> >> > pool_proto_modules.c:3293: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or
>> >> > ‘__attribute__’ before ‘parse_before_bind’
>> >> > pool_proto_modules.c: In function ‘find_victim_nodes’:
>> >> > pool_proto_modules.c:3374: error: ‘MAX_NUM_BACKENDS’ undeclared (first
>> >> use
>> >> > in this function)
>> >> >
>> >> > Any other files need to be added.
>> >> >
>> >> >
>> >> > On Fri, Aug 23, 2013 at 4:55 AM, Tatsuo Ishii <ishii at sraoss.co.jp>
>> >> wrote:
>> >> >
>> >> >> No, it's not github.
>> >> >>
>> >> >> Anyway, by hitting the url below:
>> >> >>
>> >> >>
>> >> >>
>> >>
>> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commitdiff;h=349d031b83a84038d497cd9d7b37df1a87e37c5e;hp=5368f85694f01dd5766c209b43df24cf083c2758
>> >> >>
>> >> >> you should get patch for this.
>> >> >> --
>> >> >> Tatsuo Ishii
>> >> >> SRA OSS, Inc. Japan
>> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >> >> Japanese: http://www.sraoss.co.jp
>> >> >>
>> >> >> > Hi ,
>> >> >> >
>> >> >> > Sorry for asking this...
>> >> >> > I am new to github.I tried to apply patch form github.But I am
>> >> unable to
>> >> >> > do that
>> >> >> > How to add a patch to existing pgpool. Please help me out.
>> >> >> >
>> >> >> >
>> >> >> > On Thu, Aug 22, 2013 at 5:57 PM, Tatsuo Ishii <
>> ishii at postgresql.org>
>> >> >> wrote:
>> >> >> >
>> >> >> >> > Thanks a lot,You saved my time.
>> >> >> >> >
>> >> >> >> > whether this is the link
>> >> >> >> >
>> >> >> >>
>> >> >>
>> >>
>> http://pgpool.net/mediawiki/index.php/Old_news#pgpool-II_3.2.4.2C_3.1.7.2C_3.0.11_officially_released_.282013.2F04.2F26.29
>> >> >> >>
>> >> >> >> The patch is not included in any released version. It's in the git
>> >> >> >> reporitory.
>> >> >> >>
>> >> >> >> You download the link below and save. The apply it as patch to
>> >> >> >> pgpool-II 3.2.4 source code.
>> >> >> >>
>> >> >> >> The patch will be included next release of pgpool-II but we do not
>> >> >> >> decide yet when it happens.
>> >> >> >> --
>> >> >> >> Tatsuo Ishii
>> >> >> >> SRA OSS, Inc. Japan
>> >> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >> >> >> Japanese: http://www.sraoss.co.jp
>> >> >> >>
>> >> >> >> > On Thu, Aug 22, 2013 at 5:40 PM, Tatsuo Ishii <
>> >> ishii at postgresql.org>
>> >> >> >> wrote:
>> >> >> >> >
>> >> >> >> >> [info about pgpool log deleted. I do not want to open it to
>> public
>> >> >> >> >> unless Saritha wants to do so.]
>> >> >> >> >>
>> >> >> >> >> > pgpool-II version 3.2.4 (namameboshi)
>> >> >> >> >>
>> >> >> >> >> Looking into the log and judging from the version number, it
>> seems
>> >> >> the
>> >> >> >> >> problem has been fixed in the 3.2 stable branch.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=349d031b83a84038d497cd9d7b37df1a87e37c5e
>> >> >> >> >>
>> >> >> >> >> Please try it.
>> >> >> >> >> --
>> >> >> >> >> Tatsuo Ishii
>> >> >> >> >> SRA OSS, Inc. Japan
>> >> >> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >> >> >> >> Japanese: http://www.sraoss.co.jp
>> >> >> >> >>
>> >> >> >> >> > On Thu, Aug 22, 2013 at 4:10 PM, Tatsuo Ishii <
>> >> >> ishii at postgresql.org>
>> >> >> >> >> wrote:
>> >> >> >> >> >
>> >> >> >> >> >> > Hi,
>> >> >> >> >> >> >
>> >> >> >> >> >> > I have attached pgpool.conf,pgpool.log and tomcat logs.I
>> >> didn't
>> >> >> >> find
>> >> >> >> >> >> pglog
>> >> >> >> >> >> > folder in Amazon but in local pglog folderis there.
>> >> >> >> >> >> >
>> >> >> >> >> >> > Please can you Explain me,If any query throws an exception
>> >> >> whether
>> >> >> >> >> other
>> >> >> >> >> >> > queries in sequence will be aborted or it will be excuted
>> >> >> normally.
>> >> >> >> >> >>
>> >> >> >> >> >> Unfortunately the start time of pgool.log is a liitle bit
>> >> late. I
>> >> >> >> need
>> >> >> >> >> >> a complete session log starting from the beginning of the
>> >> session.
>> >> >> >> >> >> Can you show me the earlier part of the log? I need to find
>> the
>> >> >> cause
>> >> >> >> >> >> of the transaction aborting..
>> >> >> >> >> >>
>> >> >> >> >> >> In the mean time I need to know the exact version of
>> pgpool-II.
>> >> >> You
>> >> >> >> >> >> can know by typing:
>> >> >> >> >> >>
>> >> >> >> >> >> pgpool --help
>> >> >> >> >> >> --
>> >> >> >> >> >> Tatsuo Ishii
>> >> >> >> >> >> SRA OSS, Inc. Japan
>> >> >> >> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >> >> >> >> >> Japanese: http://www.sraoss.co.jp
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >>
>> >>
>>
More information about the pgpool-general
mailing list