Sorry, just for clarification ... +) Did you created a new database using InnoDB?! +) Are the tables used by IDBroker also InnoDB tables?! +) Did your tests run successfully up to 91900 records?! +) After that you got an SQL insert with a NULL 'id' which is your PK?! +) This would indicate that IDBroker doesn't create an 'id' for 91901 record, wouldn't it?! +) Which mySQL version are you currently using?! +) If the problem persists is it possible to create a barebone test case to reproduce the error?!
Cheers, Siegfried Goeschl -----Original Message----- From: Bogdan Vatkov [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:09 PM To: Apache Torque Users List Subject: Re: IDBroker broken ? Hi Siegfried, You may be right ...i have used tableType = MyISAM I have set the tableType to InnoDB: InnoDB tables -- Stable (in 3.23 from 3.23.49) The InnoDB transactional storage engine has been declared stable in the MySQL 3.23 tree, starting from version 3.23.49. InnoDB is being used in large, heavy-load production systems. And now the error is different: (after the error SELECT count(*) FROM `user` gives 91900 records) java.sql.SQLException: General error, message from server: "Column 'id' cannot be null" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945) at com.mysql.jdbc.Connection.execSQL(Connection.java:1844) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488) at com.workingdogs.village.Record.saveWithInsert(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:899) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742) at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:242) at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:606) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1372) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1336) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1316) at edu.tu.fksu.WebComponents.UserManagement.BaseUserEdit.actualizeCustom(BaseUs erEdit.java:75) at edu.tu.fksu.Weblication.Actualizable.actualize(Actualizable.java:70) at org.apache.jsp.User_edit_jsp._jspService(User_edit_jsp.java:79) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch er.java:575) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher .java:498) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 22) at org.apache.jsp.index_jsp._jspService(index_jsp.java:141) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:619) at java.lang.Thread.run(Thread.java:536) rethrown as org.apache.torque.TorqueException: General error, message from server: "Column 'id' cannot be null" at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742) at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:242) at edu.tu.fksu.BusinessObjects.BaseUserPeer.doInsert(BaseUserPeer.java:606) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1372) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1336) at edu.tu.fksu.BusinessObjects.BaseUser.save(BaseUser.java:1316) at edu.tu.fksu.WebComponents.UserManagement.BaseUserEdit.actualizeCustom(BaseUs erEdit.java:75) at edu.tu.fksu.Weblication.Actualizable.actualize(Actualizable.java:70) at org.apache.jsp.User_edit_jsp._jspService(User_edit_jsp.java:79) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch er.java:575) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher .java:498) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:8 22) at org.apache.jsp.index_jsp._jspService(index_jsp.java:141) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:392) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:619) at java.lang.Thread.run(Thread.java:536) Caused by: java.sql.SQLException: General error, message from server: "Column 'id' cannot be null" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945) at com.mysql.jdbc.Connection.execSQL(Connection.java:1844) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488) at com.workingdogs.village.Record.saveWithInsert(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:899) ... 55 more With best regards, Bogdan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
