~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

Last_SQL_Error = Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

898

668

STOP SLAVE;

899

669

RESET SLAVE;

900

670

942

712

*** BUG 30434 ***

943

713

*****************

944

714

945

SHOW SLAVE STATUS;

946

Slave_IO_State #

947

Master_Host 127.0.0.1

948

Master_User root

949

Master_Port #

950

Connect_Retry 1

951

Master_Log_File master-bin.000001

952

Read_Master_Log_Pos #

953

Relay_Log_File #

954

Relay_Log_Pos #

955

Relay_Master_Log_File master-bin.000001

956

Slave_IO_Running Yes

957

Slave_SQL_Running No

958

Replicate_Do_DB

959

Replicate_Ignore_DB

960

Replicate_Do_Table

961

Replicate_Ignore_Table

962

Replicate_Wild_Do_Table

963

Replicate_Wild_Ignore_Table

964

Last_Errno 1072

965

Last_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

966

Skip_Counter 0

967

Exec_Master_Log_Pos #

968

Relay_Log_Space #

969

Until_Condition None

970

Until_Log_File

971

Until_Log_Pos 0

972

Master_SSL_Allowed No

973

Master_SSL_CA_File

974

Master_SSL_CA_Path

975

Master_SSL_Cert

976

Master_SSL_Cipher

977

Master_SSL_Key

978

Seconds_Behind_Master #

979

Master_SSL_Verify_Server_Cert No

980

Last_IO_Errno #

981

Last_IO_Error #

982

Last_SQL_Errno 1072

983

Last_SQL_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

715

Last_SQL_Error = Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

984

716

STOP SLAVE;

985

717

RESET SLAVE;

986

718

1232

964

27 27 27 next

1233

965

29 29 29 second

1234

966

30 30 30 next

1235

1236

* Show Slave Status *

1237

1238

show slave status;;

1239

Slave_IO_State #

1240

Master_Host 127.0.0.1

1241

Master_User root

1242

Master_Port #

1243

Connect_Retry 1

1244

Master_Log_File master-bin.000001

1245

Read_Master_Log_Pos #

1246

Relay_Log_File #

1247

Relay_Log_Pos #

1248

Relay_Master_Log_File master-bin.000001

1249

Slave_IO_Running Yes

1250

Slave_SQL_Running Yes

1251

Replicate_Do_DB

1252

Replicate_Ignore_DB

1253

Replicate_Do_Table

1254

Replicate_Ignore_Table

1255

Replicate_Wild_Do_Table

1256

Replicate_Wild_Ignore_Table

1257

Last_Errno 0

1258

Last_Error

1259

Skip_Counter 0

1260

Exec_Master_Log_Pos #

1261

Relay_Log_Space #

1262

Until_Condition None

1263

Until_Log_File

1264

Until_Log_Pos 0

1265

Master_SSL_Allowed No

1266

Master_SSL_CA_File

1267

Master_SSL_CA_Path

1268

Master_SSL_Cert

1269

Master_SSL_Cipher

1270

Master_SSL_Key

1271

Seconds_Behind_Master #

1272

Master_SSL_Verify_Server_Cert No

1273

Last_IO_Errno #

1274

Last_IO_Error #

1275

Last_SQL_Errno 0

1276

Last_SQL_Error

1277

967

Checking that both slave threads are running.

1278

968

1279

969

***** Testing Altering table def scenario *****

1280

970

1606

1296

delete from t3;

1607

1297

delete from t4;

1608

1298

delete from t31;

1299

select * from t31;

1300

f1 f2 f3 f4

1609

1301

1610

1302

** Check slave status **

1611

1303

1612

select * from t31;

1613

f1 f2 f3 f4

1614

show slave status;;

1615

Slave_IO_State #

1616

Master_Host 127.0.0.1

1617

Master_User root

1618

Master_Port #

1619

Connect_Retry 1

1620

Master_Log_File master-bin.000001

1621

Read_Master_Log_Pos #

1622

Relay_Log_File #

