Help Please, MySql error shutdown unexpectedly

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

Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 03. January 2014 21:18

Hi can someone tell me how to sort this please, when i try to start mysql it shuts down. Sorry im new to all this and stuck, Thanks :shock:

2014-01-03 20:08:58 7648 [Note] Plugin 'FEDERATED' is disabled.
2014-01-03 20:08:58 2234 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-01-03 20:08:58 7648 [Note] InnoDB: The InnoDB memory heap is disabled
2014-01-03 20:08:58 7648 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-01-03 20:08:58 7648 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-01-03 20:08:58 7648 [Note] InnoDB: Not using CPU crc32 instructions
2014-01-03 20:08:59 7648 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-01-03 20:08:59 7648 [Note] InnoDB: Completed initialization of buffer pool
2014-01-03 20:08:59 7648 [Note] InnoDB: Highest supported file format is Barracuda.
2014-01-03 20:08:59 7648 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 15977059 in the ib_logfiles!
2014-01-03 20:08:59 7648 [Note] InnoDB: Database was not shutdown normally!
2014-01-03 20:08:59 7648 [Note] InnoDB: Starting crash recovery.
2014-01-03 20:08:59 7648 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-01-03 20:08:59 7648 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace iowcaravanhire/wp_term_taxonomy uses space ID: 2 at filepath: .\iowcaravanhire\wp_term_taxonomy.ibd. Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby Altrea » 03. January 2014 21:25

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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 03. January 2014 21:41

Hi, Thank you very much, added the (innodb_force_recovery = 4) then saved, and its started.
Thanks again.
Jiffa
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby Altrea » 03. January 2014 21:56

What you have done is just a workaround to bring Mysql back running to be able to export/backup your databases.
It is NOT made for leaving your MySQL now running with this setting.
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 04. January 2014 15:02

hmm Hi again, thanks for your help getting Mysql to run, problem is now that when im updating my templatic theme on wordpress it does not seem to save, says its saving but its still showing the old items not the revisions im making? is this anything to do with adding the number 4 previously?
regards
martin
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 04. January 2014 15:30

sorry just read above post duhh, ok that explains it, have you got a tutorial on backup and export database etc at all, and then do i re install xampp etc, sorry for all questions im new to all this and trying to self teach lol
thanks
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby Altrea » 04. January 2014 19:37

Backup and restore => viewtopic.php?f=16&t=56104&p=220404#p220404
just remember to recreate the database users too if you defined some to access the database.
If you reinstall XAMPP, you should use the most current version of XAMPP 1.8.3 where this specific bug is fixed.
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 05. January 2014 14:58

Ok brill thanks, ill give that a go, when i re install xampp do i have to re install wordpress and my trevlon theme as well?
kind regards
m
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby Altrea » 05. January 2014 15:02

If you backup your static files and database (assuming the database dump is clean and successful) and restore them later normally you don't need to do a complete reinstallation of wordpress and your theme.
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 06. January 2014 15:47

