Urgent: Site broken - please help ASAP
By Paul Murray on Sunday, 13 July 2014
Posted in Technical Issues
Likes 0
Views 887
Votes 0
Hello Support

Something has gone horribly wrong!
If you go to the Site the template, the pages, modules, blah, blah are all there.
But there is no content.
eg Blog shows Blog pages but no blogs.

In the back end when I go to the Easy Blog part I see

DB function failed with error number 1030
Got error 122 from storage engine SQL=SELECT x.* FROM ( (SELECT a.`id`, b.`nickname`, b.`avatar`, b.`description`, a.`name`, a.`username`, a.`registerDate`, a.`lastvisitDate`, COUNT(p.`id`) as `totalPost`, MAX(p.`created`) as `latestPostDate` FROM `fbug_users` AS `a` INNER JOIN `fbug_easyblog_users` AS `b` ON a.`id` = b.`id` INNER JOIN `fbug_user_usergroup_map` AS `d` ON d.`user_id` = a.`id` INNER JOIN `fbug_easyblog_acl_group` AS `e` ON d.`group_id` = e.`content_id` AND e.`type` = 'group' AND e.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `f` ON e.`acl_id` = f.`id` AND f.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p` ON a.`id` = p.`created_by` GROUP BY a.`id` HAVING (COUNT(p.`id`) > 0) ) UNION (SELECT a1.`id`, b1.`nickname`, b1.`avatar`, b1.`description`, a1.`name`, a1.`username`, a1.`registerDate`, a1.`lastvisitDate`, COUNT(p1.`id`) as `totalPost`, MAX(p1.`created`) as `latestPostDate` FROM `fbug_users` AS `a1` INNER JOIN `fbug_easyblog_users` AS `b1` ON a1.`id` = b1.`id` INNER JOIN `fbug_easyblog_acl_group` AS `c1` ON a1.`id` = c1.`content_id` AND c1.`type` = 'assigned' AND c1.`status` = 1 INNER JOIN `fbug_easyblog_acl` as `d1` ON c1.`acl_id` = d1.`id` AND d1.`action` = 'add_entry' LEFT JOIN `fbug_easyblog_post` AS `p1` ON a1.`id` = p1.`created_by` GROUP BY a1.`id` HAVING (COUNT(p1.`id`) > 0) ) ) as x ORDER BY x.`name` ASC

I am putting the Site offline for maintenance ;-)

And would ask some one to look at this ASAP

Will post more as I figure out more

There was an update performed today.
And I had no more space for a back up in PLesk and tried to free up some space by deleting some stuff that I had lying around.
I had a folder with some video files in it. the files had technicaly nothing to do with the Site!
I removed said video files and then tried downloading the back up and got and error message in Plesk

ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine (Pdo.php:234)

I do not know if this was the update or my attempt to slim down the backup and then download. Or a combination of both.

Either way I think I am in a pickle and could really do with some help on this one thanks

Paul

ps can not put Site off line as I get this:

Could not save data. Error: The Global Configuration extension could not be found. Text filter settings have not been saved.
Maybe this helps. No idea. I have a scheduled back up that runs around 12:15am European time.

Today it started trying to run again at 8:00am European time!
Paul Murray
·
Sunday, 13 July 2014 19:17
·
0 Likes
·
0 Votes
·
0 Comments
·
hey paul,
from the error message it looks as somethig's messed up in your easyblog database. have you made any changes on easyblog / joomla users or the database in general recently?

also to proceed please
1) update your easyblog to the latest version so that we can run some tests on this
2) provide us with your database access to check these errors
Alex
·
Sunday, 13 July 2014 19:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Paul Murray,

I am really sorry for the delay of this reply as it is a weekend for us here.
Based on the error message, it seems like the error 122 message is due ran out of disk space.
Reference link : http://stackoverflow.com/questions/68029/got-error-122-from-storage-engine

Can you try consult regrading this issues with your webhosting provider and see how it goes? Keep us update if your webhosting provider got give any response.
Arlex Wong
·
Sunday, 13 July 2014 19:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Alex. hi Arlex

When I go into the back end. Hey it is still there :-)

This is the first thing I see:



JFTP: :mkdir: Bad response
JFTP: :chmod: Bad response
JFTP: :mkdir: Bad response
JFTP: :chmod: Bad response
JFTP: :write: Bad response

Never saw that one before.

I then try installing this here:

com_easyblog_community_3.9.16263.zip

Nerve racking stuff…

And see this:

The connection to the server was reset while the page was loading

OK back end still there

going to plesk

https://178-77-72-249.kundenadmin.hosteurope.de:8443/login_up.php3

gives me this

ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine

Additionally, an exception has occurred while trying to report this error: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine (Pdo.php:234)

Search for related Knowledge Base articles

I will see if I can reach my hosters. It is a Sunday and I am in Germany and there is the football. It should be fun. I guess if they could restart the server that would be a start. More later….

If you guys need anything from me let me know. I will be glued to my computer for the next couple of hours at least…

And yes Arlex with respect to disk space I am sure that is part of the problem.

I only had 10GB left and tried to download a 10GB file and I guess that there was some head room required...

What I also do not get is why there were 2 backups in the space of 24 hours!!!
Paul Murray
·
Sunday, 13 July 2014 20:59
·
0 Likes
·
0 Votes
·
0 Comments
·
hey paul,
in this case the hoster is really the first one to adress. as arlex said the 122 error is related to disk space (or to be precise: limits in general as it can also apply to a database limit - but that's not happening often).

the error message you shared itself was pointing to easyblog tables, therefore updating it to latest version - or in general keeping stuff up-to date is a good thing always ^^

but nevertheless, the reason doesn't seem to be extension-related because when I browse through your backend and checking other extensions they all throw out errors (akeeba etc..) - so as said: getting hold of your hosting should be the first step now to fix the limitation problems - they should also be able to tell you why there are additional backups.
Alex
·
Sunday, 13 July 2014 21:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi, hi

My hoster can deal with this tomorrow from 9:00 am. German time.
I just hope that they are not too hung over.
I will ask them to give me some more space and do a restart.

thanks all the same

best

Paul
Paul Murray
·
Sunday, 13 July 2014 21:56
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Alex

Yep. Got it thanks. Just have to sit tight.
I also do a Akebba back up before doing any updates eg Easy Social.
So there is a plan B as well. It should be OK.
Just a little nerve racking.
There should be a Homer Simpson doh smile here...

Enjoy the game

best

Paul
Paul Murray
·
Sunday, 13 July 2014 22:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Paul Murray,

Sorry for late reply to this,
I have tried to access in your site, it seems like your site under maintenance right? Because I'm not able to access now.
Okay, keep us updated then after you request with your webhosting add more space and do a restart.
Arlex Wong
·
Monday, 14 July 2014 10:17
·
0 Likes
·
0 Votes
·
0 Comments
·
hi Arlex, thank you for asking about an update. My hoster have done as requested and I was able to access my site from my phone an hour ago. I guess that there will be some minor issues to clear up but I think that the worst is over. I will update again as soon as I am sitting in front of a real computer. Will aso do an Easy Blog update as Alex suggested ASAP. Thank for your time, ditto Alex.
Paul Murray
·
Monday, 14 July 2014 22:05
·
0 Likes
·
0 Votes
·
0 Comments
·
hello Paul,

You're welcome, it seems like the blog post already visible in your site now.
Is it everything is working fine since Alex suggested you update all the component again?
Arlex Wong
·
Monday, 14 July 2014 23:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Paul, in case you haven't looked, two culprits that often end up hogging disk space: your error_log and you mentioned Akeeba backup.

For the error log, assuming that you use an IDE or ftp, you can edit it with a plain text editor. Before you that, you may want to check just how large it is. Depending upon what you are using it might be something like right click the file and "Get Info" Then remove what you don't want and save. My preferred method is to use ssh. cd to the directory where your error log is and at and enter:
> error_log
which will truncate it.

for Akeeba, check /administrator/components/com_akeeba/backup You may have some very large backups and restore point files. These will also increase the size of your full root backups so if there is stuff there you are confident that you don't need, remove it or save the archive locally then remove.
Paul
·
Tuesday, 15 July 2014 02:15
·
0 Likes
·
0 Votes
·
0 Comments
·
For anyone who stumbles across this thread. If you do not know what Akeeba back up is.
https://www.akeebabackup.com/
In my humble opinion, an absolute must have. It has saved my rear end numerous times!!!

Also info with respect to downloading back ups here:
https://www.akeebabackup.com/documentation/quick-start-guide/downloading-archives.html

Also:

https://www.akeebabackup.com/products/akeeba-kickstart.html

@Paul

Thanks for your tips. I guess that I got into a nasty spiral with respect to this. Backups of backups getting out of control, error messages and general sloppiness on my part :-(

- I was careless and had a lot of stuff lying around on my Site. Cleared 4GB of rubbish within a couple of minutes via FTP. Just by poking around…

- Cleared another 10GB of Akeeba back ups. I forget to download them but will do so in the future and am doing so as I write this.

-And yeah the Akeeba back ups get put into the Plesk back up which kind of exacerbates the situation!!!
i.e. my Akeeba 10GB Akeeba backups get put into the Plesk back up

- The result being that my Plesk back ups were running at about 7 - 10GB!!!

- What I find weird is that when I look in the Plesk back end under website resources usage. I am still at 21GB of 48.8GB. Which is exactly where I was before clearing space

I recon that I must have cleared up about 20GB so far. Will investigate further…

- With respect to the error logs. I could imagine that they too have got out of hand. All those messages… could not create back up must also take up space.

Paul or Support

Could you maybe give me a tip where I can find these error logs!?!
If I could get to them via FTP or Plesk that would be great…
I have asked google but do not know enough to filter the answer in a sensible way...
If SSH is unavoidable if someone could kindly post me a link with instructions how to do this I could give it a try?
Like what could possibly go wrong ;-)

Really need to spend a day looking at this. Like what is the point in building an amazing Site if it all goes down the drain, when one automated process gets out of control… It is a little like what Randall was talking about in another thread. Like what if you are the only administrator and get sick how long does it take an unmaintained Site to go down…. In a way I am glad that this happened now at a moment when the Site is not really getting huge amounts of traffic.

I know it is way of topic but their was the story of the apartment in Paris that stood empty for 70 years!!!

http://www.dailymail.co.uk/news/article-2323297/Inside-Paris-apartment-untouched-70-years-Treasure-trove-finally-revealed-owner-locked-fled-outbreak-WWII.html

I reckon that the way I had my Site set up it would not have survived 70 days without maintenance. Definitely food for thought!!!

ps @ Alex am now on "EasyBlog 3.9.16263" thanks Paul
Paul Murray
·
Tuesday, 15 July 2014 23:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Paul, glad it was useful. ssh is not unavoidable. In fact if you have such access and are not comfortable using it, you probably shouldn't. It is pretty easy to make huge /catastrophic mistakes from command line. It all depends upon what permissions /ownership your host provides for you. Are you using a ded server or virtual/cloud? At one time I ran a data center of windows servers (offering "cloud" services before there was a "cloud") but I learned my lessons from that experience and I stopped using windows servers quite a while ago so I am assuming that you are on a LAMP stack. for plesk I believe the structure is: var/www/vhosts/domain/statistics/ and you stated that you have access to the Plesk control panel then you should see the log config in there. the /statistics directory should be at the same level as httpdocs where the public facing files of your website reside i.e. /domain/httpdocs /domain/statistics

depending upon your webhost, they may have it configured differently. Sometimes an error log is set for specific directories like you might have one in your joomla root and another in joomla/administrator/error_log.
Paul
·
Wednesday, 16 July 2014 00:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Anyone who's reading this thread who may not know, you can get a year's worth of free storage access at Amazon. Akeeba back up supports Amazon as a storage location, and I have my backup setup to save at that location. That way I know it's always accessible somewhere. You can also automate a restore with Akeeba, and it makes sense to have a backup restored on some schedule so that you can test that critical step in the backup/recovery plan.
Kevin
·
Wednesday, 16 July 2014 02:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Paul Murray,

Yes, that was true as Paul said that is depending upon your webhosting provider and how their configure with this.

Thanks for Eileen O'Donnell and Paul heading up on this.
Arlex Wong
·
Wednesday, 16 July 2014 14:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Paul, hi Ellen

I just wanted to get back to both of you and thank you for jumping in here with tips.

@ Paul I tried following up on some of your suggestions but experienced a brain melt down. I can google all of that stuff that you mentioned but by the time I´ve understood 2 things I am struggling with the third and then I do not understand the first two any more. I will recruit a friend here in Berlin (again) who scorns graphical interfaces and loves SSH. I really want to double check the error logs.

@ Elleen thanks for your tips. Particularly Amazon. I will be looking into this the next couple of days and will yeah test a back up. As the Akeeba people say the only safe back up is a tested back up.

For any one who is interested:

ABT07 Remote Backup with Amazon S3 - Akeeba Backup Pro

https://www.youtube.com/watch?v=xbR2Aj6xNaA

All the best

Paul
Paul Murray
·
Thursday, 17 July 2014 14:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Paul Murray,

Thanks for sharing
Arlex Wong
·
Monday, 21 July 2014 01:16
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post