Codes d'Erreur

SQLSTATE[08006] Connection refused

# Vérifier service
docker compose ps postgres
 
# Restart
docker compose restart postgres
 
# Vérifier .env
POSTGRES_HOST=postgres  # Nom service Docker
POSTGRES_PORT=5432

SQLSTATE[28P01] password authentication failed for user "csweb"

# Vérifier credentials
echo $POSTGRES_USER
echo $POSTGRES_PASSWORD
 
# Reset password
docker compose exec postgres psql -U postgres -c \
  "ALTER USER csweb_analytics PASSWORD 'new_password';"

SQLSTATE[3D000] database "csweb_analytics" does not exist

# Créer database
docker compose exec postgres psql -U postgres -c \
  "CREATE DATABASE csweb_analytics OWNER csweb_analytics;"
 
# Ou rebuild
docker compose down -v
docker compose up -d

could not find driver pdo_pgsql

# PostgreSQL
apt-get install php8.1-pgsql
php -m | grep pdo_pgsql
 
# MySQL
apt-get install php8.1-mysql
 
# SQL Server
./install-sqlsrv-driver.sh

FATAL: sorry, too many clients already

-- PostgreSQL: Augmenter max_connections
ALTER SYSTEM SET max_connections = 200;
SELECT pg_reload_conf();
 
-- Vérifier connexions actives
SELECT count(*) FROM pg_stat_activity;

Dictionary 'EVAL_DICT' not found in CSPro server

# Vérifier dictionnaires disponibles
curl -X GET http://localhost:8080/api/dictionaries
 
# Uploader dictionnaire
curl -X POST http://localhost:8080/api/dictionaries \
  -F "file=@survey.dcf"

Breakout process terminated with exit code 1

# Vérifier logs
docker compose logs csweb | grep -A 10 "Breakout"
 
# Drop table existante
DROP TABLE IF EXISTS eval_dict_producteurs;
 
# Vérifier permissions
GRANT ALL ON SCHEMA public TO csweb_analytics;

Failed to parse case data: Invalid JSON

# Vérifier format case
cat case.json | jq .
 
# Re-synchroniser CSPro
curl -X POST http://cspro-server/api/sync

Table 'eval_dict_level_1' already exists

# Drop tables
php bin/console csweb:drop-breakout-tables EVAL_DICT
 
# Ou force overwrite
php bin/console csweb:process-cases-by-dict EVAL_DICT --force

{
  "error": "invalid_grant",
  "error_description": "Invalid username or password"
}

# Vérifier user existe
SELECT username, enabled FROM users WHERE username = 'admin';
 
# Reset password
php bin/console security:encode-password newpassword
UPDATE users SET password = 'HASH' WHERE username = 'admin';

{
  "error": "invalid_client",
  "error_description": "Client credentials are invalid"
}

# Vérifier .env
echo $OAUTH_CLIENT_ID
echo $OAUTH_CLIENT_SECRET
 
# Recreate client
php bin/console oauth:client:create

{
  "error": "invalid_token",
  "error_description": "The access token provided has expired"
}

# Regénérer token
curl -X POST http://localhost:8080/api/token \
  -d "grant_type=password" \
  -d "username=admin" \
  -d "password=admin123"

{
  "error": "access_denied",
  "error_description": "You do not have permission to access this resource"
}

-- Vérifier rôles user
SELECT username, roles FROM users WHERE username = 'admin';
 
-- Ajouter rôle ADMIN
UPDATE users SET roles = '["ROLE_ADMIN"]' WHERE username = 'admin';

{
  "error": "Method POST not allowed for this route"
}

# Vérifier méthode HTTP
curl -X GET http://localhost:8080/api/dictionaries  # Correct
curl -X POST http://localhost:8080/api/dictionaries  # Incorrect

{
  "error": "Dictionary 'UNKNOWN' not found"
}

# Lister ressources disponibles
curl -X GET http://localhost:8080/api/dictionaries
curl -X GET http://localhost:8080/api/breakout/jobs

{
  "error": "Syntax error in JSON payload"
}

# Valider JSON
echo '{"key": "value"}' | jq .
 
# Correct request
curl -X POST http://localhost:8080/api/webhooks \
  -H "Content-Type: application/json" \
  -d '{"event": "case_uploaded", "dictionary": "EVAL_DICT"}'

{
  "error": "Too many requests",
  "retry_after": 60
}

# Attendre 60 secondes
sleep 60
 
# Ou augmenter limite (config/packages/rate_limiter.yaml)
limit: 100
interval: '1 minute'

Error: bind: address already in use 0.0.0.0:8080

# Trouver processus
lsof -i :8080
netstat -tuln | grep 8080
 
# Kill processus
kill -9 <PID>
 
# Ou changer port
CSWEB_PORT=8081
docker compose up -d

Permission denied: '/var/lib/postgresql/data'

# Fix permissions
sudo chown -R 999:999 ./postgres-data
 
# Ou recreate volume
docker compose down -v
docker compose up -d

Container killed (OOMKilled)

# Augmenter mémoire
docker-compose.yml:
  csweb:
    mem_limit: 2g
    mem_reservation: 1g
 
# Vérifier usage
docker stats

network csweb_default not found

# Recreate network
docker compose down
docker compose up -d
 
# Ou créer manuellement
docker network create csweb_default

{
  "error": "Invalid webhook token"
}

# Vérifier token match
echo $CSPRO_WEBHOOK_TOKEN  # CSWeb
echo $BREAKOUT_WEBHOOK_TOKEN  # CSPro
 
# Utiliser même token
CSPRO_WEBHOOK_TOKEN=secret123

Webhook timed out after 30 seconds

// Répondre immédiatement
http_response_code(202);
echo json_encode(['status' => 'accepted']);
 
// Traitement async
fastcgi_finish_request();
exec("php process-webhook.php > /dev/null 2>&1 &");

{
  "error": "Missing required field: 'dictionary'"
}

# Payload correct
curl -X POST http://localhost:8080/webhooks/breakout \
  -H "X-Webhook-Token: secret123" \
  -H "Content-Type: application/json" \
  -d '{
    "event": "case_uploaded",
    "dictionary": "EVAL_DICT",
    "case_id": "abc123"
  }'

Query took 15.3 seconds to execute

-- Créer index
CREATE INDEX idx_case_id ON eval_dict_level_1(case_id);
CREATE INDEX idx_verified ON eval_cases(verified);
 
-- Analyser query
EXPLAIN ANALYZE SELECT * FROM eval_dict_level_1 WHERE case_id = '123';

PHP Fatal error: Allowed memory size exhausted

# php.ini
memory_limit = 512M
 
# Ou pour une commande
php -d memory_limit=1G bin/console csweb:process-cases-by-dict EVAL_DICT

# .env
APP_ENV=dev
APP_DEBUG=true
LOG_LEVEL=debug

# Tous les logs
docker compose logs -f
 
# Service spécifique
docker compose logs -f csweb
 
# Filtrer erreurs
docker compose logs csweb | grep ERROR

# Activer slow query log
ALTER SYSTEM SET log_min_duration_statement = 1000;
SELECT pg_reload_conf();
 
# Voir logs
docker compose exec postgres tail -f /var/lib/postgresql/data/log/postgresql.log