Create index on large tables fails with too many open files , FileNotFoundException. ------------------------------------------------------------------------------------
Key: DERBY-1661 URL: http://issues.apache.org/jira/browse/DERBY-1661 Project: Derby Issue Type: Bug Components: Store Affects Versions: 10.1.3.1, 10.1.3.0, 10.1.2.1, 10.1.1.0, 10.0.2.1, 10.0.2.0, 10.2.0.0 Reporter: Sunitha Kambhampati Assigned To: Sunitha Kambhampati Create index fails on a table with 18million rows during sort with too many open files error This error was first seen when running against a tpcc-like test. The test creates the tables, inserts data and then creates the indexes & adds constraints. Customer table has 18 million rows in this case. The below error is thrown on create index. ij> create index customer_last on customer(c_w_id, c_d_id, c_last); ERROR XSDF1: Exception during creation of file /home/cloudtst/SinglePerf/testruns/scripts/dbtpcc/tmp/T1128794811044.tmp for container ERROR XJ001: Java exception: '/home/cloudtst/SinglePerf/testruns/scripts/dbtpcc/tmp/T1128794811044.tmp (Too many open files): java.io.FileNotFoundException'. ij -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira