can multiple users access gadfly database simultaneously ?
Hi, When two users enter their login name & password and press enter simultaniously,the first who entered among the two gets the following error. Error Type: SyntaxError Error Value: unexpected token sequence.near :: 'of_que\012from noq'*'' ******************************* current state = 277 expects: '*', ';', ')', 'ORDER', ('nomatch1',) current token = ((-6, 'FROM'), 'FROM') The above error is while entering the Zope .Again If they fill the form & click submit button simultaniously.The following error occurs for the user who presses submit button first. Error Type: SyntaxError Error Value: unexpected token sequence.near :: "\012Q_name = 'q24'"*'' ******************************* current state = 231 expects: 'EXCEPT', '+', ')', 'HAVING', '-', 'UNION', 'AND', 'GROUP', '*', ';', 'OR', 'ORDER', 'INTERSECT', ('nomatch1',) current token = ((-6, 'WHERE'), 'WHERE') Both users will be accessing the same database. I don't know why this error occurs.If we refresh the error occurred page then it doesn't give error(that time no other user was pressing submit button). In the product which i have implemented multiple users will enter & fill the forms simultaneously. waiting for your immediate reply. bye, jacintha
jacintha menezes writes:
When two users enter their login name & password and press enter simultaniously,the first who entered among the two gets the following error.
Error Type: SyntaxError Error Value: unexpected token sequence.near :: 'of_que\012from noq'*'' ******************************* current state = 277 expects: '*', ';', ')', 'ORDER', ('nomatch1',) current token = ((-6, 'FROM'), 'FROM')
That looks as if Gadfly would not be thread safe. More precisely, as if the parser state got mangled by concurrent thread activity. When I looked at the code of ZGadflyDA (some years ago), I thought that the Gadfly database adapter would set a global lock and therefore behave like a monitor. In such a case, such behaviour should not be observable. Maybe, I was mislead or something changed meanwhile.
waiting for your immediate reply. ^^^^^^^^^ I am in doubt whether I shall get angry. I won't -- yet. But please keep in mind, that neither me nor the list has any obligations towards you.
Dieter
Hi, Thanks for your response.I am sorry for the way of my writing. Sincerely to tell you ,by the word 'immediately' i meant request & not command.Anyhow hope you have forgiven me. May i know ,is there any way to solve my problem ?. Should i create a work space or should i lock the page(till one person completes).Are there any dtml tags tags for these purposes or we have to write o python module ?. Thanks, Bye, jacintha
participants (2)
-
Dieter Maurer -
jacintha menezes