Re: Segfault logical replication PG 10.4

2018-07-30 Thread Mai Peng
Thank you Alvaro :) > Le 30 juil. 2018 à 22:33, Alvaro Herrera a écrit : > > On 2018-Jul-28, Alvaro Herrera wrote: > >> Aha, I see, thanks. Here's a complete fix with included testcase. In >> an unpatched assert-enabled build, this crashes this >> >> TRAP: FailedAssertion("!(ActiveSnapshotSe

Re: Segfault logical replication PG 10.4

2018-07-19 Thread Mai Peng
Hello , Some new input: On slave, all domains ( with checks) have been replaced by a simple type. No crash on slave since this bypass. Is there something to fix in the ActiveSnapshot code ? BR > Le 18 juil. 2018 à 17:03, Tom Lane a écrit : > > Mai Peng writes: >> Here the bac

Re: Segfault logical replication PG 10.4

2018-07-18 Thread Mai Peng
./build/../src/backend/main/main.c: No such file or directory.``` BR > Le 14 juil. 2018 à 13:15, Peter Eisentraut > a écrit : > > On 12.07.18 00:56, Mai Peng wrote: >> We discovered our pg_wal partition was full few days after setting our >> first logical publication

Re: ERROR: cannot start subtransactions during a parallel operation

2018-07-11 Thread Mai Peng
id::id ) $BODY$ LANGUAGE sql IMMUTABLE STRICT; > Le 1 juil. 2018 à 11:02, Mai Peng a écrit : > > Hello, how could I relax the subtransaction restriction, I used the Parallel > Unsafe option, but still have the same issue. > Rgds. > > Le ven. 29 juin 2018 20:47,

Segfault logical replication PG 10.4

2018-07-11 Thread Mai Peng
We discovered our pg_wal partition was full few days after setting our first logical publication on a PG 10.4 instance. Then, we can not synchronise our slave to the master, it triggers a segfault on the slave. We had to drop manually the subscription on slave and the slot on master. Then, we wa

Re: ERROR: cannot start subtransactions during a parallel operation

2018-07-01 Thread Mai Peng
Hello, how could I relax the subtransaction restriction, I used the Parallel Unsafe option, but still have the same issue. Rgds. Le ven. 29 juin 2018 20:47, Andres Freund a écrit : > Hi, > > On 2018-06-29 20:37:23 +0200, Tomas Vondra wrote: > > My guess is that it's a PL/pgSQL function with an E

ERROR: cannot start subtransactions during a parallel operation

2018-06-29 Thread Mai Peng
Hello, On a pG10.4 instance, my query ( a simple select from a view) throw this error: ERROR: cannot start subtransactions during a parallel operation CONTEXT: PL/pgSQL function check_validity(ltree[]) line 4 during statement block entry But prefixing this query by "set max_parallel_workers_ga