log_event.cc 165 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
   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
5
   the Free Software Foundation; version 2 of the License.
6

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

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

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

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

28
#define log_cs	&my_charset_latin1
29

30 31 32 33
#ifndef DBUG_OFF
uint debug_not_change_ts_if_art_event= 1; // bug#29309 simulation
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
34
/*
35
  pretty_print_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
36
*/
37

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

63

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

66 67 68 69 70 71 72 73
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
74

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
75
/*
monty@mysql.com's avatar
monty@mysql.com committed
76
  Ignore error code specified on command line
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
77
*/
78

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

86

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
87
/*
88
  pretty_print_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
89
*/
90

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

118

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
119
/*
120 121 122 123 124 125 126 127 128 129 130
  Creates a temporary name for load data infile:

  SYNOPSIS
    slave_load_file_stem()
    buf		      Store new filename here
    file_id	      File_id (part of file name)
    event_server_id   Event_id (part of file name)
    ext		      Extension for file name

  RETURN
    Pointer to start of extension
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
131
*/
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
132

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
133
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
134 135
static char *slave_load_file_stem(char *buf, uint file_id,
                                  int event_server_id, const char *ext)
136
{
137
  char *res;
138 139 140
  fn_format(buf,"SQL_LOAD-",slave_load_tmpdir, "", MY_UNPACK_FILENAME);
  to_unix_path(buf);

141 142 143 144 145
  buf = strend(buf);
  buf = int10_to_str(::server_id, buf, 10);
  *buf++ = '-';
  buf = int10_to_str(event_server_id, buf, 10);
  *buf++ = '-';
146 147 148
  res= int10_to_str(file_id, buf, 10);
  strmov(res, ext);                             // Add extension last
  return res;                                   // Pointer to extension
149
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
150
#endif
151

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
153
/*
154 155
  Delete all temporary files used for SQL_LOAD.

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
156 157
  SYNOPSIS
    cleanup_load_tmpdir()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
158
*/
159

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
160
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
161 162 163 164 165
static void cleanup_load_tmpdir()
{
  MY_DIR *dirp;
  FILEINFO *file;
  uint i;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
166
  char fname[FN_REFLEN], prefbuf[31], *p;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
167

168 169 170
  if (!(dirp=my_dir(slave_load_tmpdir,MYF(MY_WME))))
    return;

171 172 173 174 175 176 177 178
  /* 
     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.
  */
179
  p= strmake(prefbuf, STRING_WITH_LEN("SQL_LOAD-"));
180 181 182 183
  p= int10_to_str(::server_id, p, 10);
  *(p++)= '-';
  *p= 0;

184 185 186
  for (i=0 ; i < (uint)dirp->number_off_files; i++)
  {
    file=dirp->dir_entry+i;
187
    if (is_prefix(file->name, prefbuf))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
188 189 190 191
    {
      fn_format(fname,file->name,slave_load_tmpdir,"",MY_UNPACK_FILENAME);
      my_delete(fname, MYF(0));
    }
192 193 194 195
  }

  my_dirend(dirp);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
196
#endif
197 198


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
199
/*
200
  write_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
201
*/
202

203
static bool write_str(IO_CACHE *file, char *str, uint length)
204
{
205 206 207 208
  byte tmp[1];
  tmp[0]= (byte) length;
  return (my_b_safe_write(file, tmp, sizeof(tmp)) ||
	  my_b_safe_write(file, (byte*) str, length));
209 210 211
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
212
/*
213
  read_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
214
*/
215

216 217
static inline int read_str(char **buf, char *buf_end, char **str,
			   uint8 *len)
218
{
219
  if (*buf + ((uint) (uchar) **buf) >= buf_end)
220
    return 1;
221 222 223
  *len= (uint8) **buf;
  *str= (*buf)+1;
  (*buf)+= (uint) *len+1;
224 225 226
  return 0;
}

227

228 229 230
/*
  Transforms a string into "" or its expression in 0x... form.
*/
monty@mysql.com's avatar
monty@mysql.com committed
231

232
char *str_to_hex(char *to, const char *from, uint len)
233 234 235
{
  if (len)
  {
monty@mysql.com's avatar
monty@mysql.com committed
236 237 238
    *to++= '0';
    *to++= 'x';
    to= octet2hex(to, from, len);
239 240
  }
  else
monty@mysql.com's avatar
monty@mysql.com committed
241 242
    to= strmov(to, "\"\"");
  return to;                               // pointer to end 0 of 'to'
243 244
}

245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266
/*
  Append a version of the 'from' string suitable for use in a query to
  the 'to' string.  To generate a correct escaping, the character set
  information in 'csinfo' is used.
 */
#ifndef MYSQL_CLIENT
int
append_query_string(CHARSET_INFO *csinfo,
                    String const *from, String *to)
{
  char *beg, *ptr;
  uint32 const orig_len= to->length();
  if (to->reserve(orig_len + from->length()*2+3))
    return 1;

  beg= to->c_ptr_quick() + to->length();
  ptr= beg;
  if (csinfo->escape_with_backslash_is_dangerous)
    ptr= str_to_hex(ptr, from->ptr(), from->length());
  else
  {
    *ptr++= '\'';
267
    ptr+= escape_string_for_mysql(csinfo, ptr, 0,
268 269 270 271 272 273 274 275
                                  from->ptr(), from->length());
    *ptr++='\'';
  }
  to->length(orig_len + ptr - beg);
  return 0;
}
#endif

276

277 278 279 280 281
/*
  Prints a "session_var=value" string. Used by mysqlbinlog to print some SET
  commands just before it prints a query.
*/

282 283
#ifdef MYSQL_CLIENT

284 285 286 287 288 289 290
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,", ");
291
    fprintf(file,"%s=%d", name, test(flags & option));
292 293 294
    *need_comma= 1;
  }
}
295
#endif
296

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
297
/**************************************************************************
298
	Log_event methods (= the parent class of all events)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
299
**************************************************************************/
300

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
301
/*
302
  Log_event::get_type_str()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
303
*/
304

305 306
const char* Log_event::get_type_str()
{
307
  switch(get_type_code()) {
308
  case START_EVENT_V3:  return "Start_v3";
309 310 311 312 313
  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";
314
  case NEW_LOAD_EVENT:   return "New_load";
315
  case SLAVE_EVENT:  return "Slave";
316 317 318 319
  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";
320
  case RAND_EVENT: return "RAND";
321
  case XID_EVENT: return "Xid";
322
  case USER_VAR_EVENT: return "User var";
323
  case FORMAT_DESCRIPTION_EVENT: return "Format_desc";
324 325
  case BEGIN_LOAD_QUERY_EVENT: return "Begin_load_query";
  case EXECUTE_LOAD_QUERY_EVENT: return "Execute_load_query";
326
  default: return "Unknown";				/* impossible */
327 328 329
  }
}

330

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
331
/*
332
  Log_event::Log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
333
*/
334

335
#ifndef MYSQL_CLIENT
336
Log_event::Log_event(THD* thd_arg, uint16 flags_arg, bool using_trans)
337
  :log_pos(0), temp_buf(0), exec_time(0), flags(flags_arg), thd(thd_arg)
338
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
339 340
  server_id=	thd->server_id;
  when=		thd->start_time;
341
  cache_stmt=	using_trans;
342 343 344
}


monty@mysql.com's avatar
monty@mysql.com committed
345
/*
346 347 348 349
  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
350 351
*/

352
Log_event::Log_event()
353
  :temp_buf(0), exec_time(0), flags(0), cache_stmt(0),
354 355
   thd(0)
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
356 357 358
  server_id=	::server_id;
  when=		time(NULL);
  log_pos=	0;
359
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
360
#endif /* !MYSQL_CLIENT */
361 362


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
363
/*
364
  Log_event::Log_event()
365
*/
366

367
Log_event::Log_event(const char* buf,
368
                     const Format_description_log_event* description_event)
369
  :temp_buf(0), cache_stmt(0)
370
{
371 372
#ifndef MYSQL_CLIENT
  thd = 0;
373
#endif
374 375
  when = uint4korr(buf);
  server_id = uint4korr(buf + SERVER_ID_OFFSET);
376
  if (description_event->binlog_version==1)
377
  {
378 379 380
    log_pos= 0;
    flags= 0;
    return;
381
  }
382 383 384
  /* 4.0 or newer */
  log_pos= uint4korr(buf + LOG_POS_OFFSET);
  /*
385 386 387 388 389 390 391 392
    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).
393 394 395
  */
  if (description_event->binlog_version==3 &&
      buf[EVENT_TYPE_OFFSET]<FORMAT_DESCRIPTION_EVENT && log_pos)
396
  {
397 398 399
      /*
        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
400 401
        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
402
        not have its log_pos (which is 0) changed or it will modify
403 404 405 406
        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).
407 408
      */
    log_pos+= uint4korr(buf + EVENT_LEN_OFFSET);
409
  }
410 411 412 413 414 415 416
  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))
  {
    /*
417 418
      These events always have a header which stops here (i.e. their
      header is FROZEN).
419 420
    */
    /*
421 422 423 424 425 426 427
      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.
428 429 430 431
    */
    return;
  }
  /* otherwise, go on with reading the header from buf (nothing now) */
432 433 434
}

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
437
/*
438
  Log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
439
*/
440

441
int Log_event::exec_event(struct st_relay_log_info* rli)
442
{
monty@mysql.com's avatar
monty@mysql.com committed
443 444
  DBUG_ENTER("Log_event::exec_event");

445 446 447 448 449 450 451 452 453 454 455 456
  /*
    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.
  */
457
  if (rli)
458
  {
459
    /*
460 461 462 463
      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= .
464

465
      CAUTION: opt_using_transactions means
466
      innodb || bdb ; suppose the master supports InnoDB and BDB,
467
      but the slave supports only BDB, problems
468
      will arise:
469 470
      - suppose an InnoDB table is created on the master,
      - then it will be MyISAM on the slave
471 472 473 474 475 476 477 478 479 480 481 482
      - 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.
483 484
    */
    if ((thd->options & OPTION_BEGIN) && opt_using_transactions)
485
      rli->inc_event_relay_log_pos();
486 487
    else
    {
488 489 490 491 492 493 494 495 496 497 498 499
      /*
        bug#29309 simulation: resetting the flag to force
        wrong behaviour of artificial event to update
        rli->last_master_timestamp for only one time -
        the first FLUSH LOGS in the test.
      */
      DBUG_EXECUTE_IF("let_first_flush_log_change_timestamp",
                      if (debug_not_change_ts_if_art_event == 1
                          && is_artificial_event())
                      {
                        debug_not_change_ts_if_art_event= 0;
                      });
500
      rli->inc_group_relay_log_pos(log_pos);
501
      flush_relay_log_info(rli);
502
      /* 
503 504
         Note that Rotate_log_event::exec_event() does not call this
         function, so there is no chance that a fake rotate event resets
505
         last_master_timestamp.
506 507 508
         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).
509
      */
510 511 512 513 514 515 516 517 518 519 520 521 522 523 524
#ifndef DBUG_OFF
      if (!(is_artificial_event() && debug_not_change_ts_if_art_event > 0))
#else
      if (!is_artificial_event())
#endif
        rli->last_master_timestamp= when;
      /*
        The flag is set back to be positive so that 
        any further FLUSH LOGS will be handled as prescribed.
      */
      DBUG_EXECUTE_IF("let_first_flush_log_change_timestamp",
                      if (debug_not_change_ts_if_art_event == 0)
                      {
                        debug_not_change_ts_if_art_event= 2;
                      });
525
    }
526
  }
monty@mysql.com's avatar
monty@mysql.com committed
527
  DBUG_RETURN(0);
528
}
529

530

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
531
/*
532
  Log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
533
*/
534

535
void Log_event::pack_info(Protocol *protocol)
536
{
537
  protocol->store("", &my_charset_bin);
538 539 540
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
541
/*
542
  Log_event::net_send()
543

544
  Only called by SHOW BINLOG EVENTS
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
545
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
546

547
int Log_event::net_send(Protocol *protocol, const char* log_name, my_off_t pos)
548
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
549 550
  const char *p= strrchr(log_name, FN_LIBCHAR);
  const char *event_type;
551 552 553
  if (p)
    log_name = p + 1;
  
554
  protocol->prepare_for_resend();
555
  protocol->store(log_name, &my_charset_bin);
556
  protocol->store((ulonglong) pos);
557
  event_type = get_type_str();
558
  protocol->store(event_type, strlen(event_type), &my_charset_bin);
559 560 561 562
  protocol->store((uint32) server_id);
  protocol->store((ulonglong) log_pos);
  pack_info(protocol);
  return protocol->write();
563
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
564 565 566
#endif /* HAVE_REPLICATION */


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
567
/*
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
568
  Log_event::init_show_field_list()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
569
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
570 571 572 573

void Log_event::init_show_field_list(List<Item>* field_list)
{
  field_list->push_back(new Item_empty_string("Log_name", 20));
574
  field_list->push_back(new Item_return_int("Pos", MY_INT32_NUM_DECIMAL_DIGITS,
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
575 576 577 578
					    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));
579 580
  field_list->push_back(new Item_return_int("End_log_pos",
                                            MY_INT32_NUM_DECIMAL_DIGITS,
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
581 582 583 584
					    MYSQL_TYPE_LONGLONG));
  field_list->push_back(new Item_empty_string("Info", 20));
}

585

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

590
bool Log_event::write_header(IO_CACHE* file, ulong event_data_length)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
591
{
592 593
  byte header[LOG_EVENT_HEADER_LEN];
  DBUG_ENTER("Log_event::write_header");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
594

595 596
  /* Store number of bytes that will be written by this event */
  data_written= event_data_length + sizeof(header);
597

598 599 600 601
  /*
    log_pos != 0 if this is relay-log event. In this case we should not
    change the position
  */
602

603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657
  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
658 659 660
}


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

  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
667
*/
668

669
int Log_event::read_log_event(IO_CACHE* file, String* packet,
670
			      pthread_mutex_t* log_lock)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
671 672
{
  ulong data_len;
673
  int result=0;
674
  char buf[LOG_EVENT_MINIMAL_HEADER_LEN];
675
  DBUG_ENTER("read_log_event");
676

677
  if (log_lock)
678
    pthread_mutex_lock(log_lock);
679 680
  if (my_b_read(file, (byte*) buf, sizeof(buf)))
  {
681 682 683 684 685
    /*
      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.
    */
686
    DBUG_PRINT("error",("file->error: %d", file->error));
687 688 689
    if (!file->error)
      result= LOG_READ_EOF;
    else
690
      result= (file->error > 0 ? LOG_READ_TRUNC : LOG_READ_IO);
691
    goto end;
692
  }
693
  data_len= uint4korr(buf + EVENT_LEN_OFFSET);
694
  if (data_len < LOG_EVENT_MINIMAL_HEADER_LEN ||
695
      data_len > current_thd->variables.max_allowed_packet)
696
  {
697
    DBUG_PRINT("error",("data_len: %ld", data_len));
698
    result= ((data_len < LOG_EVENT_MINIMAL_HEADER_LEN) ? LOG_READ_BOGUS :
699 700
	     LOG_READ_TOO_LARGE);
    goto end;
701
  }
702 703 704 705 706 707 708 709

  /* Append the log event header to packet */
  if (packet->append(buf, sizeof(buf)))
  {
    /* Failed to allocate packet */
    result= LOG_READ_MEM;
    goto end;
  }
710
  data_len-= LOG_EVENT_MINIMAL_HEADER_LEN;
711 712
  if (data_len)
  {
713
    /* Append rest of event, read directly from file into packet */
714
    if (packet->append(file, data_len))
715
    {
716
      /*
717 718 719 720 721 722 723 724 725 726
        Fatal error occured when appending rest of the event
        to packet, possible failures:
	1. EOF occured when reading from file, it's really an error
           as data_len is >=0 there's supposed to be more bytes available.
           file->error will have been set to number of bytes left to read
        2. Read was interrupted, file->error would normally be set to -1
        3. Failed to allocate memory for packet, my_errno
           will be ENOMEM(file->error shuold be 0, but since the
           memory allocation occurs before the call to read it might
           be uninitialized)
727
      */
728 729
      result= (my_errno == ENOMEM ? LOG_READ_MEM :
               (file->error >= 0 ? LOG_READ_TRUNC: LOG_READ_IO));
730
      /* Implicit goto end; */
731
    }
732
  }
733 734 735 736

end:
  if (log_lock)
    pthread_mutex_unlock(log_lock);
737
  DBUG_RETURN(result);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
738
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
739
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
740

741
#ifndef MYSQL_CLIENT
742 743
#define UNLOCK_MUTEX if (log_lock) pthread_mutex_unlock(log_lock);
#define LOCK_MUTEX if (log_lock) pthread_mutex_lock(log_lock);
744
#else
745
#define UNLOCK_MUTEX
746 747 748
#define LOCK_MUTEX
#endif

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
749
/*
750 751
  Log_event::read_log_event()

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
752
  NOTE:
753
    Allocates memory;  The caller is responsible for clean-up.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
754
*/
755

756
#ifndef MYSQL_CLIENT
757 758
Log_event* Log_event::read_log_event(IO_CACHE* file,
				     pthread_mutex_t* log_lock,
759
                                     const Format_description_log_event *description_event)
760
#else
761 762
Log_event* Log_event::read_log_event(IO_CACHE* file,
                                     const Format_description_log_event *description_event)
763
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
764
{
765
  DBUG_ENTER("Log_event::read_log_event(IO_CACHE *, Format_description_log_event *");
766
  DBUG_ASSERT(description_event != 0);
767 768 769 770 771
  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
772 773
    of 13 bytes, whereas LOG_EVENT_MINIMAL_HEADER_LEN is 19 bytes (it's
    "minimal" over the set {MySQL >=4.0}).
774 775 776
  */
  uint header_size= min(description_event->common_header_len,
                        LOG_EVENT_MINIMAL_HEADER_LEN);
777

778
  LOCK_MUTEX;
779
  DBUG_PRINT("info", ("my_b_tell: %lu", (ulong) my_b_tell(file)));
780
  if (my_b_read(file, (byte *) head, header_size))
781
  {
782 783
    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
784
    UNLOCK_MUTEX;
785
    /*
786 787 788
      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.
789
    */
790
    DBUG_RETURN(0);
791
  }
792
  uint data_len = uint4korr(head + EVENT_LEN_OFFSET);
793 794 795
  char *buf= 0;
  const char *error= 0;
  Log_event *res=  0;
796 797
#ifndef max_allowed_packet
  THD *thd=current_thd;
798
  uint max_allowed_packet= thd ? thd->variables.max_allowed_packet : ~(ulong)0;
799
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
800

801
  if (data_len > max_allowed_packet)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
802
  {
803 804
    error = "Event too big";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
805 806
  }

807
  if (data_len < header_size)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
808
  {
809 810
    error = "Event too small";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
811
  }
812 813 814

  // some events use the extra byte to null-terminate strings
  if (!(buf = my_malloc(data_len+1, MYF(MY_WME))))
815 816 817
  {
    error = "Out of memory";
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
818
  }
819
  buf[data_len] = 0;
820
  memcpy(buf, head, header_size);
821
  if (my_b_read(file, (byte*) buf + header_size, data_len - header_size))
822 823 824 825
  {
    error = "read error";
    goto err;
  }
826
  if ((res= read_log_event(buf, data_len, &error, description_event)))
827
    res->register_temp_buf(buf);
828

829
err:
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
830
  UNLOCK_MUTEX;
831
  if (!res)
832
  {
833
    DBUG_ASSERT(error != 0);
834 835
    sql_print_error("Error in Log_event::read_log_event(): "
                    "'%s', data_len: %d, event_type: %d",
836
		    error,data_len,head[EVENT_TYPE_OFFSET]);
837
    my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
838 839 840 841 842 843 844 845 846
    /*
      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;
847
  }
848
  DBUG_RETURN(res);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
849 850
}

851

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
852
/*
853
  Log_event::read_log_event()
854 855
  Binlog format tolerance is in (buf, event_len, description_event)
  constructors.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
856
*/
857

858 859 860
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
861
{
862 863
  Log_event* ev;
  DBUG_ENTER("Log_event::read_log_event(char*,...)");
864
  DBUG_ASSERT(description_event != 0);
865
  DBUG_PRINT("info", ("binlog_version: %d", description_event->binlog_version));
866
  if (event_len < EVENT_LEN_OFFSET ||
867 868 869
      (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
870
    DBUG_RETURN(NULL); // general sanity check - will fail on a partial read
871
  }
872

873
  switch(buf[EVENT_TYPE_OFFSET]) {
bk@work.mysql.com's avatar
bk@work.mysql.com committed
874
  case QUERY_EVENT:
875
    ev  = new Query_log_event(buf, event_len, description_event, QUERY_EVENT);
876
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
877
  case LOAD_EVENT:
878
    ev = new Load_log_event(buf, event_len, description_event);
879
    break;
880
  case NEW_LOAD_EVENT:
881
    ev = new Load_log_event(buf, event_len, description_event);
882
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
883
  case ROTATE_EVENT:
884
    ev = new Rotate_log_event(buf, event_len, description_event);
885
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
886
#ifdef HAVE_REPLICATION
887
  case SLAVE_EVENT: /* can never happen (unused event) */
888 889
    ev = new Slave_log_event(buf, event_len);
    break;
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
890
#endif /* HAVE_REPLICATION */
891
  case CREATE_FILE_EVENT:
892
    ev = new Create_file_log_event(buf, event_len, description_event);
893 894
    break;
  case APPEND_BLOCK_EVENT:
895
    ev = new Append_block_log_event(buf, event_len, description_event);
896 897
    break;
  case DELETE_FILE_EVENT:
898
    ev = new Delete_file_log_event(buf, event_len, description_event);
899 900
    break;
  case EXEC_LOAD_EVENT:
901
    ev = new Execute_load_log_event(buf, event_len, description_event);
902
    break;
903 904
  case START_EVENT_V3: /* this is sent only by MySQL <=4.x */
    ev = new Start_log_event_v3(buf, description_event);
905 906
    break;
  case STOP_EVENT:
907
    ev = new Stop_log_event(buf, description_event);
908 909
    break;
  case INTVAR_EVENT:
910
    ev = new Intvar_log_event(buf, description_event);
911
    break;
912 913 914
  case XID_EVENT:
    ev = new Xid_log_event(buf, description_event);
    break;
nick@mysql.com's avatar
nick@mysql.com committed
915
  case RAND_EVENT:
916
    ev = new Rand_log_event(buf, description_event);
nick@mysql.com's avatar
nick@mysql.com committed
917
    break;
918
  case USER_VAR_EVENT:
919 920 921 922
    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); 
923
    break;
924 925 926 927 928 929
  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;
930
  default:
931 932
    DBUG_PRINT("error",("Unknown evernt code: %d",(int) buf[EVENT_TYPE_OFFSET]));
    ev= NULL;
933
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
934
  }
935

936
  /*
937 938 939 940 941 942 943
    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'.
944
  */
945
  if (!ev || !ev->is_valid())
946
  {
947 948
    DBUG_PRINT("error",("Found invalid event in binary log"));

949
    delete ev;
950
#ifdef MYSQL_CLIENT
951
    if (!force_opt) /* then mysqlbinlog dies */
952 953
    {
      *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
954
      DBUG_RETURN(0);
955
    }
956
    ev= new Unknown_log_event(buf, description_event);
957 958
#else
    *error= "Found invalid event in binary log";
monty@mysql.com's avatar
monty@mysql.com committed
959
    DBUG_RETURN(0);
960
#endif
961
  }
monty@mysql.com's avatar
monty@mysql.com committed
962
  DBUG_RETURN(ev);  
bk@work.mysql.com's avatar
bk@work.mysql.com committed
963 964
}

965
#ifdef MYSQL_CLIENT
966

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
967
/*
968
  Log_event::print_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
969
*/
970

971
void Log_event::print_header(FILE* file, PRINT_EVENT_INFO* print_event_info)
972
{
973
  char llbuff[22];
974
  my_off_t hexdump_from= print_event_info->hexdump_from;
lars@mysql.com's avatar
lars@mysql.com committed
975

976 977
  fputc('#', file);
  print_timestamp(file);
978
  fprintf(file, " server id %d  end_log_pos %s ", server_id,
979
	  llstr(log_pos,llbuff));
980

981
  /* mysqlbinlog --hexdump */
982
  if (print_event_info->hexdump_from)
983 984
  {
    fprintf(file, "\n");
985 986 987
    uchar *ptr= (uchar*)temp_buf;
    my_off_t size=
      uint4korr(ptr + EVENT_LEN_OFFSET) - LOG_EVENT_MINIMAL_HEADER_LEN;
988 989
    my_off_t i;

990 991 992 993
    /* Header len * 4 >= header len * (2 chars + space + extra space) */
    char *h, hex_string[LOG_EVENT_MINIMAL_HEADER_LEN*4]= {0};
    char *c, char_string[16+1]= {0};

lars@mysql.com's avatar
lars@mysql.com committed
994
    /* Pretty-print event common header if header is exactly 19 bytes */
995
    if (print_event_info->common_header_len == LOG_EVENT_MINIMAL_HEADER_LEN)
lars@mysql.com's avatar
lars@mysql.com committed
996 997 998 999 1000 1001
    {
      fprintf(file, "# Position  Timestamp   Type   Master ID        "
	      "Size      Master Pos    Flags \n");
      fprintf(file, "# %8.8lx %02x %02x %02x %02x   %02x   "
	      "%02x %02x %02x %02x   %02x %02x %02x %02x   "
	      "%02x %02x %02x %02x   %02x %02x\n",
1002 1003 1004 1005
	      (unsigned long) hexdump_from,
              ptr[0], ptr[1], ptr[2], ptr[3], ptr[4], ptr[5], ptr[6],
              ptr[7], ptr[8], ptr[9], ptr[10], ptr[11], ptr[12], ptr[13],
              ptr[14], ptr[15], ptr[16], ptr[17], ptr[18]);
lars@mysql.com's avatar
lars@mysql.com committed
1006 1007 1008
      ptr += LOG_EVENT_MINIMAL_HEADER_LEN;
      hexdump_from += LOG_EVENT_MINIMAL_HEADER_LEN;
    }
1009 1010 1011 1012 1013

    /* Rest of event (without common header) */
    for (i= 0, c= char_string, h=hex_string;
	 i < size;
	 i++, ptr++)
1014
    {
1015 1016
      my_snprintf(h, 4, "%02x ", *ptr);
      h += 3;
1017

1018
      *c++= my_isalnum(&my_charset_bin, *ptr) ? *ptr : '.';
1019 1020 1021

      if (i % 16 == 15)
      {
1022
	fprintf(file, "# %8.8lx %-48.48s |%16s|\n",
1023 1024
		(unsigned long) (hexdump_from + (i & 0xfffffff0)),
                hex_string, char_string);
1025 1026 1027 1028
	hex_string[0]= 0;
	char_string[0]= 0;
	c= char_string;
	h= hex_string;
1029
      }
1030
      else if (i % 8 == 7) *h++ = ' ';
1031
    }
1032
    *c= '\0';
1033

1034
    if (hex_string[0])
gshchepa/uchum@gleb.loc's avatar
gshchepa/uchum@gleb.loc committed
1035 1036
    {
      /* Non-full last line */
1037 1038 1039
      fprintf(file, "# %8.8lx %-48.48s |%s|\n# ",
	     (unsigned long) (hexdump_from + (i & 0xfffffff0)),
             hex_string, char_string);
gshchepa/uchum@gleb.loc's avatar
gshchepa/uchum@gleb.loc committed
1040 1041 1042
    }
    else
      fprintf(file, "# ");
1043
  }
1044 1045
}

1046

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1047
/*
1048
  Log_event::print_timestamp()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1049
*/
1050

1051
void Log_event::print_timestamp(FILE* file, time_t* ts)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1052
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1053
  struct tm *res;
1054 1055
  if (!ts)
    ts = &when;
1056 1057
#ifdef MYSQL_SERVER				// This is always false
  struct tm tm_tmp;
monty@work.mysql.com's avatar
monty@work.mysql.com committed
1058
  localtime_r(ts,(res= &tm_tmp));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1059
#else
1060
  res=localtime(ts);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1061
#endif
1062 1063

  fprintf(file,"%02d%02d%02d %2d:%02d:%02d",
1064 1065 1066 1067 1068 1069
	  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
1070 1071
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1072
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1073 1074


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1075
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1076
	Query_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1077
**************************************************************************/
1078

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1081
/*
1082
  Query_log_event::pack_info()
1083 1084 1085 1086
  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
1087
*/
1088

1089
void Query_log_event::pack_info(Protocol *protocol)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1090
{
1091
  // TODO: show the catalog ??
1092 1093 1094
  char *buf, *pos;
  if (!(buf= my_malloc(9 + db_len + q_len, MYF(MY_WME))))
    return;
1095 1096
  pos= buf;
  if (!(flags & LOG_EVENT_SUPPRESS_USE_F)
1097
      && db && db_len)
1098
  {
1099 1100
    pos= strmov(buf, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1101
    pos= strmov(pos+db_len, "`; ");
1102
  }
1103
  if (query && q_len)
1104 1105 1106 1107
  {
    memcpy(pos, query, q_len);
    pos+= q_len;
  }
1108
  protocol->store(buf, pos-buf, &my_charset_bin);
1109
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
1110
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1111
#endif
1112

1113
#ifndef MYSQL_CLIENT
1114

1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126
/* 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
1127
/*
1128
  Query_log_event::write()
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1129

1130 1131 1132 1133
  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
1134
*/
1135

1136
bool Query_log_event::write(IO_CACHE* file)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1137
{
1138 1139 1140 1141 1142
  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
1143
            1+6+           // code of charset and charset
1144
            1+1+MAX_TIME_ZONE_NAME_LENGTH+ // code of tz and tz length and tz name
1145 1146
            1+2+           // code of lc_time_names and lc_time_names_number
            1+2            // code of charset_database and charset_database_number
1147
            ], *start, *start_of_status;
1148
  ulong event_length;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1149

1150
  if (!query)
1151 1152
    return 1;                                   // Something wrong with event

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1153 1154 1155 1156 1157
  /*
    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.
1158
    Now imagine we (write()) are called by the slave SQL thread (we are
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190
    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);
1191 1192 1193 1194
  int4store(buf + Q_EXEC_TIME_OFFSET, exec_time);
  buf[Q_DB_LEN_OFFSET] = (char) db_len;
  int2store(buf + Q_ERR_CODE_OFFSET, error_code);

1195 1196 1197 1198 1199 1200 1201 1202
  /*
    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)
  {
1203
    *start++= Q_FLAGS2_CODE;
1204 1205 1206 1207 1208
    int4store(start, flags2);
    start+= 4;
  }
  if (sql_mode_inited)
  {
1209
    *start++= Q_SQL_MODE_CODE;
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1210
    int8store(start, (ulonglong)sql_mode);
1211 1212
    start+= 8;
  }
1213
  if (catalog_len) // i.e. this var is inited (false for 4.0 events)
1214
  {
1215 1216
    write_str_with_code_and_len((char **)(&start),
                                catalog, catalog_len, Q_CATALOG_NZ_CODE);
1217
    /*
1218 1219 1220 1221 1222 1223
      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
1224 1225 1226 1227 1228
      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
1229 1230
      Q_AUTO_INCREMENT*, Q_CHARSET and so replication will fail silently in
      various ways. Documented that you should not mix alpha/beta versions if
1231 1232 1233
      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.
1234
    */
1235 1236 1237 1238 1239 1240 1241 1242
  }
  if (auto_increment_increment != 1)
  {
    *start++= Q_AUTO_INCREMENT;
    int2store(start, auto_increment_increment);
    int2store(start+2, auto_increment_offset);
    start+= 4;
  }
1243 1244
  if (charset_inited)
  {
1245
    *start++= Q_CHARSET_CODE;
1246 1247 1248
    memcpy(start, charset, 6);
    start+= 6;
  }
1249 1250 1251 1252 1253 1254 1255 1256 1257
  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;
  }
1258 1259 1260 1261 1262 1263 1264
  if (lc_time_names_number)
  {
    DBUG_ASSERT(lc_time_names_number <= 0xFFFF);
    *start++= Q_LC_TIME_NAMES_CODE;
    int2store(start, lc_time_names_number);
    start+= 2;
  }
1265 1266 1267 1268 1269 1270 1271
  if (charset_database_number)
  {
    DBUG_ASSERT(charset_database_number <= 0xFFFF);
    *start++= Q_CHARSET_DATABASE_CODE;
    int2store(start, charset_database_number);
    start+= 2;
  }
1272 1273
  /*
    Here there could be code like
1274
    if (command-line-option-which-says-"log_this_variable" && inited)
1275
    {
1276
    *start++= Q_THIS_VARIABLE_CODE;
1277 1278 1279 1280 1281 1282 1283
    int4store(start, this_variable);
    start+= 4;
    }
  */
  
  /* Store length of status variables */
  status_vars_len= (uint) (start-start_of_status);
1284
  DBUG_ASSERT(status_vars_len <= MAX_SIZE_LOG_EVENT_STATUS);
1285 1286 1287 1288 1289 1290
  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
  */
1291
  event_length= (uint) (start-buf) + get_post_header_size_for_derived() + db_len + 1 + q_len;
1292 1293

  return (write_header(file, event_length) ||
1294 1295 1296 1297
          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)) ||
1298 1299
          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
1300 1301
}

1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313
/*
  Query_log_event::Query_log_event()
 
  The simplest constructor that could possibly work.  This is used for
  creating static objects that have a special meaning and are invisible
  to the log.  
*/
Query_log_event::Query_log_event()
  :Log_event(), data_buf(0)
{
}

1314

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1315
/*
1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330
  SYNOPSIS
    Query_log_event::Query_log_event()
      thd               - thread handle
      query_arg         - array of char representing the query
      query_length      - size of the  `query_arg' array
      using_trans       - there is a modified transactional table
      suppress_use      - suppress the generation of 'USE' statements
      killed_status_arg - an optional with default to THD::KILLED_NO_VALUE
                          if the value is different from the default, the arg
                          is set to the current thd->killed value.
                          A caller might need to masquerade thd->killed with
                          THD::NOT_KILLED.
  DESCRIPTION
  Creates an event for binlogging
  The value for local `killed_status' can be supplied by caller.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1331
*/
1332
Query_log_event::Query_log_event(THD* thd_arg, const char* query_arg,
1333
				 ulong query_length, bool using_trans,
1334
				 bool suppress_use, THD::killed_state killed_status_arg)
1335
  :Log_event(thd_arg,
1336 1337 1338
             ((thd_arg->tmp_table_used || thd_arg->thread_specific_used) ? 
	        LOG_EVENT_THREAD_SPECIFIC_F : 0) |
	      (suppress_use ? LOG_EVENT_SUPPRESS_USE_F : 0),
1339
	     using_trans),
1340
   data_buf(0), query(query_arg), catalog(thd_arg->catalog),
1341
   db(thd_arg->db), q_len((uint32) query_length),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
1342 1343
   thread_id(thd_arg->thread_id),
   /* save the original thread id; we already know the server id */
1344
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
1345
   flags2_inited(1), sql_mode_inited(1), charset_inited(1),
1346 1347
   sql_mode(thd_arg->variables.sql_mode),
   auto_increment_increment(thd_arg->variables.auto_increment_increment),
1348
   auto_increment_offset(thd_arg->variables.auto_increment_offset),
1349 1350
   lc_time_names_number(thd_arg->variables.lc_time_names->number),
   charset_database_number(0)
1351 1352
{
  time_t end_time;
1353 1354 1355 1356 1357 1358 1359 1360

  if (killed_status_arg == THD::KILLED_NO_VALUE)
    killed_status_arg= thd_arg->killed;
  error_code=
    (killed_status_arg == THD::NOT_KILLED) ? thd_arg->net.last_errno :
    ((thd_arg->system_thread & SYSTEM_THREAD_DELAYED_INSERT) ? 0 :
     thd->killed_errno());
  
1361 1362
  time(&end_time);
  exec_time = (ulong) (end_time  - thd->start_time);
1363
  catalog_len = (catalog) ? (uint32) strlen(catalog) : 0;
1364
  /* status_vars_len is set just before writing the event */
1365
  db_len = (db) ? (uint32) strlen(db) : 0;
1366 1367 1368
  if (thd_arg->variables.collation_database != thd_arg->db_charset)
    charset_database_number= thd_arg->variables.collation_database->number;
  
1369 1370 1371 1372 1373 1374 1375
  /*
    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 &.
  */
1376
  flags2= (uint32) (thd_arg->options & OPTIONS_WRITTEN_TO_BIN_LOG);
1377 1378 1379 1380 1381 1382
  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);
1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394
  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;
1395 1396
  DBUG_PRINT("info",("Query_log_event has flags2: %lu  sql_mode: %lu",
                     (ulong) flags2, sql_mode));
1397
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1398
#endif /* MYSQL_CLIENT */
1399

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

1401 1402
/* 2 utility functions for the next method */

1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425
/**
   Read a string with length from memory.

   This function reads the string-with-length stored at
   <code>src</code> and extract the length into <code>*len</code> and
   a pointer to the start of the string into <code>*dst</code>. The
   string can then be copied using <code>memcpy()</code> with the
   number of bytes given in <code>*len</code>.

   @param src Pointer to variable holding a pointer to the memory to
              read the string from.
   @param dst Pointer to variable holding a pointer where the actual
              string starts. Starting from this position, the string
              can be copied using @c memcpy().
   @param len Pointer to variable where the length will be stored.
   @param end One-past-the-end of the memory where the string is
              stored.

   @return    Zero if the entire string can be copied successfully,
              @c UINT_MAX if the length could not be read from memory
              (that is, if <code>*src >= end</code>), otherwise the
              number of bytes that are missing to read the full
              string, which happends <code>*dst + *len >= end</code>.
1426
*/
1427 1428 1429 1430 1431
static int
get_str_len_and_pointer(const Log_event::Byte **src,
                        const char **dst,
                        uint *len,
                        const Log_event::Byte *end)
1432
{
1433 1434 1435 1436 1437 1438
  if (*src >= end)
    return -1;       // Will be UINT_MAX in two-complement arithmetics
  uint length= **src;
  if (length > 0)
  {
    if (*src + length >= end)
1439
      return *src + length - end + 1;       // Number of bytes missing
1440 1441 1442
    *dst= (char *)*src + 1;                    // Will be copied later
  }
  *len= length;
1443 1444
  *src+= length + 1;
  return 0;
1445 1446
}

1447 1448 1449
static void copy_str_and_move(const char **src, 
                              Log_event::Byte **dst, 
                              uint len)
1450 1451
{
  memcpy(*dst, *src, len);
1452
  *src= (const char *)*dst;
1453 1454 1455 1456
  (*dst)+= len;
  *(*dst)++= 0;
}

1457

1458
#ifndef DBUG_OFF
1459 1460 1461 1462
static char const *
code_name(int code)
{
  static char buf[255];
1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476
  switch (code) {
  case Q_FLAGS2_CODE: return "Q_FLAGS2_CODE";
  case Q_SQL_MODE_CODE: return "Q_SQL_MODE_CODE";
  case Q_CATALOG_CODE: return "Q_CATALOG_CODE";
  case Q_AUTO_INCREMENT: return "Q_AUTO_INCREMENT";
  case Q_CHARSET_CODE: return "Q_CHARSET_CODE";
  case Q_TIME_ZONE_CODE: return "Q_TIME_ZONE_CODE";
  case Q_CATALOG_NZ_CODE: return "Q_CATALOG_NZ_CODE";
  case Q_LC_TIME_NAMES_CODE: return "Q_LC_TIME_NAMES_CODE";
  case Q_CHARSET_DATABASE_CODE: return "Q_CHARSET_DATABASE_CODE";
  }
  sprintf(buf, "CODE#%d", code);
  return buf;
}
1477
#endif
1478

1479 1480 1481 1482 1483 1484 1485
/**
   Macro to check that there is enough space to read from memory.

   @param PTR Pointer to memory
   @param END End of memory
   @param CNT Number of bytes that should be read.
 */
1486 1487 1488 1489 1490 1491 1492 1493 1494
#define CHECK_SPACE(PTR,END,CNT)                      \
  do {                                                \
    DBUG_PRINT("info", ("Read %s", code_name(pos[-1]))); \
    DBUG_ASSERT((PTR) + (CNT) <= (END));              \
    if ((PTR) + (CNT) > (END)) {                      \
      DBUG_PRINT("info", ("query= 0"));               \
      query= 0;                                       \
      DBUG_VOID_RETURN;                               \
    }                                                 \
1495 1496
  } while (0)

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1497
/*
1498
  Query_log_event::Query_log_event()
1499
  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
1500
*/
1501

1502
Query_log_event::Query_log_event(const char* buf, uint event_len,
1503 1504
                                 const Format_description_log_event *description_event,
                                 Log_event_type event_type)
1505
  :Log_event(buf, description_event), data_buf(0), query(NullS),
1506
   db(NullS), catalog_len(0), status_vars_len(0),
1507
   flags2_inited(0), sql_mode_inited(0), charset_inited(0),
1508
   auto_increment_increment(1), auto_increment_offset(1),
1509
   time_zone_len(0), lc_time_names_number(0), charset_database_number(0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1510 1511
{
  ulong data_len;
1512 1513
  uint32 tmp;
  uint8 common_header_len, post_header_len;
1514 1515
  Log_event::Byte *start;
  const Log_event::Byte *end;
1516
  bool catalog_nz= 1;
1517 1518 1519
  DBUG_ENTER("Query_log_event::Query_log_event(char*,...)");

  common_header_len= description_event->common_header_len;
1520
  post_header_len= description_event->post_header_len[event_type-1];
1521
  DBUG_PRINT("info",("event_len: %u  common_header_len: %d  post_header_len: %d",
1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535
                     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);
1536
  db_len = (uint)buf[Q_DB_LEN_OFFSET]; // TODO: add a check of all *_len vars
1537 1538 1539 1540 1541 1542 1543 1544 1545
  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)
1546
  {
1547
    status_vars_len= uint2korr(buf + Q_STATUS_VARS_LEN_OFFSET);
1548 1549 1550 1551 1552 1553
    /*
      Check if status variable length is corrupt and will lead to very
      wrong data. We could be even more strict and require data_len to
      be even bigger, but this will suffice to catch most corruption
      errors that can lead to a crash.
    */
1554
    if (status_vars_len > min(data_len, MAX_SIZE_LOG_EVENT_STATUS))
1555
    {
1556
      DBUG_PRINT("info", ("status_vars_len (%u) > data_len (%lu); query= 0",
1557
                          status_vars_len, data_len));
1558 1559 1560
      query= 0;
      DBUG_VOID_RETURN;
    }
1561 1562 1563 1564
    data_len-= status_vars_len;
    DBUG_PRINT("info", ("Query_log_event has status_vars_len: %u",
                        (uint) status_vars_len));
    tmp-= 2;
1565
  }
1566 1567 1568 1569 1570 1571
  /*
    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...)
  */

1572 1573
  /* variable-part: the status vars; only in MySQL 5.0  */
  
1574 1575 1576
  start= (Log_event::Byte*) (buf+post_header_len);
  end= (const Log_event::Byte*) (start+status_vars_len);
  for (const Log_event::Byte* pos= start; pos < end;)
1577
  {
1578 1579
    switch (*pos++) {
    case Q_FLAGS2_CODE:
1580
      CHECK_SPACE(pos, end, 4);
1581 1582
      flags2_inited= 1;
      flags2= uint4korr(pos);
1583
      DBUG_PRINT("info",("In Query_log_event, read flags2: %lu", (ulong) flags2));
1584 1585 1586 1587 1588 1589 1590
      pos+= 4;
      break;
    case Q_SQL_MODE_CODE:
    {
#ifndef DBUG_OFF
      char buff[22];
#endif
1591
      CHECK_SPACE(pos, end, 8);
1592 1593 1594 1595 1596 1597 1598
      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;
    }
1599
    case Q_CATALOG_NZ_CODE:
1600
      DBUG_PRINT("info", ("case Q_CATALOG_NZ_CODE; pos: 0x%lx; end: 0x%lx",
1601
                          (ulong) pos, (ulong) end));
1602 1603
      if (get_str_len_and_pointer(&pos, &catalog, &catalog_len, end))
      {
1604
        DBUG_PRINT("info", ("query= 0"));
1605 1606 1607
        query= 0;
        DBUG_VOID_RETURN;
      }
1608 1609
      break;
    case Q_AUTO_INCREMENT:
1610
      CHECK_SPACE(pos, end, 4);
1611 1612 1613 1614
      auto_increment_increment= uint2korr(pos);
      auto_increment_offset=    uint2korr(pos+2);
      pos+= 4;
      break;
1615 1616
    case Q_CHARSET_CODE:
    {
1617
      CHECK_SPACE(pos, end, 6);
1618 1619 1620 1621 1622
      charset_inited= 1;
      memcpy(charset, pos, 6);
      pos+= 6;
      break;
    }
1623 1624
    case Q_TIME_ZONE_CODE:
    {
1625 1626
      if (get_str_len_and_pointer(&pos, &time_zone_str, &time_zone_len, end))
      {
1627
        DBUG_PRINT("info", ("Q_TIME_ZONE_CODE: query= 0"));
1628 1629 1630
        query= 0;
        DBUG_VOID_RETURN;
      }
1631 1632
      break;
    }
1633
    case Q_CATALOG_CODE: /* for 5.0.x where 0<=x<=3 masters */
1634
      CHECK_SPACE(pos, end, 1);
1635 1636
      if ((catalog_len= *pos))
        catalog= (char*) pos+1;                           // Will be copied later
1637
      CHECK_SPACE(pos, end, catalog_len + 2);
1638 1639 1640
      pos+= catalog_len+2; // leap over end 0
      catalog_nz= 0; // catalog has end 0 in event
      break;
1641
    case Q_LC_TIME_NAMES_CODE:
1642
      CHECK_SPACE(pos, end, 2);
1643 1644 1645
      lc_time_names_number= uint2korr(pos);
      pos+= 2;
      break;
1646
    case Q_CHARSET_DATABASE_CODE:
1647
      CHECK_SPACE(pos, end, 2);
1648 1649 1650
      charset_database_number= uint2korr(pos);
      pos+= 2;
      break;
1651 1652 1653 1654
    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)));
1655
      pos= (const uchar*) end;                         // Break loop
1656
    }
1657
  }
1658
  
1659
#if !defined(MYSQL_CLIENT) && defined(HAVE_QUERY_CACHE)
1660 1661 1662 1663 1664 1665
  if (!(start= data_buf = (Log_event::Byte*) my_malloc(catalog_len + 1 +
                                              time_zone_len + 1 +
                                              data_len + 1 +
                                              QUERY_CACHE_FLAGS_SIZE +
                                              db_len + 1,
                                              MYF(MY_WME))))
1666
#else
1667 1668 1669 1670
  if (!(start= data_buf = (Log_event::Byte*) my_malloc(catalog_len + 1 +
                                             time_zone_len + 1 +
                                             data_len + 1,
                                             MYF(MY_WME))))
1671
#endif
1672
      DBUG_VOID_RETURN;
1673
  if (catalog_len)                                  // If catalog is given
1674
  {
1675
    if (likely(catalog_nz)) // true except if event comes from 5.0.0|1|2|3.
1676
      copy_str_and_move(&catalog, &start, catalog_len);
1677 1678 1679
    else
    {
      memcpy(start, catalog, catalog_len+1); // copy end 0
1680
      catalog= (const char *)start;
1681 1682
      start+= catalog_len+1;
    }
1683
  }
1684
  if (time_zone_len)
1685
    copy_str_and_move(&time_zone_str, &start, time_zone_len);
1686

1687
  /* A 2nd variable part; this is common to all versions */ 
1688
  memcpy((char*) start, end, data_len);          // Copy db and query
1689
  start[data_len]= '\0';              // End query with \0 (For safetly)
1690 1691
  db= (char *)start;
  query= (char *)(start + db_len + 1);
1692 1693
  q_len= data_len - db_len -1;
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1694 1695
}

