暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Server Error Message Reference -1205

原创 wzf0072 2023-08-30
196
  • Error number: 1191; Symbol: ER_FT_MATCHING_KEY_NOT_FOUND; SQLSTATE: HY000

    Message: Can't find FULLTEXT index matching the column list

  • Error number: 1192; Symbol: ER_LOCK_OR_ACTIVE_TRANSACTION; SQLSTATE: HY000

    Message: Can't execute the given command because you have active locked tables or an active transaction

  • Error number: 1193; Symbol: ER_UNKNOWN_SYSTEM_VARIABLE; SQLSTATE: HY000

    Message: Unknown system variable '%s'

  • Error number: 1194; Symbol: ER_CRASHED_ON_USAGE; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and should be repaired

  • Error number: 1195; Symbol: ER_CRASHED_ON_REPAIR; SQLSTATE: HY000

    Message: Table '%s' is marked as crashed and last (automatic?) repair failed

  • Error number: 1196; Symbol: ER_WARNING_NOT_COMPLETE_ROLLBACK; SQLSTATE: HY000

    Message: Some non-transactional changed tables couldn't be rolled back

  • Error number: 1197; Symbol: ER_TRANS_CACHE_FULL; SQLSTATE: HY000

    Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again

  • Error number: 1199; Symbol: ER_SLAVE_NOT_RUNNING; SQLSTATE: HY000

    Message: This operation requires a running slave; configure slave and do START SLAVE

    ER_SLAVE_NOT_RUNNING was removed after 8.0.32.

  • Error number: 1199; Symbol: ER_REPLICA_NOT_RUNNING; SQLSTATE: HY000

    Message: This operation requires a running replica; configure replica and do START REPLICA

    ER_REPLICA_NOT_RUNNING was added in 8.0.33.

  • Error number: 1200; Symbol: ER_BAD_SLAVE; SQLSTATE: HY000

    Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

    ER_BAD_SLAVE was removed after 8.0.32.

  • Error number: 1200; Symbol: ER_BAD_REPLICA; SQLSTATE: HY000

    Message: The server is not configured as replica; fix in config file or with CHANGE REPLICATION SOURCE TO

    ER_BAD_REPLICA was added in 8.0.33.

  • Error number: 1201; Symbol: ER_MASTER_INFO; SQLSTATE: HY000

    Message: Could not initialize master info structure; more error messages can be found in the MySQL error log

    ER_MASTER_INFO was removed after 8.0.32.

  • Error number: 1201; Symbol: ER_CONNECTION_METADATA; SQLSTATE: HY000

    Message: Could not initialize connection metadata structure; more error messages can be found in the MySQL error log

    ER_CONNECTION_METADATA was added in 8.0.33.

  • Error number: 1202; Symbol: ER_SLAVE_THREAD; SQLSTATE: HY000

    Message: Could not create slave thread; check system resources

    ER_SLAVE_THREAD was removed after 8.0.32.

  • Error number: 1202; Symbol: ER_REPLICA_THREAD; SQLSTATE: HY000

    Message: Could not create replica thread; check system resources

    ER_REPLICA_THREAD was added in 8.0.33.

  • Error number: 1203; Symbol: ER_TOO_MANY_USER_CONNECTIONS; SQLSTATE: 42000

    Message: User %s already has more than 'max_user_connections' active connections

  • Error number: 1204; Symbol: ER_SET_CONSTANTS_ONLY; SQLSTATE: HY000

    Message: You may only use constant expressions with SET

  • Error number: 1205; Symbol: ER_LOCK_WAIT_TIMEOUT; SQLSTATE: HY000

    Message: Lock wait timeout exceeded; try restarting transaction

    InnoDB reports this error when lock wait timeout expires. The statement that waited too long was rolled back (not the entire transaction). You can increase the value of the innodb_lock_wait_timeout configuration option if SQL statements should wait longer for other transactions to complete, or decrease it if too many long-running transactions are causing locking problems and reducing concurrency on a busy system.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论