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

Completed Could not shutdown query client socket

Saci

Fanatic member
Premium User
[2018-12-11 20:56:23] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Failed to execute sql command: 1/constraint failed[0m
[2018-12-12 02:00:20] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Missed out thread detachment! This could lead to memory leaks![0m
[2018-12-13 10:14:13] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31mQUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)[0m
[2018-12-13 20:30:46] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31mQUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)[0m

how fix it? help me please , im using last version 1.2.31-beta-2
 

websat

Well-known member
Hi,

Are you doing the logout over a php script?
for example ts3admin.class.php ??
Here is the connection faster than the teaspeak gets. But that is not to the detriment of the teapeak servers

I changed that in the file that way

private function quit () {
// $ this-> logout ();
// @fputs ($ this-> runtime ['socket'], "quit \ n");
@socket_shutdown ($ this-> runtime ['socket'], 2);
@socket_close ($ this-> runtime ['socket']);
// @fclose ($ this-> runtime ['socket']);
}
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator

[2018-12-11 20:56:23] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Failed to execute sql command: 1/constraint failed[0m

This is critical and means that something is going horrible wrong, and some database entries wound be saved.
The server is usually restarting then.
Code:
[2018-12-12 02:00:20] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Missed out thread detachment! This could lead to memory leaks![0m
How often does this happen?


Code:
[2018-12-13 20:30:46] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31mQUERY | Could not shutdown query client socket! 107 (Transport endpoint is not connected)[0m
This is nothing critical. Actually should be moved to debug
 

Saci

Fanatic member
Premium User
This is happening every 48 to 72 hours.
get it too today
[2018-12-14 09:59:37] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Missed out thread detachment! This could lead to memory leaks![0m

dedicated to 1 teaspeak sever with 55 instances
Icon name: computer-desktop
Chassis: desktop
Intel(R) Core(TM) i3-2130 CPU @ 3.40GHz
MemTotal: 8062960 kB
MemFree: 7004180 kB

the best would be to recreate this complete server because of the error in the database?
 
Last edited:

WolverinDEV

TeaSpeak Team
Staff member
Administrator
This is happening every 48 to 72 hours.
get it too today
[2018-12-14 09:59:37] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m GEN | Missed out thread detachment! This could lead to memory leaks![0m

dedicated to 1 teaspeak sever with 55 instances
Icon name: computer-desktop
Chassis: desktop
Intel(R) Core(TM) i3-2130 CPU @ 3.40GHz
MemTotal: 8062960 kB
MemFree: 7004180 kB

the best would be to recreate this complete server because of the error in the database?
No definitively not, this should not a permanent error, but there is may some data corruption or loss, but that shall not be that significant :)