[postgis-users] st_offsetcurve
franco base
frenk.calza at gmail.com
Wed Feb 27 03:46:19 PST 2013
Hi.
I'm trying to use this function.
With some geometry(linestring) the function
disconnect my user from the server.
This is an example of geometry that crash the system
geom:
"0102000020BB0B000009000000FE4D2431B21A3741B4D52B2C13365341FE4D2431B21A3741B4D52B2C13365341EABE01C8B41A3741D99429EF17365341ED6BC98AB41A37417262C4A6193653410E614059B21A3741F7B1BFE41B3653410C83B714B01A37418BDDF2CE1C3653416B17D7C0AE1A37414BCE79781E3653417A2AF3E8AE1A3741C434CDFC21365341DF54CA33C01A37417DDAE74642365341"
this is my query:
SELECT st_offsetcurve(geom,15)
I attach back trace and the memory dump.
Thanks a lot for your help
Franco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130227/3a0aa6dc/attachment.html>
-------------- next part --------------
*** glibc detected *** postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT: double free or corruption (out): 0x0000000000c84b80 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x766d6)[0x7fa3900726d6]
/usr/local/lib64/libgeos_c.so.1(GEOSGeom_destroy_r+0x12)[0x7fa38c571cd2]
/usr/lib64/postgresql/postgis-2.0.so(lwgeom_offsetcurve+0xfa)[0x7fa38c7f8aba]
/usr/lib64/postgresql/postgis-2.0.so(ST_OffsetCurve+0xf6)[0x7fa38c7b1f16]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT[0x571aca]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(ExecProject+0x172)[0x575402]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(ExecScan+0x113)[0x575753]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(ExecProcNode+0x238)[0x56e728]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(standard_ExecutorRun+0x11a)[0x56bbda]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT[0x6389f7]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(PortalRun+0x240)[0x639d80]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(PostgresMain+0x74c)[0x635ffc]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT[0x5fb659]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(PostmasterMain+0x647)[0x5fbfd7]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT(main+0x71e)[0x46153e]
/lib64/libc.so.6(__libc_start_main+0xed)[0x7fa39001d23d]
postgres: monitoraggio_tpl monitoraggio_tpl 192.1.1.108(51035) SELECT[0x4615e1]
======= Memory map: ========
00400000-008e7000 r-xp 00000000 08:03 1199569 /usr/bin/postgres
00ae6000-00ae7000 r--p 004e6000 08:03 1199569 /usr/bin/postgres
00ae7000-00af4000 rw-p 004e7000 08:03 1199569 /usr/bin/postgres
00af4000-00b95000 rw-p 00000000 00:00 0 [heap]
00b95000-00c9d000 rw-p 00000000 00:00 0 [heap]
7fa38b862000-7fa38b877000 r-xp 00000000 08:03 131434 /lib64/libgcc_s.so.1
7fa38b877000-7fa38ba76000 ---p 00015000 08:03 131434 /lib64/libgcc_s.so.1
7fa38ba76000-7fa38ba77000 r--p 00014000 08:03 131434 /lib64/libgcc_s.so.1
7fa38ba77000-7fa38ba78000 rw-p 00015000 08:03 131434 /lib64/libgcc_s.so.1
7fa38ba78000-7fa38bb64000 r-xp 00000000 08:03 1185217 /usr/lib64/libstdc++.so.6.0.16
7fa38bb64000-7fa38bd63000 ---p 000ec000 08:03 1185217 /usr/lib64/libstdc++.so.6.0.16
7fa38bd63000-7fa38bd6b000 r--p 000eb000 08:03 1185217 /usr/lib64/libstdc++.so.6.0.16
7fa38bd6b000-7fa38bd6d000 rw-p 000f3000 08:03 1185217 /usr/lib64/libstdc++.so.6.0.16
7fa38bd6d000-7fa38bd82000 rw-p 00000000 00:00 0
7fa38bd82000-7fa38bf02000 r-xp 00000000 08:03 1200927 /usr/local/lib64/libgeos-3.3.5.so
7fa38bf02000-7fa38c101000 ---p 00180000 08:03 1200927 /usr/local/lib64/libgeos-3.3.5.so
7fa38c101000-7fa38c10e000 r--p 0017f000 08:03 1200927 /usr/local/lib64/libgeos-3.3.5.so
7fa38c10e000-7fa38c112000 rw-p 0018c000 08:03 1200927 /usr/local/lib64/libgeos-3.3.5.so
7fa38c112000-7fa38c113000 rw-p 00000000 00:00 0
7fa38c113000-7fa38c11a000 r-xp 00000000 08:03 1183991 /usr/local/lib64/libjson.so.0.0.1
7fa38c11a000-7fa38c319000 ---p 00007000 08:03 1183991 /usr/local/lib64/libjson.so.0.0.1
7fa38c319000-7fa38c31a000 r--p 00006000 08:03 1183991 /usr/local/lib64/libjson.so.0.0.1
7fa38c31a000-7fa38c31b000 rw-p 00007000 08:03 1183991 /usr/local/lib64/libjson.so.0.0.1
7fa38c31b000-7fa38c35c000 r-xp 00000000 08:03 1200415 /usr/lib64/libproj.so.0.6.6
7fa38c35c000-7fa38c55c000 ---p 00041000 08:03 1200415 /usr/lib64/libproj.so.0.6.6
7fa38c55c000-7fa38c55d000 r--p 00041000 08:03 1200415 /usr/lib64/libproj.so.0.6.6
7fa38c55d000-7fa38c55f000 rw-p 00042000 08:03 1200415 /usr/lib64/libproj.so.0.6.6
7fa38c55f000-7fa38c560000 rw-p 00000000 00:00 0
7fa38c560000-7fa38c585000 r-xp 00000000 08:03 1200932 /usr/local/lib64/libgeos_c.so.1.7.5
7fa38c585000-7fa38c784000 ---p 00025000 08:03 1200932 /usr/local/lib64/libgeos_c.so.1.7.5
7fa38c784000-7fa38c785000 r--p 00024000 08:03 1200932 /usr/local/lib64/libgeos_c.so.1.7.5
7fa38c785000-7fa38c786000 rw-p 00025000 08:03 1200932 /usr/local/lib64/libgeos_c.so.1.7.5
7fa38c786000-7fa38c820000 r-xp 00000000 08:03 1201809 /usr/lib64/postgresql/postgis-2.0.so
7fa38c820000-7fa38ca20000 ---p 0009a000 08:03 1201809 /usr/lib64/postgresql/postgis-2.0.so
7fa38ca20000-7fa38ca21000 r--p 0009a000 08:03 1201809 /usr/lib64/postgresql/postgis-2.0.so
7fa38ca21000-7fa38ca24000 rw-p 0009b000 08:03 1201809 /usr/lib64/postgresql/postgis-2.0.so
7fa38ca24000-7fa38ca30000 r-xp 00000000 08:03 131354 /lib64/libnss_files-2.14.1.so
7fa38ca30000-7fa38cc2f000 ---p 0000c000 08:03 131354 /lib64/libnss_files-2.14.1.so
7fa38cc2f000-7fa38cc30000 r--p 0000b000 08:03 131354 /lib64/libnss_files-2.14.1.so
7fa38cc30000-7fa38cc31000 rw-p 0000c000 08:03 131354 /lib64/libnss_files-2.14.1.so
7fa38cc31000-7fa38eb19000 rw-s 00000000 00:04 32768 /SYSV0052e2c1 (deleted)
7fa38eb19000-7fa38eb35000 r-xp 00000000 08:03 131411 /lib64/libselinux.so.1
7fa38eb35000-7fa38ed34000 ---p 0001c000 08:03 131411 /lib64/libselinux.so.1
7fa38ed34000-7fa38ed35000 r--p 0001b000 08:03 131411 /lib64/libselinux.so.1
7fa38ed35000-7fa38ed36000 rw-p 0001c000 08:03 131411 /lib64/libselinux.so.1
7fa38ed36000-7fa38ed37000 rw-p 00000000 00:00 0
7fa38ed37000-7fa38ed51000 r-xp 00000000 08:03 1188843 /usr/lib64/libsasl2.so.2.0.23
7fa38ed51000-7fa38ef50000 ---p 0001a000 08:03 1188843 /usr/lib64/libsasl2.so.2.0.23
7fa38ef50000-7fa38ef51000 r--p 00019000 08:03 1188843 /usr/lib64/libsasl2.so.2.0.23
7fa38ef51000-7fa38ef52000 rw-p 0001a000 08:03 1188843 /usr/lib64/libsasl2.so.2.0.23
7fa38ef52000-7fa38ef60000 r-xp 00000000 08:03 1190369 /usr/lib64/liblber-2.4.so.2.7.1
7fa38ef60000-7fa38f15f000 ---p 0000e000 08:03 1190369 /usr/lib64/liblber-2.4.so.2.7.1
7fa38f15f000-7fa38f160000 r--p 0000d000 08:03 1190369 /usr/lib64/liblber-2.4.so.2.7.1
7fa38f160000-7fa38f161000 rw-p 0000e000 08:03 1190369 /usr/lib64/liblber-2.4.so.2.7.1
7fa38f161000-7fa38f179000 r-xp 00000000 08:03 131362 /lib64/libpthread-2.14.1.so
7fa38f179000-7fa38f378000 ---p 00018000 08:03 131362 /lib64/libpthread-2.14.1.so
7fa38f378000-7fa38f379000 r--p 00017000 08:03 131362 /lib64/libpthread-2.14.1.so
7fa38f379000-7fa38f37a000 rw-p 00018000 08:03 131362 /lib64/libpthread-2.14.1.so
7fa38f37a000-7fa38f37e000 rw-p 00000000 00:00 0
7fa38f37e000-7fa38f391000 r-xp 00000000 08:03 137365 /lib64/libresolv-2.14.1.so
7fa38f391000-7fa38f591000 ---p 00013000 08:03 137365 /lib64/libresolv-2.14.1.so
7fa38f591000-7fa38f592000 r--p 00013000 08:03 137365 /lib64/libresolv-2.14.1.so
7fa38f592000-7fa38f593000 rw-p 00014000 08:03 137365 /lib64/libresolv-2.14.1.so
7fa38f593000-7fa38f595000 rw-p 00000000 00:00 0
7fa38f595000-7fa38f598000 r-xp 00000000 08:03 131429 /lib64/libkeyutils.so.1.4
7fa38f598000-7fa38f797000 ---p 00003000 08:03 131429 /lib64/libkeyutils.so.1.4
7fa38f797000-7fa38f798000 r--p 00002000 08:03 131429 /lib64/libkeyutils.so.1.4
7fa38f798000-7fa38f799000 rw-p 00003000 08:03 131429 /lib64/libkeyutils.so.1.4
7fa38f799000-7fa38f7a2000 r-xp 00000000 08:03 1199308 /usr/lib64/libkrb5support.so.0.1
7fa38f7a2000-7fa38f9a1000 ---p 00009000 08:03 1199308 /usr/lib64/libkrb5support.so.0.1
7fa38f9a1000-7fa38f9a2000 r--p 00008000 08:03 1199308 /usr/lib64/libkrb5support.so.0.1
7fa38f9a2000-7fa38f9a3000 rw-p 00009000 08:03 1199308 /usr/lib64/libkrb5support.so.0.1
7fa38f9a3000-7fa38f9ca000 r-xp 00000000 08:03 1188503 /usr/lib64/libk5crypto.so.3.1
7fa38f9ca000-7fa38fbca000 ---p 00027000 08:03 1188503 /usr/lib64/libk5crypto.so.3.1
7fa38fbca000-7fa38fbcb000 r--p 00027000 08:03 1188503 /usr/lib64/libk5crypto.so.3.1
7fa38fbcb000-7fa38fbcc000 rw-p 00028000 08:03 1188503 /usr/lib64/libk5crypto.so.3.1
7fa38fbcc000-7fa38fbe3000 r-xp 00000000 08:03 131450 /lib64/libaudit.so.1.0.0
7fa38fbe3000-7fa38fde2000 ---p 00017000 08:03 131450 /lib64/libaudit.so.1.0.0
7fa38fde2000-7fa38fde3000 r--p 00016000 08:03 131450 /lib64/libaudit.so.1.0.0
7fa38fde3000-7fa38fde4000 rw-p 00017000 08:03 131450 /lib64/libaudit.so.1.0.0
7fa38fde4000-7fa38fdfb000 r-xp 00000000 08:03 131344 /lib64/libz.so.1.2.5
7fa38fdfb000-7fa38fffa000 ---p 00017000 08:03 131344 /lib64/libz.so.1.2.5
7fa38fffa000-7fa38fffb000 r--p 00016000 08:03 131344 /lib64/libz.so.1.2.5
7fa38fffb000-7fa38fffc000 rw-p 00017000 08:03 131344 /lib64/libz.so.1.2.5
7fa38fffc000-7fa390183000 r-xp 00000000 08:03 131338 /lib64/libc-2.14.1.so
7fa390183000-7fa390382000 ---p 00187000 08:03 131338 /lib64/libc-2.14.1.so
7fa390382000-7fa390386000 r--p 00186000 08:03 131338 /lib64/libc-2.14.1.so
7fa390386000-7fa390387000 rw-p 0018a000 08:03 131338 /lib64/libc-2.14.1.so
7fa390387000-7fa39038c000 rw-p 00000000 00:00 0
7fa39038c000-7fa3903d3000 r-xp 00000000 08:03 1190371 /usr/lib64/libldap-2.4.so.2.7.1
7fa3903d3000-7fa3905d2000 ---p 00047000 08:03 1190371 /usr/lib64/libldap-2.4.so.2.7.1
7fa3905d2000-7fa3905d3000 r--p 00046000 08:03 1190371 /usr/lib64/libldap-2.4.so.2.7.1
7fa3905d3000-7fa3905d5000 rw-p 00047000 08:03 1190371 /usr/lib64/libldap-2.4.so.2.7.1
7fa3905d5000-7fa39062b000 r-xp 00000000 08:03 131366 /lib64/libm-2.14.1.so
7fa39062b000-7fa39082a000 ---p 00056000 08:03 131366 /lib64/libm-2.14.1.so
7fa39082a000-7fa39082b000 r--p 00055000 08:03 131366 /lib64/libm-2.14.1.so
7fa39082b000-7fa39082c000 rw-p 00056000 08:03 131366 /lib64/libm-2.14.1.so
7fa39082c000-7fa39082e000 r-xp 00000000 08:03 131364 /lib64/libdl-2.14.1.so
7fa39082e000-7fa390a2e000 ---p 00002000 08:03 131364 /lib64/libdl-2.14.1.so
7fa390a2e000-7fa390a2f000 r--p 00002000 08:03 131364 /lib64/libdl-2.14.1.so
7fa390a2f000-7fa390a30000 rw-p 00003000 08:03 131364 /lib64/libdl-2.14.1.so
7fa390a30000-7fa390a6a000 r-xp 00000000 08:03 1188499 /usr/lib64/libgssapi_krb5.so.2.2
7fa390a6a000-7fa390c6a000 ---p 0003a000 08:03 1188499 /usr/lib64/libgssapi_krb5.so.2.2
7fa390c6a000-7fa390c6b000 r--p 0003a000 08:03 1188499 /usr/lib64/libgssapi_krb5.so.2.2
7fa390c6b000-7fa390c6d000 rw-p 0003b000 08:03 1188499 /usr/lib64/libgssapi_krb5.so.2.2
7fa390c6d000-7fa390c70000 r-xp 00000000 08:03 131440 /lib64/libcom_err.so.2.1
7fa390c70000-7fa390e6f000 ---p 00003000 08:03 131440 /lib64/libcom_err.so.2.1
7fa390e6f000-7fa390e70000 r--p 00002000 08:03 131440 /lib64/libcom_err.so.2.1
7fa390e70000-7fa390e71000 rw-p 00003000 08:03 131440 /lib64/libcom_err.so.2.1
7fa390e71000-7fa390f35000 r-xp 00000000 08:03 1188511 /usr/lib64/libkrb5.so.3.3
7fa390f35000-7fa391134000 ---p 000c4000 08:03 1188511 /usr/lib64/libkrb5.so.3.3
7fa391134000-7fa39113d000 r--p 000c3000 08:03 1188511 /usr/lib64/libkrb5.so.3.3
7fa39113d000-7fa39113f000 rw-p 000cc000 08:03 1188511 /usr/lib64/libkrb5.so.3.3
7fa39113f000-7fa3912c9000 r-xp 00000000 08:03 131473 /lib64/libcrypto.so.1.0.0
7fa3912c9000-7fa3914c9000 ---p 0018a000 08:03 131473 /lib64/libcrypto.so.1.0.0
7fa3914c9000-7fa3914e2000 r--p 0018a000 08:03 131473 /lib64/libcrypto.so.1.0.0
7fa3914e2000-7fa3914ec000 rw-p 001a3000 08:03 131473 /lib64/libcrypto.so.1.0.0
7fa3914ec000-7fa3914f0000 rw-p 00000000 00:00 0
7fa3914f0000-7fa391544000 r-xp 00000000 08:03 137045 /lib64/libssl.so.1.0.0
7fa391958000-7fa391959000 r--p 0000c000 08:03 133829 /lib64/libpam.so.0.83.1
7fa391959000-7fa39195a000 rw-p 0000d000 08:03 133829 /lib64/libpam.so.0.83.1
7fa39195a000-7fa391aad000 r-xp 00000000 08:03 1183990 /usr/lib64/libxml2.so.2.7.8
7fa391aad000-7fa391cad000 ---p 00153000 08:03 1183990 /usr/lib64/libxml2.so.2.7.8
7fa391cad000-7fa391cb5000 r--p 00153000 08:03 1183990 /usr/lib64/libxml2.so.2.7.8
7fa391cb5000-7fa391cb7000 rw-p 0015b000 08:03 1183990 /usr/lib64/libxml2.so.2.7.8
7fa391cb7000-7fa391cb8000 rw-p 00000000 00:00 0
7fa391cb8000-7fa391cd8000 r-xp 00000000 08:03 131346 /lib64/ld-2.14.1.so
7fa391cec000-7fa391d2d000 rw-p 00000000 00:00 0
7fa391d2e000-7fa391d4f000 rw-p 00000000 00:00 0
7fa391d4f000-7fa391d8e000 r--p 00000000 08:03 394104 /usr/lib/locale/en_US.utf8/LC_CTYPE
7fa391d8e000-7fa391ebe000 r--p 00000000 08:03 401300 /usr/lib/locale/en_US.utf8/LC_COLLATE
7fa391ebe000-7fa391ec9000 rw-p 00000000 00:00 0
7fa391ecb000-7fa391ecc000 rw-p 00000000 00:00 0
7fa391ecc000-7fa391ecd000 r--p 00000000 08:03 267762 /usr/lib/locale/en_US.utf8/LC_TIME
7fa391ecd000-7fa391ece000 r--p 00000000 08:03 394097 /usr/lib/locale/en_US.utf8/LC_NUMERIC
7fa391ece000-7fa391ecf000 r--p 00000000 08:03 267748 /usr/lib/locale/en_US.utf8/LC_MONETARY
7fa391ecf000-7fa391ed0000 r--p 00000000 08:03 269770 /usr/lib/locale/en_US.utf8/LC_MESSAGES/SYS_LC_MESSAGES
7fa391ed0000-7fa391ed7000 r--s 00000000 08:03 1188831 /usr/lib64/gconv/gconv-modules.cache
7fa391ed7000-7fa391ed8000 rw-p 00000000 00:00 0
7fa391ed8000-7fa391ed9000 r--p 00020000 08:03 131346 /lib64/ld-2.14.1.so
7fa391ed9000-7fa391eda000 rw-p 00021000 08:03 131346 /lib64/ld-2.14.1.so
7fa391eda000-7fa391edb000 rw-p 00000000 00:00 0
7fff8894f000-7fff8897e000 rw-p 00000000 00:00 0 [stack]
7fff889ff000-7fff88a00000 r-xp 00000000 00:00 0 [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
2013-02-26 16:45:40 CET LOG: server process (PID 2208) was terminated by signal 6: Aborted
2013-02-26 16:45:40 CET LOG: terminating any other active server processes
2013-02-26 16:45:40 CET WARNING: terminating connection because of crash of another server process
2013-02-26 16:45:40 CET DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2013-02-26 16:45:40 CET HINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-02-26 16:45:40 CET postgres monitoraggio_tpl WARNING: terminating connection because of crash of another server process
2013-02-26 16:45:40 CET postgres monitoraggio_tpl DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2013-02-26 16:45:40 CET postgres monitoraggio_tpl HINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-02-26 16:45:40 CET monitoraggio_tpl monitoraggio_tpl WARNING: terminating connection because of crash of another server process
2013-02-26 16:45:40 CET monitoraggio_tpl monitoraggio_tpl DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2013-02-26 16:45:40 CET monitoraggio_tpl monitoraggio_tpl HINT: In a moment you should be able to reconnect to the database and repeat your command.
2013-02-26 16:45:40 CET LOG: all server processes terminated; reinitializing
2013-02-26 16:45:40 CET LOG: database system was interrupted; last known up at 2013-02-26 16:24:27 CET
2013-02-26 16:45:40 CET LOG: database system was not properly shut down; automatic recovery in progress
2013-02-26 16:45:40 CET LOG: record with zero length at 175/ACF4EAD8
2013-02-26 16:45:40 CET LOG: redo is not required
2013-02-26 16:45:40 CET LOG: database system is ready to accept connections
2013-02-26 16:45:40 CET LOG: autovacuum launcher started
More information about the postgis-users
mailing list