Bom dia, estou migrando minha aplicação que utiliza duas base de dados postgresql 9.2 e ao realizar transações nas duas bases o rollback deixou de funcionar, segue abaixo o log:
[4-1] id:0 LOG: execute S_1: BEGIN [5-1] id:0 ERROR: value too long for type character varying(60) [6-1] id:0 STATEMENT: INSERT INTO Cidade (nome) VALUES ($1) returning codigo [7-1] id:181376 LOG: execute <unnamed>: PREPARE TRANSACTION '4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwA' [7-1] id:0 LOG: execute <unnamed>: PREPARE TRANSACTION '4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwB' [8-1] id:0 LOG: execute <unnamed>: COMMIT PREPARED '4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwA' [8-1] id:0 LOG: execute <unnamed>: COMMIT PREPARED '4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwB' [9-1] id:0 ERROR: prepared transaction with identifier "4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwB" does not exist [10-1] id:0 STATEMENT: COMMIT PREPARED '4871251_AgAAAF42gdhhbGVzc2FuZHJvLXBjLHNlcnZlcixQMTAw_YWxlc3NhbmRyby1wYyxzZXJ2ZXIsUDEwMCwB' obs.: o parâmetro max_prepared_statements já está configurado. alguma dica? Alessandro Lima email [email protected]
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
