Select Page

mysql error


How to resolve “InnoDB: Unable to lock ./ibdata1, error: 11”

ERROR (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

 

This is a commonly seen error in database driven sites. The same error can show up when a connection or restart for MySQL server is attempted via commandline.

A quick check of the log files may reveal that the actual error faced by MySQL server is “InnoDB: Unable to lock ./ibdata1, error: 11”.

In our role as Outsourced Tech Support for web hosting providers, database errors are one major category of issues we resolve for the customers.

(more…)

MySQL “stop: Unknown instance:” error – Why it happens and how to fix

Server errors are no fun.

And it is especially frustrating when the error is cryptic, like “Unknown instance“.

What does it mean, really?

A common error people face in VPS, Cloud and Dedicated servers is MySQL failing with “stop: Unknown instance:(more…)

How to fix MySQL “job failed to start” error

Bobcares.com provides Server Maintenance Services to web hosts, digital marketers and other online businesses.

As part of our services, we manage MySQL servers, and troubleshoot performance issues and server errors. (more…)

How to fix “MySQL conflicts with file from package” error in cPanel

file /usr/share/mysql/dutch/errmsg.sys from install of MySQL56-server-5.6.39-1.cp1162.x86_64 conflicts with file from package mysql-community-common-5.7.22-1.el6.x86_64

This is a common error during cPanel update- ‘MySQL conflicts with file from package‘.

Being a provider of server support and maintenance service, solving such issues is all in a day’s work for us.

In today’s post, we’ll take a look at this update failure and how we resolve this for our customers. (more…)

How to fix error in Mysql “tablespace is missing for table XXXXX”

Here at Bobcares, our Hosting Support Engineers monitor & maintain servers of web hosts, digital marketers and other online businesses.

A vast majority of these servers use MySQL as the database server, and a common error seen in them is:

1812 Tablespace is missing for table XXXX

(more…)

How to fix Magento error “Syntax error or access violation: 1118 Row size too large”

As a server administration company, we often get support requests from website and server owners.

Recently we were called on to fix this error in a Magento 2 server:

SQLSTATE[42000]: Syntax error or access violation:1118 Row size too large. The Maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

(more…)