My website is down. Help or advice needed

Permalink 1 user found helpful
I have a site which is down.. http://bamboobearbradford.co.uk/... ( in fact multiple sites, as I'm using the "Multiple Domains" addon - all are down, barring one )

Chrome is showing a message.. "The bamboobearbradford.co.uk page isn’t working"
MS Edge says "Hmm, we can't reach this page."
Firefox "The connection was reset"

The apache error logs show "child pid 4097 exit signal Segmentation fault (11)"

Any ideas what this could be? My host is looking into this also... I just don't want to waste time if they eventually come back and say C5 is at fault..)

Thank you in advance!

Conkreet
 
A3020 replied on at Permalink Reply
A3020
Segmentation fault, could be many things. I once had the same errors caused by opcache. If that's on your server you'd try to disable it in your .htaccess for that specific domain.
Conkreet replied on at Permalink Reply
Conkreet
Thanks for you reply. When you say "disable it" - what do you mean?

Thanks.
A3020 replied on at Permalink Reply
A3020
http://stackoverflow.com/a/21556994
Conkreet replied on at Permalink Reply
Conkreet
Thank you for the hint. But it wasn't that, on this occasion, unfortunately :-)
A3020 replied on at Permalink Reply
A3020
It could also be a Apache module that's conflicting. Do you have server access? I've also had this error once after I updated Imagick.
Conkreet replied on at Permalink Reply
Conkreet
I do have shell access, but not root access However, as far as I know, nothing has changed :-(
Conkreet replied on at Permalink Reply
Conkreet
I've just checked the C5 logs and found this...

Exception Occurred: /home/admin/freewebsites/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66 An exception occurred while executing 'INSERT INTO CollectionVersionBlocksOutputCache (cID, cvID, bID, arHandle, btCachedBlockOutput, btCachedBlockOutputExpires) VALUES (?, ?, ?, ?, ?, ?)' with params ["183", "50", "420", "Panel_11 : 68", "My address", 1624886328]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '183-50-420-Panel_11 : 68' for key 'PRIMARY' (0)


The very last thing I remember doing was to "Save a layout as a preset" - I think that was the option. Could this be related? It was roughly about the time of this log message.
A3020 replied on at Permalink Reply
A3020
You'd safely truncate that table. Maybe give that a try?
Conkreet replied on at Permalink Reply
Conkreet
I've just checked, it's already empty. But I have turned off caching and cleared cache, in an attempt to bring things to life :-(
A3020 replied on at Permalink Reply
A3020
Do you remember which page you were editing? If so, maybe you'd go back a version?
Conkreet replied on at Permalink Reply
Conkreet
Yes I remember which page and went back from version v102 to v99 (before this error) but this problem still exists, unfortunately.
A3020 replied on at Permalink Reply
A3020
Maybe backup the database and delete cID 183?
Conkreet replied on at Permalink Reply
Conkreet
Which table do you mean? I have already backup up. ( Maybe a too late.. My last backup was last week, :( )
A3020 replied on at Permalink Reply
A3020
I mean, you'd try to delete the page that has ID 183. Check table CollectionSearchIndexAttributes if you don't know which page corresponds to that ID.
Conkreet replied on at Permalink Reply
Conkreet
That didn't work I'm sorry to say. (I've restored the database since testing)

The page disappeared of course, but other pages on the site still gave the same problem. (even ones that had not been edited for some time)
A3020 replied on at Permalink Reply
A3020
Yeah, might be because you added a block or something to a GlobalArea or Stack that's displayed on multiple pages...

You'd try to find out which BlockType corresponds to bID = 50. If that's a custom block, you'd set the cachedBlockOutput temporarily to false.
Conkreet replied on at Permalink Best Answer Reply
Conkreet
I think I've just fixed it!

I deleted the only record in AreaLayoutPresets - Remember I said the last thing i did was to save a preset? Obviously this must be a bug of some kind
Conkreet replied on at Permalink Reply
Conkreet
http://bamboobearbradford.co.uk/ is up and running now :)
A3020 replied on at Permalink Reply
A3020
Glad you found it :)
Conkreet replied on at Permalink Reply
Conkreet
And thank you VERY much for your help

/addkarma
Conkreet replied on at Permalink Reply
Conkreet
I really appreciate your help, BTW. :-)