Proactive Insights and Support For Open-Source Applications
  • Applications
  • Platform
  • Support
  • Resources
    • OSS Research
    • FAQ
    • Newsflash
    • OSSpedia
    • How-to Guides
    • Case Studies
    • Articles
  • Company
    • About Us
    • The OSS in Hossted
  • Contact
Book a demo
  • Applications
  • Platform
  • Support
  • Resources
    • OSS Research
    • FAQ
    • Newsflash
    • OSSpedia
    • How-to Guides
    • Case Studies
    • Articles
  • Company
    • About Us
    • The OSS in Hossted
  • Contact
  • Home
  • Knowledge Base
  • Case Studies

Case Studies

All OSSpediaArticlesHow ToNewsflashCase Studies
Don't Miss out!
Join our newsletter for exclusive updates on open source innovations.

    Choose category
    • Communication and Collaboration
      • Communication
    • Project and Agile Management
      • IT Business Management
    • Data Management and Analytics
      • Data Management and Analytics
      • Data Analytics
      • Database
    • DevOps
      • Virtualization
      • Monitoring
      • Data Management and Analytics
      • Developer Tools
      • Application Development
    • Infrastructure and Network
      • Storage
      • Security
    9 Sep 2026 Troubleshooting lost downstream notifications caused by in-memory Camel SEDA queue

    Problem: An application gateway using the Open Enterprise SDK for Apache Kafka reported that Notification ID 8 was accepted and enqueued by the gateway but never showed downstream dispatch evidence for two subscribers. Gateway instrumentation recorded REST_RECEIVE and SEDA_ENQUEUE events for those transactions, while downstream stages (SEDA_DEQUEUE, HTTP_SEND, EDR_WRITE) were absent in the available exports. […]

    Knowledge Base Case Studies DevOps Application Development
    9 Sep 2026 PostgreSQL SSL handshake failures causing intermittent connection errors in a Patroni cluster

    Problem: A production PostgreSQL 15.8 deployment running inside a Patroni-managed HA cluster (Patroni 2.1.4) reported transient application failures where processes could not connect and surfaced the message “PostgreSQL connection error, Cannot connect to FX DB”. Database logs showed repeated messages indicating SSL accept-stage failures with the text “could not accept SSL connection: EOF detected”. The […]

    Knowledge Base Case Studies Data Management and Analytics Database
    9 Sep 2026 Troubleshooting an AWS Marketplace Langfuse Deployment: Version Mismatch and Architecture Refinement

    Problem: A customer preparing to deploy Langfuse from an AWS Marketplace VM requested guidance for sizing, installation in a VPC, required network ports, and hardening. Their intended use was as a shared enterprise evaluation service for AI applications with about 500 million observability events (traces, spans/steps, evaluation scores). Integration requirements included Langfuse Python/JS SDKs, a […]

    Knowledge Base Case Studies DevOps Developer Tools
    9 Sep 2026 PostgreSQL: long-running autovacuum caused by anti-wraparound freeze cycles and index bloat

    Problem: PostgreSQL 15.17 running in a Patroni-managed cluster experienced autovacuum tasks running for five hours or more on very large, non-partitioned tables. Customer-provided artifacts included table size and index statistics, autovacuum logs, pg_settings, and pg_stat_all_tables. Symptoms reported: multi-hour autovacuum/vacuum runs on large tables, continuous cleanup script execution, and 10-hour REINDEX operations on bloated indexes. The […]

    Knowledge Base Case Studies Data Management and Analytics Database
    2 Sep 2026 Debezium Disaster Recovery: architecture refinement and runbook implementation

    Problem: The customer requested a concrete Disaster Recovery (DR) strategy for a Debezium-based CDC platform covering supported DR architectures, Active‑Active vs Active‑Passive tradeoffs, replication/failover mechanisms, Kafka dependencies, metadata/offset/schema‑history recovery, RTO/RPO targets, infrastructure prerequisites, and DB‑specific guidance for Oracle, Postgres and MySQL. The existing environment used Debezium connectors, Kafka, cross‑cluster replication (MirrorMaker2), and a managed schema […]

    Knowledge Base Case Studies Data Management and Analytics Data Analytics
    10 Aug 2026 Identifying client IPs and limiting heavy queries for Patroni PostgreSQL behind HAProxy

    Problem: Production PostgreSQL clusters (PostgreSQL community edition 15.17) are running under Patroni (v3.3.2) with HAProxy (2.6.21) in front. All client connections go through HAProxy using virtual IPs and virtual ports; on the PostgreSQL side the reported client address is the HAProxy VIP rather than the originating physical client IP. The operations team needed a reliable […]

    Knowledge Base Case Studies Data Management and Analytics Database
    10 Aug 2026 PostgreSQL failover caused by connection surge and memory exhaustion on a Patroni cluster

    Problem: A production PostgreSQL cluster (community PostgreSQL 15.8, managed by Patroni v2.1.4) experienced an unplanned automatic switchover. Symptoms reported included an unexpected promotion of the standby after the primary stopped responding to health checks. Monitoring and OS traces showed memory usage climbing to ~95% on the primary node, PostgreSQL failing to respond to Patroni probe […]

    Case Studies Data Management and Analytics Database
    22 Jul 2026 Removing unused Hive jars from an Apache Spark image to address scanner-reported CVEs

    Problem: A security scan of a deployed Apache Spark binary distribution reported two vulnerabilities located in Hive artifacts bundled with Spark: CVE-2024-29869 (org.apache.hive:hive-exec, fixed in Hive 4.0.1) and CVE-2024-23953 (org.apache.hive:hive-llap-common, fixed in Hive 4.0.1). The scan showed the vulnerable artifacts present in the shipped Spark distribution (the Spark 3.5.x line shipped a Hive 2.3.x fork […]

    Knowledge Base Case Studies
    21 Jul 2026 Resolving a Spark Structured Streaming gap that blocked inbound reply messages

    Problem: A production alert arrived with the subject indicating “client replied sms” and a Severity 3 priority: inbound reply messages were not being recorded by the downstream processing pipeline. The affected pipeline is an Apache Spark Structured Streaming job that consumes reply events from a message broker and uses a persistent checkpoint directory to track […]

    Knowledge Base Case Studies Data Management and Analytics Data Analytics
    Proactive Insights and Support For Open-Source Applications
    Company
    • About Hossted
    • Data Processing Addendum
    Solutions
    • Applications
    • Support Plans
    • About Solution
    Resources
    • FAQ
    • Knowledge Base

    © HOSSTED 2026 All rights reserved

    • Privacy Policy
    • Terms and Conditions
    • Cookies Policy
    Cookie Settings

    We use cookies to measure marketing efforts and improve our services. Please review the cookie settings and confirm your choice.

    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    • Manage options
    • Manage services
    • Manage {vendor_count} vendors
    • Read more about these purposes
    View preferences
    • {title}
    • {title}
    • {title}