log_event.cc 148 KB
Newer Older
monty@mysql.com's avatar
monty@mysql.com committed
1
/* Copyright (C) 2000-2004 MySQL AB
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   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.
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   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.
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18
   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
kent@mysql.com's avatar
kent@mysql.com committed
19

20
#ifdef USE_PRAGMA_IMPLEMENTATION
bk@work.mysql.com's avatar
bk@work.mysql.com committed
21 22
#pragma implementation				// gcc: Class implementation
#endif
23

bk@work.mysql.com's avatar
bk@work.mysql.com committed
24
#include  "mysql_priv.h"
25
#include "slave.h"
26
#include <my_dir.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
27 28
#endif /* MYSQL_CLIENT */

29
#define log_cs	&my_charset_latin1
30

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

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

60

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

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

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

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

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

83

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

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

115

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
120
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
121 122 123
static inline char* slave_load_file_stem(char*buf, uint file_id,
					 int event_server_id)
{
124 125 126
  fn_format(buf,"SQL_LOAD-",slave_load_tmpdir, "", MY_UNPACK_FILENAME);
  to_unix_path(buf);

127 128 129 130 131 132 133
  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
134
#endif
135

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

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

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

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

152 153 154
  if (!(dirp=my_dir(slave_load_tmpdir,MYF(MY_WME))))
    return;

155 156 157 158 159 160 161 162 163 164 165 166 167
  /* 
     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;

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

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


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

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


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

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

211

212 213 214
/*
  Transforms a string into "" or its expression in 0x... form.
*/
monty@mysql.com's avatar
monty@mysql.com committed
215

216
char *str_to_hex(char *to, const char *from, uint len)
217 218 219
{
  if (len)
  {
monty@mysql.com's avatar
monty@mysql.com committed
220 221 222
    *to++= '0';
    *to++= 'x';
    to= octet2hex(to, from, len);
223 224
  }
  else
monty@mysql.com's avatar
monty@mysql.com committed
225 226
    to= strmov(to, "\"\"");
  return to;                               // pointer to end 0 of 'to'
227 228
}

229 230 231 232 233 234 235 236 237 238 239 240
/*
  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,", ");
241
    fprintf(file,"%s=%d", name, test(flags & option));
242 243 244
    *need_comma= 1;
  }
}
245

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

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

254 255
const char* Log_event::get_type_str()
{
256
  switch(get_type_code()) {
257
  case START_EVENT_V3:  return "Start_v3";
258 259 260 261 262
  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";
263
  case NEW_LOAD_EVENT:   return "New_load";
264
  case SLAVE_EVENT:  return "Slave";
265 266 267 268
  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";
269
  case RAND_EVENT: return "RAND";
270
  case XID_EVENT: return "Xid";
271
  case USER_VAR_EVENT: return "User var";
272
  case FORMAT_DESCRIPTION_EVENT: return "Format_desc";
273 274
  case BEGIN_LOAD_QUERY_EVENT: return "Begin_load_query";
  case EXECUTE_LOAD_QUERY_EVENT: return "Execute_load_query";
275
  default: return "Unknown";				/* impossible */
276 277 278
  }
}

279

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

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


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

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
Log_event::Log_event(const char* buf,
317
                     const Format_description_log_event* description_event)
318
  :temp_buf(0), cache_stmt(0)
319
{
320 321
#ifndef MYSQL_CLIENT
  thd = 0;
322
#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
  /* 4.0 or newer */
  log_pos= uint4korr(buf + LOG_POS_OFFSET);
  /*
334 335 336 337 338 339 340 341
    If the log is 4.0 (so here it can only be a 4.0 relay log read by
    the SQL thread or a 4.0 master binlog read by the I/O thread),
    log_pos is the beginning of the event: we transform it into the end
    of the event, which is more useful.
    But how do you know that the log is 4.0: you know it if
    description_event is version 3 *and* you are not reading a
    Format_desc (remember that mysqlbinlog starts by assuming that 5.0
    logs are in 4.0 format, until it finds a Format_desc).
342 343 344
  */
  if (description_event->binlog_version==3 &&
      buf[EVENT_TYPE_OFFSET]<FORMAT_DESCRIPTION_EVENT && log_pos)
345
  {
346 347 348
      /*
        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
349 350
        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
351
        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 361 362 363 364 365
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

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

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

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

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

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.
  */
406
  if (rli)
407
  {
408
    /*
409 410 411 412
      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= .
413

414
      CAUTION: opt_using_transactions means
415
      innodb || bdb ; suppose the master supports InnoDB and BDB,
416
      but the slave supports only BDB, problems
417
      will arise:
418 419
      - suppose an InnoDB table is created on the master,
      - then it will be MyISAM on the slave
420 421 422 423 424 425 426 427 428 429 430 431
      - but as opt_using_transactions is true, the slave will believe he
      is transactional with the MyISAM table. And problems will come
      when one 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 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 "transaction". START SLAVE will resume at BEGIN
      while the MyISAM table has already been updated.
432 433
    */
    if ((thd->options & OPTION_BEGIN) && opt_using_transactions)
434
      rli->inc_event_relay_log_pos();
435 436
    else
    {
437
      rli->inc_group_relay_log_pos(log_pos);
438
      flush_relay_log_info(rli);
439
      /* 
440 441
         Note that Rotate_log_event::exec_event() does not call this
         function, so there is no chance that a fake rotate event resets
442
         last_master_timestamp.
443 444 445
         Note that we update without mutex (probably ok - except in some very
         rare cases, only consequence is that value may take some time to
         display in Seconds_Behind_Master - not critical).
446 447
      */
      rli->last_master_timestamp= when;
448
    }
449
  }
monty@mysql.com's avatar
monty@mysql.com committed
450
  DBUG_RETURN(0);
451
}
452

453

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

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


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

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

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


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

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

507

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

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

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

520 521 522 523
  /*
    log_pos != 0 if this is relay-log event. In this case we should not
    change the position
  */
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 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579
  if (is_artificial_event())
  {
    /*
      We should not do any cleanup on slave when reading this. We
      mark this by setting log_pos to 0.  Start_log_event_v3() will
      detect this on reading and set artificial_event=1 for the event.
    */
    log_pos= 0;
  }
  else  if (!log_pos)
  {
    /*
      Calculate position of end of event

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

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

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

    log_pos= my_b_safe_tell(file)+data_written;
  }

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

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

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


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

  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
589
*/
590

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

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

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

648
#ifndef MYSQL_CLIENT
649 650
#define UNLOCK_MUTEX if (log_lock) pthread_mutex_unlock(log_lock);
#define LOCK_MUTEX if (log_lock) pthread_mutex_lock(log_lock);
651
#else
652
#define UNLOCK_MUTEX
653 654 655
#define LOCK_MUTEX
#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
  DBUG_ENTER("Log_event::read_log_event(IO_CACHE *, Format_description_log_event *");
673
  DBUG_ASSERT(description_event != 0);
674 675 676 677 678
  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
679 680
    of 13 bytes, whereas LOG_EVENT_MINIMAL_HEADER_LEN is 19 bytes (it's
    "minimal" over the set {MySQL >=4.0}).
681 682 683
  */
  uint header_size= min(description_event->common_header_len,
                        LOG_EVENT_MINIMAL_HEADER_LEN);
684

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

700
  uint data_len = uint4korr(head + EVENT_LEN_OFFSET);
701 702 703
  char *buf= 0;
  const char *error= 0;
  Log_event *res=  0;
704 705
#ifndef max_allowed_packet
  THD *thd=current_thd;
706
  uint max_allowed_packet= thd ? thd->variables.max_allowed_packet : ~(ulong)0;
707
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
708

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

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

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

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

759

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

766 767 768
Log_event* Log_event::read_log_event(const char* buf, uint event_len,
				     const char **error,
                                     const Format_description_log_event *description_event)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
769
{
770 771
  Log_event* ev;
  DBUG_ENTER("Log_event::read_log_event(char*,...)");
772
  DBUG_ASSERT(description_event != 0);
773
  DBUG_PRINT("info", ("binlog_version: %d", description_event->binlog_version));
774
  if (event_len < EVENT_LEN_OFFSET ||
775 776 777
      (uint) event_len != uint4korr(buf+EVENT_LEN_OFFSET))
  {
    *error="Sanity check failed";		// Needed to free buffer
monty@mysql.com's avatar
monty@mysql.com committed
778
    DBUG_RETURN(NULL); // general sanity check - will fail on a partial read
779
  }
780

781
  switch(buf[EVENT_TYPE_OFFSET]) {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
782
  case QUERY_EVENT:
783
    ev  = new Query_log_event(buf, event_len, description_event, QUERY_EVENT);
784
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
785
  case LOAD_EVENT:
786
    ev = new Load_log_event(buf, event_len, description_event);
787
    break;
788
  case NEW_LOAD_EVENT:
789
    ev = new Load_log_event(buf, event_len, description_event);
790
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
791
  case ROTATE_EVENT:
792
    ev = new Rotate_log_event(buf, event_len, description_event);
793
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
794
#ifdef HAVE_REPLICATION
795
  case SLAVE_EVENT: /* can never happen (unused event) */
796 797
    ev = new Slave_log_event(buf, event_len);
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
798
#endif /* HAVE_REPLICATION */
799
  case CREATE_FILE_EVENT:
800
    ev = new Create_file_log_event(buf, event_len, description_event);
801 802
    break;
  case APPEND_BLOCK_EVENT:
803
    ev = new Append_block_log_event(buf, event_len, description_event);
804 805
    break;
  case DELETE_FILE_EVENT:
806
    ev = new Delete_file_log_event(buf, event_len, description_event);
807 808
    break;
  case EXEC_LOAD_EVENT:
809
    ev = new Execute_load_log_event(buf, event_len, description_event);
810
    break;
811 812
  case START_EVENT_V3: /* this is sent only by MySQL <=4.x */
    ev = new Start_log_event_v3(buf, description_event);
813 814
    break;
  case STOP_EVENT:
815
    ev = new Stop_log_event(buf, description_event);
816 817
    break;
  case INTVAR_EVENT:
818
    ev = new Intvar_log_event(buf, description_event);
819
    break;
820 821 822
  case XID_EVENT:
    ev = new Xid_log_event(buf, description_event);
    break;
nick@mysql.com's avatar
nick@mysql.com committed
823
  case RAND_EVENT:
824
    ev = new Rand_log_event(buf, description_event);
nick@mysql.com's avatar
nick@mysql.com committed
825
    break;
826
  case USER_VAR_EVENT:
827 828 829 830
    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); 
831
    break;
832 833 834 835 836 837
  case BEGIN_LOAD_QUERY_EVENT:
    ev = new Begin_load_query_log_event(buf, event_len, description_event);
    break;
  case EXECUTE_LOAD_QUERY_EVENT:
    ev = new Execute_load_query_log_event(buf, event_len, description_event);
    break;
838
  default:
839 840
    DBUG_PRINT("error",("Unknown evernt code: %d",(int) buf[EVENT_TYPE_OFFSET]));
    ev= NULL;
841
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
842
  }
843

844
  /*
845 846 847 848 849 850 851
    is_valid() are small event-specific sanity tests which are
    important; for example there are some my_malloc() in constructors
    (e.g. Query_log_event::Query_log_event(char*...)); when these
    my_malloc() fail we can't return an error out of the constructor
    (because constructor is "void") ; so instead we leave the pointer we
    wanted to allocate (e.g. 'query') to 0 and we test it in is_valid().
    Same for Format_description_log_event, member 'post_header_len'.
852
  */
853
  if (!ev || !ev->is_valid())
854
  {
855 856
    DBUG_PRINT("error",("Found invalid event in binary log"));

857
    delete ev;
858
#ifdef MYSQL_CLIENT
859
    if (!force_opt) /* then mysqlbinlog dies */
860 861
    {
      *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
862
      DBUG_RETURN(0);
863
    }
864
    ev= new Unknown_log_event(buf, description_event);
865 866
#else
    *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
867
    DBUG_RETURN(0);
868
#endif
869
  }
monty@mysql.com's avatar
monty@mysql.com committed
870
  DBUG_RETURN(ev);  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
871 872
}

873
#ifdef MYSQL_CLIENT
874

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

879 880
void Log_event::print_header(FILE* file)
{
881
  char llbuff[22];
882 883
  fputc('#', file);
  print_timestamp(file);
884
  fprintf(file, " server id %d  end_log_pos %s ", server_id,
885
	  llstr(log_pos,llbuff)); 
886 887
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
888
/*
889
  Log_event::print_timestamp()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
890
*/
891

892
void Log_event::print_timestamp(FILE* file, time_t* ts)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
893
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
894
  struct tm *res;
895 896
  if (!ts)
    ts = &when;
897 898
#ifdef MYSQL_SERVER				// This is always false
  struct tm tm_tmp;
monty@work.mysql.com's avatar
monty@work.mysql.com committed
899
  localtime_r(ts,(res= &tm_tmp));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
900
#else
901
  res=localtime(ts);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
902
#endif
903 904

  fprintf(file,"%02d%02d%02d %2d:%02d:%02d",
905 906 907 908 909 910
	  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
911 912
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
913
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
914 915


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
916
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
917
	Query_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
918
**************************************************************************/
919

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
922
/*
923
  Query_log_event::pack_info()
924 925 926 927
  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
928
*/
929

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

954
#ifndef MYSQL_CLIENT
955

956 957 958 959 960 961 962 963 964 965 966 967
/* Utility function for the next method */
static void write_str_with_code_and_len(char **dst, const char *src,
                                        int len, uint code)
{
  DBUG_ASSERT(src);
  *((*dst)++)= code;
  *((*dst)++)= (uchar) len;
  bmove(*dst, src, len);
  (*dst)+= len;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
968
/*
969
  Query_log_event::write()
bk@work.mysql.com's avatar
bk@work.mysql.com committed
970

971 972 973 974
  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
975
*/
976

977
bool Query_log_event::write(IO_CACHE* file)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
978
{
979 980 981 982 983
  uchar buf[QUERY_HEADER_LEN+
            1+4+           // code of flags2 and flags2
            1+8+           // code of sql_mode and sql_mode
            1+1+FN_REFLEN+ // code of catalog and catalog length and catalog
            1+4+           // code of autoinc and the 2 autoinc variables
984 985
            1+6+           // code of charset and charset
            1+1+MAX_TIME_ZONE_NAME_LENGTH // code of tz and tz length and tz name
986
            ], *start, *start_of_status;
987
  ulong event_length;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
988

989
  if (!query)
990 991
    return 1;                                   // Something wrong with event

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
992 993 994 995 996
  /*
    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.
997
    Now imagine we (write()) are called by the slave SQL thread (we are
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029
    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);
1030 1031 1032 1033
  int4store(buf + Q_EXEC_TIME_OFFSET, exec_time);
  buf[Q_DB_LEN_OFFSET] = (char) db_len;
  int2store(buf + Q_ERR_CODE_OFFSET, error_code);

1034 1035 1036 1037 1038 1039 1040 1041
  /*
    You MUST always write status vars in increasing order of code. This
    guarantees that a slightly older slave will be able to parse those he
    knows.
  */
  start_of_status= start= buf+QUERY_HEADER_LEN;
  if (flags2_inited)
  {
1042
    *start++= Q_FLAGS2_CODE;
1043 1044 1045 1046 1047
    int4store(start, flags2);
    start+= 4;
  }
  if (sql_mode_inited)
  {
1048
    *start++= Q_SQL_MODE_CODE;
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1049
    int8store(start, (ulonglong)sql_mode);
1050 1051
    start+= 8;
  }
1052
  if (catalog_len) // i.e. this var is inited (false for 4.0 events)
1053
  {
1054 1055
    write_str_with_code_and_len((char **)(&start),
                                catalog, catalog_len, Q_CATALOG_NZ_CODE);
1056
    /*
1057 1058 1059 1060 1061 1062
      In 5.0.x where x<4 masters we used to store the end zero here. This was
      a waste of one byte so we don't do it in x>=4 masters. We change code to
      Q_CATALOG_NZ_CODE, because re-using the old code would make x<4 slaves
      of this x>=4 master segfault (expecting a zero when there is
      none). Remaining compatibility problems are: the older slave will not
      find the catalog; but it is will not crash, and it's not an issue
1063 1064 1065 1066 1067
      that it does not find the catalog as catalogs were not used in these
      older MySQL versions (we store it in binlog and read it from relay log
      but do nothing useful with it). What is an issue is that the older slave
      will stop processing the Q_* blocks (and jumps to the db/query) as soon
      as it sees unknown Q_CATALOG_NZ_CODE; so it will not be able to read
1068 1069
      Q_AUTO_INCREMENT*, Q_CHARSET and so replication will fail silently in
      various ways. Documented that you should not mix alpha/beta versions if
1070 1071 1072
      they are not exactly the same version, with example of 5.0.3->5.0.2 and
      5.0.4->5.0.3. If replication is from older to new, the new will
      recognize Q_CATALOG_CODE and have no problem.
1073
    */
1074 1075 1076 1077 1078 1079 1080 1081
  }
  if (auto_increment_increment != 1)
  {
    *start++= Q_AUTO_INCREMENT;
    int2store(start, auto_increment_increment);
    int2store(start+2, auto_increment_offset);
    start+= 4;
  }
1082 1083
  if (charset_inited)
  {
1084
    *start++= Q_CHARSET_CODE;
1085 1086 1087
    memcpy(start, charset, 6);
    start+= 6;
  }
1088 1089 1090 1091 1092 1093 1094 1095 1096
  if (time_zone_len)
  {
    /* In the TZ sys table, column Name is of length 64 so this should be ok */
    DBUG_ASSERT(time_zone_len <= MAX_TIME_ZONE_NAME_LENGTH);
    *start++= Q_TIME_ZONE_CODE;
    *start++= time_zone_len;
    memcpy(start, time_zone_str, time_zone_len);
    start+= time_zone_len;
  }
1097 1098
  /*
    Here there could be code like
1099
    if (command-line-option-which-says-"log_this_variable" && inited)
1100
    {
1101
    *start++= Q_THIS_VARIABLE_CODE;
1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114
    int4store(start, this_variable);
    start+= 4;
    }
  */
  
  /* Store length of status variables */
  status_vars_len= (uint) (start-start_of_status);
  int2store(buf + Q_STATUS_VARS_LEN_OFFSET, status_vars_len);

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

  return (write_header(file, event_length) ||
1118 1119 1120 1121
          my_b_safe_write(file, (byte*) buf, QUERY_HEADER_LEN) ||
          write_post_header_for_derived(file) ||
          my_b_safe_write(file, (byte*) start_of_status,
                          (uint) (start-start_of_status)) ||
1122 1123
          my_b_safe_write(file, (db) ? (byte*) db : (byte*)"", db_len + 1) ||
          my_b_safe_write(file, (byte*) query, q_len)) ? 1 : 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1124 1125
}

1126

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1127
/*
1128
  Query_log_event::Query_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1129
*/
1130
Query_log_event::Query_log_event(THD* thd_arg, const char* query_arg,
1131 1132
				 ulong query_length, bool using_trans,
				 bool suppress_use)
1133
  :Log_event(thd_arg,
1134 1135 1136
	     ((thd_arg->tmp_table_used ? LOG_EVENT_THREAD_SPECIFIC_F : 0)
	      | (suppress_use          ? LOG_EVENT_SUPPRESS_USE_F    : 0)),
	     using_trans),
1137
   data_buf(0), query(query_arg), catalog(thd_arg->catalog),
1138
   db(thd_arg->db), q_len((uint32) query_length),
1139
   error_code((thd_arg->killed != THD::NOT_KILLED) ?
1140
              ((thd_arg->system_thread & SYSTEM_THREAD_DELAYED_INSERT) ?
1141
               0 : thd->killed_errno()) : thd_arg->net.last_errno),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1142 1143
   thread_id(thd_arg->thread_id),
   /* save the original thread id; we already know the server id */
1144
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
1145
   flags2_inited(1), sql_mode_inited(1), charset_inited(1),
1146 1147 1148
   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)
1149 1150 1151 1152
{
  time_t end_time;
  time(&end_time);
  exec_time = (ulong) (end_time  - thd->start_time);
1153
  catalog_len = (catalog) ? (uint32) strlen(catalog) : 0;
1154
  /* status_vars_len is set just before writing the event */
1155
  db_len = (db) ? (uint32) strlen(db) : 0;
1156 1157 1158 1159 1160 1161 1162 1163
  /*
    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;
1164 1165 1166 1167 1168 1169
  DBUG_ASSERT(thd->variables.character_set_client->number < 256*256);
  DBUG_ASSERT(thd->variables.collation_connection->number < 256*256);
  DBUG_ASSERT(thd->variables.collation_server->number < 256*256);
  int2store(charset, thd_arg->variables.character_set_client->number);
  int2store(charset+2, thd_arg->variables.collation_connection->number);
  int2store(charset+4, thd_arg->variables.collation_server->number);
1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181
  if (thd_arg->time_zone_used)
  {
    /*
      Note that our event becomes dependent on the Time_zone object
      representing the time zone. Fortunately such objects are never deleted
      or changed during mysqld's lifetime.
    */
    time_zone_len= thd_arg->variables.time_zone->get_name()->length();
    time_zone_str= thd_arg->variables.time_zone->get_name()->ptr();
  }
  else
    time_zone_len= 0;
1182
  DBUG_PRINT("info",("Query_log_event has flags2=%lu sql_mode=%lu",flags2,sql_mode));
1183
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1184
#endif /* MYSQL_CLIENT */
1185

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

1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205
/* 2 utility functions for the next method */

static void get_str_len_and_pointer(const char **dst, const char **src, uint *len)
{
  if ((*len= **src))
    *dst= *src + 1;                          // Will be copied later
  (*src)+= *len+1;
}


static void copy_str_and_move(char **dst, const char **src, uint len)
{
  memcpy(*dst, *src, len);
  *src= *dst;
  (*dst)+= len;
  *(*dst)++= 0;
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1206
/*
1207
  Query_log_event::Query_log_event()
1208
  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
1209
*/
1210

1211
Query_log_event::Query_log_event(const char* buf, uint event_len,
1212 1213
                                 const Format_description_log_event *description_event,
                                 Log_event_type event_type)
1214
  :Log_event(buf, description_event), data_buf(0), query(NullS),
1215
   db(NullS), catalog_len(0), status_vars_len(0),
1216
   flags2_inited(0), sql_mode_inited(0), charset_inited(0),
1217 1218
   auto_increment_increment(1), auto_increment_offset(1),
   time_zone_len(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1219 1220
{
  ulong data_len;
1221 1222
  uint32 tmp;
  uint8 common_header_len, post_header_len;
1223 1224
  char *start;
  const char *end;
1225
  bool catalog_nz= 1;
1226 1227 1228
  DBUG_ENTER("Query_log_event::Query_log_event(char*,...)");

  common_header_len= description_event->common_header_len;
1229
  post_header_len= description_event->post_header_len[event_type-1];
1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244
  DBUG_PRINT("info",("event_len=%ld, common_header_len=%d, post_header_len=%d",
                     event_len, common_header_len, post_header_len));
  
  /*
    We test if the event's length is sensible, and if so we compute data_len.
    We cannot rely on QUERY_HEADER_LEN here as it would not be format-tolerant.
    We use QUERY_HEADER_MINIMAL_LEN which is the same for 3.23, 4.0 & 5.0.
  */
  if (event_len < (uint)(common_header_len + post_header_len))
    DBUG_VOID_RETURN;				
  data_len = event_len - (common_header_len + post_header_len);
  buf+= common_header_len;
  
  slave_proxy_id= thread_id = uint4korr(buf + Q_THREAD_ID_OFFSET);
  exec_time = uint4korr(buf + Q_EXEC_TIME_OFFSET);
1245
  db_len = (uint)buf[Q_DB_LEN_OFFSET]; // TODO: add a check of all *_len vars
1246 1247 1248 1249 1250 1251 1252 1253 1254
  error_code = uint2korr(buf + Q_ERR_CODE_OFFSET);

  /*
    5.0 format starts here.
    Depending on the format, we may or not have affected/warnings etc
    The remnent post-header to be parsed has length:
  */
  tmp= post_header_len - QUERY_HEADER_MINIMAL_LEN; 
  if (tmp)
1255
  {
1256 1257 1258 1259 1260
    status_vars_len= uint2korr(buf + Q_STATUS_VARS_LEN_OFFSET);
    data_len-= status_vars_len;
    DBUG_PRINT("info", ("Query_log_event has status_vars_len: %u",
                        (uint) status_vars_len));
    tmp-= 2;
1261
  }
1262 1263 1264 1265 1266 1267
  /*
    We have parsed everything we know in the post header for QUERY_EVENT,
    the rest of post header is either comes from older version MySQL or
    dedicated to derived events (e.g. Execute_load_query...)
  */

1268 1269 1270
  /* variable-part: the status vars; only in MySQL 5.0  */
  
  start= (char*) (buf+post_header_len);
1271
  end= (const char*) (start+status_vars_len);
1272
  for (const uchar* pos= (const uchar*) start; pos < (const uchar*) end;)
1273
  {
1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292
    switch (*pos++) {
    case Q_FLAGS2_CODE:
      flags2_inited= 1;
      flags2= uint4korr(pos);
      DBUG_PRINT("info",("In Query_log_event, read flags2: %lu", flags2));
      pos+= 4;
      break;
    case Q_SQL_MODE_CODE:
    {
#ifndef DBUG_OFF
      char buff[22];
#endif
      sql_mode_inited= 1;
      sql_mode= (ulong) uint8korr(pos); // QQ: Fix when sql_mode is ulonglong
      DBUG_PRINT("info",("In Query_log_event, read sql_mode: %s",
			 llstr(sql_mode, buff)));
      pos+= 8;
      break;
    }
1293
    case Q_CATALOG_NZ_CODE:
1294
      get_str_len_and_pointer(&catalog, (const char **)(&pos), &catalog_len);
1295 1296 1297 1298 1299 1300
      break;
    case Q_AUTO_INCREMENT:
      auto_increment_increment= uint2korr(pos);
      auto_increment_offset=    uint2korr(pos+2);
      pos+= 4;
      break;
1301 1302 1303 1304 1305 1306 1307
    case Q_CHARSET_CODE:
    {
      charset_inited= 1;
      memcpy(charset, pos, 6);
      pos+= 6;
      break;
    }
1308 1309
    case Q_TIME_ZONE_CODE:
    {
1310
      get_str_len_and_pointer(&time_zone_str, (const char **)(&pos), &time_zone_len);
1311 1312
      break;
    }
1313 1314 1315 1316 1317 1318
    case Q_CATALOG_CODE: /* for 5.0.x where 0<=x<=3 masters */
      if ((catalog_len= *pos))
        catalog= (char*) pos+1;                           // Will be copied later
      pos+= catalog_len+2; // leap over end 0
      catalog_nz= 0; // catalog has end 0 in event
      break;
1319 1320 1321 1322
    default:
      /* That's why you must write status vars in growing order of code */
      DBUG_PRINT("info",("Query_log_event has unknown status vars (first has\
 code: %u), skipping the rest of them", (uint) *(pos-1)));
1323
      pos= (const uchar*) end;                         // Break loop
1324
    }
1325
  }
1326
  
1327
#if !defined(MYSQL_CLIENT) && defined(HAVE_QUERY_CACHE)
1328 1329
  if (!(start= data_buf = (char*) my_malloc(catalog_len + 1 +
                                            time_zone_len + 1 +
1330 1331 1332 1333 1334 1335 1336 1337 1338
                                            data_len + 1 +
					    QUERY_CACHE_FLAGS_SIZE +
					    db_len + 1,
					    MYF(MY_WME))))
#else
  if (!(start= data_buf = (char*) my_malloc(catalog_len + 1 +
                                            time_zone_len + 1 +
                                            data_len + 1,
					    MYF(MY_WME))))
1339
#endif
1340
      DBUG_VOID_RETURN;
1341
  if (catalog_len)                                  // If catalog is given
1342
  {
1343
    if (likely(catalog_nz)) // true except if event comes from 5.0.0|1|2|3.
1344
      copy_str_and_move(&start, &catalog, catalog_len);
1345 1346 1347 1348 1349 1350
    else
    {
      memcpy(start, catalog, catalog_len+1); // copy end 0
      catalog= start;
      start+= catalog_len+1;
    }
1351
  }
1352
  if (time_zone_len)
1353 1354
    copy_str_and_move(&start, &time_zone_str, time_zone_len);

1355
  /* A 2nd variable part; this is common to all versions */ 
1356
  memcpy((char*) start, end, data_len);          // Copy db and query
1357
  start[data_len]= '\0';              // End query with \0 (For safetly)
1358 1359 1360 1361
  db= start;
  query= start + db_len + 1;
  q_len= data_len - db_len -1;
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1362 1363
}

1364

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1365
/*
1366
  Query_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1367
*/
1368

1369
#ifdef MYSQL_CLIENT
1370 1371
void Query_log_event::print_query_header(FILE* file, bool short_form,
                                         LAST_EVENT_INFO* last_event_info)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1372
{
1373
  // TODO: print the catalog ??
1374
  char buff[40],*end;				// Enough for SET TIMESTAMP
1375 1376 1377
  bool different_db= 1;
  uint32 tmp;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1378 1379
  if (!short_form)
  {
1380
    print_header(file);
1381 1382
    fprintf(file, "\t%s\tthread_id=%lu\texec_time=%lu\terror_code=%d\n",
	    get_type_str(), (ulong) thread_id, (ulong) exec_time, error_code);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1383 1384
  }

monty@mysql.com's avatar
monty@mysql.com committed
1385
  if (!(flags & LOG_EVENT_SUPPRESS_USE_F) && db)
1386
  {
monty@mysql.com's avatar
monty@mysql.com committed
1387
    if (different_db= memcmp(last_event_info->db, db, db_len + 1))
1388
      memcpy(last_event_info->db, db, db_len + 1);
monty@mysql.com's avatar
monty@mysql.com committed
1389
    if (db[0] && different_db) 
1390
      fprintf(file, "use %s;\n", db);
1391
  }
1392

1393 1394 1395 1396
  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));
1397 1398
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
    fprintf(file,"SET @@session.pseudo_thread_id=%lu;\n",(ulong)thread_id);
1399

1400
  /*
1401 1402 1403
    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).
1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432
  */
  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;
    }
  }

  /*
1433 1434 1435 1436 1437 1438 1439 1440 1441 1442
    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.
1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467
  */

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

1468 1469
  /* TODO: print the catalog when we feature SET CATALOG */

1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489
  if (likely(charset_inited))
  {
    if (unlikely(!last_event_info->charset_inited)) /* first Query event */
    {
      last_event_info->charset_inited= 1;
      last_event_info->charset[0]= ~charset[0]; // force a difference to force write
    }
    if (unlikely(bcmp(last_event_info->charset, charset, 6)))
    {
      fprintf(file,"SET "
              "@@session.character_set_client=%d,"
              "@@session.collation_connection=%d,"
              "@@session.collation_server=%d"
              ";\n",
              uint2korr(charset),
              uint2korr(charset+2),
              uint2korr(charset+4));
      memcpy(last_event_info->charset, charset, 6);
    }
  }
1490 1491 1492 1493 1494 1495 1496 1497
  if (time_zone_len)
  {
    if (bcmp(last_event_info->time_zone_str, time_zone_str, time_zone_len+1))
    {
      fprintf(file,"SET @@session.time_zone='%s';\n", time_zone_str);
      memcpy(last_event_info->time_zone_str, time_zone_str, time_zone_len+1);
    }
  }
1498 1499
}

1500

1501 1502 1503 1504
void Query_log_event::print(FILE* file, bool short_form,
                            LAST_EVENT_INFO* last_event_info)
{
  print_query_header(file, short_form, last_event_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1505
  my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
1506
  fputs(";\n", file);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1507
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1508
#endif /* MYSQL_CLIENT */
1509

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1511
/*
1512
  Query_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1513
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1514

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1515
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1516
int Query_log_event::exec_event(struct st_relay_log_info* rli)
1517 1518 1519 1520 1521 1522
{
  return exec_event(rli, query, q_len);
}


int Query_log_event::exec_event(struct st_relay_log_info* rli, const char *query_arg, uint32 q_len_arg)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1523
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1524
  int expected_error,actual_error= 0;
1525 1526 1527 1528 1529 1530
  /*
    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.
  */
1531
  thd->catalog= catalog_len ? (char *) catalog : (char *)"";
1532 1533
  thd->db_length= db_len;
  thd->db= (char*) rewrite_db(db, &thd->db_length);
1534 1535
  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
1536

1537
  /*
1538 1539 1540 1541 1542 1543 1544 1545
    InnoDB internally stores the master log position it has executed so far,
    i.e. the position just after the COMMIT event.
    When InnoDB will want to store, the positions in rli won't have
    been updated yet, so group_master_log_* will point to old BEGIN
    and event_master_log* will point to the beginning of current COMMIT.
    But log_pos of the COMMIT Query event is what we want, i.e. the pos of the
    END of the current log event (COMMIT). We save it in rli so that InnoDB can
    access it.
1546
  */
monty@mysql.com's avatar
monty@mysql.com committed
1547
  rli->future_group_master_log_pos= log_pos;
1548 1549
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

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

lars@mysql.com's avatar
lars@mysql.com committed
1552 1553 1554 1555 1556 1557 1558 1559 1560 1561
  /*
    Note:   We do not need to execute reset_one_shot_variables() if this
            db_ok() test fails.
    Reason: The db stored in binlog events is the same for SET and for
            its companion query.  If the SET is ignored because of
            db_ok(), the companion query will also be ignored, and if
            the companion query is ignored in the db_ok() test of
            ::exec_event(), then the companion SET also have so we
            don't need to reset_one_shot_variables().
  */
1562 1563 1564
  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
  {
    thd->set_time((time_t)when);
1565 1566
    thd->query_length= q_len_arg;
    thd->query= (char*)query_arg;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1567
    VOID(pthread_mutex_lock(&LOCK_thread_count));
1568
    thd->query_id = next_query_id();
1569
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
1570
    thd->variables.pseudo_thread_id= thread_id;		// for temp tables
monty@mysql.com's avatar
monty@mysql.com committed
1571
    DBUG_PRINT("query",("%s",thd->query));
1572

monty@mysql.com's avatar
monty@mysql.com committed
1573
    if (ignored_error_code((expected_error= error_code)) ||
1574
	!check_expected_error(thd,rli,expected_error))
1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610
    {
      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 etc, so nothing to do.
      */
      /*
        We do not replicate IGNORE_DIR_IN_CREATE. That is, if the master is a
        slave which runs with SQL_MODE=IGNORE_DIR_IN_CREATE, this should not
        force us to ignore the dir too. Imagine you are a ring of machines, and
        one has a disk problem so that you temporarily need IGNORE_DIR_IN_CREATE
        on this machine; you don't want it to propagate elsewhere (you don't want
        all slaves to start ignoring the dirs).
      */
      if (sql_mode_inited)
        thd->variables.sql_mode=
          (ulong) ((thd->variables.sql_mode & MODE_NO_DIR_IN_CREATE) |
                   (sql_mode & ~(ulong) MODE_NO_DIR_IN_CREATE));
      if (charset_inited)
      {
        if (rli->cached_charset_compare(charset))
        {
          /* Verify that we support the charsets found in the event. */
          if (!(thd->variables.character_set_client=
                get_charset(uint2korr(charset), MYF(MY_WME))) ||
              !(thd->variables.collation_connection=
                get_charset(uint2korr(charset+2), MYF(MY_WME))) ||
              !(thd->variables.collation_server=
                get_charset(uint2korr(charset+4), MYF(MY_WME))))
          {
            /*
1611 1612 1613 1614
              We updated the thd->variables with nonsensical values (0). Let's
              set them to something safe (i.e. which avoids crash), and we'll
              stop with EE_UNKNOWN_CHARSET in compare_errors (unless set to
              ignore this error).
1615
            */
1616
            set_slave_thread_default_charset(thd, rli);
1617 1618 1619 1620 1621
            goto compare_errors;
          }
          thd->update_charset(); // for the charset change to take effect
        }
      }
1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632
      if (time_zone_len)
      {
        String tmp(time_zone_str, time_zone_len, &my_charset_bin);
        if (!(thd->variables.time_zone=
              my_tz_find_with_opening_tz_tables(thd, &tmp)))
        {
          my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), tmp.c_ptr());
          thd->variables.time_zone= global_system_variables.time_zone;
          goto compare_errors;
        }
      }
1633 1634

      /* Execute the query (note that we bypass dispatch_command()) */
1635
      mysql_parse(thd, thd->query, thd->query_length);
1636 1637

    }
monty@mysql.com's avatar
monty@mysql.com committed
1638 1639
    else
    {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1640
      /*
monty@mysql.com's avatar
monty@mysql.com committed
1641 1642 1643 1644 1645
        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
1646
      */
1647
      if (mysql_test_parse_for_slave(thd, thd->query, thd->query_length))
monty@mysql.com's avatar
monty@mysql.com committed
1648 1649
        clear_all_errors(thd, rli);        /* Can ignore query */
      else
1650
      {
monty@mysql.com's avatar
monty@mysql.com committed
1651
        slave_print_error(rli,expected_error, 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1652
                          "\
monty@mysql.com's avatar
monty@mysql.com committed
1653
Query partially completed on the master (error on master: %d) \
monty@mysql.com's avatar
monty@mysql.com committed
1654 1655 1656
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
1657
START SLAVE; . Query: '%s'", expected_error, thd->query);
monty@mysql.com's avatar
monty@mysql.com committed
1658 1659 1660 1661
        thd->query_error= 1;
      }
      goto end;
    }
1662

1663 1664 1665 1666
    /* If the query was not ignored, it is printed to the general log */
    if (thd->net.last_errno != ER_SLAVE_IGNORED_TABLE)
      mysql_log.write(thd,COM_QUERY,"%s",thd->query);

1667
compare_errors:
lars@mysql.com's avatar
lars@mysql.com committed
1668 1669

     /*
monty@mysql.com's avatar
monty@mysql.com committed
1670 1671 1672 1673
      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",
1674
 		       expected_error, thd->net.last_errno));
monty@mysql.com's avatar
monty@mysql.com committed
1675
    if ((expected_error != (actual_error= thd->net.last_errno)) &&
1676 1677 1678
 	expected_error &&
 	!ignored_error_code(actual_error) &&
 	!ignored_error_code(expected_error))
monty@mysql.com's avatar
monty@mysql.com committed
1679 1680
    {
      slave_print_error(rli, 0,
1681
 			"\
monty@mysql.com's avatar
monty@mysql.com committed
1682
Query caused different errors on master and slave. \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1683
Error on master: '%s' (%d), Error on slave: '%s' (%d). \
monty@mysql.com's avatar
monty@mysql.com committed
1684
Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
1685 1686 1687 1688
			ER_SAFE(expected_error),
			expected_error,
			actual_error ? thd->net.last_error: "no error",
			actual_error,
1689
			print_slave_db_safe(db), query_arg);
monty@mysql.com's avatar
monty@mysql.com committed
1690 1691 1692 1693 1694 1695
      thd->query_error= 1;
    }
    /*
      If we get the same error code as expected, or they should be ignored. 
    */
    else if (expected_error == actual_error ||
1696
 	     ignored_error_code(actual_error))
monty@mysql.com's avatar
monty@mysql.com committed
1697 1698 1699 1700 1701 1702
    {
      DBUG_PRINT("info",("error ignored"));
      clear_all_errors(thd, rli);
    }
    /*
      Other cases: mostly we expected no error and get one.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1703
    */
monty@mysql.com's avatar
monty@mysql.com committed
1704 1705 1706
    else if (thd->query_error || thd->is_fatal_error)
    {
      slave_print_error(rli,actual_error,
monty@mysql.com's avatar
monty@mysql.com committed
1707
			"Error '%s' on query. Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
1708 1709
			(actual_error ? thd->net.last_error :
			 "unexpected success or fatal error"),
1710
			print_slave_db_safe(thd->db), query_arg);
monty@mysql.com's avatar
monty@mysql.com committed
1711 1712
      thd->query_error= 1;
    }
1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726

    /*
      TODO: compare the values of "affected rows" around here. Something
      like:
      if ((uint32) affected_in_event != (uint32) affected_on_slave)
      {
      sql_print_error("Slave: did not get the expected number of affected \
      rows running query from master - expected %d, got %d (this numbers \
      should have matched modulo 4294967296).", 0, ...);
      thd->query_error = 1;
      }
      We may also want an option to tell the slave to ignore "affected"
      mismatch. This mismatch could be implemented with a new ER_ code, and
      to ignore it you would use --slave-skip-errors...
1727

1728 1729 1730 1731 1732 1733 1734
      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
1735 1736
  } /* End of if (db_ok(... */

monty@mysql.com's avatar
monty@mysql.com committed
1737
end:
1738
  VOID(pthread_mutex_lock(&LOCK_thread_count));
1739 1740 1741 1742 1743 1744
  /*
    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
1745 1746 1747
    used. Note that "cleanup" queries like automatic DROP TEMPORARY TABLE
    don't suffer from these assignments to 0 as DROP TEMPORARY
    TABLE uses the db.table syntax.
1748 1749
  */
  thd->db= thd->catalog= 0;	        // prevent db from being freed
1750
  thd->query= 0;			// just to be sure
serg@serg.mylan's avatar
serg@serg.mylan committed
1751
  thd->query_length= thd->db_length =0;
1752
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1753
  close_thread_tables(thd);      
1754
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
1755 1756 1757 1758 1759 1760 1761
  /*
    If there was an error we stop. Otherwise we increment positions. Note that
    we will not increment group* positions if we are just after a SET
    ONE_SHOT, because SET ONE_SHOT should not be separated from its following
    updating query.
  */
  return (thd->query_error ? thd->query_error : 
1762
          (thd->one_shot_set ? (rli->inc_event_relay_log_pos(),0) :
1763
           Log_event::exec_event(rli))); 
1764
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1765
#endif
1766

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1768
/**************************************************************************
1769
	Start_log_event_v3 methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1770
**************************************************************************/
1771

1772 1773 1774 1775 1776 1777 1778 1779
#ifndef MYSQL_CLIENT
Start_log_event_v3::Start_log_event_v3() :Log_event(), binlog_version(BINLOG_VERSION), artificial_event(0)
{
  created= when;
  memcpy(server_version, ::server_version, ST_SERVER_VER_LEN);
}
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1780
/*
1781
  Start_log_event_v3::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1782
*/
1783

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1784
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1785
void Start_log_event_v3::pack_info(Protocol *protocol)
nick@mysql.com's avatar
nick@mysql.com committed
1786
{
1787 1788 1789 1790
  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
1791 1792
  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
1793
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1794
#endif
1795 1796


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1797
/*
1798
  Start_log_event_v3::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1799
*/
nick@mysql.com's avatar
nick@mysql.com committed
1800 1801

#ifdef MYSQL_CLIENT
1802
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
1803
{
1804 1805 1806 1807 1808 1809 1810 1811 1812
  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);
1813 1814 1815
    if (flags & LOG_EVENT_BINLOG_IN_USE_F)
      fprintf(file, "# Warning: this binlog was not closed properly. "
              "Most probably mysqld crashed writing it.\n");
1816
  }
1817 1818
  if (!artificial_event && created)
  {
1819
#ifdef WHEN_WE_HAVE_THE_RESET_CONNECTION_SQL_COMMAND
1820 1821 1822 1823 1824 1825 1826 1827 1828
    /*
      This is for mysqlbinlog: like in replication, we want to delete the stale
      tmp files left by an unclean shutdown of mysqld (temporary tables)
      and rollback unfinished transaction.
      Probably this can be done with RESET CONNECTION (syntax to be defined).
    */
    fprintf(file,"RESET CONNECTION;\n");
#else
    fprintf(file,"ROLLBACK;\n");
1829
#endif
1830
  }
nick@mysql.com's avatar
nick@mysql.com committed
1831 1832
  fflush(file);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1833
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1834

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1835
/*
1836
  Start_log_event_v3::Start_log_event_v3()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1837
*/
1838

1839 1840 1841
Start_log_event_v3::Start_log_event_v3(const char* buf,
                                       const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
1842
{
1843 1844
  buf+= description_event->common_header_len;
  binlog_version= uint2korr(buf+ST_BINLOG_VER_OFFSET);
1845 1846
  memcpy(server_version, buf+ST_SERVER_VER_OFFSET,
	 ST_SERVER_VER_LEN);
1847 1848 1849
  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
1850 1851
}

1852

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1853
/*
1854
  Start_log_event_v3::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1855
*/
1856

1857
#ifndef MYSQL_CLIENT
1858
bool Start_log_event_v3::write(IO_CACHE* file)
1859
{
1860
  char buff[START_V3_HEADER_LEN];
1861 1862 1863
  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);
1864 1865
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, (byte*) buff, sizeof(buff)));
1866
}
1867
#endif
1868

1869

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1870
/*
1871
  Start_log_event_v3::exec_event()
1872 1873 1874 1875

  The master started

  IMPLEMENTATION
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1876 1877 1878 1879
    - 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).
1880 1881

  TODO
1882 1883 1884 1885 1886
    - 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
1887 1888
*/

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1889
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1890
int Start_log_event_v3::exec_event(struct st_relay_log_info* rli)
1891
{
1892
  DBUG_ENTER("Start_log_event_v3::exec_event");
1893
  switch (binlog_version)
1894 1895 1896 1897 1898 1899 1900 1901
  {
  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
1902
    */
1903 1904 1905 1906 1907
    if (created)
    {
      close_temporary_tables(thd);
      cleanup_load_tmpdir();
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1908 1909
    break;

1910
    /*
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1911 1912
       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
1913
    */
1914
  case 1:
1915
    if (strncmp(rli->relay_log.description_event_for_exec->server_version,
1916 1917 1918 1919 1920 1921 1922 1923
                "3.23.57",7) >= 0 && created)
    {
      /*
        Can distinguish, based on the value of 'created': this event was
        generated at master startup.
      */
      close_temporary_tables(thd);
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1924
    /*
1925 1926 1927
      Otherwise, can't distinguish a Start_log_event generated at
      master startup and one generated by master FLUSH LOGS, so cannot
      be sure temp tables have to be dropped. So do nothing.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1928 1929 1930 1931
    */
    break;
  default:
    /* this case is impossible */
1932
    DBUG_RETURN(1);
nick@mysql.com's avatar
nick@mysql.com committed
1933
  }
1934
  DBUG_RETURN(Log_event::exec_event(rli));
1935
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1936
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
1937

1938 1939 1940 1941 1942 1943 1944 1945 1946
/***************************************************************************
       Format_description_log_event methods
****************************************************************************/

/*
  Format_description_log_event 1st ctor.

  SYNOPSIS
    Format_description_log_event::Format_description_log_event
1947
      binlog_version              the binlog version for which we want to build
1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961
                                  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.
*/

Format_description_log_event::
1962
Format_description_log_event(uint8 binlog_ver, const char* server_ver)
1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973
  :Start_log_event_v3()
{
  created= when;
  binlog_version= binlog_ver;
  switch (binlog_ver) {
  case 4: /* MySQL 5.0 */
    memcpy(server_version, ::server_version, ST_SERVER_VER_LEN);
    common_header_len= LOG_EVENT_HEADER_LEN;
    number_of_event_types= LOG_EVENT_TYPES;
    /* we'll catch my_malloc() error in is_valid() */
    post_header_len=(uint8*) my_malloc(number_of_event_types*sizeof(uint8),
1974
                                       MYF(MY_ZEROFILL));
1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991
    /*
      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[ROTATE_EVENT-1]= ROTATE_HEADER_LEN;
      post_header_len[LOAD_EVENT-1]= LOAD_HEADER_LEN;
      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[FORMAT_DESCRIPTION_EVENT-1]= FORMAT_DESCRIPTION_HEADER_LEN;
1992 1993
      post_header_len[BEGIN_LOAD_QUERY_EVENT-1]= post_header_len[APPEND_BLOCK_EVENT-1];
      post_header_len[EXECUTE_LOAD_QUERY_EVENT-1]= EXECUTE_LOAD_QUERY_HEADER_LEN;
1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007
    }
    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 :
2008
      LOG_EVENT_MINIMAL_HEADER_LEN;
2009 2010 2011 2012 2013 2014 2015 2016 2017
    /*
      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),
2018
                                       MYF(0));
2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048
    if (post_header_len)
    {
      post_header_len[START_EVENT_V3-1]= START_V3_HEADER_LEN;
      post_header_len[QUERY_EVENT-1]= QUERY_HEADER_MINIMAL_LEN;
      post_header_len[STOP_EVENT-1]= 0;
      post_header_len[ROTATE_EVENT-1]= (binlog_ver==1) ? 0 : ROTATE_HEADER_LEN;
      post_header_len[INTVAR_EVENT-1]= 0;
      post_header_len[LOAD_EVENT-1]= LOAD_HEADER_LEN;
      post_header_len[SLAVE_EVENT-1]= 0;
      post_header_len[CREATE_FILE_EVENT-1]= CREATE_FILE_HEADER_LEN;
      post_header_len[APPEND_BLOCK_EVENT-1]= APPEND_BLOCK_HEADER_LEN;
      post_header_len[EXEC_LOAD_EVENT-1]= EXEC_LOAD_HEADER_LEN;
      post_header_len[DELETE_FILE_EVENT-1]= DELETE_FILE_HEADER_LEN;
      post_header_len[NEW_LOAD_EVENT-1]= post_header_len[LOAD_EVENT-1];
      post_header_len[RAND_EVENT-1]= 0;
      post_header_len[USER_VAR_EVENT-1]= 0;
    }
    break;
  default: /* Includes binlog version 2 i.e. 4.0.x x<=1 */
    post_header_len= 0; /* will make is_valid() fail */
    break;
  }
}


/*
  The problem with this constructor is that the fixed header may have a
  length different from this version, but we don't know this length as we
  have not read the Format_description_log_event which says it, yet. This
  length is in the post-header of the event, but we don't know where the
2049
  post-header starts.
2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064
  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*
2065
                             description_event)
2066 2067 2068 2069 2070 2071 2072 2073 2074
  :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",
2075
                      common_header_len, number_of_event_types));
2076 2077 2078
  /* If alloc fails, we'll detect it in is_valid() */
  post_header_len= (uint8*) my_memdup((byte*)buf+ST_COMMON_HEADER_LEN_OFFSET+1,
                                      number_of_event_types*
2079
                                      sizeof(*post_header_len), MYF(0));
2080 2081 2082
  DBUG_VOID_RETURN;
}

2083
#ifndef MYSQL_CLIENT
2084 2085 2086 2087 2088 2089 2090 2091 2092 2093
bool Format_description_log_event::write(IO_CACHE* file)
{
  /*
    We don't call Start_log_event_v3::write() because this would make 2
    my_b_safe_write().
  */
  byte buff[FORMAT_DESCRIPTION_HEADER_LEN];
  int2store(buff + ST_BINLOG_VER_OFFSET,binlog_version);
  memcpy((char*) buff + ST_SERVER_VER_OFFSET,server_version,ST_SERVER_VER_LEN);
  int4store(buff + ST_CREATED_OFFSET,created);
2094
  buff[ST_COMMON_HEADER_LEN_OFFSET]= LOG_EVENT_HEADER_LEN;
2095 2096 2097 2098 2099
  memcpy((char*) buff+ST_COMMON_HEADER_LEN_OFFSET+1, (byte*) post_header_len,
         LOG_EVENT_TYPES);
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, buff, sizeof(buff)));
}
2100
#endif
2101

2102 2103 2104
/*
  SYNOPSIS
    Format_description_log_event::exec_event()
2105

2106 2107 2108 2109 2110 2111 2112 2113 2114 2115
  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");
2116 2117

  /* save the information describing this binlog */
2118 2119 2120
  delete rli->relay_log.description_event_for_exec;
  rli->relay_log.description_event_for_exec= this;

serg@serg.mylan's avatar
serg@serg.mylan committed
2121
#ifdef USING_TRANSACTIONS
2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141 2142
  /*
    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.
    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).
  */
  if (!artificial_event && created && thd->transaction.all.nht)
  {
    slave_print_error(rli, 0, "Rolling back unfinished transaction (no "
                      "COMMIT or ROLLBACK) from relay log. A probable cause "
                      "is that the master died while writing the transaction "
                      "to its binary log.");
    end_trans(thd, ROLLBACK);
  }
serg@serg.mylan's avatar
serg@serg.mylan committed
2143
#endif
2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171
  /*
    If this event comes from ourselves, there is no cleaning task to perform,
    we don't call Start_log_event_v3::exec_event() (this was just to update the
    log's description event).
  */
  if (server_id == (uint32) ::server_id)
  {
    /*
      Do not modify rli->group_master_log_pos, as this event did not exist on
      the master. That is, just update the *relay log* coordinates; this is
      done by passing log_pos=0 to inc_group_relay_log_pos, like we do in
      Stop_log_event::exec_event().
      If in a transaction, don't touch group_* coordinates.
    */
    if (thd->options & OPTION_BEGIN)
      rli->inc_event_relay_log_pos();
    else
    {
      rli->inc_group_relay_log_pos(0);
      flush_relay_log_info(rli);
    }
    DBUG_RETURN(0);
  }

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

  /**************************************************************************
2181
        Load_log_event methods
2182
   General note about Load_log_event: the binlogging of LOAD DATA INFILE is
2183
   going to be changed in 5.0 (or maybe in 5.1; not decided yet).
2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195
   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).
  **************************************************************************/
2196

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2197
/*
2198
  Load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2199
*/
2200

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2201
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2202
uint Load_log_event::get_query_buffer_length()
2203
{
2204
  return
2205 2206
    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
2207
    7 +					    // LOCAL
2208
    9 +                                     // " REPLACE or IGNORE "
2209
    13 + table_name_len*2 +                 // "INTO TABLE `table`"
2210 2211 2212 2213
    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'"
2214 2215
    19 + sql_ex.line_start_len*4 + 2 +      // " LINES STARTING BY 'str'"
    15 + 22 +                               // " IGNORE xxx  LINES"
2216
    3 + (num_fields-1)*2 + field_block_len; // " (field1, field2, ...)"
2217
}
2218

2219 2220 2221 2222 2223 2224 2225

void Load_log_event::print_query(bool need_db, char *buf,
                                 char **end, char **fn_start, char **fn_end)
{
  char *pos= buf;

  if (need_db && db && db_len)
2226
  {
2227 2228
    pos= strmov(pos, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2229
    pos= strmov(pos+db_len, "`; ");
2230
  }
2231

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2232
  pos= strmov(pos, "LOAD DATA ");
2233 2234 2235 2236

  if (fn_start)
    *fn_start= pos;

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2237 2238 2239
  if (check_fname_outside_temp_buf())
    pos= strmov(pos, "LOCAL ");
  pos= strmov(pos, "INFILE '");
2240
  memcpy(pos, fname, fname_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2241
  pos= strmov(pos+fname_len, "' ");
2242

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2243
  if (sql_ex.opt_flags & REPLACE_FLAG)
2244
    pos= strmov(pos, " REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2245
  else if (sql_ex.opt_flags & IGNORE_FLAG)
2246 2247
    pos= strmov(pos, " IGNORE ");

2248 2249 2250 2251 2252 2253
  pos= strmov(pos ,"INTO");

  if (fn_end)
    *fn_end= pos;

  pos= strmov(pos ," TABLE `");
2254 2255 2256
  memcpy(pos, table_name, table_name_len);
  pos+= table_name_len;

monty@mysql.com's avatar
monty@mysql.com committed
2257
  /* We have to create all optinal fields as the default is not empty */
2258
  pos= strmov(pos, "` FIELDS TERMINATED BY ");
monty@mysql.com's avatar
monty@mysql.com committed
2259 2260 2261 2262 2263
  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);
2264

monty@mysql.com's avatar
monty@mysql.com committed
2265 2266
  pos= strmov(pos, " ESCAPED BY ");
  pos= pretty_print_str(pos, sql_ex.escaped, sql_ex.escaped_len);
2267

monty@mysql.com's avatar
monty@mysql.com committed
2268 2269
  pos= strmov(pos, " LINES TERMINATED BY ");
  pos= pretty_print_str(pos, sql_ex.line_term, sql_ex.line_term_len);
2270 2271
  if (sql_ex.line_start_len)
  {
2272
    pos= strmov(pos, " STARTING BY ");
2273
    pos= pretty_print_str(pos, sql_ex.line_start, sql_ex.line_start_len);
2274
  }
2275

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2276
  if ((long) skip_lines > 0)
2277 2278
  {
    pos= strmov(pos, " IGNORE ");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2279
    pos= longlong10_to_str((longlong) skip_lines, pos, 10);
2280 2281
    pos= strmov(pos," LINES ");    
  }
2282 2283 2284 2285

  if (num_fields)
  {
    uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2286
    const char *field= fields;
2287
    pos= strmov(pos, " (");
2288 2289 2290
    for (i = 0; i < num_fields; i++)
    {
      if (i)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2291 2292 2293 2294
      {
        *pos++= ' ';
        *pos++= ',';
      }
2295
      memcpy(pos, field, field_lens[i]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2296 2297
      pos+=   field_lens[i];
      field+= field_lens[i]  + 1;
2298
    }
2299
    *pos++= ')';
2300
  }
2301

2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313
  *end= pos;
}


void Load_log_event::pack_info(Protocol *protocol)
{
  char *buf, *end;

  if (!(buf= my_malloc(get_query_buffer_length(), MYF(MY_WME))))
    return;
  print_query(TRUE, buf, &end, 0, 0);
  protocol->store(buf, end-buf, &my_charset_bin);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2314
  my_free(buf, MYF(0));
2315
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2316
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
2317

2318

2319 2320
#ifndef MYSQL_CLIENT

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2321
/*
2322
  Load_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2323
*/
2324

2325
bool Load_log_event::write_data_header(IO_CACHE* file)
2326
{
2327
  char buf[LOAD_HEADER_LEN];
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2328
  int4store(buf + L_THREAD_ID_OFFSET, slave_proxy_id);
2329 2330 2331 2332 2333
  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);
2334
  return my_b_safe_write(file, (byte*)buf, LOAD_HEADER_LEN) != 0;
2335
}
2336

2337

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2338
/*
2339
  Load_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2340
*/
2341

2342
bool Load_log_event::write_data_body(IO_CACHE* file)
2343
{
2344 2345 2346
  if (sql_ex.write_data(file))
    return 1;
  if (num_fields && fields && field_lens)
2347
  {
2348 2349 2350
    if (my_b_safe_write(file, (byte*)field_lens, num_fields) ||
	my_b_safe_write(file, (byte*)fields, field_block_len))
      return 1;
2351
  }
2352 2353 2354
  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));
2355 2356
}

2357

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2358
/*
2359
  Load_log_event::Load_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2360
*/
2361

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2362 2363 2364
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,
2365
			       enum enum_duplicates handle_dup,
2366
			       bool ignore, bool using_trans)
2367 2368 2369
  :Log_event(thd_arg, !thd_arg->tmp_table_used ?
	     0 : LOG_EVENT_THREAD_SPECIFIC_F, using_trans),
   thread_id(thd_arg->thread_id),
2370
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2371 2372
   num_fields(0),fields(0),
   field_lens(0),field_block_len(0),
2373
   table_name(table_name_arg ? table_name_arg : ""),
2374
   db(db_arg), fname(ex->file_name), local_fname(FALSE)
2375 2376 2377
{
  time_t end_time;
  time(&end_time);
2378
  exec_time = (ulong) (end_time  - thd_arg->start_time);
2379 2380 2381
  /* db can never be a zero pointer in 4.0 */
  db_len = (uint32) strlen(db);
  table_name_len = (uint32) strlen(table_name);
2382 2383 2384 2385 2386 2387 2388 2389 2390 2391 2392 2393 2394
  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;
2395
    
2396
  if (ex->dumpfile)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2397
    sql_ex.opt_flags|= DUMPFILE_FLAG;
2398
  if (ex->opt_enclosed)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2399
    sql_ex.opt_flags|= OPT_ENCLOSED_FLAG;
2400

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2401
  sql_ex.empty_flags= 0;
2402

2403
  switch (handle_dup) {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2404
  case DUP_REPLACE:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2405
    sql_ex.opt_flags|= REPLACE_FLAG;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2406 2407 2408 2409
    break;
  case DUP_UPDATE:				// Impossible here
  case DUP_ERROR:
    break;	
2410
  }
2411 2412
  if (ignore)
    sql_ex.opt_flags|= IGNORE_FLAG;
2413

2414 2415 2416 2417 2418 2419 2420 2421 2422 2423
  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;
2424
    
2425
  skip_lines = ex->skip_lines;
2426

2427 2428 2429 2430 2431 2432 2433 2434 2435 2436 2437
  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);
2438 2439
  }

