1C Infobase Log quite big

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jul 14, 2014
Company:

Hello,

Is there any chance to have log rotate for 1C Infobase. 1C Infobase log file is increasing in size every day and it`s quite big. Is there any setting for the platform to clear the log automatically and periodically?

Thank you.

Edited: Marius GIDU - Jul 03, 2020 12:10 PM
 
#2
People who like this:0Yes/0No
Administrator
Rating: 7
Joined: Oct 3, 2019
Company:

Hi Marius,

What is your version of the 1C platform?

Are you using the old logging format (.lgd files) or the new one (SQLite)?

Aleksandr

 
#3
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jul 14, 2014
Company:

The old one (.lgd). Platform version is 8.3.10. For the new log i saw in 8.3.16 that you have the possibilities to trancate log by day from designer.

 
#4
People who like this:0Yes/0No
Administrator
Rating: 7
Joined: Oct 3, 2019
Company:

Hi Marius,

i'm sorry I misled you.

The .lgd is the new log format (SQLite), but .lgp and .lgf are the old text format files.

Indeed, the SQLite format cannot be broken down into periods.

In new versions of 1C, it's possible to switch to the old format of the events log (pls. see screenshot 1).

In older versions of 1C, it's also possible to return to the old journal format. To do this, please stop the 1C server, transfer the file "1Cv8.lgd" to another location, and create an empty file "1Cv8.lgf" in the "1Cv8Log" folder. This will be the log journal in the old format. After that, you need to start the 1C server again, then go to the Designer. And already in the Designer, enable the breakdown of the journal by period (for example, by week). (screenshot 2).

You can also always reduce the size of the log file using the "Reduce size" button.

But note that if you use the new log file format (SQLite), the size of the "1Cv8.lgd" file will not change after the size reduction procedure. This is due to the features of the work of the SQLite. To reduce the size of the file "1Cv8.lgd" in this case, you must use the command "vacuum" in "sqlite3".

You can download the "sqlite3" from the official site "https://www.sqlite.org".

Download Scr_1.png (11.35 KB)
 
Subscribe
Be the first to know tips & trick on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.