Table '231_message' is marked as crashed and should be repaired
I haven't ever had this happen, is all my data truely lost or can i 'repair' it
i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )
either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
I am trying to start mysql but i am getting the following error
MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED]
I checked my hostname.err file in /var/lib/mysql and this is the error message it shows.
070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended
how I would repair that to get mysql to start again?
Question: Is it safe to delete the files in /var/log/mysql ? Also, is there some way I can disable logging so that this folder does not get filled up again?
Explanation:
Last night I started running a Perl script to process the data contained in some files, and then do a series of INSERTs to put them in a MySQL database. When I checked on it this morning, I found that it was very close to being done, but had locked up. I had trouble doing anything at all, actually, until I realized that 100% of the disk space on my hard drive had now been used. I went to investigate, and I quickly realized that my /var/log/mysql folder was over 120GB!
My intuition tells me that this folder is just used to store logs of what MySQL is doing. However, I have no need for these logs, and seeing as they are (unnecessarily) using over 120GB of my hard drive space, I would like to delete everything in that folder. But I'm still fairly new to Linux, and I'm not sure if this is safe. Can I just delete these files? And also, to prevent this from happening again, is there some way I can disable MySQL from creating such enormous log files?
my linux server crashed today. I found these are the last line in the log file just before i crashed.
Mar 8 07:21:00 myserver xinetd[5376]: warning: can't get client address: Connection reset by peer Mar 8 07:21:13 myserver xinetd[5395]: warning: can't get client address: Connection reset by peer
I've been with 3 dedicated hosts since 2005 and my sever experienced the first ever crash yesterday. I wanna know if any of you have experienced a crash once and not have it happen again after that time. As this is the first occurence, I'm feeling uneasy about the server stability.
This morning, apache crashed on the server that I assist a friend of mine (junglecat here) with. We finally managed to get it up and going - for some odd reason, restarting apache/httpd via Cpanel wouldn't get it going, but SSHing and typing via command line would.
I downloaded the apache error log, and it's CHOCK full of this, repeating over and over (and over) again:
DBD::mysql:t bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first) at email.pl line 55. DBD::mysql:t fetch failed: fetch() without execute() at email.pl line 56. Use of uninitialized value in concatenation (.) or string at email.pl line 59. Use of uninitialized value in concatenation (.) or string at email.pl line 61. Use of uninitialized value in concatenation (.) or string at email.pl line 76.
Have tried searching and either I'm not using the correct terms, or this doesn't happen that much (I am betting on the former). Any ideas?
I found phpmotion [url] and thinking about using this script, not only it is free but also it has the funtion that alow direct transfer video files from youtube to my server. Moreover, the phpmotion community is lovely.
The problem is that my hosting provider said this script is bad.
Quote:
While it will run on our servers I have heard nothing but bad things about this software on our servers. For quite a while it has caused issues to the point of crashing our servers but just recently (in the last couple days) we have found ways to put limits on our systems which should effect other programs/processes which will prevent this software from crashing our servers so whether or not this would be ok to run on our servers is a big *maybe* Alot of the issues appear to be related to the fact the software runs php by executing it via shell using the php executable which isn't really good considering that on our servers it will always make it use php4 which might not be what your site is running. PHPMotion is pretty much the only software I have heard discussed and has caused major issues on our servers so if you could avoid it I would definitely suggest you do! If you asked me about any software which is reported to have/cause problems on our servers without even mentioning phpmtion I would have answered phpmotion as that is the only one I have heard of which causes tons of issues.
my questions are:
1. Do you have the same experiences with phpmotion?
2. How can I reduce the problem?
3. If phpmotion is really bad, which video sharing script should be recommended?
I'm hosting proxy sites on my vps and untill yesterday my proxy worked fine with no problems at all.
But while going trough my server graphs I found it odd that I had 0 bandwidth since the middle of yesterday.. I first supposed that this was due school's out [url]but this wasn't the reason I found out!
I tried testing one of my proxies to see if it was still working, but with any URL I try to visit I get:
The requested resource could not be loaded. libcurl returned the error: Couldn't resolve host 'www.google.com'
I suppose the DNS server crashed?
I already restarted the VPS 3 times including the DNS Server.
Does anyone know of any services that can help retrieve data from a crashed server. The server is managed but the support are saying that they are having problems retriving the data. The server had an os reload and they can't slave the old disk.
I have a crashed HD that I want to recover the data. I wonder if there is any method or software out there that can do this for me.
The hard drive is installed with centos and uses ext3 filesystem.
I have tried doing a mount, not if it is done correctly, but I only see "lost+found" on the hard drive.
Usually when this happens on my hard drive w/ windows, I use some data recovery software to extract the data. I don't know which software will do this for me on an ext3 filesystem running centos.
Today my server just crashed instantly... It was running fine with a load of 0.12 but then it went down all the sudden. After a reboot I checked the /var/log/messages file and saw this:
Code: Mar 23 15:57:00 alpha kernel: Unable to handle kernel NULL pointer dereference at virtual address 00000020 Mar 23 15:57:00 alpha kernel: printing eip: Mar 23 15:57:00 alpha kernel: c017292b Mar 23 15:57:00 alpha kernel: *pde = 2085d001 Mar 23 15:57:00 alpha kernel: Oops: 0000 [#1] Mar 23 15:57:00 alpha kernel: SMP Mar 23 15:57:00 alpha kernel: Modules linked in: ipt_TOS iptable_mangle ip_conntrack_ftp ip_conntrack_irc ipt_LOG ipt_limit ipt_multiport ipt_state ip_conntr ack ipt_owner ipt_REJECT iptable_filter ip_tables autofs4 i2c_dev i2c_core sunrpc md5 ipv6 dm_mirror dm_mod button battery ac uhci_hcd ehci_hcd e1000 floppy ext3 jbd ata_piix libata sd_mod scsi_mod Mar 23 15:57:00 alpha kernel: CPU: 0 Mar 23 15:57:00 alpha kernel: EIP: 0060:[<c017292b>] Not tainted VLI Mar 23 15:57:00 alpha kernel: EFLAGS: 00010246 (2.6.9-42.0.3.ELsmp) Mar 23 15:57:00 alpha kernel: EIP is at dnotify_flush+0xe/0x70 Mar 23 15:57:00 alpha kernel: eax: c0446c40 ebx: ca05dd80 ecx: 0046ef00 edx: f1d95300 Mar 23 15:57:00 alpha kernel: esi: 00000000 edi: ca05dd80 ebp: f1d95300 esp: eb3f3fa0 Mar 23 15:57:00 alpha kernel: ds: 007b es: 007b ss: 0068 Mar 23 15:57:00 alpha kernel: Process httpd (pid: 28057, threadinfo=eb3f3000 task=efaf03b0) Mar 23 15:57:00 alpha kernel: Stack: ca05dd80 00000220 f1d95300 eb3f3000 c015a7e5 0000020f bff65b64 bff65af0 Mar 23 15:57:00 alpha kernel: c02d47cb 0000020f 0046eff4 08cd4e6c bff65b64 bff65af0 bff615b8 00000006 Mar 23 15:57:00 alpha kernel: c02d007b 0000007b 00000006 0032a7a2 00000073 00000246 bff61598 0000007b Mar 23 15:57:00 alpha kernel: Call Trace: Mar 23 15:57:00 alpha kernel: [<c015a7e5>] filp_close+0x49/0x5f Mar 23 15:57:00 alpha kernel: [<c02d47cb>] syscall_call+0x7/0xb Mar 23 15:57:00 alpha kernel: [<c02d007b>] packet_rcv+0x17e/0x307 Mar 23 15:57:00 alpha kernel: Code: 00 89 c3 85 d2 74 0e 8b 42 04 8b 12 25 ff ff ff 7f 09 c1 eb ee 89 8b 34 01 00 00 5b c3 55 89 d5 57 89 c7 56 53 8b 40 08 8 b 70 10 <0f> b7 46 20 25 00 f0 00 00 3d 00 40 00 00 75 4d 8d 46 68 e8 fb Mar 23 15:57:00 alpha kernel: <0>Fatal exception: panic in 5 seconds Mar 23 16:06:46 alpha syslogd 1.4.1: restart. So it seems like httpd crashed my server? I checked the Apache error_log and noticed lines like these:
Code: *** glibc detected *** free(): invalid pointer: 0x08872c98 *** [Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] Premature end of script headers: /home/user/public_html/forum/index.php [Fri Mar 23 15:57:03 2007] [error] [client x.x.x.x] File does not exist: /home/user/public_html/500.shtml When I look at the whole error_log it seems like such errors appear frequently and for different websites and PHP applications. This isn't the only glibc error, there's also stuff like "*** glibc detected *** corrupted double-linked list: 0x088e0bb8 ***". I have recently installed eAccelerator and searched the web: I'm not the only one who has such problems with eAccelerator. Do you think these glibc errors may have caused the server to crash?
Also, lately I noticed a lot of lines like these in the /var/log/messages file:
Code: Mar 23 15:47:45 alpha kernel: post_create: setxattr failed, rc=122 (dev=sda7 ino=4318565) and
Code: Mar 23 15:50:56 alpha ntpd[2958]: sendto(66.111.46.200): Operation not permitted I've done some Google'ing on the first error and it seems like someone with the same error got it fixed by running a filesystem check... By the way /dev/sda7 is my /home directory. But in order to run a filesystem check I need to disable all services and unmount /home? That's kind of a pain in the ***... In general, how long do you think it takes to run a filesystem check? Here's information about my /home partition:
I'm running a WAMP server, hosting an internal website for my company's use.
Windows XP Home SP3 Apache 2.0 MySQL Server 5.5 PHP 5.?
Last night Microsoft Security Essentials froze while running a scan. I restarted the scan and it froze again, so I rebooted the server. Now Apache won't start, providing the following error ....
after reinstalling the mta / postfix / smtp (because I couldn't send mails) my plesk is crashed.
I wanted to log in as admin but it doesn't accept my PW. Now with root and then it wants me to accept the license.
Now I copy all my /var/www/vhosts/ maybe when I do the setup steps in plesk it will overwrite all my website content... I hope not all plesk settings are away.
Why I pay every month money for a license? The trouble and work I have with Plesk..
My server hard disk is crashed badly. The rescue function in the server cannot take part and so I've tried using some recovery software to get back my data.
I've tried using Easy Recovery Professional. It sort all the files by it file type into different folder. I found a folder named .DB, there are also some .ado and . ldb folder too. I guess one of it is my database. The problem now is, i dunno how to read the file.
Do you have any idea to read it? I've tried many recovery system. eg. DiskInternals Linux Recovery, Disk Doctor Linux Recovery.
It seems the servers dns will not resolve and has crashed. When starting the "Named" service, here is the error:
Error in named configuration: zone 0.0.127.IN-ADDR.ARPA/IN: loaded serial 20010622 zone 215.170.107.in-addr.arpa/IN: loaded serial 1433121512 zone lanewgirl.com/IN: NS 'ns.mydomain.com' has no address records (A or AAAA)
zone mydomain.com/IN: not loaded due to errors.
_default/mydomain.com/IN: bad zone
zone mydomain2.com/IN: NS 'ns.mydomain2.com' has no address records (A or AAAA)
i've created VPS with OpenVZ.And there is some problem i have access the vps and it's show some error
Code: VM creation has failed. Reason: Private area already exists in /vz/private/250 .At the moment i forgot my SSH details..only i know my hypervm "root" details..where i log with admin password.I need to fix this because some clients of my hosting company is waiting and my number of VPS is limited.
Disk /dev/sda: 160.0 GB, 160041885696 bytes 255 heads, 63 sectors/track, 19457 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System /dev/sda1 * 1 57 457821 83 Linux /dev/sda2 58 15355 122881185 83 Linux /dev/sda3 15356 15616 2096482+ 82 Linux swap / Solaris /dev/sda4 15617 19457 30852832+ 8e Linux LVM
All the log is under a single file, occupying huge amount of space on our server use lxadmin for the vps
we are unable to even open up the file, as we have almost run out of space, we would atleast like to delete around old logs older than a month, this logs are from 3 months, so please help us in solving this problem
if we delete the sql log, will a new log be created automatically or it gives an error?
can i activate the deletion command for 10 or 30 mins and then stop it? i think by this way we cant delete some files from the dir and not all the files so i can edit my files
i want to do this because my server doesnt respond to any file system command because my hardisk is full! so i need to remove some files by any way