kae/musicmuster
1
0
Fork 0
Code Issues 28 Pull Requests Projects Releases 1 Activity

Stack dump on cancelling create new playlist #156

New Issue
Closed
opened 2022-12-22 23:07:27 +00:00 by kae · 1 comment
kae commented 2022-12-22 23:07:27 +00:00
Owner
Copy Link
Traceback (most recent call last):
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1048, "Column 'name' cannot be null")

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

Traceback (most recent call last):
  File "/home/kae/mm/app/musicmuster.py", line 441, in create_and_show_playlist
    playlist = self.create_playlist(session)
  File "/home/kae/mm/app/musicmuster.py", line 434, in create_playlist
    playlist = Playlists(session, playlist_name)
  File "<string>", line 4, in __init__
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 482, in _initialize_instance
    manager.dispatch.init_failure(self, args, kwargs)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 479, in _initialize_instance
    return manager.original_init(*mixed[1:], **kwargs)
  File "/home/kae/mm/app/models.py", line 272, in __init__
    session.commit()
  File "<string>", line 2, in commit
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1451, in commit
    self._transaction.commit(_to_root=self.future)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit
    self._prepare_impl()
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
    self.session.flush()
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush
    self._flush(objects)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush
    transaction.rollback(_capture_exception=True)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush
    flush_context.execute()
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
    rec.execute(self)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute
    util.preloaded.orm_persistence.save_obj(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
    _emit_insert_statements(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements
    result = connection._execute_20(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
    ret = self._execute_context(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
    self._handle_dbapi_exception(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
    util.raise_(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
    raise exception
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1048, "Column 'name' cannot be null")
[SQL: INSERT INTO playlists (name, last_used, loaded, is_template) VALUES (%s, %s, %s, %s)]
[parameters: (None, None, 1, 0)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
Aborted
``` Traceback (most recent call last): File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1048, "Column 'name' cannot be null") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/kae/mm/app/musicmuster.py", line 441, in create_and_show_playlist playlist = self.create_playlist(session) File "/home/kae/mm/app/musicmuster.py", line 434, in create_playlist playlist = Playlists(session, playlist_name) File "<string>", line 4, in __init__ File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 482, in _initialize_instance manager.dispatch.init_failure(self, args, kwargs) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 479, in _initialize_instance return manager.original_init(*mixed[1:], **kwargs) File "/home/kae/mm/app/models.py", line 272, in __init__ session.commit() File "<string>", line 2, in commit File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1451, in commit self._transaction.commit(_to_root=self.future) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3383, in flush self._flush(objects) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3523, in _flush transaction.rollback(_capture_exception=True) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3483, in _flush flush_context.execute() File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements result = connection._execute_20( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection return connection._execute_clauseelement( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception util.raise_( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_ raise exception File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute cursor.execute(statement, parameters) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/home/kae/.cache/pypoetry/virtualenvs/musicmuster-21R3m3EB-py3.9/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query _mysql.connection.query(self, query) sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1048, "Column 'name' cannot be null") [SQL: INSERT INTO playlists (name, last_used, loaded, is_template) VALUES (%s, %s, %s, %s)] [parameters: (None, None, 1, 0)] (Background on this error at: https://sqlalche.me/e/14/e3q8) Aborted ```
kae added the
bug
 label 2022-12-22 23:07:27 +00:00
kae commented 2022-12-23 09:30:58 +00:00
Author
Owner
Copy Link

Fixed in d3958db

Fixed in d3958db
kae closed this issue 2022-12-23 09:30:58 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
bug

Something is not working

  
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
help wanted

Need some help

  
invalid

Something is wrong

  
Priority

Work on soon

  
question

More information is needed

  
V5

   
wontfix

This won't be fixed

No Label
bug
duplicate
enhancement
help wanted
invalid
Priority
question
V5
wontfix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: kae/musicmuster#156
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?