Re: [Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable
Brought to you by:
mused
|
From: Manuel S. <man...@sy...> - 2009-01-27 11:13:34
|
Well, I could trace the problem with rdebug (ruby debug) for one case. It seems that the SQLR Cursor is not working properly. The cursor has 82 columns but by accessing a value >=15 with for example Cursor.getField(0,15) or getRow(0) it always crashes. Interestingly enough: it does not crash for the other hundred cases where the script does exactly the same thing. There is an error log in this post. There are no errors displayed by using sqlr-status. Any suggestions how to solve this problem? Thanks in advance! Regards, Manuel -----Ursprüngliche Nachricht----- Von: Manuel Studer [mailto:man...@sy...] Gesendet: Montag, 26. Januar 2009 17:50 An: sql...@li... Betreff: [Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable Hi folks, I'm using Fedora Core 10 as a database connection client and I want to copy tables from a Sybase ASE 12.5 (freetds connection) database to a PostgreSQL 8.3 db. For this, I programmed a pure Ruby script. The script is working fine for several hundred rows, but then quits returning different errors like segmentation faults, invalid pointers, corrupted double-linked list (see errors_compilation.txt) etc. When starting the script a second time, it just crashes at another point. I tried different environments such as: CentOS 5.2 and latest FreeTDS connection library Fedora 9/10 with SQL Relay 0.39.4, SQL Relay 0.40, with Sybase Open Client Library or with FreeTDS connection I tried as well different Ruby Versions such as Ruby "Enterprise" and older versions too. However, the system crashes "randomly" at different points. The computer's memory is 100% ok (memtest). I started to use gdb and other tools, but no luck so far. Does anyone have some tips or suggestions to pinpoint the problem? Regards, Manuel |