Vacuum problems ... HELP !!! - Mailing list pgsql-general

From kavoos
Subject Vacuum problems ... HELP !!!
Date
Msg-id 3B1787CD.907A8EE0@issn.org
Whole thread Raw
Responses Re: Vacuum problems ... HELP !!!  ("Eric G. Miller" <egm2@jps.net>)
List pgsql-general
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 ?

pgsql-general by date:

Previous
From: kauchali@mweb.co.za (ak)
Date:
Subject: PostgreSQL and TPC benchmarks
Next
From: "Rick Saunders"
Date:
Subject: Something odd with Postgresql 6.5