MySQL server will not start after disk reconfiguration

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
nintendoeats
New here
Posts: 2
Joined: Wed Apr 07, 2021 9:03 am

MySQL server will not start after disk reconfiguration

Post by nintendoeats » Wed Apr 07, 2021 9:20 am

I have a TS-451D2.

I had everything set up, then decided that my disk configuration was suboptimal. I had 1 disk on its own, and 3 other disks in a RAID5. I cleared out the single disk and added it to the RAID5 array

3-days later

Ok, now everything works except the MySQL server. I don't care about the data that was on it, but I do need it to run. I found a few people online who had similar problems, but nothing that was directly applicable enough for it to be clear to me what the problem is.

phpmyadmin cannot access the server. netstat | grep 3306 pulls up nothing.

I tried updating the firmware hoping that would clear the issue, but to no avail. I tried re-initializing it (both in the GUI and using the shell script), nadda. I tried to manually start it, but it says that I don't have permission.

Below is my error log. Ir seems to be having issues locking files. I tried killing all MySQL processes, and restarting them, but again to no avail.
210406 19:08:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
210406 19:08:23 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.57-MariaDB) starting as process 22669 ...
210406 19:08:24 InnoDB: The InnoDB memory heap is disabled
210406 19:08:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210406 19:08:24 InnoDB: Compressed tables use zlib 1.2.3
210406 19:08:24 InnoDB: Initializing buffer pool, size = 128.0M
210406 19:08:24 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
210406 19:08:24 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
210406 19:08:49 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
210406 19:08:52 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
210406 19:09:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
210406 19:09:01 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.57-MariaDB) starting as process 23840 ...
210406 19:09:09 [ERROR] mysqld: Can't lock aria control file '/usr/local/mysql/var/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
210406 19:09:35 InnoDB: Waiting for the background threads to start
210406 19:09:36 Percona XtraDB (http://www.percona.com) 5.5.55-MariaDB-38.8 started; log sequence number 0
210406 19:09:36 [Note] Plugin 'FEEDBACK' is disabled.
210406 19:09:40 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/usr/local/mysql/var/aria_log_control'021
210406 19:09:40 [ERROR] Plugin 'Aria' init function returned error.ter.err
210406 19:09:40 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
210406 19:09:40 InnoDB: The InnoDB memory heap is disabled
210406 19:09:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
210406 19:09:40 InnoDB: Compressed tables use zlib 1.2.3r"
210406 19:09:40 InnoDB: Initializing buffer pool, size = 128.0M
210406 19:09:40 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.p with two
210406 19:09:40 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
210406 19:09:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
210406 19:09:42 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.57-MariaDB) starting as process 25180 ...
210406 19:09:42 [Note] Server socket created on IP: '0.0.0.0'.mysql/var/.RemoteButter.err.swp"
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.r.swp" already exists!
InnoDB: Unable to lock ./ibdata1, error: 11adonly] 1418L, 80415C
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.er mysqld proces
InnoDB: Unable to lock ./ibdata1, error: 11
I could do this in a VM, but it would be nice to use the built-in server.

Thanks!

User avatar
Toxic17
Ask me anything
Posts: 5675
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: MySQL server will not start after disk reconfiguration

Post by Toxic17 » Wed Apr 07, 2021 3:36 pm

Hi there.

I'm just curious have you tried to reinitialize the database and/or resetting the root password from the GUI?

Since your model of NAS is fairly new have you updated to the latest version just released QTS 4.5.2.1605 build 20210312, since there maybe a known bug fix for this. failing that, you may need to raise a ticket with QNAP to help them understand what is going on with the SQL Service.
Regards Simon

QTS 4.x User Guidex

QNAP Club Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following


NAS: TS-473-32GB QM2-2P QXG-10G1T 4.5.3.1652 • TVS-463-16GB 4.5.3.1652 QM2-2S10G1TB • TS-459 Pro 2GB 4.2.6 • TS-121 4.3.3.1624 • APC Back-UPS ES 700G
Network: VM Hub3 • UniFi UDM Pro 1.10-0.9 • Controller: 6.2.23 • UniFi US-16-150W/US-8-60W 5.60.3 • USW Mini Flex 1.8.4 • UniFi G3-Flex • AP: AC Pro 5.60.3 • U6-LR 5.60.3

nintendoeats
New here
Posts: 2
Joined: Wed Apr 07, 2021 9:03 am

Re: MySQL server will not start after disk reconfiguration

Post by nintendoeats » Wed Apr 07, 2021 7:27 pm

Hi, thanks for the quick response.

I have reinitialized and reset the password using both the gui and the shell script (mysql_utilities.sh I think it's called). I suspect that the GUI is just calling the shell script, since they have the same options.

I was on the previous firmware when this problem started. I updated to 1605 last night and it didn't have any effect.

Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”