I have a simple problem... I'm using mysql 4.1.9/innodb table and two small python applications A and B
first application A is executed, and do a simple INSERT into a table then application B is executed: - B does a SELECT in the same table, that should return the entry created by application A (and based on the result, an UPDATE (to the entry application A has created) or an INSERT if it can't find it... but in this scenario it should find it since B is always executed just after A is) I can be sure that application A is executed before application B is started, even though B can be started just after A is done. The problem is that every once in a while, the SELECT doesn't return anything... even though I can check that application A created the entry... Everything looks as if the INSERT from application A hasn't completed when the SELECT in the application B is performed... Even though application A terminated before application B started! Any clue about what's going on? How can I prevent that? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
