WSo2 EMM - 应用程序管理数据库错误 [英] WSo2 EMM - App Management Database Bug
问题描述
运行WSo2 EMM 1.1.0，除了一个大问题，一切都一直很好。
Running WSo2 EMM 1.1.0, everything has been working just fine except for one big issue.
从我第一次点击应用程序管理选项卡时，只要服务器正在运行，即使完全没有更改，WSO2EMM_DB.h2.db文件也会开始稳定增长。最终，它变得如此之大，点击该选项卡上的应用程序需要一个可笑的长时间加载使用应用程序的设备列表。我们说5分钟以上，它变得完全不可用。我已检查错误日志，并发现每次都没有错误。
From the moment I first click on an app in the App Management tab, the WSO2EMM_DB.h2.db file starts to steadily grow as long as the server is running, even with absolutely no changes. Eventually, it gets so big that clicking an app on that tab takes a ridiculously long time to load the list of devices using the app. We're talking 5+ minutes, it becomes completely unusable. I have checked the error logs and found no errors at all, every time.
重新启动服务器不会纠正这个问题。即使我在应用程序管理选项卡上单击一个应用程序一次，而不再重复，数据库文件将继续增长。即使重新启动服务器，也没有登录EMM页面，它将继续增长。
Restarting the server does nothing to correct the issue. Even if I click an app on the App Management tab once, and never again, the database file will continue to grow. Even restarting the server and not logging into the EMM page, it will continue to grow.
我发现的唯一的东西，可能有助于保持备份副本的数据库文件，并在当前文件过大时覆盖当前文件。显然，这不是一个解决方案，因为我需要创建一个新的备份文件每次在服务器上有一个变化，最终数据库文件将变得太大。
The only thing I've found so far that can possibly help is keeping backup copies of the database file and overwriting the current file when it gets too big. Obviously that's not a solution, as I'd need to create a new backup file every time there's a change on the server, and eventually the database file would grow too big from that too.
H2数据库也不是一个问题。不仅我尝试了新鲜的几次，并有相同的行为，但这里是我可以找到关于这个问题的唯一信息，他们有问题，不管是否在H2或MySQL。
It's not an issue with the H2 database either. Not only have I tried starting over fresh several times and have had the same behavior, but here is the only info I could find regarding this issue, and they were having the issue regardless of whether or not it was on H2 or MySQL.
我一直在试图找到一个解决方案一个多月没有成功。任何帮助将不胜感激。
I've been trying to find a solution for this for over a month with no success. Any help would be appreciated!
编辑：看起来这可能是 EMM-826 。很抱歉，到目前为止，这个错误报告似乎没有回应。
It looks like this might be the subject of EMM-826. Unfortunately there seems to be no response to that bug report so far.
编辑2： EMM-826 已关闭，并显示以下讯息：
EDIT 2: EMM-826 was closed with a message saying the following:
此问题已在EMM 1.1.0 GA最新包中修复。请获取产品的所有修补程序/从最新来源构建产品[ https://github.com/ wso2 / product-emm ]，然后重试。
不幸的是，这对我没有用。我不知道我到底做了什么错，所以我会列出我做了什么来尝试修复它：
Unfortunately, that did not work for me. I'm not sure what exactly I'm doing wrong, so I'll list the what I did to try to fix it:
从 https://github.com/wso2/product-emm 并将其中的文件粘贴到我的EMM_HOME目录中。
Downloaded the zip from https://github.com/wso2/product-emm and pasted the files from that into my EMM_HOME directory.
当这不工作，我搜索补丁，发现我只使用补丁1-6。在文档中我发现我可以下载补丁7-12 此处。补丁9和10由于某种原因没有正常工作;导致我无法访问EMM仪表板或发布商。我只能访问碳管理器。
When that didn't work, I searched for patches and found I was only using patches 1-6. In the documentation I found I could download patches 7-12 here. Patches 9 and 10 didn't work right for some reason; causing me not to be able to reach the EMM dashboard or publisher. I could only access the Carbon manager. I was able to make patches 7, 8, 11, and 12 work though - with no change in behavior.
以下是重现此问题的步骤：
Here are the steps I take to reproduce the issue:
-
在设置EMM的新副本后，我登录EMM信息中心作为管理员，设置用户帐户，然后通过发布商上传应用程序。
After setting a fresh copy of the EMM up, I log in to the EMM dashboard as Admin, set up a user account, and upload an app through the Publisher.
向我设置的用户帐户注册设备。
Register a device to the user account I set up. In this case, an Android device running Android 4.2.2.
从信息中心转到应用管理，然后点击我上传的应用。设备列表已加载，但从那时起，数据库文件开始增长，并且最终在几小时后变得如此之大，设备列表将永远不会加载。
From the dashboard, I go to App Management and click the app I uploaded. The list of devices loads, but from that point on, the database file starts growing and eventually, after several hours, becomes so large it the device list will never load.
请帮助！
推荐答案
问题似乎在EMM 2.0可在此处找到。
Issue appears to be resolved in EMM 2.0, which can be found here.
这篇关于WSo2 EMM - 应用程序管理数据库错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
