Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 8 of 8 total |
CallBackResponse error in server |
Thu, Sep 16 2021 6:54 AM | Permanent Link |
David | Hi. I have noticed that my DB has become slower recently due to the number of people/data and in order to stop some of the not responding errors I have bunged in some QueryProgress events to show the progress and possibly reduce this error somewhat, or at least stop people from ending the task because 5-10 seconds is too slow!!
Anyway since doing this I have noticed a few REQUST_CALLBACKRESPONSE errors in the server and I wondered is this related in anyway to the Query Progress event? Thanks David. |
Tue, Sep 21 2021 6:37 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | David,
Sorry about the delay in getting you a response. << Hi. I have noticed that my DB has become slower recently due to the number of people/data and in order to stop some of the not responding errors I have bunged in some QueryProgress events to show the progress and possibly reduce this error somewhat, or at least stop people from ending the task because 5-10 seconds is too slow!! Anyway since doing this I have noticed a few REQUST_CALLBACKRESPONSE errors in the server and I wondered is this related in anyway to the Query Progress event? >> I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc. Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 21 2021 11:22 AM | Permanent Link |
David | Hi Tim.
I went back to a prior executable without the onProgress event and this seems to have calmed down now. I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause. I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations? Regards David. Tim Young [Elevate Software] wrote: I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc. Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 21 2021 11:22 AM | Permanent Link |
David | Hi Tim.
I went back to a prior executable without the onProgress event and this seems to have calmed down now. I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause. I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations? Regards David. Tim Young [Elevate Software] wrote: I would have to see the log entry itself to be sure, but typically those types of errors are caused when the server tries to send a progress, status, or log event and the send fails due to the client disconnecting, etc. Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 21 2021 2:30 PM | Permanent Link |
Raul Team Elevate | On 9/21/2021 11:22 AM, David wrote:
> I went back to a prior executable without the onProgress event and this seems to have calmed down now. I haven't tried yet with an updated version yet but as far as I know, this was the only change I had made so it looks like it was the cause. Sounds like clients are either terminating the app during query execution or device goes to sleep or off Wifi or such causing connection to dbsrvr to drop. > I had an application.processmessage in the onProgress event though and I see from other posts that this can have an adverse effect on some operations? Generally bad idea yes - inb most cases due to this pumping the window message queue so you can get things like mouse clicks or keyboard input if your controls are enabled possibly leading to reentrancy issues and such Raul |
Tue, Sep 21 2021 2:56 PM | Permanent Link |
David | Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change" Seemed like a good idea at the time and worked locally fine but not when multiple users on the server.
Raul wrote: On 9/21/2021 11:22 AM, David wrote: Generally bad idea yes - inb most cases due to this pumping the window message queue so you can get things like mouse clicks or keyboard input if your controls are enabled possibly leading to reentrancy issues and such Raul |
Wed, Sep 22 2021 8:29 AM | Permanent Link |
Raul Team Elevate | On 9/21/2021 2:56 PM, David wrote:
> Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change" Seemed like a good idea at the time and worked locally fine but not when multiple users on the server. Still curious - if all you added was query onprogress events then without those clients should still be timing out and disconnections should still be happening occur (you just have less info in logs - probably just session disconnecting now). What are you DSSRVR session settings and remote session timeouts in general Raul |
Wed, Sep 22 2021 2:33 PM | Permanent Link |
David | Hi Raul.
TimeOut 300s, Dead Session Clean up 30s, Dead Session Exp 7200s. I have only changed the Exp from default 12 hours to 2 hours as it allows user to unplug from network, move to new location and re-connect. David Raul wrote: On 9/21/2021 2:56 PM, David wrote: > Yes that was what I thought as well but could not see any re-connections in the server but logic was simply, "what did I change" Seemed like a good idea at the time and worked locally fine but not when multiple users on the server. Still curious - if all you added was query onprogress events then without those clients should still be timing out and disconnections should still be happening occur (you just have less info in logs - probably just session disconnecting now). What are you DSSRVR session settings and remote session timeouts in general Raul |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |