crash server 3.0.13.2

Gendos

Member
Joined
Feb 15, 2016
Messages
39
Reaction score
8
Points
58
Hello. Today my server has been crashed, in logs this error. How to avoid in the future?

Code:
2016-08-19 09:55:49.311901|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed
 

dedmen

TeamSpeak Developer
Contributor
Joined
Mar 28, 2016
Messages
530
Reaction score
584
Points
197
Look at the file sql/client_update_traffic_stats.sql. Does it seem corrupt? Redownload it.
 

Gendos

Member
Joined
Feb 15, 2016
Messages
39
Reaction score
8
Points
58
Look at the file sql/client_update_traffic_stats.sql. Does it seem corrupt? Redownload it.
all fine, file have next sytax

Code:
update clients set
client_month_upload= client_month_upload + :upload:,
client_month_download= client_month_download + :download:,
client_total_upload= client_total_upload + :upload:,
client_total_download= client_total_download + :download:
where client_id=:client_id:;
version server 3.0.13.2
 

dedmen

TeamSpeak Developer
Contributor
Joined
Mar 28, 2016
Messages
530
Reaction score
584
Points
197
Maybe the server doesnt have read access to the file?... Cant think of anything else
 

Gendos

Member
Joined
Feb 15, 2016
Messages
39
Reaction score
8
Points
58
ls -la
Code:
-rw-r--r--. 1 ts3server ts3server
all files have user ts3server​
 

hostmod

Member
Joined
Aug 21, 2016
Messages
19
Reaction score
2
Points
35
Hello. Today my server has been crashed, in logs this error. How to avoid in the future?

Code:
2016-08-19 09:55:49.311901|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed
I had the same error today, and then my server crashed!!

95bd7c8fd16b490691af1592ce9765fd.png
 

hostmod

Member
Joined
Aug 21, 2016
Messages
19
Reaction score
2
Points
35
Yesterday my server went down, I went to see in the logs had this error, can anyone help me so that doesn't happen again please?
Code:
2016-08-24 22:23:48.609838|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed
 

0x0539

Retired Staff
Contributor
Joined
Jan 30, 2016
Messages
1,334
Reaction score
1,146
Points
254
I can only think of your database being corrupt, try a complete new install and see if your issue still exists, if it doesn't your database is corrupt.
 

hostmod

Member
Joined
Aug 21, 2016
Messages
19
Reaction score
2
Points
35
Today again I had the same problem, my server crashed and was logs this error!
Code:
2016-08-25 18:15:11.737265|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_get_by_uid.sql) failed
 

jarmenso

Member
Joined
Aug 2, 2016
Messages
25
Reaction score
0
Points
33
I upgraded to "3.0.13.3" version BUT 10 minutes later server crashes
 

hostmod

Member
Joined
Aug 21, 2016
Messages
19
Reaction score
2
Points
35
Not unless you post logs.
Already posted up there. My server crashed and in the logs showed these errors.


Here was the first time that happened.
Code:
2016-08-24 22:23:48.609838|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed

And that was today, happened again.
Code:
2016-08-25 18:15:11.737265|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_get_by_uid.sql) failed

* My server is at version 3.0.13.3
* Clean install.
 
Top