WSO2EMM - 应用管理永远不会返回/未安装安装应用程序的用户列表 [英] WSO2EMM - App Management never returns list of users with App installed/not installed

问题描述

我已经安装在Linux CentOS的6.5与一个单独的MySQL数据库服务器wso2emm 1.1.0版本。
一切似乎都很好地工作：
我可以创建用户，发送邀请，安装了android的代理和登记用户的设备。
我可以上传Android应用程序（我不是在目前的iOS测试），并让他们部署的设备。
当我连接到移动管理控制台出现这个问题：
当我上的Tab应用程序管理，并单击然后，在一个特定的应用程序，这发出以下查询到MySQL

I have wso2emm version 1.1.0 installed on a Linux CentOS 6.5 with a separate MySQL DB Server. Everything seems to work fine: I can create users, send invites, have android agent installed and users' devices enrolled. I can Upload Android App (I'm not testing iOS at the moment) and have them deployed on devices. The problem arise when I connect to "Mobile Management Console": WHen I click on the Tab "App Management" and then, on a particular App, this sends the following query to mysql

- 连接Id：47
- 用户：wso2carbon
- 主机：本地主机：34879
- DB：WSO2_EMM_DB
- 命令：查询
- 时间：208
- 国家：发送数据

-- Connection Id: 47 -- User: wso2carbon -- Host: localhost:34879 -- DB: WSO2_EMM_DB -- Command: Query -- Time: 208 -- State: Sending data

select out_table.id, out_table.user_id, out_table.device_id, out_table.received_data, devices.platform_id  from notifications as out_table , devices where out_table.`feature_code`= '502A' and out_table.`status`='R' and out_table.`tenant_id`=1 and out_table.`id` in (select MAX(inner_table.`id`) from notifications as inner_table where inner_table.`feature_code`= '502A' and inner_table.`status`='R' and out_table.device_id =inner_table.device_id)  and devices.id=out_table.device_id and devices.platform_id=1 and `received_data` not like '%renelco.hellorenelco%'

然后，没有任何结果被wso2emm（NOF名单角色或用户）和应用程序挂起欢迎。

Then, no result are received by wso2emm (list nof roles or users) and the app hangs.

这有什么错呢？

我试过几件事情像

• 杀死MySQL查询/会话


• 停止/重新启动MySQL的。


• 停止/重新启动服务器wso2emm


• 重新启动整个Linux服务器

但是，什么也解决了这一问题。看来，DB服务器上的东西挡住了查询，但
我找不到什么。任何帮助将是AP preciated ...
顺祝商祺

But nothing has fixed the problem. It seems that something on the db server is blocking the query but I can't find what. Any help would be appreciated ... Best Regards

推荐答案

这是不是一个永久性的解决方案，但直到有人想出了更好的东西它是一种变通方法，会做的工作。

This isn't a permanent solution, but it's a workaround that'll do the job until someone comes up with something better.

备份在定期EMM_HOME /存储库/数据库的数据库文件;然后出现问题时，关闭该服务并覆盖所做的最新的备份文件WSO2EMM_DB.h2.db

Back up the database files in EMM_HOME/repository/database on a regular basis; and then when the issue occurs, shut down the service and overwrite the WSO2EMM_DB.h2.db file with the latest backup made.

东西是导致WSO2EMM_DB.h2.db文件，以获得过度膨胀莫名其妙。这发生在我今晚和损坏的文件有大小49016 KB，而良好的文件I备份当最后进行了更改的大小4,872 KB的。这是一个pretty显著差异。

Something is causing the WSO2EMM_DB.h2.db file to get overinflated somehow. This happened to me tonight, and the bad file had a size of 49,016 KB, while the good file I backed up when the last changes were made has a size of 4,872 KB. That's a pretty significant difference.

编辑：我一直在运行的服务器，而不进行任何更改，并密切关注该WSO2EMM_DB.h2.db文件。这似乎增益大小每小时约2兆字节。起初我以为它没有以缓慢稳定的速率获得大小，而全部一次每隔一小时，但经过进一步的实验，我发现它实际上是稳步增长。

I've been running the server without making any changes to and keeping an eye on the WSO2EMM_DB.h2.db file. It seems to gain about 2 megabytes in size every hour. At first I thought it didn't gain size at a slow steady rate, rather all at once every hour, but after further experimentation I found it does in fact grow steadily.

这篇关于WSO2EMM - 应用管理永远不会返回/未安装安装应用程序的用户列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！