Re: [Tora-develop] LONG datatype

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi,
can you please send me a dump of the table that crashes tora?
I unable to reproduce this on my laptop. What version of Oracle client 
you use?

I checked the stacktrace from Petr's email a it looks like OCI
reports that the fetched string has enormous length(alen=4294903165).
Tora crashes when it tries to copy a string of this length.

Ivan
PS: I tested the code with 11gR2 client libraries on 64bit Ubuntu and
on 32bit WinXP(MSVC).

On 01/06/2011 06:16 PM, Andreas Piesk wrote:
> On 06.01.2011 15:39, Petr Vanek wrote:
>> hmmm, I have nice crash with LONG:
>>
>> select * from plan_table;
>>
> strange, 'select * from table_with_long' works but 'select * from v$sql_plan' crashes:
>
> $ tora
> *** stack smashing detected ***: tora terminated
> ======= Backtrace: =========
> /lib/libc.so.6(__fortify_fail+0x4d)[0xc38fed]
> /lib/libc.so.6[0xc38f9a]
> tora(_ZNK12toOracleClob11displayDataEv+0x3d8)[0x84642f8]
> tora(_ZNK13toResultModel4dataERK11QModelIndexi+0x1df)[0x83268bf]
> /usr/lib/libQtGui.so.4(_ZNK19QStyledItemDelegate15initStyleOptionEP20QStyleOptionViewItemRK11QModelIndex+0x482)[0x29aa772]
> /usr/lib/libQtGui.so.4(_ZNK19QStyledItemDelegate8sizeHintERK20QStyleOptionViewItemRK11QModelIndex+0xdb)[0x29abcab]
> /usr/lib/libQtGui.so.4(_ZNK10QTableView17sizeHintForColumnEi+0x348)[0x2932db8]
> tora(_ZNK17toResultTableView17sizeHintForColumnEi+0x19)[0x8348099]
> /usr/lib/libQtGui.so.4[0x29047f7]
> /usr/lib/libQtGui.so.4[0x290bab2]
> /usr/lib/libQtGui.so.4(_ZN11QHeaderView14resizeSectionsENS_10ResizeModeE+0x24)[0x290f544]
> /usr/lib/libQtGui.so.4(_ZN10QTableView23resizeColumnsToContentsEv+0x2f)[0x29263cf]
> tora(_ZN17toResultTableView16applyColumnRulesEv+0x16c)[0x834849c]
> tora(_ZN17toResultTableView11handleFirstERKN12toConnection9exceptionEb+0x18)[0x8348698]
> tora(_ZN17toResultTableView11qt_metacallEN11QMetaObject4CallEiPPv+0x17c)[0x811898c]
> /usr/lib/libQtCore.so.4(_ZN11QMetaObject8metacallEP7QObjectNS_4CallEiPPv+0x3b)[0x215adeb]
> /usr/lib/libQtCore.so.4(_ZN11QMetaObject8activateEP7QObjectPKS_iPPv+0x2df)[0x2169c0f]
> tora(_ZN13toResultModel11firstResultERKN12toConnection9exceptionEb+0x42)[0x8116802]
> tora(_ZN13toResultModel8readDataEv+0x5c8)[0x8328368]
> tora(_ZN13toResultModel9fetchMoreEv+0x4b)[0x832846b]
> tora(_ZN13toResultModel11qt_metacallEN11QMetaObject4CallEiPPv+0x173)[0x81169b3]
> /usr/lib/libQtCore.so.4(_ZN11QMetaObject8metacallEP7QObjectNS_4CallEiPPv+0x3b)[0x215adeb]
> /usr/lib/libQtCore.so.4(_ZN11QMetaObject8activateEP7QObjectPKS_iPPv+0x2df)[0x2169c0f]
> tora(_ZN12toEventQuery13dataAvailableEPS_+0x36)[0x810d6d6]
> tora(_ZN12toEventQuery8taskDataER5QListI8toQValueE+0x29)[0x81e30a9]
> tora(_ZN12toEventQuery11qt_metacallEN11QMetaObject4CallEiPPv+0x13a)[0x810d84a]
> /usr/lib/libQtCore.so.4(_ZN11QMetaObject8metacallEP7QObjectNS_4CallEiPPv+0x3b)[0x215adeb]
> /usr/lib/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x37)[0x2165357]
> /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x23e)[0x216626e]
> /usr/lib/libQtGui.so.4(_ZN19QApplicationPrivate13notify_helperEP7QObjectP6QEvent+0xac)[0x23aaddc]
> /usr/lib/libQtGui.so.4(_ZN12QApplication6notifyEP7QObjectP6QEvent+0x176)[0x23b1836]
> /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x83)[0x2156413]
> /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x323)[0x21572d3]
> /usr/lib/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2e)[0x215742e]
> /usr/lib/libQtCore.so.4[0x217e9e0]
> /lib/libglib-2.0.so.0(g_main_context_dispatch+0x1f8)[0x31eec78]
> /lib/libglib-2.0.so.0[0x31f25e0]
> /lib/libglib-2.0.so.0(g_main_context_iteration+0x74)[0x31f26f4]
> /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x66)[0x217e4d6]
> /usr/lib/libQtGui.so.4[0x2459316]
> /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x4a)[0x2154aea]
> /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0xfa)[0x2154e2a]
> /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0xb7)[0x21574f7]
> /usr/lib/libQtGui.so.4(_ZN12QApplication4execEv+0x28)[0x23aae88]
> tora(main+0xaf2)[0x8121922]
> /lib/libc.so.6(__libc_start_main+0xe6)[0xb57cc6]
> tora[0x8103e91]
> ======= Memory map: ========
> 00110000-00111000 r-xp 00000000 00:00 0          [vdso]
> 00111000-0014f000 r-xp 00000000 fd:06 22788      /usr/lib/libQtXml.so.4.6.2
> 0014f000-00151000 rw-p 0003d000 fd:06 22788      /usr/lib/libQtXml.so.4.6.2
> 00151000-00154000 r-xp 00000000 fd:06 6353       /usr/lib/libavahi-glib.so.1.0.1
> 00154000-00155000 rw-p 00002000 fd:06 6353       /usr/lib/libavahi-glib.so.1.0.1
> 00156000-00158000 r-xp 00000000 fd:06 22748      /usr/lib/libXcomposite.so.1.0.0
> 00158000-00159000 rw-p 00001000 fd:06 22748      /usr/lib/libXcomposite.so.1.0.0
> 00159000-00161000 r-xp 00000000 fd:02 5646       /lib/libpopt.so.0.0.0
> 00161000-00162000 rw-p 00007000 fd:02 5646       /lib/libpopt.so.0.0.0
> 00162000-00164000 r-xp 00000000 fd:02 5664       /lib/libutil-2.12.so
> 00164000-00165000 r--p 00001000 fd:02 5664       /lib/libutil-2.12.so
> 00165000-00166000 rw-p 00002000 fd:02 5664       /lib/libutil-2.12.so
> 00167000-00175000 r-xp 00000000 fd:06 22744      /usr/lib/libXi.so.6.1.0
> 00175000-00176000 rw-p 0000d000 fd:06 22744      /usr/lib/libXi.so.6.1.0
> 00178000-0019f000 r-xp 00000000 fd:06 22737      /usr/lib/libpng12.so.0.44.0
> 0019f000-001a0000 rw-p 00027000 fd:06 22737      /usr/lib/libpng12.so.0.44.0
> 001a2000-001aa000 r-xp 00000000 fd:06 22738      /usr/lib/libXrender.so.1.3.0
> 001aa000-001ab000 rw-p 00008000 fd:06 22738      /usr/lib/libXrender.so.1.3.0
> 001ad000-001af000 r-xp 00000000 fd:06 22743      /usr/lib/libXinerama.so.1.0.0
> 001af000-001b0000 rw-p 00001000 fd:06 22743      /usr/lib/libXinerama.so.1.0.0
> 001b0000-001b2000 r-xp 00000000 fd:06 8477       /usr/lib/gtk-2.0/modules/libpk-gtk-module.so
> 001b2000-001b3000 rw-p 00002000 fd:06 8477       /usr/lib/gtk-2.0/modules/libpk-gtk-module.so
> 001b3000-002e7000 r-xp 00000000 fd:06 22731      /usr/lib/libX11.so.6.3.0
> 002e7000-002eb000 rw-p 00133000 fd:06 22731      /usr/lib/libX11.so.6.3.0
> 002ee000-00382000 r-xp 00000000 fd:06 8292       /usr/lib/libfreetype.so.6.3.22
> 00382000-00386000 rw-p 00094000 fd:06 8292       /usr/lib/libfreetype.so.6.3.22
> 00386000-0039c000 r-xp 00000000 fd:02 5662       /lib/libnsl-2.12.so
> 0039c000-0039d000 r--p 00016000 fd:02 5662       /lib/libnsl-2.12.so
> 0039d000-0039e000 rw-p 00017000 fd:02 5662       /lib/libnsl-2.12.so
> 0039e000-003a0000 rw-p 00000000 00:00 0
> 003a0000-003be000 r-xp 00000000 fd:06 22750      /usr/lib/libgdk_pixbuf-2.0.so.0.1800.9
> 003be000-003bf000 rw-p 0001d000 fd:06 22750      /usr/lib/libgdk_pixbuf-2.0.so.0.1800.9
> 003bf000-003c6000 r-xp 00000000 fd:06 14004      /usr/lib/libgailutil.so.18.0.1
> 003c6000-003c7000 rw-p 00006000 fd:06 14004      /usr/lib/libgailutil.so.18.0.1
> 003c7000-003cb000 r-xp 00000000 fd:06 22795      /usr/lib/libORBitCosNaming-2.so.0.1.0
> 003cb000-003cc000 rw-p 00004000 fd:06 22795      /usr/lib/libORBitCosNaming-2.so.0.1.0
> 003cc000-003d0000 r-xp 00000000 fd:06 8075       /usr/lib/gtk-2.0/modules/libcanberra-gtk-module.so
> 003d0000-003d1000 rw-p 00004000 fd:06 8075       /usr/lib/gtk-2.0/modules/libcanberra-gtk-module.so
> 003d1000-003f7000 r-xp 00000000 fd:02 2629       /lib/libexpat.so.1.5.2
> 003f7000-003f9000 rw-p 00025000 fd:02 2629       /lib/libexpat.so.1.5.2
> 003fb000-00402000 r-xp 00000000 fd:06 22745      /usr/lib/libXrandr.so.2.2.0
> 00402000-00403000 rw-p 00006000 fd:06 22745      /usr/lib/libXrandr.so.2.2.0
> 00405000-0043f000 r-xp 00000000 fd:06 14065      /usr/lib/libQtSql.so.4.6.2
> 0043f000-00441000 rw-p 0003a000 fd:06 14065      /usr/lib/libQtSql.so.4.6.2
> 00441000-00455000 r-xp 00000000 fd:06 22798      /usr/lib/libgnome-2.so.0.2800.0
> 00455000-00456000 rw-p 00014000 fd:06 22798      /usr/lib/libgnome-2.so.0.2800.0
> 00456000-0045a000 r-xp 00000000 fd:06 22757      /usr/lib/libcanberra-gtk.so.0.1.5
> 0045a000-0045b000 rw-p 00003000 fd:06 22757      /usr/lib/libcanberra-gtk.so.0.1.5
> 0045b000-0045e000 r-xp 00000000 fd:06 150221     /usr/lib/qt4/plugins/imageformats/libqsvg.so
> 0045e000-0045f000 rw-p 00002000 fd:06 150221     /usr/lib/qt4/plugins/imageformats/libqsvg.so
> 0045f000-00461000 r-xp 00000000 fd:06 2169       /usr/lib/gconv/UTF-16.so
> 00461000-00462000 r--p 00001000 fd:06 2169       /usr/lib/gconv/UTF-16.so
> 00462000-00463000 rw-p 00002000 fd:06 2169       /usr/lib/gconv/UTF-16.so
> 00463000-0046e000 r-xp 00000000 fd:06 5802       /usr/lib/libavahi-common.so.3.5.1
> 0046e000-0046f000 rw-p 0000a000 fd:06 5802       /usr/lib/libavahi-common.so.3.5.1
> 00473000-004a6000 r-xp 00000000 fd:06 8300       /usr/lib/libfontconfig.so.1.4.4
> 004a6000-004a8000 rw-p 00032000 fd:06 8300       /usr/lib/libfontconfig.so.1.4.4
> 004a8000-004ed000 r-xp 00000000 fd:02 1506       /lib/libdbus-1.so.3.4.0
> 004ed000-004ee000 r--p 00044000 fd:02 1506       /lib/libdbus-1.so.3.4.0
> 004ee000-004ef000 rw-p 00045000 fd:02 1506       /lib/libdbus-1.so.3.4.0
> 004ef000-004fa000 r-xp 00000000 fd:06 22742      /usr/lib/libpangocairo-1.0.so.0.2800.1
> 004fa000-004fb000 rw-p 0000a000 fd:06 22742      /usr/lib/libpangocairo-1.0.so.0.2800.1
> 004fb000-00518000 r-xp 00000000 fd:06 22752      /usr/lib/libatk-1.0.so.0.2809.1
> 00518000-0051a000 rw-p 0001c000 fd:06 22752      /usr/lib/libatk-1.0.so.0.2809.1
> 0051a000-00522000 r-xp 00000000 fd:06 13705      /usr/lib/libvorbisfile.so.3.3.2
> 00522000-00523000 rw-p 00007000 fd:06 13705      /usr/lib/libvorbisfile.so.3.3.2
> 00523000-00528000 r-xp 00000000 fd:06 24490      /usr/lib/libogg.so.0.6.0
> 00528000-00529000 rw-p 00005000 fd:06 24490      /usr/lib/libogg.so.0.6.0
> 00529000-00532000 r-xp 00000000 fd:06 22747      /usr/lib/libXcursor.so.1.0.2
> 00532000-00533000 rw-p 00008000 fd:06 22747      /usr/lib/libXcursor.so.1.0.2
> 00535000-00537000 r-xp 00000000 fd:06 22749      /usr/lib/libXdamage.so.1.1.0
> 00537000-00538000 rw-p 00001000 fd:06 22749      /usr/lib/libXdamage.so.1.1.0
> 00538000-00547000 r-xp 00000000 fd:06 24470      /usr/lib/libavahi-client.so.3.2.5
> 00547000-00548000 rw-p 0000f000 fd:06 24470      /usr/lib/libavahi-client.so.3.2.5
> 00549000-00552000 r-xp 00000000 fd:02 1443       /lib/libkrb5support.so.0.1
> 00552000-00553000 rw-p 00008000 fd:02 1443       /lib/libkrb5support.so.0.1
> 00555000-0057b000 r-xp 00000000 fd:02 1529       /lib/libk5crypto.so.3.1
> 0057b000-0057c000 rw-p 00026000 fd:02 1529       /lib/libk5crypto.so.3.1
> 0057c000-00585000 r-xp 00000000 fd:06 13908      /usr/lib/libltdl.so.7.2.1
> 00585000-00586000 rw-p 00008000 fd:06 13908      /usr/lib/libltdl.so.7.2.1
> 00587000-005ca000 r-xp 00000000 fd:02 2575       /lib/libgobject-2.0.so.0.2200.5
> 005ca000-005cb000 rw-p 00043000 fd:02 2575       /lib/libgobject-2.0.so.0.2200.5
> 005cb000-0073d000 r-xp 00000000 fd:06 4788       /usr/lib/libcrypto.so.1.0.0
> 0073d000-00751000 rw-p 00172000 fd:06 4788       /usr/lib/libcrypto.so.1.0.0
> 00751000-00754000 rw-p 00000000 00:00 0
> 00754000-00759000 r-xp 00000000 fd:06 150220     /usr/lib/qt4/plugins/imageformats/libqmng.so
> 00759000-0075a000 rw-p 00004000 fd:06 150220     /usr/lib/qt4/plugins/imageformats/libqmng.soAbgebrochen
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment, and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Tora-develop mailing list
> Tor...@li...
> https://lists.sourceforge.net/lists/listinfo/tora-develop