npub1cuscsrz6efq99ptktk26x58v4yqy9y46ytp8xw4rjjwq0wlt6znst66789 (npub1cus…6789) corrections, DB_POOL is per-process so it simply needs to be the same (no less) than concurrency; it's also set there as you can seehttps://github.com/mastodon/mastodon/blob/main/dist/mastodon-sidekiq.service#L10 so remember to change both 25's.
Okay, thing is, if you're running four sidekiq processes with these settings, you need 100 connections to the database for those alone, but the default connection limit on the postgresql server is 100, and you still need more connections for the web and streaming processes. I would check for db connection errors and adjust accordingly.
What's the ExecStart= of each sidekiq service file?
lamp /
npub18c…4j7pp
2023-03-17 21:18:59
in reply to nevent1q…thqz
Author Public Key
npub18ctny2qrhjmwkptydzqfwmu5cjhwg5htvmjgjjcvu0xefq409sqqx4j7ppPublished at
2023-03-17 21:18:59Event JSON
{
"id": "f51266012f0a398e3489e32384e8303243b9f2554b691a29a5be4fbe73367901",
"pubkey": "3e17322803bcb6eb05646880976f94c4aee452eb66e4894b0ce3cd9482af2c00",
"created_at": 1679087939,
"kind": 1,
"tags": [
[
"p",
"c721880c5aca405285765d95a350eca9004292ba22c2733aa3949c07bbebd0a7",
"wss://relay.mostr.pub"
],
[
"p",
"d202ebed8f368129760dfcef6971250e4ba48abf279f518710186f1b61becd8c",
"wss://relay.mostr.pub"
],
[
"e",
"2c3f4c028164e4c7e0bab2bebc6c47656afa2dc958953aad1a7e5fa6676f5de6",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://berserker.town/users/lamp/statuses/110040707221361067"
]
],
"content": "#[0] corrections, DB_POOL is per-process so it simply needs to be the same (no less) than concurrency; it's also set there as you can seehttps://github.com/mastodon/mastodon/blob/main/dist/mastodon-sidekiq.service#L10 so remember to change both 25's.\n\nOkay, thing is, if you're running four sidekiq processes with these settings, you need 100 connections to the database for those alone, but the default connection limit on the postgresql server is 100, and you still need more connections for the web and streaming processes. I would check for db connection errors and adjust accordingly.\n\nWhat's the ExecStart= of each sidekiq service file?",
"sig": "760dd1e62a101c8995f1ea7eb463be8fa92c685e8258d5dc47806ad96ee2f16b57cbe8845a83d969e9953e150f6d6c2eba8abce33c1ccef9d227d8ea07f39f7d"
}