similar to: autocommit problem with mysql

Hello All, I''ve run into a snag. (I apologize in advance. I''m not very good at system administration.) I''m building an app that allows users to upload files. Up until now I have been storing the files on the file system, but tonight I decided to change the app so the files are stored in the database as a longblob. I thought everything was working great, until I

How can I turn autocommit off using my RODBC connection to an Informix database? I want to turn autocommit off, insert a thousand or so rows then commit. I would appreciate any body's input on this.

Hello, Once or twice a day I''m losing connection to MySQL and this error is generated: Mysql::Error: Lost connection to MySQL server during query: INSERT INTO pictures (`content_type`, `name`, `size`, `thumbnail`, `updated_at`, `pictureable_type`, `description`, `pictureable_id`, `filename`, `height`, `user_id`, `parent_id`, `created_at`, `width`) VALUES(''image/jpeg'',

Hello Gluster Community, while reading that article: https://github.com/gluster/glusterfs-specs/blob/master/under_review/worm-compliance.md there seems to be an interesting feature planned for the WORM Xlator: *Scheduled Auto-commit*: Scan Triggered Using timeouts for untouched files. The next scheduled namespace scan will cause the transition. CTR DB via libgfdb can be used to find files that

I need to turn off and on the autocommit in MySql is there a method in active records that allows me to do this? or is there a method which allows me to type in the pure mysql code "set autocommit=0" Thanks. -- Posted via http://www.ruby-forum.com/.

Hello guys, I''m developing a new app in Rails, and every now and then I get an ActiveRecord error, I cannot reproduce exactly what triggers it, hope you can help me, or give me tips on debugging this kind of stuff. This time I got the error reporting page, but normally I would just see the 500.html page, with no info about what went wrong. This is the error (it''s the complete

Hello I''m having some issues with MySQL losing it''s connection, or undefined class User on Windows XP. I use Login and UserEngine. Rails 1.0/1.1, MySQL 4. MySQL problem (one of them): Mysql::Error: Lost connection to MySQL server during query: UPDATE sessions SET `data` =

Hi Another problem here. After the upgrade to 1.1 both rails and engines, my app on windows crashes very often on requests. It can''t refer to User model or losts connection to mysql. It appears like 2-3 times per 10 requests. Eg. Mysql::Error: Lost connection to MySQL server during query: UPDATE sessions SET `data` =

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

How do I get ''save'' to execute without commit? I have tried: ActiveRecord::Base.connection.begin_db_transaction # do some stuff that doesn''t issue a database COMMIT statement # then: @myObject.save # this issues a COMMIT but it shouldn''t! Shouldn''t it wait until I''ve called: ActiveRecord::Base.connection.commit_db_transaction ? what am

I am currently using the book "Agile Web Development With Rails" (2005). I am working on a fully function web application that has a shopping cart. The web page displays this, ActiveRecord::StatementInvalid in AdminController#create Mysql::Error: #23000Column ''date_available'' cannot be null: INSERT INTO products (`image_url`, `date_available`, `price`, `title`,

Hi all - I know this must be really easy to do, but I can''t for the life of me figure it out. I have about 100,000 rows I need to migrate over into rails using a migration. Right now, I select all of them out of the old database and do a series of: ... new.col = old.col ... new.save ... Problem is each one is it''s own transaction. And it''s slow. I''d

I''m building rails 3 with legacy oracle 10g db. which it''s sequence is non rails convension. I have try this. class AdCourt < ActiveRecord::Base set_sequence_name ''COURT_SEQ'' end with rails console : AdCourt.sequence_name I have got "COURT_SEQ" which look ok. When AdCourt.create!(:caption => ''AAAA'', :code =>

Hello Group, I have a problem with pending tasks in puppet-dashboard after I set the MySQL parameter autocommit = 0 and sql_mode = TRADITIONAL. Does the dashboard need autocommit to be enabled? Workers are running: env RAILS_ENV=production script/delayed_job status delayed_job: running [pid 4995] delayed_job: running [pid 5019] Regards Kai -- You received this message because you

Hello, $ ruby script/generate model balance plus:integer minus:integer equal:integer $ cat app/models/balance.rb class Balance < ActiveRecord::Base def save self.equal = self.plus - self.minus super end end $ cat test/fixtures/balances.yml _10-1: plus: 10 minus: 1 $ rake db:fixtures:load $ sqlite3 db/development.sqlite3 sqlite> select * from balances; //=>

I am using a plugin that adds a method to ActiveRecord::Base. The added method is called self.create_or_update. I need to monkey patch this method. I tried in lib/ config/initializers and in environment.rb, but the one in the plugin is always the one that is run. Where do I put my version of the method so that it overrides that of the plugin? I only use this method when running a rake task, so

Hi, by switching to MySQL from SQLite, it fixed the problem. I ran rdebug on it and it is trying to call I ActiveRecord::Base.connection.begin_db_transaction. from ActiveRecordSafetyListener.scenario_started. I don''t think SQLLite likes transactions. Ed On Nov 15, 2007 10:56 AM, Ed Howland <ed.howland at gmail.com> wrote: > If I run the story stand-alone, I get: > ruby

Hi, After playing while with ActiveRecord, I''m surprised it isn''t easier to insert data into a table whose primary key is not auto-incremented by the database server. The following code... --------------------------------------- -- MySQL database "test" --------------------------------------- CREATE TABLE gardens ( code integer NOT NULL, name

I have been working through an upgrade of my 1.2.6 application to 2.2.2. I am almost there but I have hit a problem with ActiveRecord. Before the upgrade, the following code was working fine. def create_root(administrator) root = create_root_collection(self.pingee_name, administrator,

I''ve been editing a rails app on Windows for a little while now. I just checked it into source control and started editing on my iMac. Everything seems to run normally, except that when I attempt to modify the database in any way (I''m running sqlite), I get a weird error: "cannot start a transaction within a transaction"