Troubleshooting Guide

Gyakori problémák és megoldásuk.

Queue Stuck (Job Nem Fut)

Tünetek:

• Queue item pending státusz (órák óta)
• Horizon dashboard: 0 processed jobs
• Logs: nincs processing bejegyzés

Debug:

-- Pending queue items
SELECT id, status, created_at FROM blog_post_queues WHERE status = 'pending' AND created_at < NOW() - INTERVAL 10 MINUTE;

-- Jobs tábla (Redis queue → MySQL)
SELECT * FROM jobs WHERE queue = 'default' ORDER BY created_at DESC LIMIT 10;

-- Failed jobs
SELECT * FROM failed_jobs ORDER BY failed_at DESC LIMIT 10;

Megoldás:

1. Horizon restart (Laravel Cloud Commands)
2. Queue clear + retry (Artisan command)
3. Logs ellenőrzés (ERROR szűrés)

Prompt Leak Végtelen Loop

Tünetek:

• prompt_leak_attempts = 3 (max retry elérve)
• Queue failed státusz
• Logs: "Prompt leak detected" ismétlődik

Debug:

-- Prompt leak failed items
SELECT id, prompt_leak_attempts, status FROM blog_post_queues WHERE prompt_leak_attempts > 0;

-- Logs (pattern azonosítás)
SELECT message, context FROM logs WHERE channel = 'api-response' AND message LIKE '%Prompt leak%' ORDER BY created_at DESC LIMIT 20;

Megoldás:

• Tutorial téma? → Context-aware detection check (PromptLeakDetectionService)
• CDATA használat? → AI prompt instruction check (primary-instructions.blade.php)
• False positive? → Pattern whitelist hozzáadás

Credit Számítás Hibás

Tünetek:

• User report: "Több credit lett levonva"
• Dashboard credit != queue státusz credit

Debug:

-- Credit verify (manual calculation)
SELECT
    r.id,
    r.products_count,
    SUM(csm.generation_credit) as calculated_credit,
    r.charged_credits as charged_credit
FROM blog_post_requests r
INNER JOIN blog_post_queues q ON q.blog_post_request_id = r.id
INNER JOIN credit_status_mappings csm ON csm.product_id = r.product_id AND csm.queue_status = q.status
WHERE r.id = ?
GROUP BY r.id;

Megoldás:

• credit_status_mappings ellenőrzés (helyes mapping?)
• CreditCalculationService SQL szimuláció (sikeres vs failed)
• Retry items duplicate credit? → Deduplikáció check

Deployment Failed

Tünetek:

• Queue completed de result tábla deployment_failed
• WooCommerce REST API error

Debug:

-- Deployment státusz
SELECT abpg.status, COUNT(*) FROM automated_blog_post_generations abpg
INNER JOIN blog_post_queues bpq ON abpg.blog_post_queue_id = bpq.id
WHERE bpq.blog_post_request_id = ?
GROUP BY abpg.status;

-- Logs (deployment error)
SELECT level, message, context FROM logs WHERE message LIKE '%deployment%' AND level = 'ERROR' ORDER BY created_at DESC;

Megoldás:

• WooCommerce API credential check (account_integrations.config)
• Target site elérhető? (curl test)
• Rate limit? (429 response)
• Meta field név helyes? (RankMath rank_math_description vs _yoast_wpseo_metadesc)

Teljes Referenciák

📖 Session dokumentációk:

• /docs/local/_session/generation_analysis_reference.md - Generálás vizsgálat workflow
• /docs/local/_session/credit_pricing_reference.md - Credit számítás debug
• /docs/local/_session/wordpress_woocommerce_api_testing.md - REST API teszt
• /docs/local/_session/test_scenario_ci_debugging_guide.md - CI test debugging

---

Utolsó frissítés: 2026-02-05