1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Русский/Russian

Threaded Mode
already has more than 'max_user_connections' active connections
Daea
Big Clucker
***
Posts: 190
Threads: 51
Joined: Dec 2013
Reputation: 0
#1

08.07.2015, 05:31
Добрый день.
Сразу хочу сказать что я пытаюсь прорекламить какие-либо хостинги и т.д, а просто хочу решить проблему, излагаю свою ситуацию.
В общем, сидел я на 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 "

Их ответ...

Как же такое возможно?
Find
Reply
Daea
Big Clucker
***
Posts: 190
Threads: 51
Joined: Dec 2013
Reputation: 0
#2

08.07.2015, 05:54
Проблема даже не в 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
А таблицы в БД есть.
Find
Reply
Stepashka
Godfather
*****
Posts: 5,763
Threads: 19
Joined: Jul 2008
Reputation: 0
#3

08.07.2015, 06:33
А ты к той базе подключаешься?
Find
Reply
Daea
Big Clucker
***
Posts: 190
Threads: 51
Joined: Dec 2013
Reputation: 0
#4

08.07.2015, 06:34
Убрал вообще все запросы, кроме
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
/////////////////////////////////////


Сейчас сервер не выключал, сразу попробовал зайти в БД, пишет, мол я посылаю много пакетов. Однозначно к той подключаюсь)
Find
Reply
gensek4
Big Clucker
***
Posts: 147
Threads: 6
Joined: Jan 2015
Reputation: 0
#5

08.07.2015, 07:51
Видимо, дело в плагине. Какой используйте?
Find
Reply
Daea
Big Clucker
***
Posts: 190
Threads: 51
Joined: Dec 2013
Reputation: 0
#6

08.07.2015, 08:00
https://github.com/pBlueG/SA-MP-MySQL/releases
mysql-r38-linux.tar.gz
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Русский/Russian