Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created December 9, 2014 02:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoku0825/7acf327cab54302ebb6c to your computer and use it in GitHub Desktop.
Save yoku0825/7acf327cab54302ebb6c to your computer and use it in GitHub Desktop.
$ date ; mysqlfabric group lookup_servers my_third_fabric ; date
Tue Dec  9 11:15:52 JST 2014
Traceback (most recent call last):
  File "/usr/lib64/python2.6/SocketServer.py", line 570, in process_request_thread
    self.finish_request(request, client_address)
  File "/usr/lib/python2.6/site-packages/mysql/fabric/protocols/xmlrpc.py", line 610, in finish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib/python2.6/site-packages/mysql/fabric/protocols/xmlrpc.py", line 222, in __init__
    client_address, server)
  File "/usr/lib64/python2.6/SocketServer.py", line 627, in __init__
    self.handle()
  File "/usr/lib64/python2.6/BaseHTTPServer.py", line 329, in handle
    self.handle_one_request()
  File "/usr/lib64/python2.6/BaseHTTPServer.py", line 323, in handle_one_request
    method()
  File "/usr/lib/python2.6/site-packages/mysql/fabric/protocols/xmlrpc.py", line 259, in do_POST
    protocol='xmlrpc')
  File "/usr/lib/python2.6/site-packages/mysql/fabric/persistence.py", line 132, in _wrap
    return original(*args, **kwrds)
  File "/usr/lib/python2.6/site-packages/mysql/fabric/credentials.py", line 352, in fetch_user
    cur = persister.exec_stmt(_SQL_FETCH_USER, options)
  File "/usr/lib/python2.6/site-packages/mysql/fabric/persistence.py", line 512, in exec_stmt
    self.__cnx, stmt_str, options
  File "/usr/lib/python2.6/site-packages/mysql/fabric/server_utils.py", line 125, in exec_mysql_stmt
    errno
DatabaseError: Command (
SELECT username, protocol, password
FROM users WHERE username = %s AND protocol = %s
, ('', 'xmlrpc')) failed accessing (127.0.0.1:5621). MySQL Connection not available..
Traceback (most recent call last):
  File "/usr/bin/mysqlfabric", line 443, in <module>
    main()
  File "/usr/bin/mysqlfabric", line 424, in main
    fire_command(cmd, *cargs)
  File "/usr/bin/mysqlfabric", line 356, in fire_command
    result = command.dispatch(*(command.append_options_to_args(args)))
  File "/usr/lib/python2.6/site-packages/mysql/fabric/command.py", line 415, in dispatch
    return self.client.dispatch(self, *args)
  File "/usr/lib/python2.6/site-packages/mysql/fabric/protocols/xmlrpc.py", line 820, in dispatch
    packet = getattr(self, reference)(*args)
  File "/usr/lib64/python2.6/xmlrpclib.py", line 1199, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib64/python2.6/xmlrpclib.py", line 1489, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.6/site-packages/mysql/fabric/protocols/xmlrpc.py", line 755, in request
    result = opener.open(req)
  File "/usr/lib64/python2.6/urllib2.py", line 397, in open
    response = meth(req, response)
  File "/usr/lib64/python2.6/urllib2.py", line 510, in http_response
    'http', request, response, code, msg, hdrs)
  File "/usr/lib64/python2.6/urllib2.py", line 429, in error
    result = self._call_chain(*args)
  File "/usr/lib64/python2.6/urllib2.py", line 369, in _call_chain
    result = func(*args)
  File "/usr/lib64/python2.6/urllib2.py", line 1068, in http_error_401
    host, req, headers)
  File "/usr/lib64/python2.6/urllib2.py", line 953, in http_error_auth_reqed
    return self.retry_http_digest_auth(req, authreq)
  File "/usr/lib64/python2.6/urllib2.py", line 964, in retry_http_digest_auth
    resp = self.parent.open(req, timeout=req.timeout)
  File "/usr/lib64/python2.6/urllib2.py", line 391, in open
    response = self._open(req, data)
  File "/usr/lib64/python2.6/urllib2.py", line 409, in _open
    '_open', req)
  File "/usr/lib64/python2.6/urllib2.py", line 369, in _call_chain
    result = func(*args)
  File "/usr/lib64/python2.6/urllib2.py", line 1190, in http_open
    return self.do_open(httplib.HTTPConnection, req)
  File "/usr/lib64/python2.6/urllib2.py", line 1163, in do_open
    r = h.getresponse()
  File "/usr/lib64/python2.6/httplib.py", line 990, in getresponse
    response.begin()
  File "/usr/lib64/python2.6/httplib.py", line 391, in begin
    version, status, reason = self._read_status()
  File "/usr/lib64/python2.6/httplib.py", line 355, in _read_status
    raise BadStatusLine(line)
httplib.BadStatusLine
Tue Dec  9 11:15:58 JST 2014

6秒は長すぎると思うんだ。。(しかも、都度だぜ…?)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment