P4DTI issue job000461

TitleBugzilla integration doesn't support multiple Perforce servers
Assigned userNick Barnes
DescriptionThe Bugzilla integration doesn't work with multiple Perforce servers. The second replicator instance will fail.
The failure is reported with this message:
_mysql.OperationalError: (1091, "Can't DROP 'action'. Check that column/key exists")
AnalysisThe code to handle changes in the P4DTI schema looks for a config item called schema_version. However, config items (rows in the p4dti_config table) are per-replicator, so if there is more than one replicator, the schema_version config item written by one replicator won't be found by the other. So the second replicator will think that the schema is version 0 (no schema_version) and will try to upgrade it. This upgrade will fail with the message quoted above.
How foundcustomer
Observed in1.4.0
Created byNick Barnes
Created on2002-02-06 14:16:19
Last modified byNick Barnes
Last modified on2002-04-09 11:33:23
History2002-02-06 NB Created.


Change Effect Date User Description
26878 closed 2002-02-22 12:07:29 Gareth Rees The P4DTI schema version doesn't depend on the replicator and server identifiers.