Search found 1243 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

Re: Error: MySQL shutdown unexpectedly.

dDesign wrote:[mysqld]
innodb_force_recovery = 4

THIS forces InnoDB to start in read-only mode, not any file/folder permission.
by Altrea
10. May 2016 10:15
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

Re: Error: MySQL shutdown unexpectedly.

How about the permissions? Folder permission etc.

edit:

2016-05-10 13:09:21 4744 [ERROR] InnoDB: Cannot create log files in read-only mode

Right click on the XAMPP folder and uncheck the Readonly, if this not works. Try to uncheck the read only in folder settings from folder mysql
by dDesign
10. May 2016 10:04
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

Re: Error: MySQL shutdown unexpectedly.

Thanks for your reply; I appreciate your help.

I tried with administrator rights as well:

1:09:18 PM [main] Initializing Control Panel
1:09:18 PM [main] Windows Version: Windows 8 Pro 64-bit
1:09:18 PM [main] XAMPP Version: 1.8.3
1:09:18 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
1:09:18 PM [main] Running with Administrator rights - good!
1:09:18 PM [main] XAMPP Installation Directory: "c:\xampp\"
1:09:18 PM [main] Checking for prerequisites
1:09:18 PM [main] All prerequisites found
1:09:18 PM [main] Initializing Modules
1:09:18 PM [main] Starting Check-Timer
1:09:18 PM [main] Control Panel Ready
1:09:20 PM [mysql] Attempting to start MySQL app...
1:09:20 PM [mysql] Status change detected: running
1:09:21 PM [mysql] Status change detected: stopped
1:09:21 PM [mysql] Error: MySQL shutdown unexpectedly.
1:09:21 PM [mysql] This may be due to a blocked port, missing dependencies,
1:09:21 PM [mysql] improper privileges, a crash, or a shutdown by another method.
1:09:21 PM [mysql] Press the Logs button to view error logs and check
1:09:21 PM [mysql] the Windows Event Viewer for more clues
1:09:21 PM [mysql] If you need more help, copy and post this
1:09:21 PM [mysql] entire log window on the forums


Following is the error log:

2016-05-10 13:09:21 4744 [Note] Plugin 'FEDERATED' is disabled.
2016-05-10 13:09:21 914 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.
2016-05-10 13:09:21 4744 [Note] InnoDB: Started in read only mode
2016-05-10 13:09:21 4744 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-10 13:09:21 4744 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-10 13:09:21 4744 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-10 13:09:21 4744 [Note] InnoDB: Memory barrier is not used
2016-05-10 13:09:21 4744 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-10 13:09:21 4744 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-10 13:09:21 4744 [Note] InnoDB: Disabling background IO write threads.
2016-05-10 13:09:21 4744 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-10 13:09:21 4744 [Note] InnoDB: Completed initialization of buffer pool
2016-05-10 13:09:21 4744 [ERROR] InnoDB: Cannot create log files in read-only mode
2016-05-10 13:09:21 4744 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-10 13:09:21 4744 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-10 13:09:21 4744 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-10 13:09:21 4744 [ERROR] Aborting

2016-05-10 13:09:21 4744 [Note] Binlog end
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'partition'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'ARCHIVE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MyISAM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MEMORY'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'CSV'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'sha256_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'mysql_old_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'mysql_native_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'binlog'
2016-05-10 13:09:21 4744 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by vishalp@lexcis.com
10. May 2016 08:43
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

Re: Error: MySQL shutdown unexpectedly.

Did you try to run it as Administrator? I further have no clue. The reason i think u have to start it as administrator is of the first line:

2016-05-10 12:38:43 1208 [Note] InnoDB: Started in read only mode

"ready only mode"
by dDesign
10. May 2016 08:21
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

Re: Error: MySQL shutdown unexpectedly.

Yes i did that, below are the logs after edit this line.

2016-05-10 12:38:43 1208 [Note] InnoDB: Started in read only mode
2016-05-10 12:38:43 1208 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-10 12:38:43 1208 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-10 12:38:43 1208 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-10 12:38:43 1208 [Note] InnoDB: Memory barrier is not used
2016-05-10 12:38:43 1208 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-10 12:38:43 1208 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-10 12:38:43 1208 [Note] InnoDB: Disabling background IO write threads.
2016-05-10 12:38:43 1208 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-10 12:38:43 1208 [Note] InnoDB: Completed initialization of buffer pool
2016-05-10 12:38:43 1208 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-10 12:38:43 1208 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1264883520 in the ib_logfiles!
2016-05-10 12:38:43 1208 [ERROR] InnoDB: Can't initiate database recovery, running in read-only-mode.
2016-05-10 12:38:43 1208 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-10 12:38:43 1208 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-10 12:38:43 1208 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-10 12:38:43 1208 [ERROR] Aborting

