Recherche avancée

Sur d’autres sites (3544)

• Laravel MySQL DB not updating after long process

  11 mai 2022, par slanginbits

  I'm doing some video encoding using Laravel and FFMpeg using https://github.com/protonemedia/laravel-ffmpeg

  


  During the video conversion, I can perform some db updates to update the percentage complete in hls_percent field :

  


          $ffmpeg_cmd = FFMpeg::fromDisk('local_videos')
            ->open($video->filename)
            ->exportForHLS()
            ->toDisk('local_videos')
            ->setSegmentLength(3) // optional
            ->setKeyFrameInterval($key_interval) // optional
            ->onProgress(function ($percentage, $remaining = 0, $rate = 0) use ($id) {
                ItemVideo::where('id', $id)->update(['hls_percent' => $percentage]);                
            });


  


  This process works fine and the hls_percent value gets updated to 100 and the encoded video files are generated.

  


  After some files are moved, (takes several seconds) a final db update is not done.

  


  ItemVideo::where('id', $id)->update(['hls_complete' => 1]);


  


  The timeout only happens while encoding a large 150MB (10 min duration) mp4 file. Smaller/shorter videos complete the process without any issues.

  


  I have increased the following in php.ini

  


  memory_limit = 512M 
post_max_size =  1024M
upload_max_filesize = 1024M
max_execution_time = 2400
max_input_time = 2400
default_socket_timeout = 2400


  


  I modified the global variables in the MySQL database server to higher timeouts
as instructed here https://sebhastian.com/lost-connection-mysql-server-during-query/

  


  connect_timeout 2400
delayed_insert_timeout 300
have_statement_timeout YES
innodb_flush_log_at_timeout 1
innodb_lock_wait_timeout 50
innodb_rollback_on_timeout OFF
interactive_timeout 28800
lock_wait_timeout 31536000
mysqlx_connect_timeout 30
mysqlx_idle_worker_thread_timeout 60
mysqlx_interactive_timeout 28800
mysqlx_port_open_timeout 0
mysqlx_read_timeout 30
mysqlx_wait_timeout 28800
mysqlx_write_timeout 60
net_read_timeout 2400
net_write_timeout 2400
replica_net_timeout 2400
rpl_stop_replica_timeout 31536000
rpl_stop_slave_timeout 31536000
slave_net_timeout 2400
ssl_session_cache_timeout 2400
wait_timeout 28800


  


  apache2handler :

  


  Max Requests Per Child : 0 - Keep Alive : on - Max Per Connection : 100
Timeouts Connection : 300 - Keep-Alive : 5

  


  I'm not getting an error messages in laravel or /var/log/apache2/error.log

  


  What else am I missing ? How can I keep the MySQL connection alive to make the final update ?

  


• avutil/wchar_filename,file_open : Support long file names on Windows

  26 mai 2022, par softworkz

  avutil/wchar_filename,file_open : Support long file names on Windows
  Signed-off-by : softworkz <softworkz@hotmail.com>
  
  Signed-off-by : Martin Storsjö <martin@martin.st>
  

  • [DH] libavutil/file_open.c
  • [DH] libavutil/wchar_filename.h

• How to scroll long picture(big height) scrolling with background image in ffmpeg,Text in video products will flicker

  15 juin 2022, par user18550619

  use overlay or scoll filter,the result of video still flicker !
ffmepg cmd as follow :

  


  1.scoll filter

  


  ffmpeg -y -loop 1 -i input.png -i bg.png -filter_complex "[0]scroll=vertical=0.000819672131147541,crop=iw:1280:0:0,format=yuva444p[scrollView] ;[1][scrollView]overlay=0:0:enable='between (t,0,27.466666666666665)'" -t 27.466666666666665 E :\output1.mp4

  


  2.overlay with time change y position

  


  ffmpeg -y -r 1 -loop 1 -t 27.466666666666665 -i input.png -filter_complex "color=white:s=720x1280,fps=fps=30[bg] ;movie=bg.png[bg1] ;[bg][bg1]overlay=0:0[bg2] ;[bg2][0]overlay=y=-'t*60':shortest=1[video]" -preset ultrafast -b:v 1989k -map [video] E :\output2.mp4

  


  input.png

  


  bg.png