On 05/08/2013 14:30, Thomas Mueller wrote: > I could see my pkg client is out of date, but how do I update it? > > Attempts to update all gave me those error messages. Installation fails. >
Your package database has got into an inconsistent state. pkg(8) is attempting to auto-update the schema to the latest version, but failing because it's trying to remove an 'infos' column from a table where that column has apparently already been removed. (Likely this situation has come about because pkg got killed in the middle of doing this update previously.) How happy are you to get down'n'dirty with the source code and running SQL from the command line? If you look at the updates pkg is attempting to run shown here: https://github.com/freebsd/pkg/blob/master/libpkg/private/db_upgrades.h would you be capable of looking at the DB schema, working out which of those updates had been applied, aplying any outstanding ones by hand and then setting the user version to 19 by: sql> PRAGMA user_version = 19 ; ? If not, check in /var/backups for a good copy of your local.sqlite database and try and restore from there. Unfortunately, there's no guarantee that any backup copy doesn't have the same inconsistencies as your live copy. We need to make pkg(8) databases more resilient to the effects of SIGHUP or similar while they are elbows-deep in the bowels of the DB schema... Cheers, Matthew _______________________________________________ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
