need help urgent
How to retrieve data from three consecutive tuples until th end of the database.Such that suppose the field name is ID and I want to retrieve data from another field LAT such that at a time LAT values for ID's 1,2,3 are taken then for 3,4,5 then for 4,5,6 so on till table ends. -- View this message in context: http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 Sent from the MySQL - General mailing list archive at Nabble.com.
Re: need help urgent
Hi Rakaha, You have a cursor , select id from table_name and then have a loop where in you select values of LTA for each id got from the above cursor, close the loop once all the ID have been processed. regards anandk On 3/30/07, raksha [EMAIL PROTECTED] wrote: How to retrieve data from three consecutive tuples until th end of the database.Such that suppose the field name is ID and I want to retrieve data from another field LAT such that at a time LAT values for ID's 1,2,3 are taken then for 3,4,5 then for 4,5,6 so on till table ends. -- View this message in context: http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 Sent from the MySQL - General mailing list archive at Nabble.com.
Re: need help urgent
Or you could also do this. SELECT LTA FROM TABLE A WHERE ID IN (SELECT B.ID FROM TABLE B); i hope this what your looking at, please let us know. regards anandkl On 3/30/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Rakaha, You have a cursor , select id from table_name and then have a loop where in you select values of LTA for each id got from the above cursor, close the loop once all the ID have been processed. regards anandk On 3/30/07, raksha [EMAIL PROTECTED] wrote: How to retrieve data from three consecutive tuples until th end of the database.Such that suppose the field name is ID and I want to retrieve data from another field LAT such that at a time LAT values for ID's 1,2,3 are taken then for 3,4,5 then for 4,5,6 so on till table ends. -- View this message in context: http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 Sent from the MySQL - General mailing list archive at Nabble.comhttp://nabble.com/ .
InnoDB Crash RECOVERY HELP (Urgent)
Dear all, our DB server crashed and when I try to start Mysql /etc/init.d/mysql/start I get these lins in my error log 060921 13:00:14 mysqld started 060921 13:00:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060921 13:00:14 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 3546172175. InnoDB: Error: tried to read 65536 bytes at offset 0 2173440. InnoDB: Was only able to read 54784. InnoDB: Fatal error: cannot read from file. OS error number 17. 060921 13:01:24InnoDB: Assertion failure in thread 3086943936 in file os0file.c line 2107 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=536866816 max_used_connections=0 max_connections=550 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2094947 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbffe3d4c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x814cbfb 0x8d28b8 0x1 0x8355aed 0x835c659 0x835ce73 0x829ba01 0x81d3af3 0x81c5cb2 0x815028a 0x773e33 0x80e0c71 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 060921 13:01:24 mysqld ended when I add skip-innodb in my.cnf, it startsup but my innodb tables could not be accessed. How can I start MySQL server again? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get Firefox! /a
Re: InnoDB Crash RECOVERY HELP (Urgent)
The error message says to go to http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn how to set the different recovery options for innodb. On 9/21/06, Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] wrote: Dear all, our DB server crashed and when I try to start Mysql /etc/init.d/mysql/start I get these lins in my error log 060921 13:00:14 mysqld started 060921 13:00:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060921 13:00:14 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 3546172175. InnoDB: Error: tried to read 65536 bytes at offset 0 2173440. InnoDB: Was only able to read 54784. InnoDB: Fatal error: cannot read from file. OS error number 17. 060921 13:01:24InnoDB: Assertion failure in thread 3086943936 in file os0file.c line 2107 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=536866816 max_used_connections=0 max_connections=550 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2094947 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbffe3d4c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x814cbfb 0x8d28b8 0x1 0x8355aed 0x835c659 0x835ce73 0x829ba01 0x81d3af3 0x81c5cb2 0x815028a 0x773e33 0x80e0c71 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 060921 13:01:24 mysqld ended when I add skip-innodb in my.cnf, it startsup but my innodb tables could not be accessed. How can I start MySQL server again? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get Firefox! /a -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need Update Query Help (Urgent)
Hi i ahve one table table_1 and columns like col_1,col_2,col_3 col_1 col_2 col_3 1 aa aaa 2 bb Now i want to update my table table_1 SET col_3 as bbb where max of col_1 I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = (SELECT max(col_1) FROM table_1) -- Thanks Regards, veerabhadrarao narra, +91-988-556-5556 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need Update Query Help (Urgent)
On Monday 20 February 2006 03:27, Veerabhadrarao Narra wrote: Hi i ahve one table table_1 and columns like col_1,col_2,col_3 col_1 col_2 col_3 1 aa aaa 2 bb Now i want to update my table table_1 SET col_3 as bbb where max of col_1 I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = (SELECT max(col_1) FROM table_1) It appears that you can't do what you want. This is at the bottom of the UPDATE syntax page: Currently, you cannot update a table and select from the same table in a subquery. http://dev.mysql.com/doc/refman/5.0/en/update.html However, you can to something like: select @maximum_column :=max(col_1) from table_1; UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = @maximum_column; Perhaps someone else has a better solution. -- Jeff Shapiro listserv only address -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need Update Query Help (Urgent)
I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = (SELECT max(col_1) FROM table_1) See the docs for Update at http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to the update table in a subquery. PB - Veerabhadrarao Narra wrote: Hi i ahve one table table_1 and columns like col_1,col_2,col_3 col_1 col_2 col_3 1 aa aaa 2 bb Now i want to update my table table_1 SET col_3 as bbb where max of col_1 I wrote this below Query but it shows error how to write UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = (SELECT max(col_1) FROM table_1) -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.11/264 - Release Date: 2/17/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help urgent please
-- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help urgent please
-- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname dbname.sql also do man mysqldump or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help urgent please
One thing Jim didn't mention is that mysqldump is not a mysql client command but a standalone executable. Run it from a shell prompt (DOS prompt if you are using windows) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jim Grill [EMAIL PROTECTED] wrote on 09/09/2004 11:47:55 AM: -- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname dbname.sql also do man mysqldump or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....
hi, I wish to provide some more information too regarding MySQL Server hangup. Once after I execute the C sample program, WinMySQLAdmin tool and query commands from *mysql* console never responds. During this time if I try to start mysqld from another console produce the following error message; C:\mysqld --debug Can't start server: Bind on TCP/IP port: No error 040223 19:18:22 Do you already have another mysqld server running on port: 3306? 040223 19:18:22 Aborting 040223 19:18:23 mysqld: Shutdown Complete What could make the server become inactive or hangup while executing Client C API functions. thank you Expecting your valuable reply. regards, Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full. --- Michael Widenius [EMAIL PROTECTED] wrote: hi! A == Arunachalam [EMAIL PROTECTED] writes: A As per my searching I have found the right C API in libmysql.lib from A MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) A C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), A mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing this as we make more often releases for 4.1 than for 5.0 (until 4.1 is production ready). I didn't find the API's what I have specified above in MySQL 4.1.1 in *libmysql.dll*, but those API's are provided by *mysqlclient.lib* in this version. I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* becaz libmysql is Dynamic Access Library - right. (what I have did to convert libmysql.dll file into COBOL compiler specific *libmysql.lib* is by using an utility *pexports.exe*, i have convert given libmysql.dll into libmysql.def file then by using LIB.EXE of COBOL compiler convert libmysql.def into libmysql.lib file.) A I have installed MySQL 5.0.0-alpha for Windows and I have properly linked A thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing A mechanism to the API routines i have taken the sample C code from MySQL A manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) A When I compiled this sample coding using VC++, it ask for *typelib.h* header A file, it is not given with insatllation pack, under the Mysql folder A (C:/MySQL/Include), I have searched on the net and include it accordingly. Thanks for notifying us about this. typelib.h should be included in the MySQL folder and we will do that for next MySQL windows release. (4.1.2) A After that i have made changes in some variable names becaz of it follows A other header files variable name as such. What changes did you have to make ? Including typelib.h should be enough. When I try to first compile this program in VC++ it notify the mismatch variable as MYSQL_BINDbind[3]; which is already used by winsock.h header file, so I have change this variable into *Pbind* like this. (I have doubt: after your discussion i once again compiled it with previous name(i.e, bind) it never produce any error). The variable mysql used in other API's to be changed to *mysql*, I have changed this after meeting the following errors; D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(58) : warning C4024: 'mysql_prepare' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(62) : error C2115: 'function' : incompatible types I will ask our windows team to verify that the example works ok with VC++ A Upon all the changes I can able to execute succcessfully the coding and it A does the function properly on the MySQL server database. A The PROBLEM I met is, Once this sample code executed and inserted data to A the Database the server get's hanged - why??? After the discussion with you only i came to listen mysqld.trace, but it's content cann't be understand by me, herewith I have attached that file for your reference. anyhow i understand that there is some Memory alloca/dealloc problem hangs up my MySQL server. This shouldn't happen. Can you please describe exactly what you mean with a 'hang' ? - Does the connection in your test program stop respoding ? Yes, if I run the client C program again, the console ouput stay blank with out any
Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....
hi, I have created the COBOL coding to test those C API from MySQL. Upon executing this COBOL program too hangup the server but here using mysql_error() I got the error message in a variable as *Can't open shared memory. Request event don't create (2)* These Error I captured after running the Prepared statement mysql_prepare() when executing mysql_bind_param(). What does this error mean to say I missed to quote the memory usage error when I try the mysqld from console once after the server hangup when running C program is C:\mysqld --debug Can't start server: Bind on TCP/IP port: No error 040223 19:18:22 Do you already have another mysqld server running on port: 3306? 040223 19:18:22 Aborting 040223 19:18:23 mysqld: Shutdown Complete Maximum memory usage: 20726 bytes (21k) Is i need to make changes in *my.ini* for the memory buffers? Pls reply with detail Thanks Arun. --- Arunachalam [EMAIL PROTECTED] wrote: hi, I wish to provide some more information too regarding MySQL Server hangup. Once after I execute the C sample program, WinMySQLAdmin tool and query commands from *mysql* console never responds. During this time if I try to start mysqld from another console produce the following error message; C:\mysqld --debug Can't start server: Bind on TCP/IP port: No error 040223 19:18:22 Do you already have another mysqld server running on port: 3306? 040223 19:18:22 Aborting 040223 19:18:23 mysqld: Shutdown Complete What could make the server become inactive or hangup while executing Client C API functions. thank you Expecting your valuable reply. regards, Arun. --- Arunachalam [EMAIL PROTECTED] wrote: Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full. --- Michael Widenius [EMAIL PROTECTED] wrote: hi! A == Arunachalam [EMAIL PROTECTED] writes: A As per my searching I have found the right C API in libmysql.lib from A MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) A C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), A mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing this as we make more often releases for 4.1 than for 5.0 (until 4.1 is production ready). I didn't find the API's what I have specified above in MySQL 4.1.1 in *libmysql.dll*, but those API's are provided by *mysqlclient.lib* in this version. I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* becaz libmysql is Dynamic Access Library - right. (what I have did to convert libmysql.dll file into COBOL compiler specific *libmysql.lib* is by using an utility *pexports.exe*, i have convert given libmysql.dll into libmysql.def file then by using LIB.EXE of COBOL compiler convert libmysql.def into libmysql.lib file.) A I have installed MySQL 5.0.0-alpha for Windows and I have properly linked A thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing A mechanism to the API routines i have taken the sample C code from MySQL A manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) A When I compiled this sample coding using VC++, it ask for *typelib.h* header A file, it is not given with insatllation pack, under the Mysql folder A (C:/MySQL/Include), I have searched on the net and include it accordingly. Thanks for notifying us about this. typelib.h should be included in the MySQL folder and we will do that for next MySQL windows release. (4.1.2) A After that i have made changes in some variable names becaz of it follows A other header files variable name as such. What changes did you have to make ? Including typelib.h should be enough. When I try to first compile this program in VC++ it notify the mismatch variable as MYSQL_BINDbind[3]; which is already used by winsock.h header file, so I have change this variable into *Pbind* like this. (I have doubt: after your discussion i once again compiled it with previous name(i.e, bind) it never produce any error). The variable mysql used in other API's to be changed to *mysql*, I have changed this after meeting the following errors; D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types
Re: Urgent: Prepared Statements C API hangup the Server - Help Urgent....
Hi, I have written in intermediate, on the appropriate position in this discussion, please go thru in full. --- Michael Widenius [EMAIL PROTECTED] wrote: hi! A == Arunachalam [EMAIL PROTECTED] writes: A As per my searching I have found the right C API in libmysql.lib from A MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) A C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), A mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing this as we make more often releases for 4.1 than for 5.0 (until 4.1 is production ready). I didn't find the API's what I have specified above in MySQL 4.1.1 in *libmysql.dll*, but those API's are provided by *mysqlclient.lib* in this version. I have created COBOL specific *libmysql.lib* from existing *libmysql.dll* becaz libmysql is Dynamic Access Library - right. (what I have did to convert libmysql.dll file into COBOL compiler specific *libmysql.lib* is by using an utility *pexports.exe*, i have convert given libmysql.dll into libmysql.def file then by using LIB.EXE of COBOL compiler convert libmysql.def into libmysql.lib file.) A I have installed MySQL 5.0.0-alpha for Windows and I have properly linked A thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing A mechanism to the API routines i have taken the sample C code from MySQL A manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) A When I compiled this sample coding using VC++, it ask for *typelib.h* header A file, it is not given with insatllation pack, under the Mysql folder A (C:/MySQL/Include), I have searched on the net and include it accordingly. Thanks for notifying us about this. typelib.h should be included in the MySQL folder and we will do that for next MySQL windows release. (4.1.2) A After that i have made changes in some variable names becaz of it follows A other header files variable name as such. What changes did you have to make ? Including typelib.h should be enough. When I try to first compile this program in VC++ it notify the mismatch variable as MYSQL_BINDbind[3]; which is already used by winsock.h header file, so I have change this variable into *Pbind* like this. (I have doubt: after your discussion i once again compiled it with previous name(i.e, bind) it never produce any error). The variable mysql used in other API's to be changed to *mysql*, I have changed this after meeting the following errors; D:\vcprojects\mysql\src\source.c(41) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(41) : warning C4024: 'mysql_query' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(44) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(44) : warning C4024: 'mysql_error' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(48) : error C2115: 'function' : incompatible types D:\vcprojects\mysql\src\source.c(58) : warning C4024: 'mysql_prepare' : different types for formal and actual parameter 1 D:\vcprojects\mysql\src\source.c(62) : error C2115: 'function' : incompatible types I will ask our windows team to verify that the example works ok with VC++ A Upon all the changes I can able to execute succcessfully the coding and it A does the function properly on the MySQL server database. A The PROBLEM I met is, Once this sample code executed and inserted data to A the Database the server get's hanged - why??? After the discussion with you only i came to listen mysqld.trace, but it's content cann't be understand by me, herewith I have attached that file for your reference. anyhow i understand that there is some Memory alloca/dealloc problem hangs up my MySQL server. This shouldn't happen. Can you please describe exactly what you mean with a 'hang' ? - Does the connection in your test program stop respoding ? Yes, if I run the client C program again, the console ouput stay blank with out any message. - Can you connect to mysqld with other clients ? No, WinMySQLAdmin tool won't allow me to right click on it mysql -u user -ppass also stay as such when i try it from console - Does the MySQL server take all cpu No, I can work with other application with out any trouble. I hope I have given here enough information to identify my trouble, suggest me in detail ASAP please... Thanks a lot... Regards, Arun. Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent: Prepared Statements C API hangup the Server - Help Urgent....
hi! A == Arunachalam [EMAIL PROTECTED] writes: A Hai MySQLians!!! A I have established the Successful Connection to MySQL from COBOL. A Now from COBOL I can able to query the MySQL and get back the A result sets using C APIs under MySQL 4.0.17-max both in windows A and Linux. Note that my Client is in Windows platform... A Its not enough for my application, I'm in need to use Prepared statements A for further SQL processing... A As per my searching I have found the right C API in libmysql.lib from A MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) A C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), A mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... You should probablty use MySQL 4.1 instead of MySQL 5.0 for testing this as we make more often releases for 4.1 than for 5.0 (until 4.1 is production ready). A I have installed MySQL 5.0.0-alpha for Windows and I have properly linked A thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing A mechanism to the API routines i have taken the sample C code from MySQL A manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) A When I compiled this sample coding using VC++, it ask for *typelib.h* header A file, it is not given with insatllation pack, under the Mysql folder A (C:/MySQL/Include), I have searched on the net and include it accordingly. Thanks for notifying us about this. typelib.h should be included in the MySQL folder and we will do that for next MySQL windows release. (4.1.2) A After that i have made changes in some variable names becaz of it follows A other header files variable name as such. What changes did you have to make ? Including typelib.h should be enough. I will ask our windows team to verify that the example works ok with VC++ A Upon all the changes I can able to execute succcessfully the coding and it A does the function properly on the MySQL server database. A The PROBLEM I met is, Once this sample code executed and inserted data to A the Database the server get's hanged - why??? This shouldn't happen. Can you please describe exactly what you mean with a 'hang' ? - Does the connection in your test program stop respoding ? - Can you connect to mysqld with other clients ? - Does the MySQL server take all cpu In the tests directory of the MySQL source tree there is a test program 'client_test' that shows in detail how to use prepared statements with MySQL. A (Note that If I didn't run this coding or my COBOL coding the Server remain A function properly) A Kindly suggest me the solution or quote me the things i forgot to do... In the released 5.0 server there is some known bugs in the prepared statement handling for some specific prepared statements. We have fixed these bugs in 4.1.2 which should be available quite soon (we are just now closing the last open bugs in 4.1 to be able to make a new release ASAP). To get any problems you have fixed, you could try to make a standalone test case in C that we could try to repeate. Another option is to follow the instructions in the MySQL manual of how to debug MySQL and give us a stack trace of where mysqld is hanging. Another option is to use the debug version of mysqld and start it with --debug. The trace file that is written (in C:\ or /tmp) should give us a good idea of where the bug could be. Regards, Monty -- Michael Widenius [EMAIL PROTECTED] MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent: Prepared Statements C API hangup the Server - Help Urgent....
Hai MySQLians!!! I have established the Successful Connection to MySQL from COBOL. Now from COBOL I can able to query the MySQL and get back the result sets using C APIs under MySQL 4.0.17-max both in windows and Linux. Note that my Client is in Windows platform... Its not enough for my application, I'm in need to use Prepared statements for further SQL processing... As per my searching I have found the right C API in libmysql.lib from MySQL 5.0.0, (i have doubt: Is any eariler version 4.0.xx provides this???) C API routines are: mysql_prepare(), mysql_bind_param(), mysql_execute(), mysql_stmt_affected_rows(), mysql_fetch(), mysql_stmt_close()... I have installed MySQL 5.0.0-alpha for Windows and I have properly linked thelibmysql.lib into my COBOL compiler... To verify the Parameter Passing mechanism to the API routines i have taken the sample C code from MySQL manual (URL: * http://www.mysql.com/doc/en/mysql_execute.html * ) When I compiled this sample coding using VC++, it ask for *typelib.h* header file, it is not given with insatllation pack, under the Mysql folder (C:/MySQL/Include), I have searched on the net and include it accordingly. After that i have made changes in some variable names becaz of it follows other header files variable name as such. Upon all the changes I can able to execute succcessfully the coding and it does the function properly on the MySQL server database. The PROBLEM I met is, Once this sample code executed and inserted data to the Database the server get's hanged - why??? (Note that If I didn't run this coding or my COBOL coding the Server remain function properly) Kindly suggest me the solution or quote me the things i forgot to do... Thanks in advance Arun. Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL. Pls help. urgent
Hi, I would like to enquire abt Result datatype in MySql++. After getting songList, Result songList=dac.getSong(); 1. Is it possible for me to get a specific record out? 2. Is it possible for me to get a random record out? Regards, Petty_folly _ Download Norah Jones, Eminem and more! http://www.msn.com.sg/ringtones/ - 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
Help! Urgent!
Hi folks i am in a bit of a panic. My server began playing up today and after ruling out apache and php it has come down to mysql. I need to find out what queries the database is running that is making it so slow. I can't figure out the command to use and what format it shoudl be in Thanks for any Help John Wards SportNetwork.net - 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: Help! Urgent!
On Tue, 13 Aug 2002, John Wards wrote: Hi folks i am in a bit of a panic. My server began playing up today and after ruling out apache and php it has come down to mysql. I need to find out what queries the database is running that is making it so slow. I can't figure out the command to use and what format it shoudl be in What about: mysqladmin processlist or mysqladmin status or mysqladmin variables Regards, Thomas - 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
mysql help !! urgent
Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - 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: mysql help !! urgent
mysqld --skip-grant-tables -Original Message- From: Jesse Angell [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 3:38 AM To: [EMAIL PROTECTED] Subject: mysql help !! urgent Hello, In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do anything as phpmyadmin wont work because root can't do anything at all... I have complete ssh access etc to the server, Please help me out what do i do to give root full privs again?!? please help me make mysql work again as I really need it. -- Jesse Angell PalaceUnlimited.com #1 Palace Host - 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 - 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
Help Urgent!!!
Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the following error: Got error 127 from table handler. There is an error too if I format my PC and reinstall all over again. So, can I know what is going on? Can you me and give me instruction to overcome this problem. Thanks. From Eugene
Re: Help Urgent!!!
Eugene wrote: Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the following error: Got error 127 from table handler. There is an error too if I format my PC and reinstall all over again. So, can I know what is going on? Can you me and give me instruction to overcome this problem. Thanks. That means that the table has crashed. Repair it with command: repair table dbname; -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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: help (urgent!!!) with a query(SOLVED!!)
hi people this is the correct syntax: delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day) now() the function to be used is outside the parenthesis, the column name inside; this way mysql applies the function to the column (using the specified parameters interval... compares it to the current date now() and then deletes the field if the where statement is true; thanks to jamie from the php list for pointing me in the right direction regards; At 03:56 13/08/01, you wrote: dont ya have to specify what to delete? delete * from TABLE where TIMESTAMP='date, interval 3 day' I'm new to this as well but I think this might be closer let me know the answer -C - Original Message - From: hassan el forkani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 12, 2001 5:47 PM Subject: help (urgent!!!) with a query hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... mysql version :3.23.33 server error : syntax error near'(date, interval 3 day)... regards - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
help (urgent!!!) with a query
hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... mysql version :3.23.33 server error : syntax error near'(date, interval 3 day)... regards - 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: help (urgent!!!) with a query
On 13-Aug-2001 hassan el forkani wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... mysql version :3.23.33 server error : syntax error near'(date, interval 3 day)... DELETE FROM da_table WHERE da_date DATE_SUB(current_date, INTERVAL 3 DAY); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - 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: help (urgent!!!) with a query
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani [EMAIL PROTECTED] wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but couldn't find a working answer, date functions are only explained for select queries... I believe that should TIMESTAMP_COLUMN(curdate(), interval 3 day) now() Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: help-urgent
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single database 10 tables wiht recorde in 20,000 will this create problem) I have set max connections as 150. looking for your help in this regards.it will be helpful for me if you reply me ASAP with regardds Rajesh _ http://cinesouth.com - The best for entertainment in South India - 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 - 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: help-urgent
Hello ramamurthy, rr hi, rr We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single rr database 10 tables wiht recorde in 20,000 will this create problem) rr I have set max connections as 150. rr looking for your help in this regards.it will be helpful for me if you reply me ASAP Are you running MySQL over Linux, Windoze??? If it's Linux, you sould check system logs, free disk space, etc. (/var for example) If it's Windoze, God save you!!! ;-) As Gerald proposed, give more tech info about system. Good luck, -- Roberto - 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: MySql - JSP - Please help - URGENT
Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=pas sword"); Try with: Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor d"); === Saludos, Enric Badia SONRIE, LAS COSAS NO OCURREN POR CASUALIDAD. - S O N R I Eweb : http://www.sonrie.com Pompeyo, 4e-mail: [EMAIL PROTECTED] 25006 Lleida Tel : +34 973 725 093 Spain Fax : +34 973 725 281 - - 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
MySql - JSP - Please help - URGENT
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1 and for database connection i use mm.mysql.jdbc-1.2c Here is my problem I have got MySql to run fine but when i try to interfaec it over the web i get te follwoing error error 500 javax.servlet.ServletException: Server configuration denies access to data source The jsp page it self has code that is as follows %@ page language="java" import="java.sql.*" % html code here % Class.forName("org.gjt.mm.mysql.Driver"); Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=password"); Statement stmt = myConn.createStatement(); ResultSet myResultSet = stmt.executeQuery("select * from test_tb1"); Is the a problem with mySql user permissions, or tomcat, or JDBC driver or what else. All help is greatelly appreciated! - 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