Thursday, 6 July 2017

Setting server system variable 'old_alter_table' back to '0'.

Error :-- MySQL Enterprise Backup version 4.1.0 Linux-2.6.39-400.215.10.el5uek-x86_64 [2017/03/01] Copyright (c) 2003, 2017, Oracle and/or its affiliates. All Rights Reserved.

170705 03:00:01 MAIN    INFO: A thread created with Id '140533386585920'
170705 03:00:01 MAIN    INFO: Starting with following command line ...
/arch03/MySQL_Backup/meb-4.1.0-linux-glibc2.5-x86-64bit/bin/mysqlbackup
        -u root -pxxxxxxx --no-locking
        --backup-dir=/backup/backup_full_3302/03hr_05_July_2017
        backup-and-apply-log

170705 03:00:01 MAIN    INFO:
170705 03:00:01 MAIN    INFO: MySQL server version is '5.7.16-enterprise-commercial-advanced-log'
170705 03:00:01 MAIN    INFO: MySQL server compile os version is 'linux-glibc2.5'
170705 03:00:01 MAIN    INFO: Got some server configuration information from running server.
170705 03:06:19 RDR1    INFO: Copying the database directory 'mysql'
170705 03:06:19 RDR1    INFO: Copying the database directory 'performance_schema'
170705 03:06:19 RDR1    INFO: Copying the database directory 'routeFinderBuildCircuitTable'
170705 03:06:19 RDR1    INFO: Copying the database directory 'routeFinderRouteValidation'
170705 03:06:19 RDR1    INFO: Copying the database directory 'routeFinderStatusReports'
170705 03:06:20 RDR1 Progress in MB: 46400 46600 46800 47000
170705 03:06:21 RDR1    INFO: Copying the database directory 'routeFinderTables'
170705 03:06:22 RDR1 Progress in MB: 47200 47400 47600 47800 48000 48200 48400 48600 48800 49000 49200 49400 49600 49800 50000 50200 50400 50600 50800 51000 51200 51400 51600 51800 52000 52200 52400 52600 52800
170705 03:06:38 WTR1 ERROR: Disk full while writing '/backup/backup_full_3302/03hr_05_July_2017/datadir/routeFinderTables/DvGtestT_C.MYI'
170705 03:06:38 WTR1    INFO: Requesting completion of redo log copy. Rapid: 1
170705 03:06:38 RLR1    INFO: Signaled '1' to complete log copy.
170705 03:06:38 RLR1    INFO: Signaled '1' to complete log copy.
170705 03:06:38 RLR1    INFO: Redo log reader waited = 395270.00 ms for logs to generate.

mysqlbackup failed with errors!
170705 03:06:38 MAIN    INFO: Setting server system variable 'old_alter_table' back to '0'. 



Issue :-- 170705 03:06:38 WTR1 ERROR: Disk full while writing '/backup/backup_full_3302/03hr_05_July_2017/datadir/routeFinderTables/DvGrptestT_C.MYI'

Setting server system variable 'old_alter_table' back to '0'.

Solution :--  Check server disk space where backup files generated & remove old files & start backup again  

13 comments:

  1. Fascinating post. I Have Been contemplating about this issue, so thankful for posting. Truly cool post.It "s genuinely incredibly charming and Useful post.Thanks buy cloud vps

    ReplyDelete
  2. Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers. USA RDP

    ReplyDelete
  3. It seems you are so busy in last month. The detail you shared about your work and it is really impressive that's why i am waiting for your post because i get the new ideas over here and you really write so well. good nice
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  4. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete

  5. May I just say what a solace to reveal someone who truly comprehends what they are talking about over the web. You unquestionably acknowledge how to uncover an issue and make it significant. More individuals should take a gander at this and comprehend this side of the story. I was shocked you're not more well known given that you assuredly have the
    blessing.
    best interiors

    ReplyDelete
  6. many functions like load balancing and resource dedication. However, this requires big, full of memory and space machines, which is problematic and most of the time unnecessary for small or medium businesses. best teamviewer alternatives

    ReplyDelete
  7. Download Password Hacker Fb APK for Android. Install the latest version of Password Hacker Fb APP for free. Password fb Hacker prank is a cool and just FB Cracker Online

    ReplyDelete
  8. Users can easily be configured tax rates and manage transaction records. The Latest version Tally ERP 9 Release 6.6.3 Serial Key is especially Tally ERP 9 Licence Key

    ReplyDelete
  9. Happiest birthday to the most dazzling, romantic, and dashing husband in the world. Your success, happiness, and prosperity are all that matter. Heaven Birthday Wishes

    ReplyDelete