FYI- Latest sending summary and error logs

 
From: "John Collins" <john@PROTECTED>
Date: December 9th 2008

Just FYI

The latest sending to over 18,000 went out in just under two hours That's an improvement It would have been a lot faster actually, but about a dozen times it stopped sending for as much as two minutes

When it stopped for over a minute, it would reload the message and under the progress bar a line of text would come up that said the message had stopped sending Most times it would reload the message several times, taking up to two minutes, before it would start again (a page comes up that only contains 'restarting the message'), and often on the 2nd or 3rd reload, it would kick out with a 500 server error I got about a dozen 500 server errors See below

I found that if I unclicked the 'refresh this screen every ten seconds box' on the progress bar page and just let it run without monitoring the sending, it did so with no server errors Once in a whlle I'd click it on again to see where I was and then click it off again

Below are the 500 server errors and a summary of the 664 errors in the error log I imagine that order is important, but it wasn't feasible to include the entire log here in this email so I simply included a count of each error I could send you a copy under separate cover if you wish

BTW- Dada 3 01 Pro (final)

Just FYI

The 500 server errors

Program Error (Server Error 500) More information about this error may be available in the server error log and/or program error log cannot do statement! (at: rawdb_hash) Lost connection to MySQL server during query at /DADA/Template/Widgets pm line 1218

Program Error (Server Error 500) More information about this error may be available in the server error log and/or program error log can't connect to db: at /DADA/App/Session pm line 37

====================== The error log contained a total of 664 errors Here's a summary

236 errors mail cgi: DBI connect('dbname=dadamaildb;host=localhost;port=3306','xxxuser', ) failed: Too many connections at /DADA/App/DBIHandle pm line 147

161 errors mail cgi: can't connect to db: at /DADA/App/Guts pm line 677

13 errors mail cgi: can't connect to db: at /DADA/App/Session pm line 37

15 errors mail cgi: can't connect to db: at /DADA/Mail/Send pm line 1084

11 error mail cgi: can't connect to db: at /DADA/MailingList/Settings/baseSQL pm line 64

19 errors mail cgi: Couldn't open, '// dada_files/ tmp/sendout-MNM-list-20081208121817 29363052_at_meetingsandmixers com/batchlock txt' because: No such file or directory at /DADA/Mail/MailOut pm line 587

69 errors mail cgi: Problems filling out the 'Sending Monitor' admin menu item with interesting bits of information about the mailouts: can't connect to db: at /DADA/Mail/Send pm line 1084

152 errors Reloading message at /DADA/Mail/MailOut pm line 1636

40 errors mail cgi: The file, '// dada_files/ tmp/sendout-MNM-list-20081208120303 09514284_at_meetingsandmixers com/last_access txt'does not exist to poll at /DADA/Mail/MailOut pm line 1555

6 errors mail cgi: Use of uninitialized value in numeric ne (!=) at /DADA/App/MassSend pm line 369

6 errors Widgets pm: Use of uninitialized value in substitution (s///) at (eval 11) line 23, line 1

4 errors baseSQL pm: Useless use of string eq in void context at //DADA/MailingList/Subscribers/baseSQL pm line 354, line 1

2 errors log_viewer cgi: Problems filling out the 'Sending Monitor' admin menu item with interesting bits of information about the mailouts: Couldn't open, '// dada_files/ tmp/sendout-MNM-list-20081208121817 29363052_at_meetingsandmixers com/batchlock txt' because: No such file or directory at //DADA/Mail/MailOut pm line 587

2 errors log_viewer cgi: Reloading message at //DADA/Mail/MailOut pm line 1636

1 error mail cgi: at /DADA/Template/Widgets pm line 1218

1 error mail cgi: [MNM] Mailout:"20081208120303 09514284_at_meetingsandmixers com attempting to send a mass mailing that doesn't exist anymore? Failed "still_around" test at /DADA/Mail/MailOut pm line 1500

1 error mail cgi: Attempt to reload a message which does not have a stalled process - check before attempting! at /var/www/cgi-bin/dada/mail cgi line 1157

6 errors Widgets pm: Use of uninitialized value in substitution (s///) at (eval 11) line 23, line 1

1 error mail cgi: Use of uninitialized value in string ne at /DADA/App/MassSend pm line 1286

1 error mail cgi: cannot do statement! (at: rawdb_hash) Lost connection to MySQL server during query

1 error mail cgi: Could not find mailout in the current queue?! at /DADA/Mail/MailOut pm line 2075

3 errors mail cgi: DBD driver has not implemented the AutoCommit attribute at /usr/local/perl-5 8 8/lib/site_perl/5 8 8/i686-linux/DBI pm line 678

1 error mail cgi: Raw Message that should be saved at: // dada_files/ tmp/sendout-MNM-list-20081208120921 95333323_at_meetingsandmixers com/raw_message txtisn't there at /DADA/Mail/MailOut pm line 1677

1 error mail cgi: DBD::mysql::st execute failed: Lost connection to MySQL server during query at /DADA/MailingList/Settings/baseSQL pm line 184

  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)
  • Start a new thread, email: dadadev@dadamailproject.com

This is the developer discussion mailing list for Dada Mail.

If you are just looking for support Dada Mail, consult the message boards at:

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Topics that are welcome:

  • Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.