Fatal Error?

hi all
today in my office at 13:00 i not receive any calls.
So i test to call on my number and on my mobile phone i felt the hold music but my phones not receive the call.
After i try to go on my admin panel and i saw this message:

FATAL ERROR
DB Error: connect failed
Trace Back/var/www/html/admin/libraries/db_connect.php:71 die_freepbx()

0: DB Error: connect failed

/var/www/html/admin/bootstrap.php:91 require_once()

/etc/freepbx.conf:9 require_once()

/var/www/html/admin/config.php:99 include_once()

I don’t undestand why, but now not working.
I not update from 2-3 weeks

What i can do? I have to reinstall all??

service mysqld start

And also check that your harddrive is not full.

1 Like

hard disk is not full, i have 20 GB in total and i used only 2GB

with service mysqld start i have this error:

[[email protected] ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[[email protected] ~]#

Hi
Now i have the same problem.
In the past i reset all reinstall all but was too long…
If i write command line SERVICE MYSQLD START i receive FAILED

What i can do??
Help me please :frowning:

Hi,

You need to delete the socket file of the mysql server like this:
rm -f /var/lib/mysql/mysql.sock

Then try to start the mysql service again:
service mysqld start

Thank you,

Daniel Friedman
Trixton LTD.

Hello danielf
I removed this file but when i try to start the service i receive FAILED.

If i go on the admin panel i see always the error message (also now with this file removed)
I tryed to reboot the system but nothing…

What i can do? :disappointed_relieved::disappointed_relieved:

Hi,

Please paste here your logs from your actions. Can you also paste the output of this shell command:
ps aux | grep mysql

Thank you,

Daniel Friedman
Trixton LTD.

hi danielf, now i come back in the office and i can make all you ask me, where i can take the log you ask me?

This is the result of the command you ask me in the last message:

root 1355 66.1 7.4 182448 75588 ? R Dec06 2158:49 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
root 52401 0.0 0.0 103312 828 pts/0 S+ 17:00 0:00 grep mysql

Thank you

Hi,

You need to kill your mysqld service like that:
kill -9 1355

Then:
rm -f /var/lib/mysql/mysql.sock

And then:
service mysqld start

Thank you,

Daniel Friedman
Trixton LTD.

hi,
i follow your guide but i receive it:

[[email protected] ~]# kill -9 1355
[[email protected] ~]# rm -f /var/lib/mysql/mysql.sock
[[email protected] ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]
[[email protected] ~]#

What other can i do?
Thank you

Hi,

Can you paste again the output of this shell command:

ps aux | grep mysql

Daniel Friedman
Trixton LTD.

hi
this is the result

[[email protected] ~]# ps aux | grep mysql
root 55374 0.0 0.0 103308 828 pts/0 S+ 17:35 0:00 grep mysql
root 61488 37.8 0.5 112216 5356 pts/0 R 17:22 5:03 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
[[email protected] ~]#

Hi,

Kill your mysql service and validate that it is killed:
kill -9 61488

And then (several times):
ps aux | grep mysql

If you see no mysql processes in the ps command start the mysql service again:
service mysqld start

Thank you,

Daniel Friedman
Trixton LTD.

hi
i’m trying with ps aux | grep mysql many many times, for now about 50 times, and always change the first number, for example:

[[email protected] ~]# ps aux | grep mysql
root 6622 0.0 0.0 103308 820 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql
root 6624 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql
root 6626 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql
root 6628 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql
root 6630 0.0 0.0 103308 824 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql
root 6632 0.0 0.0 103308 820 pts/0 S+ 18:13 0:00 grep mysql
[[email protected] ~]# ps aux | grep mysql

i have to continue with this command?

Hi,

It seems that there is no mysqld instance running. You can try to start the service.
if it fails again, please paste the log from the /var/log/mysqld.log

Thank you,

Daniel Friedman
Trixton LTD.

i receive failed message :frowning:

The log file is very long, how i can paste all? you need a specific line?

[[email protected] ~]# more /var/log/mysqld.log
151025 15:51:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 15:51:20 InnoDB: Initializing buffer pool, size = 8.0M
151025 15:51:20 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
151025 15:51:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
151025 15:51:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
151025 15:51:20 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
151025 15:51:20 InnoDB: Started; log sequence number 0 0
151025 15:51:20 [Note] Event Scheduler: Loaded 0 events
151025 15:51:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 15:51:56 [Note] /usr/libexec/mysqld: Normal shutdown

151025 15:51:56 [Note] Event Scheduler: Purging the queue. 0 events
151025 15:51:56 InnoDB: Starting shutdown…
151025 15:52:00 InnoDB: Shutdown completed; log sequence number 0 44233
151025 15:52:00 [Note] /usr/libexec/mysqld: Shutdown complete

151025 15:52:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 15:52:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 15:52:54 InnoDB: Initializing buffer pool, size = 8.0M
151025 15:52:54 InnoDB: Completed initialization of buffer pool
151025 15:52:57 InnoDB: Started; log sequence number 0 44233
151025 15:52:58 [Note] Event Scheduler: Loaded 0 events
151025 15:52:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 18:02:29 [Note] /usr/libexec/mysqld: Normal shutdown

151025 18:02:29 [Note] Event Scheduler: Purging the queue. 0 events
151025 18:02:29 InnoDB: Starting shutdown…
151025 18:02:34 InnoDB: Shutdown completed; log sequence number 0 44233
151025 18:02:34 [Note] /usr/libexec/mysqld: Shutdown complete

151025 18:02:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 18:03:37 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 18:03:37 InnoDB: Initializing buffer pool, size = 8.0M
151025 18:03:37 InnoDB: Completed initialization of buffer pool
151025 18:03:37 InnoDB: Started; log sequence number 0 44233
151025 18:03:37 [Note] Event Scheduler: Loaded 0 events
151025 18:03:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: ‘5.1.73’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
151025 21:48:49 [Note] /usr/libexec/mysqld: Normal shutdown

151025 21:48:49 [Note] Event Scheduler: Purging the queue. 0 events
151025 21:48:49 InnoDB: Starting shutdown…
151025 21:48:50 InnoDB: Shutdown completed; log sequence number 0 44233
151025 21:48:50 [Note] /usr/libexec/mysqld: Shutdown complete

151025 21:48:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
151025 21:49:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
151025 21:49:53 InnoDB: Initializing buffer pool, size = 8.0M
–More–(0%)

BUT it continue…

Hi,

paste this command results:
cat /var/log/mysqld.log | tail -100

Thank you,

Daniel Friedman
Trixton LTD.

hi,
this is the result:

[[email protected] ~]# cat /var/log/mysqld.log | tail -100
151209 0:08:47 InnoDB: Completed initialization of buffer pool
151209 0:08:47 InnoDB: Started; log sequence number 0 44233
151209 0:08:47 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:47 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:47 mysqld_safe Number of processes running now: 0
151209 00:08:47 mysqld_safe mysqld restarted
151209 0:08:47 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:47 InnoDB: Completed initialization of buffer pool
151209 0:08:47 InnoDB: Started; log sequence number 0 44233
151209 0:08:47 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:47 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:47 mysqld_safe Number of processes running now: 0
151209 00:08:47 mysqld_safe mysqld restarted
151209 0:08:48 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:48 InnoDB: Completed initialization of buffer pool
151209 0:08:48 InnoDB: Started; log sequence number 0 44233
151209 0:08:48 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:48 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:48 mysqld_safe Number of processes running now: 0
151209 00:08:48 mysqld_safe mysqld restarted
151209 0:08:49 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:49 InnoDB: Completed initialization of buffer pool
151209 0:08:49 InnoDB: Started; log sequence number 0 44233
151209 0:08:49 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:49 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:49 mysqld_safe Number of processes running now: 0
151209 00:08:49 mysqld_safe mysqld restarted
151209 0:08:50 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:50 InnoDB: Completed initialization of buffer pool
151209 0:08:50 InnoDB: Started; log sequence number 0 44233
151209 0:08:50 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:50 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:50 mysqld_safe Number of processes running now: 0
151209 00:08:50 mysqld_safe mysqld restarted
151209 0:08:50 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:50 InnoDB: Completed initialization of buffer pool
151209 0:08:50 InnoDB: Started; log sequence number 0 44233
151209 0:08:50 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:50 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:50 mysqld_safe Number of processes running now: 0
151209 00:08:50 mysqld_safe mysqld restarted
151209 0:08:51 Inn151209 00:08:51 mysqld_safe Number of processes running now: 0
151209 00:08:51 mysqld_safe mysqld restarted
151209 0:08:52 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:52 InnoDB: Completed initialization of buffer pool
151209 0:08:52 InnoDB: Started; log sequence number 0 44233
151209 0:08:52 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:52 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:52 mysqld_safe Number of processes running now: 0
151209 00:08:52 mysqld_safe mysqld restarted
151209 0:08:53 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:53 InnoDB: Completed initialization of buffer pool
151209 0:08:53 InnoDB: Started; log sequence number 0 44233
151209 0:08:53 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:53 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:53 mysqld_safe Number of processes running now: 0
151209 00:08:53 mysqld_safe mysqld restarted
151209 0:08:53 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:53 InnoDB: Completed initialization of buffer pool
151209 0:08:53 InnoDB: Started; log sequence number 0 44233
151209 0:08:53 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:53 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:53 mysqld_safe Number of processes running now: 0
151209 00:08:53 mysqld_safe mysqld restarted
151209 0:08:54 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:54 InnoDB: Completed initialization of buffer pool
151209 0:08:54 InnoDB: Started; log sequence number 0 44233
151209 0:08:54 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:54 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:54 mysqld_safe Number of processes running now: 0
151209 00:08:54 mysqld_safe mysqld restarted
151209 0:08:55 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:55 InnoDB: Completed initialization of buffer pool
151209 0:08:55 InnoDB: Started; log sequence number 0 44233
151209 0:08:55 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:55 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:55 mysqld_safe Number of processes running now: 0
151209 00:08:55 mysqld_safe mysqld restarted
151209 0:08:56 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:56 InnoDB: Completed initialization of buffer pool
151209 0:08:56 InnoDB: Started; log sequence number 0 44233
151209 0:08:56 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:56 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:56 mysqld_safe Number of processes running now: 0
151209 00:08:56 mysqld_safe mysqld restarted
151209 0:08:57 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:57 InnoDB: Completed initialization of buffer pool
151209 0:08:57 InnoDB: Started; log sequence number 0 44233
151209 0:08:57 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:57 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:57 mysqld_safe Number of processes running now: 0
151209 00:08:57 mysqld_safe mysqld restarted
151209 0:08:57 InnoDB: Initializing buffer pool, size = 8.0M
151209 0:08:57 InnoDB: Completed initialization of buffer pool
151209 0:08:58 InnoDB: Started; log sequence number 0 44233
151209 0:08:58 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld /mysqld.pid’ (Errcode: 28)
151209 0:08:58 [ERROR] Can’t start server: can’t create PID file: No space left on device
151209 00:08:58 mysqld_safe Number of processes running now: 0
151209 00:08:58 mysqld_safe mysqld restarted

Now i have another problem (from yesterday):
If i try to remove night service using *280 it not work… :frowning:

Hi,

You have run out of space on your computer:

151209  0:08:53 [ERROR] Can't start server: can't create PID file: No space left on device

Thank you,

Daniel Friedman
Trixton LTD.