Report this

What is the reason for this report?

Error Establishing Database Connection

Posted on July 21, 2017

I’ve been having this issue since I setup this droplet roughly a month ago. I’m paying for the $10 WordPress server which should be more than capable of handing this website. It’s 10 pages are receiving virtually no traffic. I have websites on the $5 servers that are much larger and handle daily traffic fine.

I’ve installed htop and sometimes if I click around too quickly in Wordpress it causes the server to use to much ram. That’s not much of an issue. The issue is the server randomly crashing hundreds of times a day.

I don’t believe it’s my theme or my plugins. I’ve used this same theme and plugins on other websites with no problems.

Also, I followed the instruction on how to turn off XML-RPC so that won’t be the cause.

I have hundreds of these each day. /var/log/mysql/error.log:2017-07-21T14:16:46.127753Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool /var/log/mysql/error.log:2017-07-21T14:17:16.670788Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool /var/log/mysql/error.log:2017-07-21T14:17:47.151463Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool /var/log/mysql/error.log:2017-07-21T14:18:17.705673Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool

2017-07-21T20:33:11.925586Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is ``` deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-07-21T20:33:11.930052Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.16.04.1) starting as process 14555 … 2017-07-21T20:33:11.949845Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-07-21T20:33:11.949895Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-07-21T20:33:11.949905Z 0 [Note] InnoDB: Uses event mutexes 2017-07-21T20:33:11.949911Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-07-21T20:33:11.949916Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-07-21T20:33:11.949937Z 0 [Note] InnoDB: Using Linux native AIO 2017-07-21T20:33:11.951436Z 0 [Note] InnoDB: Number of pools: 1 2017-07-21T20:33:11.953206Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-07-21T20:33:11.957165Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-07-21T20:33:11.976546Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-07-21T20:33:11.982923Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-07-21T20:33:12.003975Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-07-21T20:33:12.008146Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 262544310 2017-07-21T20:33:12.008204Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 262544319 2017-07-21T20:33:12.008216Z 0 [Note] InnoDB: Database was not shutdown normally! 2017-07-21T20:33:12.008222Z 0 [Note] InnoDB: Starting crash recovery. 2017-07-21T20:33:12.208095Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1” 2017-07-21T20:33:12.208142Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-07-21T20:33:12.208229Z 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait … 2017-07-21T20:33:12.253431Z 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB. 2017-07-21T20:33:12.254339Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-07-21T20:33:12.254352Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-07-21T20:33:12.256557Z 0 [Note] InnoDB: Waiting for purge to start 2017-07-21T20:33:12.306871Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 262544319 2017-07-21T20:33:12.309148Z 0 [Note] Plugin ‘FEDERATED’ is disabled. 2017-07-21T20:33:12.309557Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-07-21T20:33:12.334812Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170721 20:33:12 2017-07-21T20:33:12.336702Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-07-21T20:33:12.336733Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306 2017-07-21T20:33:12.336749Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’; 2017-07-21T20:33:12.336810Z 0 [Note] Server socket created on IP: ‘127.0.0.1’. 2017-07-21T20:33:12.371365Z 0 [Note] Event Scheduler: Loaded 0 events 2017-07-21T20:33:12.371654Z 0 [Note] /usr/sbin/mysqld: ready for connections. engine. You may use the startup option ‘–disable-partition-engine-check’ to skip this check. 2017-07-21T20:33:12.371671Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-07-21T20:33:12.423844Z 0 [Note] End of list of non-natively partitioned tables 2017-07-21T20:33:12.674749Z 3 [Note] Access denied for user ‘root’@‘localhost’ (using password: NO)

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.