RE: Strange behaviour of mysqld after adding/dropping a column
Hello Sinisa, the problem I had was that after I restarted mysqld (after have dropped/added a column) my data was dissapeared. So if you meant this problem I am indeed the right person. How do I apply this patch ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 3:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: > Hello Sinisa, > > have you already found the origin of the problem ? How does the bugs get > fixed -> are they solved in patch releases or are they solved in a next > release of the MySQL server ? > > Kind regards, > Ismaël > Sorry to have lost your e-mail. If that is about BDB , thanks for the test case !! A fix will come in the next 3.23 and 4.0 releases. This is a patch: = sql_table.cc 1.101 vs edited = *** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002 --- edited/sql_table.cc Mon Jul 8 22:05:06 2002 *** *** 1652,1658 VOID(pthread_mutex_unlock(&LOCK_open)); goto err; } ! thd->proc_info="end"; mysql_update_log.write(thd, thd->query,thd->query_length); if (mysql_bin_log.is_open()) --- 1652,1662 VOID(pthread_mutex_unlock(&LOCK_open)); goto err; } ! #ifdef HAVE_BERKELEY_DB ! extern bool berkeley_flush_logs(void); ! if (old_db_type == DB_TYPE_BERKELEY_DB && berkeley_flush_logs()) ! goto err; ! #endif thd->proc_info="end"; mysql_update_log.write(thd, thd->query,thd->query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: > Hello Sinisa, > > have you already found the origin of the problem ? How does the bugs get > fixed -> are they solved in patch releases or are they solved in a next > release of the MySQL server ? > > Kind regards, > Ismaël > Sorry to have lost your e-mail. If that is about BDB , thanks for the test case !! A fix will come in the next 3.23 and 4.0 releases. This is a patch: = sql_table.cc 1.101 vs edited = *** /tmp/sql_table.cc-1.101-460 Mon Feb 11 12:56:48 2002 --- edited/sql_table.cc Mon Jul 8 22:05:06 2002 *** *** 1652,1658 VOID(pthread_mutex_unlock(&LOCK_open)); goto err; } ! thd->proc_info="end"; mysql_update_log.write(thd, thd->query,thd->query_length); if (mysql_bin_log.is_open()) --- 1652,1662 VOID(pthread_mutex_unlock(&LOCK_open)); goto err; } ! #ifdef HAVE_BERKELEY_DB ! extern bool berkeley_flush_logs(void); ! if (old_db_type == DB_TYPE_BERKELEY_DB && berkeley_flush_logs()) ! goto err; ! #endif thd->proc_info="end"; mysql_update_log.write(thd, thd->query,thd->query_length); if (mysql_bin_log.is_open()) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
RE: Strange behaviour of mysqld after adding/dropping a column
Hello Sinisa, have you already found the origin of the problem ? How does the bugs get fixed -> are they solved in patch releases or are they solved in a next release of the MySQL server ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 1:43 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: > Hello Sinisa, > > this has nothing to do with services. I have also tried this without > creating a service and the result is the same. > Normally the services are also stopped automatically when logging of, so I > don't understand why I should stop it manually. Also I have tested this > constantly by stopping and restarting the service without rebooting the PC > (as I described in my bug report), with the same result. So this has nothing > to do with services or with rebooting your PC (this was only how I found the > bug). In my opinion this is a heavily bug, keeping in mind that restarting > mysql after dropping/adding a column messes up your database ! Can you > please check this ? > > Kind regards, > Ismaël Yes, it looks like a bug. We shall inspect that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: > Hello Sinisa, > > this has nothing to do with services. I have also tried this without > creating a service and the result is the same. > Normally the services are also stopped automatically when logging of, so I > don't understand why I should stop it manually. Also I have tested this > constantly by stopping and restarting the service without rebooting the PC > (as I described in my bug report), with the same result. So this has nothing > to do with services or with rebooting your PC (this was only how I found the > bug). In my opinion this is a heavily bug, keeping in mind that restarting > mysql after dropping/adding a column messes up your database ! Can you > please check this ? > > Kind regards, > Ismaël Yes, it looks like a bug. We shall inspect that. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
RE: Strange behaviour of mysqld after adding/dropping a column
Hello Sinisa, this has nothing to do with services. I have also tried this without creating a service and the result is the same. Normally the services are also stopped automatically when logging of, so I don't understand why I should stop it manually. Also I have tested this constantly by stopping and restarting the service without rebooting the PC (as I described in my bug report), with the same result. So this has nothing to do with services or with rebooting your PC (this was only how I found the bug). In my opinion this is a heavily bug, keeping in mind that restarting mysql after dropping/adding a column messes up your database ! Can you please check this ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: > * I have indeed installed MySQL as a service. That's why I use 'net stop > mysql' and 'net start mysql' to start and stop the MySQL server. > > * I have done nothing special before rebooting my PC. The problem doesn't > seem to lay in rebooting the PC, but in stopping andstarting the MySQL > service. Rebooting the PC causes this service to stop and to start. > > Kind regards, > Ismaël Sorry, but this is not reliable enough on any Windows, including W2K. You have to stop a service before re-booting. Only then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
RE: Strange behaviour of mysqld after adding/dropping a column
Cams Ismael writes: > * I have indeed installed MySQL as a service. That's why I use 'net stop > mysql' and 'net start mysql' to start and stop the MySQL server. > > * I have done nothing special before rebooting my PC. The problem doesn't > seem to lay in rebooting the PC, but in stopping andstarting the MySQL > service. Rebooting the PC causes this service to stop and to start. > > Kind regards, > Ismaël Sorry, but this is not reliable enough on any Windows, including W2K. You have to stop a service before re-booting. Only then you will have no problems with MySQL. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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
Re: Strange behaviour of mysqld after adding/dropping a column
Two questions : * have you installed MySQL as a service ?? * have you stopeed a service prior to rebooting ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - 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