[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 ryandesign):

 I [https://github.com/macports/macports-base/pull/209 improved the error
 message] to say which file it's having trouble deactivating in the
 registry. With that change, `sudo port deact gettext` now shows:
 {{{
 Warning: Failed to open Portfile from registry for gettext @0.19.8.1_2
 --->  Deactivating gettext @0.19.8.1_2
 Error: port deactivate failed:
 /opt/local/share/doc/gettext/examples/hello-c++-kde/po/mt.po is not owned
 by this entry
 }}}
 `sqlite3` confirms that it cannot find that file when searching for it
 using `=` (like `port` does):
 {{{
 $ sqlite3 registry.db
 SQLite version 3.33.0 2020-08-14 13:23:32
 Enter ".help" for usage hints.
 sqlite> select * from files where actual_path =
 "/opt/local/share/doc/gettext/examples/hello-c++-kde/po/mt.po";
 }}}
 But oddly it can find it when searching using `like`:
 {{{
 sqlite> select * from files where actual_path like
 "/opt/local/share/doc/gettext/examples/hello-c++-kde/po/mt.po";
 9837|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/mt.po|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/mt.po|1|0
 }}}
 And oddly this only affects this file, not other similar files:
 {{{
 sqlite> select * from files where actual_path =
 "/opt/local/share/doc/gettext/examples/hello-c++-kde/po/tr.po";
 9837|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/tr.po|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/tr.po|1|0
 sqlite> select * from files where actual_path =
 "/opt/local/share/doc/gettext/examples/hello-c++-kde/po/vi.po";
 9837|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/vi.po|/opt/local/share/doc/gettext/examples/hello-c++-kde/po/vi.po|1|0
 }}}

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