Re: Buildfarm member gypsy_moth seems not to like alignment patch

Tom Lane wrote:
> It looks like gypsy_moth has been failing like this:
>
> creating directory /export/home/tmp/pg-test/build-suncc/HEAD/pgsql.21325/src/test/regress/./tmp_check/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers/max_fsm_pages ... 32MB/204800
> creating configuration files ... ok
> creating template1 database in /export/home/tmp/pg-test/build-suncc/HEAD/pgsql.21325/src/test/regress/./tmp_check/data/base/1 ... ok
> initializing pg_authid ... ok
> initializing dependencies ... ok
> creating system views ... Bus Error - core dumped
> child process exited with exit code 138
> initdb: data directory "/export/home/tmp/pg-test/build-suncc/HEAD/pgsql.21325/src/test/regress/./tmp_check/data" not removed at user's request
>
> since I put in this patch:
> http://archives.postgresql.org/pgsql-committers/2008-02/msg00270.php
>
> This is unfortunate and surprising, since that patch was intended to
> prevent compilers from making unsafe alignment assumptions, but it sure
> looks like this compiler has instead added a new one. Could you poke
> into it --- at least get a stack trace from the core dump?

Running initdb with debug:
------8<------------8<------------8<------------8<------------8<------------8<------
$./initdb -D /export/home/tmp/test -d -n
<snip>
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 0/1/35, nestlvl: 1, children: <>
DEBUG: commit transaction
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... Bus Error - core dumped
child process exited with exit code 138
initdb: data directory "/export/home/tmp/test" not removed at user's request
------8<------------8<------------8<------------8<------------8<------------8<------

Stack trace:
------8<------------8<------------8<------------8<------------8<------------8<------
$ /opt/SUNWspro8/bin/dbx long_path/postgres core

program terminated by signal BUS (invalid address alignment)
Current function is toast_save_datum
1171 SET_VARSIZE(&chunk_data, chunk_size + VARHDRSZ);

(dbx) where

=>[1] toast_save_datum(rel = 0xcd8ff8, value = 14406480U, use_wal =
\001', use_fsm = '\001'), line 1171 in "tuptoaster.c"
[2] toast_insert_or_update(rel = 0xcd8ff8, newtup = 0xdba3e8, oldtup
= (nil), use_wal = '\001', use_fsm = '\001'), line 700 in "tuptoaster.c"
[3] heap_insert(relation = 0xcd8ff8, tup = 0xdba3e8, cid = 10U,
use_wal = '\001', use_fsm = '\001'), line 1815 in "heapam.c"
[4] simple_heap_insert(relation = 0xcd8ff8, tup = 0xdba3e8), line
1937 in "heapam.c"
[5] InsertRule(rulname = 0xdaf730 "_RETURN", evtype = 1, eventrel_oid
= 10950U, evslot_index = -1, evinstead = '\001', event_qual = (nil),
action = 0xdaf760, replace = '\0'), line 134 in "rewriteDefine.c"
[6] DefineQueryRewrite(rulename = 0xdaf730 "_RETURN", event_relid =
10950U, event_qual = (nil), event_type = CMD_SELECT, is_instead =
'\001', replace = '\0', action = 0xdaf760), line 461 in "rewriteDefine.c"
[7] DefineViewRules(viewOid = 10950U, viewParse = 0xdab070, replace =
'\0'), line 275 in "view.c"
[8] DefineView(stmt = 0xd3f920, queryString = 0xd9b888 "/*\n *
PostgreSQL System Views\n *\n * Copyright (c) 1996-2008, PostgreSQL
Global Development Group\n *\n * $PostgreSQL:
pgsql/src/backend/catalog/system_views.sql,v 1.47 2007/10/22 20:13:37
tgl Exp $\n */\n\nCREATE VIEW pg_roles AS \n SELECT \n
rolname,\n rolsuper,\n rolinherit,\n
rolcreaterole,\n rolcreatedb,\n rolcatupdate,\n
rolcanlogin,\n rolconnlimit,\n '********'::text as
rolpassword,\n rolvaliduntil,\n rolconfig,\n oid\n
FROM pg_aut" ...), line 447 in "view.c"
[9] ProcessUtility(parsetree = 0xd3f920, queryString = 0xd9b888 "/*\n
* PostgreSQL System Views\n *\n * Copyright (c) 1996-2008, PostgreSQL
Global Development Group\n *\n * $PostgreSQL:
pgsql/src/backend/catalog/system_views.sql,v 1.47 2007/10/22 20:13:37
tgl Exp $\n */\n\nCREATE VIEW pg_roles AS \n SELECT \n
rolname,\n rolsuper,\n rolinherit,\n
rolcreaterole,\n rolcreatedb,\n rolcatupdate,\n
rolcanlogin,\n rolconnlimit,\n '********'::text as
rolpassword,\n rolvaliduntil,\n rolconfig,\n oid\n
FROM pg_aut" ..., params = (nil), isTopLevel = '\0', dest =
0xbb1534, completionTag = 0xffbef64c ""), line 894 in "utility.c"
[10] PortalRunUtility(portal = 0xd39e68, utilityStmt = 0xd3f920,
isTopLevel = '\0', dest = 0xbb1534, completionTag = 0xffbef64c ""), line
1178 in "pquery.c"
[11] PortalRunMulti(portal = 0xd39e68, isTopLevel = '\0', dest =
0xbb1534, altdest = 0xbb1534, completionTag = 0xffbef64c ""), line 1266
in "pquery.c"
[12] PortalRun(portal = 0xd39e68, count = 2147483647, isTopLevel =
'\0', dest = 0xbb1534, altdest = 0xbb1534, completionTag = 0xffbef64c
""), line 814 in "pquery.c"
[13] exec_simple_query(query_string = 0xd2fe38 "/*\n * PostgreSQL
System Views\n *\n * Copyright (c) 1996-2008, PostgreSQL Global
Development Group\n *\n * $PostgreSQL:
pgsql/src/backend/catalog/system_views.sql,v 1.47 2007/10/22 20:13:37
tgl Exp $\n */\n\nCREATE VIEW pg_roles AS \n SELECT \n
rolname,\n rolsuper,\n rolinherit,\n
rolcreaterole,\n rolcreatedb,\n rolcatupdate,\n
rolcanlogin,\n rolconnlimit,\n '********'::text as
rolpassword,\n rolvaliduntil,\n rolconfig,\n oid\n
FROM pg_aut" ...), line 969 in "postgres.c"
[14] PostgresMain(argc = 9, argv = 0xc3c364, username = 0xc3a380
"autopg"), line 3531 in "postgres.c"
[15] main(argc = 10, argv = 0xc3c360), line 186 in "main.c"

(dbx) print chunk_data
chunk_data = {
hdr = {
vl_len_ = ""
vl_dat = ""
}
data = ""
}
(dbx) print chunk_size
chunk_size = 1996
------8<------------8<------------8<------------8<------------8<------------8<------

If I can be to further assistance - please let me know.

-J
--

Jørgen Austvik, Software Engineering - QA
Sun Microsystems Database Technology Group