Skip to content

Instantly share code, notes, and snippets.

@vetalt
Created August 28, 2016 08:28
Show Gist options
  • Save vetalt/73e19628a25101be795dd69b3290b647 to your computer and use it in GitHub Desktop.
Save vetalt/73e19628a25101be795dd69b3290b647 to your computer and use it in GitHub Desktop.
[Doctrine\DBAL\Exception\UniqueConstraintViolationException]
An exception occurred while executing 'INSERT INTO user_game_stats_email (timeout_percent, avg_time_per_move, echess_game_count, unrated_game_cou
nt, in_progress_count, timeout_count, moves_per_game, total_move_time, total_move_count, tournament_count, tournament_game_win_count, tournament_
game_loss_count, tournament_game_draw_count, tournament_1st_place, tournament_2nd_place, tournament_3rd_place, tournament_host_count, tournament_
host_user_count, tournament_withdraw_count, tournament_in_progress_count, tournament_cancel_count, tournament_points, tournament_count_total, tou
rnament_points_total, tournament_count_previous, tournament_points_previous, avg_opponent_rating, rd, rating, last_date, highest_rating, highest_
rating_date, last_game_date, is_active, total_game_count, total_win_count, total_loss_count, total_draw_count, current_streak, max_win_streak, ma
x_loss_streak, is_unrated, best_win_game_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [200, 187158, 9, 0, 12, 2, 3, 13288247, 71, 15, 0, 0, 0, 0, 0, 0, 3, 11, 0, 12, 0,
0, 12, 0, 0, 0, 0, 173.73, 1206, "2016-08-28 01:26:02", 1294, "2011-04-10 01:36:51", "2011-09-04 05:15:00", 1, 9, 5, 4, 0, 1, 4, 13, 0, 35000407,
31]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '31' for key 'PRIMARY'
Exception trace:
() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:116
Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:174
Doctrine\DBAL\Statement->execute() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:281
Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1018
Doctrine\ORM\UnitOfWork->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:378
Doctrine\ORM\UnitOfWork->commit() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:356
Doctrine\ORM\EntityManager->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Doctrine/ORM/EntityRepository.php:47
Chess\WebBundle\Doctrine\ORM\EntityRepository->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Manager/TournamentQueueProcessor.php:120
Chess\WebBundle\Manager\TournamentQueueProcessor->processQueue() at /www/sites/chess.com/current/app/cache/dev/appDevDebugProjectContainer.php:35111
ChessWebBundleManagerTournamentQueueProcessor_0000000004d8a7ff000000004835585dac9482435af420bb227aa459f5780eb0->processQueue() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/ProcessTournamentQueueCommand.php:28
Chess\WebBundle\Command\Daemon\ProcessTournamentQueueCommand->exec() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/AbstractDaemonCommand.php:45
Chess\WebBundle\Command\Daemon\AbstractDaemonCommand->execute() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:256
Symfony\Component\Console\Command\Command->run() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:849
Symfony\Component\Console\Application->doRunCommand() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:189
Symfony\Component\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:90
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:120
Symfony\Component\Console\Application->run() at /www/sites/chess.com/current/app/console:30
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '31' for key 'PRIMARY'
Exception trace:
() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93
Doctrine\DBAL\Driver\PDOStatement->execute() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165
Doctrine\DBAL\Statement->execute() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:281
Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1018
Doctrine\ORM\UnitOfWork->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:378
Doctrine\ORM\UnitOfWork->commit() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:356
Doctrine\ORM\EntityManager->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Doctrine/ORM/EntityRepository.php:47
Chess\WebBundle\Doctrine\ORM\EntityRepository->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Manager/TournamentQueueProcessor.php:120
Chess\WebBundle\Manager\TournamentQueueProcessor->processQueue() at /www/sites/chess.com/current/app/cache/dev/appDevDebugProjectContainer.php:35111
ChessWebBundleManagerTournamentQueueProcessor_0000000004d8a7ff000000004835585dac9482435af420bb227aa459f5780eb0->processQueue() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/ProcessTournamentQueueCommand.php:28
Chess\WebBundle\Command\Daemon\ProcessTournamentQueueCommand->exec() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/AbstractDaemonCommand.php:45
Chess\WebBundle\Command\Daemon\AbstractDaemonCommand->execute() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:256
Symfony\Component\Console\Command\Command->run() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:849
Symfony\Component\Console\Application->doRunCommand() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:189
Symfony\Component\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:90
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:120
Symfony\Component\Console\Application->run() at /www/sites/chess.com/current/app/console:30
[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '31' for key 'PRIMARY'
Exception trace:
() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
PDOStatement->execute() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
Doctrine\DBAL\Driver\PDOStatement->execute() at /www/sites/chess.com/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165
Doctrine\DBAL\Statement->execute() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:281
Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1018
Doctrine\ORM\UnitOfWork->executeInserts() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:378
Doctrine\ORM\UnitOfWork->commit() at /www/sites/chess.com/current/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:356
Doctrine\ORM\EntityManager->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Doctrine/ORM/EntityRepository.php:47
Chess\WebBundle\Doctrine\ORM\EntityRepository->flush() at /www/sites/chess.com/current/src/Chess/WebBundle/Manager/TournamentQueueProcessor.php:120
Chess\WebBundle\Manager\TournamentQueueProcessor->processQueue() at /www/sites/chess.com/current/app/cache/dev/appDevDebugProjectContainer.php:35111
ChessWebBundleManagerTournamentQueueProcessor_0000000004d8a7ff000000004835585dac9482435af420bb227aa459f5780eb0->processQueue() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/ProcessTournamentQueueCommand.php:28
Chess\WebBundle\Command\Daemon\ProcessTournamentQueueCommand->exec() at /www/sites/chess.com/current/src/Chess/WebBundle/Command/Daemon/AbstractDaemonCommand.php:45
Chess\WebBundle\Command\Daemon\AbstractDaemonCommand->execute() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php:256
Symfony\Component\Console\Command\Command->run() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:849
Symfony\Component\Console\Application->doRunCommand() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:189
Symfony\Component\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php:90
Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /www/sites/chess.com/current/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php:120
Symfony\Component\Console\Application->run() at /www/sites/chess.com/current/app/console:30
daemon:process_tournament_queue [--tournament [TOURNAMENT]] [--sleep [SLEEP]] [--cron-force] [--cron-clear] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-s|--shell] [--process-isolation] [-e|--env ENV] [--no-debug] [--memory MEMORY] [--] <command>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment