Vacuum problems ... HELP !!!

From: kavoos <kavoos(at)issn(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuum problems ... HELP !!!
Date: 2001-06-01 12:17:17
Message-ID: 3B1787CD.907A8EE0@issn.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message niamul 2001-06-01 13:18:29 getting primary and foreign using jdbc
Previous Message N.A. 2001-06-01 12:15:31 Postgres java interface test error