Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Life Streams Stuck in Pending #577

Open
chrisrae75 opened this issue Jan 19, 2025 · 9 comments
Open

Life Streams Stuck in Pending #577

chrisrae75 opened this issue Jan 19, 2025 · 9 comments
Assignees
@kieraneglin

Comments

@chrisrae75
Copy link

Hi,

I upgraded to the latest software for Pinchflat container.
But after the upgrade I can see new.Doenload.and Pending sections, which is cool, but the live streams are stuck in pending and no idea why.

Regards
Chris
@z0gg
Copy link

z0gg commented Jan 19, 2025

same problem

@chrisrae75
Copy link
Author

Glad I'm not the only one 😅

@kieraneglin
Copy link
Owner

Hey there! Thanks for the report (:

Would one of you mind going to an impacted Source, clicking Actions > Download Pending, wait a few minutes, then download + attach your logs? You can download your logs by visiting Config > App Info in-app 🤙

@z0gg
Copy link

z0gg commented Jan 21, 2025 •
edited by kieraneglin
Loading

Hey there! Thanks for the report (:

Would one of you mind going to an impacted Source, clicking Actions > Download Pending, wait a few minutes, then download + attach your logs? You can download your logs by visiting Config > App Info in-app 🤙

Logs 

17:34:01.393 [debug] Processing with PinchflatWeb.MediaItems.MediaItemController.show/2
  Parameters: %{"id" => "3037", "source_id" => "1"}
  Pipelines: [:browser]

17:34:01.395 [debug] QUERY OK source="media_items" db=1.0ms queue=0.1ms idle=1730.8ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 WHERE (m0."id" = ?) [3037]

17:34:01.396 [debug] QUERY OK source="tasks" db=0.6ms idle=1732.8ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", t0."media_item_id" FROM "tasks" AS t0 WHERE (t0."media_item_id" = ?) ORDER BY t0."media_item_id" [3037]

17:34:01.397 [debug] QUERY OK source="sources" db=0.9ms idle=1733.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:01.398 [debug] QUERY OK source="oban_jobs" db=0.7ms idle=1116.2ms
SELECT o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at", o0."id" FROM "oban_jobs" AS o0 WHERE (o0."id" IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) [122, 123, 125, 126, 128, 129, 131, 132, 134, 135, 137, 138, 140, 141, 143, 144, 146, 147, 149]

17:34:01.399 [debug] QUERY OK source="settings" db=0.1ms idle=795.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:01.399 [debug] QUERY OK source="settings" db=0.2ms idle=4.4ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:01.400 [debug] QUERY OK source="settings" db=0.2ms idle=3.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:01.401 [debug] QUERY OK source="media_profiles" db=0.2ms idle=3.9ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", m0."id" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:34:01.408 [info] Sent 200 in 15ms

17:34:01.532 [info] CONNECTED TO Phoenix.LiveView.Socket in 60µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "BA5rIDkhWncQCX4SBBZ4EGUqHHFheSIdhvYUqG8OFy-yuXOSWEz457LV", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:01.548 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:01.548 [debug] Replied in 315µs

17:34:06.093 [info] GET /sources/1

17:34:06.094 [debug] Processing with PinchflatWeb.Sources.SourceController.show/2
  Parameters: %{"id" => "1"}
  Pipelines: [:browser]

17:34:06.095 [debug] QUERY OK source="sources" db=0.6ms queue=0.1ms idle=1431.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.096 [debug] QUERY OK source="media_profiles" db=0.5ms queue=0.1ms idle=1432.8ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", m0."id" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:34:06.098 [debug] QUERY OK source="tasks" db=0.7ms queue=0.1ms idle=1434.1ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at" FROM "tasks" AS t0 INNER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (t0."source_id" = ?) AND (o1."state" IN (?,?,?,?)) [1, "executing", "available", "scheduled", "retryable"]

17:34:06.098 [debug] QUERY OK source="oban_jobs" db=0.1ms idle=1435.1ms
SELECT o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at", o0."id" FROM "oban_jobs" AS o0 WHERE (o0."id" = ?) [198]

17:34:06.098 [debug] QUERY OK source="settings" db=0.1ms idle=480.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:06.099 [debug] QUERY OK source="settings" db=0.1ms idle=3.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:06.099 [debug] QUERY OK source="settings" db=0.1ms idle=2.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:06.101 [debug] QUERY OK source="sources" db=0.2ms idle=2.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.101 [debug] QUERY OK source="media_items" db=0.3ms idle=2.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:34:06.102 [debug] QUERY OK source="media_items" db=0.3ms idle=3.0ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.103 [debug] QUERY OK source="sources" db=0.1ms idle=3.7ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.103 [debug] QUERY OK source="media_items" db=0.1ms idle=3.6ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:34:06.103 [debug] QUERY OK source="media_items" db=0.1ms idle=2.5ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.104 [debug] QUERY OK source="sources" db=0.1ms idle=2.5ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.105 [debug] QUERY OK source="media_items" db=0.2ms idle=2.4ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:34:06.105 [debug] QUERY OK source="media_items" db=0.3ms idle=2.1ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.107 [info] Sent 200 in 13ms

17:34:06.209 [info] CONNECTED TO Phoenix.LiveView.Socket in 70µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "AhsAEiE0BUJnRzEMJy18LUIXHgIdKyF-nc2giRgz17bgVcKnpxxGIeO5", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:06.213 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending", "source_id" => 1}

17:34:06.214 [debug] QUERY OK source="sources" db=0.6ms queue=0.1ms idle=110.4ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.216 [debug] QUERY OK source="media_items" db=0.8ms idle=111.7ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:34:06.218 [debug] QUERY OK source="media_items" db=0.9ms queue=0.1ms idle=112.3ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.218 [debug] Replied in 4ms

17:34:06.220 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded", "source_id" => 1}

17:34:06.220 [debug] QUERY OK source="sources" db=0.3ms idle=115.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.221 [debug] QUERY OK source="media_items" db=0.2ms idle=115.5ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:34:06.222 [debug] QUERY OK source="media_items" db=0.2ms idle=6.9ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.222 [debug] Replied in 2ms

17:34:06.223 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "other", "source_id" => 1}

17:34:06.224 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=7.4ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:06.225 [debug] QUERY OK source="media_items" db=0.5ms idle=6.9ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:34:06.226 [debug] QUERY OK source="media_items" db=0.5ms idle=4.9ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:34:06.226 [debug] Replied in 3ms

17:34:06.229 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:06.229 [debug] Replied in 187µs

17:34:08.336 [info] GET /healthcheck

17:34:08.336 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:34:08.336 [info] Sent 200 in 220µs

17:34:21.816 [info] GET /sources/1/media/3037

17:34:21.816 [debug] Processing with PinchflatWeb.MediaItems.MediaItemController.show/2
  Parameters: %{"id" => "3037", "source_id" => "1"}
  Pipelines: [:browser]

17:34:21.817 [debug] QUERY OK source="media_items" db=0.2ms idle=156.8ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 WHERE (m0."id" = ?) [3037]

17:34:21.818 [debug] QUERY OK source="sources" db=0.4ms idle=155.5ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:21.820 [debug] QUERY OK source="tasks" db=1.3ms idle=155.6ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", t0."media_item_id" FROM "tasks" AS t0 WHERE (t0."media_item_id" = ?) ORDER BY t0."media_item_id" [3037]

17:34:21.821 [debug] QUERY OK source="oban_jobs" db=0.3ms idle=157.7ms
SELECT o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at", o0."id" FROM "oban_jobs" AS o0 WHERE (o0."id" IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) [122, 123, 125, 126, 128, 129, 131, 132, 134, 135, 137, 138, 140, 141, 143, 144, 146, 147, 149]

17:34:21.824 [debug] QUERY OK source="settings" db=0.2ms idle=160.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:21.824 [debug] QUERY OK source="settings" db=0.2ms idle=6.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:21.826 [debug] QUERY OK source="settings" db=0.4ms idle=6.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:21.827 [debug] QUERY OK source="media_profiles" db=0.5ms idle=7.2ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", m0."id" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:34:21.835 [info] Sent 200 in 18ms

17:34:21.927 [info] CONNECTED TO Phoenix.LiveView.Socket in 51µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "ODptER45UG4mEzI9Hz52cAQVE3NleD09TB_dV_2VpcaVnpA36zu616Sv", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:21.933 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:21.934 [debug] Replied in 264µs

17:34:38.407 [info] GET /healthcheck

17:34:38.407 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:34:38.407 [info] Sent 200 in 339µs

17:34:40.475 [info] GET /sources

17:34:40.476 [debug] Processing with PinchflatWeb.Sources.SourceController.index/2
  Parameters: %{}
  Pipelines: [:browser]

17:34:40.477 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=813.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:40.478 [debug] QUERY OK source="settings" db=0.6ms queue=0.1ms idle=814.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:40.479 [debug] QUERY OK source="settings" db=0.3ms idle=816.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:40.481 [debug] QUERY OK source="settings" db=0.2ms idle=817.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:40.481 [debug] QUERY OK source="settings" db=0.3ms idle=771.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:40.483 [debug] QUERY OK source="sources" db=1.0ms idle=5.0ms
SELECT count(s0."id") FROM "sources" AS s0 INNER JOIN "media_profiles" AS m1 ON m1."id" = s0."media_profile_id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "downloaded_count", sm0."source_id" AS "source_id", sum(sm0."media_size_bytes") AS "media_size_bytes" FROM "media_items" AS sm0 WHERE (NOT (sm0."media_filepath" IS NULL)) GROUP BY sm0."source_id") AS s2 ON s2."source_id" = s0."id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "pending_count", sm0."source_id" AS "source_id" FROM "media_items" AS sm0 INNER JOIN "sources" AS ss1 ON ss1."id" = sm0."source_id" INNER JOIN "media_profiles" AS sm2 ON sm2."id" = ss1."media_profile_id" WHERE (((((NOT (NOT (sm0."media_filepath" IS NULL)) AND NOT (sm0."prevent_download" = 1)) AND ((ss1."download_cutoff_date" IS NULL) OR date(sm0."uploaded_at") >= ss1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((ss1."title_filter_regex" IS NULL) OR regexp_like(sm0."title", ss1."title_filter_regex"))) AND (((ss1."min_duration_seconds" IS NULL) OR duration_seconds >= ss1."min_duration_seconds") AND ((ss1."max_duration_seconds" IS NULL) OR duration_seconds <= ss1."max_duration_seconds"))) GROUP BY sm0."source_id") AS s3 ON (s3."source_id" = s0."id") AND (s2."source_id" = s0."id") WHERE ((s0."marked_for_deletion_at" IS NULL) AND (m1."marked_for_deletion_at" IS NULL)) []

17:34:40.485 [debug] QUERY OK source="sources" db=1.2ms queue=0.1ms idle=5.7ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", coalesce(s2."downloaded_count", 0), coalesce(s3."pending_count", 0), coalesce(s2."media_size_bytes", 0), m1."id", m1."name", m1."redownload_delay_days", m1."output_path_template", m1."download_subs", m1."download_auto_subs", m1."embed_subs", m1."sub_langs", m1."download_thumbnail", m1."embed_thumbnail", m1."download_source_images", m1."download_metadata", m1."embed_metadata", m1."download_nfo", m1."sponsorblock_behaviour", m1."sponsorblock_categories", m1."shorts_behaviour", m1."livestream_behaviour", m1."audio_track", m1."preferred_resolution", m1."media_container", m1."marked_for_deletion_at", m1."inserted_at", m1."updated_at" FROM "sources" AS s0 INNER JOIN "media_profiles" AS m1 ON m1."id" = s0."media_profile_id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "downloaded_count", sm0."source_id" AS "source_id", sum(sm0."media_size_bytes") AS "media_size_bytes" FROM "media_items" AS sm0 WHERE (NOT (sm0."media_filepath" IS NULL)) GROUP BY sm0."source_id") AS s2 ON s2."source_id" = s0."id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "pending_count", sm0."source_id" AS "source_id" FROM "media_items" AS sm0 INNER JOIN "sources" AS ss1 ON ss1."id" = sm0."source_id" INNER JOIN "media_profiles" AS sm2 ON sm2."id" = ss1."media_profile_id" WHERE (((((NOT (NOT (sm0."media_filepath" IS NULL)) AND NOT (sm0."prevent_download" = 1)) AND ((ss1."download_cutoff_date" IS NULL) OR date(sm0."uploaded_at") >= ss1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((ss1."title_filter_regex" IS NULL) OR regexp_like(sm0."title", ss1."title_filter_regex"))) AND (((ss1."min_duration_seconds" IS NULL) OR duration_seconds >= ss1."min_duration_seconds") AND ((ss1."max_duration_seconds" IS NULL) OR duration_seconds <= ss1."max_duration_seconds"))) GROUP BY sm0."source_id") AS s3 ON (s3."source_id" = s0."id") AND (s2."source_id" = s0."id") WHERE ((s0."marked_for_deletion_at" IS NULL) AND (m1."marked_for_deletion_at" IS NULL)) ORDER BY s0."custom_name", s0."id" LIMIT ? OFFSET ? [10, 0]

17:34:40.488 [info] Sent 200 in 13ms

17:34:40.578 [info] CONNECTED TO Phoenix.LiveView.Socket in 61µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "GC9hHH0FMApnKTVeEgN7egMaFjI9FhYdtWSi5cR21Yf5cML91upwiXxV", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:40.582 [debug] MOUNT PinchflatWeb.Sources.SourceLive.IndexTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "initial_sort_direction" => :asc, "initial_sort_key" => :custom_name, "results_per_page" => 10}

17:34:40.585 [debug] QUERY OK source="sources" db=1.3ms idle=103.7ms
SELECT count(s0."id") FROM "sources" AS s0 INNER JOIN "media_profiles" AS m1 ON m1."id" = s0."media_profile_id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "downloaded_count", sm0."source_id" AS "source_id", sum(sm0."media_size_bytes") AS "media_size_bytes" FROM "media_items" AS sm0 WHERE (NOT (sm0."media_filepath" IS NULL)) GROUP BY sm0."source_id") AS s2 ON s2."source_id" = s0."id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "pending_count", sm0."source_id" AS "source_id" FROM "media_items" AS sm0 INNER JOIN "sources" AS ss1 ON ss1."id" = sm0."source_id" INNER JOIN "media_profiles" AS sm2 ON sm2."id" = ss1."media_profile_id" WHERE (((((NOT (NOT (sm0."media_filepath" IS NULL)) AND NOT (sm0."prevent_download" = 1)) AND ((ss1."download_cutoff_date" IS NULL) OR date(sm0."uploaded_at") >= ss1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((ss1."title_filter_regex" IS NULL) OR regexp_like(sm0."title", ss1."title_filter_regex"))) AND (((ss1."min_duration_seconds" IS NULL) OR duration_seconds >= ss1."min_duration_seconds") AND ((ss1."max_duration_seconds" IS NULL) OR duration_seconds <= ss1."max_duration_seconds"))) GROUP BY sm0."source_id") AS s3 ON (s3."source_id" = s0."id") AND (s2."source_id" = s0."id") WHERE ((s0."marked_for_deletion_at" IS NULL) AND (m1."marked_for_deletion_at" IS NULL)) []

17:34:40.587 [debug] QUERY OK source="sources" db=1.4ms queue=0.1ms idle=104.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", coalesce(s2."downloaded_count", 0), coalesce(s3."pending_count", 0), coalesce(s2."media_size_bytes", 0), m1."id", m1."name", m1."redownload_delay_days", m1."output_path_template", m1."download_subs", m1."download_auto_subs", m1."embed_subs", m1."sub_langs", m1."download_thumbnail", m1."embed_thumbnail", m1."download_source_images", m1."download_metadata", m1."embed_metadata", m1."download_nfo", m1."sponsorblock_behaviour", m1."sponsorblock_categories", m1."shorts_behaviour", m1."livestream_behaviour", m1."audio_track", m1."preferred_resolution", m1."media_container", m1."marked_for_deletion_at", m1."inserted_at", m1."updated_at" FROM "sources" AS s0 INNER JOIN "media_profiles" AS m1 ON m1."id" = s0."media_profile_id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "downloaded_count", sm0."source_id" AS "source_id", sum(sm0."media_size_bytes") AS "media_size_bytes" FROM "media_items" AS sm0 WHERE (NOT (sm0."media_filepath" IS NULL)) GROUP BY sm0."source_id") AS s2 ON s2."source_id" = s0."id" LEFT OUTER JOIN (SELECT count(sm0."id") AS "pending_count", sm0."source_id" AS "source_id" FROM "media_items" AS sm0 INNER JOIN "sources" AS ss1 ON ss1."id" = sm0."source_id" INNER JOIN "media_profiles" AS sm2 ON sm2."id" = ss1."media_profile_id" WHERE (((((NOT (NOT (sm0."media_filepath" IS NULL)) AND NOT (sm0."prevent_download" = 1)) AND ((ss1."download_cutoff_date" IS NULL) OR date(sm0."uploaded_at") >= ss1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((ss1."title_filter_regex" IS NULL) OR regexp_like(sm0."title", ss1."title_filter_regex"))) AND (((ss1."min_duration_seconds" IS NULL) OR duration_seconds >= ss1."min_duration_seconds") AND ((ss1."max_duration_seconds" IS NULL) OR duration_seconds <= ss1."max_duration_seconds"))) GROUP BY sm0."source_id") AS s3 ON (s3."source_id" = s0."id") AND (s2."source_id" = s0."id") WHERE ((s0."marked_for_deletion_at" IS NULL) AND (m1."marked_for_deletion_at" IS NULL)) ORDER BY s0."custom_name", s0."id" LIMIT ? OFFSET ? [10, 0]

17:34:40.587 [debug] Replied in 4ms

17:34:40.590 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:40.590 [debug] Replied in 211µs

17:34:44.105 [info] GET /sources/1/edit

17:34:44.106 [debug] Processing with PinchflatWeb.Sources.SourceController.edit/2
  Parameters: %{"id" => "1"}
  Pipelines: [:browser]

17:34:44.107 [debug] QUERY OK source="sources" db=0.5ms queue=0.1ms idle=443.4ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:34:44.108 [debug] QUERY OK source="media_profiles" db=0.6ms idle=444.6ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at" FROM "media_profiles" AS m0 ORDER BY m0."name" []

17:34:44.109 [debug] QUERY OK source="settings" db=0.4ms idle=445.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:44.110 [debug] QUERY OK source="settings" db=0.2ms queue=0.1ms idle=446.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:44.110 [debug] QUERY OK source="settings" db=0.1ms idle=390.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:44.113 [info] Sent 200 in 8ms

17:34:44.215 [info] CONNECTED TO Phoenix.LiveView.Socket in 55µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "Hzp1IC8KEmJmNhJaIQBRdGdfAic3OCYRsBGUglpZ0FA1PNf7U0dbcvHZ", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:44.240 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:44.240 [debug] Replied in 325µs

17:34:51.850 [info] GET /settings

17:34:51.850 [debug] Processing with PinchflatWeb.Settings.SettingController.show/2
  Parameters: %{}
  Pipelines: [:browser]

17:34:51.852 [debug] QUERY OK source="settings" db=0.5ms queue=0.1ms idle=188.1ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:51.853 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=189.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:51.853 [debug] QUERY OK source="settings" db=0.2ms idle=190.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:51.854 [debug] QUERY OK source="settings" db=0.2ms idle=191.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:51.857 [info] Sent 200 in 7ms

17:34:51.948 [info] CONNECTED TO Phoenix.LiveView.Socket in 65µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "QQ0GTQdWIQ4aSToZGwdYG1c6NxINdzkg-u48O0C6L9irjIoXeUQWY9Wk", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:51.956 [debug] MOUNT Pinchflat.Settings.AppriseServerLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "value" => nil}

17:34:51.956 [debug] Replied in 361µs

17:34:51.957 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:51.957 [debug] Replied in 235µs

17:34:52.836 [info] GET /app_info

17:34:52.836 [debug] Processing with PinchflatWeb.Settings.SettingController.app_info/2
  Parameters: %{}
  Pipelines: [:browser]

17:34:52.837 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=985.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:52.838 [debug] QUERY OK source="settings" db=0.3ms idle=985.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:52.839 [debug] QUERY OK source="settings" db=0.1ms idle=985.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:52.840 [debug] QUERY OK source="settings" db=0.2ms idle=986.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:52.841 [debug] QUERY OK source="settings" db=0.2ms idle=99.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:52.842 [info] Sent 200 in 6ms

17:34:52.935 [info] CONNECTED TO Phoenix.LiveView.Socket in 66µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "JkFzIwIDJVwSQRIqPB5_ewMoL3AYIUNzJ9AVJeGdD1AAMPH81GI5Lo-8", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:52.941 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:52.941 [debug] Replied in 303µs

17:34:53.701 [info] GET /media_profiles

17:34:53.701 [debug] Processing with PinchflatWeb.MediaProfiles.MediaProfileController.index/2
  Parameters: %{}
  Pipelines: [:browser]

17:34:53.703 [debug] QUERY OK source="media_profiles" db=0.7ms queue=0.1ms idle=864.1ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", (SELECT count(ss0."id") AS "result" FROM "sources" AS ss0 WHERE (ss0."media_profile_id" = m0."id")) FROM "media_profiles" AS m0 WHERE (m0."marked_for_deletion_at" IS NULL) ORDER BY m0."name" []

17:34:53.704 [debug] QUERY OK source="settings" db=0.7ms queue=0.1ms idle=865.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:53.705 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=865.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:53.706 [debug] QUERY OK source="settings" db=0.1ms idle=865.4ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:53.707 [info] Sent 200 in 6ms

17:34:53.792 [info] CONNECTED TO Phoenix.LiveView.Socket in 55µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "DzVZPns0LQgYRCYSLgBCBlYDFikyK14kcMkK3RO0N4uy_NuEdlplfe0o", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:53.798 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:53.798 [debug] Replied in 294µs

17:34:57.261 [info] GET /media_profiles/1

17:34:57.261 [debug] Processing with PinchflatWeb.MediaProfiles.MediaProfileController.show/2
  Parameters: %{"id" => "1"}
  Pipelines: [:browser]

17:34:57.262 [debug] QUERY OK source="media_profiles" db=0.5ms idle=1598.9ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:34:57.263 [debug] QUERY OK source="sources" db=0.6ms idle=1600.1ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."media_profile_id" = ?) ORDER BY s0."custom_name" [1]

17:34:57.265 [debug] QUERY OK source="settings" db=0.3ms idle=1514.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:57.265 [debug] QUERY OK source="settings" db=0.2ms idle=1117.9ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:57.266 [debug] QUERY OK source="settings" db=0.1ms idle=514.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:34:57.267 [info] Sent 200 in 6ms

17:34:57.357 [info] CONNECTED TO Phoenix.LiveView.Socket in 64µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "BkxmOjACJwo1GgIZIhF0FkcgUwttfAQ8j4TOxdE2cjQrS_CUuO5N92jw", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:34:57.362 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:34:57.362 [debug] Replied in 315µs

17:35:08.493 [info] GET /healthcheck

17:35:08.493 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:35:08.493 [info] Sent 200 in 222µs

17:35:16.197 [info] GET /sources/1

17:35:16.197 [debug] Processing with PinchflatWeb.Sources.SourceController.show/2
  Parameters: %{"id" => "1"}
  Pipelines: [:browser]

17:35:16.198 [debug] QUERY OK source="sources" db=0.5ms queue=0.1ms idle=1534.9ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.200 [debug] QUERY OK source="media_profiles" db=0.4ms queue=0.1ms idle=1536.1ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", m0."id" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:35:16.201 [debug] QUERY OK source="tasks" db=0.9ms queue=0.1ms idle=1395.8ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at" FROM "tasks" AS t0 INNER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (t0."source_id" = ?) AND (o1."state" IN (?,?,?,?)) [1, "executing", "available", "scheduled", "retryable"]

17:35:16.202 [debug] QUERY OK source="oban_jobs" db=0.3ms queue=0.1ms idle=538.8ms
SELECT o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at", o0."id" FROM "oban_jobs" AS o0 WHERE (o0."id" = ?) [198]

17:35:16.202 [debug] QUERY OK source="settings" db=0.1ms idle=395.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:16.203 [debug] QUERY OK source="settings" db=0.2ms idle=4.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:16.203 [debug] QUERY OK source="settings" db=0.2ms idle=3.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:16.206 [debug] QUERY OK source="sources" db=0.6ms idle=4.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.207 [debug] QUERY OK source="media_items" db=0.8ms idle=4.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:35:16.209 [debug] QUERY OK source="media_items" db=0.6ms queue=0.1ms idle=5.4ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.210 [debug] QUERY OK source="sources" db=0.3ms idle=7.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.211 [debug] QUERY OK source="media_items" db=0.2ms queue=0.1ms idle=7.2ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:35:16.212 [debug] QUERY OK source="media_items" db=0.2ms idle=5.3ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.213 [debug] QUERY OK source="sources" db=0.3ms idle=5.1ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.214 [debug] QUERY OK source="media_items" db=0.5ms idle=4.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:35:16.215 [debug] QUERY OK source="media_items" db=0.5ms queue=0.1ms idle=4.1ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.219 [info] Sent 200 in 22ms

17:35:16.312 [info] CONNECTED TO Phoenix.LiveView.Socket in 20µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "FU1TIjJTMnxiOzReByBeE38pJBU8PFoBy5aWz5PD4Kg5vniPMFBPhr4J", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:35:16.315 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending", "source_id" => 1}

17:35:16.316 [debug] QUERY OK source="sources" db=0.4ms idle=104.5ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.317 [debug] QUERY OK source="media_items" db=0.4ms idle=104.7ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:35:16.318 [debug] QUERY OK source="media_items" db=0.5ms idle=104.1ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.318 [debug] Replied in 2ms

17:35:16.319 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded", "source_id" => 1}

17:35:16.320 [debug] QUERY OK source="sources" db=0.2ms idle=105.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.320 [debug] QUERY OK source="media_items" db=0.2ms queue=0.1ms idle=104.7ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:35:16.321 [debug] QUERY OK source="media_items" db=0.2ms idle=4.3ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.321 [debug] Replied in 1ms

17:35:16.322 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "other", "source_id" => 1}

17:35:16.323 [debug] QUERY OK source="sources" db=0.3ms idle=5.3ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:16.324 [debug] QUERY OK source="media_items" db=0.4ms idle=5.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:35:16.325 [debug] QUERY OK source="media_items" db=0.7ms idle=4.2ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:16.325 [debug] Replied in 2ms

17:35:16.327 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:35:16.327 [debug] Replied in 129µs

17:35:26.429 [info] POST /sources/1/force_download_pending

17:35:26.429 [debug] Processing with PinchflatWeb.Sources.SourceController.force_download_pending/2
  Parameters: %{"_csrf_token" => "FU1TIjJTMnxiOzReByBeE38pJBU8PFoBy5aWz5PD4Kg5vniPMFBPhr4J", "_method" => "post", "source_id" => "1"}
  Pipelines: [:browser]

17:35:26.430 [debug] QUERY OK source="sources" db=0.2ms idle=766.8ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.431 [debug] QUERY OK source="media_items" db=0.6ms idle=767.4ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:35:26.436 [info] Sent 302 in 6ms

17:35:26.446 [info] GET /sources/1

17:35:26.447 [debug] Processing with PinchflatWeb.Sources.SourceController.show/2
  Parameters: %{"id" => "1"}
  Pipelines: [:browser]

17:35:26.447 [debug] QUERY OK source="sources" db=0.4ms idle=17.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.448 [debug] QUERY OK source="media_profiles" db=0.4ms idle=16.7ms
SELECT m0."id", m0."name", m0."redownload_delay_days", m0."output_path_template", m0."download_subs", m0."download_auto_subs", m0."embed_subs", m0."sub_langs", m0."download_thumbnail", m0."embed_thumbnail", m0."download_source_images", m0."download_metadata", m0."embed_metadata", m0."download_nfo", m0."sponsorblock_behaviour", m0."sponsorblock_categories", m0."shorts_behaviour", m0."livestream_behaviour", m0."audio_track", m0."preferred_resolution", m0."media_container", m0."marked_for_deletion_at", m0."inserted_at", m0."updated_at", m0."id" FROM "media_profiles" AS m0 WHERE (m0."id" = ?) [1]

17:35:26.449 [debug] QUERY OK source="tasks" db=0.4ms idle=15.4ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at" FROM "tasks" AS t0 INNER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (t0."source_id" = ?) AND (o1."state" IN (?,?,?,?)) [1, "executing", "available", "scheduled", "retryable"]

17:35:26.449 [debug] QUERY OK source="oban_jobs" db=0.2ms idle=14.5ms
SELECT o0."id", o0."state", o0."queue", o0."worker", o0."args", o0."meta", o0."tags", o0."errors", o0."attempt", o0."attempted_by", o0."max_attempts", o0."priority", o0."attempted_at", o0."cancelled_at", o0."completed_at", o0."discarded_at", o0."inserted_at", o0."scheduled_at", o0."id" FROM "oban_jobs" AS o0 WHERE (o0."id" = ?) [198]

17:35:26.450 [debug] QUERY OK source="settings" db=0.2ms idle=13.9ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:26.450 [debug] QUERY OK source="settings" db=0.3ms idle=2.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:26.451 [debug] QUERY OK source="settings" db=0.4ms idle=2.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:35:26.453 [debug] QUERY OK source="sources" db=0.1ms idle=3.7ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.453 [debug] QUERY OK source="media_items" db=0.3ms idle=3.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:35:26.454 [debug] QUERY OK source="media_items" db=0.4ms idle=3.8ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.455 [debug] QUERY OK source="sources" db=0.1ms idle=4.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.455 [debug] QUERY OK source="media_items" db=0.2ms idle=4.0ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:35:26.456 [debug] QUERY OK source="media_items" db=0.2ms idle=2.8ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.457 [debug] QUERY OK source="sources" db=0.2ms idle=3.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.457 [debug] QUERY OK source="media_items" db=0.2ms idle=2.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:35:26.458 [debug] QUERY OK source="media_items" db=0.5ms idle=2.4ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.460 [info] Sent 200 in 13ms

17:35:26.545 [info] CONNECTED TO Phoenix.LiveView.Socket in 65µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "Dzt1BB5TIXESPjcRICl8e0goUzAZKhkDcCGqV5CIDNdzQgK8zG5uMdwH", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:35:26.550 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending", "source_id" => 1}

17:35:26.551 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=95.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.552 [debug] QUERY OK source="media_items" db=0.5ms idle=95.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) [1]

17:35:26.554 [debug] QUERY OK source="media_items" db=1.0ms idle=95.9ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds")))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.554 [debug] Replied in 3ms

17:35:26.556 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded", "source_id" => 1}

17:35:26.556 [debug] QUERY OK source="sources" db=0.2ms idle=98.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.557 [debug] QUERY OK source="media_items" db=0.1ms idle=98.4ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) [1]

