Membership Contributions fail in 4.3.x with DB Error

[Martin Fuggle]

I have three contribution types; one for membership payments and two others for donations where there is no concept of membership. On upgrading to 4.3.x from 4.2.9 the contributions that do not involve membership work just fine. However the contribution for the payment of membership fees fails with the following DB Error:

Code: [Select]

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
I have been grappling with this issue for a while and cannot find any solution. The BackTrace is here:

Code: [Select]

#0 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB.php(972): PEAR_Error->PEAR_Error("DB Error: a515ac9c2796ca0e23adbe92c68fc9fc", "a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#4 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error("a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#5 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, "a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
#6 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError("a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, NULL, "1153 ** Got a packet bigger than 'max_allowed_packet' bytes")
#7 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#9 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#10 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#11 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(131): CRM_Core_DAO->save()
#13 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(199): CRM_Core_BAO_Cache::setItem((Array:15), "CiviCRM Session", "CiviCRM_CRM_Contribute_Controller_Contribution_e6db093cb88ea31d93fbf3440e1507...")
#14 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Session.php(539): CRM_Core_BAO_Cache::storeSessionToCache((Array:2), TRUE)
#15 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(295): CRM_Core_Session::storeSessionObjects()
#16 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:15))
#17 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#18 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/drupal/civicrm.module(354): CRM_Core_Invoke::invoke((Array:3))
#19 [internal function](): civicrm_invoke("contribute", "transact")
#20 /home/pobfsjv/public_html/quinstest/includes/menu.inc(350): call_user_func_array("civicrm_invoke", (Array:2))
#21 /home/pobfsjv/public_html/quinstest/index.php(17): menu_execute_active_handler()
#22 {main}
After displaying the error I then see the following BackTrace:

Code: [Select]

#0 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB.php(972): PEAR_Error->PEAR_Error("DB Error: a515ac9c2796ca0e23adbe92c68fc9fc", "a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#4 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error("a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#5 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, "a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
#6 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError("a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, NULL, "1153 ** Got a packet bigger than 'max_allowed_packet' bytes")
#7 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#9 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#10 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#11 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#12 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(131): CRM_Core_DAO->save()
#13 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(199): CRM_Core_BAO_Cache::setItem((Array:15), "CiviCRM Session", "CiviCRM_CRM_Contribute_Controller_Contribution_e6db093cb88ea31d93fbf3440e1507...")
#14 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Session.php(539): CRM_Core_BAO_Cache::storeSessionToCache((Array:2), TRUE)
#15 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Utils/System.php(1212): CRM_Core_Session::storeSessionObjects()
#16 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Error.php(822): CRM_Utils_System::civiExit(1)
#17 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Error.php(207): CRM_Core_Error::abend(1)
#18 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#19 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#20 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB.php(972): PEAR_Error->PEAR_Error("DB Error: a515ac9c2796ca0e23adbe92c68fc9fc", "a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#21 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error("a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#22 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, "a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, "INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...", "DB_Error", TRUE)
#23 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError("a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, NULL, "1153 ** Got a packet bigger than 'max_allowed_packet' bytes")
#24 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#25 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#26 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#27 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_cache (group_name , path , data , created_date ) VALUES (...")
#28 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/DAO.php(287): DB_DataObject->insert()
#29 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(131): CRM_Core_DAO->save()
#30 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php(199): CRM_Core_BAO_Cache::setItem((Array:15), "CiviCRM Session", "CiviCRM_CRM_Contribute_Controller_Contribution_e6db093cb88ea31d93fbf3440e1507...")
#31 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Session.php(539): CRM_Core_BAO_Cache::storeSessionToCache((Array:2), TRUE)
#32 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(295): CRM_Core_Session::storeSessionObjects()
#33 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:15))
#34 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#35 /home/pobfsjv/public_html/quinstest/sites/all/modules/civicrm/drupal/civicrm.module(354): CRM_Core_Invoke::invoke((Array:3))
#36 [internal function](): civicrm_invoke("contribute", "transact")
#37 /home/pobfsjv/public_html/quinstest/includes/menu.inc(350): call_user_func_array("civicrm_invoke", (Array:2))
#38 /home/pobfsjv/public_html/quinstest/index.php(17): menu_execute_active_handler()
#39 {main}
I am trying to upgrade from Drupal 6/CiviCRM4.2.9 to Drupal7/CiviCRM4.3.3 and can't get past the CiviCRM upgrade.

Cheers
Martin Fuggle[/code]

[Eileen]

There is mention of max_allowed_packet in that error message - I'd try playing with that

https://www.google.co.nz/search?q=max_allowed_packet&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

[Martin Fuggle]

Hi Eileen - Thanks for that. I had eventually realised that myself and started to see how I can change the setting but the hosting provider that I use has a limit of 1MByte and won't increase it so it looks as if I need to change my hosting provider. Any suggestions?

Cheers
Martin Fuggle

[Martin Fuggle]

Does anyone know what the max_allowed_packet_size setting should be to accommodate CiviCRM?

Cheers
Martin Fuggle

[bpmccain]

Anything on this? I seem to be running into a similar problem with 4.3.

http://forum.civicrm.org/index.php/topic,29196.0.html

[Eileen]

There's no hard & fast rule - I'd suggesting seeing what it is & doubling it. I do know that the default (16MB) is too low

[Martin Fuggle]

I switched from Totalchoice Hosting whose setting was 1MByte to CiviHosting and their default setting is 32MBytes and I have had no problems since the switch.

Regards
Martin Fuggle

[bpmccain]

I'm already at 512MB, so I don't think it has anything to do with my memory limit.

Brian

[Martin Fuggle]

It's nothing to do with your php memory limit. It is the MySQL max_allowed_packet which needs to be increased and in a shared hosting environment that can only be set by the hoster's sysadmin.

Cheers
Martin Fuggle

[bpmccain]

Thanks Martin. That solved it. It wasn't defined in my.cnf, and so it seemed to default to 1MB. I increased it to 16MB, and everything is working fine now.

I may move up to 32 as suggested below.

Brian