jomarko commented on PR #2726: URL: https://github.com/apache/incubator-kie-tools/pull/2726#issuecomment-2475603037
### @kie-tools-examples/process-compact-architecture 🔴 I am not able to use `startContainers` script Getting these exceptions: ``` process-compact-architecture-service | ------------------------------------------------------- process-compact-architecture-service | SQL State : 42P07 process-compact-architecture-service | Error Code : 0 process-compact-architecture-service | Message : ERROR: relation "process_instances" already exists process-compact-architecture-service | Location : kie-flyway/db/persistence-jdbc/postgresql/V1.35.0__create_runtime_PostgreSQL.sql (/home/jboss/file:/home/jboss/lib/main/org.kie.kie-addons-persistence-jdbc-999-20241016-SNAPSHOT.jar!/kie-flyway/db/persistence-jdbc/postgresql/V1.35.0__create_runtime_PostgreSQL.sql) process-compact-architecture-service | Line : 21 process-compact-architecture-service | Statement : -- process-compact-architecture-service | -- Licensed to the Apache Software Foundation (ASF) under one process-compact-architecture-service | -- or more contributor license agreements. See the NOTICE file process-compact-architecture-service | -- distributed with this work for additional information process-compact-architecture-service | -- regarding copyright ownership. The ASF licenses this file process-compact-architecture-service | -- to you under the Apache License, Version 2.0 (the process-compact-architecture-service | -- "License"); you may not use this file except in compliance process-compact-architecture-service | -- with the License. You may obtain a copy of the License at process-compact-architecture-service | -- process-compact-architecture-service | -- http://www.apache.org/licenses/LICENSE-2.0 process-compact-architecture-service | -- process-compact-architecture-service | -- Unless required by applicable law or agreed to in writing, process-compact-architecture-service | -- software distributed under the License is distributed on an process-compact-architecture-service | -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY process-compact-architecture-service | -- KIND, either express or implied. See the License for the process-compact-architecture-service | -- specific language governing permissions and limitations process-compact-architecture-service | -- under the License. process-compact-architecture-service | -- process-compact-architecture-service | process-compact-architecture-service | -- To be used with kie-addons-quarkus-persistence-jdbc for Quarkus or kie-addons-springboot-persistence-jdbc for SpringBoot process-compact-architecture-service | CREATE TABLE process_instances process-compact-architecture-service | ( process-compact-architecture-service | id character(36) NOT NULL, process-compact-architecture-service | payload bytea NOT NULL, process-compact-architecture-service | process_id character varying NOT NULL, process-compact-architecture-service | version bigint, process-compact-architecture-service | process_version character varying, process-compact-architecture-service | CONSTRAINT process_instances_pkey PRIMARY KEY (id) process-compact-architecture-service | ) process-compact-architecture-service | process-compact-architecture-service | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:267) process-compact-architecture-service | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:222) process-compact-architecture-service | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) process-compact-architecture-service | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:68) process-compact-architecture-service | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:57) process-compact-architecture-service | at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) process-compact-architecture-service | at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:56) process-compact-architecture-service | at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:374) process-compact-architecture-service | ... 36 more process-compact-architecture-service | Caused by: org.postgresql.util.PSQLException: ERROR: relation "process_instances" already exists process-compact-architecture-service | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725) process-compact-architecture-service | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412) process-compact-architecture-service | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:341) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:326) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:302) process-compact-architecture-service | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:297) process-compact-architecture-service | at io.agroal.pool.wrapper.StatementWrapper.execute(StatementWrapper.java:220) process-compact-architecture-service | at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:201) process-compact-architecture-service | at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:95) process-compact-architecture-service | at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:210) process-compact-architecture-service | ... 42 more process-compact-architecture-service | process-compact-architecture-service exited with code 1 ``` Sounds to me like some additional cleanup of local environment is needed before I start this example, if that is the reason I think we need to share such information in README. I did: - KIE_TOOLS_BUILD__buildExamples=true pnpm -F @kie-tools-examples/process-compact-architecture^... build:dev - cd examples/process-compact-architecture - mvn clean package -Pcontainer - cd docker-compose - sh startContainers.sh full **mvn clean package quarkus:dev** seems to work fine 🟢 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
