v3 Time Id Command Argument 100625 11:28:17 2019 Query SELECT @@session.tx_isolation 2019 Query SET autocommit=0 2019 Query select address0_.addressId as addressId0_0_, address0_.versionNum as versionNum0_0_, address0_.flatNumberName as flatNumb3_0_0_, address0_.houseNumberName as houseNum4_0_0_, address0_.address1 as address5_0_0_, address0_.address2 as address6_0_0_, address0_.postcode as postcode0_0_, address0_.startDate as startDate0_0_, address0_.endDate as endDate0_0_, address0_.address3 as address10_0_0_, address0_.address4 as address11_0_0_, address0_.address5 as address12_0_0_, address0_.upduser as upduser0_0_, address0_.upddate as upddate0_0_, address0_.creuser as creuser0_0_, address0_.credate as credate0_0_, address0_.deluser as deluser0_0_, address0_.deldate as deldate0_0_, address0_.noOfYearsAtAddress as noOfYea19_0_0_, address0_.propertyTypeOther as propert20_0_0_, address0_.propertyOwnershipType as propert21_0_0_, address0_.noOfMonthsAtAddress as noOfMon22_0_0_ from ADDRESS address0_ where address0_.addressId=1 2019 Query update ADDRESS set versionNum=2, flatNumberName=null, houseNumberName=null, address1='test1', address2='Blenhiem Place', postcode='SS9 3HG', startDate=null, endDate=null, address3='Leigh on Sea', address4='Essex', address5='UK', upduser=null, upddate=null, creuser='riderj', credate='2005-08-29 05:21:31', deluser=null, deldate=null, noOfYearsAtAddress=null, propertyTypeOther=null, propertyOwnershipType=null, noOfMonthsAtAddress=null where addressId=1 and versionNum=1 2021 Connect root@192.168.1.203 on production 2021 Query SET autocommit=1 2021 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 2021 Query SELECT @@session.tx_isolation 2021 Query update ADDRESS set versionNum=3, flatNumberName=null, houseNumberName=null, address1='test1', address2='test2', postcode='SS9 3HG', startDate=null, endDate=null, address3='Leigh on Sea', address4='Essex', address5='UK', upduser=null, upddate=null, creuser='riderj', credate='2005-08-29 05:21:31', deluser=null, deldate=null, noOfYearsAtAddress=null, propertyTypeOther=null, propertyOwnershipType=null, noOfMonthsAtAddress=null where addressId=1 and versionNum=2 2019 Query rollback 2019 Query SET autocommit=1 from v2.1 Time Id Command Argument 100625 11:34:57 2024 Query SELECT @@session.tx_isolation 2024 Query SET autocommit=0 2024 Query select address0_.addressId as addressId0_0_, address0_.versionNum as versionNum0_0_, address0_.flatNumberName as flatNumb3_0_0_, address0_.houseNumberName as houseNum4_0_0_, address0_.address1 as address5_0_0_, address0_.address2 as address6_0_0_, address0_.postcode as postcode0_0_, address0_.startDate as startDate0_0_, address0_.endDate as endDate0_0_, address0_.address3 as address10_0_0_, address0_.address4 as address11_0_0_, address0_.address5 as address12_0_0_, address0_.upduser as upduser0_0_, address0_.upddate as upddate0_0_, address0_.creuser as creuser0_0_, address0_.credate as credate0_0_, address0_.deluser as deluser0_0_, address0_.deldate as deldate0_0_, address0_.noOfYearsAtAddress as noOfYea19_0_0_, address0_.propertyTypeOther as propert20_0_0_, address0_.propertyOwnershipType as propert21_0_0_, address0_.noOfMonthsAtAddress as noOfMon22_0_0_ from ADDRESS address0_ where address0_.addressId=1 2024 Query update ADDRESS set versionNum=2, flatNumberName=null, houseNumberName=null, address1='test1', address2='Blenhiem Place', postcode='SS9 3HG', startDate=null, endDate=null, address3='Leigh on Sea', address4='Essex', address5='UK', upduser=null, upddate=null, creuser='riderj', credate='2005-08-29 05:21:31', deluser=null, deldate=null, noOfYearsAtAddress=null, propertyTypeOther=null, propertyOwnershipType=null, noOfMonthsAtAddress=null where addressId=1 and versionNum=1 2024 Query update ADDRESS set versionNum=3, flatNumberName=null, houseNumberName=null, address1='test1', address2='test2', postcode='SS9 3HG', startDate=null, endDate=null, address3='Leigh on Sea', address4='Essex', address5='UK', upduser=null, upddate=null, creuser='riderj', credate='2005-08-29 05:21:31', deluser=null, deldate=null, noOfYearsAtAddress=null, propertyTypeOther=null, propertyOwnershipType=null, noOfMonthsAtAddress=null where addressId=1 and versionNum=2 2024 Query commit 2024 Query SET autocommit=1