Troubleshooting

# Check MySQL service status
docker service ps shopify-app_mysql

# Check MySQL logs
docker service logs shopify-app_mysql

# Check if MySQL is accepting connections
docker exec $(docker ps -q -f name=shopify-app_mysql) \
  mysqladmin ping -h localhost -uroot -p${MYSQL_ROOT_PASSWORD}

# Check if both services are on the same network
docker network inspect EcomdropNet

DATABASE_URL="mysql://shopify_user:${MYSQL_PASSWORD}@mysql:3306/shopify_app"

# View application logs
docker service logs shopify-app_shopify_app | grep "prisma migrate"

# Execute in a running container
docker exec -it $(docker ps -q -f name=shopify-app_shopify_app) \
  npm run setup

# Connect to MySQL
docker exec -it $(docker ps -q -f name=shopify-app_mysql) \
  mysql -u shopify_user -p${MYSQL_PASSWORD} shopify_app

# In MySQL shell
SHOW TABLES;

# Drop and recreate database
docker exec -it $(docker ps -q -f name=shopify-app_mysql) \
  mysql -u root -p${MYSQL_ROOT_PASSWORD} -e "
    DROP DATABASE IF EXISTS shopify_app;
    CREATE DATABASE shopify_app CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    GRANT ALL PRIVILEGES ON shopify_app.* TO 'shopify_user'@'%';
    FLUSH PRIVILEGES;
  "

# Restart application to run migrations
docker service update --force shopify-app_shopify_app

# Find process on port 3000
lsof -i :3000
# or
netstat -tlnp | grep :3000

# Kill the process (replace PID with actual process ID)
kill -9 <PID>

PORT=3001

npx prisma validate

# In Dockerfile, add before npm run build
ENV DATABASE_URL="mysql://user:pass@localhost:3306/db"

docker build \
  --build-arg DATABASE_URL="mysql://user:pass@localhost:3306/db" \
  -t shopify-app_shopify_app:latest .

# View recent logs
docker service logs --tail 100 shopify-app_shopify_app

# Follow logs in real-time
docker service logs -f shopify-app_shopify_app

# Inspect service
docker service inspect shopify-app_shopify_app --pretty

# Check task status
docker service ps shopify-app_shopify_app --no-trunc

docker service logs traefik | grep -i acme
docker service logs traefik | grep -i letsencrypt

# Check DNS resolution
nslookup connector.ecomdrop.io
dig connector.ecomdrop.io

# Should point to your server IP

# Test from external server or use online tools
curl -I http://connector.ecomdrop.io

# In traefik.yml
certificatesResolvers:
  letsencryptresolver:
    acme:
      caServer: https://acme-staging-v02.api.letsencrypt.org/directory

# Remove ACME storage
docker volume rm traefik_traefik-certificates

# Restart Traefik
docker service update --force traefik_traefik

docker service inspect shopify-app_shopify_app --pretty | grep -A 10 Labels

traefik.enable=true
traefik.http.routers.shopify_app.rule=Host(`connector.ecomdrop.io`)

# Verify both on same network
docker network inspect EcomdropNet

# From within Traefik container
docker exec -it $(docker ps -q -f name=traefik) \
  wget -O- http://shopify_app:3000

# Test directly
docker exec -it $(docker ps -q -f name=shopify-app_shopify_app) \
  wget -O- http://localhost:3000

- traefik.http.services.shopify_app.loadbalancer.server.responseTimeout=60s

# Enable MySQL slow query log
docker exec -it $(docker ps -q -f name=shopify-app_mysql) \
  mysql -u root -p${MYSQL_ROOT_PASSWORD} -e "
    SET GLOBAL slow_query_log = 'ON';
    SET GLOBAL long_query_time = 2;
  "

# Real-time monitoring
docker stats

# Check service resources
docker service ps shopify-app_shopify_app --no-trunc

deploy:
  resources:
    limits:
      memory: 1G
    reservations:
      memory: 512M

environment:
  NODE_OPTIONS: "--max-old-space-size=768"

docker exec -it $(docker ps -q -f name=shopify-app_mysql) \
  mysql -u root -p${MYSQL_ROOT_PASSWORD} -e "
    SET GLOBAL slow_query_log = 'ON';
    SET GLOBAL long_query_time = 1;
    SET GLOBAL log_queries_not_using_indexes = 'ON';
  "

-- In MySQL
SELECT * FROM information_schema.STATISTICS 
WHERE TABLE_SCHEMA = 'shopify_app';