{"id":49,"date":"2021-01-20T23:19:06","date_gmt":"2021-01-20T23:19:06","guid":{"rendered":"https:\/\/www.jibsheet.net\/linux\/?p=49"},"modified":"2021-04-06T14:35:09","modified_gmt":"2021-04-06T14:35:09","slug":"mysql-crash-cannot-connect-to-database-with-wordpress","status":"publish","type":"post","link":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/","title":{"rendered":"Mysql crash – “Cannot connect to database” with WordPress"},"content":{"rendered":"

You setup that AWS EC2 and many days later you find that mysql crashed.\u00a0 Why<\/p>\n

    \n
  1. \u00a0Look in \/var\/log\/messages\u00a0 ( more \/var\/log\/messages and search for mysql<\/li>\n
  2. \u00a0See this…<\/li>\n<\/ol>\n

    Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.802432] Out of memory: Kill pro<\/strong>
    \ncess 28710 (mysqld) score 192 or sacrifice child<\/strong>
    \nJan 18 04:23:07 ip-my-host-ip kernel: [7803276.808288] Killed process 28710 (m
    \nysqld) total-vm:1149068kB, anon-rss:193628kB, file-rss:0kB, shmem-rss:0kB
    \nJan 18 04:23:07 ip-my-host-ip kernel: [7803276.839156] oom_reaper: reaped proc
    \ness 28710 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB<\/p>\n

    3.\u00a0 \u00a0Why run out of memory – well – it has to do with swap<\/p>\n

    [root@ip-my-host-ip log]# top
    \ntop – 23:06:06 up 93 days, 2:18, 1 user, load average: 0.00, 0.00, 0.00
    \nTasks: 98 total, 1 running, 70 sleeping, 0 stopped, 0 zombie
    \nCpu(s): 0.1%us, 0.0%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
    \nMem: 1009132k total, 828180k used, 180952k free, 74476k buffers
    \nSwap: 0k total, 0k used, 0k free,<\/strong> 134412k cached<\/p>\n

     <\/p>\n

    4.\u00a0 You can see on the last line – swap is 0k – so you Need to add swap<\/p>\n

    \r\n\r\n[root@ip-my-host-ip log]# fallocate -l 1G \/swapfile\r\n[root@ip-my-host-ip log]# chmod 600 \/swapfile\r\n[root@ip-my-host-ip log]# mkswap \/swapfile\r\nSetting up swapspace version 1, size = 1048572 KiB\r\nno label, UUID=7a35f172-cded-438d-8032-f2103873794e\r\n[root@ip-my-host-ip log]# sudo swapon \/swapfile\r\n[root@ip-my-host-ip log]# swapon --show\r\nNAME TYPE SIZE USED PRIO\r\n\/swapfile file 1024M 0B -2\r\n[root@ip-my-host-ip log]# free\r\ntotal used free shared buffers cached\r\nMem: 1009132 830840 178292 368 74540 136204\r\n-\/+ buffers\/cache: 620096 389036\r\nSwap: 1048572 0 1048572\r\n\r\n<\/pre>\n
     <\/p>\n
    Note:  if you have issues – try using dd to allocate swapfile.<\/p>\n
    \r\n[root@ip-my-host-ip log]# dd if=\/dev\/zero of=\/swapfile bs=1024 count=1048576\r\n1048576+0 records in\r\n1048576+0 records out\r\n1073741824 bytes (1.1 GB) copied, 6.36502 s, 169 MB\/s\r\n<\/pre>\n
    5.\u00a0 add it to the \/etc\/fstab<\/p>\n
    \r\n#\r\nLABEL=\/ \/ ext4 defaults,noatime 1 1\r\ntmpfs \/dev\/shm tmpfs defaults 0 0\r\ndevpts \/dev\/pts devpts gid=5,mode=620 0 0\r\nsysfs \/sys sysfs defaults 0 0\r\nproc \/proc proc defaults 0 0\r\n\/swapfile none swap sw 0 0<\/strong>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
    You setup that AWS EC2 and many days later you find that mysql crashed.\u00a0 Why \u00a0Look in \/var\/log\/messages\u00a0 ( more \/var\/log\/messages and search for mysql \u00a0See this… Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.802432] Out of memory: Kill pro cess 28710 (mysqld) score 192 or sacrifice child Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.808288] Killed process 28710 (m ysqld) total-vm:1149068kB, anon-rss:193628kB, file-rss:0kB, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[],"yoast_head":"\nMysql crash - "Cannot connect to database" with Wordpress - Jon Allen's Linux Stuff<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql crash - "Cannot connect to database" with Wordpress - Jon Allen's Linux Stuff\" \/>\n<meta property=\"og:description\" content=\"You setup that AWS EC2 and many days later you find that mysql crashed.\u00a0 Why \u00a0Look in \/var\/log\/messages\u00a0 ( more \/var\/log\/messages and search for mysql \u00a0See this… Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.802432] Out of memory: Kill pro cess 28710 (mysqld) score 192 or sacrifice child Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.808288] Killed process 28710 (m ysqld) total-vm:1149068kB, anon-rss:193628kB, file-rss:0kB, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"Jon Allen's Linux Stuff\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-20T23:19:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-06T14:35:09+00:00\" \/>\n<meta name=\"author\" content=\"jonallen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jonallen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\"},\"author\":{\"name\":\"jonallen\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993\"},\"headline\":\"Mysql crash – “Cannot connect to database” with WordPress\",\"datePublished\":\"2021-01-20T23:19:06+00:00\",\"dateModified\":\"2021-04-06T14:35:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\"},\"wordCount\":181,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993\"},\"articleSection\":[\"AWS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\",\"url\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\",\"name\":\"Mysql crash - \\\"Cannot connect to database\\\" with Wordpress - Jon Allen's Linux Stuff\",\"isPartOf\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#website\"},\"datePublished\":\"2021-01-20T23:19:06+00:00\",\"dateModified\":\"2021-04-06T14:35:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.jibsheet.net\/linux\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mysql crash – “Cannot connect to database” with WordPress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#website\",\"url\":\"https:\/\/www.jibsheet.net\/linux\/\",\"name\":\"Jon Allen's Linux Stuff\",\"description\":\"Howto's, Observations, and stuff\",\"publisher\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jibsheet.net\/linux\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993\",\"name\":\"jonallen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7d7c061ce9db8f5e4710555585475882?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7d7c061ce9db8f5e4710555585475882?s=96&d=mm&r=g\",\"caption\":\"jonallen\"},\"logo\":{\"@id\":\"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.jibsheet.net\/linux\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mysql crash - \"Cannot connect to database\" with Wordpress - Jon Allen's Linux Stuff","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"Mysql crash - \"Cannot connect to database\" with Wordpress - Jon Allen's Linux Stuff","og_description":"You setup that AWS EC2 and many days later you find that mysql crashed.\u00a0 Why \u00a0Look in \/var\/log\/messages\u00a0 ( more \/var\/log\/messages and search for mysql \u00a0See this… Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.802432] Out of memory: Kill pro cess 28710 (mysqld) score 192 or sacrifice child Jan 18 04:23:07 ip-my-host-ip kernel: [7803276.808288] Killed process 28710 (m ysqld) total-vm:1149068kB, anon-rss:193628kB, file-rss:0kB, […]","og_url":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/","og_site_name":"Jon Allen's Linux Stuff","article_published_time":"2021-01-20T23:19:06+00:00","article_modified_time":"2021-04-06T14:35:09+00:00","author":"jonallen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"jonallen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#article","isPartOf":{"@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/"},"author":{"name":"jonallen","@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993"},"headline":"Mysql crash – “Cannot connect to database” with WordPress","datePublished":"2021-01-20T23:19:06+00:00","dateModified":"2021-04-06T14:35:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/"},"wordCount":181,"commentCount":0,"publisher":{"@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993"},"articleSection":["AWS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/","url":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/","name":"Mysql crash - \"Cannot connect to database\" with Wordpress - Jon Allen's Linux Stuff","isPartOf":{"@id":"https:\/\/www.jibsheet.net\/linux\/#website"},"datePublished":"2021-01-20T23:19:06+00:00","dateModified":"2021-04-06T14:35:09+00:00","breadcrumb":{"@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.jibsheet.net\/linux\/index.php\/2021\/01\/20\/mysql-crash-cannot-connect-to-database-with-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.jibsheet.net\/linux\/"},{"@type":"ListItem","position":2,"name":"Mysql crash – “Cannot connect to database” with WordPress"}]},{"@type":"WebSite","@id":"https:\/\/www.jibsheet.net\/linux\/#website","url":"https:\/\/www.jibsheet.net\/linux\/","name":"Jon Allen's Linux Stuff","description":"Howto's, Observations, and stuff","publisher":{"@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jibsheet.net\/linux\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/295a80d0b2aa929b648c4fdddee83993","name":"jonallen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7d7c061ce9db8f5e4710555585475882?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7d7c061ce9db8f5e4710555585475882?s=96&d=mm&r=g","caption":"jonallen"},"logo":{"@id":"https:\/\/www.jibsheet.net\/linux\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.jibsheet.net\/linux"]}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/posts\/49"}],"collection":[{"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":3,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":120,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/posts\/49\/revisions\/120"}],"wp:attachment":[{"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jibsheet.net\/linux\/index.php\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}