public static function cleanMemory()
{
SphinxLogPeer::clearInstancePool();
// SphinxLogServerPeer::clearInstancePool();
}
if (isset($lastLogs[$dc])) {
$serverLastLog = $lastLogs[$dc];
if ($serverLastLog->getLastLogId() >= $sphinxLog->getId()) {
KalturaLog::debug('Last log id [' . $serverLastLog->getLastLogId() . "] dc [{$dc}] is larger than id [" . $sphinxLog->getId() . "]");
continue;
}
} else {
$serverLastLog = new SphinxLogServer();
$serverLastLog->setServer($sphinxServer);
$serverLastLog->setDc($dc);
$lastLogs[$dc] = $serverLastLog;
}
try {
$sql = $sphinxLog->getSql();
$affected = $sphinxCon->exec($sql);
if (!$affected) {
$errorInfo = $sphinxCon->errorInfo();
// if(!preg_match('/^duplicate id/', $errorInfo[2]))
// die("No affected records [" . $sphinxCon->errorCode() . "]\n" . print_r($sphinxCon->errorInfo(), true));
}
$serverLastLog->setLastLogId($sphinxLog->getId());
$serverLastLog->save(myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_SPHINX_LOG));
} catch (Exception $e) {
KalturaLog::err($e->getMessage());
}
}
unset($sphinxCon);
SphinxLogPeer::clearInstancePool();
$sphinxLogs = SphinxLogPeer::retrieveByLastId($lastLogs);
}
KalturaLog::log('Done');
/**
* Method perform a DELETE on the database, given a SphinxLog or Criteria object OR a primary key value.
*
* @param mixed $values Criteria or SphinxLog object or primary key or array of primary keys
* which is used to create the DELETE statement
* @param PropelPDO $con the connection to use
* @return int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows
* if supported by native driver or if emulated using Propel.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doDelete($values, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(SphinxLogPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
if ($values instanceof Criteria) {
// invalidate the cache for all objects of this type, since we have no
// way of knowing (without running a query) what objects should be invalidated
// from the cache based on this Criteria.
SphinxLogPeer::clearInstancePool();
// rename for clarity
$criteria = clone $values;
} elseif ($values instanceof SphinxLog) {
// it's a model object
// invalidate the cache for this single object
SphinxLogPeer::removeInstanceFromPool($values);
// create criteria based on pk values
$criteria = $values->buildPkeyCriteria();
} else {
// it's a primary key, or an array of pks
$criteria = new Criteria(self::DATABASE_NAME);
$criteria->add(SphinxLogPeer::ID, (array) $values, Criteria::IN);
// invalidate the cache for this object(s)
foreach ((array) $values as $singleval) {
SphinxLogPeer::removeInstanceFromPool($singleval);
}
}
// Set the correct dbName
$criteria->setDbName(self::DATABASE_NAME);
$affectedRows = 0;
// initialize var to track total num of affected rows
try {
// use transaction because $criteria could contain info
// for more than one table or we could emulating ON DELETE CASCADE, etc.
$con->beginTransaction();
$affectedRows += BasePeer::doDelete($criteria, $con);
SphinxLogPeer::clearRelatedInstancePool();
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
