Re: [Postgres-xc-developers] Patch for bug#3013984: Sequence scope

[Mason S. <mas...@en...>]

I created a couple of databases with a couple of sequences, bounced the 
coordinators and data nodes (not GTM), then if I try and drop a 
database, it causes a crash of both the coordinator and GTM.

mds1=# drop database msd2;
ERROR:  database "msd2" does not exist
mds1=# drop database mds2;
WARNING:  can not connect to GTM: Connection refused
ERROR:  Deletion of sequences on database mds2 not completed
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: Failed.
!> \q

#0  0x907916fa in select$DARWIN_EXTSN ()
(gdb) bt
#0  0x907916fa in select$DARWIN_EXTSN ()
#1  0x00002dd1 in ServerLoop ()
#2  0x00002b7f in main ()

and

(gdb) bt
#0  0x003e54ed in gtmpqPutMsgStart ()
#1  0x003e89fd in abort_transaction ()
#2  0x00077272 in RollbackTranGTM (gxid=1142) at gtm.c:174
#3  0x000583f5 in AbortTransaction () at xact.c:2320
#4  0x00058e33 in AbortCurrentTransaction () at xact.c:2783
#5  0x00058f18 in AbortCurrentTransactionOnce () at xact.c:2911
#6  0x0029aa16 in PostgresMain (argc=4, argv=0x1002ff8, 
username=0x1002fc8 "masonsharp") at postgres.c:3622
#7  0x0025665c in BackendRun (port=0x7016f0) at postmaster.c:3607
#8  0x002559c3 in BackendStartup (port=0x7016f0) at postmaster.c:3216
#9  0x002523f5 in ServerLoop () at postmaster.c:1445
#10 0x00251a01 in PostmasterMain (argc=5, argv=0x7005a0) at 
postmaster.c:1098
#11 0x001cd3a5 in main (argc=5, argv=0x7005a0) at main.c:

We should probably check if the connection is NULL.

Thanks,

Mason

-- 
Mason Sharp
EnterpriseDB Corporation
The Enterprise Postgres Company


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.