[
http://mifosforge.jira.com/browse/MIFOSADMIN-319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kalyan Akella resolved MIFOSADMIN-319.
--------------------------------------
Resolution: Fixed
Assignee: jbrewster
> Clean up bad corrupted data on test servers - Question Group
> ------------------------------------------------------------
>
> Key: MIFOSADMIN-319
> URL: http://mifosforge.jira.com/browse/MIFOSADMIN-319
> Project: mifos administration
> Issue Type: Bug
> Reporter: jbrewster
> Assignee: jbrewster
>
> We need to clean up the various Mifos test server db's question_choice_tags
> table using the following commands. From issue MIFOS-4647:
> The table definition for question_choice_tags is corrupted. The unique key
> constraint is altered from (choice_id, tag_text) to just (tag_text). To fix
> this issue, run the following SQLs in that order:
> 1. alter table question_choice_tags drop key choice_id;
> 2. alter table question_choice_tags drop index tag_text;
> 3. alter table question_choice_tags add unique (choice_id,tag_text);
> We did this on the hudson_mifos_f_release schema on the birch box and that
> fixed the problem.
> We believe the hudson_mifos_gazelle_pseudolocale schema was created basing on
> a dump taken from a corrupted index and hence the bug appeared there too.
> Please run the above SQLs to fix this on other environments.
> ---------
> I tried this on db hudson_mifos_gazelle_pseudolocale and got this error:
> mysql> alter table question_choice_tags drop key choice_id;
> ERROR 1025 (HY000): Error on rename of
> './hudson_mifos_gazelle_pseudolocale/#sql-3a4a_22f' to
> './hudson_mifos_gazelle_pseudolocale/question_choice_tags' (errno: 150)
> so might need some other step first?
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
