Uploaded image for project: 'eZ Platform Enterprise Edition'
  1. eZ Platform Enterprise Edition
  2. EZEE-2869

Database error when method DateBasedPublisherServiceInterface::scheduleVersion is called on already scheduled version

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • 2.5.5
    • 3.0.0-beta1, 2.5.4
    • Date-Based Publisher
    • None

    Description

      In AbstractMySQLDriver.php line 55:
      
        [Doctrine\DBAL\Exception\UniqueConstraintViolationException]
        An exception occurred while executing 'INSERT INTO `ezdatebasedpublisher_scheduled_version` (`content_id`, `version_id`, `version_number`, `user_id`, `publ
        ication_date`, `url_root`) VALUES (:placeholder1, :placeholder2, :placeholder3, :placeholder4, :placeholder5, :placeholder6)' with params [57, 526, 1, 14,
        1568107200, "asdasd"]:
      
        SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '57-1' for key 'content_id_version_number'
      
      
      Exception trace:
       () at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:55
       Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169
       Doctrine\DBAL\DBALException::wrapException() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:145
       Doctrine\DBAL\DBALException::driverExceptionDuringQuery() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:162
       Doctrine\DBAL\Statement->execute() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Gateway/DoctrineDatabase.php:216
       EzSystems\DateBasedPublisher\Core\Persistence\Gateway\DoctrineDatabase->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Handler.php:62
       EzSystems\DateBasedPublisher\Core\Persistence\Handler->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Repository/DateBasedPublisherService.php:101
       EzSystems\DateBasedPublisher\Core\Repository\DateBasedPublisherService->scheduleVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/SignalSlot/DateBasedPublisherService.php:53
       EzSystems\DateBasedPublisher\Core\SignalSlot\DateBasedPublisherService->scheduleVersion() at /Users/awojs/eZ/ezplatform-ee-master/src/Command/ReproduceCommand.php:78
       App\Command\ReproduceCommand->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Command/Command.php:255
       Symfony\Component\Console\Command\Command->run() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:939
       Symfony\Component\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:87
       Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:273
       Symfony\Component\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:73
       Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/Console/Application.php:52
       eZ\Bundle\EzPublishCoreBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:149
       Symfony\Component\Console\Application->run() at /Users/awojs/eZ/ezplatform-ee-master/bin/console:38
      
      In PDOStatement.php line 119:
      
        [Doctrine\DBAL\Driver\PDOException (23000)]
        SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '57-1' for key 'content_id_version_number'
      
      
      Exception trace:
       () at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
       Doctrine\DBAL\Driver\PDOStatement->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:153
       Doctrine\DBAL\Statement->execute() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Gateway/DoctrineDatabase.php:216
       EzSystems\DateBasedPublisher\Core\Persistence\Gateway\DoctrineDatabase->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Handler.php:62
       EzSystems\DateBasedPublisher\Core\Persistence\Handler->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Repository/DateBasedPublisherService.php:101
       EzSystems\DateBasedPublisher\Core\Repository\DateBasedPublisherService->scheduleVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/SignalSlot/DateBasedPublisherService.php:53
       EzSystems\DateBasedPublisher\Core\SignalSlot\DateBasedPublisherService->scheduleVersion() at /Users/awojs/eZ/ezplatform-ee-master/src/Command/ReproduceCommand.php:78
       App\Command\ReproduceCommand->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Command/Command.php:255
       Symfony\Component\Console\Command\Command->run() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:939
       Symfony\Component\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:87
       Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:273
       Symfony\Component\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:73
       Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/Console/Application.php:52
       eZ\Bundle\EzPublishCoreBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:149
       Symfony\Component\Console\Application->run() at /Users/awojs/eZ/ezplatform-ee-master/bin/console:38
      
      In PDOStatement.php line 117:
      
        [PDOException (23000)]
        SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '57-1' for key 'content_id_version_number'
      
      
      Exception trace:
       () at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
       PDOStatement->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
       Doctrine\DBAL\Driver\PDOStatement->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:153
       Doctrine\DBAL\Statement->execute() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Gateway/DoctrineDatabase.php:216
       EzSystems\DateBasedPublisher\Core\Persistence\Gateway\DoctrineDatabase->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Persistence/Handler.php:62
       EzSystems\DateBasedPublisher\Core\Persistence\Handler->insertScheduledVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/Repository/DateBasedPublisherService.php:101
       EzSystems\DateBasedPublisher\Core\Repository\DateBasedPublisherService->scheduleVersion() at /Users/awojs/Workspace/date-based-publisher/lib/Core/SignalSlot/DateBasedPublisherService.php:53
       EzSystems\DateBasedPublisher\Core\SignalSlot\DateBasedPublisherService->scheduleVersion() at /Users/awojs/eZ/ezplatform-ee-master/src/Command/ReproduceCommand.php:78
       App\Command\ReproduceCommand->execute() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Command/Command.php:255
       Symfony\Component\Console\Command\Command->run() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:939
       Symfony\Component\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:87
       Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:273
       Symfony\Component\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/framework-bundle/Console/Application.php:73
       Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/ezsystems/ezpublish-kernel/eZ/Bundle/EzPublishCoreBundle/Console/Application.php:52
       eZ\Bundle\EzPublishCoreBundle\Console\Application->doRun() at /Users/awojs/eZ/ezplatform-ee-master/vendor/symfony/console/Application.php:149
       Symfony\Component\Console\Application->run() at /Users/awojs/eZ/ezplatform-ee-master/bin/console:38
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            adam.wojs@ibexa.co Adam Wójs
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: