Re: [Sqlrelay-discussion] Ruby + Sybase (+ PostgreSQL) very unstable

[Manuel S. <man...@sy...>]

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