Skip site navigation (1) Skip section navigation (2)

BUG #5855: pgstat wait timeout

From: "Ondrej Pachner" <ondrej(dot)pachner(at)4internet(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5855: pgstat wait timeout
Date: 2011-01-28 16:45:34
Message-ID: 201101281645.p0SGjYOP045321@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5855
Logged by:          Ondrej Pachner
Email address:      ondrej(dot)pachner(at)4internet(dot)cz
PostgreSQL version: 9.0.1
Operating system:   Debian GNU Linux - stable
Description:        pgstat wait timeout
Details: 

all counters on zero and warning about wait timeout..

postgres=> SELECT * FROM pg_stat_database;
WARNING:  pgstat wait timeout
   datid   |      datname      | numbackends | xact_commit | xact_rollback |
blks_read | blks_hit | tup_returned | tup_fetched | tup_inserted |
tup_updated | tup_deleted 
-----------+-------------------+-------------+-------------+---------------+
-----------+----------+--------------+-------------+--------------+---------
----+-------------
     11866 | template0         |           0 |           0 |             0 |
        0 |        0 |            0 |           0 |            0 |          
0 |           0
     11874 | postgres          |           1 |           0 |             0 |
        0 |        0 |            0 |           0 |            0 |          
0 |           0
 214340298 | eims_ejb_total_50 |           3 |           0 |             0 |
        0 |        0 |            0 |           0 |            0 |          
0 |           0
         1 | template1         |           0 |           0 |             0 |
        0 |        0 |            0 |           0 |            0 |          
0 |           0
(4 rows)

-----------------------------------
configuration:

listen_addresses = '*'		
port = 5432				
max_connections = 100			
shared_buffers = 512MB			
work_mem = 128MB				
maintenance_work_mem = 256MB		
effective_cache_size = 12288MB
default_statistics_target = 10000	
log_destination = 'stderr'		
logging_collector = on		
log_directory = 'pg_log'		
log_truncate_on_rotation = on		
log_rotation_age = 1d			
log_rotation_size = 0		
log_min_messages = warning		
log_min_duration_statement = 300	
log_connections = off
log_disconnections = off
log_duration = off
log_line_prefix = '%t [%p]: [%l-1] '			
log_lock_waits = on			
track_counts = on
log_planner_stats = on
autovacuum = on			
log_autovacuum_min_duration = 300	
autovacuum_max_workers = 3		
autovacuum_naptime = 1min		
autovacuum_vacuum_threshold = 50	
autovacuum_analyze_threshold = 50	
autovacuum_vacuum_scale_factor = 0.2	
autovacuum_analyze_scale_factor = 0.1	
autovacuum_freeze_max_age = 200000000	
autovacuum_vacuum_cost_delay = 20ms	
autovacuum_vacuum_cost_limit = -1	
datestyle = 'iso, dmy'
lc_messages = 'cs_CZ.utf8'			
lc_monetary = 'cs_CZ.utf8'			
lc_numeric = 'cs_CZ.utf8'			
lc_time = 'cs_CZ.utf8'				
default_text_search_config = 'pg_catalog.simple'
custom_variable_classes = 'pljava'
dynamic_library_path ='$libdir:/usr/local/postgresql-9.0.1/lib/postgresql'
pljava.classpath='/usr/local/postgresql-9.0.1/lib/postgresql/pljava.jar:/usr
/local/postgresql-9.0.1/lib/postgresql/jbossall-client.jar'

-------------
8CPUs, 16G of RAM, uname -a gives:
Linux tbdb-901 2.6.26-2-xen-amd64 #1 SMP Thu Sep 16 16:32:15 UTC 2010 x86_64
GNU/Linux

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-01-28 17:18:10
Subject: Re: BUG #5855: pgstat wait timeout
Previous:From: Bruce MomjianDate: 2011-01-28 16:18:20
Subject: Re: BUG #5854: base64 decode returns bytea and no text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group