Actions
Bug #8011
closedpymysql adds duplicated index to table with a new keyname
Start date:
09/05/2019
Due date:
% Done:
0%
Estimated time:
Affected Version:
Appion/Leginon 3.5
Show in known bugs:
No
Workaround:
Description
This is found in projectdb.projectexperiments at one installation. Oddly it is not found at other installations. Some database option was unique there that it allows pymysql 0.6.6 to insert an index with its own modified name when sinedon repeatly requests "add index" without name specification. Normally, such repeated request triggers a warning of duplicated index (Error 1066) and does not add.
Updated by Anchi Cheng about 5 years ago
If an earlier version of myami-pymysql is used, the database should be fixed with dbschema/tools/fixindex.py It will search for possible index keyname that pymysql uses.
Actions