stakwork / sphinx-nav-fiber

10 stars 45 forks source link

Failed to load audio #361

Open kevkevinpal opened 10 months ago

kevkevinpal commented 10 months ago

sometimes after clicking through a few clips on second brain we get a Failed to load audio error

tomsmith8 commented 10 months ago

I've also noticed this by tapping on an audio file (and not just bouncing around).

It also seems to be all older clips not loading for example in 2022.

tomsmith8 commented 9 months ago

@kevkevinpal Rasul looked into it and thinks it may be a permission issue, or problem with file in s3. Can you look into it?

kevkevinpal commented 9 months ago

So I started to take a look at this issue and it seems the problem is that some of the clips simply don't exist in the s3 bucket, I'm not sure where they went but they are not there

for example if you go into s3 and look up this, it will not be there

https://stakwork-uploads.s3.amazonaws.com/uploads/customers/2707/media_to_local/4e00853b-49e3-4b46-bd13-bf7f2aa25905/56f0089c-a7f2-4b1b-8576-a3e4ddb9791f.mp3

but this one for example does exist

https://s3.amazonaws.com/stakwork-uploads/uploads/customers/4291/media_to_local/44216ce7-c473-4326-a572-8f6a4ec6306e/8PQsw144cFc.mp4

So next steps would either to be deleting those values from jarvis or adding those clips manually to s3 to resolve the issue. We probably want to make sure this isn't happening for new clips we are adding aswell

tomsmith8 commented 9 months ago

We need to find out if it happening to new clips first - Can we find out the last clip with an error easily?

kevkevinpal commented 9 months ago

we uploaded new content

"video_url": "
https://s3.amazonaws.com/stakwork-uploads/uploads/customers/4291/media_to_local/7f4dd7e1-f560-4913-8ec0-258b148b0ed9/dhbWFR_8jWI.mp4
",
      "audio_url": "
https://s3.amazonaws.com/stakwork-uploads/uploads/customers/4291/media_to_local/7f4dd7e1-f560-4913-8ec0-258b148b0ed9/dhbWFR_8jWI.mp3
" 

and the video is https://www.youtube.com/watch?v=dhbWFR_8jWI&ab_channel=AntonioHdz title: Actualización Erlay Bitcoin 🔥🔥🔥

lets look this up in the graph after the add node job finishes

kevkevinpal commented 9 months ago

We should also get a list of failing links from the neo4j db by querying all the nodes and then returning the one which the fetch for the link fails and then we can either manually fix them or delete them from neo4j

tomsmith8 commented 9 months ago

I don't see this in the graph but it may have failed in Stakwork..

tomsmith8 commented 9 months ago

Based on adding new content for swarm12's SB, we are storing new content. Would be good to run the failed fetch query on the main graph to see:

  1. How many fail
  2. Is there a time pattern (between certain dates?)