| Bug #9417 | the system can't connect to database after running few days | ||
|---|---|---|---|
| Submitted: | 27 Mar 2005 10:23 | Modified: | 29 Apr 2005 8:38 |
| Reporter: | NOT_FOUND NOT_FOUND | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | mysql-4.0.21 | OS: | Windows (win 2000 server and IIS) |
| Assigned to: | CPU Architecture: | Any | |
[27 Mar 2005 10:23]
NOT_FOUND NOT_FOUND
[27 Mar 2005 15:17]
Jorge del Conde
Hi Can you please give us a test-case that reproduces this behaviour ? Thanks.
[29 Mar 2005 8:38]
NOT_FOUND NOT_FOUND
the attached files 1. "jnm_20050329.sql" database structure (dump from dbtools) 2. "no_login_test_case.asp" main entry ASP 3. "dbconnection_test_case.asp" database connection ASP 4. "common_functions.inc"common functions call in ASP I have put brief remark in the ASP for easy reading. The ASP receive data and display them onto the web pages. The data are less than 100 items and each of them around 2 to 4 words lenght. After running a few days, the system just can't connect to database from web pages, in the dbtools program from windows interface and even command prompt. it just return "Can't connect to MySQL server on 'localhost' (10055)" in web page and in command prompt. Should u what more info please let me know. the url for the web site is http://www.jacknmarcel.com.hk/EN/index.html it works after i reboot the system. Thks! Errol >From: Bug Database <dev-bugs@mysql.com> >To: errolaw@hotmail.com >Subject: Bug #9417 [Anl->Fbk]: the system can't connect to database after running few days >Date: Sun, 27 Mar 2005 17:17:15 +0200 (CEST) > >ATTENTION! Do NOT reply to this email! >To reply, use the web interface found at >http://bugs.mysql.com/?id=9417&edit=2 > > > ID: 9417 > Updated by: Jorge del Conde > Reported by: sql_errolaw sql_errolaw > User Type: User >-Status: Analyzing >+Status: Need Feedback > Severity: S1 (Critical) > Category: Server > Operating System: win 2000 server and IIS > Version: mysql-4.0.21 > New Comment: > >Hi > >Can you please give us a test-case that reproduces this behaviour ? > >Thanks. > > >Previous Comments: >------------------------------------------------------------------------ > >[2005-03-27 10:23:19] sql_errolaw sql_errolaw > >Description: >I have setup my server with following > >1. win 2000 server and IIS >2. mysql-4.0.21-win >3. myodbc-2.50.37-nt >4. dbtools 3.23.32 > >The program runs well for few days. I can insert, delete and edit data >in database. couple of days later the system will have the following >error. I have to reboot the server and the program works again! > >---------------------------------------------------------- >Microsoft OLE DB Provider for ODBC Drivers error '80004005' > >[TCX][MyODBC]Can't connect to MySQL server on 'localhost' (10055) > >web_file_name.asp, line XXX >---------------------------------------------------------- > >What is problem? How to solve it? > >thks! > >errolaw@hotmail.com >How to repeat: >user rights, database and table's names are all match. MySQL service >started. After running a few days, the system just can't connect to >database from web pages and even in the dbtools program from windows >interface. > >I have to reboot the system and everything works fine. I can still >access to database from web page and from the dbtools from the windows >interface. > >What is problem? How to solve it? >Suggested fix: > > >------------------------------------------------------------------------ > >
[29 Apr 2005 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
