MBP - database is locked

This section covers the Meteobridge PRO, PRO2, NANO SD, Raspberry Pi and VM platforms exclusively

Moderator: Mattk

Post Reply
User avatar
plex
Expert Boarder
Expert Boarder
Posts: 83
Joined: Tue Nov 30, 2010 1:01 pm
Location: Denmark

MBP - database is locked

Post by plex »

Hello

I see lots of database locked problem - is't something to care about?

I've tried to repair database without any change...

logger (01.05.2016 14:25:11): DB cannot retrieve th0temp_min (100 tries, 7135ms): database is locked
logger (01.05.2016 14:25:22): DB cannot retrieve th0temp_min (100 tries, 7121ms): database is locked
logger (01.05.2016 14:55:12): DB cannot retrieve wind0dir_min (100 tries, 7151ms): database is locked
logger (01.05.2016 15:36:15): DB cannot retrieve th0temp_min (100 tries, 7123ms): database is locked
logger (01.05.2016 15:55:16): DB cannot retrieve wind0wind_min (100 tries, 7131ms): database is locked
logger (01.05.2016 16:15:19): DB cannot retrieve th0temp_min (100 tries, 7129ms): database is locked
logger (01.05.2016 16:37:18): DB cannot retrieve th0temp_min (100 tries, 7110ms): database is locked
logger (01.05.2016 17:31:22): DB cannot retrieve th0temp_min (100 tries, 7126ms): database is locked
logger (01.05.2016 17:52:20): DB cannot retrieve wind0wind_min (100 tries, 7135ms): database is locked
logger (01.05.2016 18:15:17): DB cannot retrieve th0temp_min (100 tries, 7102ms): database is locked
logger (01.05.2016 18:15:51): DB cannot retrieve wind0wind_min (100 tries, 7130ms): database is locked
logger (01.05.2016 18:27:17): DB cannot retrieve th0hum_min (100 tries, 7131ms): database is locked
logger (01.05.2016 18:52:09): DB cannot retrieve th0temp_min (100 tries, 7120ms): database is locked
logger (01.05.2016 18:52:21): DB cannot retrieve wind0dir_min (100 tries, 7124ms): database is locked
logger (01.05.2016 19:20:24): DB cannot retrieve rain0total_min (100 tries, 7120ms): database is locked
logger (01.05.2016 20:20:12): DB cannot retrieve th0temp_min (100 tries, 7136ms): database is locked
logger (01.05.2016 20:20:22): DB cannot retrieve th0temp_min (100 tries, 7119ms): database is locked
logger (01.05.2016 21:28:14): DB cannot retrieve th0temp_min (100 tries, 7122ms): database is locked
logger (02.05.2016 00:03:04): DB cannot retrieve wind0wind_min (100 tries, 7122ms): database is locked
logger (02.05.2016 00:13:16): DB cannot retrieve th0temp_day (100 tries, 7137ms): database is locked
logger (02.05.2016 00:45:08): DB cannot retrieve th0temp_min (100 tries, 7133ms): database is locked
logger (02.05.2016 01:35:17): DB cannot retrieve th0dew_day (100 tries, 7176ms): database is locked
logger (02.05.2016 01:35:25): DB cannot retrieve wind0chill_year (100 tries, 7122ms): database is locked
logger (02.05.2016 02:20:17): DB cannot retrieve th0temp_min (100 tries, 7148ms): database is locked
logger (02.05.2016 02:20:31): DB cannot retrieve th0temp_min (100 tries, 7149ms): database is locked
logger (02.05.2016 03:08:14): DB cannot retrieve th0temp_min (100 tries, 7137ms): database is locked
logger (02.05.2016 03:31:08): DB cannot retrieve th0temp_day (100 tries, 7102ms): database is locked
logger (02.05.2016 03:31:17): DB cannot retrieve th0temp_min (100 tries, 7126ms): database is locked
logger (02.05.2016 03:57:10): DB cannot retrieve th0temp_min (100 tries, 7164ms): database is locked
logger (02.05.2016 07:23:09): DB cannot retrieve th0temp_min (100 tries, 7114ms): database is locked
logger (02.05.2016 08:15:09): DB cannot retrieve th0temp_min (100 tries, 7134ms): database is locked
logger (02.05.2016 08:40:18): DB cannot retrieve th0temp_min (100 tries, 7105ms): database is locked
logger (02.05.2016 08:40:25): DB cannot retrieve th0temp_min (100 tries, 7159ms): database is locked
logger (02.05.2016 09:42:25): DB cannot retrieve thb0seapress_min (100 tries, 7129ms): database is locked
backup (02.05.2016 10:24:53): old backup file removed: dbase-201605011019
backup (02.05.2016 10:25:15): backup completed: daily (66.6M)
logger (02.05.2016 11:33:22): DB cannot retrieve th0temp_min (100 tries, 7127ms): database is locked
logger (02.05.2016 11:59:22): DB cannot retrieve rain0total_min (100 tries, 7139ms): database is locked
logger (02.05.2016 13:58:25): DB cannot retrieve wind0wind_min (100 tries, 7113ms): database is locked
logger (02.05.2016 15:45:13): DB cannot retrieve th0temp_min (100 tries, 7144ms): database is locked
logger (02.05.2016 16:22:08): DB cannot retrieve th0temp_min (100 tries, 7127ms): database is locked
logger (02.05.2016 16:52:21): DB cannot retrieve rain0total_day (100 tries, 7124ms): database is locked
logger (02.05.2016 17:17:20): DB cannot retrieve th0temp_min (100 tries, 7127ms): database is locked
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: MBP - database is locked

Post by admin »

Hi this simply indicates that too much processes are trying to read/write data
concurrently, therefore some don't get data and give up after a series of tries.
This is what the error message is about. It is not indicating that your database
is corrupted.

Could you please post your "services" tab? I assume there will be some
data heavy operations triggered on sub-minute schedule.
User avatar
plex
Expert Boarder
Expert Boarder
Posts: 83
Joined: Tue Nov 30, 2010 1:01 pm
Location: Denmark

Re: MBP - database is locked

Post by plex »

I didn't see these problems from the beginning - it's like it started with a recent update...

Image
Post Reply