1623

Relay_Log_Pos #

1624

Relay_Master_Log_File master-bin.000001

1625

Slave_IO_Running Yes

1626

Slave_SQL_Running Yes

1627

Replicate_Do_DB

1628

Replicate_Ignore_DB

1629

Replicate_Do_Table

1630

Replicate_Ignore_Table

1631

Replicate_Wild_Do_Table

1632

Replicate_Wild_Ignore_Table

1633

Last_Errno 0

1634

Last_Error

1635

Skip_Counter 0

1636

Exec_Master_Log_Pos #

1637

Relay_Log_Space #

1638

Until_Condition None

1639

Until_Log_File

1640

Until_Log_Pos 0

1641

Master_SSL_Allowed No

1642

Master_SSL_CA_File

1643

Master_SSL_CA_Path

1644

Master_SSL_Cert

1645

Master_SSL_Cipher

1646

Master_SSL_Key

1647

Seconds_Behind_Master #

1648

Master_SSL_Verify_Server_Cert No

1649

Last_IO_Errno #

1650

Last_IO_Error #

1651

Last_SQL_Errno 0

1652

Last_SQL_Error

1304

Checking that both slave threads are running.

1653

1305

1654

1306

****************************************

1655

1307

* columns in master at middle of table *

1682

1334

(3,@b1,DEFAULT,'QA',DEFAULT);

1683

1335

1684

1336

********************************************

1685

*** Expect slave to fail with Error 1523 ***

1337

*** Expect slave to fail with Error 1535 ***

1686

1338

********************************************

1687

1339

1688

SHOW SLAVE STATUS;

1689

Slave_IO_State #

1690

Master_Host 127.0.0.1

1691

Master_User root

1692

Master_Port #

1693

Connect_Retry 1

1694

Master_Log_File master-bin.000001

1695

Read_Master_Log_Pos #

1696

Relay_Log_File #

1697

Relay_Log_Pos #

1698

Relay_Master_Log_File master-bin.000001

1699

Slave_IO_Running Yes

1700

Slave_SQL_Running No

1701

Replicate_Do_DB

1702

Replicate_Ignore_DB

1703

Replicate_Do_Table

1704

Replicate_Ignore_Table

1705

Replicate_Wild_Do_Table

1706

Replicate_Wild_Ignore_Table

1707

Last_Errno 1535

1708

Last_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

1709

Skip_Counter 0

1710

Exec_Master_Log_Pos #

1711

Relay_Log_Space #

1712

Until_Condition None

1713

Until_Log_File

1714

Until_Log_Pos 0

1715

Master_SSL_Allowed No

1716

Master_SSL_CA_File

1717

Master_SSL_CA_Path

1718

Master_SSL_Cert

1719

Master_SSL_Cipher

1720

Master_SSL_Key

1721

Seconds_Behind_Master #

1722

Master_SSL_Verify_Server_Cert No

1723

Last_IO_Errno #

1724

Last_IO_Error #

1725

Last_SQL_Errno 1535

1726

Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

1727

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

1728

START SLAVE;

1340

--source include/wait_for_slave_sql_error_and_skip.inc

1341

Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

1342

SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;

1343

include/start_slave.inc

1729

1344

1730

1345

*** Drop t10 ***

1731

1346

DROP TABLE t10;

1757

1372

(3,@b1,DEFAULT,'QA',DEFAULT);

1758

1373

1759

1374

********************************************

1760

*** Expect slave to fail with Error 1523 ***

1375

*** Expect slave to fail with Error 1535 ***

1761

1376

********************************************

1762

1377

1763

SHOW SLAVE STATUS;

1764

Slave_IO_State #

1765

Master_Host 127.0.0.1

1766

Master_User root

1767

Master_Port #

1768

Connect_Retry 1

1769

Master_Log_File master-bin.000001

1770

Read_Master_Log_Pos #

1771

Relay_Log_File #

1772

Relay_Log_Pos #

1773

Relay_Master_Log_File master-bin.000001

