Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. QSqlDatabase open() crashes when db cannot be accessed ?
QtWS25 Last Chance

QSqlDatabase open() crashes when db cannot be accessed ?

Scheduled Pinned Locked Moved Solved General and Desktop
qsqldatabaseqpsql
27 Posts 5 Posters 4.7k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    SGaist
    Lifetime Qt Champion
    wrote on 17 Jul 2020, 19:00 last edited by
    #18

    One other thing you can do is set the QT_DEBUG_PLUGINS environment to 1 in the Run part of the Project panel to see if there's something happening there.

    Since you talked about a console app working fine, did you try to create a dummy widget project and just do the connection there ?

    Interested in AI ? www.idiap.ch
    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

    R 1 Reply Last reply 17 Jul 2020, 20:48
    0
    • S SGaist
      17 Jul 2020, 19:00

      One other thing you can do is set the QT_DEBUG_PLUGINS environment to 1 in the Run part of the Project panel to see if there's something happening there.

      Since you talked about a console app working fine, did you try to create a dummy widget project and just do the connection there ?

      R Offline
      R Offline
      R-P-H
      wrote on 17 Jul 2020, 20:48 last edited by
      #19

      @SGaist said in QSqlDatabase open() crashes when db cannot be accessed ?:

      One other thing you can do is set the QT_DEBUG_PLUGINS environment to 1 in the Run part of the Project panel to see if there's something happening there.

      Since you talked about a console app working fine, did you try to create a dummy widget project and just do the connection there ?

      I set the environment variable. I get the output from all the plugins on startup but nothing extra when calling open().

      I created a fresh widget project and just added the connection part of the code and it works fine. I figure that this means there's some other library included in my original application that may be causing this issue ?

      1 Reply Last reply
      0
      • R Offline
        R Offline
        R-P-H
        wrote on 17 Jul 2020, 21:31 last edited by
        #20

        So through much debugging I finally found the issue. Just 1 line of code:

        QCoreApplication::processEvents();
        

        I have a thread that runs at application startup and emits an image to a label for displaying. The above line of code was at the end of this loop. Removing the line of code doesn't appear to cause any other issues and solves the segfault when trying to open the database.

        Why this causes the segfault in the first place is still bizarre to me...

        1 Reply Last reply
        0
        • S Offline
          S Offline
          SGaist
          Lifetime Qt Champion
          wrote on 17 Jul 2020, 21:34 last edited by
          #21

          At the end of what loop ?

          Interested in AI ? www.idiap.ch
          Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

          R 1 Reply Last reply 17 Jul 2020, 22:04
          0
          • S SGaist
            17 Jul 2020, 21:34

            At the end of what loop ?

            R Offline
            R Offline
            R-P-H
            wrote on 17 Jul 2020, 22:04 last edited by
            #22

            @SGaist said in QSqlDatabase open() crashes when db cannot be accessed ?:

            At the end of what loop ?

            It's a thread with a while loop that emits images to another window for display. The thread (with the loop) is running while the database is opened...

            1 Reply Last reply
            0
            • S Offline
              S Offline
              SGaist
              Lifetime Qt Champion
              wrote on 18 Jul 2020, 06:04 last edited by
              #23

              Some sort of splash screen ?

              In any case, it looks like that thread implementation might need a look into it to avoid future issues.

              Interested in AI ? www.idiap.ch
              Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

              R 1 Reply Last reply 18 Jul 2020, 15:51
              0
              • S SGaist
                18 Jul 2020, 06:04

                Some sort of splash screen ?

                In any case, it looks like that thread implementation might need a look into it to avoid future issues.

                R Offline
                R Offline
                R-P-H
                wrote on 18 Jul 2020, 15:51 last edited by
                #24

                @SGaist said in QSqlDatabase open() crashes when db cannot be accessed ?:

                Some sort of splash screen ?

                In any case, it looks like that thread implementation might need a look into it to avoid future issues.

                No, its a live video. The basic flow is like this:

                //On MainWindow Load...
                //Database class is created which contains database settings.
                //Create thread class and start the thread.
                //Thread runs a while() loop that captures an image and emits the image to MainWindow via a signal.
                //MainWindow receives the signal with the image and displays it inside a label.
                
                //User clicks a button inside MainWindow...
                //Open database using the database class.
                //Do something...
                //Close database.
                

                I don't really see anything very wrong with the above program flow. Yet having QCoreApplication::processEvents(); inside the loop breaks the database opening. Very strange.

                1 Reply Last reply
                0
                • S Offline
                  S Offline
                  SGaist
                  Lifetime Qt Champion
                  wrote on 18 Jul 2020, 16:43 last edited by
                  #25

                  The fact that processEvent is called in a thread is usually the sign of something off.

                  Interested in AI ? www.idiap.ch
                  Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                  R 1 Reply Last reply 18 Jul 2020, 16:49
                  0
                  • S SGaist
                    18 Jul 2020, 16:43

                    The fact that processEvent is called in a thread is usually the sign of something off.

                    R Offline
                    R Offline
                    R-P-H
                    wrote on 18 Jul 2020, 16:49 last edited by
                    #26

                    @SGaist said in QSqlDatabase open() crashes when db cannot be accessed ?:

                    The fact that processEvent is called in a thread is usually the sign of something off.

                    It was actually being called inside the slot in MainWindow to ensure that the label renders the image. But you are correct, it shouldn't be there. Is there any danger in using it ?

                    1 Reply Last reply
                    0
                    • S Offline
                      S Offline
                      SGaist
                      Lifetime Qt Champion
                      wrote on 15 Aug 2020, 20:56 last edited by
                      #27

                      I have usually seen processEvent called from the main thread directly which forces processing of events however calling it from a different thread is the first time. As you can see there's some strange interaction. I currently wonder whether you have an event that is processed by the wrong event loop.

                      Interested in AI ? www.idiap.ch
                      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                      1 Reply Last reply
                      0

                      • Login

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • Users
                      • Groups
                      • Search
                      • Get Qt Extensions
                      • Unsolved