Re: [Postgres-xc-developers] prepare statement bug

[Koichi S. <koi...@gm...>]

Wang-san;

Thanks a lot for the info.  Core file will contain the context of
pgxc_planner(), which will be needed to find the fix.

Andrei;
Mason;

Could you look into the core file?

Regards;
----------
Koichi Suzuki



2010/12/1 xiong wang <wan...@gm...>:
> Hi, Koichi,
> core stack:
> #0  0x00000000007984e2 in MemoryContextStrdup ()
> (gdb) bt
> #0  0x00000000007984e2 in MemoryContextStrdup ()
> #1  0x00000000005c708b in pgxc_planner ()
> #2  0x00000000006263cb in planner ()
> #3  0x00000000006887e7 in pg_plan_query ()
> #4  0x0000000000688895 in pg_plan_queries ()
> #5  0x000000000054f16b in PrepareQuery ()
> #6  0x0000000000690958 in ProcessUtility ()
> #7  0x000000000068f19b in PortalRunUtility ()
> #8  0x000000000068f310 in PortalRunMulti ()
> #9  0x000000000068e99b in PortalRun ()
> #10 0x0000000000688c76 in exec_simple_query ()
> #11 0x000000000068cbe4 in PostgresMain ()
> #12 0x00000000006555da in BackendRun ()
> #13 0x0000000000654b37 in BackendStartup ()
> #14 0x0000000000651f02 in ServerLoop ()
> #15 0x00000000006516a8 in PostmasterMain ()
> #16 0x00000000005d8f47 in main ()
>
> Regards,
> Benny
> 2010/12/1 Koichi Suzuki <ko...@in...>
>>
>> Do you have backtrace list of the backend?  I hope SEGV may have created
>> core file.
>>
>> Regards;
>> ---
>> Koichi Suzuki
>>
>> (2010年12月01日 14:47), xiong wang wrote:
>>>
>>> Dears,
>>> template1=# prepare a(int) as insert into t values($1);
>>> LOG:  statement: prepare a(int) as insert into t values($1);
>>> server closed the connection unexpectedly
>>>  This probably means the server terminated abnormally
>>>  before or while processing the request.
>>> The connection to the server was lost. Attempting reset: LOG:  server
>>> process (PID 26936) was terminated by signal 11: Segmentation fault
>>> LOG:  terminating any other active server processes
>>> WARNING:  terminating connection because of crash of another server
>>> process
>>> DETAIL:  The postmaster has commanded this server process to roll back
>>> the current transaction and exit, because another server process exited
>>> abnormally and possibly corrupted shared memory.
>>> HINT:  In a moment you should be able to reconnect to the database and
>>> repeat your command.
>>> WARNING:  terminating connection because of crash of another server
>>> process
>>> DETAIL:  The postmaster has commanded this server process to roll back
>>> the current transaction and exit, because another server process exited
>>> abnormally and possibly corrupted shared memory.
>>> HINT:  In a moment you should be able to reconnect to the database and
>>> repeat your command.
>>> Failed.
>>> Regards,
>>> Benny
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Increase Visibility of Your 3D Game App&  Earn a Chance To Win $500!
>>> Tap into the largest installed PC base&  get more eyes on your game by
>>> optimizing for Intel(R) Graphics Technology. Get started today with the
>>> Intel(R) Software Partner Program. Five $500 cash prizes are up for
>>> grabs.
>>> http://p.sf.net/sfu/intelisp-dev2dev
>>>
>>>
>>>
>>> _______________________________________________
>>> Postgres-xc-developers mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>
>
> ------------------------------------------------------------------------------
> Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
> Tap into the largest installed PC base & get more eyes on your game by
> optimizing for Intel(R) Graphics Technology. Get started today with the
> Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
> http://p.sf.net/sfu/intelisp-dev2dev
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>