Difference between revisions of "Jobqueue table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
Line 1: Line 1:
 
The '''jobqueue table''' maintains a list of outstanding, in-progress and recently finished commercial flagging, transcoding and user processing jobs. (probably ;-)
 
The '''jobqueue table''' maintains a list of outstanding, in-progress and recently finished commercial flagging, transcoding and user processing jobs. (probably ;-)
 +
 +
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  Field name  !! Type            !! Null !! Key !! Default !! Extras
 +
|-
 +
|| id        || int(11)      ||      || PRI || NULL                || auto_increment
 +
|-
 +
|| chanid    || int(10)      ||      || MUL || 0                  ||
 +
|-
 +
|| 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) ||      ||    ||                    ||
 +
|-
 +
|}
 +
 +
== Fields ==
 +
*'''id''' is a unique identifier for entries in the table.
 +
*'''chanid''' relates to the ''chanid'' field of the [[channel table]].
 +
*'''starttime''' is the time the job started.
 +
*'''inserttime''' is the time the job was queued.
 +
*'''type''' is the type of job.
 +
**NONE = 0x0000, SYSTEMJOB = 0x00ff, TRANSCODE = 0x0001, COMMFLAG = 0x0002, 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
 +
 +
== Example Entries ==
 +
<pre>
 +
        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
 +
</pre>
 +
<pre>
 +
        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
 +
</pre>
 +
<pre>
 +
        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.
 +
</pre>
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Revision as of 06:42, 13 March 2007

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

Table Description

Field name Type Null Key Default Extras
id int(11) PRI NULL auto_increment
chanid int(10) MUL 0
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)

Fields

  • id is a unique identifier for entries in the table.
  • chanid relates to the chanid field of the channel table.
  • starttime is the time the job started.
  • inserttime is the time the job was queued.
  • type is the type of job.
    • NONE = 0x0000, SYSTEMJOB = 0x00ff, TRANSCODE = 0x0001, COMMFLAG = 0x0002, 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

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.
Retrieved from "http://www.mythtv.org/wiki?title=Jobqueue_table&oldid=20297"