zaarn

6 ms·

1.
by zaarn 1y ago
I highly doubt it's an SQLite bug, considering how thoroughly they test their code to behave correctly as long as their assumptions are filled. And those assumptions are clearly violated when SQLite runs on ZFS with sync=disabled (sinc
2.
by zaarn 1y ago
I wouldn't recommend SQLite on ZFS (or in general for other reasons), for the precise reason that it either lags or is unsafe. I've encountered this bug both on illumos, specifically OpenIndiana, and Linux (Arch Linux).
3.
by zaarn 1y ago
I've not observed other databases locking up on ZFS, Postgres and MySQL both function just fine, without needing to modify any settings.
4.
by zaarn 1y ago
As noted in a sibling comment, this causes corruption on power failure.
5.
by zaarn 1y ago
Disabling sync corrupts SQLite databases on powerloss, I've personally experienced this following disabling sync because it causes SQLite to hang. You cannot have SQLite keep your data and run well on ZFS unless you make a zvol and for
6.
by zaarn 1y ago
SQLite on ZFS needs the Fsync behaviour to be off, otherwise SQLite will randomly hang the application as the fsync will wait for the txg to commit. This can take a minute or two, in my experience. Btrfs is a better choice for SQLite.
7.
by zaarn 1y ago
ZFS isn’t viable for SQLite unless you turn off fsync’s in ZFS, because otherwise you will have the same experience I had for years; SQLite may randomly hang for up to a few minutes with no visible cause, if there isn’t sufficient write txg
8.
by zaarn 3y ago
The output power of a rocket is different than a blow torch. The sound pressure alone is near or above atmospheric pressure. That concrete is being exposed to vacuum and more than 1atm pressure fairly rapidly. The heat on top of that and if
9.
by zaarn 4y ago
You're still referring to two distinct properties with Angular Moment being one and Spin being the other. Because a black hole can in fact orbit things and that would give it angular momentum. The spin value is merely how fast it rot
10.
by zaarn 4y ago
The commenters is probably using ChatGPT to compose the reply, it's notorious for mathematical mistakes.
11.
by zaarn 4y ago
Spin and Angular momentum are two very different things. Angular momentum measures the velocity of a black hole in, eg, an orbit. Spin measures the rotation of a black hole against it's rest frame. These are independent quantities.
12.
by zaarn 4y ago
There is a cheap and even for current humanity achievable way to rotate a black hole; change your frame of reference. That is not only true for angular momentum but linear momentum and position. Those are entirely dependent on the observer
13.
by zaarn 4y ago
The spin axis isn't a valuable reference since it depends on your frame of reference, which is a concept that gets rather ambiguous as you get close to a black hole anyway. Plus you can just "rotate" a black hole to get it to
14.
by zaarn 4y ago
Maybe uutils could have a build feature that specifically turns off the prefix matching and will break stuff but allows using newer and more useful flags in exchange. I've VERY rarely seen prefix-matched flags being used so I'd
15.
by zaarn 4y ago
That would be true of any software system we put into an airplane, yet we have deployed software into airplanes. If your AI has linear / continuous output, testing it should be no different than any other software.
16.
by zaarn 4y ago
That much is clear but any remotely continuous AI model is very predictable.
17.
by zaarn 4y ago
That entirely depends on what exactly you implement here, it's entirely possible to implement an AI with continuous & linear properties, meaning that you can extrapolate it's behaviour between a set of inputs with decent accur
18.
by zaarn 4y ago
If for a given set of inputs there is a deterministic output, then the overall behaviour to a series of inputs is just as deterministic and predictable. I'm not sure what you mean with "is not predictable" when you also admit
19.
by zaarn 4y ago
What does that question even mean?
20.
by zaarn 4y ago
The pilots take off when they take off. If their take-off clearance isn't obviously time limited, they are certainly allowed to take their time. If they rush the take-off they might skip crucial items from their checklists in the haste
21.
by zaarn 4y ago
AI is entirely deterministic. ChatGPT and StableDiffusion and friends are fed endless amounts of random seeds along with every input to keep them from just saying always the same thing.
22.
by zaarn 4y ago
The tape under the turing machine is infinite, so it's certainly not limited to 47M states. The conjecture states that all machines that halt will do so within 47M states.
23.
by zaarn 4y ago
The Pi's will be using those 200Watts at near full tilt. The main use here would be larger computational tasks that you can easily split up among the blades. Or you run a very hardware-failure tolerant software service on top.
24.
by zaarn 4y ago
I can still get SQLite to trivially corrupt indexes and table data by running it on top of NFS and dropping the network. I wouldn't put much money on this statement on their website.
25.
by zaarn 4y ago
The 1U server is however likely to use more than 200 Watts of power that the 40 Blade 2U setup would use.
26.
by zaarn 4y ago
Everyone should make decisions for themselves, but recommendations from positions of privilege should be well thought out.
27.
by zaarn 4y ago
This won't work if the server is being blocked. My mobile ISP blocks incoming UDP traffic unless the phone establishes the "connection" first. Since change of the server's public IP means that "connection" is b
28.
by zaarn 4y ago
>I have a static v6 IP on the WG server (home router, running OPNsense). Excuse my snark, but not everyone has a static v6 IP. I don't. >One time setup on the server Unless you happen to be behind a CGNAT or you're on a mobi
29.
by zaarn 4y ago
If you consider the overdraft limit, yes.
30.
by zaarn 4y ago
That's roughly it, 1.5K euros is not a lot. If you simply lost your job and went on social benefits, you would get 500€ + Rent from the state, so I don't think for many there is a good reason to have a job paying that low. The inf

More ›