16:29:59,546 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into DOCUMENT (workflow_state, last_modified_by, last_modified_date, timer_step, timer_date, timer_processed, chainkey, form, creator, creation_date, version_number, published, latest) values ('pendingApproval','admin',1192109399546,'',0,0,'D6CF6357D867854DD9ED61B7B64DB189','article','admin',1192109399546,1,1,1);  (0 milliseconds)
16:29:59,546 [http-8080-Processor18] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement bee7ff automatically
16:29:59,546 [http-8080-Processor17] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement e58279 automatically
16:29:59,546 [http-8080-Processor25] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement 1f8c72d automatically
16:29:59,546 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into DOCUMENT (workflow_state, last_modified_by, last_modified_date, timer_step, timer_date, timer_processed, chainkey, form, creator, creation_date, version_number, published, latest) values ('pendingApproval','admin',1192109399546,'',0,0,'5D68B39E911A25F074CFEA8D9AD11CD1','article','admin',1192109399546,1,1,1);  (0 milliseconds)
16:29:59,546 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] select docid from DOCUMENT where chainkey='D6CF6357D867854DD9ED61B7B64DB189' and version_number = 1;  (0 milliseconds)
16:29:59,546 [http-8080-Processor18] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] #4 - autoCommit reset back to true
16:29:59,546 [http-8080-Processor17] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement 1eadf00 automatically
16:29:59,546 [http-8080-Processor25] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement 1dc6fdb automatically
16:29:59,546 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] select docid from DOCUMENT where chainkey='5D68B39E911A25F074CFEA8D9AD11CD1' and version_number = 1;  (0 milliseconds)
16:29:59,546 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into  RECIPIENT  values (9485,'Joe');  (0 milliseconds)
16:29:59,546 [http-8080-Processor17] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement 1796ae6 automatically
16:29:59,562 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] delete from FIELD where docid = 9485 and field_name = 'sectionA.firstEditDate'; delete from FIELD where docid = 9485 and field_name = 'sectionA.writeACL'; delete from FIELD where docid = 9485 and field_name = 'sectionB.readACL'; delete from FIELD where docid = 9485 and field_name = 'sectionB.writeACL'; delete from FIELD where docid = 9485 and field_name = 'sectionA.readACL';  (0 milliseconds)
16:29:59,562 [http-8080-Processor17] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] #5 - autoCommit reset back to true
16:29:59,562 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into  RECIPIENT  values (9486,'Joe');  (0 milliseconds)
16:29:59,562 [http-8080-Processor25] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement 220aac automatically
16:29:59,562 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0]  (0 milliseconds)
16:29:59,578 [http-8080-Processor25] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] Closing statement a6e68a automatically
16:29:59,578 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] delete from FIELD where docid = 9486 and field_name = 'sectionA.firstEditDate'; delete from FIELD where docid = 9486 and field_name = 'sectionA.writeACL'; delete from FIELD where docid = 9486 and field_name = 'sectionB.readACL'; delete from FIELD where docid = 9486 and field_name = 'sectionB.writeACL'; delete from FIELD where docid = 9486 and field_name = 'sectionA.readACL';  (0 milliseconds)
16:29:59,578 [http-8080-Processor25] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] #6 - autoCommit reset back to true
16:29:59,578 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0]  (0 milliseconds)
16:29:59,593 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('B8879D619924B9C8EC9AB980CB01D2EE|1',0.0,0,NULL,1,9485,'sectionA.publishType',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Title (D6CF6357D867854DD9ED61B7B64DB189|1)',0.0,0,NULL,1,9485,'title',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9485,'sectionA.approver',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('en',0.0,0,NULL,1,9485,'contentLanguage',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('11/10/2007',0.0,1192109399500,NULL,3,9485,'sectionA.firstEditDate',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('nobody',0.0,0,NULL,1,9485,'sectionA.writeACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9485,'sectionB.readACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9485,'sectionB.writeACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('admin',0.0,0,NULL,1,9485,'sectionA.readACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9485,'sectionA.readACL',1);  (15 milliseconds)
16:29:59,593 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0]  /*wow... clobs...*/insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('JServ (a project that has since been replaced by the Apache Tomcat project). We redesigned JMeter to enhance the GUI and to add functional-testing capabilities.  The Future   We hope to see JMeter's capabilities rapidly expand as developers take advantage',0.0,0,StringReader,4,9485,'summary',0);  /*wow... clobs...*/insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('is returning the results you expect. For maximum flexibility, JMeter lets you create these assertions using regular expressions.   But please note that JMeter is not a browser.   History   Stefano Mazzocchi of the Apache Software Foundation was the origin',0.0,0,StringReader,4,9485,'sectionA.text',0);  (0 milliseconds)
16:29:59,593 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] select * from DOCUMENT where chainkey='D6CF6357D867854DD9ED61B7B64DB189' and version_number = 1 ;  (0 milliseconds)
16:29:59,593 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] select recipient from RECIPIENT where docid = 9485;  (0 milliseconds)
16:29:59,609 [http-8080-Processor13] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] select * from FIELD where docid = 9485 and (0=0);  (16 milliseconds)
16:29:59,671 [http-8080-Processor19] DEBUG [org.logicalcobwebs.proxool./autoforms_master_pool_0] insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('6A1C1A580595B4F1957AB9FCFADF6CF7|1',0.0,0,NULL,1,9486,'sectionA.publishType',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Title (5D68B39E911A25F074CFEA8D9AD11CD1|1)',0.0,0,NULL,1,9486,'title',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9486,'sectionA.approver',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('en',0.0,0,NULL,1,9486,'contentLanguage',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('11/10/2007',0.0,1192109399515,NULL,3,9486,'sectionA.firstEditDate',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('nobody',0.0,0,NULL,1,9486,'sectionA.writeACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9486,'sectionB.readACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9486,'sectionB.writeACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('admin',0.0,0,NULL,1,9486,'sectionA.readACL',0); insert into FIELD (field_string, field_numeric, field_date, field_text, field_type, docid, field_name, field_position) values ('Joe',0.0,0,NULL,1,9486,'sectionA.readACL',1);  (93 milliseconds, threw a java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`autoforms/field`, CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE))
16:29:59,671 [http-8080-Processor19] ERROR [com.elementn.autoforms.servlets.ServletUtils] Exception for request[org.apache.catalina.connector.RequestFacade@4218e8]
com.elementn.autoforms.AutoformsException: Error processing workflow on form article: Cannot add or update a child row: a foreign key constraint fails (`autoforms/field`, CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE)
	at com.elementn.autoforms.forms.FormHandler.save(FormHandler.java:390)
	at com.elementn.autoforms.servlets.AutoformsRequestProcessor.process(AutoformsRequestProcessor.java:438)
	at com.elementn.autoforms.servlets.Action.service(Action.java:54)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:595)
