[
https://issues.apache.org/jira/browse/NIFI-11879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Clow updated NIFI-11879:
------------------------
Description:
For some reason, we should specify classifer for maven-source-plugin and
maven-jar-plugin, it works fine for maven package instuction. But when we want
to install those jars into local repository and remote nexus. it gets below,
!image-2023-07-31-11-52-04-874.png|width=973,height=519!
h2. Reproduce behaviour
add plugins into pom.xml and specify classifiers. pasted code snippet below.
{code:java}
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-source-plugin</artifactId>
<configuration>
<classifier>provided-sources</classifier>
</configuration>
<executions>
<execution>
<id>attach-sources</id>
<goals>
<goal>jar</goal>
</goals>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-jar-plugin</artifactId>
<configuration>
<classifier>provided</classifier>
</configuration>
</plugin>
</plugins>
</build> {code}
and then execute maven command below,
{code:java}
mvn clean install // or mvn clean deploy{code}
h2. Workaround
downgrade maven install plugin from 3.1.0 to 2.5.2, it works fine.
was:
For some reason, we should specify classifer for maven-source-plugin and
maven-jar-plugin, it works fine for maven package instuction. But when we want
to install those jars into local repository and remote nexus. it gets below,
!image-2023-07-31-11-52-04-874.png|width=973,height=519!
h2. Reproduce behaviour
Create a table in your *PostgreSQL* database
{code:java}
CREATE TABLE test_table
(
"TIME_PERIOD" date NOT NULL,
"R0102" numeric,
"R0203" numeric,
"R0304" numeric,
"R0405" numeric,
"R0506" numeric,
"R0607" numeric,
"R0708" numeric,
"R0809" numeric,
"R0910" numeric,
modified_at_utc date DEFAULT timezone('UTC'::text, CURRENT_TIMESTAMP(0)),
CONSTRAINT test_table PRIMARY KEY ("TIME_PERIOD")
) {code}
Use attached avro to write to the table using a PutDatabaseRecord Processor
configured with UPSERT.
Nifi will throw following Exception in the Bulletin Board
{code:java}
PutDatabaseRecord[id=...] Failed to put Records to database for
FlowFile[filename=redacted.avro]. Routing to failure.:
java.sql.BatchUpdateException: Batch entry 0 INSERT INTO
"public"."test_table"("TIME_PERIOD", "R0102", "R0203", "R0304", "R0405",
"R0506", "R0607", "R0708", "R0809", "R0910") VALUES ('2022-10-21 +00',
'2.97'::numeric, '3.2'::numeric, '3.19'::numeric, '3.19'::numeric,
'3.22'::numeric, '3.33'::numeric, '3.33'::numeric, '3.4'::numeric,
'3.38'::numeric) ON CONFLICT (TIME_PERIOD) DO UPDATE SET ("TIME_PERIOD",
"R0102", "R0203", "R0304", "R0405", "R0506", "R0607", "R0708", "R0809",
"R0910") = (EXCLUDED."TIME_PERIOD", EXCLUDED."R0102", EXCLUDED."R0203",
EXCLUDED."R0304", EXCLUDED."R0405", EXCLUDED."R0506", EXCLUDED."R0607",
EXCLUDED."R0708", EXCLUDED."R0809", EXCLUDED."R0910") was aborted: ERROR:
column "time_period" does not exist
Position: 347 Call getNextException to see other errors in the batch.
- Caused by: org.postgresql.util.PSQLException: ERROR: column "time_period"
does not exist
Position: 347 {code}
h3. Generated SQL Statement
Nifi generates and issues following SQL Statement to the database:
{code:java}
INSERT INTO "public"."test_table"("TIME_PERIOD", "R0102", "R0203", "R0304",
"R0405", "R0506", "R0607", "R0708", "R0809", "R0910") VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?) ON CONFLICT (TIME_PERIOD) DO UPDATE SET ("TIME_PERIOD", "R0102",
"R0203", "R0304", "R0405", "R0506", "R0607", "R0708", "R0809", "R0910") =
(EXCLUDED."TIME_PERIOD", EXCLUDED."R0102", EXCLUDED."R0203", EXCLUDED."R0304",
EXCLUDED."R0405", EXCLUDED."R0506", EXCLUDED."R0607", EXCLUDED."R0708",
EXCLUDED."R0809", EXCLUDED."R0910") {code}
This statement only works with quoted _TIME_PERIOD_ in the _ON CONFLICT_ clause
due to the behaviour of postgres described in Section _Root Cause_
h2. Workaround
downgrade
> Maven install&deploy command not work while specifing classifier for
> generated jars.
> ------------------------------------------------------------------------------------
>
> Key: NIFI-11879
> URL: https://issues.apache.org/jira/browse/NIFI-11879
> Project: Apache NiFi
> Issue Type: Bug
> Components: Extensions
> Affects Versions: 1.21.0
> Reporter: Clow
> Assignee: Nathan Gough
> Priority: Minor
> Attachments: image-2023-07-31-11-52-04-874.png
>
>
> For some reason, we should specify classifer for maven-source-plugin and
> maven-jar-plugin, it works fine for maven package instuction. But when we
> want to install those jars into local repository and remote nexus. it gets
> below,
> !image-2023-07-31-11-52-04-874.png|width=973,height=519!
> h2. Reproduce behaviour
> add plugins into pom.xml and specify classifiers. pasted code snippet below.
> {code:java}
> <build>
> <plugins>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-source-plugin</artifactId>
> <configuration>
> <classifier>provided-sources</classifier>
> </configuration>
> <executions>
> <execution>
> <id>attach-sources</id>
> <goals>
> <goal>jar</goal>
> </goals>
> </execution>
> </executions>
> </plugin>
> <plugin>
> <groupId>org.apache.maven.plugins</groupId>
> <artifactId>maven-jar-plugin</artifactId>
> <configuration>
> <classifier>provided</classifier>
> </configuration>
> </plugin>
> </plugins>
> </build> {code}
> and then execute maven command below,
> {code:java}
> mvn clean install // or mvn clean deploy{code}
> h2. Workaround
> downgrade maven install plugin from 3.1.0 to 2.5.2, it works fine.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
