Can not update or uninstall any packages.

[Dayve]

2.4.5-RELEASE-p1 (amd64)
built on Tue Jun 02 17:51:17 EDT 2020
FreeBSD 11.3-STABLE

For weeks now I have not been able to update or uninstall any packages. Openvpn-client-export will not update. Says success but still shows as old version.

Also I can not uninstall net-snmp. Same thing it says it has uninstalled but it is still there.

Would anyone know what I can do to resolve this?

[Gertjan]

Hi,

You're pfSense told you nothing about what happens ?
( it doesn't speak out loud, doesn't make signs neither - you have to read the logs )

While you're reading, continue here : https://docs.netgate.com/pfsense/en/latest/install/upgrade-troubleshooting.html

[Dayve]

Following the link you posted. If I go to System/Updates it just sits on "Please wait while the update system initializes" forever.

I tried to refresh the the repository configuration with "pkg-static clean -ay; pkg-static install -fy pkg pfSense-repo pfSense-upgrade" and I get an error at the end saying.

Nothing to do.
Updating pfSense-core repository catalogue...
pfSense-core repository is up to date.
Updating pfSense repository catalogue...
pfSense repository is up to date.
All repositories are up to date.
process with pid 59440 still holds the lock
process with pid 59440 still holds the lock
process with pid 59440 still holds the lock
process with pid 59440 still holds the lock
process with pid 59440 still holds the lock
process with pid 59440 still holds the lock
pkg-static: Cannot get an advisory lock on a database, it is locked by another process

Also my file "upgrade_log.lastest.txt" does not seem to update. it has a old changed date on it.

Can I post a file in this form or text that may help?

Thanks

[Gertjan]

@Dayve said in Can not update or uninstall any packages.:

process with pid 59440 still holds the lock

What is the name of this process ?

ps ax | grep '59440'

Kill this process ;)
Like :

kill 59440

[Dayve]

@Gertjan
Yes that did it. Thank you

After a killed the process I could refresh the repository configuration and upgrade. I'm able to upgrade and uninstall packages now.

Nothing to do.
Updating pfSense-core repository catalogue...
pfSense-core repository is up to date.
Updating pfSense repository catalogue...
pfSense repository is up to date.
All repositories are up to date.
The following 3 package(s) will be affected (of 0 checked):

Installed packages to be UPGRADED:
	pfSense-upgrade: 0.84 -> 0.85 [pfSense]

Installed packages to be REINSTALLED:
	pfSense-repo-2.4.5_2 [pfSense]
	pkg-1.13.2 [pfSense]

Number of packages to be upgraded: 1
Number of packages to be reinstalled: 2

3 MiB to be downloaded.
[1/3] Fetching pkg-1.13.2.txz: .......... done
[2/3] Fetching pfSense-repo-2.4.5_2.txz: . done
[3/3] Fetching pfSense-upgrade-0.85.txz: .. done
Checking integrity... done (0 conflicting)
[1/3] Reinstalling pkg-1.13.2...
[1/3] Extracting pkg-1.13.2: .......... done
You may need to manually remove /usr/local/etc/pkg.conf if it is no longer needed.
[2/3] Reinstalling pfSense-repo-2.4.5_2...
[2/3] Extracting pfSense-repo-2.4.5_2: .......... done
[3/3] Upgrading pfSense-upgrade from 0.84 to 0.85...
[3/3] Extracting pfSense-upgrade-0.85: ..... done

[kor_sal]

Hello sir. I also have problem as your. But when i follow your step it show that.

"pkg-static: Cannot get an advisory lock on a database, it is locked by another process
Failed."

How can i fix it?

[Gertjan]

Same problem ?
Same solution ?! See here.