log_event.cc 126 KB
Newer Older
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 <my_dir.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
25 26
#endif /* MYSQL_CLIENT */

27
#define log_cs	&my_charset_latin1
28

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

33
#ifdef MYSQL_CLIENT
34
static void pretty_print_str(FILE* file, char* str, int len)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
35
{
36
  char* end = str + len;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
37
  fputc('\'', file);
38 39
  while (str < end)
  {
40
    char c;
41 42 43 44 45 46 47 48 49 50 51 52
    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;
    }
53 54
  }
  fputc('\'', file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
55
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
56
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
57

58

59 60 61 62 63 64 65 66 67 68 69
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)

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@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
70
/*
71
  Ignore error code specified on command line
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
72
*/
73

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

81

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

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

113

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
118
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
119 120 121
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
122
  fn_format(buf,"SQL_LOAD-",slave_load_tmpdir, "", MY_UNPACK_FILENAME);
123 124 125 126 127 128 129
  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
130
#endif
131

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

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

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

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

148 149 150
  if (!(dirp=my_dir(slave_load_tmpdir,MYF(MY_WME))))
    return;

151 152 153 154 155 156 157 158 159 160 161 162 163
  /* 
     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;

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

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


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

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


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

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

207

208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230
/*
  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'
}

231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246
/*
  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;
  }
}
247

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

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

256 257
const char* Log_event::get_type_str()
{
258
  switch(get_type_code()) {
259
  case START_EVENT_V3:  return "Start_v3";
260 261 262 263 264
  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";
265
  case NEW_LOAD_EVENT:   return "New_load";
266
  case SLAVE_EVENT:  return "Slave";
267 268 269 270
  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";
271
  case RAND_EVENT: return "RAND";
272
  case USER_VAR_EVENT: return "User var";
273
  case FORMAT_DESCRIPTION_EVENT: return "Format_desc";
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
274
  default: return "Unknown";				/* impossible */ 
275 276 277
  }
}

278

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

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


monty@mysql.com's avatar
monty@mysql.com committed
294 295 296 297 298 299 300
/*
  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).
*/

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


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

316 317
Log_event::Log_event(const char* buf,
                     const Format_description_log_event* description_event) 
318
  :temp_buf(0), cache_stmt(0)
319
{
320 321 322
#ifndef MYSQL_CLIENT
  thd = 0;
#endif  
323 324
  when = uint4korr(buf);
  server_id = uint4korr(buf + SERVER_ID_OFFSET);
325
  if (description_event->binlog_version==1)
326
  {
327 328 329
    log_pos= 0;
    flags= 0;
    return;
330
  }
331 332 333 334 335 336 337
  /* 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.
338 339 340 341
    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).
342 343
  */
  if (description_event->binlog_version==3 &&
344 345
      buf[EVENT_TYPE_OFFSET]<FORMAT_DESCRIPTION_EVENT && log_pos)
  {
346 347 348 349 350 351
      /*
        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
352 353 354 355
        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).
356 357
      */
    log_pos+= uint4korr(buf + EVENT_LEN_OFFSET);
358 359 360
  }
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

361 362 363
  flags= uint2korr(buf + FLAGS_OFFSET);
  if ((buf[EVENT_TYPE_OFFSET] == FORMAT_DESCRIPTION_EVENT) ||
      (buf[EVENT_TYPE_OFFSET] == ROTATE_EVENT))
364
  {
365 366 367 368 369 370 371
    /*
      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
372 373 374 375
      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.
376 377
    */
    return;
378
  }
379
  /* otherwise, go on with reading the header from buf (nothing now) */
380 381 382
}

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

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

389
int Log_event::exec_event(struct st_relay_log_info* rli)
390
{
391 392
  DBUG_ENTER("Log_event::exec_event");

393 394 395 396 397 398 399 400 401 402 403 404 405
  /*
    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)  
406
  {
407 408 409 410 411 412 413 414 415 416 417 418 419 420
    /*
      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
421 422
      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
423 424 425 426 427
      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
428 429
      "transaction". START SLAVE will resume at BEGIN while the MyISAM table
      has already been updated.
430 431
    */
    if ((thd->options & OPTION_BEGIN) && opt_using_transactions)
432
      rli->inc_event_relay_log_pos();
433 434
    else
    {
435
      rli->inc_group_relay_log_pos(log_pos);
436
      flush_relay_log_info(rli);
437 438 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.
      */
      rli->last_master_timestamp= when;
443
    }
444
  }
445
  DBUG_RETURN(0);
446
}
447

448

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
449
/*
450
  Log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
451
*/
452

