[MDEV-25864] After upgrading from 10.2.14 to 10.4.12, wait almost 24 hours can not open database. Created: 2021-06-06 Updated: 2021-06-06 Resolved: 2021-06-06 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Upgrades |
| Affects Version/s: | 10.4.12 |
| Fix Version/s: | 10.4.14 |
| Type: | Bug | Priority: | Major |
| Reporter: | Kuijun Cui | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | upgrade | ||
| Environment: |
mysql@t2-bitsx-db304:~$ lscpu |
||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
Hi, Cummunity. I'd set innodb_fast_shutdown to 0 while I'm doing upgrade from 10.2.14 to 10.4.12, I want to upload my data file to convenient you to find the root cause, the updated file total size is 357.29 MB, but can not allow me to upload such volumn file, could you release me the restriction? |
| Comments |
| Comment by Elena Stepanova [ 2021-06-06 ] |
|
For starters, could you please attach the MariaDB error log and specify what exactly it means, "can not login [to] the database"? What error are you getting? |
| Comment by Kuijun Cui [ 2021-06-06 ] |
|
Uploaded the error log. |
| Comment by Elena Stepanova [ 2021-06-06 ] |
|
Judging by the log, your upgrade went well and the server re-started fine after it in the matter of seconds. |
| Comment by Kuijun Cui [ 2021-06-06 ] |
|
Q> "can not login [to] the database" It can be reproduced by the datafiles that I want to upload. |
| Comment by Elena Stepanova [ 2021-06-06 ] |
|
> I mean mariadb can not create socket to listen the port that it'll provide external service. There was the bug |
| Comment by Kuijun Cui [ 2021-06-06 ] |
|
Let me try, and feedback later. |
| Comment by Kuijun Cui [ 2021-06-06 ] |
|
It's really caused by the audit plugin, after disabled it, mariadb can create socket and listen the port now. |