Mysql Archives - Page 6 of 9 - Aarvi Server Solutions

July 15, 2016
Linux, Mysql

mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’

While creating of backup of mysql I was getting below error mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’ (Errcode: 24 “Too many open files”)’ The error is due to Mysql exceeding the limit of open files on mysql So I just went ahead and saw the open file limit MariaDB [(none)]> SHOW VARIABLES […]

April 11, 2016
Mysql

[AuthFailure] Either the username was not recognised, or the password was incorrect)

Getting error on XVNC for password authentication I could see below error in logs [AuthFailure] Either the username was not recognised, or the password was incorrect) After googling I found vnc server will need to be restarted once password is reset root@online [~]# /etc/init.d/vncserver-virtuald restart root@online [~]# /etc/init.d/vncserver-x11-serviced restart Now VNC work fine

September 10, 2015
cPanel, Linux, Mysql

Got error 28 from storage engine (1030) Mysql

While working on clients server today I got the error on database while making backup of all the database using mysql dump The error was ” Got error 28 from storage engine (1030)” root@hostonline [/tmp]# mysqldump –all-databases > all_databases.sql & [1] 19341 root@hostonline [/tmp]# mysqldump: Couldn’t execute ‘SHOW TRIGGERS LIKE ‘phpbb\_posts”: Got error 28 from […]

August 27, 2015
cPanel, Mysql, PHP

libMagickWand.so.2: cannot open shared object file

While working on one cPanel server we could see below error in error_log file for one client libMagickWand.so.2: cannot open shared object file The error log were filled by such errors reinstalling imagemagick using command /scripts/installimagemagick didnt work as error were still persisting . So renamed the php,ini file mv /usr/local/lib/php.ini /usr/local/lib/php.ini-old Now to regenerate […]

August 14, 2015
cPanel, Linux, Mysql

Can’t create new tempfile Mysql

While working today came across new error in Mysql ” [myfuncol_student.ow_base_config] error: Can't create new tempfile: './myfuncol_student/ow_base_config.TMD Repairing the Mysql didn’t fix this issue mysql> repair table ow_base_config; +———————————+——–+———-+——————————————————————–+ | Table | Op | Msg_type | Msg_text | +———————————+——–+———-+——————————————————————–+ | myfuncol_student.ow_base_config | repair | error | Can’t create new tempfile: ‘./myfuncol_student/ow_base_config.TMD’ | | myfuncol_student.ow_base_config | […]

June 28, 2015
Linux, Mysql

Innodb recovery

We were getting below error on checking # /etc/init.d/mysqld status ERROR! MySQL is running but PID file could not be found On trying to restart were getting below error root@alpha [~]# /scripts/restartsrv_mysqlWaiting for “mysql” to restart ……………failed. Service ErrorThe “mysql” service failed to start. Startup LogStarting MySQL………… SUCCESS! Log Messages150627 23:53:37 mysqld_safe mysqld restarted150627 23:53:37 […]

June 21, 2015
cPanel, Mysql

Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table

Have you been getting below error “Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table” To fix this issue follow below method, Please remove the following entry from /etc/my.cnf and then restart MySQL: skip-name-resolve The restart mysql using /scripts/restartsrv_mysql This fixes the issue

March 17, 2015
Mysql

VM creation has failed. Reason: No ploop support in the kernel, or kernel is way too old. Make sure you have OpenVZ kernel 042stab058.7 or later running, and kernel ploop modules loaded.

VM creation has failed. Reason: No ploop support in the kernel, or kernel is way too old. Make sure you have OpenVZ kernel 042stab058.7 or later running, and kernel ploop modules loaded. Creation of container private area failed SOlusi : cek file berikut : It seems you are using EL5 kernel. Edit /etc/vz/vz.conf change: VE_LAYOUT=ploop […]

March 17, 2015
Mysql

email trace in cpanel shows invalid date

We tried to repair the smtp table in the eximstats database and it showed the following result. myisamchk: error: ‘/var/lib/mysql/eximstats/smtp.MYI’ is not a MyISAM-table Fix: ls -al /usr/local/cpanel/etc/eximstats_db.sql mysqladmin drop eximstats mysqladmin create eximstats mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql

March 17, 2015
Mysql

make: *** [ffmpeg_frame.lo] Error 1 ffmpeg

This error occurs due to a missing file ‘ffmpeg_frame.lo‘ in the ffmpeg-php source, while your ffmpeg-php source may contain the file named ‘ffmpeg_frame.loT‘. – To Resolve this issue you just need to rename the ‘ffmpeg_frame.loT‘ to ‘ffmpeg_frame.lo‘ and make again

Mysql

mysqldump: Error: ‘Out of resources when opening file ‘/tmp/#sql_466b_2.MAI’

[AuthFailure] Either the username was not recognised, or the password was incorrect)

Got error 28 from storage engine (1030) Mysql

libMagickWand.so.2: cannot open shared object file

Can’t create new tempfile Mysql

Innodb recovery

Error from MySQL query: DBD::mysql::db do failed: Can’t find any matching row in the user table

VM creation has failed. Reason: No ploop support in the kernel, or kernel is way too old. Make sure you have OpenVZ kernel 042stab058.7 or later running, and kernel ploop modules loaded.

email trace in cpanel shows invalid date

make: *** [ffmpeg_frame.lo] Error 1 ffmpeg

Additionally, a 503 Service Unavailable error

PHP Fatal error: Uncaught Error: Call to undefined function wp()

Inoddb recovery from crash

Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB

Let’s Get Started!

Questions? we got answers!

Featured Articles

Services

Contacts