●● IRC: #boycottnovell @ Techrights IRC Network: Friday, August 19, 2022 ●● ● Aug 19 [00:05] *britney has quit (Ping timeout: 2m30s) [00:06] *britney (~britney@muarsy2vret2q.irc) has joined #boycottnovell ● Aug 19 [01:33] *britney has quit (Ping timeout: 2m30s) [01:50] *britney (~britney@muarsy2vret2q.irc) has joined #boycottnovell ● Aug 19 [04:46] *Despatche (~desp@u3xy9z2ifjzci.irc) has joined #boycottnovell [04:51] *britney has quit (You are no longer authorized to be on this server) [04:51] *britney_ (~britney@muarsy2vret2q.irc) has joined #boycottnovell ● Aug 19 [05:26] *psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovell [05:26] *psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovell ● Aug 19 [07:13] *Techrights-sec has quit (*.net *.split) [07:13] *rianne_ has quit (*.net *.split) [07:15] *rianne_ (~rianne@freenode-vjf.peq.k31cok.IP) has joined #boycottnovell [07:15] *Techrights-sec (~quassel@freenode-l6u3hi.am6e.nqgd.t29qgt.IP) has joined #boycottnovell [07:15] *208AKWQN3 (~rianne@freenode-vjf.peq.k31cok.IP) has joined #boycottnovell [07:16] *208AKWQN3 has quit (Ping timeout: 120 seconds) [07:19] schestowitz-TR2 gm [07:19] *DaemonFC has quit (Quit: Leaving) [07:19] Techrights-sec gm [07:19] Techrights-sec the updated posts now percolate to the top of any feed list they may be in [07:19] Techrights-sec (I think) [07:20] schestowitz-TR2 thanks, last night I noticed that the android leftovers rianne added while you posted the test nodes always showed asd previous of new nodes, until this morning [07:36] schestowitz-TR2 back, sorry, was 'optimising' rianne's underpowered PC [07:36] schestowitz-TR2 I wasn't even going to mention the 'bug' [07:36] schestowitz-TR2 I assume it's to do with the timing that page was added [07:36] schestowitz-TR2 and it's already 'resolved' [07:36] schestowitz-TR2 btw, should we configure a backup procedure? I'll turn off backups for "old" soon, no point to them anymore [07:36] schestowitz-TR2 I did run a full DB check before finalising the read-only state [07:38] Techrights-sec np it's still there, just behind the updates [07:38] Techrights-sec thanks for covering the difficult topics in TR posts and the high speed in TM [07:38] Techrights-sec The SQL queries for that script mark the updated records and then once the [07:38] Techrights-sec records are chosen, they are resorted to take their update status into account [07:38] Techrights-sec :) [07:38] Techrights-sec yes, some script which also locks the database temporarily [07:38] Techrights-sec ack ● Aug 19 [09:31] schestowitz-TR2 on root@tm-new [09:31] schestowitz-TR2 tmux a -t logs [09:31] schestowitz-TR2 top pane: gemini. middle: all combined. bottom: apache [09:31] schestowitz-TR2 tm-old still clocking over 200KB/sec [09:32] schestowitz-TR2 we will depart on bicycles in about an hour, eta 2 hours later [09:56] *psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovell [09:56] *psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovell ● Aug 19 [10:35] schestowitz-TR2 I've just stopped the TM backup (remote) job and deletion of older backups [10:35] schestowitz-TR2 the local nightly backup will still happen, but the DB won't change much, just cache tables [10:35] schestowitz-TR2 I'll recover some disk space now by removing old TM backups [10:35] schestowitz-TR2 done, about 10gb of disk space recovered [10:35] schestowitz-TR2 I think you already have some of these files on external media regardless [10:35] schestowitz-TR2 I have selected few also [10:35] schestowitz-TR2 going to run full db check now [10:35] schestowitz-TR2 just in case [10:35] schestowitz-TR2 db is OK [10:35] schestowitz-TR2 I have monitoring on tail for the mariadb log [10:35] schestowitz-TR2 but that site is now in effect read-only [10:35] schestowitz-TR2 its local nightly backup supersede the previous night's backup [10:35] schestowitz-TR2 so it doesn't take any additional space [10:35] schestowitz-TR2 at least we managed to endure 18+ years without data loss [10:35] Techrights-sec ack [10:35] schestowitz-TR2 unless susan could tell me something I don't know about [10:35] schestowitz-TR2 but under our watch since 2014 no data loss [10:39] schestowitz-TR2 oh, wait... i forgot to tell you [10:39] schestowitz-TR2 [10:19] "It is part of the It's FOSS News website and you can read it on the website as well. The news website has also got a makeover as it is [10:39] schestowitz-TR2 now using the Ghost framework." Moved off WordPress? Seems like a trend... https://news.itsfoss.com/foss-weekly-22-30/ [10:39] -TechrightsBN/#boycottnovell-news.itsfoss.com | FOSS Weekly #22.30: Apt Package Management, Atomic Updates in Deepin 23 and More Linux Stuff [10:39] schestowitz-TR2 that explains why I saw all feed entries as suddenly unread [10:39] schestowitz-TR2 calling it "FOSS Weekly" might be an issue [10:39] Techrights-sec ack [10:39] schestowitz-TR2 there is already a "FLOSS Weekly" [10:39] schestowitz-TR2 I hope there can be huge momentum OFF DB-backend CMS bloat. [10:39] schestowitz-TR2 as more sites declare that they do it others start exploring the same [10:39] schestowitz-TR2 DB is a moving part that is very flaky compared to a file system [10:39] schestowitz-TR2 DBs are expressive, but in most sites 99% of actual people request the same pages over and over again [10:39] schestowitz-TR2 and caching in a DB or CMS is just another "moving part" [10:39] schestowitz-TR2 it's also a place where there's attack surface [10:39] schestowitz-TR2 hence more patching needed [10:39] schestowitz-TR2 more often [10:41] Techrights-sec yes all those moving parts are a maintenance nightmare [10:43] schestowitz-TR2 I've just noticed that in TM front page even nodes last updated 17th of Aug show up on top of new nodes like GCC 12.2 [10:43] schestowitz-TR2 I think it's a bug that prioritises all "modified time" pages over non-modified and newer [10:43] Techrights-sec were they updated? [10:43] Techrights-sec ok the sql queries must be tuned better. perhaps just boost the last day's [10:43] Techrights-sec modified files? [10:45] schestowitz-TR2 I think current day's modified [10:45] schestowitz-TR2 so it sort of resets itself at day's end [10:45] schestowitz-TR2 and then new updates bubble their way upwards, and unless updates the next day they'll fall off it [10:45] schestowitz-TR2 *updated [10:45] schestowitz-TR2 the linux kernel rc1 was updated for 3-4 days in a row and it's an important item [10:46] Techrights-sec that part of the sorting has to happen after the query is retrieved and is [10:46] Techrights-sec in the script already [10:55] schestowitz-TR2 d it's an important item [10:55] schestowitz-TR2 curiously, in gemini the order seems correct [10:55] schestowitz-TR2 bumped up to top of front page are only pages updated earlier today [10:55] schestowitz-TR2 in http/s the mesa node, the ltest addition, is about 15 from the top [10:55] schestowitz-TR2 i wondered for days if there was a way to leverage css selectors to highlight "updated" ones [10:55] schestowitz-TR2 but short of shit like JS (jquery) is't not possible ● Aug 19 [11:00] Techrights-sec checking [11:00] schestowitz-TR2 I've also just noticed that in gemini the top of the page of new pages days 2022-08-17 for things posted after that [11:00] schestowitz-TR2 I am guessing that it extracts that date from somewhere external [11:02] Techrights-sec checking [11:03] *Despatche has quit (Quit: Read error: Connection reset by deer) [11:44] *psydroid2 (~psydroid@memzbmehf99re.irc) has joined #boycottnovell ● Aug 19 [13:17] *britney_ has quit (Ping timeout: 2m30s) ● Aug 19 [14:11] *u-amarsh04 has quit (Quit: Konversation terminated!) [14:11] *u-amarsh04 has quit (Quit: Konversation terminated!) [14:18] *u-amarsh04 (~amarsh04@5tcc2vuaj9aks.irc) has joined #boycottnovell [14:18] *u-amarsh04 (~amarsh04@freenode-rmogvn.g0d7.dtdf.mc4289.IP) has joined #boycottnovell ● Aug 19 [15:23] *Despatche (~desp@u3xy9z2ifjzci.irc) has joined #boycottnovell ● Aug 19 [16:33] *Noisytoot has quit (Quit: ZNC 1.8.2 - https://znc.in) [16:40] *Noisytoot (~noisytoot@tkbibjhmbkvb8.irc) has joined #boycottnovell [16:57] schestowitz-TR2 nap now [16:57] schestowitz-TR2 btw, I noticed this morning that automatic resolution for dusplicate slug is not working anymore [16:57] schestowitz-TR2 it just says slug already used, used a different one [16:57] schestowitz-TR2 also, moments ago it didn't catch " & " and converted it. Maybe related? ● Aug 19 [19:20] *DaemonFC (~daemonfc@jmwypg2ijn7rs.irc) has joined #boycottnovell ● Aug 19 [20:06] Techrights-sec fixed, thanks for spotting the error [20:06] Techrights-sec ^ the slug part [20:06] Techrights-sec checking the & part now [20:06] Techrights-sec probabl fixed ... [20:07] schestowitz-TR2 back [20:07] schestowitz-TR2 thanks! [20:07] schestowitz-TR2 been sleeping "too much" lately [20:07] Techrights-sec np [20:29] schestowitz-TR2 > [20:29] schestowitz-TR2 tidied flow of text in IRC description [20:29] schestowitz-TR2 Thanks [20:41] Techrights-sec np ● Aug 19 [21:18] *britney__ (~britney@muarsy2vret2q.irc) has joined #boycottnovell ● Aug 19 [23:12] *psydroid2 has quit (connection closed)