jamdb_sybase connection pools are connecting to master database instead of connecting to database specified, after the database restart

[vasumur]

Hi

Today we had an issue where the connections pools are connecting to master database instead of the ones that is specified by database: option in the connection setting.

Only restarting the application we were able to resolve this issue. Appreciate if you could look into it and provide any workaround to recover from the same. This happened when the database was restarted.

config :app, App.Repo
  level: :info,
  adapter: Ecto.Adapters.Jamdb.Sybase,
  username: "*****",
  password: "*****",
  hostname: "prd_hostname",
  database: "DW",
  port: 5900,
  timeout: :timer.minutes(10),
  pool_size: 2,
  idle_interval: :timer.seconds(10),
  parameters: [autocommit: 1, fetch: 50, read_timeout: 10000]

[vstavskyi]

I can't reproduce your error, sorry.

Try add query select db_id() in checkout or ping in jamdb_sybase.ex

Like that

case query(s, 'select db_id()') do
  {:ok, %{num_rows: 1, rows: [[1]]} ->  {:disconnect, error!(err), s}
  {:ok, _} -> {:ok, s}
  {:error, err} ->  {:disconnect, error!(err), s}
end

[vasumur]

Agree it is a hard to reproduce one.
Will give your suggestion a try and let you know. Thanks