IRC: #boycottnovell @ Techrights IRC Network: Sunday, July 03, 2022

Techrights-sec2

220703 3:50:39 [ERROR] Got error 127 when reading table './drupal/node_revisions'

schestowitz-TR

schestowitz-TR

seems possble

schestowitz-TR

did you just check logs or was ther wan incident?

Techrights-sec2

checked logs but there have been temporary skips in the monitoring

Jul 03 06:58

Techrights-sec2

not sure of the reason because the HTTP daemon seems active and responding

Jul 03 06:58

Techrights-sec2

during those outages

Jul 03 06:58

schestowitz-TR

do you want to try your revised script?

schestowitz-TR

it's quiet so a little downtime right how would have minimal effect

schestowitz-TR

that table is not a critical one, and maybe it's marked as crashed

schestowitz-TR

the site itself has been working OK

schestowitz-TR

I did have httpd restarted maybe 2 times this past week

schestowitz-TR

due to load surge at DB level

schestowitz-TR

(the usual)

Techrights-sec2

can we try the script later today, I am busy afk mostly for the next few hours

Jul 03 07:03

Techrights-sec2

I would want to give the script process full attention not multitask (at best)

Jul 03 07:03

schestowitz-TR

today is 4th of july "eve" so new is not slow

schestowitz-TR

news is DEAD

schestowitz-TR

overnight while alseep only 3 new items in my feed!

schestowitz-TR

so I expect TM will be super-slow the whole day

schestowitz-TR

good day to test things

schestowitz-TR

and "tidy up" the DB, not just now but any time of the day

schestowitz-TR

I am here trying to come up with topics, having pretty much exhausted feed I can add (for now)

schestowitz-TR

I thought about improiving the irce server, but it's precarious and would be risky to tinker with

schestowitz-TR

short of a test box

schestowitz-TR

checked daily backups of TM at both ends

schestowitz-TR

running new repair script

schestowitz-TR

checking outcome

schestowitz-TR

it did need repairing

schestowitz-TR

locking was not an issue this time

schestowitz-TR

1) on TR, all 3 GZ files for today are OK

schestowitz-TR

2) on TM, db repair script update 27th of June

schestowitz-TR

3) on TR, the TM backups not compressed for a few days now, maybe by intention

schestowitz-TR

4) on TM DB repair, the tables affected seem cache relatd

schestowitz-TR

5) I've been tail -f'ing the db logs for a while, all OK

schestowitz-TR

did full backup of TM -> TR

schestowitz-TR

this time it compressed OK

schestowitz-TR

theory: since 29-06-2022 when dumping the DB it failed in the middle due to the DB issue

schestowitz-TR

judging by the size of the dump, it is likely OK, but the repair process seemed a little

schestowitz-TR

aggressive

schestowitz-TR

though not in tables that scare me, hopefully I won't see any odd bahvious

schestowitz-TR

going to run repair again (downtimes), thjen make local backup

schestowitz-TR

all good, I have more confidence in it now, well spooted (noticing this issue), we were having bad backups for 4 days already

Jul 03 07:38

schestowitz-TR

the culprits were "revisions" and search index, now it >seems< ok, but fingers crossed. if something is terrible broken, it would become

Jul 03 07:38

schestowitz-TR

apparent fast

Jul 03 07:38

*DaemonFC has quit (connection closed)

Jul 03 07:40

*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovell

Jul 03 08:04

*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovell

Jul 03 08:07

schestowitz-TR

a) saw your two links re newsrooms dying (we need to outlive these) b) rianne and I post links OK

Jul 03 09:34

schestowitz-TR

c) IO monitor mysql log all the time now having: d) studied the past 2 year's errors and events

Jul 03 09:34

*u-amarsh04 has quit (Quit: Konversation terminated!)

Jul 03 09:46

*u-amarsh04 has quit (Quit: Konversation terminated!)

Jul 03 09:46

*u-amarsh04 (~amarsh04@freenode-rmogvn.g0d7.dtdf.mc4289.IP) has joined #boycottnovell

Jul 03 09:51

*u-amarsh04 (~amarsh04@5tcc2vuaj9aks.irc) has joined #boycottnovell

