Recherche avancée

Médias (0)

Mot : - Tags -/serveur

Aucun média correspondant à vos critères n’est disponible sur le site.

Autres articles (69)

  • Personnaliser en ajoutant son logo, sa bannière ou son image de fond

    5 septembre 2013, par

    Certains thèmes prennent en compte trois éléments de personnalisation : l’ajout d’un logo ; l’ajout d’une bannière l’ajout d’une image de fond ;

  • Les tâches Cron régulières de la ferme

    1er décembre 2010, par

    La gestion de la ferme passe par l’exécution à intervalle régulier de plusieurs tâches répétitives dites Cron.
    Le super Cron (gestion_mutu_super_cron)
    Cette tâche, planifiée chaque minute, a pour simple effet d’appeler le Cron de l’ensemble des instances de la mutualisation régulièrement. Couplée avec un Cron système sur le site central de la mutualisation, cela permet de simplement générer des visites régulières sur les différents sites et éviter que les tâches des sites peu visités soient trop (...)

  • Les autorisations surchargées par les plugins

    27 avril 2010, par

    Mediaspip core
    autoriser_auteur_modifier() afin que les visiteurs soient capables de modifier leurs informations sur la page d’auteurs

Sur d’autres sites (10774)

  • DNN OpenCV Python using RSTP always crash after few minutes

    1er juillet 2022, par renaldyks

    Description :

    


    I want to create a people counter using DNN. The model I'm using is MobileNetSSD. The camera I use is IPCam from Hikvision. Python communicates with IPCam using the RSTP protocol.

    


    The program that I made is good and there are no bugs, when running the sample video the program does its job well. But when I replaced it with IPcam there was an unknown error.

    


    Error :

    


    Sometimes the error is :

    


    [h264 @ 000001949f7adfc0] error while decoding MB 13 4, bytestream -6
[h264 @ 000001949f825ac0] left block unavailable for requested intra4x4 mode -1
[h264 @ 000001949f825ac0] error while decoding MB 0 17, bytestream 762


    


    Sometimes the error does not appear and the program is killed.

    


    


    Update Error

    


    After revising the code, I caught the error. The error found is

    


    [h264 @ 0000019289b3fa80] error while decoding MB 4 5, bytestream -25


    


    Now I don't know what to do, because the error is not in Google.

    


    Source Code :

    


    Old Code

    


    This is my very earliest code before getting suggestions from the comments field.

    


    import time
import cv2
import numpy as np
import math
import threading

print("Load MobileNeteSSD model")

prototxt = "MobileNetSSD_deploy.prototxt"
model = "MobileNetSSD_deploy.caffemodel"

CLASSES = ["background", "aeroplane", "bicycle", "bird", "boat",
           "bottle", "bus", "car", "cat", "chair", "cow", "diningtable",
           "dog", "horse", "motorbike", "person", "pottedplant", "sheep",
           "sofa", "train", "tvmonitor"]

net = cv2.dnn.readNetFromCaffe(prototxt, model)

pos_line = 0
offset = 50
car = 0
detected = False
check = 0
prev_frame_time = 0


def detect():
    global check, car, detected
    check = 0
    if(detected == False):
        car += 1
        detected = True


def center_object(x, y, w, h):
    cx = x + int(w / 2)
    cy = y + int(h / 2)
    return cx, cy


def process_frame_MobileNetSSD(next_frame):
    global car, check, detected

    rgb = cv2.cvtColor(next_frame, cv2.COLOR_BGR2RGB)
    (H, W) = next_frame.shape[:2]

    blob = cv2.dnn.blobFromImage(next_frame, size=(300, 300), ddepth=cv2.CV_8U)
    net.setInput(blob, scalefactor=1.0/127.5, mean=[127.5, 127.5, 127.5])
    detections = net.forward()

    for i in np.arange(0, detections.shape[2]):
        confidence = detections[0, 0, i, 2]

        if confidence > 0.5:

            idx = int(detections[0, 0, i, 1])
            if CLASSES[idx] != "person":
                continue

            label = CLASSES[idx]

            box = detections[0, 0, i, 3:7] * np.array([W, H, W, H])
            (startX, startY, endX, endY) = box.astype("int")

            center_ob = center_object(startX, startY, endX-startX, endY-startY)
            cv2.circle(next_frame, center_ob, 4, (0, 0, 255), -1)

            if center_ob[0] < (pos_line+offset) and center_ob[0] > (pos_line-offset):
                # car+=1
                detect()

            else:
                check += 1
                if(check >= 5):
                    detected = False

            cv2.putText(next_frame, label+' '+str(round(confidence, 2)),
                        (startX, startY-10), cv2.FONT_HERSHEY_SIMPLEX, 1, (0, 0, 255), 2)
            cv2.rectangle(next_frame, (startX, startY),
                          (endX, endY), (0, 255, 0), 3)

    return next_frame


