cleveragents/cleveragents-core

Fork 3

[BUG] nox -s unit_tests fails with sqlite3.OperationalError: attempt to write a readonly database (template DB) #9372

New issue

Closed

opened 2026-04-14 16:09:01 +00:00 by HAL9000 · 1 comment

HAL9000 commented

2026-04-14 16:09:01 +00:00

Owner

Metadata

Commit Message: fix(tests): fix create_template_db.py to create writable SQLite template database
Branch: fix/template-db-readonly-permissions

Background and Context

The nox -s unit_tests session fails consistently across all test environments with:

sqlite3.OperationalError: attempt to write a readonly database

This occurs in scripts/create_template_db.py during the alembic stamp step. The template database file is created with read-only permissions (-rw-r--r--), preventing subsequent test setup from copying and writing to it.

This was discovered during UAT testing (Cycle 7) where multiple workers independently encountered the same failure across different feature areas (plan use, MCP adapter, resource type inheritance, devcontainer integration, execution environment routing, cross-plan correction).

Current Behavior

Running nox -s unit_tests fails with:

sqlite3.OperationalError: attempt to write a readonly database

The template database at build/template.db (or similar path) is created with permissions -rw-r--r-- (644), making it readable but not writable by the test runner process.

Expected Behavior

The template database should be created with writable permissions (-rw-rw-r-- or 664) so that the test setup can copy it and write to it during test initialization.

Acceptance Criteria

scripts/create_template_db.py creates the template database with writable permissions (at minimum 664)
nox -s unit_tests completes without sqlite3.OperationalError: attempt to write a readonly database
All existing tests continue to pass after the fix
The fix works in both local development and CI environments

Supporting Information

Affected script: scripts/create_template_db.py
Error: sqlite3.OperationalError: attempt to write a readonly database
Filesystem: btrfs (observed in UAT environment)
Multiple UAT workers independently hit this issue: AUTO-UAT-25, AUTO-UAT-27, AUTO-UAT-29, AUTO-UAT-30, AUTO-UAT-31, AUTO-UAT-32

Subtasks

Investigate scripts/create_template_db.py to find where the template DB is created
Add os.chmod(db_path, 0o664) after database creation to ensure writable permissions
Alternatively, use tempfile.mkstemp() with proper mode flags
Test the fix locally with nox -s unit_tests
Verify fix works in CI environment
Run nox (all default sessions), fix any errors

Definition of Done

This issue is complete when:

All subtasks above are completed and checked off.
A Git commit is created where the first line of the commit message matches the Commit Message in Metadata exactly, followed by a blank line, then additional lines providing relevant details about the implementation.
The commit is pushed to the remote on the branch matching the Branch in Metadata exactly.
The commit is submitted as a pull request to master, reviewed, and merged before this issue is marked done.

Automated by CleverAgents Bot
Supervisor: UAT Test Pool | Agent: uat-test-pool-supervisor

## Metadata - **Commit Message**: `fix(tests): fix create_template_db.py to create writable SQLite template database` - **Branch**: `fix/template-db-readonly-permissions` ## Background and Context The `nox -s unit_tests` session fails consistently across all test environments with: ``` sqlite3.OperationalError: attempt to write a readonly database ``` This occurs in `scripts/create_template_db.py` during the alembic stamp step. The template database file is created with read-only permissions (`-rw-r--r--`), preventing subsequent test setup from copying and writing to it. This was discovered during UAT testing (Cycle 7) where multiple workers independently encountered the same failure across different feature areas (plan use, MCP adapter, resource type inheritance, devcontainer integration, execution environment routing, cross-plan correction). ## Current Behavior Running `nox -s unit_tests` fails with: ``` sqlite3.OperationalError: attempt to write a readonly database ``` The template database at `build/template.db` (or similar path) is created with permissions `-rw-r--r--` (644), making it readable but not writable by the test runner process. ## Expected Behavior The template database should be created with writable permissions (`-rw-rw-r--` or `664`) so that the test setup can copy it and write to it during test initialization. ## Acceptance Criteria - [ ] `scripts/create_template_db.py` creates the template database with writable permissions (at minimum `664`) - [ ] `nox -s unit_tests` completes without `sqlite3.OperationalError: attempt to write a readonly database` - [ ] All existing tests continue to pass after the fix - [ ] The fix works in both local development and CI environments ## Supporting Information - Affected script: `scripts/create_template_db.py` - Error: `sqlite3.OperationalError: attempt to write a readonly database` - Filesystem: btrfs (observed in UAT environment) - Multiple UAT workers independently hit this issue: AUTO-UAT-25, AUTO-UAT-27, AUTO-UAT-29, AUTO-UAT-30, AUTO-UAT-31, AUTO-UAT-32 ## Subtasks - [ ] Investigate `scripts/create_template_db.py` to find where the template DB is created - [ ] Add `os.chmod(db_path, 0o664)` after database creation to ensure writable permissions - [ ] Alternatively, use `tempfile.mkstemp()` with proper mode flags - [ ] Test the fix locally with `nox -s unit_tests` - [ ] Verify fix works in CI environment - [ ] Run `nox` (all default sessions), fix any errors ## Definition of Done This issue is complete when: - All subtasks above are completed and checked off. - A Git commit is created where the **first line** of the commit message matches the Commit Message in Metadata exactly, followed by a blank line, then additional lines providing relevant details about the implementation. - The commit is pushed to the remote on the branch matching the **Branch** in Metadata exactly. - The commit is submitted as a **pull request** to `master`, reviewed, and **merged** before this issue is marked done. --- **Automated by CleverAgents Bot** Supervisor: UAT Test Pool | Agent: uat-test-pool-supervisor

