--- Log opened mar dic 20 00:00:09 2022 --- Log closed mar dic 20 01:00:56 2022 --- Log opened mar dic 20 01:01:09 2022 01:01 -!- Irssi: #friendica: Total of 11 nicks [0 ops, 0 halfops, 0 voices, 11 normal] 01:01 -!- Irssi: Join to #friendica was synced in 17 secs 02:54 < fikabot> 💬 Release notes from friendica: 2022.12 ( https://github.com/friendica/friendica/releases/tag/2022.12 ) 02:59 < fikabot> 💬 Release notes from friendica-addons: Merge pull request #1338 from brockhaus/2022.12-rc ( https://github.com/friendica/friendica-addons/releases/tag/2022.12 ) 03:15 < fikabot> 💬 friendica: Friendica 2022.12 released ( https://friendi.ca/2022/12/20/friendica-2022-12-released/ ) 03:20 < fikabot> 💬 Comments for friendica: Comment on Friendica 2022.06 released by Friendica 2022.12 released – friendica ( https://friendi.ca/2022/06/11/friendica-2022-06-released/#comment-364186 ) 07:53 < fikabot> 💬 Major fucking earthquake just fucking hit. Still going in and off. Main I've lasted for about a minute straight. 07:53 < fikabot> 💬 07:53 < fikabot> 💬 Everything broken, cabinet doors open, been shit everywhere. 07:53 < fikabot> 💬 07:54 < fikabot> 💬 No lights anywhere. Fuck, here cubes another one. 08:07 < fikabot> 💬 Close the shutters and get away from windows and glass panes!! 08:31 < fikabot> 💬 > <@bkil:grin.hu> Close the shutters and get away from windows and glass panes!! 08:31 < fikabot> 💬 08:31 < fikabot> 💬 Yeah we've been having aftershocks, mostly small but shakes the whole house. Moved my couch into the middle of the living room and sitting here in the dark. 08:31 < fikabot> 💬 08:31 < fikabot> 💬 6.4 magnitude about three miles south of me in Ferndale. 08:31 < fikabot> 💬 08:31 < fikabot> 💬 Totally cray cray. No lights anywhere in sight anywhere. I'm surprised there's cell service 08:32 < fikabot> 💬 Hope you have charged batteries on your devices and have an AM/FM radio around to learn about deadlines supplies. If you go without power for long, pumping station will also cease, so you might not have running water for long either. 08:38 < fikabot> 💬 I've got several gsllons of water jugs. A small two stroke generator that can charge devices, and gas has automatically cut off. Water is running though. 08:38 < fikabot> 💬 08:38 < fikabot> 💬 It's semi rural, a decent size size city shit two miles to the north (eureka, CA). 08:38 < fikabot> 💬 08:38 < fikabot> 💬 Just this very minute the liver radio station is just now going live (they pretape all their shows after 5pm around here. 08:38 < fikabot> 💬 08:39 < fikabot> 💬 They're saying lights out all over Humboldt county. 08:39 < fikabot> 💬 I'm literally right on the coast near there waters edge - no tsunami warnings they're saying at this time 09:48 < fikabot> 💬 Awesome on the release! 09:50 < fikabot> 💬 Oh, you have already installed it? 09:59 < fikabot> 💬 nope but am about to 09:59 < fikabot> 💬 I need many of the API upgrades to do my app development against a real server 09:59 < fikabot> 💬 I have thought about putting a dev test instance up that is always synced to the develop branch as well 09:59 < fikabot> 💬 but haven't gotten around to it 10:00 < fikabot> 💬 Just waiting for the system snapshot to complete before starting the install so I can roll back in case thing go wrong 10:43 < fikabot> 💬 As usual the adding keys part of the DB migration grinds everything to a halt lol 10:44 < fikabot> 💬 I know that takes a lot but I'm suprised that MySQL/MariaDb doesn't parallelize that to some extent. It must be I/O bound though because sometimes it is only using a fraction of 1 CPU 10:45 < fikabot> 💬 been working on it for half an hour now...anyone else see a similar effect? 10:47 < fikabot> 💬 Yeah write I/O bound for sure based on system graph 10:48 < fikabot> 💬 unfortunately since the upgrade started by the main friendica process the site doesn't work at all to present the "under maintenance" page so it just looks like a dead server 11:35 < simcop2387> i will probably have another update for the SAML addon to make it work with Model\User::getIdFromPasswordAuthenication() somehow. right now if you're using it you can't do anything that requires a password to authenticate again 11:53 < fikabot> 💬 looks like it didn't take that time...so running it again but htis time from CLI 11:54 < fikabot> 💬 it is the `ALTER IGNORE TABLE `post-content` ADD `quote-uri-id` int unsigned COMMENT ' 11:54 < fikabot> 💬 Id of the item-uri table that contains the quoted uri', ADD INDEX `quote-uri-id` (`quote-uri-id`), ADD FOREIGN KEY (`quote-uri-id`) REFERENCES `item-uri` (`id`) ON 11:54 < fikabot> 💬 UPDATE RESTRICT ON DELETE CASCADE` DB schema update that seems to be the big nut to crack 11:54 < fikabot> 💬 ```sql 11:54 < fikabot> 💬 ALTER IGNORE TABLE `post-content` ADD `quote-uri-id` int unsigned COMMENT ' 11:54 < fikabot> 💬 Id of the item-uri table that contains the quoted uri', ADD INDEX `quote-uri-id` (`quote-uri-id`), ADD FOREIGN KEY (`quote-uri-id`) REFERENCES `item-uri` (`id`) ON 11:54 < fikabot> 💬 UPDATE RESTRICT ON DELETE CASCADE 11:54 < fikabot> 💬 ``` 11:54 < fikabot> 💬 it seems to be the below command that is the big nut to crack 11:55 < fikabot> 💬 it looked like it completed about 45 minutes later but running the dry run of it on the CLI it still had that command and the subsequent ones to do just like before 12:34 < fikabot> 💬 This is timing out and doesn't go 12:34 < fikabot> 💬 but worse now getting weird friendica errors 12:34 < fikabot> 💬 ``` 12:34 < fikabot> 💬 2022-12-20T15:30:28Z index [ERROR]: DB Error {"code":1146,"error":"Table 'friendicadb.post-user-view' doesn't exist","callstack":"Item::insert, Diaspora::receiveStatusMessage, Diaspora::dispatch, Diaspora::dispatchPublic, Diaspora::storeByGuid, Diaspora::parentItem, Diaspora::receiveComment, Diaspora::dispatch","params":"SELECT `uri-id` FROM `post-user-view` WHERE (`uri-id` = 762 12:34 < fikabot> 💬 5886 AND `uid` = 0) LIMIT 1"} - {"file":"Database.php","line":703,"function":"p","uid":"45ff82","process_id":31563} 12:34 < fikabot> 💬 12:34 < fikabot> 💬 ``` 12:36 < fikabot> 💬 I don't see that view in the list of views any longer either 12:36 < fikabot> 💬 was that expected? 12:40 < fikabot> 💬 going to try it again. but is there a way to increase the timeout? 12:40 < fikabot> 💬 heluecht: you see this upgrading any production instances? 12:43 < fikabot> 💬 When you execute the update via command line, the view will be generated 12:45 < fikabot> 💬 it's not 12:45 < fikabot> 💬 the only command that was left after it bailed the other time is the one that is timing out 12:45 < fikabot> 💬 I'm trying it again 12:45 < fikabot> 💬 the error log from the first CLI execution: 12:45 < fikabot> 💬 ```bash 12:45 < fikabot> 💬 root@mysocialportal-friendica:/var/www/html# bin/console dbstructure update 12:46 < fikabot> 💬 ALTER IGNORE TABLE `post-content` ADD `quote-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the quoted uri', ADD INDEX `quote-uri-id` (`quote-uri-id`), ADD FOREIGN KEY (`quote-uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE; 12:46 < fikabot> 💬 12:46 < fikabot> 💬 Error 1205 occurred during database update: 12:46 < fikabot> 💬 Lock wait timeout exceeded; try restarting transaction 12:46 < fikabot> 💬 ``` 12:46 < fikabot> 💬 ```bash 12:46 < fikabot> 💬 # bin/console dbstructure update 12:46 < fikabot> 💬 ALTER IGNORE TABLE `post-content` ADD `quote-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the quoted uri', ADD INDEX `quote-uri-id` (`quote-uri-id`), ADD FOREIGN KEY (`quote-uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE; 12:46 < fikabot> 💬 12:46 < fikabot> 💬 Error 1205 occurred during database update: 12:47 < fikabot> 💬 Lock wait timeout exceeded; try restarting transaction 12:47 < fikabot> 💬 ``` 14:13 < fikabot> 💬 Ok increased the `innodb_lock_wait_timeout` from 50 seconds to 5 minutes. 14:13 < fikabot> 💬 let's see if that fixes it and the views are created afterward 15:04 < fikabot> 💬 ok that seemed to work 16:12 < fikabot> 💬 In case others doing upgrades fall into the same timeout issue I made a post in the forums: 16:13 < fikabot> 💬 https://friendica.myportal.social/display/e65e1095-2163-a204-ece0-940257078026 --- Log closed mar dic 20 16:47:58 2022 --- Log opened mar dic 20 16:48:08 2022 16:48 -!- Irssi: #friendica: Total of 11 nicks [0 ops, 0 halfops, 0 voices, 11 normal] 16:48 -!- Irssi: Join to #friendica was synced in 16 secs 19:38 < fikabot> 💬 > <@hank:myportal.social> In case others doing upgrades fall into the same timeout issue I made a post in the forums: 19:38 < fikabot> 💬 19:38 < fikabot> 💬 Weird, mine seems to be crashing now too, but can access the timeline through Tusky. I'll give that a try, thanks! 19:39 < fikabot> 💬 That is surprising. The API didn't work either because the table was missing a column before that goes 19:39 < fikabot> 💬 what does the dbmigrate dryrun command show as having left to do? 19:53 < fikabot> 💬 do you mean in bin/console? I only see dbstructure command 19:53 < fikabot> 💬 yep that one 19:54 < fikabot> 💬 it has a "dryrun" mode that shows you what it will need to do to properly update the schema for the current release 19:54 < fikabot> 💬 Shows nothing 19:54 < fikabot> 💬 then all of them got applied supposedly 19:56 < fikabot> 💬 Not the biggest lost yet...still can see posts at least, but when I have some time over the holidays will probably have to dig more. 19:56 < fikabot> 💬 nextcloud which uses Mariadb is running fine 19:56 < fikabot> 💬 not being able to see posts seems like a big deal lol 19:56 < fikabot> 💬 check your friendica logs for errors 19:57 < fikabot> 💬 Yeah I did briefly...nothing jumped out immediately but can recheck 20:12 < fikabot> 💬 Seeing this, could be related? 20:12 < fikabot> 💬 ``` 20:12 < fikabot> 💬 2022-12-20T22:49:00Z worker [WARNING]: Update lock could not be acquired [] - {"file":"Update.php","line":221,"function":"run","uid":"cd9a19","process_id":1155325} 20:12 < fikabot> 💬 2022-12-20T22:49:00Z worker [WARNING]: Process execution failed, quitting. {"entry":{"id":35342263,"parameter":"[]","priority":10,"created":"2022-12-20 22:48:59","pid":1155325,"executed":"2022-12-20 22:49:00","done":0,"next_try":"0001-01-01 00:00:00","retrial":0,"command":"DBUpdate"}} - {"file":"Worker.php","line":122,"function":"processQueue","uid":"cd9a19","process_id":1155325} 20:12 < fikabot> 💬 2022-12-20T22:49:00Z worker [WARNING]: Update lock could not be acquired [] - {"file":"Update.php","line":221,"function":"run","uid":"6ce147","process_id":1155339} 20:13 < fikabot> 💬 20:13 < fikabot> 💬 ``` 20:13 < fikabot> 💬 those are worker errors. it shouldn't be causing the timeline not to render 20:13 < fikabot> 💬 I can't remember is ERROR or WARNING higher criticality? 20:16 < fikabot> 💬 Error is higher 20:17 < fikabot> 💬 These are the last couple: 20:17 < fikabot> 💬 20:17 < fikabot> 💬 ``` 20:17 < fikabot> 💬 2022-12-20T23:14:53Z index [ERROR]: Uncaught Exception TypeError: "Argument 4 passed to Friendica\Content\Text\BBCode::getShareOpeningTag() must be of the type string, null given, called in /home/jbc/friendica/src/Content/Item.php on line 643" at /home/jbc/friendica/src/Content/Text/BBCode.php line 2512 {"exception":"TypeError: Argument 4 passed to Friendica\\Content\\Text\\BBCod 20:17 < fikabot> 💬 e::getShareOpeningTag() must be of the type string, null given, called in /home/jbc/friendica/src/Content/Item.php on line 643 and defined in /home/jbc/friendica/src/Content/Text/BBCode.php:2512\nStack trace:\n#0 /home/jbc/friendica/src/Content/Item.php(643): Friendica\\Content\\Text\\BBCode::getShareOpeningTag()\n#1 /home/jbc/friendica/src/Model/Item.php(3052): Friendica\\Conten 20:17 < fikabot> 💬 t\\Item->createSharedBlockByArray()\n#2 /home/jbc/friendica/src/Object/Post.php(397): Friendica\\Model\\Item::prepareBody()\n#3 /home/jbc/friendica/src/Object/Thread.php(208): Friendica\\Object\\Post->getTemplateData()\n#4 /home/jbc/friendica/src/Content/Conversation.php(768): Friendica\\Object\\Thread->getTemplateData()\n#5 /home/jbc/friendica/src/Module/Profile/Status.php(243): 20:17 < fikabot> 💬 Friendica\\Content\\Conversation->create()\n#6 /home/jbc/friendica/src/Module/Profile/Index.php(93): Friendica\\Module\\Profile\\Status->content()\n#7 /home/jbc/friendica/src/BaseModule.php(244): Friendica\\Module\\Profile\\Index->content()\n#8 /home/jbc/friendica/src/App.php(746): Friendica\\BaseModule->run()\n#9 /home/jbc/friendica/index.php(44): Friendica\\App->runFrontend()\ 20:18 < fikabot> 💬 n#10 {main}"} - {"file":null,"line":null,"function":null,"uid":"af6894","process_id":1180721} 20:18 < fikabot> 💬 2022-12-20T23:16:19Z index [ERROR]: Uncaught Exception TypeError: "Argument 4 passed to Friendica\Content\Text\BBCode::getShareOpeningTag() must be of the type string, null given, called in /home/jbc/friendica/src/Content/Item.php on line 643" at /home/jbc/friendica/src/Content/Text/BBCode.php line 2512 {"exception":"TypeError: Argument 4 passed to Friendica\\Content\\Text\\BBCod 20:18 < fikabot> 💬 e::getShareOpeningTag() must be of the type string, null given, called in /home/jbc/friendica/src/Content/Item.php on line 643 and defined in /home/jbc/friendica/src/Content/Text/BBCode.php:2512\nStack trace:\n#0 /home/jbc/friendica/src/Content/Item.php(643): Friendica\\Content\\Text\\BBCode::getShareOpeningTag()\n#1 /home/jbc/friendica/src/Model/Item.php(3052): Friendica\\Conten 20:18 < fikabot> 💬 t\\Item->createSharedBlockByArray()\n#2 /home/jbc/friendica/src/Object/Post.php(397): Friendica\\Model\\Item::prepareBody()\n#3 /home/jbc/friendica/src/Object/Thread.php(208): Friendica\\Object\\Post->getTemplateData()\n#4 /home/jbc/friendica/src/Content/Conversation.php(768): Friendica\\Object\\Thread->getTemplateData()\n#5 /home/jbc/friendica/src/Module/Profile/Status.php(243): 20:18 < fikabot> 💬 Friendica\\Content\\Conversation->create()\n#6 /home/jbc/friendica/src/Module/Profile/Index.php(93): Friendica\\Module\\Profile\\Status->content()\n#7 /home/jbc/friendica/src/BaseModule.php(244): Friendica\\Module\\Profile\\Index->content()\n#8 /home/jbc/friendica/src/App.php(746): Friendica\\BaseModule->run()\n#9 /home/jbc/friendica/index.php(44): Friendica\\App->runFrontend()\ 20:18 < fikabot> 💬 n#10 {main}"} - {"file":null,"line":null,"function":null,"uid":"2ec0eb","process_id":1183075} 20:18 < fikabot> 💬 ``` 20:18 < fikabot> 💬 hmm 20:18 < fikabot> 💬 Seems like all the latest error level stuff is like that 20:18 < fikabot> 💬 could be causing that since on index 20:19 < fikabot> 💬 how do you do your upgrade? via git? 20:19 < fikabot> 💬 yeah 20:19 < fikabot> 💬 did you run the compose after doing the git pull? 20:19 < fikabot> 💬 bin/compose yadda yadda 20:20 < fikabot> 💬 Here's my simple update script: 20:20 < fikabot> 💬 ``` 20:20 < fikabot> 💬 Here's my simple update script: 20:20 < fikabot> 💬 20:20 < fikabot> 💬 ``` 20:20 < fikabot> 💬 cd /home/jbc/friendica 20:20 < fikabot> 💬 git pull 20:20 < fikabot> 💬 bin/composer.phar install 20:21 < fikabot> 💬 20:21 < fikabot> 💬 cd /home/jbc/friendica/addon 20:21 < fikabot> 💬 git pull 20:21 < fikabot> 💬 20:21 < fikabot> 💬 ``` 20:21 < fikabot> 💬 Accidentally entered 20:21 < fikabot> 💬 yeah that should do it 20:21 < fikabot> 💬 if you go into `/home/jbc/friendica` and do `git status` what does it return? 20:21 < fikabot> 💬 Ahh, maybe this is something: 20:21 < fikabot> 💬 ``` 20:22 < fikabot> 💬 fatal: detected dubious ownership in repository at '/home/jbc/friendica' 20:22 < fikabot> 💬 To add an exception for this directory, call: 20:22 < fikabot> 💬 20:22 < fikabot> 💬 git config --global --add safe.directory /home/jbc/friendica 20:22 < fikabot> 💬 ``` 20:23 < fikabot> 💬 do you run the script as the same user you just executed that command? 20:24 < fikabot> 💬 if you do an ls -l you can see which user owns the files in the directory 20:24 < fikabot> 💬 I think I set it as www-data 20:24 < fikabot> 💬 ah then do `sudo -u www-data git status` 20:25 < fikabot> 💬 ``` 20:25 < fikabot> 💬 On branch develop 20:25 < fikabot> 💬 Your branch is up to date with 'origin/develop'. 20:25 < fikabot> 💬 20:25 < fikabot> 💬 Untracked files: 20:25 < fikabot> 💬 (use "git add ..." to include in what will be committed) 20:25 < fikabot> 💬 config/local.config.php.old 20:25 < fikabot> 💬 20:26 < fikabot> 💬 nothing added to commit but untracked files present (use "git add" to track) 20:26 < fikabot> 💬 20:26 < fikabot> 💬 ``` 20:26 < fikabot> 💬 hmm that looks okay too then :( 20:26 < fikabot> 💬 In nginx access logs I saw some issue with upstream to php7.4. May check and see if something went wonky with that 20:26 < fikabot> 💬 Like I said on Tusky I'm getting all the posts, so something with Friendica's front end not liking something with php7.4? 20:27 < fikabot> 💬 By the way, how is that flutter app coming with regards to a browser edition? 😅 20:27 < fikabot> 💬 Well the browser edition will come along for free actually 20:27 < fikabot> 💬 And the app is going wonderfully 20:28 < fikabot> 💬 Still very raw and I have to do some proper theming but... 20:28 < fikabot> 💬 I guess I'll also try on another computer tonight. Only tried on my laptop and phone 20:28 < fikabot> file ima_ed0d683.png too big to download (1080832 > allowed size: 1000000) 20:28 < fikabot> 💬 ima_ed0d683.png 20:29 < fikabot> 💬 Wow that looks pretty good already! 20:29 < fikabot> 💬 But to your point, if the error is in the page rendering due to the BBCode thing then it very well could be that the Web UI is broken but the API is working 20:30 < fikabot> 💬 I think it looks rough. I'm glad you think otherwise :) 20:30 < fikabot> 💬 Well, we are our own worst critics. 😁 20:31 < fikabot> 💬 I need to figure out how to tone down the icons a bit 20:31 < fikabot> 💬 I am very impressed with low bandwidth performance 20:32 < fikabot> 💬 even though I haven't gotten to that part of the optimization 20:32 < fikabot> 💬 Yeah, seems like Flutter is great for lazy loading stuff 20:32 < fikabot> 💬 Like I am able to load timelines, etc. with one bar of 5Ge 20:32 < fikabot> 💬 Which would help 20:32 < fikabot> 💬 And I can load posts with a lot more comments than I can in the UI but it is still slow since i haven't implemented paging of comments yet 20:33 < fikabot> 💬 Does that translate to less server load too? 20:33 < fikabot> 💬 Battery usage has been surprisingly good too, from some anecdotal data anyway 20:33 < fikabot> 💬 Oh yeah way less server load 20:33 < fikabot> 💬 Sweet! 20:33 < fikabot> 💬 No pressure, but but as my Gpa would say, hurry up. 😉 20:34 < fikabot> 💬 haha 20:34 < fikabot> 💬 What is a Gpa? 20:34 < fikabot> 💬 grandpa? 20:34 < fikabot> 💬 Grandpa yep 20:34 < fikabot> 💬 Always with a nod and a wink 20:34 < fikabot> 💬 Biggest feature I need to implement is image upload 20:34 < fikabot> 💬 Then I may start doing alpha testers 20:35 < fikabot> 💬 It is still very much not feature complete and not very informative when things go south but it is alpha 20:35 < fikabot> 💬 Assuming my page can load soon to add apps, would love to help kick the tires! 20:35 < fikabot> 💬 so comes with the territory 20:35 < fikabot> 💬 Well I'm actually just using direct username/passwords not OAuth right now too 20:35 < fikabot> 💬 so don't even need the "apps" thing 20:36 < fikabot> 💬 Ah, even better, at least for me! 20:36 < fikabot> 💬 I do want to migrate it to Oauth as an option sooner rather than later though 20:36 < fikabot> 💬 Yeah that's probably more secure long term too 20:36 < fikabot> 💬 for sure --- Log closed mié dic 21 00:00:11 2022