search

hydraplatform / hydra-server

GNU Lesser General Public License v3.0
5 stars 0 forks source link

Problems in creating tables in manually created DB #4

Closed gbasolu closed 6 years ago

gbasolu commented 6 years ago 
4828 2018-07-17 12:20:30,734 - INFO - Connecting to database: mysql+mysqlconnector://root:Hydra2018!@localhost/basinit
/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/sql/base.py:528: SAWarning: Column 'name' on table <sqlalchemy.sql.selectable.Select at 0x7f763670e2e8; Select object> being replaced by Column('name', String(length=60), table=<Select object>, nullable=False), which has the same key.  Consider use_labels for select() statements.
  (key, getattr(existing, 'table', None), value))
Traceback (most recent call last):
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 377, in cmd_query
    raw_as_string=raw_as_string)
_mysql_connector.MySQLInterfaceError: Cannot add or update a child row: a foreign key constraint fails (`basinit`.`tProject`, CONSTRAINT `tProject_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `tUser` (`id`))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 508, in do_execute
    cursor.execute(statement, parameters)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/mysql/connector/cursor_cext.py", line 264, in execute
    raw_as_string=self._raw_as_string)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 380, in cmd_query
    sqlstate=exc.sqlstate)
mysql.connector.errors.IntegrityError: 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`basinit`.`tProject`, CONSTRAINT `tProject_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `tUser` (`id`))

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "run_server.py", line 19, in <module>
    from hydra_server import s
  File "/home/giovanni/UoM/hydra-server/hydra_server/__init__.py", line 277, in <module>
    s = HydraServer()
  File "/home/giovanni/UoM/hydra-server/hydra_server/__init__.py", line 197, in __init__
    hdb.create_default_net()
  File "/home/giovanni/UoM/hydra-base/hydra_base/util/hdb.py", line 145, in create_default_net
    db.DBSession.flush()
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 153, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
    self._flush(objects)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush
    transaction.rollback(_capture_exception=True)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 187, in reraise
    raise value
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush
    flush_context.execute()
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
    rec.execute(self)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute
    uow
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
    mapper, table, insert)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 866, in _emit_insert_statements
    execute(statement, params)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
    return meth(self, multiparams, params)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
    context)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
    exc_info
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
    raise value.with_traceback(tb)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
    context)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 508, in do_execute
    cursor.execute(statement, parameters)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/mysql/connector/cursor_cext.py", line 264, in execute
    raw_as_string=self._raw_as_string)
  File "/home/giovanni/VirtualEnvs/venv3/lib/python3.6/site-packages/mysql/connector/connection_cext.py", line 380, in cmd_query
    sqlstate=exc.sqlstate)
sqlalchemy.exc.IntegrityError: (mysql.connector.errors.IntegrityError) 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`basinit`.`tProject`, CONSTRAINT `tProject_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `tUser` (`id`)) [SQL: 'INSERT INTO `tProject` (name, description, created_by) VALUES (%(name)s, %(description)s, %(created_by)s)'] [parameters: {'name': 'Project network', 'description': None, 'created_by': 1}] (Background on this error at: http://sqlalche.me/e/gkpj)
gbasolu commented 6 years ago

Solved inverting the following rows

1 hdb.create_default_net() 2 make_root_user()