Florian Micklich created STREAMPIPES-126:
--------------------------------------------
Summary: [Postgres Sink] Tries to Creating Table for each
incomming event
Key: STREAMPIPES-126
URL: https://issues.apache.org/jira/browse/STREAMPIPES-126
Project: StreamPipes
Issue Type: Bug
Affects Versions: 0.66.0, 0.67.0
Reporter: Florian Micklich
Fix For: 0.67.0
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:
{code:java}
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
{code}
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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
