Error Occurs on Large Updates

leeottaway · Post by **leeottaway** » Mon 05 May 2008 21:59

Hi

As part of switchinmg to PostGres, we have to do reasonably large imports (consisting of arounf 400000 records) from various tables that come from a different database. All we do is get the data from the old database, loop through each record and update it to Postgres using ADO.NET, adapters, datatables and a command builder (we need to loop through because we often have to modify the data very slightly before it gets sent to PostGres). Whilst looping through the records we update them to the database about once every 1000 records. Very basic stuff, however the Corelabs provider will randomly error with "Error preprared statement PRSTMT2128149872399187 already exists" (or some equally large number). This happens at least once on virtually every import. Now I realize this is because CoreLabs must be generating a supposedly very large random number that is meant to be unique but computers don't seem to do random very well. So is there any way of stopping this from happening. If it only occured once every 100 imports, we wouldn;t jhave a problem, however I can state that it happens EVERY time at least once.

Any suggestions?

Thanks

Lee Ottaway
Fusion Software (UK) Ltd

Alexey.mdr · Post by **Alexey.mdr** » Tue 06 May 2008 12:10

Hi!

Could you please specify the version of PostgreSQLDirect .NET?
Similar issue has been fixed in the version 3.5*.*.

leeottaway · Post by **leeottaway** » Tue 06 May 2008 14:56

OK, I'm running version 3.30. How do I get hold of the professional version upgrade? All I can find on your site is a trial for the standard version?

Thanks

Lee Ottaway
Fusion Software (UK) Ltd

leeottaway · Post by **leeottaway** » Wed 07 May 2008 07:54

Don't worry about it, I found my original download password and username and downloaded it from there.

Alexey.mdr · Post by **Alexey.mdr** » Wed 07 May 2008 09:35

Please let me know if the issue is solved.

leeottaway · Post by **leeottaway** » Wed 07 May 2008 10:35

Just to let you know the issue is NOT resolved in the latest version. We just did a large conversion again and on a table that has 199602 records it fell over with the prepared statement already exists bug.

Any ideas?

Lee Ottaway
Fusion Software (UK) Ltd

Alexey.mdr · Post by **Alexey.mdr** » Wed 07 May 2008 12:19

Hi Lee,

could you please point to the PostgreSQLDirect .NET component that you are using for inserting.
Please also send me a small test project to reproduce the problem
and include the definition of your own database objects, if possible.