My Apache Cayenne query run 2 times when I run my container with Testcontainers.

[ma-sharifi]

@bsideup
@andrus
Hi team; I have an issue with TestContainers. I need your help.
I use Apache Cayenne as ORM and TestContainers for running my postgresQL image. My application is a native image that was built by GraalVM.
Connection pool: agroal
OS: MacOS M2
Framework: Quarkus
Graalvm 17
When my database container ran with docker compose up command, I have log 1 ,while I got log 2 When I ran it with TestContainers :-(
The last 4 lines of the second log are addeditive!
1-

SELECT COUNT( * ) FROM test t0 WHERE ...
=== returned 1 row. - took 23 ms.
select nextval('seq_test') as "value" [user: ]
=== returned 1 row. - took 3 ms.
SELECT nextval('pk_test')
INSERT INTO test...
=== updated 1 row.
SELECT (21 columns) FROM test t0 WHERE ....
=== returned 1 row. - took 4 ms.

2-

SELECT COUNT( * ) FROM test t0 WHERE ...
=== returned 1 row. - took 8 ms.
select nextval('seq_test') as "value" [user: ]
=== returned 1 row. - took 1 ms.
SELECT nextval('pk_test')
INSERT INTO test...
=== updated 1 row.
SELECT (21 columns) FROM test t0 WHERE ...
=== returned 0 rows. - took 2 ms.
SELECT nextval('pk_user')
INSERT INTO test...
*** error.: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "test_pkey"
  Detail: Key (id)=(1) already exists.

@Slf4j
public class PostgresResource implements QuarkusTestResourceLifecycleManager
{
  static PostgreSQLContainer<?> db = new PostgreSQLContainer<>("postgres")//
      .withDatabaseName("test").withUsername("test").withPassword("test");

  @Override
  public Map<String, String> start()
  {
    db.start();
    String connectionString = "jdbc:postgresql://" + db.getContainerIpAddress() + ":" + db.getFirstMappedPort() + "/" + db.getDatabaseName();
    log.info("##Container started! connectionString: " + connectionString);
    Runtime.getRuntime().addShutdownHook(new Thread(() -> {
      log.info("****** DockerContainers stop******");
      db.stop();
    }));
    return Collections.singletonMap("quarkus.datasource.jdbc.url", connectionString); //The same as above
  }

  @Override
  public void stop()
  {
    db.stop();//Shut down the database after all tests have been executed
    log.info("##Container stopped");
  }
}

[gsmet]

I think you probably need to debug your Apache Cayenne setup.

[ma-sharifi]

Thanks for the fast reply.
I run my test with the following command.
mvn test-compile failsafe:integration-test

I dunno how to debug it in Native image:-( Would it be possible to give me a link?
It does not occur with docker-compose and appears when I'm using TestContainers.

[ma-sharifi]

When I comment some modules in my context creator, The problem is solved:

    runtime = ServerRuntime.builder() 
        .dataSource(dataSource) 
        .addConfigs(config.configurationLocations()) 
        .addModule(new ServerModule()) // added because of Native Imge
//        .addModule(CommitLogModule.extend().commitLogAnnotationEntitiesOnly().addListener(cayenneCommitLogger).module()) //
        .build();

//    LifecycleCallbackRegistry registry = runtime.getDataDomain().getEntityResolver().getCallbackRegistry();
//    for (Class<?> clazz : config.lockedClasses())
//      registry.addCallback(LifecycleEvent.PRE_UPDATE, clazz, "preUpdate");
    objectContext = runtime.newContext();
  }