Out of range value for column 'vesting_shares' at row 1 #79
Description
{"levelname": "ERROR", "asctime": "2017-11-01T02:34:40.1509503680GMT", "filename": "utils.py", "module": "utils", "funcName": "session_scope", "lineno": 137, "msecs": 376.523494720459, "message": "Caught DBAPI error", "name": "sbds.storages.db.utils", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/utils.py", "process": 38, "processName": "ForkPoolWorker-1", "threadName": "MainThread", "exc_info": "Traceback (most recent call last):\n File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/engine/base.py", line 1159, in _execute_context\n context)\n File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 113, in do_executemany\n rowcount = cursor.executemany(statement, parameters)\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 281, in executemany\n self._get_db().encoding)\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 318, in _do_execute_many\n rows += self.execute(sql + postfix)\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 250, in execute\n self.errorhandler(self, exc, value)\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler\n raise errorvalue\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 247, in execute\n res = self._query(query)\n File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 411, in _query\n rowcount = self._do_query(q)\n File \
{"levelname": "INFO", "asctime": "2017-11-01T02:38:15.1509503895GMT", "filename": "init.py", "module": "init", "funcName": "adaptive_insert", "lineno": 148, "msecs": 300.25362968444824, "message": "bulk_save failed (_mysql_exceptions.DataError) (1264, "Out of range value for column 'vesting_shares' at row 1") [SQL: 'INSERT INTO sbds_tx_delegate_vesting_shares (block_num, transaction_num, operation_num, timestamp, delegator, delegatee, vesting_shares, operation_type) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: (15237869, 33, 1, datetime.datetime(2017, 9, 6, 19, 56, 27), 'steemed', 'steemed-proxy', 1036775520.572323, 'delegate_vesting_shares')]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/init.py", "process": 40, "processName": "ForkPoolWorker-3", "threadName": "MainThread"}
Can be fixed in MySQL by changing the DECIMAL format to (19,6) for example, and restarting the synch.
USE steem;
ALTER TABLE sbds_tx_delegate_vesting_shares CHANGE COLUMN vesting_shares vesting_shares DECIMAL(19,6) NULL DEFAULT NULL AFTER delegatee;