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

Pending Few critical errors in server log

REDOSS

TeaSpeak Team
Staff member
TeaTeam
Every two weeks I check my server for critical errors in the server log and have encountered such entries.

Code:
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_servergroup_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:50] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:50] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:50] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_servergroup_permission_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:50] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:50] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:51] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_servergroup_client_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:51] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:51] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_channelgroup_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:52] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:52] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:52] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_channelgroup_permission_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:52] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:52] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:09:53] [DEBUG]     2 | [Permission]    Permission: b_virtualserver_channelgroup_client_list Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:09:53] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:09:53] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:14] [WARNING]   GEN | Timer VoiceClient::tick needs more than 3529 microseconds. Max allowed was 3000 microseconds.
[2019-10-31 17:10:14] [WARNING]     5 | Ticking of client IP:23039 (Pushkar) needs more that 2500 microseconds! (4041 microseconds)
[2019-10-31 17:10:21] [WARNING]   GEN | Timer VoiceClient::tick needs more than 7532 microseconds. Max allowed was 3000 microseconds.
[2019-10-31 17:10:21] [WARNING]     5 | Ticking of client IP:56837 (AVALADIK_BY) needs more that 2500 microseconds! (7574 microseconds)
[2019-10-31 17:10:43] [ERROR]     5 | [IP:3073/ne4ehbka | 14] Handling of packet Voice needs more than 10ms (18ms)
[2019-10-31 17:10:48] [DEBUG]     5 | [IP:59804/Arteezy_F20 (Саня) | 17] Got packet of type Command which is out of the buffer range of 32 (underflow). Packet ID: 54, Current index: 55. Dropping packet
[2019-10-31 17:10:49] [DEBUG]     5 | [IP:62272/ỖβĴĮĮϋĮỖŇ | 3] Got packet of type Command which is out of the buffer range of 32 (underflow). Packet ID: 800, Current index: 801. Dropping packet
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:52] [DEBUG]     2 | [Permission]    Permission: b_client_permissionoverview_view Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:52] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:52] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: b_client_permissionoverview_own Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:53] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:53] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:53] [DEBUG]     2 | [Permission]    Permission: b_client_remoteaddress_view Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:53] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:53] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:54] [DEBUG]     2 | [Permission]    Permission: i_client_serverquery_view_power Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:55] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:55] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:55] [DEBUG]     2 | [Permission]    Permission: i_client_needed_serverquery_view_power Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:55] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:55] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission]    Permission: i_client_permission_modify_power Required value: 75 Gained value: 75 Force required: 1 Channel: none Result: 1
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission] Value test result for test type 1.
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission]    Permission: b_permission_modify_power_ignore Required value: 1 Gained value: -2 Force required: 1 Channel: Определение респауна Result: 0
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission] Grant test result for test type 1.
[2019-10-31 17:10:56] [DEBUG]     2 | [Permission]    Permission: b_client_custom_info_view Required value: 1 Gained value: 75 Force required: 1 Channel: Определение респауна Result: 1
[2019-10-31 17:10:56] [DEBUG]     2 | Saved client permissions for client 8510 (bullet) in 0ms
[2019-10-31 17:10:56] [[1m[7m[0;31mCRITICAL] [1m[7m[0;31m  GEN | Failed to execute sql command: 1/constraint failed (/workspace/TeaSpeak-Parent_master-FRUL5U2YEGMIHINML2BZCK6KBI6I4EHNXBFX3JFUSZG2NLVUAXHA@2/TeaSpeak/server/src/DatabaseHelper.cpp:407)[0m
 

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Code:
Failed to execute sql command: 1/constraint failed
This is more or less ignoreable, depending on which SQL command fails.
But manly for permissions its kind of okey :D
 

REDOSS

TeaSpeak Team
Staff member
TeaTeam
Code:
Failed to execute sql command: 1/constraint failed
This is more or less ignoreable, depending on which SQL command fails.
But manly for permissions its kind of okey :D
But if you noticed, this error occurred only for one user and always on the same channel :)