getting errors all over the place

[unixguy]

I can no longer send mailings, here are the logs modified in the time range where I can trying to send:

[root@cmcwemm001 log]# tail -10 20100601-cmcwemm001-bav-update.log
[01.06.2010 13:47:04] 19212 ERROR/data: Unable to get database cursor
[01.06.2010 13:47:04] 19212 ERROR/data: Update failed: readDatabase.cursor
[01.06.2010 13:50:04] 19212 ERROR/data: Unable to get database cursor
[01.06.2010 13:50:04] 19212 ERROR/data: Update failed: readDatabase.cursor
[01.06.2010 13:53:04] 19212 ERROR/data: Unable to get database cursor
[01.06.2010 13:53:04] 19212 ERROR/data: Update failed: readDatabase.cursor
[01.06.2010 13:56:04] 19212 ERROR/data: Unable to get database cursor
[01.06.2010 13:56:04] 19212 ERROR/data: Update failed: readDatabase.cursor
[01.06.2010 13:59:04] 19212 ERROR/data: Unable to get database cursor
[01.06.2010 13:59:04] 19212 ERROR/data: Update failed: readDatabase.cursor

[root@cmcwemm001 log]# tail -10 20100601-cmcwemm001-mailgun.log
[01.06.2010 10:33:26] WARNING/billing/(1/10/28/28): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist
[01.06.2010 10:41:18] WARNING/billing/(1/7/29/29): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist
[01.06.2010 12:45:12] WARNING/billing/(1/7/30/30): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist
[01.06.2010 13:49:30] WARNING/billing/(1/12/32/31): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist
[01.06.2010 13:59:15] WARNING/billing/(1/13/33/32): Unable to insert record into world_mailing_backend_log_tbl: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openemm.world_mailing_backend_log_tbl' doesn't exist

[root@cmcwemm001 log]# tail -10 20100601-cmcwemm001-pickdist.log
[01.06.2010 13:56:28] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:56:59] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:57:30] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:58:01] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:58:32] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:59:03] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 13:59:34] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 14:00:05] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 14:00:36] 19376 ERROR/scan: Unable to get database cursor
[01.06.2010 14:01:07] 19376 ERROR/scan: Unable to get database cursor

[root@cmcwemm001 log]# tail -10 20100601-cmcwemm001-update.log
[01.06.2010 13:57:04] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 13:57:34] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 13:58:04] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 13:58:34] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 13:59:04] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 13:59:34] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 14:00:04] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 14:00:34] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 14:01:04] 19347 ERROR/loop: Unable to get database cursor
[01.06.2010 14:01:34] 19347 ERROR/loop: Unable to get database cursor


[root@cmcwemm001 home]# find . -mmin -10
./openemm/var/log/20100601-cmcwemm001-mailgun.log
./openemm/var/log/20100601-cmcwemm001-bav-update.log
./openemm/var/log/20100601-cmcwemm001-update.log
./openemm/var/log/20100601-cmcwemm001-pickdist.log
./openemm/var/spool/META
./openemm/var/spool/META/AgnMail=D20100601135915=1=33=001=liaMngA.xml.gz
./openemm/var/spool/META/AgnMail=D20100601135915=1=33=001=liaMngA.stamp
./openemm/var/spool/META/AgnMail=D20100601135915=1=33=001=liaMngA.final
./openemm/var/run/slrtscan.save
./openemm/webapps/core/log/openemm.log
./openemm/webapps/core/log/openemm_stderr.log
./openemm/webapps/core/log/openemm_stdout.log
./openemm/webapps/core/log/openemm_access.log


any help is appreciated

[unixguy]

one more tidbit:

[01.06.2010 11:56:04] 19212 ERROR/data: We relay domain "cmcwemm001.blahone.com" without catching it in mailertable
[01.06.2010 11:56:04] 19212 ERROR/data: We define domain "smtp.blahtwo.com" in mailertable, but do not relay it

note, blahone and blahtwo are not the same

[unixguy]

We standardized the MySQL installation, and in the process moved the unix socket file. Not sure if the socket location is tunable in OpenEMM, but it certainly does not work when it cannot find it.

Not sure why OpenEMM backend does not use the TCP/IP stack and localhost instead of the socket.

[unhuman]

Could you please give a little more detail with what you fixed and how you fixed it? Having (probably) the same problem.

"Unable to get database cursor"

Thanks - H

[unhuman]

So, I identified my problem here...

I was using xampp for my database stack. It conflicted with the default mysql configuration assumed by the system.

And, I got it working.

To debug this I linked /etc/my.cnf to the one in xampp
I also had to link /var/lib/mysql/mysql.sock to the specified by xampp.

Oddly, this only affected the scripts portion of OpenEMM, but the Java side worked fine.

More logging around exceptions in the scripts would be nice...