Page 1 of 1

pickdist error problem

Posted: Fri Oct 13, 2006 10:46 pm
by Ronin
Everything works great up until I try to send a mailing. Then one message goes out to the list and the process hangs. In the pickdist.log file I see:

[13.10.2006 16:32:38] 12003 VERBOSE/loop: No ready to send data file found
[13.10.2006 16:33:09] 12003 VERBOSE/loop: No ready to send data file found
[13.10.2006 16:33:40] 12003 VERBOSE/loop: No ready to send data file found
[13.10.2006 16:34:11] 12003 INFO/block: Unpacking /home/openemm/var/spool/META/AgnMail=D20061013163354=1=8=001=liaMngA.xml.gz
[13.10.2006 16:34:11] 12003 VERBOSE/block: Removing stamp file /home/openemm/var/spool/META/AgnMail=D20061013163354=1=8=001=liaMngA.stamp
[13.10.2006 16:34:11] 12003 DEBUG/block: Calling xmlback '-vlogenerate:media=email;path=/home/openemm/var/spool/QUEUE' '/home/openemm/var/spool/META/AgnMail=D20061013163354=1=8=001=liaMngA.xml.gz'
[13.10.2006 16:34:11] 12003 FATAL/except: CAUGHT EXCEPTION:
Traceback (most recent call last):
File "/home/openemm/bin/scripts/pickdist.py", line 192, in ?
block.moveTo (agn.mkArchiveDirectory (pd.archive))
File "/home/openemm/bin/scripts/pickdist.py", line 81, in moveTo
shutil.move (self.path, dest)
AttributeError: 'module' object has no attribute 'move'

If I kill the pickdist.sh script and restart it, another message goes and it hangs again.

Any help?

Posted: Wed Oct 18, 2006 12:11 pm
by ud
Looks like your python version does not support the shutil.move method. Can you please tell us your python version? (Just start python without argument, then you will enter the interactive mode which prints the current version.)

-- ud

Posted: Wed Oct 18, 2006 2:31 pm
by Ronin
python 2.2.3-6.3

Posted: Wed Oct 18, 2006 3:11 pm
by ud
You should upgrade to version 2.4.x or higher.

-- ud

Posted: Wed Oct 18, 2006 7:40 pm
by Ronin
Updated to Python 2.5, rebooted, restarted OpenEMM and now I get:

[18.10.2006 10:57:50] 13671 VERBOSE/loop: No ready to send data file found
[18.10.2006 10:58:21] 13671 VERBOSE/loop: No ready to send data file found
[18.10.2006 10:58:52] 13671 VERBOSE/loop: No ready to send data file found
[18.10.2006 10:59:23] 13671 FATAL/except: CAUGHT EXCEPTION:
Traceback (most recent call last):
File "/home/openemm/bin/scripts/pickdist.py", line 179, in <module>
if pd.scanForData () == 0:
File "/home/openemm/bin/scripts/pickdist.py", line 108, in scanForData
db = agn.DBase ()
AttributeError: 'module' object has no attribute 'DBase'

in pickdist.log

Posted: Thu Oct 19, 2006 1:16 am
by sfantul
did u installed python-mysql module?

Posted: Thu Oct 19, 2006 3:47 pm
by Ronin
Did a reinstall of the python-MySQL module, rebooted, restarted OpenEMM and get:

[19.10.2006 09:29:34] 10992 VERBOSE/loop: No ready to send data file found
[19.10.2006 09:30:05] 10992 VERBOSE/loop: No ready to send data file found
[19.10.2006 09:30:36] 10992 VERBOSE/loop: No ready to send data file found
[19.10.2006 09:31:07] 10992 VERBOSE/loop: No ready to send data file found
[19.10.2006 09:31:38] 10992 FATAL/except: CAUGHT EXCEPTION:
Traceback (most recent call last):
File "/home/openemm/bin/scripts/pickdist.py", line 179, in <module>
if pd.scanForData () == 0:
File "/home/openemm/bin/scripts/pickdist.py", line 123, in scanForData
r = inst.simpleQuery ('SELECT deleted FROM mailing_tbl WHERE mailing_id = %d' % block.mailingID)
File "/home/openemm/bin/scripts/agn.py", line 1204, in simpleQuery
for rec in self.query (req, parm):
File "/home/openemm/bin/scripts/agn.py", line 1181, in query
self.curs.execute (req)
File "/usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py", line 146, in execute
query = query.encode(charset)
LookupError: unknown encoding: latin1_swedish_ci

in pickdist.log when I try to send a mailing

To sfantul and ud

Posted: Fri Oct 20, 2006 8:56 pm
by Ronin
Appreciate your help guys, but...
Got tired of messing with it (was trying to get it moving on RHEL3) so I started from scratch with CentOS 4.4 and it works smooth as butter.
Great product!