17:35:26.557 [debug] QUERY OK source="media_items" db=0.3ms idle=5.7ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 WHERE ((m0."source_id" = ?) AND NOT (m0."media_filepath" IS NULL)) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.558 [debug] Replied in 1ms

17:35:26.559 [debug] MOUNT PinchflatWeb.Sources.MediaItemTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "other", "source_id" => 1}

17:35:26.560 [debug] QUERY OK source="sources" db=0.3ms idle=7.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:35:26.561 [debug] QUERY OK source="media_items" db=0.5ms idle=6.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) [1]

17:35:26.562 [debug] QUERY OK source="media_items" db=0.6ms idle=4.9ms
SELECT m0."id", m0."title", m0."uploaded_at", m0."prevent_download" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE ((m0."source_id" = ?) AND (NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))))) ORDER BY m0."uploaded_at" DESC LIMIT ? OFFSET ? [1, 10, 0]

17:35:26.562 [debug] Replied in 2ms

17:35:26.565 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:35:26.565 [debug] Replied in 188µs

17:35:38.586 [info] GET /healthcheck

17:35:38.586 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:35:38.587 [info] Sent 200 in 196µs

17:36:06.452 [info] GET /

17:36:06.453 [debug] Processing with PinchflatWeb.Pages.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]

17:36:06.454 [debug] QUERY OK source="settings" db=0.8ms idle=790.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:06.455 [debug] QUERY OK source="media_profiles" db=0.2ms idle=792.0ms
SELECT count(m0."id") FROM "media_profiles" AS m0 []

