Connection reset by peer / broken pipe

------=_Part_3448_17789771.1207080938246
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Much the same as this person here:

http://archives.postgresql.org/pgsql-general/2008-02/msg00689.php

I am running Postgres 8.2.3 and am seeing the following error messages in
my
logs:

LOG:  SSL SYSCALL error: Connection reset by peer
LOG:  could not receive data from client: Connection reset by peer
LOG:  unexpected EOF on client connection
LOG:  could not send data to client: Broken pipe

The end result is my users are connecting on TCPIP and their connection is
"hanging" and they aren't able to finish their database transaction.
Sometimes this will also cause the database server to be extremely slow.

I am using a fair number of default values in my postgresql.conf file.

Do you have any advice?  My configuration is below.  Thanks in advance--

Jeff Wigal


CONFIGURATION

#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

max_connections = 100

#superuser_reserved_connections = 2
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777
#bonjour_name = ''

#authentication_timeout = 60
ssl = on
#password_encryption = on
#db_user_namespace = off

# - TCP Keepalives -
# see 'man 7 tcp' for details

#tcp_keepalives_idle = 0
#tcp_keepalives_interval = 0
#tcp_keepalives_count = 0


#---------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#---------------------------------------------------------------------------

# - Memory -

shared_buffers = 1000
#temp_buffers = 1000
#max_prepared_transactions = 5
#work_mem = 1024
#maintenance_work_mem = 16384
#max_stack_depth = 2048

# - Free Space Map -

#max_fsm_pages = 20000
#max_fsm_relations = 1000

# - Kernel Resource Usage -

#max_files_per_process = 1000
#preload_libraries = ''

# - Cost-Based Vacuum Delay -

#vacuum_cost_delay = 0
#vacuum_cost_page_hit = 1
#vacuum_cost_page_miss = 10
#vacuum_cost_page_dirty = 20
#vacuum_cost_limit = 200

# - Background writer -

#bgwriter_delay = 200            # 10-10000 milliseconds between rounds
#bgwriter_lru_percent = 1.0        # 0-100% of LRU buffers scanned/round
#bgwriter_lru_maxpages = 5        # 0-1000 buffers max written/round
#bgwriter_all_percent = 0.333        # 0-100% of all buffers scanned/round
#bgwriter_all_maxpages = 5        # 0-1000 buffers max written/round


#---------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#---------------------------------------------------------------------------

autovacuum = on                # enable autovacuum subprocess?
#autovacuum_naptime = 60        # time between autovacuum runs, in secs
#autovacuum_vacuum_threshold = 1000    # min # of tuple updates before
                   # vacuum
#autovacuum_analyze_threshold = 500    # min # of tuple updates before
                   # analyze
#autovacuum_vacuum_scale_factor = 0.4    # fraction of rel size before
                   # vacuum
#autovacuum_analyze_scale_factor = 0.2    # fraction of rel size before
                   # analyze
#autovacuum_vacuum_cost_delay = -1    # default vacuum cost delay for
                   # autovac, -1 means use
                   # vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1    # default vacuum cost limit for
                   # autovac, -1 means use
                   # vacuum_cost_limit

#---------------------------------------------------------------------------
# LOCK MANAGEMENT
#---------------------------------------------------------------------------

#deadlock_timeout = 1000        # in milliseconds
#max_locks_per_transaction = 64        # min 10
# note: each lock table slot uses ~220 bytes of shared memory, and there
are
# max_locks_per_transaction * (max_connections +
max_prepared_transactions)
# lock table slots.

VMSTAT -S

       442368  total memory
        51800  used memory
            0  active memory
            0  inactive memory
       390568  free memory
            0  buffer memory
            0  swap cache
            0  total swap
            0  used swap
            0  free swap
      8882893 non-nice user cpu ticks
        58510 nice user cpu ticks
       952202 system cpu ticks
   1078995945 idle cpu ticks
      8062131 IO-wait cpu ticks
            0 IRQ cpu ticks
            0 softirq cpu ticks
            0 pages paged in
            0 pages paged out
            0 pages swapped in
            0 pages swapped out
            0 interrupts
   2452189757 CPU context switches
   1197496622 boot time
     48285711 forks

