thanks as you suggested i have check with all the possibilities but never got
suceess.Let me tell you more what i have tried before post.....1.Regular way as
i have mentioned in the thread.2.Commenting out the update, only run insert
still hang in Insert Statement.3.Commenting out the procedure which check
update to be done or not but same problem hang in Insert Statement4.Commenting
out all procedures only except insert statement still hang
On Tuesday, February 24, 2015 5:49 PM, "Ann Harrison
[email protected] [firebird-support]" <[email protected]>
wrote:
On Feb 23, 2015, at 1:06 AM, SUKHEN DASS [email protected]
[firebird-support] <[email protected]> wrote:
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table.
First, you've hijacked a thread, which is not considered polite on this very
traditional email list.
The insertion will take place if product id does not exist else record to be
update.
Right - and I'm assuming you've got more than one thread working at a time.
But inside the loop while executing ExecuteNonQuery control does not come back
wait for 10 hours still not came and no error message and it happens on random
rows not always for the same recrod
OK. What's happening is that one thread has updated the record and gone off to
do something else or gone to sleep. It's really important that you commit your
transaction after updating a record unless there's more than one record that
must be updated to make the database logically consistent.
I am struck past 7 days i am working googled but no solution Finally i decided
to firebird support team
You've come to the right place. What you should do is commit after each record
insert/update and probably choose the "no wait" transaction option. What's
happening is that one thread is updating record A without committing the update
then another thread is trying update the same record. Because there's an
uncommitted update, the second update waits, hoping the first will fail and it
can succeed. But its hopes are in vain. The first thread continues on its
merry way, ignoring the trail of uncommitted changes it leaves in its path and
the other threads, waiting for it to end.
My project is getting delayed please, help
Read some more about transaction semantics, or just get in the habit of
commiting after each set of changes that leave the database consistent.
Good luck,
Ann
#yiv1751182669 #yiv1751182669 -- #yiv1751182669ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1751182669
#yiv1751182669ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1751182669
#yiv1751182669ygrp-mkp #yiv1751182669hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1751182669 #yiv1751182669ygrp-mkp #yiv1751182669ads
{margin-bottom:10px;}#yiv1751182669 #yiv1751182669ygrp-mkp .yiv1751182669ad
{padding:0 0;}#yiv1751182669 #yiv1751182669ygrp-mkp .yiv1751182669ad p
{margin:0;}#yiv1751182669 #yiv1751182669ygrp-mkp .yiv1751182669ad a
{color:#0000ff;text-decoration:none;}#yiv1751182669 #yiv1751182669ygrp-sponsor
#yiv1751182669ygrp-lc {font-family:Arial;}#yiv1751182669
#yiv1751182669ygrp-sponsor #yiv1751182669ygrp-lc #yiv1751182669hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1751182669
#yiv1751182669ygrp-sponsor #yiv1751182669ygrp-lc .yiv1751182669ad
{margin-bottom:10px;padding:0 0;}#yiv1751182669 #yiv1751182669actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1751182669
#yiv1751182669activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1751182669
#yiv1751182669activity span {font-weight:700;}#yiv1751182669
#yiv1751182669activity span:first-child
{text-transform:uppercase;}#yiv1751182669 #yiv1751182669activity span a
{color:#5085b6;text-decoration:none;}#yiv1751182669 #yiv1751182669activity span
span {color:#ff7900;}#yiv1751182669 #yiv1751182669activity span
.yiv1751182669underline {text-decoration:underline;}#yiv1751182669
.yiv1751182669attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1751182669 .yiv1751182669attach div a
{text-decoration:none;}#yiv1751182669 .yiv1751182669attach img
{border:none;padding-right:5px;}#yiv1751182669 .yiv1751182669attach label
{display:block;margin-bottom:5px;}#yiv1751182669 .yiv1751182669attach label a
{text-decoration:none;}#yiv1751182669 blockquote {margin:0 0 0
4px;}#yiv1751182669 .yiv1751182669bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1751182669
.yiv1751182669bold a {text-decoration:none;}#yiv1751182669 dd.yiv1751182669last
p a {font-family:Verdana;font-weight:700;}#yiv1751182669 dd.yiv1751182669last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1751182669
dd.yiv1751182669last p span.yiv1751182669yshortcuts
{margin-right:0;}#yiv1751182669 div.yiv1751182669attach-table div div a
{text-decoration:none;}#yiv1751182669 div.yiv1751182669attach-table
{width:400px;}#yiv1751182669 div.yiv1751182669file-title a, #yiv1751182669
div.yiv1751182669file-title a:active, #yiv1751182669
div.yiv1751182669file-title a:hover, #yiv1751182669 div.yiv1751182669file-title
a:visited {text-decoration:none;}#yiv1751182669 div.yiv1751182669photo-title a,
#yiv1751182669 div.yiv1751182669photo-title a:active, #yiv1751182669
div.yiv1751182669photo-title a:hover, #yiv1751182669
div.yiv1751182669photo-title a:visited {text-decoration:none;}#yiv1751182669
div#yiv1751182669ygrp-mlmsg #yiv1751182669ygrp-msg p a
span.yiv1751182669yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1751182669
.yiv1751182669green {color:#628c2a;}#yiv1751182669 .yiv1751182669MsoNormal
{margin:0 0 0 0;}#yiv1751182669 o {font-size:0;}#yiv1751182669
#yiv1751182669photos div {float:left;width:72px;}#yiv1751182669
#yiv1751182669photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1751182669
#yiv1751182669photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1751182669
#yiv1751182669reco-category {font-size:77%;}#yiv1751182669
#yiv1751182669reco-desc {font-size:77%;}#yiv1751182669 .yiv1751182669replbq
{margin:4px;}#yiv1751182669 #yiv1751182669ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1751182669 #yiv1751182669ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1751182669
#yiv1751182669ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1751182669
#yiv1751182669ygrp-mlmsg select, #yiv1751182669 input, #yiv1751182669 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1751182669
#yiv1751182669ygrp-mlmsg pre, #yiv1751182669 code {font:115%
monospace;}#yiv1751182669 #yiv1751182669ygrp-mlmsg *
{line-height:1.22em;}#yiv1751182669 #yiv1751182669ygrp-mlmsg #yiv1751182669logo
{padding-bottom:10px;}#yiv1751182669 #yiv1751182669ygrp-msg p a
{font-family:Verdana;}#yiv1751182669 #yiv1751182669ygrp-msg
p#yiv1751182669attach-count span {color:#1E66AE;font-weight:700;}#yiv1751182669
#yiv1751182669ygrp-reco #yiv1751182669reco-head
{color:#ff7900;font-weight:700;}#yiv1751182669 #yiv1751182669ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1751182669 #yiv1751182669ygrp-sponsor
#yiv1751182669ov li a {font-size:130%;text-decoration:none;}#yiv1751182669
#yiv1751182669ygrp-sponsor #yiv1751182669ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1751182669
#yiv1751182669ygrp-sponsor #yiv1751182669ov ul {margin:0;padding:0 0 0
8px;}#yiv1751182669 #yiv1751182669ygrp-text
{font-family:Georgia;}#yiv1751182669 #yiv1751182669ygrp-text p {margin:0 0 1em
0;}#yiv1751182669 #yiv1751182669ygrp-text tt {font-size:120%;}#yiv1751182669
#yiv1751182669ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1751182669
