After update to 3.0.2, "sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: tasks"

[nakamoto-upost]

After update flask-sqlalchemy from 2.5.1 to 3.0.2, sqlalchemy raise error.
After downgrade to 2.5.1, it isn't raise.
It is problem of over 3.0.

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: tasks  
[SQL: SELECT tasks.id AS tasks_id, tasks.title AS tasks_title, tasks.classification AS tasks_classification, tasks.submitter AS tasks_submitter, tasks.text AS tasks_text, tasks.in_charge AS tasks_in_charge, tasks.status AS tasks_status, tasks.file_name AS tasks_file_name, tasks.mail_sent AS tasks_mail_sent, tasks.created AS tasks_created, tasks.updated AS tasks_updated
FROM tasks ORDER BY tasks.updated DESC]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Code

main.py

# 改行をLFにして保存すること

from datetime import datetime, timedelta, timezone, time
from telnetlib import SE
from flask import Flask, render_template, request, redirect, url_for, flash, send_from_directory
from flask_sqlalchemy import SQLAlchemy
from flask_wtf import FlaskForm
from flask_wtf.csrf import CSRFProtect
from wtforms import StringField, TextAreaField, SelectField, FileField, SubmitField, IntegerField, FloatField, DateField
from wtforms.validators import DataRequired, Length, Optional
from wtforms.widgets import NumberInput
from werkzeug.datastructures import MultiDict
from werkzeug.utils import secure_filename
import os
from flask_migrate import Migrate
from email.mime.text import MIMEText
import smtplib
from flask_apscheduler import APScheduler
import copy
from sqlalchemy import extract, or_
from flask_paginate import Pagination, get_page_parameter
from pykakasi import kakasi

kakasi = kakasi()

app = Flask(__name__)

app.config.from_object('config')

try:
    os.makedirs(app.config['UPLOAD_FOLDER'])
except FileExistsError:
    pass

SMTP_account = os.getenv('SMTP_ACCOUNT')
SMTP_password = os.getenv('SMTP_PASSWORD')

from_email = SMTP_account

SEIKAN_email = os.getenv('SEIKAN_EMAIL')
PRODUCER_email = os.getenv('PRODUCER_EMAIL')

# csrf = CSRFProtect(app)

db = SQLAlchemy()

db.init_app(app)

# migrateインスタンスを定義
Migrate(app, db, render_as_batch=True)

JST = timezone(timedelta(hours=+9), 'JST')

# initialize scheduler
scheduler = APScheduler()
# if you don't wanna use a config, you can set options here:
# scheduler.api_enabled = True
scheduler.init_app(app)
scheduler.start()

# タスクのデータベーステーブル構造
class Tasks(db.Model):
    # __tablename__ = 'tasks'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    title = db.Column(db.String(200), nullable=False)
    classification = db.Column(db.String(200), nullable=False)
    submitter = db.Column(db.String(200), nullable=False)
    text = db.Column(db.Text)
    in_charge = db.Column(db.String(200))
    status = db.Column(db.String(200), default='未実行')
    file_name = db.Column(db.String(200), nullable=True)
    mail_sent = db.Column(db.Boolean, nullable=True)
    created = db.Column(db.DateTime, default=datetime.now(JST))
    updated = db.Column(db.DateTime, default=datetime.now(JST))
    # Tasks:Tasks_historyを1:多とするリレーションシップを設定
    tasks_history = db.relationship('Tasks_history', uselist=True)
    # Tasks:Estimationを1:多とするリレーションシップを設定
    estimation = db.relationship('Estimation', uselist=True)

    def __repr__(self):
        return '<Task %r, %r, %r, %r, %r, %r, %r, %r, %r, %r, %r>' % (
            self.id,
            self.title,
            self.classification,
            self.submitter,
            self.text,
            self.in_charge,
            self.status,
            self.file_name,
            self.mail_sent,
            self.created,
            self.updated
            )
# ommit

config.py

# 改行をLFにして保存すること
import os

DEBUG = True
SQLALCHEMY_DATABASE_URI = 'sqlite:///todo_db.db'
SQLALCHEMY_TRACK_MODIFICATIONS = True
# WTF_CSRF_ENABLED = True
WTF_CSRF_ENABLED = False
SECRET_KEY = os.urandom(32)
UPLOAD_FOLDER = './uploads'
SCHEDULER_API_ENABLED = True
SERVER_NAME = '127.0.0.1:5000'

Environment:

• Python version:3.10.5
• Flask-SQLAlchemy version:3.0.2
• SQLAlchemy version:1.4.39

[tjconnelly]

i have the same problem, and just posted it on Stack Overflow:
flask-sqlalchemy 3 gives 'OperationalError: no such table' after update

[tjconnelly]

i should specify further compared to above, i'm on python 3.11.3, Flask-SQLAlchemy 3.0.3; the database is sqlite, and the connection url is absolute, not relative. i read through the release notes, and will continue to do so trying to find what changed. notably, the main connection (SQLALCHEMY_DATABASE_URI) connects and works fine, it's only databases attached via SQLALCHEMY_BINDS that have this error. all of the databases/tables exist, and rather than repost everything here, the Stack Overflow link makes it clear via flask shell that the db object knows about the tables and can see the columns but this doesn't hold up when it comes to queries. any help much appreciated!

[tjconnelly]

fixed -- i now see why this got instapunted to discussion -- problem was in my app install, not the upgrade. a bug in click 8.1.3 started me down this road, and then i started going version crazy. in fact, the tables were missing from the newly installed copy of the database. messing around with adding db.create_all() to my code only made it worse.

thanks for making a thing that upgrades smoothly, when operators have their wits about them.

[nakamoto-upost]

fixed -- i now see why this got instapunted to discussion -- problem was in my app install, not the upgrade. a bug in click 8.1.3 started me down this road, and then i started going version crazy. in fact, the tables were missing from the newly installed copy of the database. messing around with adding db.create_all() to my code only made it worse.

thanks for making a thing that upgrades smoothly, when operators have their wits about them.

I don't understand what you are talking about.
How did you end up solving this problem?