453
void Log_event::pack_info(Protocol *protocol)
454
{
455
  protocol->store("", &my_charset_bin);
456 457 458
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
459
/*
460
  Log_event::net_send()
461

462
  Only called by SHOW BINLOG EVENTS
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
463
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
464

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


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
485
/*
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
486
  Log_event::init_show_field_list()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
487
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
488 489 490 491 492 493 494 495 496

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));
497
  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
498 499 500 501
					    MYSQL_TYPE_LONGLONG));
  field_list->push_back(new Item_empty_string("Info", 20));
}

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

504

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
505
/*
506
  Log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
507
*/
508

509
bool Log_event::write_header(IO_CACHE* file, ulong event_data_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
510
{
511 512
  byte header[LOG_EVENT_HEADER_LEN];
  DBUG_ENTER("Log_event::write_header");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
513

514 515
  /* Store number of bytes that will be written by this event */
  data_written= event_data_length + sizeof(header);
516

517 518 519 520 521 522 523 524 525 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
  /*
    log_pos != 0 if this is relay-log event. In this case we should not
    change the position
  */

  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;
  }
561

562 563 564
  /*
    Header will be of size LOG_EVENT_HEADER_LEN for all events, except for
    FORMAT_DESCRIPTION_EVENT and ROTATE_EVENT, where it will be
565 566
    LOG_EVENT_MINIMAL_HEADER_LEN (remember these 2 have a frozen header,
    because we read them before knowing the format).
567
  */
568 569 570 571 572 573

  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);
574
  int2store(header+ FLAGS_OFFSET, flags);
575 576

  DBUG_RETURN(my_b_safe_write(file, header, sizeof(header)) != 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
577 578 579
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
580
/*
581
  Log_event::read_log_event()
582 583 584 585

  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
586
*/
587 588

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

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

end:
  if (log_lock)
    pthread_mutex_unlock(log_lock);
642
  DBUG_RETURN(result);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
643
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
644
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
645

646
#ifndef MYSQL_CLIENT
647 648
#define UNLOCK_MUTEX if (log_lock) pthread_mutex_unlock(log_lock);
#define LOCK_MUTEX if (log_lock) pthread_mutex_lock(log_lock);
649
#define max_allowed_packet current_thd->variables.max_allowed_packet
650
#else
651
#define UNLOCK_MUTEX
652
#define LOCK_MUTEX
653
#define max_allowed_packet (*mysql_get_parameters()->p_max_allowed_packet)
654 655
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
656
/*
657 658
  Log_event::read_log_event()

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
659
  NOTE:
660
    Allocates memory;  The caller is responsible for clean-up.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
661
*/
662

663
#ifndef MYSQL_CLIENT
664 665
Log_event* Log_event::read_log_event(IO_CACHE* file,
				     pthread_mutex_t* log_lock,
666
                                     const Format_description_log_event *description_event)
667
#else
668 669
Log_event* Log_event::read_log_event(IO_CACHE* file,
                                     const Format_description_log_event *description_event)
670
#endif  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
671
{
672 673 674 675 676 677 678 679 680 681 682
  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);
683

684
  LOCK_MUTEX;
685
  DBUG_PRINT("info", ("my_b_tell=%lu", my_b_tell(file)));
686
  if (my_b_read(file, (byte *) head, header_size))
687
  {
688 689
    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
690
    UNLOCK_MUTEX;
691 692 693 694 695
    /*
      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.
    */
696
    return 0;
697
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
698

699
  uint data_len = uint4korr(head + EVENT_LEN_OFFSET);
700 701 702
  char *buf= 0;
  const char *error= 0;
  Log_event *res=  0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
703

704
  if (data_len > max_allowed_packet)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
705
  {
706 707
    error = "Event too big";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
708 709
  }

710
  if (data_len < header_size)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
711
  {
712 713
    error = "Event too small";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
714
  }
715 716 717

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

733
err:
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
734
  UNLOCK_MUTEX;
735
  if (error)
736
  {
737 738 739
    sql_print_error("\
Error in Log_event::read_log_event(): '%s', data_len: %d, event_type: %d",
		    error,data_len,head[EVENT_TYPE_OFFSET]);
740
    my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
741 742 743 744 745 746 747 748 749
    /*
      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;
750
  }
751
  return res;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
752 753
}

754

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
755
/*
756
  Log_event::read_log_event()
757 758
  Binlog format tolerance is in (buf, event_len, description_event)
  constructors.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
759
*/
760

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

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

860
#ifdef MYSQL_CLIENT
861

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
862
/*
863
  Log_event::print_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
864
*/
865

866 867
void Log_event::print_header(FILE* file)
{
868
  char llbuff[22];
869 870
  fputc('#', file);
  print_timestamp(file);
871
  fprintf(file, " server id %d  end_log_pos %s ", server_id,
872
	  llstr(log_pos,llbuff)); 
873 874
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
875
/*
876
  Log_event::print_timestamp()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
877
*/
878

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

  fprintf(file,"%02d%02d%02d %2d:%02d:%02d",
892 893 894 895 896 897
	  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
898 899
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
900
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
901 902


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
903
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
904
	Query_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
905
**************************************************************************/
906

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
909
/*
910
  Query_log_event::pack_info()
911 912 913 914
  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
915
*/
916

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


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
941
/*
942
  Query_log_event::write()
943

944 945 946 947
  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
948
*/
949

950
bool Query_log_event::write(IO_CACHE* file)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
951
{
952 953
  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
954

955
  if (!query)
956 957
    return 1;                                   // Something wrong with event

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
958 959 960 961 962
  /*
    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.
963
    Now imagine we (write()) are called by the slave SQL thread (we are
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
964 965 966 967 968 969 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
    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);
996 997 998 999
  int4store(buf + Q_EXEC_TIME_OFFSET, exec_time);
  buf[Q_DB_LEN_OFFSET] = (char) db_len;
  int2store(buf + Q_ERR_CODE_OFFSET, error_code);

1000 1001 1002 1003 1004
  /*
    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.
  */
1005
  start_of_status= start= buf+QUERY_HEADER_LEN;
1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017
  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;
  }
1018
  if (catalog_len >= 0) // i.e. "catalog inited" (false for 4.0 events)
1019 1020
  {
    *(start++)= Q_CATALOG_CODE;
monty@mysql.com's avatar
monty@mysql.com committed
1021
    *(start++)= (uchar) catalog_len;
1022 1023
    bmove(start, catalog, catalog_len);
    start+= catalog_len;
1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038
    /*
      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';
1039
  }
1040 1041 1042 1043 1044 1045 1046
  if (auto_increment_increment != 1)
  {
    *start++= Q_AUTO_INCREMENT;
    int2store(start, auto_increment_increment);
    int2store(start+2, auto_increment_offset);
    start+= 4;
  }
1047 1048 1049 1050 1051 1052 1053 1054 1055 1056
  /*
    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;
    }
  */
  
1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068
  /* 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)) ||
1069
  	  my_b_safe_write(file, (db) ? (byte*) db : (byte*)"", db_len + 1) ||
1070
  	  my_b_safe_write(file, (byte*) query, q_len)) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1071 1072
}

1073

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1074
/*
1075
  Query_log_event::Query_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1076
*/
1077

1078 1079
#ifndef MYSQL_CLIENT
Query_log_event::Query_log_event(THD* thd_arg, const char* query_arg,
1080
				 ulong query_length, bool using_trans)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1081 1082
  :Log_event(thd_arg, !thd_arg->tmp_table_used ?
	     0 : LOG_EVENT_THREAD_SPECIFIC_F, using_trans),
1083
   data_buf(0), query(query_arg), catalog(thd_arg->catalog),
1084
   db(thd_arg->db), q_len((uint32) query_length),
1085 1086 1087
   error_code((thd_arg->killed != THD::NOT_KILLED) ?
              ((thd_arg->system_thread & SYSTEM_THREAD_DELAYED_INSERT) ?
               0 : thd->killed_errno()) : thd_arg->net.last_errno),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1088 1089
   thread_id(thd_arg->thread_id),
   /* save the original thread id; we already know the server id */
1090
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
1091 1092 1093 1094
   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)
1095 1096 1097 1098
{
  time_t end_time;
  time(&end_time);
  exec_time = (ulong) (end_time  - thd->start_time);
1099
  catalog_len = (catalog) ? (uint32) strlen(catalog) : 0;
1100
  status_vars_len= 1+4+1+8+1+1+catalog_len+1;
1101
  db_len = (db) ? (uint32) strlen(db) : 0;
1102 1103 1104 1105 1106 1107 1108 1109
  /*
    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;
1110

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

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1116
/*
1117
  Query_log_event::Query_log_event()
1118
  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
1119
*/
1120

1121 1122
Query_log_event::Query_log_event(const char* buf, uint event_len,
                                 const Format_description_log_event *description_event)
1123 1124
  :Log_event(buf, description_event), data_buf(0), query(NullS), catalog(NullS), 
   db(NullS), catalog_len(0), status_vars_len(0),
1125
   flags2_inited(0), sql_mode_inited(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1126 1127
{
  ulong data_len;
1128
  uint32 tmp;
1129
  uint8 common_header_len, post_header_len;
1130
  const char *start, *end;
1131
  DBUG_ENTER("Query_log_event::Query_log_event(char*,...)");
1132

1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143
  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))
1144
    DBUG_VOID_RETURN;				
1145 1146 1147 1148
  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);
1149
  exec_time = uint4korr(buf + Q_EXEC_TIME_OFFSET);
1150
  db_len = (uint)buf[Q_DB_LEN_OFFSET];
1151
  error_code = uint2korr(buf + Q_ERR_CODE_OFFSET);
1152 1153
  /* If auto_increment is not set by query_event, they should not be used */
  auto_increment_increment= auto_increment_offset= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1154

1155 1156 1157 1158 1159
  /*
    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:
  */
1160
  tmp= post_header_len - QUERY_HEADER_MINIMAL_LEN; 
1161 1162 1163
  if (tmp)
  {
    status_vars_len= uint2korr(buf + Q_STATUS_VARS_LEN_OFFSET);
1164 1165 1166
    data_len-= status_vars_len;
    DBUG_PRINT("info", ("Query_log_event has status_vars_len: %u",
                        (uint) status_vars_len));
1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177
    tmp-= 2;
  }
  /* 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  */
  
1178 1179 1180
  start= (char*) (buf+post_header_len);
  end= (char*) (start+status_vars_len);
  for (const uchar* pos= (const uchar*) start; pos < (const uchar*) end;)
1181
  {
1182
    switch (*pos++) {
1183 1184
    case Q_FLAGS2_CODE:
      flags2_inited= 1;
1185
      flags2= uint4korr(pos);
monty@mysql.com's avatar
monty@mysql.com committed
1186
      DBUG_PRINT("info",("In Query_log_event, read flags2: %lu", flags2));
1187 1188 1189
      pos+= 4;
      break;
    case Q_SQL_MODE_CODE:
monty@mysql.com's avatar
monty@mysql.com committed
1190 1191 1192 1193
    {
#ifndef DBUG_OFF
      char buff[22];
#endif
1194
      sql_mode_inited= 1;
1195
      sql_mode= (ulong) uint8korr(pos); // QQ: Fix when sql_mode is ulonglong
monty@mysql.com's avatar
monty@mysql.com committed
1196 1197
      DBUG_PRINT("info",("In Query_log_event, read sql_mode: %s",
			 llstr(sql_mode, buff)));
1198 1199
      pos+= 8;
      break;
monty@mysql.com's avatar
monty@mysql.com committed
1200
    }
1201
    case Q_CATALOG_CODE:
1202
      catalog_len= *pos;
1203 1204 1205 1206 1207 1208 1209 1210
      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;
1211 1212 1213 1214
      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\
1215
 code: %u), skipping the rest of them", (uint) *(pos-1)));
1216
      pos= (const uchar*) end;                         // Break look
1217 1218 1219 1220 1221
    }
  }
  
  /* A 2nd variable part; this is common to all versions */ 
  
1222 1223 1224
  if (!(start= data_buf = (char*) my_malloc(catalog_len + data_len +2, MYF(MY_WME))))
    DBUG_VOID_RETURN;
  if (catalog)                                  // If catalog is given
1225
  {
1226 1227 1228
    memcpy((char*) start, catalog, catalog_len+1);      // Copy name and end \0
    catalog= start;
    start+= catalog_len+1;
1229
  }
1230 1231 1232 1233 1234
  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;
1235
  /* This is used to detect wrong parsing. Could be removed in the future. */
1236 1237
  DBUG_PRINT("info", ("catalog: '%s'  len: %u   db: '%s'  len:  %u  q_len: %lu",
                      catalog, (uint) catalog_len, db, (uint) db_len,q_len));
1238
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1239 1240
}

1241

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1242
/*
1243
  Query_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1244
*/
1245

1246
#ifdef MYSQL_CLIENT
1247 1248
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
1249
{
1250
  // TODO: print the catalog ??
1251
  char buff[40],*end;				// Enough for SET TIMESTAMP
1252
  bool different_db= 1;
1253
  uint32 tmp;
1254

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1255 1256
  if (!short_form)
  {
1257
    print_header(file);
1258 1259
    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
1260 1261
  }

1262
  if (db)
1263
  {
pem@mysql.com's avatar
pem@mysql.com committed
1264
    if ((different_db = memcmp(last_event_info->db, db, db_len + 1)))
1265
      memcpy(last_event_info->db, db, db_len + 1);
1266
  }
1267
  
1268
  if (db && db[0] && different_db)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1269
    fprintf(file, "use %s;\n", db);
1270 1271 1272 1273
  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));
1274 1275
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
    fprintf(file,"SET @@session.pseudo_thread_id=%lu;\n",(ulong)thread_id);
1276 1277 1278 1279 1280 1281 1282 1283 1284 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
  /*
    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;
1326 1327
      /* force a difference to force write */
      last_event_info->sql_mode= ~sql_mode;
1328 1329 1330 1331 1332 1333 1334
    }
    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;
    }
  }
1335 1336 1337 1338 1339 1340 1341 1342
  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;
  }
1343

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1344
  my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
