[MacPorts] #61154: Error: port deactivate failed: this entry does not own the given file

[MacPorts]

#61154: Error: port deactivate failed: this entry does not own the given file
-------------------------+--------------------
  Reporter:  ryandesign  |      Owner:  (none)
      Type:  defect      |     Status:  new
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.6.3
Resolution:              |   Keywords:
      Port:              |
-------------------------+--------------------

Comment (by neverpanic):

 Yes, we should probably switch to WAL – we keep having various problems
 with the database as reported on the list, and not only when people are
 running MacPorts in virtual machines. Either crash recovery of SQLite on
 macOS isn't as good as upstream thinks it is, or that's because we're not
 really using WAL mode, which everybody else nowadays seems to do.

 Adding a pragma when initially connecting to the database should do the
 trick, but not that we support versions of SQLite that do not have WAL
 mode.

 I'm pretty sure we're already running all queries in a transaction, btw.
 Speed would be abysmal if we didn't, and the last time we had issues with
 that I went through all queries that modify the database and ensured that
 those are in transactions.

-- 
Ticket URL: <https://trac.macports.org/ticket/61154#comment:9>
MacPorts <https://www.macports.org/>
Ports system for macOS