def PersonDetection_UsingMobileNetSSD():
    cap = cv2.VideoCapture()
    cap.open("rtsp://admin:Admin12345@192.168.100.20:554/Streaming/channels/2/")

    global car,pos_line,prev_frame_time

    frame_count = 0

    while True:
        try:
            time.sleep(0.1)
            new_frame_time = time.time()
            fps = int(1/(new_frame_time-prev_frame_time))
            prev_frame_time = new_frame_time

            ret, next_frame = cap.read()
            w_video = cap.get(cv2.CAP_PROP_FRAME_WIDTH)
            h_video = cap.get(cv2.CAP_PROP_FRAME_HEIGHT)
            pos_line = int(h_video/2)-50

            if ret == False: break

            frame_count += 1
            cv2.line(next_frame, (int(h_video/2), 0),
                     (int(h_video/2), int(h_video)), (255, 127, 0), 3)
            next_frame = process_frame_MobileNetSSD(next_frame)

            cv2.rectangle(next_frame, (248,22), (342,8), (0,0,0), -1)
            cv2.putText(next_frame, "Counter : "+str(car), (250, 20),
                        cv2.FONT_HERSHEY_SIMPLEX, 0.5, (255, 255, 255), 1)
            cv2.putText(next_frame, "FPS : "+str(fps), (0, int(h_video)-10),
                        cv2.FONT_HERSHEY_SIMPLEX, 0.5, (255, 255, 255), 1)
            cv2.imshow("Video Original", next_frame)
            # print(car)

        except Exception as e:
            print(str(e))

        if cv2.waitKey(1) & 0xFF == ord('q'): 
            break


    print("/MobileNetSSD Person Detector")


    cap.release()
    cv2.destroyAllWindows()

if __name__ == "__main__":
    t1 = threading.Thread(PersonDetection_UsingMobileNetSSD())
    t1.start()


    


    New Code

    


    I have revised my code and the program still stops taking frames. I just revised the PersonDetection_UsingMobileNetSSD() function. I've also removed the multithreading I was using. The code has been running for about 30 minutes but after a broken frame, the code will never re-execute the program block if ret == True.

    


    def PersonDetection_UsingMobileNetSSD():
    cap = cv2.VideoCapture()
    cap.open("rtsp://admin:Admin12345@192.168.100.20:554/Streaming/channels/2/")

    global car,pos_line,prev_frame_time

    frame_count = 0

    while True:
        try:
            if cap.isOpened():
                ret, next_frame = cap.read()
                if ret:
                    new_frame_time = time.time()
                    fps = int(1/(new_frame_time-prev_frame_time))
                    prev_frame_time = new_frame_time
                    w_video = cap.get(cv2.CAP_PROP_FRAME_WIDTH)
                    h_video = cap.get(cv2.CAP_PROP_FRAME_HEIGHT)
                    pos_line = int(h_video/2)-50

                    # next_frame = cv2.resize(next_frame,(720,480),fx=0,fy=0, interpolation = cv2.INTER_CUBIC)

                    if ret == False: break

                    frame_count += 1
                    cv2.line(next_frame, (int(h_video/2), 0),
                            (int(h_video/2), int(h_video)), (255, 127, 0), 3)
                    next_frame = process_frame_MobileNetSSD(next_frame)

                    cv2.rectangle(next_frame, (248,22), (342,8), (0,0,0), -1)
                    cv2.putText(next_frame, "Counter : "+str(car), (250, 20),
                                cv2.FONT_HERSHEY_SIMPLEX, 0.5, (255, 255, 255), 1)
                    cv2.putText(next_frame, "FPS : "+str(fps), (0, int(h_video)-10),
                                cv2.FONT_HERSHEY_SIMPLEX, 0.5, (255, 255, 255), 1)
                    cv2.imshow("Video Original", next_frame)
                    # print(car)
                else:
                    print("Crashed Frame")
            else:
                print("Cap is not open")

        except Exception as e:
            print(str(e))

        if cv2.waitKey(1) & 0xFF == ord('q'): 
            break


    print("/MobileNetSSD Person Detector")


    cap.release()
    cv2.destroyAllWindows()


    


    Requirement :

    


    Hardware : Intel i5-1035G1, RAM 8 GB, NVIDIA GeForce MX330

    


    Software : Python 3.6.2 , OpenCV 4.5.1, Numpy 1.16.0

    


    Question :

    


      

    1. What should i do for fixing this error ?

      2. 


    2. What causes this to happen ?

      3. 


    


    Best Regards,

    


    


    Thanks

    


  • nodejs aws lambda ffmpeg command failure

    14 juin 2022, par mozenge

    Im running an ffmpeg command to generate a thumbnail from a video that exists on aws s3 bucket but accessed from cloud front. So i try to stream the video in the command. This is implemented in nodejs and the ffmpeg dependency is a lambda layer. The code looks like so

    


    const gifName = `${baseFilename}.gif`;
