Loading Execution Throws: Unterminated string in JSON at position 65535

Hi,
Since i’ve upgraded to 0.234.0
When trying to open the execution of some worksflows, i get Unterminated string in JSON at position 65535 and the loading spinner spins forever.
Is anyone aware of that?
It’s not for a specific workflow but with many. (not all though)

Information on your n8n setup

  • n8n version: 0.234.0
  • Database (default: SQLite): MySQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: I use the release from n8n artifactory, running in k8s 1.18

Hi @Raggingpuppies, I am so sorry you are having trouble.

I suspect this comes down to a problematic migration changing the data type of the execution data column from MEDIUMTEXT (which allows up to 16 MB) to TEXT (which allows the 65,535 B in your error message).

We actually removed the latest tag on the [email protected] image once we noticed this, so users don’t accidentally end up with this version.

Can you try upgrading to a more recent version of n8n? They should include a fix for this problem. This unfortunately wouldn’t restore old execution data, but it should at least fix the data type problem and hopefully prevent this from happening again in the future.

Further down the road you might want to consider switching to PostgreSQL, as support for MySQL will be removed in a future version:

2 Likes

Yeah, we are aware of mysql deprecation.
Thanks for the answer, we will try to upgrade and hopefully it will solve the issue
Thanks again !!!

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.