Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mySql Error #27

Closed
janenycxo opened this issue Mar 26, 2020 · 12 comments
Closed

mySql Error #27

janenycxo opened this issue Mar 26, 2020 · 12 comments

Comments

@janenycxo
Copy link

@janenycxo janenycxo commented Mar 26, 2020

After ruling out port conflicts via currports, and doing a backup/uninstall/reinstall, I am still experiencing an error for mySql when starting Xampp-

Here are the details for xampp-

9:18:26 PM [main] Initializing Control Panel
9:18:26 PM [main] Windows Version: Enterprise 64-bit
9:18:26 PM [main] XAMPP Version: 7.4.3
9:18:26 PM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
9:18:26 PM [main] Running with Administrator rights - good!
9:18:26 PM [main] XAMPP Installation Directory: "c:\xampp"
9:18:26 PM [main] Checking for prerequisites
9:18:26 PM [main] All prerequisites found
9:18:26 PM [main] Initializing Modules
9:18:26 PM [Apache] XAMPP Apache Service is already running on port 80
9:18:26 PM [Apache] XAMPP Apache Service is already running on port 443
9:18:26 PM [main] The FileZilla module is disabled
9:18:26 PM [main] The Mercury module is disabled
9:18:26 PM [main] The Tomcat module is disabled
9:18:26 PM [main] Enabling autostart for module "MySQL"
9:18:26 PM [main] Starting Check-Timer
9:18:26 PM [main] Control Panel Ready
9:18:26 PM [mysql] Autostart active: starting...
9:18:26 PM [mysql] Attempting to start MySQL service...
9:18:27 PM [mysql] Status change detected: running
9:18:33 PM [mysql] Status change detected: stopped
9:18:33 PM [mysql] Error: MySQL shutdown unexpectedly.
9:18:33 PM [mysql] This may be due to a blocked port, missing dependencies,
9:18:33 PM [mysql] improper privileges, a crash, or a shutdown by another method.
9:18:33 PM [mysql] Press the Logs button to view error logs and check
9:18:33 PM [mysql] the Windows Event Viewer for more clues
9:18:33 PM [mysql] If you need more help, copy and post this
9:18:33 PM [mysql] entire log window on the forums

and here are the details from mysql_error.log

InnoDB: using atomic writes.
2020-03-25 21:00:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-25 21:00:32 0 [Note] InnoDB: Uses event mutexes
2020-03-25 21:00:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-25 21:00:32 0 [Note] InnoDB: Number of pools: 1
2020-03-25 21:00:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-25 21:00:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-25 21:00:32 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-25 21:00:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-25 21:00:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-25 21:00:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-25 21:00:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-25 21:00:32 0 [Note] InnoDB: Waiting for purge to start
2020-03-25 21:00:32 0 [Note] InnoDB: 10.4.11 started; log sequence number 301256; transaction id 171
2020-03-25 21:00:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-25 21:00:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-25 21:00:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200325 21:00:32
2020-03-25 21:00:32 0 [Note] Server socket created on IP: '::'.
2020-03-25 21:00:32 7 [Note] Reading Master_info: 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-03-25 21:00:32 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2020-03-25 21:00:32 7 [ERROR] log 2020-03-18 16:55:01 7 [Note] Initialized Master_info from 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' listed in the index, but failed to stat
2020-03-25 21:00:32 7 [ERROR] Error counting relay log space
2020-03-25 21:00:32 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2020-03-25 21:00:32 7 [Note] Added new Master_info '2020-03-18 16:51:28 0 [Note] Reading of all Master_info entries succeeded ' to hash table
2020-03-25 21:00:32 7 [Note] Reading Master_info: 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-03-25 21:00:32 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000014' (relay_log_pos 4)
2020-03-25 21:00:32 7 [ERROR] Could not find target log during relay log initialization
2020-03-25 21:00:32 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
2020-03-25 21:00:32 7 [Note] Added new Master_info '2020-03-18 16:51:28 0 [Note] Added new Master_info '' to hash table ' to hash table
2020-03-25 21:00:32 7 [Note] Reading Master_info: 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-03-25 21:00:32 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000008' (relay_log_pos 4)
2020-03-25 21:00:32 7 [ERROR] Could not find target log during relay log initialization
2020-03-25 21:00:32 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d18@002016@003a51@003a28@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2020-03-25 21:00:32 7 [Note] Added new Master_info '2020-03-18 16:51:28 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections. ' to hash table
2020-03-25 21:00:32 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-03-25 21:00:32 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-03-25 21:00:32 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ' to hash table
2020-03-25 21:00:32 8 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-03-25 21:00:32 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution '
2020-03-25 21:00:32 9 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000076' position: 4
2020-03-25 21:00:32 8 [ERROR] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-03-25 21:00:32 0 [Warning] Reading of some Master_info entries failed
2020-03-25 21:00:32 8 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ': Slave I/O thread killed while connecting to master
2020-03-25 21:00:32 0 [ERROR] Failed to initialize multi master structures
2020-03-25 21:00:32 8 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution ': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-03-25 21:00:32 0 [ERROR] Aborting

Thank you for helping me troubleshoot!
Jane

@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 26, 2020

Hi @janenycxo - Do you have a moment this afternoon when we can jump on Zoom and screenshare/troubleshoot? I'm available until 2pm and then again after 4:30pm.

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 26, 2020

Hi @janenycxo - Do you have a moment this afternoon when we can jump on Zoom and screenshare/troubleshoot? I'm available until 2pm and then again after 4:30pm.

Yes, I am available today and can screen share. I appreciate any help to diagnose why MySQL stopped working.

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 26, 2020

Meeting ID 469-783-0374

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 26, 2020

i will keep the meeting on until 6pm , if it doesnt work out, we can schedule something another time. thank you! J

@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 26, 2020

Hi @janenycxo - So sorry I was missing in action - I had a computer failure midday that threw me into a panic in terms of finishing some lecture videos for another course - I ended up shutting my email off to focus so I missed the reply to this.

Can we try again tomorrow (Friday)? Let me know when would work for you!

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 27, 2020

Hi @susanBuck - anytime after 1pm works for me. I have a feeling it will be a quick fix with your input :) thank you for your time.

@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 27, 2020

Ok - will plan on connecting some time after 1pm! Here is my Zoom URL: https://harvard.zoom.us/my/susanbuck

Also - I'm doing some research on your issue in preparation for meeting later today, and wanted to include a copy of my MySQL log here - just to have a point of comparison for what it should look like when it starts up.

InnoDB: using atomic writes.
2020-03-27  8:11:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-27  8:11:40 0 [Note] InnoDB: Uses event mutexes
2020-03-27  8:11:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-27  8:11:40 0 [Note] InnoDB: Number of pools: 1
2020-03-27  8:11:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-27  8:11:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-27  8:11:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-27  8:11:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300324
2020-03-27  8:11:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-27  8:11:41 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-27  8:11:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-27  8:11:41 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-27  8:11:41 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-27  8:11:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:41 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:42 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:42 0 [Note] InnoDB: Waiting for purge to start
2020-03-27  8:11:42 0 [Note] InnoDB: 10.4.11 started; log sequence number 300333; transaction id 171
2020-03-27  8:11:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-27  8:11:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-27  8:11:42 0 [Note] InnoDB: Buffer pool(s) load completed at 200327  8:11:42
2020-03-27  8:11:42 0 [Note] Server socket created on IP: '::'.
@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 27, 2020

In researching this, and based on the output from your MySQL log, it seems like this might be related to a corrupt data file within the MySQL install.

Try deleting the following files and then restarting MySQL.

  • C:\xampp\mysql\data\aria_log.00000001
  • C:\xampp\mysql\data\aria_log_control
  • C:\xampp\mysql\data\multi-master.info

image

If that doesn't work, when we connect this afternoon we'll try a few other things.

Ref:

@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 27, 2020

FYI - I'm about to hop on a couple virtual meetings, but I'll be available again after 3:30pm

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 27, 2020

@susanBuck
I have also been searching on apachefriends and tried deleting the 3 files outlined in your post, unfortunately mySql is still giving me trouble.

Here is the errorlog-

InnoDB: using atomic writes.
2020-03-27 12:41:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-27 12:41:13 0 [Note] InnoDB: Uses event mutexes
2020-03-27 12:41:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-27 12:41:13 0 [Note] InnoDB: Number of pools: 1
2020-03-27 12:41:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-27 12:41:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-27 12:41:13 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-27 12:41:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-27 12:41:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-27 12:41:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-27 12:41:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-27 12:41:13 0 [Note] InnoDB: Waiting for purge to start
2020-03-27 12:41:13 0 [Note] InnoDB: 10.4.11 started; log sequence number 301310; transaction id 171
2020-03-27 12:41:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-27 12:41:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-27 12:41:13 0 [Note] Zerofilling moved table:  '.\mysql\plugin'
2020-03-27 12:41:13 0 [Note] InnoDB: Buffer pool(s) load completed at 200327 12:41:13
2020-03-27 12:41:13 0 [Note] Zerofilling moved table:  '.\mysql\servers'
2020-03-27 12:41:13 0 [Note] Server socket created on IP: '::'.
2020-03-27 12:41:13 0 [Note] Zerofilling moved table:  '.\mysql\db'
2020-03-27 12:41:14 0 [ERROR] (null).(null): Page 8192: Got error 176 when reading index file
2020-03-27 12:41:14 0 [Warning] Checking table:   '.\mysql\db'
2020-03-27 12:41:14 0 [ERROR] mysql.db: Table is from another system and must be zerofilled or repaired to be usable on this system
2020-03-27 12:41:14 0 [Warning] Recovering table: '.\mysql\db'
2020-03-27 12:41:14 0 [Note] mysql.db: Wrong CRC on datapage at 1
2020-03-27 12:41:14 0 [ERROR] mysql.db: Rows lost (Found 0 of 3); Aborting because safe repair was requested
2020-03-27 12:41:14 0 [ERROR] Couldn't repair table: mysql.db
2020-03-27 12:41:14 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'db' is corrupt; try to repair it
2020-03-27 12:41:14 0 [ERROR] Aborting

FYI - I'm about to hop on a couple virtual meetings, but I'll be available again after 3:30pm

My kids have the computers until 12:30pm for their virtual classrooms (isnt it neat how NYC Doe has come full circle to offer that to keep students/classes/teachers engaged during the closure)

It would be great to get mySQL up and running. I already watched this week's lecture and turned in the week 8 assignment but would like to practice and follow along this weeks' lecture examples.

@susanBuck

This comment has been minimized.

Copy link
Owner

@susanBuck susanBuck commented Mar 27, 2020

On the plus side, it looks like deleting those files did change the error message you're getting. That's some progress. : )

Now it looks like maybe the database is corrupt:

mysql.db: Table is from another system and must be zerofilled or repaired to be usable on this system

Researching this now, and am in Zoom whenever you're ready. 👍

@janenycxo

This comment has been minimized.

Copy link
Author

@janenycxo janenycxo commented Mar 27, 2020

Susan is such a blessing! We uninstalled xampp through the app, by going directly to the folder. Previously, I had uninstalled through the control panel which may have retained files preventing reboot. Just don't forget to backup folders before uninstall.

Thanks to @susanBuck again for her continued support (and sillyy troubleshooting).

@janenycxo janenycxo closed this Mar 27, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.