MySQL Forums
Forum List  »  Newbie

mysqld won't start on Windows 10
Posted by: CE Stanley
Date: October 13, 2016 11:11AM

I am new to MySQL and am having problems getting mysqld to remain running on a newly imaged Windows 10 PC. mysqld starts and shows in Task Manager but stops very soon after it starts. My error log is mostly empty an contains no errors, just Notes:

2016-10-13T16:52:20.432937Z 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap.
2016-10-13T16:52:20.433940Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.15) starting as process 6900 ...
2016-10-13T16:52:20.435943Z 0 [Note] --initialize specifed on an existing data directory.
2016-10-13T16:52:20.443454Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-13T16:52:20.444455Z 0 [Note] InnoDB: Uses event mutexes
2016-10-13T16:52:20.445456Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-10-13T16:52:20.446459Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-13T16:52:20.446459Z 0 [Note] InnoDB: Number of pools: 1
2016-10-13T16:52:20.447459Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-10-13T16:52:20.450459Z 0 [Note] InnoDB: Initializing buffer pool, total size = 47M, instances = 1, chunk size = 47M
2016-10-13T16:52:20.452460Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-10-13T16:52:20.464625Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2016-10-13T16:52:20.465640Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-13T16:52:20.499824Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
2016-10-13T16:52:20.506824Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 24 MB
2016-10-13T16:52:20.576072Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 24 MB
2016-10-13T16:52:20.676768Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2016-10-13T16:52:20.677776Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-13T16:52:20.678775Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-10-13T16:52:20.680773Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-13T16:52:20.720981Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-10-13T16:52:20.722984Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-10-13T16:52:20.758585Z 0 [Note] InnoDB: Doublewrite buffer created
2016-10-13T16:52:20.774231Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-10-13T16:52:20.775236Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-10-13T16:52:20.776234Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-10-13T16:52:20.795300Z 0 [Note] InnoDB: Foreign key constraint system tables created
2016-10-13T16:52:20.795300Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-10-13T16:52:20.804091Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2016-10-13T16:52:20.804985Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2016-10-13T16:52:20.812617Z 0 [Note] InnoDB: sys_virtual table created
2016-10-13T16:52:20.812617Z 0 [Note] InnoDB: Waiting for purge to start
2016-10-13T16:52:20.864517Z 0 [Note] InnoDB: 5.7.15 started; log sequence number 0
2016-10-13T16:52:20.865517Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-10-13T16:52:20.867516Z 0 [Note] Salting uuid generator variables, current_pid: 6900, server_start_time: 1476377540, bytes_sent: 0,
2016-10-13T16:52:20.872335Z 0 [Note] Generated uuid: '684938c3-9165-11e6-a2f6-10bf48b8489d', server_start_time: 1476384440, bytes_sent: 2720802337712
2016-10-13T16:52:20.874335Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 684938c3-9165-11e6-a2f6-10bf48b8489d.
2016-10-13T16:52:20.887992Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-13T16:52:20.890582Z 1 [Note] Creating the system database
2016-10-13T16:52:20.896154Z 1 [Note] A temporary password is generated for root@localhost: visuR*UBx9Qe
2016-10-13T16:52:20.899154Z 1 [Note] Creating the system tables
2016-10-13T16:52:22.307340Z 1 [Note] Filling in the system tables, part 1
2016-10-13T16:52:22.314342Z 1 [Note] Filling in the system tables, part 2
2016-10-13T16:52:22.314342Z 1 [Note] Filling in the mysql.help table
2016-10-13T16:52:22.802882Z 1 [Note] Creating the sys schema
2016-10-13T16:52:23.663739Z 1 [Note] Bootstrapping complete
2016-10-13T16:52:23.664740Z 0 [Note] Binlog end
2016-10-13T16:52:23.667742Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-10-13T16:52:23.667742Z 0 [Note] InnoDB: Starting shutdown...
2016-10-13T16:52:23.769164Z 0 [Note] InnoDB: Dumping buffer pool(s) to c:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-13T16:52:23.772169Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161013 9:52:23
2016-10-13T16:52:24.915145Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2528505
2016-10-13T16:52:24.916145Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"



Anyone have any ideas what is going on? Why mysqld stops after starting? I am specifing error_log_verbosity=3 to get this information. Is there some command line option to get more information or get information from innoDB and why it is shutting down?

Options: ReplyQuote


Subject
Written By
Posted
mysqld won't start on Windows 10
October 13, 2016 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.