1774

Slave_IO_Running Yes

1775

Slave_SQL_Running No

1776

Replicate_Do_DB

1777

Replicate_Ignore_DB

1778

Replicate_Do_Table

1779

Replicate_Ignore_Table

1780

Replicate_Wild_Do_Table

1781

Replicate_Wild_Ignore_Table

1782

Last_Errno 1535

1783

Last_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

1784

Skip_Counter 0

1785

Exec_Master_Log_Pos #

1786

Relay_Log_Space #

1787

Until_Condition None

1788

Until_Log_File

1789

Until_Log_Pos 0

1790

Master_SSL_Allowed No

1791

Master_SSL_CA_File

1792

Master_SSL_CA_Path

1793

Master_SSL_Cert

1794

Master_SSL_Cipher

1795

Master_SSL_Key

1796

Seconds_Behind_Master #

1797

Master_SSL_Verify_Server_Cert No

1798

Last_IO_Errno #

1799

Last_IO_Error #

1800

Last_SQL_Errno 1535

1801

Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

1802

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

1803

START SLAVE;

1378

--source include/wait_for_slave_sql_error_and_skip.inc

1379

Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

1380

SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;

1381

include/start_slave.inc

1804

1382

1805

1383

*** Drop t11 ***

1806

1384

DROP TABLE t11;

1911

1489

************

1912

1490

* Bug30415 *

1913

1491

************

1914

SHOW SLAVE STATUS;

1915

Slave_IO_State #

1916

Master_Host 127.0.0.1

1917

Master_User root

1918

Master_Port #

1919

Connect_Retry 1

1920

Master_Log_File master-bin.000001

1921

Read_Master_Log_Pos #

1922

Relay_Log_File #

1923

Relay_Log_Pos #

1924

Relay_Master_Log_File master-bin.000001

1925

Slave_IO_Running Yes

1926

Slave_SQL_Running No

1927

Replicate_Do_DB

1928

Replicate_Ignore_DB

1929

Replicate_Do_Table

1930

Replicate_Ignore_Table

1931

Replicate_Wild_Do_Table

1932

Replicate_Wild_Ignore_Table

1933

Last_Errno 1091

1934

Last_Error Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

1935

Skip_Counter 0

1936

Exec_Master_Log_Pos #

1937

Relay_Log_Space #

1938

Until_Condition None

1939

Until_Log_File

1940

Until_Log_Pos 0

1941

Master_SSL_Allowed No

1942

Master_SSL_CA_File

1943

Master_SSL_CA_Path

1944

Master_SSL_Cert

1945

Master_SSL_Cipher

1946

Master_SSL_Key

1947

Seconds_Behind_Master #

1948

Master_SSL_Verify_Server_Cert No

1949

Last_IO_Errno #

1950

Last_IO_Error #

1951

Last_SQL_Errno 1091

1952

Last_SQL_Error Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

1492

Last_SQL_Error = Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

1953

1493

STOP SLAVE;

1954

1494

RESET SLAVE;

1955

1495

1997

1537

*** Expect slave to fail with Error 1054 ***

1998

1538

********************************************

1999

1539

2000

SHOW SLAVE STATUS;

2001

Slave_IO_State #

2002

Master_Host 127.0.0.1

2003

Master_User root

2004

Master_Port #

2005

Connect_Retry 1

2006

Master_Log_File master-bin.000001

2007

Read_Master_Log_Pos #

2008

Relay_Log_File #

2009

Relay_Log_Pos #

2010

Relay_Master_Log_File master-bin.000001

2011

Slave_IO_Running Yes

2012

Slave_SQL_Running No

2013

Replicate_Do_DB

2014

Replicate_Ignore_DB

2015

Replicate_Do_Table

2016

Replicate_Ignore_Table

2017

Replicate_Wild_Do_Table

2018

Replicate_Wild_Ignore_Table

2019

Last_Errno 1054

2020

Last_Error Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

2021

Skip_Counter 0

2022

Exec_Master_Log_Pos #

2023

Relay_Log_Space #

2024

Until_Condition None

2025

Until_Log_File

2026

Until_Log_Pos 0

2027

Master_SSL_Allowed No

2028

Master_SSL_CA_File

2029

Master_SSL_CA_Path

2030

Master_SSL_Cert

2031

Master_SSL_Cipher

2032

Master_SSL_Key

2033

Seconds_Behind_Master #

2034

Master_SSL_Verify_Server_Cert No

2035

Last_IO_Errno #

2036

Last_IO_Error #

2037

Last_SQL_Errno 1054

2038

Last_SQL_Error Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

1540

Last_SQL_Error = Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

2039

1541

STOP SLAVE;

2040

1542

RESET SLAVE;

2041

1543

2083

1585

*** BUG 30434 ***

2084

1586

*****************

2085

1587

2086

SHOW SLAVE STATUS;

2087

Slave_IO_State #

2088

Master_Host 127.0.0.1

2089

Master_User root

2090

Master_Port #

2091

Connect_Retry 1

2092

Master_Log_File master-bin.000001

2093

Read_Master_Log_Pos #

2094

Relay_Log_File #

2095

Relay_Log_Pos #

2096

Relay_Master_Log_File master-bin.000001

2097

Slave_IO_Running Yes

2098

Slave_SQL_Running No

2099

Replicate_Do_DB

2100

Replicate_Ignore_DB

2101

Replicate_Do_Table

2102

Replicate_Ignore_Table

2103

Replicate_Wild_Do_Table

2104

Replicate_Wild_Ignore_Table

2105

Last_Errno 1072

2106

Last_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

2107

Skip_Counter 0

2108

Exec_Master_Log_Pos #

2109

Relay_Log_Space #

2110

Until_Condition None

2111

Until_Log_File

2112

Until_Log_Pos 0

2113

Master_SSL_Allowed No

2114

Master_SSL_CA_File

2115

Master_SSL_CA_Path

2116

Master_SSL_Cert

2117

Master_SSL_Cipher

2118

Master_SSL_Key

2119

Seconds_Behind_Master #

2120

Master_SSL_Verify_Server_Cert No

2121

Last_IO_Errno #

2122

Last_IO_Error #

2123

Last_SQL_Errno 1072

2124

Last_SQL_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

1588

Last_SQL_Error = Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

2125

1589

STOP SLAVE;

2126

1590

RESET SLAVE;

2127

1591

2373

1837

27 27 27 next

2374

1838

29 29 29 second

2375

1839

30 30 30 next

2376

2377

* Show Slave Status *

2378

2379

show slave status;;

2380

Slave_IO_State #

2381

Master_Host 127.0.0.1

2382

Master_User root

2383

Master_Port #

2384

Connect_Retry 1

2385

Master_Log_File master-bin.000001

2386

Read_Master_Log_Pos #

2387

Relay_Log_File #

2388

Relay_Log_Pos #

2389

Relay_Master_Log_File master-bin.000001

2390

Slave_IO_Running Yes

2391

Slave_SQL_Running Yes

2392

Replicate_Do_DB

2393

Replicate_Ignore_DB

2394

Replicate_Do_Table

2395

Replicate_Ignore_Table

2396

Replicate_Wild_Do_Table

2397

Replicate_Wild_Ignore_Table

2398

Last_Errno 0

2399

Last_Error

2400

Skip_Counter 0

2401

Exec_Master_Log_Pos #

2402

Relay_Log_Space #

2403

Until_Condition None

2404

Until_Log_File

2405

Until_Log_Pos 0

2406

Master_SSL_Allowed No

2407

Master_SSL_CA_File

2408

Master_SSL_CA_Path

2409

Master_SSL_Cert

2410

Master_SSL_Cipher

2411

Master_SSL_Key

2412

Seconds_Behind_Master #

2413

Master_SSL_Verify_Server_Cert No

2414

Last_IO_Errno #

2415

Last_IO_Error #

2416

