Database locked error

[sub]

The Channel OID for these 'bad' records is zero (because I don't what it was originally) and the Channel Name of 'Imported', 'Film4' or 'BBC One London'  was probably entered as text in the import .XML file. Over time I have tried several different entries in the XML file hence the various discrepancies. The format of the import XML file is not documented anywhere that I can find so I have made the XML file entries using the recordings-backup.xml file for guidance. I do need to import recording files from time to time and I haven't found a reliable way to do this.  This is why I have corresponded several times about getting the system to generate the XML file created when a recording is made by the app to be at least in the same format as the full recording-backup.xml file. I could then at least see what the minimum xml tags are when creating a manual XML file for imported recordings. If the NextImport utility can do this then so much the better - great. 

These two files were never intended to have the same file format, and I can't really change the format now without breaking other stuff. I can however modify the import process, so that it'll also accept a recording in the metadata file format.

[sub]

The xml files produced during an export is a full dump of everything. The xml file produced as side-by-side metadata is a subset, and uses a more flat structure for easier access to the data.

Currently the import expects one of those full sets of data. I can modify it to also accepted the cut down set of data from the side-by-side metadata

[sub]

I've added support for importing that file format in the next build.

[mvallevand]

Yes there was, I have removed it and restarted the Nextpvr service but still get the same error  message.

Right, running netcore utilities on Windows and Linux are a real nuisance, I forgot what it takes.

You need to copy the appropriate version of

./runtimes/linux-arm64/native/libe_sqlite3.so or

./runtimes/linux-arm/native/libe_sqlite3.so

to the /opt/nextpvr/system folder

Martin

[ceejayemm]

Martin

Thanks for this information. I have copied the relevant file to /opt/nextpvr/system and run the NextImport utility without any errors this time. The program runs and completes almost immediately but produces no obvious output. The NextImport.log file contains only:

[...startup]
2021-06-11 08:33:46.662 [INFO][1]      Using remote RecordingService
2021-06-11 08:33:46.665 [DEBUG][1]      Database: /var/opt/nextpvr/npvr.db3
2021-06-11 08:33:46.883 [INFO][1]      --export /home/pi/nas_recordings/Arrival (2016)
2021-06-11 08:33:46.898 [INFO][1]      Folder: Arrival (2016)


Does the process continue to run as background process and so do I need to wait a while for something to happen ?

Chris

[ceejayemm]

Sub

Thanks, I will look forward to testing the change out once the next release is available.

Chris

[mvallevand]

Does the process continue to run as background process and so do I need to wait a while for something to happen ?

If there were any video files (ts, mkv, mp4) that you didn't have in the database it would display more info and then as mentioned there would be a file called NextImport.xml for further editing or importing.

Marin

[ceejayemm]

Martin

Ok, so 'Arrival (2016)' did exist in the database, thus no output generated. However moving back to 'The Lone Ranger' which doesn't exist in the database (not in the 'scheduled_recordings' table anyway - could it be anywhere else ?) but I get the same result from the utility:

sudo -u nextpvr /opt/dotnet/dotnet  /opt/nextpvr/system/NextImport.dll --export '/home/pi/nas_recordings/Films/The Lone Ranger'
NEXTPVR_INSTALLDIR /opt/nextpvr/system/
NEXTPVR_DATADIR /opt/nextpvr/system/data/
NEXTPVR_DATADIR_USERDATA /var/opt/nextpvr/
Folder: The Lone Ranger


The log file has exactly the same information. An output file (NextImport.xml is created in /var/opt/nextpvr, not the original recording folder ?) which only contains:

<?xml version="1.0" encoding="utf-8"?>
<recordings />

Am I doing something wrong or missing something ?

Chris

[mvallevand]

What output do you get with

find /home/pi/nas_recordings/Films/The\ Lone\ Ranger

I will use that output for a test if you resend your npvr.db3 file.

Martin

[ceejayemm]

Martin

The output requested is as follows:

sudo -u nextpvr /opt/dotnet/dotnet  /opt/nextpvr/system/NextImport.dll --export '/home/pi/nas_recordings/Films/The\ Lone\ Ranger'
NEXTPVR_INSTALLDIR /opt/nextpvr/system/
NEXTPVR_DATADIR /opt/nextpvr/system/data/
NEXTPVR_DATADIR_USERDATA /var/opt/nextpvr/
Folder not found /home/pi/nas_recordings/Films/The\ Lone\ Ranger


I have renamed the folder to 'The_Lone_Ranger' as well and the following similar result:

sudo -u nextpvr /opt/dotnet/dotnet  /opt/nextpvr/system/NextImport.dll --export '/home/pi/nas_recordings/Films/The_Lone_Ranger'
NEXTPVR_INSTALLDIR /opt/nextpvr/system/
NEXTPVR_DATADIR /opt/nextpvr/system/data/
NEXTPVR_DATADIR_USERDATA /var/opt/nextpvr/
Folder: The_Lone_Ranger


Chris