log_event.cc 128 KB
Newer Older
monty@mysql.com's avatar
monty@mysql.com committed
1
/* Copyright (C) 2000-2004 MySQL AB
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
   
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
   
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
   
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */


#ifndef MYSQL_CLIENT
#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif
#include  "mysql_priv.h"
23
#include "slave.h"
24
#include "table_filter.h"
25
#include <my_dir.h>
26
extern Table_filter *rpl_filter;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
27 28
#endif /* MYSQL_CLIENT */

29
#define log_cs	&my_charset_latin1
30

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
31
/*
32
  pretty_print_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
33
*/
34

35
#ifdef MYSQL_CLIENT
36
static void pretty_print_str(FILE* file, char* str, int len)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
37
{
38
  char* end = str + len;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
39
  fputc('\'', file);
40 41
  while (str < end)
  {
42
    char c;
43 44 45 46 47 48 49 50 51 52 53 54
    switch ((c=*str++)) {
    case '\n': fprintf(file, "\\n"); break;
    case '\r': fprintf(file, "\\r"); break;
    case '\\': fprintf(file, "\\\\"); break;
    case '\b': fprintf(file, "\\b"); break;
    case '\t': fprintf(file, "\\t"); break;
    case '\'': fprintf(file, "\\'"); break;
    case 0   : fprintf(file, "\\0"); break;
    default:
      fputc(c, file);
      break;
    }
55 56
  }
  fputc('\'', file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
57
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
58
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
59

60

monty@mysql.com's avatar
monty@mysql.com committed
61
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
62

63 64 65 66 67 68 69 70
static void clear_all_errors(THD *thd, struct st_relay_log_info *rli)
{
  thd->query_error = 0;
  thd->clear_error();
  *rli->last_slave_error = 0;
  rli->last_slave_errno = 0;
}

monty@mysql.com's avatar
monty@mysql.com committed
71

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
72
/*
monty@mysql.com's avatar
monty@mysql.com committed
73
  Ignore error code specified on command line
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
74
*/
75

76 77
inline int ignored_error_code(int err_code)
{
guilhem@mysql.com's avatar
guilhem@mysql.com committed
78 79
  return ((err_code == ER_SLAVE_IGNORED_TABLE) ||
          (use_slave_mask && bitmap_is_set(&slave_error_mask, err_code)));
80
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
81
#endif
82

83

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
84
/*
85
  pretty_print_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
86
*/
87

88
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
89
static char *pretty_print_str(char *packet, char *str, int len)
90
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
91 92
  char *end= str + len;
  char *pos= packet;
93
  *pos++= '\'';
94 95 96
  while (str < end)
  {
    char c;
97
    switch ((c=*str++)) {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
98 99 100 101 102 103 104
    case '\n': *pos++= '\\'; *pos++= 'n'; break;
    case '\r': *pos++= '\\'; *pos++= 'r'; break;
    case '\\': *pos++= '\\'; *pos++= '\\'; break;
    case '\b': *pos++= '\\'; *pos++= 'b'; break;
    case '\t': *pos++= '\\'; *pos++= 't'; break;
    case '\'': *pos++= '\\'; *pos++= '\''; break;
    case 0   : *pos++= '\\'; *pos++= '0'; break;
105
    default:
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
106
      *pos++= c;
107 108
      break;
    }
109
  }
110 111
  *pos++= '\'';
  return pos;
112
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
113
#endif /* !MYSQL_CLIENT */
114

115

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
116
/*
117
  slave_load_file_stem()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
118
*/
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
119

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
120
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
121 122 123
static inline char* slave_load_file_stem(char*buf, uint file_id,
					 int event_server_id)
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
124
  fn_format(buf,"SQL_LOAD-",slave_load_tmpdir, "", MY_UNPACK_FILENAME);
125 126 127 128 129 130 131
  buf = strend(buf);
  buf = int10_to_str(::server_id, buf, 10);
  *buf++ = '-';
  buf = int10_to_str(event_server_id, buf, 10);
  *buf++ = '-';
  return int10_to_str(file_id, buf, 10);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
132
#endif
133

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
134

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
135
/*
136 137
  Delete all temporary files used for SQL_LOAD.

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
138 139
  SYNOPSIS
    cleanup_load_tmpdir()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
140
*/
141

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
142
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
143 144 145 146 147
static void cleanup_load_tmpdir()
{
  MY_DIR *dirp;
  FILEINFO *file;
  uint i;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
148
  char fname[FN_REFLEN], prefbuf[31], *p;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
149

150 151 152
  if (!(dirp=my_dir(slave_load_tmpdir,MYF(MY_WME))))
    return;

153 154 155 156 157 158 159 160 161 162 163 164 165
  /* 
     When we are deleting temporary files, we should only remove
     the files associated with the server id of our server.
     We don't use event_server_id here because since we've disabled
     direct binlogging of Create_file/Append_file/Exec_load events
     we cannot meet Start_log event in the middle of events from one 
     LOAD DATA.
  */
  p= strmake(prefbuf,"SQL_LOAD-",9);
  p= int10_to_str(::server_id, p, 10);
  *(p++)= '-';
  *p= 0;

166 167 168
  for (i=0 ; i < (uint)dirp->number_off_files; i++)
  {
    file=dirp->dir_entry+i;
169
    if (is_prefix(file->name, prefbuf))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
170 171 172 173
    {
      fn_format(fname,file->name,slave_load_tmpdir,"",MY_UNPACK_FILENAME);
      my_delete(fname, MYF(0));
    }
174 175 176 177
  }

  my_dirend(dirp);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
178
#endif
179 180


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
181
/*
182
  write_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
183
*/
184

185
static bool write_str(IO_CACHE *file, char *str, uint length)
186
{
187 188 189 190
  byte tmp[1];
  tmp[0]= (byte) length;
  return (my_b_safe_write(file, tmp, sizeof(tmp)) ||
	  my_b_safe_write(file, (byte*) str, length));
191 192 193
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
194
/*
195
  read_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
196
*/
197

198 199
static inline int read_str(char **buf, char *buf_end, char **str,
			   uint8 *len)
200
{
201
  if (*buf + ((uint) (uchar) **buf) >= buf_end)
202
    return 1;
203 204 205
  *len= (uint8) **buf;
  *str= (*buf)+1;
  (*buf)+= (uint) *len+1;
206 207 208
  return 0;
}

209

210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232
/*
  Transforms a string into "" or its expression in 0x... form.
*/
static char *str_to_hex(char *to, char *from, uint len)
{
  char *p= to;
  if (len)
  {
    p= strmov(p, "0x");
    for (uint i= 0; i < len; i++, p+= 2)
    {
      /* val[i] is char. Casting to uchar helps greatly if val[i] < 0 */
      uint tmp= (uint) (uchar) from[i];
      p[0]= _dig_vec_upper[tmp >> 4];
      p[1]= _dig_vec_upper[tmp & 15];
    }
    *p= 0;
  }
  else
    p= strmov(p, "\"\"");
  return p; // pointer to end 0 of 'to'
}

233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248
/*
  Prints a "session_var=value" string. Used by mysqlbinlog to print some SET
  commands just before it prints a query.
*/

static void print_set_option(FILE* file, uint32 bits_changed, uint32 option,
                             uint32 flags, const char* name, bool* need_comma) 
{
  if (bits_changed & option)
  {
    if (*need_comma)
      fprintf(file,", ");
    fprintf(file,"%s=%d", name, (bool)(flags & option));
    *need_comma= 1;
  }
}
249

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
250
/**************************************************************************
251
	Log_event methods (= the parent class of all events)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
252
**************************************************************************/
253

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
254
/*
255
  Log_event::get_type_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
256
*/
257

258 259
const char* Log_event::get_type_str()
{
260
  switch(get_type_code()) {
261
  case START_EVENT_V3:  return "Start_v3";
262 263 264 265 266
  case STOP_EVENT:   return "Stop";
  case QUERY_EVENT:  return "Query";
  case ROTATE_EVENT: return "Rotate";
  case INTVAR_EVENT: return "Intvar";
  case LOAD_EVENT:   return "Load";
267
  case NEW_LOAD_EVENT:   return "New_load";
268
  case SLAVE_EVENT:  return "Slave";
269 270 271 272
  case CREATE_FILE_EVENT: return "Create_file";
  case APPEND_BLOCK_EVENT: return "Append_block";
  case DELETE_FILE_EVENT: return "Delete_file";
  case EXEC_LOAD_EVENT: return "Exec_load";
273
  case RAND_EVENT: return "RAND";
274
  case USER_VAR_EVENT: return "User var";
275
  case FORMAT_DESCRIPTION_EVENT: return "Format_desc";
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
276
  default: return "Unknown";				/* impossible */ 
277 278 279
  }
}

280

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
281
/*
282
  Log_event::Log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
283
*/
284

285
#ifndef MYSQL_CLIENT
286
Log_event::Log_event(THD* thd_arg, uint16 flags_arg, bool using_trans)
287
  :log_pos(0), temp_buf(0), exec_time(0), flags(flags_arg), thd(thd_arg)
288
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
289 290 291 292
  server_id=	thd->server_id;
  when=		thd->start_time;
  cache_stmt=	(using_trans &&
		 (thd->options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN)));
293 294 295
}


monty@mysql.com's avatar
monty@mysql.com committed
296 297 298 299 300 301 302
/*
  This minimal constructor is for when you are not even sure that there is a
  valid THD. For example in the server when we are shutting down or flushing
  logs after receiving a SIGHUP (then we must write a Rotate to the binlog but
  we have no THD, so we need this minimal constructor).
*/

303
Log_event::Log_event()
304
  :temp_buf(0), exec_time(0), flags(0), cache_stmt(0),
305 306
   thd(0)
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
307 308 309
  server_id=	::server_id;
  when=		time(NULL);
  log_pos=	0;
310
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
311
#endif /* !MYSQL_CLIENT */
312 313


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
314
/*
315
  Log_event::Log_event()
316
*/
317

318 319 320
Log_event::Log_event(const char* buf,
                     const Format_description_log_event* description_event) 
  :temp_buf(0), cache_stmt(0)
321
{
322 323 324
#ifndef MYSQL_CLIENT
  thd = 0;
#endif  
325 326
  when = uint4korr(buf);
  server_id = uint4korr(buf + SERVER_ID_OFFSET);
327
  if (description_event->binlog_version==1)
328
  {
329 330 331
    log_pos= 0;
    flags= 0;
    return;
332
  }
333 334 335 336 337 338 339 340 341 342 343 344 345 346
  /* 4.0 or newer */
  log_pos= uint4korr(buf + LOG_POS_OFFSET);
  /*
    If the log is 4.0 (so here it can only be a 4.0 relay log read by the SQL
    thread or a 4.0 master binlog read by the I/O thread), log_pos is the
    beginning of the event: we transform it into the end of the event, which is
    more useful.
    But how do you know that the log is 4.0: you know it if description_event
    is version 3 *and* you are not reading a Format_desc (remember that
    mysqlbinlog starts by assuming that 5.0 logs are in 4.0 format, until it
    finds a Format_desc).
  */
  if (description_event->binlog_version==3 &&
      buf[EVENT_TYPE_OFFSET]<FORMAT_DESCRIPTION_EVENT && log_pos)
347
  {
348 349 350 351 352 353 354 355 356 357 358 359
      /*
        If log_pos=0, don't change it. log_pos==0 is a marker to mean
        "don't change rli->group_master_log_pos" (see
        inc_group_relay_log_pos()). As it is unreal log_pos, adding the event
        len's is nonsense. For example, a fake Rotate event should 
        not have its log_pos (which is 0) changed or it will modify
        Exec_master_log_pos in SHOW SLAVE STATUS, displaying a nonsense value
        of (a non-zero offset which does not exist in the master's binlog, so
        which will cause problems if the user uses this value in
        CHANGE MASTER).
      */
    log_pos+= uint4korr(buf + EVENT_LEN_OFFSET);
360
  }
361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

  flags= uint2korr(buf + FLAGS_OFFSET);
  if ((buf[EVENT_TYPE_OFFSET] == FORMAT_DESCRIPTION_EVENT) ||
      (buf[EVENT_TYPE_OFFSET] == ROTATE_EVENT))
  {
    /*
      These events always have a header which stops here (i.e. their header is
      FROZEN).
    */
    /*
      Initialization to zero of all other Log_event members as they're not
      specified. Currently there are no such members; in the future there will
      be an event UID (but Format_description and Rotate don't need this UID,
      as they are not propagated through --log-slave-updates (remember the UID
      is used to not play a query twice when you have two masters which are
      slaves of a 3rd master). Then we are done.
    */
    return;
  }
  /* otherwise, go on with reading the header from buf (nothing now) */
382 383 384
}

#ifndef MYSQL_CLIENT
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
385
#ifdef HAVE_REPLICATION
386

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
387
/*
388
  Log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
389
*/
390

391
int Log_event::exec_event(struct st_relay_log_info* rli)
392
{
monty@mysql.com's avatar
monty@mysql.com committed
393 394
  DBUG_ENTER("Log_event::exec_event");

395 396 397 398 399 400 401 402 403 404 405 406 407
  /*
    rli is null when (as far as I (Guilhem) know)
    the caller is
    Load_log_event::exec_event *and* that one is called from
    Execute_load_log_event::exec_event. 
    In this case, we don't do anything here ;
    Execute_load_log_event::exec_event will call Log_event::exec_event
    again later with the proper rli.
    Strictly speaking, if we were sure that rli is null
    only in the case discussed above, 'if (rli)' is useless here.
    But as we are not 100% sure, keep it for now.
  */
  if (rli)  
408
  {
409 410 411 412 413 414 415 416 417 418 419 420 421 422
    /*
      If in a transaction, and if the slave supports transactions,
      just inc_event_relay_log_pos(). We only have to check for OPTION_BEGIN
      (not OPTION_NOT_AUTOCOMMIT) as transactions are logged
      with BEGIN/COMMIT, not with SET AUTOCOMMIT= .
      
      CAUTION: opt_using_transactions means
      innodb || bdb ; suppose the master supports InnoDB and BDB, 
      but the slave supports only BDB, problems
      will arise: 
      - suppose an InnoDB table is created on the master,
      - then it will be MyISAM on the slave
      - but as opt_using_transactions is true, the slave will believe he is
      transactional with the MyISAM table. And problems will come when one
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
423 424
      does START SLAVE; STOP SLAVE; START SLAVE; (the slave will resume at
      BEGIN whereas there has not been any rollback). This is the problem of
425 426 427 428 429
      using opt_using_transactions instead of a finer
      "does the slave support _the_transactional_handler_used_on_the_master_".
      
      More generally, we'll have problems when a query mixes a transactional
      handler and MyISAM and STOP SLAVE is issued in the middle of the
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
430 431
      "transaction". START SLAVE will resume at BEGIN while the MyISAM table
      has already been updated.
432 433
    */
    if ((thd->options & OPTION_BEGIN) && opt_using_transactions)
434
      rli->inc_event_relay_log_pos();
435 436
    else
    {
437
      rli->inc_group_relay_log_pos(log_pos);
438
      flush_relay_log_info(rli);
439 440 441 442
      /* 
         Note that Rotate_log_event::exec_event() does not call this function,
         so there is no chance that a fake rotate event resets
         last_master_timestamp.
443 444 445
         Note that we update without mutex (probably ok - except in some very
         rare cases, only consequence is that value may take some time to
         display in Seconds_Behind_Master - not critical).
446 447
      */
      rli->last_master_timestamp= when;
448
    }
449
  }
monty@mysql.com's avatar
monty@mysql.com committed
450
  DBUG_RETURN(0);
451
}
452

453

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
454
/*
455
  Log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
456
*/
457

458
void Log_event::pack_info(Protocol *protocol)
459
{
460
  protocol->store("", &my_charset_bin);
461 462 463
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
464
/*
465
  Log_event::net_send()
466

467
  Only called by SHOW BINLOG EVENTS
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
468
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
469

470
int Log_event::net_send(Protocol *protocol, const char* log_name, my_off_t pos)
471
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
472 473
  const char *p= strrchr(log_name, FN_LIBCHAR);
  const char *event_type;
474 475 476
  if (p)
    log_name = p + 1;
  
477
  protocol->prepare_for_resend();
478
  protocol->store(log_name, &my_charset_bin);
479
  protocol->store((ulonglong) pos);
480
  event_type = get_type_str();
481
  protocol->store(event_type, strlen(event_type), &my_charset_bin);
482 483 484 485
  protocol->store((uint32) server_id);
  protocol->store((ulonglong) log_pos);
  pack_info(protocol);
  return protocol->write();
486
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
487 488 489
#endif /* HAVE_REPLICATION */


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
490
/*
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
491
  Log_event::init_show_field_list()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
492
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
493 494 495 496 497 498 499 500 501

void Log_event::init_show_field_list(List<Item>* field_list)
{
  field_list->push_back(new Item_empty_string("Log_name", 20));
  field_list->push_back(new Item_return_int("Pos", 11,
					    MYSQL_TYPE_LONGLONG));
  field_list->push_back(new Item_empty_string("Event_type", 20));
  field_list->push_back(new Item_return_int("Server_id", 10,
					    MYSQL_TYPE_LONG));
502
  field_list->push_back(new Item_return_int("End_log_pos", 11,
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
503 504 505 506
					    MYSQL_TYPE_LONGLONG));
  field_list->push_back(new Item_empty_string("Info", 20));
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
507
#endif /* !MYSQL_CLIENT */
508

509

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
510
/*
511
  Log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
512
*/
513

514
bool Log_event::write_header(IO_CACHE* file, ulong event_data_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
515
{
516 517
  byte header[LOG_EVENT_HEADER_LEN];
  DBUG_ENTER("Log_event::write_header");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
518

519 520
  /* Store number of bytes that will be written by this event */
  data_written= event_data_length + sizeof(header);
521

522 523 524 525
  /*
    log_pos != 0 if this is relay-log event. In this case we should not
    change the position
  */
526

527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581
  if (is_artificial_event())
  {
    /*
      We should not do any cleanup on slave when reading this. We
      mark this by setting log_pos to 0.  Start_log_event_v3() will
      detect this on reading and set artificial_event=1 for the event.
    */
    log_pos= 0;
  }
  else  if (!log_pos)
  {
    /*
      Calculate position of end of event

      Note that with a SEQ_READ_APPEND cache, my_b_tell() does not
      work well.  So this will give slightly wrong positions for the
      Format_desc/Rotate/Stop events which the slave writes to its
      relay log. For example, the initial Format_desc will have
      end_log_pos=91 instead of 95. Because after writing the first 4
      bytes of the relay log, my_b_tell() still reports 0. Because
      my_b_append() does not update the counter which my_b_tell()
      later uses (one should probably use my_b_append_tell() to work
      around this).  To get right positions even when writing to the
      relay log, we use the (new) my_b_safe_tell().

      Note that this raises a question on the correctness of all these
      DBUG_ASSERT(my_b_tell()=rli->event_relay_log_pos).

      If in a transaction, the log_pos which we calculate below is not
      very good (because then my_b_safe_tell() returns start position
      of the BEGIN, so it's like the statement was at the BEGIN's
      place), but it's not a very serious problem (as the slave, when
      it is in a transaction, does not take those end_log_pos into
      account (as it calls inc_event_relay_log_pos()). To be fixed
      later, so that it looks less strange. But not bug.
    */

    log_pos= my_b_safe_tell(file)+data_written;
  }

  /*
    Header will be of size LOG_EVENT_HEADER_LEN for all events, except for
    FORMAT_DESCRIPTION_EVENT and ROTATE_EVENT, where it will be
    LOG_EVENT_MINIMAL_HEADER_LEN (remember these 2 have a frozen header,
    because we read them before knowing the format).
  */

  int4store(header, (ulong) when);              // timestamp
  header[EVENT_TYPE_OFFSET]= get_type_code();
  int4store(header+ SERVER_ID_OFFSET, server_id);
  int4store(header+ EVENT_LEN_OFFSET, data_written);
  int4store(header+ LOG_POS_OFFSET, log_pos);
  int2store(header+ FLAGS_OFFSET, flags);

  DBUG_RETURN(my_b_safe_write(file, header, sizeof(header)) != 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
582 583 584
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
585
/*
586
  Log_event::read_log_event()
587 588 589 590

  This needn't be format-tolerant, because we only read
  LOG_EVENT_MINIMAL_HEADER_LEN (we just want to read the event's length).

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
591
*/
592 593

#ifndef MYSQL_CLIENT
594
int Log_event::read_log_event(IO_CACHE* file, String* packet,
595
			      pthread_mutex_t* log_lock)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
596 597
{
  ulong data_len;
598
  int result=0;
599
  char buf[LOG_EVENT_MINIMAL_HEADER_LEN];
600
  DBUG_ENTER("read_log_event");
601

602
  if (log_lock)
603
    pthread_mutex_lock(log_lock);
604 605
  if (my_b_read(file, (byte*) buf, sizeof(buf)))
  {
606 607 608 609 610
    /*
      If the read hits eof, we must report it as eof so the caller
      will know it can go into cond_wait to be woken up on the next
      update to the log.
    */
611
    DBUG_PRINT("error",("file->error: %d", file->error));
612 613 614
    if (!file->error)
      result= LOG_READ_EOF;
    else
615
      result= (file->error > 0 ? LOG_READ_TRUNC : LOG_READ_IO);
616
    goto end;
617
  }
618
  data_len= uint4korr(buf + EVENT_LEN_OFFSET);
619
  if (data_len < LOG_EVENT_MINIMAL_HEADER_LEN ||
620
      data_len > current_thd->variables.max_allowed_packet)
621
  {
622
    DBUG_PRINT("error",("data_len: %ld", data_len));
623
    result= ((data_len < LOG_EVENT_MINIMAL_HEADER_LEN) ? LOG_READ_BOGUS :
624 625
	     LOG_READ_TOO_LARGE);
    goto end;
626
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
627
  packet->append(buf, sizeof(buf));
628
  data_len-= LOG_EVENT_MINIMAL_HEADER_LEN;
629 630 631
  if (data_len)
  {
    if (packet->append(file, data_len))
632
    {
633
      /*
634 635
	Here if we hit EOF it's really an error: as data_len is >=0
        there's supposed to be more bytes available. 
636
	EOF means we are reading the event partially, which should
637
	never happen: either we read badly or the binlog is truncated.
638 639 640
      */
      result= file->error >= 0 ? LOG_READ_TRUNC: LOG_READ_IO;
      /* Implicit goto end; */
641
    }
642
  }
643 644 645 646

end:
  if (log_lock)
    pthread_mutex_unlock(log_lock);
647
  DBUG_RETURN(result);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
648
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
649
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
650

651
#ifndef MYSQL_CLIENT
652 653
#define UNLOCK_MUTEX if (log_lock) pthread_mutex_unlock(log_lock);
#define LOCK_MUTEX if (log_lock) pthread_mutex_lock(log_lock);
654
#define max_allowed_packet current_thd->variables.max_allowed_packet
655
#else
656
#define UNLOCK_MUTEX
657
#define LOCK_MUTEX
658
#define max_allowed_packet (*mysql_get_parameters()->p_max_allowed_packet)
659 660
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
661
/*
662 663
  Log_event::read_log_event()

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
664
  NOTE:
665
    Allocates memory;  The caller is responsible for clean-up.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
666
*/
667

668
#ifndef MYSQL_CLIENT
669 670
Log_event* Log_event::read_log_event(IO_CACHE* file,
				     pthread_mutex_t* log_lock,
671
                                     const Format_description_log_event *description_event)
672
#else
673 674
Log_event* Log_event::read_log_event(IO_CACHE* file,
                                     const Format_description_log_event *description_event)
675
#endif  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
676
{
677 678 679 680 681 682 683 684 685 686 687
  DBUG_ASSERT(description_event);
  char head[LOG_EVENT_MINIMAL_HEADER_LEN];
  /*
    First we only want to read at most LOG_EVENT_MINIMAL_HEADER_LEN, just to
    check the event for sanity and to know its length; no need to really parse
    it. We say "at most" because this could be a 3.23 master, which has header
    of 13 bytes, whereas LOG_EVENT_MINIMAL_HEADER_LEN is 19 bytes (it's "minimal"
    over the set {MySQL >=4.0}).
  */
  uint header_size= min(description_event->common_header_len,
                        LOG_EVENT_MINIMAL_HEADER_LEN);
688

689
  LOCK_MUTEX;
690
  DBUG_PRINT("info", ("my_b_tell=%lu", my_b_tell(file)));
691
  if (my_b_read(file, (byte *) head, header_size))
692
  {
693 694
    DBUG_PRINT("info", ("Log_event::read_log_event(IO_CACHE*,Format_desc*) \
failed my_b_read"));
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
695
    UNLOCK_MUTEX;
696 697 698 699 700
    /*
      No error here; it could be that we are at the file's end. However if the
      next my_b_read() fails (below), it will be an error as we were able to
      read the first bytes.
    */
701
    return 0;
702
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
703

704
  uint data_len = uint4korr(head + EVENT_LEN_OFFSET);
705 706 707
  char *buf= 0;
  const char *error= 0;
  Log_event *res=  0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
708

709
  if (data_len > max_allowed_packet)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
710
  {
711 712
    error = "Event too big";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
713 714
  }

715
  if (data_len < header_size)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
716
  {
717 718
    error = "Event too small";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
719
  }
720 721 722

  // some events use the extra byte to null-terminate strings
  if (!(buf = my_malloc(data_len+1, MYF(MY_WME))))
723 724 725
  {
    error = "Out of memory";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
726
  }
727
  buf[data_len] = 0;
728
  memcpy(buf, head, header_size);
729
  if (my_b_read(file, (byte*) buf + header_size, data_len - header_size))
730 731 732 733
  {
    error = "read error";
    goto err;
  }
734 735
  if ((res= read_log_event(buf, data_len, &error,
                           description_event))) 
736
    res->register_temp_buf(buf);
737

738
err:
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
739
  UNLOCK_MUTEX;
740
  if (error)
741
  {
742 743 744
    sql_print_error("\
Error in Log_event::read_log_event(): '%s', data_len: %d, event_type: %d",
		    error,data_len,head[EVENT_TYPE_OFFSET]);
745
    my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
746 747 748 749 750 751 752 753 754
    /*
      The SQL slave thread will check if file->error<0 to know
      if there was an I/O error. Even if there is no "low-level" I/O errors
      with 'file', any of the high-level above errors is worrying
      enough to stop the SQL thread now ; as we are skipping the current event,
      going on with reading and successfully executing other events can
      only corrupt the slave's databases. So stop.
    */
    file->error= -1;
755
  }
756
  return res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
757 758
}

759

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
760
/*
761
  Log_event::read_log_event()
762 763
  Binlog format tolerance is in (buf, event_len, description_event)
  constructors.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
764
*/
765

766 767 768
Log_event* Log_event::read_log_event(const char* buf, uint event_len,
				     const char **error,
                                     const Format_description_log_event *description_event)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
769
{
770 771 772 773
  Log_event* ev;
  DBUG_ENTER("Log_event::read_log_event(char*,...)");
  DBUG_ASSERT(description_event);
  DBUG_PRINT("info", ("binlog_version: %d", description_event->binlog_version));
774
  if (event_len < EVENT_LEN_OFFSET ||
775 776 777
      (uint) event_len != uint4korr(buf+EVENT_LEN_OFFSET))
  {
    *error="Sanity check failed";		// Needed to free buffer
monty@mysql.com's avatar
monty@mysql.com committed
778
    DBUG_RETURN(NULL); // general sanity check - will fail on a partial read
779
  }
780
  
781
  switch(buf[EVENT_TYPE_OFFSET]) {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
782
  case QUERY_EVENT:
783
    ev  = new Query_log_event(buf, event_len, description_event);
784
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
785
  case LOAD_EVENT:
786
    ev = new Create_file_log_event(buf, event_len, description_event);
787
    break;
788
  case NEW_LOAD_EVENT:
789
    ev = new Load_log_event(buf, event_len, description_event);
790
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
791
  case ROTATE_EVENT:
792
    ev = new Rotate_log_event(buf, event_len, description_event);
793
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
794
#ifdef HAVE_REPLICATION
795
  case SLAVE_EVENT: /* can never happen (unused event) */
796 797
    ev = new Slave_log_event(buf, event_len);
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
798
#endif /* HAVE_REPLICATION */
799
  case CREATE_FILE_EVENT:
800
    ev = new Create_file_log_event(buf, event_len, description_event);
801 802
    break;
  case APPEND_BLOCK_EVENT:
803
    ev = new Append_block_log_event(buf, event_len, description_event);
804 805
    break;
  case DELETE_FILE_EVENT:
806
    ev = new Delete_file_log_event(buf, event_len, description_event);
807 808
    break;
  case EXEC_LOAD_EVENT:
809
    ev = new Execute_load_log_event(buf, event_len, description_event);
810
    break;
811 812
  case START_EVENT_V3: /* this is sent only by MySQL <=4.x */
    ev = new Start_log_event_v3(buf, description_event);
813
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
814
#ifdef HAVE_REPLICATION
815
  case STOP_EVENT:
816
    ev = new Stop_log_event(buf, description_event);
817
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
818
#endif /* HAVE_REPLICATION */
819
  case INTVAR_EVENT:
820
    ev = new Intvar_log_event(buf, description_event);
821
    break;
nick@mysql.com's avatar
nick@mysql.com committed
822
  case RAND_EVENT:
823
    ev = new Rand_log_event(buf, description_event);
nick@mysql.com's avatar
nick@mysql.com committed
824
    break;
825
  case USER_VAR_EVENT:
826 827 828 829
    ev = new User_var_log_event(buf, description_event);
    break;
  case FORMAT_DESCRIPTION_EVENT:
    ev = new Format_description_log_event(buf, event_len, description_event); 
830
    break;
831
  default:
832 833
    DBUG_PRINT("error",("Unknown evernt code: %d",(int) buf[EVENT_TYPE_OFFSET]));
    ev= NULL;
834
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
835
  }
836 837 838 839 840 841 842 843 844
  /*
    is_valid() are small event-specific sanity tests which are important; for
    example there are some my_malloc() in constructors
    (e.g. Query_log_event::Query_log_event(char*...)); when these my_malloc()
    fail we can't return an error out of the constructor (because constructor
    is "void") ; so instead we leave the pointer we wanted to allocate
    (e.g. 'query') to 0 and we test it in is_valid(). Same for
    Format_description_log_event, member 'post_header_len'. 
  */
845
  if (!ev || !ev->is_valid())
846
  {
847 848
    DBUG_PRINT("error",("Found invalid event in binary log"));

849
    delete ev;
850
#ifdef MYSQL_CLIENT
851
    if (!force_opt) /* then mysqlbinlog dies */
852 853
    {
      *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
854
      DBUG_RETURN(0);
855
    }
856
    ev= new Unknown_log_event(buf, description_event);
857 858
#else
    *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
859
    DBUG_RETURN(0);
860
#endif
861
  }
monty@mysql.com's avatar
monty@mysql.com committed
862
  DBUG_RETURN(ev);  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
863 864
}

865
#ifdef MYSQL_CLIENT
866

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
867
/*
868
  Log_event::print_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
869
*/
870

871 872
void Log_event::print_header(FILE* file)
{
873
  char llbuff[22];
874 875
  fputc('#', file);
  print_timestamp(file);
876
  fprintf(file, " server id %d  end_log_pos %s ", server_id,
877
	  llstr(log_pos,llbuff)); 
878 879
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
880
/*
881
  Log_event::print_timestamp()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
882
*/
883

884
void Log_event::print_timestamp(FILE* file, time_t* ts)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
885
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
886
  struct tm *res;
887 888
  if (!ts)
    ts = &when;
889 890
#ifdef MYSQL_SERVER				// This is always false
  struct tm tm_tmp;
monty@work.mysql.com's avatar
monty@work.mysql.com committed
891
  localtime_r(ts,(res= &tm_tmp));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
892
#else
893
  res=localtime(ts);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
894
#endif
895 896

  fprintf(file,"%02d%02d%02d %2d:%02d:%02d",
897 898 899 900 901 902
	  res->tm_year % 100,
	  res->tm_mon+1,
	  res->tm_mday,
	  res->tm_hour,
	  res->tm_min,
	  res->tm_sec);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
903 904
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
905
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
906 907


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
908
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
909
	Query_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
910
**************************************************************************/
911

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
912
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
913

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
914
/*
915
  Query_log_event::pack_info()
916 917 918 919
  This (which is used only for SHOW BINLOG EVENTS) could be updated to
  print SET @@session_var=. But this is not urgent, as SHOW BINLOG EVENTS is
  only an information, it does not produce suitable queries to replay (for
  example it does not print LOAD DATA INFILE).
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
920
*/
921

922
void Query_log_event::pack_info(Protocol *protocol)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
923
{
924
  // TODO: show the catalog ??
925 926 927 928
  char *buf, *pos;
  if (!(buf= my_malloc(9 + db_len + q_len, MYF(MY_WME))))
    return;
  pos= buf;    
929 930
  if (!(flags & LOG_EVENT_SUPPRESS_USE_F) 
      && db && db_len)
931
  {
932 933
    pos= strmov(buf, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
934
    pos= strmov(pos+db_len, "`; ");
935
  }
936
  if (query && q_len)
937 938 939 940
  {
    memcpy(pos, query, q_len);
    pos+= q_len;
  }
941
  protocol->store(buf, pos-buf, &my_charset_bin);
942
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
943
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
944
#endif
945 946


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
947
/*
948
  Query_log_event::write()
bk@work.mysql.com's avatar
bk@work.mysql.com committed
949

950 951 952 953
  NOTES:
    In this event we have to modify the header to have the correct
    EVENT_LEN_OFFSET as we don't yet know how many status variables we
    will print!
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
954
*/
955

956
bool Query_log_event::write(IO_CACHE* file)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
957
{
958 959
  uchar buf[QUERY_HEADER_LEN+1+4+1+8+1+1+FN_REFLEN+5], *start, *start_of_status;
  ulong event_length;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
960

961
  if (!query)
962 963
    return 1;                                   // Something wrong with event

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
964 965 966 967 968
  /*
    We want to store the thread id:
    (- as an information for the user when he reads the binlog)
    - if the query uses temporary table: for the slave SQL thread to know to
    which master connection the temp table belongs.
969
    Now imagine we (write()) are called by the slave SQL thread (we are
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001
    logging a query executed by this thread; the slave runs with
    --log-slave-updates). Then this query will be logged with
    thread_id=the_thread_id_of_the_SQL_thread. Imagine that 2 temp tables of
    the same name were created simultaneously on the master (in the master
    binlog you have
    CREATE TEMPORARY TABLE t; (thread 1)
    CREATE TEMPORARY TABLE t; (thread 2)
    ...)
    then in the slave's binlog there will be
    CREATE TEMPORARY TABLE t; (thread_id_of_the_slave_SQL_thread)
    CREATE TEMPORARY TABLE t; (thread_id_of_the_slave_SQL_thread)
    which is bad (same thread id!).

    To avoid this, we log the thread's thread id EXCEPT for the SQL
    slave thread for which we log the original (master's) thread id.
    Now this moves the bug: what happens if the thread id on the
    master was 10 and when the slave replicates the query, a
    connection number 10 is opened by a normal client on the slave,
    and updates a temp table of the same name? We get a problem
    again. To avoid this, in the handling of temp tables (sql_base.cc)
    we use thread_id AND server_id.  TODO when this is merged into
    4.1: in 4.1, slave_proxy_id has been renamed to pseudo_thread_id
    and is a session variable: that's to make mysqlbinlog work with
    temp tables. We probably need to introduce

    SET PSEUDO_SERVER_ID
    for mysqlbinlog in 4.1. mysqlbinlog would print:
    SET PSEUDO_SERVER_ID=
    SET PSEUDO_THREAD_ID=
    for each query using temp tables.
  */
  int4store(buf + Q_THREAD_ID_OFFSET, slave_proxy_id);
1002 1003 1004 1005
  int4store(buf + Q_EXEC_TIME_OFFSET, exec_time);
  buf[Q_DB_LEN_OFFSET] = (char) db_len;
  int2store(buf + Q_ERR_CODE_OFFSET, error_code);

1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076
  /*
    You MUST always write status vars in increasing order of code. This
    guarantees that a slightly older slave will be able to parse those he
    knows.
  */
  start_of_status= start= buf+QUERY_HEADER_LEN;
  if (flags2_inited)
  {
    *(start++)= Q_FLAGS2_CODE;
    int4store(start, flags2);
    start+= 4;
  }
  if (sql_mode_inited)
  {
    *(start++)= Q_SQL_MODE_CODE;
    int8store(start, sql_mode);
    start+= 8;
  }
  if (catalog_len >= 0) // i.e. "catalog inited" (false for 4.0 events)
  {
    *(start++)= Q_CATALOG_CODE;
    *(start++)= (uchar) catalog_len;
    bmove(start, catalog, catalog_len);
    start+= catalog_len;
    /*
      We write a \0 at the end. As we also have written the length, it's
      apparently useless; but in fact it enables us to just do
      catalog= a_pointer_to_the_buffer_of_the_read_event
      later in the slave SQL thread.
      If we didn't have the \0, we would need to memdup to build the catalog in
      the slave SQL thread. 
      And still the interest of having the length too is that in the slave SQL
      thread we immediately know at which position the catalog ends (no need to
      search for '\0'. In other words: length saves search, \0 saves mem alloc,
      at the cost of 1 redundant byte on the disk.
      Note that this is only a fix until we change 'catalog' to LEX_STRING
      (then we won't need the \0).
    */
    *(start++)= '\0';
  }
  if (auto_increment_increment != 1)
  {
    *start++= Q_AUTO_INCREMENT;
    int2store(start, auto_increment_increment);
    int2store(start+2, auto_increment_offset);
    start+= 4;
  }
  /*
    Here there could be code like
    if (command-line-option-which-says-"log_this_variable")
    {
    *(start++)= Q_THIS_VARIABLE_CODE;
    int4store(start, this_variable);
    start+= 4;
    }
  */
  
  /* Store length of status variables */
  status_vars_len= (uint) (start-start_of_status);
  int2store(buf + Q_STATUS_VARS_LEN_OFFSET, status_vars_len);

  /*
    Calculate length of whole event
    The "1" below is the \0 in the db's length
  */
  event_length= (uint) (start-buf) + db_len + 1 + q_len;

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) buf, (uint) (start-buf)) ||
  	  my_b_safe_write(file, (db) ? (byte*) db : (byte*)"", db_len + 1) ||
  	  my_b_safe_write(file, (byte*) query, q_len)) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1077 1078
}

1079

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1080
/*
1081
  Query_log_event::Query_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1082
*/
1083

1084 1085
#ifndef MYSQL_CLIENT
Query_log_event::Query_log_event(THD* thd_arg, const char* query_arg,
1086 1087 1088 1089 1090 1091
				 ulong query_length, bool using_trans,
				 bool suppress_use)
  :Log_event(thd_arg, 
	     ((thd_arg->tmp_table_used ? LOG_EVENT_THREAD_SPECIFIC_F : 0)
	      | (suppress_use          ? LOG_EVENT_SUPPRESS_USE_F    : 0)),
	     using_trans),
1092
   data_buf(0), query(query_arg), catalog(thd_arg->catalog),
1093
   db(thd_arg->db), q_len((uint32) query_length),
1094
   error_code((thd_arg->killed != THD::NOT_KILLED) ?
1095
              ((thd_arg->system_thread & SYSTEM_THREAD_DELAYED_INSERT) ?
1096
               0 : thd->killed_errno()) : thd_arg->net.last_errno),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1097 1098
   thread_id(thd_arg->thread_id),
   /* save the original thread id; we already know the server id */
1099 1100 1101 1102 1103
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
   flags2_inited(1), sql_mode_inited(1), flags2(0),
   sql_mode(thd_arg->variables.sql_mode),
   auto_increment_increment(thd_arg->variables.auto_increment_increment),
   auto_increment_offset(thd_arg->variables.auto_increment_offset)
1104 1105 1106 1107
{
  time_t end_time;
  time(&end_time);
  exec_time = (ulong) (end_time  - thd->start_time);
1108 1109
  catalog_len = (catalog) ? (uint32) strlen(catalog) : 0;
  status_vars_len= 1+4+1+8+1+1+catalog_len+1;
1110
  db_len = (db) ? (uint32) strlen(db) : 0;
1111 1112 1113 1114 1115 1116 1117 1118 1119 1120
  /*
    If we don't use flags2 for anything else than options contained in
    thd->options, it would be more efficient to flags2=thd_arg->options
    (OPTIONS_WRITTEN_TO_BINLOG would be used only at reading time).
    But it's likely that we don't want to use 32 bits for 3 bits; in the future
    we will probably want to reclaim the 29 bits. So we need the &.
  */
  flags2= thd_arg->options & OPTIONS_WRITTEN_TO_BIN_LOG;

  DBUG_PRINT("info",("Query_log_event has flags2=%lu sql_mode=%lu",flags2,sql_mode));
1121
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1122
#endif /* MYSQL_CLIENT */
1123

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1124

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1125
/*
1126
  Query_log_event::Query_log_event()
1127
  This is used by the SQL slave thread to prepare the event before execution.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1128
*/
1129

1130 1131 1132 1133 1134
Query_log_event::Query_log_event(const char* buf, uint event_len,
                                 const Format_description_log_event *description_event)
  :Log_event(buf, description_event), data_buf(0), query(NullS), catalog(NullS), 
   db(NullS), catalog_len(0), status_vars_len(0),
   flags2_inited(0), sql_mode_inited(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1135 1136
{
  ulong data_len;
1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170
  uint32 tmp;
  uint8 common_header_len, post_header_len;
  const char *start, *end;
  DBUG_ENTER("Query_log_event::Query_log_event(char*,...)");

  common_header_len= description_event->common_header_len;
  post_header_len= description_event->post_header_len[QUERY_EVENT-1]; 
  DBUG_PRINT("info",("event_len=%ld, common_header_len=%d, post_header_len=%d",
                     event_len, common_header_len, post_header_len));
  
  /*
    We test if the event's length is sensible, and if so we compute data_len.
    We cannot rely on QUERY_HEADER_LEN here as it would not be format-tolerant.
    We use QUERY_HEADER_MINIMAL_LEN which is the same for 3.23, 4.0 & 5.0.
  */
  if (event_len < (uint)(common_header_len + post_header_len))
    DBUG_VOID_RETURN;				
  data_len = event_len - (common_header_len + post_header_len);
  buf+= common_header_len;
  
  slave_proxy_id= thread_id = uint4korr(buf + Q_THREAD_ID_OFFSET);
  exec_time = uint4korr(buf + Q_EXEC_TIME_OFFSET);
  db_len = (uint)buf[Q_DB_LEN_OFFSET];
  error_code = uint2korr(buf + Q_ERR_CODE_OFFSET);
  /* If auto_increment is not set by query_event, they should not be used */
  auto_increment_increment= auto_increment_offset= 1;

  /*
    5.0 format starts here.
    Depending on the format, we may or not have affected/warnings etc
    The remnent post-header to be parsed has length:
  */
  tmp= post_header_len - QUERY_HEADER_MINIMAL_LEN; 
  if (tmp)
1171
  {
1172 1173 1174 1175 1176
    status_vars_len= uint2korr(buf + Q_STATUS_VARS_LEN_OFFSET);
    data_len-= status_vars_len;
    DBUG_PRINT("info", ("Query_log_event has status_vars_len: %u",
                        (uint) status_vars_len));
    tmp-= 2;
1177
  }
1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189
  /* we have parsed everything we know in the post header */
#ifndef DBUG_OFF
  if (tmp) /* this is probably a master newer than us */
    DBUG_PRINT("info", ("Query_log_event has longer post header than we know\
  (%d more bytes)", tmp));
#endif
  
  /* variable-part: the status vars; only in MySQL 5.0  */
  
  start= (char*) (buf+post_header_len);
  end= (char*) (start+status_vars_len);
  for (const uchar* pos= (const uchar*) start; pos < (const uchar*) end;)
1190
  {
1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226
    switch (*pos++) {
    case Q_FLAGS2_CODE:
      flags2_inited= 1;
      flags2= uint4korr(pos);
      DBUG_PRINT("info",("In Query_log_event, read flags2: %lu", flags2));
      pos+= 4;
      break;
    case Q_SQL_MODE_CODE:
    {
#ifndef DBUG_OFF
      char buff[22];
#endif
      sql_mode_inited= 1;
      sql_mode= (ulong) uint8korr(pos); // QQ: Fix when sql_mode is ulonglong
      DBUG_PRINT("info",("In Query_log_event, read sql_mode: %s",
			 llstr(sql_mode, buff)));
      pos+= 8;
      break;
    }
    case Q_CATALOG_CODE:
      catalog_len= *pos;
      if (catalog_len)
        catalog= (char*) pos+1;                           // Will be copied later
      pos+= catalog_len+2;
      break;
    case Q_AUTO_INCREMENT:
      auto_increment_increment= uint2korr(pos);
      auto_increment_offset=    uint2korr(pos+2);
      pos+= 4;
      break;
    default:
      /* That's why you must write status vars in growing order of code */
      DBUG_PRINT("info",("Query_log_event has unknown status vars (first has\
 code: %u), skipping the rest of them", (uint) *(pos-1)));
      pos= (const uchar*) end;                         // Break look
    }
1227
  }
1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247
  
  /* A 2nd variable part; this is common to all versions */ 
  
  if (!(start= data_buf = (char*) my_malloc(catalog_len + data_len +2, MYF(MY_WME))))
    DBUG_VOID_RETURN;
  if (catalog)                                  // If catalog is given
  {
    memcpy((char*) start, catalog, catalog_len+1);      // Copy name and end \0
    catalog= start;
    start+= catalog_len+1;
  }
  memcpy((char*) start, end, data_len);          // Copy db and query
  ((char*) start)[data_len]= '\0';              // End query with \0 (For safetly)
  db= start;
  query= start + db_len + 1;
  q_len= data_len - db_len -1;
  /* This is used to detect wrong parsing. Could be removed in the future. */
  DBUG_PRINT("info", ("catalog: '%s'  len: %u   db: '%s'  len:  %u  q_len: %lu",
                      catalog, (uint) catalog_len, db, (uint) db_len,q_len));
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1248 1249
}

1250

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1251
/*
1252
  Query_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1253
*/
1254

1255
#ifdef MYSQL_CLIENT
1256 1257
void Query_log_event::print(FILE* file, bool short_form,
                            LAST_EVENT_INFO* last_event_info)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1258
{
1259
  // TODO: print the catalog ??
1260
  char buff[40],*end;				// Enough for SET TIMESTAMP
1261 1262 1263
  bool different_db= 1;
  uint32 tmp;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1264 1265
  if (!short_form)
  {
1266
    print_header(file);
1267 1268
    fprintf(file, "\tQuery\tthread_id=%lu\texec_time=%lu\terror_code=%d\n",
	    (ulong) thread_id, (ulong) exec_time, error_code);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1269 1270
  }

monty@mysql.com's avatar
monty@mysql.com committed
1271
  if (!(flags & LOG_EVENT_SUPPRESS_USE_F) && db)
1272
  {
monty@mysql.com's avatar
monty@mysql.com committed
1273
    if (different_db= memcmp(last_event_info->db, db, db_len + 1))
1274
      memcpy(last_event_info->db, db, db_len + 1);
monty@mysql.com's avatar
monty@mysql.com committed
1275
    if (db[0] && different_db) 
1276
      fprintf(file, "use %s;\n", db);
1277
  }
1278

1279 1280 1281 1282
  end=int10_to_str((long) when, strmov(buff,"SET TIMESTAMP="),10);
  *end++=';';
  *end++='\n';
  my_fwrite(file, (byte*) buff, (uint) (end-buff),MYF(MY_NABP | MY_WME));
1283 1284
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
    fprintf(file,"SET @@session.pseudo_thread_id=%lu;\n",(ulong)thread_id);
1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352
  /*
    Now the session variables;
    it's more efficient to pass SQL_MODE as a number instead of a
    comma-separated list.
    FOREIGN_KEY_CHECKS, SQL_AUTO_IS_NULL, UNIQUE_CHECKS are session-only
    variables (they have no global version; they're not listed in sql_class.h),
    The tests below work for pure binlogs or pure relay logs. Won't work for
    mixed relay logs but we don't create mixed relay logs (that is, there is no
    relay log with a format change except within the 3 first events, which
    mysqlbinlog handles gracefully). So this code should always be good.
  */

  if (likely(flags2_inited)) /* likely as this will mainly read 5.0 logs */
  {
    /* tmp is a bitmask of bits which have changed. */
    if (likely(last_event_info->flags2_inited)) 
      /* All bits which have changed */
      tmp= (last_event_info->flags2) ^ flags2;
    else /* that's the first Query event we read */
    {
      last_event_info->flags2_inited= 1;
      tmp= ~((uint32)0); /* all bits have changed */
    }

    if (unlikely(tmp)) /* some bits have changed */
    {
      bool need_comma= 0;
      fprintf(file, "SET ");
      print_set_option(file, tmp, OPTION_NO_FOREIGN_KEY_CHECKS, ~flags2,
                   "@@session.foreign_key_checks", &need_comma);
      print_set_option(file, tmp, OPTION_AUTO_IS_NULL, flags2,
                   "@@session.sql_auto_is_null", &need_comma);
      print_set_option(file, tmp, OPTION_RELAXED_UNIQUE_CHECKS, ~flags2,
                   "@@session.unique_checks", &need_comma);
      fprintf(file,";\n");
      last_event_info->flags2= flags2;
    }
  }

  /*
    If flags2_inited==0, this is an event from 3.23 or 4.0; nothing to print
    (remember we don't produce mixed relay logs so there cannot be 5.0 events
    before that one so there is nothing to reset).
  */

  if (likely(sql_mode_inited))
  {
    if (unlikely(!last_event_info->sql_mode_inited)) /* first Query event */
    {
      last_event_info->sql_mode_inited= 1;
      /* force a difference to force write */
      last_event_info->sql_mode= ~sql_mode;
    }
    if (unlikely(last_event_info->sql_mode != sql_mode))
    {
      fprintf(file,"SET @@session.sql_mode=%lu;\n",(ulong)sql_mode);
      last_event_info->sql_mode= sql_mode;
    }
  }
  if (last_event_info->auto_increment_increment != auto_increment_increment ||
      last_event_info->auto_increment_offset != auto_increment_offset)
  {
    fprintf(file,"SET @@session.auto_increment_increment=%lu, @@session.auto_increment_offset=%lu;\n",
            auto_increment_increment,auto_increment_offset);
    last_event_info->auto_increment_increment= auto_increment_increment;
    last_event_info->auto_increment_offset=    auto_increment_offset;
  }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1353
  my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
1354
  fputs(";\n", file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1355
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1356
#endif /* MYSQL_CLIENT */
1357

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1358

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1359
/*
1360
  Query_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1361
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1362

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1363
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1364
int Query_log_event::exec_event(struct st_relay_log_info* rli)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1365
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1366
  int expected_error,actual_error= 0;
1367 1368 1369 1370 1371 1372 1373
  /*
    Colleagues: please never free(thd->catalog) in MySQL. This would lead to
    bugs as here thd->catalog is a part of an alloced block, not an entire
    alloced block (see Query_log_event::exec_event()). Same for thd->db.
    Thank you.
  */
  thd->catalog= (char*) catalog;
1374
  thd->db_length= db_len;
1375
  thd->db= (char *) rpl_filter->get_rewrite_db(db, &thd->db_length);
1376 1377
  thd->variables.auto_increment_increment= auto_increment_increment;
  thd->variables.auto_increment_offset=    auto_increment_offset;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1378

1379
  /*
1380 1381 1382 1383 1384 1385 1386 1387
    InnoDB internally stores the master log position it has executed so far,
    i.e. the position just after the COMMIT event.
    When InnoDB will want to store, the positions in rli won't have
    been updated yet, so group_master_log_* will point to old BEGIN
    and event_master_log* will point to the beginning of current COMMIT.
    But log_pos of the COMMIT Query event is what we want, i.e. the pos of the
    END of the current log event (COMMIT). We save it in rli so that InnoDB can
    access it.
1388
  */
monty@mysql.com's avatar
monty@mysql.com committed
1389
  rli->future_group_master_log_pos= log_pos;
1390 1391
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

monty@mysql.com's avatar
monty@mysql.com committed
1392
  clear_all_errors(thd, rli);
1393

1394
  if (rpl_filter->db_ok(thd->db))
1395 1396
  {
    thd->set_time((time_t)when);
1397 1398
    thd->query_length= q_len;
    thd->query = (char*)query;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1399
    VOID(pthread_mutex_lock(&LOCK_thread_count));
1400 1401
    thd->query_id = query_id++;
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
1402
    thd->variables.pseudo_thread_id= thread_id;		// for temp tables
monty@mysql.com's avatar
monty@mysql.com committed
1403 1404
    mysql_log.write(thd,COM_QUERY,"%s",thd->query);
    DBUG_PRINT("query",("%s",thd->query));
1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429

    if (flags2_inited)
      /*
        all bits of thd->options which are 1 in OPTIONS_WRITTEN_TO_BIN_LOG must
        take their value from flags2.
      */
      thd->options= flags2|(thd->options & ~(ulong)OPTIONS_WRITTEN_TO_BIN_LOG);
    /*
      else, we are in a 3.23/4.0 binlog; we previously received a
      Rotate_log_event which reset thd->options and sql_mode, so nothing to do.
    */
    
    /*
      We do not replicate IGNORE_DIR_IN_CREATE. That is, if the master is a
      slave which runs with SQL_MODE=IGNORE_DIR_IN_CREATE, this should not
      force us to ignore the dir too. Imagine you are a ring of machines, and
      one has a disk problem so that you temporarily need IGNORE_DIR_IN_CREATE
      on this machine; you don't want it to propagate elsewhere (you don't want
      all slaves to start ignoring the dirs).
    */
    if (sql_mode_inited)
      thd->variables.sql_mode=
	(ulong) ((thd->variables.sql_mode & MODE_NO_DIR_IN_CREATE) |
		 (sql_mode & ~(ulong) MODE_NO_DIR_IN_CREATE));
    
monty@mysql.com's avatar
monty@mysql.com committed
1430
    if (ignored_error_code((expected_error= error_code)) ||
1431 1432
	!check_expected_error(thd,rli,expected_error))
      mysql_parse(thd, thd->query, q_len);
monty@mysql.com's avatar
monty@mysql.com committed
1433 1434
    else
    {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1435
      /*
monty@mysql.com's avatar
monty@mysql.com committed
1436 1437 1438 1439 1440
        The query got a really bad error on the master (thread killed etc),
        which could be inconsistent. Parse it to test the table names: if the
        replicate-*-do|ignore-table rules say "this query must be ignored" then
        we exit gracefully; otherwise we warn about the bad error and tell DBA
        to check/fix it.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1441
      */
monty@mysql.com's avatar
monty@mysql.com committed
1442 1443 1444
      if (mysql_test_parse_for_slave(thd, thd->query, q_len))
        clear_all_errors(thd, rli);        /* Can ignore query */
      else
1445
      {
monty@mysql.com's avatar
monty@mysql.com committed
1446
        slave_print_error(rli,expected_error, 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1447
                          "\
monty@mysql.com's avatar
monty@mysql.com committed
1448
Query partially completed on the master (error on master: %d) \
monty@mysql.com's avatar
monty@mysql.com committed
1449 1450 1451
and was aborted. There is a chance that your master is inconsistent at this \
point. If you are sure that your master is ok, run this query manually on the \
slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; \
monty@mysql.com's avatar
monty@mysql.com committed
1452
START SLAVE; . Query: '%s'", expected_error, thd->query);
monty@mysql.com's avatar
monty@mysql.com committed
1453 1454 1455 1456
        thd->query_error= 1;
      }
      goto end;
    }
1457
 
monty@mysql.com's avatar
monty@mysql.com committed
1458 1459 1460 1461 1462
    /*
      If we expected a non-zero error code, and we don't get the same error
      code, and none of them should be ignored.
    */
    DBUG_PRINT("info",("expected_error: %d  last_errno: %d",
1463
 		       expected_error, thd->net.last_errno));
monty@mysql.com's avatar
monty@mysql.com committed
1464
    if ((expected_error != (actual_error= thd->net.last_errno)) &&
1465 1466 1467
 	expected_error &&
 	!ignored_error_code(actual_error) &&
 	!ignored_error_code(expected_error))
monty@mysql.com's avatar
monty@mysql.com committed
1468 1469
    {
      slave_print_error(rli, 0,
1470
 			"\
monty@mysql.com's avatar
monty@mysql.com committed
1471
Query caused different errors on master and slave. \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1472
Error on master: '%s' (%d), Error on slave: '%s' (%d). \
monty@mysql.com's avatar
monty@mysql.com committed
1473
Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
1474 1475 1476 1477
			ER_SAFE(expected_error),
			expected_error,
			actual_error ? thd->net.last_error: "no error",
			actual_error,
1478
			print_slave_db_safe(db), query);
monty@mysql.com's avatar
monty@mysql.com committed
1479 1480 1481 1482 1483 1484
      thd->query_error= 1;
    }
    /*
      If we get the same error code as expected, or they should be ignored. 
    */
    else if (expected_error == actual_error ||
1485
 	     ignored_error_code(actual_error))
monty@mysql.com's avatar
monty@mysql.com committed
1486 1487 1488 1489 1490 1491
    {
      DBUG_PRINT("info",("error ignored"));
      clear_all_errors(thd, rli);
    }
    /*
      Other cases: mostly we expected no error and get one.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1492
    */
monty@mysql.com's avatar
monty@mysql.com committed
1493 1494 1495
    else if (thd->query_error || thd->is_fatal_error)
    {
      slave_print_error(rli,actual_error,
monty@mysql.com's avatar
monty@mysql.com committed
1496
			"Error '%s' on query. Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
1497 1498
			(actual_error ? thd->net.last_error :
			 "unexpected success or fatal error"),
1499
			print_slave_db_safe(thd->db), query);
monty@mysql.com's avatar
monty@mysql.com committed
1500 1501
      thd->query_error= 1;
    }
1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523

    /*
      TODO: compare the values of "affected rows" around here. Something
      like:
      if ((uint32) affected_in_event != (uint32) affected_on_slave)
      {
      sql_print_error("Slave: did not get the expected number of affected \
      rows running query from master - expected %d, got %d (this numbers \
      should have matched modulo 4294967296).", 0, ...);
      thd->query_error = 1;
      }
      We may also want an option to tell the slave to ignore "affected"
      mismatch. This mismatch could be implemented with a new ER_ code, and
      to ignore it you would use --slave-skip-errors...
        
      To do the comparison we need to know the value of "affected" which the
      above mysql_parse() computed. And we need to know the value of
      "affected" in the master's binlog. Both will be implemented later. The
      important thing is that we now have the format ready to log the values
      of "affected" in the binlog. So we can release 5.0.0 before effectively
      logging "affected" and effectively comparing it.
    */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1524 1525
  } /* End of if (db_ok(... */

monty@mysql.com's avatar
monty@mysql.com committed
1526
end:
1527
  VOID(pthread_mutex_lock(&LOCK_thread_count));
1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538
  /*
    Probably we have set thd->query, thd->db, thd->catalog to point to places
    in the data_buf of this event. Now the event is going to be deleted
    probably, so data_buf will be freed, so the thd->... listed above will be
    pointers to freed memory. 
    So we must set them to 0, so that those bad pointers values are not later
    used. Note that "cleanup" queries (automatic DO RELEASE_LOCK() and DROP
    TEMPORARY TABLE don't suffer from these assignments to 0 as DROP TEMPORARY
    TABLE uses the db.table syntax).
  */
  thd->db= thd->catalog= 0;	        // prevent db from being freed
1539
  thd->query= 0;			// just to be sure
serg@serg.mylan's avatar
serg@serg.mylan committed
1540
  thd->query_length= thd->db_length =0;
1541
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1542
  close_thread_tables(thd);      
1543
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
1544 1545 1546 1547 1548 1549 1550
  /*
    If there was an error we stop. Otherwise we increment positions. Note that
    we will not increment group* positions if we are just after a SET
    ONE_SHOT, because SET ONE_SHOT should not be separated from its following
    updating query.
  */
  return (thd->query_error ? thd->query_error : 
1551
          (thd->one_shot_set ? (rli->inc_event_relay_log_pos(),0) :
1552
           Log_event::exec_event(rli))); 
1553
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1554
#endif
1555

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1556

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1557
/**************************************************************************
1558
	Start_log_event_v3 methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1559
**************************************************************************/
1560

1561 1562 1563 1564 1565 1566 1567 1568
#ifndef MYSQL_CLIENT
Start_log_event_v3::Start_log_event_v3() :Log_event(), binlog_version(BINLOG_VERSION), artificial_event(0)
{
  created= when;
  memcpy(server_version, ::server_version, ST_SERVER_VER_LEN);
}
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1569
/*
1570
  Start_log_event_v3::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1571
*/
1572

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1573
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1574
void Start_log_event_v3::pack_info(Protocol *protocol)
nick@mysql.com's avatar
nick@mysql.com committed
1575
{
1576 1577 1578 1579
  char buf[12 + ST_SERVER_VER_LEN + 14 + 22], *pos;
  pos= strmov(buf, "Server ver: ");
  pos= strmov(pos, server_version);
  pos= strmov(pos, ", Binlog ver: ");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1580 1581
  pos= int10_to_str(binlog_version, pos, 10);
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
nick@mysql.com's avatar
nick@mysql.com committed
1582
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1583
#endif
1584 1585


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1586
/*
1587
  Start_log_event_v3::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1588
*/
nick@mysql.com's avatar
nick@mysql.com committed
1589 1590

#ifdef MYSQL_CLIENT
1591
void Start_log_event_v3::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
nick@mysql.com's avatar
nick@mysql.com committed
1592
{
1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tStart: binlog v %d, server v %s created ", binlog_version,
            server_version);
    print_timestamp(file);
    if (created)
      fprintf(file," at startup");
    fputc('\n', file);
  }
#ifdef WHEN_WE_HAVE_THE_RESET_CONNECTION_SQL_COMMAND
  /*
    This is for mysqlbinlog: like in replication, we want to delete the stale
    tmp files left by an unclean shutdown of mysqld (temporary tables). Probably
    this can be done with RESET CONNECTION (syntax to be defined).
  */
  fprintf(file,"RESET CONNECTION;\n");
#endif
nick@mysql.com's avatar
nick@mysql.com committed
1611 1612
  fflush(file);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1613
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1614

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1615
/*
1616
  Start_log_event_v3::Start_log_event_v3()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1617
*/
1618

1619 1620 1621
Start_log_event_v3::Start_log_event_v3(const char* buf,
                                       const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
1622
{
1623 1624
  buf+= description_event->common_header_len;
  binlog_version= uint2korr(buf+ST_BINLOG_VER_OFFSET);
1625 1626
  memcpy(server_version, buf+ST_SERVER_VER_OFFSET,
	 ST_SERVER_VER_LEN);
1627 1628 1629
  created= uint4korr(buf+ST_CREATED_OFFSET);
  /* We use log_pos to mark if this was an artificial event or not */
  artificial_event= (log_pos == 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1630 1631
}

1632

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1633
/*
1634
  Start_log_event_v3::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1635
*/
1636

1637
bool Start_log_event_v3::write(IO_CACHE* file)
1638
{
1639
  char buff[START_V3_HEADER_LEN];
1640 1641 1642
  int2store(buff + ST_BINLOG_VER_OFFSET,binlog_version);
  memcpy(buff + ST_SERVER_VER_OFFSET,server_version,ST_SERVER_VER_LEN);
  int4store(buff + ST_CREATED_OFFSET,created);
1643 1644
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, (byte*) buff, sizeof(buff)));
1645
}
1646

1647

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1648
/*
1649
  Start_log_event_v3::exec_event()
1650 1651 1652 1653

  The master started

  IMPLEMENTATION
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1654 1655 1656 1657
    - To handle the case where the master died without having time to write
      DROP TEMPORARY TABLE, DO RELEASE_LOCK (prepared statements' deletion is
      TODO), we clean up all temporary tables that we got, if we are sure we
      can (see below).
1658 1659

  TODO
1660 1661 1662 1663 1664
    - Remove all active user locks.
      Guilhem 2003-06: this is true but not urgent: the worst it can cause is
      the use of a bit of memory for a user lock which will not be used
      anymore. If the user lock is later used, the old one will be released. In
      other words, no deadlock problem.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1665 1666
*/

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1667
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1668
int Start_log_event_v3::exec_event(struct st_relay_log_info* rli)
1669
{
1670
  DBUG_ENTER("Start_log_event_v3::exec_event");
monty@mishka.local's avatar
monty@mishka.local committed
1671 1672 1673 1674 1675
  /*
    If the I/O thread has not started, mi->old_format is BINLOG_FORMAT_CURRENT
    (that's what the MASTER_INFO constructor does), so the test below is not
    perfect at all.
  */
1676 1677 1678 1679 1680 1681 1682 1683 1684
  switch (rli->relay_log.description_event_for_exec->binlog_version)
  {
  case 3:
  case 4:
    /*
      This can either be 4.x (then a Start_log_event_v3 is only at master
      startup so we are sure the master has restarted and cleared his temp
      tables; the event always has 'created'>0) or 5.0 (then we have to test
      'created').
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1685
    */
1686 1687 1688 1689 1690
    if (created)
    {
      close_temporary_tables(thd);
      cleanup_load_tmpdir();
    }
1691 1692 1693 1694 1695 1696 1697
    /*
      As a transaction NEVER spans on 2 or more binlogs:
      if we have an active transaction at this point, the master died while
      writing the transaction to the binary log, i.e. while flushing the binlog
      cache to the binlog. As the write was started, the transaction had been
      committed on the master, so we lack of information to replay this
      transaction on the slave; all we can do is stop with error.
1698 1699 1700 1701
      Note: this event could be sent by the master to inform us of the format
      of its binlog; in other words maybe it is not at its original place when
      it comes to us; we'll know this by checking log_pos ("artificial" events
      have log_pos == 0).
1702
    */
1703
    if (!artificial_event && (thd->options & OPTION_BEGIN))
1704
    {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1705 1706
      slave_print_error(rli, 0, "\
Rolling back unfinished transaction (no COMMIT or ROLLBACK) from relay log. \
monty@mysql.com's avatar
monty@mysql.com committed
1707
A probable cause is that the master died while writing the transaction to its \
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1708
binary log.");
1709 1710
      return(1);
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1711 1712
    break;

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1713
    /* 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1714 1715
       Now the older formats; in that case load_tmpdir is cleaned up by the I/O
       thread.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1716
    */
1717 1718 1719 1720 1721 1722 1723 1724 1725 1726
  case 1:
    if (strncmp(rli->relay_log.description_event_for_exec->server_version, 
                "3.23.57",7) >= 0 && created)
    {
      /*
        Can distinguish, based on the value of 'created': this event was
        generated at master startup.
      */
      close_temporary_tables(thd);
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1727
    /*
1728 1729 1730
      Otherwise, can't distinguish a Start_log_event generated at
      master startup and one generated by master FLUSH LOGS, so cannot
      be sure temp tables have to be dropped. So do nothing.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1731 1732 1733 1734
    */
    break;
  default:
    /* this case is impossible */
1735
    DBUG_RETURN(1);
nick@mysql.com's avatar
nick@mysql.com committed
1736
  }
1737
  DBUG_RETURN(Log_event::exec_event(rli));
1738
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1739
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
1740

1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984
/***************************************************************************
       Format_description_log_event methods
****************************************************************************/

/*
  Format_description_log_event 1st ctor.

  SYNOPSIS
    Format_description_log_event::Format_description_log_event
      binlog_version          	  the binlog version for which we want to build
                                  an event. Can be 1 (=MySQL 3.23), 3 (=4.0.x
                                  x>=2 and 4.1) or 4 (MySQL 5.0). Note that the
                                  old 4.0 (binlog version 2) is not supported;
                                  it should not be used for replication with
                                  5.0.

  DESCRIPTION
    Ctor. Can be used to create the event to write to the binary log (when the
    server starts or when FLUSH LOGS), or to create artificial events to parse
    binlogs from MySQL 3.23 or 4.x.
    When in a client, only the 2nd use is possible.

  TODO
    Update this code with the new event for LOAD DATA, once they are pushed (in
    4.1 or 5.0). If it's in 5.0, only the "case 4" block should be updated.

*/

Format_description_log_event::
Format_description_log_event(uint8 binlog_ver,
                             const char* server_ver) 
  :Start_log_event_v3()
{
  created= when;
  binlog_version= binlog_ver;
  switch (binlog_ver) {
  case 4: /* MySQL 5.0 */
    memcpy(server_version, ::server_version, ST_SERVER_VER_LEN);
    common_header_len= LOG_EVENT_HEADER_LEN;
    number_of_event_types= LOG_EVENT_TYPES;
    /* we'll catch my_malloc() error in is_valid() */
    post_header_len=(uint8*) my_malloc(number_of_event_types*sizeof(uint8),
                                       MYF(0)); 
    /*
      This long list of assignments is not beautiful, but I see no way to
      make it nicer, as the right members are #defines, not array members, so
      it's impossible to write a loop.
    */
    if (post_header_len)
    {
      post_header_len[START_EVENT_V3-1]= START_V3_HEADER_LEN;
      post_header_len[QUERY_EVENT-1]= QUERY_HEADER_LEN;
      post_header_len[STOP_EVENT-1]= 0;
      post_header_len[ROTATE_EVENT-1]= ROTATE_HEADER_LEN;
      post_header_len[INTVAR_EVENT-1]= 0;
      post_header_len[LOAD_EVENT-1]= LOAD_HEADER_LEN;
      post_header_len[SLAVE_EVENT-1]= 0;
      post_header_len[CREATE_FILE_EVENT-1]= CREATE_FILE_HEADER_LEN;
      post_header_len[APPEND_BLOCK_EVENT-1]= APPEND_BLOCK_HEADER_LEN;
      post_header_len[EXEC_LOAD_EVENT-1]= EXEC_LOAD_HEADER_LEN;
      post_header_len[DELETE_FILE_EVENT-1]= DELETE_FILE_HEADER_LEN;
      post_header_len[NEW_LOAD_EVENT-1]= post_header_len[LOAD_EVENT-1];
      post_header_len[RAND_EVENT-1]= 0;
      post_header_len[USER_VAR_EVENT-1]= 0;
      post_header_len[FORMAT_DESCRIPTION_EVENT-1]= FORMAT_DESCRIPTION_HEADER_LEN;
    }
    break;

  case 1: /* 3.23 */
  case 3: /* 4.0.x x>=2 */
    /*
      We build an artificial (i.e. not sent by the master) event, which
      describes what those old master versions send.
    */
    if (binlog_ver==1)
      strmov(server_version, server_ver ? server_ver : "3.23");
    else
      strmov(server_version, server_ver ? server_ver : "4.0");
    common_header_len= binlog_ver==1 ? OLD_HEADER_LEN :
      LOG_EVENT_MINIMAL_HEADER_LEN;  
    /*
      The first new event in binlog version 4 is Format_desc. So any event type
      after that does not exist in older versions. We use the events known by
      version 3, even if version 1 had only a subset of them (this is not a
      problem: it uses a few bytes for nothing but unifies code; it does not
      make the slave detect less corruptions).
    */
    number_of_event_types= FORMAT_DESCRIPTION_EVENT - 1;
    post_header_len=(uint8*) my_malloc(number_of_event_types*sizeof(uint8),
                                       MYF(0)); 
    if (post_header_len)
    {
      post_header_len[START_EVENT_V3-1]= START_V3_HEADER_LEN;
      post_header_len[QUERY_EVENT-1]= QUERY_HEADER_MINIMAL_LEN;
      post_header_len[STOP_EVENT-1]= 0;
      post_header_len[ROTATE_EVENT-1]= (binlog_ver==1) ? 0 : ROTATE_HEADER_LEN;
      post_header_len[INTVAR_EVENT-1]= 0;
      post_header_len[LOAD_EVENT-1]= LOAD_HEADER_LEN;
      post_header_len[SLAVE_EVENT-1]= 0;
      post_header_len[CREATE_FILE_EVENT-1]= CREATE_FILE_HEADER_LEN;
      post_header_len[APPEND_BLOCK_EVENT-1]= APPEND_BLOCK_HEADER_LEN;
      post_header_len[EXEC_LOAD_EVENT-1]= EXEC_LOAD_HEADER_LEN;
      post_header_len[DELETE_FILE_EVENT-1]= DELETE_FILE_HEADER_LEN;
      post_header_len[NEW_LOAD_EVENT-1]= post_header_len[LOAD_EVENT-1];
      post_header_len[RAND_EVENT-1]= 0;
      post_header_len[USER_VAR_EVENT-1]= 0;
    }
    break;
  default: /* Includes binlog version 2 i.e. 4.0.x x<=1 */
    post_header_len= 0; /* will make is_valid() fail */
    break;
  }
}


/*
  The problem with this constructor is that the fixed header may have a
  length different from this version, but we don't know this length as we
  have not read the Format_description_log_event which says it, yet. This
  length is in the post-header of the event, but we don't know where the
  post-header starts. 
  So this type of event HAS to:
  - either have the header's length at the beginning (in the header, at a
  fixed position which will never be changed), not in the post-header. That
  would make the header be "shifted" compared to other events.
  - or have a header of size LOG_EVENT_MINIMAL_HEADER_LEN (19), in all future
  versions, so that we know for sure.
  I (Guilhem) chose the 2nd solution. Rotate has the same constraint (because
  it is sent before Format_description_log_event).
*/

Format_description_log_event::
Format_description_log_event(const char* buf,
                             uint event_len,
                             const
                             Format_description_log_event*
                             description_event) 
  :Start_log_event_v3(buf, description_event)
{
  DBUG_ENTER("Format_description_log_event::Format_description_log_event(char*,...)");
  buf+= LOG_EVENT_MINIMAL_HEADER_LEN;
  if ((common_header_len=buf[ST_COMMON_HEADER_LEN_OFFSET]) < OLD_HEADER_LEN)
    DBUG_VOID_RETURN; /* sanity check */
  number_of_event_types=
    event_len-(LOG_EVENT_MINIMAL_HEADER_LEN+ST_COMMON_HEADER_LEN_OFFSET+1);
  DBUG_PRINT("info", ("common_header_len=%d number_of_event_types=%d",
                      common_header_len, number_of_event_types)); 
  /* If alloc fails, we'll detect it in is_valid() */
  post_header_len= (uint8*) my_memdup((byte*)buf+ST_COMMON_HEADER_LEN_OFFSET+1,
                                      number_of_event_types*
                                      sizeof(*post_header_len),
                                      MYF(0));  
  DBUG_VOID_RETURN;
}


bool Format_description_log_event::write(IO_CACHE* file)
{
  /*
    We don't call Start_log_event_v3::write() because this would make 2
    my_b_safe_write().
  */
  byte buff[FORMAT_DESCRIPTION_HEADER_LEN];
  int2store(buff + ST_BINLOG_VER_OFFSET,binlog_version);
  memcpy((char*) buff + ST_SERVER_VER_OFFSET,server_version,ST_SERVER_VER_LEN);
  int4store(buff + ST_CREATED_OFFSET,created);
  buff[ST_COMMON_HEADER_LEN_OFFSET]= LOG_EVENT_HEADER_LEN;    
  memcpy((char*) buff+ST_COMMON_HEADER_LEN_OFFSET+1, (byte*) post_header_len,
         LOG_EVENT_TYPES);
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, buff, sizeof(buff)));
}
  
/*
  SYNOPSIS
    Format_description_log_event::exec_event()
  
  IMPLEMENTATION
    Save the information which describes the binlog's format, to be able to
    read all coming events.
    Call Start_log_event_v3::exec_event().
*/

#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
int Format_description_log_event::exec_event(struct st_relay_log_info* rli)
{
  DBUG_ENTER("Format_description_log_event::exec_event");
  
  /* save the information describing this binlog */  
  delete rli->relay_log.description_event_for_exec;
  rli->relay_log.description_event_for_exec= this;

  /*
    If this event comes from ourselves, there is no cleaning task to perform,
    we don't call Start_log_event_v3::exec_event() (this was just to update the
    log's description event).
  */
  if (server_id == (uint32) ::server_id)
  {
    /*
      Do not modify rli->group_master_log_pos, as this event did not exist on
      the master. That is, just update the *relay log* coordinates; this is
      done by passing log_pos=0 to inc_group_relay_log_pos, like we do in
      Stop_log_event::exec_event().
      If in a transaction, don't touch group_* coordinates.
    */
    if (thd->options & OPTION_BEGIN)
      rli->inc_event_relay_log_pos();
    else
    {
      rli->inc_group_relay_log_pos(0);
      flush_relay_log_info(rli);
    }
    DBUG_RETURN(0);
  }

  /*
    If the event was not requested by the slave i.e. the master sent it while
    the slave asked for a position >4, the event will make
    rli->group_master_log_pos advance. Say that the slave asked for position
    1000, and the Format_desc event's end is 95. Then in the beginning of
    replication rli->group_master_log_pos will be 0, then 95, then jump to first
    really asked event (which is >95). So this is ok.
  */
  DBUG_RETURN(Start_log_event_v3::exec_event(rli));
}
#endif

  /**************************************************************************
  	Load_log_event methods
   General note about Load_log_event: the binlogging of LOAD DATA INFILE is
   going to be changed in 5.0 (or maybe in 4.1; not decided yet).
   However, the 5.0 slave could still have to read such events (from a 4.x
   master), convert them (which just means maybe expand the header, when 5.0
   servers have a UID in events) (remember that whatever is after the header
   will be like in 4.x, as this event's format is not modified in 5.0 as we
   will use new types of events to log the new LOAD DATA INFILE features).
   To be able to read/convert, we just need to not assume that the common
   header is of length LOG_EVENT_HEADER_LEN (we must use the description
   event).
   Note that I (Guilhem) manually tested replication of a big LOAD DATA INFILE
   between 3.23 and 5.0, and between 4.0 and 5.0, and it works fine (and the
   positions displayed in SHOW SLAVE STATUS then are fine too).
  **************************************************************************/
1985

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1986
/*
1987
  Load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1988
*/
1989

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1990
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1991
void Load_log_event::pack_info(Protocol *protocol)
1992
{
1993 1994 1995 1996 1997 1998
  char *buf, *pos;
  uint buf_len;

  buf_len= 
    5 + db_len + 3 +                        // "use DB; "
    18 + fname_len + 2 +                    // "LOAD DATA INFILE 'file''"
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1999
    7 +					    // LOCAL
2000
    9 +                                     // " REPLACE or IGNORE "
2001
    13 + table_name_len*2 +                 // "INTO TABLE `table`"
2002 2003 2004 2005 2006 2007 2008 2009
    21 + sql_ex.field_term_len*4 + 2 +      // " FIELDS TERMINATED BY 'str'"
    23 + sql_ex.enclosed_len*4 + 2 +        // " OPTIONALLY ENCLOSED BY 'str'"
    12 + sql_ex.escaped_len*4 + 2 +         // " ESCAPED BY 'str'"
    21 + sql_ex.line_term_len*4 + 2 +       // " FIELDS TERMINATED BY 'str'"
    19 + sql_ex.line_start_len*4 + 2 +      // " LINES STARTING BY 'str'" 
    15 + 22 +                               // " IGNORE xxx  LINES" 
    3 + (num_fields-1)*2 + field_block_len; // " (field1, field2, ...)"

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2010
  if (!(buf= my_malloc(buf_len, MYF(MY_WME))))
2011 2012
    return;
  pos= buf;
2013
  if (db && db_len)
2014
  {
2015 2016
    pos= strmov(pos, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2017
    pos= strmov(pos+db_len, "`; ");
2018
  }
2019

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2020 2021 2022 2023
  pos= strmov(pos, "LOAD DATA ");
  if (check_fname_outside_temp_buf())
    pos= strmov(pos, "LOCAL ");
  pos= strmov(pos, "INFILE '");
2024
  memcpy(pos, fname, fname_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2025
  pos= strmov(pos+fname_len, "' ");
2026

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2027
  if (sql_ex.opt_flags & REPLACE_FLAG)
2028
    pos= strmov(pos, " REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2029
  else if (sql_ex.opt_flags & IGNORE_FLAG)
2030 2031
    pos= strmov(pos, " IGNORE ");

2032
  pos= strmov(pos ,"INTO TABLE `");
2033 2034 2035
  memcpy(pos, table_name, table_name_len);
  pos+= table_name_len;

monty@mysql.com's avatar
monty@mysql.com committed
2036
  /* We have to create all optinal fields as the default is not empty */
2037
  pos= strmov(pos, "` FIELDS TERMINATED BY ");
monty@mysql.com's avatar
monty@mysql.com committed
2038 2039 2040 2041 2042
  pos= pretty_print_str(pos, sql_ex.field_term, sql_ex.field_term_len);
  if (sql_ex.opt_flags & OPT_ENCLOSED_FLAG)
    pos= strmov(pos, " OPTIONALLY ");
  pos= strmov(pos, " ENCLOSED BY ");
  pos= pretty_print_str(pos, sql_ex.enclosed, sql_ex.enclosed_len);
2043

monty@mysql.com's avatar
monty@mysql.com committed
2044 2045
  pos= strmov(pos, " ESCAPED BY ");
  pos= pretty_print_str(pos, sql_ex.escaped, sql_ex.escaped_len);
2046

monty@mysql.com's avatar
monty@mysql.com committed
2047 2048
  pos= strmov(pos, " LINES TERMINATED BY ");
  pos= pretty_print_str(pos, sql_ex.line_term, sql_ex.line_term_len);
2049 2050
  if (sql_ex.line_start_len)
  {
2051
    pos= strmov(pos, " STARTING BY ");
2052
    pos= pretty_print_str(pos, sql_ex.line_start, sql_ex.line_start_len);
2053
  }
2054

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2055
  if ((long) skip_lines > 0)
2056 2057
  {
    pos= strmov(pos, " IGNORE ");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2058
    pos= longlong10_to_str((longlong) skip_lines, pos, 10);
2059 2060
    pos= strmov(pos," LINES ");    
  }
2061 2062 2063 2064

  if (num_fields)
  {
    uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2065
    const char *field= fields;
2066
    pos= strmov(pos, " (");
2067 2068 2069
    for (i = 0; i < num_fields; i++)
    {
      if (i)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2070 2071 2072 2073
      {
        *pos++= ' ';
        *pos++= ',';
      }
2074
      memcpy(pos, field, field_lens[i]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2075 2076
      pos+=   field_lens[i];
      field+= field_lens[i]  + 1;
2077
    }
2078
    *pos++= ')';
2079
  }
2080

2081
  protocol->store(buf, pos-buf, &my_charset_bin);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2082
  my_free(buf, MYF(0));
2083
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2084
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
2085

2086

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2087
/*
2088
  Load_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2089
*/
2090

2091
bool Load_log_event::write_data_header(IO_CACHE* file)
2092
{
2093
  char buf[LOAD_HEADER_LEN];
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2094
  int4store(buf + L_THREAD_ID_OFFSET, slave_proxy_id);
2095 2096 2097 2098 2099
  int4store(buf + L_EXEC_TIME_OFFSET, exec_time);
  int4store(buf + L_SKIP_LINES_OFFSET, skip_lines);
  buf[L_TBL_LEN_OFFSET] = (char)table_name_len;
  buf[L_DB_LEN_OFFSET] = (char)db_len;
  int4store(buf + L_NUM_FIELDS_OFFSET, num_fields);
2100
  return my_b_safe_write(file, (byte*)buf, LOAD_HEADER_LEN) != 0;
2101
}
2102

2103

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2104
/*
2105
  Load_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2106
*/
2107

2108
bool Load_log_event::write_data_body(IO_CACHE* file)
2109
{
2110 2111 2112
  if (sql_ex.write_data(file))
    return 1;
  if (num_fields && fields && field_lens)
2113
  {
2114 2115 2116
    if (my_b_safe_write(file, (byte*)field_lens, num_fields) ||
	my_b_safe_write(file, (byte*)fields, field_block_len))
      return 1;
2117
  }
2118 2119 2120
  return (my_b_safe_write(file, (byte*)table_name, table_name_len + 1) ||
	  my_b_safe_write(file, (byte*)db, db_len + 1) ||
	  my_b_safe_write(file, (byte*)fname, fname_len));
2121 2122
}

2123

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2124
/*
2125
  Load_log_event::Load_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2126
*/
2127

2128
#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2129 2130 2131
Load_log_event::Load_log_event(THD *thd_arg, sql_exchange *ex,
			       const char *db_arg, const char *table_name_arg,
			       List<Item> &fields_arg,
2132
			       enum enum_duplicates handle_dup,
2133
			       bool ignore, bool using_trans)
2134 2135 2136
  :Log_event(thd_arg, !thd_arg->tmp_table_used ?
	     0 : LOG_EVENT_THREAD_SPECIFIC_F, using_trans),
   thread_id(thd_arg->thread_id),
2137
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2138 2139
   num_fields(0),fields(0),
   field_lens(0),field_block_len(0),
2140
   table_name(table_name_arg ? table_name_arg : ""),
2141
   db(db_arg), fname(ex->file_name), local_fname(FALSE)
2142 2143 2144
{
  time_t end_time;
  time(&end_time);
2145
  exec_time = (ulong) (end_time  - thd_arg->start_time);
2146 2147 2148
  /* db can never be a zero pointer in 4.0 */
  db_len = (uint32) strlen(db);
  table_name_len = (uint32) strlen(table_name);
2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161
  fname_len = (fname) ? (uint) strlen(fname) : 0;
  sql_ex.field_term = (char*) ex->field_term->ptr();
  sql_ex.field_term_len = (uint8) ex->field_term->length();
  sql_ex.enclosed = (char*) ex->enclosed->ptr();
  sql_ex.enclosed_len = (uint8) ex->enclosed->length();
  sql_ex.line_term = (char*) ex->line_term->ptr();
  sql_ex.line_term_len = (uint8) ex->line_term->length();
  sql_ex.line_start = (char*) ex->line_start->ptr();
  sql_ex.line_start_len = (uint8) ex->line_start->length();
  sql_ex.escaped = (char*) ex->escaped->ptr();
  sql_ex.escaped_len = (uint8) ex->escaped->length();
  sql_ex.opt_flags = 0;
  sql_ex.cached_new_format = -1;
2162
    
2163
  if (ex->dumpfile)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2164
    sql_ex.opt_flags|= DUMPFILE_FLAG;
2165
  if (ex->opt_enclosed)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2166
    sql_ex.opt_flags|= OPT_ENCLOSED_FLAG;
2167

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2168
  sql_ex.empty_flags= 0;
2169

2170
  switch (handle_dup) {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2171
  case DUP_REPLACE:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2172
    sql_ex.opt_flags|= REPLACE_FLAG;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2173 2174 2175 2176
    break;
  case DUP_UPDATE:				// Impossible here
  case DUP_ERROR:
    break;	
2177
  }
2178 2179
  if (ignore)
    sql_ex.opt_flags|= IGNORE_FLAG;
2180

2181 2182 2183 2184 2185 2186 2187 2188 2189 2190
  if (!ex->field_term->length())
    sql_ex.empty_flags |= FIELD_TERM_EMPTY;
  if (!ex->enclosed->length())
    sql_ex.empty_flags |= ENCLOSED_EMPTY;
  if (!ex->line_term->length())
    sql_ex.empty_flags |= LINE_TERM_EMPTY;
  if (!ex->line_start->length())
    sql_ex.empty_flags |= LINE_START_EMPTY;
  if (!ex->escaped->length())
    sql_ex.empty_flags |= ESCAPED_EMPTY;
2191
    
2192
  skip_lines = ex->skip_lines;
2193

2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204
  List_iterator<Item> li(fields_arg);
  field_lens_buf.length(0);
  fields_buf.length(0);
  Item* item;
  while ((item = li++))
  {
    num_fields++;
    uchar len = (uchar) strlen(item->name);
    field_block_len += len + 1;
    fields_buf.append(item->name, len + 1);
    field_lens_buf.append((char*)&len, 1);
2205 2206
  }

2207 2208 2209
  field_lens = (const uchar*)field_lens_buf.ptr();
  fields = fields_buf.ptr();
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2210
#endif /* !MYSQL_CLIENT */
2211

2212

2213
/*
2214
  Load_log_event::Load_log_event()
2215

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2216 2217 2218
  NOTE
    The caller must do buf[event_len] = 0 before he starts using the
    constructed event.
2219 2220
*/

2221 2222 2223 2224
Load_log_event::Load_log_event(const char *buf, uint event_len,
                               const Format_description_log_event *description_event)
  :Log_event(buf, description_event), num_fields(0), fields(0),
   field_lens(0),field_block_len(0),
monty@mysql.com's avatar
monty@mysql.com committed
2225
   table_name(0), db(0), fname(0), local_fname(FALSE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2226
{
monty@mysql.com's avatar
monty@mysql.com committed
2227
  DBUG_ENTER("Load_log_event");
2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239
  /*
    I (Guilhem) manually tested replication of LOAD DATA INFILE for 3.23->5.0,
    4.0->5.0 and 5.0->5.0 and it works.
  */
  if (event_len)
    copy_log_event(buf, event_len,
                   ((buf[EVENT_TYPE_OFFSET] == LOAD_EVENT) ?
                    LOAD_HEADER_LEN + 
                    description_event->common_header_len :
                    LOAD_HEADER_LEN + LOG_EVENT_HEADER_LEN),
                   description_event);
  /* otherwise it's a derived class, will call copy_log_event() itself */
monty@mysql.com's avatar
monty@mysql.com committed
2240
  DBUG_VOID_RETURN;
2241 2242
}

2243

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2244
/*
2245
  Load_log_event::copy_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2246
*/
2247

2248
int Load_log_event::copy_log_event(const char *buf, ulong event_len,
2249 2250
                                   int body_offset,
                                   const Format_description_log_event *description_event)
2251
{
2252
  DBUG_ENTER("Load_log_event::copy_log_event");
2253
  uint data_len;
2254
  char* buf_end = (char*)buf + event_len;
2255 2256
  /* this is the beginning of the post-header */
  const char* data_head = buf + description_event->common_header_len;
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2257
  slave_proxy_id= thread_id= uint4korr(data_head + L_THREAD_ID_OFFSET);
2258 2259 2260 2261 2262
  exec_time = uint4korr(data_head + L_EXEC_TIME_OFFSET);
  skip_lines = uint4korr(data_head + L_SKIP_LINES_OFFSET);
  table_name_len = (uint)data_head[L_TBL_LEN_OFFSET];
  db_len = (uint)data_head[L_DB_LEN_OFFSET];
  num_fields = uint4korr(data_head + L_NUM_FIELDS_OFFSET);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2263
	  
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2264
  if ((int) event_len < body_offset)
monty@mysql.com's avatar
monty@mysql.com committed
2265
    DBUG_RETURN(1);
2266 2267 2268 2269
  /*
    Sql_ex.init() on success returns the pointer to the first byte after
    the sql_ex structure, which is the start of field lengths array.
  */
2270 2271 2272
  if (!(field_lens= (uchar*)sql_ex.init((char*)buf + body_offset,
                                        buf_end,
                                        buf[EVENT_TYPE_OFFSET] != LOAD_EVENT)))
monty@mysql.com's avatar
monty@mysql.com committed
2273
    DBUG_RETURN(1);
2274
  
2275
  data_len = event_len - body_offset;
2276
  if (num_fields > data_len) // simple sanity check against corruption
monty@mysql.com's avatar
monty@mysql.com committed
2277
    DBUG_RETURN(1);
2278
  for (uint i = 0; i < num_fields; i++)
2279
    field_block_len += (uint)field_lens[i] + 1;
2280

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2281 2282 2283 2284
  fields = (char*)field_lens + num_fields;
  table_name  = fields + field_block_len;
  db = table_name + table_name_len + 1;
  fname = db + db_len + 1;
2285 2286
  fname_len = strlen(fname);
  // null termination is accomplished by the caller doing buf[event_len]=0
2287 2288 2289 2290 2291 2292

  /*
    In 5.0 this event will have the same format, as we are planning to log LOAD
    DATA INFILE in a completely different way (as a plain-text query) since 4.1
    or 5.0 (Dmitri's WL#874)
  */
monty@mysql.com's avatar
monty@mysql.com committed
2293
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2294 2295 2296
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2297
/*
2298
  Load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2299
*/
2300 2301

#ifdef MYSQL_CLIENT
2302
void Load_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2303
{
2304
  print(file, short_form, last_event_info, 0);
2305 2306
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2307

2308
void Load_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info,
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2309
			   bool commented)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2310
{
monty@mysql.com's avatar
monty@mysql.com committed
2311
  DBUG_ENTER("Load_log_event::print");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2312 2313
  if (!short_form)
  {
2314
    print_header(file);
2315
    fprintf(file, "\tQuery\tthread_id=%ld\texec_time=%ld\n",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2316 2317 2318
	    thread_id, exec_time);
  }

2319
  bool different_db= 1;
2320
  if (db)
2321
  {
2322 2323 2324 2325 2326 2327
    /*
      If the database is different from the one of the previous statement, we
      need to print the "use" command, and we update the last_db.
      But if commented, the "use" is going to be commented so we should not
      update the last_db.
    */
2328
    if ((different_db= memcmp(last_event_info->db, db, db_len + 1)) &&
2329
        !commented)
2330
      memcpy(last_event_info->db, db, db_len + 1);
2331
  }
2332
  
2333
  if (db && db[0] && different_db)
2334 2335 2336
    fprintf(file, "%suse %s;\n", 
            commented ? "# " : "",
            db);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2337

2338 2339 2340
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
    fprintf(file,"%sSET @@session.pseudo_thread_id=%lu;\n",
            commented ? "# " : "", (ulong)thread_id);
2341 2342
  fprintf(file, "%sLOAD DATA ",
          commented ? "# " : "");
2343 2344
  if (check_fname_outside_temp_buf())
    fprintf(file, "LOCAL ");
2345
  fprintf(file, "INFILE '%-*s' ", fname_len, fname);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2346

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2347
  if (sql_ex.opt_flags & REPLACE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2348
    fprintf(file," REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2349
  else if (sql_ex.opt_flags & IGNORE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2350 2351
    fprintf(file," IGNORE ");
  
2352
  fprintf(file, "INTO TABLE `%s`", table_name);
monty@mysql.com's avatar
monty@mysql.com committed
2353 2354
  fprintf(file, " FIELDS TERMINATED BY ");
  pretty_print_str(file, sql_ex.field_term, sql_ex.field_term_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2355

monty@mysql.com's avatar
monty@mysql.com committed
2356 2357 2358 2359
  if (sql_ex.opt_flags & OPT_ENCLOSED_FLAG)
    fprintf(file," OPTIONALLY ");
  fprintf(file, " ENCLOSED BY ");
  pretty_print_str(file, sql_ex.enclosed, sql_ex.enclosed_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2360
     
monty@mysql.com's avatar
monty@mysql.com committed
2361 2362
  fprintf(file, " ESCAPED BY ");
  pretty_print_str(file, sql_ex.escaped, sql_ex.escaped_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2363
     
monty@mysql.com's avatar
monty@mysql.com committed
2364 2365 2366
  fprintf(file," LINES TERMINATED BY ");
  pretty_print_str(file, sql_ex.line_term, sql_ex.line_term_len);

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2367

2368
  if (sql_ex.line_start)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2369
  {
2370
    fprintf(file," STARTING BY ");
2371
    pretty_print_str(file, sql_ex.line_start, sql_ex.line_start_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2372
  }
2373 2374
  if ((long) skip_lines > 0)
    fprintf(file, " IGNORE %ld LINES", (long) skip_lines);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2375

2376 2377 2378 2379
  if (num_fields)
  {
    uint i;
    const char* field = fields;
2380 2381
    fprintf(file, " (");
    for (i = 0; i < num_fields; i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2382
    {
2383
      if (i)
2384 2385
	fputc(',', file);
      fprintf(file, field);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2386
	  
2387
      field += field_lens[i]  + 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2388
    }
2389 2390
    fputc(')', file);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2391 2392

  fprintf(file, ";\n");
monty@mysql.com's avatar
monty@mysql.com committed
2393
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2394
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2395
#endif /* MYSQL_CLIENT */
2396

2397

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2398
/*
2399
  Load_log_event::set_fields()
lars@mysql.com's avatar
lars@mysql.com committed
2400 2401 2402 2403 2404

  Note that this function can not use the member variable 
  for the database, since LOAD DATA INFILE on the slave
  can be for a different database than the current one.
  This is the reason for the affected_db argument to this method.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2405
*/
2406

2407
#ifndef MYSQL_CLIENT
lars@mysql.com's avatar
lars@mysql.com committed
2408 2409
void Load_log_event::set_fields(const char* affected_db, 
				List<Item> &field_list)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2410 2411
{
  uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2412
  const char* field = fields;
2413
  for (i= 0; i < num_fields; i++)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2414
  {
lars@mysql.com's avatar
lars@mysql.com committed
2415
    field_list.push_back(new Item_field(affected_db, table_name, field));
2416
    field+= field_lens[i]  + 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2417
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2418
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2419
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2420 2421


hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2422
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2423 2424
/*
  Does the data loading job when executing a LOAD DATA on the slave
2425

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2426 2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437 2438 2439
  SYNOPSIS
    Load_log_event::exec_event
      net  
      rli                             
      use_rli_only_for_errors	  - if set to 1, rli is provided to 
                                  Load_log_event::exec_event only for this 
				  function to have RPL_LOG_NAME and 
				  rli->last_slave_error, both being used by 
				  error reports. rli's position advancing
				  is skipped (done by the caller which is
				  Execute_load_log_event::exec_event).
				  - if set to 0, rli is provided for full use,
				  i.e. for error reports and position
				  advancing.
2440

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2441 2442 2443 2444 2445 2446 2447
  DESCRIPTION
    Does the data loading job when executing a LOAD DATA on the slave
 
  RETURN VALUE
    0           Success                                                 
    1    	Failure
*/
2448

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2449 2450
int Load_log_event::exec_event(NET* net, struct st_relay_log_info* rli, 
			       bool use_rli_only_for_errors)
2451
{
2452
  char *load_data_query= 0;
2453
  thd->db_length= db_len;
2454
  thd->db= (char *) rpl_filter->get_rewrite_db(db, &thd->db_length);
2455
  DBUG_ASSERT(thd->query == 0);
monty@mysql.com's avatar
monty@mysql.com committed
2456
  thd->query_length= 0;                         // Should not be needed
monty@mysql.com's avatar
monty@mysql.com committed
2457
  thd->query_error= 0;
monty@mysql.com's avatar
monty@mysql.com committed
2458
  clear_all_errors(thd, rli);
2459 2460 2461 2462
  /*
    Usually mysql_init_query() is called by mysql_parse(), but we need it here
    as the present method does not call mysql_parse().
  */
2463
  mysql_init_query(thd, 0, 0);
monty@mysql.com's avatar
monty@mysql.com committed
2464
  if (!use_rli_only_for_errors)
2465
  {
2466
    /* Saved for InnoDB, see comment in Query_log_event::exec_event() */
monty@mysql.com's avatar
monty@mysql.com committed
2467
    rli->future_group_master_log_pos= log_pos;
2468
    DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));
2469
  }
2470 2471
 
   /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482
    We test replicate_*_db rules. Note that we have already prepared the file
    to load, even if we are going to ignore and delete it now. So it is
    possible that we did a lot of disk writes for nothing. In other words, a
    big LOAD DATA INFILE on the master will still consume a lot of space on
    the slave (space in the relay log + space of temp files: twice the space
    of the file to load...) even if it will finally be ignored.
    TODO: fix this; this can be done by testing rules in
    Create_file_log_event::exec_event() and then discarding Append_block and
    al. Another way is do the filtering in the I/O thread (more efficient: no
    disk writes at all).
  */
2483
  if (rpl_filter->db_ok(thd->db))
2484
  {
2485 2486 2487 2488
    thd->set_time((time_t)when);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
    thd->query_id = query_id++;
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
2489 2490 2491 2492 2493 2494 2495
    /*
      Initing thd->row_count is not necessary in theory as this variable has no
      influence in the case of the slave SQL thread (it is used to generate a
      "data truncated" warning but which is absorbed and never gets to the
      error log); still we init it to avoid a Valgrind message.
    */
    mysql_reset_errors(thd);
2496 2497 2498 2499

    TABLE_LIST tables;
    bzero((char*) &tables,sizeof(tables));
    tables.db = thd->db;
2500
    tables.alias = tables.table_name = (char*) table_name;
2501
    tables.lock_type = TL_WRITE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2502
    tables.updating= 1;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2503

2504
    // the table will be opened in mysql_load    
2505
    if (rpl_filter->is_on() && !rpl_filter->tables_ok(thd->db, &tables))
2506 2507 2508 2509 2510 2511 2512 2513
    {
      // TODO: this is a bug - this needs to be moved to the I/O thread
      if (net)
        skip_load_data_infile(net);
    }
    else
    {
      char llbuff[22];
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2514
      enum enum_duplicates handle_dup;
2515
      bool ignore= 0;
2516 2517 2518 2519 2520
      /*
        Make a simplified LOAD DATA INFILE query, for the information of the
        user in SHOW PROCESSLIST. Note that db is known in the 'db' column.
      */
      if ((load_data_query= (char *) my_alloca(18 + strlen(fname) + 14 +
2521
                                               strlen(tables.table_name) + 8)))
2522 2523 2524
      {
        thd->query_length= (uint)(strxmov(load_data_query,
                                          "LOAD DATA INFILE '", fname,
2525
                                          "' INTO TABLE `", tables.table_name,
2526 2527 2528
                                          "` <...>", NullS) - load_data_query);
        thd->query= load_data_query;
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2529 2530
      if (sql_ex.opt_flags & REPLACE_FLAG)
	handle_dup= DUP_REPLACE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2531
      else if (sql_ex.opt_flags & IGNORE_FLAG)
2532 2533 2534 2535
      {
        ignore= 1;
        handle_dup= DUP_ERROR;
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2536
      else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2537
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2538
        /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2539
	  When replication is running fine, if it was DUP_ERROR on the
2540
          master then we could choose IGNORE here, because if DUP_ERROR
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2541
          suceeded on master, and data is identical on the master and slave,
2542
          then there should be no uniqueness errors on slave, so IGNORE is
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2543
          the same as DUP_ERROR. But in the unlikely case of uniqueness errors
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2544 2545 2546
          (because the data on the master and slave happen to be different
	  (user error or bug), we want LOAD DATA to print an error message on
	  the slave to discover the problem.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2547 2548

          If reading from net (a 3.23 master), mysql_load() will change this
2549
          to IGNORE.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2550 2551
        */
        handle_dup= DUP_ERROR;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2552
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2553

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2554
      sql_exchange ex((char*)fname, sql_ex.opt_flags & DUMPFILE_FLAG);
2555 2556 2557 2558 2559
      String field_term(sql_ex.field_term,sql_ex.field_term_len,log_cs);
      String enclosed(sql_ex.enclosed,sql_ex.enclosed_len,log_cs);
      String line_term(sql_ex.line_term,sql_ex.line_term_len,log_cs);
      String line_start(sql_ex.line_start,sql_ex.line_start_len,log_cs);
      String escaped(sql_ex.escaped,sql_ex.escaped_len, log_cs);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2560 2561 2562 2563 2564
      ex.field_term= &field_term;
      ex.enclosed= &enclosed;
      ex.line_term= &line_term;
      ex.line_start= &line_start;
      ex.escaped= &escaped;
2565 2566 2567 2568 2569 2570

      ex.opt_enclosed = (sql_ex.opt_flags & OPT_ENCLOSED_FLAG);
      if (sql_ex.empty_flags & FIELD_TERM_EMPTY)
	ex.field_term->length(0);

      ex.skip_lines = skip_lines;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2571
      List<Item> field_list;
lars@mysql.com's avatar
lars@mysql.com committed
2572
      set_fields(thd->db,field_list);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2573
      thd->variables.pseudo_thread_id= thread_id;
2574 2575 2576 2577 2578 2579 2580 2581 2582
      if (net)
      {
	// mysql_load will use thd->net to read the file
	thd->net.vio = net->vio;
	/*
	  Make sure the client does not get confused about the packet sequence
	*/
	thd->net.pkt_nr = net->pkt_nr;
      }
monty@mysql.com's avatar
monty@mysql.com committed
2583 2584
      if (mysql_load(thd, &ex, &tables, field_list, handle_dup, ignore,
                     net != 0, TL_WRITE))
2585 2586
	thd->query_error = 1;
      if (thd->cuted_fields)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2587
      {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2588
	/* log_pos is the position of the LOAD event in the master log */
lars@mysql.com's avatar
lars@mysql.com committed
2589 2590 2591 2592 2593 2594 2595
        sql_print_warning("Slave: load data infile on table '%s' at "
                          "log position %s in log '%s' produced %ld "
                          "warning(s). Default database: '%s'",
                          (char*) table_name,
                          llstr(log_pos,llbuff), RPL_LOG_NAME, 
                          (ulong) thd->cuted_fields,
                          print_slave_db_safe(thd->db));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2596
      }
2597 2598 2599
      if (net)
        net->pkt_nr= thd->net.pkt_nr;
    }
2600 2601
  }
  else
2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612
  {
    /*
      We will just ask the master to send us /dev/null if we do not
      want to load the data.
      TODO: this a bug - needs to be done in I/O thread
    */
    if (net)
      skip_load_data_infile(net);
  }
	    
  thd->net.vio = 0; 
2613
  char *save_db= thd->db;
2614
  VOID(pthread_mutex_lock(&LOCK_thread_count));
2615
  thd->db= thd->catalog= 0;
2616
  thd->query= 0;
serg@serg.mylan's avatar
serg@serg.mylan committed
2617
  thd->query_length= thd->db_length= 0;
2618
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
2619
  close_thread_tables(thd);
2620 2621
  if (load_data_query)
    my_afree(load_data_query);
2622 2623
  if (thd->query_error)
  {
2624
    /* this err/sql_errno code is copy-paste from net_send_error() */
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2625 2626 2627 2628 2629 2630 2631 2632 2633
    const char *err;
    int sql_errno;
    if ((err=thd->net.last_error)[0])
      sql_errno=thd->net.last_errno;
    else
    {
      sql_errno=ER_UNKNOWN_ERROR;
      err=ER(sql_errno);       
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2634
    slave_print_error(rli,sql_errno,"\
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2635
Error '%s' running LOAD DATA INFILE on table '%s'. Default database: '%s'",
2636
		      err, (char*)table_name, print_slave_db_safe(save_db));
2637
    free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
2638 2639
    return 1;
  }
2640
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
2641
	    
2642
  if (thd->is_fatal_error)
2643
  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2644 2645
    slave_print_error(rli,ER_UNKNOWN_ERROR, "\
Fatal error running LOAD DATA INFILE on table '%s'. Default database: '%s'",
2646
		      (char*)table_name, print_slave_db_safe(save_db));
2647 2648 2649
    return 1;
  }

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2650
  return ( use_rli_only_for_errors ? 0 : Log_event::exec_event(rli) ); 
2651
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2652
#endif
2653 2654


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2655
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2656
  Rotate_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2657
**************************************************************************/
2658

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2659
/*
2660
  Rotate_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2661
*/
2662

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2663
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2664
void Rotate_log_event::pack_info(Protocol *protocol)
2665
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2666
  char buf1[256], buf[22];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2667
  String tmp(buf1, sizeof(buf1), log_cs);
2668
  tmp.length(0);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2669 2670 2671 2672
  tmp.append(new_log_ident, ident_len);
  tmp.append(";pos=");
  tmp.append(llstr(pos,buf));
  protocol->store(tmp.ptr(), tmp.length(), &my_charset_bin);
2673
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2674
#endif
2675

2676

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2677
/*
2678
  Rotate_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2679
*/
2680 2681

#ifdef MYSQL_CLIENT
2682
void Rotate_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2683
{
2684
  char buf[22];
2685

2686
  if (short_form)
2687 2688
    return;
  print_header(file);
2689 2690 2691
  fprintf(file, "\tRotate to ");
  if (new_log_ident)
    my_fwrite(file, (byte*) new_log_ident, (uint)ident_len, 
2692
              MYF(MY_NABP | MY_WME));
2693
  fprintf(file, "  pos: %s", llstr(pos, buf));
2694
  fputc('\n', file);
2695
  fflush(file);
2696
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2697
#endif /* MYSQL_CLIENT */
2698 2699


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2700
/*
2701
  Rotate_log_event::Rotate_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2702
*/
2703

2704 2705 2706
Rotate_log_event::Rotate_log_event(const char* buf, uint event_len,
                                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event) ,new_log_ident(NULL),alloced(0)
2707
{
2708
  DBUG_ENTER("Rotate_log_event::Rotate_log_event(char*,...)");
2709
  // The caller will ensure that event_len is what we have at EVENT_LEN_OFFSET
2710 2711
  uint8 header_size= description_event->common_header_len;
  uint8 post_header_len= description_event->post_header_len[ROTATE_EVENT-1];
2712 2713
  uint ident_offset;
  if (event_len < header_size)
monty@mysql.com's avatar
monty@mysql.com committed
2714
    DBUG_VOID_RETURN;
2715
  buf += header_size;
2716 2717 2718 2719
  pos = post_header_len ? uint8korr(buf + R_POS_OFFSET) : 4;
  ident_len = (uint)(event_len -
                     (header_size+post_header_len)); 
  ident_offset = post_header_len; 
2720 2721 2722 2723 2724
  set_if_smaller(ident_len,FN_REFLEN-1);
  if (!(new_log_ident= my_strdup_with_length((byte*) buf +
					     ident_offset,
					     (uint) ident_len,
					     MYF(MY_WME))))
monty@mysql.com's avatar
monty@mysql.com committed
2725
    DBUG_VOID_RETURN;
2726
  alloced = 1;
monty@mysql.com's avatar
monty@mysql.com committed
2727
  DBUG_VOID_RETURN;
2728
}
2729 2730


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2731
/*
2732
  Rotate_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2733
*/
2734

2735
bool Rotate_log_event::write(IO_CACHE* file)
2736
{
2737
  char buf[ROTATE_HEADER_LEN];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2738
  int8store(buf + R_POS_OFFSET, pos);
2739 2740 2741
  return (write_header(file, ROTATE_HEADER_LEN + ident_len) ||
          my_b_safe_write(file, (byte*)buf, ROTATE_HEADER_LEN) ||
          my_b_safe_write(file, (byte*)new_log_ident, (uint) ident_len));
2742 2743
}

2744

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2745
/*
2746 2747
  Rotate_log_event::exec_event()

2748
  Got a rotate log event from the master
2749

2750 2751 2752
  IMPLEMENTATION
    This is mainly used so that we can later figure out the logname and
    position for the master.
2753

2754
    We can't rotate the slave's BINlog as this will cause infinitive rotations
2755
    in a A -> B -> A setup.
2756
    The NOTES below is a wrong comment which will disappear when 4.1 is merged.
2757 2758 2759

  RETURN VALUES
    0	ok
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2760
*/
2761

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2762
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2763
int Rotate_log_event::exec_event(struct st_relay_log_info* rli)
2764
{
2765 2766 2767
  DBUG_ENTER("Rotate_log_event::exec_event");

  pthread_mutex_lock(&rli->data_lock);
2768
  rli->event_relay_log_pos= my_b_tell(rli->cur_log);
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
2769 2770 2771 2772 2773 2774 2775 2776 2777
  /*
    If we are in a transaction: the only normal case is when the I/O thread was
    copying a big transaction, then it was stopped and restarted: we have this
    in the relay log:
    BEGIN
    ...
    ROTATE (a fake one)
    ...
    COMMIT or ROLLBACK
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2778 2779
    In that case, we don't want to touch the coordinates which correspond to
    the beginning of the transaction.
2780 2781
    Starting from 5.0.0, there also are some rotates from the slave itself, in
    the relay log.
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
2782
  */
2783
  if (!(thd->options & OPTION_BEGIN))
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2784
  {
2785 2786
    memcpy(rli->group_master_log_name, new_log_ident, ident_len+1);
    rli->notify_group_master_log_name_update();
2787 2788 2789 2790 2791
    rli->group_master_log_pos= pos;
    rli->group_relay_log_pos= rli->event_relay_log_pos;
    DBUG_PRINT("info", ("group_master_log_name: '%s' group_master_log_pos:\
%lu",
                        rli->group_master_log_name,
2792
                        (ulong) rli->group_master_log_pos));
2793 2794 2795 2796 2797 2798 2799 2800 2801
    /*
      Reset thd->options and sql_mode, because this could be the signal of a
      master's downgrade from 5.0 to 4.0.
      However, no need to reset description_event_for_exec: indeed, if the next
      master is 5.0 (even 5.0.1) we will soon get a Format_desc; if the next
      master is 4.0 then the events are in the slave's format (conversion).
    */
    set_slave_thread_options(thd);
    thd->variables.sql_mode= global_system_variables.sql_mode;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2802
  }
2803 2804 2805 2806
  pthread_mutex_unlock(&rli->data_lock);
  pthread_cond_broadcast(&rli->data_cond);
  flush_relay_log_info(rli);
  DBUG_RETURN(0);
2807
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2808
#endif
2809 2810


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2811
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2812
	Intvar_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2813
**************************************************************************/
2814

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2815
/*
2816
  Intvar_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2817
*/
2818

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2819
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2820
void Intvar_log_event::pack_info(Protocol *protocol)
2821
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2822 2823
  char buf[256], *pos;
  pos= strmake(buf, get_var_type_name(), sizeof(buf)-23);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2824
  *pos++= '=';
2825
  pos= longlong10_to_str(val, pos, -10);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2826
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
2827
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2828
#endif
2829

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2830

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2831
/*
2832
  Intvar_log_event::Intvar_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2833
*/
2834

2835 2836 2837
Intvar_log_event::Intvar_log_event(const char* buf,
                                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
2838
{
2839 2840 2841
  buf+= description_event->common_header_len;
  type= buf[I_TYPE_OFFSET];
  val= uint8korr(buf+I_VAL_OFFSET);
2842 2843
}

2844

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2845
/*
2846
  Intvar_log_event::get_var_type_name()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2847
*/
2848 2849

const char* Intvar_log_event::get_var_type_name()
2850
{
2851 2852 2853 2854 2855
  switch(type) {
  case LAST_INSERT_ID_EVENT: return "LAST_INSERT_ID";
  case INSERT_ID_EVENT: return "INSERT_ID";
  default: /* impossible */ return "UNKNOWN";
  }
2856 2857
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2858

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2859
/*
2860
  Intvar_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2861
*/
2862

2863
bool Intvar_log_event::write(IO_CACHE* file)
2864
{
2865 2866
  byte buf[9];
  buf[I_TYPE_OFFSET]= (byte) type;
2867
  int8store(buf + I_VAL_OFFSET, val);
2868 2869
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
2870 2871
}

2872

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2873
/*
2874
  Intvar_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2875
*/
2876 2877

#ifdef MYSQL_CLIENT
2878 2879
void Intvar_log_event::print(FILE* file, bool short_form,
                             LAST_EVENT_INFO* last_event_info)
2880
{
2881 2882 2883
  char llbuff[22];
  const char *msg;
  LINT_INIT(msg);
2884

2885 2886 2887 2888 2889
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tIntvar\n");
  }
2890

2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901
  fprintf(file, "SET ");
  switch (type) {
  case LAST_INSERT_ID_EVENT:
    msg="LAST_INSERT_ID";
    break;
  case INSERT_ID_EVENT:
    msg="INSERT_ID";
    break;
  }
  fprintf(file, "%s=%s;\n", msg, llstr(val,llbuff));
  fflush(file);
2902
}
2903
#endif
2904

2905

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2906
/*
2907
  Intvar_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2908
*/
2909

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2910
#if defined(HAVE_REPLICATION)&& !defined(MYSQL_CLIENT)
2911
int Intvar_log_event::exec_event(struct st_relay_log_info* rli)
2912
{
2913 2914 2915 2916 2917 2918 2919 2920 2921
  switch (type) {
  case LAST_INSERT_ID_EVENT:
    thd->last_insert_id_used = 1;
    thd->last_insert_id = val;
    break;
  case INSERT_ID_EVENT:
    thd->next_insert_id = val;
    break;
  }
2922
  rli->inc_event_relay_log_pos();
2923
  return 0;
2924
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2925
#endif
2926

2927

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2928
/**************************************************************************
2929
  Rand_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2930
**************************************************************************/
2931

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2932
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2933
void Rand_log_event::pack_info(Protocol *protocol)
2934
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2935 2936 2937 2938 2939
  char buf1[256], *pos;
  pos= strmov(buf1,"rand_seed1=");
  pos= int10_to_str((long) seed1, pos, 10);
  pos= strmov(pos, ",rand_seed2=");
  pos= int10_to_str((long) seed2, pos, 10);
2940
  protocol->store(buf1, (uint) (pos-buf1), &my_charset_bin);
2941
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2942
#endif
2943 2944


2945 2946 2947
Rand_log_event::Rand_log_event(const char* buf,
                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
2948
{
2949 2950 2951
  buf+= description_event->common_header_len;
  seed1= uint8korr(buf+RAND_SEED1_OFFSET);
  seed2= uint8korr(buf+RAND_SEED2_OFFSET);
2952 2953
}

2954

2955
bool Rand_log_event::write(IO_CACHE* file)
2956
{
2957
  byte buf[16];
2958 2959
  int8store(buf + RAND_SEED1_OFFSET, seed1);
  int8store(buf + RAND_SEED2_OFFSET, seed2);
2960 2961
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
2962
}
2963

2964 2965

#ifdef MYSQL_CLIENT
2966
void Rand_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2967
{
2968
  char llbuff[22],llbuff2[22];
2969
  if (!short_form)
2970
  {
2971 2972
    print_header(file);
    fprintf(file, "\tRand\n");
2973
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2974
  fprintf(file, "SET @@RAND_SEED1=%s, @@RAND_SEED2=%s;\n",
2975
	  llstr(seed1, llbuff),llstr(seed2, llbuff2));
2976
  fflush(file);
2977
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2978
#endif /* MYSQL_CLIENT */
2979

2980

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2981
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2982
int Rand_log_event::exec_event(struct st_relay_log_info* rli)
2983
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2984 2985
  thd->rand.seed1= (ulong) seed1;
  thd->rand.seed2= (ulong) seed2;
2986
  rli->inc_event_relay_log_pos();
2987 2988
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2989
#endif /* !MYSQL_CLIENT */
2990

2991

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2992
/**************************************************************************
2993
  User_var_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2994
**************************************************************************/
2995

2996
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2997 2998 2999
void User_var_log_event::pack_info(Protocol* protocol)
{
  char *buf= 0;
3000
  uint val_offset= 4 + name_len;
3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015
  uint event_len= val_offset;

  if (is_null)
  {
    buf= my_malloc(val_offset + 5, MYF(MY_WME));
    strmov(buf + val_offset, "NULL");
    event_len= val_offset + 4;
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      double real_val;
      float8get(real_val, val);
      buf= my_malloc(val_offset + FLOATING_POINT_BUFFER, MYF(MY_WME));
3016 3017
      event_len+= my_sprintf(buf + val_offset,
			     (buf + val_offset, "%.14g", real_val));
3018 3019 3020 3021 3022 3023
      break;
    case INT_RESULT:
      buf= my_malloc(val_offset + 22, MYF(MY_WME));
      event_len= longlong10_to_str(uint8korr(val), buf + val_offset,-10)-buf;
      break;
    case STRING_RESULT:
3024 3025 3026 3027 3028 3029 3030 3031 3032 3033
      /* 15 is for 'COLLATE' and other chars */
      buf= my_malloc(event_len+val_len*2+1+2*MY_CS_NAME_SIZE+15, MYF(MY_WME));
      CHARSET_INFO *cs;
      if (!(cs= get_charset(charset_number, MYF(0))))
      {
        strmov(buf+val_offset, "???");
        event_len+= 3;
      }
      else
      {
3034 3035 3036
        char *p= strxmov(buf + val_offset, "_", cs->csname, " ", NullS);
        p= str_to_hex(p, val, val_len);
        p= strxmov(p, " COLLATE ", cs->name, NullS);
3037 3038
        event_len= p-buf;
      }
3039
      break;
3040
    case ROW_RESULT:
3041
    default:
3042 3043 3044 3045 3046
      DBUG_ASSERT(1);
      return;
    }
  }
  buf[0]= '@';
3047 3048 3049 3050
  buf[1]= '`';
  buf[2+name_len]= '`';
  buf[3+name_len]= '=';
  memcpy(buf+2, name, name_len);
3051
  protocol->store(buf, event_len, &my_charset_bin);
3052 3053
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3054
#endif /* !MYSQL_CLIENT */
3055 3056


3057 3058 3059 3060
User_var_log_event::
User_var_log_event(const char* buf,
                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3061
{
3062
  buf+= description_event->common_header_len;
3063 3064
  name_len= uint4korr(buf);
  name= (char *) buf + UV_NAME_LEN_SIZE;
3065 3066
  buf+= UV_NAME_LEN_SIZE + name_len;
  is_null= (bool) *buf;
3067 3068 3069
  if (is_null)
  {
    type= STRING_RESULT;
3070
    charset_number= my_charset_bin.number;
3071 3072 3073 3074 3075
    val_len= 0;
    val= 0;  
  }
  else
  {
3076 3077 3078
    type= (Item_result) buf[UV_VAL_IS_NULL];
    charset_number= uint4korr(buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE);
    val_len= uint4korr(buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE + 
3079
		       UV_CHARSET_NUMBER_SIZE);
3080 3081
    val= (char *) (buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE +
		   UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE);
3082 3083 3084 3085
  }
}


3086
bool User_var_log_event::write(IO_CACHE* file)
3087 3088 3089 3090
{
  char buf[UV_NAME_LEN_SIZE];
  char buf1[UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE + 
	    UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE];
3091 3092
  char buf2[8], *pos= buf2;
  uint buf1_length;
3093
  ulong event_length;
3094

3095
  int4store(buf, name_len);
3096 3097 3098 3099 3100 3101 3102
  
  if ((buf1[0]= is_null))
  {
    buf1_length= 1;
    val_len= 0;
  }    
  else
3103 3104 3105 3106
  {
    buf1[1]= type;
    int4store(buf1 + 2, charset_number);
    int4store(buf1 + 2 + UV_CHARSET_NUMBER_SIZE, val_len);
3107
    buf1_length= 10;
3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118

    switch (type) {
    case REAL_RESULT:
      float8store(buf2, *(double*) val);
      break;
    case INT_RESULT:
      int8store(buf2, *(longlong*) val);
      break;
    case STRING_RESULT:
      pos= val;
      break;
3119
    case ROW_RESULT:
3120
    default:
3121 3122 3123 3124
      DBUG_ASSERT(1);
      return 0;
    }
  }
3125 3126 3127 3128 3129 3130

  /* Length of the whole event */
  event_length= sizeof(buf)+ name_len + buf1_length + val_len;

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) buf, sizeof(buf))   ||
3131 3132 3133
	  my_b_safe_write(file, (byte*) name, name_len)     ||
	  my_b_safe_write(file, (byte*) buf1, buf1_length) ||
	  my_b_safe_write(file, (byte*) pos, val_len));
3134 3135
}

3136

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3137
/*
3138
  User_var_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3139
*/
3140 3141

#ifdef MYSQL_CLIENT
3142
void User_var_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3143 3144 3145 3146 3147 3148 3149
{
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tUser_var\n");
  }

3150
  fprintf(file, "SET @`");
3151
  my_fwrite(file, (byte*) name, (uint) (name_len), MYF(MY_NABP | MY_WME));
3152
  fprintf(file, "`");
3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171

  if (is_null)
  {
    fprintf(file, ":=NULL;\n");
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      double real_val;
      float8get(real_val, val);
      fprintf(file, ":=%.14g;\n", real_val);
      break;
    case INT_RESULT:
      char int_buf[22];
      longlong10_to_str(uint8korr(val), int_buf, -10);
      fprintf(file, ":=%s;\n", int_buf);
      break;
    case STRING_RESULT:
3172
    {
3173 3174 3175 3176 3177 3178 3179 3180 3181 3182 3183 3184 3185 3186
      /*
        Let's express the string in hex. That's the most robust way. If we
        print it in character form instead, we need to escape it with
        character_set_client which we don't know (we will know it in 5.0, but
        in 4.1 we don't know it easily when we are printing
        User_var_log_event). Explanation why we would need to bother with
        character_set_client (quoting Bar):
        > Note, the parser doesn't switch to another unescaping mode after
        > it has met a character set introducer.
        > For example, if an SJIS client says something like:
        > SET @a= _ucs2 \0a\0b'
        > the string constant is still unescaped according to SJIS, not
        > according to UCS2.
      */
3187 3188 3189 3190
      char *hex_str;
      CHARSET_INFO *cs;

      if (!(hex_str= (char *)my_alloca(2*val_len+1+2))) // 2 hex digits / byte
3191
        break; // no error, as we are 'void'
3192
      str_to_hex(hex_str, val, val_len);
3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205
      /*
        For proper behaviour when mysqlbinlog|mysql, we need to explicitely
        specify the variable's collation. It will however cause problems when
        people want to mysqlbinlog|mysql into another server not supporting the
        character set. But there's not much to do about this and it's unlikely.
      */
      if (!(cs= get_charset(charset_number, MYF(0))))
        /*
          Generate an unusable command (=> syntax error) is probably the best
          thing we can do here.
        */
        fprintf(file, ":=???;\n");
      else
3206
        fprintf(file, ":=_%s %s COLLATE `%s`;\n", cs->csname, hex_str, cs->name);
3207
      my_afree(hex_str);
3208
    }
3209
      break;
3210
    case ROW_RESULT:
3211
    default:
3212
      DBUG_ASSERT(1);
3213 3214 3215 3216 3217
      return;
    }
  }
  fflush(file);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3218
#endif
3219

3220

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3221
/*
3222
  User_var_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3223
*/
3224

3225
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3226 3227 3228
int User_var_log_event::exec_event(struct st_relay_log_info* rli)
{
  Item *it= 0;
3229 3230 3231
  CHARSET_INFO *charset;
  if (!(charset= get_charset(charset_number, MYF(MY_WME))))
    return 1;
3232 3233 3234
  LEX_STRING user_var_name;
  user_var_name.str= name;
  user_var_name.length= name_len;
3235 3236
  double real_val;
  longlong int_val;
3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247

  if (is_null)
  {
    it= new Item_null();
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      float8get(real_val, val);
      it= new Item_real(real_val);
3248
      val= (char*) &real_val;		// Pointer to value in native format
3249
      val_len= 8;
3250 3251
      break;
    case INT_RESULT:
3252 3253 3254
      int_val= (longlong) uint8korr(val);
      it= new Item_int(int_val);
      val= (char*) &int_val;		// Pointer to value in native format
3255
      val_len= 8;
3256 3257 3258 3259
      break;
    case STRING_RESULT:
      it= new Item_string(val, val_len, charset);
      break;
3260
    case ROW_RESULT:
3261
    default:
3262 3263 3264 3265 3266
      DBUG_ASSERT(1);
      return 0;
    }
  }
  Item_func_set_user_var e(user_var_name, it);
3267 3268 3269 3270
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
3271
  e.fix_fields(thd, 0, 0);
3272
  e.update_hash(val, val_len, type, charset, DERIVATION_NONE);
3273
  free_root(thd->mem_root,0);
3274

3275
  rli->inc_event_relay_log_pos();
3276 3277
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3278
#endif /* !MYSQL_CLIENT */
3279 3280


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3281
/**************************************************************************
3282
  Slave_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3283
**************************************************************************/
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3284

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3285
#ifdef HAVE_REPLICATION
3286
#ifdef MYSQL_CLIENT
3287
void Unknown_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3288 3289 3290 3291 3292 3293 3294 3295
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "# %s", "Unknown event\n");
}
#endif  
3296

3297
#ifndef MYSQL_CLIENT
3298
void Slave_log_event::pack_info(Protocol *protocol)
3299
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3300
  char buf[256+HOSTNAME_LENGTH], *pos;
3301 3302 3303 3304 3305 3306 3307
  pos= strmov(buf, "host=");
  pos= strnmov(pos, master_host, HOSTNAME_LENGTH);
  pos= strmov(pos, ",port=");
  pos= int10_to_str((long) master_port, pos, 10);
  pos= strmov(pos, ",log=");
  pos= strmov(pos, master_log);
  pos= strmov(pos, ",pos=");
3308
  pos= longlong10_to_str(master_pos, pos, 10);
3309
  protocol->store(buf, pos-buf, &my_charset_bin);
3310
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3311
#endif /* !MYSQL_CLIENT */
3312 3313 3314 3315


#ifndef MYSQL_CLIENT
Slave_log_event::Slave_log_event(THD* thd_arg,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3316
				 struct st_relay_log_info* rli)
3317
  :Log_event(thd_arg, 0, 0) , mem_pool(0), master_host(0)
3318 3319 3320 3321 3322 3323 3324 3325 3326 3327
{
  DBUG_ENTER("Slave_log_event");
  if (!rli->inited)				// QQ When can this happen ?
    DBUG_VOID_RETURN;
  
  MASTER_INFO* mi = rli->mi;
  // TODO: re-write this better without holding both locks at the same time
  pthread_mutex_lock(&mi->data_lock);
  pthread_mutex_lock(&rli->data_lock);
  master_host_len = strlen(mi->host);
3328
  master_log_len = strlen(rli->group_master_log_name);
3329 3330 3331
  // on OOM, just do not initialize the structure and print the error
  if ((mem_pool = (char*)my_malloc(get_data_size() + 1,
				   MYF(MY_WME))))
3332
  {
3333 3334 3335
    master_host = mem_pool + SL_MASTER_HOST_OFFSET ;
    memcpy(master_host, mi->host, master_host_len + 1);
    master_log = master_host + master_host_len + 1;
3336
    memcpy(master_log, rli->group_master_log_name, master_log_len + 1);
3337
    master_port = mi->port;
3338
    master_pos = rli->group_master_log_pos;
3339 3340
    DBUG_PRINT("info", ("master_log: %s  pos: %d", master_log,
			(ulong) master_pos));
3341
  }
3342 3343 3344 3345 3346 3347
  else
    sql_print_error("Out of memory while recording slave event");
  pthread_mutex_unlock(&rli->data_lock);
  pthread_mutex_unlock(&mi->data_lock);
  DBUG_VOID_RETURN;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3348
#endif /* !MYSQL_CLIENT */
3349 3350 3351 3352 3353 3354 3355 3356 3357


Slave_log_event::~Slave_log_event()
{
  my_free(mem_pool, MYF(MY_ALLOW_ZERO_PTR));
}


#ifdef MYSQL_CLIENT
3358
void Slave_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3359 3360 3361 3362 3363 3364
{
  char llbuff[22];
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3365 3366
  fprintf(file, "\
Slave: master_host: '%s'  master_port: %d  master_log: '%s'  master_pos: %s\n",
3367 3368
	  master_host, master_port, master_log, llstr(master_pos, llbuff));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3369
#endif /* MYSQL_CLIENT */
3370 3371 3372 3373 3374 3375 3376 3377


int Slave_log_event::get_data_size()
{
  return master_host_len + master_log_len + 1 + SL_MASTER_HOST_OFFSET;
}


3378
bool Slave_log_event::write(IO_CACHE* file)
3379
{
3380
  ulong event_length= get_data_size();
3381 3382 3383
  int8store(mem_pool + SL_MASTER_POS_OFFSET, master_pos);
  int2store(mem_pool + SL_MASTER_PORT_OFFSET, master_port);
  // log and host are already there
3384 3385 3386

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) mem_pool, event_length));
3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398
}


void Slave_log_event::init_from_mem_pool(int data_size)
{
  master_pos = uint8korr(mem_pool + SL_MASTER_POS_OFFSET);
  master_port = uint2korr(mem_pool + SL_MASTER_PORT_OFFSET);
  master_host = mem_pool + SL_MASTER_HOST_OFFSET;
  master_host_len = strlen(master_host);
  // safety
  master_log = master_host + master_host_len + 1;
  if (master_log > mem_pool + data_size)
3399
  {
3400 3401
    master_host = 0;
    return;
3402
  }
3403 3404
  master_log_len = strlen(master_log);
}
3405

3406

3407 3408 3409
/* This code is not used, so has not been updated to be format-tolerant */
Slave_log_event::Slave_log_event(const char* buf, uint event_len)
  :Log_event(buf,0) /*unused event*/ ,mem_pool(0),master_host(0)
3410
{
3411
  if (event_len < LOG_EVENT_HEADER_LEN)
3412
    return;
3413
  event_len -= LOG_EVENT_HEADER_LEN;
3414 3415 3416 3417 3418
  if (!(mem_pool = (char*) my_malloc(event_len + 1, MYF(MY_WME))))
    return;
  memcpy(mem_pool, buf + LOG_EVENT_HEADER_LEN, event_len);
  mem_pool[event_len] = 0;
  init_from_mem_pool(event_len);
3419 3420
}

3421

3422 3423 3424 3425 3426 3427 3428
#ifndef MYSQL_CLIENT
int Slave_log_event::exec_event(struct st_relay_log_info* rli)
{
  if (mysql_bin_log.is_open())
    mysql_bin_log.write(this);
  return Log_event::exec_event(rli);
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3429
#endif /* !MYSQL_CLIENT */
3430 3431


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3432
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3433
	Stop_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3434
**************************************************************************/
3435

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3436
/*
3437
  Stop_log_event::print()
3438
*/
3439 3440

#ifdef MYSQL_CLIENT
3441
void Stop_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3442 3443 3444 3445 3446 3447 3448
{
  if (short_form)
    return;

  print_header(file);
  fprintf(file, "\tStop\n");
  fflush(file);
3449
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3450
#endif /* MYSQL_CLIENT */
3451

3452

3453
/*
3454
  Stop_log_event::exec_event()
3455

3456
  The master stopped. 
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3457 3458
  We used to clean up all temporary tables but this is useless as, as the
  master has shut down properly, it has written all DROP TEMPORARY TABLE and DO
3459 3460 3461 3462
  RELEASE_LOCK (prepared statements' deletion is TODO).
  We used to clean up slave_load_tmpdir, but this is useless as it has been
  cleared at the end of LOAD DATA INFILE.
  So we have nothing to do here.
3463
  The place were we must do this cleaning is in Start_log_event_v3::exec_event(),
3464
  not here. Because if we come here, the master was sane.
3465 3466
*/

3467
#ifndef MYSQL_CLIENT
3468
int Stop_log_event::exec_event(struct st_relay_log_info* rli)
3469
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3470 3471
  /*
    We do not want to update master_log pos because we get a rotate event
3472
    before stop, so by now group_master_log_name is set to the next log.
3473
    If we updated it, we will have incorrect master coordinates and this
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3474
    could give false triggers in MASTER_POS_WAIT() that we have reached
3475
    the target position when in fact we have not.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3476
  */
3477 3478 3479 3480 3481 3482 3483
  if (thd->options & OPTION_BEGIN)
    rli->inc_event_relay_log_pos();
  else
  {
    rli->inc_group_relay_log_pos(0);
    flush_relay_log_info(rli);
  }
3484 3485
  return 0;
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3486
#endif /* !MYSQL_CLIENT */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3487
#endif /* HAVE_REPLICATION */
3488

3489

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3490
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3491
	Create_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3492
**************************************************************************/
3493 3494

/*
3495
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3496
*/
3497 3498

#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3499 3500 3501 3502
Create_file_log_event::
Create_file_log_event(THD* thd_arg, sql_exchange* ex,
		      const char* db_arg, const char* table_name_arg,
		      List<Item>& fields_arg, enum enum_duplicates handle_dup,
3503
                      bool ignore,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3504
		      char* block_arg, uint block_len_arg, bool using_trans)
3505
  :Load_log_event(thd_arg,ex,db_arg,table_name_arg,fields_arg,handle_dup, ignore,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3506
		  using_trans),
3507
   fake_base(0), block(block_arg), event_buf(0), block_len(block_len_arg),
3508
   file_id(thd_arg->file_id = mysql_bin_log.next_file_id())
3509
{
monty@mysql.com's avatar
monty@mysql.com committed
3510
  DBUG_ENTER("Create_file_log_event");
3511
  sql_ex.force_new_format();
monty@mysql.com's avatar
monty@mysql.com committed
3512
  DBUG_VOID_RETURN;
3513
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3514
#endif /* !MYSQL_CLIENT */
3515

3516

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3517
/*
3518
  Create_file_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3519
*/
3520

3521
bool Create_file_log_event::write_data_body(IO_CACHE* file)
3522
{
3523 3524
  bool res;
  if ((res= Load_log_event::write_data_body(file)) || fake_base)
3525 3526
    return res;
  return (my_b_safe_write(file, (byte*) "", 1) ||
3527
          my_b_safe_write(file, (byte*) block, block_len));
3528 3529
}

3530

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3531
/*
3532
  Create_file_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3533
*/
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3534

3535
bool Create_file_log_event::write_data_header(IO_CACHE* file)
3536
{
3537
  bool res;
3538
  byte buf[CREATE_FILE_HEADER_LEN];
3539 3540
  if ((res= Load_log_event::write_data_header(file)) || fake_base)
    return res;
3541
  int4store(buf + CF_FILE_ID_OFFSET, file_id);
3542
  return my_b_safe_write(file, buf, CREATE_FILE_HEADER_LEN) != 0;
3543 3544 3545
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3546
/*
3547
  Create_file_log_event::write_base()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3548
*/
3549

3550
bool Create_file_log_event::write_base(IO_CACHE* file)
3551
{
3552 3553 3554 3555
  bool res;
  fake_base= 1;                                 // pretend we are Load event
  res= write(file);
  fake_base= 0;
3556 3557 3558 3559
  return res;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3560
/*
3561
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3562
*/
3563

3564 3565 3566
Create_file_log_event::Create_file_log_event(const char* buf, uint len,
                                             const Format_description_log_event* description_event)
  :Load_log_event(buf,0,description_event),fake_base(0),block(0),inited_from_old(0)
3567
{
3568 3569 3570 3571 3572
  DBUG_ENTER("Create_file_log_event::Create_file_log_event(char*,...)");
  uint block_offset;
  uint header_len= description_event->common_header_len;
  uint8 load_header_len= description_event->post_header_len[LOAD_EVENT-1];
  uint8 create_file_header_len= description_event->post_header_len[CREATE_FILE_EVENT-1];
monty@mysql.com's avatar
monty@mysql.com committed
3573
  if (!(event_buf= my_memdup((byte*) buf, len, MYF(MY_WME))) ||
3574 3575 3576 3577 3578 3579 3580
      copy_log_event(event_buf,len,
                     ((buf[EVENT_TYPE_OFFSET] == LOAD_EVENT) ?
                      load_header_len + header_len :
                      (fake_base ? (header_len+load_header_len) :
                       (header_len+load_header_len) +
                       create_file_header_len)),
                     description_event))
monty@mysql.com's avatar
monty@mysql.com committed
3581
    DBUG_VOID_RETURN;
3582
  if (description_event->binlog_version!=1)
3583
  {
3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600
    file_id= uint4korr(buf + 
                       header_len +
		       load_header_len + CF_FILE_ID_OFFSET);
    /*
      Note that it's ok to use get_data_size() below, because it is computed
      with values we have already read from this event (because we called
      copy_log_event()); we are not using slave's format info to decode
      master's format, we are really using master's format info.
      Anyway, both formats should be identical (except the common_header_len)
      as these Load events are not changed between 4.0 and 5.0 (as logging of
      LOAD DATA INFILE does not use Load_log_event in 5.0).

      The + 1 is for \0 terminating fname  
    */
    block_offset= (description_event->common_header_len +
                   Load_log_event::get_data_size() +
                   create_file_header_len + 1);
3601 3602 3603 3604 3605 3606 3607 3608 3609
    if (len < block_offset)
      return;
    block = (char*)buf + block_offset;
    block_len = len - block_offset;
  }
  else
  {
    sql_ex.force_new_format();
    inited_from_old = 1;
3610
  }
monty@mysql.com's avatar
monty@mysql.com committed
3611
  DBUG_VOID_RETURN;
3612 3613
}

3614

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3615
/*
3616
  Create_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3617
*/
3618 3619

#ifdef MYSQL_CLIENT
3620
void Create_file_log_event::print(FILE* file, bool short_form, 
3621
				  LAST_EVENT_INFO* last_event_info, bool enable_local)
nick@mysql.com's avatar
nick@mysql.com committed
3622
{
3623
  if (short_form)
3624 3625
  {
    if (enable_local && check_fname_outside_temp_buf())
3626
      Load_log_event::print(file, 1, last_event_info);
3627
    return;
3628 3629 3630 3631
  }

  if (enable_local)
  {
serg@serg.mylan's avatar
serg@serg.mylan committed
3632
    Load_log_event::print(file, short_form, last_event_info, !check_fname_outside_temp_buf());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3633 3634 3635 3636 3637
    /* 
       That one is for "file_id: etc" below: in mysqlbinlog we want the #, in
       SHOW BINLOG EVENTS we don't.
    */
    fprintf(file, "#"); 
3638 3639
  }

3640
  fprintf(file, " file_id: %d  block_len: %d\n", file_id, block_len);
nick@mysql.com's avatar
nick@mysql.com committed
3641
}
3642

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3643

3644
void Create_file_log_event::print(FILE* file, bool short_form,
3645
				  LAST_EVENT_INFO* last_event_info)
3646
{
3647
  print(file,short_form,last_event_info,0);
3648
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3649
#endif /* MYSQL_CLIENT */
nick@mysql.com's avatar
nick@mysql.com committed
3650

3651

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3652
/*
3653
  Create_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3654
*/
3655

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3656
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3657
void Create_file_log_event::pack_info(Protocol *protocol)
3658
{
3659 3660 3661
  char buf[NAME_LEN*2 + 30 + 21*2], *pos;
  pos= strmov(buf, "db=");
  memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3662
  pos= strmov(pos + db_len, ";table=");
3663
  memcpy(pos, table_name, table_name_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3664
  pos= strmov(pos + table_name_len, ";file_id=");
3665 3666 3667
  pos= int10_to_str((long) file_id, pos, 10);
  pos= strmov(pos, ";block_len=");
  pos= int10_to_str((long) block_len, pos, 10);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3668
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
3669
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3670
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3671 3672


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3673
/*
3674
  Create_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3675
*/
3676

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3677
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3678
int Create_file_log_event::exec_event(struct st_relay_log_info* rli)
3679
{
3680
  char proc_info[17+FN_REFLEN+10], *fname_buf= proc_info+17;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3681
  char *p;
3682 3683 3684
  int fd = -1;
  IO_CACHE file;
  int error = 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3685

3686
  bzero((char*)&file, sizeof(file));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3687 3688
  p = slave_load_file_stem(fname_buf, file_id, server_id);
  strmov(p, ".info");			// strmov takes less code than memcpy
3689 3690
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
3691 3692 3693 3694 3695
  if ((fd = my_open(fname_buf, O_WRONLY|O_CREAT|O_BINARY|O_TRUNC,
		    MYF(MY_WME))) < 0 ||
      init_io_cache(&file, fd, IO_SIZE, WRITE_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
3696
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
3697 3698 3699 3700
    goto err;
  }
  
  // a trick to avoid allocating another buffer
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3701
  strmov(p, ".data");
3702 3703 3704 3705
  fname = fname_buf;
  fname_len = (uint)(p-fname) + 5;
  if (write_base(&file))
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3706
    strmov(p, ".info"); // to have it right in the error message
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3707 3708 3709
    slave_print_error(rli,my_errno,
		      "Error in Create_file event: could not write to file '%s'",
		      fname_buf);
3710 3711 3712 3713 3714 3715 3716 3717 3718
    goto err;
  }
  end_io_cache(&file);
  my_close(fd, MYF(0));
  
  // fname_buf now already has .data, not .info, because we did our trick
  if ((fd = my_open(fname_buf, O_WRONLY|O_CREAT|O_BINARY|O_TRUNC,
		    MYF(MY_WME))) < 0)
  {
3719
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
3720 3721
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3722
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
3723
  {
3724
    slave_print_error(rli,my_errno, "Error in Create_file event: write to '%s' failed", fname_buf);
3725 3726
    goto err;
  }
3727 3728
  error=0;					// Everything is ok

3729 3730 3731 3732 3733
err:
  if (error)
    end_io_cache(&file);
  if (fd >= 0)
    my_close(fd, MYF(0));
3734
  thd->proc_info= 0;
3735
  return error ? 1 : Log_event::exec_event(rli);
3736
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3737
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3738

3739

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3740
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3741
	Append_block_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3742
**************************************************************************/
3743

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3744
/*
3745
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3746
*/
3747 3748

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3749 3750
Append_block_log_event::Append_block_log_event(THD* thd_arg, const char* db_arg,
					       char* block_arg,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3751 3752 3753
					       uint block_len_arg,
					       bool using_trans)
  :Log_event(thd_arg,0, using_trans), block(block_arg),
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3754
   block_len(block_len_arg), file_id(thd_arg->file_id), db(db_arg)
3755 3756
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3757
#endif
3758 3759


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3760
/*
3761
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3762
*/
3763

3764 3765 3766
Append_block_log_event::Append_block_log_event(const char* buf, uint len,
                                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event),block(0)
3767
{
3768 3769 3770 3771 3772 3773
  DBUG_ENTER("Append_block_log_event::Append_block_log_event(char*,...)");
  uint8 common_header_len= description_event->common_header_len; 
  uint8 append_block_header_len=
    description_event->post_header_len[APPEND_BLOCK_EVENT-1];
  uint total_header_len= common_header_len+append_block_header_len;
  if (len < total_header_len)
monty@mysql.com's avatar
monty@mysql.com committed
3774
    DBUG_VOID_RETURN;
3775 3776 3777
  file_id= uint4korr(buf + common_header_len + AB_FILE_ID_OFFSET);
  block= (char*)buf + total_header_len;
  block_len= len - total_header_len;
monty@mysql.com's avatar
monty@mysql.com committed
3778
  DBUG_VOID_RETURN;
3779 3780 3781
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3782
/*
3783
  Append_block_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3784
*/
3785

3786
bool Append_block_log_event::write(IO_CACHE* file)
3787 3788 3789
{
  byte buf[APPEND_BLOCK_HEADER_LEN];
  int4store(buf + AB_FILE_ID_OFFSET, file_id);
3790 3791
  return (write_header(file, APPEND_BLOCK_HEADER_LEN + block_len) ||
          my_b_safe_write(file, buf, APPEND_BLOCK_HEADER_LEN) ||
3792 3793 3794 3795
	  my_b_safe_write(file, (byte*) block, block_len));
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3796
/*
3797
  Append_block_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3798
*/
3799 3800 3801

#ifdef MYSQL_CLIENT  
void Append_block_log_event::print(FILE* file, bool short_form,
3802
				   LAST_EVENT_INFO* last_event_info)
3803 3804 3805 3806 3807 3808 3809 3810
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "#Append_block: file_id: %d  block_len: %d\n",
	  file_id, block_len);
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3811
#endif /* MYSQL_CLIENT */
3812 3813


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3814
/*
3815
  Append_block_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3816
*/
3817

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3818
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3819
void Append_block_log_event::pack_info(Protocol *protocol)
3820 3821 3822 3823 3824 3825
{
  char buf[256];
  uint length;
  length= (uint) my_sprintf(buf,
			    (buf, ";file_id=%u;block_len=%u", file_id,
			     block_len));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3826
  protocol->store(buf, length, &my_charset_bin);
3827
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3828
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3829 3830


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3831
/*
3832
  Append_block_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3833
*/
3834

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3835
#if defined( HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3836
int Append_block_log_event::exec_event(struct st_relay_log_info* rli)
3837
{
3838
  char proc_info[17+FN_REFLEN+10], *fname= proc_info+17;
3839 3840
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
3841
  int error = 1;
monty@mysql.com's avatar
monty@mysql.com committed
3842
  DBUG_ENTER("Append_block_log_event::exec_event");
3843

3844
  memcpy(p, ".data", 6);
3845 3846
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
3847 3848
  if ((fd = my_open(fname, O_WRONLY|O_APPEND|O_BINARY, MYF(MY_WME))) < 0)
  {
3849
    slave_print_error(rli,my_errno, "Error in Append_block event: could not open file '%s'", fname);
3850 3851
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3852
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
3853
  {
3854
    slave_print_error(rli,my_errno, "Error in Append_block event: write to '%s' failed", fname);
3855 3856 3857
    goto err;
  }
  error=0;
3858

3859 3860 3861
err:
  if (fd >= 0)
    my_close(fd, MYF(0));
3862
  thd->proc_info= 0;
monty@mysql.com's avatar
monty@mysql.com committed
3863
  DBUG_RETURN(error ? error : Log_event::exec_event(rli));
3864
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3865
#endif
3866 3867


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3868
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3869
	Delete_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3870
**************************************************************************/
3871

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3872
/*
3873
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3874
*/
3875 3876

#ifndef MYSQL_CLIENT
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3877 3878 3879
Delete_file_log_event::Delete_file_log_event(THD *thd_arg, const char* db_arg,
					     bool using_trans)
  :Log_event(thd_arg, 0, using_trans), file_id(thd_arg->file_id), db(db_arg)
3880 3881
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3882
#endif
3883

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3884
/*
3885
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3886
*/
3887

3888 3889 3890
Delete_file_log_event::Delete_file_log_event(const char* buf, uint len,
                                             const Format_description_log_event* description_event)
  :Log_event(buf, description_event),file_id(0)
3891
{
3892 3893 3894
  uint8 common_header_len= description_event->common_header_len;
  uint8 delete_file_header_len= description_event->post_header_len[DELETE_FILE_EVENT-1];
  if (len < (uint)(common_header_len + delete_file_header_len))
3895
    return;
3896
  file_id= uint4korr(buf + common_header_len + DF_FILE_ID_OFFSET);
3897 3898 3899
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3900
/*
3901
  Delete_file_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3902
*/
3903

3904
bool Delete_file_log_event::write(IO_CACHE* file)
3905 3906 3907
{
 byte buf[DELETE_FILE_HEADER_LEN];
 int4store(buf + DF_FILE_ID_OFFSET, file_id);
3908 3909
 return (write_header(file, sizeof(buf)) ||
         my_b_safe_write(file, buf, sizeof(buf)));
3910 3911 3912
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3913
/*
3914
  Delete_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3915
*/
3916 3917 3918

#ifdef MYSQL_CLIENT  
void Delete_file_log_event::print(FILE* file, bool short_form,
3919
				  LAST_EVENT_INFO* last_event_info)
3920 3921 3922 3923 3924 3925 3926
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "#Delete_file: file_id=%u\n", file_id);
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3927
#endif /* MYSQL_CLIENT */
3928

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3929
/*
3930
  Delete_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3931
*/
3932

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3933
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3934
void Delete_file_log_event::pack_info(Protocol *protocol)
3935 3936 3937 3938
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
3939
  protocol->store(buf, (int32) length, &my_charset_bin);
3940
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3941
#endif
3942

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3943
/*
3944
  Delete_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3945
*/
3946

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3947
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3948 3949 3950 3951 3952 3953 3954 3955 3956 3957
int Delete_file_log_event::exec_event(struct st_relay_log_info* rli)
{
  char fname[FN_REFLEN+10];
  char *p= slave_load_file_stem(fname, file_id, server_id);
  memcpy(p, ".data", 6);
  (void) my_delete(fname, MYF(MY_WME));
  memcpy(p, ".info", 6);
  (void) my_delete(fname, MYF(MY_WME));
  return Log_event::exec_event(rli);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3958
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3959 3960


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3961
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3962
	Execute_load_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3963
**************************************************************************/
3964

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3965
/*
3966
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3967
*/
3968 3969

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3970 3971 3972
Execute_load_log_event::Execute_load_log_event(THD *thd_arg, const char* db_arg,
					       bool using_trans)
  :Log_event(thd_arg, 0, using_trans), file_id(thd_arg->file_id), db(db_arg)
3973 3974
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3975
#endif
3976 3977
  

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3978
/*
3979
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3980
*/
3981

3982 3983 3984
Execute_load_log_event::Execute_load_log_event(const char* buf, uint len,
                                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event), file_id(0)
3985
{
3986 3987 3988
  uint8 common_header_len= description_event->common_header_len;
  uint8 exec_load_header_len= description_event->post_header_len[EXEC_LOAD_EVENT-1];
  if (len < (uint)(common_header_len+exec_load_header_len))
3989
    return;
3990
  file_id= uint4korr(buf + common_header_len + EL_FILE_ID_OFFSET);
3991 3992 3993
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3994
/*
3995
  Execute_load_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3996
*/
3997

3998
bool Execute_load_log_event::write(IO_CACHE* file)
3999 4000 4001
{
  byte buf[EXEC_LOAD_HEADER_LEN];
  int4store(buf + EL_FILE_ID_OFFSET, file_id);
4002 4003
  return (write_header(file, sizeof(buf)) || 
          my_b_safe_write(file, buf, sizeof(buf)));
4004 4005 4006
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4007
/*
4008
  Execute_load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4009
*/
4010 4011 4012

#ifdef MYSQL_CLIENT  
void Execute_load_log_event::print(FILE* file, bool short_form,
4013
				   LAST_EVENT_INFO* last_event_info)
4014 4015 4016 4017 4018 4019 4020 4021
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "#Exec_load: file_id=%d\n",
	  file_id);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4022
#endif
4023

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4024
/*
4025
  Execute_load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4026
*/
4027

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4028
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4029
void Execute_load_log_event::pack_info(Protocol *protocol)
4030 4031 4032 4033
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
4034
  protocol->store(buf, (int32) length, &my_charset_bin);
4035 4036 4037
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4038
/*
4039
  Execute_load_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4040
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4041

4042
int Execute_load_log_event::exec_event(struct st_relay_log_info* rli)
4043 4044
{
  char fname[FN_REFLEN+10];
4045 4046
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
4047 4048 4049
  int error = 1;
  IO_CACHE file;
  Load_log_event* lev = 0;
4050

4051 4052 4053 4054 4055
  memcpy(p, ".info", 6);
  if ((fd = my_open(fname, O_RDONLY|O_BINARY, MYF(MY_WME))) < 0 ||
      init_io_cache(&file, fd, IO_SIZE, READ_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
4056
    slave_print_error(rli,my_errno, "Error in Exec_load event: could not open file '%s'", fname);
4057 4058
    goto err;
  }
4059
  if (!(lev = (Load_log_event*)Log_event::read_log_event(&file,
4060 4061
                                                         (pthread_mutex_t*)0,
                                                         rli->relay_log.description_event_for_exec)) ||
4062
      lev->get_type_code() != NEW_LOAD_EVENT)
4063
  {
4064
    slave_print_error(rli,0, "Error in Exec_load event: file '%s' appears corrupted", fname);
4065 4066
    goto err;
  }
4067

4068
  lev->thd = thd;
4069 4070
  /*
    lev->exec_event should use rli only for errors
4071 4072 4073
    i.e. should not advance rli's position.
    lev->exec_event is the place where the table is loaded (it calls
    mysql_load()).
4074
  */
guilhem@mysql.com's avatar
guilhem@mysql.com committed
4075

4076
  rli->future_group_master_log_pos= log_pos;
4077
  if (lev->exec_event(0,rli,1)) 
4078
  {
4079 4080 4081 4082 4083 4084 4085 4086 4087
    /*
      We want to indicate the name of the file that could not be loaded
      (SQL_LOADxxx).
      But as we are here we are sure the error is in rli->last_slave_error and
      rli->last_slave_errno (example of error: duplicate entry for key), so we
      don't want to overwrite it with the filename.
      What we want instead is add the filename to the current error message.
    */
    char *tmp= my_strdup(rli->last_slave_error,MYF(MY_WME));
4088 4089 4090 4091 4092 4093 4094 4095
    if (tmp)
    {
      slave_print_error(rli,
			rli->last_slave_errno, /* ok to re-use error code */
			"%s. Failed executing load from '%s'", 
			tmp, fname);
      my_free(tmp,MYF(0));
    }
4096 4097
    goto err;
  }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
4098 4099 4100 4101 4102 4103 4104 4105 4106 4107
  /*
    We have an open file descriptor to the .info file; we need to close it
    or Windows will refuse to delete the file in my_delete().
  */
  if (fd >= 0)
  {
    my_close(fd, MYF(0));
    end_io_cache(&file);
    fd= -1;
  }
4108
  (void) my_delete(fname, MYF(MY_WME));
4109
  memcpy(p, ".data", 6);
4110
  (void) my_delete(fname, MYF(MY_WME));
4111
  error = 0;
4112

4113 4114 4115
err:
  delete lev;
  if (fd >= 0)
4116
  {
4117
    my_close(fd, MYF(0));
4118 4119
    end_io_cache(&file);
  }
4120
  return error ? error : Log_event::exec_event(rli);
4121
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4122

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4123
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4124 4125


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4126
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4127
	sql_ex_info methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4128
**************************************************************************/
4129

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4130
/*
4131
  sql_ex_info::write_data()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4132
*/
4133

4134
bool sql_ex_info::write_data(IO_CACHE* file)
4135 4136 4137
{
  if (new_format())
  {
4138 4139 4140 4141 4142
    return (write_str(file, field_term, (uint) field_term_len) ||
	    write_str(file, enclosed,   (uint) enclosed_len) ||
	    write_str(file, line_term,  (uint) line_term_len) ||
	    write_str(file, line_start, (uint) line_start_len) ||
	    write_str(file, escaped,    (uint) escaped_len) ||
4143 4144 4145 4146 4147 4148 4149 4150 4151 4152 4153 4154
	    my_b_safe_write(file,(byte*) &opt_flags,1));
  }
  else
  {
    old_sql_ex old_ex;
    old_ex.field_term= *field_term;
    old_ex.enclosed=   *enclosed;
    old_ex.line_term=  *line_term;
    old_ex.line_start= *line_start;
    old_ex.escaped=    *escaped;
    old_ex.opt_flags=  opt_flags;
    old_ex.empty_flags=empty_flags;
4155
    return my_b_safe_write(file, (byte*) &old_ex, sizeof(old_ex)) != 0;
4156 4157 4158 4159
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4160
/*
4161
  sql_ex_info::init()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4162
*/
4163 4164 4165 4166 4167 4168 4169 4170 4171 4172 4173 4174 4175 4176

char* sql_ex_info::init(char* buf,char* buf_end,bool use_new_format)
{
  cached_new_format = use_new_format;
  if (use_new_format)
  {
    empty_flags=0;
    /*
      The code below assumes that buf will not disappear from
      under our feet during the lifetime of the event. This assumption
      holds true in the slave thread if the log is in new format, but is not
      the case when we have old format because we will be reusing net buffer
      to read the actual file before we write out the Create_file event.
    */
4177 4178 4179 4180 4181
    if (read_str(&buf, buf_end, &field_term, &field_term_len) ||
	read_str(&buf, buf_end, &enclosed,   &enclosed_len) ||
	read_str(&buf, buf_end, &line_term,  &line_term_len) ||
	read_str(&buf, buf_end, &line_start, &line_start_len) ||
	read_str(&buf, buf_end, &escaped,    &escaped_len))
4182 4183 4184 4185 4186 4187 4188 4189 4190 4191 4192 4193 4194 4195 4196 4197 4198 4199 4200 4201 4202 4203 4204 4205 4206 4207
      return 0;
    opt_flags = *buf++;
  }
  else
  {
    field_term_len= enclosed_len= line_term_len= line_start_len= escaped_len=1;
    field_term = buf++;			// Use first byte in string
    enclosed=	 buf++;
    line_term=   buf++;
    line_start=  buf++;
    escaped=     buf++;
    opt_flags =  *buf++;
    empty_flags= *buf++;
    if (empty_flags & FIELD_TERM_EMPTY)
      field_term_len=0;
    if (empty_flags & ENCLOSED_EMPTY)
      enclosed_len=0;
    if (empty_flags & LINE_TERM_EMPTY)
      line_term_len=0;
    if (empty_flags & LINE_START_EMPTY)
      line_start_len=0;
    if (empty_flags & ESCAPED_EMPTY)
      escaped_len=0;
  }
  return buf;
}