Question about Server Debug Info
Hello List, On two different occasions and on two different servers I have found server debug information written out to the mysqld.log file. Now I know that by issuing the kill -1 mysql-pid will write that information to the mysqld.log file, and by using mysqladmin debug will also write debug information to the mysqld.log file. I am wondering what other methods would write the debug info to the mysqld.log file. On the two servers in question my fellow DBA's nor myself did nothing that would have written debug info. Are there any internal settings or processes that would write debug information to the mysqld.log file? Could a client tool do something like this? We have reviewed the app privileges and the they have no ability to write debug info. Thank you, Walter Wayne Leutwyler, RHCT Sr. MySQL Database Administrator Mobile: 614 519 5672 Office: 614 889 4956 E-mail: wayne.leutwy...@gmail.com E-mail: wleut...@columbus.rr.com Website: http://penguin-workshop.dyndns.org Courage is being scared to death, but saddling up anyway. --John Wayne
Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
Hello friends I'm back to MySQL programming using the C API... it works fine when I compile using the RELEASE mode and C:\Program Files (x86)\MySQL\MySQL Server 5.5\lib but if I choose the DEBUG mode and C:\Program Files (x86)\MySQL\MySQL Server 5.5\lib\debug it fails at link time: 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportFile referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportFile 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportMode referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportMode 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtDumpMemoryLeaks referenced in function _my_end 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtCheckMemory referenced in function _my_end I read some posts that found in google about this error and found that it should be used the dynamic library libmysql instead of the static mysqlclient when debugging, but the lib\debug directory contains just the static library mysqlclient... Do I have to include an aditional library so the symbols are resolved correctly? The release mode works perfect and the application runs fine in that way only... Thanks, Miguel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
On Tue, Jun 19, 2012 at 2:48 AM, Miguel Cardenas renit...@gmail.com wrote: Hello friends 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportFile referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportFile 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportMode referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportMode 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtDumpMemoryLeaks referenced in function _my_end 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtCheckMemory referenced in function _my_end Do I have to include an aditional library so the symbols are resolved correctly? The release mode works perfect and the application runs fine in that way only... The missing functions should be provided by the Visual Studio debug runtime library. Are all source files in your own code compiled and program linked with one, and only one, of the flags /MDd (dynamic linking) or /MTd (static linking)? Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
Miguel.. i do not have VC2010 but as my memory recalls the C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all missing functions *should* be located inside the dll (e.g. __CrtSetReportFile ) can you 1) locate MSVCRT*.dll on your %PATH% 2) dumpbin -exports MSVCRT*.dll Saludos Cordiales (desde EEUU) Martin __ Porfavor no altere esta communicacion..Gracias Date: Tue, 19 Jun 2012 10:24:48 -0400 Subject: Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express From: chamael...@gmail.com To: renit...@gmail.com CC: mysql@lists.mysql.com On Tue, Jun 19, 2012 at 2:48 AM, Miguel Cardenas renit...@gmail.com wrote: Hello friends 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportFile referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportFile 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportMode referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportMode 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtDumpMemoryLeaks referenced in function _my_end 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtCheckMemory referenced in function _my_end Do I have to include an aditional library so the symbols are resolved correctly? The release mode works perfect and the application runs fine in that way only... The missing functions should be provided by the Visual Studio debug runtime library. Are all source files in your own code compiled and program linked with one, and only one, of the flags /MDd (dynamic linking) or /MTd (static linking)? Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
On Tue, Jun 19, 2012 at 10:47 AM, Martin Gainty mgai...@hotmail.com wrote: Miguel.. i do not have VC2010 but as my memory recalls the C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all missing functions *should* be located inside the dll (e.g. __CrtSetReportFile ) can you 1) locate MSVCRT*.dll on your %PATH% 2) dumpbin -exports MSVCRT*.dll The problem is at compile/link-time not run-time dll lookup, so he'll first need to make sure he can link. Once it links, I'd hazard a guess it'll run ok (assuming the program is correct..) Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
Hello Lars After hours of testing different project configurations, finally I was able to compile with debug mode... still pending the test of debugging, but just created the DLL (it was a library that I'm developing) without errors... The configurations I used (VC++ 2010 Express) were: RELEASE: - Runtime: /MT (static threaded) - Library: mysqlclient.lib (...\mysql\lib) - Ignore library: LIBCMTD.lib (without this does not link the release) - Debug: NO RELEASE: - Runtime: /MTd (static threaded debug) - Library: mysqlclient.lib (...\mysql\lib\debug) - Ignore library: empty (now allowed LIBCMTD.lib or does not link the debug) - Debug: YES If I try to use /MD or /MDd does not compile, if it works with /MT(d) will leave it that way XD I'm going to test the debug version (one thing is that compiled and another one that works =) and if get stuck again will post it... Thanks for your response P.D. One last question, is it right to use ...\mysql\lib\debug directory for debug version? or it should be set to ...\mysql\lib in both cases and the linker chooses the right one? If compiling in debug mode it works with both ...\mysql\lib and ...\mysql\lib\debug in DEBUG mode... maybe running the debugger will not work with the lib, still have to test, but at least it compiles with no errors... can you comment something about this? On Tue, Jun 19, 2012 at 2:24 PM, Lars Nilsson chamael...@gmail.com wrote: On Tue, Jun 19, 2012 at 2:48 AM, Miguel Cardenas renit...@gmail.com wrote: Hello friends 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportFile referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportFile 1mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external symbol __CrtSetReportMode referenced in function _DbugExit 1mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external symbol __CrtSetReportMode 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtDumpMemoryLeaks referenced in function _my_end 1mysqlclient.lib(my_init.obj) : error LNK2019: unresolved external symbol __CrtCheckMemory referenced in function _my_end Do I have to include an aditional library so the symbols are resolved correctly? The release mode works perfect and the application runs fine in that way only... The missing functions should be provided by the Visual Studio debug runtime library. Are all source files in your own code compiled and program linked with one, and only one, of the flags /MDd (dynamic linking) or /MTd (static linking)? Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express
On Tue, Jun 19, 2012 at 11:56 AM, Miguel Cardenas renit...@gmail.com wrote: RELEASE: - Runtime: /MT (static threaded) - Library: mysqlclient.lib (...\mysql\lib) - Ignore library: LIBCMTD.lib (without this does not link the release) - Debug: NO RELEASE: - Runtime: /MTd (static threaded debug) - Library: mysqlclient.lib (...\mysql\lib\debug) - Ignore library: empty (now allowed LIBCMTD.lib or does not link the debug) - Debug: YES If I try to use /MD or /MDd does not compile, if it works with /MT(d) will leave it that way XD I'm going to test the debug version (one thing is that compiled and another one that works =) and if get stuck again will post it... Thanks for your response P.D. One last question, is it right to use ...\mysql\lib\debug directory for debug version? or it should be set to ...\mysql\lib in both cases and the linker chooses the right one? If compiling in debug mode it works with both ...\mysql\lib and ...\mysql\lib\debug in DEBUG mode... maybe running the debugger will not work with the lib, still have to test, but at least it compiles with no errors... can you comment something about this? In general, you'd want to ensure every object file and static library linked into your program is compiled with the same runtime library selected /MT[d] or /MD[d], to ensure a proper working environment. If you were to link with libmysql.lib you'd avoid having to match up these flags for this particular library for your own code. Mixing and matching these flags among things linked into a executable or dll is a recipe for a headache on Windows. Regarding your question about the directory, you'd more than likely want to link with the one in the debug directory, I think, to get useful stack traces into library code when debugging. Lars Nilsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: More ways to debug mysql slowness..?
David Taveras wrote: Hello, We have a BSD box with the following installed: mysql-client-5.0.77 multithreaded SQL database (client) mysql-server-5.0.77 multithreaded SQL database (server) p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI php5-mysql-5.2.8mysql database access extensions for php5 We are experiencing intermittent slowdowns on the queries made with PHP to mysql to the point where pages take a lot of time to load, upon further investigation with mytop we observe that it only keep an average of 1-2 simultenaous threads and a query time of avg 2-3 seconds. During which the mysqld process reaches 99% continously for minutes. We have repaired and optimized the tables, and the DB is 200mb. The storage engine is MyISAM. I understand that further optimization can be done to my.cnf , that has been done a lot but with the same results.. andbefore I go to that path again my question is: Iam wondering what other tools exist to load test the mysql daemon, or how to better debug this situation... more tools must exist out there? Perhaps there must be a PHP/DB that I can load... and run a stress test like you would test network issues with speedtest.net just a thought.. I know you dont compare apples to oranges. MySQL databases can be slow for any number of reasons. When I need to attack a performance problem I look for bottlenecks in 4 physical components of the server: CPU, RAM, DISK, NETWORK. If any of those places are overloaded, I then examine the configurable components of MySQL to see how I can reduce/eliminate that overload. Here are the big things I look at: * Table design - Is the data being stored efficiently? Is it properly indexed? * Query design - Is this query written efficiently? Can it use any indexes that are already on the tables? Does it retrieve only the rows and columns that the user actually needs or is it moving a lot of extra data for no good reason? Does it use batch-oriented logic and not procedural SQL? * Server configuration - Is the server configured to remain within the RAM limits of the machine? Are the buffers allocated appropriately for the usage patterns of the storage engines? Can we reduce any hardware contention through setting changes? * Usage patterns - This is not really a server configuration but it *is* the leading cause of slow performance. There are usually many ways to write the same query or to perform the same action. The MySQL server will do exactly what you tell it to do, even if that means performing billions or trillions of comparisons to answer a single query. One very slow (or very greedy) query has the ability to interfere with every other fast query on the machine at that time giving them all the appearance of being slow. Concentrate on the worst offenders, because your problem may be in your USER not the machine. So, you already know that your CPU tops out (99%) when you issue a certain query. This means your query is either doing a lot of computation or a lot of memory manipulation. Look at your query and think to yourself, How would I answer that query if I were the server. Use the EXPLAIN command to show you which indexes, if any, will be used for the query and how many rows it is pulling from each of the source tables. Multiply those row numbers together to get an estimate of how many comparisions the query is trying to compute for you. And finally, know the MySQL manual. It is your best source of information when it comes to understanding or interpreting the information you can collect. I think a nice place to start will be here: http://dev.mysql.com/doc/refman/5.0/en/optimization.html Warmest regards, -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
More ways to debug mysql slowness..?
Hello, We have a BSD box with the following installed: mysql-client-5.0.77 multithreaded SQL database (client) mysql-server-5.0.77 multithreaded SQL database (server) p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI php5-mysql-5.2.8mysql database access extensions for php5 We are experiencing intermittent slowdowns on the queries made with PHP to mysql to the point where pages take a lot of time to load, upon further investigation with mytop we observe that it only keep an average of 1-2 simultenaous threads and a query time of avg 2-3 seconds. During which the mysqld process reaches 99% continously for minutes. We have repaired and optimized the tables, and the DB is 200mb. The storage engine is MyISAM. I understand that further optimization can be done to my.cnf , that has been done a lot but with the same results.. andbefore I go to that path again my question is: Iam wondering what other tools exist to load test the mysql daemon, or how to better debug this situation... more tools must exist out there? Perhaps there must be a PHP/DB that I can load... and run a stress test like you would test network issues with speedtest.net just a thought.. I know you dont compare apples to oranges. Thanks David
Re: More ways to debug mysql slowness..?
David, At 03:28 PM 8/25/2009, David Taveras wrote: Hello, We have a BSD box with the following installed: mysql-client-5.0.77 multithreaded SQL database (client) mysql-server-5.0.77 multithreaded SQL database (server) p5-DBD-mysql-4.010 MySQL drivers for the Perl DBI php5-mysql-5.2.8mysql database access extensions for php5 We are experiencing intermittent slowdowns on the queries made with PHP to mysql to the point where pages take a lot of time to load, upon further investigation with mytop we observe that it only keep an average of 1-2 simultenaous threads and a query time of avg 2-3 seconds. That is extremely slow. Look at your slow query log to see which queries are slow. You can post them here and maybe someone can help you to optimize the query. How much memory does the server have? How large are the tables? During which the mysqld process reaches 99% continously for minutes. We have repaired and optimized the tables, and the DB is 200mb. The storage engine is MyISAM. I understand that further optimization can be done to my.cnf , that has been done a lot but with the same results.. andbefore I go to that path again my question is: Iam wondering what other tools exist to load test the mysql daemon, or how to better debug this situation... more tools must exist out there? Perhaps there must be a PHP/DB that I can load... and run a stress test like you would test network issues with speedtest.net just a thought.. I know you dont compare apples to oranges. Thanks David Take a look at MONyog from http://webyog.com/en/. It will monitor the MySQL server. They have a trial download available. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Re: VC++ 2008 / MySQL debug / Unhandled exception
On Jan 14, 2009 9:40pm, Miguel Cardenas renit...@gmail.com wrote: Hi I'm using /MT (LIBCMT.lib?) and it is multi-threaded since all my multi-thread code is working. LIBCMTD.lib is ignored because it is indicated in a post at MySQL forums http://forums.mysql.com/read.php?45,49606,49606#msg-49606; and anyway applications do not compile if not ignored because lots of duplicated symbols at link time. The issue is like this (as accurate as I remember) according the debugger call stack: 1) Call mysql_real_connect() 2) mysql_real_connect() calls a shared memory request function 3) the shared memory request fails in a internal strcpy() (asm, not source available) because a memory violation trying to acces 0x Note these conditions: - The program fails inside VC++ 2008 express debug session - The program runs perfect without debug session or called directly by user - I'm programming inside VirtualBox/WinXP Now I don't know if this problem is related to the VC++ debugger that fails with certain condition of the MySQL client library or the VirtualBox manages shared memory in a different way than a real computer. I emphasize that my program works perfect with Linux, FreeBSD and Solaris, even Windows if not run in a debug session, and the problem arises inside the MySQL library, not in the MySQL code but inside the shared memory function it calls. I hope this could help to get an idea I suggest you to check bug list if you don't found one than create one. Regards, Miguel
Re: VC++ 2008 / MySQL debug / Unhandled exception
Hi I tested with both release and debug versions and the problem is the same, it fails when calling mysql_real_connect() shared memory request function strcpy() asm code access violation to 0x Regards, Miguel On Sun, Jan 11, 2009 at 9:57 AM, Patrick Sherrill patr...@coconet.comwrote: I seem to recall the issue with the debug library, but don't recall the fix. Do you get the same permissions (access) error with the release library? Pat... - Original Message - From: Miguel Cardenas renit...@gmail.com To: mysql@lists.mysql.com Sent: Saturday, January 10, 2009 10:22 AM Subject: VC++ 2008 / MySQL debug / Unhandled exception Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe: 0xC005: Access violation reading location 0x when it reaches mysql_real_connect() I'm using mysql-6.0.8-alpha-win32 binary with setup.exe installer. Note that I don't try to enter inside mysql functions, even if no breakpoints are setup and I let the program to run freely it aborts there with the unhandled exception. My VC++ 2008 configuration is this: Includes: C:\Program Files\MySQL\MySQL Server 6.0\include Libraries: C:\Program Files\MySQL\MySQL Server 6.0\lib\debug Code generation: Multi-threaded /MT Precompiled headers: NO Aditional dependencies: wsock32.lib mysqlclient.lib libmysql.lib mysys.lib Ignore specific library: (as found in a forum post) LIBCMTD.lib Debugging: YES /DEBUG I based my configuration on this post for VC++ 6.0 http://forums.mysql.com/read.php?45,49606,49606#msg-49606 I guess it may be due to the ignored LIBCMTD.lib (debug version of MT?), but if don't ignore it the compilation fails at link time with lots of redefined symbols. My concrete question: is there something wrong with the configuration shown in that post that I adapted to VC++ 2008? are VC++ programs with MySQL unable to run inside VC++ debugger? I don't want to debut my MySQL code it is working already for *NIX, but there are other parts of the program that may require debug and it aborts when calling a mysql function. Thanks for any comment or help
Re: VC++ 2008 / MySQL debug / Unhandled exception
Hi I'm using /MT (LIBCMT.lib?) and it is multi-threaded since all my multi-thread code is working. LIBCMTD.lib is ignored because it is indicated in a post at MySQL forums http://forums.mysql.com/read.php?45,49606,49606#msg-49606; and anyway applications do not compile if not ignored because lots of duplicated symbols at link time. The issue is like this (as accurate as I remember) according the debugger call stack: 1) Call mysql_real_connect() 2) mysql_real_connect() calls a shared memory request function 3) the shared memory request fails in a internal strcpy() (asm, not source available) because a memory violation trying to acces 0x Note these conditions: - The program fails inside VC++ 2008 express debug session - The program runs perfect without debug session or called directly by user - I'm programming inside VirtualBox/WinXP Now I don't know if this problem is related to the VC++ debugger that fails with certain condition of the MySQL client library or the VirtualBox manages shared memory in a different way than a real computer. I emphasize that my program works perfect with Linux, FreeBSD and Solaris, even Windows if not run in a debug session, and the problem arises inside the MySQL library, not in the MySQL code but inside the shared memory function it calls. I hope this could help to get an idea Regards, Miguel
RE: VC++ 2008 / MySQL debug / Unhandled exception
if Memory serves the LIBCMTD.lib library that you're excluding IS the MultiThreaded Library? Generally if you can run it thru debug you can get the CodeStack and InstructionPointer which will at least point to the exact location where it abended Saludos Cordiales desde EEUU!Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Sun, 11 Jan 2009 12:04:30 +0530 From: saf...@gmail.com To: renit...@gmail.com; mysql@lists.mysql.com Subject: Re: VC++ 2008 / MySQL debug / Unhandled exception Are you sure that VS2008 support Mysql6.0, since mysql 6 is in alpha stage. -- Sharique On 1/10/09, Miguel Cardenas renit...@gmail.com wrote: Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe: 0xC005: Access violation reading location 0x when it reaches mysql_real_connect() I'm using mysql-6.0.8-alpha-win32 binary with setup.exe installer. Note that I don't try to enter inside mysql functions, even if no breakpoints are setup and I let the program to run freely it aborts there with the unhandled exception. My VC++ 2008 configuration is this: Includes: C:\Program Files\MySQL\MySQL Server 6.0\include Libraries: C:\Program Files\MySQL\MySQL Server 6.0\lib\debug Code generation: Multi-threaded /MT Precompiled headers: NO Aditional dependencies: wsock32.lib mysqlclient.lib libmysql.lib mysys.lib Ignore specific library: (as found in a forum post) LIBCMTD.lib Debugging: YES /DEBUG I based my configuration on this post for VC++ 6.0 http://forums.mysql.com/read.php?45,49606,49606#msg-49606 I guess it may be due to the ignored LIBCMTD.lib (debug version of MT?), but if don't ignore it the compilation fails at link time with lots of redefined symbols. My concrete question: is there something wrong with the configuration shown in that post that I adapted to VC++ 2008? are VC++ programs with MySQL unable to run inside VC++ debugger? I don't want to debut my MySQL code it is working already for *NIX, but there are other parts of the program that may require debug and it aborts when calling a mysql function. Thanks for any comment or help-- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ Peace is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009
Re: VC++ 2008 / MySQL debug / Unhandled exception
I seem to recall the issue with the debug library, but don't recall the fix. Do you get the same permissions (access) error with the release library? Pat... - Original Message - From: Miguel Cardenas renit...@gmail.com To: mysql@lists.mysql.com Sent: Saturday, January 10, 2009 10:22 AM Subject: VC++ 2008 / MySQL debug / Unhandled exception Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe: 0xC005: Access violation reading location 0x when it reaches mysql_real_connect() I'm using mysql-6.0.8-alpha-win32 binary with setup.exe installer. Note that I don't try to enter inside mysql functions, even if no breakpoints are setup and I let the program to run freely it aborts there with the unhandled exception. My VC++ 2008 configuration is this: Includes: C:\Program Files\MySQL\MySQL Server 6.0\include Libraries: C:\Program Files\MySQL\MySQL Server 6.0\lib\debug Code generation: Multi-threaded /MT Precompiled headers: NO Aditional dependencies: wsock32.lib mysqlclient.lib libmysql.lib mysys.lib Ignore specific library: (as found in a forum post) LIBCMTD.lib Debugging: YES /DEBUG I based my configuration on this post for VC++ 6.0 http://forums.mysql.com/read.php?45,49606,49606#msg-49606 I guess it may be due to the ignored LIBCMTD.lib (debug version of MT?), but if don't ignore it the compilation fails at link time with lots of redefined symbols. My concrete question: is there something wrong with the configuration shown in that post that I adapted to VC++ 2008? are VC++ programs with MySQL unable to run inside VC++ debugger? I don't want to debut my MySQL code it is working already for *NIX, but there are other parts of the program that may require debug and it aborts when calling a mysql function. Thanks for any comment or help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
VC++ 2008 / MySQL debug / Unhandled exception
Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe: 0xC005: Access violation reading location 0x when it reaches mysql_real_connect() I'm using mysql-6.0.8-alpha-win32 binary with setup.exe installer. Note that I don't try to enter inside mysql functions, even if no breakpoints are setup and I let the program to run freely it aborts there with the unhandled exception. My VC++ 2008 configuration is this: Includes: C:\Program Files\MySQL\MySQL Server 6.0\include Libraries: C:\Program Files\MySQL\MySQL Server 6.0\lib\debug Code generation: Multi-threaded /MT Precompiled headers: NO Aditional dependencies: wsock32.lib mysqlclient.lib libmysql.lib mysys.lib Ignore specific library: (as found in a forum post) LIBCMTD.lib Debugging: YES /DEBUG I based my configuration on this post for VC++ 6.0 http://forums.mysql.com/read.php?45,49606,49606#msg-49606 I guess it may be due to the ignored LIBCMTD.lib (debug version of MT?), but if don't ignore it the compilation fails at link time with lots of redefined symbols. My concrete question: is there something wrong with the configuration shown in that post that I adapted to VC++ 2008? are VC++ programs with MySQL unable to run inside VC++ debugger? I don't want to debut my MySQL code it is working already for *NIX, but there are other parts of the program that may require debug and it aborts when calling a mysql function. Thanks for any comment or help
Re: VC++ 2008 / MySQL debug / Unhandled exception
Are you sure that VS2008 support Mysql6.0, since mysql 6 is in alpha stage. -- Sharique On 1/10/09, Miguel Cardenas renit...@gmail.com wrote: Hello list I have a problem debugging a program that uses MySQL. The program itself does not have problems, it runs perfectly when run in the console (command prompt), but if it is executed inside the Visual C++ 2008 debugger it causes an error: Unhandled exception at 0x004b1560 in MyProgram.exe: 0xC005: Access violation reading location 0x when it reaches mysql_real_connect() I'm using mysql-6.0.8-alpha-win32 binary with setup.exe installer. Note that I don't try to enter inside mysql functions, even if no breakpoints are setup and I let the program to run freely it aborts there with the unhandled exception. My VC++ 2008 configuration is this: Includes: C:\Program Files\MySQL\MySQL Server 6.0\include Libraries: C:\Program Files\MySQL\MySQL Server 6.0\lib\debug Code generation: Multi-threaded /MT Precompiled headers: NO Aditional dependencies: wsock32.lib mysqlclient.lib libmysql.lib mysys.lib Ignore specific library: (as found in a forum post) LIBCMTD.lib Debugging: YES /DEBUG I based my configuration on this post for VC++ 6.0 http://forums.mysql.com/read.php?45,49606,49606#msg-49606 I guess it may be due to the ignored LIBCMTD.lib (debug version of MT?), but if don't ignore it the compilation fails at link time with lots of redefined symbols. My concrete question: is there something wrong with the configuration shown in that post that I adapted to VC++ 2008? are VC++ programs with MySQL unable to run inside VC++ debugger? I don't want to debut my MySQL code it is working already for *NIX, but there are other parts of the program that may require debug and it aborts when calling a mysql function. Thanks for any comment or help -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ Peace is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqld, mysqld-nt, mysqld-debug
Hi. I think you had a mistake for the server types.Mysql-nt.exe is the only exexutable program on windows.So you just pay close attention about it. On Mon, Oct 6, 2008 at 8:35 PM, Steven [EMAIL PROTECTED] wrote: Steve (n) Martin! if you want apache and mysql (and possibly PHP for scripting) AND you want all 3 to run at once then d/l and implement with XAMP there are alot of XAMP specific bells and whistles that are installed that get in the way of tuning your MySQL and tuning your Apache installations so my advice is if you just want to use Mysql standalone dont use XAMP but start mysql with mysqld as suggested Well, that's your opinion. But I think for beginners is XAMPP the best basis. Everything else you can later still wish to change. Once is a fact, I wanted no discussion on the pros and reignite XAMPP. I just wanted to help. ;-) Viel Gluck! Martin Good Luck? What for? Greetings, Steven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: mysqld, mysqld-nt, mysqld-debug
Steve (n) Martin! if you want apache and mysql (and possibly PHP for scripting) AND you want all 3 to run at once then d/l and implement with XAMP there are alot of XAMP specific bells and whistles that are installed that get in the way of tuning your MySQL and tuning your Apache installations so my advice is if you just want to use Mysql standalone dont use XAMP but start mysql with mysqld as suggested Well, that's your opinion. But I think for beginners is XAMPP the best basis. Everything else you can later still wish to change. Once is a fact, I wanted no discussion on the pros and reignite XAMPP. I just wanted to help. ;-) Viel Gluck! Martin Good Luck? What for? Greetings, Steven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld, mysqld-nt, mysqld-debug
Good Morning! 2008/10/5 Varuna Seneviratna [EMAIL PROTECTED]: Hello Everybody 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? That is right! ;-) MySQL as a service should be installed, it starts either automatically or (depending on your attitude) about the services configuration. 3 In Windows is it not possible to start other to two servers mysqld and mysqld-debug You have only to start mysqld. For starting with MySQL, you don't need MySQL-Debug Varuna Greetings from Germany, Steven P.S.: Why you don't use XAMPP? Especially for beginners is the clearly better choice, since much is already preset. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld, mysqld-nt, mysqld-debug
Hello Steven I have installed it as an service, I first stopped the service form the Service Control Manager and I went to the directory C:\Program Files\MySQL\MySQL Server 5.0\bin ran the command mysqld --console. and out put was C:\Program Files\MySQL\MySQL Server 5.0\binmysqld --console 'mysqld' is not recognized as an internal or external command, operable program or batch file. The reference manual says that there are three server types, mysqld ,mysqld-nt, mysqld-debug.My problem is I am able to start mysqld server Varuna On Sun, Oct 5, 2008 at 1:14 PM, Steven [EMAIL PROTECTED] wrote: Good Morning Steven Hello Varuna! Well to start mysqld the reference manual instructs to give the command [C:\ C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console] The out put is as below 'C:\' is not recognized as an internal or external command, operable program or batch file.under the heading Starting the server for the first time It's not practical to install MySQL in the directory Program Files, because the folder name for cmd is too long and it's a little bit tricky. Better structure is the following: C:\MySQL\ So the service to start - Command Prompt (cmd) C: cd /MySQL/ mysqld-- console It is important to the folder where MySQL is. Otherwise it is not my opinion. Greetings, Steven
Re: mysqld, mysqld-nt, mysqld-debug
Varuna, A polite note - if you post the same question 6 times (especially in the space of 24 hours) people are going to be more unlikely to help you. Post the question once, and read people's responses. Now onto your issues... When you run mysqld-nt you were starting a standalone version of MySQL with named pipes support. Once this was running in one command window, you would need another command window with a client connecting to that server. The message you are getting back from Windows is that mysqld doesn't exist in C:\Program Files\MySQL\MySQL Server 5.0\bin. My first step would be to do a search for this binary (Start Search Files or Folders etc.) Secondly there are a number of ways in which MySQL can be installed on a Windows system - how did you do it? Which package did you download? Have you run the configuration wizard? (I don't use MySQL on Windows so I'm reading from the manual.) Have you installed MySQL as a service or as a server? If you've installed as a service, then you shouldn't need to be starting the server manually - just stop and start the service using services.msc. If not, I'd highly recommend reinstalling and doing so. As for users, if you've not assigned the user a password when you created it, that user won't have a password so you don't need the -p option in MySQL client programs. If you haven't created a user, the only user your system will have configured is root. Andy Varuna Seneviratna wrote: Hello Steven I have installed it as an service, I first stopped the service form the Service Control Manager and I went to the directory C:\Program Files\MySQL\MySQL Server 5.0\bin ran the command mysqld --console. and out put was C:\Program Files\MySQL\MySQL Server 5.0\binmysqld --console 'mysqld' is not recognized as an internal or external command, operable program or batch file. The reference manual says that there are three server types, mysqld ,mysqld-nt, mysqld-debug.My problem is I am able to start mysqld server Varuna On Sun, Oct 5, 2008 at 1:14 PM, Steven [EMAIL PROTECTED] wrote: Good Morning Steven Hello Varuna! Well to start mysqld the reference manual instructs to give the command [C:\ C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console] The out put is as below 'C:\' is not recognized as an internal or external command, operable program or batch file.under the heading Starting the server for the first time It's not practical to install MySQL in the directory Program Files, because the folder name for cmd is too long and it's a little bit tricky. Better structure is the following: C:\MySQL\ So the service to start - Command Prompt (cmd) C: cd /MySQL/ mysqld-- console It is important to the folder where MySQL is. Otherwise it is not my opinion. Greetings, Steven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld, mysqld-nt, mysqld-debug
Varuna, Please also remember to copy the list back in to your response so others can follow your steps if they're having trouble. As I said in my e-mail, I would recommend installing as a Windows service (you said in your e-mail that Install as a Windows service was unchecked.) I don't use MySQL on Windows so I cannot be 100% confident, but this might be the reason why the mysqld binary is not installed. You could also try installing the server as a Server Machine, not a Developer Machine. Try these and see if you get any further. Regards, Andy Varuna Seneviratna wrote: Dear Andy I am sorry if I have been nuisance to you by posting six times the same question.I wanted to learn all the three types of the server. I did a search as you have suggested and it didn't return a mysqld binary.But it returned mysqld-nt.What the reference manual says is not true.I again installed and i have listed them below .I have tried choosing the setup type as complete and custom also But the mysqld server can not be started The setUp double clicked and the screen to select the setup type appeared Then as follows 1 SetUp type typical Configuration Wizard 1 Server Type Developer Machine 2 Database Usage Multifunctional Database 3 InnoDB data file drive the default settings was selected Drive C and the installation path 4 Approximate Number Of Connections Decision Support(Dss and OLAP) 5 Networking Options TCP/IP Enabled port number 3306, Add Firewall Exception checked Enabled Strict Mode checked 6 Default character set Standard Character set 7 Windows Options Install as a Windows serviceUnchecked Include Bin Directory in Windows Path Checked *The screen with the execute Button Appeared and When clicked Prepare configuration ticked(Okay) Write Configuration file path(C:\Program Files\MySQL\MySQL Server 5.0\my.ini) ticked(Okay) After above listed installation I went to the bin directory and typed mysqld --console-Nothing happened mysqld-nt --console The output was 081005 19:02:09 InnoDB: Started; log sequence number 0 43655 081005 19:02:09 [Note] mysqld-nt: ready for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) Anyway I will settle with the mysqld-nt and go on with my assignment.Thanks For your help.Iam sorry if I have caused you any inconvenience Thanks Regards Varuna On Sun, Oct 5, 2008 at 3:17 PM, Andy Shellam [EMAIL PROTECTED] wrote: Varuna, A polite note - if you post the same question 6 times (especially in the space of 24 hours) people are going to be more unlikely to help you. Post the question once, and read people's responses. Now onto your issues... When you run mysqld-nt you were starting a standalone version of MySQL with named pipes support. Once this was running in one command window, you would need another command window with a client connecting to that server. The message you are getting back from Windows is that mysqld doesn't exist in C:\Program Files\MySQL\MySQL Server 5.0\bin. My first step would be to do a search for this binary (Start Search Files or Folders etc.) Secondly there are a number of ways in which MySQL can be installed on a Windows system - how did you do it? Which package did you download? Have you run the configuration wizard? (I don't use MySQL on Windows so I'm reading from the manual.) Have you installed MySQL as a service or as a server? If you've installed as a service, then you shouldn't need to be starting the server manually - just stop and start the service using services.msc. If not, I'd highly recommend reinstalling and doing so. As for users, if you've not assigned the user a password when you created it, that user won't have a password so you don't need the -p option in MySQL client programs. If you haven't created a user, the only user your system will have configured is root. Andy Varuna Seneviratna wrote: Hello Steven I have installed it as an service, I first stopped the service form the Service Control Manager and I went to the directory C:\Program Files\MySQL\MySQL Server 5.0\bin ran the command mysqld --console. and out put was C:\Program Files\MySQL\MySQL Server 5.0\binmysqld --console 'mysqld' is not recognized as an internal or external command, operable program or batch file. The reference manual says that there are three server types, mysqld ,mysqld-nt, mysqld-debug.My problem is I am able to start mysqld server Varuna On Sun, Oct 5, 2008 at
Re: mysqld, mysqld-nt, mysqld-debug
Andy! Even Installing as a service and choosing Server Machine as Server type does not install mysqld the settings I used are as follows. I even did a search in the C drive SetUp Type Complete The configuration choices made running Configuration Wizard 1Configuration Type Detailed 2 Server Type Server Machine 3 Database Usage Transactional database only 4 Drive for InnoDB data file InnoDB Tablespace Settings Default Settings(C: Drive and Installation path) 5 Number OF Concurrent Approximate connections Decision Support 6 Networking Options Enable networking options Checked(ticked) Add firewall exception for port 3306 Checked(ticked) Enable strict mode Checked(ticked) 7 Default Charter set Standard Character set 8 Windows Options Install As A Service Checked(ticked) Launch MySQL Server Automaticaly Checked(ticked) Service Name: MySQL Include Bin Directory in Windows path Checked(ticked) 9 Set the security settings A root password set 10 Ready to Execute Screen Execute Button Clicked Preparation configuration Okay Write Configuration file (C:\Program Files\MySQL\MySQL Server 5.0\bin) Okay Start Service Okay Apply security settings Okay Regards Varuna On Sun, Oct 5, 2008 at 9:05 PM, Andy Shellam [EMAIL PROTECTED]wrote: Varuna, Please also remember to copy the list back in to your response so others can follow your steps if they're having trouble. As I said in my e-mail, I would recommend installing as a Windows service (you said in your e-mail that Install as a Windows service was unchecked.) I don't use MySQL on Windows so I cannot be 100% confident, but this might be the reason why the mysqld binary is not installed. You could also try installing the server as a Server Machine, not a Developer Machine. Try these and see if you get any further. Regards, Andy Varuna Seneviratna wrote: Dear Andy I am sorry if I have been nuisance to you by posting six times the same question.I wanted to learn all the three types of the server. I did a search as you have suggested and it didn't return a mysqld binary.But it returned mysqld-nt.What the reference manual says is not true.I again installed and i have listed them below .I have tried choosing the setup type as complete and custom also But the mysqld server can not be started The setUp double clicked and the screen to select the setup type appeared Then as follows 1 SetUp type typical Configuration Wizard 1 Server Type Developer Machine 2 Database Usage Multifunctional Database 3 InnoDB data file drive the default settings was selected Drive C and the installation path 4 Approximate Number Of Connections Decision Support(Dss and OLAP) 5 Networking Options TCP/IP Enabled port number 3306, Add Firewall Exception checked Enabled Strict Mode checked 6 Default character set Standard Character set 7 Windows Options Install as a Windows serviceUnchecked Include Bin Directory in Windows Path Checked *The screen with the execute Button Appeared and When clicked Prepare configuration ticked(Okay) Write Configuration file path(C:\Program Files\MySQL\MySQL Server 5.0\my.ini) ticked(Okay) After above listed installation I went to the bin directory and typed mysqld --console-Nothing happened mysqld-nt --console The output was 081005 19:02:09 InnoDB: Started; log sequence number 0 43655 081005 19:02:09 [Note] mysqld-nt: ready for connections. Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) Anyway I will settle with the mysqld-nt and go on with my assignment.Thanks For your help.Iam sorry if I have caused you any inconvenience Thanks Regards Varuna On Sun, Oct 5, 2008 at 3:17 PM, Andy Shellam [EMAIL PROTECTED] wrote: Varuna, A polite note - if you post the same question 6 times (especially in the space of 24 hours) people are going to be more unlikely to help you. Post the question once, and read people's responses. Now onto your issues... When you run mysqld-nt you were starting a standalone version of MySQL with named pipes support. Once this was running in one command window, you would need another command window with a client connecting to that server. The message you are getting back from Windows is that mysqld doesn't exist in C:\Program Files\MySQL\MySQL Server 5.0\bin. My first step would be to do a search for this binary (Start Search Files or Folders etc.) Secondly there are a number of ways in which MySQL can be installed on a Windows system - how did you do it? Which package did you download? Have you run the configuration wizard? (I don't use MySQL
mysqld, mysqld-nt, mysqld-debug
Hello Everybody 1 In the reference manual there are three server types how can I start the mysqld server? 2 What is the difference between installing MySQL as a server and a service, Is it only that when installed as a service MySQL server starts when Windows starts and when Windows stops it stops? 3 In Windows is it not possible to start other to two servers mysqld and mysqld-debug Varuna
Debug Stored Proc
Is there no way to step thru a stored proc in order to debug it and see what it is doing? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Debug Stored Proc
Hi, Currently there is no way but there is a WorkLog for implementing such a feature, It may be possible to encourage someone to implement such a feature request. Regards, Antony. On 6 May 2008, at 14:58, Bryan Cantwell wrote: Is there no way to step thru a stored proc in order to debug it and see what it is doing? -- 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: mysql - debug connections dropping/not accepted
hi guys - i figured this out, turned out someone or something had applied an overly strict iptables rule best, paul On 1/25/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: You didn't say what your command line looked like - e.g., whether you were selecting a db as part of it. Assuming you were, this sounds like a corrupted db problem. To pinpoint the problem a little, try a: mysqlshow -u ... -p ... as necessary at the command line (with no database specified). I suspect that that will hang as it's trying to run through them all. If it does, then specify a database, one at a time, running through the your list of databases. The one(s) that hang are likely corrupted. If that works, i.e., turns up one db that the show hangs on, but others seem ok, then you can focus recovery/restore options on that database. - Rick Original Message Date: Friday, January 25, 2008 08:07:32 AM -0500 From: Paul Berry [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: mysql - debug connections dropping/not accepted hey guys - overnight our sql server apparantly got hit hard, and started dropping connections it was restarted and now this morning even though its showing 0 processes running, seems completely healthy on all tests, mysqld restarted with no sign of problems - none of the web servers can connect to it. you can also not connect if you log into one of those servers and try the same connect, it quickly asks for the password prompt and then seems to hang forever with out any responses any clues for this? what type of commands should i run to diagnose? i've never seen this one before thanks paul -- End Original Message --
mysql - debug connections dropping/not accepted
hey guys - overnight our sql server apparantly got hit hard, and started dropping connections it was restarted and now this morning even though its showing 0 processes running, seems completely healthy on all tests, mysqld restarted with no sign of problems - none of the web servers can connect to it. you can also not connect if you log into one of those servers and try the same connect, it quickly asks for the password prompt and then seems to hang forever with out any responses any clues for this? what type of commands should i run to diagnose? i've never seen this one before thanks paul
Re: How to debug a mysqldump dropped connection error?
The wait_timeout and interactive_timeout global variables are set to 172800, and max_allowed_packet is set to 30M, and I am still getting the problem I am having debugging a problem I am seeing with mysqldump. While using mysqldump to make backups of my database, I will intermitently get the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux 5.1.20 mysql binaries ( specifically, the Linux non RPM packages ) on a machine with 2 gigs of memory. The error has been seen (so far) in two tables. The first table is a myisam table, which takes up 15 gigs on disk, and has 534858129 rows. The second table is innodb, takes up 1.3 gigs on disk, and has 2055624 rows. The row the timeout error occurs on is always different. The error seems to show up regardless of database usage (sometimes it will show up when we are running intensive queries, other times it will show up when no queries are being run). The log-warnings option is enabled with a value of 2, but nothing shows up in the error log when the timeout occurs. I have set the interactive_timeout setting to a ridiculously high number (172800), but the timeouts still occur. I was experiencing this problem in version 5.1.18, and the upgrade to 5.1.20 has not eliminated the problem. How should I go about debugging this problem? I've created a bug for this problem (where there is more information on the table schema, command line options used with mysqldump, etc) - http://bugs.mysql.com/bug.php?id=30809 -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to debug a mysqldump dropped connection error?
I am having debugging a problem I am seeing with mysqldump. While using mysqldump to make backups of my database, I will intermitently get the following error : mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table I am running the pre-compiled 64 bit linux 5.1.20 mysql binaries ( specifically, the Linux non RPM packages ) on a machine with 2 gigs of memory. The error has been seen (so far) in two tables. The first table is a myisam table, which takes up 15 gigs on disk, and has 534858129 rows. The second table is innodb, takes up 1.3 gigs on disk, and has 2055624 rows. The row the timeout error occurs on is always different. The error seems to show up regardless of database usage (sometimes it will show up when we are running intensive queries, other times it will show up when no queries are being run). The log-warnings option is enabled with a value of 2, but nothing shows up in the error log when the timeout occurs. I have set the interactive_timeout setting to a ridiculously high number (172800), but the timeouts still occur. I was experiencing this problem in version 5.1.18, and the upgrade to 5.1.20 has not eliminated the problem. How should I go about debugging this problem? I've created a bug for this problem (where there is more information on the table schema, command line options used with mysqldump, etc) - http://bugs.mysql.com/bug.php?id=30809 -- Aiton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A question about how to debug the error 2013, 'Lost connection to MySQL server during query'
I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get no corresponding errors in the error log. The question is : how do I go about debugging this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A question about how to debug the error 2013, 'Lost connection to MySQL server during query'
[EMAIL PROTECTED] schrieb: I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get no corresponding errors in the error log. The question is : how do I go about debugging this problem? the most common error in this case is a crash of the thread processing your query -- Sebastian Mendel www.sebastianmendel.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- The Scenario: ~~ We out locked out of our door lock database. The database is Sybase Sql Anywhere version 7.0 The software uses a hard coded DBA password that is *not* the word 'sql' A Maybe Solution: ~~ The software does *not* do a check on it's ODBC DSN to see what type of driver is being used. I can successfully have the software use the MyODBC debug dll which, because it's password is unknown to the MySQL server fails with an authentication error. The debug version version of the shipped MyODBC plugin does not log the password. I need a copy of the MyODBC debug plugin which *WILL* log the password. *** PLEASE HELP US FIX OUR DOOR LOCK SYSTEM! *** ~ Michael Joyner System Administrator / 904-470-8170 Edward Waters College 1658 Kings Road Jacksonville, FL 32209 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
Michael Joyner wrote: (OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- The Scenario: ~~ We out locked out of our door lock database. The database is Sybase Sql Anywhere version 7.0 The software uses a hard coded DBA password that is *not* the word 'sql' A Maybe Solution: ~~ The software does *not* do a check on it's ODBC DSN to see what type of driver is being used. I can successfully have the software use the MyODBC debug dll which, because it's password is unknown to the MySQL server fails with an authentication error. The debug version version of the shipped MyODBC plugin does not log the password. I need a copy of the MyODBC debug plugin which *WILL* log the password. *** PLEASE HELP US FIX OUR DOOR LOCK SYSTEM! *** ~ Michael Joyner System Administrator / 904-470-8170 Edward Waters College 1658 Kings Road Jacksonville, FL 32209 MyODBC does not connect to Sybase. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED
gerald_clark wrote: Michael Joyner wrote: (OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- MyODBC does not connect to Sybase. Correct. Merely trying to use it's debug features to snatch the dba password so that I can get into the db and do a hash replacement on the software's system user so that I can undo the damage caused by a vendor locking us out of the software. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport debug options
Hello Listers, Can anyone explain what are valid values for the 'debug options' on a mysqlimport ? The manuals just say : --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. What is d: ? t: ? o (ok,thats relatively easy but just to be sure...) ? This is mysql Ver 14.12 Distrib 5.0.15, for sun-solaris2.9 (sparc) using readline 5.0 Thanks Pierre - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping
Re: mysqlimport debug options
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/the-dbug-package.html P. Evans wrote: Hello Listers, Can anyone explain what are valid values for the 'debug options' on a mysqlimport ? The manuals just say : --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. What is d: ? t: ? o (ok,thats relatively easy but just to be sure...) ? This is mysql Ver 14.12 Distrib 5.0.15, for sun-solaris2.9 (sparc) using readline 5.0 Thanks Pierre - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
RE: looking for direction on how to debug this message
Hello, I have looked at the two supplied links and still have some more questions These errors I get about every 4 to 10 minutes. I get them from 3 different application servers. If I do this mysqld --debug=d,info,error,query,general,where:O,/tmp/mysqld.trace What kind of info can I expect to see ? In the mysql variables. In 5 days I have 11885 aborted_clients. I assume this is probably pretty high? Thanks for any more help Randy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 3:27 PM To: mysql@lists.mysql.com Subject: Re: looking for direction on how to debug this message See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: Info: DB Server Mysql 4.0.20 Mandrakelinux release 10.1 (Official) for i586 - 2.6.8.1-12mdksmp Application Servers Red Hat Linux release 9 Tomcat 5.0.24 These application servers connect to the DB via Tomcat or by perl scripts In my data directory I have a file called millhouse.unitnet.com.err My main db is unitnet Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: looking for direction on how to debug this message
See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
looking for direction on how to debug this message
Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packets) 050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets) 050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries' host: `local.krusty' (Got an error reading communication packets)
Emergency! How do I debug this?
My web site has always worked, I didn't change anything, so whatever is causing this error happened all by itself: #1017 - Can't find file: './kessler/products.frm' (errno: 13) In phpMyAdmin, it shows the tables are in use and there's no way to execute a repair or anything. I don't know what else to try. Can someone please suggest a next step? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
are there backups of this machine? do you have administrator access? does kessler/products.frm still exist? [likely: /var/lib/mysql/kessler/products.frm] On Sat, 3 Sep 2005, Brian Dunning wrote: My web site has always worked, I didn't change anything, so whatever is causing this error happened all by itself: #1017 - Can't find file: './kessler/products.frm' (errno: 13) In phpMyAdmin, it shows the tables are in use and there's no way to execute a repair or anything. I don't know what else to try. Can someone please suggest a next step? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
what portal software is this? google pulls up many instances of this error from several 'different' servers, you might lookinto the software. http://www.google.com/search?num=50hl=enlr=lang_ensafe=offq=%27kessler%2Fproducts.frm%27btnG=Searchlr= it could be that the permissions are wrong, too. On Sat, 3 Sep 2005, Jason Pyeron wrote: are there backups of this machine? do you have administrator access? does kessler/products.frm still exist? [likely: /var/lib/mysql/kessler/products.frm] On Sat, 3 Sep 2005, Brian Dunning wrote: My web site has always worked, I didn't change anything, so whatever is causing this error happened all by itself: #1017 - Can't find file: './kessler/products.frm' (errno: 13) In phpMyAdmin, it shows the tables are in use and there's no way to execute a repair or anything. I don't know what else to try. Can someone please suggest a next step? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
There are no backups, unfortunately. I do have admin access. It's a RaQ if that makes any difference. I did find the database files at another location, /vol/hdd/mysql/kessler/products.frm and everything else. On Sep 3, 2005, at 1:24 PM, Jason Pyeron wrote: are there backups of this machine? do you have administrator access? does kessler/products.frm still exist? [likely: /var/lib/mysql/ kessler/products.frm] On Sat, 3 Sep 2005, Brian Dunning wrote: My web site has always worked, I didn't change anything, so whatever is causing this error happened all by itself: #1017 - Can't find file: './kessler/products.frm' (errno: 13) In phpMyAdmin, it shows the tables are in use and there's no way to execute a repair or anything. I don't know what else to try. Can someone please suggest a next step? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- 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]
Re: Emergency! How do I debug this?
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote: google pulls up many instances of this error from several 'different' servers, you might lookinto the software. http://www.google.com/search?num=50hl=enlr=lang_ensafe=offq=% 27kessler%2Fproducts.frm%27btnG=Searchlr= The reason for that is a web service (with minimal error checking) running on my problem server, called from a number of other servers, which are all now displaying the error... :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote: it could be that the permissions are wrong, too. The permissions for all the files in there are -rwxrwxr-x ...I don't know if that's what they should be or not. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
all the parent dirs +x ? what is the ouput is the show databases? On Sat, 3 Sep 2005, Brian Dunning wrote: On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote: it could be that the permissions are wrong, too. The permissions for all the files in there are -rwxrwxr-x ...I don't know if that's what they should be or not. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
FIXED... I did a chmod +rwx on the directory, and now all is well. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Emergency! How do I debug this?
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote: google pulls up many instances of this error from several 'different' servers, you might lookinto the software. http://www.google.com/search?num=50hl=enlr=lang_ensafe=offq=% 27kessler%2Fproducts.frm%27btnG=Searchlr= The reason for that is a web service (with minimal error checking) running on my problem server, called from a number of other servers, which are all now displaying the error... :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem using debug switch with mysqlimport
Hello. I've submitted a bug: http://bugs.mysql.com/7137 Sure enough... I just installed the latest 4.1 linux binaries, I didn't realize that the server itself had to be compiled with the debug enabled (although now that I realize that it makes complete sense). It would be nice if the documentation for mysqlimport would at least make note of this. Thanks for the response.Settles, Aaron [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
mysqldump + debug option not working
Hi, I am running MySQL (4.0.15 max log) mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug, --debug = 'd:t:o,debug.log' , -# ='d:t:o:debug.log' My net aim is to write the debug log to an output file (debug.log in above example). Whichever option I use above, I am unable to generate the debug log. Am I missing something very obvious?? TIA Manoj -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump + debug option not working
At 11:19 +0900 12/13/04, ManojSW wrote: Hi, I am running MySQL (4.0.15 max log) mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug, --debug = 'd:t:o,debug.log' , -# ='d:t:o:debug.log' My net aim is to write the debug log to an output file (debug.log in above example). Whichever option I use above, I am unable to generate the debug log. Am I missing something very obvious?? Was MySQL compiled with debugging support? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump + debug option not working
I am not sure. I installed it from an RPM version long time back (not sure if that RPM was compilied with debugging support). Is there anyway to check If I am running a debugging supported version?? Apologies if this is a FAQ. Manoj - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: ManojSW [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 13, 2004 11:29 AM Subject: Re: mysqldump + debug option not working At 11:19 +0900 12/13/04, ManojSW wrote: Hi, I am running MySQL (4.0.15 max log) mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug, --debug = 'd:t:o,debug.log' , -# ='d:t:o:debug.log' My net aim is to write the debug log to an output file (debug.log in above example). Whichever option I use above, I am unable to generate the debug log. Am I missing something very obvious?? Was MySQL compiled with debugging support? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump + debug option not working
Got it. I did a mysql --help and saw that debug-info is set to FALSE...so I need to compile MySQL with debugging support. Thanks for all the help!! Cheers Manoj - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: ManojSW [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 13, 2004 11:29 AM Subject: Re: mysqldump + debug option not working At 11:19 +0900 12/13/04, ManojSW wrote: Hi, I am running MySQL (4.0.15 max log) mysqldump (version 9.09 Distrib 4.0.16) on Linux platform. For some strange reasons, I am unable to use the debug option with mysqldump. I have tried the following switch with no luck: -# , --debug, --debug = 'd:t:o,debug.log' , -# ='d:t:o:debug.log' My net aim is to write the debug log to an output file (debug.log in above example). Whichever option I use above, I am unable to generate the debug log. Am I missing something very obvious?? Was MySQL compiled with debugging support? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem using debug switch with mysqlimport
Sure enough... I just installed the latest 4.1 linux binaries, I didn't realize that the server itself had to be compiled with the debug enabled (although now that I realize that it makes complete sense). It would be nice if the documentation for mysqlimport would at least make note of this. Thanks for the response.
Re: Problem using debug switch with mysqlimport
Hello. Check that your MySQL installation was compiled with debug support: mysqld --help If the --debug flag is listed with the options then you have debugging enabled. mysqladmin ver also lists the mysqld version as mysql ... --debug in this case. I'm trying to utilize the debug switch with mysqlimport so that I can figure out why I'm getting errors on the data I'm importing, but I have yet to figure out a way to do this. I've tried to read the sparse documentation concerning this feature and no debug file is ever produced. I've tried using it as indicated by the mysqlimport --help documentation such as: /usr/local/mysql/bin/mysqlimport --debug=d:t:o,mysql.dbg -uuser -ppassword --local database import_file As well as many variations of this. I've been unable to locate through Google or anything else anyone who has successfully utilized this feature. Does anyone out there have any input? Thanks. Aaron Settles, Aaron [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Problem using debug switch with mysqlimport
I'm trying to utilize the debug switch with mysqlimport so that I can figure out why I'm getting errors on the data I'm importing, but I have yet to figure out a way to do this. I've tried to read the sparse documentation concerning this feature and no debug file is ever produced. I've tried using it as indicated by the mysqlimport --help documentation such as: /usr/local/mysql/bin/mysqlimport --debug=d:t:o,mysql.dbg -uuser -ppassword --local database import_file As well as many variations of this. I've been unable to locate through Google or anything else anyone who has successfully utilized this feature. Does anyone out there have any input? Thanks. Aaron
Help with --with-debug
Hello This is probably real simple for someone that knows - I'm having a few problems installing MySQL on a particular server (it's repairing a damaged copy). I'd like to try and fix it myself so I'm recompiling with the --with-debug option. If I manage to fix the problem, is there any overhead of having MySQL built with --with-debug? Or should I eventually recompile without --with-debug when the server is put into production? Thankyou in advance- Jo _ Smart Saving with ING Direct earn 5.25% p.a. variable rate: http://ad.au.doubleclick.net/clk;7249209;8842331;n?http://www.ingdirect.com.au/burst6offer.asp?id=8 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: debug
On 06/30/2004 02:46 PM Andrew Pattison spoke: The way I do this is within PHP is to echo the value stored in mysql_error after each SQL statement. If you're not using PHP then this probably doesn't help though ;-) I'm not using PHP. I'm loading tons of data with SQL statements from the command line. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
debug
I'm running a ton of sql statements to load data. Is there a way to not display successes: Query OK, 1 row affected (0.02 sec) Records: 1 Duplicates: 0 Warnings: 0 and display failures and the query statement that failed? There are 60 000+ of these and I'd ideally like to debug the inserts without actually doing them. It fails on duplicate keys but I have no idea where the data is flawed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: debug
The way I do this is within PHP is to echo the value stored in mysql_error after each SQL statement. If you're not using PHP then this probably doesn't help though ;-) Cheers Andrew. - Original Message - From: Bob Lockie [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 3:38 PM Subject: debug I'm running a ton of sql statements to load data. Is there a way to not display successes: Query OK, 1 row affected (0.02 sec) Records: 1 Duplicates: 0 Warnings: 0 and display failures and the query statement that failed? There are 60 000+ of these and I'd ideally like to debug the inserts without actually doing them. It fails on duplicate keys but I have no idea where the data is flawed. -- 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: MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost
Marvin Cummings [EMAIL PROTECTED] wrote: I'm not actually getting an error. I'm simply unable to access any of my databases while logged in as [EMAIL PROTECTED] I'd like to change this and specify what account is used to establish a connection. How and where do I make this change in MySQL? ODBC is default username that is used on Windows. Create a new user account and use it to connect to the MySQL server: http://dev.mysql.com/doc/mysql/en/Adding_users.html -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 10:22 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5.0.0-alpha-max-debug running on localhost as [EMAIL PROTECTED] Marvin Cummings [EMAIL PROTECTED] wrote: This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I can log in to MySQLCC and the command line as root without a problem. What error do you get? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
RE: MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost
I'm not actually getting an error. I'm simply unable to access any of my databases while logged in as [EMAIL PROTECTED] I'd like to change this and specify what account is used to establish a connection. How and where do I make this change in MySQL? Thanks -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 10:22 AM To: [EMAIL PROTECTED] Subject: Re: MySQL 5.0.0-alpha-max-debug running on localhost as [EMAIL PROTECTED] Marvin Cummings [EMAIL PROTECTED] wrote: This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I can log in to MySQLCC and the command line as root without a problem. What error do you get? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
Re: MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost
Marvin Cummings [EMAIL PROTECTED] wrote: This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I can log in to MySQLCC and the command line as root without a problem. What error do you get? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 5.0.0-alpha-max-debug running on localhost as ODBC@localhost
This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I can log in to MySQLCC and the command line as root without a problem. Thanks
RE: Debug options for mysqlimport?
Good question - mysqlimport seems to work siliently and not report any errors. I had read that this was to be improved in 4 - has it ?? appreciate answers Thomas -Original Message- From: Greg G [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 15:22 To: [EMAIL PROTECTED] Subject: Debug options for mysqlimport? I'm having a tough time with the debug options for mysqlimport. I've check the docs, but they're as clear as mud. I've tried a number of combinations of -#d:t:o,filename and everything else I can think of, but I can't get any debug information. What I'm really looking for is to get the text of warnings that were generated during and import. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] * This email and any attachments are confidential and intended for the sole use of the intended recipient(s).If you receive this email in error please notify [EMAIL PROTECTED] and delete it from your system. Any unauthorized dissemination, retransmission, or copying of this email and any attachments is prohibited. Euroconex does not accept any responsibility for any breach of confidence, which may arise from the use of email. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the Company. This message has been scanned for known computer viruses. * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Debug options for mysqlimport?
I'm having a tough time with the debug options for mysqlimport. I've check the docs, but they're as clear as mud. I've tried a number of combinations of -#d:t:o,filename and everything else I can think of, but I can't get any debug information. What I'm really looking for is to get the text of warnings that were generated during and import. -Greg G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: --with-debug option
# uname -X System = SCO_SV Node = scospare Release = 3.2v5.0.6 KernelID = 2000-07-27 Machine = PentII(D) BusType = ISA Serial = 3IG004365 Users = 5-user OEM# = 0 Origin# = 1 NumCPU = 1 # Stefaan Van Dooren .--. Technical Support |o_o | Kompas Automatisering |:_/ | // \ \ Tel : +32 3 2350084(| | ) Fax : +32 3 2359792 /'\_ _/`\ Email : [EMAIL PROTECTED] \___)=(___/ -Original Message- From: Boyd Gerber [mailto:[EMAIL PROTECTED] Sent: dinsdag 25 november 2003 5:45 To: Stefaan Van Dooren Cc: [EMAIL PROTECTED] Subject: Re: --with-debug option On Tue, 25 Nov 2003, Stefaan Van Dooren wrote: Can anyone tell me what this option does, besides adding debug information ? When I add this option, I get a working mysqld server. When I remove it and recompile, my server won't work anymore It does a lot of things. With MySQL-4.0.16 is also aids in debug information for some malloc's issues for eample. This also gets around a OS bug that depends on your patches to the OS. Please provide a uname -X that would be helpful. Good Luck, Boyd Gerber [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]
--with-debug option
Hi, Can anyone tell me what this option does, besides adding debug information ? When I add this option, I get a working mysqld server. When I remove it and recompile, my server won't work anymore It looks like the server is started (hostname.err), but no pid file is created MySQL : 4.0.16 OS : SCO Openserver 5.0.6 Stefaan Van Dooren .--. Technical Support |o_o | Kompas Automatisering |:_/ | // \ \ Tel : +32 3 2350084(| | ) Fax : +32 3 2359792 /'\_ _/`\ Email : [EMAIL PROTECTED] \___)=(___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: --with-debug option
On Tue, 25 Nov 2003, Stefaan Van Dooren wrote: Can anyone tell me what this option does, besides adding debug information ? When I add this option, I get a working mysqld server. When I remove it and recompile, my server won't work anymore It does a lot of things. With MySQL-4.0.16 is also aids in debug information for some malloc's issues for eample. This also gets around a OS bug that depends on your patches to the OS. Please provide a uname -X that would be helpful. Good Luck, Boyd Gerber [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to debug mysql command hang?
The database is working fine, by the mysql command hangs indefinitely. Any thoughts how I can determine the cause? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is 4.0.15-max-debug
Arthur Maloney [EMAIL PROTECTED] wrote: I have recently reformatted my hard disk and done a clean install of 4.0.15 on Win 2k Pro SP4. I used C:\ C:\mysql\bin\ mysqld --install This created a mySQL service and it works ok. I happened look at a log in the data folder and noticed 031007 9:37:53 InnoDB: Started MySql: ready for connections. Version: '4.0.15-max-debug' socket: '' port: 3306 Since I asked for the standard server mysqld What is max-debug and where did it come from? Look at the manual: http://www.mysql.com/doc/en/Windows_prepare_environment.html You can find here: mysqld Compiled with full debugging and automatic memory allocation checking, symbolic links, InnoDB, and BDB tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
What is 4.0.15-max-debug
Dear All I have recently reformatted my hard disk and done a clean install of 4.0.15 on Win 2k Pro SP4. I used C:\ C:\mysql\bin\ mysqld --install This created a mySQL service and it works ok. I happened look at a log in the data folder and noticed 031007 9:37:53 InnoDB: Started MySql: ready for connections. Version: '4.0.15-max-debug' socket: '' port: 3306 Since I asked for the standard server mysqld What is max-debug and where did it come from? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
Hello programmers this is my path, C:\mysql\binpath PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\mysql\bin After installing 4.1.0-alpha-max-debug I try to start winmysqladmin.exe Then I get this error, === Die dynamic link library libmysql.dll wurde nicht im angegebenen Pfad C:\mysql\bin;.; C:\WINNT\System32; C:\WINNT\System; C:\WINNT; C:\WINNT\System32; C:\WINNT; C:\WINNT\System32\Wbem; C:\mysql\bin Gefunden. === However I found it in C:Mysql\lib\debug And C:Mysql\lib\opt What can I do, please ? I think my path identifier is correct, I simply appended the last ;C:\mysql\bin entry myself and it run fine under 4.1 beta. Also with support for InnoDB tables. In english the error means that winmysqladmin.exe can't run under 4.0.1 alpha, unfortunately Is this true ? When is final release of 4.1.0 scheduled please ? I highly appreciate and thank you all eternally for Enabling nested selects like SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop) Which is pure SQL-99 I think, and compatible with oracle sql. And finally I'd like to know what is support for named pipes? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
At 16:06 4/8/2003 +0200, Morten Gulbrandsen wrote: Hi, Just copy c:\mysql\lib\opt\libmysql.dll into the c:\mysql\bin directory. When is final release of 4.1.0 scheduled please ? I highly appreciate and thank you all eternally for Enabling nested selects like SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop) Which is pure SQL-99 I think, and compatible with oracle sql. And finally I'd like to know what is support for named pipes? Yours Sincerely Morten Gulbrandsen -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL compiletime errors with --with-debug=full
Hello, I am trying to report a bug, and I would like to compile mysql with debugging enabled to provide further information, but I receive compile errors. I would like to resolve the compile errors before I report the possible bug I have discovered. I am running FreeBSD 4.8, and I attempt to compile mysql-4.0.13 with the following configure command: ./configure --with-vio --with-openssl --with-debug=full (the initial bug I wanted to report is related to openssl so compiling with the ssl and vio options is essential). I then try running 'make' but I get a lot of undefined reference errors - so I have piped the STDOUT and STDERR to a file available for download at: http://www.no1.com.au/~adamc/makeoutput.txt hoping that someone with more C/C++ knowledge than myself can offer some insight. Thanks in advance, Adam Carmichael Network Operations Manager email: [EMAIL PROTECTED] web: http://www.no1.com.au icq: 2207644 #1 Computer Services, Empowerment Through Internet Communications.
Re: MySQL compiletime errors with --with-debug=full
Hi! On Jul 20, Adam Carmichael wrote: Hello, I am trying to report a bug, and I would like to compile mysql with debugging enabled to provide further information, but I receive compile errors. I would like to resolve the compile errors before I report the possible bug I have discovered. I am running FreeBSD 4.8, and I attempt to compile mysql-4.0.13 with the following configure command: ./configure --with-vio --with-openssl --with-debug=full (the initial bug I wanted to report is related to openssl so compiling with the ssl and vio options is essential). I then try running 'make' but I get a lot of undefined reference errors - so I have piped the STDOUT and STDERR to a file available for download at: http://www.no1.com.au/~adamc/makeoutput.txt hoping that someone with more C/C++ knowledge than myself can offer some insight. Are you sure you compiled mysys/ with -DSAFE_MUTEX ? safe_mutex* symbols are defined in mysys/thr_mutex.c Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL compiletime errors with --with-debug=full
Worked like a charm! Thank you very much Sergei! :) Adam - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Adam Carmichael [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 10:04 PM Subject: Re: MySQL compiletime errors with --with-debug=full Hi! On Jul 20, Adam Carmichael wrote: Hello, I am trying to report a bug, and I would like to compile mysql with debugging enabled to provide further information, but I receive compile errors. I would like to resolve the compile errors before I report the possible bug I have discovered. I am running FreeBSD 4.8, and I attempt to compile mysql-4.0.13 with the following configure command: ./configure --with-vio --with-openssl --with-debug=full (the initial bug I wanted to report is related to openssl so compiling with the ssl and vio options is essential). I then try running 'make' but I get a lot of undefined reference errors - so I have piped the STDOUT and STDERR to a file available for download at: http://www.no1.com.au/~adamc/makeoutput.txt hoping that someone with more C/C++ knowledge than myself can offer some insight. Are you sure you compiled mysys/ with -DSAFE_MUTEX ? safe_mutex* symbols are defined in mysys/thr_mutex.c Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlserver debug
Hi, Does anyone succeed to run embedded mySQL application (libmysqlserver) built in Debug. I got RtlHeapValidate exception on any mysql calls which allocates and free some memory. Crash appears in: -- cut --- void my_no_flags_free(gptr ptr) { DBUG_ENTER(my_free); DBUG_PRINT(my,(ptr: %lx,ptr)); if (ptr) free(ptr); ! DBUG_VOID_RETURN; } /* my_free */ --- It's appears only in Debug mode, Release work fine. Any ideas? Yura - 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
make of mysql 3.23.37 --with-debug fails on AIX 4.3.3 with xlc_r/xlC_r compiler
Summary: On AIX 4.3.3, using xlc_r/xlC_r compiler, configured with --with-debug, make all in client directory fails with: ld: 0711-317 ERROR: Undefined symbol: ._db_enter_ ld: 0711-317 ERROR: Undefined symbol: ._db_return_ ld: 0711-317 ERROR: Undefined symbol: _db_on_ ld: 0711-317 ERROR: Undefined symbol: ._db_pargs_ ld: 0711-317 ERROR: Undefined symbol: ._db_doprnt_ ld: 0711-317 ERROR: Undefined symbol: _db_process_ ld: 0711-317 ERROR: Undefined symbol: ._db_push_ MySql 3.23.37 source distribution Machine: IBM RS/6000 % uname -M IBM,7044-170 OS: 4.3.3 % oslevel -r 4330-09 VisualAge C++ C Compiler 5.0 I modified include/*global.h to comment out #define _AIX32_CURSES. I run: CC=xlc_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 \ CXX=xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 \ CFLAGS=-DHAVE_GETHOSTBYNAME_R_RETURN_INT \ LDFLAGS=-L/usr/local/lib \ CPPFLAGS=$CFLAGS \ CXXFLAGS=$CFLAGS \ ./configure --prefix=$INSTALL_PATH \ --libexecdir=$INSTALL_PATH/bin \ --datadir=$INSTALL_PATH/etc \ --with-unix-socket-path=$INSTALL_PATH/bin/.ardbd.sock \ --program-transform-name='s/mysql/ardb/g' \ --with-debug \ --without-docs \ --without-bench \ --enable-thread-safe-client \ --enable-large-files /usr/bin/make all In the client directory, make fails with: /bin/sh ../libtool --mode=link xlC_r -ma -O3 -qstrict -qoptimize=3 -qmax mem=8192 -g -O -DSAFE_MUTEX -DHAVE_GETHOSTBYNAME_R_RETURN_INT -Wa,-many -DUND EF_HAVE_INITGROUPS -L/usr/local/lib -o mysql mysql.o readline.o sql_string.o co mpletion_hash.o ../readline/libreadline.a -lcurses ../libmysql/libmysqlclient.la -lcrypt -lm mkdir .libs xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 -g -O -DSAFE_MUTEX -DHAVE_GETH OSTBYNAME_R_RETURN_INT -Wa,-many -DUNDEF_HAVE_INITGROUPS -L/usr/local/lib -o .li bs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadli ne.a -lcurses -L../libmysql/.libs -lmysqlclient -lcrypt -lm -lcrypt -lm -b nolib path -b libpath:/mysql/3.23.37/lib/mysql:/usr/lib:/lib ld: 0711-224 WARNING: Duplicate symbol: p_xargc ld: 0711-224 WARNING: Duplicate symbol: p_xargv ld: 0711-224 WARNING: Duplicate symbol: p_xrcfg ld: 0711-224 WARNING: Duplicate symbol: p_xrc ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information. ld: 0711-317 ERROR: Undefined symbol: ._db_enter_ ld: 0711-317 ERROR: Undefined symbol: ._db_return_ ld: 0711-317 ERROR: Undefined symbol: _db_on_ ld: 0711-317 ERROR: Undefined symbol: ._db_pargs_ ld: 0711-317 ERROR: Undefined symbol: ._db_doprnt_ ld: 0711-317 ERROR: Undefined symbol: _db_process_ ld: 0711-317 ERROR: Undefined symbol: ._db_push_ make: 1254-004 The error code from the last command is 8. It looks like ld is not finding dbug.o, which then needs int2str.c Any suggestions on what needs to be changed? More system information: Fileset Level State Description bos.adt.base 4.3.3.75CBase Application Development Toolkit bos.adt.data 4.3.0.0CBase Application Development Toolkit Data bos.adt.debug 4.3.3.75CBase Application Development Debuggers bos.adt.include 4.3.3.78CBase Application Development Include Files bos.adt.lib 4.3.3.10CBase Application Development Libraries bos.adt.libm 4.3.3.50CBase Application Development Math Library bos.adt.prof 4.3.3.80CBase Profiling Support bos.adt.samples 4.3.3.75CBase Operating System Samples bos.adt.syscalls 4.3.3.50CSystem Calls Application Development Toolkit bos.adt.utils 4.3.3.50CBase Application Development Utilities - lex and yacc bos.net.nfs.adt 4.3.3.25CNetwork File System Development Toolkit bos.rte 4.3.3.75CBase Operating System Runtime bos.rte.Dt 4.3.0.0CDesktop Integrator bos.rte.ILS 4.3.3.75CInternational Language Support bos.rte.SRC 4.3.3.75CSystem Resource Controller bos.rte.X114.3.0.0CAIXwindows Device Support bos.rte.aio 4.3.3.75CAsynchronous I/O Extension bos.rte.archive 4.3.3.75CArchive Commands bos.rte.bind_cmds 4.3.3.75CBinder and Loader Commands bos.rte.boot 4.3.3.75CBoot Commands bos.rte.bosinst 4.3.3.75CBase OS Install Commands bos.rte.commands 4.3.3.75CCommands bos.rte.compare 4.3.3.75CFile Compare
how to use checker to debug mysql applications
Hi! mysql == mysql-return-103913-monty mysql mysql-return-103913-monty writes: mysql Hi, mysql is there any way to debug a c-programm that uses the mysql c-api? I want mysql to use checker for memleak checking but it seems to be impossible to mysql compile the mysql client libraries using checker. The reason seems to be mysql some assembly language parts. All other libraries I need compile. mysql Did anybody hack up some stubs to use checker for mysql applications? mysql Best regards, mysql Carsten Hammer If you compile a debug version of the MySQL client library, you get the following features: - An internal memleak checker for MySQL client allocations - The DBUG package, which enables you to check most function calls and arguments to the MySQL library + more. You can find more information about the above in the manual section 'Debugging a MySQL client' In theory MySQL should work perfectly with any memleak package. (It works at least with purify). If you have problems, please write a full bug report about your compile problems to [EMAIL PROTECTED] and we will try to help you with this. cut Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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
how to use checker to debug mysql applications
Hi, is there any way to debug a c-programm that uses the mysql c-api? I want to use checker for memleak checking but it seems to be impossible to compile the mysql client libraries using checker. The reason seems to be some assembly language parts. All other libraries I need compile. Did anybody hack up some stubs to use checker for mysql applications? Best regards, Carsten Hammer PS: This is pointer to mysql http://www.mysql.com, for checker there seems to be no URL, I use debian. There is a package for it available. What the readme contains is only Tristans email address: [EMAIL PROTECTED] - 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: Invalid Argument ??? Not sure how to debug this
Try ... If ($result = ...) { ... ... } else echo(mysql_error()); I always do querying like this anyway (without the error echo in live stuff obviously) Tim Ward Internet Chess www.chessish.com http://www.chessish.com -- From: Daniel Negron/KBE [SMTP:[EMAIL PROTECTED]] Sent: 17 March 2002 08:38 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Invalid Argument ??? Not sure how to debug this Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |--- --| | Warning: Supplied argument is not a valid MySQL result resource in C:\My Documents\My | | Webs\php\TMPibtpit3zq0.php on line 12 | |--- --| Line 12 happens to be the WHILE statement. I am not sure if it is the while statement or the results its looking for. TIA So far, i havent been able to sleep atleast until I get this. html ? if (isset($searchstring)) { $db = mysql_connect(localhost,webuser,); mysql_select_db(cd_collection,$db); $sql= SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%' ORDER BY artist ASC; $result = mysql_query($sql,$db); echo TABLE BORDER=2; echo trtdbArtist/btdbTitle/btdbOptions/b/tr; while ($myrow = mysql_fetch_array($result)) { echo trtd.$myrow[artist].td.$myrow[title]; echo tda href=\edit.php?id=.$myrow[cd_id]. \View/a; } echo /TABLE; } else { ? form method=POST action=? $PHP_SELF ? table border=2 cellspacing=2 trtdInsert Your Search String Here./td tdSearch Type/td/tr tr tdinput type=text name=searchstring size=28/td tdselect size=1 name=searchtype option selected value=artistArtist/option option value=titleTitle/option option value=categoryCategory/option /select/td /tr /table pinput type = submit value=Submit name=B1 input type=reset value=Reset/p /form ? } ? /html **DAN** - 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
Invalid Argument ??? Not sure how to debug this
Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |-| | Warning: Supplied argument is not a valid MySQL result resource in C:\My |Documents\My | | Webs\php\TMPibtpit3zq0.php on line 12 | | |-| Line 12 happens to be the WHILE statement. I am not sure if it is the while statement or the results its looking for. TIA So far, i havent been able to sleep atleast until I get this. html ? if (isset($searchstring)) { $db = mysql_connect(localhost,webuser,); mysql_select_db(cd_collection,$db); $sql= SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%' ORDER BY artist ASC; $result = mysql_query($sql,$db); echo TABLE BORDER=2; echo trtdbArtist/btdbTitle/btdbOptions/b/tr; while ($myrow = mysql_fetch_array($result)) { echo trtd.$myrow[artist].td.$myrow[title]; echo tda href=\edit.php?id=.$myrow[cd_id]. \View/a; } echo /TABLE; } else { ? form method=POST action=? $PHP_SELF ? table border=2 cellspacing=2 trtdInsert Your Search String Here./td tdSearch Type/td/tr tr tdinput type=text name=searchstring size=28/td tdselect size=1 name=searchtype option selected value=artistArtist/option option value=titleTitle/option option value=categoryCategory/option /select/td /tr /table pinput type = submit value=Submit name=B1 input type=reset value=Reset/p /form ? } ? /html **DAN** - 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: [PHP] Invalid Argument ??? Not sure how to debug this
On Sunday 17 March 2002 16:38, Daniel Negron/KBE wrote: Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |-- |---| Warning: Supplied argument is not a valid MySQL result | resource in C:\My Documents\My | Webs\php\TMPibtpit3zq0.php on line 12 | | | - || Line 12 happens to be the WHILE statement. I am not sure if it is the while statement or the results its looking for. Put in some error checking code when you use the mysql functions as per the manual examples and you'll soon find where the error is. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I'm having an emotional outburst!! */ - 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: [PHP] Invalid Argument ??? Not sure how to debug this
On Sun, 17 Mar 2002, Daniel Negron/KBE wrote: $sql= SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%' ORDER BY artist ASC; How about: SELECT * FROM cd_list WHERE searchstring LIKE '%{$searchstring}%' Then again, do you actually have a column called searchstring in your table? In any case, the way you had it didn't seem to make much sense unless you wanted to search a user-supplied column for a string that literally contained the string searchstring. miguel - 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
Where is Win32 binary NON-debug 3.23.39 ? Debug builds much slower ?
I'd rather not fire up Viz C just to build MySQL 3.23.39 NON-DEBUG. Is there much of a performance difference between DEBUG NON-DEBUG ? Also with the Windows binary builds how does one NOT use MySQL MAX, is that a runtime option or do you need a different build entirely ? Is there much of a performance difference between MAX regular MySQL ? - Sam. - Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
OUTFILE ownership under mysqld 3.23.36-debug
Ok, this is confusing me. Under FreeBSD 4.2 and MySQL 3.23.36-debug: The mysqld process is not running as root, but as 'mysqld:mysqld'. bmdb2# ps -orgid,ruid,command -eww -p 46884 RGID RUID COMMAND 6724 6724 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld/db/mojo log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --log-update=/var/mysqld/log/bmdb2 The 'RGID RUID' is the real (as opposed to 'effective') GID and UID of the process. Then there's the environment. Then the arguments to the server itself. (You may not that I'm not using /etc/my.cnf to configure the server; I prefer to see the arguments.) Also, the server was lauched outright as UID mysqld, so I'm not using '--user'. The user 'mysqld' has it's own group, and that's the only group it's in: bmdb2# id mysqld uid=6724(mysqld) gid=6724(mysqld) groups=6724(mysqld) Yet, somehow, an SQL command such as this: select username from user limit 5 into outfile '/var/tmp/mysqld/sample'; creates a file with the 'wheel' group: bmdb2# ls -ld /var/tmp/mysqld/sample -rw-rw-rw- 1 mysqld wheel 65 Apr 10 19:36 /var/tmp/mysqld/sample I have no idea how a non-root process can set a different group than it's own. I can't find any suid/sgid code in the installed MySQL code. Does anyone have any insight on this? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
logging doesnt work with bdb if --with-debug
Description: oliver After several sig 11 I compliled a --with-debug version and enabled oliver debugging and logging. Mysqld crashed shortly after starting without oliver trace (!) and then immediatly crashed again after restart. oliver /sw/pkg/mysqldebug/3.23.36/libexec/mysqld: ready for connections oliver mysqld got signal 11; oliver The manual section 'Debugging a MySQL server' tells you how to use a oliver stack trace and/or the core file to produce a readable backtrace that may oliver help in finding out why mysqld died. oliver 010407 20:37:48 mysqld restarted oliver __db_assert: "( logp-dbentry[i].dblist)-tqh_first == ( dbp)" failed: file "../.././bdb/dist/../log/log_rec.c", line 433 oliver 010407 20:37:48 mysqld ended How-To-Repeat: oliver Compile mysql with --with-debug and --with-berkeley-db, use bdb tables oliver and run mysqld with --debug --log Fix: oliver Dont do that :/ Actually, the above problem has nothing to do with debugging. The problem is that you have got something bad in the BDB log files, which BDB because of some strange reason can't resolve. Fix: Remove all filed of type 'log.xxx' from the MySQL data directory and restart MySQL. If you get this problem again, then where is what you should try to do: - Dump all BDB tables to text files. - close down mysqld - Remove all log files of the above format - Move all BDB tables to some secure place (as a backup) - Restart mysqld - Read back the BDB tables. If you get a crash, make a copy of log files and the bdb tables and contact us; We will help you make a bug report that we can send to the Berkeley DB people to help sort this out; They are very dedicated in trying to find and fix any bugs in their recovery code. Regards, Monty - 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