1696

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1697
/*
1698
  Query_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1699
*/
1700

1701
#ifdef MYSQL_CLIENT
lars@mysql.com's avatar
lars@mysql.com committed
1702
void Query_log_event::print_query_header(FILE* file,
1703
					 PRINT_EVENT_INFO* print_event_info)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1704
{
1705
  // TODO: print the catalog ??
1706
  char buff[40],*end;				// Enough for SET TIMESTAMP
1707 1708 1709
  bool different_db= 1;
  uint32 tmp;

1710
  if (!print_event_info->short_form)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1711
  {
1712
    print_header(file, print_event_info);
1713 1714
    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
1715 1716
  }

monty@mysql.com's avatar
monty@mysql.com committed
1717
  if (!(flags & LOG_EVENT_SUPPRESS_USE_F) && db)
1718
  {
1719 1720
    if (different_db= memcmp(print_event_info->db, db, db_len + 1))
      memcpy(print_event_info->db, db, db_len + 1);
monty@mysql.com's avatar
monty@mysql.com committed
1721
    if (db[0] && different_db) 
1722
      fprintf(file, "use %s%s\n", db, print_event_info->delimiter);
1723
  }
1724

1725
  end=int10_to_str((long) when, strmov(buff,"SET TIMESTAMP="),10);
1726
  end= strmov(end, print_event_info->delimiter);
1727 1728
  *end++='\n';
  my_fwrite(file, (byte*) buff, (uint) (end-buff),MYF(MY_NABP | MY_WME));
1729
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
1730 1731
    fprintf(file,"SET @@session.pseudo_thread_id=%lu%s\n",
            (ulong)thread_id, print_event_info->delimiter);
1732

1733
  /*
1734 1735 1736
    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).
1737 1738 1739 1740
  */
  if (likely(flags2_inited)) /* likely as this will mainly read 5.0 logs */
  {
    /* tmp is a bitmask of bits which have changed. */
1741
    if (likely(print_event_info->flags2_inited)) 
1742
      /* All bits which have changed */
1743
      tmp= (print_event_info->flags2) ^ flags2;
1744 1745
    else /* that's the first Query event we read */
    {
1746
      print_event_info->flags2_inited= 1;
1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759
      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);
1760
      fprintf(file,"%s\n", print_event_info->delimiter);
1761
      print_event_info->flags2= flags2;
1762 1763 1764 1765
    }
  }

  /*
1766 1767 1768 1769 1770 1771 1772 1773 1774 1775
    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.
1776 1777 1778 1779
  */

  if (likely(sql_mode_inited))
  {
1780
    if (unlikely(!print_event_info->sql_mode_inited)) /* first Query event */
1781
    {
1782
      print_event_info->sql_mode_inited= 1;
1783
      /* force a difference to force write */
1784
      print_event_info->sql_mode= ~sql_mode;
1785
    }
1786
    if (unlikely(print_event_info->sql_mode != sql_mode))
1787
    {
1788 1789
      fprintf(file,"SET @@session.sql_mode=%lu%s\n",
              (ulong)sql_mode, print_event_info->delimiter);
1790
      print_event_info->sql_mode= sql_mode;
1791 1792
    }
  }
1793 1794
  if (print_event_info->auto_increment_increment != auto_increment_increment ||
      print_event_info->auto_increment_offset != auto_increment_offset)
1795
  {
1796 1797 1798
    fprintf(file,"SET @@session.auto_increment_increment=%lu, @@session.auto_increment_offset=%lu%s\n",
            auto_increment_increment,auto_increment_offset,
            print_event_info->delimiter);
1799 1800
    print_event_info->auto_increment_increment= auto_increment_increment;
    print_event_info->auto_increment_offset=    auto_increment_offset;
1801 1802
  }

1803 1804
  /* TODO: print the catalog when we feature SET CATALOG */

1805 1806
  if (likely(charset_inited))
  {
1807
    if (unlikely(!print_event_info->charset_inited)) /* first Query event */
1808
    {
1809 1810
      print_event_info->charset_inited= 1;
      print_event_info->charset[0]= ~charset[0]; // force a difference to force write
1811
    }
1812
    if (unlikely(bcmp(print_event_info->charset, charset, 6)))
1813
    {
1814 1815 1816
      CHARSET_INFO *cs_info= get_charset(uint2korr(charset), MYF(MY_WME));
      if (cs_info)
      {
1817 1818 1819
        /* for mysql client */
        fprintf(file, "/*!\\C %s */%s\n",
                cs_info->csname, print_event_info->delimiter);
1820
      }
1821 1822 1823 1824
      fprintf(file,"SET "
              "@@session.character_set_client=%d,"
              "@@session.collation_connection=%d,"
              "@@session.collation_server=%d"
1825
              "%s\n",
1826 1827
              uint2korr(charset),
              uint2korr(charset+2),
1828 1829
              uint2korr(charset+4),
              print_event_info->delimiter);
1830
      memcpy(print_event_info->charset, charset, 6);
1831 1832
    }
  }
1833 1834
  if (time_zone_len)
  {
1835
    if (bcmp(print_event_info->time_zone_str, time_zone_str, time_zone_len+1))
1836
    {
1837 1838
      fprintf(file,"SET @@session.time_zone='%s'%s\n",
              time_zone_str, print_event_info->delimiter);
1839
      memcpy(print_event_info->time_zone_str, time_zone_str, time_zone_len+1);
1840 1841
    }
  }
