Stability of 9.1.0

From: pasman pasmański <pasman(dot)p(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Stability of 9.1.0
Date: 2011-09-14 07:38:23
Message-ID: CAOWY8=Ywvs9tz8LDQ7y7XBrEwCUdqdBrYuSNA1f2PamXDwuRVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I install postgresql 9.1.0 version Win32 from enterprisedb (WinXp+sp3).
Every about 0,5 - 6 hours server stops.
Whats going on ??

Below a example log file:

2011-09-14 08:49:37 CEST FATAL: the database system is starting up
2011-09-14 08:49:38 CEST LOG: checkpoint complete: wrote 2179 buffers
(26.6%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=1.766 s, sync=22.640 s, total=24.468 s; sync files=67,
longest=20.957 s, average=0.337 s
2011-09-14 08:49:38 CEST LOG: database system is ready to accept connections
2011-09-14 08:49:38 CEST LOG: autovacuum launcher started
2011-09-14 08:49:51 CEST FATAL: no pg_hba.conf entry for host
"126.100.42.8", user "Admin", database "www", SSL off
2011-09-14 08:49:52 CEST ERROR: relation "msysconf" does not exist at
character 63
2011-09-14 08:49:52 CEST STATEMENT: declare SQL_CUR08F966C8 cursor
for SELECT Config, nValue FROM MSysConf
2011-09-14 08:54:14 CEST LOG: duration: 171981.000 ms statement:
VACUUM VERBOSE
2011-09-14 08:56:52 CEST LOG: duration: 5760.674 ms plan:
Query Text:

SELECT

to_char("DataPliku",'DD-MM')

, count(*)::text

, count(case when "Pierwszy zwrot" is null then 1 end)::text

, count(case when "Pierwszy zwrot" is null and "Darmowe" is null then
1 end)::text

, rpad(min("Data"),8) AS "Biling od"

, rpad(max("Data"),8) AS "Biling do"
FROM ONLY "Bladpol2"
WHERE ("DataPliku">=current_date-21)
GROUP BY "DataPliku"
ORDER BY "DataPliku"

Sort (cost=25428.40..25428.45 rows=22 width=31) (actual
time=5760.584..5760.616 rows=16 loops=1)
Sort Key: "DataPliku"
Sort Method: quicksort Memory: 18kB
-> HashAggregate (cost=25427.14..25427.91 rows=22 width=31)
(actual time=5760.339..5760.484 rows=16 loops=1)
-> Bitmap Heap Scan on "Bladpol2" (cost=1971.04..23850.38
rows=105117 width=31) (actual time=324.139..5108.444 rows=106392
loops=1)
Recheck Cond: ("DataPliku" >= (('now'::text)::date - 21))
-> Bitmap Index Scan on "Bladpol2_DataPliku"
(cost=0.00..1944.76 rows=105117 width=0) (actual time=323.527..323.527
rows=106392 loops=1)
Index Cond: ("DataPliku" >= (('now'::text)::date - 21))
2011-09-14 08:56:52 CEST CONTEXT: SQL function "c12" statement 1
2011-09-14 08:56:52 CEST LOG: duration: 6031.000 ms statement:
BEGIN;declare "SQL_CUR018F9058" cursor with hold for SELECT * FROM
www.c12();fetch 30 in "SQL_CUR018F9058"
2011-09-14 08:56:52 CEST LOG: duration: 6038.352 ms plan:
Query Text: BEGIN;declare "SQL_CUR018F9058" cursor with hold for
SELECT * FROM www.c12();fetch 30 in "SQL_CUR018F9058"
Function Scan on c12 (cost=25.00..35.00 rows=1000 width=192) (actual
time=6038.269..6038.303 rows=16 loops=1)
2011-09-14 08:56:59 CEST LOG: could not receive data from client: No
connection could be made because the target machine actively refused
it.

2011-09-14 08:56:59 CEST LOG: unexpected EOF on client connection
2011-09-14 09:02:07 CEST LOG: server process (PID 3160) was
terminated by exception 0xC0000005
2011-09-14 09:02:07 CEST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-09-14 09:02:07 CEST LOG: terminating any other active server processes
2011-09-14 09:02:07 CEST WARNING: terminating connection because of
crash of another server process
2011-09-14 09:02:07 CEST DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2011-09-14 09:02:07 CEST HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2011-09-14 09:02:07 CEST WARNING: terminating connection because of
crash of another server process
2011-09-14 09:02:07 CEST DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2011-09-14 09:02:07 CEST HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2011-09-14 09:02:07 CEST WARNING: terminating connection because of
crash of another server process
2011-09-14 09:02:07 CEST DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2011-09-14 09:02:07 CEST HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2011-09-14 09:02:07 CEST LOG: all server processes terminated; reinitializing
2011-09-14 09:02:17 CEST FATAL: pre-existing shared memory block is
still in use
2011-09-14 09:02:17 CEST HINT: Check if there are any old server
processes still running, and terminate them.

Here are non-commented settings:

listen_addresses = '*' # what IP address(es) to listen on;
port = 5432 # (change requires restart)
max_connections = 10 # (change requires restart)
shared_buffers = 64MB # min 128kB
work_mem = 8MB # min 64kB
maintenance_work_mem = 64MB # min 1MB
fsync = on # turns forced synchronization on or off
synchronous_commit = local # synchronization level; on, off, or local
wal_buffers = 4MB # (change requires restart)
wal_writer_delay = 10s
checkpoint_segments = 10 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 1h # range 30s-1h
log_destination = 'stderr' # Valid values are combinations of
logging_collector = on # Enable capturing of stderr and csvlog
log_truncate_on_rotation = on # If on, an existing log file with the
log_min_duration_statement = 2s # -1 is disabled, 0 logs all statements
log_checkpoints = on
log_line_prefix = '%t ' # special values:
log_lock_waits = on # log lock waits >= deadlock_timeout
log_temp_files = 10MB # log temporary files equal or larger
track_activities = on
track_counts = on
track_functions = all # none, pl, all
autovacuum = on # Enable autovacuum subprocess? 'on'
log_autovacuum_min_duration = 10s # -1 disables, 0 logs all actions and
autovacuum_max_workers = 1 # max number of autovacuum subprocesses
statement_timeout = 24h # in milliseconds, 0 is disabled
datestyle = 'iso, ymd'
lc_messages = 'Polish_Poland.1250' # locale for system error message
lc_monetary = 'Polish_Poland.1250' # locale for monetary formatting
lc_numeric = 'Polish_Poland.1250' # locale for number formatting
lc_time = 'Polish_Poland.1250' # locale for time formatting
default_text_search_config = 'pg_catalog.simple'

--
------------
pasman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pasman pasmański 2011-09-14 08:10:33 Re: Stability of 9.1.0
Previous Message Toby Corkindale 2011-09-14 07:30:58 Re: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4