Re: FailedAssertion("!(PrivateRefCount[i] == 0)", File: "bufmgr.c", Line: 1741

On Wed, May 30, 2012 at 6:00 PM, Erik Rijkers <er@xs4all.nl> wrote:
> (I double-checked that I got your latest commit in)
>
> I'm afraid it's not yet resolved; the sync-slave still crashes almost immediately:
>
> master logfile says:
> 2012-05-30 23:30:07.846 CEST 3918 LOG:  standby wal_receiver_01 is now the synchronous standby
> with priority 1
>
> sync-slave logfile:
>
> [...]
> 2012-05-30 23:30:07.833 CEST 3908 LOG:  database system is ready to accept read only connections
> cp: cannot stat `/home/aardvark/pg_stuff/archive_dir/000000010000000000000004': No such file or
> directory
> 2012-05-30 23:30:07.845 CEST 3917 LOG:  streaming replication successfully connected to primary
> 2012-05-30 23:40:52.635 CEST 5287 ERROR:  could not open relation with OID 26563
> 2012-05-30 23:40:52.635 CEST 5287 STATEMENT:  select current_setting('port') port, count(*) from
> public.t
> 2012-05-30 23:40:57.909 CEST 3909 FATAL:  could not open file "base/21268/26569": No such file or
> directory
> 2012-05-30 23:40:57.909 CEST 3909 CONTEXT:  writing block 5152 of relation base/21268/26569
>        xlog redo multi-insert (init): rel 1663/21268/26581; blk 3852; 35 tuples
> TRAP: FailedAssertion("!(PrivateRefCount[i] == 0)", File: "bufmgr.c", Line: 1741)
> 2012-05-30 23:40:58.006 CEST 5331 FATAL:  could not open file "base/21268/26569": No such file or
> directory
> 2012-05-30 23:40:58.006 CEST 5331 CONTEXT:  writing block 5153 of relation base/21268/26569
> 2012-05-30 23:40:59.661 CEST 3908 LOG:  startup process (PID 3909) was terminated by signal 6:
> Aborted
> 2012-05-30 23:40:59.661 CEST 3908 LOG:  terminating any other active server processes

Hmm.  I set up what I believe to be the same test case you were using,
and it's not crashing for me.  In fact, with the latest code, I
haven't been able to produce any error at all.  When I reverted my
last commit, I managed to get this:

ERROR:  could not open relation with OID 18229
STATEMENT:  select current_setting('port') port, count(*) from t

...but just once, and with no other error messages.    So I'm either
missing a step somewhere, or something about your system just happens
to tickle this moreso than on mine.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company