Re: [HACKERS] Logical replication woes

2014-05-16 Thread Heikki Linnakangas
On 05/15/2014 11:58 PM, Andres Freund wrote: On 2014-05-15 22:30:53 +0300, Heikki Linnakangas wrote: Attached patch fixes things, but I want to add some regression tests before commit. Looks good to me. Attached are two patches. One for the unitialized dbId/tsId issue; one for the decoding b

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Andres Freund
On 2014-05-15 22:30:53 +0300, Heikki Linnakangas wrote: > >Attached patch fixes things, but I want to add some regression tests > >before commit. > > Looks good to me. Attached are two patches. One for the unitialized dbId/tsId issue; one for the decoding bug. The former should be backpatched. Sh

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Andres Freund
On 2014-05-15 22:30:53 +0300, Heikki Linnakangas wrote: > On 05/15/2014 08:46 PM, Andres Freund wrote: > >On 2014-05-15 20:07:23 +0300, Heikki Linnakangas wrote: > >How very wierd. The reason for this is that > >RecordTransactionCommitPrepared() forgets to fill a couple of fields in > >xl_xact_comm

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Heikki Linnakangas
On 05/15/2014 08:46 PM, Andres Freund wrote: On 2014-05-15 20:07:23 +0300, Heikki Linnakangas wrote: Ok, so the immediate cause was quick to find: when decoding a commit-prepared WAL record, we have to use the XID from the record content (patch attached). The XID in the record header is the XID

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Andres Freund
On 2014-05-15 19:46:57 +0200, Andres Freund wrote: > Attached patch fixes things, but I want to add some regression tests > before commit. And now actually attached. Will send a patch with regression tests later tonight or tomorrow. Need to eat first... Greetings, Andres Freund -- Andres Freu

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Andres Freund
On 2014-05-15 20:07:23 +0300, Heikki Linnakangas wrote: > Ok, so the immediate cause was quick to find: when decoding a > commit-prepared WAL record, we have to use the XID from the record content > (patch attached). The XID in the record header is the XID of the transaction > doing the COMMIT PREP

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Andres Freund
Hi, On 2014-05-15 20:07:23 +0300, Heikki Linnakangas wrote: > On 05/15/2014 07:57 PM, Heikki Linnakangas wrote: > >Spotted while testing pg_recvlogical: > > > >1. Set up pg_recvlogical to receive: > > > >./pg_recvlogical -S fooslot -d postgres --create > >./pg_recvlogical -S fooslot -d postgres --

Re: [HACKERS] Logical replication woes

2014-05-15 Thread Heikki Linnakangas
On 05/15/2014 07:57 PM, Heikki Linnakangas wrote: Spotted while testing pg_recvlogical: 1. Set up pg_recvlogical to receive: ./pg_recvlogical -S fooslot -d postgres --create ./pg_recvlogical -S fooslot -d postgres --start -f - 2. In another terminal, with psql: create table foo (id int4); beg

[HACKERS] Logical replication woes

2014-05-15 Thread Heikki Linnakangas
Spotted while testing pg_recvlogical: 1. Set up pg_recvlogical to receive: ./pg_recvlogical -S fooslot -d postgres --create ./pg_recvlogical -S fooslot -d postgres --start -f - 2. In another terminal, with psql: create table foo (id int4); begin; insert into foo values (4); alter table foo a