I have a freshly created SAP DB database instance (SAP DB 7.3.0.21). Now I run "ireport.py" and do a "select * from tables".
I get some result, enter "n" to get the next page of results. After some n's, the script hangs: ... ==> n |OWNER|TABLENAME|PRIVILEGES|TYPE|TABLETYPE|CREATEDATE|CREATETIME|UPDSTATDATE|UPDSTATTIME|ALTERDATE|ALTERTIME|UNLOADED|SAMPLE_PERCENT|SAMPLE_ROWS|COMMENT|TABLEID| +-----+---------+----------+----+---------+----------+----------+-----------+-----------+---------+---------+--------+--------------+-----------+-------+-------+ |DOMAIN|CONNECTPARAMETERS|SEL|SYSTEM|VIEW|20020426|00102613|?|?|?|?|?|?|?|Connect parameters for current user|�| Now I press Ctrl-\ to quit and make an core dump. When I read this core dump and make a backtrace, I will see the following: mnz66:/usr/src/sapdb# gdb /usr/bin/python core (no debugging symbols found)... warning: core file may not match specified executable file. Core was generated by `/usr/bin/python ./ireport.py -d TST -u mnedv,mnedv'. Program terminated with signal 3, Quit. Reading symbols from /lib/libpthread.so.0...done. warning: Unable to set global thread event mask: generic error [New Thread 1024 (LWP 3856)] Error while reading shared library symbols: Cannot enable thread event reporting for Thread 1024 (LWP 3856): generic error Reading symbols from /lib/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/libutil.so.1...done. Loaded symbols for /lib/libutil.so.1 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /usr/lib/python2.1/lib-dynload/strop.so...done. Loaded symbols for /usr/lib/python2.1/lib-dynload/strop.so Reading symbols from /usr/lib/python2.1/lib-dynload/readline.so...done. Loaded symbols for /usr/lib/python2.1/lib-dynload/readline.so Reading symbols from /lib/libreadline.so.4.2...done. Loaded symbols for /lib/libreadline.so.4.2 Reading symbols from /lib/libtermcap.so.2...done. Loaded symbols for /lib/libtermcap.so.2 Reading symbols from /usr/sapdb/misc/sapdbmodule.so...done. Loaded symbols for /usr/sapdb/misc/sapdbmodule.so Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 Reading symbols from /lib/libnss_nisplus.so.2...done. Loaded symbols for /lib/libnss_nisplus.so.2 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libnss_nis.so.2...done. Loaded symbols for /lib/libnss_nis.so.2 #0 0x40152ddf in semop () from /lib/libc.so.6 (gdb) bt #0 0x40152ddf in semop () from /lib/libc.so.6 #1 0x40257ff5 in sql33_receive () from /usr/sapdb/misc/sapdbmodule.so #2 0x4024ce01 in SqlAPing () from /usr/sapdb/misc/sapdbmodule.so #3 0x4024d921 in sqlareceive () from /usr/sapdb/misc/sapdbmodule.so #4 0x4024346d in i28receiveForPython () from /usr/sapdb/misc/sapdbmodule.so #5 0x40238642 in _init () from /usr/sapdb/misc/sapdbmodule.so #6 0x40238801 in _init () from /usr/sapdb/misc/sapdbmodule.so #7 0x4023893f in _init () from /usr/sapdb/misc/sapdbmodule.so #8 0x40238ab7 in _init () from /usr/sapdb/misc/sapdbmodule.so #9 0x0805aae3 in PyEval_EvalCode () #10 0x565708ec in ?? () Error accessing memory address 0x83e58955: No such process. (gdb) This happens with python-2.1.1-mdk1 from Mandrake and with both sapdb-python-linux-i386-7.3.00.20.tgz and sapdb-python-linux-i386-7.3.00.22x.tgz. I then tried a sequence of select owner from tables select owner,tablename from tables select owner,tablename,privileges from tables and it worked all until I reached "... ,comments from tables". So something in this areas seems to be very wrong at the moment ... Greetings to Berlin, H.Schurig -- MN-Logistik GmbH http://www.mn-logistik.de Holger Schurig Network Administrator Dieselstr. 18 61191 Rosbach v.d.H�he Tel: 06003/9141-0 Fax: 06003/9141-49 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