17:36:06.455 [debug] QUERY OK source="sources" db=0.2ms idle=792.6ms
SELECT count(s0."id") FROM "sources" AS s0 []

17:36:06.456 [debug] QUERY OK source="media_items" db=0.2ms idle=793.1ms
SELECT sum(m0."media_size_bytes") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:06.456 [debug] QUERY OK source="media_items" db=0.1ms idle=514.1ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:06.457 [debug] QUERY OK source="settings" db=0.2ms queue=0.1ms idle=2.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:06.458 [debug] QUERY OK source="settings" db=0.3ms idle=2.4ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:06.458 [debug] QUERY OK source="settings" db=0.0ms idle=2.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:06.459 [debug] QUERY OK source="tasks" db=0.2ms idle=2.9ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:36:06.460 [debug] QUERY OK source="media_items" db=0.1ms idle=3.0ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:06.460 [debug] QUERY OK source="media_items" db=0.2ms idle=2.7ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:06.461 [debug] QUERY OK source="sources" db=0.1ms idle=2.5ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:06.462 [debug] QUERY OK source="media_items" db=0.3ms idle=3.3ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:36:06.462 [debug] QUERY OK source="media_items" db=0.3ms idle=2.8ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:06.463 [debug] QUERY OK source="sources" db=0.1ms idle=2.9ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:06.465 [info] Sent 200 in 12ms

