Re: Stability of 9.1.0 - Mailing list pgsql-general

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@gmail.com>:
> 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