in response to the murder of George Floyd by police

200531 Serve and Protect sculpture, Salt Lake City
200531 Serve and Protect sculpture, Salt Lake City

increasingly violent protests have been escalating globally. if we had all listened to colin kaepernick, way back when, we might have avoided this.

meanwhile, drumpf has issued an executive order making antifa a “terrorist organisation” — meaningless, as antifa isn’t an “organisation”, but convenient, because now drumpf can claim anybody is antifa, and have them arrested — and inciting violence on twitter with rhetoric recycled from the republican side of the ’60s-era race riots.

and “when the looting starts, the shooting starts” means the same thing 50 years ago as it does now.

COVID19 has facilitated increasing fascism. it’s just a matter of time before drumpf declares martial law, and/or someone assassinates him.

something that would be supremely ironic, in drumpf’s case: “assassinate” is a word that begins with not one, but two “ass”es…

ahhhh! now we find out…

my newly redesigned site uses the enfold theme, which has faulty (under certain circumstances) caching and optimisation routines, so we use lightspeed cache, which doesn’t have those (particular) faults, and works better (under certain circumstances).

except, last year, prior to my site being redesigned (when i was still using the avada theme), i was told (by SOMEONE) to disable lightspeed cache, because it had some sort of incompatibility with… something…

so, i went through the site redesign with a disabled lightspeed plugin. no problem, until i put in the enfold theme, and whatever circumstances that cause the caching and optimisation routines to fail, were happening, which was the cause of the first go-round.

turning on the lightspeed cache fixed the first go-round, but whatever incompatibility i was trying to avoid by having the lightspeed plugin disabled, took effect, which was the cause of the second go-round.

which was further confused by the fact that part of my routine for fixing the first go-round was good enough that it fixed the second go-round well enough that i didn’t find out about it until it was too late.

what i found out, today, via my web developer, is that the people who make the lightspeed cache and webhost python (my host provider) have their own battle going on: on webhost python’s servers (which include mine), the lightspeed plugin causes expired transients to multiply and duplicate. lightspeed says it’s python’s fault. python disagrees…

on the record…

OFF the record, python agrees that there is a bug in their system that they haven’t found yet… compounded by the fact that it was THEIR ERROR which caused the third go-round… 😠 but it’s not for me to say “i told you so”, especially with my already somewhat precarious position with this particular host provider…

and so, i’m caught in the middle. 😒

apparently, for the time being anyway, the plan is to disable the caching modules on both enfold AND lightspeed, keep an eye on the database (which hasn’t blown up since implementing this plan), clear the expired transients manually, and examine other options for a cache.

😒

oy! why won’t this just go away?

at midnight (which was 3:00 in the morning, florida time), i got a message saying that the database was blowing up again. they said it was 183 GIGABYTES

because of the fact that i was asleep (thankfully), i didn’t actually read the message until 7:00 my time (10:00 florida time). i immediately logged into my web server, and discovered that the MySQL disk usage was lower than i have ever seen it before, which is to say 253 MEGABYTES

what this tells me is that there’s something else going on besides this whole “enfold-theme-not-caching-correctly” horseshit.

which is bad.

it also tells me that, whatever it is, we haven’t actually found it… we may have found another problem, but not the one for which we’re looking… yet…

which is bad, but not as bad as it could be.

it also tells me that, whatever it is that is going wrong, the cronjob that we put in place to solve the problem, works, REGARDLESS of the actual problem.

which is good.

but, when it comes right down to it, it is not good for me to be so stressed out about something over which i have very little control.

which is bad.

something has to be done. this is ridiculous.

oh, but it couldn’t have ended there, now, could it?

and the answer is, a big, fat, OF COURSE NOT! 😒

i woke up this morning, and couldn’t log in to my web site… at, like, SEVEN in the fucking morning, i was wide awake because i couldn’t log in to my web site.

at NINE, the web designer gets back to me. he can’t login either. apparently the host provider has disabled the config file that makes everything work — i login using SSH, and there’s the file… everything LOOKS okay, but… the host provider apparently did SOMETHING to my web site. as far as i can tell, everything works, sort of, until you get one or two pages deep, at which point it gives me a “unable to connect to database” error.

😠

so, i file a ticket with the host provider. a couple hours later, (all the while, i’m sweating bullets) they get back to me, apparently, the database blew up AGAIN. they disabled the config file so that nobody could use the web site, because the database was growing by gigabytes A SECOND.

😠😠

eventually (seriously, they took most of the day to UN-disable the config file), the web designer went in and turned off everything having to do with the built-in, screwy, does-not-work, enfold caching and optimisation routines, turned OFF “store transients”, and set a cronfile to delete three rows of a table in the database, every hour.

😠😠😠😠‼‼‼