Jul 03 09:51

*psydroid2 (~psydroid@memzbmehf99re.irc) has joined #boycottnovell

Jul 03 10:16

schestowitz-TR

not a single entry in teh mysql.log file sicne 6am when I repaired the DB

schestowitz-TR

IMHO, the DB is in tenable state

schestowitz-TR

but I hope it does not break within 2 daya again, as it did the last time

schestowitz-TR

repaired 26th, then issues on the 28th

schestowitz-TR

which you spotted 4 days later

schestowitz-TR

from the site's front end everything seemed OK

schestowitz-TR

but backups were failing

schestowitz-TR

the most important DB table is "nodes"

schestowitz-TR

comments are also important

schestowitz-TR

in case we even wanted to export the thing, e.g. to static pages

schestowitz-TR

[09:40] <techrights-news> Running a site for 20 years is difficult for technical reasons, like technical debt and difficult "upgrade" routes, which cost a lot of time if not money. Software needs to "slow da fuck down!"

schestowitz-TR

[09:41] <techrights-news> Running very old sites and keeping them online for many years would, at some point, involve DBA skills

Techrights-sec2

ack

Jul 03 10:39

schestowitz-TR

this is the only DB in TR and TM which we were not even able to relocate to the dedicated DB server

schestowitz-TR

because, I think, the storage engine and DB are "too old"

schestowitz-TR

as soon as you "write" to the new (remote) DB it goes into a bad state and panics

schestowitz-TR

kaniini and I repeated this at least 3 times with slight variations

schestowitz-TR

and it was a repeatable issue

schestowitz-TR

don't be upset if I suggest moving TM first ;-)

schestowitz-TR

it's still a small task then TR

schestowitz-TR

but I don't wants to "modernise" the front end

schestowitz-TR

that typically just means bloat and more undesirable things

schestowitz-TR

susan openly complained that when moving from drupal 4->5 and/or 5->6 many things stopped working

schestowitz-TR

you need to give up on a lot of functionality as each "major" (x.0) release is like a

schestowitz-TR

new CMS

schestowitz-TR

and Drupal pushes out a new "major" one every 3 or so years

Jul 03 10:44

schestowitz-TR

job creation the "broken windows" way

Jul 03 10:44

schestowitz-TR

for us and others who can support Drupal

Jul 03 10:44

Techrights-sec2

ack

Jul 03 10:46

Techrights-sec2

Jul 03 10:46

Techrights-sec2

as long as the move starts and goes smoothly, either order is fine

Jul 03 10:46

schestowitz-TR

I often wonder what thought process led techdirt to a) move to wordpress b) move to wordpress.COM

schestowitz-TR

the SLAPPers can now hammer away at automttic

schestowitz-TR

and to them, a private company, masnick is just "dirt"

schestowitz-TR

sometimes the threatening letters (or words) are sent to kaniini, not to me

schestowitz-TR

it's a method

schestowitz-TR

pocock was threatened by the host too, after they had received complaints

schestowitz-TR

even the new host, in iceland, sometimes sighs a bit with its lawyers

schestowitz-TR

he uses ipfs and asked me about gemini, but those are no panaceas

Techrights-sec2

yes there are several major disadvantages to moving away from self-hosting

Techrights-sec2

they try everything they think they /might/ be able to get away with

Techrights-sec2

especially not IPFS

schestowitz-TR

you asked me how ipfs works

schestowitz-TR

I think I totally get it and why it would never work for more than a few small files

schestowitz-TR

without "accelerators" ("bros" selling their "services")

schestowitz-TR

and why I might turn it on for just the nightly "ipfs add", then shut it off for 23 hours

schestowitz-TR

with dht being the primary 'force' (waste) you distribute "maps"/merkle tress/chains with

schestowitz-TR

hashes and swarms pass these around

schestowitz-TR

those tell you which nodes have which hashes

schestowitz-TR

now, you can imagine what happens when you and millions of others have thousands of hashes each

schestowitz-TR

and the storage/cpu/ram issues aside, the "bus" is the network

schestowitz-TR

nice experiment (papers in the wastebasket), but poorly thought out for scale

schestowitz-TR

