startseitekatalogpraxiswerkzeugeressourcenmagazingrammiweb

(Stand: 27.07.24, Adresse: http://www.grammiweb.de/uebersichten/mysql-fehlercodes.shtml)

 

MySQL - Fehlercodes

Die kostenlose Datenbank MySQL zeichnet sich vor allem durch einfache Bedienung, großes Leistungspotential und erfreuliche Flexibilität aus. Trotzdem schleicht sich in die SQL-Programmierung gerne mal ein Fehler ein, so dass das gerade programmierte digitale Kunstwerk strikt seinen Dienst versagt oder das heruntergeladene Script scheinbar noch ein Schläfchen nimmt.

MySQL reagiert je nach Wunsch des Programmierers entweder mit Stillschweigen, einer individuellen oder einer vorgegebenen Fehlermeldung oder mit einem Fehlercode auf fehlerhafte Anweisungen. Der Code ist dabei eine äußerst beliebte Variante, da er zumindest ansatzweise verhindern kann, dass ungeübte oder mit der Anwendungsumgebung nicht vertraute Nutzer im Quelltext herumbasteln und auf eigene Faust versuchen, den Fehler zu beheben.

In der folgenden Aufstellung finden Sie die MySQL-Fehlercodes mit deren Bedeutung.

 

Code	Fehler in Klartext
1000	hashchk
1001	isamchk
1002	NO
1003	YES
1004	Can't create file '%-.64s' (errno: %d)
1005	Can't create table '%-.64s' (errno: %d)
1006	Can't create database '%-.64s'. (errno: %d)
1007	Can't create database '%-.64s'. Database exists
1008	Can't drop database '%-.64s'. Database doesn't exist
1009	Error dropping database (can't delete '%-.64s', errno: %d)
1010	Error dropping database (can't rmdir '%-.64s', errno: %d)
1011	Error on delete of '%-.64s' (errno: %d)
1012	Can't read record in system table
1013	Can't get status of '%-.64s' (errno: %d)
1014	Can't get working directory (errno: %d)
1015	Can't lock file (errno: %d)
1016	Can't open file: '%-.64s'. (errno: %d)
1017	Can't find file: '%-.64s' (errno: %d)
1018	Can't read dir of '%-.64s' (errno: %d)
1019	Can't change dir to '%-.64s' (errno: %d)
1020	Record has changed since last read in table '%-.64s'
1021	Disk full (%s). Waiting for someone to free some space....
1022	Can't write, duplicate key in table '%-.64s'
1023	Error on close of '%-.64s' (errno: %d)
1024	Error reading file '%-.64s' (errno: %d)
1025	Error on rename of '%-.64s' to '%-.64s' (errno: %d)
1026	Error writing file '%-.64s' (errno: %d)
1027	'%-.64s' is locked against change
1028	Sort aborted
1029	View '%-.64s' doesn't exist for '%-.64s'
1030	Got error %d from table handler
1031	Table handler for '%-.64s' doesn't have this option
1032	Can't find record in '%-.64s'
1033	Incorrect information in file: '%-.64s'
1034	Incorrect key file for table: '%-.64s'. Try to repair it
1035	Old key file for table '%-.64s'; Repair it!
1036	Table '%-.64s' is read only
1037	Out of memory. Restart daemon and try again (needed %d bytes)
1038	Out of sort memory. Increase daemon sort buffer size
1039	Unexpected eof found when reading file '%-.64s' (errno: %d)
1040	Too many connections
1041	Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
1042	Can't get hostname for your address
1043	Bad handshake
1044	Access denied for user: '%-.32s@%-.64s' to database '%-.64s'
1045	Access denied for user: '%-.32s@%-.64s' (Using password: %s)
1046	No Database Selected
1047	Unknown command
1048	Column '%-.64s' cannot be null
1049	Unknown database '%-.64s'
1050	Table '%-.64s' already exists
1051	Unknown table '%-.64s'
1052	Column: '%-.64s' in %-.64s is ambiguous
1053	Server shutdown in progress
1054	Unknown column '%-.64s' in '%-.64s'
1055	'%-.64s' isn't in GROUP BY
1056	Can't group on '%-.64s'
1057	Statement has sum functions and columns in same statement
1058	Column count doesn't match value count
1059	Identifier name '%-.100s' is too long
1060	Duplicate column name '%-.64s'
1061	Duplicate key name '%-.64s'
1062	Duplicate entry '%-.64s' for key %d
1063	Incorrect column specifier for column '%-.64s'
1064	%s near '%-.80s' at line %d
1065	Query was empty
1066	Not unique table/alias: '%-.64s'
1067	Invalid default value for '%-.64s'
1068	Multiple primary key defined
1069	Too many keys specified. Max %d keys allowed
1070	Too many key parts specified. Max %d parts allowed
1071	Specified key was too long. Max key length is %d
1072	Key column '%-.64s' doesn't exist in table
1073	BLOB column '%-.64s' can't be used in key specification with the used table type
1074	Too big column length for column '%-.64s' (max = %d). Use BLOB instead
1075	Incorrect table definition; There can only be one auto column and it must be defined as a key
1076	%s: ready for connections\n
1077	%s: Normal shutdown\n
1078	%s: Got signal %d. Aborting!\n
1079	%s: Shutdown Complete\n
1080	%s: Forcing close of thread %ld user: '%-.32s'\n
1081	Can't create IP socket
1082	Table '%-.64s' has no index like the one used in CREATE INDEX. Recreate the table
1083	Field separator argument is not what is expected. Check the manual
1084	You can't use fixed rowlength with BLOBs. Please use 'fields terminated by'.
1085	The file '%-.64s' must be in the database directory or be readable by all
1086	File '%-.80s' already exists
1087	Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld
1088	Records: %ld Duplicates: %ld
1089	Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the table handler doesn't support unique sub keys
1090	You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
1091	Can't DROP '%-.64s'. Check that column/key exists
1092	Records: %ld Duplicates: %ld Warnings: %ld
1093	INSERT TABLE '%-.64s' isn't allowed in FROM table list
1094	Unknown thread id: %lu
1095	You are not owner of thread %lu
1096	No tables used
1097	Too many strings for column %-.64s and SET
1098	Can't generate a unique log-filename %-.64s.(1-999)\n
1099	Table '%-.64s' was locked with a READ lock and can't be updated
1100	Table '%-.64s' was not locked with LOCK TABLES
1101	BLOB column '%-.64s' can't have a default value
1102	Incorrect database name '%-.100s'
1103	Incorrect table name '%-.100s'
1104	The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
1105	Unknown error
1106	Unknown procedure '%-.64s'
1107	Incorrect parameter count to procedure '%-.64s'
1108	Incorrect parameters to procedure '%-.64s'
1109	Unknown table '%-.64s' in %-.32s
1110	Column '%-.64s' specified twice
1111	Invalid use of group function
1112	Table '%-.64s' uses an extension that doesn't exist in this MySQL version
1113	A table must have at least 1 column
1114	The table '%-.64s' is full
1115	Unknown character set: '%-.64s'
1116	Too many tables. MySQL can only use %d tables in a join
1117	Too many columns
1118	Too big row size. The maximum row size, not counting BLOBs, is %d. You have to change some fields to BLOBs
1119	Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed
1120	Cross dependency found in OUTER JOIN. Examine your ON conditions
1121	Column '%-.64s' is used with UNIQUE or INDEX but is not defined as NOT NULL
1122	Can't load function '%-.64s'
1123	Can't initialize function '%-.64s'; %-.80s
1124	No paths allowed for shared library
1125	Function '%-.64s' already exist
1126	Can't open shared library '%-.64s' (errno: %d %-.64s)
1127	Can't find function '%-.64s' in library'
1128	Function '%-.64s' is not defined
1129	Host '%-.64s' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
1130	Host '%-.64s' is not allowed to connect to this MySQL server
1131	You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords
1132	You must have privileges to update tables in the mysql database to be able to change passwords for others
1133	Can't find any matching row in the user table
1134	Rows matched: %ld Changed: %ld Warnings: %ld
1135	Can't create a new thread (errno %d). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug
1136	Column count doesn't match value count at row %ld
1137	Can't reopen table: '%-.64s'
1138	Invalid use of NULL value
1139	Got error '%-.64s' from regexp
1140	Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
1141	There is no such grant defined for user '%-.32s' on host '%-.64s'
1142	%-.16s command denied to user: '%-.32s@%-.64s' for table '%-.64s'
1143	%-.16s command denied to user: '%-.32s@%-.64s' for column '%-.64s' in table '%-.64s'
1144	Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used.
1145	The host or user argument to GRANT is too long
1146	Table '%-.64s.%-.64s' doesn't exist
1147	There is no such grant defined for user '%-.32s' on host '%-.64s' on table '%-.64s'
1148	The used command is not allowed with this MySQL version
1149	You have an error in your SQL syntax
1150	Delayed insert thread couldn't get requested lock for table %-.64s
1151	Too many delayed threads in use
1152	Aborted connection %ld to db: '%-.64s' user: '%-.32s' (%-.64s)
1153	Got a packet bigger than 'max_allowed_packet'
1154	Got a read error from the connection pipe
1155	Got an error from fcntl()
1156	Got packets out of order
1157	Couldn't uncompress communication packet
1158	Got an error reading communication packets
1159	Got timeout reading communication packets
1160	Got an error writing communication packets
1161	Got timeout writing communication packets
1162	Result string is longer than max_allowed_packet
1163	The used table type doesn't support BLOB/TEXT columns
1164	The used table type doesn't support AUTO_INCREMENT columns
1165	INSERT DELAYED can't be used with table '%-.64s', because it is locked with LOCK TABLES
1166	Incorrect column name '%-.100s'
1167	The used table handler can't index column '%-.64s'
1168	All tables in the MERGE table are not identically defined
1169	Can't write, because of unique constraint, to table '%-.64s'
1170	BLOB column '%-.64s' used in key specification without a key length
1171	All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
1172	Result consisted of more than one row
1173	This table type requires a primary key
1174	This version of MySQL is not compiled with RAID support
1175	You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
1176	Key '%-.64s' doesn't exist in table '%-.64s'
1177	Can't open table
1178	The handler for the table doesn't support check/repair
1179	You are not allowed to execute this command in a transaction
1180	Got error %d during COMMIT
1181	Got error %d during ROLLBACK
1182	Got error %d during FLUSH_LOGS
1183	Got error %d during CHECKPOINT
1184	Aborted connection %ld to db: '%-.64s' user: '%-.32s' host: `%-.64s' (%-.64s)
1185	The handler for the table does not support binary table dump
1186	Binlog closed, cannot RESET MASTER
1187	Failed rebuilding the index of dumped table '%-.64s'
1188	Error from master: '%-.64s'
1189	Net error reading from master
1190	Net error writing to master
1191	Can't find FULLTEXT index matching the column list
1192	Can't execute the given command because you have active locked tables or an active transaction
1193	Unknown system variable '%-.64'
1194	Table '%-.64s' is marked as crashed and should be repaired
1195	Table '%-.64s' is marked as crashed and last (automatic?) repair failed
1196	Warning: Some non-transactional changed tables couldn't be rolled back
1197	Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again
1198	This operation cannot be performed with a running slave, run SLAVE STOP first
1199	This operation requires a running slave, configure slave and do SLAVE START
1200	The server is not configured as slave, fix in config file or with CHANGE MASTER TO
1201	Could not initialize master info structure, check permisions on master.info
1202	Could not create slave thread, check system resources
1203	User %-.64s has already more than 'max_user_connections' active connections
1204	You may only use constant expressions with SET
1205	Lock wait timeout exceeded
1206	The total number of locks exceeds the lock table size
1207	Update locks cannot be acquired during a READ UNCOMMITTED transaction
1208	DROP DATABASE not allowed while thread is holding global read lock
1209	CREATE DATABASE not allowed while thread is holding global read lock
1210	Wrong arguments to %s
1211	%-.32s@%-.64s is not allowed to create new users

Zurück zum Inhaltsverzeichnis

[an error occurred while processing this directive] [an error occurred while processing this directive]