Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
An error occurs if a transaction is already active, or if the kernel metadata is locked. In the event of an error, the transaction is immediately aborted. Return value Returns 0 on success; on failure, returns -1 and sets an error. As with many ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
Alternatively, run the following statement: mysql> ALTER TABLE tbl_name SECONDARY_LOAD; The following error is reported if the table is already loaded: mysql> ERROR 13331 (HY000): Table is already loaded. Problem: You have encountered an ...Solution ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). If an ON UPDATE CASCADE or ON DELETE CASCADE subclause is only defined for one FOREIGN KEY clause, cascading operations fail with an ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/9.7/en/get-diagnostics.html
(You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. If that is not the case, a GET STACKED DIAGNOSTICS when handler not active error occurs. Condition area list: ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error. If the timeout is reached without successful lock acquisition, an ER_LOCKING_SERVICE_TIMEOUT error ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-import.html
--abort-on-error Command-Line Format --abort-on-error Dump core on any fatal error; used for debugging only. --core-file Command-Line Format --core-file Write core file on error; used in debugging. --errins-type=name Command-Line Format ...
https://dev.mysql.com/doc/refman/9.7/en/server-configuration-validation.html
MySQL supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the server terminates with an exit ...For additional checks to occur, correct the initial problem and run the server with --validate-config ...
https://dev.mysql.com/doc/refman/9.7/en/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/monitoring-innodb-cluster.html
One or two member servers in the cluster are online, but one or more servers are in an offline, recovering, error, or unreachable state. ERROR: The instance has encountered an error during the recovery phase or while applying a transaction. This ...