Created
August 31, 2020 17:40
-
-
Save dk0r/4d8a1b484ca8b12cf0643045b40c6333 to your computer and use it in GitHub Desktop.
Output from user_sync.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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