[Rails] Caching unexpected behaviour

Hi

I have this RoR (2.3.16) app that has a simple agenda tool. Each customer has their own individual database, and I have one central database with login, passwd and the customer database name.

Something like this:

- main_database:

  - users_table:

    - login_field

    - passwd_field

    - database_name_field

- customer_db_1:

 - tables ....

- customer_db_2:

 - tables ...

So, after user authentication, I set the correspondent database connection according each customer.

The problem is:

Customer 1 sometimes see records from customer 2, even being on different databases.

I'm totally lost here... I just suspect that this could be a database connection cache issue, since the SQL query is the same for every customer (ie.: select * from agendas;) but the connection string is different for each one.

Most of the time everything runs ok.. but some customers are getting this strange behaviour.

Any idea of what could be happening?

Current env:

Passenger: 4.0.21

Apache/2.2.22 (Ubuntu)

ruby 1.8.7 (2012-02-08 patchlevel 358)

Thank you very much in advance for any help!!

Best regards

Paulo

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/ff60e3ef-df0f-4150-b5fc-33c40deea136%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.