Case Studies

Problem: An application UPDATE statement against a partitioned PostgreSQL table (UPDATE tab1 SET sys_update_date = $1, agg_status = $2, output_filename = $3, merge_type = $4 WHERE period_key = $5 and record_id = $6) experienced consistent slowdowns in a nightly early‑morning window. The customer reported that partition file sizes showed normal small footprints for partitions p1–p12, […]

Problem: Applications using Redisson MapCache began throwing RedisResponseTimeoutException errors (client timeout = 3000 ms) during eviction activity. Errors were raised while executing EVALSHA with context pointing to org.redisson.eviction.MapCacheEvictionTask; application threads were reporting “Unable to evict elements” outputs correlated with redisson-timer-* threads. Environment details: a Redis Cluster (client traffic on shard port 7000) served multiple integration […]

Problem: A production team requested guidance to implement multi-tenancy and fine-grained RBAC in Apache NiFi so different users/groups would have isolated view and edit rights at the Process Group level. Requested capabilities included: allowing certain users to view and edit only a specific Process Group (no access to other canvas areas), defining Read‑Only vs Read/Write […]

Problem: The customer reported degraded performance in a PostgreSQL query joining multiple views and tables, including V_CDD_PRF_PARTY_PARTY_R_DRF. Although the outer query applied a highly selective filter (C.FIRST_PARTY_KEY = 'CDD000248470'), the PostgreSQL optimizer did not push this predicate into the view. As a result, the view was fully evaluated, leading to increased CPU usage, higher I/O, […]

Problem: A customer reported a critical production issue related to incorrect timestamp values in a data pipeline built using Debezium CDC. Timestamps originating from an MSSQL source system were appearing +05:30 hours ahead of the expected values in the downstream system. The issue affected multiple tables containing timestamp columns based on MSSQL date and time data types that do not […]

Problem: The client experienced repeated failures in two Apache Airflow DAGs responsible for launching Kubernetes Jobs. Each DAG followed a delete-and-recreate pattern using a fixed Kubernetes Job name. Although the Airflow task responsible for deleting the Job reported success, the subsequent Job creation consistently failed with a Kubernetes conflict error indicating that the Job already […]

Problem: The client reported recurring kernel messages appearing in the system logs while running OpenZFS on a virtualized Linux server. Using dmesg -T, the customer observed approximately five identical stack traces per second, raising concerns about potential impact on production stability and data integrity. The log messages consistently referenced memory allocation paths within ZFS and […]

Problem: The client experienced an intermittent disappearance of a critical Apache Airflow DAG — Dag-Factory. The DAG would appear in the Airflow UI and CLI, then vanish from the DagBag and UI for periods of time before reappearing. Each disappearance caused pipeline failures (notably the need to re-trigger the BONG initial load), interrupting production workflows. […]

Problem: The client experienced an unexpected failover in a production PostgreSQL Patroni cluster running PostgreSQL Community version 15.8 and Patroni version 2.1.4 configured in asynchronous replication mode. Node A unexpectedly went offline and Patroni automatically promoted Node B to the primary node. The client needed to determine: The reason for the failover. Whether any transactions […]