Plugin: SJQv4

[Taddeusz]

I don't see anything in here that indicates a problem but here's my log if anyone wants to take a look. The task I'm trying to run is "DELKOCONEWS"

[Taddeusz]

I wish I could figure out why this isn't working. Until/if I can get SJQ working I've figured out a hacky alternative solution. I created a custom sage-x function that does the same thing I want to accomplish and then I put a Python script that makes a http request in unRAID's cron.daily folder.

More complicated than it really should be but it works.

[Tiki]

Originally Posted by Taddeusz

I wish I could figure out why this isn't working. Until/if I can get SJQ working I've figured out a hacky alternative solution. I created a custom sage-x function that does the same thing I want to accomplish and then I put a Python script that makes a http request in unRAID's cron.daily folder.

More complicated than it really should be but it works.

If these are favorite recordings, I wonder if you can't accomplish what you need with just the favorite settings inside Sage.

I would just set the keep at most to 2 or 3 and allow delete to Yes. Then Sage will record every episode but only keep the 2 or 3 most recent and automatically delete anything older.

[Taddeusz]

Originally Posted by Tiki

If these are favorite recordings, I wonder if you can't accomplish what you need with just the favorite settings inside Sage.

I would just set the keep at most to 2 or 3 and allow delete to Yes. Then Sage will record every episode but only keep the 2 or 3 most recent and automatically delete anything older.

I hadn't thought about that. I forgot that option was in there.

[KryptoNyte]

Is this still functional on Sage V9, and if so, is there a user's guide available somewhere, or a clarification on how to donate to get full use?

[KarylFStein]

It works under v9 fine. There is no need to have a license to "unlock" full functionality, (the license plugin was updated a while ago to not need a key). For setup I do it manually based on notes these days. What are you trying to do?

[wayner]

Originally Posted by KarylFStein

It works under v9 fine. There is no need to have a license to "unlock" full functionality, (the license plugin was updated a while ago to not need a key). For setup I do it manually based on notes these days. What are you trying to do?

What he said. There is also a link to the docs in post 1595 above: https://forums.sagetv.com/forums/sho...postcount=1595

However that might be missing screenshots.

[KryptoNyte]

Originally Posted by KarylFStein

It works under v9 fine. There is no need to have a license to "unlock" full functionality, (the license plugin was updated a while ago to not need a key). For setup I do it manually based on notes these days. What are you trying to do?

Two of my six SageTV tuners are HDPVR's. When SageTV tells either of these tuners to stop recording, I also need Sage to send this command which stops the Xbox360 from playing the channel via WMC7;

http://localhost:40511/stop (for HDPVR1)
http://localhost:40512/stop (for HDPVR2)

What little programming I've done was Visual Basic in the early 2000's, so the groovy script may be somewhat of a challenge.

[EnterNoEscape]

This is how I used to deal with the 360's when I was using an HD-PVR to record from them. I had this script running as a SJQ cron job every 15 minutes to turn them on early if there was an upcoming recording and turn them off if nothing was recording next. It ran a batch file to turn everything on or off. I hope it may provide you with some inspiration.

[KryptoNyte]

Originally Posted by EnterNoEscape

This is how I used to deal with the 360's when I was using an HD-PVR to record from them. I had this script running as a SJQ cron job every 15 minutes to turn them on early if there was an upcoming recording and turn them off if nothing was recording next. It ran a batch file to turn everything on or off. I hope it may provide you with some inspiration.

With the SJQ job running every 15 minutes to turn things on, what would happen if someone tried to tune live TV somewhere in between those 15 minute intervals?

[EnterNoEscape]

Originally Posted by KryptoNyte

With the SJQ job running every 15 minutes to turn things on, what would happen if someone tried to tune live TV somewhere in between those 15 minute intervals?

The box would come to life immediately and you would need to wait for it to start up before you would see your channel. I was using the executable tuning plugin, so it ran a batch file that would turn the box on and wait for it to respond before sending the channel.

[KryptoNyte]

Do you still have the batch files, ENE?

[FlyingDoc]

Is there anyone who can help me with setting up a windows service client for SJQ4 correctly?

I have a fully working SJQ4 environment for comskip using the Task Client plugin. I am trying to move the client tasks to a windows service client in anticipation of moving the server to another machine. I am using the same scripts and client configurations but service client always skips the task. The log for the test script indicates an invalid environment was passed to the script.

The server agent log indicates it cant find the file although the path it references is good. I have tried running the service under Local System and my user account but the error is the same.

Does the service client require any additional setup on the server?
Do i have to change the groovy scrips in some way when used with the service client?

Any help or suggestions will be gratefully received.

[FlyingDoc]

I have another SJQ question that might be easier for someone to answer...

I have a task agent running on a windows machine and the main Sage server with SJQ running on a linux machine. They work as expected when the linux firewall (ufw) is off but not when it is on. I have tried opening the ports as listed in the Sage manual but dont know if SJQ needs any additional ports opened. Note the task does get queued and run but the status is "Failed". The log from the executable indicates the remote API is not functioning and references the server IP address and port 1098 however opening this port does not help.

Any ideas?

Thanks

[phelme]

anyone still using SJQ4?

