Skip to content

Instantly share code, notes, and snippets.

@dk0r
Created August 31, 2020 17:40
Show Gist options
  • Save dk0r/4d8a1b484ca8b12cf0643045b40c6333 to your computer and use it in GitHub Desktop.
Save dk0r/4d8a1b484ca8b12cf0643045b40c6333 to your computer and use it in GitHub Desktop.
Output from user_sync.py
root@ee24356c9381:/home/oncall/src/oncall/bin# ./user_sync.py /home/oncall/configs/config.yaml
2020-08-28 16:34:59,484 INFO oncall.metrics Loaded metrics handler dummy
2020-08-28 16:34:59,484 INFO oncall.metrics Loaded metrics handler dummy
2020-08-28 16:34:59,485 INFO root Starting user sync loop at 1598632499.4854853
2020-08-28 16:34:59,485 INFO root Starting user sync loop at 1598632499.4854853
2020-08-28 16:34:59,510 INFO root Loaded 0 entries from ldap.
2020-08-28 16:34:59,510 INFO root Loaded 0 entries from ldap.
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1278, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "src/gevent/greenlet.py", line 766, in gevent._greenlet.Greenlet.run
File "/home/oncall/src/oncall/user_sync/ldap_sync.py", line 426, in main
sync(config, engine)
File "/home/oncall/src/oncall/user_sync/ldap_sync.py", line 315, in sync
rows = engine.execute('SELECT name FROM user WHERE active = FALSE AND name IN %s', ldap_usernames)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 2238, in execute
return connection.execute(statement, *multiparams, **params)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1006, in execute
return self._execute_text(object_, multiparams, params)
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1181, in _execute_text
parameters,
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1318, in _execute_context
e, statement, parameters, cursor, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1278, in _execute_context
cursor, statement, parameters, context
File "/usr/local/lib/python3.6/dist-packages/SQLAlchemy-1.3.18-py3.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.6/dist-packages/PyMySQL-0.9.3-py3.6.egg/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")
[SQL: SELECT name FROM user WHERE active = FALSE AND name IN %s]
[parameters: (set(),)]
(Background on this error at: http://sqlalche.me/e/13/f405)
2020-08-28T16:34:59Z <Greenlet at 0x7f8d14612248: main({'server': {'host': '0.0.0.0', 'port': 8080}, 'onc)> failed with ProgrammingError
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment