Opened 13 years ago
Last modified 6 years ago
#11782 closed Bug Report - General
Fatal Error on encode User Job — at Version 1
| Reported by: | Owned by: | ||
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | Plugin - MythWeb | Version: | Master Head |
| Severity: | medium | Keywords: | SQL Error: Duplicate entry |
| Cc: | Ticket locked: | no |
Description (last modified by )
I cut commercials from a program with a user job passing these parameters: /home/mythtv/Cut-List.sh "%DIR%/%FILE%" "%CHANID%" "%STARTTIMEUTC%" to the script with this command: $INSTALLPREFIX/mythtranscode --chanid "$2" --starttime "$3" --mpeg2 --honorcutlist -v all This ran without errors, but when I ran the user job for the encode I received a !NoTrans: SQL Error: Duplicate entry '2122-2013-02-15 01:59:00-512-2013-08-26 01:22:29' for key 'chanid' #1062!!. This user job passes these parameters: /home/mythtv/Archive-encode.sh "%DIR%/%FILE%" "%TITLE% - %ORIGINALAIRDATE% - %SUBTITLE%" "%TITLE%" and this is the script: mkdir "/myth/HDD-1/videos/$3" # encode using HandBrakeCLI nice HandBrakeCLI -i "$1.tmp" -o "/myth/HDD-1/videos/$3/$2.mp4" --preset="High Profile" -v2 -q 19 -a 1 -E copy:ac3 -B 640 -6 auto -Y 720 --x264-preset slower --x264-tune film >/dev/null 2>&1
Change History (2)
comment:1 by , 13 years ago
| Component: | MythTV - General → Plugin - MythWeb |
|---|---|
| Description: | modified (diff) |
| Status: | new → infoneeded_new |
by , 13 years ago
| Attachment: | apache_logs.txt added |
|---|

It sounds like you clicked the link to queue the user job twice. The second time failed, because the job queue schema is configured to only allow one instance of a job type per recording in the database.