Welcome to TangoWorldWide!
You are a Guest, which means you cannot use
all possible features on this forum.
Sign in or Register, to enjoy full functionality. It'll only take 2 seconds!
  403 Players in 20 Servers

Author Topic: Surf database maintenance (Fixes)  (Read 548 times)

0 Members and 1 Guest are viewing this topic.

Offline SiL3nT

  • Surf in my sleep
  • Partnership Director
  • Forum Addict
  • *
  • Topic Author
  • Posts: 1655
  • I Compute Therefor, i am BOFH.
    • http://steamcommunity.com/id/SiL3nTOne/
    • http://www.twitch.tv/TheSiL3nTOne
    • https://www.youtube.com/channel/UCf0TlsSyEhscQJcXL884k3g
    • https://twitter.com/SiL3nTOne
    • View Profile
  • Liked: 59
  • Likes Given: 1
  • User Avatar

    T.w² | SiL3nT

    Online


  • Total Badges: 27
    Badges: (View All)
    3 Year Coin Summer 2018 Christmas 2017 Halloween 2017 Summer 2017 Hurricane Harvey Donor Badge Collector (20) 2 Year Coin 100 Poll Votes Christmas 2016 Halloween 2016 Badge Collector (15) 1 Year Coin Summer 2016 1000 Posts 500 Posts Badge Collector (10) Spammer-50 Spammer-25 12 Days of Christmas 100 Posts Badge Collector (5) Christmas 2015 Thanksgiving 2015 Halloween 2015 Mobile User Quick Poster
Surf database maintenance (Fixes)
« on: November 21, 2016, 10:11:41 pm »
Update:
There has been a slight change in plans, we have decided to keep the live T1/T2 server open and up. The reasoning for this is that we can make the changes on the Test surf server, and simply copy the database changes over to the live server once we are done. This way there is no downtime for the live server until we make the change (which will be very short) and we can make the changes at our leisure.

-----------------------------------------------------------------------------
Good evening everyone,

It has been brought to our attention that there have been some strange issues going on with the timer on the surf server, we have isolated the issue and will be scheduling a maintenance window in order to fix the issue.

The issue lies in the way the CKSurf timer talks with and writes data to the database in regards to the zones on the maps, something went a bit wrong with a previous update to the newest version of the timer. The newest version was updated improperly and has caused an issue where bonus zones populated in the database start to shuffle around and are given an incorrect zone group ID, this is because of a change in the way the database works from the previous version of the timer to the new one.

Balon, Shab, and myself will be working on the issue this coming Wednesday and Thursday 11/23 - 11/24, we will be locking the Main Tier 1/Tier 2 server in order to work on and fix this issue. Rest assured that all of your map times and points will still be on the server and the database, we are only performing maintenance on the zones populated in the database.

Change log:
11/23 Maintenance window begins (Approximately 5:00 PM EST)

-Server will be locked
-ck_zone table will be dropped
-Fresh install of the final CKSurf timer will be installed
-Checks on the server and database will be made to ensure that install was successful
-Manual re-zoning of all maps will be started (105 maps in total)

11/24
-Manual re-zoning of all maps will be continued (105 maps in total)
-ck_zone table in the database will be checked again to ensure that changes were successful
-Server will be re-opened to the public
Maintenance window ends (Most likely later Thursday night)
« Last Edit: November 23, 2016, 09:18:20 pm by SiL3nT »
None of you seem to understand. I'm not locked in here with you. You're locked in here with *ME*!


Click anywhere above to view TheSiL3nTOne's stream.

 

G2A Sponsor Image
DigitalOcean
Sinus Bot
AllTrapNation.com
OVH Networks
G2A Sponsor Image
DigitalOcean
Sinus Bot
AllTrapNation.com
OVH Networks