← Back to team overview

dhis2-devs team mailing list archive

Multiple database creation errors with MySql

 

2.13-SNAPSHOT build 11893

Seems like there are many Tracker changes that don't work well with MySql
5.5.27

Starting with an empty db. See attached log.

-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
* INFO  2013-09-14 13:50:02,172 Hibernate configuration loaded, using dialect: o
rg.hibernate.dialect.MySQLDialect (DefaultHibernateConfigurationProvider.java [l
ocalhost-startStop-1])
* ERROR 2013-09-14 13:50:27,721 HHH000388: Unsuccessful: alter table dataelement
categoryoption add index fk_dataelementcategory_conceptid (conceptid), add const
raint fk_dataelementcategory_conceptid foreign key (conceptid) references concep
t (conceptid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:27,729 Can't create table 'd2kh.#sql-1574_276' (errno:
121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:32,037 HHH000388: Unsuccessful: alter table interpretat
ioncomment add index fk_interpretation_userid (userid), add constraint fk_interp
retation_userid foreign key (userid) references userinfo (userinfoid) (SchemaUpd
ate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:32,045 Can't create table 'd2kh.#sql-1574_276' (errno:
121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:36,968 HHH000388: Unsuccessful: alter table patientregi
strationform_fixedAttributes add index fk_patientregistrationform_fixedAttribute
s_patientregistrationformid (patientregistrationformid), add constraint fk_patie
ntregistrationform_fixedAttributes_patientregistrationformid foreign key (patien
tregistrationformid) references patientregistrationform (patientregistrationform
id) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:36,975 Identifier name 'fk_patientregistrationform_fixe
dAttributes_patientregistrationformid' is too long (SchemaUpdate.java [localhost
-startStop-1])
* ERROR 2013-09-14 13:50:36,997 HHH000388: Unsuccessful: alter table patientregi
strationform_identifierTypes add index fk_patientregistrationform_identifiertype
_patientregistrationformid (patientidentifiertypeid), add constraint fk_patientr
egistrationform_identifiertype_patientregistrationformid foreign key (patientide
ntifiertypeid) references patientidentifiertype (patientidentifiertypeid) (Schem
aUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:37,007 Identifier name 'fk_patientregistrationform_iden
tifiertype_patientregistrationformid' is too long (SchemaUpdate.java [localhost-
startStop-1])
* ERROR 2013-09-14 13:50:39,982 HHH000388: Unsuccessful: alter table report add
index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_report_
relativeperiodsid foreign key (relativeperiodsid) references relativeperiods (re
lativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:39,990 Can't create table 'd2kh.#sql-1574_276' (errno:
121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:40,098 HHH000388: Unsuccessful: alter table reporttable
 add index fk_report_relativeperiodsid (relativeperiodsid), add constraint fk_re
port_relativeperiodsid foreign key (relativeperiodsid) references relativeperiod
s (relativeperiodsid) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:40,109 Can't create table 'd2kh.#sql-1574_276' (errno:
121) (SchemaUpdate.java [localhost-startStop-1])
* ERROR 2013-09-14 13:50:42,078 HHH000388: Unsuccessful: alter table usergroupme
mbers add index fk_usergroup_userid (userid), add constraint fk_usergroup_userid
 foreign key (userid) references userinfo (userinfoid) (SchemaUpdate.java [local
host-startStop-1])
* ERROR 2013-09-14 13:50:42,083 Can't create table 'd2kh.#sql-1574_276' (errno:
121) (SchemaUpdate.java [localhost-startStop-1])
* INFO  2013-09-14 13:51:01,369 Found the following message senders: [org.hisp.d
his.message.EmailMessageSender@fb36de, org.hisp.dhis.sms.SmsMessageSender@cf5675
] (DefaultMessageService.java [localhost-startStop-1])
* INFO  2013-09-14 13:51:51,419 Camel context started (DHIS2LifecycleStrategy.ja
va [localhost-startStop-1])

Follow ups