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 4 to 1

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?

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

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

voughtdq

voughtdq

Try playing with the timeout options:

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

— 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
kpanic
Hi everyone, I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding. I sta...
New
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
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
asweet-confluent
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
apz
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New

Other Trending Topics Top

JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
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
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
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
webofbits
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself. My main conc...
#ai
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews