Projekat

Općenito

Profil

Akcije
Copy link

Podrška #26687

Zatvoren

there is already a transaction in progress, there is no transaction in progress

Dodano od Ernad Husremović prije više od 14 godina. Izmjenjeno prije oko 14 godina.

Status:
Zatvoreno
Prioritet:
Normalan
Odgovorna osoba:
Saša Vranić
Početak:
14.02.2012
Završetak:
% završeno:

0%

Procjena vremena:
Akcije
Copy link
 #1

Izmjenjeno od Ernad Husremović prije više od 14 godina 

WARNING:  there is no transaction in progress
WARNING:  there is no transaction in progress
WARNING:  there is no transaction in progress

ovo se nije prije pojavljivalo.

izgleda da se pojavlj transakcija na transakciju

nešto ovako:

begin

..

         begin
               commit
         end

...

   commit

    rollback

end

Akcije
Copy link
 #2

Izmjenjeno od Ernad Husremović prije više od 14 godina

ovo gore se odnosi na poruke

there is already a transaction in progress
Akcije
Copy link
 #3

Izmjenjeno od Ernad Husremović prije više od 14 godina

dok se negdje pojavljje slučaj

commit

ili rollback

van "begin ... end" bloka.

Akcije
Copy link
 #4

Izmjenjeno od Ernad Husremović prije više od 14 godina

  • Naslov promijenjeno iz transaction already in progres u there is already a transaction in progress, there is no transaction in progress

iako prijavljuje kao warninge ovo definitivno ukazuje da nešto u kodu nije dobro

Akcije
Copy link
 #5

Izmjenjeno od Ernad Husremović prije više od 14 godina

treba na sva mjesta kod ažuriranja FIN staviti

if gDebug > 7
    log_write("sql begin ime tabele")
end

sql begin kod
Akcije
Copy link
 #6

Izmjenjeno od Ernad Husremović prije više od 14 godina

tako i za end, commit, rolloback

Akcije
Copy link
 #7

Izmjenjeno od Saša Vranić prije više od 14 godina

To je ovdje, znam gdje se pojavljuje:

begin suban

pa se dešava update

pa begin sint

itd...

i onda na kraju END

Akcije
Copy link
 #8

Izmjenjeno od Saša Vranić prije više od 14 godina

shvatio sam da možeš imati više transakcija u prometu

Akcije
Copy link
 #9

Izmjenjeno od Ernad Husremović prije više od 14 godina

uradio povrat, pa ažuriranje AM-00002 dokumenta

hernad@macan:~/github/F18_knowhow$ tail -n 100 F18.log 

