| Bug #30225 | ERROR 1030 (HY000): Got error -1 from storage engine | ||
|---|---|---|---|
| Submitted: | 3 Aug 2007 9:40 | Modified: | 3 Aug 2007 15:51 |
| Reporter: | Alex Dantart | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.0.38 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | -1, 1030, engine, error, storage | ||
[3 Aug 2007 9:40]
Alex Dantart
[3 Aug 2007 9:54]
Sveta Smirnova
Thank you for the report. But version 4.1.15 is quite old. Please upgrade to current version 4.1.23, try with it and say us result.
[3 Aug 2007 10:52]
Alex Dantart
Upgraded to 5.0.22-Debian_0ubuntu6.06.3
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.22-Debian_0ubuntu6.06.3-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create table test (field1 varchar(128) NOT NULL, field2 varchar(128) NOT NULL) ENGINE=InnoDB;
Query OK, 0 rows affected (0.18 sec)
mysql> insert into test (field1, field2) VALUES ("a", "b");
ERROR 1030 (HY000): Got error -1 from storage engine
The same with 5.0
[3 Aug 2007 11:07]
Sveta Smirnova
Thank you for the feedback. But version 5.0.22 is outdated too. Please use current version 5.0.45.
[3 Aug 2007 11:12]
Alex Dantart
are you kidding me ? :D It's the stable version on Ubuntu repository... PLEASE do not make me installing one from tarball manually... So is this a problem that appear in ALL VERSIONS that are not the LAST one ? :P
[3 Aug 2007 11:21]
Sveta Smirnova
Thank you for the feedback. Version 5.0.22 has been released more than 1 year ago. Many bugs have been fixed since. Additionally I can not repeat described behaviour in my environment. You don't need to install something manually. Use our Generic Linux packages accessible from http://dev.mysql.com/downloads/mysql/5.0.html
[3 Aug 2007 11:37]
Alex Dantart
I'm playing with all versions this morning :P In the link you gave me there is 5.0.21 http://dev.mysql.com/downloads/mysql/5.0.html#ubuntu I've searched the LAST one from ubuntu... 5.0.38 Now 5.0.38, the same Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution Reading history-file /root/.mysql_history Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table test (field1 varchar(128) NOT NULL, field2 varchar(128) NOT NULL) ENGINE=InnoDB; Query OK, 0 rows affected (0.03 sec) mysql> insert into test (field1, field2) VALUES ("a", "b"); ERROR 1030 (HY000): Got error -1 from storage engine any ideas ?
[3 Aug 2007 11:49]
Alex Dantart
4.1.5, 5.0.21, 5.0.22, 5.0.38 all gives "ERROR 1030 (HY000): Got error -1 from storage engine" Do not offend but... don't you think we should focus the error itself instead changing versions ? It's what I told you some post above... that error appeared in all "not-last-last-last" different versions ? Anyway, 5.0.38 is one of the "super" last ones... so ??
[3 Aug 2007 12:01]
Sveta Smirnova
Thank you for the feedback. Version 5.0.38 is not last. But seems you are right: problem is in your environment. Please provide output of SHOW ENGINE INNODB STATUS, your error log, configuration file and output of command `ls -la data_directory`
[3 Aug 2007 12:31]
Alex Dantart
===================================== 070803 14:21:05 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 61 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2, signal count 2 Mutex spin waits 0, rounds 100, OS waits 0 RW-shared spins 4, OS waits 2; RW-excl spins 0, OS waits 0 ------------ TRANSACTIONS ------------ Trx id counter 0 4358 Purge done for trx's n:o < 0 0 undo n:o < 0 0 History list length 12 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 22823, OS thread id 3018648464 MySQL thread id 12, query id 1298 localhost root SHOW ENGINE INNODB STATUS ---TRANSACTION 0 4353, not started, process no 22823, OS thread id 3018783632 MySQL thread id 4, query id 1184 localhost debian-sys-maint Repair with keycache REPAIR TABLE `suscripciones`.`emails_em8` -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 26 OS file reads, 5 OS file writes, 5 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 0, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 74133 Log flushed up to 0 74133 Last checkpoint at 0 71083 0 pending log writes, 0 pending chkp writes 10 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 17412350; in additional pool allocated 873984 Buffer pool size 512 Free buffers 489 Database pages 22 Modified db pages 13 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 21, created 1, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 22823, id 2999286672, state: waiting for server activity Number of rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT my.conf: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] innodb_force_recovery = 4 user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr #datadir = /var/lib/mysql/ datadir = /discos/sata2/bbdd/ tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking old_passwords = 1 bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 #log = /var/log/mysql.log log = /var/log/mysql/mysql.log log-slow-queries = /var/log/mysql/mysql-slow.log log-bin = /var/log/mysql/mysql-bin.log expire-logs-days = 20 max_binlog_size = 104857600 skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M directory: root@:# ls -al /var/lib/mysql/test total 126064 drwx------ 2 mysql mysql 4096 Aug 3 13:55 . drwxr-xr-x 38 mysql mysql 4096 Aug 3 13:55 .. -rw-rw---- 1 mysql mysql 8790 Aug 3 11:13 fot_Schema.frm error_log: no log...
[3 Aug 2007 12:44]
Sveta Smirnova
Thank you for the feedback. Please provide output of `ls -la /discos/sata2/bbdd/`. Also please turn error log on, run problematic query and provide us error log.
[3 Aug 2007 12:51]
Alex Dantart
InnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed. InnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed. dir: total 93344 drwxr-xr-x 38 mysql mysql 4096 Aug 3 14:43 . drwx------ 2 mysql mysql 4096 Aug 3 13:28 test
[3 Aug 2007 12:54]
Alex Dantart
By the way I've tried with innodb_force_recovery 3, 4 and 5
[3 Aug 2007 13:14]
Alex Dantart
is normal that, when i create a innodb table, just .frm file is created ? in myisam there is 3 files... even when you do not insert anything... maybe is a clue :P
[3 Aug 2007 13:14]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Please read about innodb-force-recovery for at http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
[3 Aug 2007 13:21]
Alex Dantart
So,
I have installed FROM ZERO (deleting everything) 4.1.5
I have installed FROM ZERO (deleting everything) 5.0.21
I have installed FROM ZERO (deleting everything) 5.0.22
I have installed FROM ZERO (deleting everything) 5.0.38
and in every version there is "ERROR 1030 (HY000): Got error -1 from storage engine" error when I try to insert data in innodb created table.
And you tell me it's my ERROR...
I have done in a FRESH UBUNTU INSTALL.
New COMPUTER, new ubuntu:
# apt-get install mysql-client
# apt-get install mysql-server
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.22-Debian_0ubuntu6.06.3-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database t;
Query OK, 1 row affected (0.00 sec)
mysql> use t;
Database changed
mysql> create table test (field1 varchar(10) NOT NULL, field2 varchar(10) NOT NULL) ENGINE=InnoDB;
Query OK, 0 rows affected (0.11 sec)
mysql> insert into test (field1, field2) VALUES ("a", "b");
ERROR 1030 (HY000): Got error -1 from storage engine
And is my problem ?
What are you going to tell me ? to change motherboard ?
Please, read carefully... NEW COMPUTER, new ubuntu install from Internet
Just mysql-client and server install... NOTHING change
:)
[3 Aug 2007 13:36]
Alex Dantart
It's a BUG of mysql my.cnf file I have do a lot of tests, and finally I have found it It's SOMETHING about my.cnf It's a BUG of MYSQL, now works on each version I told, in each one It's something JUST OF my.cnf, no versions, no directories, no permissions, no databases, no computer, no linux version... it's just a PROBLEM AND BUG of my.cnf thank you for nothing
[3 Aug 2007 15:51]
Alex Dantart
if someone has the same problem, email me... thank you
[7 Aug 2007 9:14]
Sergei Golubchik
You wrote [3 Aug 14:31] Alex Dantart my.conf: [mysqld] innodb_force_recovery = 4 Later you wrote [3 Aug 14:51] Alex Dantart InnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed. InnoDB has *explicitly* told you that it won't work with innodb_force_recovery in my.cnf and asked you to remove this switch.
[17 Mar 2008 3:15]
Bingxi Wu
innodb_force_recovery only for crash recovery mode.if the value greater than 0,You can changes the data.
[13 Jun 2008 15:15]
Nicolas Pestana
Thanks Alex for these post, it has been helping resolve this problem (it's funny to read it too ;) )
[3 Sep 2008 22:13]
Alexandre Almeida
Oh my God! You don't need to change any version. Just set you force recovery to 0. Force recovery it´s only for recovery operation!!!
[31 May 2016 6:51]
ajit rew
I have Same problem Alex can you give me your email id
[9 Mar 2023 16:51]
FRANCISCO SANCHEZ
is normal that, when i create a innodb table, just .frm file is created ? in myisam there is 3 files... even when you do not insert anything... maybe is a clue :P You can find a [url=https://www.everyword.eu/traductor-jurado-madrid]traductor jurado in Madrid[/url] and a [url=https://tradupro.net/traductor-jurado-sevilla]Traductor jurado in Sevilla[/url] here.
[9 Mar 2023 16:53]
FRANCISCO SANCHEZ
is normal that, when i create a innodb table, just .frm file is created ? in myisam there is 3 files... even when you do not insert anything... maybe is a clue :P You can find a https://www.everyword.eu/traductor-jurado-madrid traductor jurado in Madrid https://tradupro.net/traductor-jurado-sevilla https://tradupro.pl/tlumacz-przysiegly-krakowie/
[9 Mar 2023 16:54]
FRANCISCO SANCHEZ
I'm playing with all versions this morning :P In the link you gave me there is 5.0.21 http://dev.mysql.com/downloads/mysql/5.0.html#ubuntu I've searched the LAST one from ubuntu... 5.0.38 Now 5.0.38, the same Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution Reading history-file /root/.mysql_history Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table test (field1 varchar(128) NOT NULL, field2 varchar(128) NOT NULL) ENGINE=InnoDB; Query OK, 0 rows affected (0.03 sec) mysql> insert into test (field1, field2) VALUES ("a", "b"); ERROR 1030 (HY000): Got error -1 from storage engine any ideas ?