1345
  fputs(";\n", file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1346
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1347
#endif /* MYSQL_CLIENT */
1348

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1350
/*
1351
  Query_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1352
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1353

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1354
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1355
int Query_log_event::exec_event(struct st_relay_log_info* rli)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1356
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1357
  int expected_error,actual_error= 0;
1358 1359 1360 1361 1362 1363 1364
  /*
    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;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1365
  thd->db= (char*) rewrite_db(db);
1366 1367
  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
1368

1369
  /*
1370 1371 1372 1373 1374
    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.
1375 1376 1377
    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.
1378
  */
1379
  rli->future_group_master_log_pos= log_pos;
1380 1381
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

1382
  clear_all_errors(thd, rli);
1383 1384 1385 1386

  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
  {
    thd->set_time((time_t)when);
1387 1388
    thd->query_length= q_len;
    thd->query = (char*)query;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1389
    VOID(pthread_mutex_lock(&LOCK_thread_count));
1390 1391
    thd->query_id = query_id++;
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
1392
    thd->variables.pseudo_thread_id= thread_id;		// for temp tables
1393 1394
    mysql_log.write(thd,COM_QUERY,"%s",thd->query);
    DBUG_PRINT("query",("%s",thd->query));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1395

1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415
    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)
monty@mysql.com's avatar
monty@mysql.com committed
1416 1417 1418
      thd->variables.sql_mode=
	(ulong) ((thd->variables.sql_mode & MODE_NO_DIR_IN_CREATE) |
		 (sql_mode & ~(ulong) MODE_NO_DIR_IN_CREATE));
1419
    
1420
    if (ignored_error_code((expected_error= error_code)) ||
1421 1422
	!check_expected_error(thd,rli,expected_error))
      mysql_parse(thd, thd->query, q_len);
1423 1424
    else
    {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1425
      /*
1426 1427 1428 1429 1430
        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
1431
      */
1432 1433 1434
      if (mysql_test_parse_for_slave(thd, thd->query, q_len))
        clear_all_errors(thd, rli);        /* Can ignore query */
      else
1435
      {
1436
        slave_print_error(rli,expected_error, 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1437
                          "\
monty@mysql.com's avatar
monty@mysql.com committed
1438
Query partially completed on the master (error on master: %d) \
1439 1440 1441
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
1442
START SLAVE; . Query: '%s'", expected_error, thd->query);
1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460
        thd->query_error= 1;
      }
      goto end;
    }
 
    /*
      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",
 		       expected_error, thd->net.last_errno));
    if ((expected_error != (actual_error= thd->net.last_errno)) &&
 	expected_error &&
 	!ignored_error_code(actual_error) &&
 	!ignored_error_code(expected_error))
    {
      slave_print_error(rli, 0,
 			"\
monty@mysql.com's avatar
monty@mysql.com committed
1461
Query caused different errors on master and slave. \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1462
Error on master: '%s' (%d), Error on slave: '%s' (%d). \
monty@mysql.com's avatar
monty@mysql.com committed
1463
Default database: '%s'. Query: '%s'",
1464 1465 1466 1467
 			ER_SAFE(expected_error),
 			expected_error,
 			actual_error ? thd->net.last_error: "no error",
 			actual_error,
monty@mysql.com's avatar
monty@mysql.com committed
1468
			print_slave_db_safe(db), query);
1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485
      thd->query_error= 1;
    }
    /*
      If we get the same error code as expected, or they should be ignored. 
    */
    else if (expected_error == actual_error ||
 	     ignored_error_code(actual_error))
    {
      DBUG_PRINT("info",("error ignored"));
      clear_all_errors(thd, rli);
    }
    /*
      Other cases: mostly we expected no error and get one.
    */
    else if (thd->query_error || thd->is_fatal_error)
    {
      slave_print_error(rli,actual_error,
monty@mysql.com's avatar
monty@mysql.com committed
1486
			"Error '%s' on query. Default database: '%s'. Query: '%s'",
1487 1488
 			(actual_error ? thd->net.last_error :
 			 "unexpected success or fatal error"),
monty@mysql.com's avatar
monty@mysql.com committed
1489
			print_slave_db_safe(db), query);
1490 1491 1492 1493 1494 1495 1496
      thd->query_error= 1;
    }

    /*
      TODO: compare the values of "affected rows" around here. Something
      like:
      if ((uint32) affected_in_event != (uint32) affected_on_slave)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1497
      {
1498 1499 1500 1501
      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;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1502
      }
1503 1504 1505
      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...
1506
        
1507 1508 1509 1510 1511 1512
      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
1513 1514 1515
    */
  } /* End of if (db_ok(... */

1516
end:
1517
  VOID(pthread_mutex_lock(&LOCK_thread_count));
1518 1519 1520 1521 1522 1523 1524 1525 1526 1527
  /*
    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).
  */
1528
  thd->db= thd->catalog= 0;	        // prevent db from being freed
1529
  thd->query= 0;			// just to be sure
monty@mysql.com's avatar
monty@mysql.com committed
1530
  thd->query_length= 0;
1531
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1532
  close_thread_tables(thd);      
monty@mysql.com's avatar
monty@mysql.com committed
1533
  free_root(&thd->mem_root,MYF(MY_KEEP_PREALLOC));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1534
  return (thd->query_error ? thd->query_error : Log_event::exec_event(rli)); 
1535
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1536
#endif
1537

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1539
/**************************************************************************
1540
	Start_log_event_v3 methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1541
**************************************************************************/
1542

1543
#ifndef MYSQL_CLIENT
1544
Start_log_event_v3::Start_log_event_v3() :Log_event(), binlog_version(BINLOG_VERSION), artificial_event(0)
1545 1546 1547 1548 1549 1550
{
  created= when;
  memcpy(server_version, ::server_version, ST_SERVER_VER_LEN);
}
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1551
/*
1552
  Start_log_event_v3::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1553
*/
1554

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1555
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1556
void Start_log_event_v3::pack_info(Protocol *protocol)
nick@mysql.com's avatar
nick@mysql.com committed
1557
{
1558 1559 1560 1561
  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
1562 1563
  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
1564
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1565
#endif
1566 1567


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

#ifdef MYSQL_CLIENT
1573
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
1574
{
1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592
  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
1593 1594
  fflush(file);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1595
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1596

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1597
/*
1598
  Start_log_event_v3::Start_log_event_v3()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1599
*/
1600

1601 1602 1603
Start_log_event_v3::Start_log_event_v3(const char* buf,
                                       const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
1604
{
1605 1606
  buf+= description_event->common_header_len;
  binlog_version= uint2korr(buf+ST_BINLOG_VER_OFFSET);
1607 1608
  memcpy(server_version, buf+ST_SERVER_VER_OFFSET,
	 ST_SERVER_VER_LEN);
1609 1610 1611
  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
1612 1613
}

1614

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

1619
bool Start_log_event_v3::write(IO_CACHE* file)
1620
{
1621
  char buff[START_V3_HEADER_LEN];
1622 1623 1624
  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);
1625 1626
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, (byte*) buff, sizeof(buff)));
1627
}
1628

1629

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1630
/*
1631
  Start_log_event_v3::exec_event()
1632 1633 1634 1635

  The master started

  IMPLEMENTATION
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1636 1637 1638 1639
    - 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).
1640 1641

  TODO
1642 1643 1644 1645 1646
    - 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
1647 1648
*/

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1649
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1650
int Start_log_event_v3::exec_event(struct st_relay_log_info* rli)
1651
{
1652
  DBUG_ENTER("Start_log_event_v3::exec_event");
monty@mishka.local's avatar
monty@mishka.local committed
1653 1654 1655 1656 1657
  /*
    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.
  */
1658 1659 1660 1661 1662 1663 1664 1665 1666
  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
1667
    */
1668 1669 1670 1671 1672
    if (created)
    {
      close_temporary_tables(thd);
      cleanup_load_tmpdir();
    }
1673 1674 1675 1676 1677 1678 1679
    /*
      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.
1680 1681 1682 1683
      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).
1684
    */
1685
    if (!artificial_event && (thd->options & OPTION_BEGIN))
1686
    {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1687 1688
      slave_print_error(rli, 0, "\
Rolling back unfinished transaction (no COMMIT or ROLLBACK) from relay log. \
1689
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
1690
binary log.");
1691 1692
      return(1);
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1693 1694
    break;

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1695
    /* 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1696 1697
       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
1698
    */
1699 1700 1701 1702 1703 1704 1705 1706 1707 1708
  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@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1709
    /*
1710 1711 1712
      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@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1713
    */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1714 1715 1716
    break;
  default:
    /* this case is impossible */
1717
    DBUG_RETURN(1);
nick@mysql.com's avatar
nick@mysql.com committed
1718
  }
1719
  DBUG_RETURN(Log_event::exec_event(rli));
1720
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1721
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
1722

1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750
/***************************************************************************
       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.

*/

1751 1752 1753 1754
Format_description_log_event::
Format_description_log_event(uint8 binlog_ver,
                             const char* server_ver) 
  :Start_log_event_v3()
1755 1756 1757
{
  created= when;
  binlog_version= binlog_ver;
1758
  switch (binlog_ver) {
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
  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;
  }
}

1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859

/*
  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) 
1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870
  :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() */
monty@mysql.com's avatar
monty@mysql.com committed
1871
  post_header_len= (uint8*) my_memdup((byte*)buf+ST_COMMON_HEADER_LEN_OFFSET+1,
1872 1873 1874 1875 1876 1877
                                      number_of_event_types*
                                      sizeof(*post_header_len),
                                      MYF(0));  
  DBUG_VOID_RETURN;
}

1878 1879

bool Format_description_log_event::write(IO_CACHE* file)
1880 1881
{
  /*
1882
    We don't call Start_log_event_v3::write() because this would make 2
1883 1884
    my_b_safe_write().
  */
1885
  byte buff[FORMAT_DESCRIPTION_HEADER_LEN];
1886
  int2store(buff + ST_BINLOG_VER_OFFSET,binlog_version);
1887
  memcpy((char*) buff + ST_SERVER_VER_OFFSET,server_version,ST_SERVER_VER_LEN);
1888 1889
  int4store(buff + ST_CREATED_OFFSET,created);
  buff[ST_COMMON_HEADER_LEN_OFFSET]= LOG_EVENT_HEADER_LEN;    
1890
  memcpy((char*) buff+ST_COMMON_HEADER_LEN_OFFSET+1, (byte*) post_header_len,
1891
         LOG_EVENT_TYPES);
1892 1893
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, buff, sizeof(buff)));
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
}
  
/*
  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
1924 1925
      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
1926
      Stop_log_event::exec_event().
1927
      If in a transaction, don't touch group_* coordinates.
1928
    */
1929 1930 1931 1932 1933 1934 1935
    if (thd->options & OPTION_BEGIN)
      rli->inc_event_relay_log_pos();
    else
    {
      rli->inc_group_relay_log_pos(0);
      flush_relay_log_info(rli);
    }
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
    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).
  **************************************************************************/
