MySQL don't start

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL don't start

Postby storman » 06. March 2020 19:03

Hello

I'm using xampp latest version on Windows 10 64 bit PC. Xampp was working just fine for along period since installation. Suddenly, MySQL can't be started and keeps shutting down.

I receive this message from the control panel

Code: Select all
8:00:59 PM  [mysql]    Attempting to start MySQL app...
8:00:59 PM  [mysql]    Status change detected: running
8:01:03 PM  [mysql]    Status change detected: stopped
8:01:03 PM  [mysql]    Error: MySQL shutdown unexpectedly.
8:01:03 PM  [mysql]    This may be due to a blocked port, missing dependencies,
8:01:03 PM  [mysql]    improper privileges, a crash, or a shutdown by another method.
8:01:03 PM  [mysql]    Press the Logs button to view error logs and check
8:01:03 PM  [mysql]    the Windows Event Viewer for more clues
8:01:04 PM  [mysql]    If you need more help, copy and post this
8:01:04 PM  [mysql]    entire log window on the forums



and this is the error log
Code: Select all
2020-03-06 19:52:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-06 19:52:57 0 [Note] InnoDB: Uses event mutexes
2020-03-06 19:52:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-06 19:52:57 0 [Note] InnoDB: Number of pools: 1
2020-03-06 19:52:57 0 [Note] InnoDB: Using generic crc32 instructions
2020-03-06 19:52:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-06 19:52:57 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-06 19:52:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-06 19:52:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-06 19:52:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-06 19:52:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-06 19:52:57 0 [Note] InnoDB: Waiting for purge to start
2020-03-06 19:52:57 0 [Note] InnoDB: 10.4.11 started; log sequence number 3692619; transaction id 372
2020-03-06 19:52:57 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2020-03-06 19:52:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-06 19:52:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-06 19:52:57 0 [Note] Server socket created on IP: '::'.


any help?

thanks in advance
storman
 
Posts: 5
Joined: 06. March 2020 18:58
XAMPP version: 3.2.4
Operating System: Windows 10 64 bit

Re: MySQL don't start

Postby storman » 08. March 2020 04:28

using Xampp latest version

Image
Image
storman
 
Posts: 5
Joined: 06. March 2020 18:58
XAMPP version: 3.2.4
Operating System: Windows 10 64 bit

Re: MySQL don't start

Postby Oluwataye » 08. June 2020 14:25

Same challange i'm facing. Please i need solution to the problems above. Why would almost all beginners faced with same challange. Its discouraging, someone profer solution to the above stated problem. Thanks
Oluwataye
 
Posts: 5
Joined: 14. February 2020 12:05
XAMPP version: 7.4.2
Operating System: window 10

Re: MySQL don't start

Postby ronwoodtd » 12. June 2020 12:29

My MySQL won't start either. Here is the log:

2020-06-12 12:23:46 13200 [Note] Plugin 'FEDERATED' is disabled.
2020-06-12 12:23:46 2578 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2020-06-12 12:23:46 13200 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-06-12 12:23:46 13200 [Note] InnoDB: The InnoDB memory heap is disabled
2020-06-12 12:23:46 13200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-06-12 12:23:46 13200 [Note] InnoDB: Memory barrier is not used
2020-06-12 12:23:46 13200 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-06-12 12:23:46 13200 [Note] InnoDB: Not using CPU crc32 instructions
2020-06-12 12:23:46 13200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2020-06-12 12:23:46 13200 [Note] InnoDB: Completed initialization of buffer pool
2020-06-12 12:23:46 13200 [Note] InnoDB: Highest supported file format is Barracuda.
2020-06-12 12:23:46 13200 [Note] InnoDB: 128 rollback segment(s) are active.
2020-06-12 12:23:46 13200 [Note] InnoDB: Waiting for purge to start
2020-06-12 12:23:46 13200 [Note] InnoDB: 5.6.21 started; log sequence number 1665504
2020-06-12 12:23:46 13200 [Note] Server hostname (bind-address): '*'; port: 3306
2020-06-12 12:23:46 13200 [Note] IPv6 is available.
2020-06-12 12:23:46 13200 [Note] - '::' resolves to '::';
2020-06-12 12:23:46 13200 [Note] Server socket created on IP: '::'.
2020-06-12 12:23:46 13200 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2020-06-12 12:23:46 13200 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-06-12 12:23:46 13200 [ERROR] Aborting

2020-06-12 12:23:46 13200 [Note] Binlog end
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'partition'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_METRICS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_CMP'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'INNODB_TRX'
2020-06-12 12:23:46 13200 [Note] Shutting down plugin 'InnoDB'
2020-06-12 12:23:46 13200 [Note] InnoDB: FTS optimize thread exiting.
2020-06-12 12:23:46 13200 [Note] InnoDB: Starting shutdown...
2020-06-12 12:23:48 13200 [Note] InnoDB: Shutdown completed; log sequence number 1665514
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'BLACKHOLE'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'ARCHIVE'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MRG_MYISAM'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MyISAM'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'MEMORY'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'CSV'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'sha256_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'mysql_old_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'mysql_native_password'
2020-06-12 12:23:48 13200 [Note] Shutting down plugin 'binlog'
2020-06-12 12:23:48 13200 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Can anyone help please?
ronwoodtd
 
Posts: 1
Joined: 12. June 2020 11:47
XAMPP version: v3.2.1
Operating System: Windows 10


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 5 guests