Results 1 to 2 of 2

Thread: MySQL server crash for login user !!

  1. #1
    Thread Starter
    davidz101's Avatar
    Join Date
    Sep 2013
    Location
    United States
    Posts
    93
    Thanks
    0
    Thanked 1 Time in 1 Post

    MySQL server crash for login user !!

    Hi,
    Recently I found there are lot of MySQL server crashes in the error log, see blow at the bottom. my web site allows user to register and become an contributor, as a contributor, all their post need to be approved. I tried to reproduce this MySQL crash by login as a contributor, but I can not find out how they make MySQL crash.

    My wordpress version is 4.4.5. clipper version: 1.5.1-dev.

    I searched the internet for this issue, I did found out a similar one, URL: https://wordpress.org/support/topic/...-gone-away-12/, this issue exists on wordpress 4.3 and it is fixed in 4.3.1, while my wordpress runs on 4.4.5.

    so far I block the IP address which cause the MYSQL crash, but this does not work. I still see new crash every day, maybe there are other user or if they are spammer, they use different IP address. The last choice is to disable all the contributor accounts, but this will decrease the site functionality, so I don't want to do that.

    I would like to know how to prevent the Mysql server crash. please advise ASAP.

    Thanks
    -David

    error log are copied and pasted as below (3 crashes are pasted):

    [Fri Sep 09 00:52:25.465138 2016] [proxy_fcgi:error] [pid 3366:tid 139980273796864] [client 204.13.205.130:11711] AH01071: Got error 'PHP message: WordPress database error MySQL server has gone away for query UPDATE `wp_options` SET `option_value` = 'a:13774:{s:13:\\"198.177.116.4\\";a:2:{s:8:\\"att empts\\";i:4;s:4:\\"time\\";i:1441930271;}s:14:\\" 184.168.46.184\\";a:2:{s:8:\\"attempts\\";i:1;s:4: \\"time\\";i:1441423480;}s:14:\\"196.22.142.169\\" ;a:2:{s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441 941214;}s:13:\\"217.160.166.5\\";a:2:{s:8:\\"attem pts\\";i:1;s:4:\\"time\\";i:1441921759;}s:13:\\"10 3.15.234.25\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\" time\\";i:1441911782;}s:12:\\"94.236.15.40\\";a:2: {s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:144194829 3;}s:14:\\"108.171.169.72\\";a:2:{s:8:\\"attempts\ \";i:12;s:4:\\"time\\";i:1441951199;}s:14:\\"184.1 68.193.17\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\"ti me\\";i:1441933086;}s:12:\\"188.121.41.7\\";a:2:{s :8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441451420; }s:14:\\"146.148.41.160\\";a:2:{s:8:\\"attempts\\" ;i:2;s:4:\\"time\\";i:1441453430;}s:12:\\"96.127.1 34.3\\";a:2:{s:8:\\"attempts\\";i:3;s:4:\\"time\\" ;i:1441463536;}s:15:\\"184.168.193.174\\";a:2:{s:8 :\\"attempts\\";i:2;s:4:...\n', referer: http://www.mywebsitename.com

    Sat Sep 10 07:58:19.728943 2016] [proxy_fcgi:error] [pid 3366:tid 139980391294720] [client 117.156.13.11:10163] AH01071: Got error 'PHP message: WordPress database error MySQL server has gone away for query UPDATE `wp_options` SET `option_value` = 'a:13774:{s:13:\\"198.177.116.4\\";a:2:{s:8:\\"att empts\\";i:4;s:4:\\"time\\";i:1441930271;}s:14:\\" 184.168.46.184\\";a:2:{s:8:\\"attempts\\";i:1;s:4: \\"time\\";i:1441423480;}s:14:\\"196.22.142.169\\" ;a:2:{s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441 941214;}s:13:\\"217.160.166.5\\";a:2:{s:8:\\"attem pts\\";i:1;s:4:\\"time\\";i:1441921759;}s:13:\\"10 3.15.234.25\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\" time\\";i:1441911782;}s:12:\\"94.236.15.40\\";a:2: {s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:144194829 3;}s:14:\\"108.171.169.72\\";a:2:{s:8:\\"attempts\ \";i:12;s:4:\\"time\\";i:1441951199;}s:14:\\"184.1 68.193.17\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\"ti me\\";i:1441933086;}s:12:\\"188.121.41.7\\";a:2:{s :8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441451420; }s:14:\\"146.148.41.160\\";a:2:{s:8:\\"attempts\\" ;i:2;s:4:\\"time\\";i:1441453430;}s:12:\\"96.127.1 34.3\\";a:2:{s:8:\\"attempts\\";i:3;s:4:\\"time\\" ;i:1441463536;}s:15:\\"184.168.193.174\\";a:2:{s:8 :\\"attempts\\";i:2;s:4:...\n', referer: http://www.mywebsiteurl.com


    [Sat Sep 10 07:58:23.920673 2016] [proxy_fcgi:error] [pid 21693:tid 139980248618752] [client 117.156.13.11:11092] AH01071: Got error 'PHP message: WordPress database error MySQL server has gone away for query UPDATE `wp_options` SET `option_value` = 'a:13774:{s:13:\\"198.177.116.4\\";a:2:{s:8:\\"att empts\\";i:4;s:4:\\"time\\";i:1441930271;}s:14:\\" 184.168.46.184\\";a:2:{s:8:\\"attempts\\";i:1;s:4: \\"time\\";i:1441423480;}s:14:\\"196.22.142.169\\" ;a:2:{s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441 941214;}s:13:\\"217.160.166.5\\";a:2:{s:8:\\"attem pts\\";i:1;s:4:\\"time\\";i:1441921759;}s:13:\\"10 3.15.234.25\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\" time\\";i:1441911782;}s:12:\\"94.236.15.40\\";a:2: {s:8:\\"attempts\\";i:1;s:4:\\"time\\";i:144194829 3;}s:14:\\"108.171.169.72\\";a:2:{s:8:\\"attempts\ \";i:12;s:4:\\"time\\";i:1441951199;}s:14:\\"184.1 68.193.17\\";a:2:{s:8:\\"attempts\\";i:1;s:4:\\"ti me\\";i:1441933086;}s:12:\\"188.121.41.7\\";a:2:{s :8:\\"attempts\\";i:1;s:4:\\"time\\";i:1441451420; }s:14:\\"146.148.41.160\\";a:2:{s:8:\\"attempts\\" ;i:2;s:4:\\"time\\";i:1441453430;}s:12:\\"96.127.1 34.3\\";a:2:{s:8:\\"attempts\\";i:3;s:4:\\"time\\" ;i:1441463536;}s:15:\\"184.168.193.174\\";a:2:{s:8 :\\"attempts\\";i:2;s:4:...\n', referer: http://www.mywebsiteurl.com

  2. #2
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    35,550
    Thanks
    158
    Thanked 2,836 Times in 2,714 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New user login CRASH
    By jmunce in forum Report ClassiPress Bugs
    Replies: 12
    Last Post: August 10th, 2016, 10:00 AM
  2. To many connections to MySQL server
    By justmotors in forum ClassiPress General Discussion
    Replies: 0
    Last Post: May 12th, 2015, 08:52 AM
  3. MySQL server error
    By denktankermedia in forum Report JobRoller Bugs
    Replies: 3
    Last Post: March 4th, 2015, 12:07 PM
  4. any one running large classi press ? it crash mysql
    By sonnycool in forum Help Using ClassiPress
    Replies: 0
    Last Post: February 6th, 2015, 05:58 AM
  5. BlueHost Mail Server Crash in October 22, 2013
    By mjbari in forum Report JobRoller Bugs
    Replies: 2
    Last Post: October 26th, 2013, 12:04 PM