Hi Dave, Sorry , Just now, I found it will still fail in some case in my env. I need update it.
Weiqing On Aug 9, 2017, at 23:14, Dave Birdsall <[email protected]> wrote: I will look at it this morning. Dave -----Original Message----- From: Weiqing Xu [mailto:[email protected]] Sent: Tuesday, August 8, 2017 6:44 PM To: [email protected] Subject: Re: Failure in JDBC tests on multiple pull requests I have create a PR for this issue. And the regression has beed passed twice. https://github.com/apache/incubator-trafodion/pull/1199 Does anyone can review and merge it? On Aug 8, 2017, at 09:41, Weiqing Xu <[email protected]> wrote: I'll check the JDBC regression test to make sure all unused statement will be closed. Best Regards, Weiqing On Tue, Aug 8, 2017 at 7:28 AM, Selva Govindarajan < [email protected]> wrote: This error message is thrown if you have 14 or more statements active in a single connection. Please reduce the number of open statements in the connection. It is possible that the statement is not explicitly closed in these tests. Selva -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Monday, August 7, 2017 3:09 PM To: [email protected] Subject: Failure in JDBC tests on multiple pull requests Hi, I was looking at the outstanding pull requests today. I noticed that some JDBC-related changes are getting the following failure: 2017-08-04 05:27:18 Batch Update Failed, See next exception for details 2017-08-04 05:27:18 Invalid Parameter Value: VARCHAR data longer than column length: 1 2017-08-04 05:27:30 Running testBatchInsertFKNotExist...... 2017-08-04 05:27:51 *** ERROR[2026] Server Process $ZSM0 has reached allowed depth for nowait operation from the process 0,15836. [2017-08-04 05:27:51] 2017-08-04 05:28:12 Running testBatchUpsertDuplicate...... 2017-08-04 05:28:27 Running testBatchInsertPkDuplicate...... 2017-08-04 05:28:41 Running testBatchUpdateOverflow...... 2017-08-04 05:28:48 Batch Update Failed, See next exception for details 2017-08-04 05:28:48 Invalid Parameter Value: VARCHAR data longer than column length: 1 2017-08-04 05:28:52 Running testBatchUpdatePkDuplicate...... 2017-08-04 05:28:59 Batch Update Failed, See next exception for details 2017-08-04 05:28:59 *** ERROR[8102] The operation is prevented by a unique constraint. [2017-08-04 05:28:59] 2017-08-04 05:29:06 Running testBatchInsertPositive...... 2017-08-04 05:29:14 Time consumption for batch inserting 10000 rows is 1867 milli seconds 2017-08-04 05:31:00 Tests run: 7, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 231.891 sec <<< FAILURE! - in BatchTest I don't see anything in the pull requests themselves that should cause this. Does anyone have an idea what might be doing it? I hate to get into a mode where we just repeatedly run tests until they pass without fixing the underlying problem. Thanks, Dave
