Re: Ynt:[GENERAL] postgresql : could not serialize access due toread/write dependencies among transactions

Neslisah Demirci wrote:

> First I started conversation between two person ;
>
>
> sql: 'INSERT INTO "XXXXX" ("id","customer","createdAt","updatedAt","CompanyId") VALUES
(DEFAULT,\'905322653555\',\'2017-01-1719:13:37.751 +00:00\',\'2017-01-17 19:13:37.751 +00:00\',\'1\') RETURNING *;' }, 
>
>
> name: 'error', length: 274, severity: 'ERROR', code: '40001', detail: 'Reason code: Canceled on identification as a
pivot,during write.', hint: 'The transaction might succeed if retried.', position: undefined, internalPosition:
undefined,internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType:
undefined,constraint: undefined, file: 'predicate.c', line: '4605', routine: 'OnConflict_CheckForSerializationFailure', 
>
>
>
> Secondly ; i inserted messages as below;
>
>
> Begin;
>
> 'INSERT INTO "YYYYY"
("id","body","from","to","state","data","xId","createdAt","updatedAt","CompanyId","MessageTypeId","ConvId")VALUES
(DEFAULT,\'messagetext\',\'905309788255\',\'905309788200\',\'customer\',NULL,\'463DA712296218E0D4\',\'2017-01-17
06:43:19.228+00:00\',\'2017-01-17 06:43:19.228 +00:00\',\'1\',1,23286) RETURNING *;' 
>
> commit;

Are there triggers or foreign keys in these tables?

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