Nov 20, 2009

Mysql Server Not Stable After Hard Disk Swap On April 6th

free web hosting
Open Discussion & Free Web Hosting > Astahost > Hosted Members Support

Mysql Server Not Stable After Hard Disk Swap On April 6th

Niru
Hi...

All are aware of the server issues happened on April 6th:
http://www.astahost.com/current-server-iss...ade-t15435.html

I'm still facing the issue with the MySQL Server after the server problems!!

I'm using phpBB forum for my site, and it often shows some error message after losing connection with the Database server!
Its happening many times in a minute!

Its not at all stable after the server issues! I had tried repairing the databases and optimizing the databases!
But nothing helped me! Still facing the issues!

Its showing like:

DEBUG MODE

SQL Error : 2013 Lost connection to MySQL server during query

Also showing as:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Please fix the issue!! huh.gif

Niru



 

 

 


Comment/Reply (w/o sign-up)

sparkx
I agree. I had made a very nice forum/topsite listing program it was working just fine but now once every 10 or 15 minutes. I get an error simaler to this:
QUOTE
Database error in "/index.php" on line 50

Now I get this 100% of the time on my topsite area. I have looked through the code and it is connecting to a valid sql server. I may re-upload my latest backup and see if it starts working then. Maby the server moved around the files. I am back to using the orrigional cpanel (not the cpanel x). I have been looking for a solution for this problem and just came to the conclusion to simply add to my sql error that my visitors should refresh the page. Phpbb isn't that stable of a program in the first place. Try reconfiguring manually the mysql. Search for a file that contains sql in the name then edit it to a new database and re-run your sql for the new database (you may need to backup your files to do this).
Thanks,
Sparkx

Comment/Reply (w/o sign-up)

vujsa
Please send an eamil to support for this:
support[at]xisto.com

Include the following:
AstaHost Username
cPanle Username
Your Local IP Address - Will help locate any entries in the error logs.
Affected Website(s) URL - Specify where the problem can be seen.
Description of The Problem.
Any Error Messages That You Might Receive.


Any support for this issue can be dealt with through support!
Closing Topic.

