Обсуждение: Re: [HACKERS] initdb problem
> 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)
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!
> 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)