[pgpool-hackers: 487] Re: penultimate patch for exception and memory manager ( EXCEPTION_MGR branch)

Tatsuo Ishii ishii at postgresql.org
Thu Apr 17 08:10:48 JST 2014


Hi Usama,

Thanks for the fix. I'm going to test it this weekend.

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
>>> >>>>
>>> >>>>
>>> >>>
>>> >>
>>>
>>
>>


More information about the pgpool-hackers mailing list