Connections lost - MySQL Database

Michael

I'm using
Red Hat Linux 9.0
My SQL 4..0.15
Tomcat 4.1.27
JConnector 3.0.9

I've configured a DataSource in the /home context. I can access the
database just fine when I initially satart the servers up. I have Tomcat on
server app01 and MySQL on server db01. When I leave the servers and come
back to them after 24 hours or so I start getting Exceptions:

SQLException Raised : java.sql.SQLExc eption: No operations allowed after
connection closed.

Connection was closed due to the following exception:

** BEGIN NESTED EXCEPTION **

java.sql.SQLExc eption
MESSAGE: Communication link failure: java.io.IOExcep tion, underlying cause:
Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOExcep tion
MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOExcep tion: Unexpected end of input stream
at com.mysql.jdbc. MysqlIO.reuseAn dReadPacket(Mys qlIO.java:1405)
at com.mysql.jdbc. MysqlIO.checkEr rorPacket(Mysql IO.java:1775)
at com.mysql.jdbc. MysqlIO.sendCom mand(MysqlIO.ja va:1020)
at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1109)
at com.mysql.jdbc. MysqlIO.sqlQuer y(MysqlIO.java: 1070)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:2027)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:1996)
at com.mysql.jdbc. Connection.exec SQL(Connection. java:1977)
at com.mysql.jdbc. Connection.setA utoCommit(Conne ction.java:654)
at
org.apache.comm ons.dbcp.Delega tingConnection. setAutoCommit(D elegatingConnec t
ion.java:237)
at
org.apache.comm ons.dbcp.Poolab leConnectionFac tory.activateOb ject(PoolableCo n
nectionFactory. java:273)
at org.apache.comm ons.pool.impl.G enericObjectPoo l.borrowObject( Unknown
Source)
at
org.apache.comm ons.dbcp.Abando nedObjectPool.b orrowObject(Aba ndonedObjectPoo l
..java:117)
at
org.apache.comm ons.dbcp.Poolin gDataSource.get Connection(Pool ingDataSource.j a
va:110)
at
org.apache.comm ons.dbcp.BasicD ataSource.getCo nnection(BasicD ataSource.java: 3
12)
at
genfw.resourcea ccess.db.MySQLD BAccess.getConn ection(MySQLDBA ccess.java:63)
at genfw.resourcea ccess.db.MySQLD BAccess.retriev e(MySQLDBAccess .java:189)
at genfw.dataacces s.RDBMSEntityMa nager.find(RDBM SEntityManager. java:193)
at genfw.dataacces s.RDBMSEntityMa nager.find(RDBM SEntityManager. java:145)
at genfw.dataacces s.RDBMSEntityMa nager.find(RDBM SEntityManager. java:136)
at
com.caughey.hom e.survey.busine ss.SurveyManage r.retrieveSurve yResults(Survey M
anager.java:67)
at
com.caughey.hom e.survey.action s.SurveyResults Action.perform( SurveyResultsAc t
ion.java:35)
at org.apache.stru ts.action.Actio n.execute(Actio n.java:420)
at
org.apache.stru ts.action.Reque stProcessor.pro cessActionPerfo rm(RequestProce s
sor.java:484)
at
org.apache.stru ts.action.Reque stProcessor.pro cess(RequestPro cessor.java:274 )
at org.apache.stru ts.action.Actio nServlet.proces s(ActionServlet .java:1482)
at org.apache.stru ts.action.Actio nServlet.doGet( ActionServlet.j ava:507)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:740)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at
org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio n
FilterChain.jav a:247)
at
org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC h
ain.java:193)
at
org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j a
va:256)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 3)
at
org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:480)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:995)
at
org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j a
va:191)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 3)
at
org.apache.cata lina.authentica tor.Authenticat orBase.invoke(A uthenticatorBas e
..java:494)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 1)
at
org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:480)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:995)
at
org.apache.cata lina.core.Stand ardContext.invo ke(StandardCont ext.java:2416)
at
org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:18 0
)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 3)
at
org.apache.cata lina.valves.Err orDispatcherVal ve.invoke(Error DispatcherValve .
java:171)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 1)
at
org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:17 2
)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 1)
at
org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:480)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:995)
at
org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a
:174)
at
org.apache.cata lina.core.Stand ardPipeline$Sta ndardPipelineVa lveContext.invo k
eNext(StandardP ipeline.java:64 3)
at
org.apache.cata lina.core.Stand ardPipeline.inv oke(StandardPip eline.java:480)
at org.apache.cata lina.core.Conta inerBase.invoke (ContainerBase. java:995)
at org.apache.coyo te.tomcat4.Coyo teAdapter.servi ce(CoyoteAdapte r.java:223)
at org.apache.jk.s erver.JkCoyoteH andler.invoke(J kCoyoteHandler. java:263)
at org.apache.jk.c ommon.HandlerRe quest.invoke(Ha ndlerRequest.ja va:360)
at org.apache.jk.c ommon.ChannelSo cket.invoke(Cha nnelSocket.java :604)
at
org.apache.jk.c ommon.ChannelSo cket.processCon nection(Channel Socket.java:562 )
at org.apache.jk.c ommon.SocketCon nection.runIt(C hannelSocket.ja va:679)
at
org.apache.tomc at.util.threads .ThreadPool$Con trolRunnable.ru n(ThreadPool.ja v
a:619)
at java.lang.Threa d.run(Thread.ja va:536)
** END NESTED EXCEPTION **
I have been leaving a the mysql client up and it to looses the connection.
it however recovers. The Error I get on db01 where the mysql client is
running is

ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 139
Current database: home

Then it connects and i get the results.

Jul 19 '05 #1

Subscribe Reply

1689

Similar topics

1568

InnoDB and lost connections

by: jackson marshmallow | last post by:

I have just recreated several (large) tables in the database as InnoDB and reloaded them using my client application... These tables used to be MyISAM. I haven't tried playing with any InnoDB parameters, right now everything is default. Some operations a noticeably slower, which can probably be fixed. Speed is not essential right now. But I did run into one strange problem with a batch INSERT SELECT that would take about an hour with...

MySQL Database

2317

Help - Server stops responding to connections, stops accepting connections

by: Michael Bourgon | last post by:

I've been having the same problem for 2 weeks now. If anyone has any ideas, I'd love to hear them. We are using both SQL and Windows Authentication. I was running a Profiler Trace at the time, and am going through it now but have not seen anything yet. Thanks in advance. About once a week, at no fixed time (but so far, between 8am and 11am), my SQL Server 2000 on Windows 2000 (8.00.679) will stop responding. New connections will...

Microsoft SQL Server

2649

SQL Server bouncing connections

by: ceadtinneh | last post by:

Hello Folks, Our web based application accesses our SQL Server 2k database using a connection pool of about 150 connections through a BEA JDBC driver. We recently had a situation where one of our app servers lost connectivity to the database server (the BEA error logs indicated the following: java.sql.SQLException: A problem occurred

Microsoft SQL Server

5638

Manage PostgreSQL Connections

by: Nagy Karoly | last post by:

Is there any way to close the connections of other users in PostgreSQL. I wish to run an automatic pg_dump and pg_restore and I guess users must bedisconnected first. Is that right? ________________________ Nagy Károly Gabriel R&D Manager Expert Software Group 410066 Oradea, Al. Gojdu 2 Tel. +4 0259 230 776 http://www.expert-software.ro

PostgreSQL Database

2043

More than 1024 connections from the same c-backend

by: Andreas Muck | last post by:

Hi! We have an application running on Linux (SuSE 7.2, kernel 2.4.16) that opens lots of connections to a Postgres database and occasionaly dies with segfault. Trying to reproduce the crash, I came up with the following test code: --------------------- pgsql-test.c --------------------- #include <stdio.h> #include <libpq-fe.h>

PostgreSQL Database

1187

More than 1024 connections from the same c-client

by: Andreas Muck | last post by:

PostgreSQL Database

831

Persisting password in Server Explorer/Data connections

by: Per Schjetne | last post by:

I set the "allow saving password" on the connection in the VS IDE/Data connections. But after closing and reopening, the password and the "allow saving password" checkbox is lost. I have this problem on several computers but not all. Anyone knows anything about this?

ASP.NET

3048

Wireless connections, trace them in a LAN?

by: Arno R | last post by:

Hi all, I am about to distribute an A97-runtime app. which will be used on a LAN by approx. 30 users. The network is pretty good, but there are a few managers who have wireless laptops... Of course they also want to access the db. I am a bit afraid of possible corruption due to the wireless connections. ==> Do I have to be afraid indeed? If so, what is the best way to deal with this? Should I trace the wireless connections...

Microsoft Access / VBA

1200

Connections

by: Marcelo | last post by:

Hi I would like to know about connections of sa, where SQL store the number of connections

Microsoft SQL Server

3708

mysqli connections and oop

by: Schmidty | last post by:

If you do a page reload with $_SERVER will your program lose a mysqli connection upon the reload of the page? Would this code work? I need to know how to carry over a connection between methods as I am new to OOP? Thanks... Example; ======================================== <?php // webpage $newsignon = new newuser(); logon();

PHP

8443

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8356

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8781

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8639

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7385

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5663

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4198

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2769

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1772

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General