Application not accessible from multiple clients simultaneously

[vlbeaudoin]

TL;DR Accessing echo application from multiple clients at the same time results in the first one working, and all the other ones timing out. I use sqlite3 / echo / haproxy and a tls certificate on haproxy from letsencrypt.

Hello,

I have a web application deployed on docker using the code hosted at agecem/bottin, and i currently have an issue with using multiple connections.

Essentially, I use echo to host a simple API and webapp using a server command, which opens a sqlite3 database using my data package and starts the webserver using my bottin package (see RunServer() function at line 86).

My application works well enough for now, except when I try to access the application from multiple browsers at the same time. The first one works fine, but trying to access the application from additional browsers simultaneously results in all the other ones timing out.

I read that sqlite allows multiple connections, and echo logs report no error connecting. As a side note, I use HAProxy as a loadbalancer, maybe the issue comes from there?

I was wondering if anyone has had similar problems accessing a simple echo application from multiple client computers simultaneously?

Any help is appreciated, and thank you all in advance!

[aldas]

Echo uses standard library HTTP server so every request (connection) has their own coroutine - so there should not be any locks unless something block in your implemented part.
I suggest starting by commenting out DB access and returning some static response to see if there is a lock with db access.

Also you could use pprof to profile lock contention https://www.instana.com/blog/detecting-lock-contention-in-go/
https://pkg.go.dev/net/http/pprof#pkg-overview search for "block"

[vlbeaudoin]

Thank you for your thoughtful answer and sorry for not giving feedback. I still need to try your suggestions, and will be responding once that is done!

The part about echo using std http and coroutines is a lot of help, as that at least reduces the surface I need to check. Thank you!