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

7.3B2 initdb fails

From: Nic Ferrier <nferrier(at)tapsellferrier(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 7.3B2 initdb fails
Date: 2002-10-02 22:26:46
Message-ID: 87k7l05vfd.fsf@pooh-sticks-bridge.tapsellferrier.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugs
I built 7.3B2 from CVS and ran initdb: it fails. Here's an example of
the console session:

demo >>>
$ initdb -D /usr/local/pgdata

The files belonging to this database system will be owned by user "nferrier".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgdatatest... ok
creating directory /usr/local/pgdatatest/base... ok
creating directory /usr/local/pgdatatest/global... ok
creating directory /usr/local/pgdatatest/pg_xlog... ok
creating directory /usr/local/pgdatatest/pg_clog... ok
creating template1 database in /usr/local/pgdatatest/base/1... 
initdb failed.
Removing /usr/local/pgdatatest.

<<< end of console messages.


Running initdb with debugging turned on generates too big a trace,
however I think these are the relevant bits:



>>>>
Running with debug mode on.

initdb variables:
  PGDATA=/usr/local/pgdatatest
  datadir=/usr/local/share/postgresql
  PGPATH=/usr/local/bin
  ENCODING=
  ENCODINGID=0
  POSTGRES_SUPERUSERNAME=nferrier
  POSTGRES_BKI=/usr/local/share/postgresql/postgres.bki
  POSTGRES_DESCR=/usr/local/share/postgresql/postgres.description
  POSTGRESQL_CONF_SAMPLE=/usr/local/share/postgresql/postgresql.conf.sample
  PG_HBA_SAMPLE=/usr/local/share/postgresql/pg_hba.conf.sample
  PG_IDENT_SAMPLE=/usr/local/share/postgresql/pg_ident.conf.sample
The files belonging to this database system will be owned by user "nferrier".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgdatatest... ok
creating directory /usr/local/pgdatatest/base... ok
creating directory /usr/local/pgdatatest/global... ok
creating directory /usr/local/pgdatatest/pg_xlog... ok
creating directory /usr/local/pgdatatest/pg_clog... ok
creating template1 database in /usr/local/pgdatatest/base/1... DEBUG:  invoking IpcMemoryCreate(size=1179648)
LOG:  database system was shut down at 2002-10-02 23:12:53 BST
LOG:  checkpoint record is at 0/10
LOG:  redo record is at 0/10; undo record is at 0/10; shutdown TRUE
LOG:  next transaction id: 3; next oid: 16384
LOG:  database system is ready
DEBUG:  start transaction
DEBUG:  creating bootstrap relation pg_proc...
DEBUG:  column proname name
DEBUG:  column pronamespace oid
DEBUG:  column proowner int4
DEBUG:  column prolang oid
DEBUG:  column proisagg bool
DEBUG:  column prosecdef bool
DEBUG:  column proisstrict bool
DEBUG:  column proretset bool
DEBUG:  column provolatile char
DEBUG:  column pronargs int2
DEBUG:  column prorettype oid
DEBUG:  column proargtypes oidvector
DEBUG:  column prosrc text
DEBUG:  column probin bytea
DEBUG:  column proacl _aclitem
DEBUG:  commit transaction
DEBUG:  start transaction
.
.
.
DEBUG:  start transaction
DEBUG:  bootstrap relation created
DEBUG:  commit transaction
DEBUG:  start transaction
DEBUG:  inserting row with oid 1247...
DEBUG:  inserting column 0 value 'pg_type'
DEBUG:  Typ != NULL
DEBUG:   -> pg_type
DEBUG:  inserted
DEBUG:  inserting column 1 value '11'
DEBUG:  Typ != NULL
DEBUG:   -> 11
DEBUG:  inserted
DEBUG:  inserting column 2 value '71'
DEBUG:  Typ != NULL
DEBUG:   -> 71
DEBUG:  inserted
DEBUG:  inserting column 3 value '1'
DEBUG:  Typ != NULL
DEBUG:   -> 1
DEBUG:  inserted
DEBUG:  inserting column 4 value '0'
DEBUG:  Typ != NULL
DEBUG:   -> 0
DEBUG:  inserted
DEBUG:  inserting column 5 value '1247'
DEBUG:  Typ != NULL
DEBUG:   -> 1247
DEBUG:  inserted
DEBUG:  inserting column 6 value '0'
DEBUG:  Typ != NULL
DEBUG:   -> 0
DEBUG:  inserted
DEBUG:  inserting column 7 value '0'
DEBUG:  Typ != NULL
ERROR:  Bad float4 input format -- underflow
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  exit(1)

initdb failed.
Removing /usr/local/pgdatatest.
<<< end of debug.


Here's the standard information:
I'm using Debian GNU-Linux for PPC on an iMac. 7.2 builds and
initdb's ok.


Nic


Responses

pgsql-bugs by date

Next:From: Philip ComptonDate: 2002-10-03 01:43:29
Subject: Passing character data to C function
Previous:From: Mark StosbergDate: 2002-10-02 19:17:03
Subject: Re: 7.3b2 initdb fails with semaphore error (solved)

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