please, somebody help me out On Monday, February 23, 2015 3:57 PM, "SUKHEN DASS sukhend...@yahoo.com [firebird-support]" <firebird-support@yahoogroups.com> wrote:
is it could be any buffersize/memmroy issue. please, suggest if it is how to check it in firebird On Monday, February 23, 2015 3:51 PM, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" <firebird-support@yahoogroups.com> wrote: >update never fails but it fails in insert query. loop run in a single connection with a new datarows in same query. I think it is about time to show us some code (not all). Could it be that another transaction not visible to your current transaction has inserted a row that creates a lock conflict with your insert and that your code repeatedly tries (and fails) to insert? Or that it is a real deadlock, where one transaction first successfully updates record A, then fails on record B, whereas another transaction has successfully updated record B and fails on record A? Typically, there would be no problems on INSERT, whereas UPDATE could create problems. Getting the problem on INSERT, I'd say indicates some kind of lock conflict which means that you have some UNIQUE field or constraint or don't use generators to populate your primary key. Set #yiv9669967872 #yiv9669967872 -- #yiv9669967872ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9669967872 #yiv9669967872ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9669967872 #yiv9669967872ygrp-mkp #yiv9669967872hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9669967872 #yiv9669967872ygrp-mkp #yiv9669967872ads {margin-bottom:10px;}#yiv9669967872 #yiv9669967872ygrp-mkp .yiv9669967872ad {padding:0 0;}#yiv9669967872 #yiv9669967872ygrp-mkp .yiv9669967872ad p {margin:0;}#yiv9669967872 #yiv9669967872ygrp-mkp .yiv9669967872ad a {color:#0000ff;text-decoration:none;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ygrp-lc {font-family:Arial;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ygrp-lc #yiv9669967872hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ygrp-lc .yiv9669967872ad {margin-bottom:10px;padding:0 0;}#yiv9669967872 #yiv9669967872actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9669967872 #yiv9669967872activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9669967872 #yiv9669967872activity span {font-weight:700;}#yiv9669967872 #yiv9669967872activity span:first-child {text-transform:uppercase;}#yiv9669967872 #yiv9669967872activity span a {color:#5085b6;text-decoration:none;}#yiv9669967872 #yiv9669967872activity span span {color:#ff7900;}#yiv9669967872 #yiv9669967872activity span .yiv9669967872underline {text-decoration:underline;}#yiv9669967872 .yiv9669967872attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9669967872 .yiv9669967872attach div a {text-decoration:none;}#yiv9669967872 .yiv9669967872attach img {border:none;padding-right:5px;}#yiv9669967872 .yiv9669967872attach label {display:block;margin-bottom:5px;}#yiv9669967872 .yiv9669967872attach label a {text-decoration:none;}#yiv9669967872 blockquote {margin:0 0 0 4px;}#yiv9669967872 .yiv9669967872bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9669967872 .yiv9669967872bold a {text-decoration:none;}#yiv9669967872 dd.yiv9669967872last p a {font-family:Verdana;font-weight:700;}#yiv9669967872 dd.yiv9669967872last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9669967872 dd.yiv9669967872last p span.yiv9669967872yshortcuts {margin-right:0;}#yiv9669967872 div.yiv9669967872attach-table div div a {text-decoration:none;}#yiv9669967872 div.yiv9669967872attach-table {width:400px;}#yiv9669967872 div.yiv9669967872file-title a, #yiv9669967872 div.yiv9669967872file-title a:active, #yiv9669967872 div.yiv9669967872file-title a:hover, #yiv9669967872 div.yiv9669967872file-title a:visited {text-decoration:none;}#yiv9669967872 div.yiv9669967872photo-title a, #yiv9669967872 div.yiv9669967872photo-title a:active, #yiv9669967872 div.yiv9669967872photo-title a:hover, #yiv9669967872 div.yiv9669967872photo-title a:visited {text-decoration:none;}#yiv9669967872 div#yiv9669967872ygrp-mlmsg #yiv9669967872ygrp-msg p a span.yiv9669967872yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9669967872 .yiv9669967872green {color:#628c2a;}#yiv9669967872 .yiv9669967872MsoNormal {margin:0 0 0 0;}#yiv9669967872 o {font-size:0;}#yiv9669967872 #yiv9669967872photos div {float:left;width:72px;}#yiv9669967872 #yiv9669967872photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9669967872 #yiv9669967872photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9669967872 #yiv9669967872reco-category {font-size:77%;}#yiv9669967872 #yiv9669967872reco-desc {font-size:77%;}#yiv9669967872 .yiv9669967872replbq {margin:4px;}#yiv9669967872 #yiv9669967872ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9669967872 #yiv9669967872ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9669967872 #yiv9669967872ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9669967872 #yiv9669967872ygrp-mlmsg select, #yiv9669967872 input, #yiv9669967872 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9669967872 #yiv9669967872ygrp-mlmsg pre, #yiv9669967872 code {font:115% monospace;}#yiv9669967872 #yiv9669967872ygrp-mlmsg * {line-height:1.22em;}#yiv9669967872 #yiv9669967872ygrp-mlmsg #yiv9669967872logo {padding-bottom:10px;}#yiv9669967872 #yiv9669967872ygrp-msg p a {font-family:Verdana;}#yiv9669967872 #yiv9669967872ygrp-msg p#yiv9669967872attach-count span {color:#1E66AE;font-weight:700;}#yiv9669967872 #yiv9669967872ygrp-reco #yiv9669967872reco-head {color:#ff7900;font-weight:700;}#yiv9669967872 #yiv9669967872ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ov li a {font-size:130%;text-decoration:none;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9669967872 #yiv9669967872ygrp-sponsor #yiv9669967872ov ul {margin:0;padding:0 0 0 8px;}#yiv9669967872 #yiv9669967872ygrp-text {font-family:Georgia;}#yiv9669967872 #yiv9669967872ygrp-text p {margin:0 0 1em 0;}#yiv9669967872 #yiv9669967872ygrp-text tt {font-size:120%;}#yiv9669967872 #yiv9669967872ygrp-vital ul li:last-child {border-right:none !important;}#yiv9669967872