2016-05-10 12:38:43 1208 [Note] Binlog end
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'partition'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'ARCHIVE'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'MyISAM'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'MEMORY'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'CSV'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'sha256_password'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'mysql_old_password'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'mysql_native_password'
2016-05-10 12:38:43 1208 [Note] Shutting down plugin 'binlog'
2016-05-10 12:38:43 1208 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by vishalp@lexcis.com
10. May 2016 08:12
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

Re: Error: MySQL shutdown unexpectedly.

Deleting ibdata1 may result in data loss of all innodb databases!!!
by Altrea
09. May 2016 15:16
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2057

MySQL und Apache lassen sich nicht starten

Hi ich bin ein wenig neu auf dem Gebiet aber mein SQL und mein Apache lassen sich nicht starten

MySQL Error Log
Code: Select all
2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

by gigabytenjin
09. May 2016 13:37
 
Forum: XAMPP für Windows
Topic: MySQL und Apache lassen sich nicht starten
Replies: 0
Views: 953

mysql won't launch (XAMPP v3.2.1)

Dear Apache Friends,

Today i wanted to work on my website after 2 weeks of vacation. My laptop (Acer aspire v15 nitro - black edition) has been in sleeping mode while the servers where running. But after i launched Apache (launches perfectly), i wanted to launch MySQL too, that didn't work out well.

After i click on "Start" .. it will run for some seconds and then it stops running, giving the next bug in the log:

11:58:06 [mysql] Error: MySQL shutdown unexpectedly.
11:58:06 [mysql] This may be due to a blocked port, missing dependencies,
11:58:06 [mysql] improper privileges, a crash, or a shutdown by another method.
11:58:06 [mysql] Press the Logs button to view error logs and check
11:58:06 [mysql] the Windows Event Viewer for more clues
11:58:06 [mysql] If you need more help, copy and post this
11:58:06 [mysql] entire log window on the forums

I tried many things, like deleting the "ibdata1" file and restart XAMP - no effect
Also tried to change the port of the MySQL and launching the MySQL upgrade didnt show any effects.

This is what the error log looks like:

2016-05-09 12:38:00 1ce0 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.
160509 12:38:00 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160509 12:38:00 [Note] InnoDB: The InnoDB memory heap is disabled
160509 12:38:00 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160509 12:38:00 [Note] InnoDB: Memory barrier is not used
160509 12:38:00 [Note] InnoDB: Compressed tables use zlib 1.2.3
160509 12:38:00 [Note] InnoDB: Not using CPU crc32 instructions
160509 12:38:00 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160509 12:38:00 [Note] InnoDB: Completed initialization of buffer pool
160509 12:38:00 [Note] InnoDB: Highest supported file format is Barracuda.
160509 12:38:00 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 73591974 in the ib_logfiles!
160509 12:38:00 [Note] InnoDB: Database was not shutdown normally!
160509 12:38:00 [Note] InnoDB: Starting crash recovery.
160509 12:38:00 [Note] InnoDB: Reading tablespace information from the .ibd files...
160509 12:38:00 [Note] InnoDB: Restoring possible half-written data pages
160509 12:38:00 [Note] InnoDB: from the doublewrite buffer...
160509 12:38:01 [Note] InnoDB: 128 rollback segment(s) are active.
160509 12:38:01 [Note] InnoDB: Waiting for purge to start
160509 12:38:01 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 73591974
160509 12:38:01 [Note] Plugin 'FEEDBACK' is disabled.
160509 12:38:01 [Note] Server socket created on IP: '::'.
160509 12:38:01 [Warning] 'db' entry '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_d IR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2@51110 9:19:23 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it

151110 9:19:23 [ERROR] Incorrect definition of table mysql.event: expected' 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.
160509 12:38:01 [Warning] 'db' entry ''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','IGNOR@TIONS','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',' 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.
160509 12:38:01 [Warning] 'db' entry 'ql40','ansi','no_auto_value_on_zero','no_backslash_escapes','strict_trans_tables','strict_a

