Find Jobs
Hire Freelancers

Fix MySQL on WHM / cPanel Server

$10-30 USD

Cancelled
Posted about 9 years ago

$10-30 USD

Paid on delivery
I am having issues restarting the MySQL on a server. This is what panel wrote me below. I need the mysql fixed and need to be able to use InnoDB. 150310 16:46:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 371445860714 InnoDB: 1 transaction(s) which must be rolled back or cleaned up InnoDB: in total 1 row operations to undo InnoDB: Trx id counter is A793C00 150310 16:46:19 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Starting in background the rollback of uncommitted transactions 150310 16:46:19 InnoDB: Rolling back trx with id A793A4B, 1 rows to undo 150310 16:46:19 InnoDB: Waiting for the background threads to start 150310 16:46:19 InnoDB: Assertion failure in thread 47920511842624 in file [login to view URL] line 83 InnoDB: Failing assertion: [login to view URL] == FIL_NULL || [login to view URL] >= FIL_PAGE_DATA InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: [login to view URL] InnoDB: about forcing recovery. 21:46:19 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=125 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 281667 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x3e800 /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7e4ae5] /usr/sbin/mysqld(handle_fatal_signal+0x3e1)[0x69afe1] /lib64/libpthread.so.0[0x3a3080eca0] /lib64/libc.so.6(gsignal+0x35)[0x3a3002ffc5] /lib64/libc.so.6(abort+0x110)[0x3a30031a70] /usr/sbin/mysqld[0x8f73b0] /usr/sbin/mysqld[0x874ca0] /usr/sbin/mysqld[0x88aa43] /usr/sbin/mysqld[0x8856bd] /usr/sbin/mysqld[0x87c37e] /usr/sbin/mysqld[0x93cec3] /usr/sbin/mysqld[0x93d01b] /usr/sbin/mysqld[0x87e8c9] /usr/sbin/mysqld[0x87eef9] /lib64/libpthread.so.0[0x3a3080683d] /lib64/libc.so.6(clone+0x6d)[0x3a300d4fcd] The manual page at [login to view URL] contains information that should help you find out what is causing the crash. 150310 16:46:19 mysqld_safe mysqld from pid file /var/lib/mysql/[login to view URL] ended At this point to get your system online we can either set MySQL to start without InnoDB or you may try working with a MySQL Database Administrator to recover InnoDB on the system or restore any backups of databases you have to get it back up and running. If you'd like me to try to get MySQL online sans InnoDB just let me know.
Project ID: 7284766

About the project

6 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $39 USD for this job
User Avatar
If you have mysql dumps backups - I can help you ************************************************************************************************************************************************************************************************************************************************************************************************************************************************
$50 USD in 1 day
4.8 (211 reviews)
6.8
6.8
User Avatar
Hello. I woud like to help you witg recovert mysql database INNODB. I have a lot of experience with linux.
$50 USD in 1 day
4.9 (420 reviews)
6.7
6.7
User Avatar
Hello, I am an experience system admin and i can help you in this project. You can view my profile for similar projects i have completed. I am ready to start on it and if you have any query please feel free to ask. Thanks.
$60 USD in 1 day
4.9 (160 reviews)
6.4
6.4
User Avatar
Dear sir, I will complete your project asap, LIFETIME error free guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "Fix MySQL on WHM / cPanel Server" and have analysed that I have right credentials (Linux, MySQL) to execute your esteemed project. You will never go wrong choosing me :)
$20 USD in 1 day
5.0 (37 reviews)
5.9
5.9
User Avatar
I'm David from Xieles Support. We have done many server setup which includes web service, mail service, DNS service. We are experts in troubleshooting Mysql issues. Xieles Support has been in server administration and technical support industry for the last 6 years, providing unmatched 24x7 server administration and web hosting support. We are experts in Web Hosting and specialize in Linux and Windows Server Administration. We also support various virtualization platforms like KVM, Xen, Virtuozzo, OpenVZ, HyperV and Vmware, and have enormous amount of experience in web hosting control panels like cPanel, Directadmin, Parallels Plesk, Webmin/Virtualmin etc. Lets discuss about this in detail.
$25 USD in 1 day
4.9 (23 reviews)
4.6
4.6
User Avatar
Hi, I'm Professional admin & I can help you :) fast & pro fix/installation high knownledge about severs from 10y I can give you invoice Best Regard Greg
$30 USD in 3 days
4.6 (5 reviews)
2.8
2.8

About the client

Flag of UNITED STATES
Grand Rapids, United States
5.0
31
Payment method verified
Member since Feb 19, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.