win2008,Mysql5.6,mysql Service failed to start

Check the event log , Report errors InnoDB: Attempted to open a previously opened tablespace

The final solution , modify my.ini

hold innodb_force_recovery = 0 modify  innodb_force_recovery = 1

================================================

Parameters Innodb_force_recovery Affect the whole InnoDB The recovery status of the storage engine . Default 0

Because the log is corrupted , Here, unconventional means are used , The first change innodb_force_recovery Parameters , send mysqld Skip recovery steps , take mysqld start-up , Export the data and rebuild the database .

innodb_force_recovery It can be set to 1-6, Large numbers contain the influence of all the preceding numbers .

1. (SRV_FORCE_IGNORE_CORRUPT): Ignore the detected corrupt page .
  2. (SRV_FORCE_NO_BACKGROUND): Prevent the main thread from running , If the main thread needs to execute full purge operation , It can lead to crash.
  3. (SRV_FORCE_NO_TRX_UNDO): Do not perform transaction rollback operation .
  4. (SRV_FORCE_NO_IBUF_MERGE): Do not perform merge operation of insert buffer .
  5. (SRV_FORCE_NO_UNDO_LOG_SCAN): Don't view redo logs ,InnoDB The storage engine treats uncommitted transactions as committed .
  6. (SRV_FORCE_NO_LOG_REDO): Do not roll forward .

Be careful

a When the setting parameter value is greater than 0 after , It can be done on the watch select,create,drop operation , but insert,update perhaps delete This kind of operation is not allowed .

Do logical export to database immediately , When it's done, it will innodb_force_recovery Set to 0 ,innodb_purge_thread=1 , Then rebuild the database .

Mysql Can't start InnoDB: Attempted to open a previously opened tablespace More articles about

  1. Can't start Mysql service , error InnoDB: Attempted to open a previously opened tablespace.

    2013-08-04 13:48:22 760 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous t ...

  2. Mysql Launch encountered The server quit without updating PID file (/[FAILED]l/mysql/data/021rjsh216086s.pid) and Attempted to open a previously opened tablespace

    Today, while testing the server for debugging , encounter Mysql The start-up problem of , Seems to be PID The file is missing . It's not scientific , A few days ago, it was fine , I didn't mess with it , Then a call to Baidu , Found several solutions . 1. Maybe it already exists mysql process ...

  3. XAMPP start-up mysql Report errors InnoDB: Error: could not open single-table tablespace file……

    The latest version was installed yesterday XAMPP for Windows 1.8.3. Open this morning XAMPP double-click mysql Start Button error , as follows ( Partial intercept ): 2013-09-17 10:12:02 9012 [E ...

  4. MySQL Can't start , appear “ A system error occurred 1067.”

    A scenario Use net start mysql Can't start , And appear : A system error occurred 1067. To solve the process There are many situations that can cause this error prompt , You can find "Windows journal " : open ...

  5. 【mysql start-up Innodb Methods 】

    Click here to enter the original page 1. What is the storage engine ? Mysql The data in is stored in files using various techniques ( Or memory ) in . Each of these technologies uses a different storage mechanism . Indexing techniques . Lock levels and ultimately provide a wide range of different functions and capabilities . ...

  6. MySQL Database and InnoDB Storage engine files

    Parameter file When MySQL When the example starts , The database will first read a configuration parameters file , It is used to find the location of various files in the database and specify some initialization parameters , These parameters usually define the size of a memory structure . By default ,MySQL Examples will follow a certain ...

  7. MySQL kernel :InnoDB Storage engine volume 1

    MySQL kernel :InnoDB Storage engine volumes 1(MySQL field Oracle ACE Experts work hard , A number of MySQL Oracle ACE lionized , thorough MySQL Database kernel source code analysis ,InnoDB Kernel development and optimization Essential Dictionary ) ...

  8. MySql MyISAM and InnoDB The difference between

    MyISAM: This is the default type , It's based on the tradition of ISAM type ,ISAM yes Indexed Sequential Access Method ( Indexed Sequential access method ) Abbreviation , It's the standard way to store records and files . ...

  9. mysql Start of

    1. Direct use mysqld Manual start [root@ora11g bin]# ./mysqld --defaults-file=../my.cnf :: [ERROR] Fatal error: Please ...

Random recommendation

  1. apache Open source project -- Wicket

    [infoq] Apache Wicket Is a powerful . Component based lightweight Web Application framework , Good separation of presentation and business logic . You can use it to create easy to test . High quality of debugging and support Web 2.0 application . Suppose other teams deliver ...

  2. Java String and StringBuffer The difference between

    1.String The definition of a class is like this : public final class String extends Object implements   Serializable, Comparable< ...

  3. UED Complete works of

    http://www.baiduux.com/   Baidu UFOhttp://ued.sohu.com/   sohu UEDhttp://ued.taobao.com/   TaoBao UEDhttp://www.ued ...

  4. Ionic3 Create an (Android)

    open CMD Enter the project directory from the command line Create a App project ionic start myApp blank blank App ionic start myApp tabs Navigation bar ionic start myA ...

  5. Share a mac for redis-desktop-manager Cracked version of the installation package

    link : https://pan.baidu.com/s/1BDndGmBlWoSr4hVLpF3FVw  Extraction code : wwir

  6. In the project Java Resources There are red forks , There is no other , terms of settlement

    Speaking of this place , I've changed my class for a long time   At first , I put the original project JDK The version has changed , Right-click on the project Build Path, Then change the inside JRE, useless ,  Then right-click on the item , Click on properties, Found in the Project Facet ...

  7. python(58):python Underline

    Detailed explanation Python Underline in This article will discuss Python Middle underline (_) How to use characters . We'll see , just as Python A lot of things in , Most of the different uses of underscores ( Not all ) It's just common practice . Underline (_) Common feelings ...

  8. lazy-mock , A lazy tool for generating backend simulation data

    lazy-mock lazy-mock Is based on koa2 Built , Use lowdb Persist data to JSON file . It only needs a simple configuration to implement and json-server Similar functions , But compared to json-server more ...

  9. SSH Summary of framework building steps and Hibernate Second level cache , The query cache

    Second level cache . The query cache First level cache : The default startup , The life cycle is and session synchronous ,session exclusive Second level cache : Need to load configuration information , The life cycle is synchronized with the application server ,session share 1: stay hibernate. ...

  10. sudo Logging (rsyslog)

    1, Check software rpm -qa|egrep "sudo|rsyslog" 2, edit sudoers echo "Defaults logfile=/var/log/sudo.l ...