This is becoming serious, because datbase has several hundreds procedures and some of them have the same situation (date arguments and variables) and have the same problem. Problem manifsts only when free statement is issues. Problem disappers when the procedure is changes from the IBExpert procedure edit form. But still the following situation happens (on clean server - that is restarted):
- I execute mentioned statement in IBExpert editor, IBExpert immediatly gives error message:
"Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Error reading data from the connection.
Connection will be closed immediately."
The connection becomes cloased.
- I reopen connection and go to the procedure edit form and execute edit from this editor - the error message appears:
This operation is not defined for system tables.
unsuccessful metadata update.
unknown ISC error 336397267.
deadlock.
update conflicts with concurrent update.
concurrent transaction number is 720.
Only when I restart server I can edit procedure and commit changes of procedure from the procedure edit form.
There seems to be some problems with transactions...
Posted by: jonatan.lauritsen@yahoo.dk
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment