[Database] [DEBUG] Database already created [Database] [INFO] Not loading EIR IMEI TAC Database as Redis not enabled or TAC CSV Database not set in config [Database] [DEBUG] Table apn already exists [Database] [DEBUG] Table auc already exists [Database] [DEBUG] Table subscriber already exists [Database] [DEBUG] Table subscriber_routing already exists [Database] [DEBUG] Table serving_apn already exists [Database] [DEBUG] Table ims_subscriber already exists [Database] [DEBUG] Table roaming_network already exists [Database] [DEBUG] Table emergency_subscriber already exists [Database] [DEBUG] Table roaming_rule already exists [Database] [DEBUG] Table charging_rule already exists [Database] [DEBUG] Table tft already exists [Database] [DEBUG] Table eir already exists [Database] [DEBUG] Table eir_history already exists [Database] [DEBUG] Table subscriber_attributes already exists [Database] [DEBUG] Creating table operation_log Traceback (most recent call last): File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( ~~~~~~~~~~~~~~~~~~~~~~~^ cursor, str_statement, effective_parameters, context ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute cursor.execute(statement, parameters) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ sqlite3.OperationalError: table operation_log already exists The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/opt/venvs/pyhss/bin/pyhss_api", line 5, in from pyhss.services.apiService import main File "/opt/venvs/pyhss/lib/python3.13/site-packages/pyhss/services/apiService.py", line 44, in diameterClient = Diameter( redisMessaging=redisMessaging, ...<5 lines>... productName='PyHSS-client-API' ) File "/opt/venvs/pyhss/lib/python3.13/site-packages/pyhss/lib/diameter.py", line 48, in __init__ self.database = Database(logTool=logTool) ~~~~~~~~^^^^^^^^^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/pyhss/lib/database.py", line 413, in __init__ Base.metadata.tables[table_name].create(bind=self.engine) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/sql/schema.py", line 1288, in create bind._run_ddl_visitor(ddl.SchemaGenerator, self, checkfirst=checkfirst) ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 3252, in _run_ddl_visitor conn._run_ddl_visitor(visitorcallable, element, **kwargs) ~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 2459, in _run_ddl_visitor ).traverse_single(element) ~~~~~~~~~~~~~~~^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/sql/visitors.py", line 661, in traverse_single return meth(obj, **kw) File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/sql/ddl.py", line 1022, in visit_table )._invoke_with(self.connection) ~~~~~~~~~~~~^^^^^^^^^^^^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/sql/ddl.py", line 321, in _invoke_with return bind.execute(self) ~~~~~~~~~~~~^^^^^^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1419, in execute return meth( self, distilled_parameters, execution_options or NO_OPTIONS, ) File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/sql/ddl.py", line 187, in _execute_on_connection return connection._execute_ddl( ~~~~~~~~~~~~~~~~~~~~~~~^ self, distilled_params, execution_options ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1530, in _execute_ddl ret = self._execute_context( dialect, ...<4 lines>... compiled, ) File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context return self._exec_single_context( ~~~~~~~~~~~~~~~~~~~~~~~~~^ dialect, context, statement, parameters ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( ~~~~~~~~~~~~~~~~~~~~~~~~~~~~^ e, str_statement, effective_parameters, cursor, context ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( ~~~~~~~~~~~~~~~~~~~~~~~^ cursor, str_statement, effective_parameters, context ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/venvs/pyhss/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 951, in do_execute cursor.execute(statement, parameters) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table operation_log already exists [SQL: CREATE TABLE operation_log ( id INTEGER NOT NULL, item_id INTEGER NOT NULL, operation_id VARCHAR(36) NOT NULL, operation VARCHAR(10), changes TEXT, last_modified VARCHAR(100), timestamp DATETIME, table_name VARCHAR(255), apn_id INTEGER, subscriber_routing_id INTEGER, serving_apn_id INTEGER, auc_id INTEGER, subscriber_id INTEGER, ims_subscriber_id INTEGER, roaming_rule_id INTEGER, roaming_network_id INTEGER, emergency_subscriber_id INTEGER, charging_rule_id INTEGER, tft_id INTEGER, eir_id INTEGER, imsi_imei_history_id INTEGER, subscriber_attributes_id INTEGER, PRIMARY KEY (id), FOREIGN KEY(apn_id) REFERENCES apn (apn_id), FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), FOREIGN KEY(auc_id) REFERENCES auc (auc_id), FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), FOREIGN KEY(roaming_rule_id) REFERENCES roaming_rule (roaming_rule_id), FOREIGN KEY(roaming_network_id) REFERENCES roaming_network (roaming_network_id), FOREIGN KEY(emergency_subscriber_id) REFERENCES emergency_subscriber (emergency_subscriber_id), FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), FOREIGN KEY(tft_id) REFERENCES tft (tft_id), FOREIGN KEY(eir_id) REFERENCES eir (eir_id), FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id) ) ] (Background on this error at: https://sqlalche.me/e/20/e3q8)