151110 9:19:23 [error] event scheduler: an error occurred when initializing system tables. disabli ng the Event Scheduler.

151110 9:19:23 [Warnin@'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','MYS' 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.
160509 12:38:01 [Warning] 'db' entry '.

version: '10.0.17-mariadb' socket: '' port: 3306 mariadb.org binary distribution

151209 9:38:40 [error] missing system table mysql.roles_mapping; please run mysql_upgrade to create it

151209 9:38:40 [ERROR] Incorrect definition of@ave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist

151110 9:19:23 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections' 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.
160509 12:38:01 [Warning] 'db' entry 'ed_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_ba CKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A@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_UNSIGN' 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.
160509 12:38:01 [Warning] 'db' entry '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_F@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'),' 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.
160509 12:38:01 [Warning] 'db' entry 'ystem tables. disabling the event scheduler.

151209 9:38:40 [warning] failed to load slave replication state from table mysql.gtid_slave_pos: 1146: table 'mysql.gtid_slave_pos' doesn't exist

151209 9:38:40 [Note] c:\xampp\mysql\bin\mysq@323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A

151209 9:38:40 [ERROR] Event Scheduler: An error occurred when initializing s' 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.
160509 12:38:01 [Warning] 'db' entry '_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_opti ons" but the required system tables mysql.innodb@nnections.

Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."innodb' 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.
160509 12:38:01 [Warning] 'db' entry 'odb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_p osts" but the required system tables mysql.innod@ql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."inn' 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.
160509 12:38:01 [Warning] 'db' entry 'nodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:27 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress"."wp_ postmeta" but the required system tables mysql.i@sql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:27 8f4c InnoDB: Error: Column last_update in table "mysql"."in' 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.
160509 12:38:01 [Warning] 'db' entry '."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress". "wp_terms" but the required system tables mysql.@d mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql"' 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.
160509 12:38:01 [Warning] 'db' entry '"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "wordpress" ."wp_term_taxonomy" but the required system tabl@nd mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in table "mysql' 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.
160509 12:38:01 [Warning] 'db' entry 'le "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requested for table "w ordpress"."wp_term_relationships" but the requir@e_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last_update in tab' 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.
160509 12:38:01 [Warning] 'db' entry '_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:28 8f4c innodb: error: fetch of persistent statistics requeste d for table "wordpress"."wp_users" but the requi@ql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:28 8f4c InnoDB: Error: Column last' 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.
160509 12:38:01 [Warning] 'db' entry 't_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics request ed for table "wordpress"."wp_usermeta" but the r@sql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:29 8f4c InnoDB: Error: Column las' 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.
160509 12:38:01 [Warning] 'db' entry ' last_update in table "mysql"."innodb_table_stats" is binary(4) not null but should be int not null (type mismatch).

2015-12-09 09:45:29 8f4c innodb: error: fetch of persistent statistics req uested for table "wordpress"."wp_comments" but t@s mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.

