We're in final testing of an 8.1 application we are about to roll out.
Its basically a Lead tracking system.
Each lead has 7 possible ps_xxx references (owner of the lead, referrer, 2nd_owner, source, etc.) + a couple of om_xxx lists.
All has worked fine with lots of Leads loaded and Queries to search & browse worked fine.
Then, all we did for one set of data (about 200 out of 50,000) was fully attach/point to all the ps_xxx fields. (its not mandatory that all 4 be DEFINED).
1st thing we noticed was a significant delay in paging during Queries.
Screens that were almost instant to go to the next page, now took 1 second, for example... long enough to see the spinner flipping.
(Going to another tenant WITHOUT these references filled out was still fast. That was the only difference.)
Almost simultaneous with this was out of memory errors... which sent me on a search of the forum to no avail.
Getting these primary errors:
java.lang.OutOfMemoryError: Java heap space
Out of memory error encountered in the source OS
Code: Select all
java.lang.OutOfMemoryError: Java heap space
2018-06-19 14:13:49,714 org.apache.activemq.broker.region.Topic -Usage(Main:memory:topic://defaultoutputtopic:memory) percentUsage=222%, usage=149466463, limit=67108864, percentUsageMinDelta=1%;Parent:Usage(Main:memory) percentUsage=222%, usage=149466463, limit=67108864, percentUsageMinDelta=1%,
Usage Manager memory limit reached for topic://defaultoutputtopic.
Producers will be throttled to the rate at which messages are removed from this destination to prevent flooding it.
See http://activemq.apache.org/producer-flow-control.html for more info
2018-06-19 14:25:31,039 org.apache.activemq.broker.region.Queue -Usage Manager Memory Limit (67108864) reached on queue://defaultinputqueue.
Producers will be throttled to the rate at which messages are removed from this destination to prevent flooding it.
See http://activemq.apache.org/producer-flow-control.html for more info
Out of memory error encountered in the source OS
One thing I found was a critical bug in ActiveMQ 5.8, and per this thread https://www.awareim.com/forum/viewtopic ... emq#p44219
I downloaded 8.12.1, renamed the .jar file, copied it into place, relaunched Aware and then the query still hung with out of memory error, PLUS this:
Code: Select all
2018-06-19 14:56:07,384 org.apache.activemq.broker.TransportConnection.Transport -Transport Connection to: tcp://127.0.0.1:49812 failed: java.io.EOFException
So the system works fine on queries of the Lead table that dont involve as much system resources.
The more indepth queries (ie. have more joins to return simple reference values, like a Name to display in a pulldown) generate the Out of memory error and the user cannot do anything.
I'll keep researching.
Anyone else seen this?