ERROR: invalid byte sequence for encoding "UTF8": 0x00

[anushanagireddy0430]

Component(s)

extension/storage/dbstorage

What happened?

Description

We are running opentelemetry collector in mode: Daemonset which is managed by operator in a 4 node kubernetes clutser.

To use filestorage extension, hostPath volume is not recommended at a production level as we are running collector as a Daemonset.

To implement persistence we have configured postgresdb storage extension for metrics,logs and traces telemetry data.

Steps to Reproduce

1. Install operator using helm chart opentelemetry-operator-0.83.0
2. Deploy Opentelemetrycollector CR with contrib version - 0.120.0 in mode: Daemonset
3. Attached collector yaml and logs
4. Deploy postgres v14

collector.txt

logs.txt

Actual Result

Same error logs in postgres as well
2025-04-02 02:47:53.169 UTC [1618] ERROR: invalid byte sequence for encoding "UTF8": 0x00
2025-04-02 02:47:53.169 UTC [1618] CONTEXT: unnamed portal parameter $2
2025-04-02 02:47:53.169 UTC [1618] STATEMENT: insert into exporter_loki__logs(key, value) values($1,$2) on conflict(key) do update set value=$3

Let me know what configurations I am missing, or any other persistence solutions.

Collector version

0.120.0

Environment information

Environment

AKS - v1.28.5

OpenTelemetry Collector configuration

Log output

Additional context

No response

[github-actions]

Pinging code owners:

• extension/storage/dbstorage: @dmitryax @atoulme

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[iblancasa]

Can you try to reproduce the issue without using the operator? I think it should not be an issue in the operator but want to discard that possibility.