DB errors - Migration to new server

[danewilson77]

Test


Sent from my iPhone using Tapatalk

[danewilson77]

OK. So...it's been a long 6 weeks or so dealing with Leaseweb but I think we're nearing the end of it. New server contract has been signed for a larger server. The site will be on CloudLinux OS Solo as the previous OS was extremely outdated.

The site has been migrated and tested and I think this will be resolved next week when the new site is published.

I'm very sorry for the frustration this may have caused and I appreciate the continued patience.

Do not hesitate to reach out with questions.

Have a great long weekend off guys.


Sent from my iPhone using Tapatalk

[pedro2u]

great news Dane. Enjoy your long weekend as well

[BADCLOWN]

OK. So...it's been a long 6 weeks or so dealing with Leaseweb but I think we're nearing the end of it. New server contract has been signed for a larger server. The site will be on CloudLinux OS Solo as the previous OS was extremely outdated.

The site has been migrated and tested and I think this will be resolved next week when the new site is published.

I'm very sorry for the frustration this may have caused and I appreciate the continued patience.

Do not hesitate to reach out with questions.

Have a great long weekend off guys.


Sent from my iPhone using Tapatalk



Appreciate the more detailed updates and transparency. Thank you!

[330i Lover]

Thanks Dane, hopefully it gets resolved soon and appreciate your involvement.

[danewilson77]

Test

[danewilson77]

Testing

[danewilson77]

And Testing again....

[danewilson77]

And once more...

[Oli77]

Thanks for the update and leadership Dane.

