BUG #16043: Duplicate Entry Key Message on postgres

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16043: Duplicate Entry Key Message on postgres

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      16043
Logged by:          Jason John
Email address:      [hidden email]
PostgreSQL version: 11.0
Operating system:   Centos 7
Description:        

We are currently experiencing a problem with DataSet objects that behave
differently between Oracle and Postgres.

When we perform "Next Page" / "Previous Page" repeatedly the application
crashes with a "Duplicate Entry Key" Message on postgres.

At the following address
http://docwiki.embarcadero.com/RADStudio/Rio/en/Browsing_Tables_(FireDAC)
(See: Avoiding "Unique Key Violation" Error in LDW Mode at the end of the
page), it seems that our difficulties can come from character encoding
problem. Is there any solution?

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16043: Duplicate Entry Key Message on postgres

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> We are currently experiencing a problem with DataSet objects that behave
> differently between Oracle and Postgres.
> When we perform "Next Page" / "Previous Page" repeatedly the application
> crashes with a "Duplicate Entry Key" Message on postgres.

It's impossible for anyone to help you on the basis of so little
information.  Please read

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

                        regards, tom lane


Reply | Threaded
Open this post in threaded view
|

Re: BUG #16043: Duplicate Entry Key Message on postgres

Komal Sookee
Hello Tom,

Could you help me out to find out a solution?

What information do you need?

Regards,
Jason

On Mon, 7 Oct 2019 at 17:35, Tom Lane <[hidden email]> wrote:
PG Bug reporting form <[hidden email]> writes:
> We are currently experiencing a problem with DataSet objects that behave
> differently between Oracle and Postgres.
> When we perform "Next Page" / "Previous Page" repeatedly the application
> crashes with a "Duplicate Entry Key" Message on postgres.

It's impossible for anyone to help you on the basis of so little
information.  Please read

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

                        regards, tom lane


--

Komal Sookee, Consultant Spoon Consulting Ltd | office: +230 433 34 77

This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. Spoon Consulting Ltd shall not therefore be liable for the message if modified.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16043: Duplicate Entry Key Message on postgres

Tomas Vondra-4
On Mon, Oct 07, 2019 at 05:40:14PM +0400, Komal Sookee wrote:
>Hello Tom,
>
>Could you help me out to find out a solution?
>
>What information do you need?
>

I'd start by reading the wiki page Tom already pointed you to. That's a
pretty extensive summary and it should give you at least some rought
idea what information would be useful ...

In this particular case, you should probably start with an explanation
what environment you're using, what queries are generated by the
DataSet, what exactly "Duplicate Entry Key" means in the context of the
application, and scavenge all the various logs (application, database,
...) for as much additional details as possible.

Considering PostgreSQL does not generate any "Duplicate Entry Key"
errors (there are no such messages in the source code), this very much
seems like an issue in the application and not in the database. So maybe
the first thing you need to do is convincing us this actually is a
database issue.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services