List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 27 1999 11:04pm
Subject:syntax errors written to update.log
View as plain text  

I have now fixed in MySQL 3.22.28 and 3.23.8 that the standard mysql
client will not cause ;; in the update log anymore.


>>>>> "jdd" == jdd  <jdd@stripped> writes:

jdd> Using log-long-format and log-update, I've found it's possible for the
jdd> server to write characters to the updatelog that cannot be played back
jdd> into the server without causing a syntax error.  In particular my update 
jdd> log contained a single line consisting solely of the characters ;; which
jdd> caused the server to choke.

>> How-To-Repeat:
jdd> a) update foo set x=y
jdd> ;;
jdd> b) mysql -o -p database < update.log
>> Fix:

>> Submitter-Id:	<submitter ID>
>> Originator:	John David Duncan
>> Organization:
jdd> <Oregon Public Networking>
>> MySQL support: [none ]
>> Synopsis:	<mysqld writes ;;; to update.log >
>> Severity:	
>> Priority:	
>> Category:	mysql
>> Class:		
>> Release:	mysql-3.22.27 (Source distribution)
>> Server: /usr/local/mysql/bin/mysqladmin  Ver 7.11 Distrib 3.22.27, for
> pc-bsdi4.0.1 on i386
jdd> TCX Datakonsult AB, by Monty

jdd> Server version		3.22.27-log
jdd> Protocol version	10
jdd> Connection		Localhost via UNIX socket
jdd> UNIX socket		/tmp/mysql.sock
jdd> Uptime:			8 min 8 sec

jdd> Threads: 1  Questions: 258  Slow queries: 0  Opens: 39  Flush tables: 1  Open
> tables: 0
>> Environment:
jdd> System: BSD/OS 4.0.1 BSDI BSD/OS 4.0.1 Kernel #1: Tue Jul 20
> 14:47:55 PDT 1999     sgd@stripped:/usr/src/sys/compile/RABBIT  i386

jdd> Some paths:  /usr/ucb//perl /usr/ucb//make /usr/contrib/bin/gmake /usr/ucb//gcc
> /usr/ucb//cc
jdd> GCC: gcc version
jdd> Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
jdd> Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock
> --with-low-memory --with-mit-threads=yes
jdd> Perl: This is perl, version 4.0

jdd> ---------------------------------------------------------------------
jdd> Please check "" before
jdd> posting. To request this thread, e-mail mysql-thread20478@stripped

jdd> To unsubscribe, send a message to the address shown in the
jdd> List-Unsubscribe header of this message. If you cannot see it,
jdd> e-mail mysql-unsubscribe@stripped instead.
syntax errors written to update.logjdd7 Dec
  • syntax errors written to update.logMichael Widenius28 Dec