17:36:06.561 [info] CONNECTED TO Phoenix.LiveView.Socket in 65µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "Hz5oEAMoJXIMF2ITJgFZHHwkUBQjJSo5sFZeKNGJZg1xWOn_NK6QwkDr", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:36:06.566 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded"}

17:36:06.567 [debug] QUERY OK source="media_items" db=0.4ms queue=0.1ms idle=106.6ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:06.569 [debug] QUERY OK source="media_items" db=0.5ms queue=0.1ms idle=107.2ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:06.569 [debug] QUERY OK source="sources" db=0.3ms idle=106.9ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:06.570 [debug] Replied in 3ms

17:36:06.573 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending"}

17:36:06.574 [debug] QUERY OK source="media_items" db=0.6ms idle=110.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:36:06.575 [debug] QUERY OK source="media_items" db=0.6ms idle=111.4ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:06.576 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=8.1ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:06.576 [debug] Replied in 3ms

17:36:06.579 [debug] MOUNT Pinchflat.Pages.JobTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:36:06.580 [debug] QUERY OK source="tasks" db=0.4ms idle=11.1ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:36:06.580 [debug] Replied in 1ms

17:36:06.581 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:36:06.581 [debug] Replied in 173µs

17:36:08.686 [info] GET /healthcheck

17:36:08.686 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:36:08.687 [info] Sent 200 in 198µs

