QPSQL: Unable to create query

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

Sven Schütze

  • Posts: 16
  • Joined: Wed May 15, 2013 8:45 pm
  • Location: Hamburg, Germany

QPSQL: Unable to create query

PostTue Sep 27, 2016 9:51 pm

Dear forum-users,
since today we're unable to save any projects. We receive an error-message saying: "Critical Exception : BtException: ERROR: current transaction is aborted, commands ignored until end of transaction block (25P02) QPSQL: Unable to create query".
fehlermeldung_proj v54 save.jpg
fehlermeldung_proj v54 save.jpg (47.16 KiB) Viewed 3196 times

Dispite the offer to save the project the application just freezes, no buttons are clickable any more.
Does anyone have any suggestions? This ist really critical now since we can't work in any way on our actual project.
We also tried it with backup-versions of the project, but they can't be imported too, if they were exported before, nor can simple copies of the project as saved before be saved after opening.
Running DaVinci Resolve 12.5.2 on two HP Z840-machines with Windows 8.1. Both machines are connected via 10Gbit and use the same database on one of the machines. Both crash on the same error.
Regards, Sven
Resolve 17.4.3 || AMD Ryzen Threadripper Pro 3955X on ASUS Pro WS WRX80E-SAGE w/ 2x Gigabyte RTX 3080 Turbo 10G + Decklink 4K
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query - ERROR

PostTue Sep 27, 2016 9:55 pm

First thing to try is in the Resolve Database Manager window, backing up the database. Then Optimize the database.

It's also not a great idea to have 2 Resolves accessing a common database on one of the Resolves. If the Resolve hosting the database goes down, it could corrupt the project the other Resolve was using.

If you want to have a shared database, it's better to use a dedicated database server.

I assume you don't have any existing current database backups that could be restored?
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

Benjamin McGuire

  • Posts: 47
  • Joined: Sun Feb 24, 2013 4:37 am

Re: QPSQL: Unable to create query - ERROR

PostThu Apr 06, 2017 6:09 pm

I'm getting the same thing... Version 12.5.5 on OSX Sierra. Have backuped Database, and Optimized, and it still happens. Seems to only happen when I export. Rendering DCI-Scope in prores with 5k Red files as source. Have a GTX 980 ti Graphics card (Shouldn't matter)...

Database is on my computer.

Render is still good, and I can ignore it, and everything still works. Just Annoying to see whenever I render output.

