Date: Sun, 03 Aug 2014 15:09:29 +0200 From: Wolfgang Hukriede <whukriede@gmail.com> To: freebsd-questions@freebsd.org,m.seaman@infracaninophile.co.uk Subject: Re: pkg: sqlite error while executing PRAGMA user_version Message-ID: <n888un5vhx2.fsf@almelo.raji.xor>
next in thread | raw e-mail | index | archive | help
Matthew Seaman wrote: # pkg shell SQLite version 3.8.5 2014-06-04 14:06:34 Enter ".help" for usage hints. sqlite> select * from pkg_lock ; 0|0|0 sqlite> select * from pkg_lock_pid ; sqlite> .quit Yes, this is what I get. In the meantime I discovered that "pkg info" works on the diskless box when invoked as root. I then tried "pkg upgrade -n" and "pkg upgrade". This worked after some contortions. (It first said "locked", while the second or third attempt was ok.) Becoming somewhat more confident I tried a "pkg delete nnn", but interrupted that with control-c. This seems to have been a mistake, because now I get "database is locked" consistently and nothing works, while output for "select * from pkg_lock" is "1|1|0" and "select * from pkg_lock_pid" returns a number (A pid? But there's no process with that pid). Any way to remove to lock? Thank you!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?n888un5vhx2.fsf>