Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Mango System starts up and operates, but now when I log into the editor the mango system comes to a screeching halt? Any thoughts?
-
I have been out of the office for several weeks, and am just getting back to this. I am still unable to get into the developer without the mango system freezing up. Here is a screen shot of when I tried to go into the reports at 12:08 today. The hard drive seems to be searching constantly never stops.![alt text](
image url)
-
Hi srennhack,
Of the steps I have offered, which have you done? Did you purge your events tables?
Do you still have out of memory errors in your Mango/logs/ma.log file?
-
The only step not tried is starting Mango in the safe mode. I did not see out of memory errors today.
-
Ah. I asked because there events didn't load in your header in the screenshot, which would lead me to believe you still have a very large events table (or you recently purged and have no events in the events table). The exception from the Meta point is unrelated to the performance issue beyond its being an event. How large is your events table currently?
You can try purging your audit table too, running
DELETE FROM audit;
either in the H2 web console or in the SQL console page.There can be a caching issue on the excel reports page sometimes where the first time you load the page it doesn't pull up the list of templates. If you refresh this almost always brings up the list.
If the hard drive is going crazy, is it with reads or writes? If you have tons of meta points running often doing .past(MINUTE, 5) type operations, that would be a heavy read load. There are solutions to convert that over to using the cache. If you have lots of point values waiting to be written (check this on your /internal/status.shtm page), you can adjust the NoSQL settings to delay more for small batches and increase the small batch size.
-
Also, you can get the actual text of the stack traces you wish to post from the Mango/logs/ma.log or Mango/bin/logs/ma.log file. it's a lot better than screenshots of command prompts.
-
@phildunlap
I guess I am just confused that the Mango data collection and screens that were created prior to Nov. of last year all work perfectly fine upon a restart of the system. And it is only when I try to go into the developer that everything stops working? I did create some reports back in Oct of last year that read string files from the AB PLC, and they are checking those points every 30 seconds. and the report is setup for a past 24hr period. and that all worked fine also up until the point that the Java system was upgraded, which appears to be the point where the problems accessing the Mango development screens started to occur. What can I give/send you that might help in resolving this? I don't feel that I am explaining things correctly, and not being a computer programmer, I am mostly lost with what you are telling me. as I don't know how to or where to access some of the files and setups you have described. I apologize for my lack of knowledge in this area. -
No worries. It is a lot easier to provide support if you are able to get text from your ma.log file. What are you unaware of how to access? You are navigating around the Mango/ directory in a Windows explorer, correct? Your ma.log file is the place to start. Any path I provide that begins with Mango/ is in your Mango's root directory, which it'll say it's using as MA_HOME during startup.
I don't know what you mean "the developer" as a location. It's best to take your nouns from the program, as then we're on the same page.
I would guess the upgrade to Java was incidental. If you were using a JDK, and are still, that's probably not the problem.
-
@phildunlap
Log file attached
[0_1516188987376_ma.log.5.5](Uploading 100%)
At about 8:04 yesterday i tried to log into the mango system to try and edit, but at that point everything stopped, and I had to restart the system. -
The log didn't upload. You need to wait for it to turn into a link in the preview section. I have the greatest luck with the "upload file" button above the composition window.
-
[0_1516276596205_ma.log.5](Uploading 100%)
When I try uploading, I get the following error:
-
@srennhack said in Mango System starts up and operates, but now when I log into the editor the mango system comes to a screeching halt? Any thoughts?:
[0_1516276596205_ma.log.5](Uploading 100%)
When I try uploading, I get the following error:
Is there anything else I can do? Is there an e-mail that I can send the file to?
I really need to get this issue resolved, -
Hi srennhack,
We discourage posting personal information. support@infiniteautomation.com is our support email address. I retained your contact information.
-
Resolution was found in purging the events and userEvents tables through the Mango/bin/h2-web-console.sh script (but may have been possible through the Mango interface on the SQL console page, or just purging events in the purge settings). Then, the database was backed up and restored, which reduced its on disk size from 3.8GB to about 26MB