• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Please beaware of a breaking change in the REST API on the next Plesk release (18.0.62).
    Starting from Plesk Obsidian 18.0.62, requests to REST API containing the Content-Type header with a media-type directive other than “application/json” will result in the HTTP “415 Unsupported Media Type” client error response code. Read more here

Question Upgrade MariaDB 10.3 to 10.11 via Plesk 18.0.61 on Debian 10

M

medjalil

New Pleskian
root@vps-b564bb81:/# sudo tail -n 100 /var/log/mysql/error.log
2024-05-28 15:33:01 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-28 15:33:01 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-28 15:33:01 0 [Note] InnoDB: Waiting for purge to start
2024-05-28 15:33:01 0 [Note] InnoDB: 10.3.39 started; log sequence number 140089405020; transaction id 103373182
2024-05-28 15:33:01 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-05-28 15:33:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-28 15:33:01 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-05-28 15:33:01 0 [Note] Reading of all Master_info entries succeeded
2024-05-28 15:33:01 0 [Note] Added new Master_info '' to hash table
2024-05-28 15:33:01 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.39-MariaDB-0+deb10u2' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10
2024-05-28 15:33:02 0 [Note] InnoDB: Buffer pool(s) load completed at 240528 15:33:02
2024-05-28 15:56:29 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-28 15:56:29 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-28 15:56:29 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-28 15:56:29 0 [Note] InnoDB: Starting shutdown...
2024-05-28 15:56:29 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-05-28 15:56:29 0 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25
2024-05-28 15:56:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 240528 15:56:29
2024-05-28 15:56:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-28 15:56:30 0 [Note] InnoDB: Shutdown completed; log sequence number 140093355808; transaction id 103378846
2024-05-28 15:56:30 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-05-28 15:56:31 0 [Note] Starting MariaDB 10.3.39-MariaDB-0+deb10u2 source revision ca001cf2048f0152689e1895e2dc15486dd0b1af as process 23093
2024-05-28 15:56:31 0 [Note] InnoDB: Using Linux native AIO
2024-05-28 15:56:31 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-05-28 15:56:31 0 [Note] InnoDB: Uses event mutexes
2024-05-28 15:56:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-28 15:56:31 0 [Note] InnoDB: Number of pools: 1
2024-05-28 15:56:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-28 15:56:31 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2024-05-28 15:56:31 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-28 15:56:31 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-05-28 15:56:31 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*40828928 bytes; LSN=140093355817
2024-05-28 15:56:31 0 [Note] InnoDB: Starting to delete and rewrite log files.
2024-05-28 15:56:31 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 40828928 bytes
2024-05-28 15:56:31 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 40828928 bytes
2024-05-28 15:56:31 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2024-05-28 15:56:31 0 [Note] InnoDB: New log files created, LSN=140093355817
2024-05-28 15:56:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-28 15:56:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-28 15:56:31 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-28 15:56:31 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-28 15:56:31 0 [Note] InnoDB: Waiting for purge to start
2024-05-28 15:56:31 0 [Note] InnoDB: 10.3.39 started; log sequence number 140093355817; transaction id 103378841
2024-05-28 15:56:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-28 15:56:31 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-05-28 15:56:31 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-05-28 15:56:31 0 [Note] Reading of all Master_info entries succeeded
2024-05-28 15:56:31 0 [Note] Added new Master_info '' to hash table
2024-05-28 15:56:31 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.39-MariaDB-0+deb10u2' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10
2024-05-28 15:56:32 0 [Note] InnoDB: Buffer pool(s) load completed at 240528 15:56:32
2024-05-28 15:57:26 38 [Warning] Aborted connection 38 to db: 'wordpress_b' user: 'wordpress_0' host: 'localhost' (Got an error reading communication packets)
2024-05-28 16:04:39 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-28 16:04:39 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-28 16:04:39 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-28 16:04:39 0 [Note] InnoDB: Starting shutdown...
2024-05-28 16:04:39 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-05-28 16:04:39 0 [Note] InnoDB: Instance 0, restricted to 4096 pages due to innodb_buf_pool_dump_pct=25
2024-05-28 16:04:39 0 [Note] InnoDB: Buffer pool(s) dump completed at 240528 16:04:39
2024-05-28 16:04:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-28 16:04:40 0 [Note] InnoDB: Shutdown completed; log sequence number 140094152598; transaction id 103380427
2024-05-28 16:04:40 0 [Note] /usr/sbin/mysqld: Shutdown complete

2024-05-28 16:04:40 0 [Note] Starting MariaDB 10.3.39-MariaDB-0+deb10u2 source revision ca001cf2048f0152689e1895e2dc15486dd0b1af as process 24783
2024-05-28 16:04:40 0 [Note] InnoDB: Using Linux native AIO
2024-05-28 16:04:40 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-05-28 16:04:40 0 [Note] InnoDB: Uses event mutexes
2024-05-28 16:04:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-28 16:04:40 0 [Note] InnoDB: Number of pools: 1
2024-05-28 16:04:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-28 16:04:40 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2024-05-28 16:04:40 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-28 16:04:40 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-05-28 16:04:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-28 16:04:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-28 16:04:40 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-28 16:04:40 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-05-28 16:04:40 0 [Note] InnoDB: Waiting for purge to start
2024-05-28 16:04:41 0 [Note] InnoDB: 10.3.39 started; log sequence number 140094152598; transaction id 103380394
2024-05-28 16:04:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-28 16:04:41 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-05-28 16:04:41 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-05-28 16:04:41 0 [Note] Reading of all Master_info entries succeeded
2024-05-28 16:04:41 0 [Note] Added new Master_info '' to hash table
2024-05-28 16:04:41 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.39-MariaDB-0+deb10u2' socket: '/run/mysqld/mysqld.sock' port: 3306 Debian 10
2024-05-28 16:04:42 0 [Note] InnoDB: Buffer pool(s) load completed at 240528 16:04:42
2024-05-28 16:05:14 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2024-05-28 16:05:14 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-28 16:05:14 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-28 16:05:14 0 [Note] InnoDB: Starting shutdown...
2024-05-28 16:05:14 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-05-28 16:05:14 0 [Note] InnoDB: Instance 0, restricted to 4096 pages due to innodb_buf_pool_dump_pct=25
2024-05-28 16:05:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 240528 16:05:14
2024-05-28 16:05:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-28 16:05:16 0 [Note] InnoDB: Shutdown completed; log sequence number 140094157687; transaction id 103381386
2024-05-28 16:05:16 0 [Note] /usr/sbin/mysqld: Shutdown complete
 

Attachments

  • Screenshot 2024-05-28 202146.png
    Screenshot 2024-05-28 202146.png
    80.7 KB · Views: 8
I can't tell for sure what's causing the issue your having as the information is rather limited. But for a possible solution to the error on the line below see this support article.
2024-05-28 15:57:26 38 [Warning] Aborted connection 38 to db: 'wordpress_b' user: 'wordpress_0' host: 'localhost' (Got an error reading communication packets)
Click to expand...
 
You must log in or register to reply here.

Similar threads

TimReeves
Resolved MariaDB Update to 10.11.7 via Plesk 18.0.60 on Debian 10
Replies
1
Views
330
TimReeves
TimReeves
H
Question MariaDB doesn't start after upgrade
Replies
3
Views
192
Kaspar@Plesk
Kaspar@Plesk
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
1K
emreboy
E
I
Resolved Mariadb does not start when upgrading plesk to 18.0.58 Update 1
Replies
2
Views
758
ivanes82
I
F
Question Having difficulties setting up MySQL docker for use in Plesk
Replies
3
Views
2K
aronaugust
A
Back
Top