Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    April 2015
    Posts
    26

    [Broken DB] Crash and other problems with 3.0.11.2

    Hi, i have a teamspeak 3 server 3.0.11.1 32bit
    Iv had problems when i moved it to 3.0.11.2 32 then 64 bit same version, It crashes after 30 sec same time very time, no errors in log it just, no quit message or anything it just stops.
    happened now as i moved back to 3.0.11.1 32bit, (not updating since it doesent work at all) but there was this 2 guys that joined from germany (uninvited) and i asked who they where, they dident reply, i kicked with msg who are you?, nick: Tor**** rejoined, server crashes after a few sec, i start it, ban him and look up his ip, it comes from Gmbh.. isent this Teamspeak creators?
    what im trying to know is.

    -how do i fix my server from randomly crashing newest version 64bit (no error logs or messages in logs)
    -Did Gmbh try to shutdown my server? Running no license and i do not break any rules i guess (i don't host for others and i do not say i made the program)
    Sorry for bad english, gramar and other problems in my text.

    -Joveice
    Last edited by dante696; April 23rd, 2015 at 09:47 AM. Reason: merged

  2. #2
    Join Date
    June 2008
    Posts
    18,513
    It's not us joining random servers and doing bad things.
    Do not feed the trolls and don't let them you troll you.

    Update your server to 3.0.11.2 / or 3.0.11.3 (if already released)
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  3. #3
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by dante696 View Post
    It's not us joining random servers and doing bad things.
    Do not feed the trolls and don't let them you troll you.

    Update your server to 3.0.11.2 / or 3.0.11.3 (if already released)
    I did update to 3.0.11.2 32bit > 64bit, thats when the problems started, so i used my backup with the new database file at version 3.0.11.1 and it "calmed" down and it happens less now, is there anything else i can do? updating just made it worse.
    -joveice

  4. #4
    Join Date
    June 2008
    Posts
    18,513
    This report is just not enough to say anything concrete about server 3.0.11.2. Because What you describe should be a problem with server 3.0.11.1 and older versions.

    For server 3.0.11.2
    Does the process really stop? Or do users just timeout?
    Please paste the server log(s).
    Check ping and packet loss of this server etc.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  5. #5
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by dante696 View Post
    This report is just not enough to say anything concrete about server 3.0.11.2. Because What you describe should be a problem with server 3.0.11.1 and older versions.

    For server 3.0.11.2
    Does the process really stop? Or do users just timeout?
    Please paste the server log(s).
    Check ping and packet loss of this server etc.
    Yes, ill make a time line, I click to start the server, It starts icon shows up in tray bar, i connect, 30 secounds, nothing works, edit a channel doesent do anything, *disconnected* reason : Disconnected no error no server stop, i log on to the dedicated server i have, icon is gone, : Task manager ts3 server is not running. This is for version 3.0.11.2 32 bit And 64 bit same on each no diffrence.

    --merged--

    Log:
    32bit
    Code:
    2015-04-19 18:15:39.734194|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11.2 (2014-12-15 14:43:52)
    2015-04-19 18:15:39.734194|INFO    |ServerLibPriv |   | SystemInformation: Windows 7 SP1 (7601) x64 (AMD or Intel) Binary: 32bit
    2015-04-19 18:15:39.736194|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2015-04-19 18:15:39.736194|INFO    |DatabaseQuery |   | dbPlugin version: 3.8.0.2
    2015-04-19 18:15:39.736194|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
    2015-04-19 18:15:39.785197|WARNING |Accounting    |   | Unable to find valid license key, falling back to limited functionality
    2015-04-19 18:15:44.165405|INFO    |              |   | Puzzle precompute time: 3847
    2015-04-19 18:15:44.165405|INFO    |FileManager   |   | listening on 0.0.0.0:30033
    2015-04-19 18:15:44.335406|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 
    2015-04-19 18:15:44.335406|INFO    |Query         |   | listening on 0.0.0.0:10011
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec failed no such column: token_from_client_id
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec() delete from client_properties where id=93;delete from messages where m error: no such column: token_from_client_id
    2015-04-19 18:18:39.776657|CRITICAL|VirtualServer |  1| client pruning: database delete failed for cldbid: 93, error: database error
    
    log 2
    2015-04-19 18:15:44.335406|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
    2015-04-19 18:15:45.880408|INFO    |VirtualServerBase|  1| client connected '***'(id:126) from *********
    2015-04-19 18:15:49.080412|INFO    |VirtualServerBase|  1| client connected '***'(id:98) from **********
    2015-04-19 18:15:50.792416|INFO    |VirtualServerBase|  1| client connected '***'(id:2) from **************
    2015-04-19 18:15:56.247424|INFO    |VirtualServerBase|  1| client connected '***'(id:109) from *************
    2015-04-19 18:16:11.287445|INFO    |VirtualServerBase|  1| client disconnected '***'(id:109) reason 'reasonmsg=leaving'
    64bit
    Code:
    2015-04-19 21:57:16.368360|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11.2 (2014-12-15 14:43:52)
    2015-04-19 21:57:16.384361|INFO    |ServerLibPriv |   | SystemInformation: Windows 7 SP1 (7601) x64 (AMD or Intel) Binary: 64bit
    2015-04-19 21:57:16.385361|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2015-04-19 21:57:16.385361|INFO    |DatabaseQuery |   | dbPlugin version: 3.8.0.2
    2015-04-19 21:57:16.386361|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
    2015-04-19 21:57:16.419363|WARNING |Accounting    |   | Unable to find valid license key, falling back to limited functionality
    2015-04-19 21:57:20.261583|INFO    |              |   | Puzzle precompute time: 3325
    2015-04-19 21:57:20.266583|INFO    |FileManager   |   | listening on 0.0.0.0:30033
    2015-04-19 21:57:20.407591|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1, 
    2015-04-19 21:57:20.410591|INFO    |Query         |   | listening on 0.0.0.0:10011
    2015-04-19 22:00:16.414658|ERROR   |DatabaseQuery |   | db_exec failed no such column: token_from_client_id
    2015-04-19 22:00:16.414658|ERROR   |DatabaseQuery |   | db_exec() delete from client_properties where id=93;delete from messages where m error: no such column: token_from_client_id
    2015-04-19 22:00:16.414658|CRITICAL|VirtualServer |  1| client pruning: database delete failed for cldbid: 93, error: database error
    
    
    log 2 
    2015-04-19 21:57:20.406591|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
    Last edited by dante696; April 27th, 2015 at 08:34 AM. Reason: merged and old logs removed. just edit your post next time

  6. #6
    Join Date
    June 2008
    Posts
    18,513
    Code:
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec failed no such column: token_from_client_id
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec() delete from client_properties where id=93;delete from messages where m error: no such column: token_from_client_id
    2015-04-19 18:18:39.776657|CRITICAL|VirtualServer |  1| client pruning: database delete failed for cldbid: 93, error: database error
    Your database is broken! The server can not start with that one.
    Did you downgrade with that database? That's bad and will destoy any databse :/
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  7. #7
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by dante696 View Post
    Code:
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec failed no such column: token_from_client_id
    2015-04-19 18:18:39.776657|ERROR   |DatabaseQuery |   | db_exec() delete from client_properties where id=93;delete from messages where m error: no such column: token_from_client_id
    2015-04-19 18:18:39.776657|CRITICAL|VirtualServer |  1| client pruning: database delete failed for cldbid: 93, error: database error
    Your database is broken! The server can not start with that one.
    Did you downgrade with that database? That's bad and will destoy any databse :/
    I upgraded and then it started crashing all the time, i downgraded and iv had it running now for 30 days no problems version 3.0.11.1 32bit Windows no errors in the data base, it was When i Upgraded The problem started and i downgraded again

  8. #8
    Join Date
    June 2008
    Posts
    18,513
    Can you send me that database in a private message?
    I'd like to see what is wrong with user with CLDIB 93.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  9. #9
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by dante696 View Post
    Can you send me that database in a private message?
    I'd like to see what is wrong with user with CLDIB 93.
    no, sorry.
    i don't want to send it since it contains the query passwords

  10. #10
    Join Date
    June 2008
    Posts
    18,513
    In that case i mark that threas as resolved.
    Your Database is broken and nobody can tell you why and what is broken there.


    BTW Query password(s) can be changed.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  11. #11
    Join Date
    April 2015
    Posts
    26
    oh? it can? how?
    in that case ill change it then send the file and then change it back again
    ---
    Can i mix questions? if so > There is a option in the server questions to set a delete delay for temp channels, but there is a optioon for that in the channels to. I tryed to set channel temp time to more than 24 hours but it doesent allow me, then i tryed to do it in the server settings i made the temp delete time for 48 hours and i could still not go over 24 hours in channels. Tryed 0 in channel, Channel deleted right after i left it? what is this 2 settings for and whats the diffrence?
    Last edited by Joveice; May 5th, 2015 at 12:13 PM. Reason: made 3 messages to 1

  12. #12
    Join Date
    December 2004
    Location
    RF
    Posts
    3,008
    Ah? Yes. Easy.
    Read the ...... manual already!
    Last edited by dante696; May 5th, 2015 at 12:32 PM. Reason: bad word removed

  13. #13
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by ANR Daemon View Post
    Ah? Yes. Easy.
    Read the ...... manual already!
    i tryed to find what i where looking for, but i don't seem to find it anywhere in it

  14. #14
    Join Date
    June 2008
    Posts
    18,513
    FAQ (Frequently Asked Questions)?
    https://support.teamspeakusa.com/ind...-query-account
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  15. #15
    Join Date
    April 2015
    Posts
    26
    Quote Originally Posted by dante696 View Post
    login serveradmin YOUR_CURRENT_PASSWORD
    clientsetserverquerylogin client_login_name=serveradmin





    The output with your new password should look like this:

    client_login_password=1ZKIodA6
    error id=0 msg=ok
    so i cannot select lets say password= 123123123?
    and can you answear the other question i had? or do i need to ask it somewhere else?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] teamspeak 3 application android crash crash crash
    By hycksou in forum Android
    Replies: 4
    Last Post: July 5th, 2017, 07:05 PM
  2. Replies: 8
    Last Post: June 28th, 2011, 01:53 PM

Posting Permissions

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