its not always at same insert statement....hang insert statement varies On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS <sukhend...@yahoo.com> wrote:
its a window base app using vb.net... i will definitely try your suggestion On Wednesday, February 25, 2015 11:48 AM, "'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]" <firebird-support@yahoogroups.com> 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 sukhend...@yahoo.com [firebird-support]" <firebird-support@yahoogroups.com> Do: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com> 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 aharri...@ibphoenix.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: On Feb 23, 2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com [firebird-support] <firebird-support@yahoogroups.com> 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