URGENT : NEED TO RESTORE MYSQL- CLONED FARM DOESNT LOAD PROPERLY

Nir Ben-Dor's Avatar

Nir Ben-Dor

09 Aug, 2018 05:20 PM

Hi,
I need to urgently restore a table from a large database.
I cloned the farm and the mysql on the cloned farm does not seem to start
This is urgent !!!!!!!!!
I moved the mysql back files to the new farm so terminating is not an option (took long time)

Atrtaching dump file.

Its farm 25472 and 23473.

PLASE ADVISE ASAP

Thanks !!

  1. Support Staff 1 Posted by Igor Savchenko on 09 Aug, 2018 05:41 PM

    Igor Savchenko's Avatar

    Hi Nir,

    One of our engineers is looking into this.

    Regards,
    Igor

  2. Support Staff 2 Posted by Marat Komarov on 09 Aug, 2018 07:06 PM

    Marat Komarov's Avatar

    We've fixed Master initialization. The problems were caused by the following my.cnf options, that this mysql role was bundled with:

    1) default_time_zone = America/New_York causing mysql to die with

    180809 15:44:48 [ERROR] Fatal error: Illegal or unknown default time zone 'America/New_York'
    

    2) And ignore_builtin_innodb = NO, with incorrect boolean value, causing mysql_install_db to exit with

    180809 15:44:48 [Warning] option 'ignore_builtin_innodb': boolean value 'NO' wasn't recognized. Set to OFF.
    

    We kindly suggest testing that your mysql service is operational before bundling new image.

    Regards,
    Marat

  3. 3 Posted by Nir Ben-Dor on 09 Aug, 2018 07:11 PM

    Nir Ben-Dor's Avatar

    Thank you very much Marat and the team !
    I will check this more deeply
    Strange because this is a clone of operational farm.
    I dont think I changed the timezone setting and bundled..
    Strange.

    - Nir

  4. 4 Posted by Nir Ben-Dor on 12 Aug, 2018 09:39 AM

    Nir Ben-Dor's Avatar

    Hi Marat,

    The reason for the problem is that when I clone a farm, the mysql
    configuration doesn't get cloned.
    For example I cloned farm 22605 to farm 25479

    Please advise.

    - Nir

  5. Support Staff 5 Posted by Vitaliy Demidov on 13 Aug, 2018 02:14 PM

    Vitaliy Demidov's Avatar

    Hi Nir,
    We have identified the issue with Farm clone and are working on a fix.
    Thank you for the report.

    Cheers,
    Vitaliy Demidov

  6. 6 Posted by Nir Ben-Dor on 13 Aug, 2018 02:21 PM

    Nir Ben-Dor's Avatar

    Great. thanks !

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • scalarizr_debug-fd0fce3b-7b83-4153-aa20-e15715a8abc6_(1).log 567 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac