Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-7095

mysql value sort_buffer_size error when creating event

    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]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              stoob Stoob
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: