Renew the bot on airogram + sqlalchemy
- 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”
Per in the bot code you need to add a check on the blocked user, you need to write a couple of keys.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.Maybe the IPB is changed.
2ndRemove the source of errors
-
283 10 0 Hi, I have great experience in developing tg to solve problems and solve causes.
-
122 3 0 The task was done partially, but you need to look at the code and the setup of the BD.
Let’s write and talk.
-
94014 1265 1 10 Hi.There is a great experience in developing tg bots.Can you see the bots code?
Current freelance projects in the category Bot Development
Link UA Telegram botA Telegram bot needs to be developed that connects clients and performers of physical labor (movers, cleaning, repairs, laborers) across cities in Ukraine. Functionality: Two roles — client and performer. The client creates a request, selects a category, specifies the address… Bot Development ∙ 1 hour 20 minutes back ∙ 30 proposals |
Automation of creating advertising creatives.There is a solution in the form of Higgsfield AI + nodes that generate quite close to the idea based on the prompt, paired with almost frame-by-frame editing, everything works well, except for one thing, which is the censorship on the use of celebrity faces and such. An… AI & Machine Learning, Bot Development ∙ 11 hours 45 minutes back ∙ 8 proposals |
Futures botA futures trading bot needs to be created. Under defined conditions, it should automatically set take profit, hedge, lock in profits, and automatically restart trading. Bot Development ∙ 22 hours 59 minutes back ∙ 36 proposals |
Telegram automation of message distribution in chatsNeed to send messages to Telegram chats. To avoid bans. There are several hundred chats. To configure the frequency and variability of texts. Python, Bot Development ∙ 1 day back ∙ 30 proposals |
Telegram botIt is necessary to develop a bot for a Telegram group. The functionality of the bot is quite simple: 1. Text recognition in voice messages 2. Checking for prohibited words in text 3. If prohibited words are detected, the bot should automatically delete this voice message. Bot Development ∙ 1 day 2 hours back ∙ 60 proposals |