17:36:15.737 [info] GET /

17:36:15.737 [debug] Processing with PinchflatWeb.Pages.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]

17:36:15.739 [debug] QUERY OK source="settings" db=0.5ms queue=0.1ms idle=773.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:15.740 [debug] QUERY OK source="media_profiles" db=0.5ms queue=0.1ms idle=76.1ms
SELECT count(m0."id") FROM "media_profiles" AS m0 []

17:36:15.741 [debug] QUERY OK source="sources" db=0.5ms queue=0.1ms idle=77.0ms
SELECT count(s0."id") FROM "sources" AS s0 []

17:36:15.742 [debug] QUERY OK source="media_items" db=0.6ms idle=77.9ms
SELECT sum(m0."media_size_bytes") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:15.742 [debug] QUERY OK source="media_items" db=0.1ms idle=78.9ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:15.742 [debug] QUERY OK source="settings" db=0.1ms idle=3.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:15.743 [debug] QUERY OK source="settings" db=0.2ms idle=3.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:15.744 [debug] QUERY OK source="settings" db=0.4ms idle=2.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:15.746 [debug] QUERY OK source="tasks" db=0.6ms idle=4.0ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:36:15.748 [debug] QUERY OK source="media_items" db=0.5ms idle=4.9ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:15.748 [debug] QUERY OK source="media_items" db=0.4ms idle=5.3ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:15.749 [debug] QUERY OK source="sources" db=0.2ms queue=0.1ms idle=5.8ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:15.752 [debug] QUERY OK source="media_items" db=0.6ms idle=7.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:36:15.754 [debug] QUERY OK source="media_items" db=0.7ms idle=6.4ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:15.755 [debug] QUERY OK source="sources" db=0.3ms idle=6.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:15.757 [info] Sent 200 in 20ms

17:36:15.851 [info] CONNECTED TO Phoenix.LiveView.Socket in 66µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "G0pCGTpQKEolMSUnBRwPFwE8BAJtNBYkw2plr6JrsAvLtR8T3SbG9zxo", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:36:15.855 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded"}

17:36:15.856 [debug] QUERY OK source="media_items" db=0.4ms queue=0.1ms idle=107.3ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:36:15.857 [debug] QUERY OK source="media_items" db=0.6ms idle=107.5ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:15.858 [debug] QUERY OK source="sources" db=0.3ms idle=105.4ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:15.858 [debug] Replied in 3ms

17:36:15.862 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending"}

17:36:15.863 [debug] QUERY OK source="media_items" db=0.5ms idle=108.4ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:36:15.864 [debug] QUERY OK source="media_items" db=0.6ms queue=0.1ms idle=108.2ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:36:15.865 [debug] QUERY OK source="sources" db=0.5ms idle=7.8ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:36:15.865 [debug] Replied in 3ms

17:36:15.868 [debug] MOUNT Pinchflat.Pages.JobTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:36:15.869 [debug] QUERY OK source="tasks" db=0.3ms idle=10.7ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:36:15.869 [debug] Replied in 1ms

17:36:15.869 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:36:15.870 [debug] Replied in 178µs

17:36:18.617 [info] GET /app_info

17:36:18.617 [debug] Processing with PinchflatWeb.Settings.SettingController.app_info/2
  Parameters: %{}
  Pipelines: [:browser]

17:36:18.619 [debug] QUERY OK source="settings" db=0.6ms queue=0.2ms idle=955.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:18.620 [debug] QUERY OK source="settings" db=0.7ms idle=956.1ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:18.621 [debug] QUERY OK source="settings" db=0.4ms idle=957.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:18.622 [debug] QUERY OK source="settings" db=0.3ms idle=959.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:18.623 [debug] QUERY OK source="settings" db=0.1ms idle=650.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:36:18.624 [info] Sent 200 in 7ms

17:36:18.720 [info] CONNECTED TO Phoenix.LiveView.Socket in 54µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "CD17Gx4kM2k7CSAMKARYdF81FgoAJ1kpdEInVBQQmysgYJo7mZpOTi7b", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:36:18.725 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:36:18.725 [debug] Replied in 255µs

17:36:19.828 [info] GET /download_logs

17:36:19.829 [debug] Processing with PinchflatWeb.Settings.SettingController.download_logs/2
  Parameters: %{}
  Pipelines: [:browser]

17:36:19.830 [info] Sent 200 in 1ms

17:36:38.770 [info] GET /healthcheck

17:36:38.770 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:36:38.770 [info] Sent 200 in 265µs

17:37:08.870 [info] GET /healthcheck

17:37:08.870 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:37:08.870 [info] Sent 200 in 295µs

17:37:38.962 [info] GET /healthcheck

17:37:38.962 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:37:38.962 [info] Sent 200 in 247µs

17:37:48.715 [info] GET /download_logs

17:37:48.715 [debug] Processing with PinchflatWeb.Settings.SettingController.download_logs/2
  Parameters: %{}
  Pipelines: [:browser]

17:37:48.716 [info] Sent 200 in 1ms

17:37:53.864 [info] GET /app_info

17:37:53.865 [debug] Processing with PinchflatWeb.Settings.SettingController.app_info/2
  Parameters: %{}
  Pipelines: [:browser]

17:37:53.866 [debug] QUERY OK source="settings" db=0.6ms queue=0.1ms idle=1203.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:37:53.867 [debug] QUERY OK source="settings" db=0.3ms idle=640.4ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:37:53.868 [debug] QUERY OK source="settings" db=0.2ms queue=0.1ms idle=205.2ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:37:53.870 [debug] QUERY OK source="settings" db=0.2ms idle=206.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:37:53.870 [debug] QUERY OK source="settings" db=0.2ms idle=207.1ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:37:53.872 [info] Sent 200 in 7ms

17:37:53.959 [info] CONNECTED TO Phoenix.LiveView.Socket in 61µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "VSlFLAkhWgESRBgxAy96CHNbKCsnOjk49QwYAG89D4KZraMKA4NnstWs", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:37:53.965 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:37:53.965 [debug] Replied in 302µs

17:37:56.583 [info] GET /download_logs

17:37:56.583 [debug] Processing with PinchflatWeb.Settings.SettingController.download_logs/2
  Parameters: %{}
  Pipelines: [:browser]

17:37:56.584 [info] Sent 200 in 1ms

17:38:09.047 [info] GET /healthcheck

17:38:09.047 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:38:09.047 [info] Sent 200 in 216µs

17:38:25.724 [info] GET /

17:38:25.724 [debug] Processing with PinchflatWeb.Pages.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]

17:38:25.725 [debug] QUERY OK source="settings" db=0.3ms idle=414.8ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:25.726 [debug] QUERY OK source="media_profiles" db=0.5ms idle=63.0ms
SELECT count(m0."id") FROM "media_profiles" AS m0 []

17:38:25.727 [debug] QUERY OK source="sources" db=0.2ms queue=0.1ms idle=63.8ms
SELECT count(s0."id") FROM "sources" AS s0 []

17:38:25.727 [debug] QUERY OK source="media_items" db=0.2ms idle=64.4ms
SELECT sum(m0."media_size_bytes") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:25.728 [debug] QUERY OK source="media_items" db=0.2ms idle=64.8ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:25.729 [debug] QUERY OK source="settings" db=0.5ms idle=2.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:25.730 [debug] QUERY OK source="settings" db=0.5ms idle=2.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:25.730 [debug] QUERY OK source="settings" db=0.2ms idle=3.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:25.732 [debug] QUERY OK source="tasks" db=0.4ms idle=3.8ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:25.733 [debug] QUERY OK source="media_items" db=0.3ms queue=0.1ms idle=4.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:25.734 [debug] QUERY OK source="media_items" db=0.5ms queue=0.1ms idle=4.2ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:25.734 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=4.4ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:25.738 [debug] QUERY OK source="media_items" db=0.5ms idle=6.4ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:25.739 [debug] QUERY OK source="media_items" db=0.6ms queue=0.1ms idle=6.1ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:25.739 [debug] QUERY OK source="sources" db=0.2ms idle=6.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:25.742 [info] Sent 200 in 17ms

