Vux 0 Posted April 14, 2020 Share Posted April 14, 2020 Hello everyone I'm facing a huge and strange problem which is .. after awhile of playing .. levels or items or yang could be lost not literally lost its kinda you have the levels or items or yang the day before or an hours ago My client's end game option is without wait time to save progress i thought that was the problem but still ... Can anyone help me with this nightmare ? Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted April 14, 2020 Premium Share Posted April 14, 2020 What do you mean "without wait time"? The cache is saved every hour by default, you should not change it if you don't know what you are doing. Your MySQL tables could also be corrupted, check /var/db/mysql/hostname.err Link to comment Share on other sites More sharing options...
Vux 0 Posted April 14, 2020 Author Share Posted April 14, 2020 1 minute ago, Shogun said: What do you mean "without wait time"? The cache is saved every hour by default, you should not change it if you don't know what you are doing. Your MySQL tables could also be corrupted, check /var/db/mysql/hostname.err I mean the Exit game option with no wait time .. once you click it forcefully closes Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted April 14, 2020 Premium Share Posted April 14, 2020 Well I don't think YMIR put that there just to be annoying. The data needs to be saved on the db. Link to comment Share on other sites More sharing options...
Premium xHeaven 263 Posted April 14, 2020 Premium Share Posted April 14, 2020 (edited) 1 hour ago, Shogun said: Well I don't think YMIR put that there just to be annoying. The data needs to be saved on the db. Actually, the 10 seconds wait time is just simply kind of annoying, but nothing else. I mean, what if the player crashes, the player's PC crashes, the player's internet cuts off, etc..? The server won't save its data? It should. My guess would be your first thought, corrupt MySQL tables, or something else in the background, but definitely not connected to the in-game "Exit game" option. Edited April 14, 2020 by xHeaven typo Link to comment Share on other sites More sharing options...
Forum Moderator Gurgarath 2513 Posted April 14, 2020 Forum Moderator Share Posted April 14, 2020 (edited) If I had a script that automatically back-up database and if the problem was for everyone, I would check it just in case. Like, if you don't do anything stupid that overrides your tables. If it is during shutdown, it's better to simply shutdown and wait for at least seven minutes before stopping the game and db for the cache to be saved to the database. If it is out of thin air to random players, I would definitely check my syserr and my syslog. Any packet loss? Any iddle? Any lags or core-crashes (if you have an auto-restarter)? Then I would check MySQL, if the tables are not corrupted, if a query isn't overflowing a field, if the Sql process is running as it should and so on. If you didn't touch anything related to db cache, and if it happens only in some cases, it's most likely a MySQL problem, check player & item tables as well. Edited April 14, 2020 by Gurgarath Gurgarath coming soon Link to comment Share on other sites More sharing options...
Vux 0 Posted April 15, 2020 Author Share Posted April 15, 2020 (edited) On 4/14/2020 at 5:03 PM, Shogun said: What do you mean "without wait time"? The cache is saved every hour by default, you should not change it if you don't know what you are doing. Your MySQL tables could also be corrupted, check /var/db/mysql/hostname.err as you can see here Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted April 15, 2020 Premium Share Posted April 15, 2020 All I see there is you need to run mysql_upgrade, and if your server is in the same machine as this MySQL server, then you should restrict connections to localhost and use the SSH tunnel option in Navicat to connect yourself. Other than that, I don't see anything relevant. In my.cnf: bind-address = 127.0.0.1 socket = /tmp/mysql.sock Then edit the CONFIG files in your cores and make sure they are using either SOCKET or 127.0.0.1 as connection IP. And then show the syserr in your db and game core. Link to comment Share on other sites More sharing options...
Vux 0 Posted April 16, 2020 Author Share Posted April 16, 2020 (edited) 18 hours ago, Shogun said: All I see there is you need to run mysql_upgrade, and if your server is in the same machine as this MySQL server, then you should restrict connections to localhost and use the SSH tunnel option in Navicat to connect yourself. Other than that, I don't see anything relevant. In my.cnf: bind-address = 127.0.0.1 socket = /tmp/mysql.sock Then edit the CONFIG files in your cores and make sure they are using either SOCKET or 127.0.0.1 as connection IP. And then show the syserr in your db and game core. thats my CONFIG of Core 1 , i dont see what u ment about Connection IP Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now