Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

Error with sqlite QSqlError("10", "Unable to fetch row", "disk I/O error")



  • Hello, I'm trying to make a Discord guild saver, but there is this error ocurring "randomly" which prevent me from doing it.
    Here is my code : https://pastebin.com/KZiiwVtu
    Sometime the error only appear on guild, but it doesn't save all the channels to the db, and rows are inserted randomly : alt text

    QVariant(QString, "vérification")
    QSqlError("", "", "") channel
    QVariant(QString, "info")
    QSqlError("", "", "") channel
    QVariant(QString, "alertes??")
    QSqlError("", "", "") channel
    QVariant(QString, "Général ??")
    QSqlError("", "", "") channel
    QVariant(QString, "??annonces")
    QSqlError("", "", "") channel
    QVariant(QString, "général")
    QSqlError("", "", "") channel
    QVariant(QString, "partenaires??")
    QSqlError("", "", "") channel
    QVariant(QString, "report??")
    QSqlError("", "", "") channel
    QVariant(QString, "aide??")
    QSqlError("", "", "") channel
    QVariant(QString, "event")
    QSqlError("", "", "") channel
    QVariant(QString, "Autres ??")
    QSqlError("", "", "") channel
    QVariant(QString, "suggestions")
    QSqlError("", "", "") channel
    QVariant(QString, "shitpost??")
    QSqlError("", "", "") channel
    QVariant(QString, "commandes")
    QSqlError("", "", "") channel
    QVariant(QString, "Vocal")
    QSqlError("", "", "") channel
    QVariant(QString, "AFK??")
    QSqlError("", "", "") channel
    QVariant(QString, "Le Repaire")
    QSqlError("", "", "") channel
    QVariant(QString, "bla-bla")
    QSqlError("", "", "") channel
    QVariant(QString, "blacklist")
    QSqlError("", "", "") channel
    QVariant(QString, "preuves")
    QSqlError("", "", "") channel
    QVariant(QString, "serveurs-raid")
    QSqlError("", "", "") channel
    QVariant(QString, "Staff")
    QSqlError("", "", "") channel
    QVariant(QString, "annonces")
    QSqlError("", "", "") channel
    QVariant(QString, "général-staff")
    QSqlError("", "", "") channel
    QVariant(QString, "report-a-valider")
    QSqlError("", "", "") channel
    QVariant(QString, "reglement")
    QSqlError("", "", "") channel
    QVariant(QString, "vocal-sans-micro")
    QSqlError("", "", "") channel
    QVariant(QString, "Vocal Staff")
    QSqlError("", "", "") channel
    QVariant(QString, "Mail")
    QSqlError("", "", "") channel
    QVariant(QString, "modmail-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "logs")
    QSqlError("", "", "") channel
    QVariant(QString, "altidentifier-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "join-logs")
    QSqlError("", "", "") channel
    QVariant(QString, "logs")
    QSqlError("", "", "") channel
    QVariant(QString, "Bureau des directeurs")
    QSqlError("", "", "") channel
    QVariant(QString, "discussion")
    QSqlError("", "", "") channel
    QVariant(QString, "bot-config")
    QSqlError("", "", "") channel
    QVariant(QString, "gitlab-commits")
    QSqlError("", "", "") channel
    QVariant(QString, "Réunions")
    QSqlError("", "", "") channel
    QSqlError("10", "Unable to fetch row", "disk I/O error") guild
    QSqlQuery::value: not positioned on a valid record
    QSqlDatabasePrivate::removeDatabase: connection 'saveGuild' is still in use, all queries will cease to work.
    

    but most of the time saving the guild works but this error occurs with every channel :

    QSqlError("10", "Unable to fetch row", "disk I/O error") channel
    

    I have no idea of what's happening and why, could somebody help me pls ?


  • Qt Champions 2019

    disk i/o error sounds like you've some problems with your harddisk - you should check it.



  • It works fine with other requests, and my hard drives work well. The program is on D:, and the db in AppData/Roaming on C:


  • Lifetime Qt Champion

    Hi,

    Does it also happen if you put your database somewhere else ?



  • Yes, i tried in the program's folder


  • Lifetime Qt Champion

    I meant on a different physical disk like e.g. an USB key.


Log in to reply