!Friendica Support
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
in reply to Schmaker • •reshared this
Věčný Stopař Kosmírem a Archos reshared this.
Archos
in reply to Schmaker • • •Jaroslav Svoboda
in reply to Archos • • •Radomír Žemlička
in reply to Jaroslav Svoboda • • •Odhalení: České spojky Íránu a Ruska? - Spiknutí #116
YouTubeSchmaker
in reply to Radomír Žemlička • •Jo tohle video. To jsem viděl, ale bez zdrojů je to na úrovni "zlí zednáři a anglosasové vám chtěj ukrást děti a naočkovat je Astrou"
Bohužel
Smoon
in reply to Schmaker • • •Tak bez zdrojů je i ta petice na úrovni petice za odhalení mimozemského původu Elvise Presleyho. 🤷♂️
youtube.com/watch?v=qSZe-DM_o6… 😆
@archos @multi_flexi @Razemix
Elvis is not dead, he just went home ! (Men In Black, 1997)
YouTubeRadomír Žemlička
in reply to Smoon • • •@smoon @archos @multi_flexi Tvrdí, že je nemohl zveřejnit. Těžko říct. 🤷♂️ fed.brid.gy/r/bsky.app/profile…
Patrik Kořenář
2025-04-03 15:55:43
Schmaker
in reply to Smoon • •Tak se odtajní, že není co odtajnit. Ale to je nepravděpodobný
Martin Kostera
in reply to Jaroslav Svoboda • • •@Jaroslav Svoboda Odhalení: České spojky Íránu a Ruska? - Spiknutí #116
Odhalení: České spojky Íránu a Ruska? - Spiknutí #116
YouTubeSchmaker
in reply to Archos • •Taky nevim, jaký video myslíš, ale ta petice celkem přibejvá na to, že je 8 ráno.
Já to prvně postřehl u Otta, tak jsem to trochu natáhl kvůli vyhledávatelnosti, protože to považuju za důležitý - velká část lidí plánuje bezpečnostní riziko volit
FoxVK
in reply to Schmaker • • •Dost možná by to podepsali i někteří dezoláti.
Takto to vypadá jako bič na konkrétní strany.
Petr Tesařík
in reply to FoxVK • • •Proč asi Britové v roce 1940 obětovali Coventry?
muž s klapkami na očích likes this.
Josef Zettl alias Princezna
in reply to Schmaker • • •Schmaker
in reply to Josef Zettl alias Princezna • •Schmaker
Unknown parent • •Lucinek
in reply to Schmaker • • •Schmaker
in reply to Lucinek • •Lucinek reshared this.
Martin Bodlák 💙💛
in reply to Schmaker • • •Schmaker likes this.
Schmaker
in reply to Martin Bodlák 💙💛 • •Martin Bodlák 💙💛
in reply to Schmaker • • •Schmaker
in reply to Martin Bodlák 💙💛 • •Martin Bodlák 💙💛
in reply to Schmaker • • •Schmaker
in reply to Martin Bodlák 💙💛 • •Martin Bodlák 💙💛
in reply to Schmaker • • •Schmaker
in reply to Martin Bodlák 💙💛 • •Ano, motoristi jsou Klausova úderka, ale jejich voliči budou různorodý
A ano - bohužel volební právo je v podstatě nepodmíněný 😀
Schmaker
Unknown parent • •