Skip site navigation (1) Skip section navigation (2)

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

From: Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Initdb panic: invalid record offset at 0/0 creating template1
Date: 2006-01-20 06:50:32
Message-ID: 43D08838.4040706@bull.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

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,
our too ...........we don't know what could be wrong,
is there a link with shared memory of our system ?
thanks for help


_here is the error :

_[pg_811(at)bt3 PGS]$ initdb -D /home/PGS/V811
The files belonging to this database system will be owned by user "pg_811".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.

fixing permissions on existing directory /home/PGS/V811 ... ok
creating directory /home/PGS/V811/global ... ok
creating directory /home/PGS/V811/pg_xlog ... ok
creating directory /home/PGS/V811/pg_xlog/archive_status ... ok
creating directory /home/PGS/V811/pg_clog ... ok
creating directory /home/PGS/V811/pg_subtrans ... ok
creating directory /home/PGS/V811/pg_twophase ... ok
creating directory /home/PGS/V811/pg_multixact/members ... ok
creating directory /home/PGS/V811/pg_multixact/offsets ... ok
creating directory /home/PGS/V811/base ... ok
creating directory /home/PGS/V811/base/1 ... ok
creating directory /home/PGS/V811/pg_tblspc ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /home/PGS/V811/base/1 ... PANIC:  invalid 
record offset at 0/0
child process was terminated by signal 6
initdb: removing contents of data directory "/home/PGS/V811"


_and in mode debug the end of  debugs messages are :_


DEBUG:  TZ "Etc/GMT+3" scores 0: at 1074121200 2004-01-14 20:00:00 std 
versus 2004-01-15 00:00:00 std
DEBUG:  TZ "Etc/UCT" scores 0: at 1074121200 2004-01-14 23:00:00 std 
versus 2004-01-15 00:00:00 std
DEBUG:  TZ "Etc/UTC" scores 0: at 1074121200 2004-01-14 23:00:00 std 
versus 2004-01-15 00:00:00 std
DEBUG:  TZ "Etc/GMT-12" scores 0: at 1074121200 2004-01-15 11:00:00 std 
versus 2004-01-15 00:00:00 std
DEBUG:  TZ "Etc/GMT-4" scores 0: at 1074121200 2004-01-15 03:00:00 std 
versus 2004-01-15 00:00:00 std
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
initdb: removing contents of data directory "/home/PGS/V811"
[pg_811(at)bt3 PGS]$


pgsql-novice by date

Next:From: Lynna LandstreetDate: 2006-01-20 07:36:27
Subject: Re: Problems with select statement
Previous:From: A. KretschmerDate: 2006-01-20 06:20:00
Subject: Re: save to another database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group