API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 20th, 2019
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.89 KB | None | 0 0
raw download clone embed print report
  1. postgres_1 | FROM decimal_features ORDER BY 1$$) AS ("codia" INTEGER, "decimal_f1" NUMERIC(4, 1), "decimal_f2" NUMERIC(5, 2), "decimal_f3" NUMERIC(5, 2), "decimal_f4" NUMERIC(5, 2))) AS model_features
  2. flask_1 | [2019-01-20 16:10:45,308] ERROR in app: Exception on /api/v1/prices/ [GET]
  3. flask_1 | Traceback (most recent call last):
  4. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  5. flask_1 | context)
  6. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
  7. flask_1 | cursor.execute(statement, parameters)
  8. flask_1 | psycopg2.DataError: numeric field overflow
  9. flask_1 | DETAIL: A field with precision 4, scale 1 must round to an absolute value less than 10^3.
  10. flask_1 |
  11. flask_1 |
  12. flask_1 | The above exception was the direct cause of the following exception:
  13. flask_1 |
  14. flask_1 | Traceback (most recent call last):
  15. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/app.py", line 2292, in wsgi_app
  16. flask_1 | response = self.full_dispatch_request()
  17. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/app.py", line 1815, in full_dispatch_request
  18. flask_1 | rv = self.handle_user_exception(e)
  19. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask_cors/extension.py", line 161, in wrapped_function
  20. flask_1 | return cors_after_request(app.make_response(f(*args, **kwargs)))
  21. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/app.py", line 1718, in handle_user_exception
  22. flask_1 | reraise(exc_type, exc_value, tb)
  23. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/_compat.py", line 35, in reraise
  24. flask_1 | raise value
  25. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/app.py", line 1813, in full_dispatch_request
  26. flask_1 | rv = self.dispatch_request()
  27. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatch_request
  28. flask_1 | return self.view_functions[rule.endpoint](**req.view_args)
  29. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/views.py", line 88, in view
  30. flask_1 | return self.dispatch_request(*args, **kwargs)
  31. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask/views.py", line 158, in dispatch_request
  32. flask_1 | return meth(*args, **kwargs)
  33. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/flask_principal.py", line 199, in _decorated
  34. flask_1 | rv = f(*args, **kw)
  35. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/webargs/core.py", line 444, in wrapper
  36. flask_1 | return func(*new_args, **kwargs)
  37. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/src/flask-rest-api/flask_rest_api/response.py", line 40, in wrapper
  38. flask_1 | result_raw = func(*args, **kwargs)
  39. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/src/flask-rest-api/flask_rest_api/pagination.py", line 169, in wrapper
  40. flask_1 | result = func(*args, **kwargs)
  41. flask_1 | File "/preciosa/preciosa/api/prices.py", line 69, in get
  42. flask_1 | h_prices.years
  43. flask_1 | File "/preciosa/preciosa/views.py", line 562, in ordered_prices
  44. flask_1 | features_view = features()
  45. flask_1 | File "/preciosa/preciosa/views.py", line 521, in features
  46. flask_1 | decimal_features_view = DecimalFeatures()
  47. flask_1 | File "/preciosa/preciosa/views.py", line 416, in __init__
  48. flask_1 | super().__init__(create=create)
  49. flask_1 | File "/preciosa/preciosa/views.py", line 104, in __init__
  50. flask_1 | CreateMaterializedView(self.view_name, self.selectable).execute(bind=db.session)
  51. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 96, in execute
  52. flask_1 | return bind.execute(self.against(target))
  53. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 153, in do
  54. flask_1 | return getattr(self.registry(), name)(*args, **kwargs)
  55. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1187, in execute
  56. flask_1 | bind, close_with_result=True).execute(clause, params or {})
  57. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
  58. flask_1 | return meth(self, multiparams, params)
  59. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
  60. flask_1 | return connection._execute_ddl(self, multiparams, params)
  61. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
  62. flask_1 | compiled
  63. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
  64. flask_1 | context)
  65. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
  66. flask_1 | exc_info
  67. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
  68. flask_1 | reraise(type(exception), exception, tb=exc_tb, cause=cause)
  69. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 248, in reraise
  70. flask_1 | raise value.with_traceback(tb)
  71. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  72. flask_1 | context)
  73. flask_1 | File "/home/preciosa/.local/share/virtualenvs/preciosa-AyvFTl9Q/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 509, in do_execute
  74. flask_1 | cursor.execute(statement, parameters)
  75. flask_1 | sqlalchemy.exc.DataError: (psycopg2.DataError) numeric field overflow
  76. flask_1 | DETAIL: A field with precision 4, scale 1 must round to an absolute value less than 10^3.
  77. flask_1 | [SQL: 'CREATE MATERIALIZED VIEW decimal_features_mat_view AS SELECT model_features.codia, model_features.decimal_f1, model_features.decimal_f2, model_features.decimal_f3, model_features.decimal_f4 \nFROM (SELECT codia, decimal_f1, decimal_f2, decimal_f3, decimal_f4 \nFROM crosstab($$SELECT model_decimal_features.codia, decimal_features.id, model_decimal_features.value \nFROM model_decimal_features JOIN decimal_features ON model_decimal_features.feature_id = decimal_features.id ORDER BY 1,2$$, $$SELECT decimal_features.id \nFROM decimal_features ORDER BY 1$$) AS ("codia" INTEGER, "decimal_f1" NUMERIC(4, 1), "decimal_f2" NUMERIC(5, 2), "decimal_f3" NUMERIC(5, 2), "decimal_f4" NUMERIC(5, 2))) AS model_features'] (Background on this error at: http://sqlalche.me/e/9h9h)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!