- StorageEngine - mailweb.opengauss.org

DDL两阶段锁代码
by qinhao＠newland.com.cn 24 May '23

24 May '23

各位好，最近在看opengauss代码，有个关于两阶段锁的疑问，DDL应该是遵守两阶段锁的，我的理解应该用的是spinlock，lwlock，regularlock中的regularlock，我调试了一个例子：create table t1 (a int) 按照我的理解：代码中应该先调用LockAcquire，并且LockAcquire之间没有LockRelease调用。但是实际上，LockAcquire之间有LockRelease，LockRelease后又有LockAcquire调用。这样是不是不符合两阶段锁协议？还是我的理解有问题。另外还有一个问题，PG在DDL时，也多次调用LWLockAcquire和LWLockRelease，也并没有遵守两阶段协议，代码中访问共享的数据结构时（如获取事务id），LWLockAcquire后，读写完就LWLockRelease了，也并不遵守两阶段协议，而我的理解，应该是DDL事务中，读写所有对象的加锁（例如对锁表的增删操作本身也需要锁吧），都应该遵守2PL，才能保证DDL的一致性。还是我的理解有问题，只要对核心对象的访问遵守2PL，其它对象只要保证单个对象访问的原子性就可以了？这个地方我有点迷惑新大陆软件秦浩 mobile: 17625988619 e-mail:qinhao@newland.com.cn

1 0

【邀请函】诚邀您参加 StorageEngine SIG 版本规划工作会议
by opengauss 24 May '23

24 May '23

尊敬的openGauss社区开发者，大家好 openGauss Developer Day 2023将在5月26日在北京昆泰嘉瑞文化中心召开。届时，StorageEngine SIG将线下组织SIG版本规划工作会议，集中讨论用户需求、未来技术发展、工作任务分工等，在此诚邀您的参与。如想增加会议议题，请在此填写： https://etherpad.opengauss.org/p/StorageEngine-meetings SIG组版本规划工作会议@openGauss Developer Day2023 时间：2023年5月26日 16:00-17:30 地址：北京·昆泰嘉瑞文化中心参会请务必提前报名注册（https://e-campaign.huawei.com/m/6vaqiy），以便为您制作入场胸牌。现场闭门会议、各大技术论坛、SIG组会议、开发者派对、大会展区都需凭注册信息入场参与。温馨提醒：北京天气早晚温差较大，请注意及时增减衣物，健康工作，愉悦参会。

1 0

Storage SIG
by openGauss conference 05 May '23

05 May '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-05-12 14:30 召开的zoom会议(自动录制) 会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/82870566686?pwd=Y3JZblIyZkp3MVhJSit3MjZxZk9lZz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在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-05-12 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/82870566686?pwd=Y3JZblIyZkp3MVhJSit3MjZxZk9lZz09. 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 27 Apr '23

27 Apr '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-04-28 14:30 召开的zoom会议(自动录制) 会议主题：Storage SIG 会议链接：https://us06web.zoom.us/j/82336268133?pwd=YWt1dlozSlI2QTEwSlM2ZWpTWFJyUT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在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-04-28 14:30, The subject of the conference is Storage SIG, You can join the meeting at https://us06web.zoom.us/j/82336268133?pwd=YWt1dlozSlI2QTEwSlM2ZWpTWFJyUT09. 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

StorageEngine SIG
by openGauss conference 06 Apr '23

06 Apr '23

您好！ openGauss StorageEngine SIG 邀请您参加 2023-04-10 14:30 召开的zoom会议(自动录制) 会议主题：StorageEngine SIG 会议链接：https://us06web.zoom.us/j/89825368723?pwd=M2Jpd1E0ZHY5aEhlM3h6Z1RNNnI1QT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在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-04-10 14:30, The subject of the conference is StorageEngine SIG, You can join the meeting at https://us06web.zoom.us/j/89825368723?pwd=M2Jpd1E0ZHY5aEhlM3h6Z1RNNnI1QT09. 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

写偏序问题（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

2025

2024

2023

2022

2021

2020

StorageEngine