Skip to Content
avatar image
Former Member

Loader in Python crashes on binary columns (MaxDB 7.6)


Hi, I currently use MaxDB 7.6.06 Build 003-121-202-135 on Linux and experience severe problems with binary columns and the loader. I do the following (with Python):

session = sdb.loader.Loader ()


cmd = "EXPORT COLUMNS * FROM some_binary_table DATA OUTSTREAM 'myfile' FWV BINARY"


For normal tables without binary columns, this works. However, for tables with binary columns that look like this it crashes:

CREATE TABLE my_binary_table (




The output of my script is the following:


snip -

EXPORT COLUMNS * FROM my_binary_table DATA OUTSTREAM '/tmp/output.dat' FWV BINARY


> Emergency stack backtrace <----

Using 'backtrace' for stack tracing












> Dump of siginfo contents <----

signal: 11(SIGSEGV)

code: 1(ILL_ILLOPC:illegal opcode)

errno: 0

value(int): 66(0x42)

value(ptr): 0x42

pid: 0

addr: (nil)


> Register Dump <----

rax: 0x0000000000000000 rbx: 0x0000000000c55ea8

rcx: 0x0000000000c5a530 rdx: 0x0000000000000003

rsi: 0x0000000000c55b90 rdi: 0x0000000000a36440

rsp: 0x00007fffe4c70c10 rbp: 0x0000000000000004

r08: 0x0000000000a36340 r09: 0x0101010101010101

r10: 0x0000000000000000 r11: 0x00007febdb79d50e

r12: 0x0000000000c54c30 r13: 0x0000000000000002

r14: 0x0000000000c533f2 r15: 0x0000000000000003

rip: 0x0000000000720920 eflg: 0x0000000000010246

cs: 0x0000 gs: 0x0000

fs: 0x0000

omsk: 0x0000000000000000 cr2: 0x0000000000000000

trap: 0x000000000000000e err: 0x0000000000000004


> Floating-point register dump <----

foper: 0x0000 frip: 0x0000000000000000 fdata: 0x0000000000000001

control: 0x0001 status: 0x0000 tag: 0x0000

mxcsr: 0x0000037f mxcr_mask: 0x00000000

fp[0]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[1]: 0x0.1f80 0000 ffff 0000 * 2^0x0000

fp[2]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[3]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[4]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[5]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[6]: 0x0.0000 0000 0000 0000 * 2^0x0000

fp[7]: 0x0.0000 0000 0000 0000 * 2^0x0000

xmm[00]: 0x00000000.00000000.00000000.00000000

xmm[01]: 0x00000000.00000000.00000000.00000000

xmm[02]: 0x00000000.00000000.00000000.00000000

xmm[03]: 0x00000000.00000000.00000000.00000000

xmm[04]: 0x00000000.00000000.00000000.00000000

xmm[05]: 0x00000000.00000000.00000000.00000000

xmm[06]: 0x00000000.00000000.00000000.00000000

xmm[07]: 0x00000000.00000000.00000000.00000000

xmm[08]: 0x00000000.00000000.00000000.00000000

xmm[09]: 0x00000000.00000000.00000000.00000000

xmm[10]: 0x00000000.00000000.00000000.00000000

xmm[11]: 0x00000000.00000000.00000000.00000000

xmm[12]: 0x00000000.00000000.00000000.00000000

xmm[13]: 0x00000000.00000000.00000000.00000000

xmm[14]: 0x00000000.00000000.00000000.00000000

xmm[15]: 0x00000000.00000000.00000000.00000000


> Module List <----

|.text Start |.text End | Module File Name

|0x0000000000400000|0x00000000008e3000| /opt/sdb/programs/pgm/lserver

|0x00007febdb71e000|0x00007febdb86d000| /lib64/

|0x00007febdba77000|0x00007febdba8d000| /lib64/

|0x00007febdbc8e000|0x00007febdbce3000| /lib64/

|0x00007febdbee4000|0x00007febdbfd4000| /usr/lib64/

|0x00007febdc1f0000|0x00007febdc1f8000| /lib64/

|0x00007febdc3f9000|0x00007febdc40f000| /lib64/

|0x00007febdc615000|0x00007febdc622000| /lib64/

|0x00007febdc852000|0x00007febdc854000| /lib64/

|0x00007febdca56000|0x00007febdca73000| /lib64/


> Symbolic stack backtrace <----

0: Lunlock_17 + 0x2f

SFrame: IP: 0x00007febdc407b30 (0x00007febdc407b01+0x2f)

Module: /lib64/


1: ls27_InitDatExtrRec(tls00_DBInfo, MetaDataDef&, tls00_TransformationCmd*,

tls00_DextractRec&, char) + 0xa90

Symbol: Z19ls27InitDatExtrRecP12tls00_DBInfoRP11MetaDataDefP23tls00_T


SFrame: IP: 0x0000000000720920 (0x000000000071fe90+0xa90)

Module: /opt/sdb/programs/pgm/lserver


2: ls27ExportTableRows(MetaDataDef&, tls00_DextractRec, char*) + 0xae

Symbol: Z19ls27ExportTableRowsRP11MetaDataDefP17tls00DextractRecPc

SFrame: IP: 0x00000000007268ce (0x0000000000726820+0xae)

Module: /opt/sdb/programs/pgm/lserver


3: ExportPackageDataRecord(MetaDataDef, tls00_DBInfo, char*) + 0x72c

Symbol: Z23ExportPackageDataRecordP11MetaDataDefP12tls00DBInfoPc

SFrame: IP: 0x000000000071eecc (0x000000000071e7a0+0x72c)

Module: /opt/sdb/programs/pgm/lserver


4: ExecuteTransformationPackage(tls00_Command, tls00_DBInfo) + 0x2ac

Symbol: Z28ExecuteTransformationPackageP13tls00CommandP12tls00_DBInfo

SFrame: IP: 0x00000000006e4d9c (0x00000000006e4af0+0x2ac)

Module: /opt/sdb/programs/pgm/lserver


5: ParseExecuteStatement(tls00_Command&, tls00_DBInfo) + 0x550

Symbol: Z21ParseExecuteStatementRP13tls00CommandP12tls00_DBInfo

SFrame: IP: 0x00000000006e6ee0 (0x00000000006e6990+0x550)

Module: /opt/sdb/programs/pgm/lserver


6: ctrlservcommand + 0x398

SFrame: IP: 0x00000000006df8a8 (0x00000000006df510+0x398)

Module: /opt/sdb/programs/pgm/lserver


7: c_main + 0x451

SFrame: IP: 0x00000000004142f1 (0x0000000000413ea0+0x451)

Module: /opt/sdb/programs/pgm/lserver


8: 0x00007febdb73c436 <symbol name not found>

SFrame: IP: 0x00007febdb73c436

Module: /lib64/


9: __gxx_personality_v0@@CXXABI_1.3 + 0xea

SFrame: IP: 0x0000000000413c3a (0x0000000000413b50+0xea)

Source: start.S:116

Module: /opt/sdb/programs/pgm/lserver

Traceback (most recent call last):

File "/home/dusty/bin/bsppython", line 142, in ?


File "./", line 8, in ?


File "/home/dusty/prog/bsp/buildout/src/sa_tools/sa_tools/dump/", l ine 17, in dump_table_data

dbdump(conn,, FILENAME_PATTERN % (, fn))

File "/home/dusty/prog/bsp/buildout/src/sa_tools/sa_tools/dump/", line 37, in dbdump


loader.CommunicationError: loader.CommunicationError: [1] Reading header from pi pe:closed by serve

ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'


snip -

Any clues about how to get around this?

Best Regards,

Hermann Himmelbauer</pre>

Edited by: Hermann Himmelbauer on Jul 7, 2009 4:54 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 07, 2009 at 02:59 PM


    would it be possible you upgrade the loader to version 7.7?

    Maybe you could give it a try on second machine and access your database remotely.

    Best Regards


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 07, 2009 at 04:02 PM

    Thanks for your hint, but I found another satisfying solution: MaxDB has the the possibility to export all non-binary data to a CSV-File format and export the rest to a specific binary file like that:

    EXPORT COLUMNS * FROM mytable DATA OUTSTREAM 'mytable.csv' LOB OUTSTREAM 2 'mytable.dat'

    This fortunately works now!

    Best Regards,

    Hermann Himmelbauer

    Add comment
    10|10000 characters needed characters exceeded