Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 3.3.beta
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
Never seen this one before, getting a fatal error when trying to create an event. This is new to 3.3 to my knowledge. While I'm not an expert on this MYSQL value "sort_buffer_size" it does seem a bit bizarre this requirement would change from Civi version to version. Is a warning necessary with the install of 3.3 CiviCRM that this value should be increased on everyone's servers? Or does this error provide us with a hint that a particular query needs optimizing?
<b>Here were my values.</b>
OLD (generates error in 3.3 but did not in 3.2)
sort_buffer_size = 32776
NEW INCREASED (doesn't generate error)
sort_buffer_size = 65536
DEFAULT MYSQL Value
sort_buffer_size = 2048
For what it's worth, the mysql tuning script I am using doesn't recommend increasing this sort_buffer_size value when set to 32K or 64K
Sorry. A non-recoverable error has occurred.
DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
Error Details
Database Error Code: Out of sort memory; increase server sort buffer size, 1038
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => a515ac9c2796ca0e23adbe92c68fc9fc
[message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
[mode] => 16
[debug_info] =>
SELECT CONCAT_WS(' :: ' , ca.name, ca.street_address, ca.city, sp.name) title, ce.loc_block_id
FROM civicrm_event ce
INNER JOIN civicrm_loc_block lb ON ce.loc_block_id = lb.id
INNER JOIN civicrm_address ca ON lb.address_id = ca.id
LEFT JOIN civicrm_state_province sp ON ca.state_province_id = sp.id
ORDER BY sp.name, ca.city, ca.street_address ASC
[nativecode=1038 ** Out of sort memory; increase server sort buffer size]
[type] => DB_Error
[user_info] =>
SELECT CONCAT_WS(' :: ' , ca.name, ca.street_address, ca.city, sp.name) title, ce.loc_block_id
FROM civicrm_event ce
INNER JOIN civicrm_loc_block lb ON ce.loc_block_id = lb.id
INNER JOIN civicrm_address ca ON lb.address_id = ca.id
LEFT JOIN civicrm_state_province sp ON ca.state_province_id = sp.id
ORDER BY sp.name, ca.city, ca.street_address ASC
[nativecode=1038 ** Out of sort memory; increase server sort buffer size]
[to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT CONCAT_WS(' :: ' , ca.name, ca.street_address, ca.city, sp.name) title, ce.loc_block_id
FROM civicrm_event ce
INNER JOIN civicrm_loc_block lb ON ce.loc_block_id = lb.id
INNER JOIN civicrm_address ca ON lb.address_id = ca.id
LEFT JOIN civicrm_state_province sp ON ca.state_province_id = sp.id
ORDER BY sp.name, ca.city, ca.street_address ASC
[nativecode=1038 ** Out of sort memory; increase server sort buffer size]"]
)