this better be the last of it for a while, because i’m just about ready to throw in the towel.

then, on the other hand, there’s moe…

moe has added the “famous author” rôle to her ever expanding list of hats, since her (groundbreaking) book on animal behaviour came out. she’s been travelling, on average, once a month, to various different conventions and conferences, plugging her book and her “new” way of treating animals… which is, basically, “do unto others as you would have them do to you”, with modern branding.

but this whole COVID19 pandemic has put a wrench into the works, and all of the conferences at which she was scheduled to speak for the next 6 months cancelled, which left her with a significant gap in her income. never one to be put down for long, she and a few friends (all of whom had never done this before) decided that they were going to put on a virtual veterinary conference.

seems logical, right?

and, literally, EVERYBODY she talked to about this idea was in favour of it, to the point where she has major corporations paying for top-level speakers so that they can get a plug in the program. and when i say “top-level”, i mean, for example, monique got a call, out of the blue, from Temple Grandin, who had heard about her idea and wanted to help.

all this happened around the middle of march.

the virtual veterinary conference started today. moe is giving 4 hours of talks, as well as handling IT problems — they had an app built for the conference. the developers said they could easily handle 10,000 end users. the conference currently has just over 700 users and systems are blowing up EVERYWHERE. they estimate that 25% of registered users can’t login to see the conference live (they’ll have access to recorded content, so it’s not an entire loss, but…). fortunately, moe says all the presenters can log in, so the stuff will get recorded, but she also says that the developers’ solution to this was to “reschedule for next week”, which IS NOT going to happen with a conference that is already in progress

so, it’s almost as though moe has gone away for the weekend, even though she’s right across the hall from me, at this very moment.

UPDATE: it’s now 2:30 pm, all the speakers have spoken for today (because they’re on eastern standard time), and they got off to a rocky start, but it got better, and they were able to do the second half of the show without a hitch.

tomorrow moe gets to be temple grandin’s “wing man”… 👍👍👍‼‼

database update

the database is fixed. 😌

what happened? that’s complex.

recently, i had my web site redesigned. the new design uses the “Enfold” theme, which uses a lot of what they call “transients” to maintain the look and feel of the site, regardless of the platform on which it’s being viewed. “transients” are sort of like cookies, except that you can’t opt out of them, and they don’t contain any personally identifying information. some of these “transients” expire immediately when a person leaves the web site, and others persist, for a few minutes to several days. they persist on your computer AND on my server… in the one of the tables in the database…

the “Enfold” theme has automatic caching and garbage collection routines that are supposed to handle these expired “transients”, but, because it’s a wordpress theme, it doesn’t do all the jobs very well… or, sometimes, at all… which is why i also use a caching plugin that actually, you know, works ALL the time, and not only some of the time… 😒

except that, for some reason, prior to my site upgrade, “someone” (and i have yet to identify who, but it was either my web designer or my host provider) recommended that i disable the caching plugin, because of some issue with the new version of wordpress… or something like that… as i said, i don’t remember. i distinctly remember disabling the plugin on someone’s recommendation, i just don’t remember exactly who, when or why. 😖

one way or the other, my caching plugin was disabled, which meant that, when i installed the new theme, it was relying on the not-working-the-way-it-should, internal cache… which, basically, didn’t work, causing the table in the database to expand beyond my disk space allocation. 🤯

it didn’t show up in my cPanel because i wasn’t looking at the SQL disk space, which is “below the fold” of my browser, and i just didn’t scroll down far enough to see it. 😕 during the nightly automatic backup, it was overwhelming the server for everybody, not just me. i had to pay my web designer for two days of poking through piles of arcane SQL code and deleting bits and pieces of it. it was not fun.

the solution was to enable the caching plugin(!), and to install a “transient manager” plugin, so that i can delete the expired transients from the wordpress dashboard, and not from the SQL database,… which requires A LOT more “knowing what to look for” and “knowing how to delete stuff without damaging other stuff” than i have on board, personally.

aparajita

ravi shankar’s 100th birthday was the 7th of april.

ravi shankar’s favourite incense was aparajita.

at this point, i believe i am responsible for THE ONLY retail store in the united states which sells aparajita, online.

i am aware of several local retail stores which sell aparajita in their store, but not online. i’m fairly sure that there are others, in other cities. i am also aware of at least two retail stores (i won’t give them the satisfaction of a link) who say that they sell aparajita online, but they’re either perennially “out of stock”, or flat out rip people off, and hope that nobody notices. i have no doubt that there are others of that sort out there, as well.

recently, i had to prevent a guy from los angeles from buying ALL of my aparajita. he said he was working with ravi shankar’s family and the ravi shankar foundation on a special 100th birthday celebration. problem was, his credit card failed stripe, and the order was automatically cancelled… and then i learned how to set an item limit, so that people like him can’t just swoop in and buy all of my stock…

