#57171 closed defect (worksforme)
Registry operations can take a very long time in 2.5.3 under Mojave
| Reported by: | pmetzger (Perry E. Metzger) | Owned by: | |
|---|---|---|---|
| Priority: | Normal | Milestone: | |
| Component: | base | Version: | |
| Keywords: | Cc: | ||
| Port: |
Description (last modified by pmetzger (Perry E. Metzger))
For some reason, registry operations like computing dependencies or registering files at the end of package installs now seem to take forever on my machine, which is running Mojave. It can take many minutes to compute the dependencies for a port like claws-mail, for example. Registering the files from texlive-fonts-extra has been running for tens of minutes. Running PRAGMA optimize on the database helped a bit the first time I noticed it but the problems have returned. I'm not sure how to debug this.
Change History (7)
comment:1 Changed 6 years ago by pmetzger (Perry E. Metzger)
comment:2 Changed 6 years ago by pmetzger (Perry E. Metzger)
| Description: | modified (diff) |
|---|---|
| Summary: | computing dependencies can take a very long time in 2.5.3 → computing dependencies can take a very long time in 2.5.3 under Mojave |
comment:3 Changed 6 years ago by pmetzger (Perry E. Metzger)
| Description: | modified (diff) |
|---|---|
| Summary: | computing dependencies can take a very long time in 2.5.3 under Mojave → Registry operations can take a very long time in 2.5.3 under Mojave |
comment:4 Changed 6 years ago by pmetzger (Perry E. Metzger)
Note that the file registration problem and the dependency computation problem might very well be totally unrelated. I shouldn't assume.
comment:5 Changed 19 months ago by jmroot (Joshua Root)
I'm guessing the slow installation of ports with many files like texlive-fonts-extra was #56793. Can this be closed as a duplicate, or are you still seeing poor dependency calculation performance that temporarily goes away if you optimise the db?
comment:6 Changed 6 months ago by jmroot (Joshua Root)
| Resolution: | → worksforme |
|---|---|
| Status: | new → closed |
Please reopen if you can provide a reproduction recipe.
Datapoint: If I connect to the registry database and do a "PRAGMA optimize;" the problem goes away. This makes it seem like it's a query optimizer change that happened under the version of sqlite that ships with Mojave. I don't know how to debug it from here, though.