Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
I was very happy when I noticed new 2.0 version because this chat modul has very friendly UI and looks exactly to fits my needs (flag friend integration and sound notification when a new message arrive). I have installed 2.0-beta2 version, and configured all settings.
Unfortunately after few cache clears site goes down with MySQL database connection error: "Too many connections". Issue is repeating every 5-10 minutes. Ajax pulling method did not work at all. When chat modul is disabled, everything is fine (site is alive all the time).
Comments
Comment #1
darklrd CreditAttribution: darklrd commentedWere you able to install the module properly? Did you upgrade it from an earlier version? What is the value of the max_connections variable in the mysql configuration file?
Comment #2
miljats CreditAttribution: miljats commentedNo, I was not able to clean install beta-2 version, so I installed version 1.2 and upgraded to beta-2.
mysql.allow_persistent On
mysql.max_links Unlimited
mysql.max_persistent Unlimited
Comment #3
darklrd CreditAttribution: darklrd commentedUninstall (not just disable) and install the drupalchat 6.x-2.0-beta4. Also read this issue - #1055896: Many issues one after another... FAQ & Help here! for installation related problems.
Comment #4
WolfSoul CreditAttribution: WolfSoul commentedThis error happens also with the drupal 7 version
Comment #5
WolfSoul CreditAttribution: WolfSoul commentedComment #6
igorik CreditAttribution: igorik commentedI have the same problem, this module exhausted server resources.
Comment #7
igorik CreditAttribution: igorik commentedComment #8
igorik CreditAttribution: igorik commentedComment #9
wickedwookie CreditAttribution: wickedwookie commentedSame problem here using the 6.x-2.0-beta4.
I noticed a considerable performance loss over the course of the day when developing a site on a single-site dedicated server setup. The site became more and more sluggish over the day. Disabling drupalchat instantly resolved the issue..
MySQL version used is 5.1.49. max connections allowed is set to 1.100.
Looking at the server stats, the db has set up
262 k connections and processed
3 M select and 3 M update queries
over the last 24 days, on a single site dev machine! That seems too many... I'll see how many I get now that the module is disabled..
Comment #10
darklrd CreditAttribution: darklrd commentedPlan to integrate this module with nodejs. That should fix this issue.
Comment #11
igorik CreditAttribution: igorik commentedIt sounds very good. I thought already that nobody cares about this handy module.
I stopped to use this because this bug (drupal 6.x version), and start to use bowob chat instead, which is as well very handy, but looking forward to try this again and maybe replace bowob with this in the future (if here will be the maintaince for this project).
Comment #12
igorik CreditAttribution: igorik commentedmaybe this can be helpful
http://drupal.org/project/nodejs
Comment #13
darklrd CreditAttribution: darklrd commentedYes, I am working on integration with this module.
Comment #14
darklrd CreditAttribution: darklrd commentedGood new: DrupalChat 7.x-1.x-dev now supports node.js backend! :-)
Commit: http://drupalcode.org/project/drupalchat.git/commit/15b37f6
Comment #15
igorik CreditAttribution: igorik commentedthese are very good news! looking forward to 6.x :)
Comment #16
WolfSoul CreditAttribution: WolfSoul commentedIm guessing I would need this module, node js integration module.. and do I have to upload something for node.js (sorry if this sounds stupid.. I know more about design than programing)
Comment #17
carvalhar CreditAttribution: carvalhar commentedfor drupal 6, is there a solution?
this module can reduce the ajax time:
http://drupal.org/project/js
And a backport do D6 is comming at Node.js module:
http://drupal.org/node/1082840#comment-5064260
I'm lost comparing D7/D6 versions of both modules...can someone help with the steps for suport it in d6?
thanks
Comment #18
danielm CreditAttribution: danielm commentedSubscribing DrupalChat 6.x with Node.js
Comment #19
drumming_cat CreditAttribution: drumming_cat commentedSubscribing DrupalChat 6.x with Node.js
Comment #20
eraccusa CreditAttribution: eraccusa commentedI was excited to find a currently supported live chat module for my small business site and got DrupalChat (drupalchat-6.x-2.0-beta11.tar.gz) installed and working for support communication with our clients ... I thought. Then while testing out DrupalChat, my site, hosted on a large shared hosting service, popped up an error saying it has a problem and is offline. The ONLY way I could recover was to delete the sites/all/modules/drupalchat directory. I am guessing I am going to get a nasty e-mail from my web host about too much SQL usage again if this "Too many connections" error was what caused my site to tank.
A useful, "free", chat module seemed too good to be true. It turned out it was too good to be true for us anyway. :(
Comment #21
nevets CreditAttribution: nevets commentedIn Drupal 7 it appears to be keeping mysql connections open. If I disable the module and wait for the hung connections to clear, I can wander all over the site and no problem. If the module is re-enabled, the hung connections return suggesting the callback used is terminating it such a way that it prevents Drupal from cleaning up the database connection.
Comment #22
darklrd CreditAttribution: darklrd commentedThis may be happening due to long polling. Could you please switch to normal ajax and see if it works fine? If so, then I will change default polling method to Normal AJAX. Thanks.
Comment #23
nevets CreditAttribution: nevets commentedInitial test shows Normal AJAX is working better. Will need to run longer test tomorrow.
Thanks
Comment #24
nevets CreditAttribution: nevets commentedSo far, using the Normal AJAX method there are no signs of hung mySql connections so this would seem to be a better default.
Comment #25
darklrd CreditAttribution: darklrd commentedThanks a lot for confirming this. Will make it the default in next release.
Comment #26
darklrd CreditAttribution: darklrd commentedChange introduced in 7.x-1.0-beta17. Thanks.
Comment #27
tarakennedy1221@gmail.com CreditAttribution: tarakennedy1221@gmail.com commented