img/postgresql-reliable-outbox-with-lock.svg

<?xml version="1.0" encoding="us-ascii" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentStyleType="text/css" height="1100.4091px" preserveAspectRatio="none" style="width:903px;height:1100px;background:#FFFFFF;" version="1.1" viewBox="0 0 903 1100" width="903.2354px" zoomAndPan="magnify"><defs/><g><rect fill="#FFFFFF" height="698.577" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="50.3161" y="81.834"/><rect fill="#FFFFFF" height="246.6397" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="159.1298" y="153.3388"/><rect fill="#FFFFFF" height="210.8073" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="686.8353" y="633.6365"/><rect fill="#FFFFFF" height="598.2196" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="798.5125" y="423.8135"/><line style="stroke:#808080;stroke-width:0.4090740052063964;stroke-dasharray:5.0,5.0;" x1="53.9978" x2="53.9978" y1="56.3627" y2="1036.7597"/><line style="stroke:#808080;stroke-width:0.4090740052063964;stroke-dasharray:5.0,5.0;" x1="162.8115" x2="162.8115" y1="56.3627" y2="1036.7597"/><line style="stroke:#808080;stroke-width:0.4090740052063964;stroke-dasharray:5.0,5.0;" x1="402.5288" x2="402.5288" y1="56.3627" y2="1036.7597"/><line style="stroke:#808080;stroke-width:0.4090740052063964;stroke-dasharray:5.0,5.0;" x1="690.5169" x2="690.5169" y1="56.3627" y2="1036.7597"/><line style="stroke:#808080;stroke-width:0.4090740052063964;stroke-dasharray:5.0,5.0;" x1="802.6032" x2="802.6032" y1="56.3627" y2="1036.7597"/><rect fill="#E2E2F0" height="38.1206" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="4.0907" y="17.424"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="80.9967" x="13.9085" y="33.783">Append event</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="9.8178" y="47.1162">Transaction #1</text><rect fill="#E2E2F0" height="38.1206" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="4.0907" y="1035.9416"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="80.9967" x="13.9085" y="1052.3005">Append event</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="9.8178" y="1065.6338">Transaction #1</text><rect fill="#E2E2F0" height="38.1206" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="112.9044" y="17.424"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="80.9967" x="122.7222" y="33.783">Append event</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="118.6315" y="47.1162">Transaction #2</text><rect fill="#E2E2F0" height="38.1206" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="112.9044" y="1035.9416"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="80.9967" x="122.7222" y="1052.3005">Append event</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="118.6315" y="1065.6338">Transaction #2</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="66.27" x="367.3485" y="53.6614">PostgreSQL</text><path d="M388.2112,13.5761 C388.2112,5.3947 402.9379,5.3947 402.9379,5.3947 C402.9379,5.3947 417.6646,5.3947 417.6646,13.5761 L417.6646,34.848 C417.6646,43.0295 402.9379,43.0295 402.9379,43.0295 C402.9379,43.0295 388.2112,43.0295 388.2112,34.848 L388.2112,13.5761 " fill="#E2E2F0" style="stroke:#181818;stroke-width:1.2272220156191893;"/><path d="M388.2112,13.5761 C388.2112,21.7576 402.9379,21.7576 402.9379,21.7576 C402.9379,21.7576 417.6646,21.7576 417.6646,13.5761 " fill="none" style="stroke:#181818;stroke-width:1.2272220156191893;"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="66.27" x="367.3485" y="1046.5735">PostgreSQL</text><path d="M388.2112,1057.4563 C388.2112,1049.2748 402.9379,1049.2748 402.9379,1049.2748 C402.9379,1049.2748 417.6646,1049.2748 417.6646,1057.4563 L417.6646,1078.7282 C417.6646,1086.9096 402.9379,1086.9096 402.9379,1086.9096 C402.9379,1086.9096 388.2112,1086.9096 388.2112,1078.7282 L388.2112,1057.4563 " fill="#E2E2F0" style="stroke:#181818;stroke-width:1.2272220156191893;"/><path d="M388.2112,1057.4563 C388.2112,1065.6378 402.9379,1065.6378 402.9379,1065.6378 C402.9379,1065.6378 417.6646,1065.6378 417.6646,1057.4563 " fill="none" style="stroke:#181818;stroke-width:1.2272220156191893;"/><rect fill="#E2E2F0" height="51.4538" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="640.6099" y="4.0907"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="59.7248" x="661.0636" y="20.4497">Lock table</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="53.9978" x="663.9271" y="33.783">for writes</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="646.3369" y="47.1162">Transaction #4</text><rect fill="#E2E2F0" height="51.4538" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="100.6322" x="640.6099" y="1035.9416"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="59.7248" x="661.0636" y="1052.3005">Lock table</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="53.9978" x="663.9271" y="1065.6338">for writes</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="646.3369" y="1078.967">Transaction #4</text><rect fill="#E2E2F0" height="51.4538" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="106.3592" x="749.4236" y="4.0907"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="71.997" x="766.6047" y="20.4497">Read events</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="94.9052" x="755.1506" y="33.783">after checkpoint</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="758.0141" y="47.1162">Transaction #3</text><rect fill="#E2E2F0" height="51.4538" rx="2.0454" ry="2.0454" style="stroke:#181818;stroke-width:0.4090740052063964;" width="106.3592" x="749.4236" y="1035.9416"/><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="71.997" x="766.6047" y="1052.3005">Read events</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="94.9052" x="755.1506" y="1065.6338">after checkpoint</text><text fill="#000000" font-family="sans-serif" font-size="11.4541" lengthAdjust="spacing" textLength="89.1781" x="758.0141" y="1078.967">Transaction #3</text><rect fill="#FFFFFF" height="698.577" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="50.3161" y="81.834"/><rect fill="#FFFFFF" height="246.6397" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="159.1298" y="153.3388"/><rect fill="#FFFFFF" height="210.8073" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="686.8353" y="633.6365"/><rect fill="#FFFFFF" height="598.2196" style="stroke:#808080;stroke-width:0.8181480104127928;" width="8.1815" x="798.5125" y="423.8135"/><polygon fill="#181818" points="393.1201,78.5614,401.3016,81.834,393.1201,85.1066,396.3927,81.834" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="58.4976" x2="398.029" y1="81.834" y2="81.834"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="111.2681" x="64.2246" y="77.6893">BEGIN&#160;TRANSACTION</text><polygon fill="#181818" points="393.1201,102.3963,401.3016,105.6689,393.1201,108.9415,396.3927,105.6689" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="58.4976" x2="398.029" y1="105.6689" y2="105.6689"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="215.9911" x="64.2246" y="101.5243">SELECT&#160;nextval('ES_EVENT_ID_SEQ')</text><polygon fill="#181818" points="67.4972,126.2313,59.3157,129.5039,67.4972,132.7765,64.2246,129.5039" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="62.5883" x2="402.1197" y1="129.5039" y2="129.5039"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" font-style="italic" lengthAdjust="spacing" textLength="68.7244" x="72.4061" y="125.3592">nextval=101</text><polygon fill="#181818" points="393.1201,150.0662,401.3016,153.3388,393.1201,156.6114,396.3927,153.3388" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="167.3113" x2="398.029" y1="153.3388" y2="153.3388"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="111.2681" x="173.0383" y="149.1942">BEGIN&#160;TRANSACTION</text><path d="M97.3596,163.9748 L97.3596,196.7007 L229.0814,196.7007 L229.0814,172.1562 L220.9,163.9748 L97.3596,163.9748 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M220.9,163.9748 L220.9,172.1562 L229.0814,172.1562 L220.9,163.9748 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="114.5407" x="102.2685" y="177.938">Transaction #2 starts</text><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="107.1774" x="102.2685" y="190.3189">after transaction #1</text><polygon fill="#181818" points="393.1201,215.0259,401.3016,218.2985,393.1201,221.5711,396.3927,218.2985" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="167.3113" x2="398.029" y1="218.2985" y2="218.2985"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="215.9911" x="173.0383" y="214.1538">SELECT&#160;nextval('ES_EVENT_ID_SEQ')</text><polygon fill="#181818" points="176.3109,238.8609,168.1294,242.1335,176.3109,245.4061,173.0383,242.1335" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="171.402" x2="402.1197" y1="242.1335" y2="242.1335"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" font-style="italic" lengthAdjust="spacing" textLength="68.7244" x="181.2198" y="237.9888">nextval=102</text><polygon fill="#181818" points="393.1201,295.5304,401.3016,298.803,393.1201,302.0756,396.3927,298.803" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="58.4976" x2="398.029" y1="298.803" y2="298.803"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="157.0844" x="64.2246" y="282.2774">INSERT&#160;INTO&#160;ES_EVENT(ID)</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="71.997" x="64.2246" y="294.6583">VALUES(101)</text><polygon fill="#181818" points="393.1201,331.7462,401.3016,335.0188,393.1201,338.2914,396.3927,335.0188" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="167.3113" x2="398.029" y1="335.0188" y2="335.0188"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="157.0844" x="173.0383" y="318.4933">INSERT&#160;INTO&#160;ES_EVENT(ID)</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="71.997" x="173.0383" y="330.8742">VALUES(102)</text><path d="M89.1781,345.6548 L89.1781,378.3807 L237.2629,378.3807 L237.2629,353.8362 L229.0814,345.6548 L89.1781,345.6548 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M229.0814,345.6548 L229.0814,353.8362 L237.2629,353.8362 L229.0814,345.6548 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="130.9037" x="94.087" y="359.618">Transaction #2 commits</text><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="116.177" x="94.087" y="371.9989">before transaction #1</text><polygon fill="#181818" points="393.1201,396.7059,401.3016,399.9785,393.1201,403.2511,396.3927,399.9785" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="163.2205" x2="398.029" y1="399.9785" y2="399.9785"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="39.2711" x="168.9476" y="395.8338">COMMIT</text><polygon fill="#181818" points="411.9375,420.5409,403.756,423.8135,411.9375,427.086,408.6649,423.8135" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="797.6943" y1="423.8135" y2="423.8135"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="111.2681" x="416.8464" y="419.6688">BEGIN&#160;TRANSACTION</text><polygon fill="#181818" points="411.9375,469.1376,403.756,472.4102,411.9375,475.6828,408.6649,472.4102" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="797.6943" y1="472.4102" y2="472.4102"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="130.9037" x="416.8464" y="443.5037">SELECT&#160;LAST_EVENT_ID</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="71.997" x="416.8464" y="455.8846">AS&#160;START_ID</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="170.1748" x="416.8464" y="468.2655">FROM&#160;ES_EVENT_SUBSCRIPTION</text><polygon fill="#181818" points="788.6947,492.9725,796.8762,496.2451,788.6947,499.5177,791.9673,496.2451" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="402.9379" x2="793.6036" y1="496.2451" y2="496.2451"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" font-style="italic" lengthAdjust="spacing" textLength="80.1785" x="408.6649" y="492.1004">START_ID=100</text><polygon fill="#181818" points="411.9375,541.5692,403.756,544.8418,411.9375,548.1144,408.6649,544.8418" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="797.6943" y1="544.8418" y2="544.8418"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="39.2711" x="416.8464" y="515.9354">SELECT</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="268.3525" x="416.8464" y="528.3163">pg_sequence_last_value('ES_EVENT_ID_SEQ')</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="58.9067" x="416.8464" y="540.6972">AS&#160;END_ID</text><polygon fill="#181818" points="788.6947,565.4042,796.8762,568.6768,788.6947,571.9494,791.9673,568.6768" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="402.9379" x2="793.6036" y1="568.6768" y2="568.6768"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" font-style="italic" lengthAdjust="spacing" textLength="68.7244" x="408.6649" y="564.5321">END_ID=102</text><path d="M618.5199,579.3127 L618.5199,612.0386 L762.5139,612.0386 L762.5139,587.4942 L754.3325,579.3127 L618.5199,579.3127 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M754.3325,579.3127 L754.3325,587.4942 L762.5139,587.4942 L754.3325,579.3127 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="62.1792" x="623.4288" y="593.276">Very briefly</text><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="126.8129" x="623.4288" y="605.6568">lock the table for writes</text><polygon fill="#181818" points="411.9375,630.3639,403.756,633.6365,411.9375,636.9091,408.6649,633.6365" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="686.0171" y1="633.6365" y2="633.6365"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="268.3525" x="416.8464" y="629.4918">LOCK&#160;ES_EVENT&#160;IN&#160;SHARE&#160;ROW&#160;EXCLUSIVE&#160;MODE</text><path d="M600.5206,685.1798 L600.5206,717.9057 L781.3313,717.9057 L781.3313,693.3613 L773.1499,685.1798 L600.5206,685.1798 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M773.1499,685.1798 L773.1499,693.3613 L781.3313,693.3613 L773.1499,685.1798 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="140.7215" x="605.4295" y="699.143">Waiting for pending writes</text><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="163.6296" x="605.4295" y="711.5239">to complete (transaction #1)...</text><polygon fill="#181818" points="393.1201,777.1383,401.3016,780.4109,393.1201,783.6835,396.3927,780.4109" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="54.4068" x2="398.029" y1="780.4109" y2="780.4109"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="39.2711" x="60.1339" y="776.2663">COMMIT</text><polygon fill="#181818" points="677.0175,788.5924,685.199,791.865,677.0175,795.1376,680.2901,791.865" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="402.9379" x2="681.9264" y1="791.865" y2="791.865"/><path d="M610.3384,802.5009 L610.3384,822.9546 L771.5136,822.9546 L771.5136,810.6824 L763.3321,802.5009 L610.3384,802.5009 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M763.3321,802.5009 L763.3321,810.6824 L771.5136,810.6824 L763.3321,802.5009 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="143.994" x="615.2473" y="816.4642">Table-level lock acquired...</text><polygon fill="#181818" points="411.9375,841.1712,403.756,844.4438,411.9375,847.7164,408.6649,844.4438" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="690.1078" y1="844.4438" y2="844.4438"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="39.2711" x="416.8464" y="840.2991">COMMIT</text><path d="M607.0658,855.0797 L607.0658,875.5334 L773.968,875.5334 L773.968,863.2612 L765.7865,855.0797 L607.0658,855.0797 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M765.7865,855.0797 L765.7865,863.2612 L773.968,863.2612 L765.7865,855.0797 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="149.7211" x="611.9747" y="869.043">...and immediately released</text><polygon fill="#181818" points="411.9375,906.1309,403.756,909.4035,411.9375,912.6761,408.6649,909.4035" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="797.6943" y1="909.4035" y2="909.4035"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="150.5392" x="416.8464" y="892.8779">SELECT&#160;ID&#160;FROM&#160;ES_EVENT</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="183.2652" x="416.8464" y="905.2588">WHERE&#160;ID&#160;&gt;&#160;100&#160;AND&#160;ID&#160;&lt;=&#160;102</text><polygon fill="#181818" points="788.6947,929.9658,796.8762,933.2384,788.6947,936.511,791.9673,933.2384" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="402.9379" x2="793.6036" y1="933.2384" y2="933.2384"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" font-style="italic" lengthAdjust="spacing" textLength="86.7237" x="408.6649" y="929.0938">ID=101, ID=102</text><path d="M706.8799,943.8743 L706.8799,964.328 L897.5084,964.328 L897.5084,952.0558 L889.3269,943.8743 L706.8799,943.8743 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><path d="M889.3269,943.8743 L889.3269,952.0558 L897.5084,952.0558 L889.3269,943.8743 " fill="#FEFFDD" style="stroke:#181818;stroke-width:0.4090740052063964;"/><text fill="#000000" font-family="sans-serif" font-size="10.6359" lengthAdjust="spacing" textLength="173.4474" x="711.7888" y="957.8376">Process events: ID=101, ID=102</text><polygon fill="#181818" points="411.9375,994.9255,403.756,998.1981,411.9375,1001.4707,408.6649,998.1981" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="797.6943" y1="998.1981" y2="998.1981"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="183.2652" x="416.8464" y="981.6725">UPDATE&#160;ES_EVENT_SUBSCRIPTION</text><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="150.5392" x="416.8464" y="994.0534">SET&#160;LAST_EVENT_ID&#160;=&#160;102</text><polygon fill="#181818" points="411.9375,1018.7605,403.756,1022.0331,411.9375,1025.3056,408.6649,1022.0331" style="stroke:#181818;stroke-width:0.8181480104127928;"/><line style="stroke:#181818;stroke-width:0.8181480104127928;stroke-dasharray:2.0,2.0;" x1="407.0286" x2="801.7851" y1="1022.0331" y2="1022.0331"/><text fill="#000000" font-family="monospace" font-size="10.6359" lengthAdjust="spacing" textLength="39.2711" x="416.8464" y="1017.8884">COMMIT</text><!--SRC=[bLLHRw9047xdLqouX_QIQnNboLoRKDrhoI5QG7iF9cQ5KJSYM5XjpVN- - -qYQfTwZVTWWknyttpppUoGXpH6MD9NCEeD4rvOnETQVdnfrEimHpQRSqtB5onPqOmk8SVdDIOXmcyDm65JT5Y2TsaMOTPEupI3-motsiMxCnekPbcwJgBTkICPYw0_cYOuEGlPYYOST6krmYG2t632HqcGqIId8MTf0byC7MWE_DKu6z4e4GqjefnEQ8wWzzESppBq7vtYC9geR4uQBa34nZXAfaBfIyOuvXLUi-GrLQo7jDGX07JACODmZk5YbR8FqfebHLFJH4LmTNKhfBH0r-_8lUr2u5ckRxK3k-VgkYP16ygnA5uDzub3sW4a-CetDBwy8FwO38aRZEtEs2UF5ry5F9eK005iGQrMXjuOTQDM4soDyvCtj2GL3-b6L2R-jK1r6t8kx3ZKpfNcLJBzb-w6ghiXTB-zlLMSi5sVU07ORj23FTkbtH54eqJNXvOp8FwbA5eogrhEH3OaydC3mdIvPDA12OhXmSyjQFUwNJkGTQBYiHYAyrlIh8INlZgM7nmCtTLX-U07bdTyySFhTG_rZlt1dT_sx7wPuk1zKtg_1mhpwyNGV4ovurpDnllbC8vfpiUYOsiysTvI4t4xXQ9AnjthijdlJJTRCCHi2vECuJJUZfAukB5ptDrQE5vQ8TDy9zFfjNyUoXND1l_1yWXulISWlzhEmBU71Bgz3b4DDejHax-AYYVAE4jcHKAvWUJpVblmL8x2AaQ1k5I7uElrzVM1KftWqmDX79qngne2MV9LB7PE38KFD7nUimmZcKGj_q1UeH2HLAnFjbnYn4J6U0iPnYXsPQJgC4zFcjq1PP1sZNrw8C9RSNOByXDYkHtvv_kD_Cnyw7NHP-CRdEotYEXdQOXvNgxM5gZn5Lc3ViSAoB_cMchpIUL-m5wModIw7KtjBm00]--></g></svg>