querybook icon indicating copy to clipboard operation
querybook copied to clipboard

tasks list is empty

Open brianmay opened this issue 1 year ago • 8 comments

If I try to list the tasks it is always empty. Reloading the page doesn't help.

But if I try to create the task I just created, it complains that there is already a task with that name. And I can clearly see the tasks in the task_schedule table.

brianmay avatar Oct 18 '23 01:10 brianmay

I think this is the same issue as https://github.com/pinterest/querybook/pull/1329?

baumandm avatar Oct 19 '23 14:10 baumandm

It could be, will try that fix.

Thanks for the reference.

brianmay avatar Oct 19 '23 21:10 brianmay

That mostly fixes the problem.

I notice that my task_schedule table has a celery.backend_cleanup task - appears to have been automatically created - that still does not appear in the list however.

brianmay avatar Oct 19 '23 22:10 brianmay

Does the celery.backend_cleanup task still have the incorrect type in the db? You would need to recreate or edit the task for the fix in https://github.com/pinterest/querybook/pull/1329 to take effect.

adamstruck avatar Oct 20 '23 02:10 adamstruck

I quoted the type above - it is celery.backend_cleanup - which looks OK to me.

brianmay avatar Oct 20 '23 03:10 brianmay

More specifically, I meant the task_type field in the task_schedule database table for the celery.backend_cleanup row. This is what my PR you linked changes - you'd have to reinitialize your database for the automatically created tasks to pick up this change.

adamstruck avatar Oct 21 '23 21:10 adamstruck

Yes, that is what I was looking at.

brianmay avatar Oct 22 '23 02:10 brianmay

thanks @adamstruck for the PR. I was in a PTO, just merged it.

jczhong84 avatar Oct 24 '23 04:10 jczhong84