17:38:25.831 [info] CONNECTED TO Phoenix.LiveView.Socket in 63µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "Axd3ECpTIFUiMjkTOxtwNXU2FTQ5NAt-ooEeb5BmtBjxJUGvGYsqmze5", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:38:25.837 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded"}

17:38:25.838 [debug] QUERY OK source="media_items" db=0.6ms queue=0.1ms idle=103.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:25.839 [debug] QUERY OK source="media_items" db=0.7ms queue=0.1ms idle=103.8ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:25.840 [debug] QUERY OK source="sources" db=0.5ms queue=0.1ms idle=102.0ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:25.840 [debug] Replied in 3ms

17:38:25.843 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending"}

17:38:25.844 [debug] QUERY OK source="media_items" db=0.5ms idle=105.1ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:25.845 [debug] QUERY OK source="media_items" db=0.7ms idle=105.2ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:25.846 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=7.9ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:25.847 [debug] Replied in 3ms

17:38:25.849 [debug] MOUNT Pinchflat.Pages.JobTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:25.850 [debug] QUERY OK source="tasks" db=0.3ms idle=10.2ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:25.850 [debug] Replied in 1ms

17:38:25.851 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:25.851 [debug] Replied in 174µs

17:38:30.177 [info] GET /

17:38:30.177 [debug] Processing with PinchflatWeb.Pages.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]

17:38:30.179 [debug] QUERY OK source="settings" db=0.7ms queue=0.1ms idle=857.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:30.180 [debug] QUERY OK source="media_profiles" db=0.3ms idle=516.7ms
SELECT count(m0."id") FROM "media_profiles" AS m0 []

17:38:30.180 [debug] QUERY OK source="sources" db=0.2ms idle=517.3ms
SELECT count(s0."id") FROM "sources" AS s0 []

17:38:30.181 [debug] QUERY OK source="media_items" db=0.3ms idle=517.8ms
SELECT sum(m0."media_size_bytes") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:30.181 [debug] QUERY OK source="media_items" db=0.2ms queue=0.1ms idle=518.5ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:30.182 [debug] QUERY OK source="settings" db=0.1ms idle=3.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:30.182 [debug] QUERY OK source="settings" db=0.0ms idle=2.4ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:30.183 [debug] QUERY OK source="settings" db=0.1ms idle=2.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:30.184 [debug] QUERY OK source="tasks" db=0.2ms idle=2.6ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:30.184 [debug] QUERY OK source="media_items" db=0.3ms idle=2.6ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:30.185 [debug] QUERY OK source="media_items" db=0.4ms idle=2.6ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:30.186 [debug] QUERY OK source="sources" db=0.4ms idle=3.1ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:30.187 [debug] QUERY OK source="media_items" db=0.2ms idle=4.2ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:30.188 [debug] QUERY OK source="media_items" db=0.3ms idle=3.7ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:30.188 [debug] QUERY OK source="sources" db=0.1ms idle=3.6ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:30.190 [info] Sent 200 in 12ms

17:38:30.287 [info] CONNECTED TO Phoenix.LiveView.Socket in 62µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "VR9nBCYuE3I_XQAYOjZaC1MFHhANHCEb9gUqnHqJi-SsKxmHajxUYROP", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:38:30.292 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded"}

17:38:30.293 [debug] QUERY OK source="media_items" db=0.4ms idle=107.2ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:30.294 [debug] QUERY OK source="media_items" db=0.4ms idle=107.4ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:30.295 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=106.8ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:30.295 [debug] Replied in 2ms

17:38:30.299 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending"}

17:38:30.300 [debug] QUERY OK source="media_items" db=0.6ms idle=111.0ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:30.301 [debug] QUERY OK source="media_items" db=0.6ms idle=111.7ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:30.302 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=8.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:30.302 [debug] Replied in 3ms

17:38:30.304 [debug] MOUNT Pinchflat.Pages.JobTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:30.305 [debug] QUERY OK source="tasks" db=0.3ms idle=10.8ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:30.305 [debug] Replied in 1ms

17:38:30.306 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:30.306 [debug] Replied in 189µs

17:38:39.130 [info] GET /healthcheck

17:38:39.130 [debug] Processing with PinchflatWeb.HealthController.check/2
  Parameters: %{}
  Pipelines: [:api]

17:38:39.130 [info] Sent 200 in 221µs

17:38:56.069 [info] GET /

17:38:56.069 [debug] Processing with PinchflatWeb.Pages.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]

17:38:56.071 [debug] QUERY OK source="settings" db=0.4ms queue=0.1ms idle=681.0ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:56.072 [debug] QUERY OK source="media_profiles" db=0.4ms queue=0.1ms idle=408.3ms
SELECT count(m0."id") FROM "media_profiles" AS m0 []

17:38:56.072 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=409.2ms
SELECT count(s0."id") FROM "sources" AS s0 []

17:38:56.073 [debug] QUERY OK source="media_items" db=0.3ms idle=409.8ms
SELECT sum(m0."media_size_bytes") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:56.074 [debug] QUERY OK source="media_items" db=0.2ms idle=410.5ms
SELECT count(m0."id") FROM "media_items" AS m0 WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:56.074 [debug] QUERY OK source="settings" db=0.1ms idle=3.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:56.075 [debug] QUERY OK source="settings" db=0.2ms idle=2.6ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:56.075 [debug] QUERY OK source="settings" db=0.4ms idle=2.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:56.078 [debug] QUERY OK source="tasks" db=0.4ms idle=4.0ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:56.079 [debug] QUERY OK source="media_items" db=0.5ms idle=4.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:56.080 [debug] QUERY OK source="media_items" db=0.6ms idle=5.2ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:56.081 [debug] QUERY OK source="sources" db=0.2ms queue=0.1ms idle=5.8ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:56.084 [debug] QUERY OK source="media_items" db=0.6ms idle=7.9ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:56.085 [debug] QUERY OK source="media_items" db=0.7ms idle=6.6ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:56.086 [debug] QUERY OK source="sources" db=0.4ms idle=6.7ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:56.089 [info] Sent 200 in 19ms

17:38:56.191 [info] CONNECTED TO Phoenix.LiveView.Socket in 35µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "Wj9_HHBUE1piHgs9H3hnAlM3LBwFIj8F6GMi82qb4nXVn6PAaXJYQlQN", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:38:56.202 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "downloaded"}

17:38:56.203 [debug] QUERY OK source="media_items" db=0.3ms idle=121.8ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) []

17:38:56.204 [debug] QUERY OK source="media_items" db=0.5ms idle=119.4ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (NOT (m0."media_filepath" IS NULL)) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:56.205 [debug] QUERY OK source="sources" db=0.5ms idle=119.2ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:56.205 [debug] Replied in 2ms

17:38:56.208 [debug] MOUNT Pinchflat.Pages.HistoryTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK", "media_state" => "pending"}

17:38:56.210 [debug] QUERY OK source="media_items" db=0.5ms idle=122.5ms
SELECT count(m0."id") FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) []

17:38:56.211 [debug] QUERY OK source="media_items" db=0.6ms idle=46.7ms
SELECT m0."id", m0."uuid", m0."title", m0."media_id", m0."description", m0."original_url", m0."livestream", m0."short_form_content", m0."media_downloaded_at", m0."media_redownloaded_at", m0."uploaded_at", m0."upload_date_index", m0."duration_seconds", m0."playlist_index", m0."predicted_media_filepath", m0."media_filepath", m0."media_size_bytes", m0."thumbnail_filepath", m0."metadata_filepath", m0."nfo_filepath", m0."subtitle_filepaths", m0."prevent_download", m0."prevent_culling", m0."culled_at", m0."source_id", m0."inserted_at", m0."updated_at" FROM "media_items" AS m0 INNER JOIN "sources" AS s1 ON s1."id" = m0."source_id" INNER JOIN "media_profiles" AS m2 ON m2."id" = s1."media_profile_id" WHERE (((((NOT (NOT (m0."media_filepath" IS NULL)) AND NOT (m0."prevent_download" = 1)) AND ((s1."download_cutoff_date" IS NULL) OR date(m0."uploaded_at") >= s1."download_cutoff_date")) AND   CASE
    WHEN shorts_behaviour = 'only' AND livestream_behaviour = 'only' THEN
      livestream = true OR short_form_content = true
    WHEN shorts_behaviour = 'only' THEN
      short_form_content = true
    WHEN livestream_behaviour = 'only' THEN
      livestream = true
    WHEN shorts_behaviour = 'exclude' AND livestream_behaviour = 'exclude' THEN
      short_form_content = false AND livestream = false
    WHEN shorts_behaviour = 'exclude' THEN
      short_form_content = false
    WHEN livestream_behaviour = 'exclude' THEN
      livestream = false
    ELSE
      true
  END
) AND ((s1."title_filter_regex" IS NULL) OR regexp_like(m0."title", s1."title_filter_regex"))) AND (((s1."min_duration_seconds" IS NULL) OR duration_seconds >= s1."min_duration_seconds") AND ((s1."max_duration_seconds" IS NULL) OR duration_seconds <= s1."max_duration_seconds"))) ORDER BY m0."id" DESC LIMIT ? OFFSET ? [5, 0]

17:38:56.212 [debug] QUERY OK source="sources" db=0.3ms queue=0.1ms idle=7.9ms
SELECT s0."id", s0."enabled", s0."uuid", s0."custom_name", s0."description", s0."collection_name", s0."collection_id", s0."collection_type", s0."index_frequency_minutes", s0."fast_index", s0."use_cookies", s0."download_media", s0."last_indexed_at", s0."download_cutoff_date", s0."retention_period_days", s0."original_url", s0."title_filter_regex", s0."output_path_template_override", s0."min_duration_seconds", s0."max_duration_seconds", s0."series_directory", s0."nfo_filepath", s0."poster_filepath", s0."fanart_filepath", s0."banner_filepath", s0."marked_for_deletion_at", s0."media_profile_id", s0."inserted_at", s0."updated_at", s0."id" FROM "sources" AS s0 WHERE (s0."id" = ?) [1]

17:38:56.212 [debug] Replied in 3ms

17:38:56.215 [debug] MOUNT Pinchflat.Pages.JobTableLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:56.215 [debug] QUERY OK source="tasks" db=0.3ms idle=10.9ms
SELECT t0."id", t0."job_id", t0."source_id", t0."media_item_id", t0."inserted_at", t0."updated_at", o1."id", o1."state", o1."queue", o1."worker", o1."args", o1."meta", o1."tags", o1."errors", o1."attempt", o1."attempted_by", o1."max_attempts", o1."priority", o1."attempted_at", o1."cancelled_at", o1."completed_at", o1."discarded_at", o1."inserted_at", o1."scheduled_at" FROM "tasks" AS t0 LEFT OUTER JOIN "oban_jobs" AS o1 ON o1."id" = t0."job_id" WHERE (o1."state" IN (?)) AND (? IN (SELECT value FROM JSON_EACH(o1."tags"))) ORDER BY o1."attempted_at" DESC ["executing", "show_in_dashboard"]

17:38:56.216 [debug] Replied in 1ms

17:38:56.216 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:56.217 [debug] Replied in 171µs

17:38:59.286 [info] GET /app_info

17:38:59.287 [debug] Processing with PinchflatWeb.Settings.SettingController.app_info/2
  Parameters: %{}
  Pipelines: [:browser]

17:38:59.288 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=1624.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:59.289 [debug] QUERY OK source="settings" db=0.3ms queue=0.1ms idle=1625.5ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:59.290 [debug] QUERY OK source="settings" db=0.2ms idle=1626.9ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:59.291 [debug] QUERY OK source="settings" db=0.1ms idle=1627.7ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:59.291 [debug] QUERY OK source="settings" db=0.4ms idle=894.3ms
SELECT s0."id", s0."onboarding", s0."pro_enabled", s0."yt_dlp_version", s0."apprise_version", s0."apprise_server", s0."youtube_api_key", s0."route_token", s0."extractor_sleep_interval_seconds", s0."video_codec_preference", s0."audio_codec_preference" FROM "settings" AS s0 LIMIT 1 []

17:38:59.292 [info] Sent 200 in 6ms

17:38:59.387 [info] CONNECTED TO Phoenix.LiveView.Socket in 57µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "LxNUBH0iVnYmByk8BzlSdFE2NxECCF8PCkfq5D4NpwzWvwe7cYQTVF1D", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://192.168.1.5:8945/assets/app-04a31c3ed4640060e39893a158164078.css?vsn=d", "1" => "http://192.168.1.5:8945/assets/app-1865af1c05997c585cd177052872b1d6.js?vsn=d"}, "vsn" => "2.0.0"}

17:38:59.394 [debug] MOUNT Pinchflat.UpgradeButtonLive
  Parameters: :not_mounted_at_router
  Session: %{"_csrf_token" => "lx2uHfb8VpSkqN7C2ofETNnK"}

17:38:59.394 [debug] Replied in 350µs

@imsorrywhat
Copy link

Hey there! Thanks for the report (:

Would one of you mind going to an impacted Source, clicking Actions > Download Pending, wait a few minutes, then download + attach your logs? You can download your logs by visiting Config > App Info in-app 🤙

hello @kieraneglin . any updates on this one?

@kieraneglin
Copy link
Owner

No updates! I've been busy and haven't had much time to work on the app this week.

@z0gg reviewing those logs, I don't think they have the information I need. Are those logs pulled shortly after you try to manually download pending videos?

@imsorrywhat
Copy link

imsorrywhat commented Jan 24, 2025 •
edited
Loading

what? you're not coding pinchflat 24/7/365?! kidding!

i tried capturing logs but 1 of the stuck videos downloaded after a Download Pending attempt. And the others was a restricted video that required setting up cookies so all good again for my setup. thanks!

@z0gg
Copy link

z0gg commented Jan 25, 2025

Force Download actually work for me too but I would prefer it to be automated

@kieraneglin
Copy link
Owner

@z0gg did you go to "Force Download" on an individual livestream or did you click "Download Pending" on the source itself?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kieraneglin kieraneglin

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@kieraneglin @z0gg @imsorrywhat @chrisrae75