*extremely long sigh*
So, as many of you are aware of, we had another database issue today. Unfortunately, this issue led to multiple other issues...
Around 1pm CST, our server restarted itself for an unknown reason (host is investigating why this happened). This caused our database files to become corrupt because the plug was pulled in the middle of operation. Once corrupted, the specific tables inside the database can crash. When that happens, data from inside those crashed tables can become deleted. And that's what happened to start.
Once we took the site offline to repair the damage, we found out that there has been an issue with our backups over the past few days which has prevented any real backups from taking place and the latest 'good' backup was from Friday morning.
Going to the backup's backup (which is done weekly on Mondays), it too malfunctioned and did not properly back up our database in its latest run.
So we, very frustratingly, were stuck with restoring data from a backup from Friday, July 10th. =(
I cannot apologize enough for this as we felt fairly confident in running hourly backups, daily backups, weekly backups, and then a completely separate backup as a backup to our backups! But apparently, it still wasn't enough.
The worst part of this is that about 650 pets were lost from the initial table crash. However, 450 of those pets were created after Friday's backup. This means that they are more or less lost forever and completely unrecoverable.
Doing some deduction, I was able to determine that about 400 of the 450 lost pets were bred pets so I just simply "tossed" them out. They will no longer exist and cannot be recovered. IF YOU ARE ABLE TO DETERMINE THAT ONE OF YOUR PETS WAS LOST AND YOU HAD SPENT GOLD ON IT OR USED A PHILTER ON IT - SEND ME A PM! I can track this via other tables and reimburse you.
For the remaining 50 or so lost pets, they were already in players' stables. Thus I have restored these pets as best as I could and they are now all Tamed Male Qitari. These pets were either Generated Pets or Caught Pets. IF YOU OWN ONE OF THESE PETS - SEND ME A PM WITH WHAT IT USED TO BE AND I WILL FIX IT FOR YOU!
Additionally, all battles were removed. So if you were in a battle prior to downtime, you no longer are.
Lastly, 9 players were rolled back. If you were one of these players and were noticeably rolled back, send me a PM with the details.
Below are the affected pets and players:
Unrecoverable Pets
1625499,1625540,1625627,1625881,1626882,1626886,1626890,1626891,1626892,1626899,1626900,1626905,1626906,1626911,1626912,1626914,1626918,1626919,1626929,1626930,1626934,1627261,1627344,1627345,1627355,1627357,1627389,1627393,1627829,1628578,1628664,1628671,1628674,1628681,1628693,1628698,1628722,1628724,1628725,1628726,1628730,1628732,1628733,1628736,1628741,1628742,1628743,1628744,1628748,1628750,1628752,1628784,1628796,1628809,1628811,1628813,1628833,1628855,1628875,1628878,1628888,1628893,1628930,1629026,1629032,1629038,1629046,1629049,1629066,1629125,1629134,1629165,1629170,1629176,1629180,1629190,1629193,1629197,1629206,1629311,1629332,1629333,1629355,1629357,1629361,1629380,1629387,1629400,1629409,1629424,1629425,1629431,1629438,1629443,1629465,1629467,1629473,1629479,1629482,1629485,1629492,1629494,1629495,1629502,1629504,1629506,1629513,1629524,1629540,1629557,1629560,1629571,1629576,1629582,1629591,1629595,1629606,1629634,1629635,1629722,1629804,1629842,1629844,1629845,1629846,1629902,1629903,1629906,1629909,1630060,1630072,1630259,1630295,1630545,1630641,1630645,1630647,1630649,1630651,1630655,1630661,1630664,1630665,1630667,1630669,1630672,1630675,1630676,1630686,1630687,1630689,1630696,1630700,1630705,1630922,1631337,1631343,1631344,1631347,1631350,1631353,1631355,1631364,1631366,1631374,1631446,1631454,1631458,1631459,1631464,1631550,1631561,1631576,1631577,1631578,1631579,1632451,1633333,1633799,1633806,1633813,1633816,1633819,1633820,1633830,1633831,1633835,1633838,1633839,1633840,1633844,1633846,1633924,1633929,1633930,1633945,1633950,1633952,1633954,1634230,1634243,1634245,1634253,1634260,1634262,1634298,1634385,1634469,1634636,1634642,1634650,1634651,1634780,1634839,1634882,1634886,1635016,1635169,1635454,1635462,1635463,1635469,1635476,1636033,1636053,1636055,1636074,1636086,1636133,1636155,1636174,1636198,1636204,1636224,1636263,1636270,1636271,1636274,1636275,1636276,1636277,1636278,1636280,1636281,1636282,1636283,1636290,1636291,1636292,1636293,1636294,1636296,1636297,1636298,1636299,1636302,1636303,1636309,1636311,1636313,1636316,1636317,1636318,1636321,1636323,1636324,1636325,1636329,1636331,1636332,1636334,1636335,1636336,1636337,1636338,1636339,1636341,1636343,1636344,1636345,1636348,1636349,1636350,1636353,1636358,1636359,1636360,1636361,1636363,1636365,1636366,1636368,1636370,1636371,1636372,1636373,1636375,1636378,1636379,1636380,1636382,1636384,1636385,1636386,1636387,1636388,1636389,1636390,1636391,1636392,1636395,1636396,1636398,1636401,1636404,1636405,1636406,1636407,1636409,1636410,1636412,1636413,1636417,1636420,1636422,1636424,1636426,1636427,1636428,1636429,1636430,1636431,1636432,1636434,1636435,1636436,1636437,1636438,1636440,1636441,1636442,1636443,1636445,1636446,1636447,1636448,1636449,1636450,1636452,1636455,1636457,1636458,1636459,1636460,1636461,1636462,1636463,1636465,1636466,1636467,1636468,1636470,1636473,1636475,1636476,1636478,1636481,1636483,1636484,1636485,1636486,1636490,1636491,1636492,1636493,1636494,1636495,1636496,1636497,1636498,1636499,1636501,1636502,1636503,1636504,1636505,1636506,1636507,1636508,1636511,1636514,1636515,1636516,1636517,1636518,1636519,1636520,1636521,1636523,1636524,1636526,1636527,1636528,1636529,1636530,1636533,1636534,1636535,1636536,1636537,1636538,1636539,1636540,1636542,1636543,1636544,1636545,1636547,1636548,1636550,1636552,1636558,1636559,1636560,1636561,1636562,1636563,1636564,1636565,1636566,1636567,1636568,1636573,1636577,1636578,1636584,1636585,1636586,1636590,1636591,1636592,1636594,1636595,1636596,1636598,1636601
Recoverable Pets
1636576,1629033,1626254,1630407,1636571,1629629,1636399,1636572,1636531,1630674,1636557,1628040,1636451,1635046,1627853,1628665,1635943,1631299,1631356,1636397,1636131,1636581,1636411,1636416,1636597,1636600,1636482,1636580,1636569,1636582
Affected Players
48,20295,21809,24945,27767,32746,35583,36635,36995 |