2024-11-24 06:06:38.557 UTC postmaster[19673] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-11-24 06:06:38.557 UTC postmaster[19673] LOG: listening on Unix socket "/tmp/pg_regress-Dnf0uh/.s.PGSQL.40031" 2024-11-24 06:06:38.559 UTC startup[19676] LOG: database system was shut down at 2024-11-24 06:06:38 UTC 2024-11-24 06:06:38.560 UTC postmaster[19673] LOG: database system is ready to accept connections 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init ERROR: gen_salt: Unknown salt algorithm 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init STATEMENT: select gen_salt('foo'); 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init STATEMENT: select digest('foo', 'foo'); 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init ERROR: Cannot use "foo": No such hash algorithm 2024-11-24 06:06:38.648 UTC client backend[19684] pg_regress/init STATEMENT: select hmac('foo', 'foo', 'foo'); 2024-11-24 06:06:38.649 UTC client backend[19684] pg_regress/init ERROR: Cannot use "foo": No such cipher algorithm 2024-11-24 06:06:38.649 UTC client backend[19684] pg_regress/init STATEMENT: select encrypt('foo', 'foo', 'foo'); 2024-11-24 06:06:38.703 UTC client backend[19702] pg_regress/rijndael ERROR: encrypt error: Encryption failed 2024-11-24 06:06:38.703 UTC client backend[19702] pg_regress/rijndael STATEMENT: SELECT encrypt( '\x00112233445566778899aabbccddeeff00', '\x000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'aes-cbc/pad:none'); 2024-11-24 06:06:38.704 UTC client backend[19702] pg_regress/rijndael ERROR: decrypt error: Decryption failed 2024-11-24 06:06:38.704 UTC client backend[19702] pg_regress/rijndael STATEMENT: select encode(decrypt(encrypt('foo', '0123456', 'aes') || '\x00'::bytea, '0123456', 'aes'), 'escape'); 2024-11-24 06:06:38.704 UTC client backend[19702] pg_regress/rijndael ERROR: decrypt_iv error: Decryption failed 2024-11-24 06:06:38.704 UTC client backend[19702] pg_regress/rijndael STATEMENT: select encode(decrypt_iv('\xa21a9c15231465964e3396d32095e67eb52bab05f556a581621dee1b85385789', '0123456', 'abcd', 'aes'), 'escape'); 2024-11-24 06:06:38.751 UTC client backend[19717] pg_regress/crypt-des ERROR: invalid salt 2024-11-24 06:06:38.751 UTC client backend[19717] pg_regress/crypt-des STATEMENT: SELECT crypt('password', 'a'); 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish ERROR: invalid salt 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$'); 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish ERROR: invalid salt 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$40$RQiOJ.3ELirrXwxIZY8q0O'); 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish ERROR: invalid salt 2024-11-24 06:06:38.786 UTC client backend[19723] pg_regress/crypt-blowfish STATEMENT: SELECT crypt('foox', '$2a$00$RQiOJ.3ELirrXwxIZY8q0O'); 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes ERROR: invalid salt 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes STATEMENT: SELECT crypt('foox', '_J9..BWH'); 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_........'); 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes ERROR: crypt(3) returned NULL 2024-11-24 06:06:38.833 UTC client backend[19726] pg_regress/crypt-xdes STATEMENT: SELECT crypt('password', '_..!!!!!!'); 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select dearmor(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- foo: em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor ERROR: Corrupt ascii-armor 2024-11-24 06:06:38.849 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select * from pgp_armor_headers(' -----BEGIN PGP MESSAGE----- em9va2E= =ZZZZ -----END PGP MESSAGE----- '); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: mismatched array dimensions 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array['too', 'many']); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: mismatched array dimensions 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['too', 'many'], array['foo']); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array[['']], array['foo']); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: wrong number of array subscripts 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[['']]); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: null value not allowed for header key 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array[null], array['foo']); 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor ERROR: null value not allowed for header value 2024-11-24 06:06:38.852 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[null]); 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor ERROR: header key must not contain newlines 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array[E'embedded\nnewline'], array['foo']); 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor ERROR: header value must not contain newlines 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['foo'], array[E'embedded\nnewline']); 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor ERROR: header key must not contain ": " 2024-11-24 06:06:38.853 UTC client backend[19729] pg_regress/pgp-armor STATEMENT: select armor('', array['embedded: colon+space'], array['foo']); 2024-11-24 06:06:38.881 UTC client backend[19732] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2024-11-24 06:06:38.881 UTC client backend[19732] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- ww0EBwMCxf8PTrQBmJdl0jcB6y2joE7GSLKRv7trbNsF5Z8ou5NISLUg31llVH/S0B2wl4bvzZjV VsxxqLSPzNLAeIspJk5G =mSd/ -----END PGP MESSAGE----- '), 'wrong-key', 'debug=1'); 2024-11-24 06:06:38.881 UTC client backend[19732] pg_regress/pgp-decrypt ERROR: Not text data 2024-11-24 06:06:38.881 UTC client backend[19732] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('P', 'key'), 'key', 'debug=1'); 2024-11-24 06:06:38.882 UTC client backend[19732] pg_regress/pgp-decrypt ERROR: Wrong key or corrupt data 2024-11-24 06:06:38.882 UTC client backend[19732] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- ww0EBwMC9rK/dMkF5Zlt0jcBlzAQ1mQY2qYbKYbw8h3EZ5Jk0K2IiY92R82TRhWzBIF/8cmXDPtP GXsd65oYJZp3Khz0qfyn =Nmpq -----END PGP MESSAGE----- '), 'wrong-key', 'debug=1'); 2024-11-24 06:06:38.882 UTC client backend[19732] pg_regress/pgp-decrypt ERROR: Unsupported compression algorithm 2024-11-24 06:06:38.882 UTC client backend[19732] pg_regress/pgp-decrypt STATEMENT: select pgp_sym_decrypt(dearmor(' -----BEGIN PGP MESSAGE----- jA0EBwMCRhFrAKNcLVJg0mMBLJG1cCASNk/x/3dt1zJ+2eo7jHfjgg3N6wpB3XIe QCwkWJwlBG5pzbO5gu7xuPQN+TbPJ7aQ2sLx3bAHhtYb0i3vV9RO10Gw++yUyd4R UCAAw2JRIISttRHMfDpDuZJpvYo= =AZ9M -----END PGP MESSAGE----- '), 'key', 'debug=1'); 2024-11-24 06:06:38.894 UTC client backend[19741] pg_regress/pgp-encrypt ERROR: Not text data 2024-11-24 06:06:38.894 UTC client backend[19741] pg_regress/pgp-encrypt STATEMENT: select pgp_sym_decrypt(pgp_sym_encrypt_bytea('Binary', 'baz'), 'baz'); 2024-11-24 06:06:39.242 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key 2024-11-24 06:06:39.242 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=2 and encdata.id=1; 2024-11-24 06:06:39.243 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: No encryption key found 2024-11-24 06:06:39.243 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=4 and encdata.id=1; 2024-11-24 06:06:39.244 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2024-11-24 06:06:39.244 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey), '123') from keytbl, encdata where keytbl.id=7 and encdata.id=4; 2024-11-24 06:06:39.247 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: Need password for secret key 2024-11-24 06:06:39.247 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=5 and encdata.id=1; 2024-11-24 06:06:39.247 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2024-11-24 06:06:39.247 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey), 'foo') from keytbl, encdata where keytbl.id=5 and encdata.id=1; 2024-11-24 06:06:39.251 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt ERROR: Wrong key or corrupt data 2024-11-24 06:06:39.251 UTC client backend[19754] pg_regress/pgp-pubkey-decrypt STATEMENT: select pgp_pub_decrypt(dearmor(data), dearmor(seckey)) from keytbl, encdata where keytbl.id=6 and encdata.id=5; 2024-11-24 06:06:39.272 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt ERROR: No encryption key found 2024-11-24 06:06:39.272 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt('Secret msg', dearmor(pubkey)), dearmor(seckey)) from keytbl where keytbl.id=4; 2024-11-24 06:06:39.273 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt ERROR: Refusing to encrypt with secret key 2024-11-24 06:06:39.273 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt('Secret msg', dearmor(seckey)), dearmor(seckey)) from keytbl where keytbl.id=1; 2024-11-24 06:06:39.274 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt ERROR: Not text data 2024-11-24 06:06:39.274 UTC client backend[19757] pg_regress/pgp-pubkey-encrypt STATEMENT: select pgp_pub_decrypt( pgp_pub_encrypt_bytea('Secret msg', dearmor(pubkey)), dearmor(seckey)) from keytbl where keytbl.id=1; 2024-11-24 06:06:39.284 UTC client backend[19760] pg_regress/pgp-info ERROR: No encryption key found 2024-11-24 06:06:39.284 UTC client backend[19760] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(pubkey)) from keytbl where id=4; 2024-11-24 06:06:39.286 UTC client backend[19760] pg_regress/pgp-info ERROR: No encryption key found 2024-11-24 06:06:39.286 UTC client backend[19760] pg_regress/pgp-info STATEMENT: select pgp_key_id(dearmor(seckey)) from keytbl where id=4; 2024-11-24 06:06:39.313 UTC postmaster[19673] LOG: received fast shutdown request 2024-11-24 06:06:39.313 UTC postmaster[19673] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 19673 0xaa0b82 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89dcf7 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89c1f9 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89b5cb at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres