Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-10 Thread Craig Ringer
On 10 August 2017 at 23:25, Robert Haas wrote: > On Mon, Aug 7, 2017 at 2:06 AM, Craig Ringer > wrote: > > I think so - specifically, that it's a leftover from a revision where the > > xid limit was advanced before clog truncation. > > > > I'll be finding time in the next couple of days to look

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-10 Thread Robert Haas
On Mon, Aug 7, 2017 at 2:06 AM, Craig Ringer wrote: > I think so - specifically, that it's a leftover from a revision where the > xid limit was advanced before clog truncation. > > I'll be finding time in the next couple of days to look more closely and > ensure that's all it is. A couple of days

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-07 Thread Noah Misch
On Mon, Aug 07, 2017 at 05:29:34PM +1200, Thomas Munro wrote: > On Thu, Aug 3, 2017 at 3:03 AM, Robert Haas wrote: > > On Fri, Jul 21, 2017 at 1:31 AM, Thomas Munro > > wrote: > >> Thanks Neha. It's be best to post the back trace and if possible > >> print oldestXact and ShmemVariableCache->olde

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-06 Thread Craig Ringer
On 7 August 2017 at 14:04, Thomas Munro wrote: > On Fri, Jul 21, 2017 at 7:17 PM, Kyotaro HORIGUCHI > wrote: > > In vac_truncate_clog, TruncateCLOG is called before > > SetTransactionIdLimit, which advances > > ShmemVariableCache->oldestXid. Given that the assertion in > > TruncateCLOG is valid,

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-06 Thread Thomas Munro
On Fri, Jul 21, 2017 at 7:17 PM, Kyotaro HORIGUCHI wrote: > In vac_truncate_clog, TruncateCLOG is called before > SetTransactionIdLimit, which advances > ShmemVariableCache->oldestXid. Given that the assertion in > TruncateCLOG is valid, they should be called in reverse order. I > suppose that CLO

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-06 Thread Thomas Munro
On Thu, Aug 3, 2017 at 3:03 AM, Robert Haas wrote: > On Fri, Jul 21, 2017 at 1:31 AM, Thomas Munro > wrote: >> Thanks Neha. It's be best to post the back trace and if possible >> print oldestXact and ShmemVariableCache->oldestXid from the stack >> frame for TruncateCLOG. >> >> The failing assert

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-08-02 Thread Robert Haas
On Fri, Jul 21, 2017 at 1:31 AM, Thomas Munro wrote: > Thanks Neha. It's be best to post the back trace and if possible > print oldestXact and ShmemVariableCache->oldestXid from the stack > frame for TruncateCLOG. > > The failing assertion in TruncateCLOG() has a comment that says > "vac_truncate

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-21 Thread Kyotaro HORIGUCHI
At Fri, 21 Jul 2017 11:39:38 +0530, Neha Sharma wrote in > Here is the back trace from the core dump attached. > > (gdb) bt > #0 0x7f4a71424495 in raise () from /lib64/libc.so.6 > #1 0x7f4a71425c75 in abort () from /lib64/libc.so.6 > #2 0x009dc18a in ExceptionalCondition (con

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Here is the back trace from the core dump attached. (gdb) bt #0 0x7f4a71424495 in raise () from /lib64/libc.so.6 #1 0x7f4a71425c75 in abort () from /lib64/libc.so.6 #2 0x009dc18a in ExceptionalCondition (conditionName=0xa905d0 "!(TransactionIdPrecedesOrEquals(oldestXact, ShmemVa

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Thomas Munro
On Fri, Jul 21, 2017 at 4:16 PM, Neha Sharma wrote: > > Attached is the core dump file received on PG 10beta2 version. Thanks Neha. It's be best to post the back trace and if possible print oldestXact and ShmemVariableCache->oldestXid from the stack frame for TruncateCLOG. The failing assertion

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Hi, Attached is the core dump file received on PG 10beta2 version. ​ myfile.tgz ​ Regards, Neha Sharma On Thu, Jul 20, 2017 at 2:45 PM, Neha Sharma wrote: > > > Regards, > Neha Sharma > > On T

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Regards, Neha Sharma On Thu, Jul 20, 2017 at 1:28 PM, Craig Ringer wrote: > On 20 July 2017 at 15:00, Neha Sharma > wrote: > >> Hi Craig, >> >> I had done a fresh initdb,the default parameter configuration was used. I >> was setting few set of parameters while startup by the below command. >> >

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Craig Ringer
On 20 July 2017 at 15:00, Neha Sharma wrote: > Hi Craig, > > I had done a fresh initdb,the default parameter configuration was used. I > was setting few set of parameters while startup by the below command. > > ./postgres -d postgres -c shared_buffers=$shared_bufs -N 200 -c > min_wal_size=15GB -c

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Hi Craig, I had done a fresh initdb,the default parameter configuration was used. I was setting few set of parameters while startup by the below command. ./postgres -d postgres -c shared_buffers=$shared_bufs -N 200 -c min_wal_size=15GB -c max_wal_size=20GB -c checkpoint_timeout=900 -c maintenance

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-19 Thread Craig Ringer
> > On 19 July 2017 at 20:26, Neha Sharma > wrote: > >> Hi, >> >> I am getting FailedAssertion while executing the attached >> script.However,I am not able to produce the core dump for the same,the >> script runs in background and takes around a day time to produce the >> mentioned error. >> >> "T

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-19 Thread Craig Ringer
On 19 July 2017 at 20:26, Neha Sharma wrote: > Hi, > > I am getting FailedAssertion while executing the attached script.However,I > am not able to produce the core dump for the same,the script runs in > background and takes around a day time to produce the mentioned error. > > "TRAP: FailedAssert

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-19 Thread Alvaro Herrera
Robert Haas wrote: > On Wed, Jul 19, 2017 at 8:26 AM, Neha Sharma > wrote: > > I am getting FailedAssertion while executing the attached script.However,I > > am not able to produce the core dump for the same,the script runs in > > background and takes around a day time to produce the mentioned err

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-19 Thread Robert Haas
On Wed, Jul 19, 2017 at 8:26 AM, Neha Sharma wrote: > I am getting FailedAssertion while executing the attached script.However,I > am not able to produce the core dump for the same,the script runs in > background and takes around a day time to produce the mentioned error. Maybe you should run it