CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Database corruption or session errors?
Pages: [1]

Author Topic: Database corruption or session errors?  (Read 928 times)

myles

  • I post frequently
  • ***
  • Posts: 263
  • Karma: 11
Database corruption or session errors?
May 01, 2009, 01:48:45 am
Over the last three weeks we have been having problems on updating records. These problems are irratic, but getting worse. It is almost to the point of stopping work.

Example errors:

"Could not find value for group id"
"could not find value for ct"
and another error that I will put in here when I can find it! Has to do with groups of in-line data items getting 'misplaced' on editing a record

They occur on creation and on updating (the first a multiple custom data group), contacts and activities.

Sometimes when creating a new email it will apparently' lose the connection' between the contact and the email - or 'lose' the activity type.

This has not followed any code upgrades (we're on 2.2.2).

Having read all posts I can find on similar issues my most likely candidate is a session error.

So far I've increased the memory available in the php.ini; flushed all the caches (Drupal performance caches and Views 2); checked the domain reference is correct (base url etc..)

There seems no difference between logging in as admin or other user...

My next steps will be to attempt to turn on and examine mysql logging and to dump the database(s) into a development environment on the same server to see if that is any different. I've not been able to recreate errors on a local server, or the development/playing-with-new-features site that is on the same server but is now a little behind the production site.

If so it may indicate that it is worth carrying out a completely fresh install of both drupal and civicrm.

I'd love to know what this is about though, and I'd love to save my week-end.

If it is a session problem, does anyone know of a good way to address this - as in steps to identify the problem, of not a solution.

Thanks,

Myles


 


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Database corruption or session errors?
May 01, 2009, 06:59:28 am

couple of random thoughts and things to do:

1. ensure your session table in drupal is utf8

2. truncate your session table for all users and see how long it takes to get back to the "flaky state". I suspect your sessions are getting too big and might be hitting some mysql errors

3. when u get one of the errors, delete the session table for that user and try again

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

myles

  • I post frequently
  • ***
  • Posts: 263
  • Karma: 11
Re: Database corruption or session errors?
May 01, 2009, 12:03:22 pm
Seems spot on, and wonderfully simple for me to implement.

Yes the tables were in utf8; Truncating the drupal session table seems to have sorted the problem.

At least I have not yet had an occurrence of problems that had become very frequent -  so it looks as though I may get some time to myself this week end

Thanks Lobo!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Database corruption or session errors?

This forum was archived on 2017-11-26.