This project is archived and is in readonly mode.
Windows & sqlserver - ActiveRecord::StatementInvalid (NoMemoryError: failed to allocate memory: SELECT
-
Rhett Barber@items = Item.limit(50).all
-
Rhett Barber
This happens to queries at random. Sometimes it will let them through, other times it gives this error. I have tried serving with mongrel, thin, rails s. I have tried all the 3.x versions of the activerecord-sqlserver-adapter.
-
Rhett Barber
Windows 7 Ultimate x64 dual quad with 8gb ram.
-
Rhett Barber
This is the best player divided correctly.
http://www.blueletterbible.org/bibleplayer/mp3bibleplayer.cfm?t=KJV... -
Rhett Barber
Commented out this
rescue Exception => e
message = "#{e.class.name}: #{e.message}: #{sql}"
@logger.debug message if @logger
raise translate_exception(e, message)
seems to work somehow. Have not extensively tested.
-
kdgundermann
Are you using the sqlserver adapter with ruby-odbc or with TinyTDS ?
-
Rhett Barber
http://www.ch-werner.de/rubyodbc/
It contains the files odbc.so and odbc_utf8.so which need to be copied into the .../ruby/1.8/i386-msvcrt directory of MSVC based Ruby 1.8 installations.
and
gem 'rails', '3.0.1'
gem 'activerecord-sqlserver-adapter' , '3.0.6'I BELIEVE COMMENTING OUT THE ABOVE HAS FIXED THIS ISSUE TEMPORARILY, I NEED MORE TIME TO CONFIRM.
-
Rhett Barber
It is happening again. I will work to narrow the causes.
-
Rhett Barber
Restarting the computer allows the exact query that failed to execute. Restarting mongrel and closing the command prompt and then restarting mongrel or thin does not help (the exact same query fails-even simple ones).
-
Rhett Barber
Convert all ntext fields to text. I knew this before but thought I had already converted all columns. I missed two in this table. I will test thoroughly tomorrow and report status. It works right off.
-
Rhett Barber
Still working fine. RAILS 3 IS AWESOME. THANKS RAILS CONTRIBUTORS!! GOD BLESS YOU. MERRY CHRISTMAS.
-
rails- State changed from new to open
This issue has been automatically marked as stale because it has not been commented on for at least three months.
The resources of the Rails core team are limited, and so we are asking for your help. If you can still reproduce this error on the 3-0-stable branch or on master, please reply with all of the information you have about it and add "[state:open]" to your comment. This will reopen the ticket for review. Likewise, if you feel that this is a very important feature for Rails to include, please reply with your explanation so we can consider it.
Thank you for all your contributions, and we hope you will understand this step to focus our efforts where they are most helpful.
-
rails
- State changed from open to stale