await execPromise(`ffmpeg -t 10 -ss 00:00:01 -i "${_url}" ${'/tmp/' + gifName}`);


    


    _url is a clound front url. This works when i test locally even via aws SAM cli.
But this fails when testing the deployed fuction. The error output I get is as follows

    


    2022-06-13T14:07:41.079Z    35af32d2-c63f-4942-abce-3ae7dad2a6c3    INFO    stderr:  ffmpeg version 5.0.1-static https://johnvansickle.com/ffmpeg/  Copyright (c) 2000-2022 the FFmpeg developers
  built with gcc 8 (Debian 8.3.0-6)
  configuration: --enable-gpl --enable-version3 --enable-static --disable-debug --disable-ffplay --disable-indev=sndio --disable-outdev=sndio --cc=gcc --enable-fontconfig --enable-frei0r --enable-gnutls --enable-gmp --enable-libgme --enable-gray --enable-libaom --enable-libfribidi --enable-libass --enable-libvmaf --enable-libfreetype --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-librubberband --enable-libsoxr --enable-libspeex --enable-libsrt --enable-libvorbis --enable-libopus --enable-libtheora --enable-libvidstab --enable-libvo-amrwbenc --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libdav1d --enable-libxvid --enable-libzvbi --enable-libzimg
  libavutil      57. 17.100 / 57. 17.100
  libavcodec     59. 18.100 / 59. 18.100
  libavformat    59. 16.100 / 59. 16.100
  libavdevice    59.  4.100 / 59.  4.100
  libavfilter     8. 24.100 /  8. 24.100
  libswscale      6.  4.100 /  6.  4.100
  libswresample   4.  3.100 /  4.  3.100
  libpostproc    56.  3.100 / 56.  3.100
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'https://d17yrtgi5800rj.cloudfront.net/staging/videos/a66a92eb-bc31-4440-958c-07ee23e55bcb':
  Metadata:
    major_brand     : qt  
    minor_version   : 0
    compatible_brands: qt  
    creation_time   : 2022-05-03T19:50:01.000000Z
    com.apple.quicktime.location.accuracy.horizontal: 4.732124
    com.apple.quicktime.location.ISO6709: +52.3832+004.9205+018.038/
    com.apple.quicktime.make: Apple
    com.apple.quicktime.model: iPhone 13 Pro Max
    com.apple.quicktime.software: 15.4.1
    com.apple.quicktime.creationdate: 2022-05-03T21:50:01+0200
  Duration: 00:00:42.67, start: 0.000000, bitrate: 8434 kb/s
  Stream #0:0[0x1](und): Video: hevc (Main 10) (hvc1 / 0x31637668), yuv420p10le(tv, bt2020nc/bt2020/arib-std-b67), 1920x1080, 8214 kb/s, 30 fps, 30 tbr, 600 tbn (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Video
      vendor_id       : [0][0][0][0]
      encoder         : HEVC
    Side data:
      DOVI configuration record: version: 1.0, profile: 8, level: 4, rpu flag: 1, el flag: 0, bl flag: 1, compatibility id: 4
      displaymatrix: rotation of -90.00 degrees
  Stream #0:1[0x2](und): Audio: aac (LC) (mp4a / 0x6134706D), 44100 Hz, stereo, fltp, 162 kb/s (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Audio
      vendor_id       : [0][0][0][0]
  Stream #0:2[0x3](und): Data: none (mebx / 0x7862656D), 0 kb/s (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Metadata
  Stream #0:3[0x4](und): Data: none (mebx / 0x7862656D), 5 kb/s (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Metadata
  Stream #0:4[0x5](und): Data: none (mebx / 0x7862656D), 36 kb/s (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Metadata
