Life is Feudal Official Forum

[RudgerWolvram]

So, while playing on another server, a DB crash happened, and we lost 4-5 hours of work. So I decided that on our dedicated server I was going to setup binary logging so we can have up to the minute restores if a crash ever happened and we needed to restore.

Well, it seems that that because most of the SQL procedures and functions in LiF are deterministic or NOSQL or READ SQL DATA, having Binary Logging enabled on the server breaks a lot of things. First thing I noticed out of the box was character creation get's broken.

Error message you'll see in the logs/serverconsole

Spoiler

Code: Select all

DB error #1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable). Query: INSERT INTO `character`(AccountID, Name......


Setting log_bin_trust_function_creators=1 in my.ini makes character creation work, however, I don't know how safe it is (i.e. do restores from binary logs fail when a certain query is hit or does it miss data during the restore?) or if it works for all queries generated through play. Though, even with Binary logging on and trust_functions enabled, a full backup restore should still work, I just don't know how well a binary log restore after the full restore will work.