Ultimate Member is crashing my site!

Hi!

Ultimate Member has been overloading the mySQL database on my site leading to the “error establishing database connection” error – this has happened sometimes up to three times a day over the last week or two.

A support technician suggested I try rolling back Ultimate Member to a previous version (1.3.81) which seemed to be working, but my site crashed again last night and again this morning.

My hosts provided this information – it looks like the problem is with a birthday meta but I’m not using that meta anywhere on my site (that I’m aware of) – I’ve checked and triple checked and can’t find where it’s being called.

I really appreciate any help!!!

    Id     User         Host/IP        DB   Time     %    Cmd           State Query
       --     ----         -------        --   ----     -    ---           ----- ----------
 14116476 dogfoste       localhost dogfoste_  18551   0.0  Query      statistics SELECT DISTINCT SQL_CALC_FOUND_ROWS wpxa_users.ID FROM wpxa_users LEFT JOIN wpxa_usermeta ON ( wpxa_users.ID = wpxa_usermeta.user_id ) LEFT JOIN wpxa_usermeta
 14245671 dogfoste       localhost dogfoste_  10463   0.0  Query Waiting for tab UPDATE <code>wpxa_usermeta</code> SET <code>meta_value</code> = 'a:1:{s:64:\"0d536cbe689d21403479b97ef51fcc7e1a56a753b49ee9c621b543826e845810\";a:4:{s:10:\"expiration\";i:1488384531
 14258612 dogfoste       localhost dogfoste_   9614   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14263600 dogfoste       localhost dogfoste_   9318   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14269815 dogfoste       localhost dogfoste_   8950   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14284536 dogfoste       localhost dogfoste_   8037   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295282 dogfoste       localhost dogfoste_   7375   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295356 dogfoste       localhost dogfoste_   7372   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295465 dogfoste       localhost dogfoste_   7364   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295481 dogfoste       localhost dogfoste_   7364   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295518 dogfoste       localhost dogfoste_   7363   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295709 dogfoste       localhost dogfoste_   7351   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295731 dogfoste       localhost dogfoste_   7349   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14295760 dogfoste       localhost dogfoste_   7348   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14298104 dogfoste       localhost dogfoste_   7206   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14298242 dogfoste       localhost dogfoste_   7199   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14298548 dogfoste       localhost dogfoste_   7183   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14298585 dogfoste       localhost dogfoste_   7181   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14302965 dogfoste       localhost dogfoste_   6934   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14305220 dogfoste       localhost dogfoste_   6820   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14306320 dogfoste       localhost dogfoste_   6758   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14307847 dogfoste       localhost dogfoste_   6668   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14312412 dogfoste       localhost dogfoste_   6429   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14312741 dogfoste       localhost dogfoste_   6410   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14312940 dogfoste       localhost dogfoste_   6400   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14313017 dogfoste       localhost dogfoste_   6396   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14313100 dogfoste       localhost dogfoste_   6391   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14313197 dogfoste       localhost dogfoste_   6384   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1
 14313316 dogfoste       localhost dogfoste_   6377   0.0  Query Waiting for tab SELECT umeta_id FROM wpxa_usermeta WHERE meta_key = 'birthdate' AND user_id = 1