How to solve 'statement timeout' when searching a large domain
153 views
Skip to first unread message
loce
unread,
Jan 23, 2021, 9:37:57 AM1/23/21
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to crt.sh
Hi CRT team.
When I use python to search a large domain(netflix.com - for example),it will bring back 'canceling statement due to statement timeout'.
I know you has reported on-list here in past, but i don't sure whether you have a better method to slove it now. I have tried to limit the sql query result about half of the domain certificates to avoid this problem.
Thanks a lot for your work.
-
loce
r...@sectigo.com
unread,
Jan 26, 2021, 8:00:30 AM1/26/21
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to crt.sh
Hi. Sorry, nothing's changed regarding query and session timeouts, and I'm not aware of a better method to solve the problem of long-running queries affecting the database replication.
loce
unread,
Jan 26, 2021, 8:32:00 AM1/26/21
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to crt.sh
Thanks for your answer. Maybe I need to think about other methods.