Christopher Baines @cbaines@octodon.social

It turns out the "encoding" issue I've been chasing where PostgreSQL says "invalid byte sequence for encoding" when trying to do a query, probably isn't anything to do with incorrect encoding...

My latest theory is that something about the way the query is executed isn't garbage collector safe, and when the garbage collector runs, the memory regions containing the parameters get altered...

This theory at least explains why I see this issue intermittently.

So... after 3 days, it still hadn't finished. I gave up, stopped the DELETE, added an index on a table referencing the table I was deleting from, and then it finished in a few minutes...

It's the "Trigger for constraint" bit that apparently was taking forever.

I've got a PostgreSQL DELETE query that's been running for over 27 hours now... I really hope it finishes sometime soon!

Actually made it through a pretty big refactor of how the Guix Data Service handles database connections for HTTP requests: https://git.savannah.gnu.org/cgit/guix/data-service.git/commit/?id=c3c9c07f9a208633882a21004d30c5ee29026cb1

There should be less chance of the server being slow handling requests now, and some requests should even be faster due to extra parallelism.

I'm pretty sure I must have broken something somewhere though...

Used text primary keys for a database, and now it's 8GB in size and growing...

I think I need to switch to integer primary keys, but I don't quite have the motivation.

Got some more build "machines" hooked up to https://guix.cbaines.net/ . There are lots of aarch64-linux things to build! #guix #raspberrypi

Seems like I've actually managed to build some substitutes! #guix

JavaScript on webpages, bringing all important usability issues and bugs to your browser.

In all seriousness, Grafana is more difficult to use now there's more JavaScript trying to "help" you.

Challenge for tonight was to work out why the Guix build tool I'm working on isn't building things, and this query appears to do the trick 😁

I wrote it as one long line, I used some (not great) online SQL formatter for sharing.