1967

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1968
/*
1969
  Load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1970
*/
1971

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1972
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1973
void Load_log_event::pack_info(Protocol *protocol)
1974
{
1975 1976 1977 1978 1979 1980
  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
1981
    7 +					    // LOCAL
1982
    9 +                                     // " REPLACE or IGNORE "
1983
    13 + table_name_len*2 +                 // "INTO TABLE `table`"
1984 1985 1986 1987 1988 1989 1990 1991
    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
1992
  if (!(buf= my_malloc(buf_len, MYF(MY_WME))))
1993 1994
    return;
  pos= buf;
1995
  if (db && db_len)
1996
  {
1997 1998
    pos= strmov(pos, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1999
    pos= strmov(pos+db_len, "`; ");
2000
  }
2001

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2002 2003 2004 2005
  pos= strmov(pos, "LOAD DATA ");
  if (check_fname_outside_temp_buf())
    pos= strmov(pos, "LOCAL ");
  pos= strmov(pos, "INFILE '");
2006
  memcpy(pos, fname, fname_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2007
  pos= strmov(pos+fname_len, "' ");
2008

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2009
  if (sql_ex.opt_flags & REPLACE_FLAG)
2010
    pos= strmov(pos, " REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2011
  else if (sql_ex.opt_flags & IGNORE_FLAG)
2012 2013
    pos= strmov(pos, " IGNORE ");

2014
  pos= strmov(pos ,"INTO TABLE `");
2015 2016 2017
  memcpy(pos, table_name, table_name_len);
  pos+= table_name_len;

2018 2019 2020 2021 2022 2023 2024
  /* We have to create all optinal fields as the default is not empty */
  pos= strmov(pos, "` FIELDS TERMINATED BY ");
  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);
2025

2026 2027
  pos= strmov(pos, " ESCAPED BY ");
  pos= pretty_print_str(pos, sql_ex.escaped, sql_ex.escaped_len);
2028

2029 2030
  pos= strmov(pos, " LINES TERMINATED BY ");
  pos= pretty_print_str(pos, sql_ex.line_term, sql_ex.line_term_len);
2031 2032
  if (sql_ex.line_start_len)
  {
2033
    pos= strmov(pos, " STARTING BY ");
2034
    pos= pretty_print_str(pos, sql_ex.line_start, sql_ex.line_start_len);
2035
  }
2036

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2037
  if ((long) skip_lines > 0)
2038 2039
  {
    pos= strmov(pos, " IGNORE ");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2040
    pos= longlong10_to_str((longlong) skip_lines, pos, 10);
2041 2042
    pos= strmov(pos," LINES ");    
  }
2043 2044 2045 2046

  if (num_fields)
  {
    uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2047
    const char *field= fields;
2048
    pos= strmov(pos, " (");
2049 2050 2051
    for (i = 0; i < num_fields; i++)
    {
      if (i)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2052 2053 2054 2055
      {
        *pos++= ' ';
        *pos++= ',';
      }
2056
      memcpy(pos, field, field_lens[i]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2057 2058
      pos+=   field_lens[i];
      field+= field_lens[i]  + 1;
2059
    }
2060
    *pos++= ')';
2061
  }
2062

2063
  protocol->store(buf, pos-buf, &my_charset_bin);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2064
  my_free(buf, MYF(0));
2065
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2066
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
2067

2068

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2069
/*
2070
  Load_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2071
*/
2072

2073
bool Load_log_event::write_data_header(IO_CACHE* file)
2074
{
2075
  char buf[LOAD_HEADER_LEN];
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2076
  int4store(buf + L_THREAD_ID_OFFSET, slave_proxy_id);
2077 2078 2079 2080 2081
  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);
2082
  return my_b_safe_write(file, (byte*)buf, LOAD_HEADER_LEN) != 0;
2083
}
2084

2085

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

2090
bool Load_log_event::write_data_body(IO_CACHE* file)
2091
{
2092 2093 2094
  if (sql_ex.write_data(file))
    return 1;
  if (num_fields && fields && field_lens)
2095
  {
2096 2097 2098
    if (my_b_safe_write(file, (byte*)field_lens, num_fields) ||
	my_b_safe_write(file, (byte*)fields, field_block_len))
      return 1;
2099
  }
2100 2101 2102
  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));
2103 2104
}

2105

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2106
/*
2107
  Load_log_event::Load_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2108
*/
2109

2110
#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2111 2112 2113
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,
2114 2115 2116
			       enum enum_duplicates handle_dup,
			       bool using_trans)
  :Log_event(thd_arg, 0, using_trans), thread_id(thd_arg->thread_id),
2117
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2118 2119
   num_fields(0),fields(0),
   field_lens(0),field_block_len(0),
2120
   table_name(table_name_arg ? table_name_arg : ""),
2121
   db(db_arg), fname(ex->file_name), local_fname(FALSE)
2122 2123 2124
{
  time_t end_time;
  time(&end_time);
2125
  exec_time = (ulong) (end_time  - thd_arg->start_time);
2126 2127 2128
  /* db can never be a zero pointer in 4.0 */
  db_len = (uint32) strlen(db);
  table_name_len = (uint32) strlen(table_name);
2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141
  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;
2142
    
2143
  if (ex->dumpfile)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2144
    sql_ex.opt_flags|= DUMPFILE_FLAG;
2145
  if (ex->opt_enclosed)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2146
    sql_ex.opt_flags|= OPT_ENCLOSED_FLAG;
2147

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2148
  sql_ex.empty_flags= 0;
2149

2150
  switch (handle_dup) {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2151
  case DUP_IGNORE:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2152
    sql_ex.opt_flags|= IGNORE_FLAG;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2153 2154
    break;
  case DUP_REPLACE:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2155
    sql_ex.opt_flags|= REPLACE_FLAG;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2156 2157 2158 2159
    break;
  case DUP_UPDATE:				// Impossible here
  case DUP_ERROR:
    break;	
2160
  }
2161

2162 2163 2164 2165 2166 2167 2168 2169 2170 2171
  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;
2172
    
2173
  skip_lines = ex->skip_lines;
2174

2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185
  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);
2186 2187
  }

2188 2189 2190
  field_lens = (const uchar*)field_lens_buf.ptr();
  fields = fields_buf.ptr();
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2191
#endif /* !MYSQL_CLIENT */
2192

2193

2194
/*
2195
  Load_log_event::Load_log_event()
2196

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2197 2198 2199
  NOTE
    The caller must do buf[event_len] = 0 before he starts using the
    constructed event.
2200 2201
*/

2202 2203
Load_log_event::Load_log_event(const char *buf, uint event_len,
                               const Format_description_log_event *description_event)
2204
  :Log_event(buf, description_event), num_fields(0), fields(0),
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2205
   field_lens(0),field_block_len(0),
2206
   table_name(0), db(0), fname(0), local_fname(FALSE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2207
{
2208
  DBUG_ENTER("Load_log_event");
2209 2210 2211 2212
  /*
    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.
  */
2213 2214 2215 2216 2217 2218 2219 2220 2221
  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 */
  DBUG_VOID_RETURN;
2222 2223
}

2224

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2225
/*
2226
  Load_log_event::copy_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2227
*/
2228

2229
int Load_log_event::copy_log_event(const char *buf, ulong event_len,
2230 2231
                                   int body_offset,
                                   const Format_description_log_event *description_event)
2232
{
2233
  DBUG_ENTER("Load_log_event::copy_log_event");
2234
  uint data_len;
2235
  char* buf_end = (char*)buf + event_len;
2236 2237
  /* 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
2238
  slave_proxy_id= thread_id= uint4korr(data_head + L_THREAD_ID_OFFSET);
2239 2240 2241 2242 2243
  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
2244
	  
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2245
  if ((int) event_len < body_offset)
2246
    DBUG_RETURN(1);
2247 2248 2249 2250
  /*
    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.
  */
2251 2252 2253 2254
  if (!(field_lens= (uchar*)sql_ex.init((char*)buf + body_offset,
                                        buf_end,
                                        buf[EVENT_TYPE_OFFSET] != LOAD_EVENT)))
    DBUG_RETURN(1);
2255 2256
  
  data_len = event_len - body_offset;
2257
  if (num_fields > data_len) // simple sanity check against corruption
2258
    DBUG_RETURN(1);
2259
  for (uint i = 0; i < num_fields; i++)
2260
    field_block_len += (uint)field_lens[i] + 1;
2261

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2262 2263 2264 2265
  fields = (char*)field_lens + num_fields;
  table_name  = fields + field_block_len;
  db = table_name + table_name_len + 1;
  fname = db + db_len + 1;
2266 2267
  fname_len = strlen(fname);
  // null termination is accomplished by the caller doing buf[event_len]=0
2268 2269 2270 2271 2272 2273

  /*
    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)
  */
2274
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2275 2276 2277
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2278
/*
2279
  Load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2280
*/
2281 2282

#ifdef MYSQL_CLIENT
2283
void Load_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2284
{
2285
  print(file, short_form, last_event_info, 0);
2286 2287
}

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

2289
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
2290
			   bool commented)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2291
{
2292
  DBUG_ENTER("Load_log_event::print");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2293 2294
  if (!short_form)
  {
2295
    print_header(file);
2296
    fprintf(file, "\tQuery\tthread_id=%ld\texec_time=%ld\n",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2297 2298 2299
	    thread_id, exec_time);
  }

2300
  bool different_db= 1;
2301
  if (db)
2302
  {
2303 2304 2305 2306 2307 2308
    /*
      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.
    */
pem@mysql.com's avatar
pem@mysql.com committed
2309
    if ((different_db= memcmp(last_event_info->db, db, db_len + 1)) &&
2310
        !commented)
2311
      memcpy(last_event_info->db, db, db_len + 1);
2312
  }
2313
  
2314
  if (db && db[0] && different_db)
2315 2316 2317
    fprintf(file, "%suse %s;\n", 
            commented ? "# " : "",
            db);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2318

2319 2320
  fprintf(file, "%sLOAD DATA ",
          commented ? "# " : "");
2321 2322
  if (check_fname_outside_temp_buf())
    fprintf(file, "LOCAL ");
2323
  fprintf(file, "INFILE '%-*s' ", fname_len, fname);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2324

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2325
  if (sql_ex.opt_flags & REPLACE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2326
    fprintf(file," REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2327
  else if (sql_ex.opt_flags & IGNORE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2328 2329
    fprintf(file," IGNORE ");
  
2330 2331 2332 2333 2334 2335 2336 2337
  fprintf(file, "INTO TABLE `%s`", table_name);
  fprintf(file, " FIELDS TERMINATED BY ");
  pretty_print_str(file, sql_ex.field_term, sql_ex.field_term_len);

  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
2338
     
2339 2340
  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
2341
     
2342 2343 2344
  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
2345

2346
  if (sql_ex.line_start)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2347
  {
2348
    fprintf(file," STARTING BY ");
2349
    pretty_print_str(file, sql_ex.line_start, sql_ex.line_start_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2350
  }
2351 2352
  if ((long) skip_lines > 0)
    fprintf(file, " IGNORE %ld LINES", (long) skip_lines);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2353

2354 2355 2356 2357
  if (num_fields)
  {
    uint i;
    const char* field = fields;
2358 2359
    fprintf(file, " (");
    for (i = 0; i < num_fields; i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2360
    {
2361
      if (i)
2362 2363
	fputc(',', file);
      fprintf(file, field);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2364
	  
2365
      field += field_lens[i]  + 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2366
    }
2367 2368
    fputc(')', file);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2369 2370

  fprintf(file, ";\n");
2371
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2372
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2373
#endif /* MYSQL_CLIENT */
2374

2375

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2376
/*
2377
  Load_log_event::set_fields()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2378
*/
2379

2380
#ifndef MYSQL_CLIENT
2381
void Load_log_event::set_fields(List<Item> &field_list)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2382 2383
{
  uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2384
  const char* field = fields;
2385
  for (i= 0; i < num_fields; i++)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2386
  {
2387 2388
    field_list.push_back(new Item_field(db, table_name, field));	  
    field+= field_lens[i]  + 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2389
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2390
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2391
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2392 2393


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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411
  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.
2412

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2413 2414 2415 2416 2417 2418 2419
  DESCRIPTION
    Does the data loading job when executing a LOAD DATA on the slave
 
  RETURN VALUE
    0           Success                                                 
    1    	Failure
*/
2420

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2421 2422
int Load_log_event::exec_event(NET* net, struct st_relay_log_info* rli, 
			       bool use_rli_only_for_errors)
2423
{
2424
  char *load_data_query= 0;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2425
  thd->db= (char*) rewrite_db(db);
2426
  DBUG_ASSERT(thd->query == 0);
monty@mysql.com's avatar
monty@mysql.com committed
2427
  thd->query_length= 0;                         // Should not be needed
monty@mysql.com's avatar
monty@mysql.com committed
2428
  thd->query_error= 0;
2429
  clear_all_errors(thd, rli);
2430 2431 2432 2433
  /*
    Usually mysql_init_query() is called by mysql_parse(), but we need it here
    as the present method does not call mysql_parse().
  */
2434
  mysql_init_query(thd, 0, 0);
2435 2436 2437 2438
  if (!use_rli_only_for_errors)
  {
    /* Saved for InnoDB, see comment in Query_log_event::exec_event() */
    rli->future_group_master_log_pos= log_pos;
2439
    DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));
2440 2441 2442
  }
 
   /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453
    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).
  */
2454
  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
2455
  {
2456 2457 2458 2459
    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));
2460 2461 2462 2463 2464 2465 2466
    /*
      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);
2467 2468 2469 2470 2471 2472

    TABLE_LIST tables;
    bzero((char*) &tables,sizeof(tables));
    tables.db = thd->db;
    tables.alias = tables.real_name = (char*)table_name;
    tables.lock_type = TL_WRITE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2473
    tables.updating= 1;
2474

2475 2476 2477 2478 2479 2480 2481 2482 2483 2484
    // the table will be opened in mysql_load    
    if (table_rules_on && !tables_ok(thd, &tables))
    {
      // 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
2485
      enum enum_duplicates handle_dup;
2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496 2497 2498
      /*
        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 +
                                               strlen(tables.real_name) + 8)))
      {
        thd->query_length= (uint)(strxmov(load_data_query,
                                          "LOAD DATA INFILE '", fname,
                                          "' INTO TABLE `", tables.real_name,
                                          "` <...>", NullS) - load_data_query);
        thd->query= load_data_query;
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2499 2500
      if (sql_ex.opt_flags & REPLACE_FLAG)
	handle_dup= DUP_REPLACE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2501 2502 2503
      else if (sql_ex.opt_flags & IGNORE_FLAG)
        handle_dup= DUP_IGNORE;
      else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2504
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2505
        /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2506
	  When replication is running fine, if it was DUP_ERROR on the
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2507 2508 2509 2510
          master then we could choose DUP_IGNORE here, because if DUP_ERROR
          suceeded on master, and data is identical on the master and slave,
          then there should be no uniqueness errors on slave, so DUP_IGNORE is
          the same as DUP_ERROR. But in the unlikely case of uniqueness errors
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2511 2512 2513
          (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
2514 2515 2516 2517 2518

          If reading from net (a 3.23 master), mysql_load() will change this
          to DUP_IGNORE.
        */
        handle_dup= DUP_ERROR;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2519
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2520

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2521
      sql_exchange ex((char*)fname, sql_ex.opt_flags & DUMPFILE_FLAG);
2522 2523 2524 2525 2526
      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
2527 2528 2529 2530 2531
      ex.field_term= &field_term;
      ex.enclosed= &enclosed;
      ex.line_term= &line_term;
      ex.line_start= &line_start;
      ex.escaped= &escaped;
2532 2533 2534 2535 2536 2537

      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
2538 2539
      List<Item> field_list;
      set_fields(field_list);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2540
      thd->variables.pseudo_thread_id= thread_id;
2541 2542 2543 2544 2545 2546 2547 2548 2549
      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@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2550
      if (mysql_load(thd, &ex, &tables, field_list, handle_dup, net != 0,
2551
		     TL_WRITE, 0))
2552 2553
	thd->query_error = 1;
      if (thd->cuted_fields)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2554
      {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2555 2556 2557 2558 2559 2560 2561 2562
	/* log_pos is the position of the LOAD event in the master log */
	sql_print_error("\
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(db));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2563
      }
2564 2565 2566
      if (net)
        net->pkt_nr= thd->net.pkt_nr;
    }
2567 2568
  }
  else
2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579
  {
    /*
      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; 
2580
  VOID(pthread_mutex_lock(&LOCK_thread_count));
monty@mysql.com's avatar
monty@mysql.com committed
2581
  thd->db= thd->catalog= 0;
2582 2583 2584
  thd->query= 0;
  thd->query_length= 0;
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
2585
  close_thread_tables(thd);
2586 2587
  if (load_data_query)
    my_afree(load_data_query);
2588 2589
  if (thd->query_error)
  {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2590 2591 2592 2593 2594 2595 2596 2597 2598 2599
    /* this err/sql_errno code is copy-paste from send_error() */
    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
2600
    slave_print_error(rli,sql_errno,"\
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2601
Error '%s' running LOAD DATA INFILE on table '%s'. Default database: '%s'",
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2602
		      err, (char*)table_name, print_slave_db_safe(db));
monty@mysql.com's avatar
monty@mysql.com committed
2603
    free_root(&thd->mem_root,MYF(MY_KEEP_PREALLOC));
2604 2605
    return 1;
  }
monty@mysql.com's avatar
monty@mysql.com committed
2606
  free_root(&thd->mem_root,MYF(MY_KEEP_PREALLOC));
2607
	    
2608
  if (thd->is_fatal_error)
2609
  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2610 2611 2612
    slave_print_error(rli,ER_UNKNOWN_ERROR, "\
Fatal error running LOAD DATA INFILE on table '%s'. Default database: '%s'",
		      (char*)table_name, print_slave_db_safe(db));
2613 2614 2615
    return 1;
  }

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2616
  return ( use_rli_only_for_errors ? 0 : Log_event::exec_event(rli) ); 
2617
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2618
#endif
2619 2620


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2621
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2622
  Rotate_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2623
**************************************************************************/
2624

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2625
/*
2626
  Rotate_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2627
*/
2628

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2629
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2630
void Rotate_log_event::pack_info(Protocol *protocol)
2631
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2632
  char buf1[256], buf[22];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2633
  String tmp(buf1, sizeof(buf1), log_cs);
2634
  tmp.length(0);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2635 2636 2637 2638
  tmp.append(new_log_ident, ident_len);
  tmp.append(";pos=");
  tmp.append(llstr(pos,buf));
  protocol->store(tmp.ptr(), tmp.length(), &my_charset_bin);
2639
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2640
#endif
2641

2642

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2643
/*
2644
  Rotate_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2645
*/
2646 2647

#ifdef MYSQL_CLIENT
2648
void Rotate_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2649
{
2650
  char buf[22];
2651

2652
  if (short_form)
2653 2654
    return;
  print_header(file);
2655 2656 2657
  fprintf(file, "\tRotate to ");
  if (new_log_ident)
    my_fwrite(file, (byte*) new_log_ident, (uint)ident_len, 
2658
              MYF(MY_NABP | MY_WME));
2659
  fprintf(file, "  pos: %s", llstr(pos, buf));
2660
  fputc('\n', file);
2661
  fflush(file);
2662
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2663
#endif /* MYSQL_CLIENT */
2664 2665


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2666
/*
2667
  Rotate_log_event::Rotate_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2668
*/
2669

2670 2671 2672
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)
2673
{
2674
  DBUG_ENTER("Rotate_log_event::Rotate_log_event(char*,...)");
2675
  // The caller will ensure that event_len is what we have at EVENT_LEN_OFFSET
2676 2677
  uint8 header_size= description_event->common_header_len;
  uint8 post_header_len= description_event->post_header_len[ROTATE_EVENT-1];
2678 2679
  uint ident_offset;
  if (event_len < header_size)
2680
    DBUG_VOID_RETURN;
2681
  buf += header_size;
2682 2683 2684 2685
  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; 
2686 2687 2688 2689 2690
  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))))
2691
    DBUG_VOID_RETURN;
2692
  alloced = 1;
2693
  DBUG_VOID_RETURN;
2694
}
2695 2696


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2697
/*
2698
  Rotate_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2699
*/
2700

2701
bool Rotate_log_event::write(IO_CACHE* file)
2702
{
2703
  char buf[ROTATE_HEADER_LEN];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2704
  int8store(buf + R_POS_OFFSET, pos);
2705 2706 2707
  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));
2708 2709
}

2710

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2711
/*
2712 2713
  Rotate_log_event::exec_event()

2714
  Got a rotate log event from the master
2715

2716 2717 2718
  IMPLEMENTATION
    This is mainly used so that we can later figure out the logname and
    position for the master.
2719

2720
    We can't rotate the slave's BINlog as this will cause infinitive rotations
2721
    in a A -> B -> A setup.
2722
    The NOTES below is a wrong comment which will disappear when 4.1 is merged.
2723 2724 2725

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2728
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2729
int Rotate_log_event::exec_event(struct st_relay_log_info* rli)
2730
{
2731 2732 2733
  DBUG_ENTER("Rotate_log_event::exec_event");

  pthread_mutex_lock(&rli->data_lock);
2734
  rli->event_relay_log_pos= my_b_tell(rli->cur_log);
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
2735 2736 2737 2738 2739 2740 2741 2742 2743
  /*
    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
2744 2745
    In that case, we don't want to touch the coordinates which correspond to
    the beginning of the transaction.
2746 2747
    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
2748
  */
2749
  if (!(thd->options & OPTION_BEGIN))
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2750
  {
2751 2752
    memcpy(rli->group_master_log_name, new_log_ident, ident_len+1);
    rli->notify_group_master_log_name_update();
2753 2754 2755 2756 2757
    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,
2758
                        (ulong) rli->group_master_log_pos));
2759 2760 2761 2762 2763 2764 2765 2766 2767
    /*
      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
2768
  }
2769 2770 2771 2772
  pthread_mutex_unlock(&rli->data_lock);
  pthread_cond_broadcast(&rli->data_cond);
  flush_relay_log_info(rli);
  DBUG_RETURN(0);
2773
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2774
#endif
2775 2776


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2777
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2778
	Intvar_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2779
**************************************************************************/
2780

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2781
/*
2782
  Intvar_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2783
*/
2784

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2785
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2786
void Intvar_log_event::pack_info(Protocol *protocol)
2787
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2788 2789
  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
2790
  *pos++= '=';
2791
  pos= longlong10_to_str(val, pos, -10);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2792
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
2793
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2794
#endif
2795

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2797
/*
2798
  Intvar_log_event::Intvar_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2799
*/
2800

2801 2802 2803
Intvar_log_event::Intvar_log_event(const char* buf,
                                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
2804
{
2805 2806 2807
  buf+= description_event->common_header_len;
  type= buf[I_TYPE_OFFSET];
  val= uint8korr(buf+I_VAL_OFFSET);
2808 2809
}

2810

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2811
/*
2812
  Intvar_log_event::get_var_type_name()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2813
*/
2814 2815

const char* Intvar_log_event::get_var_type_name()
2816
{
2817 2818 2819 2820 2821
  switch(type) {
  case LAST_INSERT_ID_EVENT: return "LAST_INSERT_ID";
  case INSERT_ID_EVENT: return "INSERT_ID";
  default: /* impossible */ return "UNKNOWN";
  }
2822 2823
}

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2825
/*
2826
  Intvar_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2827
*/
2828

2829
bool Intvar_log_event::write(IO_CACHE* file)
2830
{
2831 2832
  byte buf[9];
  buf[I_TYPE_OFFSET]= (byte) type;
2833
  int8store(buf + I_VAL_OFFSET, val);
2834 2835
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
2836 2837
}

2838

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2839
/*
2840
  Intvar_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2841
*/
2842 2843

#ifdef MYSQL_CLIENT
2844 2845
void Intvar_log_event::print(FILE* file, bool short_form,
                             LAST_EVENT_INFO* last_event_info)
2846
{
2847 2848 2849
  char llbuff[22];
  const char *msg;
  LINT_INIT(msg);
2850

2851 2852 2853 2854 2855
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tIntvar\n");
  }
2856

2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867
  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);
2868
}
2869
#endif
2870

2871

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2872
/*
2873
  Intvar_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2874
*/
2875

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2876
#if defined(HAVE_REPLICATION)&& !defined(MYSQL_CLIENT)
2877
int Intvar_log_event::exec_event(struct st_relay_log_info* rli)
2878
{
2879 2880 2881 2882 2883 2884 2885 2886 2887
  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;
  }
2888
  rli->inc_event_relay_log_pos();
2889
  return 0;
2890
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2891
#endif
2892

2893

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2894
/**************************************************************************
2895
  Rand_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2896
**************************************************************************/
2897

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2898
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2899
void Rand_log_event::pack_info(Protocol *protocol)
2900
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2901 2902 2903 2904 2905
  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);
2906
  protocol->store(buf1, (uint) (pos-buf1), &my_charset_bin);
2907
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2908
#endif
2909 2910


2911 2912 2913
Rand_log_event::Rand_log_event(const char* buf,
                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
2914
{
2915 2916 2917
  buf+= description_event->common_header_len;
  seed1= uint8korr(buf+RAND_SEED1_OFFSET);
  seed2= uint8korr(buf+RAND_SEED2_OFFSET);
2918 2919
}

2920

2921
bool Rand_log_event::write(IO_CACHE* file)
2922
{
2923
  byte buf[16];
2924 2925
  int8store(buf + RAND_SEED1_OFFSET, seed1);
  int8store(buf + RAND_SEED2_OFFSET, seed2);
2926 2927
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
2928
}
2929

2930 2931

#ifdef MYSQL_CLIENT
2932
void Rand_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2933
{
2934
  char llbuff[22],llbuff2[22];
2935
  if (!short_form)
2936
  {
2937 2938
    print_header(file);
    fprintf(file, "\tRand\n");
2939
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2940
  fprintf(file, "SET @@RAND_SEED1=%s, @@RAND_SEED2=%s;\n",
2941
	  llstr(seed1, llbuff),llstr(seed2, llbuff2));
2942
  fflush(file);
2943
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2944
#endif /* MYSQL_CLIENT */
2945

2946

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2947
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2948
int Rand_log_event::exec_event(struct st_relay_log_info* rli)
2949
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2950 2951
  thd->rand.seed1= (ulong) seed1;
  thd->rand.seed2= (ulong) seed2;
2952
  rli->inc_event_relay_log_pos();
2953 2954
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2955
#endif /* !MYSQL_CLIENT */
2956

2957

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2958
/**************************************************************************
2959
  User_var_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2960
**************************************************************************/
2961

2962
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2963 2964 2965
void User_var_log_event::pack_info(Protocol* protocol)
{
  char *buf= 0;
2966
  uint val_offset= 4 + name_len;
2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981
  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));
2982 2983
      event_len+= my_sprintf(buf + val_offset,
			     (buf + val_offset, "%.14g", real_val));
2984 2985 2986 2987 2988 2989
      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:
2990 2991 2992 2993 2994 2995 2996 2997 2998 2999
      /* 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
      {
3000 3001 3002
        char *p= strxmov(buf + val_offset, "_", cs->csname, " ", NullS);
        p= str_to_hex(p, val, val_len);
        p= strxmov(p, " COLLATE ", cs->name, NullS);
3003 3004
        event_len= p-buf;
      }
3005
      break;
3006
    case ROW_RESULT:
3007
    default:
3008 3009 3010 3011 3012
      DBUG_ASSERT(1);
      return;
    }
  }
  buf[0]= '@';
3013 3014 3015 3016
  buf[1]= '`';
  buf[2+name_len]= '`';
  buf[3+name_len]= '=';
  memcpy(buf+2, name, name_len);
3017
  protocol->store(buf, event_len, &my_charset_bin);
3018 3019
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3020
#endif /* !MYSQL_CLIENT */
3021 3022


3023 3024 3025
User_var_log_event::
User_var_log_event(const char* buf,
                   const Format_description_log_event* description_event)
3026
  :Log_event(buf, description_event)
3027
{
3028
  buf+= description_event->common_header_len;
3029 3030
  name_len= uint4korr(buf);
  name= (char *) buf + UV_NAME_LEN_SIZE;
3031 3032
  buf+= UV_NAME_LEN_SIZE + name_len;
  is_null= (bool) *buf;
3033 3034 3035
  if (is_null)
  {
    type= STRING_RESULT;
3036
    charset_number= my_charset_bin.number;
3037 3038 3039 3040 3041
    val_len= 0;
    val= 0;  
  }
  else
  {
3042 3043 3044
    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 + 
3045
		       UV_CHARSET_NUMBER_SIZE);
3046 3047
    val= (char *) (buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE +
		   UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE);
3048 3049 3050 3051
  }
}


3052
bool User_var_log_event::write(IO_CACHE* file)
3053 3054 3055 3056
{
  char buf[UV_NAME_LEN_SIZE];
  char buf1[UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE + 
	    UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE];
3057 3058
  char buf2[8], *pos= buf2;
  uint buf1_length;
3059
  ulong event_length;
3060

3061
  int4store(buf, name_len);
3062 3063 3064 3065 3066 3067 3068
  
  if ((buf1[0]= is_null))
  {
    buf1_length= 1;
    val_len= 0;
  }    
  else
3069 3070 3071 3072
  {
    buf1[1]= type;
    int4store(buf1 + 2, charset_number);
    int4store(buf1 + 2 + UV_CHARSET_NUMBER_SIZE, val_len);
3073
    buf1_length= 10;
3074 3075 3076 3077 3078 3079 3080 3081 3082 3083 3084

    switch (type) {
    case REAL_RESULT:
      float8store(buf2, *(double*) val);
      break;
    case INT_RESULT:
      int8store(buf2, *(longlong*) val);
      break;
    case STRING_RESULT:
      pos= val;
      break;
3085
    case ROW_RESULT:
3086
    default:
3087 3088 3089 3090
      DBUG_ASSERT(1);
      return 0;
    }
  }
3091 3092 3093 3094 3095 3096

  /* 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))   ||
3097 3098 3099
	  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));
3100 3101
}

3102

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3103
/*
3104
  User_var_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3105
*/
3106 3107

#ifdef MYSQL_CLIENT
3108
void User_var_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3109 3110 3111 3112 3113 3114 3115
{
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tUser_var\n");
  }

3116
  fprintf(file, "SET @`");
3117
  my_fwrite(file, (byte*) name, (uint) (name_len), MYF(MY_NABP | MY_WME));
3118
  fprintf(file, "`");
3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137

  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:
3138
    {
3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152
      /*
        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.
      */
3153 3154 3155 3156
      char *hex_str;
      CHARSET_INFO *cs;

      if (!(hex_str= (char *)my_alloca(2*val_len+1+2))) // 2 hex digits / byte
3157
        break; // no error, as we are 'void'
3158
      str_to_hex(hex_str, val, val_len);
3159 3160 3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171
      /*
        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
3172 3173
        fprintf(file, ":=_%s %s COLLATE %s;\n", cs->csname, hex_str, cs->name);
      my_afree(hex_str);
3174
    }
3175
      break;
3176
    case ROW_RESULT:
3177
    default:
3178
      DBUG_ASSERT(1);
3179 3180 3181 3182 3183
      return;
    }
  }
  fflush(file);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3184
#endif
3185

3186

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3187
/*
3188
  User_var_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3189
*/
3190

3191
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3192 3193 3194
int User_var_log_event::exec_event(struct st_relay_log_info* rli)
{
  Item *it= 0;
3195 3196 3197
  CHARSET_INFO *charset;
  if (!(charset= get_charset(charset_number, MYF(MY_WME))))
    return 1;
3198 3199 3200
  LEX_STRING user_var_name;
  user_var_name.str= name;
  user_var_name.length= name_len;
3201 3202
  double real_val;
  longlong int_val;
3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213

  if (is_null)
  {
    it= new Item_null();
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      float8get(real_val, val);
      it= new Item_real(real_val);
3214
      val= (char*) &real_val;		// Pointer to value in native format
3215
      val_len= 8;
3216 3217
      break;
    case INT_RESULT:
3218 3219 3220
      int_val= (longlong) uint8korr(val);
      it= new Item_int(int_val);
      val= (char*) &int_val;		// Pointer to value in native format
3221
      val_len= 8;
3222 3223 3224 3225
      break;
    case STRING_RESULT:
      it= new Item_string(val, val_len, charset);
      break;
3226
    case ROW_RESULT:
3227
    default:
3228 3229 3230 3231 3232
      DBUG_ASSERT(1);
      return 0;
    }
  }
  Item_func_set_user_var e(user_var_name, it);
3233 3234 3235 3236
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
3237
  e.fix_fields(thd, 0, 0);
3238
  e.update_hash(val, val_len, type, charset, DERIVATION_NONE);
3239 3240
  free_root(&thd->mem_root,0);

3241
  rli->inc_event_relay_log_pos();
3242 3243
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3244
#endif /* !MYSQL_CLIENT */
3245 3246


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3247
/**************************************************************************
3248
  Slave_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3249
**************************************************************************/
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3250

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3251
#ifdef HAVE_REPLICATION
3252
#ifdef MYSQL_CLIENT
3253
void Unknown_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3254 3255 3256 3257 3258 3259 3260 3261
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "# %s", "Unknown event\n");
}
#endif  
3262

3263
#ifndef MYSQL_CLIENT
3264
void Slave_log_event::pack_info(Protocol *protocol)
3265
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3266
  char buf[256+HOSTNAME_LENGTH], *pos;
3267 3268 3269 3270 3271 3272 3273
  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=");
3274
  pos= longlong10_to_str(master_pos, pos, 10);
3275
  protocol->store(buf, pos-buf, &my_charset_bin);
3276
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3277
#endif /* !MYSQL_CLIENT */
3278 3279 3280 3281


#ifndef MYSQL_CLIENT
Slave_log_event::Slave_log_event(THD* thd_arg,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3282
				 struct st_relay_log_info* rli)
3283
  :Log_event(thd_arg, 0, 0) , mem_pool(0), master_host(0)
3284 3285 3286 3287 3288 3289 3290 3291 3292 3293
{
  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);
3294
  master_log_len = strlen(rli->group_master_log_name);
3295 3296 3297
  // 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))))
3298
  {
3299 3300 3301
    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;
3302
    memcpy(master_log, rli->group_master_log_name, master_log_len + 1);
3303
    master_port = mi->port;
3304
    master_pos = rli->group_master_log_pos;
3305 3306
    DBUG_PRINT("info", ("master_log: %s  pos: %d", master_log,
			(ulong) master_pos));
3307
  }
3308 3309 3310 3311 3312 3313
  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
3314
#endif /* !MYSQL_CLIENT */
3315 3316 3317 3318 3319 3320 3321 3322 3323


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


#ifdef MYSQL_CLIENT
3324
void Slave_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3325 3326 3327 3328 3329 3330
{
  char llbuff[22];
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3331 3332
  fprintf(file, "\
Slave: master_host: '%s'  master_port: %d  master_log: '%s'  master_pos: %s\n",
3333 3334
	  master_host, master_port, master_log, llstr(master_pos, llbuff));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3335
#endif /* MYSQL_CLIENT */
3336 3337 3338 3339 3340 3341 3342 3343


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


3344
bool Slave_log_event::write(IO_CACHE* file)
3345
{
3346
  ulong event_length= get_data_size();
3347 3348 3349
  int8store(mem_pool + SL_MASTER_POS_OFFSET, master_pos);
  int2store(mem_pool + SL_MASTER_PORT_OFFSET, master_port);
  // log and host are already there
3350 3351 3352

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) mem_pool, event_length));
3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364
}


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)
3365
  {
3366 3367
    master_host = 0;
    return;
3368
  }
