• Hey Guest, we're evolving the future of TeaSpeak.
    You're invited to join the discussion here!

Pending [not a bug/just a question] query client socket hangup after 24h

lbenicio

Well-known member
hey, folks from TeaSpeak, I have a few questions about the server behavior, here we go:

1. does query the client automatically disconnects after some period of time? I noticed it usually hangups after 24h (but maybe it is client query bot problem)

2. Recently I noticed that if I try to update my default layout/template through Yatqa the server crashes, is it normal? should I do other configs?

3. does TeaSpeak escalate horizontally? like with docker? from what I understand the docker container is just for easy of deploy but you can launch n instances running behind the same DB and everything works normally out of the box?

cheers :)
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
1)
Well thats not normal, but I guess after 24h may some networky stuff hangs up :)

2)
Well not, please give me the crash dump and the version as well.

3)
Docker is supported, there is even a Dockerfile available on github.
 

lbenicio

Well-known member
1)
Well thats not normal, but I guess after 24h may some networky stuff hangs up :)

2)
Well not, please give me the crash dump and the version as well.

3)
Docker is supported, there is even a Dockerfile available on github.
1) I imagined that something would happen, not a big deal.

2) I will update to the last version and try again just to make sure (in ~13h). I'm currently on:
{"build_name": "1.4.8-beta-9", "build_version": "1.4.8-beta", "build_index": 9}

3) I saw the docker containers. I tried to run it over docker but went on some trouble (at least on OSX), but I thought it would escalate horizontally, like, if I have 2 hosts on a Kubernetes with 2 TeaSpeak Containers... I thought that depending on where the host assign the new client it would connect to different versions of the server (host1 x host2).
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Yeahr ;)

Well could you upload the crash dump?

Well whats the error when you're using TeaSpeak with docker?
 

lbenicio

Well-known member
Sorry for the delay, my script failed to update the server. I just managed to update it to latest version but everything went down... All servers crashing... People loosing packets... Music bots coming on newly generated servers.. It was a really mess.. Hahaha, I just rollback to the version it was before. I will analyze what I got and see what is useful to report. (But about the previous bug I could not even test that) :/
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
"All servers crashing... People loosing packets..."
Well thats interesting^^
Are there any crash dumps?
As well what do you mean exactly with "loosing packets"?

"Music bots coming on newly generated servers.. "
Thats not a bug ;)
 

lbenicio

Well-known member
OK, I will reformulated.

I received a mensagem about being DDOSed so the pockets and dropping players was about the DDOS I believe.

But one problem was happening. After updating to the new version, things start happening like when create a channel on one newly generated server kicking players on other server or making the hole teaspeak crashing... Some channels appears different (from the template server).

I believe that the problems related to the channel tree/struct of the server were related to the update (not necessary teaspeak bug itself), but the rest was the DDOS.

Strange, I got no crash dumps. I will try to replicate, maybe st the end of the day I something to upload

---- Automatically Merged Double Post ----

I think it does not generate crash log. Just all servers simply went down then up again

---- Automatically Merged Double Post ----

View attachment 2334

this is what was happening with newly generated server. see the music bot but i cant get rid of it?

other problem is the default layout that start coming wrong.. like missconfigured (but that i need to investigate more)

---- Automatically Merged Double Post ----

sorry about the music bot, i jsut managed to remove it. the proem is more about channels being created with wrong parameters (like with names and description wrongly)

---- Automatically Merged Double Post ----

I will try to explain the steps.:
1. create a new server (which come with a template from default template)
2. try to modify a wrong configured channel from this newly generated server
3. all servers went down (restarting)
4. When the servers returned onine, other newly generated server came with the modification did on step 2, like it was save to the template server
 
Last edited:

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Well what is a "wrong configured channel?
I'm not sure what that should be :D

And yes okey do the server hasn't actually crashed it just went busy due to the load ;)
 

lbenicio

Well-known member
like this, for example:

I had a channel on template server that was named "xxxxxx" with description "yyyyyyy"

