Troubleshooting

Troubleshooting Guide

Solutions to common DealAI.lt issues.

Database Issues

Connection Failed

Symptom: “Could not connect to database”

Solutions:

# Check PostgreSQL status
sudo systemctl status postgresql

# Test connection
psql -h 162.55.174.116 -U dealai_user -d dealai_products

# Verify credentials in .env

Slow Queries

Symptom: Page loads slowly

Solutions:

• Check slow query log
• Add missing indexes
• Optimize joins
• Use EXPLAIN ANALYZE

Elasticsearch Issues

Connection Timeout

Symptom: “Elasticsearch not responding”

Solutions:

# Check Elasticsearch status
curl http://91.99.113.45:9200/_cluster/health

# Restart Elasticsearch
sudo systemctl restart elasticsearch

Sync Not Running

Symptom: Products not appearing in search

Solutions:

# Check sync state
cat /path/to/elasticsearch-sync-state.json

# Run manual sync
php /path/to/elasticsearch-auto-sync.php

# Check logs
tail -f /var/log/dealai/elasticsearch-sync.log

Scrapyd Issues

Jobs Not Starting

Symptom: Jobs stuck in pending

Solutions:

# Check Scrapyd status
curl http://78.56.0.236:6800/daemonstatus.json

# Restart Scrapyd
ssh [email protected] "sudo systemctl restart scrapyd"

WordPress Issues

Theme Not Activating

Symptom: Theme activation fails

Solutions:

# Check file permissions
sudo chown -R www-data:www-data /var/www/html/wp-content/themes/products

# Check PHP errors
tail -f /var/log/apache2/error.log

White Screen

Symptom: Blank white page

Solutions:

• Enable WP_DEBUG
• Check error logs
• Verify PHP version
• Check memory limit

Performance Issues

Slow Search

Solutions:

• Check Elasticsearch cluster health
• Optimize query complexity
• Add caching
• Increase Elasticsearch resources

High Memory Usage

Solutions:

• Reduce batch sizes
• Enable OPcache
• Implement connection pooling
• Add memory limits

Cron Job Issues

Jobs Not Running

Solutions:

# Check cron service
sudo systemctl status cron

# Verify crontab
crontab -l

# Check permissions
chmod +x /path/to/script.php

Next Steps

• Installation - Reinstall
• Architecture - Understand system
• Development Setup - Local debugging