Hi
I added a new table to slash (to allow emails to go to non-registered
users) and when the "daily" task ran last night it seemed to not see the
latest table contents. I'm using the mysql "rename table" command to
swap a new copy of the table in and rotate an old copy out, and it sent
the emails to the people in the "old" table. Is it possible that
renaming a table would allow an existing process (slashd) that had
already connected to the older copy of the table to not see it? (I can
imagine a sql client library caching table ids or query plans or
something like that, but I certainly wasn't expecting it.)
Can anyone confirm this kind of problem, or am I just losing my mind?
Thanks
Mark
|