This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Error: 1030 Got error 28 from storage engine SQL=SELECT
#1
Error: 1030 Got error 28 from storage engine SQL=SELECT
Hello
I runned in this morning Backup from Panel sentora. After few hours I received the error from title.
I connected to server thru ssh:

Code:
df -h
Filesystem         Size  Used Avail Use% Mounted on
/dev/ploop36676p1   30G   28G   16M 100% /
none               512M  4.0K  512M   1% /dev
none               4.0K     0  4.0K   0% /sys/fs/cgroup
none               103M  1.1M  102M   2% /run
none               5.0M     0  5.0M   0% /run/lock
none               512M     0  512M   0% /run/shm
none               100M     0  100M   0% /run/user
Again:

Code:
sudo du -sh *
6.5M    bin
4.0K    boot
4.0K    dev
18G     etc
0       fastboot
32K     home
27M     lib
4.0K    lib64
16K     lost+found
4.0K    media
4.0K    mnt
4.0K    opt
du: cannot access 'proc/3849/task/3849/fd/4': No such file or directory
du: cannot access 'proc/3849/task/3849/fdinfo/4': No such file or directory
du: cannot access 'proc/3849/fd/4': No such file or directory
du: cannot access 'proc/3849/fdinfo/4': No such file or directory
0       proc
172K    root
1.1M    run
6.9M    sbin
12K     srv
0       sys
4.0K    tmp
661M    usr
9.8G    var
Another one:
Code:
cd /etc
/etc$ sudo du -sh *
4.0K    ODBCDataSources
........
18G     sentora
........
So, please help me: what is wrong here? How can I reduce this size?
Can you help me, please?
Thank you very much.
Reply
Thanks given by:
#2
RE: Error: 1030 Got error 28 from storage engine SQL=SELECT
This has been explained many times. You can clear out your log files, limit backups to 3 instead of 7, or get more HD space Wink
-TGates - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by: Bobses
#3
RE: Error: 1030 Got error 28 from storage engine SQL=SELECT
(01-06-2016, 03:58 AM)TGates Wrote: You can clear out your log files
Thanks for your answer.
How can I delete these Sentora logs? I cannot find now a solution quickly.

What can Ia do in this situation? 18 GB for panel sentora?

Code:
user@s1:/etc/sentora$ sudo du -sh *
312K    configs
4.0K    docs
18G     panel
Well, I found the solution. Smile I want to write it here to be helpfull for others.

Code:
/etc/sentora/panel/etc$ sudo du -sh *
56M     apps
2.6M    lib
376K    static
5.7M    styles
18G     tmp
552K    zppy-cache
18 GB for tmp is a huge size. So, run the command:
Code:
cd tmp
We need to see hidden files:

Code:
user@s1:/etc/sentora/panel/etc/tmp$ ls -a
.           zadmin_Dec-14-2015_091214.zip  zadmin_Dec-30-2015_071257.zip
..          zadmin_Dec-17-2015_081209.zip  zadmin_Jan-05-2016_070110.zip
_delete_me  zadmin_Dec-22-2015_091218.zip  zadmin_Jan-05-2016_070138.zip
storage     zadmin_Dec-29-2015_071226.zip

I deleted all files with .zip extension:

Code:
sudo rm *.zip
And now everything looks great:
Code:
user@s1:/$ df -h
Filesystem         Size  Used Avail Use% Mounted on
/dev/ploop36676p1   30G  5.1G   23G  19% /
none               512M  4.0K  512M   1% /dev
none               4.0K     0  4.0K   0% /sys/fs/cgroup
none               103M  1.1M  102M   2% /run
none               5.0M     0  5.0M   0% /run/lock
none               512M     0  512M   0% /run/shm
none               100M     0  100M   0% /run/user


I think it will be very helpfull a module who will delete all unnecessary files, like those about.
Reply
Thanks given by:
#4
RE: Error: 1030 Got error 28 from storage engine SQL=SELECT
I think that is also a bug. For some reason the temp backups are not being deleted from the tmp folder.
If backups are disabled, then this shouldn't be a problem Wink
-TGates - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by:
#5
RE: Error: 1030 Got error 28 from storage engine SQL=SELECT
It will be solved in next version of Sentora?
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Repo update error hostingms 3 6 ,809 02-14-2024, 09:20 AM
Last Post: TGates
apt-get install mod_ssl ERROR CMs222 9 28 ,320 11-11-2022, 09:14 PM
Last Post: zustudios
Sentora debug and error files johnnyp 0 1 ,590 10-27-2022, 06:16 PM
Last Post: johnnyp

Forum Jump:


Users browsing this thread: 1 Guest(s)