From owner-freebsd-questions@FreeBSD.ORG Wed Sep 4 06:46:05 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id 32D7F91 for ; Wed, 4 Sep 2013 06:46:05 +0000 (UTC) (envelope-from gobble.wa@gmail.com) Received: from mail-bk0-x233.google.com (mail-bk0-x233.google.com [IPv6:2a00:1450:4008:c01::233]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id BCCC527EE for ; Wed, 4 Sep 2013 06:46:04 +0000 (UTC) Received: by mail-bk0-f51.google.com with SMTP id mx10so2558622bkb.10 for ; Tue, 03 Sep 2013 23:46:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=KIZeGAdQbj4Y4afCCp05h1k9Bec3akUNd26UA8SqDh8=; b=RL1nApzLO5YKAPAhnQo5b1CskuT171iy6eN5KXsV5D9d++y1W4/QMQee5GEyzcy20G G9ijKVFJ9QdG5xob/By5ugbf5kieDK3r8P8hYGq8BWQeyDiAA3jL4PHAnpQ/9EuSpg6E SEYK2O/ByXuVTSrMzlfBqedPRul+KT6esN9WRKpgabRddljI0sixwBnVUUFUDeXb5PHa ubOG6f3g3pcVmebZp/T8OHTpYRC5ZnqNyJjS4GTrj2zCWpgTx+aT+Ti24wOJNFJ9uJdP EL+T5SYLu5xKTWKdm2XDkjZ3LaCTWtm6XJKyXNcKFIfZ9/NhPwDRZ+bc+xyx9V4Izr9V qHvQ== MIME-Version: 1.0 X-Received: by 10.204.226.135 with SMTP id iw7mr860483bkb.4.1378277162065; Tue, 03 Sep 2013 23:46:02 -0700 (PDT) Received: by 10.205.97.74 with HTTP; Tue, 3 Sep 2013 23:46:01 -0700 (PDT) Date: Wed, 4 Sep 2013 06:46:01 +0000 Message-ID: Subject: question about pkg From: Waitman Gobble To: "freebsd-questions@freebsd.org" Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.14 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Sep 2013 06:46:05 -0000 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