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  

12 comments:

  1. I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. Techno-based information has been fetched in each of your topics. Sure it will enhance and fill the queries of the public needs. Feeling so glad about your article. Thanks…!
    selenium training in chennai
    selenium online courses best selenium online training
    selenium testing training
    selenium classes

    ReplyDelete
  2. 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
  3. 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
  4. 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
  5. 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