[NSC] Database issues

[BBassic]

Which flavour of database are you running [MENTION=6886]Bozza[/MENTION]? I'm an SQL dork and happy to answer questions / help out if possible.

 

[maffew]

Which flavour of database are you running [MENTION=6886]Bozza[/MENTION]? I'm an SQL dork and happy to answer questions / help out if possible.

It will be a version of MySQL or MariaDB I am sure. My instinct thinks this isnt actually a database error as such more likely a problem Apache or something

 

[neilbard]

These keep happening periodically and I still don't know why.

Typically NSC becomes unavailable for 2-3 minutes at a time and then returns by itself.

To try and help me diagnose what the hell is going on, can you please post to this thread each time it happens, as soon as the site returns, as I want to see if there is any pattern in the times when it takes place, and I'm not always online to experience it myself.

Hopefully I can get this frustrating issue sorted sooner rather than later - sorry it's such a pain.

Database issue for me 12:08 back at 12:09

 

[maffew]

12:07-12:09

 

[Dolph Ins]

Just done it several times. Could refresh to main board but error when trying to click on this thred.

 

[Bozza]

I don’t know your infrastructure but if your application is not logging error, does the OS event logs indicate problem? e.g. if hosted on Windows server, check Event Log.

Which flavour of database are you running [MENTION=6886]Bozza[/MENTION]? I'm an SQL dork and happy to answer questions / help out if possible.

It will be a version of MySQL or MariaDB I am sure. My instinct thinks this isnt actually a database error as such more likely a problem Apache or something

Yeah, pretty standard LAMP - Linux, Apache, MySQL and PHP.

vBulletin is very good at logging issues which makes fixing them or, at least, knowing how to fix them, pretty straight forward. This stuff isn't being logged anywhere I can see though, and I've had the hosting company where we have our own dedicated server look too. They don't have specific vBulletin knowledge though.

 

[Fungus]

Even the Met Office site is down - I suspect it's something to do with nationwide flumpage and the "More Snow Tomorrow" thread.

 

[Dolph Ins]

Just done it again

 

[maffew]

13:23 - 13-25

 

[Giraffe]

Not had the database issue today, but just now it took forever for a post to go through to the point where I posted it twice because I am impatient.

 

[GT49er]

Database error on the 'Have we run out of fight' thread at 13:24. Operational again at 13:26.

 

[Hammer15]

Just got it again when I tried to thumbs-up a post - it gave me some PHP code in response. When I tried to refresh the page, got a database error message.

 

[seagulls4ever]

Yeah, pretty standard LAMP - Linux, Apache, MySQL and PHP.

vBulletin is very good at logging issues which makes fixing them or, at least, knowing how to fix them, pretty straight forward. This stuff isn't being logged anywhere I can see though, and I've had the hosting company where we have our own dedicated server look too. They don't have specific vBulletin knowledge though.

I think vBulletin won't produce any error logs because it's not an error within vBulletin, it's just reporting that it can't connect to the database. It sounds like it's an issue with your host, rather than vBulletin. Your host should be resolving this for you. This might help: https://www.vbulletin.com/docs/html/cantconnect

 

[happypig]

had it trying to load
https://nortr3nixy.nimpr.uk/showthread.php?359239-celebrity-death-pool-2018

Then again when I tried to report it
https://nortr3nixy.nimpr.uk/showthread.php?359233-Database-issues/page2

Couple of reloads and it was back.

 

[Worried Man Blues]

Just got database error, came in again fine.

 

[Sussex Nomad]

What I'm a bit confused about is surely you rent the servers from some host, why are their technical team not backing you up?

 

[Bozza]

What I'm a bit confused about is surely you rent the servers from some host, why are their technical team not backing you up?

As I’ve already said: they are. But they don’t have specific vBullerin knowledge which is what I believe is required now.

 

[Bozza]

I think vBulletin won't produce any error logs because it's not an error within vBulletin, it's just reporting that it can't connect to the database. It sounds like it's an issue with your host, rather than vBulletin. Your host should be resolving this for you. This might help: https://www.vbulletin.com/docs/html/cantconnect

VBulletin reports all DB issues including not being able to find the DB.

I’ve been dealing with those issues and logs for the best part of 17 years now and have 220,000 emails from where they e been reported!

 

[Deleted member 22389]

VBulletin reports all DB issues including not being able to find the DB.

I’ve been dealing with those issues and logs for the best part of 17 years now and have 220,000 emails from where they e been reported!

Just out of interest and nothing to do with this current problem, are you running VBulletin on a Windows server, instead of Linux.

 

[thedonkeycentrehalf]

18:22 for a minute and half. Started on the Knockeart thread but then couldn't get back to the Big Board