Last_SQL_Errno 0

2417

Last_SQL_Error

2418

1840

Checking that both slave threads are running.

2419

1841

2420

1842

***** Testing Altering table def scenario *****

2421

1843

2747

2169

delete from t3;

2748

2170

delete from t4;

2749

2171

delete from t31;

2172

select * from t31;

2173

f1 f2 f3 f4

2750

2174

2751

2175

** Check slave status **

2752

2176

2753

select * from t31;

2754

f1 f2 f3 f4

2755

show slave status;;

2756

Slave_IO_State #

2757

Master_Host 127.0.0.1

2758

Master_User root

2759

Master_Port #

2760

Connect_Retry 1

2761

Master_Log_File master-bin.000001

2762

Read_Master_Log_Pos #

2763

Relay_Log_File #

2764

Relay_Log_Pos #

2765

Relay_Master_Log_File master-bin.000001

2766

Slave_IO_Running Yes

2767

Slave_SQL_Running Yes

2768

Replicate_Do_DB

2769

Replicate_Ignore_DB

2770

Replicate_Do_Table

2771

Replicate_Ignore_Table

2772

Replicate_Wild_Do_Table

2773

Replicate_Wild_Ignore_Table

2774

Last_Errno 0

2775

Last_Error

2776

Skip_Counter 0

2777

Exec_Master_Log_Pos #

2778

Relay_Log_Space #

2779

Until_Condition None

2780

Until_Log_File

2781

Until_Log_Pos 0

2782

Master_SSL_Allowed No

2783

Master_SSL_CA_File

2784

Master_SSL_CA_Path

2785

Master_SSL_Cert

2786

Master_SSL_Cipher

2787

Master_SSL_Key

2788

Seconds_Behind_Master #

2789

Master_SSL_Verify_Server_Cert No

2790

Last_IO_Errno #

2791

Last_IO_Error #

2792

Last_SQL_Errno 0

2793

Last_SQL_Error

2177

Checking that both slave threads are running.

2794

2178

2795

2179

****************************************

2796

2180

* columns in master at middle of table *

2823

2207

(3,@b1,DEFAULT,'QA',DEFAULT);

2824

2208

2825

2209

********************************************

2826

*** Expect slave to fail with Error 1523 ***

2210

*** Expect slave to fail with Error 1535 ***

2827

2211

********************************************

2828

2212

2829

SHOW SLAVE STATUS;

2830

Slave_IO_State #

2831

Master_Host 127.0.0.1

2832

Master_User root

2833

Master_Port #

2834

Connect_Retry 1

2835

Master_Log_File master-bin.000001

2836

Read_Master_Log_Pos #

2837

Relay_Log_File #

2838

Relay_Log_Pos #

2839

Relay_Master_Log_File master-bin.000001

2840

Slave_IO_Running Yes

2841

Slave_SQL_Running No

2842

Replicate_Do_DB

2843

Replicate_Ignore_DB

2844

Replicate_Do_Table

2845

Replicate_Ignore_Table

2846

Replicate_Wild_Do_Table

2847

Replicate_Wild_Ignore_Table

2848

Last_Errno 1535

2849

Last_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

2850

Skip_Counter 0

2851

Exec_Master_Log_Pos #

2852

Relay_Log_Space #

2853

Until_Condition None

2854

Until_Log_File

2855

Until_Log_Pos 0

2856

Master_SSL_Allowed No

2857

Master_SSL_CA_File

2858

Master_SSL_CA_Path

2859

Master_SSL_Cert

2860

Master_SSL_Cipher

2861

Master_SSL_Key

2862

Seconds_Behind_Master #

2863

Master_SSL_Verify_Server_Cert No

2864

Last_IO_Errno #

2865

Last_IO_Error #

2866

Last_SQL_Errno 1535

2867

Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

2868

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

2869

START SLAVE;

2213

--source include/wait_for_slave_sql_error_and_skip.inc

2214

Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 5, test.t10 has type 254

2215

SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;

2216

