From owner-freebsd-ports@freebsd.org Mon Apr 10 16:00:24 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id AA4AAD377A8 for ; Mon, 10 Apr 2017 16:00:24 +0000 (UTC) (envelope-from asomers@gmail.com) Received: from mail-yb0-x244.google.com (mail-yb0-x244.google.com [IPv6:2607:f8b0:4002:c09::244]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 6C59DA0F for ; Mon, 10 Apr 2017 16:00:24 +0000 (UTC) (envelope-from asomers@gmail.com) Received: by mail-yb0-x244.google.com with SMTP id m133so5222718ybb.1 for ; Mon, 10 Apr 2017 09:00:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:sender:from:date:message-id:subject:to; bh=kqGGodbT7Q9Na9onmJ8LsyG8rua34WUsJLZ8gGQVxCo=; b=Ec1kjFG5YKnEn2MqZ7ZK3WwTDZ/I7/d6kbSTv9I+E7CELvQIZ2Wulnk0snIfFU+nJ3 5NRRNwHgni2z1GM98zgu8DpXe7IB/7tbY1KggQH/fDXGjZ5/SNH/xMvMI54hMT5D3qmr /TWF5GMXOAxtL2qasc1hAGdH9xeQlk6ZhXmRdl/WcTA11yfGfUYRPN7P/n2VNXUUEZPT L9ulB2tF8qu5tUnf71X9E/GlT/mDTOfpTmgwet/TOjQCkw7ONm50r5yjaAbCJRFKvSGu 0pvF43zLlWEQt2sBgslsUyOekIloMDg6eDf3HAWV2De/JRBX5HkvIMi7RMefwLEkyVn9 r36Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:sender:from:date:message-id:subject :to; bh=kqGGodbT7Q9Na9onmJ8LsyG8rua34WUsJLZ8gGQVxCo=; b=VuhpOM/5qJCfDekrXKO1u6s2VKunSVitQZBFbVdMppBEXUqxGkLQL1Tqz81iU2t0t6 0tdNtd2NR4xPBemZO2KA2bFbg9vWfp6yA4NzBsYpo9DAd/ZUjFJZ+mtyDbY86orgb0To D9atLdSbYkXdCBoKKduQ11r/9R2EKB07s8jslFMROJZbiFsg1NxIyUTjtxOA+XQVb6Ep o/If6nU6vL0JgG7kHQhFLahqdCqFkXg2kZhKJcS8+7q0SFx9NHjFOkewK17N0jbyFpix RsGUv0pD750W/tiuhhlfjzyl/+4/DXYL9tn5j1DfEYUWBMsiUI74K7EKpzEA8rBm4M8Y KS9A== X-Gm-Message-State: AFeK/H26xlga5t+16zCM5MWn7mo+exITo3HOLwWtMxMnVPk58r6heY+0F6M4hQqU37m5UjavSnFQUoN/zoIPyQ== X-Received: by 10.37.31.193 with SMTP id f184mr27258401ybf.25.1491840023317; Mon, 10 Apr 2017 09:00:23 -0700 (PDT) MIME-Version: 1.0 Sender: asomers@gmail.com Received: by 10.129.20.214 with HTTP; Mon, 10 Apr 2017 09:00:22 -0700 (PDT) From: Alan Somers Date: Mon, 10 Apr 2017 10:00:22 -0600 X-Google-Sender-Auth: mn_0hRkiOkc8oWVxZu-yUPkyalk Message-ID: Subject: 410.pkg-audit with pkg_jails="*" corrupts jails' pkg databases To: freebsd-ports@freebsd.org Content-Type: text/plain; charset=UTF-8 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 10 Apr 2017 16:00:24 -0000 I have a jailer running 11.0-RELEASE-p8 with 8 jails running either 11.0-RELEASE-p8 or 10.3-RELEASE-p12. On my jailer, I have 410.pkg-audit enabled and pkg_jails="*" is set in /etc/periodic.conf. Up until now, that's worked fine. But apparently at some point I upgraded pkg on the jailer but not in all of its jails. On the jails that got left behind, pkg is busted. All commands fail with an error like this: $ pkg audit -F vulnxml file up-to-date pkg: warning: database version 34 is newer than libpkg(3) version 33, but still compatible pkg: sqlite error while executing INSERT OR ROLLBACK INTO pkg_search(id, name, origin) VALUES (?1, ?2 || '-' || ?3, ?4); in file pkgdb.c:1544: no such table: pkg_search Presumably, copying the new pkg binary into the jails will fix this problem. But if my analysis is correct, then this is a serious problem with 410.pkg-audit. Until it gets fixed, everyone should leave pkg_jails="" in /etc/periodic.conf. -Alan