Having a total nightmare
Started cloning a D site for presentation TOMORROW MORNING (last minute request..)
Done this 100 times no probs.
SQL errors so went to remove and try again as database was showing 0mb in cpanel
then I get this error in my sql databases - The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely: The subprocess reported the “” (255) error when it ended.
Now, I have no sql at all showing in my sql databases related to my user!!!
I can see them all in phpmyadmin, and in backup so they are there.
Hostforweb are looking into it but its been a few hours and nothing so far...
Something else, now my existing sites are not allowing me to make any changes, I guess as my user is no longer allowed to those databases. Losing images, some screen result in errors etc...
Any help appreciated. This is urgent for presentation tomorrow morning and its nearly midnight now in UK!!!
|
clear cache on a site that was working fine and now this
Query:
SELECT `Page` AS `Name` FROM `sys_page_compose` WHERE `Page` != '' GROUP BY `Page`
Mysql error:
Incorrect key file for table '/tmp/#sql_a02_0.MYI'; try to repair it
Found error in the file '/home/host/public_html/demonetwork/inc/classes/BxDolPageViewAdmin.php' at line 865.
Called 'db_res' function with erroneous argument #0.
Debug backtrace:
|
Is this a shared or dedicated server? If dedicated, check the MySQL error log (/var/lib/mysql/[hostname].err). Also check /usr/local/cpanel/logs/error_log
If this is a shared server, the host needs to check this out.
BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
Is this a dedicated server?
The error is in a mysql tmp file in the servers tmp folder. This is usually the result of a mysql crash due to low disk space on the tmp partition.
The tmp folder will need to be cleared and the server restarted so mysql can rebuild the key files. But you need to have the disk space for the tmp partition checked by your host. It may not be large enough to deal with the size of the tmp files mysql creates.
And by tmp folder, i mean the servers tmp folder. Not dolphins tmp folder. Not to be confused. https://www.deanbassett.com |
where abouts is the servers temp folder?
just home/tmp ?
Its a dedicated with HFW
in WHM in server status I can see that both
Var/tmp and /dev/sda3 are 100% full...
not sure where I find these in cpanel file manager though...
Is this a dedicated server?
The error is in a mysql tmp file in the servers tmp folder. This is usually the result of a mysql crash due to low disk space on the tmp partition.
The tmp folder will need to be cleared and the server restarted so mysql can rebuild the key files. But you need to have the disk space for the tmp partition checked by your host. It may not be large enough to deal with the size of the tmp files mysql creates.
And by tmp folder, i mean the servers tmp folder. Not dolphins tmp folder. Not to be confused.
|
looks like Deanos solution is right, although I have yet to find where to clear those folders and will then need to incease temp files etc...
all other errors Im getting seem to be as a result of this.
HFW are being very very slow to respond.
|
Not temp. The name of the folder is tmp
And on most linux systems the path is just /tmp
And also on most linux systems, the /tmp folder is a hard drive partition mounted as a folder. Increasing it's size if need be is not a easy task, if the size needs to be increased you will have to get help from your host. https://www.deanbassett.com |
right now the server has completely frozen. cant access anything.
couldn't have happened at a worse time...
may be looking for a new host if this isn't resolved soon as getting no response on support.
|
yep. server is offline. all sites down. |
You can clear /tmp with tmpwatch, which should be on the server by default thanks to cPanel (via SSH):
# tmpwatch -am 24 /tmp
This will clear all files out of /tmp that are older than 24 hours (last modified).
BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
cant access anything at the mo.
Just had an email from HFW (4 hours after first ticket logged)
asking for login info a 2nd time. might be looking elsewhere after this...
|
cant access anything at the mo.
Just had an email from HFW (4 hours after first ticket logged)
asking for login info a 2nd time. might be looking elsewhere after this...
Does SSH still work at least (there might be a large delay in connecting)? If not, it's up to HFW.
BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
just trying it now. only used it a few times in the past so looking for the right command to connect to my server! |
just trying it now. only used it a few times in the past so looking for the right command to connect to my server!
You can use PuTTY on Windows: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html. For OS X and Linux (via the terminal): # ssh root@[server's IP address]
If the server uses a different port number, that will need to be manually specified. For OS X and Linux from the terminal, add -p [port number] after ssh. If you're not comfortable with SSH, I can try for you. I'll need the server's IP address and root password (used for WHM).
BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin |
|
You can also specify a different directory for mySQL to use. Geeks, making the world a better place |
HAve to say MASSIVE thank you to Nathan for going way out of his way to fix this.
No obligation at all to do anything as HFW are my 'current' host. Although after the support I got today...
Zarconia.net well worth checking out.
|
