Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Percona Discussion
Message from discussion Problem of " Invalid (old?) table or database name"

View parsed - Show only message text

Received: by 10.43.63.5 with SMTP id xc5mr16353icb.19.1344428565938;
        Wed, 08 Aug 2012 05:22:45 -0700 (PDT)
X-BeenThere: percona-discussion@googlegroups.com
Received: by 10.50.157.164 with SMTP id wn4ls5912115igb.0.canary; Wed, 08 Aug
 2012 05:22:45 -0700 (PDT)
Received: by 10.50.12.234 with SMTP id b10mr289563igc.1.1344428565038;
        Wed, 08 Aug 2012 05:22:45 -0700 (PDT)
Received: by 10.50.150.202 with SMTP id uk10msigb;
        Tue, 7 Aug 2012 20:35:41 -0700 (PDT)
Received: by 10.66.77.39 with SMTP id p7mr2092285paw.0.1344396941530;
        Tue, 07 Aug 2012 20:35:41 -0700 (PDT)
Received: by 10.66.77.39 with SMTP id p7mr2092284paw.0.1344396941511;
        Tue, 07 Aug 2012 20:35:41 -0700 (PDT)
Return-Path: <wangheng.k...@gmail.com>
Received: from mail-pb0-f49.google.com (mail-pb0-f49.google.com [209.85.160.49])
        by gmr-mx.google.com with ESMTPS id vv9si2740735pbc.2.2012.08.07.20.35.41
        (version=TLSv1/SSLv3 cipher=OTHER);
        Tue, 07 Aug 2012 20:35:41 -0700 (PDT)
Received-SPF: pass (google.com: domain of wangheng.k...@gmail.com designates 209.85.160.49 as permitted sender) client-ip=209.85.160.49;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of wangheng.k...@gmail.com designates 209.85.160.49 as permitted sender) smtp.mail=wangheng.k...@gmail.com
Received: by pbbrq13 with SMTP id rq13so731909pbb.8
        for <percona-discussion@googlegroups.com>; Tue, 07 Aug 2012 20:35:41 -0700 (PDT)
Received: by 10.68.196.193 with SMTP id io1mr33186486pbc.17.1344396941234;
        Tue, 07 Aug 2012 20:35:41 -0700 (PDT)
Return-Path: <wangheng.k...@gmail.com>
Received: from QT-Wangheng ([118.26.196.188])
        by mx.google.com with ESMTPS id pv8sm3171913pbb.25.2012.08.07.20.35.37
        (version=SSLv3 cipher=OTHER);
        Tue, 07 Aug 2012 20:35:40 -0700 (PDT)
Date: Wed, 8 Aug 2012 11:35:37 +0800
From: wangheng.king <wangheng.k...@gmail.com>
To: percona-discussion <percona-discussion@googlegroups.com>
Reply-To: wangheng.king <wangheng.k...@gmail.com>
Subject: Re: Re: Problem of " Invalid (old?) table or database name"
References: <a9332a09-5907-4672-8de1-20e5c398e...@nj2g2000pbc.googlegroups.com> <CAFHKPu97TCcXd8N-aJa4C5_4yDmDhq07UDnac-W2CppSHJJ...@mail.gmail.com> <2012080714234079848...@gmail.com>, 
	<CAFHKPu_UJPXYAUsKdC-QZs6MX0T956BJe=hA693Jpb7gOgQ...@mail.gmail.com>
X-Priority: 3
X-Has-Attach: no
X-Mailer: Foxmail 7.0.1.91[cn]
Mime-Version: 1.0
Message-ID: <201208081135343950...@gmail.com>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart422433434480_=----"

This is a multi-part message in MIME format.

------=_001_NextPart422433434480_=----
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: base64

