Yasin95 0 Posted January 26, 2018 Share Posted January 26, 2018 Hi friends, there's a problem. ch1 syserr; SYSERR: Jan 26 11:00:37 :: pid_init: Start of pid: 1365 SYSERR: Jan 26 11:07:04 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jan 26 11:07:05 :: ChildLoop: MySQL connection was reconnected. querying locale set db syserr; SYSERR: Jan 26 11:00:26 :: pid_init: Start of pid: 1353 SYSERR: Jan 26 11:04:45 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jan 26 11:05:17 :: ChildLoop: MySQL connection was reconnected. querying locale set SYSERR: Jan 26 11:07:09 :: DirectQuery: MySQL connection was reconnected. querying locale set AsyncSQL.cpp Spoiler void CAsyncSQL::ChildLoop() { cProfiler profiler(500000); // 0.5초 while (!m_bEnd) { m_sem.Wait(); int count = CopyQuery(); if (count <= 0) continue; AddCopiedQueryCount(count); SQLMsg * p; while (count--) { //시간 체크 시작 profiler.Start(); if (!PeekQueryFromCopyQueue(&p)) continue; if (m_ulThreadID != mysql_thread_id(&m_hDB)) { sys_err("MySQL connection was reconnected. querying locale set"); while (!QueryLocaleSet()); m_ulThreadID = mysql_thread_id(&m_hDB); } if (mysql_real_query(&m_hDB, p->stQuery.c_str(), p->stQuery.length())) { p->uiSQLErrno = mysql_errno(&m_hDB); sys_err("AsyncSQL: query failed: %s (query: %s errno: %d)", mysql_error(&m_hDB), p->stQuery.c_str(), p->uiSQLErrno); switch (p->uiSQLErrno) { case CR_SOCKET_CREATE_ERROR: case CR_CONNECTION_ERROR: case CR_IPSOCK_ERROR: case CR_UNKNOWN_HOST: case CR_SERVER_GONE_ERROR: case CR_CONN_HOST_ERROR: case ER_NOT_KEYFILE: case ER_CRASHED_ON_USAGE: case ER_CANT_OPEN_FILE: case ER_HOST_NOT_PRIVILEGED: case ER_HOST_IS_BLOCKED: case ER_PASSWORD_NOT_ALLOWED: case ER_PASSWORD_NO_MATCH: case ER_CANT_CREATE_THREAD: case ER_INVALID_USE_OF_NULL: m_sem.Release(); sys_err("AsyncSQL: retrying"); continue; } } profiler.Stop(); // 0.5초 이상 걸렸으면 로그에 남기기 if (!profiler.IsOk()) sys_log(0, "[QUERY : LONG INTERVAL(OverSec %ld.%ld)] : %s", profiler.GetResultSec(), profiler.GetResultUSec(), p->stQuery.c_str()); PopQueryFromCopyQueue(); if (p->bReturn) { p->Store(); PushResult(p); } else delete p; ++m_iQueryFinished; } } SQLMsg * p; while (PeekQuery(&p)) { if (m_ulThreadID != mysql_thread_id(&m_hDB)) { sys_err("MySQL connection was reconnected. querying locale set"); while (!QueryLocaleSet()); m_ulThreadID = mysql_thread_id(&m_hDB); } if (mysql_real_query(&m_hDB, p->stQuery.c_str(), p->stQuery.length())) { p->uiSQLErrno = mysql_errno(&m_hDB); sys_err("AsyncSQL::ChildLoop : mysql_query error: %s:\nquery: %s", mysql_error(&m_hDB), p->stQuery.c_str()); switch (p->uiSQLErrno) { case CR_SOCKET_CREATE_ERROR: case CR_CONNECTION_ERROR: case CR_IPSOCK_ERROR: case CR_UNKNOWN_HOST: case CR_SERVER_GONE_ERROR: case CR_CONN_HOST_ERROR: case ER_NOT_KEYFILE: case ER_CRASHED_ON_USAGE: case ER_CANT_OPEN_FILE: case ER_HOST_NOT_PRIVILEGED: case ER_HOST_IS_BLOCKED: case ER_PASSWORD_NOT_ALLOWED: case ER_PASSWORD_NO_MATCH: case ER_CANT_CREATE_THREAD: case ER_INVALID_USE_OF_NULL: continue; } } sys_log(0, "QUERY_FLUSH: %s", p->stQuery.c_str()); PopQuery(p->iID); if (p->bReturn) { p->Store(); PushResult(p); } else delete p; ++m_iQueryFinished; } } That's why syserr ? locale_string.txt Is there a problem with this file ? Thanks in advance for your reply. I'm sorry, my english is bad. Link to comment Share on other sites More sharing options...
alondark 59 Posted April 5, 2018 Share Posted April 5, 2018 up i have too Link to comment Share on other sites More sharing options...
kaanofficial 0 Posted June 20, 2022 Share Posted June 20, 2022 help Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now