>>>>> "Pavel" == Pavel Nikiforov <pavel@stripped> writes:
Pavel> ? May be bug in Mysql 3.22.22 (linux).
Pavel> Sometimes Mysql server lose updates of the table when client disconnect
Pavel> from server. It looks like this:
Pavel> some C program updates one field in records like this: "update table set
Pavel> value=%newvelue% where value_id=%id%" (%newvalue% and %id% are numbers,
Pavel> and %id% does not change all time program works). When program work all
Pavel> data updated, and I can see it using mysqlshow. But when client
Pavel> disconnect from server (mysql_close() called) all updates are lost, and
Pavel> in table there is an old value (before all updates). "mysqladmin
Pavel> flush-tables", mysql_refresh() does not helps.
Could you provide a test program of this?
MySQL should NOT loose any updates, if a client disconnects AFTER
it has sent a query to the server.
Try running mysqld with --log --log-update and check the logs that the
client really has sent the request to the server!
Note that you are require to do 'mysql_result' or 'mysql_store_result'
before calling 'mysql_close' (even if mysql_close() should be able to
handle this case)