From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Logical decoding (contrib/test_decoding) walsender broken in 9.5 master? |
Date: | 2015-04-02 08:35:43 |
Message-ID: | CAMsr+YHYLVsHcgxXGX_hq+vFY46F4r0KWp8w-K2BpH5w+nEnkw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I started bisecting from e6df2e1 (stamp 9.4beta1, good) to 095d401 (bad).
The problem revision appears to be 9402869:
commit 9402869
Author: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
Date: Sat Jan 17 01:14:32 2015 +0200
Advance backend's advertised xmin more aggressively.
which is somewhat logical given the crash location and symptoms.
Bisection procedure used:
For each step:
./configure --enable-debug --enable-cassert --prefix=/home/craig/pg/95
CFLAGS="-Og -ggdb -fno-omit-frame-pointer" && make clean install && make -C
contrib/test_decoding/ clean install && rm -rf ~/tmp/slottest95 &&
PATH=$HOME/pg/95/bin:$PATH initdb -D ~/tmp/slottest95 && cp
~/tmp/{postgresql.conf,pg_hba.conf} ~/tmp/slottest95 &&
PATH=$HOME/pg/95/bin:$PATH PGPORT=5123 postgres -D ~/tmp/slottest95/
then manually:
psql -p 5123 -c 'SELECT pg_create_logical_replication_slot('test',
'test_decoding');'
PGPORT=5123 PATH=$HOME/pg/95/bin:$PATH pg_recvlogical -d postgres -S test
--start -f -
psql -p 5123 -c 'CREATE TABLE x AS SELECT xx FROM generate_series(1,10000)
xx;'
I have to go out now; I'll follow up further but wanted to update promptly.
From | Date | Subject | |
---|---|---|---|
Next Message | Aliouii Ali | 2015-04-02 08:38:08 | Re: Tables cannot have INSTEAD OF triggers |
Previous Message | Jan Urbański | 2015-04-02 08:32:19 | Re: libpq's multi-threaded SSL callback handling is busted |