From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | how can I get read of that |
Date: | 2004-02-01 19:11:03 |
Message-ID: | Pine.UW2.4.53.0402012006380.27620@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 2004 MET
38920 | 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.868747 2004 MET
38920 | sdewitte | 6518 | 60004 | sdewitte | select count(*) from perso_identifie_objet where pio_perso_cod = 53314 and pio_obj_cod = 28204 | Sun 01 Feb 18:30:37.835876 2004 MET
38915 | 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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-01 19:53:18 | Re: ALTER SEQUENCE: Missing feature? |
Previous Message | David Fetter | 2004-02-01 18:46:48 | ALTER SEQUENCE: Missing feature? |