Code: Select all
2   Resolve                             0x0000000102efa507 _ZNK5DbObj24DbDeprecatedSerializable9SerializeI8BtStringEEvR10BtAsciiStrPKcT_ + 7927
3   Resolve                             0x0000000102f3e6c1 _ZNK5QHashI7QStringS0_E8findNodeERKS0_Pj + 5617
4   Resolve                             0x0000000102f42b96 _ZNK5QHashI7QStringS0_E8findNodeERKS0_Pj + 23238
5   Resolve                             0x0000000102f63f13 _ZN5QHashIPK11QMetaObjectPKcE13duplicateNodeEPN9QHashData4NodeEPv + 122963
6   Resolve                             0x000000010071fda5 _ZN5QListIP12SmActionBaseE6appendERKS1_ + 20997
7   Resolve                             0x00000001009eb734 _ZN18QAlgorithmsPrivate11qSortHelperIN5QListIN35UiDeliverPanelRenderQueueController10RecordItemEE8iteratorES3_PFbRKS3_S7_EEEvT_SA_RKT0_T1_ + 4484
8   Resolve                             0x00000001009e45f4 _ZN36Ui_UiDeliverPanelAddOutputTypeWidget13retranslateUiEP7QWidget + 79188
9   QtCore                              0x000000010c4eff0a _ZN11QMetaObject8activateEP7QObjectiiPPv + 1050
10  Resolve                             0x0000000100f2d634 _ZN17QtMetaTypePrivate19IteratorOwnerCommonIN5QListI15BtAudioClipInfoE14const_iteratorEE6assignEPPvPKS6_ + 23812
11  Resolve                             0x00000001009ed3b5 _ZN18QAlgorithmsPrivate11qSortHelperIN5QListIN35UiDeliverPanelRenderQueueController10RecordItemEE8iteratorES3_PFbRKS3_S7_EEEvT_SA_RKT0_T1_ + 11781
12  QtCore                              0x000000010c4eff0a _ZN11QMetaObject8activateEP7QObjectiiPPv + 1050
13  QtCore                              0x000000010c4e89a0 _ZN7QObject5eventEP6QEvent + 48
14  QtWidgets                           0x000000010b6f2d6b _ZN19QApplicationPrivate13notify_helperEP7QObjectP6QEvent + 251
15  QtWidgets                           0x000000010b6f612e _ZN12QApplication6notifyEP7QObjectP6QEvent + 8302
16  Resolve                             0x000000010002d50f _ZN11BtSingletonI15UiProjectLockerE8GetStateEv + 5679
17  QtCore                              0x000000010c4ba023 _ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent + 115
18  QtCore                              0x000000010c514296 _ZN14QTimerInfoList14activateTimersEv + 1270
19  libqcocoa.dylib                     0x000000011b420b92 qt_plugin_instance + 103186
20  CoreFoundation                      0x00007fff94d658d1 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
21  CoreFoundation                      0x00007fff94d46c6c __CFRunLoopDoSources0 + 556
22  CoreFoundation                      0x00007fff94d46156 __CFRunLoopRun + 934
23  CoreFoundation                      0x00007fff94d45b54 CFRunLoopRunSpecific + 420
24  HIToolbox                           0x00007fff942d0a5c RunCurrentEventLoopInMode + 240
25  HIToolbox                           0x00007fff942d0891 ReceiveNextEventCommon + 432
26  HIToolbox                           0x00007fff942d06c6 _BlockUntilNextEventMatchingListInModeWithFilter + 71
27  AppKit                              0x00007fff928765b4 _DPSNextEvent + 1120
28  AppKit                              0x00007fff92ff0d6b -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 2789
29  AppKit                              0x00007fff9286af35 -[NSApplication run] + 926
30  libqcocoa.dylib                     0x000000011b4217ad qt_plugin_instance + 106285
31  QtCore                              0x000000010c4b714c _ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE + 396
32  QtCore                              0x000000010c4ba5fa _ZN16QCoreApplication4execEv + 346
33  Resolve                             0x0000000100037ae7 _ZN11BtSingletonI28Sm2DolbyVisionNetworkServiceE8GetStateEv + 8135
34  Resolve                             0x00000001000369f2 _ZN11BtSingletonI28Sm2DolbyVisionNetworkServiceE8GetStateEv + 3794
35  Resolve                             0x0000000100040660 _ZN5boost2io6detail3putIcSt11char_traitsIcESaIcERA1_KcEEvT2_RKNS1_11format_itemIT_T0_T1_EERNS_12basic_formatISB_SC_SD_E11string_typeERNSI_20internal_streambuf_tEPSt6locale + 5936
36  libdyld.dylib                       0x00007fffaa338255 start + 1
Resolve Studio 17.4.6 build 4
MacOS 12.3.1 (21E258)

i7-7800X. 32GB RAM
Asus X299-A MB
AMD Vega 64
DeckLink Mini Mon4K

(1) LG 31MU97C-B 4K (4096x2160)-Grading + (1) Sharp LC-55LBU591U-client/HDR Color (4kHDMI Split)
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query - ERROR

PostThu Apr 06, 2017 6:40 pm

I'm not sure what was causing this for the OP with Resolve 12.5.2, but this error will now frequently occur when rendering in 12.5.5. It can be ignored. It will be fixed in a future release.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query - ERROR

PostSun Mar 19, 2023 3:54 pm