when I create a new server it replaces the channel name "xxxxxx" to "zzzzzzz" and description with content from another already up and running server.

Another problem is when editing the template/newly generated server make all servers went down (still can't get a crash dump) but I'm investigating.... (i can't run a VM at the moment, my MacBook Air cant handle it, to run Yatqa to check the template server)

---- Automatically Merged Double Post ----

other thing that starts happening (but I think it is about the DDoS), is that only one server cant connect... all other (28 instances) I have can connect without a problem, but this one cant connect...

---- Automatically Merged Double Post ----

Code:
[2020-04-04 13:48:49] [INFO ]    32 | Starting server
[2020-04-04 13:48:49] [INFO ]    32 | Started server on 0.0.0.0:4791 | :::4791.
[2020-04-04 13:48:49] [INFO ]    32 | [Web] Starting server on 0.0.0.0,[::]:4791
[2020-04-04 13:48:49] [DEBUG]    33 | Importing server keypair
[2020-04-04 13:48:49] [DEBUG]    33 | [Conversations] Loaded 0 conversations
[2020-04-04 13:48:49] [INFO ]    33 | Loaded 42 saved channels. Assembling...
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2042 - Editor
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2043 - Sem Registro
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2044 - Channel Admin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2045 - Operator
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2046 - Guest
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2047 - -- Outros --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2048 - -- Levels --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2049 - 1000+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2050 - 950+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2051 - 900+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2052 - 850+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2053 - 800+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2054 - 750+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2055 - 700+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2056 - 650+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2057 - 600+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2058 - 550+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2059 - 500+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2060 - 450+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2061 - 400+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2062 - 350+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2063 - 300+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2064 - 250+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2065 - 200+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2066 - 150+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2067 - 100+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2068 - 50+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2069 - 0+
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2070 - -- Registros --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2071 - Convidado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2072 - Support
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2073 - Aliado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2074 - New Member
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2075 - Regristrado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2076 - Admin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2077 - Admin Aliado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2078 - Server Admin Aliado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2079 - Server Admin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2080 - -- Vocações --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2081 - Elder Druid
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2082 - Master Sorcerer
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2083 - Royal Paladin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2084 - Elite Knight
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2085 - -- Warnings --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2086 - Warning 01
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2087 - Warning 02
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2088 - Warning 03
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2089 - -- Controle de Voz --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2090 - Force Push-To-Talk
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2091 - Force Mute
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2092 - -- TSBot --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2093 - TSBot Master Admin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2094 - TSBot Admin
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2095 - TSBot Kick
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2096 - TSBot Move
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2097 - TSBot Poke
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2098 - Online
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2099 - -- Extras --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2100 - Nao pagou GB
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2101 - Sem Maker
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2102 - Resp List Bloqueada (manual)
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2103 - Resp List Bloqueada
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2104 - Guild Bank
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2105 - Guild Bank (manual)
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2106 - No Kick
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2107 - Pode dar Reg
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2108 - Movedor
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2109 - Entrar Privado
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2110 - -- Makers --
[2020-04-04 13:48:49] [DEBUG]    33 | Push back group -> 2111 - Boss Checker
[2020-04-04 13:48:49] [DEBUG]    33 | [Property] Changing client property 'client_nickname' for 1 (New value: serveradmin, SQL: UPDATE `clients` SET `lastName` = :value WHERE `serverId` = :serverId AND `cldbid` = :cldbid)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 4 | 0 ([cspacer04]Default Channel)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 5 | 4 ([*lspacer10204]▂)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 7 | 5 (╔═● Master Admin Room)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 8 | 7 (╠═● Server Admin Room)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 9 | 8 (╠═● Regras Gerais)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 10 | 9 (╠═● Forgotten Knowledge)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 11 | 10 (╠═● Ferumbras Ascendant)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 12 | 11 (╠═● Rashid (Edron) & Djinn)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 13 | 12 (╠═● Garrafas Roshamuul)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 14 | 13 (╠═● Imbuiments)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 18 | 14 (╚═● Map)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 19 | 18 ([*lspacer10224]▂)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 20 | 19 ([cspacer] ✖ Friend List (0) ✖)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 32 | 20 ([*lspacer70224]▂)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 33 | 32 ([cspacer] ✖ Private 01 ✖)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 34 | 33 ([cspacer] ✖ Private 02 ✖)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 35 | 34 ([cspacer] ✖ Private 03 ✖)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 36 | 35 ([*lspacer20207]▂)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 37 | 36 (Channel War 01)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 38 | 37 (Channel War 02)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 39 | 38 (Channel 01)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 40 | 39 (Channel 02)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 41 | 40 (Channel 03)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 42 | 41 (Channel 04)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 43 | 42 (Channel 05)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 44 | 43 (Channel 06)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 45 | 44 (Channel 07)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 46 | 45 (Channel 08)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 47 | 46 (Channel 09)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 48 | 47 (Channel 10)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 49 | 48 (Channel 11)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 50 | 49 (Channel 12)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 51 | 50 (Channel 13)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 52 | 51 (Channel 14)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 53 | 52 (Channel 15)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 54 | 53 (Channel 16)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 55 | 54 (Channel 17)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 56 | 55 (Channel 18)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 57 | 56 (Channel 19)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 58 | 57 (Channel 20)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 59 | 58 ([*lspacer10304]▂)
[2020-04-04 13:48:49] [DEBUG]    33 |  - 60 | 59 (AFK)
from the logs, appear that the server started normally.
 
Last edited:

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Code:
I had a channel on template server that was named "xxxxxx" with description "yyyyyyy"
when I create a new server it replaces the channel name "xxxxxx" to "zzzzzzz" and description with content from another already up and running server.
This seems more like something is messed up in your database.
Could you may give me your database (PM!)?
As well try to reproduce that on a fresh installed TeaSpeak.
 

lbenicio

Well-known member
On this version {"build_name": "1.4.8-beta-9", "build_version": "1.4.8-beta", "build_index": 9} i have tested on a newly created server and the problem happeneded, i had to create a new server on a older version (dont remember which one), modify the template server then update to 1.4.8-beta-9. Im unable to install windows right now, maybe in 3-4 days i will have a notebook with windows to test it.

i will send you pm with the google drive link to download the db
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Yeahr, well I mean if in some version the database hasn't been cleaned up after server deletion this data will be still persistent.
Because on new server creation the default server will be copied and then loaded like an normal server.
But if there was already some data, some kind of undefined merge will happen.
 

lbenicio

Well-known member
OK, so, after each instance deletation I should clean the db? Like, make sure that the all row rows on all tables related to that instance are really deleted? (I haven't checked the db structure but should be easy automate this)
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
In theory yes like:
Code:
DELETE FROM `table...` WHERE `serverId` NOT IN (SELECT `serverId` from `servers`);
(There might be a typo but in general this should work.
 

lbenicio

Well-known member
I believe this is happening because I'm using SQLite DB on production... I will convert it to MySQL, add an action to run a clean query to sanitize the DB.

thanks for the help!!
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Code:
Result: query executed successfully. Took 13ms, 450 rows affected
At line 1:
DELETE FROM `properties` WHERE `serverId` NOT IN (SELECT `serverId` from `servers`);
So there were just some properties from "dead"/deleted servers.
Just execute my query and new servers should create perfectly ;)
 

lbenicio

Well-known member
From what I understood I should run this query on all tables except for the servers table after each instance delete? But as I'm using the sqlite, I can't run it outside teaspeak process to avoid concurrency problem of sqlite. So I migrate to mysql and made a script to run after each event of instance delete
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Yep, but there is no need to do that often^^
Once should be enough. In general server data will get cleaned up.
Only if the server for example crashes while deleting the server it could happen.

MySQL in in general more unstable because in case of a connection loss the server will stop as well...
 

REDOSS

TeaSpeak Team
Staff member
TeaTeam
I will close this topic, if the topic is relevant, please create a new topic or contact me to open it for comments.
New virtual servers should be created without problems, as this has been improved in recent versions.