Comment 8 for bug 1589919

Revision history for this message
Elena C (ecurry007) wrote :

Sorry - one more - the MySQL Percona error log does contain quite a bit of similar messages with various SQL statements , as in 2 examples below:
[Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT `auth_user`.`id`, `auth_user`.`password`, `auth_user`.`last_login`, `auth_user`.`is_superuser`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`date_joined` FROM `auth_user` LIMIT 1

2016-09-01 19:36:00 1328 [Note] WSREP: cleanup transaction for LOCAL_STATE: select racefixtur0_.round as round24_, racefixtur0_.language as language24_, racefixtur0_.lastUpdated as lastUpda3_24_, racefixtur0_.seasonName as seasonName24_, racefixtur0_.shortName as shortName24_, racefixtur0_.fullName as fullName24_, racefixtur0_.dateStartFP1 as dateStar7_24_, racefixtur0_.dateStartFP2 as dateStar8_24_, racefixtur0_.dateStartFP3 as dateStar9_24_, racefixtur0_.dateStartQUA as dateSta10_24_, racefixtur0_.dateStartGPX as dateSta11_24_, racefixtur0_.tbdFlag as tbdFlag24_, racefixtur0_.dateEnd as dateEnd24_, racefixtur0_.circuitId as circuitId24_, racefixtur0_.circuitName as circuit15_24_, racefixtur0_.location as location24_, racefixtur0_.raceStatus as raceStatus24_, racefixtur0_.racePhase as racePhase24_, racefixtur0_.countryCode as country19_24_, racefixtur0_.raceId as raceId24_, racefixtur0_.expireDate as expireDate24_ from race_fixture racefixtur0_ where racefixtur0_.language in ('en' , 'fr' , 'ja')
2016-09-01 19:36:00 1328 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT DISTINCT t1.ID, t1.DESCRIPTIONKEY, t1.LASTUPDATED, t1.PARENT_ID, t1.SECTIONKEY, t1.TEXT, t1.TYPE, t1.USAGETYPE, t0.ID, t0.ENTITYID, t0.ENTITYTYPE, t0.LASTUPDATED, t0.LOCALE, t0.TRANSLATEDALT, t0.TRANSLATEDHTML, t0.TRANSLATEDTEXT, t0.TRANSLATEDTITLE, t0.TRANSLATEDURL FROM DESCRIPTION t1 LEFT OUTER JOIN (DESCRIPTION_TRANSLATION t2 JOIN TRANSLATION t0 ON (t0.ID = t2.translation_ID)) ON (t2.Description_ID = t1.ID) WHERE (t1.PARENT_ID = 405)
2016-09-01 19:36:00 1328 [Note] WSREP: cleanup transaction for LOCAL_STATE: commit

and then server dies:

2016-09-01 19:36:00 1328 [Note] WSREP: cleanup transaction for LOCAL_STATE: SELECT meta_key, meta_value FROM dma_sitemeta WHERE meta_key IN ('site_name', 'siteurl', 'active_sitewide_plugins', '_site_transient_timeout_theme_roots', '_site_transient_theme_roots', 'site_admins', 'can_compress_scripts', 'global_terms_enabled', 'ms_files_rewriting') AND site_id = 1
2016-09-01 19:36:00 1328 [Note] WSREP: cleanup transaction for LOCAL_STATE: SET autocommit=1
160901 19:36:02 mysqld_safe Number of processes running now: 0
160901 19:36:02 mysqld_safe WSREP: not restarting wsrep node automatically
160901 19:36:02 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended