MySQL server has gone away, SQL

[aph]

I'm unable to reach otrsI am getting the following error from the log

Code: Select all

[Error][Kernel::System::PID::PIDGet][181] MySQL server has gone away, SQL: '
            SELECT process_name, process_id, process_host, process_create, process_change
            FROM process_id
            WHERE process_name = ? LIMIT 1'
[Fri Jan 30 09:33:08 2015][Error][Kernel::System::DB::new][223] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Any idea why this error might be occuring?

[eandrex]

when you exec

perl otrs.CheckDB.pl

what does it display?

[aph]

I was able to resolve the problem. It was a firewall problem.

[aph]

Apparently this was not a firewall problem.

I get the following error again

Code: Select all

[Wed Feb  4 10:10:02 2015][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterMailbox, because it's already running (otrs.limbachgruppe.com/1832)!
[Wed Feb  4 10:13:54 2015][Error][Kernel::System::PID::PIDGet][181] MySQL server has gone away, SQL: '
            SELECT process_name, process_id, process_host, process_create, process_change
            FROM process_id
            WHERE process_name = ? LIMIT 1'
[Wed Feb  4 10:13:54 2015][Error][Kernel::System::DB::new][223] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[Wed Feb  4 10:15:02 2015][Notice][main::_Status] Scheduler Daemon status request! PID 1839
[Wed Feb  4 10:15:02 2015][Notice][main::_Stop] Scheduler Daemon Stop! PID 1839
[Wed Feb  4 10:15:03 2015][Notice][main::_Start] Scheduler Daemon start! PID 2250

I can't follow the process part from the log

Code: Select all

SELECT process_name, process_id, process_host, process_create, process_change
            FROM process_id
            WHERE process_name = ? LIMIT 1'

What could be the reason behind it. How can I resolve it

[crythias]

a search might help.