Hello,
YAIM states explicitely that the fact that the indexes already exist is harmless.
And so does the documentation.
Regards.
Sophie.
-----Original Message-----
From: LHC Computer Grid - Rollout on behalf of Adam Padee
Sent: Fri 3/9/2007 7:26 PM
To: [log in to unmask]
Subject: Re: [LCG-ROLLOUT] Fwd: URGENT: update script of DPM failing
Hi Michel and all unfortunate DPM autoupdaters;
Michel Jouvin wrote:
> We had such a problem. This means you have corrupted the DPM database.
> The only solution is :
>
> - mysqldump database
> - Delete database
> - Create a new fresh database
> - Restore dump
>
After restoration of the dump I also had to do the following:
mysql dpm_db -u dpmmgr -p
mysql> DROP INDEX G_PFN_IDX ON dpm_get_filereq;
mysql> DROP INDEX P_PFN_IDX ON dpm_put_filereq;
This had to be done before executing the update script, because it tries
to make these indices without checking if they already exist. As they
were present in the old database, the script failed.
Best regards,
Adam
|