Solved pkg error : pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path

Well for one, one corrupting package , can bring the whole pkg infracture down, by corrupting the sqlite database, which is bad.
Second somehow it was pushed on the servers without verifying, which is bad.
Third people on quarterly could not upgrade their packages for one day, which is bad.

But hey, some Microsoft automatic upgrades, teared down thousands of servers , not booting anymore , which is more than bad.
And kernel & base of FreeBSD where not affected. Installed ports where not affected.

- 1) Maybe pkg should do more checks on it's incoming data
- 2) Checks on it's storage.
- 3) Pushing databases on the servers should be verified.

But this is only my wild gues :))
 
The cause of the issue is giving me lots of broken INDEX vibes. But I also think pkg(8) itself could perhaps do some sanity checks because apparently it'll happily import a corrupted catalogue and muck up the database.
 
The timeline is also interesting. At 12'o clock my bug report entered mailing lists. At 15 'o clock that's only 3 hours later a fix was already available. Then it took one day to be pushed to the servers.
I guess, only wild guess, dev will put in additional checks. Resulting is slow pkg become a bit slower, but we can't have it all in life :)
 
Sidenote, i stopped using gentoo/redcore linux because of too many cyclic redundancies and conflicting versions of packages being pulled in. It became one hell. Pkg works much better.
 
You must log in or register to reply here.
Back
Top