~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'

896

668

STOP SLAVE;

897

669

RESET SLAVE;

898

670

940

712

*** BUG 30434 ***

941

713

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

942

714

943

SHOW SLAVE STATUS;

944

Slave_IO_State #

945

Master_Host 127.0.0.1

946

Master_User root

947

Master_Port #

948

Connect_Retry 1

949

Master_Log_File master-bin.000001

950

Read_Master_Log_Pos #

951

Relay_Log_File #

952

Relay_Log_Pos #

953

Relay_Master_Log_File master-bin.000001

954

Slave_IO_Running Yes

955

Slave_SQL_Running No

956

Replicate_Do_DB

957

Replicate_Ignore_DB

958

Replicate_Do_Table

959

Replicate_Ignore_Table

960

Replicate_Wild_Do_Table

961

Replicate_Wild_Ignore_Table

962

Last_Errno 1072

963

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)'

964

Skip_Counter 0

965

Exec_Master_Log_Pos #

966

Relay_Log_Space #

967

Until_Condition None

968

Until_Log_File

969

Until_Log_Pos 0

970

Master_SSL_Allowed No

971

Master_SSL_CA_File

972

Master_SSL_CA_Path

973

Master_SSL_Cert

974

Master_SSL_Cipher

975

Master_SSL_Key

976

Seconds_Behind_Master #

977

Master_SSL_Verify_Server_Cert No

978

Last_IO_Errno #

979

Last_IO_Error #

980

Last_SQL_Errno 1072

981

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)'

982

716

STOP SLAVE;

983

717

RESET SLAVE;

984

718

1230

964

27 27 27 next

1231

965

29 29 29 second

1232

966

30 30 30 next

1233

1234

* Show Slave Status *

1235

1236

show slave status;;

1237

Slave_IO_State #

1238

Master_Host 127.0.0.1

1239

Master_User root

1240

Master_Port #

1241

Connect_Retry 1

1242

Master_Log_File master-bin.000001

1243

Read_Master_Log_Pos #

1244

Relay_Log_File #

1245

Relay_Log_Pos #

1246

Relay_Master_Log_File master-bin.000001

1247

Slave_IO_Running Yes

1248

Slave_SQL_Running Yes

1249

Replicate_Do_DB

1250

Replicate_Ignore_DB

1251

Replicate_Do_Table

1252

Replicate_Ignore_Table

1253

Replicate_Wild_Do_Table

1254

Replicate_Wild_Ignore_Table

1255

Last_Errno 0

1256

Last_Error

1257

Skip_Counter 0

1258

Exec_Master_Log_Pos #

1259

Relay_Log_Space #

1260

Until_Condition None

1261

Until_Log_File

1262

Until_Log_Pos 0

1263

Master_SSL_Allowed No

1264

Master_SSL_CA_File

1265

Master_SSL_CA_Path

1266

Master_SSL_Cert

1267

Master_SSL_Cipher

1268

Master_SSL_Key

1269

Seconds_Behind_Master #

1270

Master_SSL_Verify_Server_Cert No

1271

Last_IO_Errno #

1272

Last_IO_Error #

1273

Last_SQL_Errno 0

1274

Last_SQL_Error

1275

967

Checking that both slave threads are running.

1276

968

1277

969

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

1278

970

1593

1285

update t31 set f5=555555555555555 where f3=6;

1594

1286

update t31 set f2=2 where f3=2;

1595

1287

update t31 set f1=NULL where f3=1;

1596

update t31 set f3=0, f27=NULL, f35='f35 new value' where f3=3;

1288

update t31 set f3=NULL, f27=NULL, f35='f35 new value' where f3=3;

1289

Warnings:

1290

Warning 1048 Column 'f3' cannot be null

1597

1291

1598

1292

** Delete from Master **

1599

1293

1602

1296

delete from t3;

1603

1297

delete from t4;

1604

1298

delete from t31;

1299

select * from t31;

1300

f1 f2 f3 f4

1605

1301

1606

1302

** Check slave status **

1607

1303

1608

select * from t31;

1609

f1 f2 f3 f4

1610

show slave status;;

1611

Slave_IO_State #

1612

Master_Host 127.0.0.1

1613

Master_User root

1614

Master_Port #

1615

Connect_Retry 1

1616

Master_Log_File master-bin.000001

1617

Read_Master_Log_Pos #

1618

Relay_Log_File #

1619

Relay_Log_Pos #

1620

Relay_Master_Log_File master-bin.000001

1621

Slave_IO_Running Yes

1622

Slave_SQL_Running Yes

1623

Replicate_Do_DB

1624

