Re: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: _ Win98 4.10.98, AMD Duron, 128 MB RAM MySQL 3.23.39 running on localhost _ Query is DELETE FROM staticStrings WHERE ruri LIKE 'staticAnzeigen%' _ Error is Lost connection to MySQL server during query _ -- Herzlich Werner Stuerenburg Hi! The above behavour can be caused by corrupted table. If however, the above DELETE always crashes our latest 3.23.39 binary, you should prepare a repeatable test case and send it to [EMAIL PROTECTED] A complete bug report is done in the following manner: 1) First check the reference manual and the mail archive ! We try very hard to keep the manual up to date so most questions can usually be solved by looking it up. Write in the mail that you have checked the reference manual and mail archive so others know that you have tried to solve the problem yourself. 2) ALWAYS use mysqlbug when posting questions about a MySQL version you are using! mysqlbug is for bug reports AND questions. 3) Send the bug report to the right mailing list. (See http://www.mysql.com/documentation/lists.html). If you are unsure you should use [EMAIL PROTECTED] 4) Include a full example for the problem, including a full test case with all responses/error messages. -- 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[2]: bug report on WinMySQLadmin 1.1
The above behavour can be caused by corrupted table. If however, the above DELETE always crashes our latest 3.23.39 binary, you should prepare a repeatable test case and send it to [EMAIL PROTECTED] Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1 Write in the mail that you have checked the reference manual and mail archive so others know that you have tried to solve the problem yourself. Ok, I'll write that I checked the manual. 2) ALWAYS use mysqlbug when posting questions about a MySQL version you are using! mysqlbug is for bug reports AND questions. Sorry, I looked for it, but I didn't find mysqlbug. 3) Send the bug report to the right mailing list. (See http://www.mysql.com/documentation/lists.html). If you are unsure you should use [EMAIL PROTECTED] The manual says to send it to this list only when using the right format, which I didn't do. Also, which is the list for WinMySQLadmin-bugs? 4) Include a full example for the problem, including a full test case with all responses/error messages. Which is what I did, although I missed that I could have uploaded the table to your site instead of offering it to download from my site - but anyway, you should be able to reproduce the problem. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Re[2]: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: prepare a repeatable test case and send it to [EMAIL PROTECTED] Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. -- 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[4]: bug report on WinMySQLadmin 1.1
The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. True, but WinMySQLAdmin should not crash with a GPF, right? Or is that an expected behaviour, even a feature? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Re[4]: bug report on WinMySQLadmin 1.1
Werner Stuerenburg writes: The error : Server has gone away ... is not WinMySQLAdmin error, but error on the server side. True, but WinMySQLAdmin should not crash with a GPF, right? Or is that an expected behaviour, even a feature? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de No, it should not. So, you should make two bug reports !! -- 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
bug report on WinMySQLadmin 1.1
_ Win98 4.10.98, AMD Duron, 128 MB RAM MySQL 3.23.39 running on localhost _ Query is DELETE FROM staticStrings WHERE ruri LIKE 'staticAnzeigen%' _ Error is Lost connection to MySQL server during query _ WinMySQLadmin crashes with the following message: MYSQLD-OPT verursachte einen Fehler durch eine ungültige Seite in Modul MYSQLD-OPT.EXE bei 017f:0047e56a. Register: EAX= CS=017f EIP=0047e56a EFLGS=00010246 EBX=409f7604 SS=0187 ESP=0178f2d0 EBP=00a8330a ECX= DS=0187 ESI=409f7505 FS=ccff EDX=0001 ES=0187 EDI=009f7f68 GS= Bytes bei CS:EIP: _ isamchk -s ../var/pferdezeitung/staticStrings.ISM C:\mysql\binisamchk -s ..\data\pferdezeitung\staticStrings.ism C:\MYSQL\BIN\ISAMCHK.EXE: ISAM file ..\data\pferdezeitung\staticStrings.ism C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of indexfile is: 13312 Should be : 15360 C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of datafile is: 778515 Should be : 839240 C:\MYSQL\BIN\ISAMCHK.EXE: error: Found key at page 1024 that points to record ou tside datafile C:\MYSQL\BIN\ISAMCHK.EXE: error: Record-count is not ok; is 27 Should be: 28 C:\MYSQL\BIN\ISAMCHK.EXE: warning: Found 28 partsShould be: 29 parts ISAM-table '..\data\pferdezeitung\staticStrings.ism' is corrupted Fix it using switch -r or -o _ -r shows C:\mysql\binisamchk -r ..\data\pferdezeitung\staticStrings.ism - recovering ISAM-table '..\data\pferdezeitung\staticstrings.ism' Data records: 28 - Fixing index 1 - Fixing index 2 Data records: 27 _ in consequence the error is gone and WinMySQLadmin doesn't crash. I uploaded the table files, if you need a superb crashed table. As I didn't have an ftp account and creation of such didn't work as it should, I worked it out as follows: You can get http://art-quarter.com/staticstrings.ism and http://art-quarter.com/staticStrings.frm directly, but http://art-quarter.com/staticstrings.ISD does not work in the browser, so I created http://art-quarter.com/crashedTable.php3 which does not work with IE, but fine with Netscape, so please use that if you need it - I have several complaints about IE and workarounds, but none works for me, so I give up. Hope that helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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