New subject: [opensuse-buildservice] Re: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock

23 Apr 2013


      Hi,All
     My OBS instance sets up on opensuse 11.4 (64bit).The version of OBS
server is 2.3.3. The version of Mysql client is 5.1.63.
     Now I Encountered a problem about OBS server. When I refresh a page
always, I got an error says "Application Error" and the webui's log tells me
"
=====================================================================
[INFO |# 7620] Processing MonitorController#index (for 192.168.1.89 at
2013-04-23 14:13:02) [GET]
[INFO |# 7620]   Parameters: {"controller"=>"monitor", "action"=>"index"}
[INFO |# 7620] Authenticated request to "/monitor" from cheneyche
[INFO |# 7620] Rendering template within layouts/application
[INFO |# 7620] Rendering monitor/index
[INFO |# 7620] Completed in 757ms (View: 26, DB: 283) | 200 OK
[http://192.168.1.24/monitor]


[INFO |# 7620] Processing MonitorController#index (for 192.168.1.89 at
2013-04-23 14:13:03) [GET]
[INFO |# 7620]   Parameters: {"controller"=>"monitor", "action"=>"index"}
[INFO |# 7620] Authenticated request to "/monitor" from cheneyche

[FATAL|# 7620] BsRequest::ListError (<!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD
HTML 4.01 Transitional//EN&quot;
   &quot;http://www.w3.org/TR/html4/loose.dtd&quot;>
<html>
<body>
 ):
  app/models/bs_request.rb:155:in `list'
  app/models/person.rb:195:in `requests_that_need_work'
  app/models/person.rb:192:in `requests_that_need_work'
  app/controllers/application_controller.rb:335:in `check_user'
  /usr/lib64/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib64/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib64/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib64/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib64/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib64/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib64/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib64/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib64/ruby/1.8/webrick/server.rb:82:in `start'


[ERROR|# 7620] rescue_action: caught BsRequest::ListError: <!DOCTYPE HTML
PUBLIC &quot;-//W3C//DTD HTML 4.01 Transitional//EN&quot;
   &quot;http://www.w3.org/TR/html4/loose.dtd&quot;>
<html>
<body>
 
[ERROR|# 7620] Couldn't parse error xml: #
/usr/lib64/ruby/1.8/rexml/parsers/treeparser.rb:28:in `parse'
/usr/
[INFO |# 7620] Rendering template within layouts/application
[INFO |# 7620] Rendering error (400)
[FATAL|# 7620] /!\ FAILSAFE /!\  Tue Apr 23 14:13:04 +0800 2013
  Status: 500 Internal Server Error
  Mysql::Error: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2): UPDATE `sessions` SET `data` =
'BAh7CzoQbW9iaWxlX3ZpZXdGIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVy\nOjpGbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsAOgtwYXNzd2QiCzExMTEx\nMToNcmVxdWVzdHNbADoKbG9naW4iDmNoZW5leWNoZToQX2NzcmZfdG9rZW4i\nMVF4TFlJQmlRYjBxUXFZMHZtenZxMVptb3dROVNUeDMyVytreTR2L3c3M1U9\n',
`updated_at` = '2013-04-23 14:13:04' WHERE `id` = 5219
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract_adapter.rb:227:in
`log'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:324:in
`execute'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in
`update_sql'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:339:in
`update_sql'
 ……………………
 ……………………
=====================================================================
"
  and the api's log tells me "
=====================================================================
[INFO |#14010] Processing RequestController#index (for 192.168.1.24 at
2013-04-23 13:37:03) [GET]
[INFO |#14010]   Parameters: {"states"=>"declined", "user"=>"cheneyche",
"view"=>"collection", "roles"=>"creator"}
[INFO |#14010] Completed in 112ms (View: 1, DB: 1) | 200 OK
[https://192.168.1.24/request?view=collection&states=declined&roles=creator&user=cheneyche]


[INFO |#14010] Processing RequestController#index (for 192.168.1.24 at
2013-04-23 13:37:03) [GET]
[INFO |#14010]   Parameters: {"states"=>"review", "user"=>"cheneyche",
"view"=>"collection", "reviewstates"=>"new", "roles"=>"reviewer"}
[INFO |#14010] Completed in 579ms (View: 1, DB: 15) | 200 OK
[https://192.168.1.24/request?view=collection&states=review&roles=reviewer&reviewstates=new&user=cheneyche]
[FATAL|#14010] /!\ FAILSAFE /!\  Tue Apr 23 13:37:04 +0800 2013
  Status: 500 Internal Server Error
  Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:620:in
`real_connect'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:620:in
`connect'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:294:in
`reconnect!'
   
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract_adapter.rb:152:in
`verify!'
 ……………………
 ……………………
=======================================================
"   
   I'm sure the service MySql is running.

BRs
cheyw


--
View this message in context: http://opensuse.14.x6.nabble.com/Can-t-connect-to-local-MySQL-server-through...
Sent from the opensuse-buildservice mailing list archive at Nabble.com.
-- 
To unsubscribe, e-mail: opensuse-buildservice+unsubscribe@opensuse.org
To contact the owner, e-mail: opensuse-buildservice+owner@opensuse.org

[opensuse-buildservice] Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock

cheyw

Stephan Kulow

cheyw

Jan Engelhardt

cheyw

tags

participants (3)