Skip to content

PeeStream WP/DooPlay v1.0.3

Choose a tag to compare

@inside83 inside83 released this 11 Nov 22:01
· 19 commits to master since this release

Release v1.0.3: Multi-Server Atomicity, Manual Migration Locking, Idempotent Queue Reservation, and UTC Timezone Consistency

Overview

This release resolves all findings from the latest independent architectural and concurrency review. It hardens multi-server processing within a single post, harmonizes manual and automated migration locking, ensures strict DB schema compliance verification, and enforces consistent UTC timestamping across different server timezones.

What's Changed

  • Harmonized Concurrency Locking: ajax_process_batch() is now protected with acquire_lock(120), heartbeat lease extensions (extend_lock()), and guaranteed unlock in finally, making AJAX Start Migration, AJAX Check Queue, and WP-Cron completely mutually exclusive.
  • Multi-Server Post Atomicity: Posts containing multiple competitor servers (e.g. Streamtape, MixDrop, and VOE) now process each server link individually and atomically. Fresh post metadata is reloaded before each modification, distinct backup snapshots are created per link in wp_peestream_migration_backups, and each server link can be surgically rolled back without corrupting or resetting the others.
  • Idempotent Queue Pre-Reservation & UNIQUE Constraint: Added UNIQUE KEY uq_post_orig (post_id, original_url(191)) to wp_peestream_migration_queue. Tasks are atomically pre-reserved prior to calling /api/upload/url, eliminating redundant remote upload calls on concurrent executions.
  • Strict DB Schema Compliance Verification: create_tables() strictly verifies the presence of all required columns across all three plugin tables as well as both unique indexes (uq_fc_event, uq_post_orig). Schema version is bumped to 104 and is only upgraded upon verified compliance.
  • Consistent UTC Timestamps & Timezone Safety: All timestamp writes and comparison cutoffs (recover_partial_failures(), process_queue_batch()) now use consistent UTC (current_time('mysql', true) and gmdate()), eliminating bugs caused by WordPress local timezone offsets (gmt_offset).
  • Eliminated Webhook Draft Crash Window: Passed metadata directly in wp_insert_post( 'meta_input' => ... ) and added title-based draft querying, preventing duplicate draft creation even if an unexpected server timeout occurs immediately after post insertion.
  • Verified Server Attachment in Webhook: attach_server_to_post() verifies that repeatable_fields persisted to the database; failures return HTTP 500 and set audit status to 'failed' instead of 'processed'.

Package Checksum (SHA-256)

  • peestream-wp-dooplay_v1.0.3.zip: 1d94d4b35ce5517e8c3f04000b52ee780cde0c1a038fe3ef1324db156662ea87