Recherche avancée

Sur d’autres sites (6039)

• Evolution #3771 : Ne plus mettre en cache la page 404

  27 avril 2016, par - Equipement

  Avec le squelette 404 de la dist (qui reste en cache), la trace des requêtes SQL sur le second appel (afin que la page soit prise dans le cache) sur le site public d’une page qui n’existe pas, donne les résultats suivants (sous SPIP 3.0.22) :

  "set sql_mode=’’" 
  "SELECT valeur FROM `nomdelabase`.spip_meta WHERE nom=’charset_sql_connexion’" 
  "SET NAMES ’utf8’" 
  "SHOW TABLES LIKE ’spip\\_%’" 
  "SHOW CREATE TABLE `spip_rubriques`" 
  "SHOW CREATE TABLE `spip_articles`" 
  "SHOW CREATE TABLE `spip_auteurs`" 
  "SHOW CREATE TABLE `spip_mots`" 
  "SHOW CREATE TABLE `spip_syndic`" 
  "SELECT * FROM `nomdelabase`.spip_meta WHERE nom=’pcre_u’" 
  

  suivi immédiatement les requêtes de la tâche de fond :
  

  "set sql_mode=’’" 
  "SELECT valeur FROM `nomdelabase`.spip_meta WHERE nom=’charset_sql_connexion’" 
  "SET NAMES ’utf8’" 
  "SELECT * FROM `nomdelabase`.spip_jobs WHERE status=1 AND date<=’2016-04-27 15:26:01’ ORDER BY priorite DESC,date LIMIT 0,201" 
  "DELETE FROM `nomdelabase`.spip_jobs
  "SHOW CREATE TABLE `spip_jobs`" 
  "INSERT INTO spip_jobs (id_job,descriptif,fonction,args,md5args,inclure,priorite,date,status) VALUES (320,’Tâche CRON syndic (toutes les 90s)’,’syndic’,’a:1 :i:0 ...
  "SELECT id_syndic FROM `nomdelabase`.spip_syndic WHERE ((syndication  IN (’sus’,’off’))) AND statut<>’refuse’ AND NOT((date_syndic>DATE_SUB(’2016-04-27 15:26:01’, INTERVAL 1440 MINUTE))) ORDER BY date_syndic LIMIT 1" 
  "SELECT id_syndic FROM `nomdelabase`.spip_syndic WHERE syndication=’oui’ AND statut<>’refuse’ AND NOT((date_syndic>DATE_SUB(’2016-04-27 15:26:01’, INTERVAL 120 MINUTE))) ORDER BY date_syndic LIMIT 1" 
  "SELECT id_job FROM `nomdelabase`.spip_jobs WHERE status=1 AND fonction=’syndic’" 
  "INSERT INTO spip_jobs (fonction,descriptif,args,md5args,inclure,priorite,date,status) VALUES (’syndic’,’Tâche CRON syndic (toutes les 90 s)’,’a:1 :i:0
  "SELECT id_job FROM `nomdelabase`.spip_jobs WHERE id_job<321 AND status=1 AND fonction=’syndic’" 
  "SELECT * FROM `nomdelabase`.spip_jobs WHERE status=0 AND date<’2016-04-27 15:23:01’" 
  "SELECT date FROM `nomdelabase`.spip_jobs WHERE status=1 ORDER BY date LIMIT 0,1" 
  "SELECT COUNT(*) FROM `nomdelabase`.spip_jobs WHERE status=1 AND date<’2016-04-27 15:26:01’" 
  "DELETE FROM `nomdelabase`.spip_jobs_liens WHERE id_job=320" 
  "DELETE FROM `nomdelabase`.spip_jobs
  

  Visiblement, si la page 404 reste dans le cache, il y a quand même une connexion à Mysql (suivie d’une seconde pour la tâche de fond).

