Alex on Nostr: Dude, what the fuck. This query is unacceptable. 🤣 This is why we need database ...
Dude, what the fuck. This query is unacceptable. 🤣 This is why we need database timeouts on Nostr relays.
This is so fucking epic. #Ditto with JSON logging to Loki and Grafana. I can get a list of all SQL queries from all Ditto servers I run in the last 30 minutes that took > 1 second, complete with parameters.
Published at
2025-01-28 18:28:37Event JSON
{
"id": "07950e29b5c37e36408fa1eaf2b4745ba95cb82e2788a8220528b4a3a46026bf",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1738088917,
"kind": 1,
"tags": [
[
"q",
"71855ab4f61c463c28b692915d1d6fc5a962b86c852f98faaa8335192353ebc8",
"wss://gleasonator.dev/relay",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"imeta",
"url https://image.nostr.build/78e58cc9d211436992b0c6db965d433887ff82807f513f139afe30ade6eae9ed.png",
"m image/png",
"x 6f6348b7261b43b17cdd81cb32e21d086c4b8f4c000e0b2aaf8aea2dc0f20b3a",
"ox 78e58cc9d211436992b0c6db965d433887ff82807f513f139afe30ade6eae9ed",
"size 476167",
"dim 1623x941",
"blurhash L06[K[.9M{.9%Nj[ayj]IAayofWB"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"wss://gleasonator.dev/relay"
]
],
"content": "Dude, what the fuck. This query is unacceptable. 🤣 This is why we need database timeouts on Nostr relays.\n\nnostr:nevent1qvzqqqqqqypzqprpljlvcnpnw3pejvkkhrc3y6wvmd7vjuad0fg2ud3dky66gaxaqydhwumn8ghj7emvv4shxmmwv96x7u3wv3jhvtmjv4kxz7gqypcc2k457cwyv0pgk6ffzhgadlz6jc4cdjzjlx8642pn2xfr204us8wdtz2\n\nhttps://image.nostr.build/78e58cc9d211436992b0c6db965d433887ff82807f513f139afe30ade6eae9ed.png",
"sig": "e3ff2b7ce7dac4f08146557a7790bd1797b8827b251ae591669debaec7e6c28da9f96303ad4a5698668af74a9004826321337cfa3f970a670403e842690e7ed2"
}
