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, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----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. :/
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.
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-----

Barry,
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 tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

Hi again,
Barry Warsaw 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.
Cheers,
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi wrote:
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-----

Barry Warsaw wrote:
http://sourceforge.net/tracker/index.php?func=detail&aid=1688957&group_id=103&atid=300103
Cheers,
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi 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.
- -Barry
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin)
iQCVAwUBRgtR8nEjvBPtnXfVAQJjVAP7BnREssCZMUD4Hp1nCOF7t1EzP76YIbc2 X0Wju9HdiMfRM3TyLnWaKWVB2J4ItJJ1AB73hwY6DtgTf7Yyqp1icaXxhL1ZwKtg Wl0XWdzC/3rftcc6VA3yABEMRAVwT5w5eu/mdsOBLRw1B5+p81lB4LirWkLaKeKP ObnSn3ZoY9s= =N0nP -----END PGP SIGNATURE-----

Barry Warsaw wrote:
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, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

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 test@colinux.pc (unlocked) The variable 'm' is the test MailList instance pid=6644>: None
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----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. :/
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.
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-----

Barry,
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 tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

Hi again,
Barry Warsaw 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.
Cheers,
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi wrote:
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-----

Barry Warsaw wrote:
http://sourceforge.net/tracker/index.php?func=detail&aid=1688957&group_id=103&atid=300103
Cheers,
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Mar 27, 2007, at 4:22 AM, Tokio Kikuchi 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.
- -Barry
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin)
iQCVAwUBRgtR8nEjvBPtnXfVAQJjVAP7BnREssCZMUD4Hp1nCOF7t1EzP76YIbc2 X0Wju9HdiMfRM3TyLnWaKWVB2J4ItJJ1AB73hwY6DtgTf7Yyqp1icaXxhL1ZwKtg Wl0XWdzC/3rftcc6VA3yABEMRAVwT5w5eu/mdsOBLRw1B5+p81lB4LirWkLaKeKP ObnSn3ZoY9s= =N0nP -----END PGP SIGNATURE-----

Barry Warsaw wrote:
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, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/

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 test@colinux.pc (unlocked) The variable 'm' is the test MailList instance pid=6644>: None
-- Tokio Kikuchi, tkikuchi@is.kochi-u.ac.jp http://weather.is.kochi-u.ac.jp/
participants (2)
-
Barry Warsaw
-
Tokio Kikuchi