News

HQbird 2024 R2 Update 10

IBSurgeon releases version HQbird 2024 R2 Update 10. In addition to fixes from vanilla versions recent releases, HQbird has the following new features:

Materialized Views (New Feature) in 5.0

  • New persistent view type: defined like a view, stored like a table. Supports indices; DML and triggers not allowed.
  • Syntax: CREATE / ALTER / RECREATE MATERIALIZED VIEW ... AS [WITH [NO] DATA]. Drop via regular DROP VIEW.
  • Convert between types: ALTER ... TO NOT MATERIALIZED and ALTER VIEW ... TO MATERIALIZED.
  • REFRESH MATERIALIZED VIEW — four modes:
    • Default: full exclusive reload (fastest for many changes).
    • CONCURRENTLY: merge-based update, no exclusive lock, requires unique index.
    • DROP DATA: clears all data and indices to free space.
    • CASCADE: refreshes all dependent MVs in correct dependency order.
  • gbak restore automatically refreshes all MVs. Use -NO_MATVIEWS switch to skip. Backup containing MVs requires MV-capable Firebird to restore.

Backup & Recovery

  • Verification backup: revolving pre-compression deletion; disk space coefficients now configurable.
  • Backup-Restore-Replace task: configurable backup directory and filename template (e.g. brr_{0,date,yyyyMMdd_HH-mm-ss}.fbk); directory auto-created if missing.
  • nBackup: journal rename changed to atomic rename with retry.

Trace & Monitoring

  • New connection_id field in trace configuration dialog.
  • Trace report: case-insensitive process name grouping and filtering; progress percentage during report generation.

Web Interface & Configuration

  • Web console localization improvements; new labeled divider element for form grouping.
  • Cache-busting updated to prevent stale JS/CSS after upgrades.
  • Default file transfer settings unified: port 8722, user socketuser, strong password.
  • KA license registration: HTTP/HTTPS prefix no longer required in host field.

Bug Fixes

  • False critical alert when all database tasks are temporarily disabled — fixed.
  • Trace session list error for SYSDBA users without trace list permissions — fixed.
  • UTF-8 paths in decryption component causing mon/trace errors — fixed on DG side.
  • Replication config: empty-value keys no longer retained after removal.
  • journal_archive_command handling for Firebird 4+ corrected (FB PR #8381).

Installer & Build

  • Windows installer updated; client library binaries and OpenSSL updated.
  • VSS Writer: extended database state logging (size, timestamp, gstat -h).
  • cloudbackup: Socket protocol file upload support added.
More details is here.
Download here.