pkg: Cannot get an advisory lock on a database, it is locked by another process

[dw07]

HI,

I receive this error when trying to install nginx and systemctl

pkg: Cannot get an advisory lock on a database, it is locked by another process

 

[YYY__]

Solved - pkg upgrade -- pkg: Cannot get an advisory lock on a database, it is locked by another process

I checked what was running and saw this: # ps -auwx | grep 'USER\|pkg' | grep -v grep USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND root 55747 0.0 0.0 11804 2612 - IJ 07:50 0:00.00 /bin/sh - /usr/local/etc/periodic/security/460.pkg-checksum root 58051 0.0 0.0...

forums.freebsd.org

pkg does not confirm that the process holding the lock is another instance of pkg · Issue #1550 · freebsd/pkg

pkg version 1.9.4 on FreeBSD 11.0-RELEASE-p8 pkg database appears to pkg to be locked by a g_eli kernel thread due to pid reuse after a reboot. (ee95ca16)[root@mtumishi /var/db/pkg]$ pkg check -d p...

github.com

 

[dw07]

Solved - pkg upgrade -- pkg: Cannot get an advisory lock on a database, it is locked by another process

I checked what was running and saw this: # ps -auwx | grep 'USER\|pkg' | grep -v grep USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND root 55747 0.0 0.0 11804 2612 - IJ 07:50 0:00.00 /bin/sh - /usr/local/etc/periodic/security/460.pkg-checksum root 58051 0.0 0.0...

forums.freebsd.org

pkg does not confirm that the process holding the lock is another instance of pkg · Issue #1550 · freebsd/pkg

pkg version 1.9.4 on FreeBSD 11.0-RELEASE-p8 pkg database appears to pkg to be locked by a g_eli kernel thread due to pid reuse after a reboot. (ee95ca16)[root@mtumishi /var/db/pkg]$ pkg check -d p...

github.com

I installed nginx and its messed everything up

 

[hbsd]

Clean your pkg cache and do a force update:

# pkg clean
# pkg update -f

(If) that doesn't worked do a force reinstallation of pkg:

# pkg-static bootstrap -f

 

[dw07]

Clean your pkg cache and do a force update:

# pkg clean
# pkg update -f

(If) that doesn't worked do a force reinstallation of pkg:

# pkg-static bootstrap -f

I got it installed, but its messed up all my other apache24 connections

 

[hbsd]

I got it installed, but its messed up all my other apache24 connections

These commands do not break anything. You just cleared the pkg cache and reinstalled it.

 

[dw07]

These commands do not break anything. You just cleared the pkg cache and reinstalled it.

I was following the pkg notes for Zoneminder and nginx is a requirement. I already have Apache24 configured for rancid access via viewvc. nginx has messed it up so I reverted back to pre zoneminder install.

Do you know how to configure zoneminder in Apache24? I am a novice with it.

Its all configured on a FreeBSD guest on a vmware workstation host. I got Rancid and OpenVPN working and want to add zoneminder without breaking anything.

I think i need to segment everything into virtual host on apache one for rancid/viewvc, and then another for zoneminder. Not sure though because I initially tried to configure viewvc as a virtual host but was told not to and given the code I applied that works.

 

[hbsd]

I found this tutorial helpful: Zoneminder FreeBSD Installation and configuration
Of course, it uses nginx in this guide but it's not too difficult to change it to Apache.