Re: [Mailman-Developers] How can I reload mlist data from SA database
We must be sure that always_refresh=True don't break the lock. No good. Can't get lock at all. $ bin/withlist test Loading list [EMAIL PROTECTED] (unlocked) The variable 'm' is the test MailList instance m.Lock() m.Locked() False m.Save() Traceback (most recent call last): File console, line 1, in module File /usr/local/mailman/Mailman/MailList.py, line 576, in Save self.__lock.refresh() File /usr/local/mailman/Mailman/LockFile.py, line 187, in refresh raise NotLockedError('%s: %s' % (repr(self), self._read())) NotLockedError: LockFile 3078782956: /usr/local/mailman/locks/[EMAIL PROTECTED] [unlocked: 18000sec] pid=6644: None -- Tokio Kikuchi, [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi wrote: testing 2.2 code on my PC. What is curious about the LMTP/HTTP interfaces with SQLAlchemy based database is that changes commited in LMTP/HTTP sessions cannot be reflected on the other sessions. If I subscribe an address via HTTP then it cannot be unsubscribed from LMTP and vise versa, until I restart the runners. Perhaps we need a reload mechanism but I don't know how to implement it. I think I've noticed a similar problem. I think it has to do with concurrency between processes using SQLAlchemy. As you said, it seems like we need an explicit reload but I'm really hoping that that's just because we're not doing something right. I haven't had time to figure it out yet, or to contact the SA mailing list to get their feedback. We definitely need to address that issue before we get too far down the SA road. I've submitted a patch to address this problem on SF patch area because I'm not confident whether to check this in the svn. I hope you have time to review and write a better patch. Hi Tokio, I wonder if we shouldn't just be adding always_refresh=True to the mappers? I can't get to the SQLAlchemy site atm to provide a reference. - -Barry -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iQCVAwUBRgtR8nEjvBPtnXfVAQJjVAP7BnREssCZMUD4Hp1nCOF7t1EzP76YIbc2 X0Wju9HdiMfRM3TyLnWaKWVB2J4ItJJ1AB73hwY6DtgTf7Yyqp1icaXxhL1ZwKtg Wl0XWdzC/3rftcc6VA3yABEMRAVwT5w5eu/mdsOBLRw1B5+p81lB4LirWkLaKeKP ObnSn3ZoY9s= =N0nP -END PGP SIGNATURE- ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
Barry Warsaw wrote: Hi Tokio, I wonder if we shouldn't just be adding always_refresh=True to the mappers? I can't get to the SQLAlchemy site atm to provide a reference. I can't access the sqlalchemy site either now. But, I tested my code with two terminals using bin/withlist seeing if I can see a change in one in another. What is odd was that if I used only session.refresh() in Load(), the locks are broken. We must be sure that always_refresh=True don't break the lock. -- Tokio Kikucih, [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
Hi again, Barry Warsaw wrote: testing 2.2 code on my PC. What is curious about the LMTP/HTTP interfaces with SQLAlchemy based database is that changes commited in LMTP/HTTP sessions cannot be reflected on the other sessions. If I subscribe an address via HTTP then it cannot be unsubscribed from LMTP and vise versa, until I restart the runners. Perhaps we need a reload mechanism but I don't know how to implement it. I think I've noticed a similar problem. I think it has to do with concurrency between processes using SQLAlchemy. As you said, it seems like we need an explicit reload but I'm really hoping that that's just because we're not doing something right. I haven't had time to figure it out yet, or to contact the SA mailing list to get their feedback. We definitely need to address that issue before we get too far down the SA road. I've submitted a patch to address this problem on SF patch area because I'm not confident whether to check this in the svn. I hope you have time to review and write a better patch. Cheers, -- Tokio Kikuchi, [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi wrote: I've submitted a patch to address this problem on SF patch area because I'm not confident whether to check this in the svn. I hope you have time to review and write a better patch. Hi Tokio, Thanks... what's the patch #? - -Barry -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iQCVAwUBRgkbvXEjvBPtnXfVAQIRAwQAkRTNctv/r0DNdOD/Mzx2kXLihvpad/Pq MgkuG7exUPZtUYvsakvA2hNfZIHUAxAOdOfal9KzNFW+mgpCZ48/VEdJZgx2A/cy Rb0yACBAc2Y49+03OScOwDfb/wp7Y4KhtDvwqUWMeER7w2SFJ833DDPv8grci1Mj 9ijpDLnhL+s= =csH6 -END PGP SIGNATURE- ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
Barry Warsaw wrote: On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi wrote: I've submitted a patch to address this problem on SF patch area because I'm not confident whether to check this in the svn. I hope you have time to review and write a better patch. Hi Tokio, Thanks... what's the patch #? - -Barry http://sourceforge.net/tracker/index.php?func=detailaid=1688957group_id=103atid=300103 Cheers, -- Tokio Kikuchi, [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mar 3, 2007, at 1:13 AM, Tokio Kikuchi wrote: Hi Barry, Hi Tokio, Man, I don't know what happened but I just got /plastered/ with email this week. Between that and work, I haven't even touched the code. :/ Since we at Japanese universities are in Spring vacation, I started testing 2.2 code on my PC. What is curious about the LMTP/HTTP interfaces with SQLAlchemy based database is that changes commited in LMTP/HTTP sessions cannot be reflected on the other sessions. If I subscribe an address via HTTP then it cannot be unsubscribed from LMTP and vise versa, until I restart the runners. Perhaps we need a reload mechanism but I don't know how to implement it. I think I've noticed a similar problem. I think it has to do with concurrency between processes using SQLAlchemy. As you said, it seems like we need an explicit reload but I'm really hoping that that's just because we're not doing something right. I haven't had time to figure it out yet, or to contact the SA mailing list to get their feedback. We definitely need to address that issue before we get too far down the SA road. Other than that, I think I've checked with i18n plain text message deliveries for both regular and digest. Still to go are mime multipart messages and archives. I've also added a comment on Testing Mailman 2.2 wiki page how to test run the 2.2 code. Thanks, and I saw your recent patches. One thing we should be extra careful about is to include unit tests for anything we fix. I really want to improve our test suite so having test that cover the things you change are really important. I'm also trying to be very diligent about keeping the test suite working. Eventually I'd like to integrate our stuff with one of the Python community buildbots. Thanks, and I hope you haven't wasted your entire spring vacation waiting for me to respond! :) - -Barry -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iQCVAwUBRfHY+nEjvBPtnXfVAQK7GQP9FgHP8VkbuRQYcPSYmC7m8J3OPAsCEUe7 qdeYCdiJk9EIaOxzUJKWT6KrkRsBTs6Rj9LbPtyR9ZwP4xpW838eMakCoRGaFUCr veJY7J7zVtF26igcwytAJcb5LID/FRJpCIylJxHs9WQwLgJuypRyoqSRAOSgnwkQ FBFOWpPY1UA= =+UnM -END PGP SIGNATURE- ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
Re: [Mailman-Developers] How can I reload mlist data from SA database
Barry, Other than that, I think I've checked with i18n plain text message deliveries for both regular and digest. Still to go are mime multipart messages and archives. I've also added a comment on Testing Mailman 2.2 wiki page how to test run the 2.2 code. Thanks, and I saw your recent patches. One thing we should be extra careful about is to include unit tests for anything we fix. I really want to improve our test suite so having test that cover the things you change are really important. I'm also trying to be very diligent about keeping the test suite working. Eventually I'd like to integrate our stuff with one of the Python community buildbots. Ok, I will try to contribute test codes as well as the i18n fixes in the main codes. BTW, I realized I might have messed code and some tests fail. Do you want password scheme to be called by ENUM or TAG. I saw the default scheme in Defaults.py is string and changed to be called by TAG but it made test_passwords.py to fail. I think we can change the test code like so: class TestPBKDF2Passwords(TestPasswordsBase): scheme = 'pbkdf2' Thoughts? Thanks, and I hope you haven't wasted your entire spring vacation waiting for me to respond! :) Never mind. The new semester starts in April. :) -- Tokio Kikuchi [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp
[Mailman-Developers] How can I reload mlist data from SA database
Hi Barry, Since we at Japanese universities are in Spring vacation, I started testing 2.2 code on my PC. What is curious about the LMTP/HTTP interfaces with SQLAlchemy based database is that changes commited in LMTP/HTTP sessions cannot be reflected on the other sessions. If I subscribe an address via HTTP then it cannot be unsubscribed from LMTP and vise versa, until I restart the runners. Perhaps we need a reload mechanism but I don't know how to implement it. Other than that, I think I've checked with i18n plain text message deliveries for both regular and digest. Still to go are mime multipart messages and archives. I've also added a comment on Testing Mailman 2.2 wiki page how to test run the 2.2 code. Cheers, -- Tokio Kikuchi, [EMAIL PROTECTED] http://weather.is.kochi-u.ac.jp/ ___ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-developers%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showfile=faq01.027.htp