Hello guys, we noticed an issue on one of our test apps. It consists of several tabs based on the updatable view datasources. when user updates some data on one of the tabs and then performs query reexecution to check o\if data was updated - he gets deadlock issue. THe intersing thing is that after we checked on the db side it seems that the deadlock comes from this query:
so probably it seems to be a bug with FS not app logic. If you are interested I can forward you an xml file and a link to app with reproduce steps Best regards, Anatoly |
Hello, I'm having the same problem whenever two users are trying to access (read only) the same record. Here is a short abstract from the trace file -
Please help! Thanks, Ilia |
Hi Everyone, We identified the bug and applied a solution. The solution is being tested by Quality Assurance. All of the deadlock issues seem to be related to each other. We were able to reproduce one of the deadlock errors by making a grid to show the next page of rows using the nextPage button and then selecting a row in the grid. Selecting a row caused the deadlock. (The grid must have a selection changed event). We did not even need a second user for this. The deadlock happened even if the application was used by one user. So, it is pretty safe to say that this issue will be fixed in Formspider 1.10. We will send out a hot fix to our professional support customers as soon as the fix is approved by Quality Assurance. Kind Regards, Yalim did you fix it?
(22 Aug '16, 14:02)
lezgin
Hi Zamir, We are preparing a new version 1.10 which has this fix. It will be available soon. Thank you for bringing this to our attention. Kind Regards,
(23 Aug '16, 12:31)
Yalim ♦♦
Hi Zamir, We just uploaded 1.10.1 which has the fix for the issue included. Many thanks again for bringing this issue to our attention. Kind Regards,
(25 Aug '16, 10:31)
Yalim ♦♦
|
Hi Yalim, I'm using 1.10.1 and I get this error when I use pagination on a grid, in fact this is why I found this topic. The GUI model consists of a readonly grid + a toolbar which includes a clasical pagination panel. When a user double click a record in grid(or press an Edit button in toolbar) an edit record modal dialog is popuped. Do nothing but close this dialog(visible='N' and requery datasource). Do this two or three times and this deadock exception occurs. Just comment out the inclusion of pagination panel in toolbar and you're free of deadlock exception. Hope this info is useful to you! Cezar |
Hi Anatoly,
Yes please send it. Thanks.
sent to contact at theformspider.com