Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

crt.sh was down and leaking too much information. #10

Open
d-oderbolz opened this issue May 12, 2023 · 2 comments
Open

crt.sh was down and leaking too much information. #10

d-oderbolz opened this issue May 12, 2023 · 2 comments

Comments

@d-oderbolz
Copy link

I executed the search https://crt.sh/?q=sbb.ch
and got this error:

"FATAL: terminating connection due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be removed.
CONTEXT: PL/pgSQL function line 4216 at FOR over EXECUTE statement
ERROR : server conn crashed?
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request."

Therefore I know you are running postgres.

@strboul
Copy link

strboul commented Jul 11, 2023

Got similar error at https://crt.sh/?q=ts.net

FATAL:  terminating connection due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be removed.
CONTEXT:  PL/pgSQL function web_apis(text,text[],text[]) line 4216 at FOR over EXECUTE statement
ERROR:  server conn crashed?
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

@AyrA
Copy link

AyrA commented Aug 7, 2024

Same here. It just dumped the entire SQL query.

FATAL:  terminating connection due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be removed.
CONTEXT:  SQL statement "SELECT c.ID, x509_print(c.CERTIFICATE, NULL, 196608), ca.ID, cac.CA_ID,
					digest(c.CERTIFICATE, 'sha1'::text),
					digest(c.CERTIFICATE, 'sha256'::text),
					x509_serialNumber(c.CERTIFICATE),
					digest(x509_publicKey(c.CERTIFICATE), 'sha256'::text),
					x509_rsamodulus(c.CERTIFICATE),
					x509_hasROCAFingerprint(c.CERTIFICATE),
					x509_hasClosePrimes(c.CERTIFICATE),
					c.CERTIFICATE
				                                                                                                                                                                                                                                          FROM certificate c
					LEFT OUTER JOIN ca ON (c.ISSUER_CA_ID = ca.ID)
					LEFT OUTER JOIN ca_certificate cac
									ON (c.ID = cac.CERTIFICATE_ID)
				WHERE digest(c.CERTIFICATE, 'sha256') = t_bytea"
PL/pgSQL function web_apis(text,text[],text[]) line 2087 at SQL statement
FATAL:  server conn crashed?
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants