Bug 191480

Summary:	ports-mgmt/pkg: pkg version locks database too long
Product:	Ports & Packages	Reporter:	freebsd
Component:	Individual Port(s)	Assignee:	Walter Schwarzenfeld <w.schwarzenfeld>
Status:	Closed Feedback Timeout
Severity:	Affects Some People	CC:	bapt, w.schwarzenfeld
Priority:	---
Version:	Latest
Hardware:	Any
OS:	Any

Description freebsd 2014-06-29 14:28:02 UTC

Doing something like "pkg version -vL'=' can take several minutes especially on smaller devices. During the whole time the database is locked. This prevents any port being installed or removed. 
What I think is happening is something like this:
pkg creates a read cursor on the database and then walks from entry to entry to obtain the ports version through some make command.
What it could be doing instead (to prevent the long locks) is something like this:
Take the output of the query that was use to create the cursor and put it in a list then process that list as it did with results of the cursor.

Comment 1 Mark Linimon freebsd_committer

2014-07-04 01:29:17 UTC

Over to maintainers.

Comment 2 Walter Schwarzenfeld 2018-01-11 18:24:20 UTC

I think this is solved and can closed.

Comment 3 Walter Schwarzenfeld 2019-02-25 14:15:27 UTC

Close here with Feedback timeout.