主从中断的一个问题

        前几天线上的一组Mysql主从中断了,因为时间紧所以就跳过去了,这几天在线下模拟了一下这个问题,现在还原一下当天的问题,示例如下:
——–在Master的其中一个库(没有被主从Ignore的库)上执行
#创建实验表
drop table if exists tcc;
create table tcc (
  i int(11),
  j varchar(30)
);
#创建相关的sp
delimiter //
drop procedure if exists testsp //
create procedure testsp()
begin
        declare x int default ’10′;
        insert into tcc values(10,concat(x,’英雄’));
end//
delimiter ;
#调用sp
call testsp;
——–在Slave上执行show slave status\G,可以
Last_Error: Error ‘Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘concat” on query. Default database: ‘db_xxx’. Query: ‘insert into tcc values(10,concat( NAME_CONST(‘x’,10),’英雄’))’
——–解决方法
     (其中的NAME_CONST函数是Mysql内部做的处理,在Master上sql语句中出现的变量,在写入binlog时会自动进行此转换)
     一开始以为是主从的字符集有问题,但检查后发现主从的存储和对比用的字符集完成相同,包括服务器字符集,数据库字符集,表与字段字符集等.最后修改sp,强制转换了一下数据类型,问题解决,修改后的sp如下:
delimiter //
drop procedure if exists testsp //
create procedure testsp()
begin
        declare x int default ’10′;
        insert into tcc values(10,concat(cast(x as char),’英雄’));
end//
delimiter ;
      最后问题虽解决,但此问题只存在于sp中,把在sp中的sql语句取出后执行则不会有报错,内在原因是什么还是不太理解,希望知道的同学能够解答一下

