search for: savepoint

Hi, I''m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch of Mysql Errors : Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''RELEASE SAVEPOINT active_record_1'' at line 1: RELEASE SAVEPOINT active_record_1 Mysql version is 4.1.22 which supports save points but not the RELEASE SAVEPOINT command. I did a test under mysql console. So, - is Rails 2.3.2 incompatible with mysql 4.1.22 ? - is there a special Mysql adapter ? Thanks --...

Hello! I experienced problems with testing transactions which are supposed to be rolled back, but are not, because of transactional fixtures eliminating the inner transaction. Can this be worked around somehow without turning off transactional fixtures? Maybe savepoints can help this? Does anyone have any experience with savepoints to achieve nested transaction functionality? Both Postgres and MySQL support savepoints (didn''t check others). I was thinking to make a custom patch for AR to create savepoints for inner transactions. Can somebody help me...

...est units all should be okay" do file = File.new("test/files/lib/upload_sample.xml") upload = XmlUpload.create(:xml_contents => contents = file.read) ..... ..... end The create line is throwing up the following error ActiveRecord::StatementInvalid: Mysql2::Error: SAVEPOINT active_record_1 does not exist: ROLLBACK TO SAVEPOINT active_record_1 /Users/conor/.rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.0.3/lib/ active_record/connection_adapters/abstract_adapter.rb:202:in `rescue in log'' /Users/conor/.rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.0.3/lib/...

hello can anybody help me with this bug, (this sometimes occur sometimes passes) 1) ActiveRecord::StatementInvalid in ''MailReader on Simple Tasks should not accept duplicate email'' Mysql::Error: MySQL server has gone away: ROLLBACK TO SAVEPOINT active_record_1 /home/poldz/.gem/ruby/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'' /home/poldz/.gem/ruby/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:323:in `execute'' /home/poldz/.gem/ruby/...

Rails 2.3.5 I am working on a nested form that assigns roles to users through a table called clearances. I have attr_acessable turned off globally in an initializer: ActiveRecord::Base.send(:attr_accessible, nil) I have this set in clearance.rb attr_accessible(:description, :effective_from, :role_id, :superceded_after, :user_id) And this is what params looks like after the

...uel was designed in a way that it won''t allow users to directly manipulate connections and control where to start and end transactions. So it only provides a block-based approach: Here is how this would be implemented in Sequel (assuming a decent database like PostgreSQL that supports savepoints - if that is not the case, just remove the :savepoint option): DB.transaction(savepoint: true, rollback: :always) do # sandboxed database access here: u = User[1] u.name = ''Changed'' u.save_changes end I have a similar issue with the design of RSpec lack of an aroun...

...that job, my session is isolated and I don''t see any data. But: If the job fails (exeption) there is data in the database - although a rollback is performed: The rollback itself is logged "SQL (0.1ms) ROLLBACK" - and no COMMIT is logged. Is rails perfoming a "ROLLBACKUP TO SAVEPOINT" instead? How can I make sure, that no data is written, if a ROLLBACK happens? Thanks, yanosz -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6...

...l-3.35.0/lib/sequel/database/query.rb:253:in `transaction'' # /home/rodrigo/ecore/src/ruby/matterhorn/spec/spec_helper.rb:51:in `block (3 levels) in <top (required)>'' ... See this spec_helper extract: config.around(:each) do |example| 51: DB.transaction(savepoint: true, rollback: :always) do example.run end end Any idea of what has been changed since the releases I''m using that could be causing this? Only the first spec is failing. All others are passing. I don''t have any clue why I can''t upgrade RSpec......

...t, enable it and restart apache - Tell all ''web servers'' expect server ''adam'' and ''eva'' to stop service vsftpd - Tell all servers which are not ''dedicated servers'', to run `apt-get upgrade`, run a check script and run `apt-savepoint restore` if the script fails - Tell server ''tiny'' to reboot - Tell all ''web servers'' to change /etc/my.cnf and restart mysql I do not want: - That a config file is automatically overwritten when manually alter it on the local server (I do want to be able to...

...serting. When trying to use the same connection among the parent process and its children, I get into a total mess (due to concurrent access to the db connection). Sample errors from different runs: The famous "MySQL has gone away" Some other times it work perfectly! "Mysql::Error: SAVEPOINT active_record_1 does not exist" "undefined method all_hashes for nil:NilClass" I know that I have so many issues to handle here: concurrency safety, blocking DB adapter, the nature of the testing environment..etc But, is there another approach to handle it? What is the best practi...

...ver. > This works using rsync's hard-link option to minimize wasted disk space. > This means that the recovery process is just copying the files you need. > Also, graceful recovery for downtime and optimistic disk space usage are > both very nice. (it will try to keep as many backup savepoints as it can > disk space depending) > > I'm evaluating ZFS and will likely include some features of ZFS into > BBuddy as we integrate these capabilities into our backup processes. > We're free to do this in part because we have redundant backup sets, so > a single failure w...