Re: Uncaught PHP ExceptionDoctrine\DBAL\Exception\UniqueConstraintViolationException: "An exceptionoccurred while executing 'UPDATE

On 08/14/2018 05:58 AM, Jarosław Torbicki wrote:
>
> Hello,
>
> I used PostgreSQL 9.3 but I executed upgrade few days ago.
>
> Now, I am using 10.4 PostgreSQL and:
>
> doctrine/annotations                 v1.2.7
>
> doctrine/cache                       v1.4.2
>
> doctrine/collections                 v1.3.0
>
> doctrine/common                      v2.7.3
>
> doctrine/dbal                        v2.5.13
>
> doctrine/doctrine-bundle             v1.5.2
>
> doctrine/doctrine-cache-bundle       v1.0.1
>
> doctrine/inflector                   v1.0.1
>
> doctrine/instantiator                1.0.5
>
> doctrine/lexer                       v1.0.1
>
> doctrine/orm                         v2.5.14
>
> I have a problem with ManyToOne relation.
>
> For example, I have main object with three child and when I execute on 
> main object
>
>                             $em = $this->getDoctrine()->getManager();
>
>                 $em->merge($data);
>
>                             $em->flush();
>
> I sometimes get ERROR message like:
>
> /Uncaught PHP Exception 
> Doctrine\DBAL\Exception\UniqueConstraintViolationException: "An 
> exception occurred while executing 'UPDATE/
>
> I get this ERRROR message not for all main object and not for all 
> child. For example, first update child object is ok but in second I 
> get error.
>
> SQL prepared by doctrine:
>
> UPDATE child_table SET id = ?, name = ?, object_name = ?, object_size 
> = ? WHERE id = ?' with params ["2", "test Name object 2", "test name 
> object 2", "1234", 3]
>
> In this sql the doctrine tries update object with id=3 using data from 
> object with id = 2.
>
> This problem didn’t occur before executing upgrade to 10.4 version.
>
> Can you help me and give some tips?
>



This mailing list is about development of PostgreSQL, not about how to 
use it. Please ask in the correct forum (possibly the pgsql-general 
mailing list)

cheers

andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services