RGVhciA6DQpUaGFua3MgTGF1cnluYXMgQml2ZWluaXMgLCBidXQgSSB0aGluayB0aGUgYnVnIzUx
MTgwIGlzIG5vdCB0aGUgc2FtZSBwcm9ibGVtLiBUaGUgZXJyb3IgbG9nIGFsd2F5cyByZXBvcnRz
IHRoZSB3YXJuaW5nIGxpa2UgdGhlc2U6IA0KMTIwNDEwICAyOjE1OjIxIFtXYXJuaW5nXSBJbnZh
bGlkIChvbGQ/KSB0YWJsZSBvciBkYXRhYmFzZSBuYW1lICcjc3FsNTc5MF8yZTg2XzE4NmUnDQox
MjA0MTAgIDI6MTU6MjEgW1dhcm5pbmddIEludmFsaWQgKG9sZD8pIHRhYmxlIG9yIGRhdGFiYXNl
IG5hbWUgJyNzcWw1NzkwXzJlODZfMTg2ZScNCjEyMDQxMCAgMjoxNToyMSBbV2FybmluZ10gSW52
YWxpZCAob2xkPykgdGFibGUgb3IgZGF0YWJhc2UgbmFtZSAnI3NxbDU3OTBfMmU4Nl8xODZmJw0K
DQpUaHJvdWdoIGFuYWx5c2lzIG9mIHRoZSBiaW5sb2csdGhlcmUgYXJlIHRocmVlIHN0YXRlbWVu
dHMgaW4gdGhpcyBwZXJpb2QuIHRoZSBzdGF0ZW1lbnRzIGxpa2UgdGhlc2U6DQoxLiAgICIgRFJP
UCBUQUJMRSBJRiBFWElTVFMgW1RFTVBfVEFCTEVfTkFNRV07Ig0KMi4gobBjcmVhdGUgdGVtcG9y
YXJ5IHRhYmxlIFtURU1QX1RBQkxFX05BTUVdIHNlbGVjdCBjb2wxLGNvbDIsLi4uIGZyb20gW1RB
QkxFX05BTUVdOyIgDQozLiChsGFsdGVyIHRhYmxlIFtURU1QX1RBQkxFX05BTUVdIGFkZCB1bmlx
dWUgaWR4X2NvbDEoY29sMSk7Ig0KDQpBbmQgdGhlIGRpZmZlcmVuY2UgZnJvbSBidWcjNTExODAg
aXMgdGhlIGVycm9yIGxvZyBuZXZlciByZXBvcnRzIHRoZSBpbmZvcm1hdGlvbiBsaWtlIHRoZXNl
Og0KPHJlc3VsdCAyIHdoZW4gZXhwbGFpbmluZyBmaWxlbmFtZSAnI3NxbDItNDk0Ny03MjM5MCc+
IGRvZXMgbm90IGV4aXN0IGluIHRoZSBJbm5vREIgaW50ZXJuYWwNCklubm9EQjogZGF0YSBkaWN0
aW9uYXJ5IHRob3VnaCBNeVNRTCBpcyB0cnlpbmcgdG8gZHJvcCBpdC4gDQoNClNvIEkgdGhpbmsg
dGhlcmUgYXJlIHNvbWUgb3RoZXIgcG9pbnRzIHRyaWdnZXJpbmcgdGhlIHByb2JsZW0uDQpUaGFu
ayB5b3UgdmVyeSBtdWNoIGFuZCBsb29raW5nIGZvcndhcmQgdG8gaGVhcmluZyBmcm9tIHlvdS4N
Cg0KDQoNCg0KSGVuZyBXYW5nDQpWYXlhIEJ1aWxkaW5nLCBTdXpob3UgU3RyZWV0LCBIYWlkaWFu
IERpc3RyaWN0LCBCZWkgSmluZywgQ2hpbmEuIDEwMDA4MA0KaHR0cHM6Ly9naXRodWIuY29tL0hl
bmdXYW5nLw0KRnJvbTogTGF1cnluYXMgQml2ZWluaXMNCkRhdGU6IDIwMTItMDgtMDggMTA6NDMN
ClRvOiBwZXJjb25hLWRpc2N1c3Npb24NClN1YmplY3Q6IFJlOiBSZTogUHJvYmxlbSBvZiAiIElu
dmFsaWQgKG9sZD8pIHRhYmxlIG9yIGRhdGFiYXNlIG5hbWUiDQpIZW5nIC0NCg0KPiBUaGFuayB5
b3UgZm9yIHlvdSBoZWxwLCBidXQgdGhlIGRlc2NyaXB0aW9uIG9mIGJ1ZyAjNTExODAgaXMgbm90
IHZlcnkNCj4gZGV0YWlsZWQuIEFuZCB0aGUgcmVwZWF0IHNpdHVhdGlvbiBzZWVtcyBub3QgdG8g
bWVldCBvdXIgcHJvYmxlbS4NCj4gMS4gICAiIERST1AgVEFCTEUgSUYgRVhJU1RTIFtURU1QX1RB
QkxFX05BTUVdOyINCj4gMi4gk2NyZWF0ZSB0ZW1wb3JhcnkgdGFibGUgW1RFTVBfVEFCTEVfTkFN
RV0gc2VsZWN0IGNvbDEsY29sMiwuLi4gZnJvbQ0KPiBbVEFCTEVfTkFNRV07Ig0KPiAzLiCTYWx0
ZXIgdGFibGUgW1RFTVBfVEFCTEVfTkFNRV0gYWRkIHVuaXF1ZSBpZHhfY29sMShjb2wxKTsiDQo+
DQo+IFBsZWFzZSBnaXZlIG1lIG1vcmUgZGV0YWlsZWQgaW5mb3JtYXRpb24gaW4gb3JkZXIgdG8g
Y29uZmlybSB0aGUgcHJvYmxlbSBpcw0KPiB0aGUgYnVnICM1MTE4MC4NCg0KVGhlIDUxMTgwICJI
b3cgdG8gcmVwZWF0IiBkb2VzIG5vdCBsaXN0IGFsbCB0aGUgd2F5cyB0byByZXBlYXQgdGhlDQpp
c3N1ZS4gSXQgaXMgZW5vdWdoIHRvIGhhdmUgYW4gb3BlbiB0ZW1wb3JhcnkgdGFibGUgKGNhbiBi
ZSBhbHNvIGFuDQppbnRlcm5hbCB0ZW1wb3JhcnkgdGFibGUsIHN1Y2ggYXMgZm9yIEFMVEVSIFRB
QkxFKSBhbmQgdGhlbiBkbyBhbnkNCm9wZXJhdGlvbiB0aGF0IGludm9rZXMgZXhwbGFpbl9maWxl
bmFtZSgpIGF0IG9uZSBwb2ludCBvciBhbm90aGVyLCBmb3INCmV4YW1wbGUsIGlzc3VlIFNIT1cg
RU5HSU5FIElubm9EQiBTVEFUVVMgaW4gb3RoZXIgdGhyZWFkLiBUaGUgaXNzdWUNCmhlcmUgaXMg
dGhhdCBleHBsYWluX2ZpbGVuYW1lKCkgaXMgbm90IGZ1bGx5IGNvbXBhdGlibGUgd2l0aCB0aGUN
CiIjc3FsLi4uIiBuYW1lcyB0aGF0IGFyZSBnZW5lcmF0ZWQgZm9yIHRob3NlIHRlbXAgdGFibGVz
LiBCdWcNCmh0dHA6Ly9idWdzLm15c3FsLmNvbS9idWcucGhwP2lkPTMyNDMwIG1pZ2h0IHByb3Zp
ZGUgbW9yZSBiYWNrZ3JvdW5kDQpvbiB0aGlzLg0KDQotLSANCkxhdXJ5bmFzDQp3d3cucGVyY29u
YS5jb20NCg0KLS0gDQpZb3UgcmVjZWl2ZWQgdGhpcyBtZXNzYWdlIGJlY2F1c2UgeW91IGFyZSBz
dWJzY3JpYmVkIHRvIHRoZSBHb29nbGUgR3JvdXBzICJQZXJjb25hIERpc2N1c3Npb24iIGdyb3Vw
Lg0KVG8gcG9zdCB0byB0aGlzIGdyb3VwLCBzZW5kIGVtYWlsIHRvIHBlcmNvbmEtZGlzY3Vzc2lv
bkBnb29nbGVncm91cHMuY29tLg0KVG8gdW5zdWJzY3JpYmUgZnJvbSB0aGlzIGdyb3VwLCBzZW5k
IGVtYWlsIHRvIHBlcmNvbmEtZGlzY3Vzc2lvbit1bnN1YnNjcmliZUBnb29nbGVncm91cHMuY29t
Lg0KRm9yIG1vcmUgb3B0aW9ucywgdmlzaXQgdGhpcyBncm91cCBhdCBodHRwOi8vZ3JvdXBzLmdv
b2dsZS5jb20vZ3JvdXAvcGVyY29uYS1kaXNjdXNzaW9uP2hsPWVuLg==

