Hello,
I work with Agnès Bocchino who have posted a message on the NOVICE
mailing-list on an initdb error.
Maybe we must post this message in the GENERAL mailing-list.
I try, hoping someone knows this error.
Regards,
Alexandra DANTE
-------- Message original --------
Sujet: [NOVICE] Initdb panic: invalid record offset at 0/0 creating
template1
Date: Fri, 20 Jan 2006 07:50:32 +0100
De: Agnes Bocchino <agnes.bocchino@xxxxxxxx>
Pour: pgsql-novice@xxxxxxxxxxxxxx
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@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@bt3 PGS]$
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
