| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: assertion failure 9.3.4 |
| Date: | 2014-04-17 23:47:21 |
| Message-ID: | 53506809.7020707@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
All,
So have encountered a 2nd report of this issue, or of an issue which
sounds very similar:
- corruption in two "queue" tables
- the tables are written in a high-concurrency, lock-contested environment
- user uses SELECT FOR UPDATE with these tables.
- pg_stat_statements .so is loaded, but the extension is not installed
- four rows were added to the queue tables, while not being added to the
PK index. This allowed duplicate PKs to be added.
Currently the user is testing not loading the pg_stat_statements.so to
see if the problem goes away. They have a destruction test environment,
so we should be able to confirm/deny in a couple days.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-04-18 00:15:27 | Re: Verbose output of pg_dump not show schema name |
| Previous Message | Josh Berkus | 2014-04-17 23:42:21 | Re: How can we make beta testing better? |