Caused by: com.elementn.autoforms.AutoformsException: Cannot add or update a child row: a foreign key constraint fails (`autoforms/field`, CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE)
	at com.elementn.autoforms.model.GenericDataProvider.create(GenericDataProvider.java:245)
	at com.elementn.autoforms.model.DataProvider.createDocument(DataProvider.java:139)
	at com.elementn.autoforms.forms.workflow.Workflow.executeEvent(Workflow.java:1177)
	at com.elementn.autoforms.forms.workflow.Workflow.executeStep(Workflow.java:1048)
	at com.elementn.autoforms.forms.workflow.Workflow.run(Workflow.java:941)
	at com.elementn.autoforms.forms.workflow.Workflow.process(Workflow.java:793)
	at com.elementn.autoforms.forms.FormHandler.save(FormHandler.java:387)
	... 17 more
Caused by: com.elementn.autoforms.AutoformsException: Cannot add or update a child row: a foreign key constraint fails (`autoforms/field`, CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE)
	at com.elementn.autoforms.model.GenericDataProvider.saveDocumentFields(GenericDataProvider.java:1068)
	at com.elementn.autoforms.model.GenericDataProvider.create(GenericDataProvider.java:232)
	... 23 more
Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`autoforms/field`, CONSTRAINT `field_ibfk_1` FOREIGN KEY (`docid`) REFERENCES `document` (`docid`) ON DELETE CASCADE)
	at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:665)
	at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	at $java.sql.PreparedStatement$$EnhancerByProxool$$b6e30c41.executeBatch(<generated>)
	at com.elementn.autoforms.model.GenericDataProvider.saveDocumentFields(GenericDataProvider.java:1055)
	... 24 more