Re: [GENERAL] Still big problems with pg_dump! - Mailing list pgsql-admin

gdb gives me this:

bash-2.05$ adb /usr/local/pgsql/bin/postgres
/data/postgres/base/17903709/core
core file = /data/postgres/base/17903709/core -- program
``/usr/local/pgsql/bin/postgres'' on platform SUNW,Ultra-60
SIGBUS: Bus Error
$c
AllocSetAlloc+0x18c(476120, 3, 226018, 0, 0, 13)
MemoryContextAlloc+0x68(476120, 3, 70670000, 7efefeff, 81010100, ff00)
MemoryContextStrdup+0x28(476120, 4c8568, ffffffff, fffffff8, 0, ffbfe541)
make_greater_string+0x1c(4c8568, 13, 297, 4c8730, 0, ffbfe5d1)
prefix_selectivity+0xcc(4c0780, 4c7ab8, 4c8568, ffbfe670, ffbfe68b,
ffbfe6a0)
patternsel+0x278(ffbfe7a0, 0, 476120, 0, 0, ffbfe728)
likesel+0x10(ffbfe7a0, ffbfe7a0, 1d7080, fffffff8, 0, ffbfe809)
OidFunctionCall4+0x124(71b, 4c0780, 4b7, 4c7b90, 1, ffbfe7e1)
restriction_selectivity+0x64(4c0780, 4b7, 4c7b90, 1, 0, ffbfe8a0)
clauselist_selectivity+0x164(4c0780, 4c8478, 1, 0, 0, 4c8295)
restrictlist_selectivity+0x2c(4c0780, 4c7c18, 1, 0, 0, ff0000)
set_baserel_size_estimates+0x2c(4c0780, 4c7d70, ffffffff, fffffff8, 0,
4c83f9)
set_plain_rel_pathlist+0x18(4c0780, 4c7d70, 4c0808, 53, 4c0348, 20)
set_base_rel_pathlists+0xf8(4c0780, 4c8460, 1, 0, 0, 4c7c00)
make_one_rel+0xc(4c0780, 0, ffbfecb8, ffbfecb0, 0, 0)
subplanner+0x148(4c0780, 4c7cb8, 0, 0, 0, 0)
query_planner+0x98(4c0780, 4c7a48, 0, 0, 0, 0)
grouping_planner+0x7cc(4c0780, bff00000, 0, ff13a000, 0, 0)
subquery_planner+0x260(4c0780, bff00000, 0, 7efefeff, 81010100, ff0000)
planner+0x54(4c0780, 4c1e00, 4c15e0, fffffff8, 0, ffbfffd5)
pg_plan_query+0x54(4c0780, 29b99c, 0, 53, 4c0348, 20)
pg_exec_query_string+0x388(4c0348, 2, 476010, 4c0330, 800000, 0)
PostgresMain+0x1398(5, ffbff2d0, 40c1d9, 473, 0, ffbff1c8)
DoBackend+0x7d8(40c0a8, 1, 22730, 1552dc, 0, 40c2d9)
BackendStartup+0xb0(40c0a8, 5, ffbff800, ffbff5d8, ffbff658, 0)
ServerLoop+0x370(297024, 49a0, 0, 3f1f88, 297004, 2d560000)
PostmasterMain+0xbe4(5, 3f2980, 65720000, 0, 65720000, 65720000)
main+0x294(5, ffbffd8c, ffbffda4, 3e64c0, 0, 0)
_start+0x5c(0, 0, 0, 0, 0, 0)
$C
ffbfe340 AllocSetAlloc+0x18c(476120, 3, 226018, 0, 0, 13)
ffbfe3e0 MemoryContextAlloc+0x68(476120, 3, 70670000, 7efefeff,
81010100, ff00)
ffbfe450 MemoryContextStrdup+0x28(476120, 4c8568, ffffffff, fffffff8, 0,
ffbfe541)
ffbfe4c8 make_greater_string+0x1c(4c8568, 13, 297, 4c8730, 0, ffbfe5d1)
ffbfe548 prefix_selectivity+0xcc(4c0780, 4c7ab8, 4c8568, ffbfe670,
ffbfe68b, ffbfe6a0)
ffbfe5d8 patternsel+0x278(ffbfe7a0, 0, 476120, 0, 0, ffbfe728)
ffbfe6b0 likesel+0x10(ffbfe7a0, ffbfe7a0, 1d7080, fffffff8, 0, ffbfe809)
ffbfe728 OidFunctionCall4+0x124(71b, 4c0780, 4b7, 4c7b90, 1, ffbfe7e1)
ffbfe828 restriction_selectivity+0x64(4c0780, 4b7, 4c7b90, 1, 0, ffbfe8a0)
ffbfe8b0 clauselist_selectivity+0x164(4c0780, 4c8478, 1, 0, 0, 4c8295)
ffbfe958 restrictlist_selectivity+0x2c(4c0780, 4c7c18, 1, 0, 0, ff0000)
ffbfe9d8 set_baserel_size_estimates+0x2c(4c0780, 4c7d70, ffffffff,
fffffff8, 0, 4c83f9)
ffbfea48 set_plain_rel_pathlist+0x18(4c0780, 4c7d70, 4c0808, 53, 4c0348, 20)
ffbfeab8 set_base_rel_pathlists+0xf8(4c0780, 4c8460, 1, 0, 0, 4c7c00)
ffbfeb40 make_one_rel+0xc(4c0780, 0, ffbfecb8, ffbfecb0, 0, 0)
ffbfebb8 subplanner+0x148(4c0780, 4c7cb8, 0, 0, 0, 0)
ffbfec70 query_planner+0x98(4c0780, 4c7a48, 0, 0, 0, 0)
ffbfecf8 grouping_planner+0x7cc(4c0780, bff00000, 0, ff13a000, 0, 0)
ffbfedc8 subquery_planner+0x260(4c0780, bff00000, 0, 7efefeff, 81010100,
ff0000)
ffbfee58 planner+0x54(4c0780, 4c1e00, 4c15e0, fffffff8, 0, ffbfffd5)
ffbfeed8 pg_plan_query+0x54(4c0780, 29b99c, 0, 53, 4c0348, 20)
ffbfef50 pg_exec_query_string+0x388(4c0348, 2, 476010, 4c0330, 800000, 0)
ffbff038 PostgresMain+0x1398(5, ffbff2d0, 40c1d9, 473, 0, ffbff1c8)
ffbff0f8 DoBackend+0x7d8(40c0a8, 1, 22730, 1552dc, 0, 40c2d9)
ffbff4e8 BackendStartup+0xb0(40c0a8, 5, ffbff800, ffbff5d8, ffbff658, 0)
ffbff568 ServerLoop+0x370(297024, 49a0, 0, 3f1f88, 297004, 2d560000)
ffbff810 PostmasterMain+0xbe4(5, 3f2980, 65720000, 0, 65720000, 65720000)
ffbffca0 main+0x294(5, ffbffd8c, ffbffda4, 3e64c0, 0, 0)
ffbffd28 _start+0x5c(0, 0, 0, 0, 0, 0)



Andrew Sullivan wrote:

>On Tue, Sep 17, 2002 at 11:08:46AM -0400, Tom Lane wrote:
>
>
>>This should be producing a core file in your database directory
>>($PGDATA/base/yourdboid/).  With gdb you'd do
>>    gdb /path/to/postgres-executable /path/to/corefile
>>    gdb> bt
>>    gdb> quit
>>I don't remember the equivalent incantations with Solaris' debugger.
>>
>
>I think it's
>
>adb /path/to/postgres-executable /path/to/corefile
>$c
>
>[or]
>
>$C
>
>A
>
>