[Mailman-Developers] How can I reload mlist data from SA database

[Barry Warsaw]

-----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-----