Thread
-
Vacuum problems ... HELP !!!
kavoos <kavoos@issn.org> — 2001-06-01T12:17:17Z
Linux Suze 7.1 PG 7.1.2 psql -l List of databases Database | Owner -----------+---------- isds | postgres template0 | postgres template1 | postgres (3 rows) isds=# select version(); version --------------------------------------------------------------- PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2 (1 row) isds=# \d t008 Table "t008" Attribute | Type | Modifier -----------+--------------+---------- issn | character(9) | not null date_ | character(6) | not null status | character(1) | not null startdate | character(4) | not null enddate | character(4) | not null country | character(3) | not null frequency | character(1) | not null center | character(2) | not null type_ | character(1) | not null alphabet | character(1) | not null language | character(3) | not null medium | character(2) | not null Indices: t008_alphabet, t008_center, t008_country, t008_date, t008_enddate, t008_freq, t008_language, t008_medium, t008_pkey, t008_startdate, t008_status, t008_type vacuum verbose analyse T008; isds=# vacuum verbose analyse T008; NOTICE: --Relation t008-- NOTICE: Pages 17957: Changed 0, reaped 0, Empty 0, New 0; Tup 1005540: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 138, MaxLen 138; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 1.20s/0.10u sec. NOTICE: Index t008_pkey: Pages 7394; Tuples 1005540. CPU 0.64s/0.96u sec. NOTICE: Index t008_alphabet: Pages 2760; Tuples 1005540. CPU 0.23s/0.76u sec. NOTICE: Index t008_center: Pages 2760; Tuples 1005540. CPU 0.21s/0.76u sec. NOTICE: Index t008_country: Pages 2760; Tuples 1005540. CPU 0.25s/0.73u sec. NOTICE: Index t008_date: Pages 3313; Tuples 1005540. CPU 0.18s/0.81u sec. NOTICE: Index t008_enddate: Pages 2760; Tuples 1005540. CPU 0.18s/0.81u sec. NOTICE: Index t008_freq: Pages 2760; Tuples 1005540. CPU 0.12s/0.93u sec. NOTICE: Index t008_language: Pages 2760; Tuples 1005540. CPU 0.18s/0.80u sec. NOTICE: Index t008_medium: Pages 2760; Tuples 1005540. CPU 0.20s/0.96u sec. NOTICE: Index t008_startdate: Pages 2760; Tuples 1005540. CPU 0.20s/1.06u sec. NOTICE: Index t008_status: Pages 2760; Tuples 1005540. CPU 0.16s/1.10u sec. NOTICE: Index t008_type: Pages 2760; Tuples 1005540. CPU 0.21s/0.98u sec. NOTICE: Analyzing... pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. In pglog file : /usr/local/progs/pgsql/bin/postmaster: BackendStartup: pid 25501 user postgres db isds socket 5 /usr/local/progs/pgsql/bin/postmaster child[25501]: starting with (postgres -d2 -v131072 -p isds ) FindExec: found "/usr/local/progs/pgsql/bin/postgres" using argv[0] DEBUG: connection: host=[local] user=postgres database=isds DEBUG: InitPostgres DEBUG: StartTransactionCommand DEBUG: query: SELECT usesuper FROM pg_user WHERE usename = 'postgres' DEBUG: ProcessQuery DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: vacuum verbose analyse T008; DEBUG: ProcessUtility: vacuum verbose analyse T008; NOTICE: --Relation t008-- NOTICE: Pages 17957: Changed 0, reaped 0, Empty 0, New 0; Tup 1005540: Vac 0, Keep/VTL 0/0, Crash 0,NOTICE: Index t008_pkey: Pages 7394; Tuples 1005540. CPU 0.64s/0.96u sec. NOTICE: Index t008_alphabet: Pages 2760; Tuples 1005540. CPU 0.23s/0.76u sec. NOTICE: Index t008_center: Pages 2760; Tuples 1005540. CPU 0.21s/0.76u sec. NOTICE: Index t008_country: Pages 2760; Tuples 1005540. CPU 0.25s/0.73u sec. NOTICE: Index t008_date: Pages 3313; Tuples 1005540. CPU 0.18s/0.81u sec. NOTICE: Index t008_enddate: Pages 2760; Tuples 1005540. CPU 0.18s/0.81u sec. NOTICE: Index t008_freq: Pages 2760; Tuples 1005540. CPU 0.12s/0.93u sec. NOTICE: Index t008_language: Pages 2760; Tuples 1005540. CPU 0.18s/0.80u sec. NOTICE: Index t008_medium: Pages 2760; Tuples 1005540. CPU 0.20s/0.96u sec. NOTICE: Index t008_startdate: Pages 2760; Tuples 1005540. CPU 0.20s/1.06u sec. NOTICE: Index t008_status: Pages 2760; Tuples 1005540. CPU 0.16s/1.10u sec. NOTICE: Index t008_type: Pages 2760; Tuples 1005540. CPU 0.21s/0.98u sec. NOTICE: Analyzing... /usr/local/progs/pgsql/bin/postmaster: reaping dead processes... /usr/local/progs/pgsql/bin/postmaster: CleanupProc: pid 25501 exited with status 139 Server process (pid 25501) exited with status 139 at Fri Jun 1 13:58:47 2001 Terminating any active server processes... Server processes were terminated at Fri Jun 1 13:58:47 2001 Reinitializing shared memory and semaphores invoking IpcMemoryCreate(size=17760256) DEBUG: database system was interrupted at 2001-06-01 13:56:48 CEST DEBUG: CheckPoint record at (0, 2652790280) DEBUG: Redo record at (0, 2652790280); Undo record at (0, 0); Shutdown TRUE DEBUG: NextTransactionId: 1178; NextOid: 14543137 DEBUG: database system was not properly shut down; automatic recovery in progress... /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling reading 5 /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling reading 5 What is status 139 ? -
Re: Vacuum problems ... HELP !!!
Eric G. Miller <egm2@jps.net> — 2001-06-06T01:23:54Z
On Fri, Jun 01, 2001 at 02:17:17PM +0200, kavoos wrote: [snip] > /usr/local/progs/pgsql/bin/postmaster: reaping dead processes... > /usr/local/progs/pgsql/bin/postmaster: CleanupProc: pid 25501 exited > with status 139 > Server process (pid 25501) exited with status 139 at Fri Jun 1 13:58:47 > 2001 > Terminating any active server processes... > Server processes were terminated at Fri Jun 1 13:58:47 2001 > Reinitializing shared memory and semaphores > invoking IpcMemoryCreate(size=17760256) > DEBUG: database system was interrupted at 2001-06-01 13:56:48 CEST > DEBUG: CheckPoint record at (0, 2652790280) > DEBUG: Redo record at (0, 2652790280); Undo record at (0, 0); Shutdown > TRUE > DEBUG: NextTransactionId: 1178; NextOid: 14543137 > DEBUG: database system was not properly shut down; automatic recovery > in progress... > /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling > reading 5 > /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling > reading 5 > > What is status 139 ? 139 = 128 + 11 ; Sig 11 ? -- Eric G. Miller <egm2@jps.net>