Wikimedia Bugzilla is closed!

It was hard to debug this one because we don't log the $fname for BEGIN/COMMIT (bug 42598).

The delete('user', ..) query in removeUnusedAccounts.php triggers an automatic transaction begin() call, from Database::query() via Database::delete():


> # If DBO_TRX is set, start a transaction
> if ( ( $this->mFlags & DBO_TRX ) && !$this->mTrxLevel &&
> 	$sql != 'BEGIN' && $sql != 'COMMIT' && $sql != 'ROLLBACK'
> ) {
> 	if ( strpos( $sqlstart, "SHOW " ) !== 0 && strpos( $sqlstart, "SET " ) !== 0 ) {
> 		$this->begin( __METHOD__ . " ($fname)" );
> 		$this->mTrxAutomatic = true;
> 	}
> }

However it isn't committed anywhere.

The SQL debug log looks like this:


Query krinkle_betawiki (2879) (slave): BEGIN /* RemoveUnusedAccounts::isInactiveAccount Krinkle */ 
Query krinkle_betawiki (2880) (slave): SELECT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */  COUNT(*)  FROM `mw_revision`  WHERE rev_user = '406'  LIMIT 1  
Query krinkle_betawiki (2881) (slave): SELECT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */  COUNT(*)  FROM `mw_archive`  WHERE ar_user = '406'  LIMIT 1  
Query krinkle_betawiki (2882) (slave): SELECT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */  COUNT(*)  FROM `mw_image`  WHERE img_user = '406'  LIMIT 1  
Query krinkle_betawiki (2883) (slave): SELECT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */  COUNT(*)  FROM `mw_oldimage`  WHERE oi_user = '406'  LIMIT 1  
Query krinkle_betawiki (2884) (slave): SELECT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */  COUNT(*)  FROM `mw_filearchive`  WHERE fa_user = '406'  LIMIT 1  
Query krinkle_betawiki (2885) (slave): COMMIT /* RemoveUnusedAccounts::isInactiveAccount Krinkle */ 
Query krinkle_betawiki (2886) (slave): BEGIN /* DatabaseBase::query (RemoveUnusedAccounts::execute) Krinkle */ 
Query krinkle_betawiki (2887) (slave): DELETE /* RemoveUnusedAccounts::execute Krinkle */ FROM `mw_user` WHERE user_id IN ('44','45','46','48','50','51','52','53','54','56','62','64','66','67','69','70','73','76','77','78','79','81','82','83','84','86','87','90','91','92','93','96','104','105','106','111','112','113','118','119','123','126','131','133','137','138','141','142','144','145','148','151','152','157','158','160','162','163','164','165','166','167','170','171','172','173','174','176','177','179','180','181','183','184','186
Query krinkle_betawiki (2888) (slave): DELETE /* RemoveUnusedAccounts::execute Krinkle */ FROM `mw_logging` WHERE log_user IN ('44','45','46','48','50','51','52','53','54','56','62','64','66','67','69','70','73','76','77','78','79','81','82','83','84','86','87','90','91','92','93','96','104','105','106','111','112','113','118','119','123','126','131','133','137','138','141','142','144','145','148','151','152','157','158','160','162','163','164','165','166','167','170','171','172','173','174','176','177','179','180','181','183','184',
Query krinkle_betawiki (2889) (slave): DELETE /* RemoveUnusedAccounts::execute Krinkle */ FROM `mw_recentchanges` WHERE rc_user IN ('44','45','46','48','50','51','52','53','54','56','62','64','66','67','69','70','73','76','77','78','79','81','82','83','84','86','87','90','91','92','93','96','104','105','106','111','112','113','118','119','123','126','131','133','137','138','141','142','144','145','148','151','152','157','158','160','162','163','164','165','166','167','170','171','172','173','174','176','177','179','180','181','183','

.. and that's the end of it, after this the execution naturally terminates from the maintenance script.