Paul Smith wrote:
> In the backup, for the row which will become broken, I get:
>
> ctid| xmin | xmax
> +--+--
> (18722,29) | 23862661 | 23862661
Okay.
> Assuming it hadn't changed in the broken version (from application
> knowledge, it's unlikely to c
On 26/05/2015 19:47, Alvaro Herrera wrote:
Paul Smith wrote:
No, nothing like that. It was just running fine, and then suddenly (at 2am
on 23 May) it started throwing up loads of these errors. The DB server
wasn't even restarted at that point. It was just working fine, then suddenly
wasn't. (Th
On 05/26/2015 11:47 AM, Alvaro Herrera wrote:
> Paul Smith wrote:
>
>> No, nothing like that. It was just running fine, and then suddenly (at 2am
>> on 23 May) it started throwing up loads of these errors. The DB server
>> wasn't even restarted at that point. It was just working fine, then suddenl
Paul Smith wrote:
> No, nothing like that. It was just running fine, and then suddenly (at 2am
> on 23 May) it started throwing up loads of these errors. The DB server
> wasn't even restarted at that point. It was just working fine, then suddenly
> wasn't. (The first error was at 02:00:32 BST, the
On 26/05/2015 16:01, Alvaro Herrera wrote:
Paul Smith wrote:
With PostgreSQL 9.3.5 on Ubuntu 12.04, I'm getting the error:
ERROR: MultiXactId 1934308693 has not been created yet -- apparent
wraparound
on doing various queries on our database. I don't think it is a wraparound -
I think the t
Paul Smith wrote:
> With PostgreSQL 9.3.5 on Ubuntu 12.04, I'm getting the error:
>
> ERROR: MultiXactId 1934308693 has not been created yet -- apparent
> wraparound
>
> on doing various queries on our database. I don't think it is a wraparound -
> I think the tuple has mistakenly decided it has
On 26/05/2015 10:23, Tatsuo Ishii wrote:
It was fixed in 9.3.7.
OK.
Do you know what the bug number was or what it was called (I've tried
searching for it before posting, but found nothing which seemed to be
the same problem as ours).
Do you know whether, if we upgrade to 9.3.7/8, it wil
It was fixed in 9.3.7.
Unfortunately 9.3.7 has new bug which is irrelevant to this.
http://www.postgresql.org/message-id/20150525142657.4686.35...@wrigleys.postgresql.org
I'm not sure if Ubuntu 12.04 is affected by the bug or not though.
As far as I know developers plan to release 9.3.8 etc. soo
With PostgreSQL 9.3.5 on Ubuntu 12.04, I'm getting the error:
ERROR: MultiXactId 1934308693 has not been created yet -- apparent
wraparound
on doing various queries on our database. I don't think it is a
wraparound - I think the tuple has mistakenly decided it has a
MultiXactId related to i
