Re: Test "tablespace" fails during `make installcheck` on master-replica setup - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Test "tablespace" fails during `make installcheck` on master-replica setup
Date
Msg-id 20161207124253.GC11146@e733.localdomain
Whole thread Raw
In response to Re: Test "tablespace" fails during `make installcheck` on master-replica setup  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Test "tablespace" fails during `make installcheck` on master-replica setup
List pgsql-hackers
> In the same host, primary and standby will try to use the tablespace
> in the same path. That's the origin of this breakage.

Sorry, I don't follow. Don't master and replica use different
directories to store _all_ data? Particularly in my case:

```
$ find path/to/postgresql-install/ -type d -name pg_tblspc
/home/eax/work/postgrespro/postgresql-install/data-slave/pg_tblspc
/home/eax/work/postgrespro/postgresql-install/data-master/pg_tblspc
```

Where exactly a collision happens?

On Wed, Dec 07, 2016 at 09:39:20PM +0900, Michael Paquier wrote:
> On Wed, Dec 07, 2016 at 03:18:59PM +0300, Aleksander Alekseev wrote:
> > I noticed, that `make installcheck` fails on my laptop with following
> > errors:
> >
> > http://afiskon.ru/s/98/6f94ce2cfa_regression.out.txt
> > http://afiskon.ru/s/b3/d0da05597e_regression.diffs.txt
>
> The interesting bit for the archives:
>
> *** /home/eax/work/postgrespro/postgresql-src/src/test/regress/expected/tablespace.out    2016-12-07
13:53:44.000728436+0300 
> --- /home/eax/work/postgrespro/postgresql-src/src/test/regress/results/tablespace.out    2016-12-07
13:53:46.150728558+0300 
> ***************
> *** 66,71 ****
> --- 66,72 ----
> INSERT INTO testschema.test_default_tab VALUES (1);
> CREATE INDEX test_index1 on testschema.test_default_tab (id);
> CREATE INDEX test_index2 on testschema.test_default_tab (id) TABLESPACE regress_tblspace;
> + ERROR:  could not open file "pg_tblspc/16395/PG_10_201612061/16393/16407": No such file or directory
> \d testschema.test_index1
>
> > Any ideas what can cause this issue?
>
> In the same host, primary and standby will try to use the tablespace
> in the same path. That's the origin of this breakage.
> --
> Michael



--
Best regards,
Aleksander Alekseev

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Test "tablespace" fails during `make installcheck` on master-replica setup
Next
From: Michael Paquier
Date:
Subject: Re: Test "tablespace" fails during `make installcheck` on master-replica setup