it still takes quite a bit of time just to add 1 )(or 5) new objects every night

schestowitz-TR

to make a new chain of hashes

schestowitz-TR

my hope was that patience would tackle performance issues and that more people

schestowitz-TR

would "PIN" our hashed data

Techrights-sec2

yes

schestowitz-TR

i think the above issues will merit debates in the coming years because of media hype and subversion

schestowitz-TR

also, those relates to the dynamic of free press and how lawyers/poliicians are being

schestowitz-TR

manipulated into impeding it online

schestowitz-TR

now that print press is mostly obsolete

schestowitz-TR

so they don't need to worry about paper distribution as much

schestowitz-TR

social control media is already rotting away, which I am extremely happy to see

schestowitz-TR

turns out, selling sex for being on a platform is a thing now (FBInstagram/OnlyFans)

Techrights-sec2

I too get the impression that it was not fully thought out and that the

Techrights-sec2

coding started far too soon and got ahead of the planning

Techrights-sec2

ack

Techrights-sec2

there have been several articles over the months about at least one instance

*psydruid (~psydruid@jevhxkzmtrbww.irc) has left #boycottnovell

Jul 03 11:00

*psydruid (~psydruid@jevhxkzmtrbww.irc) has joined #boycottnovell

Jul 03 11:00

schestowitz-TR

a lot of it is connections, not sex. Like Trump spewinfg out Twitetr ToS violations every day for 4 years minus 2 weeks as POTUS

schestowitz-TR

blockchains are very dumb to hype up

schestowitz-TR

they're not even a new thing

schestowitz-TR

maybe the term is

schestowitz-TR

they do the same with "HEY HI"

schestowitz-TR

"ML" is very very old

schestowitz-TR

"clown" is just "mainframe"

schestowitz-TR

1950s?

schestowitz-TR

sorry to be going off in a tangent, but while you were afk and this buffer was already full of info on TM BD I did not wantg

schestowitz-TR

to add more re the closure of newsrooms (100 a year in the US) due to "recession" (downplaying severity)

schestowitz-TR

Netcraft shows millions of domains and sites perishing

schestowitz-TR

the domain registration cartels (I pay 42 pounds every 2 years PER DOMAIN) have probably given people qualm

schestowitz-TR

about saying online. Those are not servers but WEB servers and domains.

schestowitz-TR

I can probably still find online the old BBC program (maybe predates Gates bribes) on how the Web had become too

schestowitz-TR

centralised, with the lion's share of traffic going into few "masters"

schestowitz-TR

in the past 3-4 years there were talks about making data portable across sites, but that was alwats limited to GAFAM

schestowitz-TR

as is http/spfy (/3) is de factor bus for "clown" and "social control media" and "webapps"

schestowitz-TR

*as if ... de facto

Jul 03 11:06

schestowitz-TR

we rianne and I work just a 40-hour block (weekend+break), I will probably code more towards things that I think

schestowitz-TR

help tackle at least some of these issues, at least for our own use. The fight for "Linux" was already 'won'

schestowitz-TR

(or lost, seeing what LF does to the name and where ChromeOS goes), but many concurrent issues are intact

schestowitz-TR

I think that after being enamoured w/ social control media federated, dweb, freesw) I realise promoting

schestowitz-TR

schestowitz-TR

hive of many irc networks would be a lot better. IRCNow (from FSF/LibrePlanet) work towards this too

schestowitz-TR

======

schestowitz-TR

in case scrollback was short and went outside it

schestowitz-TR

I've just attempted to contact ircnow, using 3 different networks of theirs

schestowitz-TR

but all of them deny entry except for particular usernames

schestowitz-TR

how odd!

Techrights-sec2

ack

Techrights-sec2

interesting

schestowitz-TR

evern "bsdforall"

schestowitz-TR

irc is vastly easier to maintain and to use than pleroma, mastodon, and diaspora

schestowitz-TR

it also obviates the need for "instant messaging" or "texting"

schestowitz-TR

there are "apps" for IRC, have been for well over a decade

schestowitz-TR

pleroma, mastodon, and diaspora

schestowitz-TR

=running a WEB server

schestowitz-TR

irc

schestowitz-TR

