• Resolved tektonik.com

    (@tektonikcom)


    We had to rename the folder where this plugin was stored because it was generating too many user connections to the database, crashing the site completely. Please see the error message:

    Fatal error: SQLSTATE[42000] [1203] User **** already has more than ‘max_user_connections’ active connections in /home/gonzo/domains/***.com/public_html/members/library/Am/Lite.php on line 885

    The error message is linked to the aMember plugin but was in fact caused by WP Google Maps locking up queries :

    | 130 | gonzo_dbadmin | localhost | gonzo_wp | Query | 0 | creating table | ALTER TABLE qbr521e_wpgmza_maps CHANGE COLUMN traffic traffic INT(10) NOT NULL |
    | 133 | gonzo_dbadmin | localhost | gonzo_wp | Query | 39 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN polyname polyname VARCHAR(100) NOT NULL |
    | 137 | gonzo_dbadmin | localhost | gonzo_wp | Query | 75 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
    | 139 | gonzo_dbadmin | localhost | gonzo_wp | Query | 31 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
    | 141 | gonzo_dbadmin | localhost | gonzo_wp | Query | 19 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohopacity ohopacity VARCHAR(3) NOT NULL |
    | 144 | gonzo_dbadmin | localhost | gonzo_wp | Query | 63 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
    | 146 | gonzo_dbadmin | localhost | gonzo_wp | Query | 38 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
    | 148 | gonzo_dbadmin | localhost | gonzo_wp | Query | 36 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
    | 151 | gonzo_dbadmin | localhost | gonzo_wp | Query | 4 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohlinecolor ohlinecolor VARCHAR(7) NOT NULL |
    | 153 | gonzo_dbadmin | localhost | gonzo_wp | Query | 82 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
    | 156 | gonzo_dbadmin | localhost | gonzo_wp | Query | 56 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
    | 159 | gonzo_dbadmin | localhost | gonzo_wp | Query | 50 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |
    | 161 | gonzo_dbadmin | localhost | gonzo_wp | Query | 46 | Waiting for table metadata lock | ALTER TABLE qbr521e_wpgmza_polygon CHANGE COLUMN ohfillcolor ohfillcolor VARCHAR(7) NOT NULL |

    There’s a lot more, I only pasted an excerpt.

    Please advise.

    Thank you,
    Alain

    https://wordpress.org/plugins/wp-google-maps/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author WPGMaps

    (@wpgmaps)

    Hi there.

    So sorry for only getting back to you now.

    Please advise what plugin you used to record this so that we can try replicate this on our side? This is the first time i’ve seen this though.

    My apologies for any inconvenience caused.

    Plugin Author WPGMaps

    (@wpgmaps)

    Hi Alain
    Further to our note, and looking a little deeper on our side, those SQL queries should only run on activation of the plugin, or on update of the plugin. If you can please get in touch with me so I can get the full list of the queries that were run so that I may debug further? Please use our contact page on our website.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WP Google Maps Crashes Website’ is closed to new replies.