I get an error (see below) when using mass contact for sending to around 70 emails, although I broke the message every 25 emails just in case... I know some of the users got the message but no idea if everyone did it. No node of mass contact was created as well.

I get no problems when sending to just a few (to 7-10 emails).

I am running Drupal 5.5 on 1&1 hosting. I have no idea of MySQL but I gess it has to do with the time mass contact is taking for sending the messages out.

Any idea how to solve the problem? I really ned help with this...

Thanks,

psc

The Error

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '[Success] Send #!ccc: -e-mails' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '[Success] Send #!ccc: -e-mails' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '[Success] Send #!ccc: -e-mails') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: SELECT lid FROM artve_drupal_locales_source WHERE source = '[Success] Send #!ccc: -e-mails' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT s.lid, t.translation FROM artve_drupal_locales_source s INNER JOIN artve_drupal_locales_target t ON s.lid = t.lid WHERE s.source = '%message in %file on line %line.' AND t.locale = 'es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid, source FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_source (location, source) VALUES ('/mass_contact', '%message in %file on line %line.') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: SELECT lid FROM artve_drupal_locales_source WHERE source = '%message in %file on line %line.' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_locales_target (lid, locale, translation) VALUES (0, 'es', '') in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO artve_drupal_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: DELETE FROM artve_drupal_cache WHERE cid = 'locale:es' in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172.', 2, '', 'http://afectadosrtve.es/mass_contact', 'http://afectadosrtve.es/mass_contact', '84.190.39.164', 1197333128) in /homepages/21/d222132267/htdocs/drupal55/includes/database.mysql.inc on line 172

Comments

oadaeh’s picture

oadaeh commented

This looks like you've lost the connection to your database server.

And lo, there is a MySQL page that talks about it: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

I'm not sure why you would be getting this. Maybe it's trying to send too many e-mails at one time, but I would think your PHP or Apache would time out before your database (unless it's set to a lower time-out duration than the web server). Still, you could try setting the "Max number of users before breaking up the e-mail" setting on the Settings page (admin/build/mass_contact/settings) to some low-ish number, like 10, to see if that makes this error go away.

genemcc’s picture

genemcc commented

I set my Max number to 10 and still get these errors...

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Mass email', 'mass_contact', 'http://dfwaug.net/mass_contact', '71.244.26.228', 2, '3b61e3e26b3d75daa687a421e3d1d607', 160195, 1202932517) in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172.', 2, '', 'http://www.dfwaug.net/mass_contact', 'http://dfwaug.net/mass_contact', '71.244.26.228', 1202932517) in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Cannot modify header information - headers already sent by (output started at /homepages/20/d176116070/htdocs/includes/database.mysql.inc:172) in /homepages/20/d176116070/htdocs/includes/common.inc on line 311.', 2, '', 'http://www.dfwaug.net/mass_contact', 'http://dfwaug.net/mass_contact', '71.244.26.228', 1202932517) in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = '3b61e3e26b3d75daa687a421e3d1d607' in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172.', 2, '', 'http://www.dfwaug.net/mass_contact', 'http://dfwaug.net/mass_contact', '71.244.26.228', 1202932517) in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('3b61e3e26b3d75daa687a421e3d1d607', 2, 0, '71.244.26.228', 'form|a:1:{s:32:\\"817221105f3e22c640747f9109afdc37\\";a:2:{s:9:\\"timestamp\\";i:1202932243;s:4:\\"args\\";a:1:{i:0;s:14:\\"system_modules\\";}}}messages|a:1:{s:6:\\"status\\";a:14:{i:0;s:9:\\"cid = \\"1\\"\\";i:1;s:441:\\"[Success] Send #2: <em>punaroor <pavanp@gmail.com>, mshell <michelle.petty@dyn-intl.com>, gavin25 & in /homepages/20/d176116070/htdocs/includes/database.mysql.inc on line 172

The emails are going out but no log entries or posts are being made.

metabits’s picture

metabits commented

Could it be because of having the database and drupal on different servers? Hosting in 1&1 is working like that (no way to change it unless having a dedicated server, and this won't happen to that website I manage)

Thanks!

psc

oadaeh’s picture

oadaeh commented

@psc, I doubt that would be the issue, otherwise you would have those messages all over the place and other database changes not being saved.

Just to double check,
@genemcc, are you on a setup where the database is on a different server?

oadaeh’s picture

oadaeh commented

No updates on this? Shall I close it?

genemcc’s picture

genemcc commented

Sorry. I haven't check in a while. Yes. But this only happens on one of the sites hosted there and not the other. Thanks!

oadaeh’s picture

oadaeh commented

I did a search on Google for this error and found two nodes on d.o that have possible solutions:
http://drupal.org/node/186384
http://drupal.org/node/163987

genemcc’s picture

genemcc commented

Thanks! I'll take a look.

g76’s picture

g76 commented

this worked for me. I am on a shared hosting account, no access to mysql settings(max_allowed_packet or timeout settings), but this seemed to fix it:

http://drupal.org/node/227445#comment-770663

also, disable syslog and database logging.

oadaeh’s picture

oadaeh commented
Status: Active » Closed (fixed)
oadaeh’s picture

oadaeh commented

Marked #1241588: Warning on Mass Contact as a duplicate.