-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
my replication slave crashed. Now, I am unable to restart with following
error message:
081021 21:34:21 [Note] Slave SQL thread initialized, starting
replication in log 'log.000129' at position 28457291, relay log
'/video/mysql/mysqld-relay-bin.000331' position: 10541803
081021 21:34:21 [ERROR] Slave: Query caused different errors on master
and slave. Error on master: 'Table '%-.64s' already exists' (1050),
Error on slave: 'You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1' (1064). Default database: 'firewall'. Query:
'CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY INVOKER VIEW
`drops_udp` AS ', Error_code: 0
081021 21:34:21 [ERROR] Error running query, slave SQL thread aborted.
Fix the problem, and restart the slave SQL thread with "SLAVE START". We
stopped at log 'log.000129' position 28457291
Does the master or the slave have an error? What do I have to do to fix
this issue?
Thanks,
Uwe
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQIcBAEBAgAGBQJI/i9vAAoJEEJXG7BUuynnhd4P/39swMU29YkQ0h8xsarH5GPu
dYWFsIp0weR4E2VBvuc4HfA1pGLttnpw02Ru2MQkeA4OhT5V7naZhPxj0p0tjI5S
WCsUf+CcW1lSqAuhmDAvGO7T/Cv+cCnzDqhj+mQKwrPJwRSj3ZomdicXM3C1mPL6
d2w6F8q4ez2ntaeiSIc53l9t0n8aIkExmGRyJztGaPqOiLF19K3kJ3U9VD2lD4FQ
yZtcmWLCSapiS+HvsjueAVe3VxDKFqzYKCZjD30yhTeGWtdDt2COHj35BeUkK98y
mxPQAu6fymLB2C35Ry68QpTeKGkKUxGElsHt2JxOKHYVWnnbpS6YnxVk0n42vImv
bg6wUkAj2jFbJyfFuMNWm4oEIUZb5uzTNAnBJp60RpE6kTfkOM51PhakPfPzcaKZ
IFmI2nhuplGnhPzbAT4Oxj1Y8OQqswgQUqqFJnyEZbiT8pFA4Gk6mkksrLr7TtJF
GG02sdtLT2wAMfW/8txN90seZeB8l6KQc+hPcn/Q5WwP7cunsUQkzcL4XtikCtzs
H5B/RZGPt7dxQvmDFKhYSGGSB86+JoTScvIggYkeDpugKClR/M6+sn8n4Sxd+uMT
sxwJoTlx2dr6GkO/6qbCjfS6yCKaVGdvOWKKjoABoLPpnmOUdaYKuIOrLnmj7vTl
jXNJA46FFmRn0zElV/Ea
=N9cq
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
