Strange/random overload of the server

On Thu, Sep 2, 2010 at 8:14 AM, Georgi Ivanov <georgi.r.ivanov@gmail.com> wrote:

Hi,
I have some strange problems with my server.

Randomly  the server gets overloaded with queries.
Queries are accepted and never executed, thus reaching max_connections limit
.
This I/O wait in top command reaches up to 90%
Couple of restarts (and sometimes vacuum and reindex of my biggest tables)
fix it for a while (about a week or so).
I suspected full-text indexes going wild, but after i dropping indexes i had
same issues again.
I found that file system have errors. Can this lead to this kind of behavior
?

Yes.

I am planning downtime to fix the FS errors since this can't be done on
mounted file systems.

Sounds like you're headed in the right direction. Note that it's
possible your db is corrupted and you'll need to restore from a
previous known good backup if you've been having file system problems.

--
To understand recursion, one must first understand recursion.

On Thu, Sep 2, 2010 at 5:25 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

On Thu, Sep 2, 2010 at 8:14 AM, Georgi Ivanov <georgi.r.ivanov@gmail.com> wrote:

Hi,
I have some strange problems with my server.

Randomly  the server gets overloaded with queries.
Queries are accepted and never executed, thus reaching max_connections limit
.
This I/O wait in top command reaches up to 90%
Couple of restarts (and sometimes vacuum and reindex of my biggest tables)
fix it for a while (about a week or so).
I suspected full-text indexes going wild, but after i dropping indexes i had
same issues again.
I found that file system have errors. Can this lead to this kind of behavior
?

Yes.

Your disk might be broken. Check the SMART status.

Groeten, Arjen Nienhuis