"database is locked" on brand new container

[bpmmmm]

I've been running NextPVR for quite some time in a windows VM with no issues. Recently, I started playing around with docker and wanted to try out a container instead. I'm putting the config and recording files on a NAS share -- I know it's working because the config folder fills up with files as soon as the container is started. 
The problem is that there still seems to be some kind of problem (permissions?) with the database. I'm consistently getting a "database is locked" error in the container log. 

Any ideas what might be happening. Docker is new to me, so assume nothing

The log from the container is attached. There isn't much in the NextPVR logs; mostly the same information.

-Brian

[mvallevand]

You need to attach the zipped logs from the Setting web page and the must be under 2MB or you need to find an external host ie OneDrive GoogleDrive.

Martin

[bpmmmm]

I'm not sure what's happening, but the attachment disappears when I save the post. It's small enough that I can post it here.

NEXTPVR_INSTALLDIR /app/
NEXTPVR_DATADIR /app/data/
NEXTPVR_DATADIR_USERDATA /config/
[1] See LICENSE.txt for license information
[1] No /config/scripts/PreStartup.sh
[1] Checking if upgrade required
[1] master file is /app/data/Config-master-dont-edit.xml
[1] Doing database updates
[1] Database: /config/npvr.db3
[1] create table if not exists IPTV_RECORDER (capture_source_oid int, m3u_url VARCHAR(250), xmltv_url VARCHAR(250), max_connections int): SQLite Error 5: 'database is locked'.
[1] alter table HDHR_RECORDER add column address VARCHAR(64): SQLite Error 5: 'database is locked'.
[1] create table if not exists SATIP_RECORDER (capture_source_oid int, device_identifier VARCHAR(250), device_instance int, device_standard VARCHAR(250), base_url VARCHAR(250)): SQLite Error 5: 'database is locked'.
[1] CREATE TABLE if not exists [SD_ARTWORK] ([oid] integer PRIMARY KEY AUTOINCREMENT NOT NULL, [show_id] varchar(50) NOT NULL, [type] int NOT NULL, [url] varchar(255) NOT NULL): SQLite Error 5: 'database is locked'.
[1] create table if not exists EXTRA_RECORDER (capture_source_oid int, device_identifier VARCHAR(250)): SQLite Error 5: 'database is locked'.
[1] create table if not exists SYSTEM_INFO (name VARCHAR(250), value VARCHAR(250)): SQLite Error 5: 'database is locked'.
[1] CREATE INDEX if not exists index_tuning ON CHANNEL_MAPPING (tuning): SQLite Error 5: 'database is locked'.
[1] create table if not exists SESSION (sid VARCHAR(64) PRIMARY KEY, address VARCHAR(128), permission int, timestamp datetime): SQLite Error 5: 'database is locked'.
[1] alter table RECENTLY_DELETED add column cached_event VARCHAR(128): SQLite Error 5: 'database is locked'.
[1] create table if not exists VOD ([oid] integer PRIMARY KEY AUTOINCREMENT NOT NULL, source VARCHAR(250), name VARCHAR(250), description VARCHAR(250), artwork VARCHAR(250), group_name VARCHAR(250), url VARCHAR(250), command VARCHAR(250), args VARCHAR(250)): SQLite Error 5: 'database is locked'.
[2] Unexpected error removing old sessions: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: SESSION'.
  at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
  at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
  at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
  at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
  at NShared.Extend.SecurityHelper.RemoveOldSessions()
[2] Unloading...
[2] Flushing logs


/config/logs
/config/media
/config/media/shows
/config/media/channels
/config/scripts
/config/web
/config/web/temp
NEXTPVR_INSTALLDIR /app/
NEXTPVR_DATADIR /app/data/
NEXTPVR_DATADIR_USERDATA /config/
Config.xml does not exists. Creating it from master.
[1] See LICENSE.txt for license information
[1] No /config/scripts/PreStartup.sh
[1] Checking if upgrade required
[1] master file is /app/data/Config-master-dont-edit.xml
[1] Doing database updates
[1] Database: /config/npvr.db3
[1] missing db...copying from: /app/data/empty.db3
[1] create table if not exists IPTV_RECORDER (capture_source_oid int, m3u_url VARCHAR(250), xmltv_url VARCHAR(250), max_connections int): SQLite Error 5: 'database is locked'.
[2] Unexpected error removing old sessions: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: SESSION'.
  at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
  at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
  at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
  at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
  at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
  at NShared.Extend.SecurityHelper.RemoveOldSessions()
[2] Unloading...
[2] Flushing logs

[mvallevand]

That's not the log we want but maybe the web server is not running. Attachments must be zipped, but is seems your source docker file is not being installed correctly. Perhaps /config is not correct, too small etc.

Martin

[sub]

Maybe the data directory is read-only?

[bpmmmm]

You are right, the web server is not accessible yet. The only log I get other than the container log from earlier if the nrecord.log under /config/logs. It's basically the same information without the startup initialization steps. The share containing /config has over a terabyte free and is not limited in any way that I know of. Files are getting created, and I see a npvr.db3-journal file coming and going on a regular basis, but several tries at recreating the container have all resulted in the same database error.

[bpmmmm]

I created the config, recordings, and buffer folders all under the same share. When I start the container, the config folder fills up with the initial files and nrecord.log get created and written to. It doesn't seem like anything is read only at this point, but the npvr.db3 doe retain the same file date of 12/28/2019 1:33PM, which I thought seemed weird. The share is mapped to the container volume using root at the moment, so there should not be a permission issue, but I agree it sure looks like one -- If it weren't for the log working and the config folder getting populated...

[sub]

If you restart the container, do you get the same errors or different ones? (now that npvr.db3 exists)

[bpmmmm]

Same errors. I've restarted and cleared files/restarted multiple times. I get the extra initialization info if everything is cleared out, but basically the same datbase error no matter what I do.

[sub]

If you delete the npvr.db3 file, and restart, does it make any difference? If not, zip and attach the new npvr.db3 that gets created.