Thread

1. initdb fails on ia64 SMP system

   Ian Grant <ian.grant@cl.cam.ac.uk> — 2002-08-20T10:54:16Z

   Hello PostgreSQL people,
   
   Thanks for making PostgreSQL, it's great. Here's a bug report.
   
   Thanks
   Ian
   
   Your name               : Ian Grant
   Your email address      : ian.grant@cl.cam.ac.uk
   
   System Configuration
   ---------------------
     Architecture (example: Intel Pentium)         : ia64, 4 way SMP
   
     Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.3 SMP kernel
   
     PostgreSQL version (example: PostgreSQL-7.2.1):   PostgreSQL-7.2.1
   
     Compiler used (example:  gcc 2.95.2)  : 2.96 20000731 (Red Hat Linux 7.1 
   2.96-85)
   
   Please enter a FULL description of your problem:
   -------------------------------------------------
   
   Running "initdb -D /data/path" fails. With debug enabled (-d switch) I get a 
   trace which ends:
   
   DEBUG:  inserting column 10 value 'byteain'
   DEBUG:  Typ == NULL, typeindex = 7
   DEBUG:   -> byteain
   DEBUG:  inserted
   DEBUG:  inserting column 11 value 'byteaout'
   DEBUG:  Typ == NULL, typeindex = 7
   ERROR:  Relation "pg_class" does not exist
   
   initdb failed.
   Removing /local/scratch/ig206/postgresql_data.
   
   Running the same command again causes it to fail somewhere different, e.g.:
   
   DEBUG:  inserting column 9 value '0'
   DEBUG:  Typ == NULL, typeindex = 9
   DEBUG:   -> 0
   DEBUG:  inserted
   DEBUG:  inserting column 10 value 'cidin'
   DEBUG:  Typ == NULL, typeindex = 7
   DEBUG:   -> cidin
   DEBUG:  inserted
   DEBUG:  inserting column 11 value 'cidout'
   DEBUG:  Typ == NULL, typeindex = 7
   ERROR:  Relation "pg_class" does not exist
   
   initdb failed.
   Removing /local/scratch/ig206/postgresql_data.
   
   It's not always pg_class which doesn't exist, e.g.:
   
   DEBUG:  inserting column 10 value 'boolin'
   DEBUG:  Typ == NULL, typeindex = 7
   DEBUG:   -> boolin
   DEBUG:  inserted
   DEBUG:  inserting column 11 value 'boolout'
   DEBUG:  Typ == NULL, typeindex = 7
   ERROR:  Relation "pg_proc" does not exist
   
   
   Please describe a way to repeat the problem.   Please try to provide a
   concise reproducible example, if at all possible: 
   -----------------------------------------------------------------------
   
   Build postgresql 7.2.1 on an SMP ia64 machine and run initdb?
   
   If you know how this problem might be fixed, list the solution below:
   ----------------------------------------------------------------------
   
   Sorry, I have no idea at all.
   
   -- 
   Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
   Phone: +44 1223 334420
   
   -- 
   Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
   Phone: +44 1223 334420
   
   
   
   

2. Re: initdb fails on ia64 SMP system

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-08-20T14:48:59Z

   Ian Grant <Ian.Grant@cl.cam.ac.uk> writes:
   >   Architecture (example: Intel Pentium)         : ia64, 4 way SMP
   >   Operating System (example: Linux 2.0.26 ELF)  : Linux 2.4.3 SMP kernel
   
   Does anything else work for you on that box?  I seem to recall that
   kernels before about 2.4.9 had serious SMP bugs.
   
   > Running the same command again causes it to fail somewhere different, e.g.:
   
   In that case I don't think it's our bug.  initdb is quite deterministic,
   at least when running on a deterministic platform ;-)
   
   			regards, tom lane