=1980s-friendly

Techrights-sec2

interesting

Techrights-sec2

one things which can be added to the list of possible topics to write about

Techrights-sec2

is the importance of the decentralized nature of IRC and that one positive

Techrights-sec2

aspect of the Leenode mess was that an increased number of communities chose

Techrights-sec2

then to run their own IRC networks

schestowitz-TR

the sorts of discussions/debate you get in irc are not possible to have in social control media

schestowitz-TR

or the "comments" section of a blog

schestowitz-TR

those are not comparable

Techrights-sec2

ack

Jul 03 11:35

schestowitz-TR

as you note, many new domains are snubbed by gulag (>90% of the search market) while it pews out TWEETS as

schestowitz-TR

search [sic] results for important topics

schestowitz-TR

it's certainly geared towards particular outcomes

schestowitz-TR

Twiutter is prefiltered, both on the membership level and moderation level

schestowitz-TR

but NEVER on the basis of factuality

schestowitz-TR

I was trying to access 3 networks of IRC Now to establish some framework for collaboration

schestowitz-TR

but I cannot even get in, I've tried many things

schestowitz-TR

(I barely use email anymore, not much outgoing mail anyway)

Techrights-sec2

true, it prioritizes hearsay (tweets) over published content

Jul 03 11:38

schestowitz-TR

in june 2022 netcraft observed almost 10 million sites DE-registered

schestowitz-TR

let me check when the decreases started

schestowitz-TR

this might be a subject worth researching and reporting on

schestowitz-TR

just writing a lot of text is pointless if you say nothing new

schestowitz

"Cloudflare experienced strong growth this month, gaining 2.99 million sites and 85,000 domains, representing a 4.64% growth in its number of sites. Cloudflare experienced a significant outage on 21 June, impacting around half of the total requests made to its network. The outage lasted around an hour and a half and affected a significant number of popular sites. 20.2% of the million most visited sites rely on Cloudflare (up 1,400 sites since

Jul 03 11:42

schestowitz

last month)."

Jul 03 11:42

schestowitz-TR

March, April, May, June = loss of about 20 million Web sites

schestowitz-TR

Feb was gain

schestowitz-TR

jan a loss

schestowitz-TR

it peaked 5 years ago

schestowitz-TR

I'm going to make charts on this

schestowitz-TR

and will show you in the draft

schestowitz-TR

I started taking screesshots

Techrights-sec2

ack

Techrights-sec2

the loss peaked or the number of unique domains?

Techrights-sec2

ack

Techrights-sec2

checking

Techrights-sec2

many of the "local" papers in the US are shells held by a national company

Techrights-sec2

specializing not in gathering local news but in pumping out an agenda into

Techrights-sec2

the local market

Techrights-sec2

instead

https://miscellanynews.org/2021/04/29/opinions/the-unprecedented-consolidation-of-the-modern-media-industry-has-severe-consequences/

Techrights-sec2

https://www.usip.org/publications/2022/06/back-basics-fixing-americas-polarized-media-landscape

Techrights-sec2

-TechrightsBN/#boycottnovell-Could not resolve host: miscellanynews.org; Unknown error ( status 0 @ https://miscellanynews.org/2021/04/29/opinions/the-unprecedented-consolidation-of-the-modern-media-industry-has-severe-consequences/ )

https://projects.iq.harvard.edu/futureofmedia/index-us-mainstream-media-ownership

Techrights-sec2

-TechrightsBN/#boycottnovell-www.usip.org | Back to the Basics: Fixing the Americas’ Polarized Media Landscape | United States Institute of Peace

-TechrightsBN/#boycottnovell-projects.iq.harvard.edu | Index of US Mainstream Media Ownership | The Future of Media Project

https://billmoyers.com/story/media-consolidation-should-anyone-care/

Techrights-sec2

-TechrightsBN/#boycottnovell-What is Media Consolidation and Why Should Anyone Care? - BillMoyers

Techrights-sec2

news deserts are a thing in the US

https://www.fool.com/investing/stock-market/market-sectors/communication/media-stocks/big-6/

Techrights-sec2

https://www.pbs.org/moyers/moyersonamerica/net/timeline.html