Stream mapping:
  Stream #0:0 -> #0:0 (hevc (native) -> gif (native))
Press [q] to stop, [?] for help
[hevc @ 0x63641c0] Multiple Dolby Vision RPUs found in one AU. Skipping previous.
[hevc @ 0x6375900] Multiple Dolby Vision RPUs found in one AU. Skipping previous.
[hevc @ 0x6333600] Multiple Dolby Vision RPUs found in one AU. Skipping previous.
Output #0, gif, to '/tmp/a66a92eb-bc31-4440-958c-07ee23e55bcb.gif':
  Metadata:
    major_brand     : qt  
    minor_version   : 0
    compatible_brands: qt  
    com.apple.quicktime.creationdate: 2022-05-03T21:50:01+0200
    com.apple.quicktime.location.accuracy.horizontal: 4.732124
    com.apple.quicktime.location.ISO6709: +52.3832+004.9205+018.038/
    com.apple.quicktime.make: Apple
    com.apple.quicktime.model: iPhone 13 Pro Max
    com.apple.quicktime.software: 15.4.1
    encoder         : Lavf59.16.100
  Stream #0:0(und): Video: gif, bgr8(pc, gbr/bt2020/arib-std-b67, progressive), 1080x1920, q=2-31, 200 kb/s, 30 fps, 100 tbn (default)
    Metadata:
      creation_time   : 2022-05-03T19:50:01.000000Z
      handler_name    : Core Media Video
      vendor_id       : [0][0][0][0]
      encoder         : Lavc59.18.100 gif
    Side data:
      DOVI configuration record: version: 1.0, profile: 8, level: 4, rpu flag: 1, el flag: 0, bl flag: 1, compatibility id: 4
      displaymatrix: rotation of -0.00 degrees