im getting similar message. any thoughts? mac 12.3.1 on both 18.1.3 and 18.1.4 build 9. i am using the blackmagic cloud subscription
Code: Select all
2   Resolve                             0x0000000100346021 _ZN5QHashI7QStringN5DbObj14DbDatabaseList5EntryEE13duplicateNodeEPN9QHashData4NodeEPv + 47473
3   Resolve                             0x0000000100391fc3 _ZN5QHashI7QStringN5DbObj14DbDatabaseList5EntryEE13duplicateNodeEPN9QHashData4NodeEPv + 358675
4   Resolve                             0x000000010038bc96 _ZN5QHashI7QStringN5DbObj14DbDatabaseList5EntryEE13duplicateNodeEPN9QHashData4NodeEPv + 333286
5   Resolve                             0x000000010039237f _ZN5QHashI7QStringN5DbObj14DbDatabaseList5EntryEE13duplicateNodeEPN9QHashData4NodeEPv + 359631
6   Resolve                             0x000000010039284c _ZN5QHashI7QStringN5DbObj14DbDatabaseList5EntryEE13duplicateNodeEPN9QHashData4NodeEPv + 360860
7   Resolve                             0x00000001003d4104 _ZN5QHashIK7QStringNSt3__112basic_stringIwNS2_11char_traitsIwEENS2_9allocatorIwEEEEE13duplicateNodeEPN9QHashData4NodeEPv + 249972
8   Resolve                             0x00000001015c7ded _ZN17QtMetaTypePrivate23QMetaTypeFunctionHelperI16SequenceTabsDataLb1EE4LoadER11QDataStreamPv + 48445
9   Resolve                             0x00000001015c40c3 _ZN17QtMetaTypePrivate23QMetaTypeFunctionHelperI16SequenceTabsDataLb1EE4LoadER11QDataStreamPv + 32787
10  Resolve                             0x00000001056a1c29 _ZN17QtMetaTypePrivate23QMetaTypeFunctionHelperI18InitCheckBoxParamsLb1EE9ConstructEPvPKv + 59625
11  libQt5Core.5.dylib                  0x0000000125b5a642 _ZN11QMetaObject8activateEP7QObjectPKS_iPPv + 3730
12  Resolve                             0x000000010561c803 _ZN17QtMetaTypePrivate23QMetaTypeFunctionHelperIN11HTTPService12ResponseCodeELb1EE9ConstructEPvPKv + 62275
13  Resolve                             0x00000001056c15ef _ZN17QtMetaTypePrivate23QMetaTypeFunctionHelperI18InitCheckBoxParamsLb1EE9ConstructEPvPKv + 189103
14  libQt5Core.5.dylib                  0x0000000125b5a502 _ZN11QMetaObject8activateEP7QObjectPKS_iPPv + 3410
15  libQt5Core.5.dylib                  0x0000000125b63302 _ZN6QTimer10timerEventEP11QTimerEvent + 98
16  libQt5Core.5.dylib                  0x0000000125b526a1 _ZN7QObject5eventEP6QEvent + 113
17  libQt5Widgets.5.dylib               0x000000011b34b4a6 _ZN19QApplicationPrivate13notify_helperEP7QObjectP6QEvent + 262
18  libQt5Widgets.5.dylib               0x000000011b34c888 _ZN12QApplication6notifyEP7QObjectP6QEvent + 488
19  Resolve                             0x00000001032ee374 _ZN9QtPrivate11QSlotObjectIM29UiProxyGeneratorFolderWatcherFvRK7QStringENS_4ListIJS4_EEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 255652
20  libQt5Core.5.dylib                  0x0000000125b29e06 _ZN16QCoreApplication15notifyInternal2EP7QObjectP6QEvent + 166
21  libQt5Core.5.dylib                  0x0000000125b8a43b _ZN14QTimerInfoList14activateTimersEv + 987
22  libqcocoa.dylib                     0x00000001d273f2c2 qt_plugin_instance + 193154
23  CoreFoundation                      0x00007ff80dbfbbca __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
24  CoreFoundation                      0x00007ff80dbfbb32 __CFRunLoopDoSource0 + 180
25  CoreFoundation                      0x00007ff80dbfb8b0 __CFRunLoopDoSources0 + 242
26  CoreFoundation                      0x00007ff80dbfa2c0 __CFRunLoopRun + 892
27  CoreFoundation                      0x00007ff80dbf9884 CFRunLoopRunSpecific + 562
28  HIToolbox                           0x00007ff816cefce6 RunCurrentEventLoopInMode + 292
29  HIToolbox                           0x00007ff816cefa4a ReceiveNextEventCommon + 594
30  HIToolbox                           0x00007ff816cef7e5 _BlockUntilNextEventMatchingListInModeWithFilter + 70
31  AppKit                              0x00007ff81055753d _DPSNextEvent + 927
32  AppKit                              0x00007ff810555bfa -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 1394
33  libqcocoa.dylib                     0x00000001d273f937 qt_plugin_instance + 194807
34  libQt5Core.5.dylib                  0x0000000125b264c7 _ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE + 471
35  libQt5Widgets.5.dylib               0x000000011b56394c _ZN7QDialog4execEv + 508
36  Resolve                             0x00000001032f1163 _ZN9QtPrivate11QSlotObjectIM29UiProxyGeneratorFolderWatcherFvRK7QStringENS_4ListIJS4_EEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 267411
37  Resolve                             0x00000001032ef34c _ZN9QtPrivate11QSlotObjectIM29UiProxyGeneratorFolderWatcherFvRK7QStringENS_4ListIJS4_EEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 259708
38  libQt5Core.5.dylib                  0x0000000125b29e06 _ZN16QCoreApplication15notifyInternal2EP7QObjectP6QEvent + 166
39  libQt5Core.5.dylib                  0x0000000125b8a43b _ZN14QTimerInfoList14activateTimersEv + 987
40  libqcocoa.dylib                     0x00000001d273f2c2 qt_plugin_instance + 193154
41  CoreFoundation                      0x00007ff80dbfbbca __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
42  CoreFoundation                      0x00007ff80dbfbb32 __CFRunLoopDoSource0 + 180
43  CoreFoundation                      0x00007ff80dbfb8b0 __CFRunLoopDoSources0 + 242
44  CoreFoundation                      0x00007ff80dbfa2c0 __CFRunLoopRun + 892
45  CoreFoundation                      0x00007ff80dbf9884 CFRunLoopRunSpecific + 562
46  HIToolbox                           0x00007ff816cefce6 RunCurrentEventLoopInMode + 292
47  HIToolbox                           0x00007ff816cefa4a ReceiveNextEventCommon + 594
48  HIToolbox                           0x00007ff816cef7e5 _BlockUntilNextEventMatchingListInModeWithFilter + 70
49  AppKit                              0x00007ff81055753d _DPSNextEvent + 927
50  AppKit                              0x00007ff810555bfa -[NSApplication(NSEvent) _nextEventMatchingEventMask:untilDate:inMode:dequeue:] + 1394
51  AppKit                              0x00007ff8105482a9 -[NSApplication run] + 586
52  libqcocoa.dylib                     0x00000001d273fe84 qt_plugin_instance + 196164
53  libQt5Core.5.dylib                  0x0000000125b264c7 _ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE + 471
54  libQt5Core.5.dylib                  0x0000000125b2a3a2 _ZN16QCoreApplication4execEv + 130
55  Resolve                             0x0000000103313482 _ZN9QtPrivate11QSlotObjectIM10QEventLoopFvvENS_4ListIJEEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 53698
56  Resolve                             0x0000000103310c1a _ZN9QtPrivate11QSlotObjectIM10QEventLoopFvvENS_4ListIJEEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 43354
57  Resolve                             0x00000001032e606c _ZN9QtPrivate11QSlotObjectIM29UiProxyGeneratorFolderWatcherFvRK7QStringENS_4ListIJS4_EEEvE4implEiPNS_15QSlotObjectBaseEP7QObjectPPvPb + 222108
58  dyld                                0x000000012619451e start + 462
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query - ERROR

PostSun Mar 19, 2023 4:45 pm

more detail it says
BtException:SSl SYSCALL error: Operation timed out
() QPSQL: Unable to create query
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query - ERROR

PostSun Mar 19, 2023 6:32 pm

You're getting this error with a Cloud Project Library selected? Or a Network Project Library?

In the Resolve Help menu, select "Create Diagnostics Log on Desktop" and send a link to the file it creates.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query

PostMon Mar 20, 2023 12:46 pm

cloud project file. will send log shortly
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query

PostMon Mar 20, 2023 6:12 pm

thank you sir for your help

https://www.filemail.com/d/drevefprhdehhwf

it appears after a little while of exporting
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query

PostMon Mar 20, 2023 7:03 pm

It looks like the connection to the Cloud server is timing out and causing those errors.

I don't know if that is an issue caused at the server end, or if it's a poor network connection to the server.

Is your Internet connection solid and does it have good up/download speeds?
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query

PostMon Mar 20, 2023 9:49 pm

I was wondering that and tested it at 40 download 11 upload. I've tried to copy project to local incase that's the issue but it wouldn't do so.
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query

PostMon Mar 20, 2023 10:26 pm

You should be able to copy the project to a Local project library.

In the Cloud project library, select the project, then press <CMD> <c> (for copy), then select the Local project library, and place the cursor into the Projects area, and press <CMD><v> (for paste) and that should copy the project between the project libraries.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query

PostTue Mar 21, 2023 1:23 pm

thank you for the copy function wa able to copy it to local. the rectangle that lets you copy for me would freeze out.
Offline

cire30a

  • Posts: 245
  • Joined: Thu Nov 22, 2018 11:30 am
  • Real Name: Eric Cross

Re: QPSQL: Unable to create query

PostTue Mar 21, 2023 2:04 pm

actual mr Dwaine you wouldnt know how to get a project back from the cloud server from two weeks ago. when i attempted to acces this project that kep having issues i forced quit while on a timeline and when i came back that timeline was there but every cut and edit was removed about 24hours of footage. all the markers are still there though in the blank timeline.
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 11241
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: QPSQL: Unable to create query

PostTue Mar 21, 2023 6:26 pm

I don't have a way to help with that.

Going forward, I'd recommend that for any important projects you work with, that last more than a day, that at the end of each workday, you make a Project Export .drp of the project, and keep copies of those drps off the main system drive. Then if anything happens to the system drive, or the Project Library, or the project itself, you have daily backups you can revert to.
Dwaine Maggart
Blackmagic Design DaVinci Support

Return to DaVinci Resolve

Who is online

Users browsing this forum: Bing [Bot], BloodMan, Charles Bennett, Zanshin and 173 guests