Error Unable to open PDO Connection

[prathmes...@gmail.com]

Hello,

 Our Atom Instance of version 1.3 has been UN-epxectedly crashing on our production Server. It's producing the following error and also refer the attached Screen Shot,

Unable to open PDO Connection: Cant connect to local MySQL server through Socket 'var/run/mysql/mysql.sock' (111)

Whenever I restart the server, clear symfony Cache and re-build the Search index, the Problem temporarily fixes itself but crashes again after some time .

By the error message it seems it has trouble connecting to the Database or maybe something to do with the php-module. Can someone let me know how to fix this.

Any help, is appreciated !


Thanks,
Prathmesh Mengane,
Database and CMS Developer,
Dumbarton Oaks.

[Sebastjan Auser]

Hi,

is your MySQL server running?

If is not running check your MySQL log file to see errors. We had similar problem on our productin server. MySQL server was down.
When I have checked log files I saw that scratch disk was full, and that is reason why your MySQL server refused to start.

I hope that this will help you.

Best regards,
Sebastjan

--
You received this message because you are subscribed to the Google Groups "ICA-AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at http://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/f099dd66-2a5b-4516-be8a-52e338d92d64%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
Lp,
Sebastjan Auser

Digital Archive Solutions
gsm: +386 (0)30 363 003

www.archive-smh.info
www.da-slo.si
www.da-slo.com.au

Sent from mobile1

[prathmes...@gmail.com]

Hi Sebastjan,

  When I currently checked our MySQL status, its running fine and here is the status report :

Uptime: 7530  Threads: 1  Questions: 114520  Slow queries: 0  Opens: 429  Flush tables: 1  Open tables: 110  Queries per second avg: 15.208

But this status is when our Atom is working fine. Did you mean that your MySQL server was not running when Atom Crashed ?
I'll report back with the MySQL server status when the Atom Crashes again.

Best,
Prathmesh

[Sebastjan Auser]

Hi,

yes, when AtoM crashed, MySQL server was down.

Best regards,

Sebastjan

To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/43edeb7f-010c-4ce1-9c35-da3231d00374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[prathmes...@gmail.com]

Hi Sebastjan,

   You were right, the MySQL server was down whenever the Atom crashes.

mysqladmin -u root status
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

We have restarted the mysqld service and the Instance is running fine for now. It's happening because of Server running out of memory, which might be caused due to inefficient MySQL queries related to Atom or Something else. We will be further analyzing and  keeping an eye on the situation

Thanks for the help !

-Prathmesh Mengane,

Database and CMS Developer,
Dumbarton Oaks.