Plugin: Sage Job Queue (SJQ)

[theringnebula]

Thanks, That code appears to be working as expected although I did add the NODELETE option as well to play it safe.

Thanks!

[GollyJer]

Hey Slugger. I think I may have found a bug.
Currently none of the shows in my Sage database are imported videos but SJQ seems to think they all are. I tested the IsVideo and IsTV functions and this is what I get.

2009/05/25 14:22:20.547 Processing 'Dirty Jobs'...
2009/05/25 14:22:20.547 Line 1: Evaluating 'IsVideo == "true"' == true
2009/05/25 14:22:20.547 Line 1: Evaluating 'IsTV == "true"' == true

I'm looking to do this...

if [IsVideo == true] {
   :PRIORITY 10
   AddToSageDB
}

..but can't isolate imported videos at this point.

Thanks for the amazing tool man.
-Jeremy

[Slugger]

Originally Posted by GollyJer

Hey Slugger. I think I may have found a bug.
Currently none of the shows in my Sage database are imported videos but SJQ seems to think they all are. I tested the IsVideo and IsTV functions and this is what I get.

2009/05/25 14:22:20.547 Processing 'Dirty Jobs'...
2009/05/25 14:22:20.547 Line 1: Evaluating 'IsVideo == "true"' == true
2009/05/25 14:22:20.547 Line 1: Evaluating 'IsTV == "true"' == true

I'm looking to do this...

if [IsVideo == true] {
   :PRIORITY 10
   AddToSageDB
}

..but can't isolate imported videos at this point.

Thanks for the amazing tool man.
-Jeremy

Thanks for finding this bug. The bug is fixed in snapshot build 477.

[GollyJer]

Tested build 478 (assuming it still had the fix applied in 477). Although IsVideo didn't cause anything to show up in the queue, it still showed as true in the log. Weird. Also, none of the Imported Videos show up in the queue with the job code I posted above. Strangely, if I run a debug on one of the files they show up in the queue for a little while.

