MySQL problems

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

MySQL problems

Postby tss1410 » 23. March 2014 21:18

Hello.
I had xampp 1.8.1 on my computer, and used the mysql and apache.
I was gonna to format my pc, so i took a backup of the whole xampp folder.
After i had reformat my pc, i tried to copy paste the xampp folder to use it again, but then i got this error:

21:12:14 [mysql] Error: MySQL shutdown unexpectedly.
21:12:14 [mysql] This may be due to a blocked port, missing dependencies,
21:12:14 [mysql] improper privileges, a crash, or a shutdown by another method.
21:12:14 [mysql] Check the "/xampp/mysql/data/mysql_error.log" file
21:12:14 [mysql] and the Windows Event Viewer for more clues

If i remove the "mysql" folder and uses the default that come when i install xampp, it doesn't give error.

How can i fix it so i can use my old databases?
tss1410
 
Posts: 2
Joined: 23. March 2014 21:12
Operating System: windows 7

Re: MySQL problems

Postby JJ_Tagy » 23. March 2014 21:27

Did you copy/paste the folder over a new XAMPP installation? What does the MySQL_error.log file say?
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: MySQL problems

Postby tss1410 » 23. March 2014 21:29

140323 21:31:41 [Note] Plugin 'FEDERATED' is disabled.
140323 21:31:41 InnoDB: The InnoDB memory heap is disabled
140323 21:31:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140323 21:31:41 InnoDB: Compressed tables use zlib 1.2.3
140323 21:31:41 InnoDB: Initializing buffer pool, size = 16.0M
140323 21:31:41 InnoDB: Completed initialization of buffer pool
140323 21:31:41 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 14798567867
140323 21:31:41 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 14798571664
140323 21:31:41 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 13 14 15 140323 21:31:41 InnoDB: Assertion failure in thread 4280 in file rem0rec.c line 561
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
16 17 18 19 20 21 20:31:41 UTC - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
2We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

2 key_buffer_size=16777216
23 read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133450 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
24 25 26 27 28 29 30 InnoDB: Thread 4536 stopped in file os0sync.c line 434
1028e96 mysqld.exe!my_osmaperr()
1021f75 mysqld.exe!my_osmaperr()
4f541c4
461d090
669ee7c
ffffffffffffffff
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
tss1410
 
Posts: 2
Joined: 23. March 2014 21:12
Operating System: windows 7

Re: MySQL problems

Postby AmrFarouk » 25. March 2014 01:32

I have the same problem but a little bit different error.... Any Help?

2014-03-25 02:25:53 7756 [Note] Plugin 'FEDERATED' is disabled.
2014-03-25 02:25:53 1c08 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.
2014-03-25 02:25:53 7756 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-25 02:25:53 7756 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-25 02:25:53 7756 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-25 02:25:53 7756 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-25 02:25:53 7756 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-25 02:25:53 7756 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-03-25 02:25:53 7756 [Note] InnoDB: Completed initialization of buffer pool
2014-03-25 02:25:53 7756 [Note] InnoDB: Highest supported file format is Barracuda.
2014-03-25 02:25:54 7756 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1625987
2014-03-25 02:25:54 7756 [Warning] InnoDB: Starting to delete and rewrite log files.
2014-03-25 02:25:54 7756 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2014-03-25 02:25:54 7756 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
2014-03-25 02:25:55 7756 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2014-03-25 02:25:55 1c08 InnoDB: Operating system error number 183 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-03-25 02:25:55 7756 [ERROR] InnoDB: File C:\xampp\mysql\data\ib_logfile101: 'rename' returned OS error 283.
2014-03-25 02:25:55 1c08 InnoDB: Assertion failure in thread 7176 in file srv0start.cc line 709
InnoDB: Failing assertion: success
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
00:25:55 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133777 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
478300 mysqld.exe!my_thread_name()
6b1d3d mysqld.exe!my_mb_ctype_mb()
4efd32 mysqld.exe!murmur3_32()
4ab97a mysqld.exe!murmur3_32()
229e60 mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
263f9e mysqld.exe!?plugin_lock_by_name@@YAPAUst_plugin_int@@PAVTHD@@PBUst_mysql_lex_string@@H@Z()
268624 mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
22156b mysqld.exe!?init_common_variables@@YAHXZ()
222278 mysqld.exe!?win_main@@YAHHPAPAD@Z()
2227e7 mysqld.exe!?mysql_service@@YAHPAX@Z()
6ac89a mysqld.exe!my_mb_ctype_mb()
77193677 kernel32.dll!BaseThreadInitThunk()
77a99d72 ntdll.dll!RtlInitializeExceptionChain()
77a99d45 ntdll.dll!RtlInitializeExceptionChain()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2014-03-25 02:26:52 7364 [Note] Plugin 'FEDERATED' is disabled.
2014-03-25 02:26:52 2638 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.
2014-03-25 02:26:52 7364 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-25 02:26:52 7364 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-25 02:26:52 7364 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-25 02:26:52 7364 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-25 02:26:52 7364 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-25 02:26:52 7364 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-03-25 02:26:52 7364 [Note] InnoDB: Completed initialization of buffer pool
2014-03-25 02:26:52 7364 [ERROR] InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 is of different size 5242880 bytes than other log files 50331648 bytes!
2014-03-25 02:26:52 7364 [ERROR] Plugin 'InnoDB' init function returned error.
2014-03-25 02:26:52 7364 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-03-25 02:26:52 7364 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-03-25 02:26:52 7364 [ERROR] Aborting

2014-03-25 02:26:52 7364 [Note] Binlog end
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'partition'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_METRICS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_CMP'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'INNODB_TRX'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'BLACKHOLE'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'ARCHIVE'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'MRG_MYISAM'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'MyISAM'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'MEMORY'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'CSV'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'sha256_password'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'mysql_old_password'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'mysql_native_password'
2014-03-25 02:26:52 7364 [Note] Shutting down plugin 'binlog'
2014-03-25 02:26:52 7364 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2014-03-25 02:28:42 9496 [Note] Plugin 'FEDERATED' is disabled.
2014-03-25 02:28:42 d64 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.
2014-03-25 02:28:42 9496 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-03-25 02:28:42 9496 [Note] InnoDB: The InnoDB memory heap is disabled
2014-03-25 02:28:42 9496 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-03-25 02:28:42 9496 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-03-25 02:28:42 9496 [Note] InnoDB: Not using CPU crc32 instructions
2014-03-25 02:28:42 9496 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-03-25 02:28:42 9496 [Note] InnoDB: Completed initialization of buffer pool
2014-03-25 02:28:42 9496 [ERROR] InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 is of different size 5242880 bytes than other log files 50331648 bytes!
2014-03-25 02:28:42 9496 [ERROR] Plugin 'InnoDB' init function returned error.
2014-03-25 02:28:42 9496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-03-25 02:28:42 9496 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-03-25 02:28:42 9496 [ERROR] Aborting

2014-03-25 02:28:42 9496 [Note] Binlog end
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'partition'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_METRICS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_CMP'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'INNODB_TRX'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'BLACKHOLE'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'ARCHIVE'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'MRG_MYISAM'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'MyISAM'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'MEMORY'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'CSV'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'sha256_password'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'mysql_old_password'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'mysql_native_password'
2014-03-25 02:28:42 9496 [Note] Shutting down plugin 'binlog'
2014-03-25 02:28:42 9496 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
AmrFarouk
 
Posts: 1
Joined: 25. March 2014 01:28
Operating System: Windows

Re: MySQL problems

Postby JJ_Tagy » 27. March 2014 13:09

MySQL has some steps to help troubleshoot crashes. Both of yours look like ibdata corruption. You can search these forums for "ibdata" and follow instructions (specifically from Altrea). Alternatively, you can go through the steps at http://dev.mysql.com/doc/mysql/en/crashing.html
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 133 guests