Peter Fitzgibbons
2006-Jun-26 21:12 UTC
[Rails] Rake + SQL Server + Migrations == Errors. Help?!
Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter Fitzgibbons ================== database.yml ================ ================== end database.yml ==============development: adapter: sqlserver database: buildview_dev host: localhost username: user password: password # Warning: The database defined as ''test'' will be erased and # re-generated from your development database when you run ''rake''. # Do not set this db to the same as development or production. test: adapter: sqlserver database: buildview_test host: localhost username: user password: password production: adapter: sqlserver database: buildview_rails host: production username: user password: password ============== schema.rb =================# This file is autogenerated. Instead of editing this file, please use the # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. ActiveRecord::Schema.define() do # Could not dump table "SalesCustomers" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "SalesPlans" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "community_news" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex community_news # Could not dump table "community_news_users" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "disclaimers" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex disclaimers # Could not dump table "home_milestones" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "homes" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex homes # Could not dump table "homes_users" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "lots" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex lots # Could not dump table "milestone_fixture" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "milestone_masters" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex milestone_masters # Could not dump table "permissions" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex permissions # Could not dump table "permissions_roles" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "plans" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex plans # Could not dump table "roles" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex roles # Could not dump table "roles_users" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "sales_lot_status" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "salescancellations" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex salescancellations # Could not dump table "salescommunities" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "salesconfigurations" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "salesconstructionstages" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "saleslots" because of following DBI::DatabaseError # EOF OLE error code:800A0E78 in ADODB.Recordset Operation is not allowed when the object is closed. HRESULT error code:0x80020009 Exception occurred. # Could not dump table "subdivisions" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex subdivisions # Could not dump table "user_login_history" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex user_login_history # Could not dump table "users" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex users # Could not dump table "workflows" because of following ActiveRecord::StatementInvalid # DBI::DatabaseError: Count OLE error code:8000FFFF in Microsoft OLE DB Provider for SQL Server ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state. HRESULT error code:0x80020009 Exception occurred.: EXEC sp_helpindex workflows end ================ end schema.rb ================-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060626/d589a0b1/attachment-0001.html
Rafael Szuminski
2006-Jun-26 22:55 UTC
[Rails] Rake + SQL Server + Migrations == Errors. Help?!
I have run into the zombie transaction before. Add this to your environment.rb: #uncomment this for dumping schema with rake, comment out afterwards, otherwise migrations don''t work #ActiveRecord::Base.connection.instance_variable_get("@connection")["AutoCommit"] = false and uncomment the second line before running rake and comment out after rake finishes. Hope it helps raf