Opened 14 years ago

Closed 14 years ago

#25400 closed defect (fixed)

sqlite error: database is locked

Reported by: vinc17@… Owned by: macports-tickets@…
Priority: Normal Milestone: MacPorts 1.9.2
Component: base Version: 1.9.1
Keywords: Cc:
Port:

Description

Since MacPorts 1.9.x (at least 1.9.1), I sometimes get errors like

$ port installed gcc43
sqlite error: database is locked (5) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry
    while executing
"registry::open $db_path"
    (procedure "mportinit" line 536)
    invoked from within
"mportinit ui_options global_options global_variations"
Error: /opt/local/bin/port: Failed to initialize MacPorts, sqlite error: database is locked (5) while executing query: ATTACH DATABASE '/opt/local/var/macports/registry/registry.db' AS registry

while another port is running. This never occurred with MacPorts 1.8.x, which waited for the lock to be released.

Change History (3)

comment:1 Changed 14 years ago by vinc17@…

Component: portsbase

comment:2 Changed 14 years ago by jmroot (Joshua Root)

Milestone: MacPorts 1.9.2

Only the filemap part of the old registry actually had any locking. Apparently sqlite3_prepare is returning SQLITE_BUSY when we attach the registry. See if r70122 fixes this.

comment:3 Changed 14 years ago by jmroot (Joshua Root)

Resolution: fixed
Status: newclosed

Assuming fixed in the absence of a report to the contrary…

Note: See TracTickets for help on using tickets.