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

There is an inconsistency between Nacos's local configuration information and the database configuration information, and this inconsistency cannot be automatically resolved. #12231

Closed
Bo-Qiu opened this issue Jun 15, 2024 · 2 comments

Comments

@Bo-Qiu
Copy link
Contributor

Bo-Qiu commented Jun 15, 2024

Describe the bug
When inserting and updating configurations in the database, the gmt_modified field is set using the local timestamp of the Nacos node rather than the database's built-in time function. This can lead to inconsistencies between the server node data and the database data when different Nacos nodes concurrently modify the same configuration, and this inconsistency cannot be automatically resolved.

Expected behavior
When inserting and updating configurations in the database, the time-related field values need to be set using the time obtained from the database's built-in time function.

Actually behavior
When inserting and updating configurations in the database, the gmt_modified field is set using the local timestamp of the Nacos node rather than the database's built-in time function.

Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 15, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
@KomachiSion KomachiSion added area/Config area/Client Related to Nacos Client SDK and removed area/Client Related to Nacos Client SDK labels Jun 17, 2024
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
Bo-Qiu added a commit to Bo-Qiu/nacos that referenced this issue Jun 18, 2024
… database, the time-related field values need to be set using the time obtained from the database's built-in time function.
shiyiyue1102 pushed a commit that referenced this issue Jul 9, 2024
…se, the time-related field values need to be set using the time obtained from the database's built-in time function. (#12244)
@Bo-Qiu Bo-Qiu closed this as completed Jul 9, 2024
lowezheng added a commit to lowezheng/nacos that referenced this issue Jul 24, 2024
…apexsoft

* commit '197795a854992d3f88824e4cdde34c61d8f56cf4': (225 commits)
  Fix alibaba#12395, use request context replace session depend. (alibaba#12398)
  Revert "Add an id primary key column to both the roles and permissions tables.(mysql-schema.sql) (alibaba#12206)" (alibaba#12396)
  Upgrade to 2.4.0 (alibaba#12384)
  Develop support ram info switch (alibaba#12382)
  Close derby ops api default. (alibaba#12372)
  Upgrade grpc to 1.64.2 (alibaba#12369)
  fix(alibaba#12333): fixed auth Plugin resource parser can't parser v2 config openAPI namespaceId. (alibaba#12336)
  Adjust integration tests for common modules in the core module to comply with checkstyle. (alibaba#12349)
  [IT]Adjust integration tests for cluster,code,smoke modules in the core module to comply with checkstyle. (alibaba#12350)
  fix [ISSUE alibaba#12323] , using the project's logback packagingData configuration instead of logback-nacos.xml's packagingData configuration (alibaba#12360)
  Remove the accessToken from the URL. (alibaba#12353)
  feat(alibaba#12355): Record the cost of ConfigDump in Prometheus. (alibaba#12356)
  [IT]Adjust core module auth integration tests to meet checkstyle requirements. (alibaba#12368)
  [ISSUE alibaba#12282]Fix the issue where monitoring data cannot be found through the IP dimension in the ListeningQuery (alibaba#12315)
  Adjust integration tests for ability, base, and client modules in the core module to comply with checkstyle. (alibaba#12335)
  Develop refactor request context (alibaba#12331)
  fix unexpect exception from NetworkInterface.ifUp (alibaba#12325)
  fix(alibaba#12231): When inserting and updating configurations in the database, the time-related field values need to be set using the time obtained from the database's built-in time function. (alibaba#12244)
  add some UT for default auth plugin (alibaba#12318)
  [ISSUE alibaba#12219] 修复nacos-client中config的ServerListManager解析endpoint失败问题 (alibaba#12220)
  ...

# Conflicts:
#	plugin-default-impl/nacos-default-auth-plugin/src/main/java/com/alibaba/nacos/plugin/auth/impl/persistence/ExternalPermissionPersistServiceImpl.java
#	pom.xml
@caoyanan666
Copy link
Contributor

caoyanan666 commented Jul 26, 2024

这个会让pg报错,
image

@caoyanan666
Copy link
Contributor

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

No branches or pull requests

3 participants