i’ve actually had this happen before: a few years ago, i stocked an incense that was made for the theosophical society by shroff agarbathies, that shroff called “Adyar Meditation Incense”, but the theosophical people called it “Leadbeater Incense”, and it was fantastic, rose, agar, and sandalwood, and i was the ONLY agarbathiwala outside of the theosophical society that carried it… but then the government of india put some sort of restrictions on the export of sandalwood, and shroff stopped making it. i found out about it when someone from florida (i suspect a theosophist, actually) bought TWO KILOS of adyar meditation incense, in 100 gram packages, and when i tried to order more, i couldn’t.

fortunately, i held back some for my own, personal “stash”, but since then i have been very wary of people who buy a huge quantity of one particular incense.

and, the fact is, i’ve been having some trouble locating a supplier of aparajita… AGAIN… 😒

my contact at mavana stopped responding to my emails, the mavana web site died, both of the suppliers (one in florida, one in new york) that carried it have gone out of business, and all of the other suppliers i’ve talked to say that they won’t carry it because aparajita smells too “medicinal”, whatever that means… 😟

my only hope is the fact that, in india, it is still popular enough that it’s being “copied” by at least two incense manufacturers… they haven’t got the recipe for the incense, but their labeling and package artwork is a direct rip-off of the authentic aparajita.

so, i guess i may have to actually travel to india eventually… 😒

databases

my first direct experience with databases was in the late 1980s or early 1990s, when i got a “job”, “working” for this… guy…

i don’t remember his name — possibly “henry” — but i remember his attitudes: he was always right, nothing he thought of had ever been thought of before, he was the richest, smartest, trendiest, most “on-top-of-it” dude that ever hit the face of the planet, and GAWD HELP YOU if you EVER got in his way.

needless to say, the “job” didn’t last long. it started with him demonstrating how generous he was, by buying me a disk caddy, so that i would have somewhere to keep all of the disks i was going to accumulate working for him. then he started asking me about computers. at the time, i was NOT a “computer geek”, nor did i want to be one (my father was one of the original “computer geeks” and i DID NOT want to be like my father), but i knew about computers because i had been working as a typesetter for a few years. he asked me what i didn’t know about computers, and one of the first things out of my mouth was “databases”, so he signed me up for a week of training with “FileMaker”…

what i learned was a bunch of recycled stuff from my already ample knowledge of microslut word and excel, with a bunch of “hypercard-like” stuff which i sort of vaguely understood (but nobody i knew used hypercard for anything, so i never really knew what i had missed until years later), and, at the same time i was doing this training, i was helping this… guy… clean out his house, because he was going through a divorce, or some awful shit like that, and he, basically, had to move EVERYTHING that was “his”, out of one house and into another, that was a few houses down the street…

which is where i learned that his “rich” persona was heavily financed by several HUNDRED overdrawn credit cards — he had been using one credit card to pay off another credit card, and when he ran out of credit cards, he would just start up a new one, and use it to pay off the previous ones… FOR YEARS… — at which point i decided that working for this guy might not be such a good idea, if i wanted to get paid.

quite apart from the fact that working for him was REALLY annoying…

so, ultimately, i spent a week learning really complex software that i never got to use for anything, and that was it, until i got my job at software.com, testing email servers, in 2001.

and, for all of my work with databases at software.com/openwave, i still don’t have a really solid grasp of what they are… where they “live”, what they do, how they work… anything… all i know is that, under the right set of circumstances, you can give “commands” to a database, and it will perform certain functions with a variety of different “objects”, the outcomes of which can be used in a multitude of different ways, depending on what is contained in your database.

i get the impression that databases are a lot like the world wide web, in that they both have a lot of objects (web sites) that are linked together in a somewhat-haphazard, but definitely organised way.

so, you can imagine that it was something of a surprise when, the other morning, i woke up, checked my email, and discovered two somewhat alarming notices. the first was warning me that i had used up 90% of my disk space on my server, and the other was warning me that a “table” on my main database was malfunctioning… or something… and collecting 251 GB worth of data… which, somehow, was NOT showing up in my cPanel, which says “Disk Usage 18.43 GB / 292.97 GB”…

and, of course, it happened on a sunday, when nobody’s in the office, and on mothers day, when even fewer people are in the office, and during a PANDEMIC… 😒

so, first thing this morning, after waking up to a broken heat pump, and a wife who wrenched her back, i wrote to my web designer, who said, oh yeah, we’ve seen this kind of thing before, it’ll cost between $200 and $500 to fix it…

and I DON’T EVEN KNOW WHAT’S WRONG… 😖