[Lightsail] mysql-server crippled on Ubuntu 20.04 image?

0

Hi all,

I did a fresh installation today, just spinned a new instance on lightsail with Ubuntu 20.04 image and noticed that doing:

sudo apt install mysql-server

Basically not only does it fails but it cripples the server completely hogging the CPU because the mysqld fails to start but somehow ends in the weirdest loop ever.

All I know is that I can't set up the server and I haven't had a problem using another service.. I don't know if it's a mirror thing. It's been a weird turn of events.

asked 4 years ago405 views
2 Answers
0

davidg50,

Thanks for using Lightsail. I am sorry to hear that you are having trouble with this setup. With problems like these the first thing I do is see if I can't easily reproduce the issue by trying what you did. I started up a Nano sized instance running Ubuntu 20.04 LTS and then issued the same command you mention below once it had come up.

On the Nano instance my installation also failed and I experienced some CPU throttling as well. /var/log/syslog had this to say:

Sep 28 23:49:48 ip-172-26-10-28 kernel: [ 1677.033109] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysql.service,task=mysqld,pid=5995,uid=113
Sep 28 23:49:48 ip-172-26-10-28 kernel: [ 1677.033132] Out of memory: Killed process 5995 (mysqld) total-vm:731884kB, anon-rss:270104kB, file-rss:2012kB, shmem-rss:0kB, UID:113 pgtables:772kB oom_score_adj:0
Sep 28 23:49:48 ip-172-26-10-28 kernel: [ 1677.064135] oom_reaper: reaped process 5995 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB

So it seems the server daemon ran out of memory during startup.

I tried this on the next size up (Micro) and it worked without problems.

If you are using our smallest size instance to do this, you may consider bumping that up to the Micro size. If you are not using the Nano, please provide any snippets from your syslog or mysql error.log files to help diagnose the issue.

I hope this helps!

Donley

profile pictureAWS
answered 3 years ago
0

Hello,

It seems mysql-server uses so much memory these days but yea that fixed my issue. I selected the 1GB ram lightsail instance and it went away.

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions