BOT TG Blocks Hosting
9 USD - 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
Current freelance projects in the category Databases & SQL
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 7 hours 29 minutes back ∙ 3 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 13 hours 21 minutes back ∙ 8 proposals |
Setting up a backup system and optimizing server infrastructure
Objective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 1 day 11 hours back ∙ 23 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 1 day 13 hours back ∙ 43 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 1 day 14 hours back ∙ 10 proposals |
Kharkiv