Replicate_Ignore_DB

1625

Replicate_Do_Table

1626

Replicate_Ignore_Table

1627

Replicate_Wild_Do_Table

1628

Replicate_Wild_Ignore_Table

1629

Last_Errno 0

1630

Last_Error

1631

Skip_Counter 0

1632

Exec_Master_Log_Pos #

1633

Relay_Log_Space #

1634

Until_Condition None

1635

Until_Log_File

1636

Until_Log_Pos 0

1637

Master_SSL_Allowed No

1638

Master_SSL_CA_File

1639

Master_SSL_CA_Path

1640

Master_SSL_Cert

1641

Master_SSL_Cipher

1642

Master_SSL_Key

1643

Seconds_Behind_Master #

1644

Master_SSL_Verify_Server_Cert No

1645

Last_IO_Errno #

1646

Last_IO_Error #

1647

Last_SQL_Errno 0

1648

Last_SQL_Error

1304

Checking that both slave threads are running.

1649

1305

1650

1306

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

1651

1307

* columns in master at middle of table *

1678

1334

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

1679

1335

1680

1336

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

1681

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

1337

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

1682

1338

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

1683

1339

1684

SHOW SLAVE STATUS;

1685

Slave_IO_State #

1686

Master_Host 127.0.0.1

1687

Master_User root

1688

Master_Port #

1689

Connect_Retry 1

1690

Master_Log_File master-bin.000001

1691

Read_Master_Log_Pos #

1692

Relay_Log_File #

1693

Relay_Log_Pos #

1694

Relay_Master_Log_File master-bin.000001

1695

Slave_IO_Running Yes

1696

Slave_SQL_Running No

1697

Replicate_Do_DB

1698

Replicate_Ignore_DB

1699

Replicate_Do_Table

1700

Replicate_Ignore_Table

1701

Replicate_Wild_Do_Table

1702

Replicate_Wild_Ignore_Table

1703

Last_Errno 1535

1704

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

1705

Skip_Counter 0

1706

Exec_Master_Log_Pos #

1707

Relay_Log_Space #

1708

Until_Condition None

1709

Until_Log_File

1710

Until_Log_Pos 0

1711

Master_SSL_Allowed No

1712

Master_SSL_CA_File

1713

Master_SSL_CA_Path

1714

Master_SSL_Cert

1715

Master_SSL_Cipher

1716

Master_SSL_Key

1717

Seconds_Behind_Master #

1718

Master_SSL_Verify_Server_Cert No

1719

Last_IO_Errno #

1720

Last_IO_Error #

1721

Last_SQL_Errno 1535

1722

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

1723

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

1724

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

1725

1344

1726

1345

*** Drop t10 ***

1727

1346

DROP TABLE t10;

1753

1372

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

1754

1373

1755

1374

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

1756

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

1375

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

1757

1376

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

1758

1377

1759

SHOW SLAVE STATUS;

1760

Slave_IO_State #

1761

Master_Host 127.0.0.1

1762

Master_User root

1763

Master_Port #

1764

Connect_Retry 1

1765

Master_Log_File master-bin.000001

1766

Read_Master_Log_Pos #

1767

Relay_Log_File #

1768

Relay_Log_Pos #

1769

Relay_Master_Log_File master-bin.000001

1770

Slave_IO_Running Yes

1771

Slave_SQL_Running No

1772

Replicate_Do_DB

1773

Replicate_Ignore_DB

1774

Replicate_Do_Table

1775

Replicate_Ignore_Table

1776

Replicate_Wild_Do_Table

1777

Replicate_Wild_Ignore_Table

1778

Last_Errno 1535

1779

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

1780

Skip_Counter 0

1781

Exec_Master_Log_Pos #

1782

Relay_Log_Space #

1783

Until_Condition None

1784

Until_Log_File

1785

Until_Log_Pos 0

1786

Master_SSL_Allowed No

1787

Master_SSL_CA_File

1788

Master_SSL_CA_Path

1789

Master_SSL_Cert

1790

Master_SSL_Cipher

1791

Master_SSL_Key

1792

Seconds_Behind_Master #

1793

Master_SSL_Verify_Server_Cert No

1794

Last_IO_Errno #

1795

Last_IO_Error #

1796

Last_SQL_Errno 1535

1797

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

1798

SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;

1799

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

1800

1382

1801

1383

*** Drop t11 ***

1802

1384

DROP TABLE t11;

1907

1489

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

1908

1490

* Bug30415 *

1909

1491

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

1910

SHOW SLAVE STATUS;

1911

Slave_IO_State #

1912

Master_Host 127.0.0.1

1913

Master_User root

