The SPJ is using Type 2 driver. Thanks, Ming
发件人: Venkat Muthuswamy [mailto:venkat.muthusw...@esgyn.com] 发送时间: 2016年6月8日 8:58 收件人: user@trafodion.incubator.apache.org 主题: RE: when a query will be cancelled? Hi Ming, Is your SPJ using type 2 jdbc or type 4 jdbc ? Venkat From: Liu, Ming (Ming) [mailto:ming....@esgyn.cn<mailto:ming....@esgyn.cn>] Sent: Tuesday, June 07, 2016 5:48 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: 答复: when a query will be cancelled? Hi, Hans, In my test SPJ, there is only one statement. It is one big UPDATE query, which will try to update 10M rows in a single thread, so it takes 1.5 hour. And we will try to narrow down the issue further by debugging. Want to check with community that if there are some special settings about 1 hour timeout. Ming 发件人: Hans Zeller [mailto:hans.zel...@esgyn.com] 发送时间: 2016年6月8日 0:42 收件人: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 主题: Re: when a query will be cancelled? Hi Ming, One thing to test would be where you get the timeout, whether it's in JDBC done in the SPJ or in the communication between the master executor and the UDR server. When you simulate it in your dev environment, do you also issue a single JDBC call that takes more than an hour? I have to admit I haven't tried it, but hopefully these instructions will work for SPJs as well: https://cwiki.apache.org/confluence/display/TRAFODION/Tutorial%3A+The+object-oriented+UDF+interface#Tutorial:Theobject-orientedUDFinterface-DebuggingUDFcode Hans On Tue, Jun 7, 2016 at 9:04 AM, Liu, Ming (Ming) <ming....@esgyn.cn<mailto:ming....@esgyn.cn>> wrote: Hi, We have a SPJ that perform some insert/select operations against a big table, and each time then the SPJ runs for 1 hour, the CALL statement will return -8007 error code, said it is cancelled. What can be possible reasons for a query to be cancelled? >>CALL QUERY1SPJ(); *** ERROR[8007] The operation has been canceled. *** ERROR[8811] Trying to close a statement that is either not in the open state or has not reached EOF. --- SQL operation failed with errors. I have a dev environment, and simulate a long running SPJ (Not same as the SPJ in real cluster as above), but I am not able to reproduce it. The test SPJ runs 1 hour 50 mins and finish correctly. So this seems not a common SPJ issue, but I am not sure. Any suggestions to debug this issue will be very appreciated. Thanks, Ming