• Home
  • About Us
  • FAQs
  • Blog
Aarvi

Mysql

Inoddb recovery from crash

We had a Inoddb database crash in server , Where Mysqld was not starting. So first we checked on what databases tables are crashed or corrupted using command mysqlcheck -A –all-databases and repaired it using mysqlcheck –auto-repair –all-databases You can check in below URL for additional functions using mysqlcheck https://mariadb.com/kb/en/mysqlcheck/ First thing we did was […]
Read more

MySQL: Stale lock file prevents the service from starting

Attempting to start the MySQL service results in the following error: [ERROR] Unix socket lock file is empty /var/lib/mysql/mysql.sock.lock. [ERROR] Unable to setup unix socket lock file. Below were the errors in mysql error log 2021-01-06T01:29:39.630848Z 0 [Note] – ‘127.0.0.1’ resolves to ‘127.0.0.1’; 2021-01-06T01:29:39.630871Z 0 [Note] Server socket created on IP: ‘127.0.0.1’. 2021-01-06T01:29:39.630932Z 0 [ERROR] […]
Read more

error: libcare:3 bad rotation count ‘5

Got an error from Anacron below error error: libcare:3 bad rotation count ‘5 # keep 5 last archives’ error: found error in /var/log/libcare/*.log , skipping The fix to this issue was open file /etc/logrotate.d/libcare /var/log/libcare/*.log { daily rotate 5 #keep 5 last archives missingok # it’s ok if there is no such file notifempty # […]
Read more

Cannot open /var/log/sa/sa09: No such file or directory

Have been getting emails on below error “Cannot open /var/log/sa/sa09: No such file or directory” The solution is to reinstall cronie-anacron using command yum reinstall cronie-anacron Loaded plugins: fastestmirror, universal-hooks Loading mirror speeds from cached hostfile EA4: 208.74.123.61 cpanel-addons-production-feed: 208.74.123.61 cpanel-plugins: 208.74.123.61 base: mirror.oss.ou.edu extras: mirror.oss.ou.edu updates: mirror.netdepot.com EA4 | 2.9 kB 00:00:00 cpanel-addons-production-feed | […]
Read more

Error Couldn’t find device with uuid

Got an error while working on a LVM system [root@ok1x40 daily]# vgs WARNING: Device for PV zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x not found or rejected by a filter. WARNING: Device for PV zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x not found or rejected by a filter. Couldn’t find device with uuid zwUwUP-OyCI-O3T4-c4l5-YCUV-8wpX-3UIA0x. VG #PV #LV #SN Attr VSize VFree vg 1 1 0 wz-pn- <9.88g […]
Read more

Roundcube from Mysql to Sqlite

As new cPanel versions come with SQLite While migrating from old server which has MySQL format to new SQLite server You need to convert to SQLite to preserve data and migrate without issues Below is the command used on old server to convert MySQL ro SQLite for Roundcube /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite
Read more

YumRepo Error: All mirror URLs are not using ftp, http[s] or file.

Have been getting below error on one of the Centos 5 VM where yum is not working and giving below error yum update kernel Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile YumRepo Error: All mirror URLs are not using ftp, http[s] or file. Eg. Invalid release/repo/arch combination/ removing mirrorlist with no valid mirrors: […]
Read more

Error restoring a particular database

[root@OK1053 mysql]# mysql uulimain_testagain < /home/uulimain/public_html/uulimain_testagain.sql ERROR 1067 (42000) at line 242: Invalid default value for ‘up_to_date_as_of’ For this error need to cross-check the mysql version of database backup from where is imported and also the mysql version on the current server, if both are same database will restore.
Read more

The MySQL Connection could not be established. Joomla

While instaling Joomla using softaculous was getting error The MySQL Connection could not be established Mysql was working fine   issue was with Mysql not supporting more then 16 characters in database name. in advanded setting I changed database name which resolved this issue  
Read more