FREE -M

             total       used       free     shared    buffers     cached
Mem:           432         50        381          0          0          0
-/+ buffers/cache:         50        381
Swap:            0          0          0

------=_Part_3448_17789771.1207080938246
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div style="font-family: courier new,monospace;" class="gmail_quote">Much
the same as this person here:<br><br><a
href="http://archives.postgresql.org/pgsql-general/2008-02/msg00689.php"
target="_blank">http://archives.postgresql.org/pgsql-general/2008-02/msg00689.php</a><br>


<br>I am running Postgres 8.2.3 and am seeing the following error messages
in my logs:<br><br>LOG: &nbsp;SSL SYSCALL error: Connection reset by
peer<br>
LOG: &nbsp;could not receive data from client: Connection reset by
peer<br>LOG: &nbsp;unexpected EOF on client connection<br>

<font style="font-family: courier new,monospace;" size="2">LOG:&nbsp; 
could not send data to client: Broken pipe<br><br></font>The end result is
my users are connecting on TCPIP and their connection is
&quot;hanging&quot; and they aren&#39;t able to finish their database
transaction.&nbsp; Sometimes this will also cause the database server to
be extremely slow.&nbsp; <br>


<br>I am using a fair number of default values in my postgresql.conf
file.&nbsp; <br><br>Do you have any advice?&nbsp; My configuration is
below.&nbsp; Thanks in advance--<br><br>Jeff Wigal<br> <br>
<br>CONFIGURATION<br><br>#---------------------------------------------------------------------------<br>
# CONNECTIONS AND
AUTHENTICATION<br>#---------------------------------------------------------------------------<br>
<br># - Connection Settings -<br><br>
max_connections = 100<br><br>#superuser_reserved_connections = 2<br>
#unix_socket_directory = &#39;&#39;<br>#unix_socket_group = &#39;&#39;<br>
#unix_socket_permissions = 0777 &nbsp; &nbsp; &nbsp; <br>#bonjour_name =
&#39;&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br>
<br>#authentication_timeout = 60 &nbsp; &nbsp; &nbsp; <br>ssl = on<br>
#password_encryption = on<br>#db_user_namespace = off<br>
<br># - TCP Keepalives -<br># see &#39;man 7 tcp&#39; for details<br>
<br>#tcp_keepalives_idle = 0 &nbsp; &nbsp; &nbsp;&nbsp;
<br>#tcp_keepalives_interval = 0 &nbsp; &nbsp; &nbsp; <br>
#tcp_keepalives_count = 0 &nbsp; &nbsp;&nbsp; <br><br><br>
#---------------------------------------------------------------------------<br>#
RESOURCE USAGE (except WAL)<br>
#---------------------------------------------------------------------------<br><br>
# - Memory -<br><br>shared_buffers = 1000 &nbsp; &nbsp; &nbsp;
&nbsp;&nbsp; <br>
#temp_buffers = 1000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
<br>#max_prepared_transactions = 5 &nbsp; &nbsp; &nbsp; <br>
#work_mem = 1024 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
<br>#maintenance_work_mem = 16384 &nbsp; &nbsp; &nbsp; <br>
#max_stack_depth = 2048 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <br><br>#
- Free Space Map -<br>
<br>#max_fsm_pages = 20000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; <br>
#max_fsm_relations = 1000 &nbsp; &nbsp; &nbsp; <br><br># - Kernel Resource
Usage -<br>
<br>#max_files_per_process = 1000 &nbsp; &nbsp; &nbsp;
<br>#preload_libraries = &#39;&#39;<br>
<br># - Cost-Based Vacuum Delay -<br><br>
#vacuum_cost_delay = 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
<br>#vacuum_cost_page_hit = 1 &nbsp; &nbsp; &nbsp; <br>
#vacuum_cost_page_miss = 10 &nbsp; &nbsp; &nbsp;
<br>#vacuum_cost_page_dirty = 20 &nbsp; &nbsp; &nbsp; <br>
#vacuum_cost_limit = 200 &nbsp; &nbsp; &nbsp; <br><br># - Background
writer -<br>
<br>#bgwriter_delay = 200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#
10-10000 milliseconds between rounds<br>
#bgwriter_lru_percent = 1.0 &nbsp; &nbsp; &nbsp; &nbsp;# 0-100% of LRU
buffers scanned/round<br>#bgwriter_lru_maxpages = 5 &nbsp; &nbsp; &nbsp;
&nbsp;# 0-1000 buffers max written/round<br>
#bgwriter_all_percent = 0.333 &nbsp; &nbsp; &nbsp; &nbsp;# 0-100% of all
buffers scanned/round<br>#bgwriter_all_maxpages = 5 &nbsp; &nbsp; &nbsp;
&nbsp;# 0-1000 buffers max written/round<br>
<br><br>#---------------------------------------------------------------------------<br>
# AUTOVACUUM
PARAMETERS<br>#---------------------------------------------------------------------------<br>
<br>autovacuum = on &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;# enable autovacuum subprocess?<br>#autovacuum_naptime = 60 &nbsp;
&nbsp; &nbsp; &nbsp;# time between autovacuum runs, in secs<br>
#autovacuum_vacuum_threshold = 1000 &nbsp; &nbsp;# min # of tuple updates
before<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;# vacuum<br>
#autovacuum_analyze_threshold = 500 &nbsp; &nbsp;# min # of tuple updates
before <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;# analyze<br>
#autovacuum_vacuum_scale_factor = 0.4 &nbsp; &nbsp;# fraction of rel size
before <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;# vacuum<br>
#autovacuum_analyze_scale_factor = 0.2 &nbsp; &nbsp;# fraction of rel size
before <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;# analyze<br>
#autovacuum_vacuum_cost_delay = -1 &nbsp; &nbsp;# default vacuum cost
delay for <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;# autovac, -1 means use <br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#
vacuum_cost_delay<br>#autovacuum_vacuum_cost_limit = -1 &nbsp; &nbsp;#
default vacuum cost limit for <br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;#
autovac, -1 means use<br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp;# vacuum_cost_limit<br>
<br>#---------------------------------------------------------------------------<br>
# LOCK
MANAGEMENT<br>#---------------------------------------------------------------------------<br>
<br>#deadlock_timeout = 1000 &nbsp; &nbsp; &nbsp; &nbsp;# in
milliseconds<br>#max_locks_per_transaction = 64 &nbsp; &nbsp; &nbsp;
&nbsp;# min 10<br>
# note: each lock table slot uses ~220 bytes of shared memory, and there
are<br># max_locks_per_transaction * (max_connections +
max_prepared_transactions)<br>
# lock table slots.<br><br>VMSTAT -S<br>
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 442368&nbsp; total
memory<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 51800&nbsp; used
memory<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;
active
memory<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp; inactive memory<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 390568&nbsp; free
memory<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp; buffer memory<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;
swap
cache<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp; total swap<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;
used
swap<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp; free swap<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8882893 non-nice user cpu
ticks<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58510 nice user cpu
ticks<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 952202 system cpu
ticks<br>&nbsp;&nbsp; 1078995945 idle cpu ticks<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8062131 IO-wait cpu
ticks<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0 IRQ cpu ticks<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0
softirq cpu
ticks<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0 pages paged in<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 pages
paged
out<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0 pages swapped in<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 pages
swapped
out<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0 interrupts<br>
&nbsp;&nbsp; 2452189757 CPU context switches<br>&nbsp;&nbsp; 1197496622
boot time<br>
&nbsp;&nbsp;&nbsp;&nbsp; 48285711 forks<br><br>FREE -M<br>
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
used&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; free&nbsp;&nbsp;&nbsp;&nbsp;
shared&nbsp;&nbsp;&nbsp; buffers&nbsp;&nbsp;&nbsp;&nbsp; cached<br>
Mem:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
432&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
381&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<br>-/+
buffers/cache:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 381<br>
Swap:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0<br><br>
</div><br style="font-family: courier new,monospace;">

------=_Part_3448_17789771.1207080938246--