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.

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

[v1.0.0b] - Error when purging group data exports #1711

Closed
5 tasks done
SteveDinn opened this issue Oct 8, 2022 · 0 comments · Fixed by #3314
Closed
5 tasks done

[v1.0.0b] - Error when purging group data exports #1711

SteveDinn opened this issue Oct 8, 2022 · 0 comments · Fixed by #3314
Labels
bug: confirmed bug Something isn't working good first issue Good for newcomers

Comments

@SteveDinn
Copy link

First Check

  • This is not a feature request
  • I added a very descriptive title to this issue.
  • I used the GitHub search to find a similar issue and didn't find it.
  • I searched the Mealie documentation, with the integrated search.
  • I already read the docs and didn't find an answer.

What is the issue you are experiencing?

Just decided to search through my logs and found this error happening with the scheduled background tasks

127.0.0.1:43132 - "GET /docs HTTP/1.1" 200
INFO: 06-Oct-22 11:19:50        Running daily callbacks
INFO: 06-Oct-22 11:19:50        purging expired registration tokens
INFO: 06-Oct-22 11:19:50        registration token purged
INFO: 06-Oct-22 11:19:50        purging password reset tokens
INFO: 06-Oct-22 11:19:50        password reset tokens purges
INFO: 06-Oct-22 11:19:50        purging group data exports
ERROR: 06-Oct-22 11:19:50       Error in scheduled task func='purge_group_data_exports': exception='(psycopg2.errors.UndefinedFunction) operator does not exist: character varying <= timestamp without time zone
LINE 3: WHERE group_data_exports.expires <= '2022-10-05T11:19:50.354...
                                         ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

[SQL: SELECT group_data_exports.created_at AS group_data_exports_created_at, group_data_exports.update_at AS group_data_exports_update_at, group_data_exports.id AS group_data_exports_id, group_data_exports.group_id AS group_data_exports_group_id, group_data_exports.name AS group_data_exports_name, group_data_exports.filename AS group_data_exports_filename, group_data_exports.path AS group_data_exports_path, group_data_exports.size AS group_data_exports_size, group_data_exports.expires AS group_data_exports_expires
FROM group_data_exports
WHERE group_data_exports.expires <= %(expires_1)s]
[parameters: {'expires_1': datetime.datetime(2022, 10, 5, 11, 19, 50, 354853)}]
(Background on this error at: https://sqlalche.me/e/14/f405)'
INFO: 06-Oct-22 11:19:50        Running hourly callbacks
INFO: 06-Oct-22 11:19:55        Running minutely callbacks

Deployment

Docker (Linux)

Deployment Details

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug: confirmed bug Something isn't working good first issue Good for newcomers
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants