Repository navigation
v1.0.3 — Rollback Conflict Safety, Owner-Token Fencing, URL Hash & Bounded Retry
PeeStream DataLife Engine (DLE) Addon v1.0.3 Release
Key Updates & Security Hardening
-
Rollback Conflict Safety & Real Error Reporting:
- Eliminated false success reporting when optimistic update encounters lock contention.
- Preserves backup record in 'completed' state so users can retry without losing historical snapshots.
- Single rollback API strictly fails closed on optimistic contention.
-
Strict Owner-Token Fencing:
- Removed 'OR owner_token='''' fallback across queue status updates.
- Enforces mutual exclusion and verifies affected rows on completion. Stale workers whose lease expired cannot alter active items.
-
Collision-Free, Full-Length SHA-256 URL Hash:
- Replaced prefix-truncated index with full 256-bit binary-safe
url_hash(CHAR(64)) andUNIQUE KEY uq_post_urlhash (post_id, url_hash). - Prevents collation collisions and handles arbitrarily long URLs cleanly. Full original URL is preserved for verification.
- Replaced prefix-truncated index with full 256-bit binary-safe
-
Bounded Upload Retry Engine:
- Controlled, bounded retry for temporary upload failures (
retry_count < 3) without parallel duplication or modifying original posts.
- Controlled, bounded retry for temporary upload failures (
-
Safe Archiving & Schema Crash Recovery:
- Added
peestream_queue_archivetable to safely preserve historical duplicates during upgrade. - Idempotent runtime migration (
peestream_ensure_schema) runs before cron worker starts. - Implemented
peestream_recover_interrupted_tasksto handle process crashes between post update and queue/backup finalization.
- Added
Verification
- 196 automated test cases passing (100% success rate).
SHA-256: b0ae90d07bc5a4aaa34d15f92ceabd7d10abbceea907376d9e867ad90bf632f2