2440 2441 2442
  field_lens = (const uchar*)field_lens_buf.ptr();
  fields = fields_buf.ptr();
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2443
#endif /* !MYSQL_CLIENT */
2444

2445

2446
/*
2447
  Load_log_event::Load_log_event()
2448

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2449 2450 2451
  NOTE
    The caller must do buf[event_len] = 0 before he starts using the
    constructed event.
2452 2453
*/

2454 2455 2456 2457
Load_log_event::Load_log_event(const char *buf, uint event_len,
                               const Format_description_log_event *description_event)
  :Log_event(buf, description_event), num_fields(0), fields(0),
   field_lens(0),field_block_len(0),
monty@mysql.com's avatar
monty@mysql.com committed
2458
   table_name(0), db(0), fname(0), local_fname(FALSE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2459
{
monty@mysql.com's avatar
monty@mysql.com committed
2460
  DBUG_ENTER("Load_log_event");
2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472
  /*
    I (Guilhem) manually tested replication of LOAD DATA INFILE for 3.23->5.0,
    4.0->5.0 and 5.0->5.0 and it works.
  */
  if (event_len)
    copy_log_event(buf, event_len,
                   ((buf[EVENT_TYPE_OFFSET] == LOAD_EVENT) ?
                    LOAD_HEADER_LEN + 
                    description_event->common_header_len :
                    LOAD_HEADER_LEN + LOG_EVENT_HEADER_LEN),
                   description_event);
  /* otherwise it's a derived class, will call copy_log_event() itself */
monty@mysql.com's avatar
monty@mysql.com committed
2473
  DBUG_VOID_RETURN;
2474 2475
}

2476

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2477
/*
2478
  Load_log_event::copy_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2479
*/
2480

2481
int Load_log_event::copy_log_event(const char *buf, ulong event_len,
2482 2483
                                   int body_offset,
                                   const Format_description_log_event *description_event)
2484
{
2485
  DBUG_ENTER("Load_log_event::copy_log_event");
2486
  uint data_len;
2487
  char* buf_end = (char*)buf + event_len;
2488 2489
  /* 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
2490
  slave_proxy_id= thread_id= uint4korr(data_head + L_THREAD_ID_OFFSET);
2491 2492 2493 2494 2495
  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
2496
	  
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2497
  if ((int) event_len < body_offset)
monty@mysql.com's avatar
monty@mysql.com committed
2498
    DBUG_RETURN(1);
2499 2500 2501 2502
  /*
    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.
  */
2503 2504 2505
  if (!(field_lens= (uchar*)sql_ex.init((char*)buf + body_offset,
                                        buf_end,
                                        buf[EVENT_TYPE_OFFSET] != LOAD_EVENT)))
monty@mysql.com's avatar
monty@mysql.com committed
2506
    DBUG_RETURN(1);
2507
  
2508
  data_len = event_len - body_offset;
2509
  if (num_fields > data_len) // simple sanity check against corruption
monty@mysql.com's avatar
monty@mysql.com committed
2510
    DBUG_RETURN(1);
2511
  for (uint i = 0; i < num_fields; i++)
2512
    field_block_len += (uint)field_lens[i] + 1;
2513

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2514 2515 2516 2517
  fields = (char*)field_lens + num_fields;
  table_name  = fields + field_block_len;
  db = table_name + table_name_len + 1;
  fname = db + db_len + 1;
2518 2519
  fname_len = strlen(fname);
  // null termination is accomplished by the caller doing buf[event_len]=0
2520

monty@mysql.com's avatar
monty@mysql.com committed
2521
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2522 2523 2524
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2525
/*
2526
  Load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2527
*/
2528 2529

#ifdef MYSQL_CLIENT
2530
void Load_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2531
{
2532
  print(file, short_form, last_event_info, 0);
2533 2534
}

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

2536
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
2537
			   bool commented)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2538
{
monty@mysql.com's avatar
monty@mysql.com committed
2539
  DBUG_ENTER("Load_log_event::print");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2540 2541
  if (!short_form)
  {
2542
    print_header(file);
2543
    fprintf(file, "\tQuery\tthread_id=%ld\texec_time=%ld\n",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2544 2545 2546
	    thread_id, exec_time);
  }

2547
  bool different_db= 1;
2548
  if (db)
2549
  {
2550 2551 2552 2553 2554 2555
    /*
      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.
    */
2556
    if ((different_db= memcmp(last_event_info->db, db, db_len + 1)) &&
2557
        !commented)
2558
      memcpy(last_event_info->db, db, db_len + 1);
2559
  }
2560
  
2561
  if (db && db[0] && different_db)
2562 2563 2564
    fprintf(file, "%suse %s;\n", 
            commented ? "# " : "",
            db);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2565

2566 2567 2568
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
    fprintf(file,"%sSET @@session.pseudo_thread_id=%lu;\n",
            commented ? "# " : "", (ulong)thread_id);
2569 2570
  fprintf(file, "%sLOAD DATA ",
          commented ? "# " : "");
2571 2572
  if (check_fname_outside_temp_buf())
    fprintf(file, "LOCAL ");
2573
  fprintf(file, "INFILE '%-*s' ", fname_len, fname);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2574

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2575
  if (sql_ex.opt_flags & REPLACE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2576
    fprintf(file," REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2577
  else if (sql_ex.opt_flags & IGNORE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2578 2579
    fprintf(file," IGNORE ");
  
2580
  fprintf(file, "INTO TABLE `%s`", table_name);
monty@mysql.com's avatar
monty@mysql.com committed
2581 2582
  fprintf(file, " FIELDS TERMINATED BY ");
  pretty_print_str(file, sql_ex.field_term, sql_ex.field_term_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2583

monty@mysql.com's avatar
monty@mysql.com committed
2584 2585 2586 2587
  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
2588
     
monty@mysql.com's avatar
monty@mysql.com committed
2589 2590
  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
2591
     
monty@mysql.com's avatar
monty@mysql.com committed
2592 2593 2594
  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
2595

2596
  if (sql_ex.line_start)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2597
  {
2598
    fprintf(file," STARTING BY ");
2599
    pretty_print_str(file, sql_ex.line_start, sql_ex.line_start_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2600
  }
2601 2602
  if ((long) skip_lines > 0)
    fprintf(file, " IGNORE %ld LINES", (long) skip_lines);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2603

2604 2605 2606 2607
  if (num_fields)
  {
    uint i;
    const char* field = fields;
2608 2609
    fprintf(file, " (");
    for (i = 0; i < num_fields; i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2610
    {
2611
      if (i)
2612 2613
	fputc(',', file);
      fprintf(file, field);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2614
	  
2615
      field += field_lens[i]  + 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2616
    }
2617 2618
    fputc(')', file);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2619 2620

  fprintf(file, ";\n");
monty@mysql.com's avatar
monty@mysql.com committed
2621
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2622
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2623
#endif /* MYSQL_CLIENT */
2624

2625

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2626
/*
2627
  Load_log_event::set_fields()
lars@mysql.com's avatar
lars@mysql.com committed
2628 2629 2630 2631 2632

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

2635
#ifndef MYSQL_CLIENT
lars@mysql.com's avatar
lars@mysql.com committed
2636
void Load_log_event::set_fields(const char* affected_db, 
2637 2638
				List<Item> &field_list,
                                Name_resolution_context *context)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2639 2640
{
  uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2641
  const char* field = fields;
2642
  for (i= 0; i < num_fields; i++)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2643
  {
2644 2645
    field_list.push_back(new Item_field(context,
                                        affected_db, table_name, field));
2646
    field+= field_lens[i]  + 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2647
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2648
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2649
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2650 2651


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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669
  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.
2670

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2671 2672 2673 2674 2675 2676 2677
  DESCRIPTION
    Does the data loading job when executing a LOAD DATA on the slave
 
  RETURN VALUE
    0           Success                                                 
    1    	Failure
*/
2678

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2679 2680
int Load_log_event::exec_event(NET* net, struct st_relay_log_info* rli, 
			       bool use_rli_only_for_errors)
2681
{
2682 2683
  thd->db_length= db_len;
  thd->db= (char*) rewrite_db(db, &thd->db_length);
2684
  DBUG_ASSERT(thd->query == 0);
monty@mysql.com's avatar
monty@mysql.com committed
2685
  thd->query_length= 0;                         // Should not be needed
monty@mysql.com's avatar
monty@mysql.com committed
2686
  thd->query_error= 0;
monty@mysql.com's avatar
monty@mysql.com committed
2687
  clear_all_errors(thd, rli);
2688 2689 2690 2691
  /*
    Usually mysql_init_query() is called by mysql_parse(), but we need it here
    as the present method does not call mysql_parse().
  */
2692
  mysql_init_query(thd, 0, 0);
monty@mysql.com's avatar
monty@mysql.com committed
2693
  if (!use_rli_only_for_errors)
2694
  {
2695
    /* Saved for InnoDB, see comment in Query_log_event::exec_event() */
monty@mysql.com's avatar
monty@mysql.com committed
2696
    rli->future_group_master_log_pos= log_pos;
2697
    DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));
2698
  }
2699 2700
 
   /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2701 2702 2703 2704 2705 2706 2707 2708 2709 2710
    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).
lars@mysql.com's avatar
lars@mysql.com committed
2711 2712 2713 2714 2715 2716 2717 2718 2719 2720


    Note:   We do not need to execute reset_one_shot_variables() if this
            db_ok() test fails.
    Reason: The db stored in binlog events is the same for SET and for
            its companion query.  If the SET is ignored because of
            db_ok(), the companion query will also be ignored, and if
            the companion query is ignored in the db_ok() test of
            ::exec_event(), then the companion SET also have so we
            don't need to reset_one_shot_variables().
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2721
  */
2722
  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
2723
  {
2724 2725
    thd->set_time((time_t)when);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
2726
    thd->query_id = next_query_id();
2727
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
2728 2729 2730 2731 2732 2733
    /*
      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.
    */
monty@mysql.com's avatar
monty@mysql.com committed
2734
    mysql_reset_errors(thd, 0);
2735 2736 2737 2738

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

2743 2744 2745 2746 2747 2748 2749 2750 2751 2752
    // 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];
2753
      char *end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2754
      enum enum_duplicates handle_dup;
2755
      bool ignore= 0;
2756 2757
      char *load_data_query;

2758
      /*
2759 2760
        Forge LOAD DATA INFILE query which will be used in SHOW PROCESS LIST
        and written to slave's binlog if binlogging is on.
2761
      */
2762
      if (!(load_data_query= (char *)thd->alloc(get_query_buffer_length() + 1)))
2763
      {
2764 2765 2766 2767 2768
        /*
          This will set thd->fatal_error in case of OOM. So we surely will notice
          that something is wrong.
        */
        goto error;
2769
      }
2770 2771 2772 2773 2774 2775 2776

      print_query(FALSE, load_data_query, &end, (char **)&thd->lex->fname_start,
                  (char **)&thd->lex->fname_end);
      *end= 0;
      thd->query_length= end - load_data_query;
      thd->query= load_data_query;

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2777
      if (sql_ex.opt_flags & REPLACE_FLAG)
2778
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2779
	handle_dup= DUP_REPLACE;
2780
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2781
      else if (sql_ex.opt_flags & IGNORE_FLAG)
2782 2783 2784 2785
      {
        ignore= 1;
        handle_dup= DUP_ERROR;
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2786
      else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2787
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2788
        /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2789
	  When replication is running fine, if it was DUP_ERROR on the
2790
          master then we could choose IGNORE here, because if DUP_ERROR
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2791
          suceeded on master, and data is identical on the master and slave,
2792
          then there should be no uniqueness errors on slave, so IGNORE is
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2793
          the same as DUP_ERROR. But in the unlikely case of uniqueness errors
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2794 2795 2796
          (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
2797 2798

          If reading from net (a 3.23 master), mysql_load() will change this
2799
          to IGNORE.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2800 2801
        */
        handle_dup= DUP_ERROR;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2802
      }
2803 2804 2805 2806 2807 2808 2809 2810 2811 2812
      /*
        We need to set thd->lex->sql_command and thd->lex->duplicates
        since InnoDB tests these variables to decide if this is a LOAD
        DATA ... REPLACE INTO ... statement even though mysql_parse()
        is not called.  This is not needed in 5.0 since there the LOAD
        DATA ... statement is replicated using mysql_parse(), which
        sets the thd->lex fields correctly.
      */
      thd->lex->sql_command= SQLCOM_LOAD;
      thd->lex->duplicates= handle_dup;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2813

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2814
      sql_exchange ex((char*)fname, sql_ex.opt_flags & DUMPFILE_FLAG);
2815 2816 2817 2818 2819
      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
2820 2821 2822 2823 2824
      ex.field_term= &field_term;
      ex.enclosed= &enclosed;
      ex.line_term= &line_term;
      ex.line_start= &line_start;
      ex.escaped= &escaped;
2825 2826 2827 2828 2829 2830

      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
2831
      List<Item> field_list;
2832 2833
      thd->main_lex.select_lex.context.resolve_in_table_list_only(&tables);
      set_fields(thd->db, field_list, &thd->main_lex.select_lex.context);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2834
      thd->variables.pseudo_thread_id= thread_id;
2835
      List<Item> set_fields;
2836 2837 2838 2839 2840 2841 2842 2843 2844
      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;
      }
2845 2846 2847 2848 2849
      /*
        It is safe to use set_fields twice because we are not going to
        update it inside mysql_load().
      */
      if (mysql_load(thd, &ex, &tables, field_list, set_fields, set_fields,
2850
                     handle_dup, ignore, net != 0))
2851
        thd->query_error= 1;
2852
      if (thd->cuted_fields)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2853
      {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2854
	/* log_pos is the position of the LOAD event in the master log */
lars@mysql.com's avatar
lars@mysql.com committed
2855 2856 2857 2858 2859 2860 2861
        sql_print_warning("Slave: load data infile on table '%s' at "
                          "log position %s in log '%s' produced %ld "
                          "warning(s). Default database: '%s'",
                          (char*) table_name,
                          llstr(log_pos,llbuff), RPL_LOG_NAME, 
                          (ulong) thd->cuted_fields,
                          print_slave_db_safe(thd->db));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2862
      }
2863 2864 2865
      if (net)
        net->pkt_nr= thd->net.pkt_nr;
    }
2866 2867
  }
  else
2868 2869 2870 2871 2872 2873 2874 2875 2876
  {
    /*
      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);
  }
2877 2878

error:
2879
  thd->net.vio = 0; 
2880
  char *save_db= thd->db;
2881
  VOID(pthread_mutex_lock(&LOCK_thread_count));
2882
  thd->db= thd->catalog= 0;
2883
  thd->query= 0;
serg@serg.mylan's avatar
serg@serg.mylan committed
2884
  thd->query_length= thd->db_length= 0;
2885
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
2886 2887 2888
  close_thread_tables(thd);
  if (thd->query_error)
  {
2889
    /* this err/sql_errno code is copy-paste from net_send_error() */
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2890 2891 2892 2893 2894 2895 2896 2897 2898
    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
2899
    slave_print_error(rli,sql_errno,"\
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2900
Error '%s' running LOAD DATA INFILE on table '%s'. Default database: '%s'",
2901
		      err, (char*)table_name, print_slave_db_safe(save_db));
2902
    free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
2903 2904
    return 1;
  }
2905
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
2906
	    
2907
  if (thd->is_fatal_error)
2908
  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2909 2910
    slave_print_error(rli,ER_UNKNOWN_ERROR, "\
Fatal error running LOAD DATA INFILE on table '%s'. Default database: '%s'",
2911
		      (char*)table_name, print_slave_db_safe(save_db));
2912 2913 2914
    return 1;
  }

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2915
  return ( use_rli_only_for_errors ? 0 : Log_event::exec_event(rli) ); 
2916
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2917
#endif
2918 2919


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2920
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2921
  Rotate_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2922
**************************************************************************/
2923

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2924
/*
2925
  Rotate_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2926
*/
2927

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2928
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2929
void Rotate_log_event::pack_info(Protocol *protocol)
2930
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2931
  char buf1[256], buf[22];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2932
  String tmp(buf1, sizeof(buf1), log_cs);
2933
  tmp.length(0);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2934 2935 2936 2937
  tmp.append(new_log_ident, ident_len);
  tmp.append(";pos=");
  tmp.append(llstr(pos,buf));
  protocol->store(tmp.ptr(), tmp.length(), &my_charset_bin);
2938
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2939
#endif
2940

2941

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2942
/*
2943
  Rotate_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2944
*/
2945 2946

#ifdef MYSQL_CLIENT
2947
void Rotate_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
2948
{
2949
  char buf[22];
2950

2951
  if (short_form)
2952 2953
    return;
  print_header(file);
2954 2955 2956
  fprintf(file, "\tRotate to ");
  if (new_log_ident)
    my_fwrite(file, (byte*) new_log_ident, (uint)ident_len, 
2957
              MYF(MY_NABP | MY_WME));
2958
  fprintf(file, "  pos: %s", llstr(pos, buf));
2959
  fputc('\n', file);
2960
  fflush(file);
2961
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2962
#endif /* MYSQL_CLIENT */
2963 2964


2965

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2966
/*
2967
  Rotate_log_event::Rotate_log_event() (2 constructors)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2968
*/
2969

2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994

#ifndef MYSQL_CLIENT
Rotate_log_event::Rotate_log_event(THD* thd_arg,
                                   const char* new_log_ident_arg,
                                   uint ident_len_arg, ulonglong pos_arg,
                                   uint flags_arg)
  :Log_event(), new_log_ident(new_log_ident_arg),
   pos(pos_arg),ident_len(ident_len_arg ? ident_len_arg :
                          (uint) strlen(new_log_ident_arg)), flags(flags_arg)
{
#ifndef DBUG_OFF
  char buff[22];
  DBUG_ENTER("Rotate_log_event::Rotate_log_event(THD*,...)");
  DBUG_PRINT("enter",("new_log_ident %s pos %s flags %lu", new_log_ident_arg,
                      llstr(pos_arg, buff), flags));
#endif
  if (flags & DUP_NAME)
    new_log_ident= my_strdup_with_length(new_log_ident_arg,
                                         ident_len,
                                         MYF(MY_WME));
  DBUG_VOID_RETURN;
}
#endif


2995 2996
Rotate_log_event::Rotate_log_event(const char* buf, uint event_len,
                                   const Format_description_log_event* description_event)
2997
  :Log_event(buf, description_event) ,new_log_ident(0), flags(DUP_NAME)
2998
{
2999
  DBUG_ENTER("Rotate_log_event::Rotate_log_event(char*,...)");
3000
  // The caller will ensure that event_len is what we have at EVENT_LEN_OFFSET
3001 3002
  uint8 header_size= description_event->common_header_len;
  uint8 post_header_len= description_event->post_header_len[ROTATE_EVENT-1];
3003 3004
  uint ident_offset;
  if (event_len < header_size)
monty@mysql.com's avatar
monty@mysql.com committed
3005
    DBUG_VOID_RETURN;
3006
  buf += header_size;
3007 3008 3009 3010
  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; 
3011
  set_if_smaller(ident_len,FN_REFLEN-1);
3012 3013 3014
  new_log_ident= my_strdup_with_length((byte*) buf + ident_offset,
                                       (uint) ident_len,
                                       MYF(MY_WME));
monty@mysql.com's avatar
monty@mysql.com committed
3015
  DBUG_VOID_RETURN;
3016
}
3017 3018


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3019
/*
3020
  Rotate_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3021
*/
3022

3023
#ifndef MYSQL_CLIENT
3024
bool Rotate_log_event::write(IO_CACHE* file)
3025
{
3026
  char buf[ROTATE_HEADER_LEN];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3027
  int8store(buf + R_POS_OFFSET, pos);
3028 3029 3030
  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));
3031
}
3032
#endif
3033

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3034
/*
3035 3036
  Rotate_log_event::exec_event()

3037
  Got a rotate log event from the master
3038

3039 3040 3041
  IMPLEMENTATION
    This is mainly used so that we can later figure out the logname and
    position for the master.
3042

3043
    We can't rotate the slave's BINlog as this will cause infinitive rotations
3044
    in a A -> B -> A setup.
3045
    The NOTES below is a wrong comment which will disappear when 4.1 is merged.
3046 3047 3048

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3051
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3052
int Rotate_log_event::exec_event(struct st_relay_log_info* rli)
3053
{
3054 3055 3056
  DBUG_ENTER("Rotate_log_event::exec_event");

  pthread_mutex_lock(&rli->data_lock);
3057
  rli->event_relay_log_pos= my_b_tell(rli->cur_log);
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
3058 3059 3060 3061 3062 3063 3064 3065 3066
  /*
    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
3067 3068
    In that case, we don't want to touch the coordinates which correspond to
    the beginning of the transaction.
3069 3070
    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
3071
  */
3072
  if (!(thd->options & OPTION_BEGIN))
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3073
  {
3074 3075
    memcpy(rli->group_master_log_name, new_log_ident, ident_len+1);
    rli->notify_group_master_log_name_update();
3076 3077 3078 3079 3080
    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,
3081
                        (ulong) rli->group_master_log_pos));
3082
    /*
3083 3084
      Reset thd->options and sql_mode etc, because this could be the signal of
      a master's downgrade from 5.0 to 4.0.
3085 3086 3087 3088 3089
      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);
3090
    set_slave_thread_default_charset(thd, rli);
3091
    thd->variables.sql_mode= global_system_variables.sql_mode;
3092 3093
    thd->variables.auto_increment_increment=
      thd->variables.auto_increment_offset= 1;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3094
  }
3095 3096 3097 3098
  pthread_mutex_unlock(&rli->data_lock);
  pthread_cond_broadcast(&rli->data_cond);
  flush_relay_log_info(rli);
  DBUG_RETURN(0);
3099
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3100
#endif
3101 3102


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3103
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3104
	Intvar_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3105
**************************************************************************/
3106

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3107
/*
3108
  Intvar_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3109
*/
3110

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3111
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3112
void Intvar_log_event::pack_info(Protocol *protocol)
3113
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3114 3115
  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
3116
  *pos++= '=';
3117
  pos= longlong10_to_str(val, pos, -10);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3118
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
3119
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3120
#endif
3121

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3123
/*
3124
  Intvar_log_event::Intvar_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3125
*/
3126

3127 3128 3129
Intvar_log_event::Intvar_log_event(const char* buf,
                                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3130
{
3131 3132 3133
  buf+= description_event->common_header_len;
  type= buf[I_TYPE_OFFSET];
  val= uint8korr(buf+I_VAL_OFFSET);
3134 3135
}

3136

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

const char* Intvar_log_event::get_var_type_name()
3142
{
3143 3144 3145 3146 3147
  switch(type) {
  case LAST_INSERT_ID_EVENT: return "LAST_INSERT_ID";
  case INSERT_ID_EVENT: return "INSERT_ID";
  default: /* impossible */ return "UNKNOWN";
  }
3148 3149
}

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3151
/*
3152
  Intvar_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3153
*/
3154

3155
#ifndef MYSQL_CLIENT
3156
bool Intvar_log_event::write(IO_CACHE* file)
3157
{
3158 3159
  byte buf[9];
  buf[I_TYPE_OFFSET]= (byte) type;
3160
  int8store(buf + I_VAL_OFFSET, val);
3161 3162
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
3163
}
3164
#endif
3165

3166

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3167
/*
3168
  Intvar_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3169
*/
3170 3171

#ifdef MYSQL_CLIENT
3172 3173
void Intvar_log_event::print(FILE* file, bool short_form,
                             LAST_EVENT_INFO* last_event_info)
3174
{
3175 3176 3177
  char llbuff[22];
  const char *msg;
  LINT_INIT(msg);
3178

3179 3180 3181 3182 3183
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tIntvar\n");
  }
3184

3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195
  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);
3196
}
3197
#endif
3198

3199

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3200
/*
3201
  Intvar_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3202
*/
3203

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3204
#if defined(HAVE_REPLICATION)&& !defined(MYSQL_CLIENT)
3205
int Intvar_log_event::exec_event(struct st_relay_log_info* rli)
3206
{
3207 3208 3209 3210 3211 3212 3213 3214 3215
  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;
  }
3216
  rli->inc_event_relay_log_pos();
3217
  return 0;
3218
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3219
#endif
3220

3221

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3222
/**************************************************************************
3223
  Rand_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3224
**************************************************************************/
3225

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3226
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3227
void Rand_log_event::pack_info(Protocol *protocol)
3228
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3229 3230 3231 3232 3233
  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);
3234
  protocol->store(buf1, (uint) (pos-buf1), &my_charset_bin);
3235
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3236
#endif
3237 3238


3239 3240 3241
Rand_log_event::Rand_log_event(const char* buf,
                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3242
{
3243 3244 3245
  buf+= description_event->common_header_len;
  seed1= uint8korr(buf+RAND_SEED1_OFFSET);
  seed2= uint8korr(buf+RAND_SEED2_OFFSET);
3246 3247
}

3248

3249
#ifndef MYSQL_CLIENT
3250
bool Rand_log_event::write(IO_CACHE* file)
3251
{
3252
  byte buf[16];
3253 3254
  int8store(buf + RAND_SEED1_OFFSET, seed1);
  int8store(buf + RAND_SEED2_OFFSET, seed2);
3255 3256
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
3257
}
3258
#endif
3259

3260 3261

#ifdef MYSQL_CLIENT
3262
void Rand_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3263
{
3264
  char llbuff[22],llbuff2[22];
3265
  if (!short_form)
3266
  {
3267 3268
    print_header(file);
    fprintf(file, "\tRand\n");
3269
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3270
  fprintf(file, "SET @@RAND_SEED1=%s, @@RAND_SEED2=%s;\n",
3271
	  llstr(seed1, llbuff),llstr(seed2, llbuff2));
3272
  fflush(file);
3273
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3274
#endif /* MYSQL_CLIENT */
3275

3276

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3277
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3278
int Rand_log_event::exec_event(struct st_relay_log_info* rli)
3279
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3280 3281
  thd->rand.seed1= (ulong) seed1;
  thd->rand.seed2= (ulong) seed2;
3282
  rli->inc_event_relay_log_pos();
3283 3284
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3285
#endif /* !MYSQL_CLIENT */
3286

3287

3288 3289 3290 3291 3292 3293 3294
/**************************************************************************
  Xid_log_event methods
**************************************************************************/

#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
void Xid_log_event::pack_info(Protocol *protocol)
{
3295 3296
  char buf[128], *pos;
  pos= strmov(buf, "COMMIT /* xid=");
3297
  pos= longlong10_to_str(xid, pos, 10);
3298
  pos= strmov(pos, " */");
3299 3300 3301 3302
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
}
#endif

3303 3304 3305 3306 3307 3308 3309 3310
/*
  NOTE it's ok not to use int8store here,
  as long as xid_t::set(ulonglong) and
  xid_t::get_my_xid doesn't do it either

  we don't care about actual values of xids as long as
  identical numbers compare identically
*/
3311 3312 3313 3314

Xid_log_event::
Xid_log_event(const char* buf,
              const Format_description_log_event *description_event)
3315 3316 3317
  :Log_event(buf, description_event)
{
  buf+= description_event->common_header_len;
3318
  memcpy((char*) &xid, buf, sizeof(xid));
3319 3320 3321
}


3322
#ifndef MYSQL_CLIENT
3323 3324 3325 3326 3327
bool Xid_log_event::write(IO_CACHE* file)
{
  return write_header(file, sizeof(xid)) ||
         my_b_safe_write(file, (byte*) &xid, sizeof(xid));
}
3328
#endif
3329 3330 3331 3332 3333 3334 3335


#ifdef MYSQL_CLIENT
void Xid_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
{
  if (!short_form)
  {
3336 3337 3338
    char buf[64];
    longlong10_to_str(xid, buf, 10);

3339
    print_header(file);
3340 3341
    fprintf(file, "\tXid = %s\n", buf);
    fflush(file);
3342
  }
3343
  fprintf(file, "COMMIT;\n");
3344 3345 3346 3347 3348 3349 3350
}
#endif /* MYSQL_CLIENT */


#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
int Xid_log_event::exec_event(struct st_relay_log_info* rli)
{
3351
  /* For a slave Xid_log_event is COMMIT */
3352
  mysql_log.write(thd,COM_QUERY,"COMMIT /* implicit, from Xid_log_event */");
3353
  return end_trans(thd, COMMIT) || Log_event::exec_event(rli);
3354 3355 3356 3357
}
#endif /* !MYSQL_CLIENT */


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3358
/**************************************************************************
3359
  User_var_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3360
**************************************************************************/
3361

3362
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3363 3364 3365
void User_var_log_event::pack_info(Protocol* protocol)
{
  char *buf= 0;
3366
  uint val_offset= 4 + name_len;
3367 3368 3369 3370 3371 3372 3373 3374 3375 3376 3377 3378 3379 3380 3381
  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));
3382 3383
      event_len+= my_sprintf(buf + val_offset,
			     (buf + val_offset, "%.14g", real_val));
3384 3385 3386 3387 3388
      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;
3389 3390 3391 3392 3393 3394 3395 3396 3397 3398
    case DECIMAL_RESULT:
    {
      buf= my_malloc(val_offset + DECIMAL_MAX_STR_LENGTH, MYF(MY_WME));
      String str(buf+val_offset, DECIMAL_MAX_STR_LENGTH, &my_charset_bin);
      my_decimal dec;
      binary2my_decimal(E_DEC_FATAL_ERROR, val+2, &dec, val[0], val[1]);
      my_decimal2string(E_DEC_FATAL_ERROR, &dec, 0, 0, 0, &str);
      event_len= str.length() + val_offset;
      break;
    } 
3399
    case STRING_RESULT:
3400 3401 3402 3403 3404 3405 3406 3407 3408 3409
      /* 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
      {
3410 3411 3412
        char *p= strxmov(buf + val_offset, "_", cs->csname, " ", NullS);
        p= str_to_hex(p, val, val_len);
        p= strxmov(p, " COLLATE ", cs->name, NullS);
3413 3414
        event_len= p-buf;
      }
3415
      break;
3416
    case ROW_RESULT:
3417
    default:
3418 3419 3420 3421 3422
      DBUG_ASSERT(1);
      return;
    }
  }
  buf[0]= '@';
3423 3424 3425 3426
  buf[1]= '`';
  buf[2+name_len]= '`';
  buf[3+name_len]= '=';
  memcpy(buf+2, name, name_len);
3427
  protocol->store(buf, event_len, &my_charset_bin);
3428 3429
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3430
#endif /* !MYSQL_CLIENT */
3431 3432


3433 3434 3435 3436
User_var_log_event::
User_var_log_event(const char* buf,
                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3437
{
3438
  buf+= description_event->common_header_len;
3439 3440
  name_len= uint4korr(buf);
  name= (char *) buf + UV_NAME_LEN_SIZE;
3441 3442
  buf+= UV_NAME_LEN_SIZE + name_len;
  is_null= (bool) *buf;
3443 3444 3445
  if (is_null)
  {
    type= STRING_RESULT;
3446
    charset_number= my_charset_bin.number;
3447 3448 3449 3450 3451
    val_len= 0;
    val= 0;  
  }
  else
  {
3452 3453 3454
    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 + 
3455
		       UV_CHARSET_NUMBER_SIZE);
3456 3457
    val= (char *) (buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE +
		   UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE);
3458 3459 3460 3461
  }
}


3462
#ifndef MYSQL_CLIENT
3463
bool User_var_log_event::write(IO_CACHE* file)
3464 3465 3466 3467
{
  char buf[UV_NAME_LEN_SIZE];
  char buf1[UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE + 
	    UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE];
3468
  char buf2[max(8, DECIMAL_MAX_FIELD_SIZE + 2)], *pos= buf2;
3469
  uint buf1_length;
3470
  ulong event_length;
3471

3472
  int4store(buf, name_len);
3473 3474 3475 3476 3477 3478 3479
  
  if ((buf1[0]= is_null))
  {
    buf1_length= 1;
    val_len= 0;
  }    
  else
3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490
  {
    buf1[1]= type;
    int4store(buf1 + 2, charset_number);

    switch (type) {
    case REAL_RESULT:
      float8store(buf2, *(double*) val);
      break;
    case INT_RESULT:
      int8store(buf2, *(longlong*) val);
      break;
3491 3492 3493 3494 3495 3496
    case DECIMAL_RESULT:
    {
      my_decimal *dec= (my_decimal *)val;
      dec->fix_buffer_pointer();
      buf2[0]= (char)(dec->intg + dec->frac);
      buf2[1]= (char)dec->frac;
3497
      decimal2bin((decimal_t*)val, buf2+2, buf2[0], buf2[1]);
3498 3499 3500
      val_len= decimal_bin_size(buf2[0], buf2[1]) + 2;
      break;
    }
3501 3502 3503
    case STRING_RESULT:
      pos= val;
      break;
3504
    case ROW_RESULT:
3505
    default:
3506 3507 3508
      DBUG_ASSERT(1);
      return 0;
    }
3509 3510
    int4store(buf1 + 2 + UV_CHARSET_NUMBER_SIZE, val_len);
    buf1_length= 10;
3511
  }
3512 3513 3514 3515 3516 3517

  /* 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))   ||
3518 3519 3520
	  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));
3521
}
3522
#endif
3523

3524

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3525
/*
3526
  User_var_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3527
*/
3528 3529

#ifdef MYSQL_CLIENT
3530
void User_var_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3531 3532 3533 3534 3535 3536 3537
{
  if (!short_form)
  {
    print_header(file);
    fprintf(file, "\tUser_var\n");
  }

3538
  fprintf(file, "SET @`");
3539
  my_fwrite(file, (byte*) name, (uint) (name_len), MYF(MY_NABP | MY_WME));
3540
  fprintf(file, "`");
3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558

  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;
3559 3560 3561 3562 3563 3564
    case DECIMAL_RESULT:
    {
      char str_buf[200];
      int str_len= sizeof(str_buf) - 1;
      int precision= (int)val[0];
      int scale= (int)val[1];
3565 3566
      decimal_digit_t dec_buf[10];
      decimal_t dec;
3567 3568 3569 3570 3571 3572
      dec.len= 10;
      dec.buf= dec_buf;

      bin2decimal(val+2, &dec, precision, scale);
      decimal2string(&dec, str_buf, &str_len, 0, 0, 0);
      str_buf[str_len]= 0;
3573
      fprintf(file, ":=%s;\n",str_buf);
3574 3575
      break;
    }
3576
    case STRING_RESULT:
3577
    {
3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591
      /*
        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.
      */
3592 3593 3594 3595
      char *hex_str;
      CHARSET_INFO *cs;

      if (!(hex_str= (char *)my_alloca(2*val_len+1+2))) // 2 hex digits / byte
3596
        break; // no error, as we are 'void'
3597
      str_to_hex(hex_str, val, val_len);
3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610
      /*
        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
3611
        fprintf(file, ":=_%s %s COLLATE `%s`;\n", cs->csname, hex_str, cs->name);
3612
      my_afree(hex_str);
3613
    }
3614
      break;
3615
    case ROW_RESULT:
3616
    default:
3617
      DBUG_ASSERT(1);
3618 3619 3620 3621 3622
      return;
    }
  }
  fflush(file);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3623
#endif
3624

3625

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3626
/*
3627
  User_var_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3628
*/
3629

3630
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3631 3632 3633
int User_var_log_event::exec_event(struct st_relay_log_info* rli)
{
  Item *it= 0;
3634 3635 3636
  CHARSET_INFO *charset;
  if (!(charset= get_charset(charset_number, MYF(MY_WME))))
    return 1;
3637 3638 3639
  LEX_STRING user_var_name;
  user_var_name.str= name;
  user_var_name.length= name_len;
3640 3641
  double real_val;
  longlong int_val;
3642 3643 3644 3645 3646 3647 3648 3649 3650 3651

  if (is_null)
  {
    it= new Item_null();
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      float8get(real_val, val);
3652
      it= new Item_float(real_val);
3653
      val= (char*) &real_val;		// Pointer to value in native format
3654
      val_len= 8;
3655 3656
      break;
    case INT_RESULT:
3657 3658 3659
      int_val= (longlong) uint8korr(val);
      it= new Item_int(int_val);
      val= (char*) &int_val;		// Pointer to value in native format
3660
      val_len= 8;
3661
      break;
3662 3663 3664 3665 3666 3667 3668 3669
    case DECIMAL_RESULT:
    {
      Item_decimal *dec= new Item_decimal(val+2, val[0], val[1]);
      it= dec;
      val= (char *)dec->val_decimal(NULL);
      val_len= sizeof(my_decimal);
      break;
    }
3670 3671 3672
    case STRING_RESULT:
      it= new Item_string(val, val_len, charset);
      break;
3673
    case ROW_RESULT:
3674
    default:
3675 3676 3677 3678 3679
      DBUG_ASSERT(1);
      return 0;
    }
  }
  Item_func_set_user_var e(user_var_name, it);
3680 3681 3682 3683
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
3684
  e.fix_fields(thd, 0);
3685 3686 3687 3688 3689
  /*
    A variable can just be considered as a table with
    a single record and with a single column. Thus, like
    a column value, it could always have IMPLICIT derivation.
   */
3690
  e.update_hash(val, val_len, type, charset, DERIVATION_IMPLICIT);
3691
  free_root(thd->mem_root,0);
3692

3693
  rli->inc_event_relay_log_pos();
3694 3695
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3696
#endif /* !MYSQL_CLIENT */
3697 3698


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3699
/**************************************************************************
3700
  Slave_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3701
**************************************************************************/
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3702

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3703
#ifdef HAVE_REPLICATION
3704
#ifdef MYSQL_CLIENT
3705
void Unknown_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3706 3707 3708 3709 3710 3711 3712 3713
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
  fprintf(file, "# %s", "Unknown event\n");
}
#endif  
3714

3715
#ifndef MYSQL_CLIENT
3716
void Slave_log_event::pack_info(Protocol *protocol)
3717
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3718
  char buf[256+HOSTNAME_LENGTH], *pos;
3719 3720 3721 3722 3723 3724 3725
  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=");
3726
  pos= longlong10_to_str(master_pos, pos, 10);
3727
  protocol->store(buf, pos-buf, &my_charset_bin);
3728
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3729
#endif /* !MYSQL_CLIENT */
3730 3731 3732 3733


#ifndef MYSQL_CLIENT
Slave_log_event::Slave_log_event(THD* thd_arg,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3734
				 struct st_relay_log_info* rli)
3735
  :Log_event(thd_arg, 0, 0) , mem_pool(0), master_host(0)
3736 3737 3738 3739
{
  DBUG_ENTER("Slave_log_event");
  if (!rli->inited)				// QQ When can this happen ?
    DBUG_VOID_RETURN;
3740

3741 3742 3743 3744 3745
  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);
3746
  master_log_len = strlen(rli->group_master_log_name);
3747 3748 3749
  // 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))))
3750
  {
3751 3752 3753
    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;
3754
    memcpy(master_log, rli->group_master_log_name, master_log_len + 1);
3755
    master_port = mi->port;
3756
    master_pos = rli->group_master_log_pos;
3757 3758
    DBUG_PRINT("info", ("master_log: %s  pos: %d", master_log,
			(ulong) master_pos));
3759
  }
3760 3761 3762 3763 3764 3765
  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
3766
#endif /* !MYSQL_CLIENT */
3767 3768 3769 3770 3771 3772 3773 3774 3775


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


#ifdef MYSQL_CLIENT
3776
void Slave_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3777 3778 3779 3780 3781 3782
{
  char llbuff[22];
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3783 3784
  fprintf(file, "\
Slave: master_host: '%s'  master_port: %d  master_log: '%s'  master_pos: %s\n",
3785 3786
	  master_host, master_port, master_log, llstr(master_pos, llbuff));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3787
#endif /* MYSQL_CLIENT */
3788 3789 3790 3791 3792 3793 3794 3795


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


3796
#ifndef MYSQL_CLIENT
3797
bool Slave_log_event::write(IO_CACHE* file)
3798
{
3799
  ulong event_length= get_data_size();
3800 3801 3802
  int8store(mem_pool + SL_MASTER_POS_OFFSET, master_pos);
  int2store(mem_pool + SL_MASTER_PORT_OFFSET, master_port);
  // log and host are already there
3803 3804 3805

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) mem_pool, event_length));
3806
}
3807
#endif
3808 3809 3810 3811 3812 3813 3814 3815 3816 3817 3818


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)
3819
  {
3820 3821
    master_host = 0;
    return;
3822
  }
3823 3824
  master_log_len = strlen(master_log);
}
3825

3826

3827 3828 3829
/* 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)
3830
{
3831
  if (event_len < LOG_EVENT_HEADER_LEN)
3832
    return;
3833
  event_len -= LOG_EVENT_HEADER_LEN;
3834 3835 3836 3837 3838
  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);
3839 3840
}

3841

3842 3843 3844 3845 3846 3847 3848
#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
3849
#endif /* !MYSQL_CLIENT */
3850 3851


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3852
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3853
	Stop_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3854
**************************************************************************/
3855

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3856
/*
3857
  Stop_log_event::print()
3858
*/
3859 3860

#ifdef MYSQL_CLIENT
3861
void Stop_log_event::print(FILE* file, bool short_form, LAST_EVENT_INFO* last_event_info)
3862 3863 3864 3865 3866 3867 3868
{
  if (short_form)
    return;

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

3872

3873
/*
3874
  Stop_log_event::exec_event()
3875

3876
  The master stopped.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3877
  We used to clean up all temporary tables but this is useless as, as the
3878 3879
  master has shut down properly, it has written all DROP TEMPORARY TABLE
  (prepared statements' deletion is TODO only when we binlog prep stmts).
3880 3881 3882
  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.
3883
  The place were we must do this cleaning is in Start_log_event_v3::exec_event(),
3884
  not here. Because if we come here, the master was sane.
3885 3886
*/

3887
#ifndef MYSQL_CLIENT
3888
int Stop_log_event::exec_event(struct st_relay_log_info* rli)
3889
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3890 3891
  /*
    We do not want to update master_log pos because we get a rotate event
3892
    before stop, so by now group_master_log_name is set to the next log.
3893
    If we updated it, we will have incorrect master coordinates and this
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3894
    could give false triggers in MASTER_POS_WAIT() that we have reached
3895
    the target position when in fact we have not.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3896
  */
3897 3898 3899 3900 3901 3902 3903
  if (thd->options & OPTION_BEGIN)
    rli->inc_event_relay_log_pos();
  else
  {
    rli->inc_group_relay_log_pos(0);
    flush_relay_log_info(rli);
  }
3904 3905
  return 0;
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3906
#endif /* !MYSQL_CLIENT */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3907
#endif /* HAVE_REPLICATION */
3908

3909

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3910
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3911
	Create_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3912
**************************************************************************/
3913 3914

/*
3915
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3916
*/
3917 3918

#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3919 3920 3921 3922
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,
3923
                      bool ignore,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3924
		      char* block_arg, uint block_len_arg, bool using_trans)
3925
  :Load_log_event(thd_arg,ex,db_arg,table_name_arg,fields_arg,handle_dup, ignore,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3926
		  using_trans),
3927
   fake_base(0), block(block_arg), event_buf(0), block_len(block_len_arg),
3928
   file_id(thd_arg->file_id = mysql_bin_log.next_file_id())
3929
{
monty@mysql.com's avatar
monty@mysql.com committed
3930
  DBUG_ENTER("Create_file_log_event");
3931
  sql_ex.force_new_format();
monty@mysql.com's avatar
monty@mysql.com committed
3932
  DBUG_VOID_RETURN;
3933
}
3934

3935

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3936
/*
3937
  Create_file_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3938
*/
3939

3940
bool Create_file_log_event::write_data_body(IO_CACHE* file)
3941
{
3942 3943
  bool res;
  if ((res= Load_log_event::write_data_body(file)) || fake_base)
3944 3945
    return res;
  return (my_b_safe_write(file, (byte*) "", 1) ||
3946
          my_b_safe_write(file, (byte*) block, block_len));
3947 3948
}

3949

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3950
/*
3951
  Create_file_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3952
*/
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3953

3954
bool Create_file_log_event::write_data_header(IO_CACHE* file)
3955
{
3956
  bool res;
3957
  byte buf[CREATE_FILE_HEADER_LEN];
3958 3959
  if ((res= Load_log_event::write_data_header(file)) || fake_base)
    return res;
3960
  int4store(buf + CF_FILE_ID_OFFSET, file_id);
3961
  return my_b_safe_write(file, buf, CREATE_FILE_HEADER_LEN) != 0;
3962 3963 3964
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3965
/*
3966
  Create_file_log_event::write_base()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3967
*/
3968

3969
bool Create_file_log_event::write_base(IO_CACHE* file)
3970
{
3971 3972 3973 3974
  bool res;
  fake_base= 1;                                 // pretend we are Load event
  res= write(file);
  fake_base= 0;
3975 3976 3977
  return res;
}

3978
#endif /* !MYSQL_CLIENT */
3979

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3980
/*
3981
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3982
*/
3983

3984 3985 3986
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)
3987
{
3988 3989 3990 3991 3992
  DBUG_ENTER("Create_file_log_event::Create_file_log_event(char*,...)");
  uint block_offset;
  uint header_len= description_event->common_header_len;
  uint8 load_header_len= description_event->post_header_len[LOAD_EVENT-1];
  uint8 create_file_header_len= description_event->post_header_len[CREATE_FILE_EVENT-1];
monty@mysql.com's avatar
monty@mysql.com committed
3993
  if (!(event_buf= my_memdup((byte*) buf, len, MYF(MY_WME))) ||
3994 3995 3996 3997 3998 3999 4000
      copy_log_event(event_buf,len,
                     ((buf[EVENT_TYPE_OFFSET] == LOAD_EVENT) ?
                      load_header_len + header_len :
                      (fake_base ? (header_len+load_header_len) :
                       (header_len+load_header_len) +
                       create_file_header_len)),
                     description_event))
monty@mysql.com's avatar
monty@mysql.com committed
4001
    DBUG_VOID_RETURN;
4002
  if (description_event->binlog_version!=1)
4003
  {
4004 4005 4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019 4020
    file_id= uint4korr(buf + 
                       header_len +
		       load_header_len + CF_FILE_ID_OFFSET);
    /*
      Note that it's ok to use get_data_size() below, because it is computed
      with values we have already read from this event (because we called
      copy_log_event()); we are not using slave's format info to decode
      master's format, we are really using master's format info.
      Anyway, both formats should be identical (except the common_header_len)
      as these Load events are not changed between 4.0 and 5.0 (as logging of
      LOAD DATA INFILE does not use Load_log_event in 5.0).

      The + 1 is for \0 terminating fname  
    */
    block_offset= (description_event->common_header_len +
                   Load_log_event::get_data_size() +
                   create_file_header_len + 1);
4021 4022 4023 4024 4025 4026 4027 4028 4029
    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;
4030
  }
monty@mysql.com's avatar
monty@mysql.com committed
4031
  DBUG_VOID_RETURN;
4032 4033
}

4034

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4035
/*
4036
  Create_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4037
*/
4038 4039

#ifdef MYSQL_CLIENT
4040
void Create_file_log_event::print(FILE* file, bool short_form, 
4041
				  LAST_EVENT_INFO* last_event_info, bool enable_local)
nick@mysql.com's avatar
nick@mysql.com committed
4042
{
4043
  if (short_form)
4044 4045
  {
    if (enable_local && check_fname_outside_temp_buf())
4046
      Load_log_event::print(file, 1, last_event_info);
4047
    return;
4048 4049 4050 4051
  }

  if (enable_local)
  {
serg@serg.mylan's avatar
serg@serg.mylan committed
4052
    Load_log_event::print(file, short_form, last_event_info, !check_fname_outside_temp_buf());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4053 4054 4055 4056 4057
    /* 
       That one is for "file_id: etc" below: in mysqlbinlog we want the #, in
       SHOW BINLOG EVENTS we don't.
    */
    fprintf(file, "#"); 
4058 4059
  }

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

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

4064
void Create_file_log_event::print(FILE* file, bool short_form,
4065
				  LAST_EVENT_INFO* last_event_info)
4066
{
4067
  print(file,short_form,last_event_info,0);
4068
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4069
#endif /* MYSQL_CLIENT */
nick@mysql.com's avatar
nick@mysql.com committed
4070

4071

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4072
/*
4073
  Create_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4074
*/
4075

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4076
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4077
void Create_file_log_event::pack_info(Protocol *protocol)
4078
{
4079 4080 4081
  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
4082
  pos= strmov(pos + db_len, ";table=");
4083
  memcpy(pos, table_name, table_name_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4084
  pos= strmov(pos + table_name_len, ";file_id=");
4085 4086 4087
  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
4088
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
4089
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4090
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4091 4092


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4093
/*
4094
  Create_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4095
*/
4096

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4097
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4098
int Create_file_log_event::exec_event(struct st_relay_log_info* rli)
4099
{
4100
  char proc_info[17+FN_REFLEN+10], *fname_buf= proc_info+17;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4101
  char *p;
4102 4103 4104
  int fd = -1;
  IO_CACHE file;
  int error = 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4105

4106
  bzero((char*)&file, sizeof(file));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4107 4108
  p = slave_load_file_stem(fname_buf, file_id, server_id);
  strmov(p, ".info");			// strmov takes less code than memcpy
4109 4110
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
4111 4112 4113 4114
  my_delete(fname_buf, MYF(0)); // old copy may exist already
  if ((fd= my_create(fname_buf, CREATE_MODE,
		     O_WRONLY | O_BINARY | O_EXCL | O_NOFOLLOW,
		     MYF(MY_WME))) < 0 ||
4115 4116 4117
      init_io_cache(&file, fd, IO_SIZE, WRITE_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
4118
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
4119 4120 4121 4122
    goto err;
  }
  
  // a trick to avoid allocating another buffer
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4123
  strmov(p, ".data");
4124 4125 4126 4127
  fname = fname_buf;
  fname_len = (uint)(p-fname) + 5;
  if (write_base(&file))
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4128
    strmov(p, ".info"); // to have it right in the error message
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4129 4130 4131
    slave_print_error(rli,my_errno,
		      "Error in Create_file event: could not write to file '%s'",
		      fname_buf);
4132 4133 4134 4135 4136 4137
    goto err;
  }
  end_io_cache(&file);
  my_close(fd, MYF(0));
  
  // fname_buf now already has .data, not .info, because we did our trick
4138 4139 4140 4141
  my_delete(fname_buf, MYF(0)); // old copy may exist already
  if ((fd= my_create(fname_buf, CREATE_MODE,
		     O_WRONLY | O_BINARY | O_EXCL | O_NOFOLLOW,
		     MYF(MY_WME))) < 0)
4142
  {
4143
    slave_print_error(rli,my_errno, "Error in Create_file event: could not open file '%s'", fname_buf);
4144 4145
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4146
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
4147
  {
4148
    slave_print_error(rli,my_errno, "Error in Create_file event: write to '%s' failed", fname_buf);
4149 4150
    goto err;
  }
4151 4152
  error=0;					// Everything is ok

4153 4154 4155 4156 4157
err:
  if (error)
    end_io_cache(&file);
  if (fd >= 0)
    my_close(fd, MYF(0));
4158
  thd->proc_info= 0;
4159
  return error ? 1 : Log_event::exec_event(rli);
4160
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4161
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4162

4163

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4164
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4165
	Append_block_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4166
**************************************************************************/
4167

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4168
/*
4169
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4170
*/
4171 4172

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4173 4174
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
4175 4176 4177
					       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
4178
   block_len(block_len_arg), file_id(thd_arg->file_id), db(db_arg)
4179 4180
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4181
#endif
4182 4183


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4184
/*
4185
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4186
*/
4187

4188 4189 4190
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)
4191
{
4192 4193 4194 4195 4196 4197
  DBUG_ENTER("Append_block_log_event::Append_block_log_event(char*,...)");
  uint8 common_header_len= description_event->common_header_len; 
  uint8 append_block_header_len=
    description_event->post_header_len[APPEND_BLOCK_EVENT-1];
  uint total_header_len= common_header_len+append_block_header_len;
  if (len < total_header_len)
monty@mysql.com's avatar
monty@mysql.com committed
4198
    DBUG_VOID_RETURN;
4199 4200 4201
  file_id= uint4korr(buf + common_header_len + AB_FILE_ID_OFFSET);
  block= (char*)buf + total_header_len;
  block_len= len - total_header_len;
monty@mysql.com's avatar
monty@mysql.com committed
4202
  DBUG_VOID_RETURN;
4203 4204 4205
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4206
/*
4207
  Append_block_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4208
*/
4209

4210
#ifndef MYSQL_CLIENT
4211
bool Append_block_log_event::write(IO_CACHE* file)
4212 4213 4214
{
  byte buf[APPEND_BLOCK_HEADER_LEN];
  int4store(buf + AB_FILE_ID_OFFSET, file_id);
4215 4216
  return (write_header(file, APPEND_BLOCK_HEADER_LEN + block_len) ||
          my_b_safe_write(file, buf, APPEND_BLOCK_HEADER_LEN) ||
4217 4218
	  my_b_safe_write(file, (byte*) block, block_len));
}
4219
#endif
4220 4221


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4222
/*
4223
  Append_block_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4224
*/
4225 4226 4227

#ifdef MYSQL_CLIENT  
void Append_block_log_event::print(FILE* file, bool short_form,
4228
				   LAST_EVENT_INFO* last_event_info)
4229 4230 4231 4232 4233
{
  if (short_form)
    return;
  print_header(file);
  fputc('\n', file);
4234 4235
  fprintf(file, "#%s: file_id: %d  block_len: %d\n",
	  get_type_str(), file_id, block_len);
4236
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4237
#endif /* MYSQL_CLIENT */
4238 4239


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4240
/*
4241
  Append_block_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4242
*/
4243

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4244
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4245
void Append_block_log_event::pack_info(Protocol *protocol)
4246 4247 4248 4249 4250 4251
{
  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
4252
  protocol->store(buf, length, &my_charset_bin);
4253 4254 4255
}


4256
/*
4257
  Append_block_log_event::get_create_or_append()
4258 4259
*/

4260
int Append_block_log_event::get_create_or_append() const
4261
{
4262
  return 0; /* append to the file, fail if not exists */
4263 4264
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4265
/*
4266
  Append_block_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4267
*/
4268

4269
int Append_block_log_event::exec_event(struct st_relay_log_info* rli)
4270
{
4271
  char proc_info[17+FN_REFLEN+10], *fname= proc_info+17;
4272 4273
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
4274
  int error = 1;
monty@mysql.com's avatar
monty@mysql.com committed
4275
  DBUG_ENTER("Append_block_log_event::exec_event");
4276

4277
  memcpy(p, ".data", 6);
4278 4279
  strnmov(proc_info, "Making temp file ", 17); // no end 0
  thd->proc_info= proc_info;
4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290 4291 4292
  if (get_create_or_append())
  {
    my_delete(fname, MYF(0)); // old copy may exist already
    if ((fd= my_create(fname, CREATE_MODE,
		       O_WRONLY | O_BINARY | O_EXCL | O_NOFOLLOW,
		       MYF(MY_WME))) < 0)
    {
      slave_print_error(rli, my_errno,
			"Error in %s event: could not create file '%s'",
			get_type_str(), fname);
      goto err;
    }
  }
4293 4294
  else if ((fd = my_open(fname, O_WRONLY | O_APPEND | O_BINARY | O_NOFOLLOW,
                         MYF(MY_WME))) < 0)
4295
  {
4296 4297 4298
    slave_print_error(rli, my_errno,
                      "Error in %s event: could not open file '%s'",
                      get_type_str(), fname);
4299 4300
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4301
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
4302
  {
4303 4304 4305
    slave_print_error(rli, my_errno,
                      "Error in %s event: write to '%s' failed",
                      get_type_str(), fname);
4306 4307 4308
    goto err;
  }
  error=0;
4309

4310 4311 4312
err:
  if (fd >= 0)
    my_close(fd, MYF(0));
4313
  thd->proc_info= 0;
monty@mysql.com's avatar
monty@mysql.com committed
4314
  DBUG_RETURN(error ? error : Log_event::exec_event(rli));
4315
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4316
#endif
4317 4318


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4319
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4320
	Delete_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4321
**************************************************************************/
4322

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4323
/*
4324
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4325
*/
4326 4327

#ifndef MYSQL_CLIENT
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4328 4329 4330
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)
4331 4332
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4333
#endif
4334

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4335
/*
4336
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4337
*/
4338

4339 4340 4341
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)
4342
{
4343 4344 4345
  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))
4346
    return;
4347
  file_id= uint4korr(buf + common_header_len + DF_FILE_ID_OFFSET);
4348 4349 4350
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4351
/*
4352
  Delete_file_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4353
*/
4354

4355
#ifndef MYSQL_CLIENT
4356
bool Delete_file_log_event::write(IO_CACHE* file)
4357 4358 4359
{
 byte buf[DELETE_FILE_HEADER_LEN];
 int4store(buf + DF_FILE_ID_OFFSET, file_id);
4360 4361
 return (write_header(file, sizeof(buf)) ||
         my_b_safe_write(file, buf, sizeof(buf)));
4362
}
4363
#endif
4364 4365


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4366
/*
4367
  Delete_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4368
*/
4369 4370 4371

#ifdef MYSQL_CLIENT  
void Delete_file_log_event::print(FILE* file, bool short_form,
4372
				  LAST_EVENT_INFO* last_event_info)
4373 4374 4375 4376 4377 4378 4379
{
  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
4380
#endif /* MYSQL_CLIENT */
4381

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4382
/*
4383
  Delete_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4384
*/
4385

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4386
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4387
void Delete_file_log_event::pack_info(Protocol *protocol)
4388 4389 4390 4391
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
4392
  protocol->store(buf, (int32) length, &my_charset_bin);
4393
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4394
#endif
4395

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4396
/*
4397
  Delete_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4398
*/
4399

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4400
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4401 4402 4403 4404 4405 4406 4407 4408 4409 4410
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
4411
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4412 4413


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4414
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4415
	Execute_load_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4416
**************************************************************************/
4417

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4418
/*
4419
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4420
*/
4421 4422

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4423 4424 4425
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)
4426 4427
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4428
#endif
4429 4430
  

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4431
/*
4432
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4433
*/
4434

4435 4436 4437
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)
4438
{
4439 4440 4441
  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))
4442
    return;
4443
  file_id= uint4korr(buf + common_header_len + EL_FILE_ID_OFFSET);
4444 4445 4446
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4447
/*
4448
  Execute_load_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4449
*/
4450

4451
#ifndef MYSQL_CLIENT
4452
bool Execute_load_log_event::write(IO_CACHE* file)
4453 4454 4455
{
  byte buf[EXEC_LOAD_HEADER_LEN];
  int4store(buf + EL_FILE_ID_OFFSET, file_id);
4456 4457
  return (write_header(file, sizeof(buf)) || 
          my_b_safe_write(file, buf, sizeof(buf)));
4458
}
4459
#endif
4460 4461


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4462
/*
4463
  Execute_load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4464
*/
4465 4466 4467

#ifdef MYSQL_CLIENT  
void Execute_load_log_event::print(FILE* file, bool short_form,
4468
				   LAST_EVENT_INFO* last_event_info)
4469 4470 4471 4472 4473 4474 4475 4476
{
  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
4477
#endif
4478

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4479
/*
4480
  Execute_load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4481
*/
4482

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4483
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4484
void Execute_load_log_event::pack_info(Protocol *protocol)
4485 4486 4487 4488
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
4489
  protocol->store(buf, (int32) length, &my_charset_bin);
4490 4491 4492
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4493
/*
4494
  Execute_load_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4495
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4496

4497
int Execute_load_log_event::exec_event(struct st_relay_log_info* rli)
4498 4499
{
  char fname[FN_REFLEN+10];
4500 4501
  char *p= slave_load_file_stem(fname, file_id, server_id);
  int fd;
4502 4503 4504
  int error = 1;
  IO_CACHE file;
  Load_log_event* lev = 0;
4505

4506
  memcpy(p, ".info", 6);
4507 4508
  if ((fd = my_open(fname, O_RDONLY | O_BINARY | O_NOFOLLOW,
                    MYF(MY_WME))) < 0 ||
4509 4510 4511
      init_io_cache(&file, fd, IO_SIZE, READ_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
4512
    slave_print_error(rli,my_errno, "Error in Exec_load event: could not open file '%s'", fname);
4513 4514
    goto err;
  }
4515
  if (!(lev = (Load_log_event*)Log_event::read_log_event(&file,
4516 4517
                                                         (pthread_mutex_t*)0,
                                                         rli->relay_log.description_event_for_exec)) ||
4518
      lev->get_type_code() != NEW_LOAD_EVENT)
4519
  {
4520
    slave_print_error(rli,0, "Error in Exec_load event: file '%s' appears corrupted", fname);
4521 4522
    goto err;
  }
4523

4524
  lev->thd = thd;
4525 4526
  /*
    lev->exec_event should use rli only for errors
4527 4528 4529
    i.e. should not advance rli's position.
    lev->exec_event is the place where the table is loaded (it calls
    mysql_load()).
4530
  */
guilhem@mysql.com's avatar
guilhem@mysql.com committed
4531

4532
  rli->future_group_master_log_pos= log_pos;
4533
  if (lev->exec_event(0,rli,1)) 
4534
  {
4535 4536 4537 4538 4539 4540 4541 4542 4543
    /*
      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));
4544 4545 4546 4547 4548 4549 4550 4551
    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));
    }
4552 4553
    goto err;
  }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
4554 4555 4556 4557 4558 4559 4560 4561 4562 4563
  /*
    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;
  }
4564
  (void) my_delete(fname, MYF(MY_WME));
4565
  memcpy(p, ".data", 6);
4566
  (void) my_delete(fname, MYF(MY_WME));
4567
  error = 0;
4568

4569 4570 4571
err:
  delete lev;
  if (fd >= 0)
4572
  {
4573
    my_close(fd, MYF(0));
4574 4575
    end_io_cache(&file);
  }
4576
  return error ? error : Log_event::exec_event(rli);
4577
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4578

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4579
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4580 4581


4582 4583 4584 4585 4586 4587 4588 4589 4590 4591 4592 4593 4594 4595 4596 4597 4598 4599 4600 4601 4602 4603 4604 4605 4606
/**************************************************************************
	Begin_load_query_log_event methods
**************************************************************************/

#ifndef MYSQL_CLIENT
Begin_load_query_log_event::
Begin_load_query_log_event(THD* thd_arg, const char* db_arg, char* block_arg,
                           uint block_len_arg, bool using_trans)
  :Append_block_log_event(thd_arg, db_arg, block_arg, block_len_arg,
                          using_trans)
{
   file_id= thd_arg->file_id= mysql_bin_log.next_file_id();
}
#endif


Begin_load_query_log_event::
Begin_load_query_log_event(const char* buf, uint len,
                           const Format_description_log_event* desc_event)
  :Append_block_log_event(buf, len, desc_event)
{
}


#if defined( HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4607
int Begin_load_query_log_event::get_create_or_append() const
4608
{
4609
  return 1; /* create the file */
4610 4611 4612 4613 4614 4615 4616 4617 4618 4619 4620 4621 4622 4623 4624 4625 4626 4627 4628 4629 4630 4631 4632 4633 4634 4635 4636 4637 4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652 4653 4654 4655 4656 4657 4658 4659 4660 4661 4662 4663
}
#endif /* defined( HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */


/**************************************************************************
	Execute_load_query_log_event methods
**************************************************************************/


#ifndef MYSQL_CLIENT
Execute_load_query_log_event::
Execute_load_query_log_event(THD* thd_arg, const char* query_arg,
                     ulong query_length_arg, uint fn_pos_start_arg,
                     uint fn_pos_end_arg,
                     enum_load_dup_handling dup_handling_arg,
                     bool using_trans, bool suppress_use):
  Query_log_event(thd_arg, query_arg, query_length_arg, using_trans,
                  suppress_use),
  file_id(thd_arg->file_id), fn_pos_start(fn_pos_start_arg),
  fn_pos_end(fn_pos_end_arg), dup_handling(dup_handling_arg)
{
}
#endif /* !MYSQL_CLIENT */


Execute_load_query_log_event::
Execute_load_query_log_event(const char* buf, uint event_len,
                             const Format_description_log_event* desc_event):
  Query_log_event(buf, event_len, desc_event, EXECUTE_LOAD_QUERY_EVENT),
  file_id(0), fn_pos_start(0), fn_pos_end(0)
{
  if (!Query_log_event::is_valid())
    return;

  buf+= desc_event->common_header_len;

  fn_pos_start= uint4korr(buf + ELQ_FN_POS_START_OFFSET);
  fn_pos_end= uint4korr(buf + ELQ_FN_POS_END_OFFSET);
  dup_handling= (enum_load_dup_handling)(*(buf + ELQ_DUP_HANDLING_OFFSET));

  if (fn_pos_start > q_len || fn_pos_end > q_len ||
      dup_handling > LOAD_DUP_REPLACE)
    return;

  file_id= uint4korr(buf + ELQ_FILE_ID_OFFSET);
}


ulong Execute_load_query_log_event::get_post_header_size_for_derived()
{
  return EXECUTE_LOAD_QUERY_EXTRA_HEADER_LEN;
}


4664
#ifndef MYSQL_CLIENT
4665 4666 4667 4668 4669 4670 4671 4672 4673 4674
bool
Execute_load_query_log_event::write_post_header_for_derived(IO_CACHE* file)
{
  char buf[EXECUTE_LOAD_QUERY_EXTRA_HEADER_LEN];
  int4store(buf, file_id);
  int4store(buf + 4, fn_pos_start);
  int4store(buf + 4 + 4, fn_pos_end);
  *(buf + 4 + 4 + 4)= (char)dup_handling;
  return my_b_safe_write(file, (byte*) buf, EXECUTE_LOAD_QUERY_EXTRA_HEADER_LEN);
}
4675
#endif
4676 4677 4678 4679 4680 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 4703 4704 4705 4706 4707 4708 4709 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 4738 4739 4740 4741 4742 4743 4744 4745 4746 4747 4748 4749 4750 4751 4752 4753 4754 4755 4756 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 4775 4776 4777 4778 4779 4780 4781 4782 4783 4784 4785


#ifdef MYSQL_CLIENT
void Execute_load_query_log_event::print(FILE* file, bool short_form,
                                         LAST_EVENT_INFO* last_event_info)
{
  print(file, short_form, last_event_info, 0);
}


void Execute_load_query_log_event::print(FILE* file, bool short_form,
                                         LAST_EVENT_INFO* last_event_info,
                                         const char *local_fname)
{
  print_query_header(file, short_form, last_event_info);

  if (local_fname)
  {
    my_fwrite(file, (byte*) query, fn_pos_start, MYF(MY_NABP | MY_WME));
    fprintf(file, " LOCAL INFILE \'");
    fprintf(file, local_fname);
    fprintf(file, "\'");
    if (dup_handling == LOAD_DUP_REPLACE)
      fprintf(file, " REPLACE");
    fprintf(file, " INTO");
    my_fwrite(file, (byte*) query + fn_pos_end, q_len-fn_pos_end,
        MYF(MY_NABP | MY_WME));
    fprintf(file, ";\n");
  }
  else
  {
    my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
    fprintf(file, ";\n");
  }

  if (!short_form)
    fprintf(file, "# file_id: %d \n", file_id);
}
#endif


#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
void Execute_load_query_log_event::pack_info(Protocol *protocol)
{
  char *buf, *pos;
  if (!(buf= my_malloc(9 + db_len + q_len + 10 + 21, MYF(MY_WME))))
    return;
  pos= buf;
  if (db && db_len)
  {
    pos= strmov(buf, "use `");
    memcpy(pos, db, db_len);
    pos= strmov(pos+db_len, "`; ");
  }
  if (query && q_len)
  {
    memcpy(pos, query, q_len);
    pos+= q_len;
  }
  pos= strmov(pos, " ;file_id=");
  pos= int10_to_str((long) file_id, pos, 10);
  protocol->store(buf, pos-buf, &my_charset_bin);
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
}


int
Execute_load_query_log_event::exec_event(struct st_relay_log_info* rli)
{
  char *p;
  char *buf;
  char *fname;
  char *fname_end;
  int error;

  /* Replace filename and LOCAL keyword in query before executing it */
  if (!(buf = my_malloc(q_len + 1 - (fn_pos_end - fn_pos_start) +
                        (FN_REFLEN + 10) + 10 + 8 + 5, MYF(MY_WME))))
  {
    slave_print_error(rli, my_errno, "Not enough memory");
    return 1;
  }

  p= buf;
  memcpy(p, query, fn_pos_start);
  p+= fn_pos_start;
  fname= (p= strmake(p, " INFILE \'", 9));
  p= slave_load_file_stem(p, file_id, server_id);
  fname_end= (p= strmake(p, ".data", 5));
  *(p++)='\'';
  switch (dup_handling)
  {
  case LOAD_DUP_IGNORE:
    p= strmake(p, " IGNORE", 7);
    break;
  case LOAD_DUP_REPLACE:
    p= strmake(p, " REPLACE", 8);
    break;
  default:
    /* Ordinary load data */
    break;
  }
  p= strmake(p, " INTO", 5);
  p= strmake(p, query+fn_pos_end, q_len-fn_pos_end);

  error= Query_log_event::exec_event(rli, buf, p-buf);

  /* Forging file name for deletion in same buffer */
  *fname_end= 0;

4786 4787 4788 4789 4790 4791
  /*
    If there was an error the slave is going to stop, leave the
    file so that we can re-execute this event at START SLAVE.
  */
  if (!error)
    (void) my_delete(fname, MYF(MY_WME));
4792 4793 4794 4795 4796 4797 4798

  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
  return error;
}
#endif


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4799
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4800
	sql_ex_info methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4801
**************************************************************************/
4802

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4803
/*
4804
  sql_ex_info::write_data()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4805
*/
4806

4807
bool sql_ex_info::write_data(IO_CACHE* file)
4808 4809 4810
{
  if (new_format())
  {
4811 4812 4813 4814 4815
    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) ||
4816 4817 4818 4819 4820 4821 4822 4823 4824 4825 4826 4827
	    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;
4828
    return my_b_safe_write(file, (byte*) &old_ex, sizeof(old_ex)) != 0;
4829 4830 4831 4832
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4833
/*
4834
  sql_ex_info::init()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4835
*/
4836 4837 4838 4839 4840 4841 4842 4843 4844 4845 4846 4847 4848 4849

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.
    */
4850 4851 4852 4853 4854
    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))
4855 4856 4857 4858 4859 4860 4861 4862 4863 4864 4865 4866 4867 4868 4869 4870 4871 4872 4873 4874 4875 4876 4877 4878 4879 4880
      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;
}