impossible position in Replication

suggest change

Usually this means that the Master crashed and that sync_binlog was OFF. The solution is to CHANGE MASTER to POS=0 of the next binlog file (see the Master) on the Slave.

The cause: The Master sends replication items to the Slave before flushing to its binlog (when sync_binlog=OFF). If the Master crashes before the flush, the Slave has already logically moved past the end of file on the binlog. When the Master starts up again, it starts a new binlog, so CHANGEing to the beginning of that binlog is the best available solution.

A longer term solution is sync_binlog=ON, if you can afford the extra I/O that it causes.

(If you are running with GTID, …?)

Found a mistake? Have a question or improvement idea? Let me know.

Error Codes:

* Error code 1064 Syntax error

* Error code 1175 Safe Update

* Error code 1215 Cannot add foreign key constraint

* 1411 - Bad Value for number date default etc.

* Access denied

* impossible position in Replication

* Cannot connect

* 144 145

* 139

* 1366

* 1062 24

Table Of Contents

0 Getting started with MySQL

1 Limit and Offset

2 Creating Databases

3 Backup using mysqldump

4 Table Creation

5 Insert

6 Error Codes

7 Stored routines, procedures and functions

8 Reserved Words

9 String operations

10 Delete

11 View

12 Indexes and Keys

13 Date and Time Operations

14 Comments

15 LOAD DATA INFILE

16 PREPARE Statements

17 ALTER TABLE

18 Joins

19 UPDATE

20 Change Password

21 JSON

22 MySQL Admin

23 TRIGGERS

24 Pivot Queries

25 Configuration and tuning

26 Converting from MyISAM to InnoDB

27 SELECT

28 Create New User

29 Group By

30 UNION

31 Drop Table

32 Data Types

33 Performance Tuning

34 Events

35 ENUM

36 Install MySQL with Docker

37 Arithmetic

38 Character Sets and Collations

39 MyISAM Engine

40 Many-to-many Mapping table

41 Using Variables

42 Log files

43 Partitioning

44 Security via GRANTs

45 Backticks

46 mysqlimport

47 MySQL LOCK TABLE

48 MySQL Unions

49 ORDER BY

50 MySQL client

51 MySQL Performance Tips

52 Temporary Tables

53 Transaction

54 Customize PS1

55 Dealing with sparse or missing data

56 Dynamic Un-Pivot Table using Prepared Statement

57 NULL

58 Replication

59 Connecting with UTF-8

60 SSL Connection Setup

61 Handling Time Zones

62 Time with subsecond precision

63 Error 1055 ONLY FULL GROUP BY

64 Full-Text search

65 Extract values from JSON type

66 Regular Expressions

67 Recover and reset default root password

68 One to Many

69 JOINS Join 3 tables

70 Server Information

71 Recover from lost root password

72 Contributors