Yicong-Huang opened a new issue, #6144: URL: https://github.com/apache/texera/issues/6144
### Task Summary After pulling main, a newly added `sql/updates/N.sql` breaks `bin/local-dev.sh up`: jOOQ codegen reads the live postgres at sbt-compile time and fails with `not found: value <NEW_TABLE>` (seen with 27.sql / `workflow_cover_image`). `infra_ensure_db_schema` only bootstraps `sql/texera_ddl.sql` on a fresh DB; nothing applies updates to an existing local DB — the official `sql/docker-compose.yml` liquibase runner is manual, undocumented, and its creds don't match local-dev's. Teach local-dev to reconcile the schema before any build: parse the changeSets from `sql/changelog.xml`, compare with liquibase's `databasechangelog` table, and psql-apply the missing `sql/updates/N.sql` in order, recording applications in `databasechangelog` (liquibase-compatible, MD5SUM left NULL for recompute). On fresh bootstrap, seed all changeSets as applied (the DDL already contains them). Fail fast with a clear message if an update errors. ### Task Type - [x] Refactor / Cleanup - [x] DevOps / Deployment / CI - [ ] Testing / QA - [ ] Documentation - [ ] Performance - [ ] Other -- 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]