3369 3370
  master_log_len = strlen(master_log);
}
3371

3372

3373 3374 3375
/* 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)
3376
{
3377
  if (event_len < LOG_EVENT_HEADER_LEN)
3378
    return;
3379
  event_len -= LOG_EVENT_HEADER_LEN;
3380 3381 3382 3383 3384
  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);
3385 3386
}

3387

3388 3389 3390 3391 3392 3393 3394
#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
3395
#endif /* !MYSQL_CLIENT */
3396 3397


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3398
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3399
	Stop_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3400
**************************************************************************/
3401

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3402
/*
3403
  Stop_log_event::print()
3404
*/
3405 3406

#ifdef MYSQL_CLIENT
3407
void Stop_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3408 3409 3410 3411 3412 3413 3414
{
  if (short_form)
    return;

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

3418

3419
/*
3420
  Stop_log_event::exec_event()
3421

3422
  The master stopped. 
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3423 3424
  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
3425 3426 3427 3428
  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.
3429
  The place were we must do this cleaning is in Start_log_event_v3::exec_event(),
3430
  not here. Because if we come here, the master was sane.
3431 3432
*/

3433
#ifndef MYSQL_CLIENT
3434
int Stop_log_event::exec_event(struct st_relay_log_info* rli)
3435
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3436 3437
  /*
    We do not want to update master_log pos because we get a rotate event
3438
    before stop, so by now group_master_log_name is set to the next log.
3439
    If we updated it, we will have incorrect master coordinates and this
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3440
    could give false triggers in MASTER_POS_WAIT() that we have reached
3441
    the target position when in fact we have not.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3442
  */
3443 3444 3445 3446 3447 3448 3449
  if (thd->options & OPTION_BEGIN)
    rli->inc_event_relay_log_pos();
  else
  {
    rli->inc_group_relay_log_pos(0);
    flush_relay_log_info(rli);
  }
3450 3451
  return 0;
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3452
#endif /* !MYSQL_CLIENT */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3453
#endif /* HAVE_REPLICATION */
3454

3455

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3456
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3457
	Create_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3458
**************************************************************************/
3459 3460

/*
3461
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3462
*/
3463 3464

#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3465 3466 3467 3468 3469 3470 3471
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,
		      char* block_arg, uint block_len_arg, bool using_trans)
  :Load_log_event(thd_arg,ex,db_arg,table_name_arg,fields_arg,handle_dup,
		  using_trans),
3472
   fake_base(0), block(block_arg), event_buf(0), block_len(block_len_arg),
3473
   file_id(thd_arg->file_id = mysql_bin_log.next_file_id())
