2023-08-28 14:06:06,325 - request_annos_again.py - WARNING : [] is no valid label for subsequent annotation task. Will ignore label. 2023-08-28 14:06:06,352 - request_annos_again.py - WARNING : [] is no valid label for subsequent annotation task. Will ignore label. 2023-08-28 14:06:06,367 - request_annos_again.py - WARNING : ['tank'] is no valid label for subsequent annotation task. Will ignore label. 2023-08-28 14:06:06,385 - request_annos_again.py - WARNING : ['tank'] is no valid label for subsequent annotation task. Will ignore label. 2023-08-28 14:06:06,487 - request_annos_again.py - ERROR : 2023-08-28 14:06:06.451605 Traceback (most recent call last): File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/cursors.py", line 199, in execute args = tuple(map(db.literal, args)) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/connections.py", line 288, in literal s = self.escape(o, self.encoders) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/converters.py", line 76, in Float2Str raise ProgrammingError("%s can not be used with MySQL" % s) MySQLdb._exceptions.ProgrammingError: nan can not be used with MySQL The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/code/src/backend/lost/pyapi/script.py", line 91, in _run self.main() File "/home/lost/app/pipes/lost_ootb_pipes/found/request_annos_again.py", line 47, in main self.outp.request_lds_annos(lds, fs, original_anno_keys, original_img_keys, self.get_arg('img_path_key')) File "/code/src/backend/lost/pyapi/inout.py", line 417, in request_lds_annos self._request_lds(pe, lds, fs, anno_meta_keys, img_meta_keys, img_path_key) File "/code/src/backend/lost/pyapi/inout.py", line 565, in _request_lds self._script._dbm.commit() File "/code/src/backend/lost/db/access.py", line 81, in commit self.session.commit() File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1451, in commit self._transaction.commit(_to_root=self.future) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3444, in flush self._flush(objects) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3583, in _flush with util.safe_reraise(): File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3544, in _flush flush_context.execute() File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements result = connection._execute_20( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection return connection._execute_clauseelement( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception util.raise_( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/cursors.py", line 199, in execute args = tuple(map(db.literal, args)) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/connections.py", line 288, in literal s = self.escape(o, self.encoders) File "/opt/mambaforge/envs/lost/lib/python3.10/site-packages/MySQLdb/converters.py", line 76, in Float2Str raise ProgrammingError("%s can not be used with MySQL" % s) sqlalchemy.exc.ProgrammingError: (MySQLdb._exceptions.ProgrammingError) nan can not be used with MySQL [SQL: INSERT INTO two_d_anno (anno_task_id, timestamp, timestamp_lock, state, track_id, data, dtype, sim_class, iteration, user_id, img_anno_id, confidence, anno_time, description, meta, meta_blob, is_example) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)] [parameters: (4, None, None, 1, None, None, None, nan, 0, None, 5, None, None, nan, None, None, 0)] (Background on this error at: https://sqlalche.me/e/14/f405)