API tools faq
paste
Guest User

Untitled

a guest
Oct 27th, 2020
15
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.06 KB | None | 0 0
raw download clone embed print report
  1. [2020-10-27 19:30:34,287] ERROR in app: Exception on /register [POST]
  2. Traceback (most recent call last):
  3. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
  4. cursor, statement, parameters, context
  5. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
  6. cursor.execute(statement, parameters)
  7. File "/usr/local/lib/python3.7/dist-packages/pymysql/cursors.py", line 170, in execute
  8. result = self._query(query)
  9. File "/usr/local/lib/python3.7/dist-packages/pymysql/cursors.py", line 328, in _query
  10. conn.query(q)
  11. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 517, in query
  12. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  13. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 732, in _read_query_result
  14. result.read()
  15. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 1075, in read
  16. first_packet = self.connection._read_packet()
  17. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 684, in _read_packet
  18. packet.check_error()
  19. File "/usr/local/lib/python3.7/dist-packages/pymysql/protocol.py", line 220, in check_error
  20. err.raise_mysql_exception(self._data)
  21. File "/usr/local/lib/python3.7/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
  22. raise errorclass(errno, errval)
  23. pymysql.err.InternalError: (1364, "Field 'id' doesn't have a default value")
  24.  
  25. The above exception was the direct cause of the following exception:
  26.  
  27. Traceback (most recent call last):
  28. File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 2446, in wsgi_app
  29. response = self.full_dispatch_request()
  30. File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1951, in full_dispatch_request
  31. rv = self.handle_user_exception(e)
  32. File "/usr/local/lib/python3.7/dist-packages/flask_restplus/api.py", line 583, in error_router
  33. return original_handler(e)
  34. File "/usr/local/lib/python3.7/dist-packages/flask_cors/extension.py", line 161, in wrapped_function
  35. return cors_after_request(app.make_response(f(*args, **kwargs)))
  36. File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1820, in handle_user_exception
  37. reraise(exc_type, exc_value, tb)
  38. File "/usr/local/lib/python3.7/dist-packages/flask/_compat.py", line 39, in reraise
  39. raise value
  40. File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1949, in full_dispatch_request
  41. rv = self.dispatch_request()
  42. File "/usr/local/lib/python3.7/dist-packages/flask/app.py", line 1935, in dispatch_request
  43. return self.view_functions[rule.endpoint](**req.view_args)
  44. File "/usr/local/lib/python3.7/dist-packages/flask_security/decorators.py", line 498, in wrapper
  45. return f(*args, **kwargs)
  46. File "/usr/local/lib/python3.7/dist-packages/flask_security/views.py", line 273, in register
  47. user = register_user(**form.to_dict())
  48. File "/usr/local/lib/python3.7/dist-packages/flask_security/registerable.py", line 35, in register_user
  49. user_registered.send(app._get_current_object(), user=user, confirm_token=token)
  50. File "/usr/lib/python3/dist-packages/blinker/base.py", line 267, in send
  51. for receiver in self.receivers_for(sender)]
  52. File "/usr/lib/python3/dist-packages/blinker/base.py", line 267, in <listcomp>
  53. for receiver in self.receivers_for(sender)]
  54. File "/opt/osp/app.py", line 362, in user_registered_sighandler
  55. system.newLog(1, "A New User has Registered - Username:" + str(user.username))
  56. File "/opt/osp/functions/system.py", line 105, in newLog
  57. db.session.commit()
  58. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/scoping.py", line 162, in do
  59. return getattr(self.registry(), name)(*args, **kwargs)
  60. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 1027, in commit
  61. self.transaction.commit()
  62. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 494, in commit
  63. self._prepare_impl()
  64. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 473, in _prepare_impl
  65. self.session.flush()
  66. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 2459, in flush
  67. self._flush(objects)
  68. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 2597, in _flush
  69. transaction.rollback(_capture_exception=True)
  70. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
  71. compat.reraise(exc_type, exc_value, exc_tb)
  72. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/util/compat.py", line 154, in reraise
  73. raise value
  74. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/session.py", line 2557, in _flush
  75. flush_context.execute()
  76. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
  77. rec.execute(self)
  78. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 540, in execute
  79. self.dependency_processor.process_saves(uow, states)
  80. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/dependency.py", line 1171, in process_saves
  81. uowcommit, secondary_insert, secondary_update, secondary_delete
  82. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/orm/dependency.py", line 1233, in _run_crud
  83. connection.execute(statement, secondary_insert)
  84. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 988, in execute
  85. return meth(self, multiparams, params)
  86. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
  87. return connection._execute_clauseelement(self, multiparams, params)
  88. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
  89. distilled_params,
  90. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
  91. e, statement, parameters, cursor, context
  92. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
  93. util.raise_from_cause(sqlalchemy_exception, exc_info)
  94. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
  95. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  96. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/util/compat.py", line 153, in reraise
  97. raise value.with_traceback(tb)
  98. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
  99. cursor, statement, parameters, context
  100. File "/usr/local/lib/python3.7/dist-packages/sqlalchemy/engine/default.py", line 550, in do_execute
  101. cursor.execute(statement, parameters)
  102. File "/usr/local/lib/python3.7/dist-packages/pymysql/cursors.py", line 170, in execute
  103. result = self._query(query)
  104. File "/usr/local/lib/python3.7/dist-packages/pymysql/cursors.py", line 328, in _query
  105. conn.query(q)
  106. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 517, in query
  107. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  108. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 732, in _read_query_result
  109. result.read()
  110. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 1075, in read
  111. first_packet = self.connection._read_packet()
  112. File "/usr/local/lib/python3.7/dist-packages/pymysql/connections.py", line 684, in _read_packet
  113. packet.check_error()
  114. File "/usr/local/lib/python3.7/dist-packages/pymysql/protocol.py", line 220, in check_error
  115. err.raise_mysql_exception(self._data)
  116. File "/usr/local/lib/python3.7/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
  117. raise errorclass(errno, errval)
  118. sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1364, "Field 'id' doesn't have a default value")
  119. [SQL: INSERT INTO roles_users (user_id, role_id) VALUES (%(user_id)s, %(role_id)s)]
  120. [parameters: {'user_id': 186, 'role_id': 2}]
  121. (Background on this error at: http://sqlalche.me/e/2j85)
  122. [2020-10-27 19:31:16 +0000] [14120] [INFO] Handling signal: term
  123. [2020-10-27 19:31:16 +0000] [14134] [INFO] Handling signal: term
  124. [2020-10-27 19:31:16 +0000] [14046] [INFO] Handling signal: term
  125. [2020-10-27 19:31:16 +0000] [14135] [INFO] Handling signal: term
  126. [2020-10-27 19:31:16 +0000] [14110] [INFO] Handling signal: term
  127. [2020-10-27 19:31:16 +0000] [14100] [INFO] Handling signal: term
  128. [2020-10-27 19:31:16 +0000] [14012] [INFO] Handling signal: term
  129. [2020-10-27 19:31:16 +0000] [14040] [INFO] Handling signal: term
  130. [2020-10-27 19:31:16 +0000] [14059] [INFO] Handling signal: term
  131. [2020-10-27 19:31:16 +0000] [14048] [INFO] Handling signal: term
  132. [2020-10-27 19:31:16 +0000] [14013] [INFO] Handling signal: term
  133. [2020-10-27 19:31:16 +0000] [14055] [INFO] Worker exiting (pid: 14055)
  134. [2020-10-27 19:31:16 +0000] [14052] [INFO] Worker exiting (pid: 14052)
  135. [2020-10-27 19:31:16 +0000] [14152] [INFO] Worker exiting (pid: 14152)
  136. [2020-10-27 19:31:16 +0000] [14040] [INFO] Shutting down: Master
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!