I think that using any function in plperlu language stops the server.
Perl version is 5.14 from activestate.
2011/9/14, pasman pasmański <pasman.p@xxxxxxxxx>:
> 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
>
--
------------
pasman
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
