Hi,

I am struggling with an interesting problem where the video module seems to be storing multiple durations per video/node in the video_queue table. Also the durations are all different even for the same node...

My setup:

  • Video 7.x-2.10
  • AWS SDK / Amazon S3 storage
  • Zencoder

I have looked through a ton of issues and nothing seems to address this issue so I don't know if it is just my setup...
Is there some way to flush the video_queue table?

Thanks.

Comments

theamoeba’s picture

Issue summary: View changes
brycefisherfleig’s picture

Hi Theamoeba,

Thanks for using the video module! Some follow up questions:

  • What are your transcoder presets?
  • How did you discover this problem?
  • Have you tried using the development version of the Video module?
theamoeba’s picture

Hi brycefisherfleig, thanks for the response :).

Video transcoder: Zencoder
Number of thumbnails: 5
Dimension of thumbnails: 320x240
Postback URL for Zencoder: http://.../postback/jobs
Location for Zencoder output: Amazon S3

I have setup a view to show off the durations and there are up to 20 different durations per node

No, I haven't tested the dev version. I will do that and report back.

brycefisherfleig’s picture

Great! Let me know how the dev version works for you. Can you send me the information or a screenshot on "Advanced video settings" tab inside the preset you're using?

brycefisherfleig’s picture

Also, can you describe the steps to reproduce? Does this happen consistently for you?

theamoeba’s picture

brycefisherfleig,

i have installed the dev version (7.x-2.x-dev) and it still does exactly the same thing.

yes, it happens consistently. i think the problem is at video_jobs::create() - line 11 of ./includes/jobs.inc because each time there is a change to the video or it needs to re-encoded it creates a new row in the video_queue table and doesn't seem to clean up the old ones...

node revisions are turned on, i couldn't find any evidence that revisions cause trouble with the video module or drupal_write_record().

thanks.

theamoeba’s picture

i thought of adding a cleanup function to the video_jobs::create and video_jobs::update functions but that may have other nasty ramifications...

the biggest issue for me at the moment is not so much that the video_queue table is full of duplicates but rather that in views when i add the duration field it fetches all the duplicates. distinct also doesn't work because most of the duplicates have different durations.

theamoeba’s picture

sorry I missed your preset question. the site using 3 presets:

  • mp4
    • advanced video settings are: everything is blank except for Deinterlace: Detect (default) and H.264 profile: Baseline
  • universal smartphone
    • advanced video settings are: everything is blank except for Deinterlace: Detect (default), Maximum frame rate: 30, Video bitrate: 1500 and H.264 profile: Baseline

  • webm
    • advanced video settings are: everything is blank except for Deinterlace: Detect (default) and H.264 profile: None

theamoeba’s picture

+1

theamoeba’s picture

StatusFileSize
new52.67 KB

Every time I add a video to a node it adds 5 new entries to the video_queue table. See the attached picture.

hypertext200’s picture

Status: Active » Closed (works as designed)