View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004260||SOGo||Web General||public||2017-08-24 15:34||2018-10-03 10:28|
|Platform||[Server] Linux||OS||RHEL/CentOS||OS Version||7|
|Summary||0004260: After a restart of services on servers, some user settings are resetted|
On SOGO 3.2.9 updated to 3.2.10, server CentOS 7.3, MariaDB 10.0, with NGINX. we note randomly that the settings in mysql/sogo_user_profile were resetted to default. It seems (but needs to be confirmed) to occur after a nginx restart (but the first time it occurs this was a sogod+nginx restart).
When it occurs, this is only (actually) on one user, all others are not modified. But on the 3 times it occurs, this was 3 different users.
|Tags||No tags attached.|
Is it possible that these users had images in their HTML signatures?
Try doing in mysql:
alter table sogo_user_profile MODIFY c_defaults LONGTEXT;
Data being truncates means the JSON payload isn't valid anymore, thus it is invalidated.
At 4:00AM, exactly when the phone of user concerned made an activesync connection, sogo overflows in memory. The problem is that there is absolutly no activity on the server at this time, just some terminals like this phone which make some ping requests one time a minute. So I don't understand why sogo has reached this limit, when it have no problem with it at work hours when about 40 terminals are connected and are working !!
Sep 06 04:12:11 sogod : 126.96.36.199 "POST /SOGo/Microsoft-Server-ActiveSync?User=myuser&DeviceId=BC6A29MD9D3JHFP5KTA1HRLK0O&DeviceType=iPhone&Cmd=Ping HTTP/1.1" 200 13/0 10.722 - - 0
Well : I think that you can close this issue as there was no more loss of settings appends since the fields modifications and this last problem at 2017-09-06.
|2017-08-24 15:34||fsoyer||New Issue|
|2017-08-24 19:35||ludovic||Severity||major => minor|
|2017-08-24 19:36||ludovic||Note Added: 0012232|
|2017-08-24 19:54||ludovic||Note Added: 0012233|
|2017-08-24 20:13||ludovic||Changeset attached||=> sogo master 2a046557|
|2017-08-24 20:13||ludovic||Assigned To||=> ludovic|
|2017-08-24 20:13||ludovic||Resolution||open => fixed|
|2017-08-25 07:54||fsoyer||Note Added: 0012234|
|2017-08-25 12:49||ludovic||Note Added: 0012235|
|2017-08-25 12:49||ludovic||Status||new => resolved|
|2017-09-06 09:24||fsoyer||Note Added: 0012260|
|2017-09-06 09:24||fsoyer||Status||resolved => feedback|
|2017-09-06 09:24||fsoyer||Resolution||fixed => reopened|
|2017-10-17 09:50||Christian Mack||Relationship added||related to 0004315|
|2018-10-03 10:07||fsoyer||Note Added: 0013073|
|2018-10-03 10:07||fsoyer||Status||feedback => assigned|
|2018-10-03 10:28||francis||Status||assigned => resolved|
|2018-10-03 10:28||francis||Resolution||reopened => fixed|