Re: Got error 139 from storage engine

[Nitin jain]

Hi,

my row is really very big and now I tried by making all the column as a mediumtext still getting the same error. Even this behaviour persists if I switch the storage type to myISAM.

error log snippet

org.hibernate.exception.GenericJDBCException: could not insert: [com.ss.sm.vo.DirectorSummary]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2397)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:500)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:490)
at com.ss.sm.dao.DirectorSummaryDAO.insert(DirectorSummaryDAO.java:53)
at com.ss.sm.start.DSManager.loadDirectorSummary(DSManager.java:49)
at com.ss.sm.start.SavvySummaryManager.loadDirectorSummary(SavvySummaryManager.java:25)
at com.ss.sm.start.SavvySummaryManager.main(SavvySummaryManager.java:20)
Caused by: java.sql.SQLException: Got error 139 from storage engine
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1906)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1831)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1693)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:104)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1967)
... 17 more

Hibernate: insert into DIRECTOR_SUMMARY (SI_ID, SCHOOL_NAME, ADDRESS, CITY, STATE, ZIPCODE, PHONE, FAX, WEB_PAGE, DIRECTOR_NAME, DIRECTOR_EMAIL, GENERAL_APPR_LEARN, APPL_ACCEPTED, WAIT_LIST, TOTAL_ENROLL, TEACHER_STUDENT_RATIO, EXTENDED_DAY, ESTABLISHED, PERCENT_TEACHER_B_M_TC_CPR_FA, THIRD_YEAR, ELABORATION_THIRD_YEAR, KINDA_ELEM_SCHOOL_PROG, RELIG_AFFL, TEACHING_RELIG_CONC, TRANSPORTATION, DROP_OFF_PROC, DROP_OFF_TIME, LATE_PICKUP_POLI, NAYC_ACCRD, OTHER_ACCRD, OTHER_MEMBERSHIP, FACILITY_INCLUDE, SCHOOL_PHIL_MISSION, DAY_IN_LIFE, GENERAL_APPR_LEARN_COMMENT, CURR_TEACH_APPRO_ORAL_LANG, CURR_TEACH_APPRO_NR_POEM_SONG, CURR_TEACH_APPRO_STORY_BOOK_READ_TELL, CURR_TEACH_APPRO_LITERACY_SKILL, CURR_TEACH_APPRO_MATH_REASON_NUMBER, CURR_TEACH_APPRO_ORIE_TIME_SPACE, CURR_TEACH_APPRO_SCIE_REAS, CURR_TEACH_APPRO_MUSIC, CURR_TEACH_APPRO_VISU_ARTS, CURR_TEACH_APPRO_PHYS_ACTI, COND_ENVI_LANG_SKILLS, COND_ENVI_MATH_NUM_SENSE, COND_ENVI_TIME_SPAC_SKILL, COND_ENVI_SCIE_REAS_PHYS_WORLD, COND_ENVI_MUSIC, COND_ENVI_VISU_ARTS, COND_ENVI_PHYS_ACTI, DIRE_COMMENT_CURR, DIRE_COMM_HOME_SCHOOL_CONN, DIRE_COMMENT_DISCIPLINE, SITU_ANAL_DISC_INCI, HAND_FOOD_ALLE, CHILD_MEDICATIONS, DIRE_COMM_HEALTH_SNACKS, SCHOOL_YEAR, POTTY_TRAINING, INQUIRIES, DIRE_COMM_DIVERSITY, MORE_WAIT_LIST, PARENT_VISIT_TOURS, CHILD_INTER_PROC, FORM_CHILD_INTER_PROC, PARENT_INTER_PROC, DEADLINE_APPL, APPLICATION_FEE, ACCEPTANCE_CRIT, CRITERIA_BASED_ON, NOTE_ON_SELECTIVITY_CRIT, NOTIFICATION, DEPOSIT_REQD, FINANCIAL_AID, DIRE_COMM_FEED_SCH_TIPS, PERC_BACHELOR_DEG, PERC_MASTER_DEG, PERC_TEACH_CRED, PERC_CPR, PERC_FIRST_AID, FACILITY_INCLUDE_Q95, RAT_GUIDANCE_KINDERGARTEN, BEGINING_YEAR_SEP) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)