Sql error: error returned from database: cached plan must not change result type
We've had this error on our jobs, any ideas?
11 Replies
This error stopped our workers for 5 days*
@heyenter that would be the case if you upgraded server and not workers for instance or not all your workers
Did you do such upgrade ?
It's strange because we hadn't dev anything for several days
Maybe of your container died and did a repull
We've just upgraded to the latest version today: backend, lsp and workers
Ah ok
but most updates don't change the query plan so this is most unfortunate
we did change it recently exceptionally
do you have an history of the events of your containers ?
If I look, I'll find the error ^^ ok so it was an update of the container that caused the shutdown of workers. Would you advise us to stay with one version (like 1.132.0) or the main?
Depends if you like auto-updates or not. I would say if you need stability over updates, pick a release
but we're improving the product really rapidly still so don't forget to pick new releases š
Ok thanks ruben !
I'd be happy to make a call in September with you and @.atoo
š
Sounds great!