Forum

Results 1 to 4 of 4
  1. #1
    Join Date
    February 2012
    Location
    Nuremberg, Bavaria
    Posts
    258

    Question [Question/Suggestion] Database upgrades

    Hey,

    is it true, that database updates are only performed by the version of instance, which provides this new database update and the next version wouldn't import it even, if it wasn't updated yet?

    Usually are upgrades done like this:
    Code:
    3.0.12.3 -> 3.0.12.4 -> 3.0.13 -> 3.0.13.1 -> 3.0.13.2
    You'll update your instance to every single version and won't skip any.

    3.0.13 for example delivers now a database update: sql/update_25.sql

    If you upgrade from 3.0.12.4 to 3.0.13, it will be imported by starting TeamSpeak automatic, right?

    But what, if this isn't the usual update process? I know a lot of people with an update process like this:
    Code:
    3.0.12.3 -> 3.0.12.4 -> 3.0.13.2
    They're too lazy to update their TS3 server to every single version, don't want to update to the new version, because they want to test it first or they just don't had the time for updating it and skip some due of that.

    If I'm right, the database update of v3.0.13 (sql/update_25.sql) won't be imported automatic now. This would mean, that the server is using a wrong database schema with which the TS3 server isn't able to work. At the end, the server will not startup and/or die/stop.

    Sure, you can now import the database update before starting the TS3 server instance, but the most people wouldn't do or just forget that. After (maybe) a few update attempts, I can already see the users creating a new topic here which is called "Unable to start TS3 server after update" (or similar).

    Is that the current process for updating the database? If yes, I want to suggest, that the version of the database should be checked at every startup of the TS3 server instance and if required, it should import all missing updates.

    I'm waiting for your feedback. Thanks!

  2. #2
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,368
    TeamSpeak upgrades the database until the target version and the current database version match.

    Examples:
    1. Database version 20, target version 25: installing upgrades 21, 22, 23, 24 and 25.
    2. Database version 26, target version 25: infinite loop (aborted by missing files)

  3. #3
    Join Date
    February 2012
    Location
    Nuremberg, Bavaria
    Posts
    258
    Ah, ok. Thanks for this information.

    How long can such an update take? From 24 to 25 it shouldn't take long for example, due of that, that it only has less than 10 changes...

  4. #4
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,368
    Neglegible compared to puzzle precompute.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Question about database update error
    By internetvietnam in forum Server Support
    Replies: 1
    Last Post: March 16th, 2015, 04:05 PM
  2. [Rejected] Retain server uptime on upgrades
    By napok in forum Suggestions and Feedback
    Replies: 4
    Last Post: August 16th, 2012, 08:24 AM
  3. Channel Descriptions truncated after upgrades
    By cepler in forum Bug Reports [EN/DE]
    Replies: 0
    Last Post: April 18th, 2010, 01:22 PM
  4. [suggestion] Plugin/skins/scripts database
    By azzy101 in forum Suggestions and Feedback
    Replies: 0
    Last Post: February 10th, 2010, 10:28 PM
  5. Question - about server upgrades
    By IMplODemE in forum Windows
    Replies: 1
    Last Post: February 3rd, 2010, 05:01 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •