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 ?
Forum Updated to NodeBB v4.3 + New Features

QSqlDatabase open() crashes when db cannot be accessed ?

Scheduled Pinned Locked Moved Solved General and Desktop
qsqldatabaseqpsql
27 Posts 5 Posters 4.9k Views 2 Watching
  • 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.
  • R R-P-H

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

    @R-P-H

    Add the code below to the main.cpp file and try to run this code in both Debug and Release modes:

       qputenv("QT_FATAL_WARNINGS", "1");
       qSetMessagePattern("Type: %{type}\nProduct Name: %{appname}\nFile: %{file}\nLine: %{line}\nMethod: %{function}\nThreadID: %{threadid}\nThreadPtr: %{qthreadptr}\nMessage: %{message}");
    

    It should print some info about this crash issue.

    Hi, nothing is printed. It is a widget application, not a console app if that's why ?

    Cobra91151C Offline
    Cobra91151C Offline
    Cobra91151
    wrote on last edited by
    #16

    @R-P-H

    You need to clean, run qmake and rebuild your project. It should display the debug info when the crash occurs in the Application output window.

    R 1 Reply Last reply
    0
    • Cobra91151C Cobra91151

      @R-P-H

      You need to clean, run qmake and rebuild your project. It should display the debug info when the crash occurs in the Application output window.

      R Offline
      R Offline
      R-P-H
      wrote on last edited by
      #17

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

      @R-P-H

      You need to clean, run qmake and rebuild your project. It should display the debug info when the crash occurs in the Application output window.

      Yes, I did as you said and there is no additional output. I also created a new console project with the same database code and it runs fine. No idea what's wrong with my widget application in release mode...

      1 Reply Last reply
      0
      • SGaistS Offline
        SGaistS Offline
        SGaist
        Lifetime Qt Champion
        wrote on 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
        0
        • SGaistS SGaist

          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 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 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
            • SGaistS Offline
              SGaistS Offline
              SGaist
              Lifetime Qt Champion
              wrote on 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
              0
              • SGaistS SGaist

                At the end of what loop ?

                R Offline
                R Offline
                R-P-H
                wrote on 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
                • SGaistS Offline
                  SGaistS Offline
                  SGaist
                  Lifetime Qt Champion
                  wrote on 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
                  0
                  • SGaistS SGaist

                    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 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
                    • SGaistS Offline
                      SGaistS Offline
                      SGaist
                      Lifetime Qt Champion
                      wrote on 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
                      0
                      • SGaistS SGaist

                        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 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
                        • SGaistS Offline
                          SGaistS Offline
                          SGaist
                          Lifetime Qt Champion
                          wrote on 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