Strange problem when upgrading to 7.2 with pg_upgrade. - Mailing list pgsql-hackers

From Brian Hirt
Subject Strange problem when upgrading to 7.2 with pg_upgrade.
Date
Msg-id 1013732243.9962.345.camel@loopy.tr.berkhirt.com
Whole thread Raw
Responses Re: Strange problem when upgrading to 7.2 with pg_upgrade.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Strange problem when upgrading to 7.2 with pg_upgrade.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
I've started playing around with 7.2 on one of my development machines. 
I decided to try the pg_upgrade program, something I usually never do.

Anyway, I followed the steps in the pg_upgrade (going from 7.1.3 to
7.2), and then when I started the database up after the upgrade finished
and vacuumed one of my tables, i get these error messages from the
postmaster.  After this point I cannot restart the postmaster without
resetting the xlog.

I've kept the PGDATA directory around incase someone thinks this is
worth looking into, i would be more than happy to help out. 

If i migrate the data over manually like a always do (pg_dump then
pg_restore), i don't have any problems.  Part of the problem might be
path names for shared libraries specified in CREATE FUNCTION; I started
using pg back when it was version 6 before '$libdir' was supported and I
haven't bothered to take the absolute path names out yet -- i've just
updated it with each release (each release is installed in a different
location in case i need to roll back, and so i can test multiple version
at one time).  not sure if pg_upgrade even checks for this.

oby/pgsql@loopy pg_upgrade]$ /moby/pgsql-7.2/bin/postmaster -i -o -F -B
256 -D/mo
DEBUG:  database system was shut down at 2002-02-14 12:20:53 MST
DEBUG:  checkpoint record is at 1/A7000010
DEBUG:  redo record is at 1/A7000010; undo record is at 1/A7000010;
shutdown TRUE
DEBUG:  next transaction id: 589031; next oid: 19512
DEBUG:  database system is ready



DEBUG:  --Relation developer--
DEBUG:  Pages 669: Changed 0, Empty 0; Tup 51508: Vac 0, Keep 0, UnUsed
0.Total CPU 0.07s/0.03u sec elapsed 0.11 sec.
DEBUG:  Analyzing developer
FATAL 2:  read of clog file 0, offset 139264 failed: Success
DEBUG:  server process (pid 17786) exited with exit code 2
DEBUG:  terminating any other active server processes
NOTICE:  Message from PostgreSQL backend:The Postmaster has informed me that some other backenddied abnormally and
possiblycorrupted shared memory.I have rolled back the current transaction and amgoing to terminate your database
systemconnection and exit.Please reconnect to the database system and repeat your query.
 
DEBUG:  all server processes terminated; reinitializing shared memory
and semaphores
DEBUG:  database system was interrupted at 2002-02-14 12:20:58 MST
DEBUG:  checkpoint record is at 1/A7000010
DEBUG:  redo record is at 1/A7000010; undo record is at 1/A7000010;
shutdown TRUE
DEBUG:  next transaction id: 589031; next oid: 19512
DEBUG:  database system was not properly shut down; automatic recovery
in progress
DEBUG:  redo starts at 1/A7000050
FATAL 2:  read of clog file 0, offset 139264 failed: Success
DEBUG:  startup process (pid 17788) exited with exit code 2
DEBUG:  aborting startup due to startup process failure
[postgres@loopy pg_upgrade]$ 
[postgres@loopy pg_upgrade]$ 
[postgres@loopy pg_upgrade]$ 
[postgres@loopy pg_upgrade]$ df -k
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda8               248895    192496     43549  82% /
/dev/hda1                31079      4988     24487  17% /boot
/dev/hda5             24080660   6601476  17479184  28% /home
/dev/hda6              5044156   1930892   2857032  41% /usr
/dev/hda9               248895    133875    102170  57% /var
/dev/hdd1             59919196  39090008  20829188  66% /disk
oby/pgsql@loopy pg_upgrade]$ /moby/pgsql-7.2/bin/postmaster -i -o -F -B
256 -D/mo
DEBUG:  database system was interrupted being in recovery at 2002-02-14
12:21:06 MSTThis probably means that some data blocks are corruptedand you will have to use the last backup for
recovery.
DEBUG:  checkpoint record is at 1/A7000010
DEBUG:  redo record is at 1/A7000010; undo record is at 1/A7000010;
shutdown TRUE
DEBUG:  next transaction id: 589031; next oid: 19512
DEBUG:  database system was not properly shut down; automatic recovery
in progress
DEBUG:  redo starts at 1/A7000050
FATAL 2:  read of clog file 0, offset 139264 failed: Success
DEBUG:  startup process (pid 17793) exited with exit code 2
DEBUG:  aborting startup due to startup process failure
[postgres@loopy pg_upgrade]$ 




pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: [GENERAL] Postgres 7.2 - Updating rows in cursor problem
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Postgres 7.2 - Updating rows in cursor problem