[Rails] Rails 3 app has strange behaviour with Mysql2 database

Hi,

I have developed a little web app with a sqlite3 database in
development environment. Now I switched over to mysql2 for production
environment. At a first look everthing looks good!

BUT, I have delayed_jobs that run methods in the background, where two
nested active records were compared with "if hash1 == hash2", then it
should just show whether they are the same or not. With mysql2 in
production, it shows randomly entries which should have changed, but
they didn't! What I found strange is that it is really random!!!

Again with sqlite3 in production or development it is working as
intended!!! I checked this in both environments, so that the issues
doesn't occur only in production mode. I checked it also with mysql2
in development environment, there I have the same issue that randomly
entries were shown that shoould have changed, but didn't in reality.

Finally I think it has something to do with the mysql2 database!!! Has
anybody an idea???

My database.yml looks like this:
# SQLite version 3.x
# gem install sqlite3
production:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000

# 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: sqlite3
database: db/test.sqlite3
pool: 5
timeout: 5000

development:
adapter: mysql2
encoding: utf8
database: patent_production
pool: 5
username: xxx
password: xxx
host: localhost

I really hope someone can help, because I am searching now for over
two days and don't find a solution. I can of course deploy on a
sqlite3 db, but I read recommendation to do it rather on mysql.

Cheers,
Sebastian

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.