/* * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information * * This program is free software; you can redistribute it and/or modify it * under the terms of the GNU General Public License as published by the * Free Software Foundation; either version 2 of the License, or (at your * option) any later version. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for * more details. * * You should have received a copy of the GNU General Public License along * with this program. If not, see . */ #include "Transaction.h" #include "MySQLConnection.h" #include "PreparedStatement.h" #include std::mutex TransactionTask::_deadlockLock; //- Append a raw ad-hoc query to the transaction void TransactionBase::Append(const char* sql) { SQLElementData data; data.type = SQL_ELEMENT_RAW; data.element.query = strdup(sql); m_queries.push_back(data); } //- Append a prepared statement to the transaction void TransactionBase::AppendPreparedStatement(PreparedStatementBase* stmt) { SQLElementData data; data.type = SQL_ELEMENT_PREPARED; data.element.stmt = stmt; m_queries.push_back(data); } void TransactionBase::Cleanup() { // This might be called by explicit calls to Cleanup or by the auto-destructor if (_cleanedUp) return; for (SQLElementData const &data : m_queries) { switch (data.type) { case SQL_ELEMENT_PREPARED: delete data.element.stmt; break; case SQL_ELEMENT_RAW: free((void*)(data.element.query)); break; } } m_queries.clear(); _cleanedUp = true; } bool TransactionTask::Execute() { int errorCode = m_conn->ExecuteTransaction(m_trans); if (!errorCode) return true; if (errorCode == ER_LOCK_DEADLOCK) { // Make sure only 1 async thread retries a transaction so they don't keep dead-locking each other std::lock_guard lock(_deadlockLock); uint8 loopBreaker = 5; // Handle MySQL Errno 1213 without extending deadlock to the core itself for (uint8 i = 0; i < loopBreaker; ++i) if (!m_conn->ExecuteTransaction(m_trans)) return true; } // Clean up now. m_trans->Cleanup(); return false; }