INSERT IGNORE isn't being fixed up for postgres in fsck related code.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. day to day operation
2. mogadm fsck (lots when running)

What is the expected output? What do you see instead?
We see the following identical multiple entries in our postgres logs:

LOG:  execute <unnamed>: INSERT INTO server_settings (field, value) VALUES 
($1, $2)
DETAIL:  parameters: $1 = 'fsck_logid_processed', $2 = '9432699'
ERROR:  duplicate key value violates unique constraint "server_settings_pkey"

What version of the product are you using? On what operating system?
Mogile 2.45
Fedora8

Please provide any additional information below.
(PostgreSQL) 8.3.0

Original issue reported on code.google.com by tsaavik on 15 Mar 2011 at 7:36

[GoogleCodeExporter]

This is due to REPLACE INTO emulation, so if your log levels are too verbose 
it'll spam. (according to robbat).

I'm going to close this. Re-open if fsck is actually not working correctly? IE 
is it actually progressing and fsck'ing items correctly?

Original comment by dorma...@rydia.net on 10 Oct 2011 at 9:51

• Changed state: Invalid

[GoogleCodeExporter]

Just creates some spam in the postgres logs, everything works.
Nice to know the code is seeing the failure and taking the correction action. :D

Original comment by tsaavik on 10 Oct 2011 at 10:30