List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 11 1999 8:05am
Subject:Table not updated when client disconnects from server...
View as plain text  
>>>>> "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.

Hi!

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)

Regards,
Monty
Thread
Table not updated when client disconnects from server...Pavel Nikiforov6 May
  • Table not updated when client disconnects from server...Jani Tolonen11 May
  • Table not updated when client disconnects from server...Michael Widenius11 May
    • Exclusive lock, MySQL/Perl HTTPDMailing Lists11 May
      • Re: Exclusive lock, MySQL/Perl HTTPDOrlando Andico11 May
        • Re: Exclusive lock, MySQL/Perl HTTPDFred Read12 May
      • Exclusive lock, MySQL/Perl HTTPDMichael Widenius11 May
        • Re: Exclusive lock, MySQL/Perl HTTPDMailing Lists11 May
          • Re: Exclusive lock, MySQL/Perl HTTPDRichard McLean12 May
          • Re: Exclusive lock, MySQL/Perl HTTPDRenaud Bruyeron12 May
        • Re: Exclusive lock, MySQL/Perl HTTPDFred Read12 May