frame=    1 fps=0.0 q=-0.0 size=       0kB time=00:00:00.08 bitrate=   0.0kbits/s speed=0.325x    
frame=    4 fps=0.0 q=-0.0 size=     768kB time=00:00:00.18 bitrate=34952.5kbits/s speed=0.239x    
frame=    9 fps=6.6 q=-0.0 size=    2304kB time=00:00:00.34 bitrate=55512.8kbits/s speed=0.248x    
frame=   14 fps=7.0 q=-0.0 size=    3584kB time=00:00:00.51 bitrate=57568.9kbits/s speed=0.255x    
frame=   19 fps=7.2 q=-0.0 size=    5120kB time=00:00:00.68 bitrate=61680.9kbits/s speed=0.259x    
frame=   24 fps=7.4 q=-0.0 size=    6656kB time=00:00:00.84 bitrate=64911.8kbits/s speed=0.258x    
frame=   29 fps=7.5 q=-0.0 size=    7936kB time=00:00:01.01 bitrate=64368.0kbits/s speed=0.26x    
frame=   33 fps=7.5 q=-0.0 size=    9472kB time=00:00:01.14 bitrate=68065.5kbits/s speed=0.259x    
frame=   37 fps=7.5 q=-0.0 size=   10752kB time=00:00:01.28 bitrate=68812.8kbits/s speed=0.261x    
frame=   42 fps=7.6 q=-0.0 size=   12032kB time=00:00:01.44 bitrate=68448.7kbits/s speed=0.26x    
frame=   46 fps=7.6 q=-0.0 size=   13312kB time=00:00:01.58 bitrate=69020.2kbits/s speed=0.261x    
frame=   50 fps=7.6 q=-0.0 size=   14336kB time=00:00:01.71 bitrate=68678.7kbits/s speed=0.261x    
frame=   54 fps=7.6 q=-0.0 size=   15360kB time=00:00:01.84 bitrate=68385.4kbits/s speed=0.259x    
frame=   58 fps=7.6 q=-0.0 size=   16640kB time=00:00:01.98 bitrate=68845.9kbits/s speed=0.26x    
frame=   62 fps=7.6 q=-0.0 size=   17664kB time=00:00:02.11 bitrate=68579.9kbits/s speed=0.26x    
frame=   66 fps=7.6 q=-0.0 size=   18944kB time=00:00:02.24 bitrate=69280.9kbits/s speed=0.259x    
frame=   70 fps=7.6 q=-0.0 size=   20224kB time=00:00:02.38 bitrate=69611.3kbits/s speed=0.26x    
frame=   74 fps=7.7 q=-0.0 size=   21504kB time=00:00:02.51 bitrate=70183.6kbits/s speed=0.26x    
frame=   78 fps=7.7 q=-0.0 size=   22784kB time=00:00:02.64 bitrate=70699.4kbits/s speed=0.259x    
frame=   82 fps=7.7 q=-0.0 size=   24064kB time=00:00:02.78 bitrate=70910.9kbits/s speed=0.26x    
frame=   86 fps=7.7 q=-0.0 size=   25600kB time=00:00:02.91 bitrate=72067.1kbits/s speed=0.259x    
frame=   91 fps=7.7 q=-0.0 size=   27136kB time=00:00:03.08 bitrate=72174.7kbits/s speed=0.26x    
frame=   95 fps=7.7 q=-0.0 size=   28416kB time=00:00:03.21 bitrate=72518.3kbits/s speed=0.26x    
frame=   99 fps=7.7 q=-0.0 size=   29696kB time=00:00:03.34 bitrate=72835.2kbits/s speed=0.26x    
frame=  103 fps=7.7 q=-0.0 size=   30976kB time=00:00:03.48 bitrate=72918.2kbits/s speed=0.26x    
frame=  108 fps=7.7 q=-0.0 size=   32768kB time=00:00:03.64 bitrate=73746.0kbits/s speed=0.26x    
frame=  112 fps=7.7 q=-0.0 size=   34048kB time=00:00:03.78 bitrate=73788.7kbits/s speed=0.26x    
frame=  116 fps=7.7 q=-0.0 size=   35072kB time=00:00:03.91 bitrate=73480.8kbits/s speed=0.26x    
frame=  120 fps=7.7 q=-0.0 size=   36352kB time=00:00:04.04 bitrate=73711.8kbits/s speed=0.26x    
frame=  124 fps=7.7 q=-0.0 size=   37376kB time=00:00:04.18 bitrate=73249.8kbits/s speed=0.26x    
frame=  128 fps=7.7 q=-0.0 size=   38656kB time=00:00:04.31 bitrate=73473.3kbits/s speed=0.26x    
frame=  132 fps=7.7 q=-0.0 size=   39936kB time=00:00:04.44 bitrate=73683.7kbits/s speed=0.26x    
frame=  136 fps=7.7 q=-0.0 size=   41216kB time=00:00:04.58 bitrate=73720.8kbits/s speed=0.26x    
frame=  141 fps=7.7 q=-0.0 size=   42496kB time=00:00:04.74 bitrate=73444.6kbits/s speed=0.26x    
frame=  145 fps=7.8 q=-0.0 size=   43776kB time=00:00:04.88 bitrate=73486.3kbits/s speed=0.261x    
frame=  150 fps=7.8 q=-0.0 size=   45312kB time=00:00:05.04 bitrate=73650.0kbits/s speed=0.261x    
frame=  154 fps=7.8 q=-0.0 size=   46336kB time=00:00:05.18 bitrate=73278.9kbits/s speed=0.261x    
frame=  159 fps=7.8 q=-0.0 size=   47616kB time=00:00:05.34 bitrate=73046.9kbits/s speed=0.261x    
frame=  164 fps=7.8 q=-0.0 size=   49152kB time=00:00:05.51 bitrate=73076.8kbits/s speed=0.262x    
frame=  168 fps=7.8 q=-0.0 size=   50176kB time=00:00:05.64 bitrate=72879.8kbits/s speed=0.262x    
frame=  173 fps=7.8 q=-0.0 size=   51456kB time=00:00:05.81 bitrate=72552.1kbits/s speed=0.262x    
frame=  178 fps=7.8 q=-0.0 size=   52736kB time=00:00:05.98 bitrate=72243.0kbits/s speed=0.262x    
frame=  183 fps=7.8 q=-0.0 size=   54272kB time=00:00:06.14 bitrate=72409.8kbits/s speed=0.262x    
frame=  187 fps=7.8 q=-0.0 size=   55552kB time=00:00:06.28 bitrate=72465.3kbits/s speed=0.263x    
frame=  191 fps=7.8 q=-0.0 size=   56832kB time=00:00:06.41 bitrate=72631.5kbits/s speed=0.262x    
frame=  196 fps=7.8 q=-0.0 size=   58368kB time=00:00:06.58 bitrate=72667.3kbits/s speed=0.263x    
frame=  200 fps=7.8 q=-0.0 size=   59648kB time=00:00:06.71 bitrate=72822.1kbits/s speed=0.262x    
frame=  204 fps=7.8 q=-0.0 size=   60928kB time=00:00:06.84 bitrate=72971.1kbits/s speed=0.262x    
frame=  208 fps=7.8 q=-0.0 size=   62208kB time=00:00:06.98 bitrate=73009.7kbits/s speed=0.262x    
frame=  212 fps=7.8 q=-0.0 size=   63488kB time=00:00:07.11 bitrate=73149.6kbits/s speed=0.262x    
frame=  216 fps=7.8 q=-0.0 size=   64768kB time=00:00:07.24 bitrate=73284.5kbits/s speed=0.262x    
frame=  220 fps=7.8 q=-0.0 size=   66048kB time=00:00:07.38 bitrate=73315.1kbits/s speed=0.262x    
frame=  224 fps=7.8 q=-0.0 size=   67072kB time=00:00:07.51 bitrate=73163.0kbits/s speed=0.262x    
frame=  228 fps=7.8 q=-0.0 size=   68352kB time=00:00:07.64 bitrate=73290.5kbits/s speed=0.262x    
frame=  232 fps=7.8 q=-0.0 size=   69632kB time=00:00:07.78 bitrate=73319.5kbits/s speed=0.262x    
frame=  236 fps=7.8 q=-0.0 size=   70912kB time=00:00:07.91 bitrate=73440.1kbits/s speed=0.262x    
frame=  240 fps=7.8 q=-0.0 size=   72192kB time=00:00:08.04 bitrate=73556.8kbits/s speed=0.262x    
frame=  245 fps=7.8 q=-0.0 size=   73728kB time=00:00:08.21 bitrate=73566.4kbits/s speed=0.262x    
frame=  249 fps=7.8 q=-0.0 size=   75008kB time=00:00:08.34 bitrate=73676.9kbits/s speed=0.262x    
frame=  253 fps=7.8 q=-0.0 size=   76288kB time=00:00:08.48 bitrate=73697.1kbits/s speed=0.262x    
frame=  257 fps=7.8 q=-0.0 size=   77568kB time=00:00:08.61 bitrate=73802.2kbits/s speed=0.262x    
frame=  261 fps=7.8 q=-0.0 size=   78848kB time=00:00:08.74 bitrate=73904.2kbits/s speed=0.262x    
frame=  265 fps=7.8 q=-0.0 size=   80128kB time=00:00:08.88 bitrate=73919.9kbits/s speed=0.262x    
frame=  269 fps=7.8 q=-0.0 size=   81152kB time=00:00:09.01 bitrate=73784.4kbits/s speed=0.262x    
frame=  273 fps=7.8 q=-0.0 size=   82432kB time=00:00:09.14 bitrate=73882.2kbits/s speed=0.262x    
frame=  278 fps=7.8 q=-0.0 size=   83712kB time=00:00:09.31 bitrate=73659.4kbits/s speed=0.262x    
frame=  282 fps=7.8 q=-0.0 size=   84992kB time=00:00:09.44 bitrate=73755.8kbits/s speed=0.262x    
frame=  287 fps=7.8 q=-0.0 size=   86784kB time=00:00:09.61 bitrate=73978.6kbits/s speed=0.262x    
frame=  291 fps=7.8 q=-0.0 size=   88064kB time=00:00:09.74 bitrate=74067.8kbits/s speed=0.262x    
frame=  295 fps=7.8 q=-0.0 size=   89344kB time=00:00:09.88 bitrate=74079.6kbits/s speed=0.262x    
frame=  299 fps=7.8 q=-0.0 size=   90624kB time=00:00:10.01 bitrate=74165.0kbits/s speed=0.262x    
frame=  300 fps=7.8 q=-0.0 Lsize=   91358kB time=00:00:10.04 bitrate=74542.5kbits/s speed=0.261x    
video:91358kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: 0.000021%


    


    Any ideas what might be wrong ?

    


  • Paperclip with heroku and paperclip, migration fails

    2 décembre 2013, par jdartland

    I have a created ruby on rails application and I'm using paperclip to handle my file uploads.
    Paperclip works just fine on my local machine. But my video upload stops working when I deploy to Heroku. Does anyone know whats going wrong. I also get an error when I try to upload a video which says that the video filename does not exist. The photo upload works but not the Video, I'm using paperclip iwth nested attributes and ffmpeg.

    Upload Error log :

    Paperclip::Error (Asset model missing required attr_accessor for 'video_file_name')
    