[///Mark_D]

TESTING!

https://www.youtube.com/watch?v=oCyXsHC-lQ4

[///Mark_D]

https://www.youtube.com/watch?v=oCyXsHC-lQ4

[danewilson77]

Guys.....I'm having the below done asap just to get it done. You may experience up to an hour of DT.

Fingers crossed.

Hello,

The next steps to complete the migration process will be switch the old IPs to the new server. These are the steps that will be performed during this process at the schedule time:

1. The latest data will be copied from the current server to the new server just before the switch.

2. The servers will be rebooted to switch the network interfaces on the VPS.

3. The cPanel settings will be configured on the new server to match the IP and domain settings from the old server.

The process to switch over the old IPs to the new server takes about an hour to complete as the latest data will need to be copied to the new server. There is about 30 minutes of downtime for the sites during the process when the IPs are being switched and updating of the cPanel settings. I will be performing these changes on my end to the server configurations and you do not need to make changes to the new IP as it will not be in use after the switch.

Please let me know if you are ready to proceed with these changes or schedule them at a specific time. I will be able to perform these steps any time between Monday to Friday 9AM to 6PM regular EDT.

Best regards,

Victor Sumin Advanced Services department USA.

[danewilson77]

Please use this thread (as long as it shows on the new server) to communicate any waning DB error issues.

Thank you

[dpark]

Works great on Chrome. Nice to not have to use Firefox to get the site to load properly. Nothing against FF, but at work we use Chrome because we are a Google Suite company.

[danewilson77]

Good to hear. I do not think the site has moved to the new server yet.

[danewilson77]

Migration to new server will occur later this afternoon. I will try to give you a heads up just prior to, if I'm able to.

[danewilson77]

The IP switch is now completed and the server is booted. I am updating the cPanel settings on the new server to configure the old IP and the site will be online shortly. I will keep you updated with the progress

The sites are now resolving from the new server and the migration is completed. There are a few things I am checking to finish up the migration and I will update you further.

[cakM3]

Awesome job following up Dane, thanks!!! :thumbs

[danewilson77]

I'm getting 404 page not found error. Maybe transfer in progress?


Sent from my iPhone using Tapatalk

[Oli77]

Tapatalk does not appear to be up-to-date.

Not getting errors though (within Tapatalk), just empty areas.

[Oli77]

nvm I was not logged into tapatalk. it is working now.

[danewilson77]

OK. I think we're out of the woods. Migration complete.

Continue to let me know of issues.

[fredo]

OK. I think we're out of the woods. Migration complete.

That's great news. Thank you!

[PdZHP]

Finally, thank you!

[fredo]

I'm getting sporadic DB errors. Most recent one was today (6/11) around 4 PM CST.

If this helps: I'm on Windows 10 with MS Edge browser.

[Oli77]

Just got one as well, ~8:15 PM Eastern Time.
Running Windows 10 Enterprise running duckduckgo browser.

[Galapolis]

Got a few on Windows 11 and MacOS as well, both Firefox. Seems to be working again though.

[danewilson77]

Yep. They've have some bum in the road but it seems like they've been quick to resolve.

[pedro2u]

Dane - not sure if it's just me, but there have been numerous times over the last week or so that the site has been unavailable. Not sure if that's expected or if its happening to others. When it's not working, I've tried my iPhone (chrome), and both Google Chrome and Bing on my desktop and the site is dead on all of them.

I've got some screen shots of it from this morning, but I couldn't post them because something has happened to my permission settings?

You may not post new threads.............BB code is On
You may post replies..........................Smilies are On
You may not post attachments.......[IMG] code is On
You may not edit your posts...........[VIDEO] code is On
HTML code is On

[fredo]

Same here. I keep getting sporadic errors on my iPad and laptop.

Today, I'm on Windows 10 with MS Edge browser. I can't post pics because the "Insert Image" button is only allowing images from an URL. :dunno

[pedro2u]

same here Fredo. The "manage attachments" feature is missing from the advanced reply feature

[pedro2u]

so how did Washburn just post an image of his floormats????

[Galapolis]

Been getting the same errors and can't upload images either.

Not sure if it's connected to this but have we considered moving to XenForo? Seems most forums these days are ditching vBulletin.

[fredo]

same here Fredo. The "manage attachments" feature is missing from the advanced reply feature

Very interesting. I posted a pic 2 min ago, but I can't anymore.

https://www.zhpmafia.com/forums/showthread.php?18267-Fredo-s-CL-findings&p=620661#post620661

[BADCLOWN]

Still periodically can't get in the site, after an unspecified amount of time, I regain access.


Additionally, I am getting a database error when I attempt to "post a new thread" in the FS section. This is all occurring on safari/mac/iphone

[Galapolis]

Same here, I would seriously suggest looking into Xenforo...

[FastAlpine]

I am a new member and thought maybe something was wrong with my membership but it appears to be a database issue. I will continue to monitor it and post a new member welcome once I can.

[BADCLOWN]

Still can’t post a new parts FS thread due to database error

[Galapolis]

Can't access PMs or settings either.

[BADCLOWN]

Couldn’t access the site at all last night

[BMWCurves]

Same, still very unstable connection

[BADCLOWN]

Multiple database errors, couldn’t get on this morning.

Any of the admins care to provide some insight here? Crickets.

[BADCLOWN]

STILL can’t post in the classifieds

[pedro2u]

I was going to post a screenshot of the "This page isn't working" error that I still get multpile times every day - but this thread still doesn't allow me to add attachments???

So I figured I'd start a new thread and post it there! But when I try to "Post New Thread" in the General Forum so I can attach that image, I get the data base error. I can't post a screenshot of that either, so here's a copy & paste. Please note that apologize is spelled wrong in the error response.......


Database Error

The BMW E46 330 ZHP For Sale Forum | 330i/Ci BMW ZHP Performance Package database has encountered a problem.

Please try the following:


Load the page again by clicking the Refresh button in your web browser.
Open the www.zhpmafia.com home page, then try to open another page.
Click the Back button to try another link.


The www.zhpmafia.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[pedro2u]

or apologise is the UK version. Which we can live with. I "apologize" :facepalm

[fredo]

Rando says they opened a ticket this morning (7/16) and are waiting to hear back. :thumbsup

[danewilson77]

Test

[danewilson77]

Guys,

I've been working this issue with Leaseweb for ______ weeks(insert number) and I keep getting the running around (or at least that's how I feel). Becoming very frustrating.

Know that I am working this in the background, even though I may not have time to post in here.


I'll continue to look into their "suspicious IP address" claim

-------------------------------------------------------------------------------------------------

Greetings,

This is an update regarding your request.

We have replicated the website error you reported.

After restarting the MySQL process, the website is now loading correctly on our end. Please see the attached screenshot for reference.

Additionally, we observed that the server load is high. Please refer to the snippet below:

=== ~]# w 15:55:59 up 5 days, 21:29, 0 users, load average: 57.22, 47.08, 28.45 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT ===

Upon reviewing the logs, I noticed that the issue was caused by a high number of hits. Here are the relevant entries from the Apache access logs:

=== 17516 /home/zhpmafia/access-logs/zhpmafia.com:47.76.99.127 17626 /home/zhpmafia/access-logs/zhpmafia.com:47.76.209.138 17864 /home/zhpmafia/access-logs/zhpmafia.com-ssl_log:47.76.209.138 18206 /home/zhpmafia/access-logs/zhpmafia.com-ssl_log:47.76.99.127 ===

Can you please review the IPs from your end and let us know if there are any suspicious IPs so that we can block the IPs in the server firewall for you.