vujsa

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : mysql, server, stable, hard, disk, swap, april, 6th

  1. Email Server / Cpanel Problems
    (1)
  2. Can't Access Any Site Hosted On The Server
    (4)
    Ever since yesterday, I wasn't able to access my site http://maxotek.net , so I tried
    others' sites like http://www.handyphp.com , none of which opened. I've tried PINGing the
    sites and have received no response as yet. I've heard that there were some changes to the IP
    addresses for the shared IPs. Just a while ago, I heard from a friend of mine that he was able to
    access the sites. Another one reported of a Gateway Timeout error. Do I need to make some changes
    in the CPanel or will this be solved automatically?....
  3. Full Disk Usage Warning In Cpanel
    (7)
    A few minutes ago I received an automated mail notifying me about 109.68% (548.38 Megs) of disk
    space used by my hosting account. It was extremely surprising because I have not uploaded anything
    in a while. Nevertheless, I went back to CPanel and looked into the Disk Usage Viewer. It could only
    account for ~295 MBs. While, I can free up quite a bit of space from the Trash directory, I am
    wondering what's causing the disk space to be misreported. Edit : I have emptied the Trash
    folder which managed to free ~75 MBs. Although, this has brought down the disk usage wit....
  4. Server Overloads
    (11)
    Alright, this is becoming a major problem. For the past few days, the Gamma server has been
    overloading a lot. The server has reached a load peak of 14.92 thus disabling services like PHP, CGI
    and have even shut down MySQL once. This is as big of a problem as XBOX Live having problems from
    the past few days. At the time of writing, Gamma's httpd has crashed. Just as a
    suggestion, Astahost needs to update the HTTP server software, Apache 1.3.33 is ancient. The latest
    stable version is 2.2.6. xboxrulz....
  5. Connecting To Astahost's Mysql
    (8)
    Now this topic could fit under lots of subforums but this isn't really a programming question
    but rather asking what asthosts mysql host is? Long story short I need to connect to a mysql
    database via c++ (I dont even know if that is possible) but I cant use localhost (for obviouse
    reasons). Could you tell me how to find the mysql host for my account? Thanks, Sparkx....
  6. Gamma Server Failure
    (5)
    Apparently when I just checked the server today (because it kept not allowing connections), the
    server had failed as shown below: I hope the admins rectify this problem. xboxrulz....
  7. Current Server Issues That You May Have From The April 6th Hard Drive Swap And Cpanel Upgrade
    Place your issues here! (25)
    I keep seeing messages in the shoutbox that there are issues with the server and cPanel. If this is
    true, then why hasn't anyone made a post about it? To begin with, I have no control over the
    server so complaining to me or in the shoutbox doesn't help. None of the staff has control over
    the server so they can try and contact those that do but in the end, we really need a post about the
    problems. The shoutbox simply has too short of a life span for reporting problems. So please
    reply to this topic and this topic only if you have any problems NOT already p....
  8. Mssql Server Gone Away?
    Please help! (0)
    Problem was solved. Thread can be deleted. /smile.gif" style="vertical-align:middle" emoid=":)"
    border="0" alt="smile.gif" />....
  9. Site Not Opeing ( Phpbb Forum) :: Can't Connect To Local Mysql
    (3)
    Hi all, Please help me! My site was working fine! ( www.fun.niranvv.com ) But now, its showing
    one error message as: Warning: mysql_connect() : Can't connect to local MySQL server
    through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/niranvv/public_html/fun/db/mysql4.php on line 48 Warning: mysql_error(): supplied argument is
    not a valid MySQL-Link resource in /home/niranvv/public_html/fun/db/mysql4.php on line 330 Warning:
    mysql_errno(): supplied argument is not a valid MySQL-Link resource in
    /home/niranvv/public_html/fun/db/mysql4.php on line....
  10. Server Or Me?
    I have an error? It doesn't look like anyone else has it? (5)
    OK I don't know if this is the right place for this so could the mods move it the the correct
    place? Thanks. Whenever I try to access my website or log onto the control pannel I get the
    following error message: QUOTE Network Error (tcp_error) A communication error occurred:
    "Operation timed out" The Web Server may be down, too busy, or experiencing other problems
    preventing it from responding to requests. You may wish to try again at a later time. For
    assistance, contact your network support team. It says contact support team (I assume thats
    you). Is an....
  11. What Is The MySQL Version @ Asta ?
    MySQL 4.0.26-Max
    (16)
    Hi, A few question here, 1. Just wondering, the MySQL hosted on astahost.com is actually version
    "4.0.26-Max" according to phpmyadmin. But why is cPanel showing "4.1.21-standard"? 2. Actually
    i've existing codes that need function introduced after version 4.1.1, is there by any chance
    astahost or xisto is going to upgrade the MySQL package? Thanks....
  12. Problem With MySQL
    (5)
    I tried to visit my website today and I recieved the dreadful page from my php-nuke site "There
    seems to be a problem with the MySQL database" First I thought, "no big deal server is probably
    rebooting or down for a little bit" So i logged into my cpanel and clicked on "Server Status".
    Thats when I started worrying. It said the MySQL servers were up and runnign fine. I went back to my
    main page and looked at my MySQL server count and instead of saying 2/99 it now says NA/99 I am
    unable to create a new database and I recieve this error when I click on PHPmyadmin QUO....
  13. Php And Mysql Version.
    (7)
    Is there any plan to upgrade or see if it can be upgraded to PHP5 and mySQL5 in the future?....
  14. Mysql Connect Error, Too Many Connections.
    (1)
    Just to begin with I want to say that I am not here necessarily to complain about it lol. I'm
    not sure but if my site is possibly helping to contribute to the problem, I'd like to know if
    anyone knows any good articles or tutorials that might have information on what to look out for that
    could contribute to these sort of problems. I know my site may not have anything to do with it (as
    I don't think it is overly popular or anything or even close), but knowing what to look out for
    when messing with PHP/mySQL would be great. I personally haven't found too....
  15. Are There Mail Server Issues Today?
    (4)
    I have been having a lot of problems today connecting to the mail server and was wondering if there
    are any ongoing problems. Thanks, Gin....
  16. Mysql Error Never Seen On My Site Before (too Many Connections).
    (13)
    I just tried to visit my site to see if anything had changed on my forums and such and I got this
    message: Warning: mysql_connect(): Too many connections in /xxxx/xxxxx/xxxxxx_xxxxx/xxx/xx_xxxx.php
    on line 7 Error! Could not connect: Too many connections. I have never recieved this error before,
    does this mean someone is mucking with my site somehow??? The particular php file it mentions is
    the one that defines variables like db username etc and connection to the site's database that I
    include wherever it is needed in various file for the site. EDIT: I managed t....
  17. Site Unavailable!
    Server Timeout error! (7)
    My Astahost Website seems to be unavailable currently. The Time is : 4:15 PM IST (GMT+5:30hrs)
    The browser gives a "Server Timeout Error". Is this a temporary server downtime, or do I have to
    re-configure my site or something? I also have enough credits to go on with - 17 at this time...
    My site is : www.omkarshub.astahost.com ....
  18. Help Me!
    Frontpage & phpBB with MySQL (3)
    I was just approved an Astahost account with the starter package. I explored the Cpanel a bit
    and have got the following problems : 1.Frontpage Extensions The Cpanel states that the
    Frontpage Extensions have been installed. But when I uploaded my site on frontpage at
    "ftp://ftp.mysitename.astahost.com/public_html/" it stated an error that Fronpage Extensions are not
    installed on this server! When I opened my site online, I can see the page, but I cannot see any
    graphics/images! Also, my forms and other stuff isn't working either. Please help me out and let
    me....
  19. Weird MySQL Message
    (4)
    wenever i assign priviledges to a MySQL databases, it seems to work properly but this message is
    always there QUOTE bitshift_wforumu (Privileges: ALL PRIVILEGES) Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:bitshift_wforum:localhost","bitshift_wforumu"," ");
    PHP $dbh=mysql_connect ("localhost", "bitshift_wforumu", " ") or die ('I cannot connect to the
    database because: ' . mysql_error()); mysql_select_db ("bitshift_wforum"); My database
    name is: bitshift_wforum the username is: bitshift_wforumu What does all that maen, it ....
  20. Problem With MySQL Not Being Able To Connect
    Anyone know the reason for this error... (9)
    Hello everyone, Im currently having a problem with mySQL, I wrote a PHP login script that
    doesnt seem to be working for some reason. I created a database and everything looks correct, is
    this a server issue or is the issue related to my script? But anyway this is my error, hope someone
    can help Ive tried to search forum for answer but none of the posts seems to answer my question:
    QUOTE Warning: mysql_connect(): Host 'gamma.xisto.com' is not allowed to connect to this
    MySQL server in /home/hp2001/public_html/ucscKGD/checklogin.php on line 10 cannot co....
  21. Google Sitemaps Not Verifying My Site...
    Tells me to configure server (4)
    This is the error that Google gives me while i try to verify my site. NOT VERIFIED We've
    detected that your 404 (file not found) error page returns a status of 200 (OK) in the header. The
    explanation for this error at google is: This configuration presents a security risk for site
    verification and therefore, we can't verify your site. If your web server is configured to
    return a status of 200 in the header of 404 pages, and we enabled you to verify your site with this
    configuration, others would be able to take advantage of this and verify your site as well.....
  22. MySQL - Can't Connect
    Cristal Report (1)
    From http://thoaionline.com (hosted by Astahost) QUOTE Warning: mysql_connect(): Can't
    connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in
    /home/pheart/public_html/thoaionline/includes/database.mysql.inc on line 31 Can't connect to
    local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) In cPanel Mysql
    databases 0 / 99 But I have 5 MySQL databases in my account (maybe more). All of them become
    unusable now. Some more messages from http://website.thoaionline.com QUOTE Warning: 
    mysql_pc....
  23. Can I Access MySQL Database From Outsite, Directly
    (10)
    I'm going to make an OFFLINE FORUM. So I want to know is that possible or not. My paid host
    don't allow that. How about astahost?....
  24. IPS Driver Error / MySQL Database
    What in the world? How is this possible? (1)
    Just several hours ago, I couldn't access my website/forum because of some error with an SQL
    socket or something like that. I need desperate help because I don't want to reformat everything
    again. Well, here is what comes up: IPB WARNING mysql_connect(): Can't connect to local
    MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Line: 114 of
    /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can
    try to refresh the page by clicking here. Error Returned: SQL error: Can't connect to local
    M....
  25. MySQL Database
    Important Report (3)
    I'm writing this to report about a error. One of my mySQL database has been droped and my site
    stop working. I don't know the reason. I'm hosted on gamma server. I think you (admin)
    should check it. PS: One of my paid hosting provider also met this problem a few day ago.....
  26. Multibyte-string Functions
    since server shift (1)
    Hello, I use multibyte functions to split a string by letter and I was wondering if you could turn
    them on again, because they were on before the server shift (and they are in PHP by default) and now
    I get fatal errors, when trying to use them. In the Phpinfo they don't appear at all.. I've
    been waiting for quite some time now and it is only a basic PHP-integrated feature.. Thanks, Ruben....
  27. Server Connection Poor
    (13)
    I don't know if it's my end or not but the server seems like it's not working as usual,
    sometimes I can't connect or the forums would lose its images. This also happens to my website
    too. My website is on the panda server. my website URL: http://www.ae-net.cjb.net Thanx,
    xboxrulz....
  28. Problem With Mysql
    Cannot connect to database.... (6)
    Hi, this is the first time after I got my hosting to try and use MySQL. My site is
    http://abhiram.astahost.com . I created a user in CPanel -> 'MySQL Databases' as root. So,
    the new user created will be 'abhiram_root'. Similarly I created a database called
    'webpage' (which changes to 'abhiram_webpage'). I set up the database and the tables
    using phpMyAdmin and uploaded the files after making changes to the user name and the database. But
    it's not opening the database. It's connecting to MySQL without any problems, but it
    isn'....
  29. Mysql Error
    (5)
    Hey i got this error trying to install something on my database CODE mysql error: You have an
    error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the
    right syntax to use near 'rpg_class` (`name`, `folder`, `regatt`, `magicatt`, `magicdef` mysql
    error number: 1064 can anyone tell me what this means or how i fix it?? thanks in advance....
  30. General Problems With New Account
    MySQL problems and quota issues (2)
    I just got a new account and CPanel reports that I have -380.2 MB of quota space and using 400.2MB.
    This disables some of Cpanel's functions. It would have been nice to use the automated Mambo
    installer, but no biggy. I uploaded the latest Mambo .tar.gz from my FTP program and unpacked it
    via Cpanel's file manager with no problem. When I first logged into the system I created a new
    Database for mambo and a new user for that database and linked the two from Cpanel. I logged off to
    watch something on TV and came back and that database isn't being reported....

    1. Looking for mysql, server, stable, hard, disk, swap, april, 6th

See Also,

*SIMILAR VIDEOS*
Searching Video's for mysql, server, stable, hard, disk, swap, april, 6th
advertisement



Mysql Server Not Stable After Hard Disk Swap On April 6th

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com