pull down to refresh

0 sats \ 5 replies \ @OneOneSeven OP 9 Jan \ on: Charts and Numbers is no more... meta charts_and_maps

https://media.tenor.com/eDjkZ-51FzsAAAAM/well-this-is.gif

@k00b I getting some errors when trying to change territory names:

Invalid prisma.sub.update() invocation: Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(PostgresError { code: "40P01", message: "deadlock detected", severity: "ERROR", detail: Some("Process 1385 waits for ShareLock on transaction 3982037312; blocked by process 22193.\nProcess 22193 waits for ShareLock on transaction 3982037086; blocked by process 1385."), column: None, hint: Some("See server log for query details.") }), transient: false })

Invalid prisma.sub.findUnique() invocation: Timed out fetching a new connection from the connection pool. More info: http://pris.ly/d/connection-pool (Current connection pool timeout: 10, connection limit: 2)

write
preview
42 sats \ 4 replies \ @k00b 9 Jan

Ah! Hmmm I have SNL, but I’ll troubleshoot after and let you know ASAP

reply
21 sats \ 3 replies \ @OneOneSeven OP 9 Jan

Thank you sir

reply
138 sats \ 0 replies \ @k00b 10 Jan

I found the issue. I'll ping you when I submit what should hopefully be a fix.

reply
68 sats \ 1 reply \ @k00b 10 Jan

I changed it myself in the process of figuring out what was going on. Hopefully ~charts_and_maps is what you intended?

The root cause is that the name update conflicts with the periodic (and frequent) aggregates we compute. I had to disable those aggregates to prevent the error, because the real fix is going to be invasive and I didn't want to leave you hanging.

I'll try to get the real fix in by the end of the weekend.

reply
0 sats \ 0 replies \ @OneOneSeven OP 10 Jan

Yes, perfect, thank you!!

reply