Not all videos transferred for a channel (Reprocessing doesn't help) #69

New issue

Closed

opened 2020-08-10 23:52:27 +02:00 by tzarebczan · 2 comments

tzarebczan commented

2020-08-10 23:52:27 +02:00

(Migrated from github.com)

select yt.id,yt.desired_lbry_channel, yt.failure_reason,yt.total_subscribers, yt.status, yt.transferred_at, yt.transfer_state, sum(if(sv.transferred = 1, 1, 0)) as transferred, sum(if( sv.transferred=0, 1, 0)) as not_transferred from youtube_data yt
inner join synced_video sv on sv.youtube_data_id = yt.id 
where yt.transfer_state = 2 and yt.is_deleted_on_youtube = 0 and channel_publish_id is not null
and sv.status = 'published'
group by yt.id
having not_transferred > 0 and transferred > 0;

There's a little over 100 channels where only some of the videos were transferred, and not all. I re-ran these in state 1, pending upgrade, but it only fixed some of them, and in other cases, only transferred a little more content. My guess is we aren't processing/listing them all somewhere or limiting to last X. ``` select yt.id,yt.desired_lbry_channel, yt.failure_reason,yt.total_subscribers, yt.status, yt.transferred_at, yt.transfer_state, sum(if(sv.transferred = 1, 1, 0)) as transferred, sum(if( sv.transferred=0, 1, 0)) as not_transferred from youtube_data yt inner join synced_video sv on sv.youtube_data_id = yt.id where yt.transfer_state = 2 and yt.is_deleted_on_youtube = 0 and channel_publish_id is not null and sv.status = 'published' group by yt.id having not_transferred > 0 and transferred > 0; ```

tzarebczan commented

2021-02-09 20:16:10 +01:00

(Migrated from github.com)

Found one case where the video was a duplicate and we deleted one, but the publish record itself points to the duplicate that was deleted, and not the one that needed to be transferred. The claim id is incorrect, but the URI is. Can try to write a query to fix these.

tzarebczan commented

2021-02-11 22:53:49 +01:00

(Migrated from github.com)

This has been fixed. will reprocess

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: LBRYCommunity/ytsync#69

No description provided.

Rows
Columns