Error 87 on 3TB USB DISK (Win7) 1.7.7 [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error 87 on 3TB USB DISK (Win7) 1.7.7 [SOLVED]

Postby magicGT » 02. January 2012 09:46

Hello,

I'm experiencing strange problem. I have downloaded latest version of xampp 1.7.7. extracted from zip on my local hard drive.
After doing setup_xampp.bat I have run xampp_control.exe and both apache and mysql started without any problems.

I have decided to copy this xampp to my USB hard drive (3 terabytes), I have again run setup_xampp.bat and xampp_control.exe but this time mysql didn't start. Apache is running nicely but mysql won't budge.

I have checked mysql log for USB drive:

120102 9:38:30 [Note] Plugin 'FEDERATED' is disabled.
120102 9:38:30 InnoDB: The InnoDB memory heap is disabled
120102 9:38:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120102 9:38:30 InnoDB: Compressed tables use zlib 1.2.3
120102 9:38:30 InnoDB: Initializing buffer pool, size = 16.0M
120102 9:38:30 InnoDB: Completed initialization of buffer pool
120102 9:38:30 InnoDB: highest supported file format is Barracuda.
120102 9:38:30 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name F:\xampp 1.7.7\mysql\data\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.


I have checked local hard drive log as well:
120102 9:41:46 [Note] Plugin 'FEDERATED' is disabled.
120102 9:41:46 InnoDB: The InnoDB memory heap is disabled
120102 9:41:46 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120102 9:41:46 InnoDB: Compressed tables use zlib 1.2.3
120102 9:41:46 InnoDB: Initializing buffer pool, size = 16.0M
120102 9:41:46 InnoDB: Completed initialization of buffer pool
120102 9:41:46 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120102 9:41:46 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120102 9:41:47 InnoDB: Waiting for the background threads to start
120102 9:41:48 InnoDB: 1.1.8 started; log sequence number 1595675
120102 9:41:48 [Note] Event Scheduler: Loaded 0 events
120102 9:41:48 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)


It runs but It looks like it found same problems "starting crash recovery". I have also used USB drive with 1 terabyte capacity and I have no such problems.
Do You tink 3 terabytes might have caused this problem? Did anyone came across something like that?

regards, magicGT
magicGT
 
Posts: 2
Joined: 02. January 2012 09:31
Operating System: Windows 7

Re: Error 87 on 2TB USB DISK

Postby Sharley » 02. January 2012 10:00

Possible bug related to the size of the sectors in a large 2TB plus formatted hard drive.
http://bugs.mysql.com/bug.php?id=28913

Please try these workarounds:
Open the \xampp\mysql\bin\my.ini file scroll down to the innodb section and add this as the last line of the section
Code: Select all
innodb_flush_method=unbuffered
Save the file and try and start MySQL again.

If that does not allow you to move on then try the alternate line
Code: Select all
innodb_flush_method=normal
Again save the file and try and start MySQL again.

Make a Backup of any file you want to edit first.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Error 87 on 3TB USB DISK

Postby magicGT » 02. January 2012 10:47

Hmm, I wasn't aware of this issue. Thank You very much for quick reply.
I have tried first method (unbuffered), but it didn't wok. Then I have used alternate method and now it works like a charm :)

Thank You very much for Your help and Happy New Year :D

regards, magicGT
magicGT
 
Posts: 2
Joined: 02. January 2012 09:31
Operating System: Windows 7

Re: Error 87 on 3TB USB DISK

Postby Sharley » 02. January 2012 10:53

Thanks for the feedback and I am also pleased that you can now move on. 8)

I will close this now and mark it solved. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 67 guests