Akcije
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:
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
Izmjenjeno od Ernad Husremović prije više od 14 godina
ovo gore se odnosi na poruke
there is already a transaction in progress
Izmjenjeno od Ernad Husremović prije više od 14 godina
dok se negdje pojavljje slučaj
commit
ili rollback
van "begin ... end" bloka.
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
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
Izmjenjeno od Ernad Husremović prije više od 14 godina
tako i za end, commit, rolloback
Izmjenjeno od Saša Vranić prije više od 14 godina
Izmjenjeno od Saša Vranić prije više od 14 godina
shvatio sam da možeš imati više transakcija u prometu
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
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
Izmjenjeno od Saša Vranić prije oko 14 godina
- Status promijenjeno iz Dodijeljeno u Zatvoreno
Akcije