Le 29 déc. 04, à 18:05, Tom Lane a écrit :
=?ISO-8859-1?Q?R=E9mi_Zara?= <[EMAIL PROTECTED]> writes:here is the tail of regression.diff (which indicates that the first=20 query failed):
SELECT '1'::mquery_txt; ! server closed the connection unexpectedly ! This probably means the server terminated abnormally ! before or while processing the request. ! connection to server was lost
Backtracing the core dump from that crash would do fine.
Here you go
(gdb) bt
#0 0x0100000a in ?? ()
#1 0x046e9cce in queryin (buf=Cannot access memory at address 0x0
) at query.c:543
#2 0x046e9e44 in mqtxt_in (fcinfo=0xffffb688) at query.c:620
#3 0x0019d790 in OidFunctionCall3 (functionId=61367, arg1=2762304, arg2=0, arg3=4294967295) at fmgr.c:1408
#4 0x00091298 in stringTypeDatum (tp=0x2a26e9, string=0x2a2640 "1", atttypmod=-1) at parse_type.c:338
#5 0x00091968 in coerce_type (pstate=0x2a2610, node=0x2a2240, inputTypeId=2762304, targetTypeId=61366, targetTypeMod=-1, ccontext=98, cformat=COERCE_EXPLICIT_CAST)
at parse_coerce.c:185
#6 0x0009157c in coerce_to_target_type (pstate=0x2a2518, expr=0x2a2240, exprtype=705, targettype=61366, targettypmod=-1, ccontext=COERCION_EXPLICIT,
cformat=COERCE_EXPLICIT_CAST) at parse_coerce.c:80
#7 0x0008b440 in typecast_expression (pstate=0x2a2518, expr=0x2a2240, typename=0x2a2358) at parse_expr.c:1651
#8 0x0008a814 in transformExpr (pstate=0x2a2518, expr=0x2a23d8) at parse_expr.c:177
#9 0x00093224 in transformTargetEntry (pstate=0x2a2518, node=0x2a23d8, expr=0x0, colname=0x0, resjunk=0 '\0') at parse_target.c:72
#10 0x000932aa in transformTargetList (pstate=0x2a2518, targetlist=0xffffb688) at parse_target.c:148
#11 0x00077676 in transformSelectStmt (pstate=0x2a2518, stmt=0x2a2450) at analyze.c:1813
#12 0x00075496 in transformStmt (pstate=0x2a2518, parseTree=0x2a2450, extras_before=0xffffba80, extras_after=0xffffba84) at analyze.c:371
#13 0x00075230 in do_parse_analyze (parseTree=0x2a2450, pstate=0x2a2518) at analyze.c:245
#14 0x0007514c in parse_analyze (parseTree=0x2a2450, paramTypes=0x0, numParams=0) at analyze.c:169
#15 0x00138f3a in pg_analyze_and_rewrite (parsetree=0x2a2450, paramTypes=0x0, numParams=0) at postgres.c:555
#16 0x00139298 in exec_simple_query (query_string=0x2a2020 "SELECT '1'::mquery_txt;") at postgres.c:872
#17 0x0013b4c6 in PostgresMain (argc=4, argv=0x27f390, username=0x27f260 "rzara") at postgres.c:3007
#18 0x00114b7c in BackendRun (port=0x28f200) at postmaster.c:2817
#19 0x0011447e in BackendStartup (port=0x28f200) at postmaster.c:2453
#20 0x00112cd0 in ServerLoop () at postmaster.c:1198
#21 0x001126f0 in PostmasterMain (argc=3, argv=0xffffc674) at postmaster.c:917
#22 0x000e465e in main (argc=3, argv=0xffffc674) at main.c:268
Regards,
Rémi Zara
-- Rémi Zara http://www.remi-zara.net/
smime.p7s
Description: S/MIME cryptographic signature
