Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

k8s里部署企业版,cn pod init报错Error when self-registering: Error 1264: Out of range value for column 'mem_size' at row 1 #226

Open
taoyang987 opened this issue Dec 6, 2024 · 5 comments

Comments

@taoyang987
Copy link

Begin initializing...
Loading from environment...
Local IP: 10.233.92.25
Environment loaded: {"instance_id":"polardbx","instance_type":"0","primary_instance_id":"polardbx","pod_id":"polardbx-tpgd-cn-default-6cdcf4cb5c-xvh2d","local_ip":"10.233.92.25","server_port":3306,"htap_port":3606,"mgr_port":3406,"mpp_port":3506,"cpu_core":1,"mem_size":2147483648,"metadb_host":"polardbx-tpgd-gms","metadb_port":3306,"metadb_user":"admin","metadb_enc_passwd":"xtdtDw67gnv+owhjFsAsVw==","enc_key":"t62p9fgdjl6v6hbc"}
Connecting to metadb...
Connected to metadb!
try clean dirty server info record sql = DELETE FROM server_info where extras = 'polardbx-tpgd-cn-default-6cdcf4cb5c-xvh2d' and inst_id = 'polardbx' limit 1
Try self-registration, register 10.233.92.25:3306 to metadb...
Error when self-registering: Error 1264: Out of range value for column 'mem_size' at row 1

@taoyang987
Copy link
Author

taoyang987 commented Dec 6, 2024

apiVersion: polardbx.aliyun.com/v1
kind: PolarDBXCluster
metadata:
name: polardbx
namespace: polardbx-operator-system
spec:
serviceName: mysql
privileges:

  • username: admin
    password: "123456"
    type: SUPER
    config:
    dn:
    mycnfOverwrite: |-
    sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    group_concat_max_len=10240000
    lower_case_table_names=1
    default_time_zone= +08:00
    topology:
    nodes:
    gms:
    template:
    image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-engine:v2.4.1_8.4.19
    resources:
    requests:
    cpu: 100m
    memory: 500Mi
    limits:
    cpu: 1
    memory: 1Gi
    cn:
    replicas: 1
    template:
    image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-sql:v2.4.1_5.4.19
    resources:
    requests:
    cpu: 100m
    memory: 1Gi
    limits:
    cpu: 1
    memory: 2Gi
    dn:
    replicas: 1
    template:
    image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-engine:v2.4.1_8.4.19
    resources:
    requests:
    cpu: 100m
    memory: 500Mi
    limits:
    cpu: 1
    memory: 1Gi
    cdc:
    replicas: 1
    template:
    image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-cdc:v2.4.1_5.4.19
    resources:
    requests:
    cpu: 100m
    memory: 500Mi
    limits:
    cpu: 1
    memory: 1Gi

@taoyang987
Copy link
Author

image

@taoyang987
Copy link
Author

image
yaml中我把这一段删除就可以正常部署了.
那么问题来了,我应该在哪里配置呢?

@taoyang987
Copy link
Author

image
配置要使用冒号而不是等号,
标准版里是使用等号

@taoyang987
Copy link
Author

image
怀疑是不是sql_mode参数不能用,我只改成一个值,也不能传,把sql_mode注释掉,就能启动运行成功
在dn节点,/data/mysql/conf/my.cnf,配置是传过去了.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant