Tasks Returning `\u0000` and `/u0000` keeps the execution stuck in RUNNING state.

[caxefaizan]

Describe the issue

Reported in version 0.22.x and validated in 0.23.7 as well

Reproducible Steps:
with nodejs

id: test
namespace: staging
tasks:
  - id: test
    type: io.kestra.plugin.scripts.node.Script
    containerImage: '{{kv("DOCKER_IMAGE")}}'
    script: |
      const Kestra = require('@kestra-io/libs');
      const result = '\u0000'
      Kestra.outputs({ result: result }); 

with python

id: eland_604547
namespace: company.team
labels:
  customer: synsel

tasks:
  - id: test
    type: io.kestra.plugin.scripts.python.Script
    beforeCommands:
      - pip install kestra
    script: |
      from kestra import Kestra
      result = '\u0000'
      Kestra.outputs({ result: result }); 

Had to kill the task

But i still see RUNNING state in logs

Environment

• Kestra Version: 0.23.x

[loicmathieu]

This is tricky, \u0000 is a unicode sequence that has no textual representation.
Postgres refuses such unicode sequence inside a JSONB column which is correct.

The only way I can think of is to sanitize the string, but this would be arbitrary.
I'll discuss it internally.

[anna-geller]

next steps: check on Elastic to validate if we need to fix serialization on JDBC

[loicmathieu]

After internal discussion, the decision has been taken to fail the task if it contains unsupported unicode sequence.
The rational is that if it's unsupported by the database, you should not use it, and there is no good replacement for it.