hilms: January 2017

Re: [firebird-support] Insert SQL Deadlock Issue

04.01.2017 13:36, Vishal Tiwari vishualsoft@yahoo.co.in [firebird-support] wrote:
> Error 3:
> *validation error for column VAT, value "*** null ***"*
> * -sql_dialect set database dialect n*
> *
> *

First of all fix fbclient.dll(gds32.dll) - firebird.msg version mismatch.

--
WBR, SD.

------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Insert SQL Deadlock Issue

Just checked in the code Transaction components are used. Sorry for mistake.

On Wednesday, 4 January 2017 5:40 PM, "Vishal Tiwari vishualsoft@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> wrote:

Hi All,

At production department, we are receiving below errors, not for all times, but frequently. We tried looking into code and found that there is a very simple insert statement which might cause that issue. Because functionality executes that Insert statement.

Wondering how to resolve that issue, because as a developer we are not able to reproduce these error at least once.

We are using Delphi 6 and Firbird version is 2.5.2. I found that Transaction component in Delphi is not used while executing the SQL.

Error 1:

There was an error processing this cancellation on main server.

lock conflict on no wait transaction

deadlock

update conflicts with concurrent update

requires both input and output filenames

Error 2:

There was an error RaiseFees.

Unable to complete network request to host "<Our Server Name>".

Error writing data to the connection.

unknown Win32 error 10054

Error 3:

validation error for column VAT, value "*** null ***"

-sql_dialect set database dialect n

Please help in this regards, as it seems deadlock issue.

Trying hard to get the solution.

With Best Regards.

Vishal

__._,_.___

Posted by: Vishal Tiwari <vishualsoft@yahoo.co.in>

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group