Bug 4.50e, Query Failed:INSERT into emails set id=

[Elmerbug]

Folks, 1 particular email causes SugarCRM email Group Inbox to crash as follows. This appears to be the same bug as 7500, logged early in 2006.

O/S 2.6.17.11-1.1.x86
Sugar OSS Version 4.5.0e (Build 1185)


Query Failed:INSERT into emails set id='8ee737ca-7521-3f7e-a6f3-4540c16b91ec', date_entered='2006-10-26 14:12:09', date_modified='2006-10-26 14:12:09', assigned_user_id='ba82b70f-8bac-b477-31ee-4522b0f2aeaf', modified_user_id='109d0603-826e-448a-f990-451e7cff1f11', created_by='109d0603-826e-448a-f990-451e7cff1f11', name='FW: VSI102020060001 Microsoft LCS Interop [Case:80]', date_start='2006-10-25', time_start='12:07:00', description='\r\n> \r\n> ----------\r\n> From: Don Couchman\r\n> Sent: Wednesday, October 25, 2006 9:06:40 PM\r\n> To: support\r\n> Subject: VSI102020060001 Microsoft LCS Interop [Case:80]\r\n> Auto forwarded by a Rule\r\n> \r\n \r\n\r\n _____ \r\n\r\nFrom: George Gudz (Volt) [mailto:a-georgg@microsoft.com] \r\nSent: Wednesday, October 25, 2006 10:25 AM\r\nTo: Don Couchman\r\nSubject: RE: CLI command\r\n\r\n \r\n\r\nHi Don, \r\n\r\n \r\n\r\nadmin >show support\r\n\r\n \r\n\r\n------------------------------------------------------------------------\r\n---------\r\n\r\n>>>>>>>> SHOW BANNER\r\n\r\n------------------------------------------------------------------------\r\n---------\r\n\r\n \r\n\r\n---------------------------------------------------------\r\n\r\n-- Version: 10.02.08.0a VEGA400 Runtime System\r\n\r\n-- Serial #: 0050580012c4\r\n\r\n--\r\n\r\n-- ***** UNLICENSED ENGINEERING BUILD - NOT FOR EXTERNAL RELEASE *****\r\n\r\n--\r\n\r\n-- (c) 1998-2006 VegaStream Limited. All rights reserved.\r\n\r\n---------------------------------------------------------\r\n\r\n \r\n\r\nHost name:Vega400 IP address:172.29.104.195\r\n\r\n IP address:255.255.255.255(D)\r\n\r\n \r\n\r\nSystem licensed for 96 VoIP channels\r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n------------------------------------------------------------------------\r\n---------\r

[cburn]

I was able to get the email to stop erroring by editing the my.cnf file and adding the following text:

[mysqld]
set-variable = max_connections=512
set-variable = max_user_connections=45
set-variable = wait_timeout=360
set-variable = key_buffer=16M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=3M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = max_allowed_packet=64M

That seemed to be a decent workaround. But the real problem still remains.

Any advice would be useful.