4.0.15 replication failure ('Event too big')
Hello, I am having replication troubles with 4.0.15. Some info: mysql show slave status; | www.x.com | replicon| 3306| 60| ns1-bin.001 | 16958428| linux-relay-bin.011 | 623915| ns1-bin.001 | Yes | No| | | 0 | Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. | 0| 8147397 | 9437494 The server bin log is fine. The slave bin log gives the error: # mysqlbinlog linux-relay-bin.011 m ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len: 1701345056, event_type: 61 ERROR: Could not read entry at offset 622931 : Error in log format or read error Some google searches show this was noticed in 4.0.5 as well. I'm not specifying max_binlog_size on the master or server. I am not specifying max_allowed_packet on the master. I have not set max_packet_size either. I note that my bin logs are only 9MB on the slave. I'm currently upgrading to 4.0.18 but unless I missed it I don't see this fixed in the changelogs. Anyone have any recommendations on how to ensure this doesn't happen again? Thanks! -- VoIP SIP:[EMAIL PROTECTED] Free calendar client and server - works with Exchange/Outlook Now with TV-Listing Schedules for 13 countries! http://www.ScheduleWorld.com/ http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp (JWS) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[q] can I start MySQL in READONLY mode?
Hello, I have a situation where I'd like to do some debugging against a MySQL database that's setup so I couldn't modify it (select only). I did some google searching and searched mysql.com but didn't find much on readonly. Is this possible? I already know I can just backup/restore the datafiles as many times as I need to - I was just hoping for a flag or startup option or something. Thanks. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web start (JNLP): http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [q] can I start MySQL in READONLY mode?
Matt, Peter - thanks guys!! -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web start (JNLP): http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0.9 grant replication slave ... fails.
I'm using 4.0.9 and I can not grant replication slave. [EMAIL PROTECTED] root]# rpm -qf /usr/bin/mysql MySQL-client-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysql mysqld mysqld-max [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld-max MySQL-Max-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld MySQL-4.0.9-0 mysql grant replication slave on *.*to [EMAIL PROTECTED] identified by 'replicon01'; mysql show grants for [EMAIL PROTECTED]; +--+ | Grants for [EMAIL PROTECTED] | +--+ | GRANT USAGE ON *.* TO 'test01'@'a.com' IDENTIFIED BY PASSWORD '65907ecf00036cf9' | +--+ 1 row in set (0.00 sec) I have 2 other 4.0.9 machines where this works perfectly. I'm worried one of my machines didn't fully upgrade to 4.0.9. Suggestions? Thank you. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web Start: http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.9 grant replication slave ... fails.
OK. I solved it. In a last ditch effort I tried the /usr/bin/mysql_fix_privilege_tables script. That fixed it up. Replication seems to be working fine. Cheers. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web Start: http://www.ScheduleWorld.com/sw/ScheduleWorld.jnlp - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php