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

工单获取不到回调信息,工单状态无法变更 #2767

Open
cslingjun opened this issue Aug 20, 2024 · 1 comment
Open

工单获取不到回调信息,工单状态无法变更 #2767

cslingjun opened this issue Aug 20, 2024 · 1 comment

Comments

@cslingjun
Copy link
Contributor

cslingjun commented Aug 20, 2024

重现步骤

1、从1.8.5docker部署,升级到1.11.0 k8s部署
2、django_q_task数据进行全量迁移,该表有200W+数据
3、迁移完后,执行工单,工单状态一直在执行中,拿不到回调请求 ,经过排查发现,在DB会执行下面语句,并且会超时
image
然后在qcluster.log中也发现对应错误日志
image

预期外的结果

在1.8.5中应该是不会执行下面这样的语句的 ,因为我拿这条语句在1.8.5下面同样是慢的。这算是个坑吧 ,也排查了大半天了。
最终把django_q_task备份后,进行truncate后,就好了,工单状态扭转成功

SELECT `django_q_task`.`id`, `django_q_task`.`name`, `django_q_task`.`func`, `django_q_task`.`hook`, `django_q_task`.`args`, `django_q_task`.`kwargs`, `django_q_task`.`result`, `django_q_task`.`group`, `django_q_task`.`started`, `django_q_task`.`stopped`, `django_q_task`.`success`, `django_q_task`.`attempt_count` FROM `django_q_task` WHERE `django_q_task`.`success` = 1 ORDER BY `django_q_task`.`stopped` ASC LIMIT 1 FOR UPDATE

日志文本

No response

版本

1.11.0

部署方式

K8S

是否还有其他可以辅助定位问题的信息?比如数据库版本等

No response

@LeoQuote
Copy link
Collaborator

感谢反馈,可以直接编辑项目文档

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants