SamTV12345 / PodFetch

A sleek and efficient podcast downloader.
https://samtv12345.github.io/PodFetch
Apache License 2.0
347 stars 25 forks source link

Database `Err` on gpodder sync #524

Closed wyattjsmith1 closed 9 months ago

wyattjsmith1 commented 9 months ago

Describe the bug

The bug seems to be the same as https://github.com/SamTV12345/PodFetch/issues/440, but that one was fixed and marked as resolved a month ago.

When performing a full sync, I get the following:

2024-01-02T22:44:14 ℹ️ - Actix runtime found; starting in Actix runtime                                                                                                                                                                                                                   
thread 'actix-rt|system:0|arbiter:0' panicked at src/models/subscription.rs:136:26:
called `Result::unwrap()` on an `Err` value: DatabaseError(Unknown, "column \"deleted\" is of type timestamp without time zone but expression is of type integer") 

This error was not occurring on the 4.5.x releases (to my knowledge).

Reproduction

Perform a full gpodder sync with a postgres database.

System Info

PodFetch: https://github.com/SamTV12345/PodFetch/pkgs/container/podfetch/162745937?tag=v4.6.0-7d4fa09

Running in kubernetes (k3s)
Postgres database
OIDC enabled
Syncing via gpodder with AntennaPod
I ran the required `podfetch users generate apiKey` after upgrading.

Used Package Manager

npm

Validations

SamTV12345 commented 9 months ago

image

Can you reproduce it somehow? I just tried it with the latest image and it worked.

wyattjsmith1 commented 9 months ago

Oh, I think I manually added a bad subscription. This can be closed.