tracker issue : CF-3750467

Problem Description:  When attempting to index a persistent entity with joined properties with greater than 10,000 records, the function ormIndex('EntityName') hangs the server, even if there is only one property in the entity which is being indexed

Steps to Reproduce:

1) Create persistent CFC associated with table of greater than 10,000 records with join relationships to other components.

2) set all properties as indexable=false except for one

3) Run ormIndex('EntityName') on component

Actual Result:
Server response with java.lang.OutOfMemoryError: GC overhead limit exceeded

Expected Result:
Index of persistent entity

Any Workarounds:

Looping the records in small chunks will succeed, however when attemping to loop the full collection, the server crashes with:  pipe error: Too many open files in system errors

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3750467

External Customer Info:
External Company:  
External Customer Name: JJClausen
External Customer Email:  
External Test Config: My Hardware and Environment details:



OSX:

OSX v 10.9.1

Proc: 2.9 GHz Intel Core i7

Memory: 8GB 



PostgreSQL:

9.2.4 on x86_64-apple-darwin-12.5.0



CF Server:

Server Details

Server Product	 ColdFusion

Version	 ColdFusion 10,287689

Edition	 Developer 

Operating System	 Mac OS X 

OS Version	 10.9.1 

Update Level	 /Applications/ColdFusion10/cfusion/lib/updates/chf10000013.jar 

Adobe Driver Version	 4.1 (Build 0001) 





JVM Details

Java Version	 1.7.0_45 

Java Vendor	 Oracle Corporation 

Java Vendor URL	http://java.oracle.com/ 

Java Home	 /Library/Java/JavaVirtualMachines/jdk1.7.0_45.jdk/Contents/Home/jre 

Java File Encoding	 UTF8 

Java Default Locale	 en_US 

File Separator	 / 

Path Separator	 : 

Line Separator	 Chr(10) 

User Name	 jonclausen 

User Home	 /Users/username 

User Dir	 /Applications/ColdFusion10/cfusion/bin 

Java VM Specification Version	 1.7 

Java VM Specification Vendor	 Oracle Corporation 

Java VM Specification Name	 Java Virtual Machine Specification 

Java VM Version	 24.45-b08 

Java VM Vendor	 Oracle Corporation 

Java VM Name	 Java HotSpot(TM) 64-Bit Server VM 

Java Specification Version	 1.7 

Java Specification Vendor	 Oracle Corporation 

Java Specification Name	 Java Platform API Specification 

Java Class Version	 51.0



JVM Config:

Min Heap: 512MB

Max Heap: 1024MB

JVM Args:

-XX:MaxPermSize=1024m -XX:+UseParallelGC -XX:+DisableExplicitGC -Xbatch -Dcoldfusion.home={application.home} -Dcoldfusion.rootDir={application.home} -Dcoldfusion.libPath={application.home}/lib -Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true -Dcoldfusion.jsafe.defaultalgo=FIPS186Random

Attachments:

Comments: