Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

InnoDB: Database was not shut down normally!

From: John Gehring <john.gehring(at)gmail.com>
Date: Thu Oct 11 2007 - 13:28:14 EDT


I get the following message in the .err file after running my mysql++ application:

071011 10:48:07 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...
InnoDB: Doing recovery: scanned up to log sequence number 0 1460518
071011 10:48:07 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed

After running the embedded application, the log does not always contain messages about "Starting an apply batch of log...". However, the "InnoDB: Database was not shut down normally!" message is consistently there.

If I access the same database via mysqld, I do not see these messages once I have opened and closed the database a couple of times. I am shutting down the mysqld before running the embedded app.

I notice in the mysql++ code that mysql_library_end() is not called, but it seems that the mysql embedded documentation states that this function should be called. Can anyone shed some light on this?

I'm running the following (all debug configuration): mysql++-2.3.2 - built on my machine with Microsoft VC++ 2005, linked against:
mysql sever 5.1 (using the libmysqld.dll that came with the distribution) Received on Thu Oct 11 13:28:28 2007

This archive was generated by hypermail 2.1.8 : Fri Jul 04 2008 - 00:21:29 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library