nathandunn
commented
9 years ago I’m assuming trying to setup a production database by deploying a the .war file int tomcat?
If so, I would recommend create a postgresql or mysql database and connect to that. If you want to continue with H2, you will have to to over-ride the apollo-config.groovy file to use dataSource.dbCreate = “create”, though I don’t recommend this as embedded databases are typically slower.
You might want to look through here and the “sample-*.groovy” files.
https://webapollo.readthedocs.org/en/latest/Apollo2Build/
Let me know if you need additional help.
Nathan
On May 26, 2015, at 2:51 AM, lfaino notifications@github.com wrote:
Dear, I`m trying to configure WebApollo but I have some issues. here the error:
this is the first (maybe a note not an error)
Note: /home/luigi/Downloads/Apollo/target/work/plugins/shiro-1.2.1/src/java/org/apache/shiro/grails/LegacyShiroFilter.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details.
the error comes here:
Shiro Configured | Error 2015-05-26 11:42:17,175 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_feature drop foreign key FK_8m30ycwh545b4aoxor9sbk1oq | Error 2015-05-26 11:42:17,176 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_feature' doesn't exist | Error 2015-05-26 11:42:17,177 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_feature drop foreign key FK_l94xl424xp988f06gr2b3t5tw | Error 2015-05-26 11:42:17,177 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_feature' doesn't exist | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_property drop foreign key FK_38g8n4bitmdwkrcs217uexrwx | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_property' doesn't exist | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_property drop foreign key FK_9o7xs7saygim8y0sm4ostvpc1 | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_property' doesn't exist | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table canned_comment_feature_type drop foreign key FK_es9vpf57b7a14sv803xy64k8h | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.canned_comment_feature_type' doesn't exist | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table canned_comment_feature_type drop foreign key FK_8l290fdei9m707s7ngn712sts | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.canned_comment_feature_type' doesn't exist | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm drop foreign key FK_oksfqluv12ktmut9s6o9jla7a | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm' doesn't exist | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm drop foreign key FK_6d097oy44230tuoo8lb8dkkcp | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm' doesn't exist | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_ke2nrw91sxil8mv7osgv83pw1 | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_tlfh10092i00g6rlv589naqy5 | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_nq02ir0qeydr5tj3071k9gl7b | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_jaqi1bk3t2c0m3pybmparp856 | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_r1o1rnfnsf7oipuv1h7h1fln7 | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_pwxrfyx6rqu5krq4nj5wa3u4f | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_ob1d0vrfaix8b28j4tvilqnyv | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table data_adapter_data_adapter drop foreign key FK_c5a2cdstwj0ydibnu567urh7q | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.data_adapter_data_adapter' doesn't exist | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table data_adapter_data_adapter drop foreign key FK_321276juoco9ijc32gxeo7mi9 | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.data_adapter_data_adapter' doesn't exist | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref drop foreign key FK_np3tfcu9g867to3qux6raf9y8 | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref' doesn't exist | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref_property drop foreign key FK_3p1ssctww083s0tt65mmm64uo | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref_property' doesn't exist | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref_property drop foreign key FK_t6ojbvugx8kou45oklsie3rt5 | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref_property' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table environmentcvterm drop foreign key FK_tql9djnqw1d7migfndoj3lrph | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.environmentcvterm' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table environmentcvterm drop foreign key FK_rrwb96jjqgtg077yv8pbim3jj | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.environmentcvterm' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_hc4vrafs0ws7ugdkp0n6u3xdo | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_kfq8esgv3in8wxml2x36f2md | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_7huaou2aj3ac3oa49c1e0nhlm | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_dbxref drop foreign key FK_n6n7lheb1qkmlde8u6gvvjxne | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_dbxref' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_dbxref drop foreign key FK_1mrfkxbb3n7fhjxcrkxappdn8 | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_dbxref' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_event drop foreign key FK_35nc3xd2axx6fwyap4bjkt09u | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_event' doesn't exist | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_feature_phenotypes drop foreign key FK_aqr7eiyx6puju6elciwubbwmo | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_feature_phenotypes' doesn't exist | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_feature_phenotypes drop foreign key FK_dy5g29heir5ic3d36okyuihho | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_feature_phenotypes' doesn't exist | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_hak8r429shmpho06rbyvwnmt0 | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_b42u9iq4kuqe5ay544do81n32 | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,193 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_cm3gqs38fa2lpllgoum8n4kgn | Error 2015-05-26 11:42:17,193 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,206 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_736wxgjs6pip5212ash5i68p | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_grails_user drop foreign key FK_lflwbgxduee8ljjwe5rfbdil2 | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_grails_user' doesn't exist | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_grails_user drop foreign key FK_4dgbhgiw0vb9hqy2k5fqg3neh | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_grails_user' doesn't exist | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location drop foreign key FK_qml7xp9f5uojcw7jwdxcb35le | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location' doesn't exist | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location drop foreign key FK_dhnrehn3tj85m2j9c0m4md3f4 | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location' doesn't exist | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location_publication drop foreign key FK_n4lr2f61atuxmm8cb90qtkojq | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location_publication' doesn't exist | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location_publication drop foreign key FK_jquf8fftudekrwgx1e870jy43 | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location_publication' doesn't exist | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property drop foreign key FK_jpvdxc57abfiridcr57x8130 | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property' doesn't exist | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property drop foreign key FK_36e638geg9tew42b1mp2ehff | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property' doesn't exist | Error 2015-05-26 11:42:17,212 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property_publication drop foreign key FK_j4dnb11fi9vcvrdjo5m352pyq | Error 2015-05-26 11:42:17,212 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property_publication drop foreign key FK_86law9p6s1pbt02n3mltkcqwh | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_publication drop foreign key FK_580odgbjowisfshvk82rfjri2 | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_publication drop foreign key FK_qolh5l4blkx8vfmwcl7f3woan | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_publication' doesn't exist | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship drop foreign key FK_8jm56covt0m7m0m191bc5jseh | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship' doesn't exist | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship drop foreign key FK_72kmd92rdc6gne0nrh026o1j0 | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship' doesn't exist | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_feature_property drop foreign key FK_scm5rx2kuhgkhdfvskyo924cy | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_feature_property' doesn't exist | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_feature_property drop foreign key FK_ebgnfbogf1lwdxd8jc17511o7 | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_feature_property' doesn't exist | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_publication drop foreign key FK_4j4u29xis9bhr65slfaimgjye | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_publication' doesn't exist | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_publication drop foreign key FK_bdd324e5jb0lpuhs7biy2kacm | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_publication' doesn't exist | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_nf9qbuay984ixqd2k1425rnyo | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_82wsc3bv9i01t9851xv4xekis | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_ll4cqdh994s6x8n7vku1q7iwd | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_gsol4u8wrfwbkh1qrx18i3u6 | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_cuwo3ernssd0t0wjceb7lmm11 | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_iy7bbt67s7jaemiajsrqalv5o | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_q3wop7ii25dgiofnp2l3yj9v0 | Error 2015-05-26 11:42:17,222 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_dbxref drop foreign key FK_r9xhefcekikp1od79ectkb22b | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_dbxref' doesn't exist | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_dbxref drop foreign key FK_pniehpb3pk1rqe95ejk0od6vg | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_dbxref' doesn't exist | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_publication drop foreign key FK_g6l9cr99p5dhb0kvs9y0tjwnv | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_publication' doesn't exist | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_publication drop foreign key FK_3a9j1mryggb0bcaguvkhw8hjm | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_publication' doesn't exist | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table grails_user_roles drop foreign key FK_4mxkyj2itw9wyvcn6d8d4mta2 | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.grails_user_roles' doesn't exist | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table grails_user_roles drop foreign key FK_jsuq1rc9mb07tg4kubnqn8yw6 | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.grails_user_roles' doesn't exist | Error 2015-05-26 11:42:17,226 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_organism_property drop foreign key FK_f1e1d91q04mqaij1ep3s36ujl | Error 2015-05-26 11:42:17,226 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_organism_property' doesn't exist | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_organism_property drop foreign key FK_qyxdgqthtlgixvtdkkhc8g3pu | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_organism_property' doesn't exist | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organism_property drop foreign key FK_8jxbx51qysqlm07orah5xg45y | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organism_property' doesn't exist | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organism_property drop foreign key FK_3rtkicqpr3ca8dwivye3yajaa | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organism_property' doesn't exist | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organismdbxref drop foreign key FK_jbw15sttun6yrcrxchi0lwtam | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organismdbxref drop foreign key FK_kaayriabr4k4b3aomk46dmc77 | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organismdbxref drop foreign key FK_s3vk7onqrk0n4c86xnvqmm3ho | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,230 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organismdbxref drop foreign key FK_l1jfi0wpnyooutd820p5gskr | Error 2015-05-26 11:42:17,230 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_4nvoxx3htem6jseb4rmu0aqfp | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_hycx5el5itt1lqidt532shkpj | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_6p3mx8al2w4f7ltqiwf1j88fm | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_cwgh6naf9gackae2ei11v6p41 | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,233 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_phmfgylejydjqyrvo3imc97go | Error 2015-05-26 11:42:17,233 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,234 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_jh0fc3orduigl8s7ymentbtrs | Error 2015-05-26 11:42:17,234 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_gb4wy9qesx6vnekxekm18k9xa | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_cvterm drop foreign key FK_9e2v7goj5w6nds5jo0x1va1nm | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_cvterm' doesn't exist | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_cvterm drop foreign key FK_aicsmj1kn20ikm14292g9r2j9 | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_cvterm' doesn't exist | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_t52r166gd8710vffy3aompe7d | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_bf1bstadamyw0gsarkb933l5b | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_1kkkx1uxs6li0r72qhvke6o77 | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_8pbyj05khavdl5a648c7pmcil | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_q6jvhi3l7ty0m9tpbn09d8pxj | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_8rbhsxxdf669tyed8jrr747hv | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_gskh1e7b6qa2du48ayu49lr3s | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_hffc43aavltp8t5dtwactux5f | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_tk1pgifvuhurefn0y3myfyyt4 | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_ro87rogww8hoobbwya2nn16xk | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_42b0lk4rcfjcagw84jugd1sgj | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_i94ksmdxi88hcqnuycebgkdvs | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication drop foreign key FK_h3g8f3q2krcnwmq2nasbanlay | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication' doesn't exist | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_author drop foreign key FK_9eou8yof43krmrsdvfhfuisln | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_author' doesn't exist | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_97qgrmdull1avkfqpfq1mc1wt | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_euu6xx78omdvver8lij1ys2oq | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,246 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_q6hf14oiq9pomkjrhtndonmeh | Error 2015-05-26 11:42:17,246 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publicationdbxref drop foreign key FK_oh81hma8qx88fhvcmfugx836b | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publicationdbxref' doesn't exist | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publicationdbxref drop foreign key FK_pgoyqd75q47r6ycwowcppbhk6 | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publicationdbxref' doesn't exist | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table role_permissions drop foreign key FK_d4atqq8ege1sij0316vh2mxfu | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.role_permissions' doesn't exist | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table sequence drop foreign key FK_rux0954nxr4lwvj2qgyjibua7 | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.sequence' doesn't exist | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table sequence_chunk drop foreign key FK_4tsu0cp2dh2avbxifp1h1c9vd | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.sequence_chunk' doesn't exist | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table synonym drop foreign key FK_4ylco1irefvydmsnedglqqdfu | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.synonym' doesn't exist | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table user_group_users drop foreign key FK_9jib0g899h0gy3dypo7datfm9 | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.user_group_users' doesn't exist | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table user_group_users drop foreign key FK_jppito7humh6e3v5mjjtutd7h | Error 2015-05-26 11:42:17,251 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.user_group_users' doesn't exist organism null | Running 8 integration tests... 11 of 11 | Error 2015-05-26 11:43:14,728 [main] ERROR spi.SqlExceptionHelper - Data truncation: Data too long for column 'current' at row 1 | Failure: adding an exon to an existing transcript(org.bbop.apollo.RequestHandlingServiceIntegrationSpec) | org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; SQL [n/a]; Data truncation: Data too long for column 'current' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'current' at row 1 at org.bbop.apollo.FeatureEventService.$ttaddNewFeatureEvent(FeatureEventService.groovy:66) at org.bbop.apollo.RequestHandlingService.$ttaddExon(RequestHandlingService.groovy:636) at org.bbop.apollo.RequestHandlingServiceIntegrationSpec.adding an exon to an existing transcript(RequestHandlingServiceIntegrationSpec.groovy:334) Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'current' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2350)
I think that it is an mysql error but i`m not sure
thanks Luigi
— Reply to this email directly or view it on GitHub.
lfaino
holmrenser
Dear, I`m trying to configure WebApollo but I have some issues. here the error:
this is the first (maybe a note not an error)
Note: /home/luigi/Downloads/Apollo/target/work/plugins/shiro-1.2.1/src/java/org/apache/shiro/grails/LegacyShiroFilter.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details.
the error comes here:
Shiro Configured | Error 2015-05-26 11:42:17,175 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_feature drop foreign key FK_8m30ycwh545b4aoxor9sbk1oq | Error 2015-05-26 11:42:17,176 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_feature' doesn't exist | Error 2015-05-26 11:42:17,177 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_feature drop foreign key FK_l94xl424xp988f06gr2b3t5tw | Error 2015-05-26 11:42:17,177 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_feature' doesn't exist | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_property drop foreign key FK_38g8n4bitmdwkrcs217uexrwx | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_property' doesn't exist | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table analysis_property drop foreign key FK_9o7xs7saygim8y0sm4ostvpc1 | Error 2015-05-26 11:42:17,178 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.analysis_property' doesn't exist | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table canned_comment_feature_type drop foreign key FK_es9vpf57b7a14sv803xy64k8h | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.canned_comment_feature_type' doesn't exist | Error 2015-05-26 11:42:17,179 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table canned_comment_feature_type drop foreign key FK_8l290fdei9m707s7ngn712sts | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.canned_comment_feature_type' doesn't exist | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm drop foreign key FK_oksfqluv12ktmut9s6o9jla7a | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm' doesn't exist | Error 2015-05-26 11:42:17,180 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm drop foreign key FK_6d097oy44230tuoo8lb8dkkcp | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm' doesn't exist | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_ke2nrw91sxil8mv7osgv83pw1 | Error 2015-05-26 11:42:17,181 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_tlfh10092i00g6rlv589naqy5 | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_nq02ir0qeydr5tj3071k9gl7b | Error 2015-05-26 11:42:17,182 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_path drop foreign key FK_jaqi1bk3t2c0m3pybmparp856 | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_path' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_r1o1rnfnsf7oipuv1h7h1fln7 | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,183 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_pwxrfyx6rqu5krq4nj5wa3u4f | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table cvterm_relationship drop foreign key FK_ob1d0vrfaix8b28j4tvilqnyv | Error 2015-05-26 11:42:17,184 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.cvterm_relationship' doesn't exist | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table data_adapter_data_adapter drop foreign key FK_c5a2cdstwj0ydibnu567urh7q | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.data_adapter_data_adapter' doesn't exist | Error 2015-05-26 11:42:17,185 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table data_adapter_data_adapter drop foreign key FK_321276juoco9ijc32gxeo7mi9 | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.data_adapter_data_adapter' doesn't exist | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref drop foreign key FK_np3tfcu9g867to3qux6raf9y8 | Error 2015-05-26 11:42:17,186 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref' doesn't exist | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref_property drop foreign key FK_3p1ssctww083s0tt65mmm64uo | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref_property' doesn't exist | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table dbxref_property drop foreign key FK_t6ojbvugx8kou45oklsie3rt5 | Error 2015-05-26 11:42:17,187 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.dbxref_property' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table environmentcvterm drop foreign key FK_tql9djnqw1d7migfndoj3lrph | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.environmentcvterm' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table environmentcvterm drop foreign key FK_rrwb96jjqgtg077yv8pbim3jj | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.environmentcvterm' doesn't exist | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_hc4vrafs0ws7ugdkp0n6u3xdo | Error 2015-05-26 11:42:17,188 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_kfq8esgv3in8wxml2x36f2md | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature drop foreign key FK_7huaou2aj3ac3oa49c1e0nhlm | Error 2015-05-26 11:42:17,189 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_dbxref drop foreign key FK_n6n7lheb1qkmlde8u6gvvjxne | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_dbxref' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_dbxref drop foreign key FK_1mrfkxbb3n7fhjxcrkxappdn8 | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_dbxref' doesn't exist | Error 2015-05-26 11:42:17,190 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_event drop foreign key FK_35nc3xd2axx6fwyap4bjkt09u | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_event' doesn't exist | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_feature_phenotypes drop foreign key FK_aqr7eiyx6puju6elciwubbwmo | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_feature_phenotypes' doesn't exist | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_feature_phenotypes drop foreign key FK_dy5g29heir5ic3d36okyuihho | Error 2015-05-26 11:42:17,191 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_feature_phenotypes' doesn't exist | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_hak8r429shmpho06rbyvwnmt0 | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_b42u9iq4kuqe5ay544do81n32 | Error 2015-05-26 11:42:17,192 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,193 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_cm3gqs38fa2lpllgoum8n4kgn | Error 2015-05-26 11:42:17,193 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,206 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_genotype drop foreign key FK_736wxgjs6pip5212ash5i68p | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_genotype' doesn't exist | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_grails_user drop foreign key FK_lflwbgxduee8ljjwe5rfbdil2 | Error 2015-05-26 11:42:17,207 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_grails_user' doesn't exist | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_grails_user drop foreign key FK_4dgbhgiw0vb9hqy2k5fqg3neh | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_grails_user' doesn't exist | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location drop foreign key FK_qml7xp9f5uojcw7jwdxcb35le | Error 2015-05-26 11:42:17,208 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location' doesn't exist | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location drop foreign key FK_dhnrehn3tj85m2j9c0m4md3f4 | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location' doesn't exist | Error 2015-05-26 11:42:17,209 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location_publication drop foreign key FK_n4lr2f61atuxmm8cb90qtkojq | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location_publication' doesn't exist | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_location_publication drop foreign key FK_jquf8fftudekrwgx1e870jy43 | Error 2015-05-26 11:42:17,210 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_location_publication' doesn't exist | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property drop foreign key FK_jpvdxc57abfiridcr57x8130 | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property' doesn't exist | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property drop foreign key FK_36e638geg9tew42b1mp2ehff | Error 2015-05-26 11:42:17,211 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property' doesn't exist | Error 2015-05-26 11:42:17,212 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property_publication drop foreign key FK_j4dnb11fi9vcvrdjo5m352pyq | Error 2015-05-26 11:42:17,212 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_property_publication drop foreign key FK_86law9p6s1pbt02n3mltkcqwh | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_property_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_publication drop foreign key FK_580odgbjowisfshvk82rfjri2 | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_publication' doesn't exist | Error 2015-05-26 11:42:17,214 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_publication drop foreign key FK_qolh5l4blkx8vfmwcl7f3woan | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_publication' doesn't exist | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship drop foreign key FK_8jm56covt0m7m0m191bc5jseh | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship' doesn't exist | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship drop foreign key FK_72kmd92rdc6gne0nrh026o1j0 | Error 2015-05-26 11:42:17,215 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship' doesn't exist | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_feature_property drop foreign key FK_scm5rx2kuhgkhdfvskyo924cy | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_feature_property' doesn't exist | Error 2015-05-26 11:42:17,216 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_feature_property drop foreign key FK_ebgnfbogf1lwdxd8jc17511o7 | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_feature_property' doesn't exist | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_publication drop foreign key FK_4j4u29xis9bhr65slfaimgjye | Error 2015-05-26 11:42:17,217 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_publication' doesn't exist | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_relationship_publication drop foreign key FK_bdd324e5jb0lpuhs7biy2kacm | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_relationship_publication' doesn't exist | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_nf9qbuay984ixqd2k1425rnyo | Error 2015-05-26 11:42:17,218 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_82wsc3bv9i01t9851xv4xekis | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_ll4cqdh994s6x8n7vku1q7iwd | Error 2015-05-26 11:42:17,219 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table feature_synonym drop foreign key FK_gsol4u8wrfwbkh1qrx18i3u6 | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.feature_synonym' doesn't exist | Error 2015-05-26 11:42:17,220 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_cuwo3ernssd0t0wjceb7lmm11 | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_iy7bbt67s7jaemiajsrqalv5o | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,221 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm drop foreign key FK_q3wop7ii25dgiofnp2l3yj9v0 | Error 2015-05-26 11:42:17,222 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm' doesn't exist | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_dbxref drop foreign key FK_r9xhefcekikp1od79ectkb22b | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_dbxref' doesn't exist | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_dbxref drop foreign key FK_pniehpb3pk1rqe95ejk0od6vg | Error 2015-05-26 11:42:17,223 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_dbxref' doesn't exist | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_publication drop foreign key FK_g6l9cr99p5dhb0kvs9y0tjwnv | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_publication' doesn't exist | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table featurecvterm_publication drop foreign key FK_3a9j1mryggb0bcaguvkhw8hjm | Error 2015-05-26 11:42:17,224 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.featurecvterm_publication' doesn't exist | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table grails_user_roles drop foreign key FK_4mxkyj2itw9wyvcn6d8d4mta2 | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.grails_user_roles' doesn't exist | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table grails_user_roles drop foreign key FK_jsuq1rc9mb07tg4kubnqn8yw6 | Error 2015-05-26 11:42:17,225 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.grails_user_roles' doesn't exist | Error 2015-05-26 11:42:17,226 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_organism_property drop foreign key FK_f1e1d91q04mqaij1ep3s36ujl | Error 2015-05-26 11:42:17,226 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_organism_property' doesn't exist | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_organism_property drop foreign key FK_qyxdgqthtlgixvtdkkhc8g3pu | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_organism_property' doesn't exist | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organism_property drop foreign key FK_8jxbx51qysqlm07orah5xg45y | Error 2015-05-26 11:42:17,227 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organism_property' doesn't exist | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organism_property drop foreign key FK_3rtkicqpr3ca8dwivye3yajaa | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organism_property' doesn't exist | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organismdbxref drop foreign key FK_jbw15sttun6yrcrxchi0lwtam | Error 2015-05-26 11:42:17,228 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organism_property_organismdbxref drop foreign key FK_kaayriabr4k4b3aomk46dmc77 | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organism_property_organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organismdbxref drop foreign key FK_s3vk7onqrk0n4c86xnvqmm3ho | Error 2015-05-26 11:42:17,229 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,230 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table organismdbxref drop foreign key FK_l1jfi0wpnyooutd820p5gskr | Error 2015-05-26 11:42:17,230 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.organismdbxref' doesn't exist | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_4nvoxx3htem6jseb4rmu0aqfp | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_hycx5el5itt1lqidt532shkpj | Error 2015-05-26 11:42:17,231 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table permission drop foreign key FK_6p3mx8al2w4f7ltqiwf1j88fm | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.permission' doesn't exist | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_cwgh6naf9gackae2ei11v6p41 | Error 2015-05-26 11:42:17,232 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,233 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_phmfgylejydjqyrvo3imc97go | Error 2015-05-26 11:42:17,233 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,234 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_jh0fc3orduigl8s7ymentbtrs | Error 2015-05-26 11:42:17,234 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype drop foreign key FK_gb4wy9qesx6vnekxekm18k9xa | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype' doesn't exist | Error 2015-05-26 11:42:17,235 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_cvterm drop foreign key FK_9e2v7goj5w6nds5jo0x1va1nm | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_cvterm' doesn't exist | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_cvterm drop foreign key FK_aicsmj1kn20ikm14292g9r2j9 | Error 2015-05-26 11:42:17,236 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_cvterm' doesn't exist | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_t52r166gd8710vffy3aompe7d | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_bf1bstadamyw0gsarkb933l5b | Error 2015-05-26 11:42:17,237 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_1kkkx1uxs6li0r72qhvke6o77 | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,238 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_description drop foreign key FK_8pbyj05khavdl5a648c7pmcil | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_description' doesn't exist | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_q6jvhi3l7ty0m9tpbn09d8pxj | Error 2015-05-26 11:42:17,239 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_8rbhsxxdf669tyed8jrr747hv | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_gskh1e7b6qa2du48ayu49lr3s | Error 2015-05-26 11:42:17,240 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_hffc43aavltp8t5dtwactux5f | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table phenotype_statement drop foreign key FK_tk1pgifvuhurefn0y3myfyyt4 | Error 2015-05-26 11:42:17,241 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.phenotype_statement' doesn't exist | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_ro87rogww8hoobbwya2nn16xk | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,242 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_42b0lk4rcfjcagw84jugd1sgj | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table preference drop foreign key FK_i94ksmdxi88hcqnuycebgkdvs | Error 2015-05-26 11:42:17,243 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.preference' doesn't exist | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication drop foreign key FK_h3g8f3q2krcnwmq2nasbanlay | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication' doesn't exist | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_author drop foreign key FK_9eou8yof43krmrsdvfhfuisln | Error 2015-05-26 11:42:17,244 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_author' doesn't exist | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_97qgrmdull1avkfqpfq1mc1wt | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_euu6xx78omdvver8lij1ys2oq | Error 2015-05-26 11:42:17,245 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,246 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publication_relationship drop foreign key FK_q6hf14oiq9pomkjrhtndonmeh | Error 2015-05-26 11:42:17,246 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publication_relationship' doesn't exist | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publicationdbxref drop foreign key FK_oh81hma8qx88fhvcmfugx836b | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publicationdbxref' doesn't exist | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table publicationdbxref drop foreign key FK_pgoyqd75q47r6ycwowcppbhk6 | Error 2015-05-26 11:42:17,247 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.publicationdbxref' doesn't exist | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table role_permissions drop foreign key FK_d4atqq8ege1sij0316vh2mxfu | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.role_permissions' doesn't exist | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table sequence drop foreign key FK_rux0954nxr4lwvj2qgyjibua7 | Error 2015-05-26 11:42:17,248 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.sequence' doesn't exist | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table sequence_chunk drop foreign key FK_4tsu0cp2dh2avbxifp1h1c9vd | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.sequence_chunk' doesn't exist | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table synonym drop foreign key FK_4ylco1irefvydmsnedglqqdfu | Error 2015-05-26 11:42:17,249 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.synonym' doesn't exist | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table user_group_users drop foreign key FK_9jib0g899h0gy3dypo7datfm9 | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.user_group_users' doesn't exist | Error 2015-05-26 11:42:17,250 [main] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table user_group_users drop foreign key FK_jppito7humh6e3v5mjjtutd7h | Error 2015-05-26 11:42:17,251 [main] ERROR hbm2ddl.SchemaExport - Table 'apollotest.user_group_users' doesn't exist organism null | Running 8 integration tests... 11 of 11 | Error 2015-05-26 11:43:14,728 [main] ERROR spi.SqlExceptionHelper - Data truncation: Data too long for column 'current' at row 1 | Failure: adding an exon to an existing transcript(org.bbop.apollo.RequestHandlingServiceIntegrationSpec) | org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; SQL [n/a]; Data truncation: Data too long for column 'current' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'current' at row 1 at org.bbop.apollo.FeatureEventService.$ttaddNewFeatureEvent(FeatureEventService.groovy:66) at org.bbop.apollo.RequestHandlingService.$ttaddExon(RequestHandlingService.groovy:636) at org.bbop.apollo.RequestHandlingServiceIntegrationSpec.adding an exon to an existing transcript(RequestHandlingServiceIntegrationSpec.groovy:334) Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'current' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2366) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2350)
I think that it is an mysql error but i`m not sure
my system is:
Linux pathos 3.16.0-31-generic #43-Ubuntu SMP Tue Mar 10 17:37:36 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
mysql Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.3
java version "1.8.0_45" Java(TM) SE Runtime Environment (build 1.8.0_45-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)
thanks Luigi