MySQL error
Solved! Everything works perfect.
How to avoid to create this mysql-bin files?
Thank you so much for helping!
decen
This problem does not occur in normal use. Did you do anything? Clear the log? Close mysql-bin?
Time to time i use Log Cleanup app
decen
The mysql-bin log does not need to be cleared by itself. The mysql of the panel is only kept for 10 days, the old ones are cleared every day.
Facing similar Issue
2024-12-15T15:50:49.121209Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15T15:50:49.121339Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-15T15:50:49.121344Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-12-15T15:50:49.121371Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-12-15T15:50:49.121390Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 139591 ...
2024-12-15T15:50:49.242861Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-12-15T15:50:49.242895Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-12-15T15:50:49.242899Z 0 [Note] InnoDB: Uses event mutexes
2024-12-15T15:50:49.242902Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-12-15T15:50:49.242905Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-12-15T15:50:49.243280Z 0 [Note] InnoDB: Number of pools: 1
2024-12-15T15:50:49.243374Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-12-15T15:50:55.388502Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2768326
2024-12-15T15:50:55.390271Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-12-15T15:50:55.390286Z 0 [Note] Shutting down plugin 'MEMORY'
2024-12-15T15:50:55.390294Z 0 [Note] Shutting down plugin 'CSV'
2024-12-15T15:50:55.390299Z 0 [Note] Shutting down plugin 'sha256_password'
2024-12-15T15:50:55.390303Z 0 [Note] Shutting down plugin 'mysql_native_password'
2024-12-15T15:50:55.390487Z 0 [Note] Shutting down plugin 'binlog'
2024-12-15T15:50:55.397984Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
2024-12-15T15:50:56.389423Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15T15:50:56.389556Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-15T15:50:56.389561Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-12-15T15:50:56.389589Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-12-15T15:50:56.389612Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 140668 ...
2024-12-15T15:50:56.506829Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-12-15T15:50:56.506862Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-12-15T15:50:56.506866Z 0 [Note] InnoDB: Uses event mutexes
2024-12-15T15:50:56.506869Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-12-15T15:50:56.506872Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-12-15T15:50:56.507253Z 0 [Note] InnoDB: Number of pools: 1
2024-12-15T15:50:56.507349Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-12-15T15:50:57.013427Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-12-15T15:50:57.013532Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-12-15T15:50:57.013578Z 0 [Note] IPv6 is available.
2024-12-15T15:50:57.013586Z 0 [Note] - '::' resolves to '::';
2024-12-15T15:50:57.013675Z 0 [Note] Server socket created on IP: '::'.
2024-12-15T15:50:57.017113Z 0 [Note] Failed to start slave threads for channel ''
2024-12-15T15:50:57.022196Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.44-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-12-15T15:51:01.507037Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2024-12-15T15:51:04.609300Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15T15:51:04.609442Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-15T15:51:04.609447Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-12-15T15:51:04.609468Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-12-15T15:51:04.609492Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 141795 ...
2024-12-15T15:51:04.734341Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-12-15T15:51:04.734371Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-12-15T15:51:04.734374Z 0 [Note] InnoDB: Uses event mutexes
2024-12-15T15:51:04.734378Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-12-15T15:51:04.734381Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-12-15T15:51:04.734761Z 0 [Note] InnoDB: Number of pools: 1
2024-12-15T15:51:04.734855Z 0 [Note] InnoDB: Using CPU crc32 instructions
2024-12-15T15:51:04.738741Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2024-12-15T15:51:04.967493Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-12-15T15:51:04.989202Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15T15:51:04.989331Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-15T15:51:04.989336Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-12-15T15:51:04.989367Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-12-15T15:51:04.989386Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 142111 ...
2024-12-15T15:51:05.025351Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-12-15T15:51:05.037280Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-12-15T15:51:05.079809Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2768345
2024-12-15T15:51:05.079838Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2768354
2024-12-15T15:51:05.079845Z 0 [Note] InnoDB: Database was not shutdown normally!
2024-12-15T15:51:05.079849Z 0 [Note] InnoDB: Starting crash recovery.
2024-12-15T15:51:05.096589Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-12-15T15:51:05.336852Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2024-12-15T15:51:05.336968Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-12-15T15:51:05.337115Z 0 [Note] IPv6 is available.
2024-12-15T15:51:05.337130Z 0 [Note] - '::' resolves to '::';
2024-12-15T15:51:05.337163Z 0 [Note] Server socket created on IP: '::'.
2024-12-15T15:51:05.340018Z 0 [Note] Failed to start slave threads for channel ''
2024-12-15T15:51:05.344276Z 0 [Note] Event Scheduler: Loaded 0 events
2024-12-15T15:51:05.344472Z 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.7.44-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2024-12-15T15:51:05.388084Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-12-15T15:51:05.398192Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2024-12-15T15:51:05.398205Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2024-12-15T15:51:05.398209Z 0 [Note] InnoDB: Retrying to lock the first data file
2024-12-15T15:51:06.398354Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2024-12-15T15:51:06.398380Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2024-12-15T15:51:07.398519Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2024-12-15T15:51:07.398548Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2024-12-15T15:51:08.398692Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2024-12-15T15:51:08.398720Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2024-12-15T15:51:09.398850Z 0 [ERROR] InnoDB: Unable to lock /www/server/data/ibdata1 error: 11
2024-12-15T15:51:09.398877Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2024-12-15T15:51:10.076776Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2024-12-15T15:51:10.086584Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2024-12-15T15:51:13.169398Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2024-12-15T15:51:13.169532Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-12-15T15:51:13.169537Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2024-12-15T15:51:13.169558Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-12-15T15:51:13.169585Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 143050 ...
2024-12-15T15:51:13.275848Z 0 [Note] InnoDB: PUNCH HOLE support available
2024-12-15T15:51:13.275881Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-12-15T15:51:13.275885Z 0 [Note] InnoDB: Uses event mutexes
2024-12-15T15:51:13.275888Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2024-12-15T15:51:13.275891Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2024-12-15T15:51:13.276262Z 0 [Note] InnoDB: Number of pools: 1
2024-12-15T15:51:13.276365Z 0 [Note] InnoDB: Using CPU crc32 instructions
Data locked: NO
Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:103
LUA : init_queue:111
WOC : NO
Next activation : never
2024-12-15T16:24:33.780452Z 14 [Note] Aborted connection 14 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-15T16:24:33.792299Z 17 [Note] Aborted connection 17 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-15T16:24:33.813288Z 18 [Note] Aborted connection 18 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-15T17:29:22.678212Z 30 [Warning] Hostname 'static-host-138-199-85-60.awasr.om' does not resolve to '138.199.85.60'.
2024-12-15T17:29:22.678264Z 30 [Note] Hostname 'static-host-138-199-85-60.awasr.om' has the following IP addresses:
2024-12-15T17:29:22.678275Z 30 [Note] - 185.151.30.171
2024-12-15T17:29:22.678283Z 30 [Note] - 2a07:7800::171
2024-12-16T16:33:28.661814Z 49 [Note] Aborted connection 49 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-16T16:33:28.671255Z 52 [Note] Aborted connection 52 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-16T16:33:28.690304Z 53 [Note] Aborted connection 53 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-16T16:33:34.712268Z 63 [Note] Aborted connection 63 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-16T16:38:33.549340Z 72 [Note] Got an error reading communication packets
2024-12-16T17:19:24.834016Z 130 [Note] Got an error reading communication packets
2024-12-16T17:19:24.838774Z 131 [Note] Got an error reading communication packets
2024-12-16T17:19:33.449030Z 132 [Warning] IP address '192.168.100.221' could not be resolved: Name or service not known
2024-12-16T17:19:33.484970Z 132 [Note] Bad handshake
2024-12-16T17:19:33.520816Z 133 [Note] Bad handshake
2024-12-16T17:19:33.572175Z 134 [Note] Access denied for user 'fi-pos'@'192.168.100.221' (using password: YES)
2024-12-16T17:19:33.630717Z 135 [Note] Bad handshake
2024-12-16T17:19:33.670948Z 136 [Note] Bad handshake
2024-12-16T17:19:33.713842Z 137 [Note] Bad handshake
2024-12-16T17:19:50.366946Z 138 [Note] Bad handshake
2024-12-16T17:19:50.401236Z 139 [Note] Bad handshake
2024-12-16T17:19:50.419256Z 140 [Note] Access denied for user 'fi-pos'@'192.168.100.221' (using password: YES)
2024-12-16T17:22:09.752759Z 185 [Note] Access denied for user 'fi-pos'@'138.199.85.60' (using password: YES)
2024-12-16T17:22:09.778542Z 186 [Note] Bad handshake
2024-12-16T17:22:09.806020Z 187 [Note] Bad handshake
2024-12-16T17:22:09.836581Z 188 [Note] Bad handshake
2024-12-16T17:22:09.864689Z 189 [Note] Bad handshake
2024-12-16T17:22:09.892344Z 190 [Note] Bad handshake
2024-12-16T17:22:09.919400Z 191 [Note] Bad handshake
2024-12-16T17:22:09.944999Z 192 [Note] Bad handshake
2024-12-16T17:22:09.973604Z 193 [Note] Bad handshake
2024-12-16T17:22:10.001712Z 194 [Note] Bad handshake
2024-12-16T17:25:58.063744Z 198 [Note] Got an error reading communication packets
2024-12-16T17:56:37.462131Z 751 [Warning] Hostname 'dynamic.isp.ooredoo.om' does not resolve to '5.21.125.126'.
2024-12-16T17:56:37.462181Z 751 [Note] Hostname 'dynamic.isp.ooredoo.om' has the following IP addresses:
2024-12-16T17:56:37.462191Z 751 [Note] - 185.151.30.171
2024-12-16T17:56:37.462198Z 751 [Note] - 2a07:7800::171
2024-12-16T17:56:39.504512Z 752 [Note] Got an error reading communication packets
2024-12-16T17:57:44.066654Z 753 [Note] Aborted connection 753 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T17:57:44.066798Z 751 [Note] Aborted connection 751 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:02:40.116088Z 781 [Note] Bad handshake
2024-12-16T18:02:40.232339Z 782 [Note] Bad handshake
2024-12-16T18:02:54.138796Z 787 [Note] Bad handshake
2024-12-16T18:02:54.182695Z 788 [Note] Bad handshake
2024-12-16T18:02:56.487297Z 790 [Note] Bad handshake
2024-12-16T18:02:56.587981Z 791 [Note] Bad handshake
2024-12-16T18:03:07.990185Z 789 [Note] Aborted connection 789 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:03:07.992224Z 792 [Note] Aborted connection 792 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:03:13.771623Z 796 [Note] Bad handshake
2024-12-16T18:03:13.832445Z 797 [Note] Bad handshake
2024-12-16T18:03:25.743656Z 799 [Note] Bad handshake
2024-12-16T18:03:25.817985Z 800 [Note] Bad handshake
2024-12-16T18:03:27.363523Z 803 [Note] Bad handshake
2024-12-16T18:03:27.428351Z 804 [Note] Bad handshake
2024-12-16T18:03:35.714008Z 805 [Note] Aborted connection 805 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:03:35.721516Z 801 [Note] Aborted connection 801 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:03:40.548768Z 809 [Note] Bad handshake
2024-12-16T18:03:40.607827Z 811 [Note] Bad handshake
2024-12-16T18:03:53.800584Z 815 [Note] Bad handshake
2024-12-16T18:03:53.845664Z 816 [Note] Bad handshake
2024-12-16T18:03:55.896272Z 819 [Note] Bad handshake
2024-12-16T18:03:55.975384Z 820 [Note] Bad handshake
2024-12-16T18:04:08.565285Z 821 [Note] Aborted connection 821 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:04:08.731011Z 817 [Note] Aborted connection 817 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:04:21.880735Z 826 [Note] Bad handshake
2024-12-16T18:04:22.066118Z 827 [Note] Bad handshake
2024-12-16T18:04:46.673358Z 835 [Note] Bad handshake
2024-12-16T18:04:46.768165Z 836 [Note] Bad handshake
2024-12-16T18:04:48.787121Z 838 [Note] Bad handshake
2024-12-16T18:04:48.846256Z 839 [Note] Bad handshake
2024-12-16T18:05:06.685739Z 840 [Note] Aborted connection 840 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:05:06.686317Z 837 [Note] Aborted connection 837 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T18:05:11.416647Z 847 [Note] Bad handshake
2024-12-16T18:05:11.503936Z 848 [Note] Bad handshake
2024-12-16T18:17:39.673974Z 930 [Warning] IP address '35.187.27.99' has been resolved to the host name '99.27.187.35.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-16T18:17:39.789616Z 930 [Note] Got an error reading communication packets
2024-12-16T18:17:46.017841Z 933 [Warning] IP address '35.195.123.144' has been resolved to the host name '144.123.195.35.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-16T18:17:46.127519Z 933 [Note] Access denied for user 'root'@'35.195.123.144' (using password: NO)
2024-12-16T18:29:47.666009Z 1032 [Note] Bad handshake
2024-12-16T18:29:47.818039Z 1033 [Note] Bad handshake
2024-12-16T18:30:57.800672Z 1045 [Note] Bad handshake
2024-12-16T18:30:57.915999Z 1046 [Note] Bad handshake
2024-12-16T18:32:23.511635Z 1061 [Note] Bad handshake
2024-12-16T18:32:23.581330Z 1062 [Note] Bad handshake
2024-12-16T18:33:45.692611Z 1075 [Note] Bad handshake
2024-12-16T18:33:45.751021Z 1076 [Note] Bad handshake
2024-12-16T18:56:30.255952Z 1519 [Note] Bad handshake
2024-12-16T19:00:08.903657Z 1547 [Note] Bad handshake
2024-12-16T19:00:08.964021Z 1548 [Note] Bad handshake
2024-12-16T19:02:31.803898Z 1570 [Note] Bad handshake
2024-12-16T19:02:32.051070Z 1571 [Note] Bad handshake
2024-12-16T19:12:16.263057Z 1699 [Warning] Hostname 'scan-57-18.security.ipip.net' does not resolve to '103.203.57.18'.
2024-12-16T19:12:16.263088Z 1699 [Note] Hostname 'scan-57-18.security.ipip.net' has the following IP addresses:
2024-12-16T19:12:16.263099Z 1699 [Note] - 185.151.30.171
2024-12-16T19:12:16.263107Z 1699 [Note] - 2a07:7800::171
2024-12-16T19:12:26.273284Z 1699 [Note] Got timeout reading communication packets
2024-12-16T19:54:40.682782Z 4272 [Note] Got an error reading communication packets
2024-12-16T19:54:40.687218Z 4273 [Note] Got an error reading communication packets
2024-12-16T21:12:17.497312Z 1572 [Note] Aborted connection 1572 to db: 'fi_pos' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-16T21:29:15.626087Z 8317 [Warning] IP address '59.52.178.147' could not be resolved: Temporary failure in name resolution
2024-12-16T21:29:15.984761Z 8317 [Note] Got an error reading communication packets
2024-12-16T22:00:02.368977Z 8318 [Warning] IP address '45.88.88.47' could not be resolved: Name or service not known
2024-12-16T22:00:02.497294Z 8318 [Note] Access denied for user 'root'@'45.88.88.47' (using password: NO)
2024-12-16T22:42:23.194409Z 8335 [Warning] IP address '87.121.86.83' could not be resolved: Name or service not known
2024-12-16T22:42:23.379977Z 8335 [Note] Access denied for user 'root'@'87.121.86.83' (using password: NO)
2024-12-16T22:48:10.442886Z 8336 [Warning] IP address '194.48.251.77' could not be resolved: Name or service not known
2024-12-16T22:48:10.583720Z 8336 [Note] Access denied for user 'root'@'194.48.251.77' (using password: NO)
2024-12-16T22:48:11.127887Z 8337 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:11.674495Z 8338 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:12.233497Z 8339 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:12.623097Z 8340 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:23.216826Z 8362 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:23.761998Z 8363 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-16T22:48:24.320912Z 8364 [Note] Access denied for user 'root'@'194.48.251.77' (using password: YES)
2024-12-17T00:00:19.959330Z 9335 [Warning] IP address '194.48.251.49' could not be resolved: Name or service not known
2024-12-17T00:00:20.086450Z 9335 [Note] Access denied for user 'root'@'194.48.251.49' (using password: NO)
2024-12-17T00:00:20.642040Z 9336 [Note] Access denied for user 'root'@'194.48.251.49' (using password: YES)
2024-12-17T02:08:24.960626Z 11216 [Note] Access denied for user 'username_here'@'localhost' (using password: YES)
2024-12-17T03:49:55.567106Z 12773 [Warning] Hostname 'internettl.org' does not resolve to '104.152.52.83'.
2024-12-17T03:49:55.567140Z 12773 [Note] Hostname 'internettl.org' has the following IP addresses:
2024-12-17T03:49:55.567150Z 12773 [Note] - 162.255.119.131
2024-12-17T03:49:55.818166Z 12773 [Note] Got an error reading communication packets
2024-12-17T05:12:21.542090Z 14041 [Note] Got an error reading communication packets
2024-12-17T05:58:21.224105Z 14755 [Note] Bad handshake
2024-12-17T05:58:21.277074Z 14756 [Note] Bad handshake
2024-12-17T06:01:22.763135Z 14790 [Warning] IP address '71.6.232.22' could not be resolved: Name or service not known
2024-12-17T06:01:26.420470Z 14792 [Note] Bad handshake
2024-12-17T06:01:26.483972Z 14793 [Note] Bad handshake
2024-12-17T06:01:30.484658Z 14790 [Note] Got an error reading communication packets
2024-12-17T06:02:40.823998Z 14806 [Note] Bad handshake
2024-12-17T06:02:40.877953Z 14807 [Note] Bad handshake
2024-12-17T06:03:17.988832Z 14819 [Note] Bad handshake
2024-12-17T06:03:18.040338Z 14820 [Note] Bad handshake
2024-12-17T06:03:20.651394Z 14823 [Note] Bad handshake
2024-12-17T06:03:20.710708Z 14824 [Note] Bad handshake
2024-12-17T06:03:28.895804Z 14825 [Note] Aborted connection 14825 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-17T06:03:28.895835Z 14821 [Note] Aborted connection 14821 to db: 'unconnected' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-17T06:03:33.331553Z 14826 [Note] Bad handshake
2024-12-17T06:03:33.379674Z 14827 [Note] Bad handshake
2024-12-17T06:05:35.169051Z 14852 [Note] Got an error reading communication packets
2024-12-17T06:42:25.327844Z 14936 [Note] Bad handshake
2024-12-17T06:42:25.369303Z 14937 [Note] Bad handshake
2024-12-17T06:48:33.809886Z 14942 [Note] Bad handshake
2024-12-17T06:48:33.864303Z 14943 [Note] Bad handshake
2024-12-17T07:27:53.477447Z 14970 [Warning] IP address '194.48.251.88' could not be resolved: Name or service not known
2024-12-17T07:27:53.665470Z 14970 [Note] Access denied for user 'root'@'194.48.251.88' (using password: NO)
2024-12-17T07:27:54.043404Z 14971 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:27:54.428010Z 14972 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:27:54.999876Z 14973 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:27:55.571886Z 14974 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:02.709240Z 14989 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:03.130645Z 14990 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:03.526785Z 14991 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:03.918532Z 14992 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:04.480376Z 14993 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:04.880438Z 14994 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:05.290439Z 14995 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:05.857703Z 14996 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:06.409878Z 14997 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T07:28:06.956397Z 14998 [Note] Access denied for user 'root'@'194.48.251.88' (using password: YES)
2024-12-17T08:01:51.181355Z 15030 [Note] Got an error reading communication packets
2024-12-17T08:02:08.396183Z 15033 [Note] Got an error reading communication packets
2024-12-17T08:10:54.808633Z 15041 [Note] Bad handshake
2024-12-17T08:10:54.848387Z 15042 [Note] Bad handshake
2024-12-17T08:24:34.905681Z 14828 [Note] Aborted connection 14828 to db: 'fi_pos' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-17T08:33:58.613486Z 19057 [Warning] IP address '35.190.205.136' has been resolved to the host name '136.205.190.35.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-17T08:33:58.746824Z 19057 [Note] Got an error reading communication packets
2024-12-17T08:33:59.212152Z 19062 [Warning] IP address '34.78.26.243' has been resolved to the host name '243.26.78.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-17T08:33:59.325992Z 19062 [Note] Access denied for user 'root'@'34.78.26.243' (using password: NO)
2024-12-17T08:49:42.587074Z 25606 [Note] Aborted connection 25606 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T08:49:42.596388Z 25609 [Note] Aborted connection 25609 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T08:49:42.615288Z 25610 [Note] Aborted connection 25610 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T08:49:43.580863Z 25618 [Note] Aborted connection 25618 to db: 'sql_radiochaskao' user: 'sql_radiochaskao' host: 'localhost' (Got an error reading communication packets)
2024-12-17T09:47:22.248338Z 38928 [Warning] IP address '194.48.251.146' could not be resolved: Name or service not known
2024-12-17T09:47:22.376441Z 38928 [Note] Access denied for user 'root'@'194.48.251.146' (using password: NO)
2024-12-17T09:54:08.855125Z 14944 [Note] Aborted connection 14944 to db: 'fi_pos' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-17T10:05:29.146214Z 39326 [Note] Got an error reading communication packets
2024-12-17T10:11:37.434469Z 15043 [Note] Aborted connection 15043 to db: 'fi_pos' user: 'fi_pos' host: '5.21.125.126' (Got an error reading communication packets)
2024-12-17T12:16:51.431360Z 47859 [Note] Got packets out of order
2024-12-17T12:32:50.996109Z 50824 [Warning] IP address '159.203.46.221' could not be resolved: Name or service not known
2024-12-17T12:32:50.996364Z 50824 [Note] Got packets out of order
2024-12-17T12:42:55.409607Z 52718 [Warning] IP address '167.94.146.60' could not be resolved: Name or service not known
2024-12-17T12:42:56.060848Z 52718 [Note] Got an error reading communication packets
2024-12-17T12:42:57.586327Z 52726 [Note] Got packets out of order
2024-12-17T12:42:59.094704Z 52732 [Note] Got packets out of order
2024-12-17T12:43:01.159336Z 52738 [Note] Got packets out of order
2024-12-17T13:22:56.813091Z 60283 [Warning] IP address '185.167.97.229' could not be resolved: Name or service not known
2024-12-17T13:22:56.813327Z 60283 [Note] Got packets out of order
2024-12-17T13:24:59.434612Z 60678 [Note] Got an error reading communication packets
2024-12-17T13:26:34.430991Z 60976 [Note] Got an error reading communication packets
2024-12-17T13:27:50.112261Z 61212 [Note] Got an error reading communication packets
2024-12-17T13:54:42.314887Z 61318 [Warning] Hostname 'rnd.group-ib.com' does not resolve to '80.82.77.202'.
2024-12-17T13:54:42.314922Z 61318 [Note] Hostname 'rnd.group-ib.com' has the following IP addresses:
2024-12-17T13:54:42.314932Z 61318 [Note] - 5.9.185.30
2024-12-17T13:54:52.325170Z 61318 [Note] Got timeout reading communication packets
2024-12-17T14:32:24.614600Z 61324 [Note] Got an error reading communication packets
2024-12-17T15:01:35.494671Z 62617 [Note] Aborted connection 62617 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T15:01:35.539047Z 62620 [Note] Aborted connection 62620 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T15:01:35.563709Z 62621 [Note] Aborted connection 62621 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-17T15:35:03.527857Z 63801 [Note] Got an error reading communication packets
2024-12-17T16:24:57.033070Z 64995 [Warning] IP address '159.65.168.103' could not be resolved: Name or service not known
2024-12-17T16:24:57.294724Z 64995 [Note] Got an error reading communication packets
2024-12-17T16:42:02.659890Z 65429 [Warning] IP address '205.210.31.6' could not be resolved: Name or service not known
2024-12-17T16:42:12.670103Z 65429 [Note] Got timeout reading communication packets
2024-12-17T16:53:21.132557Z 66687 [Note] Got an error reading communication packets
2024-12-17T17:14:34.369033Z 67035 [Warning] IP address '185.47.172.136' could not be resolved: Name or service not known
2024-12-17T17:14:34.369175Z 67035 [Note] Got packets out of order
2024-12-17T17:45:54.106963Z 67244 [Warning] IP address '194.48.251.142' could not be resolved: Name or service not known
2024-12-17T17:45:54.289095Z 67244 [Note] Access denied for user 'root'@'194.48.251.142' (using password: NO)
2024-12-17T19:23:53.435002Z 70045 [Warning] IP address '85.31.47.120' could not be resolved: Name or service not known
2024-12-17T19:23:53.564196Z 70045 [Note] Access denied for user 'root'@'85.31.47.120' (using password: NO)
2024-12-17T21:54:09.008108Z 71363 [Note] Got an error reading communication packets
2024-12-17T23:16:10.175920Z 71733 [Warning] IP address '87.120.117.177' could not be resolved: Name or service not known
2024-12-17T23:16:10.315148Z 71733 [Note] Access denied for user 'root'@'87.120.117.177' (using password: NO)
2024-12-17T23:16:10.728722Z 71734 [Note] Access denied for user 'root'@'87.120.117.177' (using password: YES)
2024-12-17T23:16:11.284979Z 71735 [Note] Access denied for user 'root'@'87.120.117.177' (using password: YES)
2024-12-17T23:16:11.872748Z 71736 [Note] Access denied for user 'root'@'87.120.117.177' (using password: YES)
2024-12-18T03:22:24.378501Z 73385 [Note] Got an error reading communication packets
2024-12-18T03:26:29.474267Z 73419 [Note] Access denied for user 'username_here'@'localhost' (using password: YES)
2024-12-18T06:57:42.573091Z 74744 [Note] Got an error reading communication packets
2024-12-18T07:06:59.417507Z 74747 [Warning] IP address '34.140.130.14' has been resolved to the host name '14.130.140.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-18T07:06:59.533127Z 74747 [Note] Got an error reading communication packets
2024-12-18T07:06:59.936684Z 74748 [Warning] IP address '34.38.111.228' has been resolved to the host name '228.111.38.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2024-12-18T07:07:00.047717Z 74748 [Note] Access denied for user 'root'@'34.38.111.228' (using password: NO)
2024-12-18T08:13:44.654615Z 74832 [Warning] IP address '178.215.224.9' could not be resolved: Name or service not known
2024-12-18T08:13:44.847574Z 74832 [Note] Access denied for user 'root'@'178.215.224.9' (using password: NO)
2024-12-18T08:13:45.288402Z 74833 [Note] Access denied for user 'root'@'178.215.224.9' (using password: YES)
2024-12-18T08:13:45.850553Z 74834 [Note] Access denied for user 'root'@'178.215.224.9' (using password: YES)
2024-12-18T08:13:46.410393Z 74835 [Note] Access denied for user 'root'@'178.215.224.9' (using password: YES)
2024-12-18T08:41:04.006818Z 74852 [Note] Got packets out of order
2024-12-18T10:26:37.709085Z 75012 [Warning] IP address '167.94.145.111' could not be resolved: Name or service not known
2024-12-18T10:26:38.703175Z 75012 [Note] Got an error reading communication packets
2024-12-18T10:26:41.886131Z 75013 [Note] Got packets out of order
2024-12-18T10:26:43.953774Z 75014 [Note] Got packets out of order
2024-12-18T10:26:46.002093Z 75015 [Note] Got packets out of order
2024-12-18T11:04:29.912909Z 75033 [Note] Got an error reading communication packets
2024-12-18T11:06:46.890634Z 75047 [Note] Access denied for user 'username_here'@'localhost' (using password: YES)
2024-12-18T12:43:18.054370Z 76904 [Note] Aborted connection 76904 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-18T12:43:18.063631Z 76907 [Note] Aborted connection 76907 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-18T12:43:18.084161Z 76908 [Note] Aborted connection 76908 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2024-12-18T12:43:22.363849Z 0 [Note] Giving 1 client threads a chance to die gracefully
2024-12-18T12:43:22.363916Z 0 [Note] Shutting down slave threads
2024-12-18T12:43:24.364074Z 0 [Note] Forcefully disconnecting 0 remaining clients
2024-12-18T12:43:24.364183Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-12-18T12:43:24.364481Z 0 [Note] Binlog end
2024-12-18T12:43:24.394588Z 0 [Note] Shutting down plugin 'ngram'
2024-12-18T12:43:24.394603Z 0 [Note] Shutting down plugin 'partition'
2024-12-18T12:43:24.394608Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2024-12-18T12:43:24.394616Z 0 [Note] Shutting down plugin 'ARCHIVE'
2024-12-18T12:43:24.394620Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
Hello, do you have the latest log information? You can check the error log in the mysql management interface
Hello, is the Config file empty? Have you adjusted the configuration?
aaPanel_Kern
Contents of config file:
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /www/server/data/mysql
skip-external-locking
performance_schema_max_table_instances=400
table_definition_cache=400
table_open_cache = 4096
key_buffer_size = 1024M
max_allowed_packet = 1M
table_open_cache = 4096
sort_buffer_size = 16M
net_buffer_length = 8K
read_buffer_size = 16M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 256M
thread_cache_size = 512
query_cache_size = 512M
tmp_table_size = 512M
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
explicit_defaults_for_timestamp = true
#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
expire_logs_days = 10
#early-plugin-load = ""
#loose-innodb-trx=0
#loose-innodb-locks=0
#loose-innodb-lock-waits=0
#loose-innodb-cmp=0
#loose-innodb-cmp-per-index=0
#loose-innodb-cmp-per-index-reset=0
#loose-innodb-cmp-reset=0
#loose-innodb-cmpmem=0
#loose-innodb-cmpmem-reset=0
#loose-innodb-buffer-page=0
#loose-innodb-buffer-page-lru=0
#loose-innodb-buffer-pool-stats=0
#loose-innodb-metrics=0
#loose-innodb-ft-default-stopword=0
#loose-innodb-ft-inserted=0
#loose-innodb-ft-deleted=0
#loose-innodb-ft-being-deleted=0
#loose-innodb-ft-config=0
#loose-innodb-ft-index-cache=0
#loose-innodb-ft-index-table=0
#loose-innodb-sys-tables=0
#loose-innodb-sys-tablestats=0
#loose-innodb-sys-indexes=0
#loose-innodb-sys-columns=0
#loose-innodb-sys-fields=0
#loose-innodb-sys-foreign=0
#loose-innodb-sys-foreign-cols=0
default_storage_engine = InnoDB
innodb_data_home_dir = /www/server/data/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /www/server/data/mysql
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 1024M
sort_buffer_size = 16M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
SSH IP address, account password and port:
aapanel login link address and account password:
Detailed problem description:
No post link will not be able to know which user's information is, and the problem will not be processed
Hello, this is a problem caused by installing MariaDB using the apt command.
Hi still facing issue
2025-01-20T11:11:11.259823Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-01-20T11:11:11.259872Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2025-01-20T11:11:11.259902Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2025-01-20T11:11:11.259921Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 483042 ...
2025-01-20T11:11:11.391355Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-01-20T11:11:11.391388Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-01-20T11:11:11.391392Z 0 [Note] InnoDB: Uses event mutexes
2025-01-20T11:11:11.391395Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-01-20T11:11:11.391398Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-01-20T11:11:11.391844Z 0 [Note] InnoDB: Number of pools: 1
2025-01-20T11:11:11.391952Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-01-20T11:11:11.393307Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M
2025-01-20T11:11:11.666456Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-01-20T11:11:11.735413Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-01-20T11:11:11.748068Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-01-20T11:11:11.748574Z 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.3.39. Please follow the instructions at http://dev.mysql.com/doc/refman/5.7/en/upgrading-downgrading.html
2025-01-20T11:11:11.748589Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2025-01-20T11:11:12.048995Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2025-01-20T11:11:12.049028Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2025-01-20T11:11:12.049039Z 0 [ERROR] Failed to initialize builtin plugins.
2025-01-20T11:11:12.049047Z 0 [ERROR] Aborting
2025-01-20T11:11:12.049056Z 0 [Note] Binlog end
2025-01-20T11:11:12.049150Z 0 [Note] Shutting down plugin 'CSV'
2025-01-20T11:11:12.065396Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
Please help me solve this
Hello, try the server to do a snapshot backup and then operate
cp -aprf /www/server/data /www/server/data_bak222
cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak222
mv ib_logfile0 /tmp/ib_logfile0.bak222
mv ib_logfile1 /tmp/ib_logfile1.bak222
/etc/init.d/mysqld restartaaPanel_Kern
I did that but still same
Hello, is it possible to delete these files? Start again?
mysql-bin.index
mysql-bin.0*
I had some important data there... is it possible to take a back up of that first? So that I can restore it