Side note, I almost think some variable name updates are in order. The concept of "Videos" being separate from "TV" is flawed. TV is a video and very often videos are of tv. The SJQ job code would be more readable (this is the programmer in me coming out) if the variables were more clear.
Suggestion:
Change IsTV to IsRecordedVideo (originally I though IsRecording would be good but the verb-ness of it doesn't sit well)
Change IsVideo to IsImportedVideo
Change IsDVD to IsImportedDVD (assuming this tests for imported DVD's vs a DVD being played in the DVD drive).

[Slugger]

Originally Posted by GollyJer

Tested build 478 (assuming it still had the fix applied in 477). Although IsVideo didn't cause anything to show up in the queue, it still showed as true in the log. Weird. Also, none of the Imported Videos show up in the queue with the job code I posted above. Strangely, if I run a debug on one of the files they show up in the queue for a little while.

Side note, I almost think some variable name updates are in order. The concept of "Videos" being separate from "TV" is flawed. TV is a video and very often videos are of tv. The SJQ job code would be more readable (this is the programmer in me coming out) if the variables were more clear.
Suggestion:
Change IsTV to IsRecordedVideo (originally I though IsRecording would be good but the verb-ness of it doesn't sit well)
Change IsVideo to IsImportedVideo
Change IsDVD to IsImportedDVD (assuming this tests for imported DVD's vs a DVD being played in the DVD drive).

I'm a little confused as to which build you're running because there is no snapshot 478. Build 477 is the last build of SJQ. SVN commit 478 was an update to the SRE plugin. The latest available build of SJQ is 477, check the Help > About menu in the SJQ GUI to ensure you're running build 477, which is currently the only build that has the fix for the IsVideo test.

I don't disagree with your suggested name changes for those tests (except for the IsTV one, I think that's fine), but changing the names will break users' rulesets and cause syntax errors. IsDVD is the only one that could use a more detailed description in the docs, but the Sage API docs aren't clear as to whether or not a DVD in the tray would pass this test. Therefore, I think everything will stay as is (though I'm still willing to read and consider arguments for change).

[GollyJer]

Yeah. I quickly saw 478 in your download area and assumed it was SJQ. I'm currently using 477 and it's ALMOST working as expected. Now IsVideo works but I'm getting weird entries in the queue. There's an entry for each tuner card in the system and for each tuner card entry there is a corresponding "Tender Is the Pork" entry. They look like this:

9099687	Hauppauge HD PVR Capture Device S-Video  AddToSageDB 	
9099690	Tender Is the Pork                       AddToSageDB

Any ideas? Thanks.

[Edit]
Tender Is The Pork is the currently recording show which I wouldn't have expected to be added to the queue with the rule I'm using.

[Slugger]

What does your ruleset look like?

[GollyJer]

Originally Posted by Slugger

What does your ruleset look like?

Like this.

if [IsVideo == true] {
   AddToSageDB
}

[Slugger]

Try snapshot 480.

[Skirge01]

I seem to be having issues with comskip hanging for some strange reason--obviously not the fault of SJQ. But, is there a way to get SJQ to kill the process and requeue it after a certain period of time? I'm thinking this is something that comskip should be on the lookout for, but thought I'd ask it here.

[Slugger]

Originally Posted by Skirge01

I seem to be having issues with comskip hanging for some strange reason--obviously not the fault of SJQ. But, is there a way to get SJQ to kill the process and requeue it after a certain period of time? I'm thinking this is something that comskip should be on the lookout for, but thought I'd ask it here.

Always on the wish list, but never implemented as I've never had a need for it personally. Someone's already opened an issue ticket for this item. However, with the summer here on top of the fact that I'm moving next month, one shouldn't hold their breath in anticipation of new SJQ features over the summer. This seems like something I may tackle in the fall. Until then, you will need to manually stop the task client and kill any lingering task processes.

[GollyJer]

Originally Posted by Slugger

Try snapshot 480.

Working perfectly. Thanks Slugger.

[personalt]

my sjq.sqllite fiel is huge, it is 1,533,850 KB. Should it be this large? I have been running sjq for a few months to run comskip. It works fine... I upgraded to the latest production release this morning

[Slugger]

Originally Posted by personalt

my sjq.sqllite fiel is huge, it is 1,533,850 KB. Should it be this large? I have been running sjq for a few months to run comskip. It works fine... I upgraded to the latest production release this morning

Some older versions had bugs in the log purging code that have since been fixed. Also, older versions logged excessive amounts of data, which has also been fixed. SQLite only marks deleted data for reuse internally, it does not release the disk space so even though your db file might be 1.5GB, it's likely that a lot of that space has since been released and is just being wasted b/c under normal use SJQ should no longer require anywhere near that much space. Perhaps if you open an issue ticket I'll add a feature that will periodically "vacuum" (the SQLite operation used to reclaim the unused disk space) the unused space out of the db file. But as long as things are working as expected and you don't absolutely need the space then I don't think there's anything to worry about. But if you do want SJQ to periodically release that unused disk space then please open an issue ticket at the project web site to remind me.

Note: For those who are interested, one can manually reclaim the disk space from their SQLite db files by installing the SQLite command line program, loading the SJQ db file and running the "VACUUM" statement against the db. That statement will reclaim all unused disk space from the db file.

[baudfather]

Just want to clarify the use of the :RETURNCODE option - would it be placed before or after the call to comskip.exe in the client config file? Thanks!

[Slugger]

Before.

[antplugger]

Hey Guys,

I wonder if I could get a little help fault finding SJQ. I am running Vista x64 with SJQ 2.1.3.414 - Everything was working perfectly until I upgraded to SP2 now COMSKIP is not being run anymore. Client is running ad SJQ is running the only error I can see in the logs is

2009/06/11 21:40:45.610 IPv6 interface detected; client restriction settings ignored [restrictions do not support IPv6 addresses]
2009/06/11 21:40:55.605 IPv6 interface detected; client restriction settings ignored [restrictions do not support IPv6 addresses]
2009/06/11 21:41:05.592 IPv6 interface detected; client restriction settings ignored [restrictions do not support IPv6 addresses]

I dont remember seeing those before

Queue looks like this
4575130 Olivia COMSKIP WAITING 10 Jun 8, 2009 1:10:19 PM
4575131 Jakers!: The Adventures Of Piggley Winks COMSKIP WAITING 10 Jun 8, 2009 7:10:29 PM
4575390 Monarchy COMSKIP WAITING 10 Jun 8, 2009 8:30:09 PM
4575392 Top Gear Australia COMSKIP WAITING 10 Jun 8, 2009 8:30:09 PM

Any help greatly appreciated.

Cheers

[Slugger]

Is there a firewall (perhaps installed or reenabled with the upgrade to SP2) blocking access to the SJQ server from the task client? Are you sure the task client is still running?

[antplugger]

Fixed - The client had lost its config for comskip. I just had to re-enter and save it.

For future reference - Where are these config's kept ?

Thanks

[nyplayer]

The configs are stored on the sjq.sqlite DB. It is based on IP address so if your Client's IP changed for some reason then you will not see your config. It is best to use a static IP address.

If you ever have to format and redo your client you can use the same IP you used when you set up the config.... and it will still be there.