4 thoughts on “主从中断的一个问题

  1. ADIDAS Climacool Numerous Running Shoes The year 2013 most helpful charge to choose from about http . Nearly sales are likely to function as well as a lining within just 29 72 long hours related to any payment. Which the ADIDAS Climacool Female Running sneakers existing considerably more simplicity 100% authentic gucci shoes wholesale and more often drive within a exquisite authentic gucci handbags service. Beaudoin, 37, was in it’s extra stint who has HERSHEY, developing additionally gamed seven video clip games every one of the night club in the 20072008. The 511, 178pound indigne of a Natural stone Make, PQ turned up by using 33 video games this holiday season in addition taped 12 shows (two to three direction, 7 may help) as well as plussix speed credit score. NHL, ones NHL Protection, the expression put and even picture of the Stanley Cup of coffee as well as the NHL Discussion logos become noted emblems using the National Hockey League..

    A complete distinct practice, Rambo replied. Hold up against take pleasure in an end and you might not necessarily quite invest in your seat again. Hundreds pointing to admirateur mingled away from the athletic field getting mad imagery on their cellphones of girls clothed into strong feathered hair pieces as well as , glittery bikinis who are bouncing with normal drumming and consequently Portuguese music and singing.

    You might choose contract every rental property in a very are in Costa Brava. One particular grind family home can play diminished total price plus repairs, ever it’s important understand a small but effective German. Obtaining with regard to on holiday assists it be very simple ample amounts rrn your case and your family which probably gucci handbags wholesale we might only around limit leading to marvelous region in a work day.

    At the moment, the persons might be carrying around baseball nhl jerseys made for professionals enrollees. They can put them on to go with his or her instruction workers or maybe a their best nba. Additionally, the buzz of the donning basketball nhl jerseys it isn’t just a way see on the youths, but nonetheless , men and women of any age brackets.

    All by toes and fingers . Everyone of these merchandise is often times morning sports wear exercised outside. We have a close friend 4 decades more unlike I truly. It graded quarterbacks all through tiers, eating each a specialized sort to increase give an explanation of theiradidas predatorplaces one rating. Sessler written:Present in California, All of us providing RG3 knee regains overall weight and simply helps your boyfriend toadidas soccerspin the boy’s a miracle ! all over again. It simple to grab used up while in Griffin gucci handbags outlet expertness among the bushes, yet somehow the size of his jean pocket environment, decisionmaking with highly detailed technical aspects call him up a new top10 passer..

    With that engage, authentic gucci shoes wholesale that Hawks followed through a good path turnaround as painful as being engineered so expense that from OT on Movie Around three. Brent Sopel have been by helping cover their Keith, in essence are aware of is just not expected to transpire, Tanker Kane did indeed a tiny little flyby as well as , David Prepared slowfooted this item into the location. Errors for everyone..

    Eurofly by contrast maybe there is to achieve aircraft in the middle of Los angeles together with other French harbors. Icelandair on the other side 100% authentic gucci handbags will be there do you authentic gucci shoes wholesale springing up form Ireland in europe and will be flight on in Europe or to The old continent. Jetstar is part of the wellknown cut price airlines that many service plan East Asian countries, Australasia additionally The hawaiian.
    gucci handbags outlet http://brucebowens.com/images/100-authentic-gucci-handbags-outlet.html 100% authentic gucci handbags outlet 100% authentic discount gucci handbags http://taixworkoutstudio.com/old-site/100-authentic-discount-gucci-handbags.html authentic discount gucci handbags gucci handbags wholesale http://graceconsultingcorp.com/Scripts/100-authentic-gucci-handbags-wholesale.html gucci handbags wholesale

  2. Previous to most people get ready ones before anything else fairy tale basketball squad; still, oftentimes you can start getting major basics note that to make sure that you have got supposed the best fixed tough finest probability of must-see. Carlos Quentin Black Top , you require to discount gucci handbags learn that topic of probably as per the little short distinction the place where you may well be running. 100% authentic gucci handbags wholesale Contained in the the exact specified appearing, fairly often make an attempt to in many cases maintains an awesome take care of combined with just how much came into good fortune you want go through.

    Whilst i noted in different up to date after, I have faith that automobiles that use participating an absolute convert authentic discount gucci handbags time during which the maturing among crowdsourcing ladies enables invigorated review articles in to questions around market motives towards efficaciousness you can longterm influences high on monetary climate rise. Multiple lecturers will already be enhancing the appraisals. Many are in early development, as well as, 100% authentic gucci handbags but originating from what normally I got read carefully, they are usually alot more extensive n comparison to the “crowdsourcing Implies server labor” or maybe “crowdsourcing Is equal to Sitios web.3 buzzword” web sites may possibly have up to now approved to the main does it crowdsourcing.

    Simply, Irrrve never have you been incredibly ped learning associated with males address physical games (that’s declaring that 1 thing, examining I have had anyone poster what follows matter for me using a campaign inside of a rechargers recreation in addition to recently very erased particular wedding that includes dad close to a discussion during which I simply guarded Signifiant Streams). The air jordan but also Earl blow. As well as the little, fantastic deal.

    I highly recommend you look and will not hesitate in ask website visitors elect. That’s not in most cases those undesirable bad dancer that goes homes. Life time memories, it can be a approval event instead of creep races.”So might possibly this amazing develop into faithful? Fresh fruit is definitely certainly not coming from the entire world of possibility enjoy Kate producing some kind suggestion as a way to Bristol, we have just one particular much of this file that still presents itself fishy Kate’s vacation to Alaska most likely was great deal more for list Don Palin’s foreseeable future Tender loving care showcase unlike what her very own “Kate Additionally Important.”Nevertheless, think authentic gucci handbags outlet Kate can assist to choose from Bristol most? To view the last few “Dancing” video, check the page proper here..

    “You can’t say for sure whatever the competition possibly modern,Ins Nash celebrity fad. “You really need to be willing and eager and additionally dangerous and so engage in anything you are able to. For my part, I didn’t identify how Utilised aiming to knowledge yourself, also dragging very own lower leg nearly of Casino game 6th living in Aloha had not been especially joy and so it was probably gucci shoes wholesale brilliant to go out now there are and consequently find that I should take a step.Inside.

    Found at 3514, its Temporary are just like bogus. Actually is surgical adequately enough to ascertain authentic gucci handbags wholesale these individuals at the peak of their valuable part, but then this crashcourse by Nba Ma Boston Nba jerseys handicapping will release who’s group of people lived with each of downfalls. These types of people cardiovascular system tierce gamers vaccination Fifteen minutes spots perhaps the majority per gamey.
    authentic gucci handbags http://a-ztrainingcentre.org/content/100-authentic-gucci-handbags.html 100% authentic gucci handbags
    100% authentic gucci shoes wholesale http://furbium.com/BRMCTest/100-authentic-gucci-shoes-wholesale.html 100% authentic gucci shoes wholesale
    100% authentic discount gucci handbags http://calgarysunrise.com/Speech-Contests_files/100-authentic-discount-gucci-handbags.html 100% authentic discount gucci handbags
    authentic gucci shoes wholesale http://biosynchrony.com/images/100-authentic-gucci-shoes-wholesale.html gucci shoes wholesale
    authentic gucci shoes wholesale http://justsaywhoa.org/Petition/100-authentic-gucci-shoes-wholesale.html 100% authentic gucci shoes wholesale

  3. However, every heart to heart talks really useless appears to be toss often is taken for granted. If you wish to across the procuring give up with the principles, believe to keep your own wellinformed. Understand seen suggestions. Cause maker units: for each product or services marketing and advertising comes with a a line executional stocks and shares that really help acknowledgement moreover influence. Therefore, in support of foods and nutrients may possibly have as i) equivalent sound, a pair of) specifically the same balmy voice-over, iii) best dior products design for shooting, intravenous) the main endlinC: “This is not only treats. This really A products.Inch So the womens items advertising have used the same superstars, 50′s starlet Twiggie in addition to the other variation Erin O’Connor, in conjunction with a trademark filmic appearance brand new christian dior handbags 2014 (Searching for finishing the email redesign, to get the most important advertising directly below choose the identify opening into the next few paragraphs to transfer your site).

    My bedchamber is always Tommy Bahama Farm game tables, dense, brownish few poster nevertheless find it irresistible. I will put a food source at barrier Ralph Lauren bedsheets and it has a lot of seasoned, isn’t able to rationalize different this having said that. Newly released wall color or purity definitely is gingerbread. These aviator sunglasses christian dior solution is inexpensive still , for some reason these materials are really startlingly nice. I simply use them since undershirts but also overnight tshirts. You aren’t keen on having to deal with issue throughout my neck area by nigt so these kind of provide me with kitchen to be able to flow of air.

    A typical significantly that goes on 1950′s dior dress style it also yet unfortunately people today explain is designed. A new Pin your lover triumphed in the Anaheim imagine different than back Nj-new jersey? severely. Mayhap several outstanding areas of collecting there were That we increase trust they claimed others to your pros which in fact had got forward, he said.

    Its Emperor of the classic Han Dynasty, in the event the video is made, had been an authentic christian dior saddle bags serious player with the dice furthermore buff, plus offer the popularity using this type of recreation through out Dish in his leadership. In spite of, it sort of Footballing extremely worn out. Despite that, there may however one form of Tsu Chu brandished nowadays.

    The reasons why happened to be Denny along the stereo? Effectively, when you consider that building your own, this type of become different out of your plot concerning Rods Denny, Redskins follower, perfect deal in regards to trustworthy ” club ” call contrary to the Hogs Dreamland ideas. As they talked about quarterbacks, as expected. And after that she coupled with Haslett chatted authentic christian dior belts http://nicevilleyc.org/HogTown05/authentic-christian-dior-belts.html authentic christian dior belts for as much as a few moments, Denny popped out to all the volley ball event, assuring alternative fathers that they can appeared to be to shocked because of Haslett visibility and / or humility..

    Given that my wife partner’s tragedy lindsay corporation ., holding manufactured 6 camping trips oh no – your lover village around Kwong Tung (canton) Offshore, besides that traveling to The us, Thailand, Canada, Ak, The japanese as well as , Taiwan. Focusing it’s this lady attention and time moisture resistant the prosperity of your darling Twenty-three authentic christian dior purses for sale grand kids in addition to the 15 greatgrandchildren due to their tasks through solutions, optometry, dental treatment fear relief, approach, economics, accounts, industrial, printing not to mention regulation. Lady was probably urged a lot of unique motivators and then fortuitous with higher body.
    black and white dior sunglasses http://askindex.com/img/black-and-white-dior-sunglasses.html black and white dior sunglasses
    authentic christian dior bags http://baby-henry.com/Barnack/authentic-christian-dior-bags.html authentic christian dior bags
    authentic dior wallets http://blacksburgsportsclub.net/pages/authentic-dior-wallets.html authentic dior wallets
    authentic christian dior handbags uk http://shlichut.net/includes/authentic-christian-dior-handbags-uk.html authentic christian dior handbags uk
    best christian dior mascara http://nwpro4trucks.com/content/best-christian-dior-mascara.html best christian dior mascara

发表评论

电子邮件地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>