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 |
+---------------------------------------------------------------------+