• Ffmpeg generated movie (png -> mp4) has no video

  21 avril 2016, par ILiveForVR

  I have a whole bunch of png’s which I would like to convert into a mp4 video.
  I am using the following command to stich them together :
  ffmpeg -i _2016-04-20_14-51-00-500_%06d.png -pix_fmt yuv420p movie.mp4

  I am getting a file, which has a size so it isn’t empty. But when I play it in VLC or Quicktime it shows the time going by, but it has no video in it. Any idea what I’m doing wrong ?
  I also tried :

  ffmpeg -framerate 1/5 -i _2016-04-20_14-51-00-500_%06d.png -c:v libx264 -r 30 -pix_fmt yuv420p out.mp4

  and

  ffmpeg -r 45 -f image2 -s 1920x1080 -i _2016-04-20_14-51-00-500_%06d.png -vcodec libx264 -crf 25  -pix_fmt yuv420p test.mp4

  But still no video.
  This is the commandline output :

  >ffmpeg -i _2016-04-20_14-51-00-500_%06d.png -pix_fmt yuv420p movie.mp4
  
  ffmpeg version N-79546-g13406b6 Copyright (c) 2000-2016 the FFmpeg developers
  
    built with gcc 5.3.0 (GCC)
  
    configuration: --enable-gpl --enable-version3 --disable-w32threads --enable-avisynth --enable-bzlib --enable-fontconfig --enable-frei0r --enable-gnutls --enable-iconv --enable-libass --enable-libbluray --enable-libbs2b --enable-libcaca --enable-libfreetype --enable-libgme --enable-libgsm --enable-libilbc --enable-libmodplug --enable-libmfx --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-libopus --enable-librtmp --enable-libschroedinger --enable-libsnappy --enable-libsoxr --enable-libspeex --enable-libtheora --enable-libtwolame --enable-libvidstab --enable-libvo-amrwbenc --enable-libvorbis --enable-libvpx --enable-libwavpack --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxavs --enable-libxvid --enable-libzimg --enable-lzma --enable-decklink --enable-zlib
  
    libavutil      55. 22.100 / 55. 22.100
  
    libavcodec     57. 35.100 / 57. 35.100
  
    libavformat    57. 34.102 / 57. 34.102
  
    libavdevice    57.  0.101 / 57.  0.101
  
    libavfilter     6. 44.100 /  6. 44.100
  
    libswscale      4.  1.100 /  4.  1.100
  
    libswresample   2.  0.101 /  2.  0.101
  
    libpostproc    54.  0.100 / 54.  0.100
  
  Input #0, image2, from '_2016-04-20_14-51-00-500_%06d.png':
  
    Duration: 00:00:02.60, start: 0.000000, bitrate: N/A
  
      Stream #0:0: Video: png, rgba(pc), 8192x4096 [SAR 3779:3779 DAR 2:1], 25 tbr, 25 tbn
  
  [libx264 @ 00000000025851e0] using SAR=1/1
  
  [libx264 @ 00000000025851e0] frame MB size (512x256) > level limit (36864)
  
  [libx264 @ 00000000025851e0] DPB size (4 frames, 524288 mbs) > level limit (1 frames, 184320 mbs)
  
  [libx264 @ 00000000025851e0] MB rate (3276800) > level limit (2073600)
  
  [libx264 @ 00000000025851e0] using cpu capabilities: MMX2 SSE2Fast SSSE3 SSE4.2 AVX FMA3 AVX2 LZCNT BMI2
  
  [libx264 @ 00000000025851e0] profile High, level 5.2
  
  [libx264 @ 00000000025851e0] 264 - core 148 r2665 a01e339 - H.264/MPEG-4 AVC codec - Copyleft 2003-2016 - http://www.videolan.org/x264.html - options: cabac=1 ref=3 deblock=1:0:0 analyse=0x3:0x113 me=hex subme=7 psy=1 psy_rd=1.00:0.00 mixed_ref=1 me_range=16 chroma_me=1 trellis=1 8x8dct=1 cqm=0 deadzone=21,11 fast_pskip=1 chroma_qp_offset=-2 threads=18 lookahead_threads=3 sliced_threads=0 nr=0 decimate=1 interlaced=0 bluray_compat=0 constrained_intra=0 bframes=3 b_pyramid=2 b_adapt=1 b_bias=0 direct=1 weightb=1 open_gop=0 weightp=2 keyint=250 keyint_min=25 scenecut=40 intra_refresh=0 rc_lookahead=40 rc=crf mbtree=1 crf=23.0 qcomp=0.60 qpmin=0 qpmax=69 qpstep=4 ip_ratio=1.40 aq=1:1.00
  
  [mp4 @ 0000000002583fc0] Using AVStream.codec to pass codec parameters to muxers is deprecated, use AVStream.codecpar instead.
  
  Output #0, mp4, to 'movie.mp4':
  
    Metadata:
  
      encoder         : Lavf57.34.102
  
      Stream #0:0: Video: h264 ([33][0][0][0] / 0x0021), yuv420p, 8192x4096 [SAR 1:1 DAR 2:1], q=2-31, 25 fps, 12800 tbn
  
      Metadata:
  
        encoder         : Lavc57.35.100 libx264
  
      Side data:
  
        cpb: bitrate max/min/avg: 0/0/0 buffer size: 0 vbv_delay: -1
  
  Stream mapping:
  
    Stream #0:0 -> #0:0 (png (native) -> h264 (libx264))
  
  Press [q] to stop, [?] for help
  
  frame=   65 fps=3.2 q=-1.0 Lsize=   13498kB time=00:00:02.48 bitrate=44585.2kbits/s speed=0.123x    6x
  
  video:13497kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: 0.009971%
  
  [libx264 @ 00000000025851e0] frame I:1     Avg QP:16.71  size:1373751
  
  [libx264 @ 00000000025851e0] frame P:52    Avg QP:23.59  size:234822
  
  [libx264 @ 00000000025851e0] frame B:12    Avg QP:21.17  size: 19609
  
  [libx264 @ 00000000025851e0] consecutive B-frames: 73.8%  3.1%  4.6% 18.5%
  
  [libx264 @ 00000000025851e0] mb I  I16..4: 14.7% 73.8% 11.5%
  
  [libx264 @ 00000000025851e0] mb P  I16..4:  3.1%  5.9%  0.5%  P16..4: 23.2%  7.7%  2.0%  0.0%  0.0%    skip:57.5%
  
  [libx264 @ 00000000025851e0] mb B  I16..4:  0.1%  0.1%  0.0%  B16..8:  9.0%  0.2%  0.0%  direct: 0.2%  skip:90.3%  L0:33.0% L1:66.6% BI: 0.4%
  
  [libx264 @ 00000000025851e0] 8x8 transform intra:63.5% inter:78.5%
  
  [libx264 @ 00000000025851e0] coded y,uvDC,uvAC intra: 33.7% 3.1% 1.0% inter: 10.1% 0.4% 0.0%
  
  [libx264 @ 00000000025851e0] i16 v,h,dc,p: 24% 57%  3% 17%
  
  [libx264 @ 00000000025851e0] i8 v,h,dc,ddl,ddr,vr,hd,vl,hu: 14% 31% 38%  2%  3%  2%  5%  2%  4%
  
  [libx264 @ 00000000025851e0] i4 v,h,dc,ddl,ddr,vr,hd,vl,hu: 12% 63% 10%  2%  2%  1%  5%  1%  4%
  
  [libx264 @ 00000000025851e0] i8c dc,h,v,p: 94%  2%  3%  0%
  
  [libx264 @ 00000000025851e0] Weighted P-Frames: Y:0.0% UV:0.0%
  
  [libx264 @ 00000000025851e0] ref P L0: 71.6% 13.1% 10.8%  4.4%
  
  [libx264 @ 00000000025851e0] ref B L0: 69.0% 30.6%  0.4%
  
  [libx264 @ 00000000025851e0] ref B L1: 89.7% 10.3%
  
  [libx264 @ 00000000025851e0] kb/s:42522.38