Im not winning with this :-(( ok think ive done it all correct but now when i try to get into my site ie, lolcalhost/iowcaravanhire im getting

Error 404

localhost
Apache/2.4.7 (Win32) OpenSSL/1.0.1e PHP/5.5.6


aggggggggggggg lol

any ideas ? sorry again.
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby Altrea » 06. January 2014 16:16

Apache access.log?
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 06. January 2014 16:22

hold on ill check,
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 06. January 2014 16:24

127.0.0.1 - - [06/Jan/2014:14:45:06 +0000] "GET /isleofwightcaravanhire HTTP/1.1" 404 1052 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
127.0.0.1 - - [06/Jan/2014:14:45:06 +0000] "GET /favicon.ico HTTP/1.1" 200 7782 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:14:45:58 +0000] "GET /iowcaravanhire/ HTTP/1.1" 404 1052 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:02:38 +0000] "GET /phpmyadmin/db_operations.php?server=1&db=iowcaravanhire&token=64807f7c16e2dc45d917904257c656a9&ajax_request=true&ajax_page_request=true&menuHashes=54d4b237-2c8fe16a-960fc98d&_nocache=1389020558847163170 HTTP/1.1" 200 36344 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:02:45 +0000] "GET /phpmyadmin/js/get_scripts.js.php?scripts[]=db_operations.js HTTP/1.1" 200 4070 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:07 +0000] "GET /phpmyadmin/db_structure.php?server=1&db=information_schema&token=64807f7c16e2dc45d917904257c656a9&ajax_request=true&ajax_page_request=true&menuHashes=54d4b237-2c8fe16a-960fc98d-0ac635f3&_nocache=13890205868965499 HTTP/1.1" 200 93841 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:20 +0000] "GET /phpmyadmin/navigation.php?ajax_request=1&token=64807f7c16e2dc45d917904257c656a9&aPath=cm9vdA%3D%3D.aW5mb3JtYXRpb25fc2NoZW1h&vPath=cm9vdA%3D%3D.aW5mb3JtYXRpb25fc2NoZW1h&pos=0&pos2_name=&pos2_value=&searchClause=&searchClause2=&_nocache=1389020600453725733 HTTP/1.1" 200 33023 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:29 +0000] "GET /phpmyadmin/index.php?token=64807f7c16e2dc45d917904257c656a9&ajax_request=true&ajax_page_request=true&menuHashes=54d4b237-2c8fe16a-960fc98d-0ac635f3-52bdaedc&_nocache=1389020609703945755 HTTP/1.1" 200 35678 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:31 +0000] "GET /phpmyadmin/version_check.php?&_nocache=1389020611123257673 HTTP/1.1" 200 39 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:37 +0000] "GET /phpmyadmin/db_structure.php?server=1&db=iowcaravanhire&token=64807f7c16e2dc45d917904257c656a9&ajax_request=true&ajax_page_request=true&menuHashes=54d4b237-2c8fe16a-960fc98d-0ac635f3-52bdaedc&_nocache=1389020617020954441 HTTP/1.1" 200 53583 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:55 +0000] "GET /phpmyadmin/db_structure.php?server=1&db=mysql&token=64807f7c16e2dc45d917904257c656a9&ajax_request=true&ajax_page_request=true&menuHashes=54d4b237-2c8fe16a-960fc98d-0ac635f3-52bdaedc&_nocache=1389020635553684134 HTTP/1.1" 200 76982 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:03:56 +0000] "GET /phpmyadmin/navigation.php?ajax_request=1&token=64807f7c16e2dc45d917904257c656a9&aPath=cm9vdA%3D%3D.bXlzcWw%3D&vPath=cm9vdA%3D%3D.bXlzcWw%3D&pos=0&pos2_name=&pos2_value=&searchClause=&searchClause2=&_nocache=1389020636848275942 HTTP/1.1" 200 20880 "http://localhost/phpmyadmin/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
::1 - - [06/Jan/2014:15:14:34 +0000] "GET /phpmyadmin/navigation.php?ajax_request=1&token=64807f7c16e2dc45d917904257c656a9&aPath=cm9vdA%3D%3D.cGhwbXlhZG1pbg%3D%3D&vPath=cm9vdA%3D%3D.cGhwbXlhZG1pbg%3D%3D&pos=0&pos2_name=&pos2_value=&searchClause=&searchClause2=&_nocache=1389021274048497109 HTTP/1.1" 200 11250 "http://localhost/phpmyadmin/import.php" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 06. January 2014 16:48

[06-Jan-2014 14:48:41 Europe/Berlin] PHP Warning: file_get_contents(lang.tmp): failed to open stream: No such file or directory in D:\xampp2\htdocs\xampp\index.php on line 2
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Re: Help Please, MySql error shutdown unexpectedly

Postby jiffa0 » 06. January 2014 16:50

[Mon Jan 06 14:41:13.537184 2014] [core:notice] [pid 22420:tid 656] AH00094: Command line: 'd:\\xampp2\\apache\\bin\\httpd.exe -d D:/xampp2/apache'
[Mon Jan 06 14:41:13.840201 2014] [mpm_winnt:notice] [pid 22420:tid 656] AH00418: Parent: Created child process 11596
[Mon Jan 06 14:41:36.554501 2014] [ssl:warn] [pid 11596:tid 668] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Mon Jan 06 14:41:38.649620 2014] [ssl:warn] [pid 11596:tid 668] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Mon Jan 06 14:41:39.014641 2014] [mpm_winnt:notice] [pid 11596:tid 668] AH00354: Child: Starting 150 worker threads.
jiffa0
 
Posts: 13
Joined: 03. January 2014 21:12
Operating System: windows 7 64bt

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 38 guests