ERROR: EVP_CipherFinal_ex failed. OpenSSL error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt

[cobolbaby]

If you're dealing with a TEXT field, encryption and decryption issues may pop up.

postgres=# create table t(id int primary key, col2 text);
CREATE TABLE
postgres=# create table t_tde(id int primary key, col2 text) using pg_tde;
CREATE TABLE
postgres=# \timing on
Timing is on.
postgres=# insert into t select n, md5(random()::varchar) || n from generate_series(1, 1000000) as n;
INSERT 0 1000000
Time: 3345.107 ms (00:03.345)

postgres=# insert into t_tde select n, md5(random()::varchar) || n from generate_series(1, 1000000) as n;
2023-11-11 06:53:56.092 CST [12609] ERROR:  EVP_CipherFinal_ex failed. OpenSSL error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt
2023-11-11 06:53:56.092 CST [12609] STATEMENT:  insert into t_tde select n, md5(random()::varchar) || n from generate_series(1, 1000000) as n;
ERROR:  EVP_CipherFinal_ex failed. OpenSSL error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt
Time: 80.529 ms
postgres=# insert into t_tde values(0, 'abcdefg');
ERROR:  EVP_CipherFinal_ex failed. OpenSSL error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt
Time: 1.043 ms

[dutow]

Thank you for the bug report @cobolbaby

Could you give us a more detailed description, do you have example SQL statements that cause this error?

[dutow]

Fixed by #105