• avconv : from multiple png to movie not exporting correctly

  13 avril 2016, par abhra

  I am trying to generate a mp4 movie from a set of pngs using avconv on my debian8 system. The mp4 file its generating basically looping over the first figure for some time. Here is the command I am using

  avconv -r 10 -start_number 8 -i images_%06d.png -b:v 1000k -vf scale=640 :-1 test.mp4

  Output is

  avconv version 11.6-6:11.6-1 deb8u1, Copyright (c) 2000-2014 the Libav developers built on Mar 2 2016 23:00:02 with gcc 4.9.2
  (Debian 4.9.2-10) Input #0, image2, from ’images_%06d.png’ :
  Duration : 00:00:16.00, start : 0.000000, bitrate : N/A
  Stream #0.0 : Video : png, rgb24, 2400x1801, 25 fps, 25 tbn File ’test.mp4’ already exists. Overwrite ? [y/N] y [scale @ 0x820c60] The
  ::flags= option syntax is deprecated. Use either
  : : or w=:h=:flags=. [libx264 @ 0x837760]
  using cpu capabilities : MMX2 SSE2Fast SSSE3 SSE4.2 AVX AVX2 FMA3 LZCNT
  BMI2 [libx264 @ 0x837760] profile High, level 2.2 [libx264 @ 0x837760]
  264 - core 142 r2431 a5831aa - H.264/MPEG-4 AVC codec - Copyleft
  2003-2014 - http://www.videolan.org/x264.html - options : cabac=1 ref=3
  deblock=1:0:0 analyse=0x3:0x113 me=hex subme=7 psy=1 psy_rd=1.00:0.00
  mixed_ref=1 me_range=16 chroma_me=1 trellis=1 8x8dct=1 cqm=0
  deadzone=21,11 fast_pskip=1 chroma_qp_offset=-2 threads=12
  lookahead_threads=2 sliced_threads=0 nr=0 decimate=1 interlaced=0
  bluray_compat=0 constrained_intra=0 bframes=3 b_pyramid=2 b_adapt=1
  b_bias=0 direct=1 weightb=1 open_gop=0 weightp=2 keyint=250
  keyint_min=10 scenecut=40 intra_refresh=0 rc_lookahead=40 rc=abr
  mbtree=1 bitrate=1000 ratetol=1.0 qcomp=0.60 qpmin=0 qpmax=69 qpstep=4
  ip_ratio=1.40 aq=1:1.00 Output #0, mp4, to ’test.mp4’ : Metadata :
  encoder : Lavf56.1.0
  Stream #0.0 : Video : libx264, yuv420p, 640x480, q=-1—1, 1000 kb/s, 10 fps, 10 tbn, 10 tbc
  Metadata :
  encoder : Lavc56.1.0 libx264 Stream mapping : Stream #0:0 -> #0:0 (png (native) -> h264 (libx264)) Press ctrl-c to stop encoding frame= 17 fps= 0 q=0.0 size= 0kB time=10000000000.00
  bitrate= 0.0kbitframe= 34 fps= 32 q=0.0 size= 0kB
  time=10000000000.00 bitrate= 0.0kbitframe= 51 fps= 32 q=0.0 size=
  0kB time=10000000000.00 bitrate= 0.0kbitframe= 393 fps= 32 q=0.0
  Lsize= 139kB time=39.00 bitrate= 29.2kbits/s video:132kB
  audio:0kB other streams:0kB global headers:0kB muxing overhead :
  5.284794% [libx264 @ 0x837760] frame I:2 Avg QP : 3.69 size : 51320 [libx264 @ 0x837760] frame P:99 Avg QP : 0.32 size : 242 [libx264
  @ 0x837760] frame B:292 Avg QP : 0.15 size : 26 [libx264 @
  0x837760] consecutive B-frames : 0.8% 0.5% 0.0% 98.7% [libx264 @
  0x837760] mb I I16..4 : 45.5% 19.2% 35.3% [libx264 @ 0x837760] mb P
  I16..4 : 0.0% 0.0% 0.0% P16..4 : 0.9% 0.0% 0.0% 0.0% 0.0%
  skip:99.0% [libx264 @ 0x837760] mb B I16..4 : 0.0% 0.0% 0.0%
  B16..8 : 0.2% 0.0% 0.0% direct : 0.0% skip:99.8% L0:22.3% L1:77.7%
  BI : 0.0% [libx264 @ 0x837760] final ratefactor : -21.09 [libx264 @
  0x837760] 8x8 transform intra:18.9% inter:41.7% [libx264 @ 0x837760]
  coded y,uvDC,uvAC intra : 34.1% 0.0% 0.0% inter : 0.1% 0.0% 0.0%
  [libx264 @ 0x837760] i16 v,h,dc,p : 81% 14% 5% 0% [libx264 @
  0x837760] i8 v,h,dc,ddl,ddr,vr,hd,vl,hu : 49% 14% 36% 0% 0% 0% 0%
  0% 0% [libx264 @ 0x837760] i4 v,h,dc,ddl,ddr,vr,hd,vl,hu : 36% 28% 19%
  3% 3% 2% 4% 2% 3% [libx264 @ 0x837760] i8c dc,h,v,p : 100% 0% 0%
  0% [libx264 @ 0x837760] Weighted P-Frames : Y:0.0% UV:0.0% [libx264 @
  0x837760] ref P L0 : 99.3% 0.0% 0.6% 0.1% [libx264 @ 0x837760] ref B
  L0 : 4.2% 95.8% [libx264 @ 0x837760] ref B L1 : 99.8% 0.2% [libx264 @
  0x837760] kb/s:27.34

  I have also tried

  cat *.png | avconv -f image2pipe -i - -b:v 1000k -vf scale=640 :-1 test2.mp4

  output shows

  avconv version 11.6-6:11.6-1 deb8u1, Copyright (c) 2000-2014 the Libav developers built on Mar 2 2016 23:00:02 with gcc 4.9.2
  (Debian 4.9.2-10) Codec AVOption b (set bitrate (in bits/s)) specified
  for output file #0 (test2.mp4) has not been used for any stream. The
  most likely reason is either wrong type (e.g. a video option with no
  video streams) or that it is a private option of some encoder which
  was not actually used for any stream. Output #0, image2pipe, to
  ’test2.mp4’ : Output file #0 does not contain any stream

  When getting frames fromtest.mp4

  avconv -i test.mp4 -r 30 -f image2 %04d.png

  I found 1000 or more copies of the images_000001.png.

  Would you please help, whether I have made any mistake in commands ? Or am I missing some codec options ? Thanks for the help.