_sql_query VALTYPE(_ret) = O
push ids: fin_suban / (array): 1 / 10AM00000002   1 ; 
push ids qry: UPDATE fmk.semaphores_fin_suban SET ids = ids || ARRAY['10AM00000002   1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002   1'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_suban WHERE idfirma='10' AND idvn='AM' AND brnal='00000002' AND rbr='   2'
_sql_query VALTYPE(_ret) = O
push ids: fin_suban / (array): 1 / 10AM00000002   2 ; 
push ids qry: UPDATE fmk.semaphores_fin_suban SET ids = ids || ARRAY['10AM00000002   2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002   2'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_sint WHERE idfirma='10' AND idvn='AM' AND brnal='00000002' AND rbr='  1'
_sql_query VALTYPE(_ret) = O
push ids: fin_sint / (array): 1 / 10AM00000002  1 ; 
push ids qry: UPDATE fmk.semaphores_fin_sint SET ids = ids || ARRAY['10AM00000002  1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  1'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_sint WHERE idfirma='10' AND idvn='AM' AND brnal='00000002' AND rbr='  2'
_sql_query VALTYPE(_ret) = O
push ids: fin_sint / (array): 1 / 10AM00000002  2 ; 
push ids qry: UPDATE fmk.semaphores_fin_sint SET ids = ids || ARRAY['10AM00000002  2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  2'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_anal WHERE idfirma='10' AND idvn='AM' AND brnal='00000002' AND rbr='  1'
_sql_query VALTYPE(_ret) = O
push ids: fin_anal / (array): 1 / 10AM00000002  1 ; 
push ids qry: UPDATE fmk.semaphores_fin_anal SET ids = ids || ARRAY['10AM00000002  1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  1'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_anal WHERE idfirma='10' AND idvn='AM' AND brnal='00000002' AND rbr='  2'
_sql_query VALTYPE(_ret) = O
push ids: fin_anal / (array): 1 / 10AM00000002  2 ; 
push ids qry: UPDATE fmk.semaphores_fin_anal SET ids = ids || ARRAY['10AM00000002  2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  2'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
DELETE FROM fmk.fin_nalog WHERE idfirma='10' AND idvn='AM' AND brnal='00000002'
_sql_query VALTYPE(_ret) = O
push ids: fin_nalog / (array): 1 / 10AM00000002 ; 
push ids qry: UPDATE fmk.semaphores_fin_nalog SET ids = ids || ARRAY['10AM00000002'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_suban(idfirma, idvn, brnal, rbr, datdok, datval, opis, idpartner, idkonto, d_P, iznosbhd, iznosdem) VALUES('10','AM','00000002','   1','2011-12-31',NULL,'amortizacija 2011 SII                                                           ','      ','1094   ','2',          1822.00,           931.55)
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_suban(idfirma, idvn, brnal, rbr, datdok, datval, opis, idpartner, idkonto, d_P, iznosbhd, iznosdem) VALUES('10','AM','00000002','   2','2011-12-31',NULL,'amortizacija 2011 SII                                                           ','      ','5401   ','1',          1822.00,           931.55)
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_anal(idfirma, idvn, brnal, rbr, datnal, idkonto, dugbhd, potbhd, dugdem, potdem) VALUES('10','AM','00000002','  1','2011-12-31','1094   ',             0.00,          1822.00,           0.00,         931.55)
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_anal(idfirma, idvn, brnal, rbr, datnal, idkonto, dugbhd, potbhd, dugdem, potdem) VALUES('10','AM','00000002','  2','2011-12-31','5401   ',          1822.00,             0.00,         931.55,           0.00)
_sql_query VALTYPE(_ret) = O
BEGIN;
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_sint(idfirma, idvn, brnal, rbr, datnal, idkonto, dugbhd, potbhd, dugdem, potdem) VALUES('10','AM','00000002','  1','2011-12-31','109',             0.00,          1822.00,           0.00,         931.55)
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_sint(idfirma, idvn, brnal, rbr, datnal, idkonto, dugbhd, potbhd, dugdem, potdem) VALUES('10','AM','00000002','  2','2011-12-31','540',          1822.00,             0.00,         931.55,           0.00)
_sql_query VALTYPE(_ret) = O
SQL BEGIN: fmk.fin_nalog
BEGIN;
_sql_query VALTYPE(_ret) = O
INSERT INTO fmk.fin_nalog(idfirma, idvn, brnal, datnal, dugbhd, potbhd, dugdem, potdem) VALUES('10','AM','00000002','2012-02-14',          1822.00,          1822.00,         931.55,         931.55)
_sql_query VALTYPE(_ret) = O
push ids: fin_suban / (array): 1 / 10AM00000002   1 ; 
push ids qry: UPDATE fmk.semaphores_fin_suban SET ids = ids || ARRAY['10AM00000002   1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002   1'] <@ ids)) ;
push ids: fin_suban / (array): 1 / 10AM00000002   2 ; 
push ids qry: UPDATE fmk.semaphores_fin_suban SET ids = ids || ARRAY['10AM00000002   2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002   2'] <@ ids)) ;
push ids: fin_sint / (array): 1 / 10AM00000002  1 ; 
push ids qry: UPDATE fmk.semaphores_fin_sint SET ids = ids || ARRAY['10AM00000002  1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  1'] <@ ids)) ;
push ids: fin_sint / (array): 1 / 10AM00000002  2 ; 
push ids qry: UPDATE fmk.semaphores_fin_sint SET ids = ids || ARRAY['10AM00000002  2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  2'] <@ ids)) ;
push ids: fin_anal / (array): 1 / 10AM00000002  1 ; 
push ids qry: UPDATE fmk.semaphores_fin_anal SET ids = ids || ARRAY['10AM00000002  1'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  1'] <@ ids)) ;
push ids: fin_anal / (array): 1 / 10AM00000002  2 ; 
push ids qry: UPDATE fmk.semaphores_fin_anal SET ids = ids || ARRAY['10AM00000002  2'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002  2'] <@ ids)) ;
push ids: fin_nalog / (array): 1 / 10AM00000002 ; 
push ids qry: UPDATE fmk.semaphores_fin_nalog SET ids = ids || ARRAY['10AM00000002'] WHERE user_code <> 'hernad' AND ((ids IS NULL) OR NOT (ARRAY['10AM00000002'] <@ ids)) ;
COMMIT;
_sql_query VALTYPE(_ret) = O
COMMIT;
_sql_query VALTYPE(_ret) = O
COMMIT;
_sql_query VALTYPE(_ret) = O
SQL COMMIT: fmk.fin_nalog
COMMIT;
_sql_query VALTYPE(_ret) = O
azuriram: 10AM00000002 saldo              0.00

Akcije
Copy link
 #10

Izmjenjeno od Ernad Husremović prije više od 14 godina

fakat čudno:

hernad@macan:~/github/F18_knowhow$ cat F18.log | grep "^SQL " 

SQL BEGIN: fmk.fin_nalog
SQL COMMIT: fmk.fin_nalog

zašto samo ovdje imamo begin commit

nije čudno ... počinje sa nalog i završava sa nalog.

begin commit nije vezana za neku tabelu nego za transakciju

Akcije
Copy link
 #11

Izmjenjeno od Saša Vranić prije oko 14 godina

  • Status promijenjeno iz Dodijeljeno u Zatvoreno
Akcije
Copy link

Također dostupno kao Atom PDF