[pdal] Oracle point cloud

Albert Godfrind albert.godfrind at oracle.com
Wed Feb 25 13:28:17 PST 2015 

I would like to test this too in my environments (I have a 11.2.0.1 and a 11.2.0.2 environment)

@Oscar: can you share your PDAL build (it would save me building it myself)

Albert 
--
Albert Godfrind, Oracle
+33 6 09 97 27 23
Sent from my iPhone

> On 25 févr. 2015, at 22:17, Oscar Martinez Rubi - BK <O.MartinezRubi at tudelft.nl> wrote:
> 
> 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
> >
> 
> _______________________________________________
> pdal mailing list
> pdal at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pdal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pdal/attachments/20150225/e3e91a28/attachment-0001.html>

More information about the pdal mailing list