Critical: Persistent Database Connection Failures in Follow Bot Service

[0xthrpw]

The follow-bot service is experiencing frequent database connection failures that require immediate attention.

Symptoms:

• Repeated connection drops approximately every 10-30 minutes
• Failed logical streaming reconnection attempts
• PostgreSQL subscription errors
• Socket connection terminations

Impact:

• Service stability compromised
• Potential data streaming interruptions
• Risk of missed events or data loss

Steps to reproduce:

1. Monitor service logs for connection errors
2. Observe pattern of disconnections
3. Check subscription status

Recommended investigation steps:

1. Review database connection configuration
2. Check network stability between service and database
3. Verify connection pool settings
4. Analyze database server logs for corresponding errors
5. Test with connection resilience patterns