Re: postgres sometimes returns no data

pls remember that since the switches didn't run, this all (or mostly) could
be related to an unknown process.  My bad component appears to have started
around 54 seconds into nov 10.  The overall job appears to have ended around
01:01:44 which makes me wonder if a lot of the EOFs are related to some sort
of cleanup effort between pentaho and postgres.  I'm poking around for info
on how to run perfmon unattended, how big its footprint would be if
monitoring for an extended period of time unattended , and how to look at
what the os might have told me that day at that time.  I took a peek at
available disk space, and while I don't know what postgres might be allowed
to take, there is a ton of available space.  I closed out about a handful of
idle queries on pg admin iii left by programmers.  I'll post more soon.

2015-11-10 00:54:03 EST LOG:  checkpoints are occurring too frequently (116
seconds apart)
2015-11-10 00:54:03 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:54:24 EST LOG:  checkpoints are occurring too frequently (21
seconds apart)
2015-11-10 00:54:24 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:54:46 EST LOG:  checkpoints are occurring too frequently (22
seconds apart)
2015-11-10 00:54:46 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:55:11 EST LOG:  checkpoints are occurring too frequently (25
seconds apart)
2015-11-10 00:55:11 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:55:36 EST LOG:  checkpoints are occurring too frequently (25
seconds apart)
2015-11-10 00:55:36 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:56:07 EST LOG:  checkpoints are occurring too frequently (31
seconds apart)
2015-11-10 00:56:07 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:56:38 EST LOG:  checkpoints are occurring too frequently (31
seconds apart)
2015-11-10 00:56:38 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:57:15 EST LOG:  checkpoints are occurring too frequently (37
seconds apart)
2015-11-10 00:57:15 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:57:53 EST LOG:  checkpoints are occurring too frequently (38
seconds apart)
2015-11-10 00:57:53 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:58:35 EST LOG:  checkpoints are occurring too frequently (42
seconds apart)
2015-11-10 00:58:35 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:59:12 EST LOG:  checkpoints are occurring too frequently (37
seconds apart)
2015-11-10 00:59:12 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 00:59:34 EST LOG:  checkpoints are occurring too frequently (22
seconds apart)
2015-11-10 00:59:34 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 01:00:15 EST LOG:  checkpoints are occurring too frequently (41
seconds apart)
2015-11-10 01:00:15 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 01:00:46 EST LOG:  checkpoints are occurring too frequently (31
seconds apart)
2015-11-10 01:00:46 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 01:01:15 EST LOG:  checkpoints are occurring too frequently (29
seconds apart)
2015-11-10 01:01:15 EST HINT:  Consider increasing the configuration
parameter "checkpoint_segments".
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection
2015-11-10 01:01:44 EST LOG:  could not receive data from client: No
connection could be made because the target machine actively refused it.


2015-11-10 01:01:44 EST LOG:  unexpected EOF on client connection



--
View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873824.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.