1914

Master_Port #

1915

Connect_Retry 1

1916

Master_Log_File master-bin.000001

1917

Read_Master_Log_Pos #

1918

Relay_Log_File #

1919

Relay_Log_Pos #

1920

Relay_Master_Log_File master-bin.000001

1921

Slave_IO_Running Yes

1922

Slave_SQL_Running No

1923

Replicate_Do_DB

1924

Replicate_Ignore_DB

1925

Replicate_Do_Table

1926

Replicate_Ignore_Table

1927

Replicate_Wild_Do_Table

1928

Replicate_Wild_Ignore_Table

1929

Last_Errno 1091

1930

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

1931

Skip_Counter 0

1932

Exec_Master_Log_Pos #

1933

Relay_Log_Space #

1934

Until_Condition None

1935

Until_Log_File

1936

Until_Log_Pos 0

1937

Master_SSL_Allowed No

1938

Master_SSL_CA_File

1939

Master_SSL_CA_Path

1940

Master_SSL_Cert

1941

Master_SSL_Cipher

1942

Master_SSL_Key

1943

Seconds_Behind_Master #

1944

Master_SSL_Verify_Server_Cert No

1945

Last_IO_Errno #

1946

Last_IO_Error #

1947

Last_SQL_Errno 1091

1948

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'

1949

1493

STOP SLAVE;

1950

1494

RESET SLAVE;

1951

1495

1993

1537

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

1994

1538

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

1995

1539

1996

SHOW SLAVE STATUS;

1997

Slave_IO_State #

1998

Master_Host 127.0.0.1

1999

Master_User root

2000

Master_Port #

2001

Connect_Retry 1

2002

Master_Log_File master-bin.000001

2003

Read_Master_Log_Pos #

2004

Relay_Log_File #

2005

Relay_Log_Pos #

2006

Relay_Master_Log_File master-bin.000001

2007

Slave_IO_Running Yes

2008

Slave_SQL_Running No

2009

Replicate_Do_DB

2010

Replicate_Ignore_DB

2011

Replicate_Do_Table

2012

Replicate_Ignore_Table

2013

Replicate_Wild_Do_Table

2014

Replicate_Wild_Ignore_Table

2015

Last_Errno 1054

2016

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'

2017

Skip_Counter 0

2018

Exec_Master_Log_Pos #

2019

Relay_Log_Space #

2020

Until_Condition None

2021

Until_Log_File

2022

Until_Log_Pos 0

2023

Master_SSL_Allowed No

2024

Master_SSL_CA_File

2025

Master_SSL_CA_Path

2026

Master_SSL_Cert

2027

Master_SSL_Cipher

2028

Master_SSL_Key

2029

Seconds_Behind_Master #

2030

Master_SSL_Verify_Server_Cert No

2031

Last_IO_Errno #

2032

Last_IO_Error #

2033

Last_SQL_Errno 1054

2034

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'

2035

1541

STOP SLAVE;

2036

1542

RESET SLAVE;

2037

1543

2079

1585

*** BUG 30434 ***

2080

1586

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

2081

1587

2082

SHOW SLAVE STATUS;

2083

Slave_IO_State #

2084

Master_Host 127.0.0.1

2085

Master_User root

2086

Master_Port #

2087

Connect_Retry 1

2088

Master_Log_File master-bin.000001

2089

Read_Master_Log_Pos #

2090

Relay_Log_File #

2091

Relay_Log_Pos #

2092

Relay_Master_Log_File master-bin.000001

2093

Slave_IO_Running Yes

2094

Slave_SQL_Running No

2095

Replicate_Do_DB

2096

Replicate_Ignore_DB

2097

Replicate_Do_Table

2098

Replicate_Ignore_Table

2099

Replicate_Wild_Do_Table

2100

Replicate_Wild_Ignore_Table

2101

Last_Errno 1072

2102

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)'

2103

Skip_Counter 0

2104

Exec_Master_Log_Pos #

2105

Relay_Log_Space #

2106

Until_Condition None

2107

Until_Log_File

2108

Until_Log_Pos 0

2109

Master_SSL_Allowed No

2110

Master_SSL_CA_File

2111

Master_SSL_CA_Path

2112

Master_SSL_Cert

2113

Master_SSL_Cipher

2114

Master_SSL_Key

2115

Seconds_Behind_Master #

2116

Master_SSL_Verify_Server_Cert No

2117

Last_IO_Errno #

2118

Last_IO_Error #

2119

Last_SQL_Errno 1072

2120

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)'

2121

1589

STOP SLAVE;

2122

1590

RESET SLAVE;

2123

1591

Older »