| From: | Spencer Thomason <spencer(at)whiteskycommunications(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14295: Hot standby crash during tsvector rebuild |
| Date: | 2016-09-01 18:34:51 |
| Message-ID: | 7E7B1C18-719C-4BF8-8A60-D8F0857EA03F@whiteskycommunications.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Please see the attachments.
I have included the master and slave configs and python scripts that trigger this on our systems.
The way to reproduce this are:
- create a new database
- setup streaming replication to 2 or more slaves
- run the populate_db.py script
- if slaves do not crash, run the purge_db.py script followed by the populate_db.py script again.
I didn’t see failures immediately but within 15-20 mins of inserting records, the slaves crashed.
Also, I should note that this is on a SPARC T2 at 1.4GHz so the single thread performance might be a factor as well.
| Attachment | Content-Type | Size |
|---|---|---|
| create-db.sql | application/octet-stream | 166 bytes |
| postgresql-slave.conf | application/octet-stream | 21.4 KB |
| postgresql-master.conf | application/octet-stream | 21.4 KB |
| words.txt | text/plain | 207.6 KB |
| populate_db.py | text/x-python-script | 3.6 KB |
| purge_db.py | text/x-python-script | 947 bytes |
| ATT00001.txt | text/plain | 595 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | neil | 2016-09-02 03:15:51 | BUG #14307: SELECT from pg_timezone_abbrevs gives an ERROR: F0000 |
| Previous Message | villan.lampard.epl | 2016-09-01 18:34:18 | BUG #14306: copy command from csv to table is missing the timestamp in |