[Koha] MySql errors

Fri Dec 4 07:21:13 NZDT 2020

Nothing that jumps out at me ???

201201 14:04:21 [Warning] Using unique option prefix myisam-recover instead
of myisam-recover-options is deprecated and will be removed in a future
release. Please use the full name instead.
201201 14:04:21 [Note] Plugin 'FEDERATED' is disabled.
201201 14:04:21 InnoDB: The InnoDB memory heap is disabled
201201 14:04:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
201201 14:04:21 InnoDB: Compressed tables use zlib 1.2.8
201201 14:04:21 InnoDB: Using Linux native AIO
201201 14:04:22 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
201201 14:04:22 InnoDB: Completed initialization of buffer pool
201201 14:04:22 InnoDB: Fatal error: cannot allocate memory for the buffer
pool
201201 14:04:22 [ERROR] Plugin 'InnoDB' init function returned error.
201201 14:04:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
201201 14:04:23 [ERROR] Unknown/unsupported storage engine: InnoDB
201201 14:04:23 [ERROR] Aborting

201201 14:04:23 [Note] /usr/sbin/mysqld: Shutdown complete

201202  4:42:38 [Warning] Using unique option prefix myisam-recover instead
of myisam-recover-options is deprecated and will be removed in a future
release. Please use the full name instead.
201202  4:42:38 [Note] Plugin 'FEDERATED' is disabled.
201202  4:42:38 InnoDB: The InnoDB memory heap is disabled
201202  4:42:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
201202  4:42:38 InnoDB: Compressed tables use zlib 1.2.8
201202  4:42:38 InnoDB: Using Linux native AIO
201202  4:42:38 InnoDB: Initializing buffer pool, size = 128.0M
201202  4:42:38 InnoDB: Completed initialization of buffer pool
201202  4:42:38 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
201202  4:42:38  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...
201202  4:42:38  InnoDB: Waiting for the background threads to start
201202  4:42:39 InnoDB: 5.5.62 started; log sequence number 2511323625
201202  4:42:39 [Note] Server hostname (bind-address): '10.27.1.25'; port:
3306
201202  4:42:39 [Note]   - '10.27.1.25' resolves to '10.27.1.25';
201202  4:42:39 [Note] Server socket created on IP: '10.27.1.25'.
201202  4:42:39 [Note] Event Scheduler: Loaded 0 events
201202  4:42:51 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.62-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port:
3306  (Debian)

On Thu, Dec 3, 2020 at 12:01 PM Alvaro Cornejo <cornejo.alvaro at gmail.com>
wrote:

> Hi Scott,
>
> Have you any error/warning on your mysql log that might give you a clue?
>
> Might it be that mysql runs out of allowed connections or memory?
>
> See this:
> https://tecadmin.net/check-update-max-connections-value-mysql
>
> https://www.percona.com/blog/2018/06/28/what-to-do-when-mysql-runs-out-of-memory-troubleshooting-guide/
>
> Also, you can check mysql config/performance with:
> https://github.com/major/MySQLTuner-perl
>
> In addition, you are not running memcached it will give an extra boost to
> your koha.
>
> Regards,
>
> Alvaro
>
>
> |----------------------------------------------------------------------------------------|
>  Stay safe / Cuídate/  Reste sécurisé
> *7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  *q *Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le jeu. 3 déc. 2020 à 11:34, Scott Owen <sowen at almaschools.net> a écrit :
>
>> Hi All,
>>
>> I have been getting some random errors for the last couple of months on
>> all
>> of my Koha boxes:
>>
>> Software error:
>> DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't
>> connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
>> (2) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1490. at
>> /usr/share/koha/lib/Koha/Database.pm line 102
>> For help, please send mail to the webmaster ([no address given]), giving
>> this error message and the time and date of the error.
>>
>>
>>
>> Current version information (at least for this one installation...other
>> versions may differ):
>>
>> Koha version: 17.11.18.000
>> OS version ('uname -a'): Linux Pine 3.16.0-4-686-pae #1 SMP Debian
>> 3.16.51-3 (2017-12-13) i686
>> Perl interpreter: /usr/bin/perl
>> Perl version: 5.020002
>> Perl @INC: /usr/share/koha/lib
>> /etc/perl
>> /usr/local/lib/i386-linux-gnu/perl/5.20.2
>> /usr/local/share/perl/5.20.2
>> /usr/lib/i386-linux-gnu/perl5/5.20
>> /usr/share/perl5
>> /usr/lib/i386-linux-gnu/perl/5.20
>> /usr/share/perl/5.20
>> /usr/local/lib/site_perl
>> .
>> MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (i686)
>> using readline 6.3
>> Apache version: Server version: Apache/2.4.10 (Debian)
>> Memcached: Servers: undefined | Namespace: koha | Status: unknown | Config
>> read from: Nowhere Note that the right place to define the memcached
>> config
>> is in your $KOHA_CONF file. Currently you do not have a valid memcached
>> configuration defined. | Effective caching method:
>> Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free
>> software, covered by the GNU General Public License, and you are welcome
>> to
>> change it and/or distribute copies of it under certain conditions.
>>
>> I've done some "googling" but couldn't find a definitive "fix" for this
>> issue....
>> Any idea where I should start on this ?? MySql config ??? Koha config ???
>> any ideas what I should be looking for ? Known issue ??
>> Thank you,
>>
>> -Scott
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>