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:

UPDATE T_BDF_PANELDTLINS SET LABEL_TX = BDF_SUPPORT.CHECKNULL(:B2 ) WHERE BDF_PANELDTLINS_OID = :B1

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

asked 03 Oct '13, 20:35

anatoly4u's gravatar image

anatoly4u
6917
accept rate: 0%

edited 03 Oct '13, 20:35

Hi Anatoly,

Yes please send it. Thanks.

(04 Oct '13, 01:48) Yalim Gerger ♦♦

sent to contact at theformspider.com

(04 Oct '13, 06:18) anatoly4u

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 -

Deadlock graph:
                                          ---------Blocker(s)--------  ---------Waiter(s)---------

Resource Name                             process session holds waits  process session holds waits
TX-00090004-00001836-00000000-00000000         74      27     X             74      27           X

session 27: DID 0001-004A-000050FA      session 27: DID 0001-004A-000050FA

Rows waited on:
  Session 27: obj - rowid = 0001897F - AAAYl/AAJAAAJUyAAR
  (dictionary objn - 100735, file - 9, block - 38194, slot - 17)

----- Information for the OTHER waiting sessions -----
----- End of information for the OTHER waiting sessions -----

Information for THIS session:

----- Current SQL Statement for this session (sql_id=7dqarh6jc9885) -----
UPDATE T_BDF_PANELDTLINS SET FIRSTROW_NR = :B3 , LASTROW_NR = :B2 WHERE BDF_PANELDTLINS_OID = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x721e3830      1112  package body FORMSPIDER.BDF_PANELDTLINS_API
0x7c838728       711  package body FORMSPIDER.BDF_RESPONSE_MNG
0x7c838728      2673  package body FORMSPIDER.BDF_RESPONSE_MNG
0x7d931798      1760  package body FORMSPIDER.BDF_ENGINE
0x7d931798      2164  package body FORMSPIDER.BDF_ENGINE
0x7d931798      2448  package body FORMSPIDER.BDF_ENGINE
0x802ca640         1  anonymous block

Please help!

Thanks, Ilia

link

answered 09 Nov '15, 18:22

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120511
accept rate: 0%

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

link

answered 10 Nov '15, 09:35

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

edited 10 Nov '15, 09:38

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,
Yalim

(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,
Yalim

(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

link

answered 28 Nov '16, 10:02

brg's gravatar image

brg
1114
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2

Asked: 03 Oct '13, 20:35

Seen: 1,815 times

Last updated: 28 Nov '16, 10:02


© Copyright Gerger 2017