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 ] 然后再试一次.

This issue is fixed in the EMM 1.1.0 GA latest pack. Please get all the patches for the product/build the product from the latest source [ https://github.com/wso2/product-emm ] and try again.

不幸的是，这对我不起作用.我不确定我到底做错了什么，所以我将列出我为修复它所做的工作:

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:

1. 从 http://wso2.com 下载了 EMM 1.1.0 zip/products/enterprise-mobility-manager/.

从 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 仪表板或发布者.我只能访问 Carbon 管理器.不过，我能够使补丁 7、8、11 和 12 正常工作 - 行为没有改变.

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:

1. 设置 EMM 的新副本后，我以管理员身份登录 EMM 仪表板，设置用户帐户，然后通过 Publisher 上传应用.

1. 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.

将设备注册到我设置的用户帐户.在这种情况下，运行 Android 4.2.2 的 Android 设备.

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屋！