Episode imports with large URLs

PRX / cms.prx.org

CMS API for PRX

https://cms.prx.org

GNU Affero General Public License v3.0

4 stars 2 forks source link

Episode imports with large URLs #569

Open cavis opened 4 years ago

cavis commented 4 years ago

Seen: podcast imports failing because the episodes have very long urls.

https://play.podtrac.com/npr-510016/edge1.pod.npr.org/anon.npr-mp3/npr/lusa/2020/06/20200608_lusa_prtestingpodcastlusa.mp3?awCollectionId=510016&awEpisodeId=872471989&aw_0_1st.cv=yes&orgId=1&d=1792&p=510016&story=872471989&t=podcast&e=872471989&size=28617459&ft=pod&f=510016

Need a migration to allow these longer audio_files.upload_path.

cavis commented 4 years ago

I've worked around this for now - removing unnecessary query params. But this is still an issue, so I'll leave this open.

There may be some issues with mysql 5.6 and changing these to TEXT fields. Performance could degrade with some of the group-by / unique-by codes in CMS and/or Exchange. Might need an additional index.