BOT TG Blocks Hosting
- sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '109.94.200.00'"), and pymysql.err.InternalError: Packet sequence number wrong - got 1 expected 0.- And on the telnet the sadness root@vps:~/hugme-bot# telnet 109.94.00.00 3306 Trying 109.94.200.000...Connected to 109.94.00.00Escape character is '^]'.kHost '78.140.000000' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.Also in logs more than 200k errors.- ERROR - tgbot.services.scheduler - TRY SEND NOTIFICATION ERROR: Forbidden: user is deactivated Every 5 seconds the bot tried to send a message to the person that the bot banned.“Tri send notification error”
By the way, the programmer left himself.But the error processing (e.g., removing the message from the cycle) has not been left.I so guess that it may be in the code something wrong is done (for example, those millions of logs), because now open 6 sessions, and the call-to error (from 15:45) increased from: Aborted clients 248.1 k Aborted connects 265.5 k to Aborted clients 248.9 k Aborted connects 275.3 k
Finally, two of these problems must be solved.1 .Fix the source of the problem so that the bot doesn’t swim and it starts
2ndRemove the source of errors
-
558 10 4 Good Morning Ruslan.
I found a solution: to increase the possible number of connections or disconnect the bots from the databases when they are turned off.
The database is installed on the same server as the robot itself.
I will be happy to cooperate!
-
198 0 1 Hello the reason from part I realized, with the TG bots and their loading to the server I have run for 3 years. The price can be agreed as well as the time.
-
MySQL не умеет в потоки. Ставьте postgresql и ваш вопрос решён, за это даже деньги брать неудобно.
-
Не та версія май скл. Або ставте постгрес або ін версію май скл
-
Current freelance projects in the category Bot Development
Bots"I am looking for a programmer to create a turnkey Telegram bot. The bot should be an intelligent conversationalist based on AI (Gemini or ChatGPT), helping people on any topic and in any language. Payment (Monobank or LiqPay) for subscription needs to be integrated as well. I… Bot Development ∙ 8 minutes back ∙ 4 proposals |
Creation of a multifunctional bot in Telegram
22 USD
(I will provide all materials in private messages) Here is a detailed project description: After pressing the button /start The bot sends a text with rules and terms of use (under the text, the button ‘acknowledged’) After pressing the button, the next message is… Python, Bot Development ∙ 4 hours 57 minutes back ∙ 61 proposals |
Need an AI agent for cold calls in Ukrainian.
449 USD
Need an AI agent for cold calls in Ukrainian. The topic is biofertilizers. The agent should call clients, work with a script, answer typical questions, and transfer interested clients to the manager. Need the cost of setup and monthly expenses. Bot Development ∙ 12 hours 16 minutes back ∙ 22 proposals |
Development of a system for automating job postings in Facebook groups for a recruitment agencyI am looking for a specialist to create and maintain a job posting system in Facebook groups.About the company:We are a recruitment agency in Israel and we specialize in personnel selection for enterprises, factories, warehouses, manufacturing companies, and other employers… Web Programming, Bot Development ∙ 1 day 2 hours back ∙ 39 proposals |
"Automation / Chatbots" "CRM Setup"
112 USD
Looking for a technical assistant/integrator to set up automation in a beauty salon. Setting up a chatbot for the beauty salon (Integration of Instagram + Altegio/YCLIENTS + Wahelp) with training. Current setup: CRM system: Altegio (YCLIENTS). Main traffic channel: Instagram… AI & Machine Learning, Bot Development ∙ 1 day 9 hours back ∙ 31 proposals |