crash server 3.0.13.2

[Gendos]

Hello. Today my server has been crashed, in logs this error. How to avoid in the future?

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

 

[dedmen]

Look at the file sql/client_update_traffic_stats.sql. Does it seem corrupt? Redownload it.

 

[Gendos]

Look at the file sql/client_update_traffic_stats.sql. Does it seem corrupt? Redownload it.

all fine, file have next sytax

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]

Maybe the server doesnt have read access to the file?... Cant think of anything else

 

[Gendos]

ls -la

-rw-r--r--. 1 ts3server ts3server

all files have user ts3server​

 

[hostmod]

Hello. Today my server has been crashed, in logs this error. How to avoid in the future?

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!!

 

[hostmod]

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?

2016-08-24 22:23:48.609838|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed

 

[freets3.ovh]

You've already put your question here. : https://r4p3.net/threads/crash-server-3-0-13-2.2937

 

[0x0539]

I had the same error today, and then my server crashed!!

Try updating to 3.0.13.3 since it crashed anyway.

 

[Gendos]

Try updating to 3.0.13.3 since it crashed anyway.

I try, same on 3.0.13.3

 

[0x0539]

I try, same on 3.0.13.3

Clean install or overwrite?

 

[Gendos]

Clean install or overwrite?

clean + my database

 

[0x0539]

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]

Try updating to 3.0.13.3 since it crashed anyway.

Mine is in 3.0.13.3. Clean installation!

 

[hostmod]

Today again I had the same problem, my server crashed and was logs this error!

2016-08-25 18:15:11.737265|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_get_by_uid.sql) failed

 

[jarmenso]

I upgraded to "3.0.13.3" version BUT 10 minutes later server crashes

 

[0x0539]

I upgraded to "3.0.13.3" version BUT 10 minutes later server crashes

Post your logs.

 

[hostmod]

Post your logs.

Brother, about my mistakes, you don't know what might be causing it?

 

[0x0539]

Brother, about my mistakes, you don't know what might be causing it?

Not unless you post logs.

 

[hostmod]

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.

2016-08-24 22:23:48.609838|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/client_update_traffic_stats.sql) failed

And that was today, happened again.

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.