← Back to team overview

maria-discuss team mailing list archive

Re: My Solution to MariaDB Database Server Crashed in Experimental Online Store

 

Good evening from Singapore,


My virtual server is an Amazon AWS Linux instance. I only gave it 1 GB of RAM.


How much RAM/memory do I need to support MariaDB SQL database server without crashing?


Giving my virtual server more than 1 GB of RAM will cost me more money.


________________________________
From: Rhys.Campbell@xxxxxxxxxxxx <Rhys.Campbell@xxxxxxxxxxxx>
Sent: Monday, October 22, 2018 6:22 PM
To: Turritopsis Dohrnii Teo En Ming; maria-discuss@xxxxxxxxxxxxxxxxxxx
Subject: RE: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

It's failing to allocate memory the innodb buffer pool. Check your memory usage / total ram / add more ram

-----Original Message-----
From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Turritopsis Dohrnii Teo En Ming
Sent: 22 October 2018 11:49
To: Reindl Harald <h.reindl@xxxxxxxxxxxxx>; maria-discuss@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

Good afternoon from Singapore,

My MariaDB SQL Database Server really crashed. I did not reboot my virtual server at all. It has crashed twice already.

Here is the output of /var/log/mariadb/mariadb.log.

[root@ip-10-0-0-76 mariadb]# tail -n 50 mariadb.log
181018  5:43:33 [Note] Server socket created on IP: '0.0.0.0'.
181018  5:43:33 [Note] Event Scheduler: Loaded 0 events
181018  5:43:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
181018  7:22:34 [Warning] IP address '31.184.193.100' could not be resolved: Name or service not known
181018  7:55:41 [Warning] IP address '58.218.213.3' could not be resolved: Name or service not known
181018 12:58:57 [Warning] IP address '113.4.133.5' could not be resolved: Name or service not known
181018 19:59:04 [Warning] IP address '196.52.43.89' could not be resolved: Name or service not known
181019 09:04:06 mysqld_safe Number of processes running now: 0
181019 09:04:06 mysqld_safe mysqld restarted
181019  9:04:06 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 15275 ...
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 128917504 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 96681984 bytes)
181019  9:04:06 [ERROR] mysqld: Out of memory (Needed 72499200 bytes)
181019  9:04:06 InnoDB: The InnoDB memory heap is disabled
181019  9:04:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181019  9:04:06 InnoDB: Compressed tables use zlib 1.2.7
181019  9:04:06 InnoDB: Using Linux native AIO
181019  9:04:06 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137756672 bytes) failed; errno 12
181019  9:04:06 InnoDB: Completed initialization of buffer pool
181019  9:04:06 InnoDB: Fatal error: cannot allocate memory for the buffer pool
181019  9:04:06 [ERROR] Plugin 'InnoDB' init function returned error.
181019  9:04:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
181019  9:04:06 [Note] Plugin 'FEEDBACK' is disabled.
181019  9:04:06 [ERROR] Unknown/unsupported storage engine: InnoDB
181019  9:04:06 [ERROR] Aborting

181019  9:04:06 [Note] /usr/libexec/mysqld: Shutdown complete

181019 09:04:07 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
181022 02:54:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
181022  2:54:37 [Note] /usr/libexec/mysqld (mysqld 5.5.60-MariaDB) starting as process 22837 ...
181022  2:54:37 InnoDB: The InnoDB memory heap is disabled
181022  2:54:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181022  2:54:37 InnoDB: Compressed tables use zlib 1.2.7
181022  2:54:37 InnoDB: Using Linux native AIO
181022  2:54:37 InnoDB: Initializing buffer pool, size = 128.0M
181022  2:54:37 InnoDB: Completed initialization of buffer pool
181022  2:54:37 InnoDB: highest supported file format is Barracuda.
181022  2:54:37  InnoDB: Starting crash recovery from checkpoint LSN=94454915
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
181022  2:54:37  InnoDB: Starting final batch to recover 4 pages from redo log
181022  2:54:37  InnoDB: Waiting for the background threads to start
181022  2:54:38 Percona XtraDB (http://www.percona.com) 5.5.59-MariaDB-38.11 started; log sequence number 94455139
181022  2:54:38 [Note] Plugin 'FEEDBACK' is disabled.
181022  2:54:38 [Note] Server socket created on IP: '0.0.0.0'.
181022  2:54:39 [Note] Event Scheduler: Loaded 0 events
181022  2:54:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.60-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server





===BEGIN SIGNATURE===
Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017 [1] https://tdtemcerts.wordpress.com/ [2] http://tdtemcerts.blogspot.sg/ [3] https://www.scribd.com/user/270125049/Teo-En-Ming
===END SIGNATURE===




From: Maria-discuss <maria-discuss-bounces+turritopsis.dohrnii=teo-en-ming.com@xxxxxxxxxxxxxxxxxxx> on behalf of Reindl Harald <h.reindl@xxxxxxxxxxxxx>
Sent: Friday, October 19, 2018 8:00 PM
To: maria-discuss@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store



Am 19.10.18 um 13:17 schrieb Turritopsis Dohrnii Teo En Ming:
> Good evening from Singapore,
>
> Here is my solution:
>
> # systemctl start mariadb.service
>
> # mysql
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 2
> Server version: 5.5.60-MariaDB MariaDB Server
>
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> MariaDB [(none)]> quit
> Bye
>
> # systemctl enable mariadb.service

what has this to do with a crash?
you simply forgot to enable the service and rebootet

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Follow ups

References