<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>I would like to test this too in my environments (I have a 11.2.0.1 and a 11.2.0.2 environment)</div><div><br></div><div>@Oscar: can you share your PDAL build (it would save me building it myself)</div><div><br></div><div>Albert <br>--<div>Albert Godfrind, Oracle<div>+33 6 09 97 27 23<br><div>Sent from my iPhone</div></div></div></div><div><br>On 25 févr. 2015, at 22:17, Oscar Martinez Rubi - BK <<a href="mailto:O.MartinezRubi@tudelft.nl">O.MartinezRubi@tudelft.nl</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
<div>
<div>BTW, what commands do you use to create the blocks and base tables?</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div style="font-size:8px; color:#575757">Enviado de Samsung Mobile</div>
</div>
<br>
<br>
<div>-------- Mensaje original --------</div>
<div>De: Oscar Martinez Rubi </div>
<div>Fecha:25/02/2015 17:55 (GMT+01:00) </div>
<div>Para: Howard Butler </div>
<div>Cc: <a href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a>, Theo Tijssen - BK </div>
<div>Asunto: Re: [pdal] Oracle point cloud </div>
<div><br>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Hi Howard,<br>
<br>
I run the pdal pipeline with gdb, please see below.<br>
<br>
I also tested with the write.xml and autzen-dd.las in the test folder <br>
and I get the same output.<br>
<br>
BTW, I am running this in a Oracle 12.1.0.2 in RedHat 6.5<br>
<br>
Any insight?<br>
<br>
Regards,<br>
<br>
O.<br>
<br>
<br>
---------------------------<br>
-bash-4.1$ gdb --args pdal pipeline -i oracle_pipeline.xml --developer-debug<br>
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-75.el6)<br>
Copyright (C) 2010 Free Software Foundation, Inc.<br>
License GPLv3+: GNU GPL version 3 or later <br>
<<a href="http://gnu.org/licenses/gpl.html">http://gnu.org/licenses/gpl.html</a>><br>
This is free software: you are free to change and redistribute it.<br>
There is NO WARRANTY, to the extent permitted by law. Type "show copying"<br>
and "show warranty" for details.<br>
This GDB was configured as "x86_64-redhat-linux-gnu".<br>
For bug reporting instructions, please see:<br>
<<a href="http://www.gnu.org/software/gdb/bugs/">http://www.gnu.org/software/gdb/bugs/</a>>...<br>
Reading symbols from /home/oscar/sw/PDAL-trunk/build/bin/pdal...(no <br>
debugging symbols found)...done.<br>
(gdb) r<br>
Starting program: /home/oscar/sw/PDAL-trunk/build/bin/pdal pipeline -i <br>
oracle_pipeline.xml --developer-debug<br>
[Thread debugging using libthread_db enabled]<br>
warning: File "/usr/local/gcc484/lib64/libstdc++.so.6.0.19-gdb.py" <br>
auto-loading has been declined by your `auto-load safe-path' set to <br>
"/usr/share/gdb/auto-load:/usr/lib/debug:/usr/bin/mono-gdb.py".<br>
To enable execution of this file add<br>
add-auto-load-safe-path <br>
/usr/local/gcc484/lib64/libstdc++.so.6.0.19-gdb.py<br>
line to your configuration file "/home/oscar/.gdbinit".<br>
To completely disable this security protection add<br>
set auto-load safe-path /<br>
line to your configuration file "/home/oscar/.gdbinit".<br>
For more information about this security protection see the<br>
"Auto-loading safe path" section in the GDB manual. E.g., run from the <br>
shell:<br>
info "(gdb)Auto-loading safe path"<br>
<br>
Program received signal SIGSEGV, Segmentation fault.<br>
0x00007ffff314a7fe in kotgttc () from <br>
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1<br>
Missing separate debuginfos, use: debuginfo-install <br>
bzip2-libs-1.0.5-7.el6_0.x86_64 cyrus-sasl-lib-2.1.23-15.el6_6.1.x86_64 <br>
geos-3.4.2-1.rhel6.x86_64 glibc-2.12-1.149.el6_6.5.x86_64 <br>
keyutils-libs-1.4-5.el6.x86_64 krb5-libs-1.10.3-33.el6.x86_64 <br>
libaio-0.3.107-10.el6.x86_64 libcom_err-1.41.12-21.el6.x86_64 <br>
libcurl-7.19.7-40.el6_6.4.x86_64 libidn-1.18-2.el6.x86_64 <br>
libjpeg-turbo-1.2.1-3.el6_5.x86_64 libpng-1.2.49-1.el6_2.x86_64 <br>
libselinux-2.0.94-5.8.el6.x86_64 libssh2-1.4.2-1.el6_6.1.x86_64 <br>
libtiff-3.9.4-10.el6_5.x86_64 libtool-ltdl-2.2.6-15.5.el6.x86_64 <br>
libxml2-2.7.6-17.el6_6.1.x86_64 nspr-4.10.6-1.el6_5.x86_64 <br>
nss-3.16.2.3-3.el6_6.x86_64 nss-softokn-freebl-3.14.3-22.el6_6.x86_64 <br>
nss-util-3.16.2.3-2.el6_6.x86_64 numactl-2.0.9-2.el6.x86_64 <br>
openldap-2.4.39-8.el6.x86_64 openssl-1.0.1e-30.el6_6.5.x86_64 <br>
pcre-7.8-6.el6.x86_64 proj-4.8.0-3.el6.x86_64 sqlite-3.6.20-1.el6.x86_64 <br>
unixODBC-2.2.14-14.el6.x86_64 zlib-1.2.3-29.el6.x86_64<br>
(gdb) bt<br>
#0 0x00007ffff314a7fe in kotgttc () from <br>
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1<br>
#1 0x00007ffff302d1cb in OCIObjectNew () from <br>
/opt/oracle/product/12.1.0.2/lib/libclntsh.so.12.1<br>
#2 0x00007ffff6daec98 in OWConnection::CreateType(OCIColl**, OCIType*) <br>
() from /home/oscar/sw/gdal-trunk/build/lib/libgdal.so<br>
#3 0x00007fffe9fe4ca5 in pdal::OciWriter::writeTile(pdal::PointBuffer <br>
const&) ()<br>
from /home/oscar/sw/PDAL-trunk/build/lib/libpdal_plugin_writer_oci.so<br>
#4 0x00007ffff7d06640 in <br>
pdal::Writer::run(std::shared_ptr<pdal::PointBuffer>) () from <br>
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#5 0x00007ffff7ce2908 in pdal::Stage::execute(pdal::PointContext) () <br>
from /home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#6 0x00007ffff7da2a5e in pdal::PipelineKernel::execute() () from <br>
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#7 0x00007ffff7ca0d57 in pdal::Kernel::innerRun() () from <br>
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#8 0x00007ffff7ca0fa5 in pdal::Kernel::do_execution() () from <br>
/home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#9 0x00007ffff7ca12b4 in pdal::Kernel::run(int, char const**, <br>
std::basic_string<char, std::char_traits<char>, std::allocator<char> > <br>
const&) ()<br>
from /home/oscar/sw/PDAL-trunk/build/lib/libpdalcpp.so<br>
#10 0x000000000040f96c in main ()<br>
<br>
<br>
On 23-02-15 00:23, Howard Butler wrote:<br>
>> On Feb 17, 2015, at 8:54 AM, Oscar Martinez Rubi <<a href="mailto:O.MartinezRubi@tudelft.nl">O.MartinezRubi@tudelft.nl</a>> wrote:<br>
>><br>
>> Thanks guys! Still not working though<br>
>><br>
>> To get rid of that message I recreated the DB (well the user) and create the base and blocks tables:<br>
>><br>
>> create table blocks tablespace users pctfree 0 nologging<br>
>> lob(points) store as securefile (tablespace users nocompress<br>
>> cache reads nologging) as<br>
>> SELECT * FROM mdsys.SDO_PC_BLK_TABLE where 0 = 1;<br>
>><br>
>> create table blocksbase (id number, pc sdo_pc) tablespace users pctfree 0 nologging;<br>
>><br>
>> BTW, I had to add the ID to the base table (which I was not doing before).<br>
>><br>
>> But when I run PDAL now I get a Segmentation fault (XML below)<br>
> $ gdb --args pdal pipeline -i myfile.xml --developer-debug<br>
><br>
> Then press 'r' to run<br>
><br>
> when crashes, press 'bt' for backtrace. Please report the traceback here.<br>
><br>
> I just tested <a href="https://github.com/PDAL/PDAL/blob/master/test/data/oracle/write.xml">
https://github.com/PDAL/PDAL/blob/master/test/data/oracle/write.xml</a> 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.<br>
><br>
> Sorry for the challenges.<br>
><br>
> Howard<br>
><br>
<br>
</div>
</span></font>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>pdal mailing list</span><br><span><a href="mailto:pdal@lists.osgeo.org">pdal@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/mailman/listinfo/pdal">http://lists.osgeo.org/mailman/listinfo/pdal</a></span></div></blockquote></body></html>