Hi all,
I'm a newbie that may be in over my head. I am trying to use XAMPP to run open biblio for a small church library. all was going well until I tried to start this morning. All worked well last night which makes the log message worrisome:
"Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums"
on the log:
[color=#0000FF]2017-05-12 18:01:01 1db0 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.
2017-05-12 18:01:01 7600 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2017-05-12 18:01:01 7600 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-12 18:01:01 7600 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-12 18:01:01 7600 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-05-12 18:01:01 7600 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-05-12 18:01:01 7600 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-12 18:01:01 7600 [Note] InnoDB: Using generic crc32 instructions
2017-05-12 18:01:01 7600 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-12 18:01:01 7600 [Note] InnoDB: Completed initialization of buffer pool
2017-05-12 18:01:02 7600 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-12 18:01:02 7600 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 1835087 in the ib_logfiles!
2017-05-12 18:01:02 7600 [Note] InnoDB: Database was not shutdown normally!
2017-05-12 18:01:02 7600 [Note] InnoDB: Starting crash recovery.
2017-05-12 18:01:02 7600 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-05-12 18:01:03 7600 [Note] InnoDB: Restoring possible half-written data pages
2017-05-12 18:01:03 7600 [Note] InnoDB: from the doublewrite buffer...
2017-05-12 18:01:05 7600 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-12 18:01:05 7600 [Note] InnoDB: Waiting for purge to start
2017-05-12 18:01:05 7600 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835087
2017-05-12 18:01:05 8044 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-12 18:01:05 7600 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-12 18:01:05 7600 [Note] Server socket created on IP: '::'.
2017-05-12 18:01:07 7600 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.21-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-05-12 18:01:38 2752 [ERROR] mysqld.exe: Table '.\openbiblio\settings' is marked as crashed and should be repaired
2017-05-12 18:01:38 2752 [Warning] Checking table: '.\openbiblio\settings'
2017-05-12 18:06:36 8632 [ERROR] mysqld.exe: Table '.\openbiblio\session' is marked as crashed and should be repaired
2017-05-12 18:06:36 8632 [Warning] Checking table: '.\openbiblio\session'
2017-05-12 18:10:34 2752 [ERROR] mysqld.exe: Table '.\openbiblio\member' is marked as crashed and should be repaired
2017-05-12 18:10:34 2752 [Warning] Checking table: '.\openbiblio\member'
2017-05-12 18:10:34 2752 [ERROR] mysqld.exe: Table '.\openbiblio\member_fields' is marked as crashed and should be repaired
2017-05-12 18:10:34 2752 [Warning] Checking table: '.\openbiblio\member_fields'
2017-05-12 18:20:43 8632 [ERROR] mysqld.exe: Table '.\openbiblio\usmarc_tag_dm' is marked as crashed and should be repaired
2017-05-12 18:20:43 8632 [Warning] Checking table: '.\openbiblio\usmarc_tag_dm'
2017-05-12 18:20:43 8632 [ERROR] mysqld.exe: Table '.\openbiblio\usmarc_subfield_dm' is marked as crashed and should be repaired
2017-05-12 18:20:43 8632 [Warning] Checking table: '.\openbiblio\usmarc_subfield_dm'
[/color]
What is weird is I thought I may have shutdown while forgetting to quit XAMPP, but log erro shows time of 18h00 when I actually started the program.
Any help or advise would be welcome. We are desperate.
Thanks!!