[postgis-users] MakePoint/GeometryFromText core dump
Chris LaReau
lareau at korora.com
Sun May 1 12:07:55 PDT 2005
Greetings,
This is my first post to the list, but I've been toying around with
PostGIS for many months now, and I must say I'm very impressed with
it and find it very useful.
My problem: I just upgraded to postgresql-8.0.2, postgis-1.0.0,
geos-2.1.1, proj-4.4.9, and my old applications seem to be working
fine on my Fedora Core 3 / gcc 3.4.3 laptop. Then I built and ran
everything on our Red Hat 7.1 / gcc 2.96 server (the first time ever
running PostGIS or even PostgreSQL on this box, so I have no history
with it for comparison), and the MakePoint() / GeometryFromText()
functions cause postgres to dump core. I found a thread or two in
the archives about this problem, but didn't see that it had been
resolved or even reproduced. Unfortunately, I seem to have
discovered a good test case... :-(
What follows is a GDB stack trace, and also an attempt to reproduce
the problem under valgrind. I say "attempt" because postgres seems
to have some kind of (I would assume unrelated) issue with actually
getting up and running under valgrind, so it really wasn't much help
at all. I took a look at some of the code involved in the
GeometryFromText() crash and nothing really jumped out at me as
being problematic (though I have to say the comparison of a literal
-1 with an unsigned integer variable is a bit unsettling).
Any help with this would be most appreciated. I'll be happy to
provide any more information if I possibly can.
Cheers,
Chris LaReau
lareau at korora.com
#### gdb session ####
sh-2.05$ gdb run/bin/postgres
GNU gdb Red Hat Linux (5.2-2)
Copyright 2002 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i386-redhat-linux"...
(gdb) run -D postgresql/data incoasterpaedia
Starting program: /home/lareau/Korora/web/run/bin/postgres -D postgresql/data incoasterpaedia
LOG: database system was shut down at 2005-05-01 04:19:19 CDT
LOG: checkpoint record is at 0/186FBE4C
LOG: redo record is at 0/186FBE4C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 2170; next OID: 3048647
LOG: database system is ready
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 2170/1/0, nestlvl: 1, children: <>
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 2170/1/0, nestlvl: 1, children: <>
PostgreSQL stand-alone backend 8.0.2
backend> SELECT GeometryFromText('POINT(-106 40.6666666666667)',-1);
DEBUG: StartTransaction
STATEMENT: SELECT GeometryFromText('POINT(-106 40.6666666666667)',-1);
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 2171/1/0, nestlvl: 1, children: <>
STATEMENT: SELECT GeometryFromText('POINT(-106 40.6666666666667)',-1);
Program received signal SIGSEGV, Segmentation fault.
0x40c248ef in lwpoint_serialize_buf (point=0x8301a58,
buf=0x8301a34 "info_LWGEOM_from_text", retsize=0xbfffdab8) at lwpoint.c:44
44 hasSRID = (point->SRID != -1);
(gdb) where
#0 0x40c248ef in lwpoint_serialize_buf (point=0x8301a58,
buf=0x8301a34 "info_LWGEOM_from_text", retsize=0xbfffdab8) at lwpoint.c:44
#1 0x40c23fe5 in lwgeom_serialize_buf (lwgeom=0x8301a58,
buf=0x8301a34 "info_LWGEOM_from_text", retsize=0xbfffdab8) at lwgeom.c:81
#2 0x40c2b57e in pglwgeom_serialize (in=0x8301a58) at lwgeom_pg.c:121
#3 0x40c2e1ca in LWGEOM_from_text (fcinfo=0xbfffdb40) at lwgeom_ogc.c:813
#4 0x0810334c in ExecMakeFunctionResult (fcache=0x82ffa18,
econtext=0x82ffb88, isNull=0xbfffdc7b "", isDone=0x0) at execQual.c:1042
#5 0x081050fb in ExecEvalExprSwitchContext (expression=0x82ffa18,
econtext=0x82ffb88, isNull=0xbfffdc7b "", isDone=0x0) at execQual.c:2781
#6 0x0813f9a0 in evaluate_expr (expr=0x82f7e60, result_type=3006102)
at clauses.c:2479
#7 0x0813f120 in simplify_function (funcid=3006222, result_type=3006102,
args=0x82f7e10, allow_inline=1 '\001', context=0xbfffdf20)
at clauses.c:2002
#8 0x0813e745 in eval_const_expressions_mutator (node=0x82f7c88,
context=0xbfffdf20) at clauses.c:1295
#9 0x08140769 in expression_tree_mutator (node=0x82f77a8,
mutator=0x813e67c <eval_const_expressions_mutator>, context=0xbfffdf20)
at clauses.c:3210
#10 0x0813ef7b in eval_const_expressions_mutator (node=0x82f77a8,
context=0xbfffdf20) at clauses.c:1846
#11 0x0814086f in expression_tree_mutator (node=0x82f7758,
mutator=0x813e67c <eval_const_expressions_mutator>, context=0xbfffdf20)
at clauses.c:3285
#12 0x0813ef7b in eval_const_expressions_mutator (node=0x82f7758,
context=0xbfffdf20) at clauses.c:1846
#13 0x0813e651 in eval_const_expressions (node=0x82f7758) at clauses.c:1201
#14 0x08137a6e in preprocess_expression (parse=0x82f7620, expr=0x82f7758,
kind=1) at planner.c:416
#15 0x08137816 in subquery_planner (parse=0x82f7620, tuple_fraction=0)
at planner.c:241
#16 0x081376d3 in planner (parse=0x82f7620, isCursor=0 '\0', cursorOptions=0,
boundParams=0x0) at planner.c:130
#17 0x08168ba7 in pg_plan_query (querytree=0x82f7620, boundParams=0x0)
at postgres.c:647
#18 0x08168c4e in pg_plan_queries (querytrees=0x82f7d58, boundParams=0x0,
needSnapshot=1) at postgres.c:715
#19 0x08168e6f in exec_simple_query (
query_string=0x82f7250 "SELECT GeometryFromText('POINT(-106 40.", '6' <repeats 12 times>, "7)',-1);\n") at postgres.c:874
#20 0x0816b34e in PostgresMain (argc=4, argv=0x82adbc8,
username=0x82ae168 "postgres") at postgres.c:3007
#21 0x081194f5 in main (argc=4, argv=0x82adbc8) at main.c:334
#22 0x400f1336 in __libc_start_main (main=0x8119290 <main>, argc=4,
ubp_av=0xbfffe2c4, init=0x8073d68 <_init>, fini=0x81e1d00 <_fini>,
rtld_fini=0x4000d2fc <_dl_fini>, stack_end=0xbfffe2bc)
at ../sysdeps/generic/libc-start.c:129
(gdb) p point
$1 = (LWPOINT *) 0x8301a58
(gdb) p *point
$2 = {type = 1 '\001', bbox = 0x0, SRID = 4294967295, point = 0x8301a70}
#### valgrind attempt ####
sh-2.05$ echo "SELECT GeometryFromText('POINT(-106 40.67)',-1);" | run/bin/valgrind -v --num-callers=10 --log-file=/tmp/gftlog run/bin/postgres -D postgresql/data incoasterpaedia
sh-2.05$ cat /tmp/gftlog.pid28555
==28555== Memcheck, a memory error detector for x86-linux.
==28555== Copyright (C) 2002-2005, and GNU GPL'd, by Julian Seward et al.
==28555== Using valgrind-2.4.0, a program supervision framework for x86-linux.
==28555== Copyright (C) 2000-2005, and GNU GPL'd, by Julian Seward et al.
==28555==
==28555== My PID = 28555, parent PID = 28459. Prog and args are:
==28555== run/bin/postgres
==28555== -D
==28555== postgresql/data
==28555== incoasterpaedia
==28555==
==28555== Valgrind library directory: /home/lareau/Korora/web/run/lib/valgrind
==28555== Command line
==28555== run/bin/postgres
==28555== -D
==28555== postgresql/data
==28555== incoasterpaedia
==28555== Startup, with flags:
==28555== -v
==28555== --num-callers=10
==28555== --log-file=/tmp/gftlog
==28555== Contents of /proc/version:
==28555== Linux version 2.4.9-31.3RS (root at rh72-build.rackspace.com) (gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)) #1 Fri May 3 18:33:32 CDT 2002
==28555== Reading syms from /home/lareau/Korora/web/run/bin/postgres (0x8048000)
==28555== Reading syms from /lib/ld-2.2.4.so (0x1B8E4000)
==28555== Reading syms from /home/lareau/Korora/web/run/lib/valgrind/stage2 (0xB0000000)
==28555== Reading syms from /lib/ld-2.2.4.so (0xB1000000)
==28555== Reading syms from /lib/libdl-2.2.4.so (0xB1020000)
==28555== Reading syms from /lib/libc-2.2.4.so (0xB1024000)
==28555== Reading syms from /home/lareau/Korora/web/run/lib/valgrind/vgskin_memcheck.so (0xB1300000)
==28555== Reading suppressions file: /home/lareau/Korora/web/run/lib/valgrind/default.supp
==28555==
==28555== Reading syms from /home/lareau/Korora/web/run/lib/valgrind/vg_inject.so (0x1B8FD000)
==28555== Reading syms from /home/lareau/Korora/web/run/lib/valgrind/vgpreload_memcheck.so (0x1B900000)
==28555== Reading syms from /usr/lib/libz.so.1.1.3 (0x1B912000)
==28555== object doesn't have any debug info
==28555== Reading syms from /usr/lib/libreadline.so.4.2 (0x1B921000)
==28555== object doesn't have any debug info
==28555== Reading syms from /lib/libtermcap.so.2.0.8 (0x1B94A000)
==28555== object doesn't have a symbol table
==28555== object doesn't have any debug info
==28555== Reading syms from /lib/libcrypt-2.2.4.so (0x1B94F000)
==28555== Reading syms from /lib/libresolv-2.2.4.so (0x1B97D000)
==28555== Reading syms from /lib/libnsl-2.2.4.so (0x1B990000)
==28555== Reading syms from /lib/libdl-2.2.4.so (0x1B9A8000)
==28555== Reading syms from /lib/libm-2.2.4.so (0x1B9AD000)
==28555== Reading syms from /lib/libc-2.2.4.so (0x1B9D0000)
==28555== TRANSLATE: 0x1BA4C380 redirected to 0x1B903520
==28555== TRANSLATE: 0x1BA4CF10 redirected to 0x1B903A70
==28555== TRANSLATE: 0x1BA543C0 redirected to 0x1B904AC0
==28555== TRANSLATE: 0x1BA4DDD8 redirected to 0x1B903ED0
==28555== Reading syms from /lib/libnss_files-2.2.4.so (0x1BC0A000)
==28555== TRANSLATE: 0x1BA52AFC redirected to 0x1B9046C4
==28555== TRANSLATE: 0x1BA4D2E4 redirected to 0x1B903F84
==28555==
==28555== Process terminating with default action of signal 6 (SIGABRT): dumping core
==28555== at 0x1B9FE921: kill (in /lib/libc-2.2.4.so)
==28555== by 0x1B9FFD07: abort (../sysdeps/generic/abort.c:88)
==28555== by 0x81C8120: errfinish (elog.c:451)
==28555== by 0x8098578: ReadControlFile (xlog.c:3211)
==28555== by 0x8098EF7: XLOGShmemInit (xlog.c:3457)
==28555== by 0x815F223: CreateSharedMemoryAndSemaphores (ipci.c:140)
==28555== by 0x81CF0C6: InitCommunication (postinit.c:188)
==28555== by 0x81CF0D6: BaseInit (postinit.c:210)
==28555== by 0x816AF3A: PostgresMain (postgres.c:2694)
==28555== by 0x81194F4: main (main.c:334)
==28555== discard syms at 0x1BC0A000-0x1BC15000 in /lib/libnss_files-2.2.4.so due to munmap()
==28555==
==28555== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 46 from 3)
--28555--
--28555-- supp: 3 _dl_start/ld-2.2.4.so(Cond)
--28555-- supp: 40 _dl_relocate_object/dl_main(Cond)
--28555-- supp: 3 _dl_relocate_object/libc-2.2.4.so/_dl_catch_error(Cond)
==28555== malloc/free: in use at exit: 43943 bytes in 91 blocks.
==28555== malloc/free: 213 allocs, 122 frees, 149593 bytes allocated.
==28555==
==28555== searching for pointers to 91 not-freed blocks.
==28555== checked 648620 bytes.
==28555==
==28555== LEAK SUMMARY:
==28555== definitely lost: 1460 bytes in 35 blocks.
==28555== possibly lost: 0 bytes in 0 blocks.
==28555== still reachable: 42483 bytes in 56 blocks.
==28555== suppressed: 0 bytes in 0 blocks.
==28555== Use --leak-check=full to see details of leaked memory.
--28555-- TT/TC: 0 tc sectors discarded.
--28555-- 6691 tt_fast misses.
--28555-- translate: new 6445 (99118 -> 1489194; ratio 150:10)
--28555-- discard 115 (1405 -> 21840; ratio 155:10).
--28555-- chainings: 4389 chainings, 0 unchainings.
--28555-- dispatch: 38048993 jumps (bb entries); of them 1210293 (3%) unchained.
--28555-- 761/10428 major/minor sched events.
--28555-- reg-alloc: 1043 t-req-spill, 269126+6669 orig+spill uis,
--28555-- 33057 total-reg-rank
--28555-- sanity: 762 cheap, 31 expensive checks.
--28555-- ccalls: 27978 C calls, 54% saves+restores avoided (90542 bytes)
--28555-- 36153 args, avg 0.86 setup instrs each (9828 bytes)
--28555-- 0% clear the stack (83934 bytes)
--28555-- 10177 retvals, 31% of reg-reg movs avoided (6222 bytes)
More information about the postgis-users
mailing list