Advertisement
seeker_dsr

Untitled

Jan 23rd, 2018
589
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.77 KB | None | 0 0
  1. mysql> select * from inputs where job_id=17555869\G
  2. *************************** 1. row ***************************
  3. id: 17652709
  4. job_id: 17555869
  5. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q3.mp4
  6. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":1475,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"1340","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":1018123204,"format":"mp4","video_start_time":0.04}
  7. created_at: 2018-01-22 15:46:11
  8. updated_at: 2018-01-22 15:49:42
  9. *************************** 2. row ***************************
  10. id: 17652717
  11. job_id: 17555869
  12. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q2.mp4
  13. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":952,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"817","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":657306206,"format":"mp4","video_start_time":0.04}
  14. created_at: 2018-01-22 15:46:11
  15. updated_at: 2018-01-22 15:51:52
  16. *************************** 3. row ***************************
  17. id: 17652725
  18. job_id: 17555869
  19. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q1.mp4
  20. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":491,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"388","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"95","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":339189857,"format":"mp4","video_start_time":0.04}
  21. created_at: 2018-01-22 15:46:11
  22. updated_at: 2018-01-22 15:53:01
  23. *************************** 4. row ***************************
  24. id: 17652733
  25. job_id: 17555869
  26. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q0.mp4
  27. metadata: {"channels":1,"duration_in_ms":5520050,"total_bitrate_in_kbps":65,"video_streams":[],"audio_streams":[{"map":"0:0","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"64","duration":5520.0,"channels":2}],"rotate":null,"file_size_in_bytes":45112655,"format":"mp4","video_start_time":0.0}
  28. created_at: 2018-01-22 15:46:11
  29. updated_at: 2018-01-22 15:53:14
  30. *************************** 5. row ***************************
  31. id: 17652741
  32. job_id: 17555869
  33. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-qx720.mp4
  34. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":3492,"video_streams":[{"map":"0:0","video_codec":"h264","width":"1280","height":"720","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"3358","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":2410174200,"format":"mp4","video_start_time":0.04}
  35. created_at: 2018-01-22 15:46:11
  36. updated_at: 2018-01-22 16:00:57
  37. 5 rows in set (0.00 sec)
  38.  
  39. mysql> select * from outputs where job_id=17555869\G
  40. *************************** 1. row ***************************
  41. id: 136863989
  42. job_id: 17555869
  43. url: NULL
  44. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q3.mp4","mkdir_mode":"0777"}
  45. created_at: 2018-01-22 15:46:11
  46. updated_at: 2018-01-22 15:46:11
  47. metadata: NULL
  48. *************************** 2. row ***************************
  49. id: 136863997
  50. job_id: 17555869
  51. url: NULL
  52. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q2.mp4","thumbnails":{"number":100,"presets":{"norm":"-brightness-contrast 8x20"}},"mkdir_mode":"0777"}
  53. created_at: 2018-01-22 15:46:11
  54. updated_at: 2018-01-22 15:46:11
  55. metadata: NULL
  56. *************************** 3. row ***************************
  57. id: 136864005
  58. job_id: 17555869
  59. url: NULL
  60. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q1.mp4","sample":[{"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-preview.mp4","dir":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/","from":30,"duration":4}],"mkdir_mode":"0777"}
  61. created_at: 2018-01-22 15:46:11
  62. updated_at: 2018-01-22 15:46:11
  63. metadata: NULL
  64. *************************** 4. row ***************************
  65. id: 136864013
  66. job_id: 17555869
  67. url: NULL
  68. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q0.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q0.mp4","mkdir_mode":"0777"}
  69. created_at: 2018-01-22 15:46:11
  70. updated_at: 2018-01-22 15:46:11
  71. metadata: NULL
  72. *************************** 5. row ***************************
  73. id: 136864021
  74. job_id: 17555869
  75. url: NULL
  76. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-qx720.mp4","mkdir_mode":"0777"}
  77. created_at: 2018-01-22 15:46:11
  78. updated_at: 2018-01-22 15:46:11
  79. metadata: NULL
  80. *************************** 6. row ***************************
  81. id: 136864029
  82. job_id: 17555869
  83. url: NULL
  84. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.f4m","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"no_fragments":true,"drm":"adobe","fragment_duration":30,"mkdir_mode":"0777","pkg_config":"drm/inventos.xml","ls_url":"http://drm.videomore.ru:8080/flashaccessserver/sampletenant","policy_file":"/home/converter_api/releases/20171024122000/drm/default.pol"}
  85. created_at: 2018-01-22 15:46:11
  86. updated_at: 2018-01-22 15:46:11
  87. metadata: NULL
  88. *************************** 7. row ***************************
  89. id: 136864037
  90. job_id: 17555869
  91. url: NULL
  92. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.wvm","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"drm":"widevine","mkdir_mode":"0777","content_id":"videomore_production_job_17555869_a516e41590ea41ebddc3ff37fd9b5d1b-q3_a516e41590ea41ebddc3ff37fd9b5d1b-q2_a516e41590ea41ebddc3ff37fd9b5d1b-q1_a516e41590ea41ebddc3ff37fd9b5d1b-qx720","provider":"inventosvideomore","pkg_url":"http://wv-packagerk-1.videomore.ru","pkg_scp":"root@wv-packagerk-1.videomore.ru"}
  93. created_at: 2018-01-22 15:46:11
  94. updated_at: 2018-01-22 15:46:11
  95. metadata: NULL
  96. *************************** 8. row ***************************
  97. id: 136864045
  98. job_id: 17555869
  99. url: NULL
  100. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.mpd","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"drm":"widevine","mkdir_mode":"0777","content_id":"videomore_production_job_17555869_a516e41590ea41ebddc3ff37fd9b5d1b-q3_a516e41590ea41ebddc3ff37fd9b5d1b-q2_a516e41590ea41ebddc3ff37fd9b5d1b-q1_a516e41590ea41ebddc3ff37fd9b5d1b-qx720","provider":"inventosvideomore","iv":"39e4cde027ce6671c3b61795ec355f77","key":"9c019260bb4881303bccdde14dbece86b3ad77da55a725e1373c87343aafacd6","ls_url":"https://license.widevine.com/cenc/getcontentkey/inventosvideomore"}
  101. created_at: 2018-01-22 15:46:11
  102. updated_at: 2018-01-22 15:46:11
  103. metadata: NULL
  104. *************************** 9. row ***************************
  105. id: 136864053
  106. job_id: 17555869
  107. url: NULL
  108. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/a516e41590ea41ebddc3ff37fd9b5d1b-preview.f4m","no_fragments":true,"type":"playlist","index_directory":"/a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/a516e41590ea41ebddc3ff37fd9b5d1b-preview.mp4","bandwidth":496}],"mkdir_mode":"0777"}
  109. created_at: 2018-01-22 15:46:11
  110. updated_at: 2018-01-22 15:46:11
  111. metadata: NULL
  112. 9 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement