Cannot open database because the database engine reported an error

Posted By Bioguy over 7 years ago

I recently changed my data drive (E:) with two 3TB drives using Storage Spaces in Win 10 as one drive with replication (similar to RAID 1). I chose GPT as the format. Now I get a error saying Simply cannot open the database because the database engine reported an error. The error log reports the following:

160524 11:32:53 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: dev.mysql.com/.../operating-system-error-codes.html
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.

I can transfer the Simply data files to my Drive C (SSD), and Simply opens the database ok. I have made sure the properties of the folder on my E drive allow all access to all users, so that should not be the problem.

Amy suggestions?

0 RandyW over 7 years ago

MySQL was developed from the Unix/Linux Open Source world, and generally requires direct (SCSI) access to its disk storage. It can work with most filesystems, or even with raw, unformatted disk space, but it's not surprising to me that it doesn't work with a new Microsoft disk system.

This:

http://www.independent-software.com/mysql-error-1067-windows-error-87-error_invalid_parameter/

and this:

http://bugs.mysql.com/bug.php?id=28913

suggest that adding this:

1

innodb_flush_method=normal

to the database configuration file may help.

(This is a peer support forum, and I am not connected with Sage software in any way. You can try this, but the standard Open Source warranty applies - if something breaks, you keep both pieces.)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Bioguy over 7 years ago in reply to RandyW

Thanks for the reply. Where do I find the database configuration file in Sage Simply Accounting (I am using Simply 2011 pro)?.
Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ginkgo Bike over 7 years ago in reply to Bioguy

What version of Sage 50 are you running, some of the earlier versions did not like large drives (1 TB and larger), the more recent versions now have no problem with them. This was due to some sort of issue in the MySQL database engine that was used.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

Cannot open database because the database engine reported an error

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING