Data Analytics

Problem: The client reported several security vulnerabilities in Airflow version 2.5.0, including weak password policies such as allowing passwords with less than 8 characters, lack of password expiration, and absence of enforced password changes during the first login. These weaknesses compromise overall system security and user account integrity. Solution: To address these issues, the expert […]

Problem: The client reported a critical issue with Solr 6.6.5, where Solr cores were becoming corrupt when new data was pushed through the Data Import Handler (DIH). This issue led to significant data loss and functionality impact, as existing indexed data became inaccessible, resulting in zero search results despite having content in Solr. Process: Step […]

Problem: Airflow login failed with an “Invalid login” prompt for the user “admin” in production. The environment details are as follows: Helm version 1.9.0 and Airflow Image version 2.6.3. The expected outcome was a successful login. Solution: Identify the Issue: The problem was related to login issues with the Airflow UI using the “admin” user. […]

Problem: The client faced significant delays in executing Elasticsearch queries within their production environment. A particular query, which involved a simple numeric account identifier, took an alarming 68 seconds to execute, despite returning only six hits. The total size of the query output was 583KB, yet the Elasticsearch profiler indicated that 67 seconds of this […]

Problem: The client reported an issue where the Prometheus pod was crashing in the production environment. The error logs indicated a variety of issues including “Terminated Reason: Error” and messages about unhealthy blocks and existing lock files. The specific error message highlighted was: Last State: Terminated Reason: Error Message: und healthy block” mint=1680069600000 maxt=1680091200000 ulid=01GWPY8332RWJAPSFZ8KNAJQ9H […]

Problem: The client reported that the Prometheus directory inside /var/lib had grown to 23GB, leading to high disk utilization on /var and potentially impacting other services. The /var directory has a total capacity of 200GB, which is shared by other service libraries and log files. Currently, the utilization on /var is at 80%, and the […]

Problem: The client, utilizing Kafka Streams application version 3.3.1, encountered issues with managing changelog topics. Despite configuring the application for automatic cleanup of records within these topics, unchecked growth was noticed, posing potential risks to system performance and stability. Process: Initial Assessment: The client reported the issue, highlighting the design of their Kafka Streams application […]

Problem: The client has requested assistance with the following issue regarding the `connect-eoc-data-summary-to-grid-sink-httpfile-connector`. The connector is experiencing a lag where it is not reading any records, and the offset is not being committed, causing the lag to keep increasing. The client indicated that the grid connector appears to be stuck and has failed. The following […]

Problem: Certain Elasticsearch queries timed out after 30 seconds. Details: The customer used Elasticsearch (version 7.17.0 or slightly newer) to query documents created by the Actimize application. The Elastic index contained approximately 80 million documents, amounting to several terabytes. Typically, queries were executed within a few seconds, but some queries consistently took 30 seconds or […]