Author Topic: Backtraces (Read 1652 times)

mcsmom · December 09, 2008, 05:36:32 am

Hi,

I'm having a bunch of problems with search where I'm getting tremendous backtraces and messages like
Sorry. A non-recoverable error has occurred.

Quote

DB Error: unknown error

Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213

Return to home page.

Error Details:

Array
(
[callback] => Array
(

=> CRM_Core_Error
[1] => handle
)

Code: [Select]
=> -1 [message] => DB Error: unknown error [mode] => 16 [debug_info] => REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (2,751),(2,914),(2,921),(2,922),(2,923); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction] [type] => DB_Error [user_info] => REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (2,751),(2,914),(2,921),(2,922),(2,923); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction] [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (2,751),(2,914),(2,921),(2,922),(2,923); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"] ) [/quote] Since this is a live site of course I don't have backtrace on. Is there anyway I can get it not to show this to my users? I really don't like seeing my paths exposed to the public. Second, what is the story with the database deadlock? I have never experienced this before and have no idea what to do. Elin

Donald Lobo · December 09, 2008, 09:57:56 am

is this error reproducible? does it happen when there is a significant load on the system?

I'll chat with you on IM to get more details. not seen the deadlock error before, but i think we do need to start using 'locks' when accessing the group_contact_cache

lobo

jday · November 09, 2011, 12:29:53 pm

I get the error if two people are both trying to create an organic group at the same time or one is creating a group and one is trying to send a mailing. Solution seems to be just wait a while and try again.

Code: [Select]

Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213

Additional Details:

Array ( [callback] =&gt; Array ( [0] =&gt; CRM_Core_Error [1] =&gt; handle ) [code] =&gt; a515ac9c2796ca0e23adbe92c68fc9fc [message] =&gt; DB Error: a515ac9c2796ca0e23adbe92c68fc9fc [mode] =&gt; 16 [debug_info] =&gt; REPLACE INTO civicrm_group_nesting (child_group_id, parent_group_id) VALUES (174,6); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction] [type] =&gt; DB_Error     [user_info] =&gt; REPLACE INTO civicrm_group_nesting (child_group_id, parent_group_id) VALUES (174,6); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction] [to_string] =&gt; [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="REPLACE INTO civicrm_group_nesting (child_group_id, parent_group_id) VALUES (174,6); [nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"] )

CiviCRM Community Forums (archive)

News:

Author Topic: Backtraces (Read 1652 times)

mcsmom

Backtraces

Donald Lobo

Re: Backtraces

jday

Database Error Code: Deadlock found when trying to get lock; try restarting ...