3474
{
3475
  DBUG_ENTER("Create_file_log_event");
3476
  sql_ex.force_new_format();
3477
  DBUG_VOID_RETURN;
3478
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3479
#endif /* !MYSQL_CLIENT */
3480

3481

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3482
/*
3483
  Create_file_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3484
*/
3485

3486
bool Create_file_log_event::write_data_body(IO_CACHE* file)
3487
{
3488 3489
  bool res;
  if ((res= Load_log_event::write_data_body(file)) || fake_base)
3490 3491
    return res;
  return (my_b_safe_write(file, (byte*) "", 1) ||
3492
          my_b_safe_write(file, (byte*) block, block_len));
3493 3494
}

3495

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3496
/*
3497
  Create_file_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3498
*/
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3499

3500
bool Create_file_log_event::write_data_header(IO_CACHE* file)
3501
{
3502
  bool res;
3503
  byte buf[CREATE_FILE_HEADER_LEN];
3504 3505
  if ((res= Load_log_event::write_data_header(file)) || fake_base)
    return res;
3506
  int4store(buf + CF_FILE_ID_OFFSET, file_id);
3507
  return my_b_safe_write(file, buf, CREATE_FILE_HEADER_LEN) != 0;
3508 3509 3510
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3511
/*
3512
  Create_file_log_event::write_base()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3513
*/
3514

3515
bool Create_file_log_event::write_base(IO_CACHE* file)
3516
{
3517 3518 3519 3520
  bool res;
  fake_base= 1;                                 // pretend we are Load event
  res= write(file);
  fake_base= 0;
3521 3522 3523 3524
  return res;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3525
/*
3526
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3527
*/
3528

3529 3530 3531 3532
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)
{
3533
  DBUG_ENTER("Create_file_log_event::Create_file_log_event(char*,...)");
3534 3535 3536 3537
  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];
3538 3539
  if (!(event_buf= my_memdup((byte*) buf, len, MYF(MY_WME))) ||
      copy_log_event(event_buf,len,
3540 3541 3542 3543 3544 3545
                     ((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))
3546
    DBUG_VOID_RETURN;
3547
  if (description_event->binlog_version!=1)
3548
  {
3549 3550 3551 3552 3553 3554
    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
3555 3556 3557 3558 3559 3560 3561
      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  
3562
    */
3563 3564 3565
    block_offset= (description_event->common_header_len +
                   Load_log_event::get_data_size() +
                   create_file_header_len + 1);
3566 3567 3568 3569 3570 3571 3572 3573 3574
    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;
3575
  }
3576
  DBUG_VOID_RETURN;
3577 3578
}

3579

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3580
/*
3581
  Create_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3582
*/
3583 3584

#ifdef MYSQL_CLIENT
3585
void Create_file_log_event::print(FILE* file, bool short_form, 
3586
				  LAST_EVENT_INFO* last_event_info, bool enable_local)
nick@mysql.com's avatar
nick@mysql.com committed
3587
{
3588
  if (short_form)
3589 3590
  {
    if (enable_local && check_fname_outside_temp_buf())
3591
      Load_log_event::print(file, 1, last_event_info);
3592
    return;
3593 3594 3595 3596
  }

  if (enable_local)
  {
3597
    Load_log_event::print(file, 1, last_event_info, !check_fname_outside_temp_buf());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3598 3599 3600 3601 3602
    /* 
       That one is for "file_id: etc" below: in mysqlbinlog we want the #, in
       SHOW BINLOG EVENTS we don't.
    */
    fprintf(file, "#"); 
3603 3604
  }

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

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

3609
void Create_file_log_event::print(FILE* file, bool short_form,
3610
				  LAST_EVENT_INFO* last_event_info)
3611
{
3612
  print(file,short_form,last_event_info,0);
3613
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3614
#endif /* MYSQL_CLIENT */
nick@mysql.com's avatar
nick@mysql.com committed
3615

3616

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3617
/*
3618
  Create_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3619
*/
3620

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3621
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3622
void Create_file_log_event::pack_info(Protocol *protocol)
3623
{
3624 3625 3626
  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
3627
  pos= strmov(pos + db_len, ";table=");
3628
  memcpy(pos, table_name, table_name_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3629
  pos= strmov(pos + table_name_len, ";file_id=");
3630 3631 3632
  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
3633
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
3634
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3635
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3636 3637


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3638
/*
3639
  Create_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3640
*/
3641

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3642
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3643
int Create_file_log_event::exec_event(struct st_relay_log_info* rli)
3644
{
3645
  char proc_info[17+FN_REFLEN+10], *fname_buf= proc_info+17;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3646
  char *p;
3647 3648 3649
  int fd = -1;
  IO_CACHE file;
  int error = 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3650

3651
  bzero((char*)&file, sizeof(file));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3652 3653
  p = slave_load_file_stem(fname_buf, file_id, server_id);
  strmov(p, ".info");			// strmov takes less code than memcpy
3654 3655
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
3656 3657 3658 3659 3660
  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)))
  {
3661
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
3662 3663 3664 3665
    goto err;
  }
  
  // a trick to avoid allocating another buffer
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3666
  strmov(p, ".data");
3667 3668 3669 3670
  fname = fname_buf;
  fname_len = (uint)(p-fname) + 5;
  if (write_base(&file))
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3671
    strmov(p, ".info"); // to have it right in the error message
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3672 3673 3674
    slave_print_error(rli,my_errno,
		      "Error in Create_file event: could not write to file '%s'",
		      fname_buf);
3675 3676 3677 3678 3679 3680 3681 3682 3683
    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)
  {
3684
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
3685 3686
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3687
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
3688
  {
3689
    slave_print_error(rli,my_errno, "Error in Create_file event: write to '%s' failed", fname_buf);
3690 3691
    goto err;
  }
3692 3693
  error=0;					// Everything is ok

3694 3695 3696 3697 3698
err:
  if (error)
    end_io_cache(&file);
  if (fd >= 0)
    my_close(fd, MYF(0));
3699
  thd->proc_info= 0;
3700
  return error ? 1 : Log_event::exec_event(rli);
3701
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3702
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3703

3704

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3705
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3706
	Append_block_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3707
**************************************************************************/
3708

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3709
/*
3710
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3711
*/
3712 3713

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3714 3715
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
3716 3717 3718
					       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
3719
   block_len(block_len_arg), file_id(thd_arg->file_id), db(db_arg)
3720 3721
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3722
#endif
3723 3724


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3725
/*
3726
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3727
*/
3728

3729 3730 3731
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)
3732
{
3733
  DBUG_ENTER("Append_block_log_event::Append_block_log_event(char*,...)");
3734 3735 3736 3737 3738
  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)
3739
    DBUG_VOID_RETURN;
3740 3741 3742
  file_id= uint4korr(buf + common_header_len + AB_FILE_ID_OFFSET);
  block= (char*)buf + total_header_len;
  block_len= len - total_header_len;
3743
  DBUG_VOID_RETURN;
3744 3745 3746
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3747
/*
3748
  Append_block_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3749
*/
3750

3751
bool Append_block_log_event::write(IO_CACHE* file)
3752 3753 3754
{
  byte buf[APPEND_BLOCK_HEADER_LEN];
  int4store(buf + AB_FILE_ID_OFFSET, file_id);
3755 3756
  return (write_header(file, APPEND_BLOCK_HEADER_LEN + block_len) ||
          my_b_safe_write(file, buf, APPEND_BLOCK_HEADER_LEN) ||
3757 3758 3759 3760
	  my_b_safe_write(file, (byte*) block, block_len));
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3761
/*
3762
  Append_block_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3763
*/
3764 3765 3766

#ifdef MYSQL_CLIENT  
void Append_block_log_event::print(FILE* file, bool short_form,
3767
				   LAST_EVENT_INFO* last_event_info)
3768 3769 3770 3771 3772 3773 3774 3775
{
  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
3776
#endif /* MYSQL_CLIENT */
3777 3778


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3779
/*
3780
  Append_block_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3781
*/
3782

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3783
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3784
void Append_block_log_event::pack_info(Protocol *protocol)
3785 3786 3787 3788 3789 3790
{
  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
3791
  protocol->store(buf, length, &my_charset_bin);
3792
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3793
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3794 3795


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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3800
#if defined( HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3801
int Append_block_log_event::exec_event(struct st_relay_log_info* rli)
3802
{
3803
  char proc_info[17+FN_REFLEN+10], *fname= proc_info+17;
3804 3805
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
3806
  int error = 1;
3807
  DBUG_ENTER("Append_block_log_event::exec_event");
3808

3809
  memcpy(p, ".data", 6);
3810 3811
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
3812 3813
  if ((fd = my_open(fname, O_WRONLY|O_APPEND|O_BINARY, MYF(MY_WME))) < 0)
  {
3814
    slave_print_error(rli,my_errno, "Error in Append_block event: could not open file '%s'", fname);
3815 3816
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3817
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
3818
  {
3819
    slave_print_error(rli,my_errno, "Error in Append_block event: write to '%s' failed", fname);
3820 3821 3822
    goto err;
  }
  error=0;
3823

3824 3825 3826
err:
  if (fd >= 0)
    my_close(fd, MYF(0));
3827
  thd->proc_info= 0;
3828
  DBUG_RETURN(error ? error : Log_event::exec_event(rli));
3829
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3830
#endif
3831 3832


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3833
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3834
	Delete_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3835
**************************************************************************/
3836

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3837
/*
3838
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3839
*/
3840 3841

#ifndef MYSQL_CLIENT
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3842 3843 3844
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)
3845 3846
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3847
#endif
3848

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3849
/*
3850
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3851
*/
3852

3853 3854 3855
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)
3856
{
3857 3858 3859
  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))
3860
    return;
3861
  file_id= uint4korr(buf + common_header_len + DF_FILE_ID_OFFSET);
3862 3863 3864
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3865
/*
3866
  Delete_file_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3867
*/
3868

3869
bool Delete_file_log_event::write(IO_CACHE* file)
3870 3871 3872
{
 byte buf[DELETE_FILE_HEADER_LEN];
 int4store(buf + DF_FILE_ID_OFFSET, file_id);
3873 3874
 return (write_header(file, sizeof(buf)) ||
         my_b_safe_write(file, buf, sizeof(buf)));
3875 3876 3877
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3878
/*
3879
  Delete_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3880
*/
3881 3882 3883

#ifdef MYSQL_CLIENT  
void Delete_file_log_event::print(FILE* file, bool short_form,
3884
				  LAST_EVENT_INFO* last_event_info)
3885 3886 3887 3888 3889 3890 3891
{
  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
3892
#endif /* MYSQL_CLIENT */
3893

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3894
/*
3895
  Delete_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3896
*/
3897

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3898
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3899
void Delete_file_log_event::pack_info(Protocol *protocol)
3900 3901 3902 3903
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
3904
  protocol->store(buf, (int32) length, &my_charset_bin);
3905
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3906
#endif
3907

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3908
/*
3909
  Delete_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3910
*/
3911

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3912
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3913 3914 3915 3916 3917 3918 3919 3920 3921 3922
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
3923
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
3924 3925


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3926
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3927
	Execute_load_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3928
**************************************************************************/
3929

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3930
/*
3931
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3932
*/
3933 3934

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3935 3936 3937
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)
3938 3939
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3940
#endif
3941 3942
  

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3943
/*
3944
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3945
*/
3946

3947 3948 3949
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)
3950
{
3951 3952 3953
  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))
3954
    return;
3955
  file_id= uint4korr(buf + common_header_len + EL_FILE_ID_OFFSET);
3956 3957 3958
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3959
/*
3960
  Execute_load_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3961
*/
3962

3963
bool Execute_load_log_event::write(IO_CACHE* file)
3964 3965 3966
{
  byte buf[EXEC_LOAD_HEADER_LEN];
  int4store(buf + EL_FILE_ID_OFFSET, file_id);
3967 3968
  return (write_header(file, sizeof(buf)) || 
          my_b_safe_write(file, buf, sizeof(buf)));
3969 3970 3971
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3972
/*
3973
  Execute_load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3974
*/
3975 3976 3977

#ifdef MYSQL_CLIENT  
void Execute_load_log_event::print(FILE* file, bool short_form,
3978
				   LAST_EVENT_INFO* last_event_info)
3979 3980 3981 3982 3983 3984 3985 3986
{
  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
3987
#endif
3988

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3989
/*
3990
  Execute_load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3991
*/
3992

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3993
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3994
void Execute_load_log_event::pack_info(Protocol *protocol)
3995 3996 3997 3998
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
3999
  protocol->store(buf, (int32) length, &my_charset_bin);
4000 4001 4002
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4003
/*
4004
  Execute_load_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4005
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4006

4007
int Execute_load_log_event::exec_event(struct st_relay_log_info* rli)
4008 4009
{
  char fname[FN_REFLEN+10];
4010 4011
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
4012 4013 4014
  int error = 1;
  IO_CACHE file;
  Load_log_event* lev = 0;
4015

4016 4017 4018 4019 4020
  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)))
  {
4021
    slave_print_error(rli,my_errno, "Error in Exec_load event: could not open file '%s'", fname);
4022 4023
    goto err;
  }
4024
  if (!(lev = (Load_log_event*)Log_event::read_log_event(&file,
4025 4026
                                                         (pthread_mutex_t*)0,
                                                         rli->relay_log.description_event_for_exec)) ||
4027
      lev->get_type_code() != NEW_LOAD_EVENT)
4028
  {
4029
    slave_print_error(rli,0, "Error in Exec_load event: file '%s' appears corrupted", fname);
4030 4031
    goto err;
  }
4032

4033
  lev->thd = thd;
4034 4035
  /*
    lev->exec_event should use rli only for errors
4036 4037 4038
    i.e. should not advance rli's position.
    lev->exec_event is the place where the table is loaded (it calls
    mysql_load()).
4039
  */
4040

4041
  rli->future_group_master_log_pos= log_pos;
4042
  if (lev->exec_event(0,rli,1)) 
4043
  {
4044 4045 4046 4047 4048 4049 4050 4051 4052
    /*
      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));
4053 4054 4055 4056 4057 4058 4059 4060
    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));
    }
4061 4062
    goto err;
  }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
4063 4064 4065 4066 4067 4068 4069 4070 4071 4072
  /*
    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;
  }
4073
  (void) my_delete(fname, MYF(MY_WME));
4074
  memcpy(p, ".data", 6);
4075
  (void) my_delete(fname, MYF(MY_WME));
4076
  error = 0;
4077

4078 4079 4080
err:
  delete lev;
  if (fd >= 0)
4081
  {
4082
    my_close(fd, MYF(0));
4083 4084
    end_io_cache(&file);
  }
4085
  return error ? error : Log_event::exec_event(rli);
4086
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4087

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4088
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4089 4090


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4091
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4092
	sql_ex_info methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4093
**************************************************************************/
4094

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4095
/*
4096
  sql_ex_info::write_data()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4097
*/
4098

4099
bool sql_ex_info::write_data(IO_CACHE* file)
4100 4101 4102
{
  if (new_format())
  {
4103 4104 4105 4106 4107
    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) ||
4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119
	    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;
4120
    return my_b_safe_write(file, (byte*) &old_ex, sizeof(old_ex)) != 0;
4121 4122 4123 4124
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4125
/*
4126
  sql_ex_info::init()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4127
*/
4128 4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 4140 4141

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.
    */
4142 4143 4144 4145 4146
    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))
4147 4148 4149 4150 4151 4152 4153 4154 4155 4156 4157 4158 4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172
      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;
}