Community Forums Today's Posts     Member List     Archive    
Results 1 to 9 of 9
  1. 04-12-2011, 19:19 #1
    Master_D
    Master_D is offline -= TeamSpeak Addict =-
    Join Date
    Dec 2009
    Location
    Germany
    Posts
    205

    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.
    Reply With Quote Reply With Quote
  2. 05-12-2011, 07:50 #2
    dante696
    dante696 is offline -= TeamSpeak Team =-
    Join Date
    Jun 2008
    Posts
    7,773
    Please give us more informations!

    Server version and what have you done with your databse, to get this crash?
    ---------------------------------------------------------
    Please don't send me private messages with support questions as long I or someone else from Teamspeak Staff asked for it.
    Seriously > They belong into the forum and maybe other users have these questions/problems too.

    TeamSpeak FAQ || What should i report, when i open a client thread? || Report and upload your Crashdump here
    NPL License (Registration)
    Reply With Quote Reply With Quote
  3. 05-12-2011, 13:34 #3
    Master_D
    Master_D is offline -= TeamSpeak Addict =-
    Join Date
    Dec 2009
    Location
    Germany
    Posts
    205
    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.
    Reply With Quote Reply With Quote
  4. 05-12-2011, 14:44 #4
    dante696
    dante696 is offline -= TeamSpeak Team =-
    Join Date
    Jun 2008
    Posts
    7,773
    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
    ---------------------------------------------------------
    Please don't send me private messages with support questions as long I or someone else from Teamspeak Staff asked for it.
    Seriously > They belong into the forum and maybe other users have these questions/problems too.

    TeamSpeak FAQ || What should i report, when i open a client thread? || Report and upload your Crashdump here
    NPL License (Registration)
    Reply With Quote Reply With Quote
  5. 06-12-2011, 08:15 #5
    dante696
    dante696 is offline -= TeamSpeak Team =-
    Join Date
    Jun 2008
    Posts
    7,773
    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
    ---------------------------------------------------------
    Please don't send me private messages with support questions as long I or someone else from Teamspeak Staff asked for it.
    Seriously > They belong into the forum and maybe other users have these questions/problems too.

    TeamSpeak FAQ || What should i report, when i open a client thread? || Report and upload your Crashdump here
    NPL License (Registration)
    Reply With Quote Reply With Quote
  6. 06-12-2011, 13:11 #6
    Master_D
    Master_D is offline -= TeamSpeak Addict =-
    Join Date
    Dec 2009
    Location
    Germany
    Posts
    205
    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.
    Reply With Quote Reply With Quote
  7. 06-12-2011, 13:26 #7
    Master_D
    Master_D is offline -= TeamSpeak Addict =-
    Join Date
    Dec 2009
    Location
    Germany
    Posts
    205
    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.
    Reply With Quote Reply With Quote
  8. 06-12-2011, 14:57 #8
    dante696
    dante696 is offline -= TeamSpeak Team =-
    Join Date
    Jun 2008
    Posts
    7,773
    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; 08-12-2011 at 14:28.
    ---------------------------------------------------------
    Please don't send me private messages with support questions as long I or someone else from Teamspeak Staff asked for it.
    Seriously > They belong into the forum and maybe other users have these questions/problems too.

    TeamSpeak FAQ || What should i report, when i open a client thread? || Report and upload your Crashdump here
    NPL License (Registration)
    Reply With Quote Reply With Quote
  9. 21-02-2012, 10:30 #9
    dante696
    dante696 is offline -= TeamSpeak Team =-
    Join Date
    Jun 2008
    Posts
    7,773
    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
    ---------------------------------------------------------
    Please don't send me private messages with support questions as long I or someone else from Teamspeak Staff asked for it.
    Seriously > They belong into the forum and maybe other users have these questions/problems too.

    TeamSpeak FAQ || What should i report, when i open a client thread? || Report and upload your Crashdump here
    NPL License (Registration)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MySQL and Ban error
    By ozman in forum [TeamSpeak 2] Server Support
    Replies: 5
    Last Post: 11-01-2007, 02:59
  2. TS + MySQL 4.0.27 ERROR
    By Nom4d3_ in forum [TeamSpeak 2] Server Support
    Replies: 5
    Last Post: 17-06-2006, 22:52
  3. Error with MySQL
    By charlie in forum [TeamSpeak 2] Server Support
    Replies: 0
    Last Post: 08-05-2006, 16:40
  4. "waveindevcaps specified device identifier out of range" error
    By CheroKee Cowboy in forum [TeamSpeak 2] Client Support
    Replies: 1
    Last Post: 17-01-2005, 12:03

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
  •  

Forum Rules