Scott, There were 257 commands related to the table before the error. They all look the same. Below are the last two (256th and 257th), followed by the one that caused the read-only error.
LOAD DATA LOCAL INFILE 'f:\\Staging\\infiles1\\4539_1140709500_1140709923.in_process-1ccede-0' INTO TABLE `AB4539p2` FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (ID,TimeStamp,In,Out); LOAD DATA LOCAL INFILE 'f:\\Staging\\infiles1\\4539_1140712200_1140713975.in_process-1cebd5-0' INTO TABLE `AB4539p2` FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (ID,TimeStamp,In,Out); LOAD DATA LOCAL INFILE 'f:\\Staging\\infiles1\\4539_1140714000_1140714722.in_process-1d187c-0' INTO TABLE `AB4539p2` FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (ID,TimeStamp,In,Out); If I had to guess what happened, I'd say the database put a lock on the table during the 257th LOAD DATA, and then didn't release it by the time the 258th command was executed. Eric -----Original Message----- From: Scott Tanner [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 9:38 AM To: Goldblatt, Eric Cc: Mysql User List Subject: Re: replication after editing bin logs Can you post the failed SQL statement from your altered bin log, and maybe the preceding commands related to that table? Scott Tanner AMi Entertainment.net On Thu, 2006-03-09 at 08:28, Goldblatt, Eric wrote: > Scott, > > The table already existed before the binlog. The strange thing is that > there were inserts into this table earlier in the binlog, and they did > not produce any error messages. > > > Eric > -----Original Message----- > From: Scott Tanner [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 08, 2006 3:46 PM > To: Goldblatt, Eric > Subject: Re: replication after editing bin logs > > On Wed, 2006-03-08 at 14:51, Goldblatt, Eric wrote: > snip- > > When I came to step 5, I submitted the SQL text file as a batch job: > > > > mysql -u root -p -e "source binlogs_045_052_parsed" > > > > After many hours I received the following error message: > > > > ERROR 1036 (HY000) at line 1387471 in file: 'binlogs_045_052_parsed': > > Table 'AB4539p2' is read only > > > > At this point, the mysql batch job terminated. > > If its saying the table is read only, it could be a simple > permissions issue. Is this table being created from the binlog, or is > it an existing table? > > > Regards, > > Scott Tanner > AMi Entertainment -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