2015-12-09 09:45:29 8f4c InnoDB: Error: Column' 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.
160509 12:38:01 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
160509 12:38:01 [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
160509 12:38:01 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
160509 12:38:01 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
160509 12:38:01 [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.
160509 12:38:01 [Note] Started replication for '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
160509 12:38:01 [ERROR] Master '160420 14:08:50 [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
160509 12:38:01 [Note] Master '160420 14:08:50 [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-160420@002014@003a08@003a50@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
160509 12:38:01 [ERROR] Master '160420 14:08:50 [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
160509 12:38:01 [ERROR] Master '160420 14:08:50 [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
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
160509 12:38:01 [Note] Master '160420 14:08:50 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
160509 12:38:01 [Note] Started replication for 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': 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
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, 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.000001' position: 4
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
160509 12:38:01 [ERROR] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': 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
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed
160509 12:38:01 [Note] Master 'Version: '10.0.17-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info', errno 2)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020fetch@0020of@0020persistent@0020statistics@0020requested@0020for@0020table@0020@0022wordpress@0022@002e@0022wp_options@0022@0020but@0020the@0020required@0020system@0020tables@0020mysql@002einnodb_table_stats@0020and@0020mysql@002einnod.info' failed
160509 12:38:01 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' not found (Errcode: 2 "No such file or directory")
160509 12:38:01 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info', errno 2)
160509 12:38:01 [ERROR] Initialized Master_info from 'master-2016@002d04@002d20@002014@003a09@003a06@00207d70@0020innodb@003a@0020error@003a@0020column@0020last_update@0020in@0020table@0020@0022mysql@0022@002e@0022innodb_table_stats@0022@0020is@0020binary@00284@0029@0020not@0020null@0020but@0020should@0020be@0020int@0020not@0020null@0020@0028type@0020mismatch@0029@002e@000d.info' failed



Hope you guys can help me out.

Regards,


Davey
by dDesign
09. May 2016 11:43
 
Forum: XAMPP for Windows
Topic: mysql won't launch (XAMPP v3.2.1)
Replies: 5
Views: 667

Error Log

Hello,
My Mysql still swith off, and I dont know what I should to do

2016-05-09 07:17:35 139c 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.
2016-05-09 7:17:35 5020 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-09 7:17:35 5020 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-09 7:17:35 5020 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-09 7:17:35 5020 [Note] InnoDB: Memory barrier is not used
2016-05-09 7:17:35 5020 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-09 7:17:35 5020 [Note] InnoDB: Using generic crc32 instructions
2016-05-09 7:17:35 5020 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-09 7:17:35 5020 [Note] InnoDB: Completed initialization of buffer pool
2016-05-09 7:17:35 5020 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-09 7:17:35 5020 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-09 7:17:35 5020 [Note] InnoDB: Waiting for purge to start
2016-05-09 7:17:35 5020 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 7435306
2016-05-09 7:17:36 4080 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x22c7)

2016-05-09 7:17:36 5020 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-05-09 7:17:36 5020 [ERROR] Plugin 'Aria' init function returned error.
2016-05-09 7:17:36 5020 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-05-09 7:17:36 5020 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-09 7:17:36 5020 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-05-09 7:17:36 5020 [ERROR] Aborting

2016-05-09 07:27:44 dbc 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.
2016-05-09 7:27:44 3516 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-09 7:27:44 3516 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-09 7:27:44 3516 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-09 7:27:44 3516 [Note] InnoDB: Memory barrier is not used
2016-05-09 7:27:44 3516 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-09 7:27:44 3516 [Note] InnoDB: Using generic crc32 instructions
2016-05-09 7:27:44 3516 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-09 7:27:44 3516 [Note] InnoDB: Completed initialization of buffer pool
2016-05-09 7:27:44 3516 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-09 7:27:44 3516 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-09 7:27:44 3516 [Note] InnoDB: Waiting for purge to start
2016-05-09 7:27:44 3516 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 7435316
2016-05-09 7:27:44 4872 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x22c7)

2016-05-09 7:27:44 3516 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-05-09 7:27:44 3516 [ERROR] Plugin 'Aria' init function returned error.
2016-05-09 7:27:44 3516 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-05-09 7:27:44 3516 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-09 7:27:44 3516 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-05-09 7:27:44 3516 [ERROR] Aborting

2016-05-09 07:28:51 5c4 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.
2016-05-09 7:28:52 1476 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-09 7:28:52 1476 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-09 7:28:52 1476 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-09 7:28:52 1476 [Note] InnoDB: Memory barrier is not used
2016-05-09 7:28:52 1476 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-09 7:28:52 1476 [Note] InnoDB: Using generic crc32 instructions
2016-05-09 7:28:52 1476 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-09 7:28:52 1476 [Note] InnoDB: Completed initialization of buffer pool
2016-05-09 7:28:52 1476 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-09 7:28:52 1476 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-09 7:28:52 1476 [Note] InnoDB: Waiting for purge to start
2016-05-09 7:28:52 1476 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 7435326
2016-05-09 7:28:52 2432 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x22c7)

2016-05-09 7:28:52 1476 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-05-09 7:28:52 1476 [ERROR] Plugin 'Aria' init function returned error.
2016-05-09 7:28:52 1476 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-05-09 7:28:52 1476 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-09 7:28:52 1476 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-05-09 7:28:52 1476 [ERROR] Aborting

