# Run 1: the poisoned duplicate at row 47 fails the whole chunk

$ java -jar target/spring-batch-1.0.0.jar --spring.profiles.active=broken \
    --import.file=file:scenario-data/restart-demo/input.csv \
    --spring.datasource.url=jdbc:h2:file:.../scenario-data/restart-demo/db

2026-09-13T06:23:09.122Z  INFO 5302 --- [           main] o.s.batch.core.step.AbstractStep         : Executing step: [importStep]
2026-09-13T06:23:09.162Z  WARN 5302 --- [           main] c.a.b.p.ProductValidatingProcessor       : filtering abc-0012: does not match ^[A-Z]{3}-\d{4}$
2026-09-13T06:23:09.176Z  WARN 5302 --- [           main] c.a.b.p.ProductValidatingProcessor       : filtering ABC-0033: priceCents must be positive, was 0
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO PRODUCT (sku, name, price_cents) VALUES (?, ?, ?)]; Unique index or primary key violation: "PUBLIC.CONSTRAINT_18 INDEX PUBLIC.CONSTRAINT_INDEX_1 ON PUBLIC.PRODUCT(SKU NULLS FIRST) VALUES ( /* 5 */ 'ABC-0005' )"; SQL statement:
Caused by: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO PRODUCT (sku, name, price_cents) VALUES (?, ?, ?)]; Unique index or primary key violation: "PUBLIC.CONSTRAINT_18 INDEX PUBLIC.CONSTRAINT_INDEX_1 ON PUBLIC.PRODUCT(SKU NULLS FIRST) VALUES ( /* 5 */ 'ABC-0005' )"; SQL statement:
2026-09-13T06:23:09.205Z  INFO 5302 --- [           main] o.s.batch.core.step.AbstractStep         : Step: [importStep] executed in 85ms
JOB FINISHED: status=FAILED exitCode=FAILED

$ SELECT status, read_count, filter_count, write_count, commit_count, rollback_count FROM BATCH_STEP_EXECUTION;
STATUS | READ_COUNT | FILTER_COUNT | WRITE_COUNT | COMMIT_COUNT | ROLLBACK_COUNT
FAILED | 50         | 2            | 38          | 4            | 1
(1 row, 21 ms)

$ SELECT COUNT(*) FROM PRODUCT;
COUNT(*)
38
(1 row, 20 ms)
