[STREAMPIPES-278] Error on pipeline postgres - relation already exists

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 0.67.0
• Component/s: Pipeline Elements
• Labels: postgres postgresql suggestion-done suggestion-outdated
• Assignee: Tim Bossenmaier
• Reporter: Daniel Vitorino
• Created: 08/Jan/21 17:24
• Updated: 26/Nov/22 13:44
• Resolved: 17/Nov/22 17:30

Description

Hi.

There is an error on postgres module.
This message happens after I start the pipeline.

The table already exists, but streampipes instead of update it with the data, try to create the table again.

 

"14:16:27.178 SP [Thread-9] ERROR o.a.s.s.d.jvm.postgresql.PostgreSql - USERLOG - correspondingPipeline: ed13463d-01e9-4ab5-94fa-cc66791f6e33 - peURI: http://pipeline-elements-all-jvm:8090/sec/org.apache.streampipes.sinks.databases.jvm.postgresql/ed13463d-01e9-4ab5-94fa-cc66791f6e33-org.apache.streampipes.jIIFQqIanChHGIsXtAts-postgresql-3 - ERROR: relation "secagem_toggling" already exists"