Noticed I started having issues with manually queued compression scripts recently. While things work fine for the ones queued after recordings are finished (via RecordingStopped on the Favorite), the ones I add through the "Assign SJQ Tasks" dialog button fail because not all the SQ4_METADATA variables are present and return NULL according to the logs.

Very strange.

Edit: pretty sure I'm speaking to myself at this point.

Think I may have figured it out and it was to do with what type of file SJQ and SageTV thinks it is. Basically the ones added to the queue by the recording engine are typed (SJQ4_TYPE) as "MediaFile" while those added manually i.e. the ones that are all failing, are typed as "Airing". Airing is a completely different set of APIs (i.e. GetMediaTitle vs GetAiringTitle) so I'm thinking the SJQ4 variables my script relies upon are not being set. So I have to figure out an alternative to get the paths etc. At least I hope that's what's going on.

[mikeg]

My SJQ tasks stopped running and I'm trying to troubleshoot the issue. I've determined that Comskip works by manually running it, so now it looks like SJQ is not running the tasks when queued or when events occur.

So far I've uninstalled/reinstalled SJQ, SJQ UI, and SJQ Task Client and the issue remains. Does anyone know where to look for logs from SJQ?

[jusjoken]

Originally Posted by mikeg

My SJQ tasks stopped running and I'm trying to troubleshoot the issue. I've determined that Comskip works by manually running it, so now it looks like SJQ is not running the tasks when queued or when events occur.

So far I've uninstalled/reinstalled SJQ, SJQ UI, and SJQ Task Client and the issue remains. Does anyone know where to look for logs from SJQ?

I believe that the logs are in plugins/sjq

K

[wayner]

Originally Posted by mikeg

My SJQ tasks stopped running and I'm trying to troubleshoot the issue. I've determined that Comskip works by manually running it, so now it looks like SJQ is not running the tasks when queued or when events occur.

So far I've uninstalled/reinstalled SJQ, SJQ UI, and SJQ Task Client and the issue remains. Does anyone know where to look for logs from SJQ?

When you look in the Installed Plugins - does it show Failed for SJQ? I appear to have that issue and haven't got around to troubleshooting it.

[mikeg]

Thanks to Justin, I found the logs and it looks like the sage events are being handled, but whenever SJQ tries to run it seems to be hitting a runtime exception related to the database. Here are the log messages:

2022-02-17 07:00:00,590 INFO  [TaskQueue]: Scheduling queue processor for ~8 seconds from now!
2022-02-17 07:00:03,061 INFO  [Plugin]: Event received: RecordingStopped
2022-02-17 07:00:08,590 INFO  [TaskQueue]: Running queue processor now!
2022-02-17 07:00:08,590 INFO  [TaskQueue]: Enforcing licensing restrictions... license is valid!
2022-02-17 07:00:08,591 ERROR [DataStore]: SQL Error
org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: page[111] data leaf table:67 entries:6 parent:500 keys:[4355, 4357, 4359, 4361, 4363, 4365] offsets:[1870, 1668, 1533, 1355, 1153, 1018] parent 500 expected 39" [50000-145]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
	at org.h2.message.DbException.get(DbException.java:156)
	at org.h2.message.DbException.convert(DbException.java:279)
	at org.h2.server.TcpServerThread.sendError(TcpServerThread.java:186)
	at org.h2.server.TcpServerThread.run(TcpServerThread.java:139)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: page[111] data leaf table:67 entries:6 parent:500 keys:[4355, 4357, 4359, 4361, 4363, 4365] offsets:[1870, 1668, 1533, 1355, 1153, 1018] parent 500 expected 39
	at org.h2.message.DbException.throwInternalError(DbException.java:226)
	at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:233)
	at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226)
	at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:389)
	at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90)
	at org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
	at org.h2.index.IndexCursor.next(IndexCursor.java:222)
	at org.h2.table.TableFilter.next(TableFilter.java:341)
	at org.h2.command.dml.Select.queryFlat(Select.java:498)
	at org.h2.command.dml.Select.queryWithoutCache(Select.java:597)
	at org.h2.command.dml.Query.query(Query.java:257)
	at org.h2.command.dml.Query.query(Query.java:227)
	at org.h2.command.CommandContainer.query(CommandContainer.java:78)
	at org.h2.command.Command.executeQuery(Command.java:132)
	at org.h2.server.TcpServerThread.process(TcpServerThread.java:278)
	at org.h2.server.TcpServerThread.run(TcpServerThread.java:137)
	... 1 more

	at org.h2.engine.SessionRemote.done(SessionRemote.java:543)
	at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:152)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:77)
	at com.google.code.sagetvaddons.sjq.server.DataStore.getPendingTasks(DataStore.java:556)
	at com.google.code.sagetvaddons.sjq.server.TaskQueue$QueueProcessor.run(TaskQueue.java:98)
	at java.util.TimerThread.mainLoop(Unknown Source)
	at java.util.TimerThread.run(Unknown Source)

[mikeg]

Originally Posted by wayner

When you look in the Installed Plugins - does it show Failed for SJQ? I appear to have that issue and haven't got around to troubleshooting it.

No, the SJQ, SJQ Task Agent, and SJQ UI plugins all uninstalled and re-installed successfully.