[Bug 232350] periodic: pkg-checksum and pkg-backup interfere with 'overnight' port builds

bugzilla-noreply at freebsd.org bugzilla-noreply at freebsd.org
Fri Jan 10 07:15:07 UTC 2020


https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=232350

--- Comment #29 from Tatsuki Makino <tatsuki_makino at hotmail.com> ---
(In reply to Matthew Seaman from comment #28)

Thank you for answering my sqlite3 questions.

However, I don't think the pkg_lock table is for pkg-lock.
I have locked seamonkey-2.49.4_27, but when I run sqlite3
/var/db/pkg/local.sqlite .dump , I only get the following:

CREATE TABLE pkg_lock (exclusive INTEGER(1),advisory INTEGER(1),read
INTEGER(8));
INSERT INTO pkg_lock VALUES(0,0,0);

And there is a column for the locked flag in the packages table.

CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT NOT NULL,name TEXT
NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc TEXT NOT
NULL,mtree_id INTEGER REFERENCES mtree(id) ON DELETE RESTRICT ON UPDATE
CASCADE,message TEXT,arch TEXT NOT NULL,maintainer TEXT NOT NULL, www
TEXT,prefix TEXT NOT NULL,flatsize INTEGER NOT NULL,automatic INTEGER NOT
NULL,locked INTEGER NOT NULL DEFAULT 0, ...Omitted

The column names in the pkg_lock table seem to allow simultaneous invocation...

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the freebsd-pkg mailing list