[pdal] Oracle point cloud

Wed Feb 25 13:17:59 PST 2015

BTW, what commands do you use to create the blocks and base tables?

Enviado de Samsung Mobile

-------- Mensaje original --------
De: Oscar Martinez Rubi
Fecha:25/02/2015 17:55 (GMT+01:00)
Para: Howard Butler
Cc: pdal at lists.osgeo.org, Theo Tijssen - BK
Asunto: Re: [pdal] Oracle point cloud

Hi Howard,

I run the pdal pipeline with gdb, please see below.

I also tested with the write.xml and autzen-dd.las in the test folder
and I get the same output.

BTW, I am running this in a Oracle 12.1.0.2 in RedHat 6.5

Any insight?

Regards,

O.

---------------------------
-bash-4.1$ gdb --args pdal pipeline -i oracle_pipeline.xml --developer-debug
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-75.el6)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
<http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /home/oscar/sw/PDAL-trunk/build/bin/pdal...(no
debugging symbols found)...done.
(gdb) r
Starting program: /home/oscar/sw/PDAL-trunk/build/bin/pdal pipeline -i
oracle_pipeline.xml --developer-debug
[Thread debugging using libthread_db enabled]
warning: File "/usr/local/gcc484/lib64/libstdc++.so.6.0.19-gdb.py"
auto-loading has been declined by your `auto-load safe-path' set to
"/usr/share/gdb/auto-load:/usr/lib/debug:/usr/bin/mono-gdb.py".
To enable execution of this file add
     add-auto-load-safe-path
/usr/local/gcc484/lib64/libstdc++.so.6.0.19-gdb.py
line to your configuration file "/home/oscar/.gdbinit".
To completely disable this security protection add
     set auto-load safe-path /
line to your configuration file "/home/oscar/.gdbinit".
For more information about this security protection see the
"Auto-loading safe path" section in the GDB manual.  E.g., run from the
shell:
     info "(gdb)Auto-loading safe path"

Program received signal SIGSEGV, Segmentation fault.
0x00007ffff314a7fe in kotgttc () from
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1
Missing separate debuginfos, use: debuginfo-install
bzip2-libs-1.0.5-7.el6_0.x86_64 cyrus-sasl-lib-2.1.23-15.el6_6.1.x86_64
geos-3.4.2-1.rhel6.x86_64 glibc-2.12-1.149.el6_6.5.x86_64
keyutils-libs-1.4-5.el6.x86_64 krb5-libs-1.10.3-33.el6.x86_64
libaio-0.3.107-10.el6.x86_64 libcom_err-1.41.12-21.el6.x86_64
libcurl-7.19.7-40.el6_6.4.x86_64 libidn-1.18-2.el6.x86_64
libjpeg-turbo-1.2.1-3.el6_5.x86_64 libpng-1.2.49-1.el6_2.x86_64
libselinux-2.0.94-5.8.el6.x86_64 libssh2-1.4.2-1.el6_6.1.x86_64
libtiff-3.9.4-10.el6_5.x86_64 libtool-ltdl-2.2.6-15.5.el6.x86_64
libxml2-2.7.6-17.el6_6.1.x86_64 nspr-4.10.6-1.el6_5.x86_64
nss-3.16.2.3-3.el6_6.x86_64 nss-softokn-freebl-3.14.3-22.el6_6.x86_64
nss-util-3.16.2.3-2.el6_6.x86_64 numactl-2.0.9-2.el6.x86_64
openldap-2.4.39-8.el6.x86_64 openssl-1.0.1e-30.el6_6.5.x86_64
pcre-7.8-6.el6.x86_64 proj-4.8.0-3.el6.x86_64 sqlite-3.6.20-1.el6.x86_64
unixODBC-2.2.14-14.el6.x86_64 zlib-1.2.3-29.el6.x86_64
(gdb) bt
#0  0x00007ffff314a7fe in kotgttc () from
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1
#1  0x00007ffff302d1cb in OCIObjectNew () from
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1
#2  0x00007ffff6daec98 in OWConnection::CreateType(OCIColl**, OCIType*)
() from /home/oscar/sw/gdal-trunk/build/lib/libgdal.so
#3  0x00007fffe9fe4ca5 in pdal::OciWriter::writeTile(pdal::PointBuffer
const&) ()
    from /home/oscar/sw/PDAL-trunk/build/lib/libpdal_plugin_writer_oci.so
#4  0x00007ffff7d06640 in
pdal::Writer::run(std::shared_ptr<pdal::PointBuffer>) () from
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#5  0x00007ffff7ce2908 in pdal::Stage::execute(pdal::PointContext) ()
from /home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#6  0x00007ffff7da2a5e in pdal::PipelineKernel::execute() () from
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#7  0x00007ffff7ca0d57 in pdal::Kernel::innerRun() () from
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#8  0x00007ffff7ca0fa5 in pdal::Kernel::do_execution() () from
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#9  0x00007ffff7ca12b4 in pdal::Kernel::run(int, char const**,
std::basic_string<char, std::char_traits<char>, std::allocator<char> >
const&) ()
    from /home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so
#10 0x000000000040f96c in main ()

On 23-02-15 00:23, Howard Butler wrote:
>> On Feb 17, 2015, at 8:54 AM, Oscar Martinez Rubi <O.MartinezRubi at tudelft.nl> wrote:
>>
>> Thanks guys! Still not working though
>>
>> To get rid of that message I recreated the DB (well the user) and create the base and blocks tables:
>>
>> create table blocks tablespace users pctfree 0 nologging
>> lob(points) store as securefile (tablespace users nocompress
>> cache reads nologging) as
>> SELECT * FROM mdsys.SDO_PC_BLK_TABLE where 0 = 1;
>>
>> create table blocksbase (id number, pc sdo_pc) tablespace users pctfree 0 nologging;
>>
>> BTW, I had to add the ID to the base table (which I was not doing before).
>>
>> But when I run PDAL now I get a Segmentation fault (XML below)
> $ gdb --args pdal pipeline -i myfile.xml --developer-debug
>
> Then press 'r' to run
>
> when crashes, press 'bt' for backtrace. Please report the traceback here.
>
> I just tested https://github.com/PDAL/PDAL/blob/master/test/data/oracle/write.xml with the autzen-dd.las file in test/data/autzen and it successfully loaded for me with no crash. If that one succeeds for you, we might be able to make some progress.
>
> Sorry for the challenges.
>
> Howard
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20150225/02bfa1e8/attachment.html>