its not always at same insert statement....hang insert statement varies
On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS
<[email protected]> wrote:
its a window base app using vb.net... i will definitely try your suggestion
On Wednesday, February 25, 2015 11:48 AM, "'[email protected]'
[email protected] [firebird-support]"
<[email protected]> wrote:
Hi,
1. Is this VB exe or web?
2. Save all insert statement parameters to tabbed csv and you will see at what
statment it stop. If this is always at the same statement, then compare it e.g.
in excel withprevious statements.
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "SUKHEN DASS [email protected] [firebird-support]"
<[email protected]>
Do: "[email protected]" <[email protected]>
Temat: [firebird-support] Re: Is there still a difference between sweep and
gabage collection?
Data: wt., lut 24, 2015 14:42
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. / div>
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 wa it" 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
#yiv9625703431 -- #yiv9625703431ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9625703431
#yiv9625703431ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9625703431
#yiv9625703431ygrp-mkp #yiv9625703431hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9625703431 #yiv9625703431ygrp-mkp #yiv9625703431ads
{margin-bottom:10px;}#yiv9625703431 #yiv9625703431ygrp-mkp .yiv9625703431ad
{padding:0 0;}#yiv9625703431 #yiv9625703431ygrp-mkp .yiv9625703431ad p
{margin:0;}#yiv9625703431 #yiv9625703431ygrp-mkp .yiv9625703431ad a
{color:#0000ff;text-decoration:none;}#yiv9625703431 #yiv9625703431ygrp-sponsor
#yiv9625703431ygrp-lc {font-family:Arial;}#yiv9625703431
#yiv9625703431ygrp-sponsor #yiv9625703431ygrp-lc #yiv9625703431hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9625703431
#yiv9625703431ygrp-sponsor #yiv9625703431ygrp-lc .yiv9625703431ad
{margin-bottom:10px;padding:0 0;}#yiv9625703431 #yiv9625703431actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9625703431
#yiv9625703431activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9625703431
#yiv9625703431activity span {font-weight:700;}#yiv9625703431
#yiv9625703431activity span:first-child
{text-transform:uppercase;}#yiv9625703431 #yiv9625703431activity span a
{color:#5085b6;text-decoration:none;}#yiv9625703431 #yiv9625703431activity span
span {color:#ff7900;}#yiv9625703431 #yiv9625703431activity span
.yiv9625703431underline {text-decoration:underline;}#yiv9625703431
.yiv9625703431attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9625703431 .yiv9625703431attach div a
{text-decoration:none;}#yiv9625703431 .yiv9625703431attach img
{border:none;padding-right:5px;}#yiv9625703431 .yiv9625703431attach label
{display:block;margin-bottom:5px;}#yiv9625703431 .yiv9625703431attach label a
{text-decoration:none;}#yiv9625703431 blockquote {margin:0 0 0
4px;}#yiv9625703431 .yiv9625703431bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9625703431
.yiv9625703431bold a {text-decoration:none;}#yiv9625703431 dd.yiv9625703431last
p a {font-family:Verdana;font-weight:700;}#yiv9625703431 dd.yiv9625703431last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9625703431
dd.yiv9625703431last p span.yiv9625703431yshortcuts
{margin-right:0;}#yiv9625703431 div.yiv9625703431attach-table div div a
{text-decoration:none;}#yiv9625703431 div.yiv9625703431attach-table
{width:400px;}#yiv9625703431 div.yiv9625703431file-title a, #yiv9625703431
div.yiv9625703431file-title a:active, #yiv9625703431
div.yiv9625703431file-title a:hover, #yiv9625703431 div.yiv9625703431file-title
a:visited {text-decoration:none;}#yiv9625703431 div.yiv9625703431photo-title a,
#yiv9625703431 div.yiv9625703431photo-title a:active, #yiv9625703431
div.yiv9625703431photo-title a:hover, #yiv9625703431
div.yiv9625703431photo-title a:visited {text-decoration:none;}#yiv9625703431
div#yiv9625703431ygrp-mlmsg #yiv9625703431ygrp-msg p a
span.yiv9625703431yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9625703431
.yiv9625703431green {color:#628c2a;}#yiv9625703431 .yiv9625703431MsoNormal
{margin:0 0 0 0;}#yiv9625703431 o {font-size:0;}#yiv9625703431
#yiv9625703431photos div {float:left;width:72px;}#yiv9625703431
#yiv9625703431photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9625703431
#yiv9625703431photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9625703431
#yiv9625703431reco-category {font-size:77%;}#yiv9625703431
#yiv9625703431reco-desc {font-size:77%;}#yiv9625703431 .yiv9625703431replbq
{margin:4px;}#yiv9625703431 #yiv9625703431ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9625703431 #yiv9625703431ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9625703431
#yiv9625703431ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9625703431
#yiv9625703431ygrp-mlmsg select, #yiv9625703431 input, #yiv9625703431 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9625703431
#yiv9625703431ygrp-mlmsg pre, #yiv9625703431 code {font:115%
monospace;}#yiv9625703431 #yiv9625703431ygrp-mlmsg *
{line-height:1.22em;}#yiv9625703431 #yiv9625703431ygrp-mlmsg #yiv9625703431logo
{padding-bottom:10px;}#yiv9625703431 #yiv9625703431ygrp-msg p a
{font-family:Verdana;}#yiv9625703431 #yiv9625703431ygrp-msg
p#yiv9625703431attach-count span {color:#1E66AE;font-weight:700;}#yiv9625703431
#yiv9625703431ygrp-reco #yiv9625703431reco-head
{color:#ff7900;font-weight:700;}#yiv9625703431 #yiv9625703431ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9625703431 #yiv9625703431ygrp-sponsor
#yiv9625703431ov li a {font-size:130%;text-decoration:none;}#yiv9625703431
#yiv9625703431ygrp-sponsor #yiv9625703431ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9625703431
#yiv9625703431ygrp-sponsor #yiv9625703431ov ul {margin:0;padding:0 0 0
8px;}#yiv9625703431 #yiv9625703431ygrp-text
{font-family:Georgia;}#yiv9625703431 #yiv9625703431ygrp-text p {margin:0 0 1em
0;}#yiv9625703431 #yiv9625703431ygrp-text tt {font-size:120%;}#yiv9625703431
#yiv9625703431ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9625703431
