Multiple server instances running?

[lukewilde]

The web application on my installation runs with very poor performance, typically taking multiple seconds to react to clicks, and often erroring out. For example:

Warning: SQLite3::prepare(): Unable to prepare statement: 5, database is locked in /home/wilde/BirdNET-Pi/scripts/history.php on line 28

Fatal error: Uncaught Error: Call to a member function execute() on bool in /home/wilde/BirdNET-Pi/scripts/history.php:29 Stack trace: #0 /home/wilde/BirdNET-Pi/homepage/views.php(155): include() #1 {main} thrown in /home/wilde/BirdNET-Pi/scripts/history.php on line 29

I also have other weird issues like the daily chart not showing up on the overview page despite detections logging.

I just took a look at htop and the swap is maxed out and it seems that there are multiple instances of the server running. Is that normal?

The install script crashed a few times so I restarted it twice, could be related.

It's running on a RaspberryPi 4

[svc-user]

If you hit F5 for treeview I'm rather certain that the three server.py lines will fold under the same main process - alas. it's still just a single instance spawning multiple processes.

The Sqlite database can end up being locked after a server crash, sudden loss of power or similar.

Most solutions I can find seem to either use the sqlite shell to .dump the old database to a new, or do a reboot.