sleep(5);
continue;
}
foreach ($sphinxLogs as $sphinxLog) {
$dc = $sphinxLog->getDc();
KalturaLog::log('Sphinx log id ' . $sphinxLog->getId() . " dc [{$dc}] Memory: [" . memory_get_usage() . "]");
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());
}
