hansva opened a new issue, #9249: URL: https://github.com/apache/hop/issues/9249
### Apache Hop version? 2.20.0 ### Java version? 21 ### Operating system macOS ### What happened? **Description** `prepareSchemaAndCommitMode()` calls `setCommit(0)` to run the schema DDL with autocommit on (create table, HNSW index, mapped-column ALTERs), then sets the commit size again. On a transactional pipeline (connection group), that connection is shared with other transforms. Switching it to autocommit commits their open work, and then leaves the connection in PgVector Upsert's commit mode instead of the pipeline's. **To reproduce** 1. Build a transactional pipeline (shared connection) with PgVector Upsert plus another writing transform on the same connection. 2. Turn on "create table if missing", "create HNSW index", or column mappings. 3. Make the pipeline fail after the other transform has written rows. **Expected:** the pipeline rolls back as one transaction. **Actual:** the other transform's rows may already have been committed by the DDL step. ### Issue Priority Priority: 2 ### Issue Component Component: Database -- 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]
