It was a long weekend. We fought through it, but the war is not over yet. I've already thanked you on Discord, so I'd like to do the same here.
Added a lot of debug to the filter to track down the SQL issues. Since it was completely random as to when it happens, but pretty reproducible as to what happens when it occurs, it was worth a try to replace the database server. I set up a new database VM today and migrated it.
I also applied a small patch. No update is required.
- The movement speed of trade pets is slightly higher ~70% (instead of ~45%) of the original value
- The alchemy rate has been slightly increased
- Drop has been increased to 1.1x
- Gold has been increased to 1.2x
Thanks for sticking with us. We had a peak of 170 online players over the weekend and went right back down to 110 players after maintenance was over.
----
Update: 14.05.2024
A quick recap of events. We had our grand opening on Friday. Unfortunately, it wasn't all peace, joy and pancakes. We had to deal with crash issues, major lags and routing issues. While we were able to narrow down the crashing and routing issues (meaning most players should be able to connect without issue), we were not yet able to get a handle on the lag issue.
As always, you can skip the technical part
I have invested over 50 hours from Friday to Monday evening with a total of 7 hours sleep, added countless lines of debugging and read through thousands of lines of debug output. Unfortunately the error is not reproducible, kind of random, but always behaves the same. Today I will update the dependencies of the filter, maybe it is a general problem in the database framework we are using.
The problem basically boils down to this: something triggers a SQL query, which then leads to a massive exhaustion of the database connection pool. This leads to the creation of connections, which happens on the main thread. Each connection also creates a short running thread, the thread takes about 300-500ms to be fully created, the connection about 5ms to be established, usually 10 connections are created -> 3-5seconds lag. This continues until we are at 300 connections over a time between 5-15 minutes and then a sudden disconnect from random users and the connection pool is refilled.
While this is happening, sql is basically very very bitchy. Sometimes it's super slow, sometimes it times out because no connections are available. Thats why you are mostly not able to reconnect in that time when it happened. At first I thought it was the SQL Server, then I had a chance to test it while it was happening. The filter SQL query crashed, the one on the SQL server was perfectly fine.
Compensation
The compensation will be paid out in 2 parts. One part will be as crash compensation for the players and characters mentioned here
[Only registered and activated users can see links. Click Here To Register...]. The other compensation will be for lag and will apply to every player. I'm already in the process of choosing a good compensation for the crashes, but I can't say when it will be paid out yet, as I want it to be chosen wisely and not "forced".
Its too hard, Gameplay & Webmall
There is a general perception that the webmall should be the cheapest option. It is not. The small potions are cheaper and easily accessible as the early game is too hard. I've also lowered the prices of the other potions. Keep in mind that they are still more expensive than the potion NPCs in town.
Gold prices will also swing depending on the average gold of the players. This will start once a few players have reached higher levels so that we see a normal amount of gold.
1000 potions (small) - 110k NPC - 50k Webmall
1000 potions (medium) - 200k NPC - 300k Webmall
1000 potions (large) - 400k NPC - 500k Webmall
The server should be hard, you shouldn't permanently level on your monsters or on monsters 3 levels higher. We have no auto gear, we have huge spawns, just use your game experience to get around this situation.
CTF & BA
Yes, it's enabled, the times suck and it's usually in the middle of the night. I'll change it in the meantime on a restart. Sorry for that.
Elitepvpers Event
I'm not a fan of the signature event. I'm happy for you guys to use our signature below, but you won't get anything out of it.
That's why we're turning the tables. Post a ingame screenshot of a funny, wholesome, impressive or just plain beautiful picture of Evolin and spread some love. You'll receive 4 Globals for this. Of course, you can also advertise your guild. Don't forget to add your character name. This is available once per person.
Please use
[Only registered and activated users can see links. Click Here To Register...] to upload your image.
Code:
[CENTER]
[URL=https://www.elitepvpers.com/forum/sro-pserver-advertising/5222034-evolin-70-cap-ecsro-jobsystem-beta-map-no-p2w-long-term-vsro-based.html][IMG]https://i.epvpimg.com/37uPfab.png[/IMG][/URL]
[/CENTER]
Discord Changes
I'm tired of the lag and crash spam. That's why I've blacklisted it. If you bypass it, I'll just mute you. Yes, I know it's laggy, we have a bot that tracks exactly when it starts and when it stops. It sucks for you and it sucks for me too, spread some love instead and keep players and yourself motivated.
I've also added #announcements-tr, moved announcements to #announcements-en, moved the old general-other-lang to general-german and added a new #general-other-lang