2016-05-09 07:28:56 12ec 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.
2016-05-09 7:28:56 4844 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-09 7:28:56 4844 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-09 7:28:56 4844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-09 7:28:56 4844 [Note] InnoDB: Memory barrier is not used
2016-05-09 7:28:56 4844 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-09 7:28:56 4844 [Note] InnoDB: Using generic crc32 instructions
2016-05-09 7:28:56 4844 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-09 7:28:56 4844 [Note] InnoDB: Completed initialization of buffer pool
2016-05-09 7:28:56 4844 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-09 7:28:57 4844 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-09 7:28:57 4844 [Note] InnoDB: Waiting for purge to start
2016-05-09 7:28:57 4844 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 7435336
2016-05-09 7:28:57 3452 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x22c7)

2016-05-09 7:28:57 4844 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-05-09 7:28:57 4844 [ERROR] Plugin 'Aria' init function returned error.
2016-05-09 7:28:57 4844 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-05-09 7:28:57 4844 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-09 7:28:57 4844 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-05-09 7:28:57 4844 [ERROR] Aborting

2016-05-09 07:30:36 157c 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.
2016-05-09 7:30:36 5500 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-09 7:30:36 5500 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-09 7:30:36 5500 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-09 7:30:36 5500 [Note] InnoDB: Memory barrier is not used
2016-05-09 7:30:36 5500 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-09 7:30:36 5500 [Note] InnoDB: Using generic crc32 instructions
2016-05-09 7:30:36 5500 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-09 7:30:36 5500 [Note] InnoDB: Completed initialization of buffer pool
2016-05-09 7:30:36 5500 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-09 7:30:36 5500 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-09 7:30:36 5500 [Note] InnoDB: Waiting for purge to start
2016-05-09 7:30:37 5500 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-76.0 started; log sequence number 7435346
2016-05-09 7:30:37 5600 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x22c7)

2016-05-09 7:30:37 5500 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2016-05-09 7:30:37 5500 [ERROR] Plugin 'Aria' init function returned error.
2016-05-09 7:30:37 5500 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2016-05-09 7:30:37 5500 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-09 7:30:37 5500 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
2016-05-09 7:30:37 5500 [ERROR] Aborting

[EDIT by Altrea: splitted from original topic because it is unrelated. Please read [INFO] How to not fail getting help here (section: Board and thread structure)]
by Anjessw
09. May 2016 06:37
 
Forum: XAMPP for Windows
Topic: Error Log
Replies: 0
Views: 268

XAMPP (Apache+MySQL Problem)

Hallo.

Ich habe derzeit das Problem das 2 Sachen nie Starten möchten egal Welche Version ich Nutze.
Apache und die MySQL startet einfach nicht
Hier einmal die Logs!

Apache
Code: Select all
01:48:17  [Apache]    Fehler: Apache wurde unerwartet beendet
01:48:17  [Apache]    Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
01:48:17  [Apache]    fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
01:48:17  [Apache]    Drücke den Logs Button um error logs zu sehen und prüfe
01:48:17  [Apache]    im Windows Event Viewer für weitere Hinweise
01:48:17  [Apache]    Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
01:48:17  [Apache]    und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.



MySQL
Code: Select all
2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Hoffe man kann mir Schnell Helfen!
by xDaysHouse
07. May 2016 00:51
 
Forum: XAMPP für Windows
Topic: XAMPP (Apache+MySQL Problem)
Replies: 4
Views: 2046

MySQL stürzt immer ab.

Hallo zusammen,

konnte gestern Nachmittag noch ganz normal arbeiten.
Nach einem PC-Neustart lies sich dann MySQL nicht mehr starten bzw. stürzte immer ab.

Code: Select all
16:58:34  [mysql]    Error: MySQL shutdown unexpectedly.
16:58:34  [mysql]    This may be due to a blocked port, missing dependencies,
16:58:34  [mysql]    improper privileges, a crash, or a shutdown by another method.
16:58:34  [mysql]    Press the Logs button to view error logs and check
16:58:34  [mysql]    the Windows Event Viewer for more clues
16:58:34  [mysql]    If you need more help, copy and post this
16:58:34  [mysql]    entire log window on the forums


Folgendes steht in der Log:
Code: Select all
160503 16:58:20 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160503 16:58:20 [Note] InnoDB: The InnoDB memory heap is disabled
160503 16:58:20 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160503 16:58:20 [Note] InnoDB: Memory barrier is not used
160503 16:58:20 [Note] InnoDB: Compressed tables use zlib 1.2.3
160503 16:58:20 [Note] InnoDB: Not using CPU crc32 instructions
160503 16:58:20 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160503 16:58:20 [Note] InnoDB: Completed initialization of buffer pool
160503 16:58:20 [Note] InnoDB: Highest supported file format is Barracuda.
160503 16:58:20 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 36138561 in the ib_logfiles!
160503 16:58:20 [Note] InnoDB: Database was not shutdown normally!
160503 16:58:20 [Note] InnoDB: Starting crash recovery.
160503 16:58:20 [Note] InnoDB: Reading tablespace information from the .ibd files...
160503 16:58:20 [Note] InnoDB: Restoring possible half-written data pages
160503 16:58:20 [Note] InnoDB: from the doublewrite buffer...
160503 16:58:21 [Note] InnoDB: 128 rollback segment(s) are active.
160503 16:58:21 [Note] InnoDB: Waiting for purge to start
160503 16:58:21 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 36138561
160503 16:58:21 [Note] Plugin 'FEEDBACK' is disabled.
160503 16:58:21 [Note] Server socket created on IP: '::'.


Kann mir jemand sagen wie ich jetzt weiter vorgehen muss?

Vielen Dank,
by medastumpn
03. May 2016 16:09
 
Forum: XAMPP für Windows
Topic: MySQL stürzt immer ab.
Replies: 3
Views: 2340

Re: Change htdoc and mysql dir

Nobbie wrote:If there is no datadir entry, simply create one.

And Please, please, please - use Google for further help. Dont ask for any byte and any letter - try to help yourself. This is really not that difficult as you might think, simply "go for it". Google and Wikipedia knows everything, it is on you to use it!


I have been googing for seven hours straight and have not found a single website that shows you what line in what file (I assume it is my.cnf?) that you are supposed to add datadir.

While what you are talking about is true for googling stuff for windows users it is most definitely not true for mac users.

Apache already points to the right directory, but this is useless if mysql's default cant be changed. If I add the datadir entry mysql wont start, if I comment out that line MySQL is fine again.
Code: Select all
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /Applications/XAMPP/xamppfiles/var/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port      = 3308
socket      = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
datadir = /Users/MyUsername/OneDrive/WebDev/mysql
user = mysql
port=3308
socket      = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M


# Where do all the plugins live
plugin_dir = /Applications/XAMPP/xamppfiles/lib/mysql/plugin/

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id   = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin


# Point the following paths to different dedicated disks
tmpdir = /Applications/XAMPP/xamppfiles/temp/mysql
#log-update    = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /Applications/XAMPP/xamppfiles/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
# Deprecated in 5.6
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

!include /Applications/XAMPP/xamppfiles/mysql/my.cnf
by Dave003
03. May 2016 15:18
 
Forum: XAMPP for Mac OS X
Topic: Change htdoc and mysql dir
Replies: 11
Views: 3638

Re: ERROR by MySQL

There is this warning about InnoDB in the log:

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.

You can solve this by simply removing the line with innodb_additional_mem_pool_size from your my.ini file.

I have already reported this issue at viewtopic.php?f=16&t=71532. However, it seems like no one cares.
by Joergi
02. May 2016 15:21
 
Forum: XAMPP for Windows
Topic: ERROR by MySQL
Replies: 3
Views: 358

Re: Hilfe! MySQL setzt Passwort, obwohl keins gesetzt ist?

EDIT: habe glaube das Problem gefunden. Scheinbar ist es so, wenn man sehr viele SQL Befehle schnell ausführt, dann zerschießts die Datenbank. (Hatte zwar nur eine Session und die sollte laut InnoDB standardmäßig repeatable read als isolation level haben, aber naja ist ja doch mariadb?) Habe die Befehle überwiegend Prozeduren und Events "stückweise" ausgeführt und siehe da kein Problem. Ist zwar etwas komfortabilitätsverlustbehaftet aber at last it works...
by Foreach
01. May 2016 20:49
 
Forum: XAMPP für Windows
Topic: Hilfe! MySQL setzt Passwort, obwohl keins gesetzt ist?
Replies: 2
Views: 1859

ERROR by MySQL

2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

_________________

What do I have to do. please help me
by ItsJustSem
01. May 2016 16:15
 
Forum: XAMPP for Windows
Topic: ERROR by MySQL
Replies: 3
Views: 358
PreviousNext

Return to advanced search