Problems and Suggestions for BZ - Post Here Pinned

4951 replies · 732239 views

n
ntuser1
Posts: 137
#4201
 

 

DB corruption and the fact I was super swamped with other things I needed to take care of over the weekend, I could only get an hour or two to work on it per day so I could never resolve the issue

 

Last night I stayed up till 2am and got it working

 

Sorry everyone!

 

 

Are you using FastServ, at least as per the domain DNS history? I have a much better experience with OVH dedicated servers, faster links, stable service, and of course more cost effective option accounting for all the bandwidth and server speed. If you have any questions we can discuss. On OVH you could have a main, and a backup dedicated server, virtualized (vSphere), with full backups/redundancy and restore with a click of a button (accounting for the proper virtualization backup software). Not advertising OVH here, just offering technical advice

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4202
 

 

Corruption sounds bad.  What was the solution..restoring backups? 

 

Thank you for that, I was _almost_ starting to get worried!  

 

 

 

Yes, I spent too much time trying to isolate the bad table but ultimately just restored it from a previous nightly backup. So we lost ~1days worth of data but not the end of the world I suppose. 

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4203
 

 

Are you using FastServ, at least as per the domain DNS history? I have a much better experience with OVH dedicated servers, faster links, stable service, and of course more cost effective option accounting for all the bandwidth and server speed. If you have any questions we can discuss. On OVH you could have a main, and a backup dedicated server, virtualized (vSphere), with full backups/redundancy and restore with a click of a button (accounting for the proper virtualization backup software). Not advertising OVH here, just offering technical advice

 

We own our own servers and I have a backup server as well, but it was mostly I just didnt have enough time to fix the issue. Otherwise it would have only been a few hour outage. But thanks for the info. 

W
WongDong
Posts: 5482
#4204

And the spoiler button is back, yaaay! Thanks!

Z
ZaruZaru
Posts: 8
#4205

Just want to say, that website didn't let me sign in, implying i had wrong pass (which i didn't), then i got e-mail about "login attempts" with which i remade into a new password. 

 

Was very weird thing to do. At first i thought my account disappeared, btw.

G
Grievous
Posts: 4594
#4206

Can the admins ask members that post papparazzi pics to please put them in spoiler tags?

tzdon's avatar
tzdon
Posts: 23041
#4207

Member i follow don`t show me anything new ??

I activate all and see nothing...

tzdon's avatar
tzdon
Posts: 23041
#4208

mmh...Nothing happens....

G
Grievous
Posts: 4594
#4209
On 12/13/2021 at 4:36 PM, tzdon said:

Member i follow don`t show me anything new ??

I activate all and see nothing...

 

I don't know what this means. 

tzdon's avatar
tzdon
Posts: 23041
#4210
On 12/19/2021 at 2:34 AM, Grievous said:

 

I don't know what this means. 

 

It means :

i can see ALL Activity. But when i wanna see the Activity of Members i follow the Site show this >

and i activate everything..

 

Opera Momentaufnahme_2021-12-20_192940_www.bellazon.jpg
G
Grievous
Posts: 4594
#4211

Oh, the activity stream.  People post here all the time that it's not working.

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4212

Everyone,

 

I apologize for the site being down for the better part of the week. I had been out of town with limited connectivity. 

 

So we ran out of disk space (again) and it caused some DB corruption. Due to some unfortunate timing I had to restore the DB to Dec 21st. 

 

I apologize for the inconvenience caused and I will be working next week to add additional storage to the server so these issues will stop. 

 

 

Kingdom of Rats...'s avatar
Kingdom of Rats...
Posts: 50708
#4213

Thanks for having the site up again!

 

6 hours ago, maddog107 said:

Due to some unfortunate timing I had to restore the DB to Dec 21st. 

 

 

So, all content between Dec 21 and today is forever lost? Or will that be recovered somehow?

Be excellent to each other!'s avatar
Be excellent to each other!
Posts: 41998
#4214
8 hours ago, maddog107 said:

Everyone,

 

I apologize for the site being down for the better part of the week. I had been out of town with limited connectivity. 

 

So we ran out of disk space (again) and it caused some DB corruption. Due to some unfortunate timing I had to restore the DB to Dec 21st. 

 

I apologize for the inconvenience caused and I will be working next week to add additional storage to the server so these issues will stop.

 

Do you need any donations to help you out?

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4215
3 hours ago, Stormbringer said:

Thanks for having the site up again!

 

 

 

So, all content between Dec 21 and today is forever lost? Or will that be recovered somehow?

'

I have the IBD files and I tried recovering from them but its a very manual process and you need to delete all indexes and what not before you can relink the FRM files to IBD but there were a lot of tables that were failing that relink so I was worried about the integrity if I did it that way. I ended up restoring from a clean backup on the 21st. Backups are run daily but since we had no disk space all backups were truncated part way through due to no disk space. 

 

I was on vacation unfortunately so I wasn't keeping an eye out Sorry 

 

 

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4216
1 hour ago, Stromboli1 said:

 

Do you need any donations to help you out?

 

Im good, I appreciate the thought though

 

missparker7's avatar
missparker7
Posts: 39775
#4217

Thanks you got us the biggest part back.

W
WongDong
Posts: 5482
#4218

Thanks for the revive!

 

I posted so much content since 21st, and for all of it to go into the ether forever ...well, this is crushing to say the least.

Dont you know im loco's avatar
Dont you know im loco
Posts: 11003
#4219
19 minutes ago, WongDong said:

Thanks for the revive!

 

I posted so much content since 21st, and for all of it to go into the ether forever ...well, this is crushing to say the least.

 

Sorry

 

Probably next week once I have some time I will take a look at some software that claims it can recover data directly from the IBD files. All the attachments and what not are still on our server, just the posts that are associated with them are not. But I would not count on it working. 

 

I apologize for the inconvenience

 

Hombres necios que acusáis a la mujer sin razón...'s avatar
Hombres necios que acusáis a la mujer sin razón...
Posts: 56919
#4220

Thank you to resolve the problems on this forum & i don't know why the site become to have problems.

Page of 248