This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.
Welcome To openGauss Community
Hey @liuzhen001 , thanks for your contribution to the community.
Bot Usage Manual
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands. You can self-configure the PR merge rules for this repository. For more details, please refer to Here.
Contact Guide
If you have any questions, please contact the SIG: StorageEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @libiao2024, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zjh_hw .
/assign
20260912自验：
安装转测包
copy mysql_fdw相关的文件至openGauss对应目录
[douxin@openGauss62 B0912]$ find ./ -name "mysql_fdw*"
./lib/postgresql/mysql_fdw.so
./share/postgresql/extension/mysql_fdw--1.0--1.1.sql
./share/postgresql/extension/mysql_fdw--1.0.sql
./share/postgresql/extension/mysql_fdw--1.1.sql
./share/postgresql/extension/mysql_fdw.control
mysql信息：
(host '20.20.20.62', port '3376', user 'wzy1', password 'Huawei@123');
建表：
create database douxin;
use douxin;
CREATE TABLE tab_fdw (
col1 INT,
col2 VARCHAR(20)
);
insert into tab_fdw values(1, 'dx1'), (2, 'dx2');
openGauss B库用新的mysql_fdw.so
设置相关guc
gs_guc generate -S default -D $GAUSSHOME/bin -o usermapping
create extension mysql_fdw;
SELECT version();
SELECT fdwname,
fdwhandler,
fdwhandler::regprocedure,
fdwvalidator::regprocedure
FROM pg_foreign_data_wrapper
WHERE fdwname = 'mysql_fdw';
DROP SERVER IF EXISTS server_fdw_1624 CASCADE;
CREATE SERVER server_fdw_1624 FOREIGN DATA WRAPPER mysql_fdw OPTIONS (host '20.20.20.62', port '3376', user 'wzy1', password 'Huawei@123');
DROP FOREIGN TABLE IF EXISTS tab_fdw_1624;
CREATE FOREIGN TABLE tab_fdw_1624 (
col1 INT,
col2 VARCHAR(20)
)
SERVER server_fdw_1624
OPTIONS (dbname 'douxin', table_name 'tab_fdw');
SELECT * FROM tab_fdw_1624;
回归结论： 回归通过
回归版本：B022
回归记录：
测试类型
工具功能
测试版本
7.0.0LTS
问题描述
操作系统和硬件信息
openGauss：7.0.0 build
29918c91测试环境
企业版主备
被测功能
预置条件
操作步骤
openGauss 链接 jemalloc，并在主程序中导出
malloc/free。启用RTLD_DEEPBIND后，MariaDB Connector/C 内部出现分配器不一致：部分内存通过进程级 jemalloc 分配；
libmariadb 的直接
free调用绑定到 glibc；core 中
MYSQL::db指针位于 openGauss 的 SYSV 内存区域，但最终传给 glibcfree()；glibc 检测到无效指针后执行
abort(), 从而触发invalid pointer和SIGABRT。SQL复制-- 复现 issue #1624
SELECT version();
SELECT fdwname,
fdwhandler,
fdwhandler::regprocedure,
fdwvalidator::regprocedure
FROM pg_foreign_data_wrapper
WHERE fdwname = 'mysql_fdw';
DROP SERVER IF EXISTS server_fdw_1624 CASCADE;
CREATE SERVER server_fdw_1624
FOREIGN DATA WRAPPER mysql_fdw
OPTIONS (host '20.20.20.212', port '3306', user 'ci_mysql', password 'hua@429*Test');
DROP FOREIGN TABLE IF EXISTS tab_fdw_1624;
CREATE FOREIGN TABLE tab_fdw_1624 (
col1 INT,
col2 VARCHAR(20)
)
SERVER server_fdw_1624
OPTIONS (dbname 'ci_db', table_name 'tab_fdw');
SELECT * FROM tab_fdw_1624;
预期输出
实际输出
日志信息
提单组织
测试团队
测试代码