No device listed -- error saving capture source: SQLite Error 1: 'no such column: −1'

[skrottapple]

I see, my mistake. I'll leave it in their hands.

Sure, here's the journal after trying to start it again:

Code:

apr 12 01:16:40 k55a systemd[1]: Starting nextpvr-server.service - NextPVRServer...
apr 12 01:16:41 k55a server.sh[13208]: Starting server..
apr 12 01:16:41 k55a server.sh[13210]: Unhandled exception. System.InvalidOperationException: The data is NULL at ordinal 1. This method can't be cal>
apr 12 01:16:41 k55a server.sh[13210]:    at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
apr 12 01:16:41 k55a server.sh[13210]:    at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
apr 12 01:16:41 k55a server.sh[13210]:    at NShared.IPTVRecorder.GetPresentDevices()
apr 12 01:16:41 k55a server.sh[13210]:    at NShared.Visible.CaptureSource.UpdateDevices(ICaptureSourceUpdateStatus callback)
apr 12 01:16:41 k55a server.sh[13210]:    at NShared.RecordingService..ctor()
apr 12 01:16:41 k55a server.sh[13210]:    at NPVR.Program.Main(String[] args)
apr 12 01:16:42 k55a server.sh[13208]: Done. PID=13210
apr 12 01:16:42 k55a systemd[1]: Started nextpvr-server.service - NextPVRServer.
apr 12 01:16:43 k55a systemd[1]: nextpvr-server.service: Main process exited, code=dumped, status=6/ABRT
apr 12 01:16:43 k55a systemd[1]: nextpvr-server.service: Failed with result 'core-dump'.
apr 12 01:17:10 k55a systemd[1]: Starting nextpvr-server.service - NextPVRServer...
apr 12 01:17:10 k55a server.sh[13293]: Starting server..
apr 12 01:17:10 k55a server.sh[13295]: Unhandled exception. System.InvalidOperationException: The data is NULL at ordinal 1. This method can't be cal>
apr 12 01:17:10 k55a server.sh[13295]:    at Microsoft.Data.Sqlite.SqliteValueReader.GetString(Int32 ordinal)
apr 12 01:17:10 k55a server.sh[13295]:    at Microsoft.Data.Sqlite.SqliteDataReader.GetString(Int32 ordinal)
apr 12 01:17:10 k55a server.sh[13295]:    at NShared.IPTVRecorder.GetPresentDevices()
apr 12 01:17:10 k55a server.sh[13295]:    at NShared.Visible.CaptureSource.UpdateDevices(ICaptureSourceUpdateStatus callback)
apr 12 01:17:10 k55a server.sh[13295]:    at NShared.RecordingService..ctor()
apr 12 01:17:10 k55a server.sh[13295]:    at NPVR.Program.Main(String[] args)
apr 12 01:17:12 k55a server.sh[13293]: /opt/nextpvr/shell/server.sh: rad 23: 13295 Avbruten (SIGABRT)      (minnesutskrift skapad) /opt/dotnet/dotnet>
apr 12 01:17:12 k55a server.sh[13293]: Done. PID=
apr 12 01:17:12 k55a systemd[1]: nextpvr-server.service: Deactivated successfully.
apr 12 01:17:12 k55a systemd[1]: Started nextpvr-server.service - NextPVRServer.

I had to install sqlite3 first though. I hope that wasn't a dependency.

> I strongly suspect the -1 is a return code

So do I, but judging from the linked answer on SO I believe it's a return code for something other than the sqlite query (the question demonstrates that that's where the erroneous column name is in the error message), that's being saved in a variable and used as a literal, but since it's prefixed with a hyphen-minus is instead interpreted as a column name. Just guessing.

[sub]

As Martin said, basically the -1 means it couldn't find a requested column by name. Unfortunately we can't tell what name it was looking for from this info. (the DbDatatReader.GetOrdinal("column-name") api is used to the get the column index, and it's returning -1 to indicate it couldn't find the column)

Given we've never seen another single report with this error, it makes me wonder if the npvr.db3 got corrupt somehow.

[mvallevand]

I tried his npvr.db3 file here and it was fine.

Martin

[sub]

Yeah, I checked the file here, and it superficially looked ok. Had the IPTV columns expected etc.

Maybe some file permission error reports like this. Like can open the file but not read from it.

[mvallevand]

That's why I tried sqlite3 as sudo -u nextpvr plus the file was copied from empty.db3

Martin

[skrottapple]

Well, I'm out of ideas. I tried removing and reinstalling, but ran into the same issue.

In fact I couldn't even find documentation of "DbDatatReader.GetOriginal". The closest I got was ".GetOrdinal", and even then it said it would throw an exception if there was no match, so I didn't get any wiser. Thanks for the explanation nonetheless!

I don't think I have much to contribute so I'll leave it to you. Let me know if you need any additional info.

[mvallevand]

I probably gave you sql the added those null. The second insert should have been (those ' ' are two single quotes)

Code:

delete from IPTV_RECORDER;
insert into IPTV_RECORDER select oid, '', '', '32' from capture_source limit 1;

martin

[skrottapple]

I take it you want me to rerun the sql queries.

I replaced the second insert with what you provided.

Server starts. "IPTV Device" visible in Devices. First time I see anything there.

[mvallevand]

Can we see the zipped logs now?

Martin

[sub]

In fact I couldn't even find documentation of "DbDatatReader.GetOriginal". The closest I got was ".GetOrdinal", and even then it said it would throw an exception if there was no match, so I didn't get any wiser. T

It was GetOridinal(). I think my browser must have tried to correct the spelling or something. It returns -1 if the column isn't found.