mysql error:ERROR hbm2ddl.SchemaUpdate - Row size too large when pushing Grails app to Cloud Foundry -

-

i able deploy cloud foundry last time , new domain classes getting introduced, need update it. updated successfully, 1 table not created, why tried delete app , push again see error in detail , got:

error hbm2ddl.schemaupdate  - unsuccessful: create table case_file (id bigint not null auto_increment, version bigint not null, case_type varchar(255) not null, category varchar(255) not null, client_id bigint not null, date_created datetime not null, class varchar(255) not null, has_criminal_record bit, house_size decimal(19,2), number_of_children integer, agreement varchar(255), brief_evaluation varchar(4000), comments varchar(4000), court_order varchar(255), date_from datetime, date_of_birth datetime, date_of_report datetime, date_signed_authorized_person datetime, date_signed_revisor datetime, date_to datetime, demand_number varchar(255), first_name varchar(255), has_court_order bit, has_intervention_plan bit, has_voluntary_measures bit, interventions_measure_and_resources varchar(4000), last_name varchar(255), other_documents varchar(255), permanent_code varchar(255), proposed_orientation varchar(4000), results_obtained varchar(4000), signature_of_authorized_person longblob, signature_of_director_of_social_services longblob, signature_of_revisor longblob, situation_of_child varchar(4000), voluntary varchar(255), primary key (id)) engine=innodb 2012-06-10 15:17:02,466 [main] error hbm2ddl.schemaupdate  - row size large. maximum row size used table type, not counting blobs, 65535. have change columns text or blobs 2012-06-10 15:17:02,501 [main] error hbm2ddl.schemaupdate  - unsuccessful: alter table case_file add index fk27f9b12b94d36a39 (client_id), add constraint fk27f9b12b94d36a39 foreign key (client_id) references client (id) 2012-06-10 15:17:02,501 [main] error hbm2ddl.schemaupdate  - table 'd838abcc25b974c87a204aa924e607694.case_file' doesn't exist 2012-06-10 15:17:13,997 [main] error util.jdbcexceptionreporter  - table 'd838abcc25b974c87a204aa924e607694.case_file' doesn't exist stopping tomcat because context stopped.

just give little background domain, contain 3 longblobs (for pictures) , i'm thinking that might cause "row size large" problem. way, i'm using grails 2.0.0. how resolve this?

the app works fine locally, did not throw error, that's why shocked when saw it.

you can read hard limit in mysql on their website. basically, have many 256 , 4000 character columns have gone on 65,535 limit. best course of action switch varchar(4000) columns text:

class mydomain {     string description      static mapping = {         description type: "text"     } }

be aware though hibernate may not able migrate existing data new column type. test first! , sure cf database before updating it.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more