Hello, I have a table, say its stru is like:
domain ip noticed The column "noticed" is an enum value (eigher 0 or 1). When process one update "ip", it will set "noticed" to 0. Then process two know the status changed, it will do something and set "noticed" to 1. What the problem I meet is, when process two read ip from the table, and before it update the "noticed" to 1 (it has to do something with the ip, and this will take few seconds), process one also updated the table with new ip and noticed=0. Under this case, process two has gotten the outdated IPs (not the new ones updated by process one), since it will set noticed=1 finally so it doesn't have a chance to find it's using old IPs. So how to resolve this problem? Thanks for my newbie questions. Merry Holidays! Eva.
