sql: only raise transaction log level to warn after 1s

sql: only raise transaction log level to warn after 1s #690