Forum

Results 1 to 9 of 9
  1. #1
    Join Date
    December 2009
    Location
    Germany
    Posts
    288

    Solved [MySQL] Error with value range

    2011-12-04 19:14:50.327960|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 0, clie error: Out of range value for column 'client_total_download' at row 1
    2011-12-04 19:14:50.328013|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    Server is crashing with this error on every download or upload-complete.

  2. #2
    Join Date
    June 2008
    Posts
    17,940
    Please give us more informations!

    Server version and what have you done with your databse, to get this crash?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  3. #3
    Join Date
    December 2009
    Location
    Germany
    Posts
    288
    Server-version is "3.0.1 (17.11.11 08:34) auf Linux"
    as mentioned, there is a mysql-database.
    and the mentioned errors appearing on every finished filetransfer.

    2011-12-04 19:08:37.199966|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 0, clie error: Out of range value for column 'client_total_download' at row 1
    2011-12-04 19:08:37.200031|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    2011-12-04 19:08:11.314921|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.rar' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 19:08:11.315889|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r10' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 19:14:50.327960|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 0, clie error: Out of range value for column 'client_total_download' at row 1
    2011-12-04 19:14:50.328013|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    2011-12-04 19:09:38.261848|INFO |VirtualServer | 3| file download from (id:**), '/WoWScrnShot_120411_180038.jpg' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 19:12:28.567332|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r00' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 19:02:15.549473|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 19:02:15.609503|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 0, clie error: Out of range value for column 'client_total_download' at row 1
    2011-12-04 19:02:15.609561|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    2011-12-04 18:59:07.716736|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r09' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:59:07.718170|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.rar' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:40:04.024212|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:40:23.821848|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:45:23.233749|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:45:46.161413|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:49:56.966724|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:50:08.076879|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:53:38.677753|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:53:47.465045|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:56:50.402106|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:56:56.462154|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 18:56:56.582096|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 0, clie error: Out of range value for column 'client_total_download' at row 1
    2011-12-04 18:56:56.582136|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    2011-12-04 18:45:24.161328|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r05' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:45:48.069386|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r16' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:49:57.158892|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r06' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:50:09.321602|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r17' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:53:39.151959|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r07' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:53:48.256891|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r08' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 18:56:51.164793|INFO |VirtualServer | 3| file download from (id:**), '/WoWHD/WoW_3_3_5_a_Fix.r09' by client 'Necromonga | Willigis'(id:***)
    2011-12-04 16:09:53.646001|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:10:40.034420|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:12:34.880222|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:14:37.902211|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:16:28.103763|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:17:45.881255|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:19:25.067606|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv err
    or: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:20:50.924362|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:22:39.401810|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:24:07.175643|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:25:27.985293|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:28:09.189600|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:28:13.229784|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:30:34.864428|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:31:21.936817|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:33:07.900322|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 16:33:32.045239|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 0, serv error: Out of range value for column 'server_total_download' at row 1
    2011-12-04 17:51:33.667555|ERROR |DatabaseQuery | | db_exec() update servers set server_month_upload= server_month_upload + 1048576 error: Out of range value for column 'server_total_upload' at row 1
    2011-12-04 17:51:33.679348|ERROR |DatabaseQuery | | db_exec() update clients set client_month_upload= client_month_upload + 1048576 error: Out of range value for column 'client_total_upload' at row 1
    2011-12-04 17:51:33.679379|CRITICAL|DatabaseQuery | | Assertion "error == ERROR_ok" failed at server/serverlib/database/db_database.cpp:113;
    Quoted all Error-Messages, that are relevant for this problem.

    From my researches, the value of download and upload-values exceeds the int-datatype.

  4. #4
    Join Date
    June 2008
    Posts
    17,940
    Can you send me a dump of your database? So we can try to reproduce it?

    I have no idea, what does cause this error
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  5. #5
    Join Date
    June 2008
    Posts
    17,940
    I gave myself Sever Admin on your Server Admin and client permissions on a user, but i could not reproduce your problem.

    Code:
    06.12.2011 09:05:36	VirtualServer	Info	file upload to (id:1), '/DirLinker.exe' by client 'WerHätteDasGedacht'(id:664)	
    06.12.2011 09:05:38	VirtualServer	Info	file download from (id:1), '/DirLinker.exe' by client 'WerHätteDasGedacht'(id:664)	
    06.12.2011 09:06:02	VirtualServer	Info	file deleted from (id:1), 'files\virtualserver_1\channel_1\/DirLinker.exe' by client 'WerHätteDasGedacht'(id:664)
    Test 2 with a quota on client
    Code:
    06.12.2011 09:09:48	VirtualServer	Info	listening on 0.0.0.0:9987	
    06.12.2011 09:09:48	VirtualServer	Info	client connected 'WerHätteDasGedacht'(id:664) from 127.0.0.1:59773	
    06.12.2011 09:10:08	VirtualServer	Info	client connected 'Ultimate'(id:665) from 127.0.0.1:53097	
    06.12.2011 09:10:21	VirtualServer	Info	permission 'i_ft_quota_mb_upload_per_client'(id:24809) with values (value:5000) was added by 'WerHätteDasGedacht'(id:664) to client (id:665)	
    06.12.2011 09:10:24	VirtualServer	Info	permission 'i_ft_quota_mb_download_per_client'(id:24808) with values (value:5000) was added by 'WerHätteDasGedacht'(id:664) to client (id:665)	
    06.12.2011 09:10:27	VirtualServer	Info	permission 'i_ft_file_browse_power'(id:24804) with values (value:75) was added by 'WerHätteDasGedacht'(id:664) to client (id:665)	
    06.12.2011 09:10:33	VirtualServer	Info	permission 'i_ft_file_upload_power'(id:24796) with values (value:75) was added by 'WerHätteDasGedacht'(id:664) to client (id:665)	
    06.12.2011 09:10:39	VirtualServer	Info	permission 'i_ft_file_download_power'(id:24798) with values (value:75) was added by 'WerHätteDasGedacht'(id:664) to client (id:665)	
    06.12.2011 09:10:48	VirtualServer	Info	file upload to (id:1), '/teamspeak_data-2011-12-05.sql.zip' by client 'Ultimate'(id:665)	
    06.12.2011 09:10:57	VirtualServer	Info	file deleted from (id:1), 'files\virtualserver_1\channel_1\/teamspeak_data-2011-12-05.sql.zip' by client 'WerHätteDasGedacht'(id:664)	
    06.12.2011 09:11:43	VirtualServer	Info	client disconnected 'WerHätteDasGedacht'(id:664) reason 'reasonmsg=Server Shutdown!'	
    06.12.2011 09:11:43	VirtualServer	Info	client disconnected 'Ultimate'(id:665) reason 'reasonmsg=Server Shutdown!'	
    06.12.2011 09:11:43	VirtualServer	Info	stopped
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  6. #6
    Join Date
    December 2009
    Location
    Germany
    Posts
    288
    You 've seen, that this db has already a fix??

    In Tables client and server, all Transfer-fields (upload and download) has now Unsigned Bigint instead of unsigned Int !!

    because of this is happened the evening before this dump, and i've fixxed this already in the database, this is also in this dump. So change the value-types back and test it again. Then the crash should happen.

  7. #7
    Join Date
    December 2009
    Location
    Germany
    Posts
    288
    3, 9989, 1, , 3904571793, 3555932681, 4273616821, 4538496752
    The quote above is the row out of the server-table. Last value, row name is "server_total_download", is too high, the max-value for unsigned Int in Mysql is quoted below.

    INT[(M)] [UNSIGNED] [ZEROFILL]

    Integer normaler Größe. Der vorzeichenbehaftete Bereich liegt zwischen -2147483648 und 2147483647. Der vorzeichenlose Bereich liegt zwischen 0 und 4294967295.

  8. #8
    Join Date
    June 2008
    Posts
    17,940
    I still can't reproduce the crash, but I made a ticket for the 4GB limit for a quota.
    Ticket ID TS-805

    Edit > This is on our todo
    Last edited by dante696; December 8th, 2011 at 02:28 PM.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  9. #9
    Join Date
    June 2008
    Posts
    17,940
    Server 3.0.2 (2012-02-21 or newer) gets a fix for following tables and all values getting converted to "bigint(20) unsigned"

    Code:
    "clients"
    client_month_upload
    client_month_download
    client_total_upload
    client_total_download
    
    "servers"
    server_month_upload
    server_month_download
    server_total_upload
    server_total_download
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Resolved] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
    By Svenskunganka in forum Server Support
    Replies: 2
    Last Post: September 12th, 2013, 10:59 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •