Le 2013-12-01 18:50, Aurelien Bompard a écrit :
archiver.system_archiver.archive_message(msg,mlist)There's something wrong here, the archive_message() signature is mlist ast the first argument, and msg as the second. That's what's causing the traceback.
Ok, my mistake.
Now i have something normal (except the timestamp gap where i've inserted blank line: (venv_hk)nico@vostrodeb:~/wspace/mailman$ mailman withlist -r mlist.showArchiver newsletter@lists.menestrel.local newsletter - hyperkitty <mailman.model.mailinglist.ListArchiver object at 0x22e2ad0> [12:27:31.795920] EXECUTE: 'SELECT * FROM patch WHERE version=0', () [12:27:31.806851] DONE [12:27:31.807570] EXECUTE: 'SELECT patch.version FROM patch', () [12:27:31.808319] DONE [12:27:31.811304] EXECUTE: 'SELECT patch.version FROM patch', () [12:27:31.812192] DONE
[12:30:09.609158] EXECUTE: 'SELECT list.archive_policy, list.display_name, list.name, list.subject_prefix FROM list WHERE list.name = %s', (u'newsletter@lists.menestrel.local',) [12:30:09.617901] DONE [12:30:09.619191] EXECUTE: 'INSERT INTO list (archive_policy, subject_prefix, name, display_name) VALUES (%s, %s, %s, %s) RETURNING list.name', (<ArchivePolicy.public: 2>, u'[Newsletter] ', u'newsletter@lists.menestrel.local', u'Newsletter') [12:30:09.622524] DONE [12:30:09.623575] EXECUTE: 'SELECT COUNT(*) FROM email WHERE email.list_name = %s AND email.message_id = %s', (u'newsletter@lists.menestrel.local', u'ant') [12:30:09.630188] DONE Can't get the user from Mailman: HTTP Error 404: 404 Not Found [12:30:09.662961] EXECUTE: 'INSERT INTO thread (thread_id, list_name, date_active) VALUES (%s, %s, %s) RETURNING thread.list_name, thread.thread_id', (u'MS6QLWERIJLGCRF44J7USBFDELMNT2BW', u'newsletter@lists.menestrel.local', datetime.datetime(2013, 12, 1, 18, 30, 9, 630910)) [12:30:09.667042] DONE [12:30:09.667636] EXECUTE: 'INSERT INTO email (list_name, subject, archived_date, user_id, message_id, thread_depth, content, message_id_hash, thread_id, "date", sender_email, thread_order, in_reply_to, sender_name, timezone) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING email.list_name, email.message_id', (u'newsletter@lists.menestrel.local', u'Testing the test list', datetime.datetime(2013, 12, 1, 12, 30, 9, 618457), None, u'ant', 0, u'Tests are better than no tests\nbut the water deserves to be swum.\n', u'MS6QLWERIJLGCRF44J7USBFDELMNT2BW', u'MS6QLWERIJLGCRF44J7USBFDELMNT2BW', datetime.datetime(2013, 12, 1, 18, 30, 9, 630910), u'anne@example.com', 0, None, u'anne@example.com', 0) [12:30:09.675587] DONE [12:30:09.676383] EXECUTE: 'SELECT email.archived_date, email.content, email."date", email.in_reply_to, email.list_name, email.message_id, email.message_id_hash, email.sender_email, email.sender_name, email.subject, email.thread_depth, email.thread_id, email.thread_order, email.timezone, email.user_id FROM email WHERE email.list_name = %s AND email.thread_id = %s ORDER BY email."date"', (u'newsletter@lists.menestrel.local', u'MS6QLWERIJLGCRF44J7USBFDELMNT2BW') [12:30:09.678620] DONE [12:30:09.679593] EXECUTE: 'SELECT email.archived_date, email.content, email."date", email.in_reply_to, email.list_name, email.message_id, email.message_id_hash, email.sender_email, email.sender_name, email.subject, email.thread_depth, email.thread_id, email.thread_order, email.timezone, email.user_id FROM email WHERE email.list_name = %s AND email.thread_id = %s ORDER BY email.in_reply_to IS NOT NULL, email."date" LIMIT 1', (u'newsletter@lists.menestrel.local', u'MS6QLWERIJLGCRF44J7USBFDELMNT2BW') [12:30:09.680938] DONE [12:30:09.683727] EXECUTE: 'SELECT attachment.content, attachment.content_type, attachment.counter, attachment.encoding, attachment.list_name, attachment.message_id, attachment.name, attachment."size" FROM attachment WHERE attachment.list_name = %s AND attachment.message_id = %s ORDER BY attachment.counter', (u'newsletter@lists.menestrel.local', u'ant') [12:30:09.686151] DONE [12:30:09.698702] COMMIT xid=None
which is reproduced with ease The first order (shown in log too with the migration script) will never return a record, given the table : CREATE TABLE patch ( version integer NOT NULL, CONSTRAINT patch_pkey PRIMARY KEY (version ) ) WITH ( OIDS=FALSE );
and index starting at 1.
the upgrade script always outpust : (venv_hk)nico@vostrodeb:~/wspace$ kittystore-updatedb -p hyperkitty_standalone -s settings Upgrading the database schema and populating the search index if necessary... [19:57:07.588982] EXECUTE: 'SELECT * FROM patch WHERE version=0', () [19:57:07.591484] DONE [19:57:07.592248] EXECUTE: 'SELECT patch.version FROM patch', () [19:57:07.592814] DONE [19:57:07.595901] EXECUTE: 'SELECT patch.version FROM patch', () [19:57:07.596562] DONE
[19:59:46.123198] EXECUTE: 'SELECT patch.version FROM patch ORDER BY version DESC LIMIT 1', () [19:59:46.125043] DONE Done, the current schema version is 12. [19:59:46.125824] EXECUTE: 'SELECT COUNT(*) FROM (SELECT DISTINCT email.user_id FROM email) AS "_tmp"', () [19:59:46.129038] DONE [19:59:46.129416] EXECUTE: 'SELECT DISTINCT email.user_id FROM email', () [19:59:46.130346] DONE Updating user_id fields from Mailman, this can take some time... [19:59:46.130583] EXECUTE: 'SELECT COUNT(*) FROM email', () [19:59:46.131234] DONE [19:59:46.132320] EXECUTE: 'SELECT email.archived_date, email.content, email."date", email.in_reply_to, email.list_name, email.message_id, email.message_id_hash, email.sender_email, email.sender_name, email.subject, email.thread_depth, email.thread_id, email.thread_order, email.timezone, email.user_id FROM email', () [19:59:46.133438] DONE Can't get the user from Mailman: HTTP Error 404: 404 Not Found [19:59:46.159782] COMMIT xid=None ...done!
with the same time delay
definitely something wrong with db urgrade.
Cheers
Aurélien _______________________________________________ hyperkitty-devel mailing list hyperkitty-devel@lists.fedorahosted.org https://lists.fedorahosted.org/mailman/listinfo/hyperkitty-devel