Problem: The client wanted to allow admins to reset user passwords without forcing the next login change. Process: The expert confirmed that FreeIPA didn’t respect the set attribute with –setattr=krbPasswordExpiration from the command line. It changed the password but the expiry date automatically adjusted to the value from global_policy `ipa pwpolicy-show`. The expert tried to […]
Security 18 Oct 2024 Resolving PostgreSQL Database Corruption in Wiki.js on AWS EC2Problem: The client was experiencing issues with their Wiki.js application running on an AWS EC2 instance, utilizing PostgreSQL as the database and Docker for deployment. After a system crash, attempts to restart the application via the Docker Compose file resulted in errors. The client requested assistance in investigating the problem, stating that while the application […]
Database 18 Oct 2024 Solving SSL Configuration Issues in Opensearch DeploymentProblem: Our customer, using Opensearch (1 node) with SSL in their production environment, faced challenges while implementing a new node to ensure high availability. When individually pointing our application (Actone) to the new node, indexing and searching worked as expected. However, integrating both nodes simultaneously resulted in a – javax.net.ssl.SSLHandshakeException: Received fatal alert: certificate_unknown error […]
Data Analytics 16 Oct 2024 Creation of Sorted String Table Folders in CassandraProblem: The client wanted to understand the logic behind the creation of SSTable (sorted string table) folders in Cassandra when data is written to a database table within a keyspace. Specifically, the question was about why each table has two directories in certain scenarios and how this logic affects the ability to achieve data backups […]
Database 14 Oct 2024 Managing Unresolved Pending Tasks in Cassandra’s Nodetool CompactionStatsProblem: During a diagnostic call, it was observed that nodetool compactionstats was displaying 3,493 pending tasks related to the skyrt_prod1.event_state table. Despite new tasks being initiated and processed, these existing pending tasks remained uncleared, with no tasks currently in progress. This issue raised concerns about potential underlying problems with Cassandra’s compaction process. Solution: The accumulation […]
Database 13 Oct 2024 Apache Spark: DAGs didn’t move to the running stateProblem: The client faced Spark issues during job submissions through Airflow. Out of 15 max DAGs that got triggered, there were always 3-4 dags getting triggered in the Initial state and never moving to the running state. A few DAGs also got stuck in the ContainerCreate state and never came up and ran. Process: Step […]
Data Analytics 11 Oct 2024 Enhancing Prometheus Adapter Configuration for Multiple Config FilesProblem: The client seeks guidance on passing multiple configuration files to Prometheus Adapter (P8s) version v0.11.1 without encountering size limitations or performance issues. They aim to aggregate custom metrics efficiently across microservices in Kubernetes. Process: The experts discussed various aspects of configuring Prometheus Adapter, addressing concerns such as size limitations with config maps and optimizing […]
Data Analytics 8 Oct 2024 Optimizing Changelog Topic Management for Kafka Streams ApplicationProblem: The client, operating a Kafka Streams application version 3.3.1, encountered significant issues with managing changelog topics. Despite configuring the application for automatic record cleanup, the changelog topics exhibited unchecked growth. This accumulation of records risked deteriorating system performance and stability, potentially impacting the application’s reliability. Process: Initial Assessment: Issue Reporting: The client highlighted problems […]
Data Analytics 6 Oct 2024 Issue with Incremental Backup Location Causing Data Storage ExhaustionProblem: The client reported that data storage space was being exhausted because the incremental backups were being saved in the same location as the data storage. This issue forced the client to delete incremental backups to free up space for new data. The client requested a consultation on how to configure incremental backups to be […]
Database