Techrights-sec2

-TechrightsBN/#boycottnovell-The Big 6 Media Companies | The Motley Fool

-TechrightsBN/#boycottnovell-www.pbs.org | Moyers on America . The Net @ Risk . Resources. Timeline | PBS

schestowitz-TR

finalising now

schestowitz-TR

not sure about you, but to me www becomes more like drawing blood out of stone

schestowitz-TR

gemini is catching up

schestowitz-TR

www is very big, but low s/n ratio

Techrights-sec2

yes, and most of the high profile accounts around the net, especailly those

Techrights-sec2

exploited by social control media, are quite pernicious

schestowitz-TR

"infleunders" = clergy

schestowitz-TR

i've put a skeletal draft

schestowitz-TR

with room for change in focus, direction

schestowitz-TR

finalising now

schestowitz-TR

not sure about you, but to me www becomes more like drawing blood out of stone

schestowitz-TR

gemini is catching up

schestowitz-TR

www is very big, but low s/n ratio

schestowitz-TR

"infleunders" = clergy

Techrights-sec2

basically

Techrights-sec2

or more accurately, mullahs

Techrights-sec2

since there is a predominant political aspect to "influencing"

Techrights-sec2

the entertainment part is just a carrier signal to ensure people are listening

Techrights-sec2

and then on rare occasion, to avoid burning the crowd gathered, a payload

Techrights-sec2

is delivered

schestowitz-TR

many influencers [sic] get paid by ksa for musicwashing and sportwashing

schestowitz-TR

you buy oil

schestowitz-TR

and that helps not only putin

https://text.npr.org/601323233

Techrights-sec2

https://apnews.com/article/election-2020-donald-trump-politics-media-misinformation-7a60e1e6005c8b3b967c9ad337cb1a6a

Techrights-sec2

Techrights-sec2

yep that's a prime example

Techrights-sec2

I saw some stats that without oil and other petrochemicals 24 of the moslem nations have *combined* a smaller GDP than most *tiny* counties have alone

Techrights-sec2

all they currently have is hanging on petrochemical industry

-TechrightsBN/#boycottnovell-text.npr.org | Did Fake News On Facebook Help Elect Trump? Here's What We Know

-TechrightsBN/#boycottnovell-apnews.com | Report: Social media influencers push voting misinformation | AP News

schestowitz-TR

ksa unis are money laundering of sorts

schestowitz-TR

