Hi all
First, many thanks to all who helped with my crashes probs. Not fixed yet
but has been analyzed as a need to upgrade the BIOS.
Then as I said before, I have this problem with stats buffer I know have a
phantoom query:
Script started on Sun Feb 1 20:05:56 2004
~ 20:05:56: psql
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands
\g or terminate with semicolon to execute query \q to quit
ohp=# SELECT * from pg_stat_activity ;datid | datname | procpid | usesysid | usename |
current_query
| query_start
-------+----------+---------+----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------38920
|sdewitte | 27575 | 60004 | sdewitte | <IDLE>
| Sun 01 Feb 20:06:01.867356
2004MET38920 | sdewitte | 27577 | 60004 | sdewitte | select lieu_cod from lieu_position,perso_position,lieu where
ppos_perso_cod= 41980 and ppos_pos_cod = lpos_pos_cod and lpos_lieu_cod = lieu_cod and lieu_refuge = 'O' | Sun 01 Feb
20:06:01.8687472004 MET38920 | sdewitte | 6518 | 60004 | sdewitte | select count(*) from perso_identifie_objet
wherepio_perso_cod = 53314 and pio_obj_cod = 28204
| Sun 01 Feb 18:30:37.835876 2004 MET38915 | ohp | 27574 | 101 | ohp | <IDLE>
| Sun 01 Feb 20:06:00.472581 2004 MET
(4 rows)
ohp=# \q
~ 20:06:04: exit
script done on Sun Feb 1 20:06:04 2004
Feb 1 18:31:02 server postgres[1759]: [61-1] LOG: statistics buffer is full
Feb 1 18:31:06 server postgres[6658]: [23-1] LOG: recycled transaction log file "0000000A00000014"
Feb 1 18:31:40 server postgres[6868]: [23-1] LOG: duration: 5298.605 ms statement: VACUUM ANALYZE "public"."perso"
Feb 1 18:31:41 server postgres[6891]: [23-1] LOG: duration: 2350.284 ms statement: update perso set perso_der_connex
=now() where perso_cod = 30245
Feb 1 18:31:42 server postgres[6868]: [24-1] LOG: duration: 2438.490 ms statement: VACUUM ANALYZE
"public"."sessions_log"
Feb 1 18:31:45 server postgres[6888]: [23-1] LOG: recycled transaction log file "0000000A00000015"
Feb 1 18:31:45 server postgres[6888]: [24-1] LOG: recycled transaction log file "0000000A00000016"
As you can see, there was a stat buffer full at 18:31 and the process 6518
no longer exists but still shows up in pg_stat_activity.
How can I get rid of it short of restarting postgresql?
Regards,
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