Now the server load appears to be normal and operating at normal values. Please refer to the below snippet: === ~]# w 16:25:36 up 5 days, 21:58, 0 users, load average: 1.57, 7.69, 13.47 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT ===

Kindly review this and if you need any further assistance, please don't hesitate to reach out to us.

----- Kind regards,

Jenny Wilkinson Customer Care USA
I appreciate everyone's patience and I hope I can get this resolved (like really resolved).

[danewilson77]

And more............

Greetings,

Thank you for sharing the screenshots regarding the issue with the database.

We understand your concerns regarding the issue. As mentioned in our previous reply, in order to investigate further, we kindly request your permission to repair and optimize the database to see if that resolves the issue.

Please note that we are requesting this permission because there may be a temporary slowdown in the performance of the sites on the server during this process. Therefore, we kindly seek your approval before proceeding.

Please inform us whether we can proceed with repairing the database now, or specify the exact date, time, and timezone if you prefer us to schedule it for off-peak hours.

Awaiting your response.

Thank you!

----- Kind Regards,

Stephen Diaz Customer Care USA

[danewilson77]

Couldn’t access the site at all last night

When you say "access" to be clear.....you weren't able to even log in or "access" the site?

[BADCLOWN]

The site wouldn’t even pull up, I was getting errors. Main page wouldn’t even load and I see that pretty routinely.


Thanks for the update Dane, sorry if the posts came off bitchy but I thought the issue(s) were resolved so my apologies. Again, it’s appreciated whatever effort is being put in to remedy the problems.

[Galapolis]

As of right now, it seems that all functions are back online.

[BADCLOWN]

I can generate a FS ad in the classifieds so at least that is working again (for me)

[Oli77]

Seems to be working!

[danewilson77]

OK. Thanks guys.

New update. Again....let me know of any issues. Thank you

Greetings,

This is an update regarding your request.

Upon checking the databases, we found that one of the tables was marked as crashed. Here is a snippet for your reference:

==== zhpmafia_zhpforum.filedata Error : Table './zhpmafia_zhpforum/filedata' is marked as crashed and last (automatic?) repair failed Error : Table 'filedata' is marked as crashed and last (automatic?) repair failed error : Corrupt ====

Furthermore, we have repaired and optimized the databases for you. Prior to the repairs, the Article section for the domain was showing a database error, as mentioned in our previous response.

After repairing and optimizing the database, we can confirm that everything is now loading properly without any issues. We have attached a screenshot for your reference.

Please check if you are still encountering any database errors on your end. If you continue to face issues, kindly provide us with a screenshot of the error and a detailed description of the steps you followed to encounter the error. This will help us replicate and address the issue on our end

Kindly check and verify these details on your end and let us know if you require any further assistance.

----- Kind Regards,

Stephen Diaz Customer Care USA


Sent from my iPhone using Tapatalk

[pedro2u]

Dane

Understand the frustration and appreciate the effort.

I've been waiting to be able to attach an image that shows the error we get when the site is not available! So just tried again here, and unfortunately this particular thread doesn't show the "Go Advanced" button (?), so that you then go to "Manage Attachments"

I do see Go Advanced in other threads though.

???????

Pete

[danewilson77]

Checking..........

[BADCLOWN]

From 1000 to at least 1100 hours this morning (last time I checked until now), I couldn’t access the site at all same “database errors” message

[pedro2u]

Dane - FYI

site has been down (site not working message) all morning here and just came back up

[danewilson77]

The latest

Greetings,

This is an update regarding your request.

We have escalated your ticket to our Advanced Services department for further review.

As soon as more information becomes available you will be informed.

In the meantime if you require any assistance from our Customer Care team please let us know by replying to this ticket.

----- Kind regards,

Ethan Thompson Customer Care USA


Sent from my iPhone using Tapatalk

[danewilson77]

Test

[danewilson77]

40292

[BADCLOWN]

That’s a nice Ford GT

[Oli77]

testada

[BADCLOWN]

Had the same database error/couldn’t access the site issues this morning

[Fried_Chicken]

This site went offline for me for a while, and had spotty reliability for something like the last half year;

Is it working again?

[BADCLOWN]

No it’s not, last few days I love had moderate periods of time where I can’t access the site at all. Still continuing

[BADCLOWN]

Site was inaccessible a lot today, now is the first I’ve been able to get on

[danewilson77]

Test

[danewilson77]

Test

[CoastalJay]

Seems okay right now. Thanks for working to stabilize!


Sent from my iPhone using Tapatalk

[BADCLOWN]

Site still continues to be down occasionally

[Oli77]

I concur, whenever it does, its usually back up in a few minutes.