[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problem With Saving Parts

Hi all,
I've mentioned this before, but it is now becoming a real problem.

When Saving a part with the Vendor info filled in it is taking
increasingly long for for the save not to produce this error:

"DBD::Pg::st execute failed: ERROR: duplicate key violates unique
constraint "partsvendor_pkey" at LedgerSMB/IC.pm line 529.


INSERT INTO partsvendor 
(vendor_id, parts_id, 
partnumber, lastcost, 
leadtime, curr)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: duplicate key violates unique constraint "partsvendor_pkey"

There seems to be no rhyme nor reason, sometimes it works first time,
every time for a while, other (now most) times it can take ages.

The record so far is 102 attempts, and just changing a spelling mistake
can now take 20 mins!

When saving a new part, the same happens but the part record is saved
without the vendor info - the part complete records then have to be
deleted manually.

The only trend is that it is getting much worse as the dbase grows!

If necessary I can supply a back-up of our dbase for testing - I was
hoping that I could hang on for 1.3, but this is becoming a real


I have become....... comfortably numb.