Re: [ADMIN] Crash with pg_clog file not found

2008-11-03 Thread Matthieu Roger
2008-10-31 20:17:32 CET 10.0.0.119 exile FATAL: connection limit exceeded for non-superusers This is just a wild guess, but how many connections are there? Especially see This link is interesting, I'm reading about it and found a good article on the msdn blog with a tool to check the desktop

Re: [ADMIN] Crash with pg_clog file not found

2008-11-03 Thread Tom Lane
Matthieu Roger [EMAIL PROTECTED] writes: 2008-10-31 20:14:27 CET 10.0.0.119 exile PANIC: could not access status of transaction 0 Can you present a self-contained test case that causes that? A stack trace from the PANIC would be mighty useful too, but I dunno whether there's any point in

Re: [ADMIN] Crash with pg_clog file not found

2008-11-03 Thread Matthieu Roger
2008/11/3 Tom Lane [EMAIL PROTECTED]: Matthieu Roger [EMAIL PROTECTED] writes: 2008-10-31 20:14:27 CET 10.0.0.119 exile PANIC: could not access status of transaction 0 Can you present a self-contained test case that causes that? Hello Tom, we were not able to reproduce at will :-( it seems

Re: [ADMIN] Crash with pg_clog file not found

2008-11-03 Thread Rainer Bauer
Matthieu Roger wrote: 2008-10-31 20:17:32 CET 10.0.0.119 exile FATAL: connection limit exceeded for non-superusers This is just a wild guess, but how many connections are there? Especially see

Re: [ADMIN] Crash with pg_clog file not found

2008-11-03 Thread Scott Marlowe
On Mon, Nov 3, 2008 at 8:49 AM, Matthieu Roger [EMAIL PROTECTED] wrote: 8.3.3 was also producing the same error, prior version (8.3.1) did not seem to exhibit it, though we've opened a new universe in the web game which increased the number of accounts and players in september so maybe this

[ADMIN] Crash with pg_clog file not found

2008-11-02 Thread Matthieu Roger
Hello, OS: Windows 2003 64bits Cpu : 2x Opteron Dual core Ram : 8Go Ram Disk : Areca Raid10 6x 200Go sata Postgresql 8.3.4 we're experiencing problems since some weeks with always the same error (same transaction 0 and same pg_clog file ) : 2008-10-31 20:14:27 CET 10.0.0.119 exile PANIC: