MatrixOne v1.1 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

Troubleshooting

来源 1 浏览 122 扫码 打印 2024-01-26 12:47:11
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • Glossary
  • MatrixOne Documentation
  • Contribution Guide
    • Make Your First Contribution
    • Code Style
      • Code of Conduct
      • Code Comment Style
      • Commit & Pull Request Style
    • How to Contribute
      • Preparation
      • Contribute Documentation
      • Review a Pull Request
      • Make a Design
      • Types of Contributions
      • Contribute Code
      • Report an Issue
  • Deploying
    • MatrixOne distributed cluster deployment
    • Plan MatrixOne Cluster Topology
      • Minimum Production Environment Deployment Plan
      • Experience Environment Deployment Plan
      • Cluster Topology Planning Overview
      • Recommended Production Environment Deployment Plan
    • Maintenance
      • Health check and resource monitoring
      • Starting and stopping
      • Scaling
      • Import data from local Minio to MatrixOne
      • Managing CN Groups with Proxy
      • Operator Management
      • Updating
  • Developing Guide
    • Application Developing Tutorials
      • Python CRUD demo
      • SpringBoot and JPA CRUD demo
      • Golang CRUD demo
      • Gorm CRUD demo
      • Java CRUD demo
      • SQLAlchemy CRUD demo
      • SpringBoot and MyBatis CRUD demo
    • Account Design
      • Multi-Account Overview
      • Publish-Subscribe
    • Connect to MatrixOne
      • Python connect to MatrixOne
      • MatrixOne SSL connection
      • Connecting to MatrixOne with Golang
      • Connecting to MatrixOne with Database Client Tool
      • Java connect to MatrixOne
        • Connect MatrixOne with JDBC
        • Connect MatrixOne with Java ORMs
    • Ecological Tools
      • Computing Engine
        • Writing Batch data to MatrixOne Using Spark
        • Writing Real-Time Data to MatrixOne Using Flink
      • Scheduling Tools
        • Connecting MatrixOne with DolphinScheduler
      • ETL Tools
        • Writing Data to MatrixOne Using DataX
        • Writing Data to MatrixOne Using SeaTunnel
      • BI Tools
        • Visualizing MatrixOne Data with FineBI
        • Visualizing MatrixOne Reports with Yonghong BI
        • Visual Monitoring of MatrixOne with Superset
    • Export Data
      • Export data by MODUMP
      • Export data by SELECT INTO
    • Read Data
      • Common Table Expression
      • Subquery
      • Multi-table Join Queries
      • Window Function.
      • Query Data from a Single Table
      • Views
    • Schema Design
      • Overview
      • Create Temporary Table
      • Create Table
      • Create Secondary Index
      • Create View
      • Create Database
      • Data Integrity
        • FOREIGN KEY Constraints
        • UNIQUE KEY Constraints
        • Data Integrity Constraints Overview
        • NOT NULL Constraints
        • AUTO INCREMENT Constraints
        • PRIMARY KEY Constraints
    • Transactions
      • General Transaction Overview
      • Transaction by MatrixOne Server
        • MVCC
        • Isolation Level
        • Pessimistic Transaction
        • Explicit Transaction
        • Transaction Overview
        • Optimistic Transaction
        • Implicit Transaction
        • How to use transaction
          • User Guide
          • Scenario
    • Write Data
      • Prepared
      • Delete Data
      • Update Data
      • Import Data
        • Insert
        • Bulk Load
          • Load jsonlines format data
          • Load data from S3
          • Bulk Load Overview
          • Load csv format data
          • Load data by using the `source`
  • FAQs
    • Product FAQs
    • SQL FAQs
    • Deployment FAQs
  • Getting Started
    • Basic SQL
    • Deploy standalone MatrixOne
      • Overview
      • Deploy on Linux
        • Building from source code
        • Using binary package
        • Using Docker
      • Deploy on macOS
        • Using Docker
        • Building from source code
        • Using binary package
  • Maintenance
    • Backup and Restore
      • Backup and Recovery Concepts
      • Backup and Restore by using mo-dump
      • MatrixOne Backup and Recovery Overview
    • Mount Data
      • Mount directory to Docker container
  • Migrating
    • Migrate data from PostgreSQL to MatrixOne
    • Migrate data from MySQL to MatrixOne
    • Migrate data to MatrixOne Overview
    • Migrate data from SQL Server to MatrixOne
    • Migrate data from SQL Server to MatrixOne
  • Overview
    • What’s New
    • MatrixOne Feature List
    • MatrixOne Introduction
    • MatrixOne Architecture Design
      • Logtail Protocol Architecture
      • Architecture Design Overview
      • Detailed Caching and Hot-Cold Data Separation Architecture
      • Transaction and Lock Mechanisms Architecture
      • Detailed Stream Engine Architecture
      • Detailed Logservice Architecture
      • Detailed Proxy Architecture
      • Transactional Analytical Engine Architecture
    • MatrixOne Feature
      • High Availability
      • Cost-Effective
      • MySQL Compatibility
      • HTAP
      • Scalability
      • Multi-Account
  • Performance Tuning
    • SQL Performance Tuning Methods Overview
    • Performance tuning best practices
      • Scaling CN for better performance
      • Using Cluster by for performance tuning
    • Understanding the Query Execution Plan
      • Explain Statements Using JOIN
      • Explain Statements Using Aggregation
      • Explain Statements Using Subqueries
      • Query Execution Plan Overview
      • EXPLAIN Statements Using Views
      • Using EXPLAIN to learn the execution plan
  • Privilege
    • Authentication and Authorization
    • Security and Permissions Overview
    • Security Audit
    • Password Management
    • Data Transmission Encryption
    • Access Control
      • Best Practices
      • About MatrixOne Privilege Management
      • Privilege Management Scenario
    • User Guide
      • Create accounts, Verify Resource Isolation
      • Privileges Management Overview
      • Use the new account to creates users, roles, grant the privilege
  • Reference
    • MatrixOne Catalog
    • MatrixOne Directory Structure
    • Privilege Control Types
    • Data Types
      • Fixed-Point Types (Exact Value/) - DECIMAL
      • Data Type Conversion
      • BLOB and TEXT Type
      • ENUM Type
      • UUID Type
      • JSON Data Type
      • Data Types Overview
      • Date and Time Types
        • YEAR Type
        • Timestamp Initialization
    • Functions and Operators
      • Functions
        • Other Functions
          • UUID(/)
          • SLEEP
        • JSON Functions
        • Mathematical
          • POWER(/)
          • PI(/)
          • LN(/)
          • COS(/)
          • SIN(/)
          • ACOS(/)
          • LOG10(/)
          • ATAN(/)
          • RAND(/)
          • ROUND(/)
          • LOG(/)
          • CEIL(/)
          • SINH(/)
          • ABS(/)
          • TAN(/)
          • EXP(/)
          • FLOOR(/)
          • LOG2(/)
          • COT(/)
        • Aggregate Functions
          • VARIANCE
          • STDDEV_POP
          • AVG
          • COUNT
          • ANY_VALUE
          • BIT_XOR
          • MAX
          • SUM
          • BIT_OR
          • MEDIAN
          • BIT_AND
          • GROUP_CONCAT
          • MIN
        • System OPS Functions
          • CURRENT_USER(/)
          • CURRENT_ROLE(/)
          • PURGE_LOG(/)
          • CURRENT_USER_NAME(/)
          • CURRENT_ROLE_NAME(/)
        • String
          • REVERSE(/)
          • CONCAT(/)
          • TRIM(/)
          • SPACE(/)
          • LTRIM(/)
          • BIN(/)
          • LPAD(/)
          • REPEAT(/)
          • CHAR_LENGTH(/)
          • SPLIT_PART(/)
          • INSTR(/)
          • BIT_LENGTH(/)
          • RPAD(/)
          • FIND_IN_SET(/)
          • HEX(/)
          • FORMAT(/)
          • SUBSTRING(/)
          • FIELD(/)
          • RTRIM(/)
          • OCT(/)
          • EMPTY(/)
          • LEFT(/)
          • SUBSTRING_INDEX(/)
          • LENGTH(/)
          • CONCAT_WS(/)
          • ENDSWITH(/)
          • STARTSWITH(/)
          • Regular Expressions
            • REGEXP_INSTR(/)
            • REGEXP_REPLACE(/)
            • NOT REGEXP
            • Regular Expressions Overview
            • REGEXP_SUBSTR(/)
            • REGEXP_LIKE(/)
        • Datetime
          • DATE(/)
          • DATEDIFF(/)
          • DAY(/)
          • SECOND(/)
          • MONTH(/)
          • DATE_ADD(/)
          • UTC_TIMESTAMP(/)
          • WEEKDAY(/)
          • DATE_FORMAT(/)
          • TIME(/)
          • UNIX_TIMESTAMP
          • CURDATE(/)
          • FROM_UNIXTIME
          • TIMEDIFF(/)
          • YEAR(/)
          • TO_DATE(/)
          • DATE_SUB(/)
          • TO_SECONDS(/)
          • TIMESTAMPDIFF(/)
          • EXTRACT(/)
          • MINUTE(/)
          • TO_DAYS(/)
          • DAYOFYEAR(/)
          • WEEK(/)
          • CURRENT_TIMESTAMP(/)
          • HOUR(/)
          • TIMESTAMP(/)
        • Window Functions
          • DENSE_RANK(/)
          • ROW_NUMBER(/)
          • RANK(/)
        • Table
          • UNNEST(/)
      • Operators
        • INTERVAL
        • OPERATORS
          • OPERATORS Precedence
          • OPERATORS Overview
          • Comparison Functions and Operators
            • NOT LIKE
            • NOT IN
            • >=
            • IS
            • COALESCE
            • BETWEEN … AND …
            • >
            • LIKE
            • <=
            • IS NOT NULL
            • NOT BETWEEN … AND …
            • IS NULL
            • ISNULL
            • <
            • ILIKE
            • \=
            • IS NOT
            • Comparison Functions and Operators Overview
            • IN
            • <>,!=
          • Logical Operators
            • AND,&&
            • OR
            • Logical Operators Overview
            • NOT,!
            • XOR
          • Arithmetic Operators
            • -
            • Arithmetic Operators Overview
            • -
            • *
            • /
            • DIV
            • %,MOD
            • +
          • Assignment Operators
            • \=
            • Assignment Operators Overview
          • Flow Control Functions
            • IFNULL
            • IF
            • Flow Control Functions Overview
            • NULLIF
            • CASE WHEN
          • Bit Functions and Operators
            • >>
            • Bit Functions and Operators Overview
            • ~
            • ^
            • <<
            • |
            • &
          • Cast Functions and Operators
            • CAST
            • Cast Functions and Operators Overview
            • CONVERT
            • BINARY
    • Limitations
      • JDBC supported features list
      • Partitioning supported features list
    • MatrixOne Tools
      • mo_ctl Tool
    • SQL Language Structure
      • Comments
      • Keywords
    • SQL Statements
      • Data Definition Language
        • CREATE EXTERNAL TABLE
        • CREATE TABLE
        • DROP INDEX
        • TRUNCATE TABLE
        • ALTER PUBLICATION
        • ALTER VIEW
        • CREATE…FROM…PUBLICATION…
        • CREATE VIEW
        • DROP SEQUENCE
        • ALTER TABLE
        • ALTER STAGE
        • CREATE STAGE
        • CREATE PUBLICATION
        • DROP STAGE
        • DROP DATABASE
        • CREATE SEQUENCE
        • CREATE INDEX
        • DROP PUBLICATION
        • DROP VIEW
        • CREATE DATABASE
        • DROP TABLE
      • Type of SQL Statements
      • Data Manipulation Language
        • DELETE
        • UPDATE
        • INSERT ON DUPLICATE KEY UPDATE
        • INSERT INTO SELECT
        • INSERT
        • REPLACE
        • LOAD DATA
        • Information Functions
          • LAST_INSERT_ID(/)
          • LAST_QUERY_ID(/)
      • Data Query Language
        • JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • NATURAL JOIN
          • OUTER JOIN
          • FULL JOIN
          • JOIN Overview
          • INNER JOIN
        • With CTE
        • SELECT
        • SUBQUERY
          • Derived Tables
          • SUBQUERY Overview
          • SUBQUERY with EXISTS
          • SUBQUERY with ALL
          • SUBQUERY with ANY or SOME
          • SUBQUERY with IN
          • Comparisons Using Subqueries
        • Combining Queries
          • MINUS
          • INTERSECT
          • UNION
          • Combining Queries Overview
      • Other
        • KILL
        • Prepared Statements
          • EXECUTE
          • DEALLOCATE
          • PREPARE
        • Explain
          • Explain Analyze
          • EXPLAIN
          • EXPLAIN Output Format
        • SET
          • SET ROLE
        • SHOW
          • SHOW GRANT
          • SHOW ACCOUNTS
          • SHOW SUBSCRIPTIONS
          • SHOW CREATE VIEW
          • SHOW COLLATION
          • SHOW TABLES
          • SHOW PROCESSLIST
          • SHOW INDEX
          • SHOW VARIABLES
          • SHOW CREATE TABLE
          • SHOW STAGE
          • SHOW SEQUENCES
          • SHOW PUBLICATIONS
          • SHOW ROLES
          • SHOW CREATE PUBLICATION
          • SHOW FUNCTION STATUS
          • SHOW COLUMNS
          • SHOW DATABASES
        • USE
          • USE DATABASE
      • Data Control Language
        • DROP ROLE
        • GRANT
        • DROP ACCOUNT
        • ALTER ACCOUNT
        • CREATE USER
        • CREATE ROLE
        • ALTER USER
        • DROP USER
        • REVOKE
        • CREATE ACCOUNT
    • System Paramaters
      • System Parameters Overview
      • Distributed Common Parameters Configuration
      • Standalone Common Parameters Configuration
    • System Variables
      • System Variables Overview
      • Custom variable
      • System Variables parameters
        • Timezone support
        • Save query result support
        • SQL Mode
        • Lowercase table names support
  • Release Notes
    • v1.0.1
    • v0.8.0
    • v0.3.0
    • v0.6.0
    • v0.2.0
    • v0.5.1
    • v1.0.0-rc2
    • v1.0.0-rc1
    • v0.5.0
    • v0.4.0
    • Release Timeline
    • v1.1.0
    • v0.1.0
    • v1.0.0
    • v1.0.2
    • v0.7.0
  • Testing
    • Performance Testing
      • SSB Test with MatrixOne
      • TPCH Test with MatrixOne
      • TPCC Test with MatrixOne
    • Testing Tool
      • MO-Tester
      • MO-Tester Specification
  • Troubleshooting
    • Database statistics
    • Error Code
    • Common statistic data query
    • Slow Queries
暂无相关搜索结果！

    本文档使用 全库网 构建

    展开/收起文章目录

    思维导图备注

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度