2013-12-02T14:38:16.867747+00:00 app[web.1]: Paperclip::Error (Asset model missing required attr_accessor for 'video_file_name'):
    
2013-12-02T14:38:16.867747+00:00 app[web.1]:   app/controllers/projects_controller.rb:60:in `block in update'
    
2013-12-02T14:38:16.867747+00:00 app[web.1]:   app/controllers/projects_controller.rb:59:in `update'

    Here is my migration error :

    Migrating to AddAttachmentPhotoToAssets (20131021134721)
    
==  AddAttachmentPhotoToAssets: migrating =====================================
    
-- change_table(:assets)
    
   -> 0.0273s
    
==  AddAttachmentPhotoToAssets: migrated (0.0276s) ============================
    

    
Migrating to AddProjectIdToAssets (20131022082744)
    
-- add_column(:assets, :project_id, :integer)
    
PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
    
: ALTER TABLE "assets" ADD COLUMN "project_id" integer
    
-- add_column(:assets, :project_id, :integer)
    
PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
    
: ALTER TABLE "assets" ADD COLUMN "project_id" integer
    
rake aborted!
    
PG::DuplicateColumn: ERROR:  column "project_id" of relation "assets" already exists
    
: ALTER TABLE "assets" ADD COLUMN "project_id" integer
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `exec'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:425:in `block in log'
    
