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. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. This article seems really amazing! Many thanks for giving this useful knowledge. Best CA Coaching Centers in Hyderabad

    ReplyDelete
  10. Good article. Reading your blog was a genuine pleasure. Others will find that useful.
    Hello everyone! We offer training in development as well as placement courses.
    Analyse that location and give this time.Best CA Coaching Centers in Hyderabad



    ReplyDelete