Techrights logo

IRC: #boycottnovell @ Techrights IRC Network: Friday, August 19, 2022

(ℹ) Join us now at the IRC channel | ䷉ Find the plain text version at this address (HTTP) or in Gemini (how to use Gemini) with a full GemText version.

*britney has quit (Ping timeout: 2m30s)Aug 19 00:05
*britney (~britney@muarsy2vret2q.irc) has joined #boycottnovellAug 19 00:06
*britney has quit (Ping timeout: 2m30s)Aug 19 01:33
*britney (~britney@muarsy2vret2q.irc) has joined #boycottnovellAug 19 01:50
*Despatche (~desp@u3xy9z2ifjzci.irc) has joined #boycottnovellAug 19 04:46
*britney has quit (You are no longer authorized to be on this server)Aug 19 04:51
*britney_ (~britney@muarsy2vret2q.irc) has joined #boycottnovellAug 19 04:51
*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovellAug 19 05:26
*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovellAug 19 05:26
*Techrights-sec has quit (*.net *.split)Aug 19 07:13
*rianne_ has quit (*.net *.split)Aug 19 07:13
*rianne_ (~rianne@freenode-vjf.peq.k31cok.IP) has joined #boycottnovellAug 19 07:15
*Techrights-sec (~quassel@freenode-l6u3hi.am6e.nqgd.t29qgt.IP) has joined #boycottnovellAug 19 07:15
*208AKWQN3 (~rianne@freenode-vjf.peq.k31cok.IP) has joined #boycottnovellAug 19 07:15
*208AKWQN3 has quit (Ping timeout: 120 seconds)Aug 19 07:16
schestowitz-TR2gmAug 19 07:19
*DaemonFC has quit (Quit: Leaving)Aug 19 07:19
Techrights-secgmAug 19 07:19
Techrights-secthe updated posts now percolate to the top of any feed list they may be inAug 19 07:19
Techrights-sec(I think)Aug 19 07:19
schestowitz-TR2thanks, 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 morningAug 19 07:20
schestowitz-TR2back, sorry, was 'optimising' rianne's underpowered PCAug 19 07:36
schestowitz-TR2I wasn't even going to mention the 'bug'Aug 19 07:36
schestowitz-TR2I assume it's to do with the timing that page was addedAug 19 07:36
schestowitz-TR2and it's already 'resolved'Aug 19 07:36
schestowitz-TR2btw, should we configure a backup procedure? I'll turn off backups for "old" soon, no point to them anymoreAug 19 07:36
schestowitz-TR2I did run a full DB check before finalising the read-only stateAug 19 07:36
Techrights-secnp it's still there, just behind the updatesAug 19 07:38
Techrights-secthanks for covering the difficult topics in TR posts and the high speed in TMAug 19 07:38
Techrights-secThe SQL queries for that script mark the updated records and then once theAug 19 07:38
Techrights-secrecords are chosen, they are resorted to take their update status into accountAug 19 07:38
Techrights-sec:)Aug 19 07:38
Techrights-secyes, some script which also locks the database temporarilyAug 19 07:38
Techrights-secackAug 19 07:38
schestowitz-TR2on root@tm-newAug 19 09:31
schestowitz-TR2tmux a -t logsAug 19 09:31
schestowitz-TR2top pane: gemini. middle: all combined. bottom: apacheAug 19 09:31
schestowitz-TR2tm-old still clocking over 200KB/secAug 19 09:31
schestowitz-TR2we will depart on bicycles in about an hour, eta 2 hours later Aug 19 09:32
*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovellAug 19 09:56
*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovellAug 19 09:56
schestowitz-TR2I've just stopped the TM backup (remote) job and deletion of older backupsAug 19 10:35
schestowitz-TR2the local nightly backup will still happen, but the DB won't change much, just cache tablesAug 19 10:35
schestowitz-TR2I'll recover some disk space now by removing old TM backupsAug 19 10:35
schestowitz-TR2done, about 10gb of disk space recoveredAug 19 10:35
schestowitz-TR2I think you already have some of these files on external media regardlessAug 19 10:35
schestowitz-TR2I have selected few alsoAug 19 10:35
schestowitz-TR2going to run full db check nowAug 19 10:35
schestowitz-TR2just in caseAug 19 10:35
schestowitz-TR2db is OKAug 19 10:35
schestowitz-TR2I have monitoring on tail for the mariadb logAug 19 10:35
schestowitz-TR2but that site is now in effect read-onlyAug 19 10:35
schestowitz-TR2its local nightly backup supersede the previous night's backup  Aug 19 10:35
schestowitz-TR2so it doesn't take any additional spaceAug 19 10:35
schestowitz-TR2at least we managed to endure 18+ years without data lossAug 19 10:35
Techrights-secackAug 19 10:35
schestowitz-TR2unless susan could tell me something I don't know aboutAug 19 10:35
schestowitz-TR2but under our watch since 2014 no data lossAug 19 10:35
schestowitz-TR2oh, wait... i forgot to tell youAug 19 10:39
schestowitz-TR2[10:19] <techrights-news> "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 isAug 19 10:39
schestowitz-TR2 now using the Ghost framework." Moved off WordPress? Seems like a trend... https://news.itsfoss.com/foss-weekly-22-30/Aug 19 10:39
-TechrightsBN/#boycottnovell-news.itsfoss.com | FOSS Weekly #22.30: Apt Package Management, Atomic Updates in Deepin 23 and More Linux StuffAug 19 10:39
schestowitz-TR2that explains why I saw all feed entries as suddenly unreadAug 19 10:39
schestowitz-TR2calling it "FOSS Weekly" might be an issueAug 19 10:39
Techrights-secackAug 19 10:39
schestowitz-TR2there is already a "FLOSS Weekly"Aug 19 10:39
schestowitz-TR2I hope there can be huge momentum OFF DB-backend CMS bloat.Aug 19 10:39
schestowitz-TR2as more sites declare that they do it others start exploring the sameAug 19 10:39
schestowitz-TR2DB is a moving part that is very flaky compared to a file systemAug 19 10:39
schestowitz-TR2DBs are expressive, but in most sites 99% of actual people request the same pages over and over againAug 19 10:39
schestowitz-TR2and caching in a DB or CMS is just another "moving part"Aug 19 10:39
schestowitz-TR2it's also a place where there's attack surfaceAug 19 10:39
schestowitz-TR2hence more patching neededAug 19 10:39
schestowitz-TR2more oftenAug 19 10:39
Techrights-secyes all those moving parts are a maintenance nightmareAug 19 10:41
schestowitz-TR2I'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.2Aug 19 10:43
schestowitz-TR2I think it's a bug that prioritises all "modified time" pages over non-modified and newerAug 19 10:43
Techrights-secwere they updated?Aug 19 10:43
Techrights-secok the sql queries must be tuned better.  perhaps just boost the last day's    Aug 19 10:43
Techrights-secmodified files?Aug 19 10:43
schestowitz-TR2I think current day's modifiedAug 19 10:45
schestowitz-TR2so it sort of resets itself at day's endAug 19 10:45
schestowitz-TR2and then new updates bubble their way upwards, and unless updates the next day they'll fall off itAug 19 10:45
schestowitz-TR2*updatedAug 19 10:45
schestowitz-TR2the linux kernel rc1 was updated for 3-4 days in a row and it's an important itemAug 19 10:45
Techrights-secthat part of the sorting has to happen after the query is retrieved and isAug 19 10:46
Techrights-secin the script alreadyAug 19 10:46
schestowitz-TR2d it's an important itemAug 19 10:55
schestowitz-TR2curiously, in gemini the order seems correctAug 19 10:55
schestowitz-TR2bumped up to top of front page are only pages updated earlier todayAug 19 10:55
schestowitz-TR2in http/s the mesa node, the ltest addition, is about 15 from the topAug 19 10:55
schestowitz-TR2i wondered for days if there was a way to leverage css selectors to highlight "updated" onesAug 19 10:55
schestowitz-TR2but short of shit like JS (jquery) is't not possibleAug 19 10:55
Techrights-seccheckingAug 19 11:00
schestowitz-TR2I've also just noticed that in gemini the top of the page of new pages days 2022-08-17 for things posted after thatAug 19 11:00
schestowitz-TR2I am guessing that it extracts that date from somewhere externalAug 19 11:00
Techrights-seccheckingAug 19 11:02
*Despatche has quit (Quit: Read error: Connection reset by deer)Aug 19 11:03
*psydroid2 (~psydroid@memzbmehf99re.irc) has joined #boycottnovellAug 19 11:44
*britney_ has quit (Ping timeout: 2m30s)Aug 19 13:17
*u-amarsh04 has quit (Quit: Konversation terminated!)Aug 19 14:11
*u-amarsh04 has quit (Quit: Konversation terminated!)Aug 19 14:11
*u-amarsh04 (~amarsh04@5tcc2vuaj9aks.irc) has joined #boycottnovellAug 19 14:18
*u-amarsh04 (~amarsh04@freenode-rmogvn.g0d7.dtdf.mc4289.IP) has joined #boycottnovellAug 19 14:18
*Despatche (~desp@u3xy9z2ifjzci.irc) has joined #boycottnovellAug 19 15:23
*Noisytoot has quit (Quit: ZNC 1.8.2 - https://znc.in)Aug 19 16:33
*Noisytoot (~noisytoot@tkbibjhmbkvb8.irc) has joined #boycottnovellAug 19 16:40
schestowitz-TR2nap nowAug 19 16:57
schestowitz-TR2btw, I noticed this morning that automatic resolution for dusplicate slug is not working anymoreAug 19 16:57
schestowitz-TR2it just says slug already used, used a different oneAug 19 16:57
schestowitz-TR2also, moments ago it didn't catch " & " and converted it. Maybe related?Aug 19 16:57
*DaemonFC (~daemonfc@jmwypg2ijn7rs.irc) has joined #boycottnovellAug 19 19:20
Techrights-secfixed, thanks for spotting the errorAug 19 20:06
Techrights-sec^ the slug partAug 19 20:06
Techrights-secchecking the & part nowAug 19 20:06
Techrights-secprobabl fixed ...Aug 19 20:06
schestowitz-TR2backAug 19 20:07
schestowitz-TR2thanks!Aug 19 20:07
schestowitz-TR2been sleeping "too much" latelyAug 19 20:07
Techrights-secnpAug 19 20:07
schestowitz-TR2> Aug 19 20:29
schestowitz-TR2    tidied flow of text in IRC descriptionAug 19 20:29
schestowitz-TR2ThanksAug 19 20:29
Techrights-secnpAug 19 20:41
*britney__ (~britney@muarsy2vret2q.irc) has joined #boycottnovellAug 19 21:18
*psydroid2 has quit (connection closed)Aug 19 23:12

Generated by irclog2html.py 2.6 | ䷉ find the plain text version at this address (HTTP) or in Gemini (how to use Gemini) with a full GemText version.