Thank you very much for your solution, Sandhya, I will try it out.
Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540 发件人: Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] 发送时间: 2017年4月17日 12:29 收件人: user@trafodion.incubator.apache.org 主题: RE: How to deal with SQL 10007 You need to configure more space for the scratch file overflow. The upsert operation needs to perform a sort that is pretty large so it is overflowing to temp space but there isn’t enough space on the /tmp disk. In Trafodion 2.1 we have support for a CQD which makes it easy to override the env settings. Since you’re based on 2.0 , what you can do is configure more space for scratch space by changing the envvar setting but you’ll need to restart trafodion. Either you can assign one large disk instead of /tmp or else specifiy a list of disks so the sort has more space to overflow suring execution. These changes need to be made on everynode and permissions set correctly. Steps : * Create directories under every mounted disk on every single node using a command similar to this * mkdir -p <dir>/stfs_overflow * Make sure the new directories are owned by the trafodion user for read/write access * chown trafodion:<group> <dir>/stfs_overflow * Edit $MY_SQROOT/etc/ms.env on each node * STFS_HDD_LOCATION=<dir1>/stfs_overflow:<dir2>/stfs_overflow:<dir3>/stfs_overflow * Stop and start Trafodion. Sandhya From: Liu, Yuan (Yuan) [mailto:yuan....@esgyn.cn] Sent: Sunday, April 16, 2017 9:18 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: 答复: How to deal with SQL 10007 Hi Sandhya, Thanks for your response, it is based on Trafodion 2.0, so why caused this issue and is there any way to solve this? Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540 发件人: Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] 发送时间: 2017年4月17日 12:13 收件人: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> 主题: RE: How to deal with SQL 10007 Hi, Error 28 means it has run out of space on /tmp. Which version of Trafodion are you using ? Thanks Sandhya From: Liu, Yuan (Yuan) [mailto:yuan....@esgyn.cn] Sent: Sunday, April 16, 2017 7:39 PM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: How to deal with SQL 10007 Hi trafodioners, When I executed “upsert using load into …”, I encountered the SQL 10007 error as below, *** ERROR[10007] Sort failed while writing to a scratch file with error 28. Details: SQScratchFile::executeVectorIO [2017-04-15 10:52:34] My current STFS_HDD_LOCATION is $MY_SQROOT/tmp set in ms.env. Can anyone help on how to solve this issue? Best regards, Yuan Email: yuan....@esgyn.cn<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540
