mysql shutdown unexpectedly

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql shutdown unexpectedly

Postby Emmanuel1903 » 21. June 2018 17:50

mysql was working perfectly on my xampp before but suddenly it stopped working. this is what it displayed in the error log
2018-06-21 17:33:39 2250 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.
180621 17:33:39 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180621 17:33:39 [Note] InnoDB: The InnoDB memory heap is disabled
180621 17:33:39 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
180621 17:33:39 [Note] InnoDB: Memory barrier is not used
180621 17:33:39 [Note] InnoDB: Compressed tables use zlib 1.2.3
180621 17:33:39 [Note] InnoDB: Not using CPU crc32 instructions
180621 17:33:39 [Note] InnoDB: Initializing buffer pool, size = 16.0M
180621 17:33:39 [Note] InnoDB: Completed initialization of buffer pool
180621 17:33:39 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
180621 17:33:39 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
180621 17:33:39 [Note] InnoDB: Database physically writes the file full: wait...
180621 17:33:39 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
180621 17:33:39 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
180621 17:33:40 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
180621 17:33:40 [Warning] InnoDB: New log files created, LSN=45781
180621 17:33:40 [Note] InnoDB: Doublewrite buffer not found: creating new
180621 17:33:40 [Note] InnoDB: Doublewrite buffer created
180621 17:33:41 [Note] InnoDB: 128 rollback segment(s) are active.
180621 17:33:41 [Warning] InnoDB: Creating foreign key constraint system tables.
180621 17:33:41 [Note] InnoDB: Foreign key constraint system tables created
180621 17:33:41 [Note] InnoDB: Creating tablespace and datafile system tables.
180621 17:33:41 [Note] InnoDB: Tablespace and datafile system tables created.
180621 17:33:41 [Note] InnoDB: Waiting for purge to start
180621 17:33:41 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 0
180621 17:33:41 [Note] Plugin 'FEEDBACK' is disabled.
180621 17:33:41 [Note] Server socket created on IP: '::'.
180621 17:33:41 [Warning] 'db' entry 'size of datafile is: 1907 should be: 1760

180409 15:17:15 [error] mysql.db: got error: 0 when reading datafile at record: 3

180409 15:17:15 [error] got an error from unknown thread, ha _myisam.cc:952

180409 15:17:15 [Warning] Recove@80409 15:17:15 [Warning] Checking table: '.\mysql\db'

180409 15:17:15 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly

180409 15:17:15 [ERROR] mysql.db:' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.
180621 17:33:41 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
180621 17:33:41 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
180621 17:33:41 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
180621 17:33:41 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180621 17:33:41 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
180621 17:33:42 [Note] Started replication for '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
180621 17:33:42 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
180621 17:33:42 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-180401@002018@003a51@003a15@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000063' position: 4
180621 17:33:42 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
180621 17:33:42 [ERROR] Failed to open the relay log '.\mysql-relay-bin-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000036' (relay_log_pos 4)
180621 17:33:42 [ERROR] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL: Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't exist, Internal MariaDB error code: 1146
180621 17:33:42 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
180621 17:33:42 [ERROR] Could not find target log during relay log initialization
180621 17:33:42 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4

180621 17:33:42 [ERROR] Initialized Master_info from 'master-version@003a@0020@002710@002e0@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' failed
180621 17:33:42 [Warning] Reading of some Master_info entries failed
180621 17:33:42 [ERROR] Failed to initialize multi master structures
180621 17:33:42 [ERROR] Aborting

180621 17:33:42 [Note] Master '180401 18:51:15 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Error reading relay log event: slave SQL thread was killed
180621 17:33:42 [Note] InnoDB: FTS optimize thread exiting.
180621 17:33:42 [Note] InnoDB: Starting shutdown...
180621 17:33:43 [Note] InnoDB: Shutdown completed; log sequence number 1600614
180621 17:33:43 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
Emmanuel1903
 
Posts: 2
Joined: 21. June 2018 17:39
XAMPP version: 3.2.1
Operating System: windows 10

Re: mysql shutdown unexpectedly

Postby Emmanuel1903 » 23. June 2018 08:42

please guys help me out this error has been stopping me from working :cry:
Emmanuel1903
 
Posts: 2
Joined: 21. June 2018 17:39
XAMPP version: 3.2.1
Operating System: windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 122 guests