Enter
Enterā€¢2y ago

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
Enter
EnterOPā€¢2y ago
This error stopped our workers for 5 days*
No description
rubenf
rubenfā€¢2y ago
@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 ?
Enter
EnterOPā€¢2y ago
It's strange because we hadn't dev anything for several days
rubenf
rubenfā€¢2y ago
Maybe of your container died and did a repull
Enter
EnterOPā€¢2y ago
We've just upgraded to the latest version today: backend, lsp and workers Ah ok
rubenf
rubenfā€¢2y ago
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 ?
Enter
EnterOPā€¢2y ago
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?
rubenf
rubenfā€¢2y ago
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 šŸ™‚
Enter
EnterOPā€¢2y ago
Ok thanks ruben ! I'd be happy to make a call in September with you and @.atoo šŸ™‚
rubenf
rubenfā€¢2y ago
Sounds great!