Re: archive falling behind

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: archive falling behind
Date: 2013-04-27 20:51:17
Message-ID: 20130427165117.396a2952@shishi.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


From: German Becker <german(dot)becker(at)gmail(dot)com>
Subject: Re: archive falling behind

> Actually this seems like a very strange filesystem /hw problem. The
> wal segments keep "changing" even after I stoped the database and
> noone is supposly accesing it:

I've seen this before. It was bad RAM. I bet it's a hardware problem
for you as well... either bad RAM or a flaky disk.

In my case, I found it out because I got syntax errors in the
PostgreSQL logs: SELGCT was not a valid keyword. It turns out
that the flaky RAM was flipping bit 1 occasionally, so it would
randomly add or subtract 2 from a byte.

Regards,

David.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message German Becker 2013-04-29 19:58:56 PANIC during VACUUM
Previous Message ALEXANDER JOSE 2013-04-27 14:32:37 Postgresql Courses