Endpoint Protection

 View Only
Expand all | Collapse all

Error "java.sql.SQLException: Connection is closed"

Rafeeq

RafeeqDec 06, 2012 05:14 PM

Migration User

Migration UserDec 07, 2012 12:23 AM

Migration User

Migration UserDec 07, 2012 12:58 AM

Migration User

Migration UserDec 12, 2012 07:23 AM

  • 1.  Error "java.sql.SQLException: Connection is closed"

    Posted Dec 06, 2012 04:48 PM

    SEP 12.1 RU2 Manager installed in one server (os 2008 R2) with external DB SQL Server 2008 installed in another one (same os, 2008 R2).
    These machines are in the same subnet, no firewall or similar in the middle.

    In the scm-server-0.log every 10 minuts (precisely) I read the following error:

     

    THREAD 28 SEVERE: 

     

    java.sql.SQLException: Connection is closed.
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185)
    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.createStatement(PoolingDataSource.java:215)
    at com.sygate.scm.server.db.util.SqlDbHelper.setDeadlockPriority(SqlDbHelper.java:988)
    at com.sygate.scm.server.db.util.DatabaseUtilities.closeConnection(DatabaseUtilities.java:882)
    at com.sygate.scm.server.db.util.DatabaseUtilities.closeConnection(DatabaseUtilities.java:905)
    at com.sygate.scm.server.db.util.DbHelper.close(DbHelper.java:176)
    at com.sygate.scm.server.task.SecurityAlertNotifyTask.execute(SecurityAlertNotifyTask.java:451)
    at com.sygate.scm.server.task.MonitoredTimerTask.run(MonitoredTimerTask.java:22)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)
     
     
    In the monitor section of the console, I don't see any event.
    No effects, till now.
     
    What could be?
     
     
    Thanks!

     



  • 2.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 06, 2012 05:14 PM

    Does this SEPM has access to internet?



  • 3.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 06, 2012 05:33 PM

    It can only reach symantecliveupdate.com and symantec.com domains (LiveUpdate seems to work) via proxy (not authenticated).



  • 4.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 07, 2012 12:13 AM

    try running dbvalidator tool

    http://www.symantec.com/business/support/index?page=content&id=HOWTO39461

    Log setting is Finest leavel as per this document

    http://www.symantec.com/business/support/index?page=content&id=TECH102413



  • 5.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 07, 2012 12:23 AM

    HI,

    Can you try to access internet without Proxy.



  • 6.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 07, 2012 12:58 AM

    Whether your SEPM service is getting stopped?



  • 7.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 12, 2012 04:51 AM

    I'm investigating this "issue" with the Symantec support. If I get some infos I'll give them to you.

     

    Answering your questions:

    • I can't try access without (or bypassing) proxy (I can reach symantec.com, symantecliveupdate.com and akamai.net domains);
    • the SEPM service does not stop and, apparently, no symptoms at all (only the message in the log file).


  • 8.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 12, 2012 07:23 AM

    Dear,

    Your issue is resolve or not...?

     



  • 9.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Dec 12, 2012 09:59 AM

    As I said in my last post, not yet. Under investigation by support.

    Troubleshooting is ongoing smiley



  • 10.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Feb 12, 2013 04:26 AM

    Had the same issue. Tried below article and the issue is resolved now.

    Home, Monitors and Reports tabs in the SEPM are blank. Able to reach SEPM Reporting through Internet Explorer
    https://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=TECH156875

    Please check if this resolves your issue..

     



  • 11.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Mar 14, 2013 12:19 PM

    Hey Diabolicus,

     

    Did you get anywhere on this with Symantec Support?

     

    I get this exact error on every SQL based installation of SEP 12.1.2 I've done, in all my labs, on customer sites; everywhere!

    Service doesn't stop, some SEPM's have full access to Internet, others just to Symantec, some not at all but update via an internal LiveUpdate Administrator server.

    There doesn't appear to be any issue with any of the SEPM's at all, everything appears to be working fine, just this annoying error message (and in the case of the no internet access the usual accompanying erros you'd expect to see).

     

    I've been led to believe that the DB connection is being closed twice for some reason so maybe this is a side effect of that?

     

    I tried the fix in the post above but the key was already present...also that appears to be fixing something to do with displaying Reporting content in the SEPM console (something that often happens when you remove the sa rights on the SQL service account), not fixing a database connection issue...

     

    Please let me know if you managed to resolve this error, it's driving me nuts!

     



  • 12.  RE: Error "java.sql.SQLException: Connection is closed"
    Best Answer

    Posted Mar 14, 2013 07:08 PM

    Hi Mike!

    Symantec support knows the origin of the problem (that, as you said, does not cause any issue) and they said that they will probably fix it in the RU3.

    Just as information: the logs occur because there is a call to close a connection twice, instead of once, so the second attempt to close it produces a log that says the connection has already been closed.

     

    Hope you can find these infos helpful



  • 13.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Mar 15, 2013 04:56 AM

    Superb, thanks for confirming that :)

     

    Same old, "fixed in next release"...hmmm...we'll see...



  • 14.  RE: Error "java.sql.SQLException: Connection is closed"

    Posted Apr 10, 2013 09:51 AM

    Home, Monitors and Reports tabs in the SEPM are blank. Able to reach SEPM Reporting through Internet Explorer
    https://www.symantec.com/business/support/index?page=content&pmv=print&impressions=&viewlocale=&id=TECH156875

     

    Have you tried the above article. Has that not resolved your issue