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
