ruby1.8: util.c:101: tds_set_state: Assertion `tds->state < (sizeof(state_names)/sizeof(state_names[0]))' failed. about tiny_tds HOT 6 CLOSED

The above code looks like a FreeTDS trace? Perhaps a FreeTDS bug? What version are you using?

from tiny_tds.

also: freetds-dev version 0.82-7 package on debian

from tiny_tds.

I've found an interesting work around...

I'm doing something like this:
client.execute("select * from tablename").each do |row|
MyClass.create(row)
end

The above loop breaks 200 or so iterations in.

When I instead do:

rows = client.execute("select * from tablename")
rows.count # force lazy evaluation of entire iterator ?
rows.each do |row|
  MyClass.create(row)
end

I'm wondering if client.execute is returning a lazily evaluated iterator, and that the problem lies therein somehow. Could a timeout occur during looping over a result set?

from tiny_tds.

Yea, the README explains this behavior.
https://github.com/rails-sqlserver/tiny_tds

If you use result.each(:cache_rows => false) it alleviates the need for putting the entire collection into memory just to iterate over it. I have not tested this raw behavior in a production env, especially one where the live read from the wire of the results takes a long time (increased by what happens in the block. For instance.

result = client.execute("SELECT * FROM [big_users_table]")
result.each(:cache_rows => false).each do |user_row|
  sleep(2)
end

YMMV when doing this. I am curious, on how big the select would have taken and how long would the sum of each block take in your case?

from tiny_tds.

Closing this issue. Please reopen if there is more information and/or actions that I need to take.

from tiny_tds.

I get the following error when I read more than 100 message at consumer side. I publish messages to RabbitMQ and have run a consumer to read from RabbitMQ it breaks when find more than 100 or sometimes 90's messages the error is given below

ruby: util.c:95: tds_set_state: Assertion `tds->state < (sizeof(state_names)/sizeof(state_names[0]))' failed. Aborted

from tiny_tds.