((imho)

schestowitz-TR

and patent mills

schestowitz-TR

via foreigners

schestowitz-TR

oil patents

Techrights-sec2

for example 60% of Malaysia's total exports go to KSA

Techrights-sec2

meaning they are exceptionally dependent on that petrolchemical state

schestowitz-TR

west pays ksa

schestowitz-TR

ksa pays west

schestowitz-TR

lobbyists etc

schestowitz-TR

so both side "benefit"

schestowitz-TR

buy our oil, we''l fund twitter losses

schestowitz-TR

and censor critics of our agenda

Techrights-sec2

yep

Techrights-sec2

s/agenda/shared agenda/

schestowitz-TR

murica has its own women oppressing men

schestowitz-TR

in gowns of black

schestowitz-TR

-women-oppressing

schestowitz-TR

the dash matters

Techrights-sec2

I also recall that KSA, which leads a 30-something nation alliance, defines

Techrights-sec2

"terrorism" quite differenty from the rest of the world and uses largely a

Techrights-sec2

political / religious defninition which applies to their opponents and no one

Techrights-sec2

else

Techrights-sec2

that too

Jul 03 13:06

schestowitz-TR

draft

schestowitz-TR

thorn on their side

schestowitz-TR

published

schestowitz-TR

I do manage to find topics, but not easily

schestowitz-TR

it's more important than old activities I did

*techrights_guest|20 (~d52d6a5b@54n9xgft8g6u2.irc) has joined #boycottnovell

Jul 03 15:57

*techrights_guest|20 has quit (Quit: Connection closed)

Jul 03 16:06

schestowitz-TR

lunduke now promotes "ad-free", like Larabel

schestowitz-TR

better than asking for $300 (or discounted "FOR ONE DAY ONLY!") to just have a chat with him

schestowitz-TR

of course it's just filling his feed with irrelevant junk

schestowitz-TR

and I doubt it'll help him make a living

schestowitz-TR

we're in front page of LXer now

schestowitz-TR

(no, you won't notice a difference; LXer is weak)

schestowitz-TR

just wated an hour in gulkagtube watching a local who abuses people and provoked them for reactions, that he then uploads

schestowitz-TR

while it's not illegal per se, that reminds me how awful the Internet can make people be

schestowitz-TR

some people have at least challenged him on it

schestowitz-TR

gulagtube is a cesspool

schestowitz-TR

it can be addictive because I know the guy (chatted a few times in town) and it shows my city

schestowitz-TR

but with "proper" media this behaviour would not be tolerated

schestowitz-TR

I must admit it is addictive

schestowitz-TR

as I know the guy (since 2008) and it's showing places right near us (in HD)

schestowitz-TR

but watching those video rewards nasty behavious

schestowitz-TR

like abusing fat people, old people, mocking diables, filming heart attacks, annoying homeless people...

schestowitz-TR

and then watching the local police's resources

schestowitz-TR

even verbally abusing vegan activists, just to test their limits

Techrights-sec2

the shock value of "entertainment"

Jul 03 21:11

Techrights-sec2

Jul 03 21:11

Techrights-sec2

or wasting their time and keeping them from important action instead

Jul 03 21:11

schestowitz-TR

I guess I dould dub that "rockvhair-camera vigilante"

Jul 03 21:12

schestowitz-TR

thinking that going about with a camera is the same as law enforcement

schestowitz-TR

when it fact causing a lot of unnecessary scenes

schestowitz-TR

"for drama" - his own words

schestowitz-TR

if there was no channel, there would be none of that

*DaemonFC (~daemonfc@jhkxkj5a94mv2.irc) has joined #boycottnovell

Jul 03 21:15

Techrights-sec2

ack

Jul 03 21:16

schestowitz-TR

I could rant on

schestowitz-TR

this really bothers me

schestowitz-TR

I feel gulity that I watch these videos (I know all these places)

schestowitz-TR

and a guy who started the thing, Danny Shine, ditched him

schestowitz-TR

because he turned out to be attention-seeking provocateur

schestowitz-TR

not sure how soviety can discourage this type of behaviour

schestowitz-TR

provoking people isn't a crime

schestowitz-TR

or anti-social behaviour

schestowitz-TR

he tries to be a public nuisance and when people react he cuts it so that it's out of context

schestowitz-TR

I wonder if other countries have a similar thing

schestowitz-TR

he used to do this in London

schestowitz-TR

in the US the cops would nail him real fast

schestowitz-TR

he was arreretsed many times in the US and once in Canada, IIRC

schestowitz-TR

hooked up with Alex Jones for something, at one point...

schestowitz-TR

The Internet is hopeless

schestowitz-TR

rant over

Techrights-sec2

perhaps

Jul 03 21:20

Techrights-sec2

however there are lots of examples of even more antisocial behavior in

Jul 03 21:20

Techrights-sec2

Youtube besides that one some even dealing in physical violence

Jul 03 21:20

schestowitz-TR

there were some local copycats

Jul 03 21:21

schestowitz-TR

if that spreads, the cops won't be able to focus on real crime

Jul 03 21:21

schestowitz-TR

but manufactured (provocation) "scenes"

Jul 03 21:21

Techrights-sec2

Tiktok was also cultivating both vandalism and physical assault

Jul 03 21:22

schestowitz-TR

I've just had to run repair again, also studied again the logs from the past 2 weeks, aboutn 25k entry logs

schestowitz-TR

it seems like the DB is losing some old node _revisions_, not as critical as nodes themslves

schestowitz-TR

to the outside it looks like things are normal, but maybe soon we should look into exporting and migrating to

schestowitz-TR

avoid worse scenarios

schestowitz-TR

it looks like the warnings return later in the same day that we repair

schestowitz-TR

usually cach, search, and revision-related data

schestowitz-TR

so those are almost disposable

schestowitz-TR

but that might spread

schestowitz-TR

when you repaired it last week it was block_cache, I think, based on the logs