> Bruce,
> 
> It does not seem to be an initdb problem per se, as the initdb
> proceeds normally and I end up with a database that works to some
> extent.
> 
> If you have seen my recent posts and backtraces you will see that,
> after initdb'ing, I connect to the template1 database and do a
> "select * from pg_user;" is get an error.
> 
> template1=> select * from pg_user;
> ERROR:  Relation pg_user does not have attribute usename
> template1=> 
> 
> If I attempt to create a table I get a core dump.
> 
> It smells of an alignment problem (I'm on SPARC/Linux) as the
> error is in a system call memmove() and the library call where
> it bombs is _wordcopy_fwd_aligned ().

OK.

I have fixed the bootstrap process so it properly assignes attalign
values.  It was not need with single-key indexes, but is needed now.

Also, I found many cases where system columns where missing
pg_attribute.attalign values.  The values where ' '.   The system has no
idea what to do with such a value.

Would someone check a running 6.3.2 system and let me know if there are
any blank attalign values?  It think you will find that there are.  The
current patch fixes that.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Mon, 24 Aug 1998 15:18:28 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] initdb problem
On Mon, Aug 24, 1998 at 03:18:28PM -0400, Bruce Momjian wrote:
> Would someone check a running 6.3.2 system and let me know if there are
> any blank attalign values?  It think you will find that there are.  The
> current patch fixes that.

echo "select * from pg_attribute where attalign != 'i' and attalign !=
'c'and attalign != 'd' and attalign!='s';"|psql template1

gives:

