Re: Re[2]: Serious MySQL internal deadlock

2001-02-14 Thread Andreas Steinmetz
Milivojevic wrote: Andreas Steinmetz writes: Hi, just FYI: the deadlock problem is still in MySQL 3.23.33, the test I did send you behaves as in 3.23.32. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH Thank you for contacting me, as I was just now starting to search

Re: Re[2]: Serious MySQL internal deadlock

2001-02-07 Thread Andreas Steinmetz
y intended to be too human-readable. I was even thinking of using Unix secs since the epoch but than this isn't portable and doesn't help when looking for problems. On 07-Feb-2001 Sinisa Milivojevic wrote: Andreas Steinmetz writes: Hi, the inserts did not change the state after the select fi

Re: Re[2]: Serious MySQL internal deadlock

2001-02-06 Thread Andreas Steinmetz
opers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: Re[2]: Serious MySQL internal deadlock

2001-02-06 Thread Andreas Steinmetz
' and time='2001020423' and time'20010205231000'; On 06-Feb-2001 Sinisa Milivojevic wrote: Andreas Steinmetz writes: Hi, well, the query is over a network. Single switch with two VLANs between the systems, network speed is *200MBit/s*. The php code structure executing

Re: Re[2]: Serious MySQL internal deadlock

2001-02-05 Thread Andreas Steinmetz
] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH

Re: Serious MySQL internal deadlock

2001-02-02 Thread Andreas Steinmetz
that the database lock handling is corrupted. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH Id UserHostdb Command TimeState Info 226 logdaemon 10.1.1.6syslog Killed 64 System lock INSERT INTO pcp (time,host,c pu_user,cpu_nice,cpu_sys

Serious MySQL internal deadlock

2001-02-01 Thread Andreas Steinmetz
tion after a power outage or a system crash? Yes, I' using a ups but it can happen, that these things fail, causing a home made power outage. It wouldn't be too good if a non-standard shutdown of a slave would mean to restart replication from scratch. Andreas Steinmetz D.O.M. Datenverarbeitung

Re: Serious MySQL internal deadlock

2001-02-01 Thread Andreas Steinmetz
. If I can do anything to help to sort this out I'll happily do so. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Simple DoS scenario against mysql slaves

2001-01-19 Thread Andreas Steinmetz
edly cause a denial of service condition for the mysql slaves, as any valid user is allowed to use the 'set password' command to change his or her password. This is a real bad problem. Could somebody of the mysql team please look into this? Andreas Steinmetz D.O.M. Datenverarbe

instant slave crash (signal 11) on 'set password'

2001-01-17 Thread Andreas Steinmetz
of the two servers involved is for automatic failover in case of a system crash (proven working the hard way...). Thus a one way replication scheme is not useable in this case. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH