Hi guys. So far I'm quite often getting table locked and can't interact for minutes.
Can somebody explain me what's happening? I think it's the first query that's causing the issue
MariaDB processlist
MariaDB [(none)]> show processlist;
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 118178 | friendica | localhost | friendica | Query | 580 | Sending data | SELECT `id` FROM `item-uri` WHERE (`id` < 12098300 AND NOT EXISTS(SELECT `uri-id` FROM `post-user` W | 0.000 |
| 122966 | friendica | localhost | friendica | Query | 577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('tag:mastodonczech.cz,2025-04-05:objectId=24551028:obj | 0.000 |
| 123368 | friendica | localhost | friendica | Query | 96 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://cum.camp/users/shitpisscum';) | 0.000 |
| 123374 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | OPTIMIZE TABLE `post-delivery` | 0.000 |
| 123376 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | DELETE FROM `post-delivery` WHERE (`uri-id` = 12110298 AND `inbox-id` = 555134) | 0.000 |
| 123414 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 | 0.000 |
| 123416 | friendica | localhost | friendica | Query | 576 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |
| 123423 | friendica | localhost | friendica | Query | 577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 | 0.000 |
| 123430 | friendica | localhost | friendica | Query | 574 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.arch-linux.cz/users/Erebos/s | 0.000 |
| 123431 | friendica | localhost | friendica | Query | 572 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |
| 123432 | friendica | localhost | friendica | Query | 569 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/365tipu/status | 0.000 |
| 123435 | friendica | localhost | friendica | Query | 566 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha';) | 0.000 |
| 123441 | friendica | localhost | friendica | Query | 536 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |
| 123445 | friendica | localhost | friendica | Query | 532 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha';) | 0.000 |
| 123446 | friendica | localhost | friendica | Query | 531 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.social/users/FrancoisPrague/ | 0.000 |
| 123456 | friendica | localhost | friendica | Query | 528 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/Zvedatori/stat | 0.000 |
| 123457 | friendica | localhost | friendica | Query | 527 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea';) | 0.000 |
| 123463 | friendica | localhost | friendica | Query | 503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |
| 123464 | friendica | localhost | friendica | Query | 503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha';) | 0.000 |
| 123466 | friendica | localhost | friendica | Query | 498 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |
| 123468 | friendica | localhost | friendica | Query | 493 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://imaginair.es/users/ELeGarben';) | 0.000 |
| 123485 | friendica | localhost | friendica | Query | 462 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |
| 123486 | friendica | localhost | friendica | Query | 455 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.online/users/Psychonaut/stat | 0.000 |
| 123498 | friendica | localhost | friendica | Query | 451 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |
| 123509 | friendica | localhost | friendica | Query | 444 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha';) | 0.000 |
| 123510 | friendica | localhost | friendica | Query | 443 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |
| 123525 | friendica | localhost | friendica | Query | 420 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |
| 123532 | friendica | localhost | friendica | Query | 389 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990';, ' | 0.000 |
| 123540 | friendica | localhost | friendica | Query | 358 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990';, ' | 0.000 |
| 123541 | friendica | localhost | friendica | Query | 354 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |
| 123560 | friendica | localhost | friendica | Query | 326 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |
| 123561 | friendica | localhost | friendica | Query | 325 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |
| 123565 | friendica | localhost | friendica | Query | 314 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990';, ' | 0.000 |
| 123581 | friendica | localhost | friendica | Query | 289 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz';) | 0.000 |
| 123583 | friendica | localhost | friendica | Query | 285 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 | 0.000 |
| 123586 | friendica | localhost | friendica | Query | 275 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha';) | 0.000 |
| 123589 | friendica | localhost | friendica | Query | 258 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 | 0.000 |
| 123590 | friendica | localhost | friendica | Query | 255 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990';, ' | 0.000 |
| 123594 | friendica | localhost | friendica | Query | 233 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |
| 123597 | friendica | localhost | friendica | Query | 223 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz';) | 0.000 |
| 123603 | friendica | localhost | friendica | Query | 198 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |
| 123604 | friendica | localhost | friendica | Query | 190 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz';) | 0.000 |
| 123615 | friendica | localhost | friendica | Query | 133 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz';) | 0.000 |
| 123617 | friendica | localhost | friendica | Query | 126 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea';) | 0.000 |
| 123620 | friendica | localhost | friendica | Query | 104 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990';, ' | 0.000 |
| 123625 | friendica | localhost | friendica | Query | 82 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://noc.social/users/ThatAltair';) | 0.000 |
| 123627 | friendica | localhost | friendica | Query | 71 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |
| 123636 | friendica | localhost | friendica | Query | 43 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://schmaker.eu/objects/c83e3896-1167-f0c | 0.000 |
| 123642 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
Schmaker /
npub1h2…zuym5
2025-04-05 06:24:12
Author Public Key
npub1h2xu2vfleynwn5qwnn0feudydsg56ad3j50rnr0us4xcctwuzq2qmzuym5Seen on
wss://relay.mostr.pubPublished at
2025-04-05 06:24:12Event JSON
{
"id": "e97ddfbbc3b4f0a9e879a2cc3f952397416391e214856f0530c7c8851cb90d26",
"pubkey": "ba8dc5313fc926e9d00e9cde9cf1a46c114d75b1951e398dfc854d8c2ddc1014",
"created_at": 1743834252,
"kind": 1,
"tags": [
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"p",
"08e210217b9bf22ce53ebf1e27b5ed8dc9db28dc1d82f1f4575eee7b3a76743a",
"wss://relay.mostr.pub"
],
[
"proxy",
"https://schmaker.eu/objects/c83e3896-2267-f0cc-8c43-a63904964172",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.mostr.pub"
]
],
"content": "Hi guys. So far I'm quite often getting table locked and can't interact for minutes.\n\nCan somebody explain me what's happening? I think it's the first query that's causing the issue\n\nMariaDB processlist\nMariaDB [(none)]\u003e show processlist;\n+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+\n| Id | User | Host | db | Command | Time | State | Info | Progress |\n+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+\n| 118178 | friendica | localhost | friendica | Query | 580 | Sending data | SELECT `id` FROM `item-uri` WHERE (`id` \u003c 12098300 AND NOT EXISTS(SELECT `uri-id` FROM `post-user` W | 0.000 |\n| 122966 | friendica | localhost | friendica | Query | 577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('tag:mastodonczech.cz,2025-04-05:objectId=24551028:obj | 0.000 |\n| 123368 | friendica | localhost | friendica | Query | 96 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://cum.camp/users/shitpisscum') | 0.000 |\n| 123374 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | OPTIMIZE TABLE `post-delivery` | 0.000 |\n| 123376 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | DELETE FROM `post-delivery` WHERE (`uri-id` = 12110298 AND `inbox-id` = 555134) | 0.000 |\n| 123414 | friendica | localhost | friendica | Query | 578 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 | 0.000 |\n| 123416 | friendica | localhost | friendica | Query | 576 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |\n| 123423 | friendica | localhost | friendica | Query | 577 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 | 0.000 |\n| 123430 | friendica | localhost | friendica | Query | 574 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.arch-linux.cz/users/Erebos/s | 0.000 |\n| 123431 | friendica | localhost | friendica | Query | 572 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |\n| 123432 | friendica | localhost | friendica | Query | 569 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/365tipu/status | 0.000 |\n| 123435 | friendica | localhost | friendica | Query | 566 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha') | 0.000 |\n| 123441 | friendica | localhost | friendica | Query | 536 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |\n| 123445 | friendica | localhost | friendica | Query | 532 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha') | 0.000 |\n| 123446 | friendica | localhost | friendica | Query | 531 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.social/users/FrancoisPrague/ | 0.000 |\n| 123456 | friendica | localhost | friendica | Query | 528 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodonczech.cz/users/Zvedatori/stat | 0.000 |\n| 123457 | friendica | localhost | friendica | Query | 527 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea') | 0.000 |\n| 123463 | friendica | localhost | friendica | Query | 503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |\n| 123464 | friendica | localhost | friendica | Query | 503 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha') | 0.000 |\n| 123466 | friendica | localhost | friendica | Query | 498 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |\n| 123468 | friendica | localhost | friendica | Query | 493 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://imaginair.es/users/ELeGarben') | 0.000 |\n| 123485 | friendica | localhost | friendica | Query | 462 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |\n| 123486 | friendica | localhost | friendica | Query | 455 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.online/users/Psychonaut/stat | 0.000 |\n| 123498 | friendica | localhost | friendica | Query | 451 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |\n| 123509 | friendica | localhost | friendica | Query | 444 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha') | 0.000 |\n| 123510 | friendica | localhost | friendica | Query | 443 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |\n| 123525 | friendica | localhost | friendica | Query | 420 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |\n| 123532 | friendica | localhost | friendica | Query | 389 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' | 0.000 |\n| 123540 | friendica | localhost | friendica | Query | 358 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' | 0.000 |\n| 123541 | friendica | localhost | friendica | Query | 354 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |\n| 123560 | friendica | localhost | friendica | Query | 326 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mastodon.energy/users/Sustainable2050 | 0.000 |\n| 123561 | friendica | localhost | friendica | Query | 325 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |\n| 123565 | friendica | localhost | friendica | Query | 314 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' | 0.000 |\n| 123581 | friendica | localhost | friendica | Query | 289 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz') | 0.000 |\n| 123583 | friendica | localhost | friendica | Query | 285 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://societas.online/objects/ae8a63f0f4110 | 0.000 |\n| 123586 | friendica | localhost | friendica | Query | 275 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://mastodon.social/users/simaocunha') | 0.000 |\n| 123589 | friendica | localhost | friendica | Query | 258 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://diaspora.psyco.fr/objects/af4fc4f0f41 | 0.000 |\n| 123590 | friendica | localhost | friendica | Query | 255 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' | 0.000 |\n| 123594 | friendica | localhost | friendica | Query | 233 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://witter.cz/users/banterCZ/statuses/114 | 0.000 |\n| 123597 | friendica | localhost | friendica | Query | 223 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz') | 0.000 |\n| 123603 | friendica | localhost | friendica | Query | 198 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |\n| 123604 | friendica | localhost | friendica | Query | 190 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz') | 0.000 |\n| 123615 | friendica | localhost | friendica | Query | 133 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://baraag.net/users/fartnutzz') | 0.000 |\n| 123617 | friendica | localhost | friendica | Query | 126 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://qoto.org/users/justcbdstorea') | 0.000 |\n| 123620 | friendica | localhost | friendica | Query | 104 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://mamutovo.cz/users/vsa#likes/78990', ' | 0.000 |\n| 123625 | friendica | localhost | friendica | Query | 82 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`) VALUES ('https://noc.social/users/ThatAltair') | 0.000 |\n| 123627 | friendica | localhost | friendica | Query | 71 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://lemmy.world/activities/like/11d3d6ba- | 0.000 |\n| 123636 | friendica | localhost | friendica | Query | 43 | Waiting for table metadata lock | INSERT IGNORE INTO `item-uri` (`uri`, `guid`) VALUES ('https://schmaker.eu/objects/c83e3896-1167-f0c | 0.000 |\n| 123642 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |\n+--------+-----------+-----------+-----------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+",
"sig": "d7470dfae382831631d2fb146db7aa53092780e98882ffb9a4dad47677c3a7b12ceccd04b4381a101868113ba1f68a97db1893e980c6f6ec45b4e0bbce4aba66"
}