Skip to content

MySQLdb.ProgrammingError #1608

Closed
Closed

Description

@davidancalagon

Docker container was updated this morning. Upon update, getting the following SQL error:

2026-10-02 07:10:40,791 [django.request/ERROR] Internal Server Error: /
Traceback (most recent call last):
File "/usr/local/lib/python3.13/dist-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "/usr/local/lib/python3.13/dist-packages/django/db/backends/mysql/base.py", line 78, in execute
return self.cursor.execute(query, args)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
File "/usr/local/lib/python3.13/dist-packages/MySQLdb/cursors.py", line 219, in execute
res = self._query(mogrified_query)
File "/usr/local/lib/python3.13/dist-packages/MySQLdb/cursors.py", line 498, in _query
db.query(q)
~~~~~~~~^^^
File "/usr/local/lib/python3.13/dist-packages/MySQLdb/connections.py", line 302, in query
_mysql.connection.query(self, query)
~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
MySQLdb.ProgrammingError: (1146, "Table 'tubesync.tmp_history_pks_a901c2cc' doesn't exist")

Pinned by tcely

Activity

  1. tcely commented on Oct 4, 2026

    @tcely
    Collaborator

    There's really not a lot to go on here.

    Please pull the latest image and try again with debugging enabled. Then collect the docker logs for the container and attach them to this issue.

    Thanks!


    Based on the table name alone, I took a guess about what may be causing this. If you want to try the test image, it may give you better results.

    main...test-issue-1608

  2. added
    waiting-on-authorMore details or answers are needed from the author of this issue
    on Oct 4, 2026
  3. davidancalagon commented on Oct 4, 2026

    @davidancalagon
    Author

    Attached is the debug log file.

    tubesync_logs.txt

  4. removed
    waiting-on-authorMore details or answers are needed from the author of this issue
    on Oct 4, 2026
  5. tcely commented on Oct 4, 2026

    @tcely
    Collaborator

    Give it a try with this image:

    ghcr.io/meeb/tubesync@sha256:16a864d51b39d9def97d51e5b9410d198a58b21abb6446d910ec6960ba44ba31
    
  6. added
    waiting-on-authorMore details or answers are needed from the author of this issue
    on Oct 4, 2026
  7. davidancalagon commented on Oct 4, 2026

    @davidancalagon
    Author

    That image you suggested seems to have resolved the issue.

  8. removed
    waiting-on-authorMore details or answers are needed from the author of this issue
    on Oct 4, 2026
  9. tcely commented on Oct 4, 2026

    @tcely
    Collaborator

    That image you suggested seems to have resolved the issue.

    Alright, I have opened #1611 for this.

    @davidancalagon After this is merged please look for the new log messages about a temporary table in the database after loading the dashboard.

    Part of these changes is to stop using a table in favor of using memory when there are less than 10,000 tasks waiting.

    See also:

  10. added
    waiting-on-authorMore details or answers are needed from the author of this issue
    on Oct 4, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

waiting-on-authorMore details or answers are needed from the author of this issue

Projects

  • Status
    Done

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions