Try the fastest and simplest way to install ONLYOFFICE

[Control Panel] Backup function doesn't work

Tech support for Enterprise Version

Re: [Control Panel] Backup function doesn't work

Postby dsi-lille » Fri Jun 02, 2017 11:20 am

Hello Maxim,

you can download the csv here : https://filesender.renater.fr/?s=downlo ... d5&lang=en

it seems that the date are in GMT format and not in GMT+2 format.

Thanks again,
Yoann
dsi-lille
 
Posts: 151
Joined: Mon Jul 11, 2016 1:47 pm

Re: [Control Panel] Backup function doesn't work

Postby Maxim » Fri Jun 02, 2017 1:44 pm

Yoann please execute following
Code: Select all
select * from login_events where date between '2017-02-26' and '2017-02-27'

It needs to check out what data is saved in "login_events".
But anyway that's very strange that this table contains 7 101 113 rows. It's absolutely huge number of records in the database!
Maxim
 
Posts: 1240
Joined: Tue Oct 11, 2016 2:34 pm

Re: [Control Panel] Backup function doesn't work

Postby dsi-lille » Wed Jun 07, 2017 8:20 am

Hello Maxim,

There only lines like this (juste the date change) :
Code: Select all
3349873   123.45.67.89   (null)   (null)   (null)   2017-02-26 00:00:32   2   245fe815-28c8-44ff-bc0c-78ae0cf0d8d2   (null)   1010   (null)


The IP Adresse came from a serveur who use OnlyOffice API to populate some groups.
I think this is the main reason why there so much row in this table.

Thanks again,
Yoann.
dsi-lille
 
Posts: 151
Joined: Mon Jul 11, 2016 1:47 pm

Re: [Control Panel] Backup function doesn't work

Postby Maxim » Wed Jun 07, 2017 9:38 am

Hello Yoann!
We know that the problem is connected with this table.
First of all try to delete this
Code: Select all
delete * from login_events where date between '2017-02-26' and '2017-02-27'

and try again to create backup
if the issue appears again you can extend the time range of data to delete, for example
Code: Select all
delete * from login_events where date between '2017-02-15' and '2017-03-15'

and try again to create backup
don't forget to check logs
Maxim
 
Posts: 1240
Joined: Tue Oct 11, 2016 2:34 pm

Re: [Control Panel] Backup function doesn't work

Postby dsi-lille » Mon Jun 12, 2017 12:02 pm

Hello Maxim,

The backup creation work now.
i deleted a lot of rows, there remain "only" 1 288 941 rows in login_events table
Do i need to schedule a purge for this table ?

Thanks again,
Yoann
dsi-lille
 
Posts: 151
Joined: Mon Jul 11, 2016 1:47 pm

Re: [Control Panel] Backup function doesn't work

Postby Maxim » Tue Jun 13, 2017 8:00 am

Hello Yoann!
After that issue we have decided to implement automatic deletion in login_events table. We will add this feature in future releases.
Maxim
 
Posts: 1240
Joined: Tue Oct 11, 2016 2:34 pm

Re: [Control Panel] Backup function doesn't work

Postby dsi-lille » Wed Jun 14, 2017 8:11 am

Hello maxim,

thanks for your help and your answer :)

Yoann.
dsi-lille
 
Posts: 151
Joined: Mon Jul 11, 2016 1:47 pm

Previous

Return to Enterprise Version

Who is online

Users browsing this forum: dsi-lille and 1 guest