Server01.ldf and RockAndRollITS

[skronix]

The RockAndRollITS log file sometimes starts to weigh large, what is it connected with and how is it treated? Also Server01.ldf is starting to take on a lot of weight. Who faced this problem and how is it solved?

 

[doogydog]

delete

 

[RGaming]

just delete or make a job to automatic it upload somewhere before it will be deleted

 

[skronix]

...........

just delete or make a job to automatic it upload somewhere before it will be deleted

I delete, it starts over again like this

 

[PwrDex]

Well my secret is simple, restarting Rockandrollits every 4 hours. It's not causing anything on running server but avoid the generating of buglog...
I'm already spent weeks to resolve what causing it..

 

[skronix]

Well my secret is simple, restarting Rockandrollits every 4 hours. It's not causing anything on running server but avoid the generating of buglog...
I'm already spent weeks to resolve what causing it..

Crontap to restart the service every 4 hours?

 

[trungnt88]

LDF file normally refers to the LogDataFile of MS SQL server. LDF records all the transactions and changes to the database. The LDF is critical for disaster recovery. Beside of the LDF, we also have MDF which stands for Main Database File and contains all the information in a database (up-to-date version).

You can turn off certain types of log to reduce the log size, or if you want to do it in easy way you can do via mssql server ui, take a look here:

You must be registered to see links

 

[DWBaHu0]

I never had such big logs.

 

[S37uP!Update]

This is quite old problem, PwrDex is right, the solution would be to create a cron job to restart the RockandRollIts.

 

[uiop]

Would it be better to:
RockAndRollITS.ini
LogLevel=3

 

[PwrDex]

Would it be better to:
RockAndRollITS.ini
LogLevel=3

Already tried all log level from 0 to 7
none helped...

 

[HariSeldon]

Probably the problem is somewhere in the ini files. Ever since I configured my ini the way I saw fit, I have never had this problem (more than 2 years now).
But what exactly is the reason, I still do not know. It takes a lot of tests for this.

 

[uiop]

Already tried all log level from 0 to 7
none helped...

[NetLib]
Port=35739
PortForHS=62001
SendMaxBufSize=655360
ProcessDataLimit=10000
MaxUserNum=500
WatchsNoPackLimit=30000
UseEncryptPacket=1
SystemLogTTimeOut=100
ReactorTimeOut=100
DisableReactorPipe=1
ConnectRetryTime=5000
ConnectRetryNum=10
UseEncryptPacket=0
LogLevel=3

[RockAndRoll]
ESymRepositoryPath="/etc/cabal/GMSHeartITS/"

[DBAgent]
Addr=127.0.0.1
Port=32080

 

[HariSeldon]

Try use this

[NetLib]
Port=35739
LogLevel=1
MaxUserNum=-1
ConnectRetryNum=10
ConnectTimeout=10000
DisableReactorPipe=0
LinklayerAsyncConnect=0
MaxStayTimeInQueue=0
MemPoolUnitSizeClass=0
ProcessDataLimit=1024
ReactorTimeOut=-1
SendMaxBufSizeLinkHandler=2621440
SendMaxBufSizeUserHandler=2621440
TcpNoDelay=1
UseEncryptPacket=0
WatchsNoPackLimit=1000
PortForHS=62001

SendMaxBufSize=32768
SystemLogTTimeOut=100
ConnectRetryTime=5000

[RockAndRoll]
ESymRepositoryPath=/etc/cabal/GMSHeartITS/
UseDBAgentConnect=1
ProcessLayerTaskNum=1

[DBAgent]
Addr=127.0.0.1
Port=32080

 

[skronix]

Already tried all log level from 0 to 7
none helped...

Do you have the same problem too?

 

[PwrDex]

Do you have the same problem too?

Since cron doing it's job no..

 

[skronix]

Since cron doing it's job no..

I found a solution to the problem

 

[PwrDex]

I found a solution to the problem

Than you can tell us if you know..
As i tried to find it the closest what i reached is that it's trying to connect somewhere and refused, so it's falling to one infinite loop

 

[skronix]

Than you can tell us if you know..
As i tried to find it the closest what i reached is that it's trying to connect somewhere and refused, so it's falling to one infinite loop

I agree about the eternal loop, I mean that when I turn off the firewall, the log stopped weighing a lot and everything works stably