Re: Don't removes/recycles WAL files at all - Mailing list pgsql-general

From Michael Govorun
Subject Re: Don't removes/recycles WAL files at all
Date
Msg-id m31xw7zr8n.fsf@shpion.ru
Whole thread Raw
In response to Re: Don't removes/recycles WAL files at all  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Don't removes/recycles WAL files at all  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

>>> Server don't recycles or removes WAL files at all, generating 12-20
>>> files every day.
>
> There's something broken there.  Check to see why checkpoint operations
> are not completing (look in the postmaster log for relevant error
> messages).  Open transactions should not affect this.

I get such periodical errors in my log when user connects to proftpd
server which uses posgresql for authentication:

003-07-31 00:21:10 [14889]  LOG:  query: select login from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889]  LOG:  query: select homedir from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889]  LOG:  query: select uid from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889]  LOG:  query: select gid from accounts where login = 'testuser'
2003-07-31 00:21:10 [14889]  LOG:  query: select shell from accounts where login = 'testuser'
2003-07-31 00:21:12 [14889]  LOG:  query: select password from accounts where login = 'testuser'  limit 1
2003-07-31 00:21:12 [14889]  LOG:  query: select login from accounts where 1
2003-07-31 00:21:12 [14889]  ERROR:  Argument of WHERE must be type boolean, not type integer
2003-07-31 00:21:12 [14889]  LOG:  statement: select login from accounts where 1
2003-07-31 00:21:12 [14889]  LOG:  query: select login from accounts where 1
2003-07-31 00:21:12 [14889]  ERROR:  Argument of WHERE must be type boolean, not type integer
2003-07-31 00:21:12 [14889]  LOG:  statement: select login from accounts where 1
2003-07-31 00:21:12 [14889]  LOG:  query: update accounts set login_count = login_count + 1 where login = 'testuser'

and when user disconnects:

2003-07-31 00:21:14 [14889]  LOG:  SSL SYSCALL error: EOF detected
2003-07-31 00:21:14 [14889]  LOG:  pq_recvbuf: unexpected EOF on client connection

No other errors messages in my log.

I have old version of proftpd installed in my system. I'm going to
install new version today. But I can delay this if needed (if it's
postgres bug) and look into proftpd sources.

--
Michael Govorun

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Minimal system (was Re: Basic questions before start)
Next
From: "scott.marlowe"
Date:
Subject: Re: Minimal system (was Re: Basic questions before start)