Bug description
Today I got this error in my docker logs:
ame": "INFO", "asctime": "2018-01-19T04:39:47.1516336787GMT",
"filename": "__init__.py", "module": "__init__", "funcName": "adaptive_insert", "lineno": 168,
"msecs": 401.9653797149658,
"message": "safe_merge_insert failed (raised as a result of Query-invoked autoflush;
consider using a session.no_autoflush block if this flush is occurring prematurely) (_mysql_exceptions.DataError) (1264, \"Out of range value for column 'min_to_receive' at row 1\")
[SQL: 'INSERT INTO sbds_tx_limit_order_creates (block_num, transaction_num, operation_num, timestamp, owner, orderid, cancel, amount_to_sell, min_to_receive, fill_or_kill, expiration, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)']
[parameters: (5166963, 1, 1, datetime.datetime(2016, 9, 21, 15, 49, 24), 'ausbitbank', 1474472955, 0, 181.25, 18125000000.0, 0, '1969-12-31T23:59:59', 'limit_order_create')]",
"name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/__init__.py", "process": 37,
"processName": "ForkPoolWorker-1", "threadName": "MainThread"}
The SBDS tried to insert 18125000000.0 into the column min_to_receive. But I found that the column's length is decimal(15,6).
18125000000.0 is out of range for min_to_receive. The column need at least decimal(17,6).
Posted on Utopian.io - Rewarding Open Source Contributors