XF 2.2 Can a long-running browser job be interrupted and run via CLI instead?

[djbaxter]

I started an update of master templates on a rather large forum late Thursday night I think and most completed successfully.

However, this portion has been running for two days and making very slow progress:

Importing... Master data (Phrases: 6.6%)

Is there a way for me to interrupt/terminate the browser job and complete the job via CLI?

If so, what is the correct CLI command to do this?

 

[imno007]

cmd.php xf:rebuild-master-data

 

[djbaxter]

Actually from cPanel Terminal I had to cd to public_html and then run this:

php cmd.php xf:rebuild-master-data

 

[djbaxter]

Well the CLI also timed out on phrases.

 

[djbaxter]

Can you cancel a job? I don't need the phrases updated.

 

[Mike]

See:

Fixed - Upgrade taking many hours (phrase import)

So far it's been running for 4 hours and I'm at "Importing... Master data (Phrases: 4.4%)" and looks to be taking around an hour for each %. Is this something others have experienced? Did the upgrade via the button in the admin panel.

xenforo.com

It is likely you’re running into a MariaDB regression (currently thinking).

 

[djbaxter]

Not sure what you mean by that, @Mike
It is running MariaDB but I'm not seeing any of the reported problems with the recent upgrade and as far as I can tell it was not auto-upgraded - same version we've been running for more than a year.

Current Version​

MariaDB 10.3.26

 

[Paul B]

- same version we've been running for more than a year.

10.3.26 was released 3 November 2020.

MariaDB 10.3.26 Release Notes

Status: Stable (GA) | Release Date: 3 Nov 2020

mariadb.com

 

[djbaxter]

Oh. I'm losing it. Need. More. Sleep.

What's the fixed version?

 

[Paul B]

Downgrade to 10.3.25.

 

[djbaxter]

There is apparently an autofix script released by cPanel, released on Nov 6:

/scripts/autorepair fix_mariadb_show_grants_roles

Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offline." ...

support.cpanel.net

Has anyone tried this?

 

[Mike]

I've also included workaround code in the open report:

Fixed - Upgrade taking many hours (phrase import)

So far it's been running for 4 hours and I'm at "Importing... Master data (Phrases: 4.4%)" and looks to be taking around an hour for each %. Is this something others have experienced? Did the upgrade via the button in the admin panel.

xenforo.com

 

[djbaxter]

@Mike thank you for that. I had missed your post in the other thread.

I made those edits and of course I now have a warning from File Check.

I'll do a search but is there an easy way to keep the edits but get rid of that File Check alert?

 

[Paul B]

is there an easy way to keep the edits but get rid of that File Check alert?

No.

Just ignore it - you know you patched that file.

 

[djbaxter]

Thank you.

 

[Ozzy47]

I'll do a search but is there an easy way to keep the edits but get rid of that File Check alert?

Maybe not necessary in this situation, but there is my paid addon,

[OzzModz] Ignore Files From Health Check

At times we might need to edit core or addon files. The issue is that we are plagued with the dreaded file health check results showing up on the ACP index. Well this addon solves that. Now if you have edited a file, you can add it to the ignore...

xenforo.com