Reduntant commits and different isolation levels #2041
Description
Syncing mainnet with latest master, I got the following logs. It appears we're doing redundant Begin transaction ... Commit. Also we use 2 different isolation levels. While this may not have a performance effect, it should be sorted out
2025-12-01 02:17:43 EET [3343011]: [37967334-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.015 ms execute 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967335-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\x0103308c67a7948363dd0d4baff4a360b991ecc479ade37d797854baa1c95e1a'
2025-12-01 02:17:43 EET [3343011]: [37967336-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3343011]: [37967337-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.012 ms bind 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967338-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\xa699330f5da2afca0ffbbad421e5370e5014b49166594b7d2982431af069c950'
2025-12-01 02:17:43 EET [3343011]: [37967339-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3343011]: [37967340-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.014 ms execute 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967341-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\xa699330f5da2afca0ffbbad421e5370e5014b49166594b7d2982431af069c950'
2025-12-01 02:17:43 EET [3343011]: [37967342-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3343011]: [37967343-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.002 ms bind 10: COMMIT
2025-12-01 02:17:43 EET [3343011]: [37967344-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3343011]: [37967345-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.015 ms execute 10: COMMIT
2025-12-01 02:17:43 EET [3343011]: [37967346-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3343011]: [37967347-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.002 ms bind 5: BEGIN ISOLATION LEVEL READ COMMITTED
2025-12-01 02:17:43 EET [3343011]: [37967348-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3343011]: [37967349-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.005 ms execute 5: BEGIN ISOLATION LEVEL READ COMMITTED
2025-12-01 02:17:43 EET [3343011]: [37967350-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3348788]: [1201765-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.017 ms bind 0: BEGIN ISOLATION LEVEL REPEATABLE READ
2025-12-01 02:17:43 EET [3348788]: [1201766-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3348788]: [1201767-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.007 ms execute 0: BEGIN ISOLATION LEVEL REPEATABLE READ
2025-12-01 02:17:43 EET [3348788]: [1201768-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3348788]: [1201769-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.018 ms bind 1: SELECT * FROM block WHERE slot_no IS NOT NULL ORDER BY slot_no DESC LIMIT 1
2025-12-01 02:17:43 EET [3348788]: [1201770-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3348788]: [1201771-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.017 ms execute 1: SELECT * FROM block WHERE slot_no IS NOT NULL ORDER BY slot_no DESC LIMIT 1
2025-12-01 02:17:43 EET [3348788]: [1201772-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3348788]: [1201773-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.003 ms bind 2: COMMIT
2025-12-01 02:17:43 EET [3348788]: [1201774-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3348788]: [1201775-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.008 ms execute 2: COMMIT
2025-12-01 02:17:43 EET [3348788]: [1201776-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3343011]: [37967351-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.032 ms bind 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967352-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\x83c5aa77e2d32df02ee7f4211f3c9772b5d6f1d7930f3b2a1c10ea03de0cdd37'
2025-12-01 02:17:43 EET [3343011]: [37967353-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_bind_message, postgres.c:2006
2025-12-01 02:17:43 EET [3343011]: [37967354-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.029 ms execute 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967355-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\x83c5aa77e2d32df02ee7f4211f3c9772b5d6f1d7930f3b2a1c10ea03de0cdd37'
2025-12-01 02:17:43 EET [3343011]: [37967356-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOCATION: exec_execute_message, postgres.c:2262
2025-12-01 02:17:43 EET [3343011]: [37967357-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] LOG: 00000: duration: 0.028 ms bind 6: SELECT id FROM block WHERE hash = $1
2025-12-01 02:17:43 EET [3343011]: [37967358-1] user=kostas,db=mainnet-10-6,app=[unknown],client=[local] DETAIL: parameters: $1 = '\x5a764e0458987604f42aabd1d2d387b64a50487dbcb86cc96ad3a64c9f776358'