Difference between revisions of "Jobqueue table"

From MythTV Official Wiki
Jump to: navigation, search
m (FK)
(Fields)
 
(2 intermediate revisions by the same user not shown)
Line 41: Line 41:
 
*'''inserttime''' is the time the job was queued.
 
*'''inserttime''' is the time the job was queued.
 
*'''type''' is the type of job.
 
*'''type''' is the type of job.
**NONE = 0x0000, SYSTEMJOB = 0x00ff, TRANSCODE = 0x0001, COMMFLAG = 0x0002, USERJOB = 0xff00, USERJOB1 = 0x0100, USERJOB2 = 0x0200, USERJOB3 = 0x0400, USERJOB4 = 0x0800  
+
** NONE = 0x0000
 +
** SYSTEMJOB = 0x00ff
 +
*** TRANSCODE = 0x0001
 +
*** COMMFLAG = 0x0002
 +
*** METADATA = 0x0004
 +
*** PREVIEW = 0x0008
 +
** USERJOB = 0xff00
 +
*** USERJOB1 = 0x0100
 +
*** USERJOB2 = 0x0200
 +
*** USERJOB3 = 0x0400
 +
*** USERJOB4 = 0x0800  
 
*'''cmds'''
 
*'''cmds'''
**RUN = 0x0000, PAUSE = 0x0001, RESUME = 0x0002, STOP = 0x0004, RESTART = 0x0008
+
** RUN = 0x0000
 +
** PAUSE = 0x0001
 +
** RESUME = 0x0002
 +
** STOP = 0x0004
 +
** RESTART = 0x0008
 
*'''flags'''
 
*'''flags'''
**NO_FLAGS = 0x0000, USE_CUTLIST = 0x0001, LIVE_REC = 0x0002, EXTERNAL = 0x0004
+
** NO_FLAGS = 0x0000
 +
** USE_CUTLIST = 0x0001
 +
** LIVE_REC = 0x0002
 +
** EXTERNAL = 0x0004
 
*'''status'''
 
*'''status'''
**UNKNOWN = 0x0000, QUEUED = 0x0001, PENDING = 0x0002, STARTING = 0x0003, RUNNING = 0x0004, STOPPING = 0x0005, PAUSED = 0x0006, RETRY = 0x0007, ERRORING = 0x0008, ABORTING = 0x0009,    DONE = 0x0100, FINISHED = 0x0110, ABORTED = 0x0120, ERRORED = 0x0130, CANCELLED = 0x0140,
+
** UNKNOWN = 0x0000
 +
** QUEUED = 0x0001
 +
** PENDING = 0x0002
 +
** STARTING = 0x0003
 +
** RUNNING = 0x0004
 +
** STOPPING = 0x0005
 +
** PAUSED = 0x0006
 +
** RETRY = 0x0007
 +
** ERRORING = 0x0008
 +
** ABORTING = 0x0009
 +
** DONE = 0x0100
 +
*** FINISHED = 0x0110
 +
*** ABORTED = 0x0120
 +
*** ERRORED = 0x0130
 +
*** CANCELLED = 0x0140
 
*'''statustime''' is the time the status was last updated
 
*'''statustime''' is the time the status was last updated
 
*'''schedruntime''' is the time that the job should run. Added in {{changeset|12917}}.
 
*'''schedruntime''' is the time that the job should run. Added in {{changeset|12917}}.

Latest revision as of 08:09, 30 March 2020

Important.png Note: The correct title of this article is jobqueue table. It appears incorrectly here due to technical restrictions.

The jobqueue table maintains a list of outstanding, in-progress and recently finished commercial flagging, transcoding and user processing jobs.

Table Description

Field name Type Null Key Default Extras
id int(11) PRI NULL auto_increment
chanid int(10) MUL 0 REFERENCES recorded(chanid,starttime)
starttime datetime 0000-00-00 00:00:00
inserttime datetime 0000-00-00 00:00:00
type int(11) 0
cmds int(11) 0
flags int(11) 0
status int(11) 0
statustime timestamp CURRENT_TIMESTAMP
hostname varchar(255)
args blob
comment varchar(128)
schedruntime datetime 2007-01-01 00:00:00

Fields

  • id is a unique identifier for entries in the table.
  • chanid relates to the chanid field of the channel table.
  • starttime is the start time of the recording.
  • inserttime is the time the job was queued.
  • type is the type of job.
    • NONE = 0x0000
    • SYSTEMJOB = 0x00ff
      • TRANSCODE = 0x0001
      • COMMFLAG = 0x0002
      • METADATA = 0x0004
      • PREVIEW = 0x0008
    • USERJOB = 0xff00
      • USERJOB1 = 0x0100
      • USERJOB2 = 0x0200
      • USERJOB3 = 0x0400
      • USERJOB4 = 0x0800
  • cmds
    • RUN = 0x0000
    • PAUSE = 0x0001
    • RESUME = 0x0002
    • STOP = 0x0004
    • RESTART = 0x0008
  • flags
    • NO_FLAGS = 0x0000
    • USE_CUTLIST = 0x0001
    • LIVE_REC = 0x0002
    • EXTERNAL = 0x0004
  • status
    • UNKNOWN = 0x0000
    • QUEUED = 0x0001
    • PENDING = 0x0002
    • STARTING = 0x0003
    • RUNNING = 0x0004
    • STOPPING = 0x0005
    • PAUSED = 0x0006
    • RETRY = 0x0007
    • ERRORING = 0x0008
    • ABORTING = 0x0009
    • DONE = 0x0100
      • FINISHED = 0x0110
      • ABORTED = 0x0120
      • ERRORED = 0x0130
      • CANCELLED = 0x0140
  • statustime is the time the status was last updated
  • schedruntime is the time that the job should run. Added in [12917].

Example Entries

        id: 4061
    chanid: 1039
 starttime: 2007-01-13 09:00:00
inserttime: 2007-03-12 16:33:25
      type: 1
      cmds: 0
     flags: 1
    status: 272
statustime: 2006-12-10 22:18:48
  hostname: localhost.localdomain
      args:
   comment: High Quality: 4.5 GB => 4.5
        id: 4588
    chanid: 1005
 starttime: 2007-03-10 20:00:00
inserttime: 2007-03-11 15:56:13
      type: 1
      cmds: 0
     flags: 1
    status: 272
statustime: 2007-03-11 17:35:46
  hostname: localhost.localdomain
      args: RENAME_TO_NUV
   comment: Low Quality: 1.5 GB => 799.9
        id: 4559
    chanid: 1039
 starttime: 2007-03-10 08:00:00
inserttime: 2007-03-10 10:30:00
      type: 2
      cmds: 0
     flags: 0
    status: 272
statustime: 2007-03-10 12:41:26
  hostname: localhost.localdomain
      args:
   comment: Finished, 11 break(s) found.