List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 11 1999 1:47pm
Subject:Table not updated when client disconnects from server...
View as plain text  
Pavel Nikiforov writes:
 > ? May be bug in Mysql 3.22.22 (linux). 
 > 
 > Sometimes Mysql server lose updates of the table when client disconnect
 > from server. It looks like this:
 > some C program updates one field in records like this: "update table set
 > value=%newvelue% where value_id=%id%" (%newvalue% and %id% are numbers,
 > and %id% does not change all time program works). When program work all
 > data updated, and I can see it using mysqlshow. But when client
 > disconnect from server (mysql_close() called) all updates are lost, and
 > in table there is an old value (before all updates). "mysqladmin
 > flush-tables", mysql_refresh() does not helps.
 > 

Hi!

Can you reproduce this?

If possible, we would need to have the C -program that
does the updates and a complete example of this problem,
reproduced with as small amount of data as possible.

Please read the section 'How to report bugs or problems'
from the manual, it should be very helpful.

Yours,

- Jani

-- 
+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___       ==  mysql@stripped         |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|       Jani Tolonen             |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|       mailto: jani@stripped      |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|       Helsinki                 |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____  Finland                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+
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