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
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 -
answered 09 Nov '15, 18:22
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
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!
answered 28 Nov '16, 10:02