include/start_slave.inc

2870

2217

2871

2218

*** Drop t10 ***

2872

2219

DROP TABLE t10;

2898

2245

(3,@b1,DEFAULT,'QA',DEFAULT);

2899

2246

2900

2247

********************************************

2901

*** Expect slave to fail with Error 1523 ***

2248

*** Expect slave to fail with Error 1535 ***

2902

2249

********************************************

2903

2250

2904

SHOW SLAVE STATUS;

2905

Slave_IO_State #

2906

Master_Host 127.0.0.1

2907

Master_User root

2908

Master_Port #

2909

Connect_Retry 1

2910

Master_Log_File master-bin.000001

2911

Read_Master_Log_Pos #

2912

Relay_Log_File #

2913

Relay_Log_Pos #

2914

Relay_Master_Log_File master-bin.000001

2915

Slave_IO_Running Yes

2916

Slave_SQL_Running No

2917

Replicate_Do_DB

2918

Replicate_Ignore_DB

2919

Replicate_Do_Table

2920

Replicate_Ignore_Table

2921

Replicate_Wild_Do_Table

2922

Replicate_Wild_Ignore_Table

2923

Last_Errno 1535

2924

Last_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

2925

Skip_Counter 0

2926

Exec_Master_Log_Pos #

2927

Relay_Log_Space #

2928

Until_Condition None

2929

Until_Log_File

2930

Until_Log_Pos 0

2931

Master_SSL_Allowed No

2932

Master_SSL_CA_File

2933

Master_SSL_CA_Path

2934

Master_SSL_Cert

2935

Master_SSL_Cipher

2936

Master_SSL_Key

2937

Seconds_Behind_Master #

2938

Master_SSL_Verify_Server_Cert No

2939

Last_IO_Errno #

2940

Last_IO_Error #

2941

Last_SQL_Errno 1535

2942

Last_SQL_Error Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

2943

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

2944

START SLAVE;

2251

--source include/wait_for_slave_sql_error_and_skip.inc

2252

Last_SQL_Error = Table definition on master and slave does not match: Column 2 type mismatch - received type 252, test.t11 has type 15

2253

SET GLOBAL SQL_SLAVE_SKIP_COUNTER= 2;

2254

include/start_slave.inc

2945

2255

2946

2256

*** Drop t11 ***

2947

2257

DROP TABLE t11;

3052

2362

************

3053

2363

* Bug30415 *

3054

2364

************

3055

SHOW SLAVE STATUS;

3056

Slave_IO_State #

3057

Master_Host 127.0.0.1

3058

Master_User root

3059

Master_Port #

3060

Connect_Retry 1

3061

Master_Log_File master-bin.000001

3062

Read_Master_Log_Pos #

3063

Relay_Log_File #

3064

Relay_Log_Pos #

3065

Relay_Master_Log_File master-bin.000001

3066

Slave_IO_Running Yes

3067

Slave_SQL_Running No

3068

Replicate_Do_DB

3069

Replicate_Ignore_DB

3070

Replicate_Do_Table

3071

Replicate_Ignore_Table

3072

Replicate_Wild_Do_Table

3073

Replicate_Wild_Ignore_Table

3074

Last_Errno 1091

3075

Last_Error Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

3076

Skip_Counter 0

3077

Exec_Master_Log_Pos #

3078

Relay_Log_Space #

3079

Until_Condition None

3080

Until_Log_File

3081

Until_Log_Pos 0

3082

Master_SSL_Allowed No

3083

Master_SSL_CA_File

3084

Master_SSL_CA_Path

3085

Master_SSL_Cert

3086

Master_SSL_Cipher

3087

Master_SSL_Key

3088

Seconds_Behind_Master #

3089

Master_SSL_Verify_Server_Cert No

3090

Last_IO_Errno #

3091

Last_IO_Error #

3092

Last_SQL_Errno 1091

3093

Last_SQL_Error Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

2365