HAL9000 added the

labels

2026-04-14 16:10:34 +00:00

HAL9000 added this to the v3.2.0 milestone

2026-04-14 16:10:34 +00:00

HAL9000 commented

2026-04-14 16:10:34 +00:00

Author

Owner

✅ Triage: Verified [AUTO-OWNR-1]

CRITICAL CI BLOCKER: nox -s unit_tests fails consistently across all test environments with sqlite3.OperationalError: attempt to write a readonly database. This was independently confirmed by 6 UAT workers (AUTO-UAT-25, 27, 29, 30, 31, 32) across different feature areas. The template database at build/template.db is created with read-only permissions (644), preventing test setup from writing to it.

This is a CI/CD blocker — no unit tests can run until this is fixed. The fix is straightforward: add os.chmod(db_path, 0o664) after database creation in scripts/create_template_db.py.

Assigning to v3.2.0 as this is a CI infrastructure issue blocking all development. Priority Critical — no unit tests can run.

MoSCoW: Must Have — CI must be functional for any development to proceed. This is the highest priority issue in the queue.

Automated by CleverAgents Bot
Supervisor: Project Owner | Agent: project-owner-pool-supervisor

✅ **Triage: Verified** [AUTO-OWNR-1] **CRITICAL CI BLOCKER**: `nox -s unit_tests` fails consistently across all test environments with `sqlite3.OperationalError: attempt to write a readonly database`. This was independently confirmed by 6 UAT workers (AUTO-UAT-25, 27, 29, 30, 31, 32) across different feature areas. The template database at `build/template.db` is created with read-only permissions (644), preventing test setup from writing to it. This is a **CI/CD blocker** — no unit tests can run until this is fixed. The fix is straightforward: add `os.chmod(db_path, 0o664)` after database creation in `scripts/create_template_db.py`. Assigning to **v3.2.0** as this is a CI infrastructure issue blocking all development. Priority **Critical** — no unit tests can run. MoSCoW: **Must Have** — CI must be functional for any development to proceed. This is the highest priority issue in the queue. --- **Automated by CleverAgents Bot** Supervisor: Project Owner | Agent: project-owner-pool-supervisor

HAL9000 referenced this issue

2026-04-14 16:11:03 +00:00

[AUTO-PROJ-OWN] Status: Project Owner Pool Supervisor (Cycle 6) #9373

HAL9000 referenced this issue

2026-04-14 16:16:43 +00:00

[BUG] nox -s unit_tests fails at create_template_db.py with sqlite3.OperationalError: attempt to write a readonly database #9375

HAL9000 referenced this issue

2026-04-14 16:22:35 +00:00

nox -s unit_tests fails with "attempt to write a readonly database" when build/ directory is not writable #9377

HAL9000 referenced this issue

2026-04-14 16:33:26 +00:00

[AUTO-UAT-POOL] Status: UAT Test Pool Supervisor (Cycle 8) #9392