Date: Wed, 4 Sep 2013 06:46:01 +0000 From: Waitman Gobble <gobble.wa@gmail.com> To: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: question about pkg Message-ID: <CAFuo_fwLczu1bwWWpfucbEsSejqM30qGv72vSwcs7KezTXb7Eg@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi, by chance anyone know what's up with this.. could save me some troubleshooting time.. Here's a 9.2 machine. # uname -a FreeBSD do.burplex.com 9.2-BETA2 FreeBSD 9.2-BETA2 #0 r253773M: Mon Jul 29 14:22:34 PDT 2013 da3m0n8t3r@do.burplex.com:/usr/obj/usr/src/sys/KAGISO amd64 # sqlite3 /var/db/pkg/local.sqlite sqlite> SELECT COUNT(id) FROM packages WHERE time is null; 0 sqlite> SELECT COUNT(id) FROM packages WHERE time is not null; 551 Here's a 10.0-CURRENT machine. > uname -a FreeBSD dx.burplex.com 10.0-CURRENT FreeBSD 10.0-CURRENT #0 r252355: Fri Jun 28 16:39:19 PDT 2013 root@dx.burplex.com:/usr/obj/usr/src/sys/FURAHA amd64 # sqlite3 /var/db/pkg/local.sqlite sqlite> SELECT COUNT(id) FROM packages WHERE time is null; 814 sqlite> SELECT COUNT(id) FROM packages WHERE time is NOT null; 104 time = null is causing me some issues.. Thanks -- Waitman Gobble San Jose California USA 510-830-7975
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFuo_fwLczu1bwWWpfucbEsSejqM30qGv72vSwcs7KezTXb7Eg>