Re: Initdb panic: invalid record offset at 0/0 creating template1]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET>
Cc: pgsql-general(at)postgresql(dot)org, Agnes Bocchino <agnes(dot)bocchino(at)BULL(dot)NET>
Subject: Re: Initdb panic: invalid record offset at 0/0 creating template1]
Date: 2006-01-20 14:56:04
Message-ID: 17043.1137768964@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DANTE ALEXANDRA <ALEXANDRA(dot)DANTE(at)BULL(dot)NET> writes:
> we recompiled and built an RPM on IA64, release of postgresql : 8.1.1,
> on RHEL4 update 2,
> the installation of the rpm seem to be good,
> we install with --nodeps , and we indicate the path for the library's
> /opt/intel_cc_80/lib
> but when trying to init with the user account "pg_811",
> it fall in panic,

Whose RPM did you use, and did you use any special options? Why did
you feel it necessary to use --nodeps?

> DEBUG: invoking IpcMemoryCreate(size=11083776)
> LOG: database system was shut down at 2006-01-20 07:13:57 CET
> LOG: invalid primary checkpoint link in control file
> PANIC: invalid record offset at 0/0
> child process was terminated by signal 6

Hm, I wonder what's getting written into the files ... would you run
initdb with --noclean and then post the results of
* pg_controldata $PGDATA
* od -x $PGDATA/pg_xlog/000000010000000000000000
(I'm assuming that the file is there and od won't produce much output
... if it comes to megabytes don't post it ...)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2006-01-20 15:05:29 Re: autovacuum and temporary tables
Previous Message Neil Brandt 2006-01-20 14:26:07 Re: mac os x compile failure