You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by "Liu, Yuan (Yuan)" <yu...@esgyn.cn> on 2017/04/17 04:17:42 UTC
答复: 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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
发件人: Sandhya Sundaresan [mailto:sandhya.sundaresan@esgyn.com]
发送时间: 2017年4月17日 12:13
收件人: 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.liu@esgyn.cn]
Sent: Sunday, April 16, 2017 7:39 PM
To: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
答复: How to deal with SQL 10007
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Thank you very much for your solution, Sandhya, I will try it out.
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
发件人: Sandhya Sundaresan [mailto:sandhya.sundaresan@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.liu@esgyn.cn]
Sent: Sunday, April 16, 2017 9:18 PM
To: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
发件人: Sandhya Sundaresan [mailto:sandhya.sundaresan@esgyn.com]
发送时间: 2017年4月17日 12:13
收件人: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn]
Sent: Sunday, April 16, 2017 7:39 PM
To: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
RE: How to deal with SQL 10007
Posted by Sandhya Sundaresan <sa...@esgyn.com>.
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
o mkdir -p <dir>/stfs_overflow
· Make sure the new directories are owned by the trafodion user for read/write access
o chown trafodion:<group> <dir>/stfs_overflow
· Edit $MY_SQROOT/etc/ms.env on each node
o STFS_HDD_LOCATION=<dir1>/stfs_overflow:<dir2>/stfs_overflow:<dir3>/stfs_overflow
· Stop and start Trafodion.
Sandhya
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Sunday, April 16, 2017 9:18 PM
To: 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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
发件人: Sandhya Sundaresan [mailto:sandhya.sundaresan@esgyn.com]
发送时间: 2017年4月17日 12:13
收件人: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn]
Sent: Sunday, April 16, 2017 7:39 PM
To: user@trafodion.incubator.apache.org<ma...@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.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540