Last_SQL_Error = Error 'Can't DROP 'c7'; check that column/key exists' on query. Default database: 'test'. Query: 'ALTER TABLE t14 DROP COLUMN c7'

3094

2366

STOP SLAVE;

3095

2367

RESET SLAVE;

3096

2368

3138

2410

*** Expect slave to fail with Error 1054 ***

3139

2411

********************************************

3140

2412

3141

SHOW SLAVE STATUS;

3142

Slave_IO_State #

3143

Master_Host 127.0.0.1

3144

Master_User root

3145

Master_Port #

3146

Connect_Retry 1

3147

Master_Log_File master-bin.000001

3148

Read_Master_Log_Pos #

3149

Relay_Log_File #

3150

Relay_Log_Pos #

3151

Relay_Master_Log_File master-bin.000001

3152

Slave_IO_Running Yes

3153

Slave_SQL_Running No

3154

Replicate_Do_DB

3155

Replicate_Ignore_DB

3156

Replicate_Do_Table

3157

Replicate_Ignore_Table

3158

Replicate_Wild_Do_Table

3159

Replicate_Wild_Ignore_Table

3160

Last_Errno 1054

3161

Last_Error Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

3162

Skip_Counter 0

3163

Exec_Master_Log_Pos #

3164

Relay_Log_Space #

3165

Until_Condition None

3166

Until_Log_File

3167

Until_Log_Pos 0

3168

Master_SSL_Allowed No

3169

Master_SSL_CA_File

3170

Master_SSL_CA_Path

3171

Master_SSL_Cert

3172

Master_SSL_Cipher

3173

Master_SSL_Key

3174

Seconds_Behind_Master #

3175

Master_SSL_Verify_Server_Cert No

3176

Last_IO_Errno #

3177

Last_IO_Error #

3178

Last_SQL_Errno 1054

3179

Last_SQL_Error Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

2413

Last_SQL_Error = Error 'Unknown column 'c7' in 't15'' on query. Default database: 'test'. Query: 'ALTER TABLE t15 ADD COLUMN c2 DECIMAL(8,2) AFTER c7'

3180

2414

STOP SLAVE;

3181

2415

RESET SLAVE;

3182

2416

3224

2458

*** BUG 30434 ***

3225

2459

*****************

3226

2460

3227

SHOW SLAVE STATUS;

3228

Slave_IO_State #

3229

Master_Host 127.0.0.1

3230

Master_User root

3231

Master_Port #

3232

Connect_Retry 1

3233

Master_Log_File master-bin.000001

3234

Read_Master_Log_Pos #

3235

Relay_Log_File #

3236

Relay_Log_Pos #

3237

Relay_Master_Log_File master-bin.000001

3238

Slave_IO_Running Yes

3239

Slave_SQL_Running No

3240

Replicate_Do_DB

3241

Replicate_Ignore_DB

3242

Replicate_Do_Table

3243

Replicate_Ignore_Table

3244

Replicate_Wild_Do_Table

3245

Replicate_Wild_Ignore_Table

3246

Last_Errno 1072

3247

Last_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

3248

Skip_Counter 0

3249

Exec_Master_Log_Pos #

3250

Relay_Log_Space #

3251

Until_Condition None

3252

Until_Log_File

3253

Until_Log_Pos 0

3254

Master_SSL_Allowed No

3255

Master_SSL_CA_File

3256

Master_SSL_CA_Path

3257

Master_SSL_Cert

3258

Master_SSL_Cipher

3259

Master_SSL_Key

3260

Seconds_Behind_Master #

3261

Master_SSL_Verify_Server_Cert No

3262

Last_IO_Errno #

3263

Last_IO_Error #

3264

Last_SQL_Errno 1072

3265

Last_SQL_Error Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

2461

Last_SQL_Error = Error 'Key column 'c6' doesn't exist in table' on query. Default database: 'test'. Query: 'CREATE INDEX part_of_c6 ON t16 (c6)'

3266

2462

STOP SLAVE;

3267

2463

RESET SLAVE;

3268

2464

Older »