1842 1843
  if (lc_time_names_number != print_event_info->lc_time_names_number)
  {
bar@mysql.com's avatar
bar@mysql.com committed
1844 1845
    fprintf(file, "SET @@session.lc_time_names=%d%s\n",
            lc_time_names_number, print_event_info->delimiter);
1846 1847
    print_event_info->lc_time_names_number= lc_time_names_number;
  }
1848 1849 1850 1851 1852 1853 1854 1855 1856 1857
  if (charset_database_number != print_event_info->charset_database_number)
  {
    if (charset_database_number)
      fprintf(file, "SET @@session.collation_database=%d%s\n",
              charset_database_number, print_event_info->delimiter);
    else
      fprintf(file, "SET @@session.collation_database=DEFAULT%s\n",
              print_event_info->delimiter);
    print_event_info->charset_database_number= charset_database_number;
  }
1858 1859
}

1860

1861
void Query_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
1862
{
1863
  print_query_header(file, print_event_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1864
  my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
1865
  fprintf(file, "%s\n", print_event_info->delimiter);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1866
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1867
#endif /* MYSQL_CLIENT */
1868

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1870
/*
1871
  Query_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1872
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1873

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1874
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891

static const char *rewrite_db(const char *db)
{
  if (replicate_rewrite_db.is_empty() || db == NULL)
    return db;
  I_List_iterator<i_string_pair> it(replicate_rewrite_db);
  i_string_pair* tmp;

  while ((tmp=it++))
  {
    if (strcmp(tmp->key, db) == 0)
      return tmp->val;
  }
  return db;
}


1892
int Query_log_event::exec_event(struct st_relay_log_info* rli)
1893 1894 1895 1896 1897
{
  return exec_event(rli, query, q_len);
}


1898 1899
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
1900
{
1901
  const char *new_db= rewrite_db(db);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1902
  int expected_error,actual_error= 0;
1903 1904 1905 1906 1907 1908
  /*
    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.
  */
1909
  thd->catalog= catalog_len ? (char *) catalog : (char *)"";
1910
  thd->set_db(new_db, strlen(new_db));          /* allocates a copy of 'db' */
1911 1912
  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
1913

1914
  /*
1915 1916 1917 1918 1919 1920 1921 1922
    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.
1923
  */
monty@mysql.com's avatar
monty@mysql.com committed
1924
  rli->future_group_master_log_pos= log_pos;
1925 1926
  DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));

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

lars@mysql.com's avatar
lars@mysql.com committed
1929 1930 1931 1932 1933 1934 1935 1936 1937 1938
  /*
    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().
  */
1939 1940 1941
  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
  {
    thd->set_time((time_t)when);
1942 1943
    thd->query_length= q_len_arg;
    thd->query= (char*)query_arg;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1944
    VOID(pthread_mutex_lock(&LOCK_thread_count));
1945
    thd->query_id = next_query_id();
1946
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
1947
    thd->variables.pseudo_thread_id= thread_id;		// for temp tables
monty@mysql.com's avatar
monty@mysql.com committed
1948
    DBUG_PRINT("query",("%s",thd->query));
1949

monty@mysql.com's avatar
monty@mysql.com committed
1950
    if (ignored_error_code((expected_error= error_code)) ||
1951
	!check_expected_error(thd,rli,expected_error))
1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987
    {
      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))))
          {
            /*
1988 1989 1990 1991
              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).
1992
            */
1993
            set_slave_thread_default_charset(thd, rli);
1994 1995 1996 1997 1998
            goto compare_errors;
          }
          thd->update_charset(); // for the charset change to take effect
        }
      }
1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
      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;
        }
      }
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022
      if (lc_time_names_number)
      {
        if (!(thd->variables.lc_time_names=
              my_locale_by_number(lc_time_names_number)))
        {
          my_printf_error(ER_UNKNOWN_ERROR,
                      "Unknown locale: '%d'", MYF(0), lc_time_names_number);
          thd->variables.lc_time_names= &my_locale_en_US;
          goto compare_errors;
        }
      }
      else
        thd->variables.lc_time_names= &my_locale_en_US;
2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037
      if (charset_database_number)
      {
        CHARSET_INFO *cs;
        if (!(cs= get_charset(charset_database_number, MYF(0))))
        {
          char buf[20];
          int10_to_str((int) charset_database_number, buf, -10);
          my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
          goto compare_errors;
        }
        thd->variables.collation_database= cs;
      }
      else
        thd->variables.collation_database= thd->db_charset;
      
2038
      /* Execute the query (note that we bypass dispatch_command()) */
2039 2040
      const char* found_semicolon= NULL;
      mysql_parse(thd, thd->query, thd->query_length, &found_semicolon);
2041 2042

    }
