Server freezes when using command as a GM

[flamezito]

Hello, I made a simple script that reloads the cash shop automatically at 9:00 pm, however, sometimes the server freezes for about 5 to 10 seconds, where some players are disconnected in the process.

I thought it was the script's fault or something like that, however, I noticed the same behavior when using a simple "@ii" command within the game on a GM account, so I did a test with a normal account and the server didn't froze.

apparently the server or client freezes when a GM or a script executes a command.

In the server logs, it doesn't show anything, it only shows the log of players who disconnected.

Somewhere on this forum, I saw a similar problem, where someone said it was a problem inserting into the command log table, however, looking at the table, I see the logs without problems and inserted at a high speed.

My script:

-   script  cashshop#updat  -1,{

OnClock2100:

    atcommand "@reloaditemdb";

    end;

}

Edited June 17, 2024 by flamezito

[Chaos92]

15 minutes ago, flamezito said:

Hello, I made a simple script that reloads the cash shop automatically at 9:00 pm, however, sometimes the server freezes for about 5 to 10 seconds, where some players are disconnected in the process.

I thought it was the script's fault or something like that, however, I noticed the same behavior when using a simple "@ii" command within the game on a GM account, so I did a test with a normal account and the server didn't froze.

apparently the server or client freezes when a GM or a script executes a command.

In the server logs, it doesn't show anything, it only shows the log of players who disconnected.

Somewhere on this forum, I saw a similar problem, where someone said it was a problem inserting into the command log table, however, looking at the table, I see the logs without problems and inserted at a high speed.

My script:

-   script  cashshop#updat  -1,{

OnClock2100:

    atcommand "@reloaditemdb";

    end;

}

latest rathena have command @reloadcashdb. should be faster.

[flamezito]

10 minutes ago, Chaos92 said:

latest rathena have command @reloadcashdb. should be faster.

Okay, I'll try! But that doesn't change what happened to @ii
I'm using a VPS KVM 2 core 8g ram

[Chaos92]

4 hours ago, flamezito said:

Okay, I'll try! But that doesn't change what happened to @ii
I'm using a VPS KVM 2 core 8g ram

didnt know what to say, check the log maybe. it shouldnt be freeze.

But if @reloaditemdb, most probably will freeze awhile since the data is so many to be loaded.

but for @ii I dont think so. it should be fast.

just use @reloadcashdb.

Edited June 17, 2024 by Chaos92
additional info