March 2023 - StorageEngine - mailweb.opengauss.org

写偏序问题（write skew）
by qinhao＠newland.com.cn 25 Mar '23

25 Mar '23

最近尝试用PostgreSQL写偏序例子，测试opengauss的serializable隔离级别，结果两个事务都成功提交了，opengauss如何解决写偏序问题呢？ create table dots ( id int not null primary key, color text not null ); insert into dots with x(id) as (select generate_series(1,10)) select id, case when id % 2 = 1 then 'black' else 'white' end from x; 事务1 ：事务2 start transaction isolation level serializable; start transaction isolation level serializable; update dots set color = 'black' where color = 'white'; update dots set color = 'white' where color = 'black'; commit; commit; 如果是PostgreSQL其中有一个事务会失败的，但是opengauss都成功了！ openGauss=# select * from dots; id | color ----+------- 4 | black 6 | black 8 | black 10 | black 2 | black 3 | white 5 | white 7 | white 9 | white 1 | white 参考：https://wiki.postgresql.org/wiki/SSI#Black_and_White 新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

2 1

Storage SIG
by openGauss conference 21 Mar '23

21 Mar '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-03-24 14:30 召开的zoom会议会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/83002460766?pwd=eTIyTEdaR2NaM3pGdHRXbzcvdGFXQT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/StorageEngine-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss StorageEngine SIG invites you to attend the zoom conference will be held at 2023-03-24 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/83002460766?pwd=eTIyTEdaR2NaM3pGdHRXbzcvdGFXQT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/StorageEngine-meetings More information: https://opengauss.org/en/

1 0

Storage SIG
by openGauss conference 17 Mar '23

17 Mar '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-03-21 14:30 召开的zoom会议(自动录制) 会议主题：Storage SIG 会议内容：存储SIG组例会补充开一次会议链接：https://us06web.zoom.us/j/82697345845?pwd=Qmc2eUFrdFFDWGdoRE5pRGlFbFBkUT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/StorageEngine-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss StorageEngine SIG invites you to attend the zoom conference(auto recording) will be held at 2023-03-21 14:30, The subject of the conference is Storage SIG, Summary: 存储SIG组例会补充开一次 You can join the meeting at https://us06web.zoom.us/j/82697345845?pwd=Qmc2eUFrdFFDWGdoRE5pRGlFbFBkUT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/StorageEngine-meetings More information: https://opengauss.org/en/

1 0

Storage SIG
by openGauss conference 10 Mar '23

10 Mar '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-03-17 14:30 召开的Zoom会议(自动录制) 会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/81135959452?pwd=RTNpUmJLS1IyUU9HNUZIZ0xuNWVHdz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/StorageEngine-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss StorageEngine SIG invites you to attend the Zoom conference(auto recording) will be held at 2023-03-17 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/81135959452?pwd=RTNpUmJLS1IyUU9HNUZIZ0xuNWVHdz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/StorageEngine-meetings More information: https://opengauss.org/en/

1 0

Storage SIG
by openGauss conference 10 Mar '23

10 Mar '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-03-17 14:30 召开的Zoom会议(自动录制) 会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/86416504643?pwd=a3ZqR3JIc0YyVGcxenIrdFE3N2JGUT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/StorageEngine-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss StorageEngine SIG invites you to attend the Zoom conference(auto recording) will be held at 2023-03-17 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/86416504643?pwd=a3ZqR3JIc0YyVGcxenIrdFE3N2JGUT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/StorageEngine-meetings More information: https://opengauss.org/en/

1 0

【check-in】添加发布订阅的开发自测项
by chenxiaobin (F) 10 Mar '23

10 Mar '23

各位openGauss开发者，大家好：目前openGauss-server仓合入了发布订阅的测试套件和用例，发布订阅是openGauss实现集群间数据实时同步的一个关键特性，由于该特性的测试需要部署多个集群，因此有独立的测试目录。相应的更新了check-in文档模板，新增该开发自测项，后续check-in评审时需要补充这部分内容。在src\test\subscription目录下运行make check p={port} dbcompatibility={dbcompatibility}即可，成功打印如下：注：Plugin仓的需求运行check时需要指定B兼容性数据库，即dbcompatibility=B. [输入图片说明] 如何运行：https://opengauss.org/zh/blogs/xiteming/HowtorunFastcheck.html SQL兼容性需求check-in模板：https://gitee.com/opengauss/community/blob/master/check-… 社区需求check-in模板：https://gitee.com/opengauss/community/blob/master/check-in/t…

1 0

2023.3.14 TC会议
by openGauss conference 08 Mar '23

08 Mar '23

您好！ openGauss TC SIG 邀请您参加 2023-03-14 09:30 召开的Zoom会议(自动录制) 会议主题：2023.3.14 TC会议会议内容：请大家积极申报议题，谢谢会议链接：https://us06web.zoom.us/j/84749039722?pwd=aFhIbWt5M2M0WDkwblkzL0srQ1N1UT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2023-03-14 09:30, The subject of the conference is 2023.3.14 TC会议, Summary: 请大家积极申报议题，谢谢 You can join the meeting at https://us06web.zoom.us/j/84749039722?pwd=aFhIbWt5M2M0WDkwblkzL0srQ1N1UT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0

Storage SIG
by openGauss conference 06 Mar '23

06 Mar '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-03-07 14:30 召开的Zoom会议(自动录制) 会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/88670822301?pwd=cm92bHdDa3FHVWN0bStRT0VYYXJidz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/StorageEngine-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss StorageEngine SIG invites you to attend the Zoom conference(auto recording) will be held at 2023-03-07 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/88670822301?pwd=cm92bHdDa3FHVWN0bStRT0VYYXJidz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/StorageEngine-meetings More information: https://opengauss.org/en/

1 0

2024

2023

2022

2021

2020

StorageEngine March 2023