monty@mysql.com's avatar
monty@mysql.com committed
2043 2044
    else
    {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2045
      /*
monty@mysql.com's avatar
monty@mysql.com committed
2046 2047 2048 2049 2050
        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
2051
      */
2052
      if (mysql_test_parse_for_slave(thd, thd->query, thd->query_length))
monty@mysql.com's avatar
monty@mysql.com committed
2053 2054
        clear_all_errors(thd, rli);        /* Can ignore query */
      else
2055
      {
monty@mysql.com's avatar
monty@mysql.com committed
2056
        slave_print_error(rli,expected_error, 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2057
                          "\
monty@mysql.com's avatar
monty@mysql.com committed
2058
Query partially completed on the master (error on master: %d) \
monty@mysql.com's avatar
monty@mysql.com committed
2059 2060 2061
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
2062
START SLAVE; . Query: '%s'", expected_error, thd->query);
monty@mysql.com's avatar
monty@mysql.com committed
2063 2064 2065 2066
        thd->query_error= 1;
      }
      goto end;
    }
2067

2068 2069 2070 2071
    /* 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);

2072
compare_errors:
lars@mysql.com's avatar
lars@mysql.com committed
2073 2074

     /*
monty@mysql.com's avatar
monty@mysql.com committed
2075 2076 2077 2078
      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",
2079
 		       expected_error, thd->net.last_errno));
monty@mysql.com's avatar
monty@mysql.com committed
2080
    if ((expected_error != (actual_error= thd->net.last_errno)) &&
2081 2082 2083
 	expected_error &&
 	!ignored_error_code(actual_error) &&
 	!ignored_error_code(expected_error))
monty@mysql.com's avatar
monty@mysql.com committed
2084 2085
    {
      slave_print_error(rli, 0,
2086
 			"\
monty@mysql.com's avatar
monty@mysql.com committed
2087
Query caused different errors on master and slave. \
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2088
Error on master: '%s' (%d), Error on slave: '%s' (%d). \
monty@mysql.com's avatar
monty@mysql.com committed
2089
Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
2090 2091 2092 2093
			ER_SAFE(expected_error),
			expected_error,
			actual_error ? thd->net.last_error: "no error",
			actual_error,
2094
			print_slave_db_safe(db), query_arg);
monty@mysql.com's avatar
monty@mysql.com committed
2095 2096 2097 2098 2099 2100
      thd->query_error= 1;
    }
    /*
      If we get the same error code as expected, or they should be ignored. 
    */
    else if (expected_error == actual_error ||
2101
 	     ignored_error_code(actual_error))
monty@mysql.com's avatar
monty@mysql.com committed
2102 2103 2104
    {
      DBUG_PRINT("info",("error ignored"));
      clear_all_errors(thd, rli);
2105
      thd->killed= THD::NOT_KILLED;
monty@mysql.com's avatar
monty@mysql.com committed
2106 2107 2108
    }
    /*
      Other cases: mostly we expected no error and get one.
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2109
    */
monty@mysql.com's avatar
monty@mysql.com committed
2110 2111 2112
    else if (thd->query_error || thd->is_fatal_error)
    {
      slave_print_error(rli,actual_error,
monty@mysql.com's avatar
monty@mysql.com committed
2113
			"Error '%s' on query. Default database: '%s'. Query: '%s'",
monty@mysql.com's avatar
monty@mysql.com committed
2114 2115
			(actual_error ? thd->net.last_error :
			 "unexpected success or fatal error"),
2116
			print_slave_db_safe(thd->db), query_arg);
monty@mysql.com's avatar
monty@mysql.com committed
2117 2118
      thd->query_error= 1;
    }
2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132

    /*
      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...
2133

2134 2135 2136 2137 2138 2139 2140
      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
2141 2142
  } /* End of if (db_ok(... */

monty@mysql.com's avatar
monty@mysql.com committed
2143
end:
2144
  VOID(pthread_mutex_lock(&LOCK_thread_count));
2145 2146 2147 2148 2149 2150
  /*
    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
2151 2152 2153
    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.
2154
  */
2155
  thd->catalog= 0;
2156
  thd->set_db(NULL, 0);                 /* will free the current database */
2157
  DBUG_PRINT("info", ("end: query= 0"));
2158
  thd->query= 0;			// just to be sure
2159
  thd->query_length= 0;
2160
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2161
  close_thread_tables(thd);      
2162
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
2163 2164 2165 2166 2167 2168 2169
  /*
    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 : 
2170
          (thd->one_shot_set ? (rli->inc_event_relay_log_pos(),0) :
2171
           Log_event::exec_event(rli))); 
2172
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2173
#endif
2174

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

2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190
/**************************************************************************
	Muted_query_log_event methods
**************************************************************************/

#ifndef MYSQL_CLIENT
/*
  Muted_query_log_event::Muted_query_log_event()
*/
Muted_query_log_event::Muted_query_log_event()
  :Query_log_event()
{
}
#endif


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2191
/**************************************************************************
2192
	Start_log_event_v3 methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2193
**************************************************************************/
2194

2195 2196 2197 2198 2199 2200 2201 2202
#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
2203
/*
2204
  Start_log_event_v3::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2205
*/
2206

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2207
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2208
void Start_log_event_v3::pack_info(Protocol *protocol)
nick@mysql.com's avatar
nick@mysql.com committed
2209
{
2210 2211 2212 2213
  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
2214 2215
  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
2216
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2217
#endif
2218 2219


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2220
/*
2221
  Start_log_event_v3::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2222
*/
nick@mysql.com's avatar
nick@mysql.com committed
2223 2224

#ifdef MYSQL_CLIENT
2225
void Start_log_event_v3::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
nick@mysql.com's avatar
nick@mysql.com committed
2226
{
2227
  if (!print_event_info->short_form)
2228
  {
2229
    print_header(file, print_event_info);
2230 2231 2232 2233 2234 2235
    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);
2236 2237 2238
    if (flags & LOG_EVENT_BINLOG_IN_USE_F)
      fprintf(file, "# Warning: this binlog was not closed properly. "
              "Most probably mysqld crashed writing it.\n");
2239
  }
2240 2241
  if (!artificial_event && created)
  {
2242
#ifdef WHEN_WE_HAVE_THE_RESET_CONNECTION_SQL_COMMAND
2243 2244 2245 2246 2247 2248
    /*
      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).
    */
2249
    fprintf(file,"RESET CONNECTION%s\n", print_event_info->delimiter);
2250
#else
2251
    fprintf(file,"ROLLBACK%s\n", print_event_info->delimiter);
2252
#endif
2253
  }
nick@mysql.com's avatar
nick@mysql.com committed
2254 2255
  fflush(file);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2256
#endif /* MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2257

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2258
/*
2259
  Start_log_event_v3::Start_log_event_v3()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2260
*/
2261

2262 2263 2264
Start_log_event_v3::Start_log_event_v3(const char* buf,
                                       const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
2265
{
2266 2267
  buf+= description_event->common_header_len;
  binlog_version= uint2korr(buf+ST_BINLOG_VER_OFFSET);
2268 2269
  memcpy(server_version, buf+ST_SERVER_VER_OFFSET,
	 ST_SERVER_VER_LEN);
guilhem@gbichot3.local's avatar
guilhem@gbichot3.local committed
2270 2271
  // prevent overrun if log is corrupted on disk
  server_version[ST_SERVER_VER_LEN-1]= 0;
2272 2273 2274
  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
2275 2276
}

2277

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2278
/*
2279
  Start_log_event_v3::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2280
*/
2281

2282
#ifndef MYSQL_CLIENT
2283
bool Start_log_event_v3::write(IO_CACHE* file)
2284
{
2285
  char buff[START_V3_HEADER_LEN];
2286 2287 2288
  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);
2289 2290
  return (write_header(file, sizeof(buff)) ||
          my_b_safe_write(file, (byte*) buff, sizeof(buff)));
2291
}
2292
#endif
2293

2294

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2295
/*
2296
  Start_log_event_v3::exec_event()
2297 2298 2299 2300

  The master started

  IMPLEMENTATION
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2301 2302 2303 2304
    - 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).
2305 2306

  TODO
2307 2308 2309 2310 2311
    - 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
2312 2313
*/

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2314
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2315
int Start_log_event_v3::exec_event(struct st_relay_log_info* rli)
2316
{
2317
  DBUG_ENTER("Start_log_event_v3::exec_event");
2318
  switch (binlog_version)
2319 2320 2321 2322 2323 2324 2325 2326
  {
  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
2327
    */
2328 2329 2330 2331 2332
    if (created)
    {
      close_temporary_tables(thd);
      cleanup_load_tmpdir();
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2333 2334
    break;

2335
    /*
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2336 2337
       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
2338
    */
2339
  case 1:
2340
    if (strncmp(rli->relay_log.description_event_for_exec->server_version,
2341 2342 2343 2344 2345 2346 2347 2348
                "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
2349
    /*
2350 2351 2352
      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
2353 2354 2355 2356
    */
    break;
  default:
    /* this case is impossible */
2357
    DBUG_RETURN(1);
nick@mysql.com's avatar
nick@mysql.com committed
2358
  }
2359
  DBUG_RETURN(Log_event::exec_event(rli));
2360
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2361
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
2362

2363 2364 2365 2366 2367 2368 2369 2370 2371
/***************************************************************************
       Format_description_log_event methods
****************************************************************************/

/*
  Format_description_log_event 1st ctor.

  SYNOPSIS
    Format_description_log_event::Format_description_log_event
2372
      binlog_version              the binlog version for which we want to build
2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386
                                  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::
2387
Format_description_log_event(uint8 binlog_ver, const char* server_ver)
2388 2389 2390 2391 2392 2393 2394
  :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);
guilhem@gbichot3.local's avatar
guilhem@gbichot3.local committed
2395 2396
    DBUG_EXECUTE_IF("pretend_version_50034_in_binlog",
                    strmov(server_version, "5.0.34"););
2397 2398 2399 2400
    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),
2401
                                       MYF(MY_ZEROFILL));
2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414 2415 2416 2417 2418
    /*
      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;
2419 2420
      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;
2421 2422 2423 2424 2425 2426 2427 2428 2429 2430 2431 2432 2433 2434
    }
    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 :
2435
      LOG_EVENT_MINIMAL_HEADER_LEN;
2436 2437 2438 2439 2440 2441 2442 2443 2444
    /*
      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),
2445
                                       MYF(0));
2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467
    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;
  }
guilhem@gbichot3.local's avatar
guilhem@gbichot3.local committed
2468
  calc_server_version_split();
2469 2470 2471 2472 2473 2474 2475 2476
}


/*
  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
2477
  post-header starts.
2478 2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492
  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*
2493
                             description_event)
2494 2495 2496 2497 2498 2499 2500 2501 2502
  :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",
2503
                      common_header_len, number_of_event_types));
2504 2505 2506
  /* 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*
2507
                                      sizeof(*post_header_len), MYF(0));
guilhem@gbichot3.local's avatar
guilhem@gbichot3.local committed
2508
  calc_server_version_split();
2509 2510 2511
  DBUG_VOID_RETURN;
}

2512
#ifndef MYSQL_CLIENT
2513 2514 2515 2516 2517 2518 2519 2520 2521 2522
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);
2523
  buff[ST_COMMON_HEADER_LEN_OFFSET]= LOG_EVENT_HEADER_LEN;
2524 2525 2526 2527 2528
  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)));
}
2529
#endif
2530

2531 2532 2533
/*
  SYNOPSIS
    Format_description_log_event::exec_event()
2534

2535 2536 2537 2538 2539 2540 2541 2542 2543 2544
  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");
2545 2546

  /* save the information describing this binlog */
2547 2548 2549
  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
2550
#ifdef USING_TRANSACTIONS
2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571
  /*
    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
2572
#endif
2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592 2593 2594 2595 2596 2597 2598 2599 2600
  /*
    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
2601 2602 2603
    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.
2604 2605 2606 2607 2608
  */
  DBUG_RETURN(Start_log_event_v3::exec_event(rli));
}
#endif

guilhem@gbichot3.local's avatar
guilhem@gbichot3.local committed
2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639

/**
   Splits the event's 'server_version' string into three numeric pieces stored
   into 'server_version_split':
   X.Y.Zabc (X,Y,Z numbers, a not a digit) -> {X,Y,Z}
   X.Yabc -> {X,Y,0}
   Xabc -> {X,0,0}
   'server_version_split' is then used for lookups to find if the server which
   created this event has some known bug.
*/
void Format_description_log_event::calc_server_version_split()
{
  char *p= server_version, *r;
  ulong number;
  for (uint i= 0; i<=2; i++)
  {
    number= strtoul(p, &r, 10);
    server_version_split[i]= (uchar)number;
    DBUG_ASSERT(number < 256); // fit in uchar
    p= r;
    DBUG_ASSERT(!((i == 0) && (*r != '.'))); // should be true in practice
    if (*r == '.')
      p++; // skip the dot
  }
  DBUG_PRINT("info",("Format_description_log_event::server_version_split:"
                     " '%s' %d %d %d", server_version,
                     server_version_split[0],
                     server_version_split[1], server_version_split[2]));
}


2640
  /**************************************************************************
2641
        Load_log_event methods
2642
   General note about Load_log_event: the binlogging of LOAD DATA INFILE is
2643
   going to be changed in 5.0 (or maybe in 5.1; not decided yet).
2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655
   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).
  **************************************************************************/
2656

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2657
/*
2658
  Load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2659
*/
2660

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2661
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
2662
uint Load_log_event::get_query_buffer_length()
2663
{
2664
  return
2665 2666
    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
2667
    7 +					    // LOCAL
2668
    9 +                                     // " REPLACE or IGNORE "
2669
    13 + table_name_len*2 +                 // "INTO TABLE `table`"
2670 2671 2672 2673
    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'"
2674 2675
    19 + sql_ex.line_start_len*4 + 2 +      // " LINES STARTING BY 'str'"
    15 + 22 +                               // " IGNORE xxx  LINES"
2676
    3 + (num_fields-1)*2 + field_block_len; // " (field1, field2, ...)"
2677
}
2678

2679 2680 2681 2682 2683 2684 2685

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)
2686
  {
2687 2688
    pos= strmov(pos, "use `");
    memcpy(pos, db, db_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2689
    pos= strmov(pos+db_len, "`; ");
2690
  }
2691

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2692
  pos= strmov(pos, "LOAD DATA ");
2693 2694 2695 2696

  if (fn_start)
    *fn_start= pos;

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2697 2698 2699
  if (check_fname_outside_temp_buf())
    pos= strmov(pos, "LOCAL ");
  pos= strmov(pos, "INFILE '");
2700
  memcpy(pos, fname, fname_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2701
  pos= strmov(pos+fname_len, "' ");
2702

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2703
  if (sql_ex.opt_flags & REPLACE_FLAG)
2704
    pos= strmov(pos, " REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2705
  else if (sql_ex.opt_flags & IGNORE_FLAG)
2706 2707
    pos= strmov(pos, " IGNORE ");

2708 2709 2710 2711 2712 2713
  pos= strmov(pos ,"INTO");

  if (fn_end)
    *fn_end= pos;

  pos= strmov(pos ," TABLE `");
2714 2715 2716
  memcpy(pos, table_name, table_name_len);
  pos+= table_name_len;

monty@mysql.com's avatar
monty@mysql.com committed
2717
  /* We have to create all optinal fields as the default is not empty */
2718
  pos= strmov(pos, "` FIELDS TERMINATED BY ");
monty@mysql.com's avatar
monty@mysql.com committed
2719 2720 2721 2722 2723
  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);
2724

monty@mysql.com's avatar
monty@mysql.com committed
2725 2726
  pos= strmov(pos, " ESCAPED BY ");
  pos= pretty_print_str(pos, sql_ex.escaped, sql_ex.escaped_len);
2727

monty@mysql.com's avatar
monty@mysql.com committed
2728 2729
  pos= strmov(pos, " LINES TERMINATED BY ");
  pos= pretty_print_str(pos, sql_ex.line_term, sql_ex.line_term_len);
2730 2731
  if (sql_ex.line_start_len)
  {
2732
    pos= strmov(pos, " STARTING BY ");
2733
    pos= pretty_print_str(pos, sql_ex.line_start, sql_ex.line_start_len);
2734
  }
2735

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2736
  if ((long) skip_lines > 0)
2737 2738
  {
    pos= strmov(pos, " IGNORE ");
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2739
    pos= longlong10_to_str((longlong) skip_lines, pos, 10);
2740 2741
    pos= strmov(pos," LINES ");    
  }
2742 2743 2744 2745

  if (num_fields)
  {
    uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2746
    const char *field= fields;
2747
    pos= strmov(pos, " (");
2748 2749 2750
    for (i = 0; i < num_fields; i++)
    {
      if (i)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2751 2752 2753 2754
      {
        *pos++= ' ';
        *pos++= ',';
      }
2755
      memcpy(pos, field, field_lens[i]);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2756 2757
      pos+=   field_lens[i];
      field+= field_lens[i]  + 1;
2758
    }
2759
    *pos++= ')';
2760
  }
2761

2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773
  *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
2774
  my_free(buf, MYF(0));
2775
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2776
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
2777

2778

2779 2780
#ifndef MYSQL_CLIENT

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

2785
bool Load_log_event::write_data_header(IO_CACHE* file)
2786
{
2787
  char buf[LOAD_HEADER_LEN];
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2788
  int4store(buf + L_THREAD_ID_OFFSET, slave_proxy_id);
2789 2790 2791 2792 2793
  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);
2794
  return my_b_safe_write(file, (byte*)buf, LOAD_HEADER_LEN) != 0;
2795
}
2796

2797

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2798
/*
2799
  Load_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2800
*/
2801

2802
bool Load_log_event::write_data_body(IO_CACHE* file)
2803
{
2804 2805 2806
  if (sql_ex.write_data(file))
    return 1;
  if (num_fields && fields && field_lens)
2807
  {
2808 2809 2810
    if (my_b_safe_write(file, (byte*)field_lens, num_fields) ||
	my_b_safe_write(file, (byte*)fields, field_block_len))
      return 1;
2811
  }
2812 2813 2814
  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));
2815 2816
}

2817

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2818
/*
2819
  Load_log_event::Load_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2820
*/
2821

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2822 2823 2824
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,
2825
			       enum enum_duplicates handle_dup,
2826
			       bool ignore, bool using_trans)
2827 2828 2829 2830
  :Log_event(thd_arg,
             (thd_arg->tmp_table_used || thd_arg->thread_specific_used) ?
               LOG_EVENT_THREAD_SPECIFIC_F : 0,
             using_trans),
2831
   thread_id(thd_arg->thread_id),
2832
   slave_proxy_id(thd_arg->variables.pseudo_thread_id),
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2833 2834
   num_fields(0),fields(0),
   field_lens(0),field_block_len(0),
2835
   table_name(table_name_arg ? table_name_arg : ""),
2836
   db(db_arg), fname(ex->file_name), local_fname(FALSE)
2837 2838 2839
{
  time_t end_time;
  time(&end_time);
2840
  exec_time = (ulong) (end_time  - thd_arg->start_time);
2841 2842 2843
  /* db can never be a zero pointer in 4.0 */
  db_len = (uint32) strlen(db);
  table_name_len = (uint32) strlen(table_name);
2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856
  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;
2857
    
2858
  if (ex->dumpfile)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2859
    sql_ex.opt_flags|= DUMPFILE_FLAG;
2860
  if (ex->opt_enclosed)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2861
    sql_ex.opt_flags|= OPT_ENCLOSED_FLAG;
2862

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2863
  sql_ex.empty_flags= 0;
2864

2865
  switch (handle_dup) {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2866
  case DUP_REPLACE:
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2867
    sql_ex.opt_flags|= REPLACE_FLAG;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2868 2869 2870 2871
    break;
  case DUP_UPDATE:				// Impossible here
  case DUP_ERROR:
    break;	
2872
  }
2873 2874
  if (ignore)
    sql_ex.opt_flags|= IGNORE_FLAG;
2875

2876 2877 2878 2879 2880 2881 2882 2883 2884 2885
  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;
2886
    
2887
  skip_lines = ex->skip_lines;
2888

2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899
  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);
2900 2901
  }

2902 2903 2904
  field_lens = (const uchar*)field_lens_buf.ptr();
  fields = fields_buf.ptr();
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2905
#endif /* !MYSQL_CLIENT */
2906

2907

2908
/*
2909
  Load_log_event::Load_log_event()
2910

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2911 2912 2913
  NOTE
    The caller must do buf[event_len] = 0 before he starts using the
    constructed event.
2914 2915
*/

2916 2917 2918 2919
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
2920
   table_name(0), db(0), fname(0), local_fname(FALSE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2921
{
monty@mysql.com's avatar
monty@mysql.com committed
2922
  DBUG_ENTER("Load_log_event");
2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934
  /*
    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
2935
  DBUG_VOID_RETURN;
2936 2937
}

2938

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2939
/*
2940
  Load_log_event::copy_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2941
*/
2942

2943
int Load_log_event::copy_log_event(const char *buf, ulong event_len,
2944 2945
                                   int body_offset,
                                   const Format_description_log_event *description_event)
2946
{
2947
  DBUG_ENTER("Load_log_event::copy_log_event");
2948
  uint data_len;
2949
  char* buf_end = (char*)buf + event_len;
2950 2951
  /* 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
2952
  slave_proxy_id= thread_id= uint4korr(data_head + L_THREAD_ID_OFFSET);
2953 2954 2955 2956 2957
  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
2958
	  
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2959
  if ((int) event_len < body_offset)
monty@mysql.com's avatar
monty@mysql.com committed
2960
    DBUG_RETURN(1);
2961 2962 2963 2964
  /*
    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.
  */
2965 2966 2967
  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
2968
    DBUG_RETURN(1);
2969
  
2970
  data_len = event_len - body_offset;
2971
  if (num_fields > data_len) // simple sanity check against corruption
monty@mysql.com's avatar
monty@mysql.com committed
2972
    DBUG_RETURN(1);
2973
  for (uint i = 0; i < num_fields; i++)
2974
    field_block_len += (uint)field_lens[i] + 1;
2975

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2976 2977 2978 2979
  fields = (char*)field_lens + num_fields;
  table_name  = fields + field_block_len;
  db = table_name + table_name_len + 1;
  fname = db + db_len + 1;
2980 2981
  fname_len = strlen(fname);
  // null termination is accomplished by the caller doing buf[event_len]=0
2982

monty@mysql.com's avatar
monty@mysql.com committed
2983
  DBUG_RETURN(0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2984 2985 2986
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2987
/*
2988
  Load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2989
*/
2990 2991

#ifdef MYSQL_CLIENT
2992
void Load_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
2993
{
2994
  print(file, print_event_info, 0);
2995 2996
}

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

2998
void Load_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info,
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
2999
			   bool commented)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3000
{
monty@mysql.com's avatar
monty@mysql.com committed
3001
  DBUG_ENTER("Load_log_event::print");
3002
  if (!print_event_info->short_form)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3003
  {
3004
    print_header(file, print_event_info);
3005
    fprintf(file, "\tQuery\tthread_id=%ld\texec_time=%ld\n",
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3006 3007 3008
	    thread_id, exec_time);
  }

3009
  bool different_db= 1;
3010
  if (db)
3011
  {
3012 3013 3014 3015 3016 3017
    /*
      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.
    */
3018
    if ((different_db= memcmp(print_event_info->db, db, db_len + 1)) &&
3019
        !commented)
3020
      memcpy(print_event_info->db, db, db_len + 1);
3021
  }
3022
  
3023
  if (db && db[0] && different_db)
3024
    fprintf(file, "%suse %s%s\n", 
3025
            commented ? "# " : "",
3026
            db, print_event_info->delimiter);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3027

3028
  if (flags & LOG_EVENT_THREAD_SPECIFIC_F)
3029 3030 3031
    fprintf(file,"%sSET @@session.pseudo_thread_id=%lu%s\n",
            commented ? "# " : "", (ulong)thread_id,
            print_event_info->delimiter);
3032 3033
  fprintf(file, "%sLOAD DATA ",
          commented ? "# " : "");
3034 3035
  if (check_fname_outside_temp_buf())
    fprintf(file, "LOCAL ");
3036
  fprintf(file, "INFILE '%-*s' ", fname_len, fname);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3037

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3038
  if (sql_ex.opt_flags & REPLACE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3039
    fprintf(file," REPLACE ");
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3040
  else if (sql_ex.opt_flags & IGNORE_FLAG)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3041 3042
    fprintf(file," IGNORE ");
  
3043
  fprintf(file, "INTO TABLE `%s`", table_name);
monty@mysql.com's avatar
monty@mysql.com committed
3044 3045
  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
3046

monty@mysql.com's avatar
monty@mysql.com committed
3047 3048 3049 3050
  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
3051
     
monty@mysql.com's avatar
monty@mysql.com committed
3052 3053
  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
3054
     
monty@mysql.com's avatar
monty@mysql.com committed
3055 3056 3057
  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
3058

3059
  if (sql_ex.line_start)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3060
  {
3061
    fprintf(file," STARTING BY ");
3062
    pretty_print_str(file, sql_ex.line_start, sql_ex.line_start_len);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3063
  }
3064 3065
  if ((long) skip_lines > 0)
    fprintf(file, " IGNORE %ld LINES", (long) skip_lines);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3066

3067 3068 3069 3070
  if (num_fields)
  {
    uint i;
    const char* field = fields;
3071 3072
    fprintf(file, " (");
    for (i = 0; i < num_fields; i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3073
    {
3074
      if (i)
3075 3076
	fputc(',', file);
      fprintf(file, field);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3077
	  
3078
      field += field_lens[i]  + 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3079
    }
3080 3081
    fputc(')', file);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3082

3083
  fprintf(file, "%s\n", print_event_info->delimiter);
monty@mysql.com's avatar
monty@mysql.com committed
3084
  DBUG_VOID_RETURN;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3085
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3086
#endif /* MYSQL_CLIENT */
3087

3088

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3089
/*
3090
  Load_log_event::set_fields()
lars@mysql.com's avatar
lars@mysql.com committed
3091 3092 3093 3094 3095

  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
3096
*/
3097

3098
#ifndef MYSQL_CLIENT
lars@mysql.com's avatar
lars@mysql.com committed
3099
void Load_log_event::set_fields(const char* affected_db, 
3100 3101
				List<Item> &field_list,
                                Name_resolution_context *context)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3102 3103
{
  uint i;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3104
  const char* field = fields;
3105
  for (i= 0; i < num_fields; i++)
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3106
  {
3107 3108
    field_list.push_back(new Item_field(context,
                                        affected_db, table_name, field));
3109
    field+= field_lens[i]  + 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3110
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3111
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3112
#endif /* !MYSQL_CLIENT */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3113 3114


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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132
  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.
3133

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3134 3135 3136 3137 3138 3139 3140
  DESCRIPTION
    Does the data loading job when executing a LOAD DATA on the slave
 
  RETURN VALUE
    0           Success                                                 
    1    	Failure
*/
3141

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3142 3143
int Load_log_event::exec_event(NET* net, struct st_relay_log_info* rli, 
			       bool use_rli_only_for_errors)
3144
{
3145 3146
  const char *new_db= rewrite_db(db);
  thd->set_db(new_db, strlen(new_db));
3147
  DBUG_ASSERT(thd->query == 0);
monty@mysql.com's avatar
monty@mysql.com committed
3148
  thd->query_length= 0;                         // Should not be needed
monty@mysql.com's avatar
monty@mysql.com committed
3149
  thd->query_error= 0;
monty@mysql.com's avatar
monty@mysql.com committed
3150
  clear_all_errors(thd, rli);
3151
  /*
3152
    Usually lex_start() is called by mysql_parse(), but we need it here
3153 3154
    as the present method does not call mysql_parse().
  */
3155 3156 3157
  lex_start(thd);
  mysql_reset_thd_for_next_command(thd);

monty@mysql.com's avatar
monty@mysql.com committed
3158
  if (!use_rli_only_for_errors)
3159
  {
3160
    /* Saved for InnoDB, see comment in Query_log_event::exec_event() */
monty@mysql.com's avatar
monty@mysql.com committed
3161
    rli->future_group_master_log_pos= log_pos;
3162
    DBUG_PRINT("info", ("log_pos: %lu", (ulong) log_pos));
3163
  }
3164 3165
 
   /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3166 3167 3168 3169 3170 3171 3172 3173 3174 3175
    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
3176 3177 3178 3179 3180 3181 3182 3183 3184 3185


    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
3186
  */
3187
  if (db_ok(thd->db, replicate_do_db, replicate_ignore_db))
3188
  {
3189 3190
    thd->set_time((time_t)when);
    VOID(pthread_mutex_lock(&LOCK_thread_count));
3191
    thd->query_id = next_query_id();
3192
    VOID(pthread_mutex_unlock(&LOCK_thread_count));
3193 3194 3195 3196 3197 3198
    /*
      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
3199
    mysql_reset_errors(thd, 0);
3200 3201 3202

    TABLE_LIST tables;
    bzero((char*) &tables,sizeof(tables));
3203
    tables.db= thd->strmake(thd->db, thd->db_length);
3204
    tables.alias = tables.table_name = (char*) table_name;
3205
    tables.lock_type = TL_WRITE;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3206
    tables.updating= 1;
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3207

3208 3209 3210 3211 3212 3213 3214 3215 3216 3217
    // 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];
3218
      char *end;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3219
      enum enum_duplicates handle_dup;
3220
      bool ignore= 0;
3221 3222
      char *load_data_query;

3223
      /*
3224 3225
        Forge LOAD DATA INFILE query which will be used in SHOW PROCESS LIST
        and written to slave's binlog if binlogging is on.
3226
      */
3227
      if (!(load_data_query= (char *)thd->alloc(get_query_buffer_length() + 1)))
3228
      {
3229 3230 3231 3232 3233
        /*
          This will set thd->fatal_error in case of OOM. So we surely will notice
          that something is wrong.
        */
        goto error;
3234
      }
3235 3236 3237 3238 3239 3240 3241

      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
3242
      if (sql_ex.opt_flags & REPLACE_FLAG)
3243
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3244
	handle_dup= DUP_REPLACE;
3245
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3246
      else if (sql_ex.opt_flags & IGNORE_FLAG)
3247 3248 3249 3250
      {
        ignore= 1;
        handle_dup= DUP_ERROR;
      }
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3251
      else
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3252
      {
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3253
        /*
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3254
	  When replication is running fine, if it was DUP_ERROR on the
3255
          master then we could choose IGNORE here, because if DUP_ERROR
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3256
          suceeded on master, and data is identical on the master and slave,
3257
          then there should be no uniqueness errors on slave, so IGNORE is
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3258
          the same as DUP_ERROR. But in the unlikely case of uniqueness errors
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3259 3260 3261
          (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
3262 3263

          If reading from net (a 3.23 master), mysql_load() will change this
3264
          to IGNORE.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3265 3266
        */
        handle_dup= DUP_ERROR;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3267
      }
3268 3269 3270 3271 3272 3273 3274 3275 3276 3277
      /*
        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
3278

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3279
      sql_exchange ex((char*)fname, sql_ex.opt_flags & DUMPFILE_FLAG);
3280 3281 3282 3283 3284
      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
3285 3286 3287 3288 3289
      ex.field_term= &field_term;
      ex.enclosed= &enclosed;
      ex.line_term= &line_term;
      ex.line_start= &line_start;
      ex.escaped= &escaped;
3290 3291 3292 3293 3294 3295

      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
3296
      List<Item> field_list;
3297 3298
      thd->lex->select_lex.context.resolve_in_table_list_only(&tables);
      set_fields(tables.db, field_list, &thd->lex->select_lex.context);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3299
      thd->variables.pseudo_thread_id= thread_id;
3300 3301 3302 3303 3304 3305 3306 3307 3308
      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;
      }
3309
      /*
3310
        It is safe to use tmp_list twice because we are not going to
3311 3312
        update it inside mysql_load().
      */
3313 3314
      List<Item> tmp_list;
      if (mysql_load(thd, &ex, &tables, field_list, tmp_list, tmp_list,
3315
                     handle_dup, ignore, net != 0))
3316
        thd->query_error= 1;
3317
      if (thd->cuted_fields)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3318
      {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3319
	/* log_pos is the position of the LOAD event in the master log */
lars@mysql.com's avatar
lars@mysql.com committed
3320 3321 3322 3323 3324 3325 3326
        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
3327
      }
3328 3329 3330
      if (net)
        net->pkt_nr= thd->net.pkt_nr;
    }
3331 3332
  }
  else
3333 3334 3335 3336 3337 3338 3339 3340 3341
  {
    /*
      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);
  }
3342 3343

error:
3344
  thd->net.vio = 0; 
3345
  const char *remember_db= thd->db;
3346
  VOID(pthread_mutex_lock(&LOCK_thread_count));
3347
  thd->catalog= 0;
3348
  thd->set_db(NULL, 0);                   /* will free the current database */
3349
  thd->query= 0;
3350
  thd->query_length= 0;
3351
  VOID(pthread_mutex_unlock(&LOCK_thread_count));
3352 3353 3354
  close_thread_tables(thd);
  if (thd->query_error)
  {
3355
    /* this err/sql_errno code is copy-paste from net_send_error() */
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3356 3357 3358 3359 3360 3361 3362 3363 3364
    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
3365
    slave_print_error(rli,sql_errno,"\
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3366
Error '%s' running LOAD DATA INFILE on table '%s'. Default database: '%s'",
3367
		      err, (char*)table_name, print_slave_db_safe(remember_db));
3368
    free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
3369 3370
    return 1;
  }
3371
  free_root(thd->mem_root,MYF(MY_KEEP_PREALLOC));
3372
	    
3373
  if (thd->is_fatal_error)
3374
  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3375 3376
    slave_print_error(rli,ER_UNKNOWN_ERROR, "\
Fatal error running LOAD DATA INFILE on table '%s'. Default database: '%s'",
3377
		      (char*)table_name, print_slave_db_safe(remember_db));
3378 3379 3380
    return 1;
  }

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3381
  return ( use_rli_only_for_errors ? 0 : Log_event::exec_event(rli) ); 
3382
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3383
#endif
3384 3385


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3386
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3387
  Rotate_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3388
**************************************************************************/
3389

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3390
/*
3391
  Rotate_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3392
*/
3393

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3394
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3395
void Rotate_log_event::pack_info(Protocol *protocol)
3396
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3397
  char buf1[256], buf[22];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3398
  String tmp(buf1, sizeof(buf1), log_cs);
3399
  tmp.length(0);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3400
  tmp.append(new_log_ident, ident_len);
3401
  tmp.append(STRING_WITH_LEN(";pos="));
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3402 3403
  tmp.append(llstr(pos,buf));
  protocol->store(tmp.ptr(), tmp.length(), &my_charset_bin);
3404
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3405
#endif
3406

3407

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3408
/*
3409
  Rotate_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3410
*/
3411 3412

#ifdef MYSQL_CLIENT
3413
void Rotate_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
3414
{
3415
  char buf[22];
3416

3417
  if (print_event_info->short_form)
3418
    return;
3419
  print_header(file, print_event_info);
3420 3421 3422
  fprintf(file, "\tRotate to ");
  if (new_log_ident)
    my_fwrite(file, (byte*) new_log_ident, (uint)ident_len, 
3423
              MYF(MY_NABP | MY_WME));
3424
  fprintf(file, "  pos: %s", llstr(pos, buf));
3425
  fputc('\n', file);
3426
  fflush(file);
3427
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3428
#endif /* MYSQL_CLIENT */
3429 3430


3431

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3432
/*
3433
  Rotate_log_event::Rotate_log_event() (2 constructors)
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3434
*/
3435

3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447 3448

#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*,...)");
3449 3450
  DBUG_PRINT("enter",("new_log_ident: %s  pos: %s  flags: %lu", new_log_ident_arg,
                      llstr(pos_arg, buff), (ulong) flags));
3451 3452
#endif
  if (flags & DUP_NAME)
3453
    new_log_ident= my_strdup_with_length(new_log_ident_arg,
3454
                                         ident_len, MYF(MY_WME));
3455 3456 3457 3458 3459
  DBUG_VOID_RETURN;
}
#endif


3460 3461
Rotate_log_event::Rotate_log_event(const char* buf, uint event_len,
                                   const Format_description_log_event* description_event)
3462
  :Log_event(buf, description_event) ,new_log_ident(0), flags(DUP_NAME)
3463
{
3464
  DBUG_ENTER("Rotate_log_event::Rotate_log_event(char*,...)");
3465
  // The caller will ensure that event_len is what we have at EVENT_LEN_OFFSET
3466 3467
  uint8 header_size= description_event->common_header_len;
  uint8 post_header_len= description_event->post_header_len[ROTATE_EVENT-1];
3468 3469
  uint ident_offset;
  if (event_len < header_size)
monty@mysql.com's avatar
monty@mysql.com committed
3470
    DBUG_VOID_RETURN;
3471
  buf += header_size;
3472 3473 3474 3475
  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; 
3476
  set_if_smaller(ident_len,FN_REFLEN-1);
3477
  new_log_ident= my_strdup_with_length(buf + ident_offset,
3478 3479
                                       (uint) ident_len,
                                       MYF(MY_WME));
monty@mysql.com's avatar
monty@mysql.com committed
3480
  DBUG_VOID_RETURN;
3481
}
3482 3483


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3484
/*
3485
  Rotate_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3486
*/
3487

3488
#ifndef MYSQL_CLIENT
3489
bool Rotate_log_event::write(IO_CACHE* file)
3490
{
3491
  char buf[ROTATE_HEADER_LEN];
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3492
  int8store(buf + R_POS_OFFSET, pos);
3493 3494 3495
  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));
3496
}
3497
#endif
3498

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3499
/*
3500 3501
  Rotate_log_event::exec_event()

3502
  Got a rotate log event from the master
3503

3504 3505 3506
  IMPLEMENTATION
    This is mainly used so that we can later figure out the logname and
    position for the master.
3507

3508
    We can't rotate the slave's BINlog as this will cause infinitive rotations
3509
    in a A -> B -> A setup.
3510
    The NOTES below is a wrong comment which will disappear when 4.1 is merged.
3511 3512 3513

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3516
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3517
int Rotate_log_event::exec_event(struct st_relay_log_info* rli)
3518
{
3519 3520 3521
  DBUG_ENTER("Rotate_log_event::exec_event");

  pthread_mutex_lock(&rli->data_lock);
3522
  rli->event_relay_log_pos= my_b_tell(rli->cur_log);
guilhem@gbichot2's avatar
guilhem@gbichot2 committed
3523 3524 3525 3526 3527 3528 3529 3530 3531
  /*
    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
3532 3533
    In that case, we don't want to touch the coordinates which correspond to
    the beginning of the transaction.
3534 3535
    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
3536
  */
3537
  if (!(thd->options & OPTION_BEGIN))
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3538
  {
3539 3540
    memcpy(rli->group_master_log_name, new_log_ident, ident_len+1);
    rli->notify_group_master_log_name_update();
3541
    rli->group_master_log_pos= pos;
3542 3543
    strmake(rli->group_relay_log_name, rli->event_relay_log_name,
            sizeof(rli->group_relay_log_name) - 1);
3544 3545 3546 3547
    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,
3548
                        (ulong) rli->group_master_log_pos));
3549
    /*
3550 3551
      Reset thd->options and sql_mode etc, because this could be the signal of
      a master's downgrade from 5.0 to 4.0.
3552 3553 3554 3555 3556
      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);
3557
    set_slave_thread_default_charset(thd, rli);
3558
    thd->variables.sql_mode= global_system_variables.sql_mode;
3559 3560
    thd->variables.auto_increment_increment=
      thd->variables.auto_increment_offset= 1;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3561
  }
3562 3563 3564 3565
  pthread_mutex_unlock(&rli->data_lock);
  pthread_cond_broadcast(&rli->data_cond);
  flush_relay_log_info(rli);
  DBUG_RETURN(0);
3566
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3567
#endif
3568 3569


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3570
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3571
	Intvar_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3572
**************************************************************************/
3573

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3574
/*
3575
  Intvar_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3576
*/
3577

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3578
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3579
void Intvar_log_event::pack_info(Protocol *protocol)
3580
{
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3581 3582
  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
3583
  *pos++= '=';
3584
  pos= longlong10_to_str(val, pos, -10);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3585
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
3586
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3587
#endif
3588

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3590
/*
3591
  Intvar_log_event::Intvar_log_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3592
*/
3593

3594 3595 3596
Intvar_log_event::Intvar_log_event(const char* buf,
                                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3597
{
3598 3599 3600
  buf+= description_event->common_header_len;
  type= buf[I_TYPE_OFFSET];
  val= uint8korr(buf+I_VAL_OFFSET);
3601 3602
}

3603

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3604
/*
3605
  Intvar_log_event::get_var_type_name()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3606
*/
3607 3608

const char* Intvar_log_event::get_var_type_name()
3609
{
3610 3611 3612 3613 3614
  switch(type) {
  case LAST_INSERT_ID_EVENT: return "LAST_INSERT_ID";
  case INSERT_ID_EVENT: return "INSERT_ID";
  default: /* impossible */ return "UNKNOWN";
  }
3615 3616
}

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

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3618
/*
3619
  Intvar_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3620
*/
3621

3622
#ifndef MYSQL_CLIENT
3623
bool Intvar_log_event::write(IO_CACHE* file)
3624
{
3625 3626
  byte buf[9];
  buf[I_TYPE_OFFSET]= (byte) type;
3627
  int8store(buf + I_VAL_OFFSET, val);
3628 3629
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
3630
}
3631
#endif
3632

3633

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3634
/*
3635
  Intvar_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3636
*/
3637 3638

#ifdef MYSQL_CLIENT
3639
void Intvar_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
3640
{
3641 3642 3643
  char llbuff[22];
  const char *msg;
  LINT_INIT(msg);
3644

3645
  if (!print_event_info->short_form)
3646
  {
3647
    print_header(file, print_event_info);
3648 3649
    fprintf(file, "\tIntvar\n");
  }
3650

3651 3652 3653 3654 3655 3656 3657 3658
  fprintf(file, "SET ");
  switch (type) {
  case LAST_INSERT_ID_EVENT:
    msg="LAST_INSERT_ID";
    break;
  case INSERT_ID_EVENT:
    msg="INSERT_ID";
    break;
3659 3660 3661 3662
  case INVALID_INT_EVENT:
  default: // cannot happen
    msg="INVALID_INT";
    break;
3663
  }
3664 3665
  fprintf(file, "%s=%s%s\n",
          msg, llstr(val,llbuff), print_event_info->delimiter);
3666
  fflush(file);
3667
}
3668
#endif
3669

3670

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3671
/*
3672
  Intvar_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3673
*/
3674

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3675
#if defined(HAVE_REPLICATION)&& !defined(MYSQL_CLIENT)
3676
int Intvar_log_event::exec_event(struct st_relay_log_info* rli)
3677
{
3678 3679 3680 3681 3682 3683 3684 3685
  switch (type) {
  case LAST_INSERT_ID_EVENT:
    thd->last_insert_id = val;
    break;
  case INSERT_ID_EVENT:
    thd->next_insert_id = val;
    break;
  }
3686
  rli->inc_event_relay_log_pos();
3687
  return 0;
3688
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3689
#endif
3690

3691

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3692
/**************************************************************************
3693
  Rand_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3694
**************************************************************************/
3695

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3696
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3697
void Rand_log_event::pack_info(Protocol *protocol)
3698
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3699 3700 3701 3702 3703
  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);
3704
  protocol->store(buf1, (uint) (pos-buf1), &my_charset_bin);
3705
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3706
#endif
3707 3708


3709 3710 3711
Rand_log_event::Rand_log_event(const char* buf,
                               const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3712
{
3713 3714 3715
  buf+= description_event->common_header_len;
  seed1= uint8korr(buf+RAND_SEED1_OFFSET);
  seed2= uint8korr(buf+RAND_SEED2_OFFSET);
3716 3717
}

3718

3719
#ifndef MYSQL_CLIENT
3720
bool Rand_log_event::write(IO_CACHE* file)
3721
{
3722
  byte buf[16];
3723 3724
  int8store(buf + RAND_SEED1_OFFSET, seed1);
  int8store(buf + RAND_SEED2_OFFSET, seed2);
3725 3726
  return (write_header(file, sizeof(buf)) ||
          my_b_safe_write(file, buf, sizeof(buf)));
3727
}
3728
#endif
3729

3730 3731

#ifdef MYSQL_CLIENT
3732
void Rand_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
3733
{
3734
  char llbuff[22],llbuff2[22];
3735
  if (!print_event_info->short_form)
3736
  {
3737
    print_header(file, print_event_info);
3738
    fprintf(file, "\tRand\n");
3739
  }
3740 3741 3742
  fprintf(file, "SET @@RAND_SEED1=%s, @@RAND_SEED2=%s%s\n",
	  llstr(seed1, llbuff),llstr(seed2, llbuff2),
          print_event_info->delimiter);
3743
  fflush(file);
3744
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3745
#endif /* MYSQL_CLIENT */
3746

3747

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
3748
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3749
int Rand_log_event::exec_event(struct st_relay_log_info* rli)
3750
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3751 3752
  thd->rand.seed1= (ulong) seed1;
  thd->rand.seed2= (ulong) seed2;
3753
  rli->inc_event_relay_log_pos();
3754 3755
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3756
#endif /* !MYSQL_CLIENT */
3757

3758

3759 3760 3761 3762 3763 3764 3765
/**************************************************************************
  Xid_log_event methods
**************************************************************************/

#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
void Xid_log_event::pack_info(Protocol *protocol)
{
3766 3767
  char buf[128], *pos;
  pos= strmov(buf, "COMMIT /* xid=");
3768
  pos= longlong10_to_str(xid, pos, 10);
3769
  pos= strmov(pos, " */");
3770 3771 3772 3773
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
}
#endif

3774 3775 3776 3777 3778 3779 3780 3781
/*
  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
*/
3782 3783 3784 3785

Xid_log_event::
Xid_log_event(const char* buf,
              const Format_description_log_event *description_event)
3786 3787 3788
  :Log_event(buf, description_event)
{
  buf+= description_event->common_header_len;
3789
  memcpy((char*) &xid, buf, sizeof(xid));
3790 3791 3792
}


3793
#ifndef MYSQL_CLIENT
3794 3795 3796 3797 3798
bool Xid_log_event::write(IO_CACHE* file)
{
  return write_header(file, sizeof(xid)) ||
         my_b_safe_write(file, (byte*) &xid, sizeof(xid));
}
3799
#endif
3800 3801 3802


#ifdef MYSQL_CLIENT
3803
void Xid_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
3804
{
3805
  if (!print_event_info->short_form)
3806
  {
3807 3808 3809
    char buf[64];
    longlong10_to_str(xid, buf, 10);

3810
    print_header(file, print_event_info);
3811 3812
    fprintf(file, "\tXid = %s\n", buf);
    fflush(file);
3813
  }
3814
  fprintf(file, "COMMIT%s\n", print_event_info->delimiter);
3815 3816 3817 3818 3819 3820 3821
}
#endif /* MYSQL_CLIENT */


#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
int Xid_log_event::exec_event(struct st_relay_log_info* rli)
{
3822
  /* For a slave Xid_log_event is COMMIT */
3823
  mysql_log.write(thd,COM_QUERY,"COMMIT /* implicit, from Xid_log_event */");
3824
  return end_trans(thd, COMMIT) || Log_event::exec_event(rli);
3825 3826 3827 3828
}
#endif /* !MYSQL_CLIENT */


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3829
/**************************************************************************
3830
  User_var_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3831
**************************************************************************/
3832

3833
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
3834 3835 3836
void User_var_log_event::pack_info(Protocol* protocol)
{
  char *buf= 0;
3837
  uint val_offset= 4 + name_len;
3838 3839 3840 3841 3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852
  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));
3853 3854
      event_len+= my_sprintf(buf + val_offset,
			     (buf + val_offset, "%.14g", real_val));
3855 3856 3857 3858 3859
      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;
3860 3861 3862 3863 3864 3865 3866 3867 3868 3869
    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;
    } 
3870
    case STRING_RESULT:
3871 3872 3873 3874 3875 3876 3877 3878 3879 3880
      /* 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
      {
3881 3882 3883
        char *p= strxmov(buf + val_offset, "_", cs->csname, " ", NullS);
        p= str_to_hex(p, val, val_len);
        p= strxmov(p, " COLLATE ", cs->name, NullS);
3884 3885
        event_len= p-buf;
      }
3886
      break;
3887
    case ROW_RESULT:
3888
    default:
3889 3890 3891 3892 3893
      DBUG_ASSERT(1);
      return;
    }
  }
  buf[0]= '@';
3894 3895 3896 3897
  buf[1]= '`';
  buf[2+name_len]= '`';
  buf[3+name_len]= '=';
  memcpy(buf+2, name, name_len);
3898
  protocol->store(buf, event_len, &my_charset_bin);
3899 3900
  my_free(buf, MYF(MY_ALLOW_ZERO_PTR));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3901
#endif /* !MYSQL_CLIENT */
3902 3903


3904 3905 3906 3907
User_var_log_event::
User_var_log_event(const char* buf,
                   const Format_description_log_event* description_event)
  :Log_event(buf, description_event)
3908
{
3909
  buf+= description_event->common_header_len;
3910 3911
  name_len= uint4korr(buf);
  name= (char *) buf + UV_NAME_LEN_SIZE;
3912 3913
  buf+= UV_NAME_LEN_SIZE + name_len;
  is_null= (bool) *buf;
3914 3915 3916
  if (is_null)
  {
    type= STRING_RESULT;
3917
    charset_number= my_charset_bin.number;
3918 3919 3920 3921 3922
    val_len= 0;
    val= 0;  
  }
  else
  {
3923 3924 3925
    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 + 
3926
		       UV_CHARSET_NUMBER_SIZE);
3927 3928
    val= (char *) (buf + UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE +
		   UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE);
3929 3930 3931 3932
  }
}


3933
#ifndef MYSQL_CLIENT
3934
bool User_var_log_event::write(IO_CACHE* file)
3935 3936 3937 3938
{
  char buf[UV_NAME_LEN_SIZE];
  char buf1[UV_VAL_IS_NULL + UV_VAL_TYPE_SIZE + 
	    UV_CHARSET_NUMBER_SIZE + UV_VAL_LEN_SIZE];
3939
  char buf2[max(8, DECIMAL_MAX_FIELD_SIZE + 2)], *pos= buf2;
3940
  uint buf1_length;
3941
  ulong event_length;
3942

3943
  int4store(buf, name_len);
3944 3945 3946 3947 3948 3949 3950
  
  if ((buf1[0]= is_null))
  {
    buf1_length= 1;
    val_len= 0;
  }    
  else
3951 3952 3953 3954 3955 3956 3957 3958 3959 3960 3961
  {
    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;
3962 3963 3964 3965 3966 3967
    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;
3968
      decimal2bin((decimal_t*)val, buf2+2, buf2[0], buf2[1]);
3969 3970 3971
      val_len= decimal_bin_size(buf2[0], buf2[1]) + 2;
      break;
    }
3972 3973 3974
    case STRING_RESULT:
      pos= val;
      break;
3975
    case ROW_RESULT:
3976
    default:
3977 3978 3979
      DBUG_ASSERT(1);
      return 0;
    }
3980 3981
    int4store(buf1 + 2 + UV_CHARSET_NUMBER_SIZE, val_len);
    buf1_length= 10;
3982
  }
3983 3984 3985 3986 3987 3988

  /* 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))   ||
3989 3990 3991
	  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));
3992
}
3993
#endif
3994

3995

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3996
/*
3997
  User_var_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
3998
*/
3999 4000

#ifdef MYSQL_CLIENT
4001
void User_var_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
4002
{
4003
  if (!print_event_info->short_form)
4004
  {
4005
    print_header(file, print_event_info);
4006 4007 4008
    fprintf(file, "\tUser_var\n");
  }

4009
  fprintf(file, "SET @`");
4010
  my_fwrite(file, (byte*) name, (uint) (name_len), MYF(MY_NABP | MY_WME));
4011
  fprintf(file, "`");
4012 4013 4014

  if (is_null)
  {
4015
    fprintf(file, ":=NULL%s\n", print_event_info->delimiter);
4016 4017 4018 4019 4020 4021 4022
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      double real_val;
      float8get(real_val, val);
4023
      fprintf(file, ":=%.14g%s\n", real_val, print_event_info->delimiter);
4024 4025 4026 4027
      break;
    case INT_RESULT:
      char int_buf[22];
      longlong10_to_str(uint8korr(val), int_buf, -10);
4028
      fprintf(file, ":=%s%s\n", int_buf, print_event_info->delimiter);
4029
      break;
4030 4031 4032 4033 4034 4035
    case DECIMAL_RESULT:
    {
      char str_buf[200];
      int str_len= sizeof(str_buf) - 1;
      int precision= (int)val[0];
      int scale= (int)val[1];
4036 4037
      decimal_digit_t dec_buf[10];
      decimal_t dec;
4038 4039 4040 4041 4042 4043
      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;
4044
      fprintf(file, ":=%s%s\n",str_buf, print_event_info->delimiter);
4045 4046
      break;
    }
4047
    case STRING_RESULT:
4048
    {
4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062
      /*
        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.
      */
4063 4064 4065 4066
      char *hex_str;
      CHARSET_INFO *cs;

      if (!(hex_str= (char *)my_alloca(2*val_len+1+2))) // 2 hex digits / byte
4067
        break; // no error, as we are 'void'
4068
      str_to_hex(hex_str, val, val_len);
4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079
      /*
        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.
        */
4080
        fprintf(file, ":=???%s\n", print_event_info->delimiter);
4081
      else
4082 4083
        fprintf(file, ":=_%s %s COLLATE `%s`%s\n",
                cs->csname, hex_str, cs->name, print_event_info->delimiter);
4084
      my_afree(hex_str);
4085
    }
4086
      break;
4087
    case ROW_RESULT:
4088
    default:
4089
      DBUG_ASSERT(1);
4090 4091 4092 4093 4094
      return;
    }
  }
  fflush(file);
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4095
#endif
4096

4097

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4098
/*
4099
  User_var_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4100
*/
4101

4102
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4103 4104 4105
int User_var_log_event::exec_event(struct st_relay_log_info* rli)
{
  Item *it= 0;
4106 4107 4108
  CHARSET_INFO *charset;
  if (!(charset= get_charset(charset_number, MYF(MY_WME))))
    return 1;
4109 4110 4111
  LEX_STRING user_var_name;
  user_var_name.str= name;
  user_var_name.length= name_len;
4112 4113
  double real_val;
  longlong int_val;
4114 4115 4116 4117 4118 4119 4120 4121 4122 4123

  if (is_null)
  {
    it= new Item_null();
  }
  else
  {
    switch (type) {
    case REAL_RESULT:
      float8get(real_val, val);
4124
      it= new Item_float(real_val);
4125
      val= (char*) &real_val;		// Pointer to value in native format
4126
      val_len= 8;
4127 4128
      break;
    case INT_RESULT:
4129 4130 4131
      int_val= (longlong) uint8korr(val);
      it= new Item_int(int_val);
      val= (char*) &int_val;		// Pointer to value in native format
4132
      val_len= 8;
4133
      break;
4134 4135 4136 4137 4138 4139 4140 4141
    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;
    }
4142 4143 4144
    case STRING_RESULT:
      it= new Item_string(val, val_len, charset);
      break;
4145
    case ROW_RESULT:
4146
    default:
4147 4148 4149 4150 4151
      DBUG_ASSERT(1);
      return 0;
    }
  }
  Item_func_set_user_var e(user_var_name, it);
4152 4153 4154 4155
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
4156
  e.fix_fields(thd, 0);
4157 4158 4159 4160 4161
  /*
    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.
   */
kaa@polly.local's avatar
kaa@polly.local committed
4162
  e.update_hash(val, val_len, type, charset, DERIVATION_IMPLICIT, 0);
4163
  free_root(thd->mem_root,0);
4164

4165
  rli->inc_event_relay_log_pos();
4166 4167
  return 0;
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4168
#endif /* !MYSQL_CLIENT */
4169 4170


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4171
/**************************************************************************
4172
  Slave_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4173
**************************************************************************/
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4174

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4175
#ifdef HAVE_REPLICATION
4176
#ifdef MYSQL_CLIENT
4177
void Unknown_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
4178
{
4179
  if (print_event_info->short_form)
4180
    return;
4181
  print_header(file, print_event_info);
4182 4183 4184 4185
  fputc('\n', file);
  fprintf(file, "# %s", "Unknown event\n");
}
#endif  
4186

4187
#ifndef MYSQL_CLIENT
4188
void Slave_log_event::pack_info(Protocol *protocol)
4189
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4190
  char buf[256+HOSTNAME_LENGTH], *pos;
4191 4192 4193 4194 4195 4196 4197
  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=");
4198
  pos= longlong10_to_str(master_pos, pos, 10);
4199
  protocol->store(buf, pos-buf, &my_charset_bin);
4200
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4201
#endif /* !MYSQL_CLIENT */
4202 4203 4204 4205


#ifndef MYSQL_CLIENT
Slave_log_event::Slave_log_event(THD* thd_arg,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4206
				 struct st_relay_log_info* rli)
4207
  :Log_event(thd_arg, 0, 0) , mem_pool(0), master_host(0)
4208 4209 4210 4211
{
  DBUG_ENTER("Slave_log_event");
  if (!rli->inited)				// QQ When can this happen ?
    DBUG_VOID_RETURN;
4212

4213 4214 4215 4216 4217
  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);
4218
  master_log_len = strlen(rli->group_master_log_name);
4219 4220 4221
  // 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))))
4222
  {
4223 4224 4225
    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;
4226
    memcpy(master_log, rli->group_master_log_name, master_log_len + 1);
4227
    master_port = mi->port;
4228
    master_pos = rli->group_master_log_pos;
4229
    DBUG_PRINT("info", ("master_log: %s  pos: %lu", master_log,
4230
			(ulong) master_pos));
4231
  }
4232 4233 4234 4235 4236 4237
  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
4238
#endif /* !MYSQL_CLIENT */
4239 4240 4241 4242 4243 4244 4245 4246 4247


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


#ifdef MYSQL_CLIENT
4248
void Slave_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
4249 4250
{
  char llbuff[22];
4251
  if (print_event_info->short_form)
4252
    return;
4253
  print_header(file, print_event_info);
4254
  fputc('\n', file);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4255 4256
  fprintf(file, "\
Slave: master_host: '%s'  master_port: %d  master_log: '%s'  master_pos: %s\n",
4257 4258
	  master_host, master_port, master_log, llstr(master_pos, llbuff));
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4259
#endif /* MYSQL_CLIENT */
4260 4261 4262 4263 4264 4265 4266 4267


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


4268
#ifndef MYSQL_CLIENT
4269
bool Slave_log_event::write(IO_CACHE* file)
4270
{
4271
  ulong event_length= get_data_size();
4272 4273 4274
  int8store(mem_pool + SL_MASTER_POS_OFFSET, master_pos);
  int2store(mem_pool + SL_MASTER_PORT_OFFSET, master_port);
  // log and host are already there
4275 4276 4277

  return (write_header(file, event_length) ||
          my_b_safe_write(file, (byte*) mem_pool, event_length));
4278
}
4279
#endif
4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290


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)
4291
  {
4292 4293
    master_host = 0;
    return;
4294
  }
4295 4296
  master_log_len = strlen(master_log);
}
4297

4298

4299 4300 4301
/* 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)
4302
{
4303
  if (event_len < LOG_EVENT_HEADER_LEN)
4304
    return;
4305
  event_len -= LOG_EVENT_HEADER_LEN;
4306 4307 4308 4309 4310
  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);
4311 4312
}

4313

4314 4315 4316 4317 4318 4319 4320
#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
4321
#endif /* !MYSQL_CLIENT */
4322 4323


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4324
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4325
	Stop_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4326
**************************************************************************/
4327

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4328
/*
4329
  Stop_log_event::print()
4330
*/
4331 4332

#ifdef MYSQL_CLIENT
4333
void Stop_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
4334
{
4335
  if (print_event_info->short_form)
4336 4337
    return;

4338
  print_header(file, print_event_info);
4339 4340
  fprintf(file, "\tStop\n");
  fflush(file);
4341
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4342
#endif /* MYSQL_CLIENT */
4343

4344

4345
/*
4346
  Stop_log_event::exec_event()
4347

4348
  The master stopped.
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4349
  We used to clean up all temporary tables but this is useless as, as the
4350 4351
  master has shut down properly, it has written all DROP TEMPORARY TABLE
  (prepared statements' deletion is TODO only when we binlog prep stmts).
4352 4353 4354
  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.
4355
  The place were we must do this cleaning is in Start_log_event_v3::exec_event(),
4356
  not here. Because if we come here, the master was sane.
4357 4358
*/

4359
#ifndef MYSQL_CLIENT
4360
int Stop_log_event::exec_event(struct st_relay_log_info* rli)
4361
{
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4362 4363
  /*
    We do not want to update master_log pos because we get a rotate event
4364
    before stop, so by now group_master_log_name is set to the next log.
4365
    If we updated it, we will have incorrect master coordinates and this
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4366
    could give false triggers in MASTER_POS_WAIT() that we have reached
4367
    the target position when in fact we have not.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4368
  */
4369 4370 4371 4372 4373 4374 4375
  if (thd->options & OPTION_BEGIN)
    rli->inc_event_relay_log_pos();
  else
  {
    rli->inc_group_relay_log_pos(0);
    flush_relay_log_info(rli);
  }
4376 4377
  return 0;
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4378
#endif /* !MYSQL_CLIENT */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4379
#endif /* HAVE_REPLICATION */
4380

4381

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4382
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4383
	Create_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4384
**************************************************************************/
4385 4386

/*
4387
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4388
*/
4389 4390

#ifndef MYSQL_CLIENT
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4391 4392 4393 4394
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,
4395
                      bool ignore,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4396
		      char* block_arg, uint block_len_arg, bool using_trans)
4397
  :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
4398
		  using_trans),
4399
   fake_base(0), block(block_arg), event_buf(0), block_len(block_len_arg),
4400
   file_id(thd_arg->file_id = mysql_bin_log.next_file_id())
4401
{
monty@mysql.com's avatar
monty@mysql.com committed
4402
  DBUG_ENTER("Create_file_log_event");
4403
  sql_ex.force_new_format();
monty@mysql.com's avatar
monty@mysql.com committed
4404
  DBUG_VOID_RETURN;
4405
}
4406

4407

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4408
/*
4409
  Create_file_log_event::write_data_body()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4410
*/
4411

4412
bool Create_file_log_event::write_data_body(IO_CACHE* file)
4413
{
4414 4415
  bool res;
  if ((res= Load_log_event::write_data_body(file)) || fake_base)
4416 4417
    return res;
  return (my_b_safe_write(file, (byte*) "", 1) ||
4418
          my_b_safe_write(file, (byte*) block, block_len));
4419 4420
}

4421

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4422
/*
4423
  Create_file_log_event::write_data_header()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4424
*/
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4425

4426
bool Create_file_log_event::write_data_header(IO_CACHE* file)
4427
{
4428
  bool res;
4429
  byte buf[CREATE_FILE_HEADER_LEN];
4430 4431
  if ((res= Load_log_event::write_data_header(file)) || fake_base)
    return res;
4432
  int4store(buf + CF_FILE_ID_OFFSET, file_id);
4433
  return my_b_safe_write(file, buf, CREATE_FILE_HEADER_LEN) != 0;
4434 4435 4436
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4437
/*
4438
  Create_file_log_event::write_base()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4439
*/
4440

4441
bool Create_file_log_event::write_base(IO_CACHE* file)
4442
{
4443 4444 4445 4446
  bool res;
  fake_base= 1;                                 // pretend we are Load event
  res= write(file);
  fake_base= 0;
4447 4448 4449
  return res;
}

4450
#endif /* !MYSQL_CLIENT */
4451

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4452
/*
4453
  Create_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4454
*/
4455

4456 4457 4458
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)
4459
{
4460 4461 4462 4463 4464
  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
4465
  if (!(event_buf= my_memdup((byte*) buf, len, MYF(MY_WME))) ||
4466 4467 4468 4469 4470 4471 4472
      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
4473
    DBUG_VOID_RETURN;
4474
  if (description_event->binlog_version!=1)
4475
  {
4476 4477 4478 4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491 4492
    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);
4493 4494 4495 4496 4497 4498 4499 4500 4501
    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;
4502
  }
monty@mysql.com's avatar
monty@mysql.com committed
4503
  DBUG_VOID_RETURN;
4504 4505
}

4506

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4507
/*
4508
  Create_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4509
*/
4510 4511

#ifdef MYSQL_CLIENT
4512
void Create_file_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info,
lars@mysql.com's avatar
lars@mysql.com committed
4513
				  bool enable_local)
nick@mysql.com's avatar
nick@mysql.com committed
4514
{
4515
  if (print_event_info->short_form)
4516 4517
  {
    if (enable_local && check_fname_outside_temp_buf())
4518
      Load_log_event::print(file, print_event_info);
4519
    return;
4520 4521 4522 4523
  }

  if (enable_local)
  {
4524
    Load_log_event::print(file, print_event_info,
4525
			  !check_fname_outside_temp_buf());
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4526 4527 4528 4529 4530
    /* 
       That one is for "file_id: etc" below: in mysqlbinlog we want the #, in
       SHOW BINLOG EVENTS we don't.
    */
    fprintf(file, "#"); 
4531 4532
  }

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

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

4537
void Create_file_log_event::print(FILE* file, PRINT_EVENT_INFO* print_event_info)
4538
{
4539
  print(file, print_event_info, 0);
4540
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4541
#endif /* MYSQL_CLIENT */
nick@mysql.com's avatar
nick@mysql.com committed
4542

4543

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4544
/*
4545
  Create_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4546
*/
4547

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4548
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4549
void Create_file_log_event::pack_info(Protocol *protocol)
4550
{
4551 4552 4553
  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
4554
  pos= strmov(pos + db_len, ";table=");
4555
  memcpy(pos, table_name, table_name_len);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4556
  pos= strmov(pos + table_name_len, ";file_id=");
4557 4558 4559
  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
4560
  protocol->store(buf, (uint) (pos-buf), &my_charset_bin);
4561
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4562
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4563 4564


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4565
/*
4566
  Create_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4567
*/
4568

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4569
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4570
int Create_file_log_event::exec_event(struct st_relay_log_info* rli)
4571
{
4572 4573
  char proc_info[17+FN_REFLEN+10], *fname_buf;
  char *ext;
4574 4575 4576
  int fd = -1;
  IO_CACHE file;
  int error = 1;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4577

4578
  bzero((char*)&file, sizeof(file));
4579 4580
  fname_buf= strmov(proc_info, "Making temp file ");
  ext= slave_load_file_stem(fname_buf, file_id, server_id, ".info");
4581
  thd->proc_info= proc_info;
4582 4583 4584 4585
  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 ||
4586 4587 4588
      init_io_cache(&file, fd, IO_SIZE, WRITE_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
4589 4590 4591
    slave_print_error(rli,my_errno,
                      "Error in Create_file event: could not open file '%s'",
                      fname_buf);
4592 4593 4594 4595
    goto err;
  }
  
  // a trick to avoid allocating another buffer
4596 4597
  fname= fname_buf;
  fname_len= (uint) (strmov(ext, ".data") - fname);
4598 4599
  if (write_base(&file))
  {
4600
    strmov(ext, ".info"); // to have it right in the error message
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4601
    slave_print_error(rli,my_errno,
4602 4603
		      "Error in Create_file event: could not write to file "
                      "'%s'",
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4604
		      fname_buf);
4605 4606 4607 4608 4609 4610
    goto err;
  }
  end_io_cache(&file);
  my_close(fd, MYF(0));
  
  // fname_buf now already has .data, not .info, because we did our trick
4611 4612 4613 4614
  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)
4615
  {
4616 4617 4618
    slave_print_error(rli,my_errno,
                      "Error in Create_file event: could not open file '%s'",
                      fname_buf);
4619 4620
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4621
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
4622
  {
4623 4624 4625
    slave_print_error(rli,my_errno,
                      "Error in Create_file event: write to '%s' failed",
                      fname_buf);
4626 4627
    goto err;
  }
4628 4629
  error=0;					// Everything is ok

4630 4631 4632 4633 4634
err:
  if (error)
    end_io_cache(&file);
  if (fd >= 0)
    my_close(fd, MYF(0));
4635
  thd->proc_info= 0;
4636
  return error ? 1 : Log_event::exec_event(rli);
4637
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4638
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4639

4640

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4641
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4642
	Append_block_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4643
**************************************************************************/
4644

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4645
/*
4646
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4647
*/
4648 4649

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4650 4651
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
4652 4653 4654
					       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
4655
   block_len(block_len_arg), file_id(thd_arg->file_id), db(db_arg)
4656 4657
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4658
#endif
4659 4660


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4661
/*
4662
  Append_block_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4663
*/
4664

4665 4666 4667
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)
4668
{
4669 4670 4671 4672 4673 4674
  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
4675
    DBUG_VOID_RETURN;
4676 4677 4678
  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
4679
  DBUG_VOID_RETURN;
4680 4681 4682
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4683
/*
4684
  Append_block_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4685
*/
4686

4687
#ifndef MYSQL_CLIENT
4688
bool Append_block_log_event::write(IO_CACHE* file)
4689 4690 4691
{
  byte buf[APPEND_BLOCK_HEADER_LEN];
  int4store(buf + AB_FILE_ID_OFFSET, file_id);
4692 4693
  return (write_header(file, APPEND_BLOCK_HEADER_LEN + block_len) ||
          my_b_safe_write(file, buf, APPEND_BLOCK_HEADER_LEN) ||
4694 4695
	  my_b_safe_write(file, (byte*) block, block_len));
}
4696
#endif
4697 4698


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4699
/*
4700
  Append_block_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4701
*/
4702 4703

#ifdef MYSQL_CLIENT  
lars@mysql.com's avatar
lars@mysql.com committed
4704
void Append_block_log_event::print(FILE* file,
4705
				   PRINT_EVENT_INFO* print_event_info)
4706
{
4707
  if (print_event_info->short_form)
4708
    return;
4709
  print_header(file, print_event_info);
4710
  fputc('\n', file);
4711 4712
  fprintf(file, "#%s: file_id: %d  block_len: %d\n",
	  get_type_str(), file_id, block_len);
4713
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4714
#endif /* MYSQL_CLIENT */
4715 4716


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4717
/*
4718
  Append_block_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4719
*/
4720

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4721
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4722
void Append_block_log_event::pack_info(Protocol *protocol)
4723 4724 4725 4726 4727 4728
{
  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
4729
  protocol->store(buf, length, &my_charset_bin);
4730 4731 4732
}


4733
/*
4734
  Append_block_log_event::get_create_or_append()
4735 4736
*/

4737
int Append_block_log_event::get_create_or_append() const
4738
{
4739
  return 0; /* append to the file, fail if not exists */
4740 4741
}

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4742
/*
4743
  Append_block_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4744
*/
4745

4746
int Append_block_log_event::exec_event(struct st_relay_log_info* rli)
4747
{
4748
  char proc_info[17+FN_REFLEN+10], *fname= proc_info+17;
4749
  int fd;
4750
  int error = 1;
monty@mysql.com's avatar
monty@mysql.com committed
4751
  DBUG_ENTER("Append_block_log_event::exec_event");
4752

4753 4754
  fname= strmov(proc_info, "Making temp file ");
  slave_load_file_stem(fname, file_id, server_id, ".data");
4755
  thd->proc_info= proc_info;
4756 4757 4758 4759 4760 4761 4762 4763 4764 4765 4766 4767 4768
  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;
    }
  }
4769 4770
  else if ((fd = my_open(fname, O_WRONLY | O_APPEND | O_BINARY | O_NOFOLLOW,
                         MYF(MY_WME))) < 0)
4771
  {
4772 4773 4774
    slave_print_error(rli, my_errno,
                      "Error in %s event: could not open file '%s'",
                      get_type_str(), fname);
4775 4776
    goto err;
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
4777
  if (my_write(fd, (byte*) block, block_len, MYF(MY_WME+MY_NABP)))
4778
  {
4779 4780 4781
    slave_print_error(rli, my_errno,
                      "Error in %s event: write to '%s' failed",
                      get_type_str(), fname);
4782 4783 4784
    goto err;
  }
  error=0;
4785

4786 4787 4788
err:
  if (fd >= 0)
    my_close(fd, MYF(0));
4789
  thd->proc_info= 0;
monty@mysql.com's avatar
monty@mysql.com committed
4790
  DBUG_RETURN(error ? error : Log_event::exec_event(rli));
4791
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4792
#endif
4793 4794


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4795
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4796
	Delete_file_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4797
**************************************************************************/
4798

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4799
/*
4800
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4801
*/
4802 4803

#ifndef MYSQL_CLIENT
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4804 4805 4806
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)
4807 4808
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4809
#endif
4810

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4811
/*
4812
  Delete_file_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4813
*/
4814

4815 4816 4817
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)
4818
{
4819 4820 4821
  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))
4822
    return;
4823
  file_id= uint4korr(buf + common_header_len + DF_FILE_ID_OFFSET);
4824 4825 4826
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4827
/*
4828
  Delete_file_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4829
*/
4830

4831
#ifndef MYSQL_CLIENT
4832
bool Delete_file_log_event::write(IO_CACHE* file)
4833 4834 4835
{
 byte buf[DELETE_FILE_HEADER_LEN];
 int4store(buf + DF_FILE_ID_OFFSET, file_id);
4836 4837
 return (write_header(file, sizeof(buf)) ||
         my_b_safe_write(file, buf, sizeof(buf)));
4838
}
4839
#endif
4840 4841


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4842
/*
4843
  Delete_file_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4844
*/
4845 4846

#ifdef MYSQL_CLIENT  
lars@mysql.com's avatar
lars@mysql.com committed
4847
void Delete_file_log_event::print(FILE* file,
4848
				  PRINT_EVENT_INFO* print_event_info)
4849
{
4850
  if (print_event_info->short_form)
4851
    return;
4852
  print_header(file, print_event_info);
4853 4854 4855
  fputc('\n', file);
  fprintf(file, "#Delete_file: file_id=%u\n", file_id);
}
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4856
#endif /* MYSQL_CLIENT */
4857

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4858
/*
4859
  Delete_file_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4860
*/
4861

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4862
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4863
void Delete_file_log_event::pack_info(Protocol *protocol)
4864 4865 4866 4867
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
4868
  protocol->store(buf, (int32) length, &my_charset_bin);
4869
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4870
#endif
4871

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4872
/*
4873
  Delete_file_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4874
*/
4875

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4876
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4877 4878 4879
int Delete_file_log_event::exec_event(struct st_relay_log_info* rli)
{
  char fname[FN_REFLEN+10];
4880
  char *ext= slave_load_file_stem(fname, file_id, server_id, ".data");
4881
  (void) my_delete(fname, MYF(MY_WME));
4882
  strmov(ext, ".info");
4883 4884 4885
  (void) my_delete(fname, MYF(MY_WME));
  return Log_event::exec_event(rli);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4886
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
4887 4888


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4889
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4890
	Execute_load_log_event methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
4891
**************************************************************************/
4892

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4893
/*
4894
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4895
*/
4896 4897

#ifndef MYSQL_CLIENT  
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4898 4899 4900
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)
4901 4902
{
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4903
#endif
4904 4905
  

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4906
/*
4907
  Execute_load_log_event ctor
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4908
*/
4909

4910 4911 4912
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)
4913
{
4914 4915 4916
  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))
4917
    return;
4918
  file_id= uint4korr(buf + common_header_len + EL_FILE_ID_OFFSET);
4919 4920 4921
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4922
/*
4923
  Execute_load_log_event::write()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4924
*/
4925

4926
#ifndef MYSQL_CLIENT
4927
bool Execute_load_log_event::write(IO_CACHE* file)
4928 4929 4930
{
  byte buf[EXEC_LOAD_HEADER_LEN];
  int4store(buf + EL_FILE_ID_OFFSET, file_id);
4931 4932
  return (write_header(file, sizeof(buf)) || 
          my_b_safe_write(file, buf, sizeof(buf)));
4933
}
4934
#endif
4935 4936


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4937
/*
4938
  Execute_load_log_event::print()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4939
*/
4940 4941

#ifdef MYSQL_CLIENT  
lars@mysql.com's avatar
lars@mysql.com committed
4942
void Execute_load_log_event::print(FILE* file,
4943
				   PRINT_EVENT_INFO* print_event_info)
4944
{
4945
  if (print_event_info->short_form)
4946
    return;
4947
  print_header(file, print_event_info);
4948 4949 4950 4951
  fputc('\n', file);
  fprintf(file, "#Exec_load: file_id=%d\n",
	  file_id);
}
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4952
#endif
4953

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4954
/*
4955
  Execute_load_log_event::pack_info()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4956
*/
4957

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4958
#if defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT)
4959
void Execute_load_log_event::pack_info(Protocol *protocol)
4960 4961 4962 4963
{
  char buf[64];
  uint length;
  length= (uint) my_sprintf(buf, (buf, ";file_id=%u", (uint) file_id));
4964
  protocol->store(buf, (int32) length, &my_charset_bin);
4965 4966 4967
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4968
/*
4969
  Execute_load_log_event::exec_event()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4970
*/
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
4971

4972
int Execute_load_log_event::exec_event(struct st_relay_log_info* rli)
4973 4974
{
  char fname[FN_REFLEN+10];
4975
  char *ext;
4976
  int fd;
4977
  int error= 1;
4978
  IO_CACHE file;
4979
  Load_log_event *lev= 0;
4980

4981
  ext= slave_load_file_stem(fname, file_id, server_id, ".info");
4982 4983
  if ((fd = my_open(fname, O_RDONLY | O_BINARY | O_NOFOLLOW,
                    MYF(MY_WME))) < 0 ||
4984 4985 4986
      init_io_cache(&file, fd, IO_SIZE, READ_CACHE, (my_off_t)0, 0,
		    MYF(MY_WME|MY_NABP)))
  {
4987 4988 4989
    slave_print_error(rli,my_errno,
                      "Error in Exec_load event: could not open file '%s'",
                      fname);
4990 4991
    goto err;
  }
4992
  if (!(lev = (Load_log_event*)Log_event::read_log_event(&file,
4993 4994
                                                         (pthread_mutex_t*)0,
                                                         rli->relay_log.description_event_for_exec)) ||
4995
      lev->get_type_code() != NEW_LOAD_EVENT)
4996
  {
4997 4998 4999
    slave_print_error(rli,0,
                      "Error in Exec_load event: file '%s' appears corrupted",
                      fname);
5000 5001
    goto err;
  }
5002

5003
  lev->thd = thd;
5004 5005
  /*
    lev->exec_event should use rli only for errors
5006 5007 5008
    i.e. should not advance rli's position.
    lev->exec_event is the place where the table is loaded (it calls
    mysql_load()).
5009
  */
guilhem@mysql.com's avatar
guilhem@mysql.com committed
5010

5011
  rli->future_group_master_log_pos= log_pos;
5012
  if (lev->exec_event(0,rli,1)) 
5013
  {
5014 5015 5016 5017 5018 5019 5020 5021 5022
    /*
      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));
5023 5024 5025 5026 5027 5028 5029 5030
    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));
    }
5031 5032
    goto err;
  }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
5033 5034 5035 5036 5037 5038 5039 5040 5041 5042
  /*
    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;
  }
5043
  (void) my_delete(fname, MYF(MY_WME));
5044
  memcpy(ext, ".data", 6);
5045
  (void) my_delete(fname, MYF(MY_WME));
5046
  error = 0;
5047

5048 5049 5050
err:
  delete lev;
  if (fd >= 0)
5051
  {
5052
    my_close(fd, MYF(0));
5053 5054
    end_io_cache(&file);
  }
5055
  return error ? error : Log_event::exec_event(rli);
5056
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
5057

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5058
#endif /* defined(HAVE_REPLICATION) && !defined(MYSQL_CLIENT) */
5059 5060


5061 5062 5063 5064 5065 5066 5067 5068 5069 5070 5071 5072 5073 5074 5075 5076 5077 5078 5079 5080 5081 5082 5083 5084 5085
/**************************************************************************
	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)
5086
int Begin_load_query_log_event::get_create_or_append() const
5087
{
5088
  return 1; /* create the file */
5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100
}
#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,
5101 5102 5103 5104 5105
                             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,
                             THD::killed_state killed_err_arg):
5106
  Query_log_event(thd_arg, query_arg, query_length_arg, using_trans,
5107
                  suppress_use, killed_err_arg),
5108 5109 5110 5111 5112 5113 5114 5115 5116 5117 5118 5119 5120 5121 5122 5123 5124 5125 5126 5127 5128 5129 5130 5131 5132 5133 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143
  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;
}


5144
#ifndef MYSQL_CLIENT
5145 5146 5147 5148 5149 5150 5151 5152 5153 5154
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);
}
5155
#endif
5156 5157 5158


#ifdef MYSQL_CLIENT
lars@mysql.com's avatar
lars@mysql.com committed
5159
void Execute_load_query_log_event::print(FILE* file,
5160
                                         PRINT_EVENT_INFO* print_event_info)
5161
{
5162
  print(file, print_event_info, 0);
5163 5164 5165
}


lars@mysql.com's avatar
lars@mysql.com committed
5166
void Execute_load_query_log_event::print(FILE* file,
5167
                                         PRINT_EVENT_INFO* print_event_info,
5168 5169
                                         const char *local_fname)
{
5170
  print_query_header(file, print_event_info);
5171 5172 5173 5174 5175 5176 5177 5178 5179 5180 5181 5182

  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));
5183
    fprintf(file, "%s\n", print_event_info->delimiter);
5184 5185 5186 5187
  }
  else
  {
    my_fwrite(file, (byte*) query, q_len, MYF(MY_NABP | MY_WME));
5188
    fprintf(file, "%s\n", print_event_info->delimiter);
5189 5190
  }

5191
  if (!print_event_info->short_form)
5192 5193 5194 5195 5196 5197 5198 5199 5200 5201 5202 5203 5204 5205 5206 5207 5208 5209 5210 5211 5212 5213 5214 5215 5216 5217 5218 5219 5220 5221 5222 5223 5224 5225 5226 5227 5228 5229 5230 5231 5232 5233 5234 5235 5236 5237 5238 5239 5240 5241
    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;
5242
  fname= (p= strmake(p, STRING_WITH_LEN(" INFILE \'")));
5243 5244
  p= slave_load_file_stem(p, file_id, server_id, ".data");
  fname_end= p= strend(p);                      // Safer than p=p+5
5245
  *(p++)='\'';
5246
  switch (dup_handling) {
5247
  case LOAD_DUP_IGNORE:
5248
    p= strmake(p, STRING_WITH_LEN(" IGNORE"));
5249 5250
    break;
  case LOAD_DUP_REPLACE:
5251
    p= strmake(p, STRING_WITH_LEN(" REPLACE"));
5252 5253 5254 5255 5256
    break;
  default:
    /* Ordinary load data */
    break;
  }
5257
  p= strmake(p, STRING_WITH_LEN(" INTO"));
5258 5259 5260 5261 5262 5263 5264
  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;

5265 5266 5267 5268 5269 5270
  /*
    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));
5271 5272 5273 5274 5275 5276 5277

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


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
5278
/**************************************************************************
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5279
	sql_ex_info methods
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
5280
**************************************************************************/
5281

monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5282
/*
5283
  sql_ex_info::write_data()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5284
*/
5285

5286
bool sql_ex_info::write_data(IO_CACHE* file)
5287 5288 5289
{
  if (new_format())
  {
5290 5291 5292 5293 5294
    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) ||
5295 5296 5297 5298 5299 5300 5301 5302 5303 5304 5305 5306
	    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;
5307
    return my_b_safe_write(file, (byte*) &old_ex, sizeof(old_ex)) != 0;
5308 5309 5310 5311
  }
}


monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5312
/*
5313
  sql_ex_info::init()
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
5314
*/
5315 5316 5317 5318 5319 5320 5321 5322 5323 5324 5325 5326 5327 5328

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.
    */
5329 5330 5331 5332 5333
    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))
5334 5335 5336 5337 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5349 5350 5351 5352 5353 5354 5355 5356 5357 5358 5359
      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;
}