[pgpool-hackers: 492] Re: penultimate patch for exception and memory manager ( EXCEPTION_MGR branch)
Tatsuo Ishii
ishii at postgresql.org
Thu Apr 17 12:38:35 JST 2014
> On Thu, Apr 17, 2014 at 4:10 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>
>> Hi Usama,
>>
>> Thanks for the fix. I'm going to test it this weekend.
>>
>>
> Great. Looking forward to your feedback and making this part of pgpool 3.4.
Sure. I think we are getting very close to merge Usama's branch soon.
> In addition to the regression run, are you planning to do any additional
> testing of this? We should also do some stress testing of the changes.
Yes, at least we need to do more test for watchdog with the new
code. I have two small pgpool-II dedicated watchdog test machines at
office.
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
>> >
>> > I was able to reproduce and fix the regression issue which was halting
>> the
>> > 055.backend_all_backend case. The issue was with the faulty logic in
>> > find_primary_node function in which I had made a mistake to put the try
>> > catch block inside the loop. I have checked-in the fix in EXCEPTION_MGR
>> > branch and the patch for that is also attached with the mail.
>> > The patch also makes some adjustments when we report an error from wait()
>> > system call. as "EINTR" (Interrupted system call) is not an actual error.
>> > So with the current patch wait() loop is not terminated when wait() call
>> > failed with EINTR errno.
>> >
>> > I will be removing the compiler warnings as a separate patch.
>> >
>> > Thanks
>> > --usama
>> >
>> >
>> > On Mon, Apr 7, 2014 at 4:54 PM, Muhammad Usama <m.usama at gmail.com>
>> wrote:
>> >
>> >> Hi Tatsuo
>> >>
>> >> Thanks for testing the Exception manager branch. I have pushed the merge
>> >> and now the branch is up-to date with the master branch. I am looking
>> into
>> >> the issue you are getting with the regression and compiler warnings and
>> >> will update you on this.
>> >>
>> >> Regarding your comment. "Looking at your commit, it seems there are some
>> >> unresolved conflicts."
>> >> All the conflicts were resolved in the brach when the merge was pushed.
>> >> The git log message is only informing about the conflicts
>> >> which occurred during the merge, but I had resolved all the conflicts
>> >> before committing the merge.
>> >>
>> >> Thanks
>> >> Usama
>> >>
>> >>
>> >> On Sun, Apr 6, 2014 at 4:43 AM, Tatsuo Ishii <ishii at postgresql.org>
>> wrote:
>> >>
>> >>> Usama,
>> >>>
>> >>> Finally I had a chance to EXCEPTION_MGR branch on Cent OS 6.5.1.
>> >>> (51101226e1ba8b4feaca4ac4a01fcd4528f4c8a).
>> >>>
>> >>> 1) there are number of compiler warnings.
>> >>>
>> >>> 2) regression test 055.backend_all_backend does not pass (hungs)
>> >>>
>> >>> Here is the pgpool log when it hungs:
>> >>>
>> >>> 2014-04-06 08:19:20: pid 16130: LOG: failover: set new primary node:
>> -1
>> >>> 2014-04-06 08:19:20 LOG: pid: 16212 worker process received restart
>> >>> request
>> >>> 2014-04-06 08:19:20: pid 16130: LOG: failover done. shutdown host
>> >>> /tmp(11001)
>> >>> 2014-04-06 08:19:21 LOG: pid: 16211 pcp child process received
>> restart
>> >>> request
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: PCP child 16211 exits with status
>> >>> 256 in failover()
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: fork a new PCP child pid 16277 in
>> >>> failover()
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: worker child 16212 exits with
>> >>> status 256
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: fork a new worker child pid 16278
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: health checking retry count 3
>> >>> 2014-04-06 08:19:21: pid 16130: LOG: received fast shutdown request
>> >>> 2014-04-06 08:19:21: pid 16278: WARNING: child_exit: called from
>> invalid
>> >>> process. ignored.
>> >>> 2014-04-06 08:19:21: pid 16277: WARNING: child_exit: called from
>> invalid
>> >>> process. ignored.
>> >>> 2014-04-06 08:19:26: pid 16130: LOG: received fast shutdown request
>> >>> 2014-04-06 08:19:41 ERROR: pid: 16130 wait() failed. reason:Interrupted
>> >>> system call
>> >>>
>> >>> pid 16130 is pgpool main process and it loops forever:
>> >>>
>> >>> 20 0x000000370a20f1d4 in wait () from /lib64/libpthread.so.0
>> >>> #1 0x0000000000406987 in terminate_all_childrens (code=<value
>> optimized
>> >>> out>,
>> >>> arg=<value optimized out>) at main/pgpool_main.c:787
>> >>> #2 system_will_go_down (code=<value optimized out>, arg=<value
>> optimized
>> >>> out>)
>> >>> at main/pgpool_main.c:2512
>> >>> #3 0x000000000045d4ea in proc_exit_prepare (code=-1)
>> >>> at utils/error/elog.c:2301
>> >>> #4 0x0000003709e35e22 in exit () from /lib64/libc.so.6
>> >>> #5 0x00000000004066fa in system_exit (sig=2) at main/pgpool_main.c:803
>> >>> #6 exit_handler (sig=2) at main/pgpool_main.c:1004
>> >>> #7 <signal handler called>
>> >>> #8 0x000000370a20f1d2 in wait () from /lib64/libpthread.so.0
>> >>> #9 0x00000000004066c4 in exit_handler (sig=2) at
>> main/pgpool_main.c:998
>> >>> #10 <signal handler called>
>> >>> #11 0x0000003709e32be0 in sigprocmask () from /lib64/libc.so.6
>> >>> #12 0x0000000000408933 in PgpoolMain (discard_status=<value optimized
>> >>> out>,
>> >>> clear_memcache_oidmaps=<value optimized out>) at
>> >>> main/pgpool_main.c:408
>> >>> #13 0x0000000000404660 in main (argc=<value optimized out>,
>> >>> argv=<value optimized out>) at main/main.c:319
>> >>>
>> >>> pgpool_main.c:787 is here:
>> >>> ----------------------------------------------------
>> >>> /* wait for all children to exit */
>> >>>
>> >>> while (wait(NULL) > 0); <--- 787
>> >>> if (errno != ECHILD)
>> >>> ereport(LOG,
>> >>> (errmsg("wait() failed. reason:%s", strerror(errno))));
>> >>> --------------------------------------------------------
>> >>>
>> >>> It seems pgpool is waitng for children which are not exiting.
>> >>>
>> >>> Here are pgpool related processes which remain at the point:
>> >>>
>> >>> 16130 pts/1 S+ 0:00
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/temp/installed/bin/pgpool
>> >>> -D -n -f
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pgpool.conf
>> >>> -F
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pcp.conf
>> >>> -a
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pool_hba.conf
>> >>> 16172 pts/1 S+ 0:00
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/temp/installed/bin/pgpool
>> >>> -D -n -f
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pgpool.conf
>> >>> -F
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pcp.conf
>> >>> -a
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pool_hba.conf
>> >>> 16234 pts/1 S+ 0:00 /bin/sh
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/follow_master.sh
>> >>> 1 /tmp 11001
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/data1
>> >>> 1 0 /tmp 0
>> >>> 16276 pts/1 S+ 0:00
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/temp/installed/bin/pgpool
>> >>> -f
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pgpool.conf
>> >>> -m f stop
>> >>> 16281 pts/1 S+ 0:00
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/temp/installed/bin/pgpool
>> >>> -f
>> >>>
>> /home/vagrant/src/pgpool2-5511012/src/test/regression/tests/055.backend_all_down/testdir/etc/pgpool.conf
>> >>> -m f stop
>> >>> 16584 pts/2 S+ 0:00 grep pgpool
>> >>>
>> >>> I have no idea what's wrong so far...
>> >>>
>> >>> Best regards,
>> >>> --
>> >>> Tatsuo Ishii
>> >>> SRA OSS, Inc. Japan
>> >>> English: http://www.sraoss.co.jp/index_en.php
>> >>> Japanese: http://www.sraoss.co.jp
>> >>>
>> >>>
>> >>> From: Muhammad Usama <m.usama at gmail.com>
>> >>> Subject: Re: penultimate patch for exception and memory manager (
>> >>> EXCEPTION_MGR branch)
>> >>> Date: Tue, 1 Apr 2014 20:25:34 +0500
>> >>> Message-ID: <CAEJvTzVcOR2GLF9+ekP5_iLyi3=
>> >>> 4vCc4Go+oypd1L+sRg7hjJg at mail.gmail.com>
>> >>>
>> >>> > Hi Tatsuo,
>> >>> >
>> >>> > I haven't had any success in reproducing the issue you encountered
>> with
>> >>> my
>> >>> > patch, the regression runs cleanly on my end. I have therefore
>> committed
>> >>> > the patch in the EXCEPTION_MGR branch so I can continue with the
>> >>> remaining
>> >>> > work on the memory manger front and will apply the fix for the
>> problem
>> >>> once
>> >>> > it is fixed as a patch.
>> >>> >
>> >>> > Thanks
>> >>> > Usama
>> >>> >
>> >>> >
>> >>> >
>> >>> > On Thu, Mar 27, 2014 at 8:32 PM, Muhammad Usama <m.usama at gmail.com>
>> >>> wrote:
>> >>> >
>> >>> >> Hi Tatsuo.
>> >>> >>
>> >>> >> I am looking into the problem of double free reported by you. but I
>> am
>> >>> >> unable to reproduce the scenario at my end. I tried the regression
>> on
>> >>> Linux
>> >>> >> Ubuntu x86_64 and on OS/X and regression is clean on both systems.
>> Can
>> >>> you
>> >>> >> please tell me if you can always produce the problem or with some
>> >>> specific
>> >>> >> configure switches.
>> >>> >> And if it is possible for you to send me the stack trace with
>> symbols
>> >>> for
>> >>> >> the problem that would be really helpful for identifying the exact
>> >>> issue.
>> >>> >>
>> >>> >> thanks
>> >>> >> Muhammad Usama
>> >>> >>
>> >>> >>
>> >>> >> On Wed, Mar 19, 2014 at 6:20 PM, Muhammad Usama <m.usama at gmail.com>
>> >>> wrote:
>> >>> >>
>> >>> >>> Hi Tatsuo
>> >>> >>>
>> >>> >>> Sorry for the delay. I was stuck in some other work, and now I am
>> >>> >>> resuming the work on this patch. For some reason regression was
>> >>> working
>> >>> >>> fine on my machine when I sent out the patch but will send you the
>> >>> updated
>> >>> >>> patch after figuring out the problem.
>> >>> >>>
>> >>> >>>
>> >>> >>> Thanks
>> >>> >>> Usama
>> >>> >>>
>> >>> >>>
>> >>> >>>
>> >>> >>> On Wed, Feb 19, 2014 at 9:23 AM, Tatsuo Ishii <
>> ishii at postgresql.org
>> >>> >wrote:
>> >>> >>>
>> >>> >>>> Usama,
>> >>> >>>>
>> >>> >>>> Thanks for the explanation.
>> >>> >>>>
>> >>> >>>> BTW, I ran a reggression test against EXEC_MANAGER branch and got
>> >>> >>>> serious problems.
>> >>> >>>>
>> >>> >>>> testing 003.failover...*** glibc detected *** pgpool: worker
>> process:
>> >>> >>>> free(): invalid pointer: 0x00000000007756c8 ***
>> >>> >>>>
>> >>> >>>> testing 055.backend_all_down...*** glibc detected ***
>> >>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool:
>> >>> >>>> double free or corruption (!prev): 0x000000000075c050 ***
>> >>> >>>>
>> >>> >>>> [ and regression test hangs]
>> >>> >>>>
>> >>> >>>> Detailed log attached.
>> >>> >>>>
>> >>> >>>> Best regards,
>> >>> >>>> --
>> >>> >>>> Tatsuo Ishii
>> >>> >>>> SRA OSS, Inc. Japan
>> >>> >>>> English: http://www.sraoss.co.jp/index_en.php
>> >>> >>>> Japanese: http://www.sraoss.co.jp
>> >>> >>>>
>> >>> >>>> > On Thu, Feb 13, 2014 at 3:49 AM, Tatsuo Ishii <
>> >>> ishii at postgresql.org>
>> >>> >>>> wrote:
>> >>> >>>> >
>> >>> >>>> >> Usama,
>> >>> >>>> >>
>> >>> >>>> >> Thanks for your hard work.
>> >>> >>>> >>
>> >>> >>>> >> One thing I noticed is, you moved src/tools/pcp to
>> src/utils/pcp.
>> >>> Is
>> >>> >>>> >> there any reason for this?
>> >>> >>>> >>
>> >>> >>>> >
>> >>> >>>> > Since the pgpool binary and pcp tool binaries all requires the
>> >>> >>>> functions
>> >>> >>>> > defined in pcp_stream.c for reading and writing to pcp streams.
>> But
>> >>> >>>> with
>> >>> >>>> > the arrival of memory manager API in pgpool, pcp stream
>> functions
>> >>> >>>> requires
>> >>> >>>> > to distinguish between calls made from pgpool and pcp tools. As
>> we
>> >>> >>>> need to
>> >>> >>>> > create reading and writing buffers in specific MemoryContexts
>> when
>> >>> the
>> >>> >>>> > function is invoked from pgpool, and as pcp tools does not have
>> a
>> >>> >>>> concept
>> >>> >>>> > of MemoryContext so the step of selecting a MemoryContext before
>> >>> >>>> allocating
>> >>> >>>> > a memory needed to be skipped when in pcp tools environment.
>> >>> >>>> >
>> >>> >>>> > To achieve the above, the patch makes the libpcp exclusive for
>> the
>> >>> tool
>> >>> >>>> > binaries only (compile with POOL_PRIVATE flag) and now pgpool
>> uses
>> >>> the
>> >>> >>>> > pcp_stream.c function directly and no longer has the dependancy
>> on
>> >>> the
>> >>> >>>> lib.
>> >>> >>>> >
>> >>> >>>> > To make this new arrangement visible in pgpool source directory
>> >>> >>>> structure
>> >>> >>>> > the patch rearranges the source code organisation and moves the
>> >>> >>>> > pcp_stream.c and pcp_error.c files to src/utils/pcp from
>> >>> src/lib/pcp
>> >>> >>>> > directory, while the pcp.c file still remains at its original
>> >>> >>>> directory.
>> >>> >>>> > Also the new arrangement of code seems more naturally fit to the
>> >>> rest
>> >>> >>>> of
>> >>> >>>> > pgppol-II source structure as other stream related functions
>> also
>> >>> >>>> resides
>> >>> >>>> > in src/utils directory.
>> >>> >>>> >
>> >>> >>>> > --
>> >>> >>>> > Thanks
>> >>> >>>> > Muhammad Usama
>> >>> >>>> >
>> >>> >>>> >
>> >>> >>>> > --
>> >>> >>>> >> Tatsuo Ishii
>> >>> >>>> >> SRA OSS, Inc. Japan
>> >>> >>>> >> English: http://www.sraoss.co.jp/index_en.php
>> >>> >>>> >> Japanese: http://www.sraoss.co.jp
>> >>> >>>> >>
>> >>> >>>> >> From: Muhammad Usama <m.usama at gmail.com>
>> >>> >>>> >> Subject: Re: penultimate patch for exception and memory
>> manager (
>> >>> >>>> >> EXCEPTION_MGR branch)
>> >>> >>>> >> Date: Tue, 11 Feb 2014 19:55:48 +0500
>> >>> >>>> >> Message-ID: <
>> >>> >>>> >>
>> >>> CAEJvTzWEjDWgtJ3HGCuaSwkGpXzWBETmrM4ShrA5tcNTQFvEuA at mail.gmail.com>
>> >>> >>>> >>
>> >>> >>>> >> > Hi Tatsuo
>> >>> >>>> >> >
>> >>> >>>> >> > I have rebased the EXCEPTION_MGR branch to current master,
>> >>> please
>> >>> >>>> find
>> >>> >>>> >> the
>> >>> >>>> >> > updated patch generated after rebasing.
>> >>> >>>> >> >
>> >>> >>>> >> > Thanks
>> >>> >>>> >> > Muhammad Usama
>> >>> >>>> >> >
>> >>> >>>> >> >
>> >>> >>>> >> > On Tue, Feb 11, 2014 at 11:17 AM, Tatsuo Ishii <
>> >>> >>>> ishii at postgresql.org>
>> >>> >>>> >> wrote:
>> >>> >>>> >> >
>> >>> >>>> >> >> Usama,
>> >>> >>>> >> >>
>> >>> >>>> >> >> I have checked EXCEPTION_MGR branch and it seems it is far
>> >>> behind
>> >>> >>>> main
>> >>> >>>> >> >> branch. The last patch brought to the EXCEPTION_MGR was
>> dated
>> >>> >>>> >> >> 2013/12/19. Can you please rebase the branch?
>> >>> >>>> >> >>
>> >>> >>>> >> >> Best regards,
>> >>> >>>> >> >> --
>> >>> >>>> >> >> Tatsuo Ishii
>> >>> >>>> >> >> SRA OSS, Inc. Japan
>> >>> >>>> >> >> English: http://www.sraoss.co.jp/index_en.php
>> >>> >>>> >> >> Japanese: http://www.sraoss.co.jp
>> >>> >>>> >> >>
>> >>> >>>> >> >> From: Muhammad Usama <m.usama at gmail.com>
>> >>> >>>> >> >> Subject: penultimate patch for exception and memory manager
>> (
>> >>> >>>> >> >> EXCEPTION_MGR branch)
>> >>> >>>> >> >> Date: Mon, 10 Feb 2014 19:53:41 +0500
>> >>> >>>> >> >> Message-ID:
>> <CAEJvTzUZHKKHjz-ZvYaAsviwVVBKSoX-ByNq9rhANO1zPJYR=
>> >>> >>>> >> >> w at mail.gmail.com>
>> >>> >>>> >> >>
>> >>> >>>> >> >> > Please find the penultimate patch for integration of
>> memory
>> >>> and
>> >>> >>>> >> exception
>> >>> >>>> >> >> > manager APIs into pgpool.
>> >>> >>>> >> >> > The patch is generated on the EXCEPTION_MGR development
>> >>> branch
>> >>> >>>> and
>> >>> >>>> >> >> > integrates the said APIs in query processing portion of
>> >>> pgpool-II
>> >>> >>>> >> code.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Patch summary for review
>> >>> >>>> >> >> > ======================
>> >>> >>>> >> >> > The patch is very large mainly because of replacing of
>> >>> >>>> pool_error(),
>> >>> >>>> >> >> > pool_debug() and pool_log() function calls to
>> >>> ereport(ERROR,..)
>> >>> >>>> >> >> > ereport(DEBUG,..) and ereport(LOG,..) and it would be
>> little
>> >>> time
>> >>> >>>> >> >> consuming
>> >>> >>>> >> >> > to review the patch. Although all the above also needs the
>> >>> >>>> thorough
>> >>> >>>> >> >> review,
>> >>> >>>> >> >> > as replacing pool_error() with ereport(ERROR) or
>> >>> ereport(FATAL)
>> >>> >>>> is
>> >>> >>>> >> just
>> >>> >>>> >> >> not
>> >>> >>>> >> >> > a cosmetic but changes the flow of code, but there are few
>> >>> >>>> things,
>> >>> >>>> >> that
>> >>> >>>> >> >> > requires the more attention than others.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Lifecycle of objects.
>> >>> >>>> >> >> > ================
>> >>> >>>> >> >> > Since with integration of memory manager, it is very
>> >>> important to
>> >>> >>>> >> manage
>> >>> >>>> >> >> > the life cycle of each object and making sure the object
>> is
>> >>> >>>> created in
>> >>> >>>> >> >> the
>> >>> >>>> >> >> > proper MemoryContext. Here is the summary of some
>> important
>> >>> >>>> objects
>> >>> >>>> >> and
>> >>> >>>> >> >> > their residences.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Some Important Memory Contexts
>> >>> >>>> >> >> > ============================
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > ProcessLoopContext:
>> >>> >>>> >> >> > This context resets at every main loop iteration of a
>> process
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > TopMemoryContext:
>> >>> >>>> >> >> > This context is same as PostgreSQL's TopMemoryContext and
>> >>> lives
>> >>> >>>> for a
>> >>> >>>> >> >> life
>> >>> >>>> >> >> > time of process.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > ErrorContext:
>> >>> >>>> >> >> > Same as PostgreSQL's ErrorContext and used for error
>> >>> processing.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > QueryContext:
>> >>> >>>> >> >> > Used by pgpool child process and it lives for single query
>> >>> cycle.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Lifecycle of Important Objects
>> >>> >>>> >> >> > ========================
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > SessionContext:
>> >>> >>>> >> >> > The session context consists of a backend and frontend
>> >>> >>>> connection and
>> >>> >>>> >> it
>> >>> >>>> >> >> > lives for a single iteration of main child process loop.
>> >>> >>>> >> >> > So the session context object is created in
>> >>> ProcessLoopContext.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > ProcessContext:
>> >>> >>>> >> >> > ConnectionPool:
>> >>> >>>> >> >> > BackendConnection:
>> >>> >>>> >> >> > The above objects are required for the life of process
>> hence
>> >>> are
>> >>> >>>> >> created
>> >>> >>>> >> >> in
>> >>> >>>> >> >> > TopMemoryContext which lives throughout the process life
>> >>> time.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Child Frontend connection:
>> >>> >>>> >> >> > Frontend connection object is placed in the
>> >>> ProcessLoopContext
>> >>> >>>> since
>> >>> >>>> >> new
>> >>> >>>> >> >> > frontend connection is created at every main loop
>> iteration
>> >>> of
>> >>> >>>> pgpool
>> >>> >>>> >> >> child
>> >>> >>>> >> >> > process.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > PCP Frontend connection:
>> >>> >>>> >> >> > This object can live till the pcp process so the object
>> for
>> >>> pcp
>> >>> >>>> >> frontend
>> >>> >>>> >> >> is
>> >>> >>>> >> >> > created in TopMemoryContext.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > new configuration parameters
>> >>> >>>> >> >> > ========================
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > The patch also adds three new configuration parameters to
>> >>> >>>> control the
>> >>> >>>> >> >> error
>> >>> >>>> >> >> > reporting style and details.
>> >>> >>>> >> >> > Parameters names and their behaviours are borrowed from
>> >>> >>>> PostgreSQL.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > int log_error_verbosity; /* controls how much detail
>> about
>> >>> >>>> error
>> >>> >>>> >> >> should
>> >>> >>>> >> >> > be emitted */
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > int client_min_messages; /*controls which message
>> should
>> >>> be
>> >>> >>>> sent to
>> >>> >>>> >> >> > client */
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > int log_min_messages; /*controls which message
>> should
>> >>> be
>> >>> >>>> >> emitted to
>> >>> >>>> >> >> > server log */
>> >>> >>>> >> >> >
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Some other notable changes introduced by the patch.
>> >>> >>>> >> >> > ==========================================
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > The patch changes the error reporting behaviour and now
>> >>> pgpool-II
>> >>> >>>> >> tries
>> >>> >>>> >> >> to
>> >>> >>>> >> >> > send all the error and log messages to the connected
>> frontend
>> >>> >>>> clients
>> >>> >>>> >> >> > (controllable by "client_min_messages" configuration
>> >>> parameter ).
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > The patch added an extra call back "on_system_exit" to the
>> >>> elog
>> >>> >>>> API,
>> >>> >>>> >> >> which
>> >>> >>>> >> >> > is not present in the PostgreSQL.
>> >>> >>>> >> >> > The call back is called at system exit by elog API just
>> >>> before
>> >>> >>>> calling
>> >>> >>>> >> >> the
>> >>> >>>> >> >> > "on_shmem_exit" call backs.
>> >>> >>>> >> >> > "on_system_exit" is a single call back and can be used to
>> >>> clean
>> >>> >>>> up
>> >>> >>>> >> things
>> >>> >>>> >> >> > which are dependent on shared memory.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > "repalloc()" behaviour in PostgreSQL palloc API is little
>> >>> >>>> different
>> >>> >>>> >> from
>> >>> >>>> >> >> > C-API counterpart "realloc()".
>> >>> >>>> >> >> > ("realloc()" behaves as "malloc()" if ptr argument is
>> NULL.
>> >>> While
>> >>> >>>> >> >> > "repalloc()" does not works on NULL pointers)
>> >>> >>>> >> >> > So I have changed the behaviour of "repalloc()" to make it
>> >>> more
>> >>> >>>> >> >> consistent
>> >>> >>>> >> >> > with C-API.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > The patch makes the libpcp exclusive for the tool binaries
>> >>> only
>> >>> >>>> >> (compile
>> >>> >>>> >> >> > with POOL_PRIVATE flag ). pgpool binary no longer has the
>> >>> >>>> dependancy
>> >>> >>>> >> on
>> >>> >>>> >> >> the
>> >>> >>>> >> >> > lib, and uses the pcp_stream.c function directly.
>> >>> >>>> >> >> > For this new arrangement the patch also rearranges the
>> source
>> >>> >>>> code
>> >>> >>>> >> >> > organisation and moves the pcp_stream.c and pcp_error.c
>> >>> files to
>> >>> >>>> >> >> > src/utils/pcp directory from src/lib/pcp directory.
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > What is still remaining.
>> >>> >>>> >> >> > ==================
>> >>> >>>> >> >> > 1- Need to decide the MemoryContext for memcache objects.
>> >>> >>>> >> >> > 2- Watchdog and few rewrite function are still without the
>> >>> >>>> managers.
>> >>> >>>> >> >> > 3- Replace all remaining occurrences of pool_error,
>> >>> pool_debug,
>> >>> >>>> and
>> >>> >>>> >> >> > pool_log with appropriate ereport() calls
>> >>> >>>> >> >> > 4 -Code cleanup
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Reviews comments and suggestions are most welcome
>> >>> >>>> >> >> >
>> >>> >>>> >> >> > Thanks
>> >>> >>>> >> >> > Usama
>> >>> >>>> >> >>
>> >>> >>>> >>
>> >>> >>>>
>> >>> >>>> using pgpool-II at /home/t-ishii/work/
>> >>> >>>> git.postgresql.org/pgpool2/src/test/regression/temp/installed
>> >>> >>>> *************************
>> >>> >>>> REGRESSION MODE : install
>> >>> >>>> PGPOOL-II : /home/t-ishii/work/
>> >>> >>>> git.postgresql.org/pgpool2/src/test/regression/temp/installed
>> >>> >>>> PostgreSQL bin : /usr/local/pgsql/bin
>> >>> >>>> pgbench : /usr/local/pgsql/bin/pgbench
>> >>> >>>> PostgreSQL jdbc :
>> >>> /usr/local/pgsql/share/postgresql-9.2-1003.jdbc4.jar
>> >>> >>>> *************************
>> >>> >>>> testing 001.load_balance...ok.
>> >>> >>>> testing 002.native_replication...ok.
>> >>> >>>>
>> >>> >>>> testing 003.failover...*** glibc detected *** pgpool: worker
>> process:
>> >>> >>>> free(): invalid pointer: 0x00000000007756c8 ***
>> >>> >>>> ======= Backtrace: =========
>> >>> >>>> /lib64/libc.so.6(+0x763b6)[0x7fd2922cf3b6]
>> >>> >>>> pgpool: worker process[0x41d1ff]
>> >>> >>>> pgpool: worker process[0x436363]
>> >>> >>>> pgpool: worker process[0x436615]
>> >>> >>>> pgpool: worker process[0x405e94]
>> >>> >>>> pgpool: worker process[0x4072bf]
>> >>> >>>> pgpool: worker process[0x407425]
>> >>> >>>> pgpool: worker process[0x408d01]
>> >>> >>>> pgpool: worker process[0x404ef8]
>> >>> >>>> /lib64/libc.so.6(__libc_start_main+0xfd)[0x7fd292277b1d]
>> >>> >>>> pgpool: worker process[0x4040e9]
>> >>> >>>> ======= Memory map: ========
>> >>> >>>> 00400000-0050c000 r-xp 00000000 08:05 2635374
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070c000-0070e000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070c000-0070e000
>> >rw-p
>> >>> 0010c000 08:05 2635374 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070e000-00795000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070e000-00795000
>> >rw-p
>> >>> 00000000 00:00 0 [heap]
>> >>> >>>> 7fd29044d000-7fd290463000 r-xp 00000000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290463000-7fd290662000 ---p 00016000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290662000-7fd290663000 rw-p 00015000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290663000-7fd290883000 rw-s 00000000 00:04 61898777
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd290883000-7fd29088f000 r-xp 00000000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd29088f000-7fd290a8e000 ---p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a8e000-7fd290a8f000 r--p 0000b000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a8f000-7fd290a90000 rw-p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a90000-7fd290a92000 r-xp 00000000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290a92000-7fd290c91000 ---p 00002000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290c91000-7fd290c92000 rw-p 00001000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290c92000-7fd290c9a000 r-xp 00000000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7fd290c9a000-7fd290e99000 ---p 00008000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7fd290e99000-7fd290e9a000 rw-p 00007000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7fd290e9a000-7fd290e9c000 r-xp 00000000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7fd290e9c000-7fd29109c000 ---p 00002000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7fd29109c000-7fd29109d000 r--p 00002000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7fd29109d000-7fd29109e000 rw-p 00003000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7fd29109e000-7fd2910c5000 r-xp 00000000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7fd2910c5000-7fd2912c4000 ---p 00027000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7fd2912c4000-7fd2912c6000 rw-p 00026000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7fd2912c6000-7fd2912c9000 r-xp 00000000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7fd2912c9000-7fd2914c8000 ---p 00003000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7fd2914c8000-7fd2914c9000 rw-p 00002000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7fd2914c9000-7fd291597000 r-xp 00000000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7fd291597000-7fd291796000 ---p 000ce000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7fd291796000-7fd2917a1000 rw-p 000cd000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7fd2917a1000-7fd2917d9000 r-xp 00000000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7fd2917d9000-7fd2919d8000 ---p 00038000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7fd2919d8000-7fd2919da000 rw-p 00037000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7fd2919da000-7fd291a36000 r-xp 00000000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7fd291a36000-7fd291c35000 ---p 0005c000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7fd291c35000-7fd291c37000 rw-p 0005b000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7fd291c37000-7fd291c3b000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd291c3b000-7fd291dd1000 r-xp 00000000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7fd291dd1000-7fd291fd0000 ---p 00196000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7fd291fd0000-7fd291ff3000 rw-p 00195000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7fd291ff3000-7fd291ff7000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd291ff7000-7fd292052000 r-xp 00000000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7fd292052000-7fd292251000 ---p 0005b000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7fd292251000-7fd292259000 rw-p 0005a000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7fd292259000-7fd2923ca000 r-xp 00000000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7fd2923ca000-7fd2925ca000 ---p 00171000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7fd2925ca000-7fd2925ce000 r--p 00171000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7fd2925ce000-7fd2925cf000 rw-p 00175000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7fd2925cf000-7fd2925d4000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd2925d4000-7fd292656000 r-xp 00000000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7fd292656000-7fd292855000 ---p 00082000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7fd292855000-7fd292856000 r--p 00081000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7fd292856000-7fd292857000 rw-p 00082000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7fd292857000-7fd29286d000 r-xp 00000000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7fd29286d000-7fd292a6c000 ---p 00016000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7fd292a6c000-7fd292a6d000 r--p 00015000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7fd292a6d000-7fd292a6e000 rw-p 00016000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7fd292a6e000-7fd292a70000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd292a70000-7fd292a86000 r-xp 00000000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7fd292a86000-7fd292c85000 ---p 00016000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7fd292c85000-7fd292c86000 r--p 00015000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7fd292c86000-7fd292c87000 rw-p 00016000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7fd292c87000-7fd292c89000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd292c89000-7fd292c90000 r-xp 00000000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7fd292c90000-7fd292e90000 ---p 00007000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7fd292e90000-7fd292e91000 r--p 00007000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7fd292e91000-7fd292e92000 rw-p 00008000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7fd292e92000-7fd292ec0000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd292ec0000-7fd292ed7000 r-xp 00000000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7fd292ed7000-7fd2930d6000 ---p 00017000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7fd2930d6000-7fd2930d7000 r--p 00016000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7fd2930d7000-7fd2930d8000 rw-p 00017000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7fd2930d8000-7fd2930dc000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd2930fb000-7fd293102000 r-xp 00000000 08:05 2635363
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7fd293102000-7fd293302000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07fd293102000-7fd293302000
>> >---p
>> >>> 00007000 08:05 2635363 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7fd293302000-7fd293303000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07fd293302000-7fd293303000
>> >rw-p
>> >>> 00007000 08:05 2635363 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7fd293303000-7fd29332b000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07fd293303000-7fd29332b000
>> >r-xp
>> >>> 00000000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7fd29332b000-7fd29352a000 ---p 00028000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7fd29352a000-7fd29352d000 rw-p 00027000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7fd29352d000-7fd29354b000 r-xp 00000000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7fd29372e000-7fd29372f000 rw-s 00000000 00:04 61997084
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd29372f000-7fd293730000 rw-s 00000000 00:04 61964315
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd293730000-7fd293731000 rw-s 00000000 00:04 61931546
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd293731000-7fd29373f000 rw-s 00000000 00:04 61866007
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd29373f000-7fd29374a000 rw-p 00000000 00:00 0
>> >>> >>>> 7fd29374a000-7fd29374b000 r--p 0001d000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7fd29374b000-7fd29374c000 rw-p 0001e000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7fd29374c000-7fd29374d000 rw-p 00000000 00:00 0
>> >>> >>>> 7fffb3324000-7fffb3345000 rw-p 00000000 00:00 0
>> >>> >>>> [stack]
>> >>> >>>> 7fffb33ff000-7fffb3400000 r-xp 00000000 00:00 0
>> >>> >>>> [vdso]
>> >>> >>>> ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
>> >>> >>>> [vsyscall]
>> >>> >>>>
>> >>> >>>> *** glibc detected *** pgpool: worker process: free(): invalid
>> >>> pointer:
>> >>> >>>> 0x00000000007756c8 ***
>> >>> >>>> ======= Backtrace: =========
>> >>> >>>> /lib64/libc.so.6(+0x763b6)[0x7fd2922cf3b6]
>> >>> >>>> pgpool: worker process[0x41d1ff]
>> >>> >>>> pgpool: worker process[0x436363]
>> >>> >>>> pgpool: worker process[0x436615]
>> >>> >>>> pgpool: worker process[0x405e94]
>> >>> >>>> pgpool: worker process[0x4072bf]
>> >>> >>>> pgpool: worker process[0x407425]
>> >>> >>>> pgpool: worker process[0x408d01]
>> >>> >>>> pgpool: worker process[0x404ef8]
>> >>> >>>> /lib64/libc.so.6(__libc_start_main+0xfd)[0x7fd292277b1d]
>> >>> >>>> pgpool: worker process[0x4040e9]
>> >>> >>>> ======= Memory map: ========
>> >>> >>>> 00400000-0050c000 r-xp 00000000 08:05 2635374
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070c000-0070e000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070c000-0070e000
>> >rw-p
>> >>> 0010c000 08:05 2635374 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070e000-00795000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070e000-00795000
>> >rw-p
>> >>> 00000000 00:00 0 [heap]
>> >>> >>>> 7fd29044d000-7fd290463000 r-xp 00000000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290463000-7fd290662000 ---p 00016000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290662000-7fd290663000 rw-p 00015000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7fd290663000-7fd290883000 rw-s 00000000 00:04 61898777
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7fd290883000-7fd29088f000 r-xp 00000000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd29088f000-7fd290a8e000 ---p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a8e000-7fd290a8f000 r--p 0000b000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a8f000-7fd290a90000 rw-p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7fd290a90000-7fd290a92000 r-xp 00000000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290a92000-7fd290c91000 ---p 00002000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290c91000-7fd290c92000 rw-p 00001000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7fd290c92000-7fd290c9a000 r-xp 00000000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7fd290c9a000-7fd290e99000 ---p 00008000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7fd290e99000-7fd290e9a000 rw-p 00007000 08:05 1704181
>> >>> >>>> ok.
>> >>> >>>> testing 004.watchdog...ok.
>> >>> >>>> testing 005.jdbc...ok.
>> >>> >>>> testing 006.memqcache...ok.
>> >>> >>>> testing 050.bug58...ok.
>> >>> >>>> testing 051.bug60...ok.
>> >>> >>>> testing 052.do_query...ok.
>> >>> >>>> testing 053.insert_lock_hangs...ok.
>> >>> >>>> testing 054.postgres_fdw...ok.
>> >>> >>>>
>> >>> >>>> testing 055.backend_all_down...*** glibc detected ***
>> >>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool:
>> >>> >>>> double free or corruption (!prev): 0x000000000075c050 ***
>> >>> >>>> *** glibc detected *** pgpool: worker process: double free or
>> >>> >>>> corruption (!prev): 0x000000000075d490 ***
>> >>> >>>> ======= Backtrace: =========
>> >>> >>>> /lib64/libc.so.6(+0x763b6)[0x7f0dca1f93b6]
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool[0x41d1ff]
>> <
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x41d1ff%5D
>> >
>> >>> >>>>
>> >>> >>>> /home/t-ishii/work/
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool[0x4058a7]
>> <
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x4058a7%5D
>> >
>> >>> >>>>
>> >>> >>>> /home/t-ishii/work/
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool[0x40882f]
>> <
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x40882f%5D
>> >
>> >>> >>>>
>> >>> >>>> /home/t-ishii/work/
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool[0x404ef8]
>> <
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x404ef8%5D
>> >
>> >>> <
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x41d1ff%5D/home/t-ishii/work/git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x4058a7%5D/home/t-ishii/work/git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x40882f%5D/home/t-ishii/work/git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x404ef8%5D
>> >>> >
>> >>> >>>> ======= Backtrace: =========
>> >>> >>>> /lib64/libc.so.6(__libc_start_main+0xfd)[0x7f0dca1a1b1d]
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool[0x4040e9]
>> <
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x4040e9%5D
>> >
>> >>> <
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool%5B0x4040e9%5D
>> >>> >
>> >>> >>>> pgpool: worker process======= Memory map: ========
>> >>> >>>> /lib64/libc.so.6(__libc_start_main+0xfd)[0x7f0dca1a1b1d]
>> >>> >>>> pgpool: worker process[0x4040e9]
>> >>> >>>> ======= Memory map: ========
>> >>> >>>> 00400000-0050c000 r-xp 00000000 08:05 2635374
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070c000-0070e000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070c000-0070e000
>> >rw-p
>> >>> 0010c000 08:05 2635374 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool
>> >>> >>>> 0070e000-00771000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/bin/pgpool0070e000-00771000
>> >rw-p
>> >>> 00000000 00:00 0 [heap]
>> >>> >>>> 7f0dc8377000-7f0dc838d000 r-xp 00000000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7f0dc838d000-7f0dc858c000 ---p 00016000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7f0dc858c000-7f0dc858d000 rw-p 00015000 08:05 1704093
>> >>> >>>> /lib64/libgcc_s-4.4.5.so.1
>> >>> >>>> 7f0dc858d000-7f0dc87ad000 rw-s 00000000 00:04 84148247
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7f0dc87ad000-7f0dc87b9000 r-xp 00000000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7f0dc87b9000-7f0dc89b8000 ---p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7f0dc89b8000-7f0dc89b9000 r--p 0000b000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7f0dc89b9000-7f0dc89ba000 rw-p 0000c000 08:05 1704191
>> >>> >>>> /lib64/libnss_files-2.11.1.so
>> >>> >>>> 7f0dc89ba000-7f0dc89bc000 r-xp 00000000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7f0dc89bc000-7f0dc8bbb000 ---p 00002000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7f0dc8bbb000-7f0dc8bbc000 rw-p 00001000 08:05 1704176
>> >>> >>>> /lib64/libkeyutils-1.2.so
>> >>> >>>> 7f0dc8bbc000-7f0dc8bc4000 r-xp 00000000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7f0dc8bc4000-7f0dc8dc3000 ---p 00008000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7f0dc8dc3000-7f0dc8dc4000 rw-p 00007000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>> 7f0dc8dc4000-7f0dc8dc6000 r-xp 00000000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7f0dc8dc6000-7f0dc8fc6000 ---p 00002000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7f0dc8fc6000-7f0dc8fc7000 r--p 00002000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7f0dc8fc7000-7f0dc8fc8000 rw-p 00003000 08:05 1704128
>> >>> >>>> /lib64/libdl-2.11.1.so
>> >>> >>>> 7f0dc8fc8000-7f0dc8fef000 r-xp 00000000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7f0dc8fef000-7f0dc91ee000 ---p 00027000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7f0dc91ee000-7f0dc91f0000 rw-p 00026000 08:05 1704166
>> >>> >>>> /lib64/libk5crypto.so.3.1
>> >>> >>>> 7f0dc91f0000-7f0dc91f3000 r-xp 00000000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7f0dc91f3000-7f0dc93f2000 ---p 00003000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7f0dc93f2000-7f0dc93f3000 rw-p 00002000 08:05 1704103
>> >>> >>>> /lib64/libcom_err.so.2.1
>> >>> >>>> 7f0dc93f3000-7f0dc94c1000 r-xp 00000000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7f0dc94c1000-7f0dc96c0000 ---p 000ce000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7f0dc96c0000-7f0dc96cb000 rw-p 000cd000 08:05 1704179
>> >>> >>>> /lib64/libkrb5.so.3.3
>> >>> >>>> 7f0dc96cb000-7f0dc9703000 r-xp 00000000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7f0dc9703000-7f0dc9902000 ---p 00038000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7f0dc9902000-7f0dc9904000 rw-p 00037000 08:05 1704152
>> >>> >>>> /lib64/libgssapi_krb5.so.2.2
>> >>> >>>> 7f0dc9904000-7f0dc9960000 r-xp 00000000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7f0dc9960000-7f0dc9b5f000 ---p 0005c000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7f0dc9b5f000-7f0dc9b61000 rw-p 0005b000 08:05 1970855
>> >>> >>>> /usr/lib64/libfreebl3.so
>> >>> >>>> 7f0dc9b61000-7f0dc9b65000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dc9b65000-7f0dc9cfb000 r-xp 00000000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7f0dc9cfb000-7f0dc9efa000 ---p 00196000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7f0dc9efa000-7f0dc9f1d000 rw-p 00195000 08:05 1703939
>> >>> >>>> /lib64/libcrypto.so.1.0.0l
>> >>> >>>> 7f0dc9f1d000-7f0dc9f21000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dc9f21000-7f0dc9f7c000 r-xp 00000000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7f0dc9f7c000-7f0dca17b000 ---p 0005b000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7f0dca17b000-7f0dca183000 rw-p 0005a000 08:05 1703951
>> >>> >>>> /lib64/libssl.so.1.0.0l
>> >>> >>>> 7f0dca183000-7f0dca2f4000 r-xp 00000000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7f0dca2f4000-7f0dca4f4000 ---p 00171000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7f0dca4f4000-7f0dca4f8000 r--p 00171000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7f0dca4f8000-7f0dca4f9000 rw-p 00175000 08:05 1703946
>> >>> >>>> /lib64/libc-2.11.1.so
>> >>> >>>> 7f0dca4f9000-7f0dca4fe000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dca4fe000-7f0dca580000 r-xp 00000000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7f0dca580000-7f0dca77f000 ---p 00082000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7f0dca77f000-7f0dca780000 r--p 00081000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7f0dca780000-7f0dca781000 rw-p 00082000 08:05 1704182
>> >>> >>>> /lib64/libm-2.11.1.so
>> >>> >>>> 7f0dca781000-7f0dca797000 r-xp 00000000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7f0dca797000-7f0dca996000 ---p 00016000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7f0dca996000-7f0dca997000 r--p 00015000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7f0dca997000-7f0dca998000 rw-p 00016000 08:05 1704185
>> >>> >>>> /lib64/libnsl-2.11.1.so
>> >>> >>>> 7f0dca998000-7f0dca99a000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dca99a000-7f0dca9b0000 r-xp 00000000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7f0dca9b0000-7f0dcabaf000 ---p 00016000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7f0dcabaf000-7f0dcabb0000 r--p 00015000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7f0dcabb0000-7f0dcabb1000 rw-p 00016000 08:05 1704202
>> >>> >>>> /lib64/libresolv-2.11.1.so
>> >>> >>>> 7f0dcabb1000-7f0dcabb3000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dcabb3000-7f0dcabba000 r-xp 00000000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7f0dcabba000-7f0dcadba000 ---p 00007000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7f0dcadba000-7f0dcadbb000 r--p 00007000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7f0dcadbb000-7f0dcadbc000 rw-p 00008000 08:05 1703950
>> >>> >>>> /lib64/libcrypt-2.11.1.so
>> >>> >>>> 7f0dcadbc000-7f0dcadea000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dcadea000-7f0dcae01000 r-xp 00000000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7f0dcae01000-7f0dcb000000 ---p 00017000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7f0dcb000000-7f0dcb001000 r--p 00016000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7f0dcb001000-7f0dcb002000 rw-p 00017000 08:05 1703970
>> >>> >>>> /lib64/libpthread-2.11.1.so
>> >>> >>>> 7f0dcb002000-7f0dcb006000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dcb025000-7f0dcb02c000 r-xp 00000000 08:05 2635363
>> >>> >>>> /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7f0dcb02c000-7f0dcb22c000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07f0dcb02c000-7f0dcb22c000
>> >---p
>> >>> 00007000 08:05 2635363 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7f0dcb22c000-7f0dcb22d000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07f0dcb22c000-7f0dcb22d000
>> >rw-p
>> >>> 00007000 08:05 2635363 /home/t-ishii/work/
>> >>> >>>>
>> >>>
>> git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.0
>> >>> >>>> 7f0dcb22d000-7f0dcb255000<
>> >>>
>> http://git.postgresql.org/pgpool2/src/test/regression/temp/installed/lib/libpcp.so.0.0.07f0dcb22d000-7f0dcb255000
>> >r-xp
>> >>> 00000000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7f0dcb255000-7f0dcb454000 ---p 00028000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7f0dcb454000-7f0dcb457000 rw-p 00027000 08:05 2004750
>> >>> >>>> /usr/local/pgsql/lib/libpq.so.5.6
>> >>> >>>> 7f0dcb457000-7f0dcb475000 r-xp 00000000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7f0dcb658000-7f0dcb659000 rw-s 00000000 00:04 84246555
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7f0dcb659000-7f0dcb65a000 rw-s 00000000 00:04 84213786
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7f0dcb65a000-7f0dcb65b000 rw-s 00000000 00:04 84181017
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7f0dcb65b000-7f0dcb669000 rw-s 00000000 00:04 84115478
>> >>> >>>> /SYSV00000000 (deleted)
>> >>> >>>> 7f0dcb669000-7f0dcb674000 rw-p 00000000 00:00 0
>> >>> >>>> 7f0dcb674000-7f0dcb675000 r--p 0001d000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7f0dcb675000-7f0dcb676000 rw-p 0001e000 08:05 1703940
>> >>> >>>> /lib64/ld-2.11.1.so
>> >>> >>>> 7f0dcb676000-7f0dcb677000 rw-p 00000000 00:00 0
>> >>> >>>> 7fff746e1000-7fff74702000 rw-p 00000000 00:00 0
>> >>> >>>> [stack]
>> >>> >>>> 7fff747ff000-7fff74800000 r-xp 00000000 00:00 0
>> >>> >>>> [vdso]
>> >>> >>>> ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
>> >>> >>>> [vsyscall]
>> >>> >>>> 7fd290c92000-7fd290c9a000 r-xp 00000000 08:05 1704181
>> >>> >>>> /lib64/libkrb5support.so.0.1
>> >>> >>>>
>> >>> >>>>
>> >>> >>>
>> >>> >>
>> >>>
>> >>
>> >>
>>
>
>
>
> --
> Ahsan Hadi
> Snr Director Product Development
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Phone: +92-51-8358874
> Mobile: +92-333-5162114
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com/
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
> This e-mail message (and any attachment) is intended for the use of the
> individual or entity to whom it is addressed. This message contains
> information from EnterpriseDB Corporation that may be privileged,
> confidential, or exempt from disclosure under applicable law. If you are
> not the intended recipient or authorized to receive this for the intended
> recipient, any use, dissemination, distribution, retention, archiving, or
> copying of this communication is strictly prohibited. If you have received
> this e-mail in error, please notify the sender immediately by reply e-mail
> and delete this message.
More information about the pgpool-hackers
mailing list