andreagrandi Comments - Answer Overflow

andreagrandi

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

@kostas I wanted to thank you again for helping me a couple of weeks ago. I finally found the time to document the whole procedure I did and also mentioned your service https://www.andreagrandi.it/posts/self-hosting-analytics-at-zero-cost/ 🙂

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

So it supports connection limits as a parameter?

it seems so! They haven't updated the ticket but apparently the workaround...works. Personally I would have provided a nice default and added an env variable but it's ok. I only hope that 10 connections means the driver/library is automatically distributing the incoming requests among those connections... and not that I can only have 10 visitors at the same time (not that I regularly have 10 visitors at the same time... but when you post a link somwhere you usually get a lot of requests in few seconds and then they slow down.. in that case I would miss the events)

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

using ?connection_limit=10 (in my case) seems to mitigate the issue. I left the tab open on Real Time for 30 minutes, no errors

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

I found this https://github.com/umami-software/umami/issues/87#issuecomment-684861864 they seem to "blame" Prisma but they haven't effectively fixed it

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

well.. logs are quite clear: once you move away from the "Realtime" page, all the errors in Vercel logs disappear and the main dashboard shows data correctly

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

I think their "real time" code is so badly written that I would hit the limit even on a pro plan

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

not even an issue of too many user on the website because the app was only recording 2-3 visits

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

probably not an issue on your side (you rightly limit the number of connections), but rather on their side. It's absurd that a single user application uses all the 20 connections

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

I think Umami does, by default, some aggressive data polling. The "realtime" data stopped working. I checked Vercel logs and I see a lot of these errors:

⨯ PrismaClientUnknownRequestError: 
Invalid `prisma.website.findUnique()` invocation:


Error in connector: Error querying the database: ERROR: branch [umami:main]: concurrent connections limit exceeded

⨯ PrismaClientUnknownRequestError: 
Invalid `prisma.website.findUnique()` invocation:


Error in connector: Error querying the database: ERROR: branch [umami:main]: concurrent connections limit exceeded

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

in the end it seems that the umami-migrations (the shadow db) wasn't needed (it's currently empty). Should I delete it? Or it doesn't matter?

66 replies

XXata

•Created by andreagrandi on 7/19/2024 in #help

Database error: error parsing response from server: `S` field missing

it's up and running 🚀

66 replies

XXata