tag:blogger.com,1999:blog-3835820450680690950.post2372754152446530500..comments2024-03-06T18:26:21.212-08:00Comments on Firelit Design: How to fix MySql Replication Error 1236Erichttp://www.blogger.com/profile/04711486359505177802noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-3835820450680690950.post-46154787581058115052017-10-26T12:27:13.692-07:002017-10-26T12:27:13.692-07:00hi, so thanks so much, so much, much, tahnks for y...hi, so thanks so much, so much, much, tahnks for your post <br />Thanks so much for this AWESOME article! You saved my life! :-)Anonymoushttps://www.blogger.com/profile/11177794134994488716noreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-44477795859089213802017-04-20T02:04:25.650-07:002017-04-20T02:04:25.650-07:00Thanks from Brazil! Worked fine!Thanks from Brazil! Worked fine!Assunção, Erik.https://www.blogger.com/profile/05726813503820960694noreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-87826996568095262202015-06-19T05:26:46.155-07:002015-06-19T05:26:46.155-07:00edulanka, thank you! You made my day...
Error 12...edulanka, thank you! You made my day... <br /><br />Error 1236 can have various reasons, but when the reason is 'binlog truncated in the middle of event', solution provided by you works perfectly.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-79332647174326041592014-06-11T15:38:10.137-07:002014-06-11T15:38:10.137-07:00As a customer it works but as a DBA I must say tha...As a customer it works but as a DBA I must say that this wouldnt work as it should, you should see in the binlog whats wrongAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-81562701368475950952013-12-06T06:57:40.542-08:002013-12-06T06:57:40.542-08:00Thank you! It worked for me.
Thank you! It worked for me.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-12952050094155039352013-11-14T00:49:40.984-08:002013-11-14T00:49:40.984-08:00Dunno if it is a possible problem, but when settin...Dunno if it is a possible problem, but when setting MASTER_LOG_POS = 0 before changing MASTER_LOG_FILE, the actual position seems to be adjusted in relation to the old log file. Then when the log file is changed afterwards, that adjusted position is used and not the initially set position.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-46850944826586688572013-09-14T04:57:00.856-07:002013-09-14T04:57:00.856-07:00Done
Its works
Thanks
Got fatal error 1236 FRO...Done <br /><br />Its works<br /><br />Thanks<br /><br />Got fatal error 1236 FROM MASTER <br />WHEN reading DATA FROM BINARY LOG: <br />'binlog truncated in the middle of event; consider out of disk space on master; <br />the first event 'mysql-bin.000792' at 608112413,<br /> the last event read from './mysql-bin.000792' at 608112413, <br /> the last byte read from './mysql-bin.000792' at 608112640.'<br /> <br />STOP SLAVE;<br />CHANGE MASTER TO MASTER_LOG_FILE = 'mysql-bin.000793', MASTER_LOG_POS = 0;Anonymoushttps://www.blogger.com/profile/16351942396087795541noreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-41506211959473142152013-04-18T02:43:39.486-07:002013-04-18T02:43:39.486-07:00great post , thanks a lot great post , thanks a lot arammanhttps://www.blogger.com/profile/03712182751564828490noreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-14844956544968304892013-04-17T04:30:32.023-07:002013-04-17T04:30:32.023-07:00Excellent perfect!!Excellent perfect!!Shiv Chouarsianoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-17234402557813095932013-03-13T06:56:49.821-07:002013-03-13T06:56:49.821-07:00Excellent!
Thank you very much!
Saludos desde Ar...Excellent! <br />Thank you very much!<br /><br />Saludos desde Argentina!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-57230571107715722502012-12-26T19:23:43.673-08:002012-12-26T19:23:43.673-08:00Thank you!!Thank you!!Anonymoushttps://www.blogger.com/profile/08462788099684193184noreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-33845708261417105972012-12-26T07:04:34.336-08:002012-12-26T07:04:34.336-08:00Thank you Firelit,
This is very nice and good conc...Thank you Firelit,<br />This is very nice and good concept,I thought of doing the same when found the difference in slave status and master status but not having the knowledge of performing this,<br />This doc cleared concepts.Anupam Vishwakarmanoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-19053019643806166962012-10-17T05:16:25.418-07:002012-10-17T05:16:25.418-07:00nice!
Thank you so much!nice!<br /><br />Thank you so much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-41983547654513150602012-10-17T05:15:42.279-07:002012-10-17T05:15:42.279-07:00nice!
Thank you so much!nice!<br /><br />Thank you so much!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3835820450680690950.post-55743283982110815472012-01-05T23:44:27.242-08:002012-01-05T23:44:27.242-08:00Hey there
Thanks so much for this AWESOME article...Hey there<br /><br />Thanks so much for this AWESOME article! You saved my life! :-)Anonymousnoreply@blogger.com