Closed Skeeve closed 4 years ago
php artisan siwecos:trigger-daily-scans
[2019-10-31 14:56:37] staging.ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '199-40' for key 'PRIMARY' (SQL: insert into `scan_siwecos_scan` (`created_at`, `scan_id`, `siwecos_scan_id`, `updated_at`) values (2019-10-31 14:56:37, 199, 40, 2019-10-31 14:56:37)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '199-40' for key 'PRIMARY' (SQL: insert into `scan_siwecos_scan` (`created_at`, `scan_id`, `siwecos_scan_id`, `updated_at`) values (2019-10-31 14:56:37, 199, 40, 2019-10-31 14:56:37)) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '199-40' for key 'PRIMARY' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '199-40' for key 'PRIMARY' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
Sieht aus als hätten wir da einen Fehler in der DB
Fehler durch mehrfach-Assoziation von MailDomain
s zur Domain.
Bspw.:
example.org
->mailDomain: mx.example.org
->mailDomain: mx.example.org
Dadurch will der Command mehrmals den gleichen Eintrag setzen und stürzt ab.
In Staging werden nur 3 Domains recurrent gescannt. Wir haben aber 29 verifizierte.