------=_001_NextPart422433434480_=----
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3DGB2312" http-equiv=3DContent-Type>
<STYLE>
BLOCKQUOTE {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
P {
	MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
BODY {
	LINE-HEIGHT: 1.5; FONT-FAMILY: =CE=A2=C8=ED=D1=C5=BA=DA; COLOR: #000080; =
FONT-SIZE: 10.5pt
}
</STYLE>

<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.17006"></HEAD>
<BODY style=3D"MARGIN: 10px">
<DIV>Dear :</DIV>
<DIV>Thanks <A href=3D"mailto:laurynas.bivei...@percona.com">Laurynas=20
Biveinis</A>&nbsp;, but I think the bug#51180 is not the same problem. The=
 error=20
log always reports the warning like these:&nbsp;</DIV>
<DIV>
<DIV>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; BACKGROUND-COLOR: transparent; FONT-VA=
RIANT: normal; FONT-STYLE: normal; TEXT-INDENT: 0pt; MARGIN: 0cm 0cm 0pt; =
PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PADDING-RIGHT: 0px; DISP=
LAY: block; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-POSITION: 0% 0%; FLOAT: =
none; LETTER-SPACING: normal; VISIBILITY: inherit; COLOR: rgb(0,0,0); CLEA=
R: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORDER-RIGHT: rgb(0,0,0)=
; TEXT-DECORATION: none; PADDING-TOP: 0px"><SPAN=20
style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPS=
E: separate; FONT: medium Tahoma; WHITE-SPACE: normal; ORPHANS: 2; LETTER-=
SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-hori=
zontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-de=
corations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-st=
roke-width: 0px"><SPAN=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"=20
lang=3DEN-US>120410&nbsp; 2:15:21 [Warning] Invalid (old?) table or databa=
se name=20
'#sql5790_2e86_186e'</SPAN></SPAN></P>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"></P>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; BACKGROUND-COLOR: transparent; FONT-VA=
RIANT: normal; FONT-STYLE: normal; TEXT-INDENT: 0pt; MARGIN: 0cm 0cm 0pt; =
PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PADDING-RIGHT: 0px; DISP=
LAY: block; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-POSITION: 0% 0%; FLOAT: =
none; LETTER-SPACING: normal; VISIBILITY: inherit; COLOR: rgb(0,0,0); CLEA=
R: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORDER-RIGHT: rgb(0,0,0)=
; TEXT-DECORATION: none; PADDING-TOP: 0px"><SPAN=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"=20
lang=3DEN-US>120410&nbsp; 2:15:21 [Warning] Invalid (old?) table or databa=
se name=20
'#sql5790_2e86_186e'</SPAN></P>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"></P>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; BACKGROUND-COLOR: transparent; FONT-VA=
RIANT: normal; FONT-STYLE: normal; TEXT-INDENT: 0pt; MARGIN: 0cm 0cm 0pt; =
PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PADDING-RIGHT: 0px; DISP=
LAY: block; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-POSITION: 0% 0%; FLOAT: =
none; LETTER-SPACING: normal; VISIBILITY: inherit; COLOR: rgb(0,0,0); CLEA=
R: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORDER-RIGHT: rgb(0,0,0)=
; TEXT-DECORATION: none; PADDING-TOP: 0px"><SPAN=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"=20
lang=3DEN-US>120410&nbsp; 2:15:21 [Warning] Invalid (old?) table or databa=
se name=20
'#sql5790_2e86_186f'</SPAN></P>
<P=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; BACKGROUND-COLOR: transparent; FONT-VA=
RIANT: normal; FONT-STYLE: normal; TEXT-INDENT: 0pt; MARGIN: 0cm 0cm 0pt; =
PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PADDING-RIGHT: 0px; DISP=
LAY: block; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-POSITION: 0% 0%; FLOAT: =
none; LETTER-SPACING: normal; VISIBILITY: inherit; COLOR: rgb(0,0,0); CLEA=
R: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORDER-RIGHT: rgb(0,0,0)=
; TEXT-DECORATION: none; PADDING-TOP: 0px"><SPAN=20
style=3D"LIST-STYLE: disc none outside; BACKGROUND-IMAGE: none; BORDER-BOT=
TOM: rgb(0,0,0); POSITION: static; TEXT-ALIGN: left; BORDER-LEFT: rgb(0,0,=
0); PADDING-BOTTOM: 0px; LINE-HEIGHT: normal; OVERFLOW-X: visible; OVERFLO=
W-Y: visible; TEXT-TRANSFORM: none; FONT-VARIANT: normal; FONT-STYLE: norm=
al; TEXT-INDENT: 0pt; PADDING-LEFT: 0px; BACKGROUND-ATTACHMENT: scroll; PA=
DDING-RIGHT: 0px; DISPLAY: inline; FONT-FAMILY: =CB=CE=CC=E5; BACKGROUND-P=
OSITION: 0% 0%; FLOAT: none; LETTER-SPACING: normal; VISIBILITY: inherit; =
COLOR: #333399; CLEAR: none; FONT-SIZE: 12pt; BORDER-TOP: rgb(0,0,0); BORD=
ER-RIGHT: rgb(0,0,0); TEXT-DECORATION: none; PADDING-TOP: 0px"=20
lang=3DEN-US></SPAN>&nbsp;</P></DIV></DIV>
<DIV=20
style=3D"COLOR: #333399">Through&nbsp;analysis&nbsp;of&nbsp;the&nbsp;binlo=
g,there&nbsp;are&nbsp;three=20
statements&nbsp;in&nbsp;this&nbsp;period. the statements like these:</DIV>
<DIV>
<DIV style=3D"COLOR: #000000"><SPAN=20
style=3D"COLOR: #333399">1.&nbsp;&nbsp;</SPAN><SPAN style=3D"COLOR: #33339=
9">=20
"</SPAN><SPAN=20
style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPS=
E: separate; FONT: medium Tahoma; WHITE-SPACE: normal; ORPHANS: 2; LETTER-=
SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-hori=
zontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-de=
corations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-st=
roke-width: 0px"><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; COLOR: #333399; FONT-SIZE: 16px">=
&nbsp;DROP=20
TABLE IF EXISTS [TEMP_TABLE_NAME];</SPAN></SPAN><SPAN=20
style=3D"COLOR: #333399">"</SPAN></DIV>
<DIV style=3D"COLOR: #000000"><SPAN style=3D"COLOR: #333399"></SPAN><SPAN=20
style=3D"COLOR: #333399">2. =A1=B0create&nbsp;temporary=20
table&nbsp;[TEMP_TABLE_NAME]&nbsp;select&nbsp;col1,col2,...&nbsp;from&nbsp=
;[TABLE_NAME];"=20
</SPAN></DIV>
<DIV style=3D"COLOR: #333399">3.=20
=A1=B0alter&nbsp;table&nbsp;[TEMP_TABLE_NAME]&nbsp;add&nbsp;unique&nbsp;id=
x_col1(col1);"<SPAN=20
style=3D"COLOR: #333399"></SPAN></DIV>
<DIV style=3D"COLOR: #000000">&nbsp;</DIV>
<DIV>And the difference&nbsp;from bug#51180&nbsp;is the error log never re=
ports=20
the information like these:</DIV>
<DIV><SPAN=20
style=3D"WIDOWS: 2; TEXT-TRANSFORM: none; BACKGROUND-COLOR: rgb(255,255,25=
5); TEXT-INDENT: 0px; FONT: 12px/19px Verdana, 'Lucida Grande', 'Lucida Sa=
ns Unicode', Tahoma, Arial, sans-serif; WHITE-SPACE: normal; ORPHANS: 2; L=
ETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-text-=
decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-=
stroke-width: 0px"=20
class=3DApple-style-span>&lt;result 2 when explaining filename=20
'#sql2-4947-72390'&gt; does not exist in the InnoDB internal<BR>InnoDB: da=
ta=20
dictionary though MySQL is trying to drop it.</SPAN>&nbsp;</DIV></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV>So I think there are some other points triggering the problem.</DIV>
<DIV>Thank you very much and looking forward to hearing from you.</DIV></D=
IV>
<DIV>&nbsp;</DIV>
<HR style=3D"WIDTH: 210px; HEIGHT: 1px" align=3Dleft color=3D#b5c4df SIZE=
=3D1>

<DIV><SPAN>
<DIV><SPAN>
<P style=3D"TEXT-ALIGN: left; MARGIN: 0cm 0cm 0pt" class=3DMsoNormal=20
align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: =
14pt"=20
lang=3DEN-US>Heng Wang<?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P style=3D"TEXT-ALIGN: left; MARGIN: 0cm 0cm 0pt" class=3DMsoNormal=20
align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: =
14pt"=20
lang=3DEN-US>Vaya Building, Suzhou Street, Haidian District, Bei Jing, Chi=
na.=20
100080<o:p></o:p></SPAN></P>
<P style=3D"TEXT-ALIGN: left; MARGIN: 0cm 0cm 0pt" class=3DMsoNormal=20
align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: =
14pt"=20
lang=3DEN-US><A href=3D"https://github.com/HengWang/"><FONT=20
color=3D#0000ff>https://github.com/HengWang/</FONT></A></SPAN></SPAN></SPA=
N></P></DIV></DIV>
<DIV=20
style=3D"BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOT=
TOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt s=
olid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<DIV=20
style=3D"PADDING-BOTTOM: 8px; PADDING-LEFT: 8px; PADDING-RIGHT: 8px; BACKG=
ROUND: #efefef; COLOR: #000000; FONT-SIZE: 12px; PADDING-TOP: 8px">
<DIV><B>From:</B>&nbsp;<A href=3D"mailto:laurynas.bivei...@percona.com">La=
urynas=20
Biveinis</A></DIV>
<DIV><B>Date:</B>&nbsp;2012-08-08&nbsp;10:43</DIV>
<DIV><B>To:</B>&nbsp;<A=20
href=3D"mailto:percona-discussion@googlegroups.com">percona-discussion</A>=
</DIV>
<DIV><B>Subject:</B>&nbsp;Re: Re: Problem of " Invalid (old?) table or dat=
abase=20
name"</DIV></DIV></DIV>
<DIV>
<DIV>Heng&nbsp;-</DIV>
<DIV>&nbsp;</DIV>
<DIV>&gt;&nbsp;Thank&nbsp;you&nbsp;for&nbsp;you&nbsp;help,&nbsp;but&nbsp;t=
he&nbsp;description&nbsp;of&nbsp;bug&nbsp;#51180&nbsp;is&nbsp;not&nbsp;ver=
y</DIV>
<DIV>&gt;&nbsp;detailed.&nbsp;And&nbsp;the&nbsp;repeat&nbsp;situation&nbsp=
;seems&nbsp;not&nbsp;to&nbsp;meet&nbsp;our&nbsp;problem.</DIV>
<DIV>&gt;&nbsp;1.&nbsp;&nbsp;&nbsp;"&nbsp;DROP&nbsp;TABLE&nbsp;IF&nbsp;EXI=
STS&nbsp;[TEMP_TABLE_NAME];"</DIV>
<DIV>&gt;&nbsp;2.&nbsp;=93create&nbsp;temporary&nbsp;table&nbsp;[TEMP_TABL=
E_NAME]&nbsp;select&nbsp;col1,col2,...&nbsp;from</DIV>
<DIV>&gt;&nbsp;[TABLE_NAME];"</DIV>
<DIV>&gt;&nbsp;3.&nbsp;=93alter&nbsp;table&nbsp;[TEMP_TABLE_NAME]&nbsp;add=
&nbsp;unique&nbsp;idx_col1(col1);"</DIV>
<DIV>&gt;</DIV>
<DIV>&gt;&nbsp;Please&nbsp;give&nbsp;me&nbsp;more&nbsp;detailed&nbsp;infor=
mation&nbsp;in&nbsp;order&nbsp;to&nbsp;confirm&nbsp;the&nbsp;problem&nbsp;=
is</DIV>
<DIV>&gt;&nbsp;the&nbsp;bug&nbsp;#51180.</DIV>
<DIV>&nbsp;</DIV>
<DIV>The&nbsp;51180&nbsp;"How&nbsp;to&nbsp;repeat"&nbsp;does&nbsp;not&nbsp=
;list&nbsp;all&nbsp;the&nbsp;ways&nbsp;to&nbsp;repeat&nbsp;the</DIV>
<DIV>issue.&nbsp;It&nbsp;is&nbsp;enough&nbsp;to&nbsp;have&nbsp;an&nbsp;ope=
n&nbsp;temporary&nbsp;table&nbsp;(can&nbsp;be&nbsp;also&nbsp;an</DIV>
<DIV>internal&nbsp;temporary&nbsp;table,&nbsp;such&nbsp;as&nbsp;for&nbsp;A=
LTER&nbsp;TABLE)&nbsp;and&nbsp;then&nbsp;do&nbsp;any</DIV>
<DIV>operation&nbsp;that&nbsp;invokes&nbsp;explain_filename()&nbsp;at&nbsp=
;one&nbsp;point&nbsp;or&nbsp;another,&nbsp;for</DIV>
<DIV>example,&nbsp;issue&nbsp;SHOW&nbsp;ENGINE&nbsp;InnoDB&nbsp;STATUS&nbs=
p;in&nbsp;other&nbsp;thread.&nbsp;The&nbsp;issue</DIV>
<DIV>here&nbsp;is&nbsp;that&nbsp;explain_filename()&nbsp;is&nbsp;not&nbsp;=
fully&nbsp;compatible&nbsp;with&nbsp;the</DIV>
<DIV>"#sql..."&nbsp;names&nbsp;that&nbsp;are&nbsp;generated&nbsp;for&nbsp;=
those&nbsp;temp&nbsp;tables.&nbsp;Bug</DIV>
<DIV>http://bugs.mysql.com/bug.php?id=3D32430&nbsp;might&nbsp;provide&nbsp=
;more&nbsp;background</DIV>
<DIV>on&nbsp;this.</DIV>
<DIV>&nbsp;</DIV>
<DIV>--&nbsp;</DIV>
<DIV>Laurynas</DIV>
<DIV>www.percona.com</DIV>
<DIV>&nbsp;</DIV>
<DIV>--&nbsp;</DIV>
<DIV>You&nbsp;received&nbsp;this&nbsp;message&nbsp;because&nbsp;you&nbsp;a=
re&nbsp;subscribed&nbsp;to&nbsp;the&nbsp;Google&nbsp;Groups&nbsp;"Percona&=
nbsp;Discussion"&nbsp;group.</DIV>
<DIV>To&nbsp;post&nbsp;to&nbsp;this&nbsp;group,&nbsp;send&nbsp;email&nbsp;=
to&nbsp;percona-discussion@googlegroups.com.</DIV>
<DIV>To&nbsp;unsubscribe&nbsp;from&nbsp;this&nbsp;group,&nbsp;send&nbsp;em=
ail&nbsp;to&nbsp;percona-discussion+unsubscribe@googlegroups.com.</DIV>
<DIV>For&nbsp;more&nbsp;options,&nbsp;visit&nbsp;this&nbsp;group&nbsp;at&n=
bsp;http://groups.google.com/group/percona-discussion?hl=3Den.</DIV>
<DIV>&nbsp;</DIV></DIV></BODY></HTML>

------=_001_NextPart422433434480_=------

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2013 Google