cause of table crash
Hello I get the following errors/warnings on a table: Table is marked as crashed Not used space is supposed to be: 3688 but is: 3624 record delete-link-chain corrupted corrupt What can be the cause of this crash? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: Tablecrash
yes, its gone in 4.0.16
-Ursprungligt meddelande-
Från: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Skickat: den 23 oktober 2003 21:12
Till: [EMAIL PROTECTED]
Ämne: Re: Tablecrash
Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] wrote:
I got a table that crashes everytime that I use delete from
hvd_layout_settings
This is a infinite loop:
while (1)
{
check table hvd_layout_settings = table ok
delete from hvd_layout_settings
check table hvd_layout_settings = table crashed
repair table hvd_layout_settings
}
Im using mysql 4.0.15a.
Seems your bug is the same as http://bugs.mysql.com/bug.php?id=1321
Which OS do you use?
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored
by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
GRANT insert,delete,update,select on phonewatch.* to [EMAIL PROTECTED] identified by 'password' works. GRANT insert,delete,update,select on phonewatch.* to datatal identified by 'password' do not. Can someone please test this and verify if it's a bug? -Ursprungligt meddelande- Från: Nathaniel Mallet [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 03:04 Till: Rory McKinley; Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: RE: GRANT problem I was having the same problems trying to get a user added to a new DB, so here's are the commands I used: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES; where user and password are whatever you need it to be. I've never had much luck with % as host, so specify localhost for you user, and you should be all set. Nat -Original Message- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:21 AM To: Datatal AB - Gauffin, Jonas Cc: [EMAIL PROTECTED] Subject: Re: GRANT problem Ok. I'm stumped. If I'm reading the manual correctly, you were right about not hving to specify the host..the only difference between your version and the manual is that they use single quotes around the user name but I can't see how that makes any difference. I normally just specfiy hosts because using wildcards for hosts makes me nervous - hey, even paranoid people have enemies :) If anyone knows the answer to this I would be interested in knowing what it is too Sorry I can't be of more help Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] forums.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: SV: GRANT problem
I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. -Ursprungligt meddelande- Från: gerald_clark [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 15:11 Till: Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: Re: SV: GRANT problem What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: SV: SV: GRANT problem
Use 'localhost' as the host unless you are specifying the grant to be for users on another machine. '%' stands for all machines except 'localhost'. I know. And the is exactly what I want. Datatal AB - Gauffin, Jonas wrote: I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. -Ursprungligt meddelande- Från: gerald_clark [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 15:11 Till: Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: Re: SV: GRANT problem What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT problem
Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db. When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD, I get ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) please help -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 09:15 Till: [EMAIL PROTECTED] Ämne: GRANT problem Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
yep. but that does only apply when using INSERT INTO, right? GRANT should do that by itself? anyway, it didn't help. didn't help to restart mysqld either. mysql select * from db where user='datatal'; +--++-+-+-+-+-+-+---++-+++---+--+ | Host | Db | User| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +--++-+-+-+-+-+-+---++-+++---+--+ | %| phonewatch | datatal | Y | Y | Y | Y | N | N | N | N | N | N | N | N| +--++-+-+-+-+-+-+---++-+++---+--+ mysql select * from db where user='datatal'; +--++-+-+-+-+-+-+---++-+++---+--+ | Host | Db | User| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +--++-+-+-+-+-+-+---++-+++---+--+ | %| phonewatch | datatal | Y | Y | Y | Y | N | N | N | N | N | N | N | N| +--++-+-+-+-+-+-+---++-+++---+--+ -Ursprungligt meddelande- Från: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:03 Till: Datatal AB - Gauffin, Jonas Ämne: AW: GRANT problem Hi Jonas, did you send a 'FLUSH PRIVILEGES' after the GRANT-Statement ? If not, MySQL-Srver doesn't read the privileges-Table again. mfg Klaus -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 10:44 Till: [EMAIL PROTECTED] Ämne: SV: GRANT problem Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db. When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD, I get ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) please help -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 09:15 Till: [EMAIL PROTECTED] Ämne: GRANT problem Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tablecrash
Hello
I got a table that crashes everytime that I use delete from
hvd_layout_settings
This is a infinite loop:
while (1)
{
check table hvd_layout_settings = table ok
delete from hvd_layout_settings
check table hvd_layout_settings = table crashed
repair table hvd_layout_settings
}
Im using mysql 4.0.15a.
To whom should I send the table?
//Jonas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: selecting table structure
describe tablename return columns: +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ -Ursprungligt meddelande- Från: Gjoko Jovanovski [mailto:[EMAIL PROTECTED] Skickat: den 22 oktober 2003 15:10 Till: [EMAIL PROTECTED] Ämne: selecting table structure Is there a way to select/query the table structure and get a recordset with the results? Something like: Id, int, not null, autoincrement name, varchar(20), not null Thanks, Gjoko. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table crashes
Hello Some one my tables have crashed (again). I had to repair them ASAP since the db is in my production enviroment. 1. How can I find the cause of the crashes? 2. I've created a my.cnf and added the following lines. Is the format correct? [mysqld] set-variable = myisam-recover=BACKUP,FORCE set-variable = myisam_sort_buffer_size=4M I need to get this going without getting crashes every week, please help. /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: Table crashes
Hello crashes occurs for some reasons like : - unclean tables ( tables are closed improprely), - hardware problems - something goes wrong in the system - know bugs Check that your tables are clean, before start using them. MyODBC 3.51 is the only way that I access the database. (MyODBC is used in a multithreaded server and in InternetInformationServer (asp)) The server is coded in c++ and got a class that acts like a odbc pool (keeps connections open during the lifetime of the server and handles them to threads that requests a db connection) How are tables getting unclean? When are tables closed? Should I disconnect/connect when a thread is handling the dbconnection back to the pool? It seems that you said the REPAIR doesn't occurs after you configuring related variables in the my.cnf file ? Because the daemon will not start when the my.cnf contains any errors (variable names), the format is to be correct. No. I asked if my configuration were correct. I've just added it to my.cnf. Can you indicates what MySQL version you run and your OS version. Win2000 Mysql 4.0.12 (mysqld.exe) MyODBC was an old version (2.x), I've just installed 3.51.06 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
VB: errors
No answers? No suggestions? Surely, someone must have got these errors. -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas Skickat: den 22 september 2003 14:16 Till: [EMAIL PROTECTED] Ämne: errors Hello I often get these errormessages. Why? * X clients is using or hasnt closed the table properly (No clients are using the table.) * found X parts, should be X * table is marked as crash (table stopped working, i need to repair it) Im using mysql-nt 4.0.12 Myodbc 2.x on some systems and myodbc 3.51.x on some. I got a service(win32) that have a odbcpool (singleton) that keeps connections open and hands them to other threads (iocp) when requested. There are also a webserver that access the db through odbc. I've not specified any specific instructions when creating the tables. //Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: errors
Im pretty sure that the server has not been rebooted inproperly. Can there be any other reasons? The errors occur quite often. -Ursprungligt meddelande- Från: Victor Pendleton [mailto:[EMAIL PROTECTED] Skickat: den 23 september 2003 14:26 Till: Datatal AB - Gauffin, Jonas; [EMAIL PROTECTED] Ämne: [iHateSpam] RE: errors Jonas, Are you getting these messages when you run a check tables? These errors can be caused when the database is not `cleanly` shutdown. -Original Message- From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:22 AM To: [EMAIL PROTECTED] Subject: VB: errors No answers? No suggestions? Surely, someone must have got these errors. -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas Skickat: den 22 september 2003 14:16 Till: [EMAIL PROTECTED] Ämne: errors Hello I often get these errormessages. Why? * X clients is using or hasnt closed the table properly (No clients are using the table.) * found X parts, should be X * table is marked as crash (table stopped working, i need to repair it) Im using mysql-nt 4.0.12 Myodbc 2.x on some systems and myodbc 3.51.x on some. I got a service(win32) that have a odbcpool (singleton) that keeps connections open and hands them to other threads (iocp) when requested. There are also a webserver that access the db through odbc. I've not specified any specific instructions when creating the tables. //Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
errors
Hello I often get these errormessages. Why? * X clients is using or hasnt closed the table properly (No clients are using the table.) * found X parts, should be X * table is marked as crash (table stopped working, i need to repair it) Im using mysql-nt 4.0.12 Myodbc 2.x on some systems and myodbc 3.51.x on some. I got a service(win32) that have a odbcpool (singleton) that keeps connections open and hands them to other threads (iocp) when requested. There are also a webserver that access the db through odbc. I've not specified any specific instructions when creating the tables. //Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Duplicate keys?
Hello Have anyone got this error before: ERROR 1062: Duplicate entry '2147483647' for key 1 I get it when I do a simple insert query. The primary key is an auto_increment field and are not specified in the insert. Thanks, Jonas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: Duplicate keys?
No, the last inserted id is just 1051 or something like that.
Must be something else.
Dunno where '2147483647' comes from.
Is there a way to reset the auto_increment value or something?
First, check out with myisamchk if the table isn't crashed.
Then you can use SET INSERT_ID=value (or similar, I don't
remember exactly)
I've used CHECK TABLE, REPAIR TABLE and no errors were reported.
I've used:
mysql SET INSERT_ID=1034;
Query OK, 0 rows affected (0.00 sec)
mysql alter table user_info change column userid userid int not null
auto_increment;
Query OK, 1026 rows affected (0.02 sec)
Records: 1026 Duplicates: 0 Warnings: 0
And then inserting:
mysql insert into user_info (nickname) values('test');
Query OK, 1 row affected (0.00 sec)
mysql insert into user_info (nickname) values('test');
ERROR 1062: Duplicate entry '2147483647' for key 1
And it get's fuckedup again. Why do the counter freakout??
How do I rebuild the indexfile?
I do not have access to the files, only to the consoleutilities (using
shell acount to my isp).
query = nospam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
