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
begin:vcard
fn;quoted-printable:J=C3=B8rgen Austvik
n;quoted-printable:Austvik;J=C3=B8rgen
org:Sun Microsystems;Database Technology Group
adr:;;Haakon VII gt. 7b;Trondheim;;NO-7485;Norway
email;internet:[EMAIL PROTECTED]
title:Senior Engineer
tel;work:+47 73 84 21 10
tel;fax:+47 73 84 21 01
tel;cell:+47 901 97 886
x-mozilla-html:FALSE
url:http://www.sun.com/
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