attrelid|attname       |atttypid|attdisbursion|attlen|attnum|attnelems|attcacheoff|atttypmod|attbyval|attisset|attalign|attnotnull|atthasdef
--------+--------------+--------+-------------+------+------+---------+-----------+---------+--------+--------+--------+----------+---------
   16536|inhrel        |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16536|inhparent     |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16536|inhseqno      |      23|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indexrelid    |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indrelid      |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indproc       |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indkey        |      22|            0|    16|     4|        0|         -1|       -1|f       |f       |        |f         |f        
   16547|indclass      |      30|            0|    32|     5|        0|         -1|       -1|f       |f       |        |f         |f        
   16547|indisclustered|      16|            0|     1|     6|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indislossy    |      16|            0|     1|     7|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indhaskeytype |      16|            0|     1|     8|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indisunique   |      16|            0|     1|     9|        0|         -1|       -1|t       |f       |        |f         |f        
   16547|indpred       |      25|            0|    -1|    10|        0|         -1|       -1|f       |f       |        |f         |f        
   16565|verrelid      |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16565|verbaseid     |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16565|vertime       |      23|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16577|starelid      |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16577|staattnum     |      21|            0|     2|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16577|staop         |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16577|stalokey      |      25|            0|    -1|     4|        0|         -1|       -1|f       |f       |        |f         |f        
   16577|stahikey      |      25|            0|    -1|     5|        0|         -1|       -1|f       |f       |        |f         |f        
   16590|oprname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   16590|oprowner      |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprprec       |      21|            0|     2|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprkind       |      18|            0|     1|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprisleft     |      16|            0|     1|     5|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprcanhash    |      16|            0|     1|     6|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprleft       |      26|            0|     4|     7|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprright      |      26|            0|     4|     8|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprresult     |      26|            0|     4|     9|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprcom        |      26|            0|     4|    10|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprnegate     |      26|            0|     4|    11|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprlsortop    |      26|            0|     4|    12|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprrsortop    |      26|            0|     4|    13|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprcode       |      24|            0|     4|    14|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprrest       |      24|            0|     4|    15|        0|         -1|       -1|t       |f       |        |f         |f        
   16590|oprjoin       |      24|            0|     4|    16|        0|         -1|       -1|t       |f       |        |f         |f        
   16614|opcname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   16614|opcdeftype    |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amname        |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   16624|amowner       |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amkind        |      18|            0|     1|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amstrategies  |      21|            0|     2|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amsupport     |      21|            0|     2|     5|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amgettuple    |      24|            0|     4|     6|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|aminsert      |      24|            0|     4|     7|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amdelete      |      24|            0|     4|     8|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amgetattr     |      24|            0|     4|     9|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amsetlock     |      24|            0|     4|    10|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amsettid      |      24|            0|     4|    11|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amfreetuple   |      24|            0|     4|    12|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|ambeginscan   |      24|            0|     4|    13|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amrescan      |      24|            0|     4|    14|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amendscan     |      24|            0|     4|    15|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|ammarkpos     |      24|            0|     4|    16|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amrestrpos    |      24|            0|     4|    17|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amopen        |      24|            0|     4|    18|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amclose       |      24|            0|     4|    19|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|ambuild       |      24|            0|     4|    20|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amcreate      |      24|            0|     4|    21|        0|         -1|       -1|t       |f       |        |f         |f        
   16624|amdestroy     |      24|            0|     4|    22|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopid        |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopclaid     |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopopr       |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopstrategy  |      21|            0|     2|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopselect    |      24|            0|     4|     5|        0|         -1|       -1|t       |f       |        |f         |f        
   16654|amopnpages    |      24|            0|     4|     6|        0|         -1|       -1|t       |f       |        |f         |f        
   16838|amid          |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16838|amopclaid     |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16838|amproc        |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16838|amprocnum     |      21|            0|     2|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16901|lanname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   16901|lanispl       |      16|            0|     1|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16901|lanpltrusted  |      16|            0|     1|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16901|lanplcallfoid |      26|            0|     4|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16901|lancompiler   |      25|            0|    -1|     5|        0|         -1|       -1|f       |f       |        |f         |f        
   16914|parproid      |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   16914|parnum        |      21|            0|     2|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16914|parbound      |      18|            0|     1|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16914|partype       |      26|            0|     4|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   16978|aggowner      |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggtransfn1   |      24|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggtransfn2   |      24|            0|     4|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggfinalfn    |      24|            0|     4|     5|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggbasetype   |      26|            0|     4|     6|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggtranstype1 |      26|            0|     4|     7|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggtranstype2 |      26|            0|     4|     8|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|aggfinaltype  |      26|            0|     4|     9|        0|         -1|       -1|t       |f       |        |f         |f        
   16978|agginitval1   |      25|            0|    -1|    10|        0|         -1|       -1|f       |f       |        |f         |f        
   16978|agginitval2   |      25|            0|    -1|    11|        0|         -1|       -1|f       |f       |        |f         |f        
   17030|iplrel        |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   17030|iplipl        |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   17030|iplseqno      |      23|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   17041|inhproname    |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17041|inhargrel     |      26|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   17041|inhdefrel     |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   17041|inhproc       |      26|            0|     4|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   17053|rulename      |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17053|ev_type       |      18|            0|     1|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   17053|ev_class      |      26|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   17053|ev_attr       |      21|            0|     2|     4|        0|         -1|       -1|t       |f       |        |f         |f        
   17053|is_instead    |      16|            0|     1|     5|        0|         -1|       -1|t       |f       |        |f         |f        
   17053|ev_qual       |      25|            0|    -1|     6|        0|         -1|       -1|f       |f       |        |f         |f        
   17053|ev_action     |      25|            0|    -1|     7|        0|         -1|       -1|f       |f       |        |f         |f        
   17068|relname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17068|listenerpid   |      23|            0|     4|     2|        0|         -1|       -1|t       |f       |        |f         |f        
   17068|notification  |      23|            0|     4|     3|        0|         -1|       -1|t       |f       |        |f         |f        
   17079|objoid        |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   17079|description   |      25|            0|    -1|     2|        0|         -1|       -1|f       |f       |        |f         |f        
   17089|mkoidname     |     911|            0|    36|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17092|mkoidint2     |     810|            0|     6|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17095|attrelid      |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
   17101|proname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17104|prosrc        |      25|            0|    -1|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17110|typname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17116|relname       |      19|            0|    32|     1|        0|         -1|       -1|f       |f       |        |f         |f        
   17129|objoid        |      26|            0|     4|     1|        0|         -1|       -1|t       |f       |        |f         |f        
(118 rows)

EOF

Michael
-- 
Michael Meskes			meskes@online-club.de, meskes@debian.org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

Tue, 25 Aug 1998 09:01:11 +0200
Michael Meskes <meskes@online-club.de>
Re: [HACKERS] initdb problem
> On Mon, Aug 24, 1998 at 03:18:28PM -0400, Bruce Momjian wrote:
> > Would someone check a running 6.3.2 system and let me know if there are
> > any blank attalign values?  It think you will find that there are.  The
> > current patch fixes that.
> 
> echo "select * from pg_attribute where attalign != 'i' and attalign !=
> 'c'and attalign != 'd' and attalign!='s';"|psql template1

Yikes.  Good thing that is fixed now.


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Tue, 25 Aug 1998 13:32:27 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] initdb problem