estevammr

estevammr

Hi everybody,

I’m trying to unsuccessfully change the connection timeout using the Mariex lib.

[error] Mariaex.Protocol (pid <0.268.0>) disconnected: ** (DBConnection.ConnectionError) client pid <0.266.0> timed out because it checked out the connection for more than 5000ms

I’m using phoenix and performing a heavy query on a mysql database. Anyone know how to change this using phoenix ?

Thank you all

Showing Posts 1 to 4

voughtdq

voughtdq

Try playing with the timeout options:

execute(conn, query, params, pool_timeout: 60_000, timeout: 60_000)

estevammr

estevammr OP

I’m doing it this way, and returned the error below :frowning:

{:ok, p} = Mariaex.start_link(username: "username", database: "database", password: "password", hostname: "hostname")

Mariaex.execute(p, "query", [], pool_timeout: 60_000, timeout: 60_000)

** (FunctionClauseError) no function clause matching in Mariaex.execute/4
    (mariaex) lib/mariaex.ex:239: Mariaex.execute(#PID<0.268.0>, "query", [], [pool_timeout: 60000, timeout: 60000])

And before with Mariex.query gave this problem

[error] Mariaex.Protocol (#PID<0.268.0>) disconnected: ** (Mariaex.Error) [tcp] `recv` failed with: :timeout
{:error,
 %Mariaex.Error{action: "recv", connection_id: #PID<0.268.0>, mariadb: nil,
  message: nil, reason: :timeout, tag: :tcp}}

Thanks for the answer @voughtdq

estevammr

estevammr OP

I was doing the iex. When I did it right on the phoenix it worked out the timeout.

Thank you all

estevammr

estevammr OP

@AstonJ , I tried editing Mariex for Mariaex in the post and the tag I created but I could not. Can you adjust to be correct?

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
ryanwinchester
apply_graft/2 doesn’t rewrite an add_many sub-workflow’s deps on an add step. Grafted jobs cancel with “upstream job was deleted” Version...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge &amp; Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews