Mysql startet nicht

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

Mysql startet nicht

Postby denmla » 31. October 2016 17:20

Hallo Zusammen
Mysql startet nicht mehr
heist das das ich es neu Installieren muss :(

Vielen Dank für die Antwort
2016-10-31 10:44:53 3628 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation
2016-10-31 10:45:25 1f50 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-10-31 10:45:25 8016 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-10-31 10:45:25 8016 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-31 10:45:25 8016 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-31 10:45:25 8016 [Note] InnoDB: Memory barrier is not used
2016-10-31 10:45:25 8016 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-31 10:45:25 8016 [Note] InnoDB: Using generic crc32 instructions
2016-10-31 10:45:25 8016 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-10-31 10:45:25 8016 [Note] InnoDB: Completed initialization of buffer pool
2016-10-31 10:45:25 8016 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-31 10:45:25 8016 [Note] InnoDB: The log sequence numbers 4376657 and 4376657 in ibdata files do not match the log sequence number 32863086 in the ib_logfiles!
2016-10-31 10:45:25 8016 [Note] InnoDB: Database was not shutdown normally!
2016-10-31 10:45:25 8016 [Note] InnoDB: Starting crash recovery.
2016-10-31 10:45:25 8016 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-10-31 10:45:25 1f50 InnoDB: Operating system error number 38 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
InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-10-31 10:45:25 8016 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation
2016-10-31 13:43:21 1850 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-10-31 13:43:21 6224 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-10-31 13:43:21 6224 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-31 13:43:21 6224 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-31 13:43:21 6224 [Note] InnoDB: Memory barrier is not used
2016-10-31 13:43:21 6224 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-31 13:43:21 6224 [Note] InnoDB: Using generic crc32 instructions
2016-10-31 13:43:21 6224 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-10-31 13:43:21 6224 [Note] InnoDB: Completed initialization of buffer pool
2016-10-31 13:43:22 6224 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-31 13:43:22 6224 [Note] InnoDB: The log sequence numbers 4376657 and 4376657 in ibdata files do not match the log sequence number 32863086 in the ib_logfiles!
2016-10-31 13:43:22 6224 [Note] InnoDB: Database was not shutdown normally!
2016-10-31 13:43:22 6224 [Note] InnoDB: Starting crash recovery.
2016-10-31 13:43:22 6224 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-10-31 13:43:23 1850 InnoDB: Operating system error number 38 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
InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-10-31 13:43:23 6224 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation
denmla
 
Posts: 2
Joined: 31. October 2016 13:37
XAMPP version: 3.2.2
Operating System: Windows 7

Re: Mysql startet nicht

Postby Altrea » 31. October 2016 19:53

Hi,

Vielleicht, vielleicht auch nicht.
=> viewtopic.php?f=16&t=72437

mit freundlichen Grüßen,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Mysql startet nicht

Postby denmla » 03. November 2016 14:52

Hei :-)

habe es gemacht hat immer noch leider das Problem

my.im
nnodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_method=normal
innodb_lock_wait_timeout = 50
innodb_flush_method=normal

## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="C:/xampp/mysql/share/charsets"

Fehlermeldung

2016-11-03 14:48:33 6260 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation
2016-11-03 14:48:53 e44 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-11-03 14:48:53 3652 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-11-03 14:48:53 3652 [Note] InnoDB: The InnoDB memory heap is disabled
2016-11-03 14:48:53 3652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-11-03 14:48:53 3652 [Note] InnoDB: Memory barrier is not used
2016-11-03 14:48:53 3652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-11-03 14:48:53 3652 [Note] InnoDB: Using generic crc32 instructions
2016-11-03 14:48:53 3652 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-11-03 14:48:53 3652 [Note] InnoDB: Completed initialization of buffer pool
2016-11-03 14:48:53 3652 [Note] InnoDB: Highest supported file format is Barracuda.
2016-11-03 14:48:53 3652 [Note] InnoDB: The log sequence numbers 4376657 and 4376657 in ibdata files do not match the log sequence number 32863086 in the ib_logfiles!
2016-11-03 14:48:53 3652 [Note] InnoDB: Database was not shutdown normally!
2016-11-03 14:48:53 3652 [Note] InnoDB: Starting crash recovery.
2016-11-03 14:48:53 3652 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-11-03 14:48:53 e44 InnoDB: Operating system error number 38 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
InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-11-03 14:48:53 3652 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation
denmla
 
Posts: 2
Joined: 31. October 2016 13:37
XAMPP version: 3.2.2
Operating System: Windows 7


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 39 guests