already has more than 'max_user_connections' active connections - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: already has more than 'max_user_connections' active connections (/showthread.php?tid=580777)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Русский/Russian (https://sampforum.blast.hk/forumdisplay.php?fid=32)
+---- Thread: already has more than 'max_user_connections' active connections (/showthread.php?tid=580777)
already has more than 'max_user_connections' active connections - Daea - 08.07.2015
Добрый день.
Сразу хочу сказать что я пытаюсь прорекламить какие-либо хостинги и т.д, а просто хочу решить проблему, излагаю свою ситуацию.
В общем, сидел я на MyArena, потом сервер закрыли за неуплату, а я работал над сервером и тестил его по локалке. Потом... Оплатил арену залил мод всё нормально, но мне не понравились их условия с БД, после чего я перешёл на рухостер. А там мод вообще не загружается. К БД подключается, но не может выполнить даже элементарного запроса, хотя другие запросы уже закомментированы.
"[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
[13:37:32] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
#1203 - User heiegSkd already has more than 'max_user_connections' active connections
Слишком много одновременных подключений к БД MySQL.
С уважением,
Команда Ru-hoster "
Их ответ...
Как же такое возможно?
Re: already has more than 'max_user_connections' active connections - Daea - 08.07.2015
Проблема даже не в mysql_close.
Я ведь 1 раз запустил сервер на рухостере...
Так же пишет вот что:
[08:58:29] Query: SELECT * FROM `House`, callback: LoadProperty, connectionhandle: 1, error:Table 'heiegSkd.House' doesn't exist
[08:58:29] Query: SELECT * FROM `Safes`, callback: LoadSafes, connectionhandle: 1, error:Table 'heiegSkd.Safes' doesn't exist
А таблицы в БД есть.
Re: already has more than 'max_user_connections' active connections - Stepashka - 08.07.2015
А ты к той базе подключаешься?
Re: already has more than 'max_user_connections' active connections - Daea - 08.07.2015
Убрал вообще все запросы, кроме
connects = mysql_connect(mysql_host, mysql_user, mysql_db, mysql_pass);
if(mysql_errno(connects)) return printf("[MYSQL] неудалось соединится с базой данных (%d)", connects);
else printf("[MYSQL] подключение успешно (%d)", connects);
mysql_log(LOG_ERROR | LOG_WARNING,LOG_TYPE_TEXT);
mysql_set_charset("cp1251_general_ci");
mysql_function_query(connects,"SET NAMES 'cp1251'",false,"","");
mysql_function_query(connects,"SET CHARACTER SET 'cp1251'",false,"","");
А флуд уже летит... Кто прав, кто виноват?
/////////////////////////////////////
Да, к той. Что по почте выслали, на той создал таблицы, вот прямо сейчас смотрю на них. А при подключении пишет что их нет.
Вот что выводит при коде выше:
Код:
Вот что выводит... [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set cp1251_general_ci (path: /usr/local/mysql/share/charsets/) [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections [09:31:19] [ERROR] CMySQLConnection::Connect - (error #1203) User heiegSkd already has more than 'max_user_connections' active connections
Сейчас сервер не выключал, сразу попробовал зайти в БД, пишет, мол я посылаю много пакетов. Однозначно к той подключаюсь)
Re: already has more than 'max_user_connections' active connections - gensek4 - 08.07.2015
Видимо, дело в плагине. Какой используйте?
Re: already has more than 'max_user_connections' active connections - Daea - 08.07.2015
https://github.com/pBlueG/SA-MP-MySQL/releases
mysql-r38-linux.tar.gz