/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_adapter.rb:420:in `log'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract/schema_statements.rb:360:in `add_column'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/connection_adapters/postgresql/schema_statements.rb:379:in `add_column'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:625:in `block in method_missing'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:597:in `block in say_with_time'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:597:in `say_with_time'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:617:in `method_missing'
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:383:in `method_missing'
    
/app/db/migrate/20131022082744_add_project_id_to_assets.rb:2:in `'
    
/app/db/migrate/20131022082744_add_project_id_to_assets.rb:1:in `<top>&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `require&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `block in require&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:213:in `load_dependency&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activesupport-4.0.0/lib/active_support/dependencies.rb:228:in `require&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:718:in `load_migration&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:714:in `migration&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:708:in `disable_ddl_transaction&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:1012:in `use_transaction?&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:922:in `rescue in block in migrate&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:919:in `block in migrate&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:916:in `each&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:916:in `migrate&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:764:in `up&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/migration.rb:742:in `migrate&#39;
    
/app/vendor/bundle/ruby/2.0.0/gems/activerecord-4.0.0/lib/active_record/railties/databases.rake:42:in `block (2 levels) in <top>&#39;
    
Tasks: TOP => db:migrate
    
(See full trace by running task with --trace)
    
</top></top>

    Here is my table :

     create_table "assets", force: true do |t|
    
    t.datetime "created_at"
    
    t.datetime "updated_at"
    
    t.string   "photo_file_name"
    
    t.string   "photo_content_type"
    
    t.integer  "photo_file_size"
    
    t.datetime "photo_updated_at"
    
    t.integer  "project_id"
    
    t.string   "video_file_name"
    
    t.string   "video_content_type"
    
    t.integer  "video_file_size"
    
    t.datetime "video_updated_at"
    
  end
    
add_index "projects", ["permalink"], name: "index_projects_on_permalink", using: :btree
    

    
  create_table "settings", force: true do |t|
    
    t.string   "title"
    
    t.text     "description"
    
    t.text     "paragraph"
    
    t.datetime "created_at"
    
    t.datetime "updated_at"
    
    t.string   "photo_file_name"
    
    t.string   "photo_content_type"
    
    t.integer  "photo_file_size"
    
    t.datetime "photo_updated_at"
    
    t.string   "video_file_name"
    
    t.string   "video_content_type"
    
    t.integer  "video_file_size"
    
    t.datetime "video_updated_at"
    
  end

    Would gladly need some help ! :)

Navigation