Connection Issues
Database Connection Failed
Symptoms:- Server fails to start
- Error:
ECONNREFUSEDorcould not connect to server
Verify PostgreSQL is running
Verify PostgreSQL is running
Check connection string
Check connection string
PG_DATABASE_URL format:- Wrong host (use
dbin Docker, notlocalhost) - Special characters in password need URL encoding
- Port mismatch (default is 5432)
Test database connection
Test database connection
Create database if missing
Create database if missing
Redis Connection Failed
Symptoms:- Worker fails to start
- Error:
Redis connection failed
Verify Redis is running
Verify Redis is running
Test Redis connection
Test Redis connection
Migration Issues
Migrations Failed to Run
Symptoms:- Server starts but database schema is incorrect
- Error:
relation does not exist
Run migrations manually
Run migrations manually
Reset database (development only)
Reset database (development only)
Check migration status
Check migration status
Migration Lock Issues
Symptoms:- Migrations stuck or timeout
- Error:
could not obtain lock
Performance Issues
Slow Query Performance
Symptoms:- Pages load slowly
- API requests timeout
Check database performance
Check database performance
Optimize database
Optimize database
Check Redis cache
Check Redis cache
Review resource limits
Review resource limits
- Add resource limits in docker-compose.yml
- Increase Kubernetes resource requests/limits
High Memory Usage
Solutions:Authentication Issues
Unable to Sign In
Symptoms:- Login fails with generic error
- OAuth redirect fails
Check APP_SECRET
Check APP_SECRET
APP_SECRET is set and consistent across all services:Verify OAuth configuration
Verify OAuth configuration
- Callback URLs must match exactly
- Client ID and secret must be correct
- OAuth app must be published/verified
Check JWT token settings
Check JWT token settings
Session Expired Immediately
Solutions:- Check Redis is running and accessible
- Verify
REDIS_URLis correct - Check system time is synchronized (NTP)
- Verify browser cookies are enabled
File Upload Issues
Files Not Uploading
Symptoms:- File upload fails silently
- 500 error on upload
Check storage configuration
Check storage configuration
For S3 storage
For S3 storage
- S3 credentials are correct
- Bucket exists and is accessible
- Bucket CORS policy allows uploads
- IAM permissions include
s3:PutObject
Check volume mounts
Check volume mounts
Email Issues
Emails Not Sending
Symptoms:- Password reset emails not received
- Invitation emails not sent
Check email driver
Check email driver
EMAIL_DRIVER=logger outputs to logs instead of sending.Test SMTP connection
Test SMTP connection
Check worker logs
Check worker logs
Verify email configuration
Verify email configuration
- Wrong SMTP port (use 587 for TLS, 465 for SSL)
- Authentication required but credentials missing
- App-specific password needed (Gmail)
- Firewall blocking outbound SMTP
Worker Issues
Background Jobs Not Processing
Symptoms:- Webhooks not firing
- Emails queued but not sent
- Imports/exports stuck
Check worker is running
Check worker is running
Verify Redis connection
Verify Redis connection
Check job queues
Check job queues
Restart worker
Restart worker
Debugging Techniques
Enable Debug Logs
Increase log verbosity:Access Container Shell
Check Service Health
Inspect Database Schema
Common Error Messages
”APP_SECRET must be set”
Cause: Missing or emptyAPP_SECRET environment variable
Solution:
“Port 3000 already in use”
Cause: Another service is using port 3000 Solution:“Relation does not exist”
Cause: Database schema not initialized or migrations not run Solution:“Invalid token” or “Unauthorized”
Cause: Token validation failed Solutions:- Verify
APP_SECRETmatches across server and worker - Check token hasn’t expired
- Regenerate API key if using API authentication
- Clear browser cookies and sign in again
Performance Debugging
High CPU Usage
Investigation:- Add database indexes for frequently queried fields
- Optimize GraphQL queries
- Enable Redis caching
- Scale worker replicas
High Memory Usage
Investigation:- Increase container memory limits
- Restart services periodically
- Check for memory leaks in logs
- Scale horizontally instead of vertically
Disk Space Issues
Investigation:- Clean up old Docker images:
docker image prune -a - Archive old data
- Increase volume size
- Configure log rotation
Webhook Issues
Webhooks Not Firing
Symptoms:- External systems not receiving events
- Webhook jobs stuck in queue
Check webhook configuration
Check webhook configuration
Check worker logs
Check worker logs
Test webhook endpoint
Test webhook endpoint
Check webhook queue
Check webhook queue
Data Integrity Issues
Metadata Sync Issues
Symptoms:- Custom objects not appearing
- Field changes not reflected
Data Inconsistencies
Investigation:Docker-Specific Issues
Cannot Pull Docker Image
Solutions:Volume Permission Issues
Symptoms:- Cannot write files
- Permission denied errors
Kubernetes-Specific Issues
Pods in CrashLoopBackOff
Investigation:- Database not ready (check init containers)
- Missing secrets or ConfigMaps
- Insufficient resources
- Failed health checks
PVC Not Binding
Investigation:- Ensure storage class exists and is default
- Check PV availability
- Verify access mode matches (ReadWriteMany for shared storage)
