Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

All connections are blacklisted -> No error details #221

Open
Yaroslav-F opened this issue Oct 30, 2018 · 2 comments
Open

All connections are blacklisted -> No error details #221

Yaroslav-F opened this issue Oct 30, 2018 · 2 comments

Comments

@Yaroslav-F
Copy link

Yaroslav-F commented Oct 30, 2018

Morning!

Very quick question/issue here.
I've tried switching from mysql to makara adapter in database.yml and all seemed to work fine at first.

production:
  database: *****
  pool: **
  username: ****
  adapter: mysql2_makara
  makara:
    id: prod
    sticky: true
    connections:
      - role: master
        host: production.master.rds.com
        name: MasterNode
      - role: slave
        host: production.master.rds.com
        name: ReadReplica

Please note that I'm using same host for master and slave for now until I can get read replica up and running.

Then I noticed that for operations on some objects, where object is locked (selected for update) for longer period of time - makara blacklists all connections and raises [Makara/master] All connections are blacklisted -> No error details error.

So far I dealt with it by adding disable_blacklist: true flag to my master connection portion of config. However I'd like to understand why connections are getting blacklisted, is that because of the delay caused by locking the object? Or by the fact that both master & slave are pointing to the same host?

Could someone clear things out for me please?
Many Thanks!

@aniliyidogan
Copy link

Hi,
I am experiencing the same problem, could a different situation be identified about the solution?

@psahni
Copy link

psahni commented Jan 10, 2024

@Yaroslav-F @aniliyidogan
Any resolution on the issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants