Server Database lock after the server ran a while

Conan Exiles PC Discussion
1

**Game mode: Online Private
**Type of issue:Bug/Performance
Server type:PVE
**Region:EU

Since last month i took over a rental server of a community and copied it to my own Dedicated Server.
After setting things up i start to notice that after a while people started to complain about infinite loading screens and respawn screen. It appears to have somekind of bug in the database system which causes the database not responding at requests anymore. If u are already ingame when this happens, everything is fine and u can play without any lag but as soon as you die it starts.
The only fix so far is that i have to restart the gameserver once in a while(sometimes within 1 hour and sometimes in 1 1/2 day).

My Dedicated Machine is powered by an intel i7 980x with 24GB RAM and 2x 1TB HDD in RAID 1 and it runs Windows server 2016 Datacenter with all the latest updates that it has.
I hosted many servers before and never seen such an issue on my machine. The machine load itself is low while running the conan server and everything else still keeps responding.

Please provide a step-by-step process of how the bug can be reproduced. The more details you provide us with the easier it will be for us to find and fix the bug:

  1. Start a server and let people play in it
  2. Watch it carefully after a few hours/days and the database is unresponsive.
  3. Restart gameserver and bug is gone and database responds fine.
3 Likes
2

Do what others here have done.
Restart the Server EVERY DAY at a Specific Time to clean up any memory leaks and/or other inconsistencies.

2 Likes
3

How large is your database file? Ours is 220mb

We restart our server game every day too.

I also run this script on my database everytime too and it stopped the issues you describe :

@echo off
for %%a in (game.db) do (
echo “%%a”
sqlite3.exe %%a “VACUUM;REINDEX;ANALYZE;pragma integrity_check”
)
pause

I didn’t see much improvement when I upgraded the server to SSD’s :frowning:

Also make sure the game.db-shm and game.db-wal are gone/deleted before relaunching the server.

Goes without saying… Take a backup of your database file before doing any work on it.

2 Likes
4

Yep! Nothing like a little data base compacting and re-indexing to help speed things up.

1 Like
5

Well currently the size is just about 34MB because i wiped the server completely when i took it over.
The problem is i have to restart sometimes 4-5 times a day and sometimes not even once. Its very inconsistent.
I will try the script at the next restart. And for those 2 files i usually keep em there unless the console spams those files are corrupt because they contain a piece of data and i noticed if i remove those i get a bigger rollback then when i leave those 2 files.

I wish funcom notices this and makes a workaround for this issue since apparently lots of server owners have this issue :frowning:

1 Like
6

The script did not work at all, it outputs an error: ΓÇ£game.dbΓÇ¥
Error: near “G?VACUUM”: syntax error
Press any key to continue . . .

1 Like
7

It’s becaue the quotes are Unicode special characters instead of the default ASCII double quotes.

Replace them with the normal ‘"’ quote and it should work.

1 Like
8

Yes i figured that out myself and forgot to post it back :stuck_out_tongue:

And i just ran the script and started up my server. I will reply if it helped alot or not.
Also again i hope funcom employees will pick this up and start working on an actually fix for this issue since apparently i am not the only server owner who has this issue.

1 Like
9

This topic was automatically closed after 7 days. New replies are no longer allowed.