[STREAMPIPES-126] [Postgres Sink] Tries to Creating Table for each incomming event

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.66.0, 0.67.0
• Fix Version/s: 0.68.0
• Assignee: Tim Bossenmaier
• Reporter: Florian Micklich
• Created: 14/May/20 12:51
• Updated: 26/Nov/22 12:55
• Resolved: 16/Mar/21 14:17

Description

Hi,

I simple creates a random stream adapter and used the postgres sink together with the internal docker postgres container ( user1 ...)

The pipeline is starting without error but I get a console error:

14:37:12.627 SP [Thread-2] ERROR o.a.s.s.d.jvm.postgresql.PostgreSql - USERLOG - correspondingPipeline: 37cad1cf-a7cc-468e-8c23-aadf964728cb - peURI: http://host.docker.internal:7015/sec/org.apache.streampipes.sinks.databases.jvm.postgresql/37cad1cf-a7cc-468e-8c23-aadf964728cb-org.apache.streampipes.SRIOtjvrYzNxYSAFsyJz-postgresql-3 - ERROR: relation "table" already exists

It seems to me that the create table statement is used on each event (onEvent-method) and not in the onInvocation method.

The table is created and can't be created again because the name is already used.
So no data is stored at the moment in the sink.