Re: Unexpected connects and disconnects at the DB server.
"Jason L. Froebe" <[email protected]> Tue, 7 Oct 2008 15:28:51 -0700 (PDT)
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <[email protected]> |
--0-1133879684-1223418531=:86540 Content-Type: text/plain; charset=us-ascii Could be running an invalid command or something that would cause a disconnect. Put Ribo inbetween the server and the perl script. You should be able to see who disconnects first and why. Jason L. Froebe Tech log http://www.froebe.net/blog MyDatabases (free) magazine: http://froebe.net/blog/category/databases/my-databases/ Froebe Fibers http://www.froebe-fibers.com The opinions expressed within are the sole rantings of a raving lunatic and in no way reflect the rantings, fits, tantrums, errors, corrections, allocutions, or aimless thoughts of Sybase or its employees or of TeamSybase or ISUG. Any resemblence to reasonable thought, or any official or published opinion of Sybase, TeamSybase or ISUG is merely coincidental, and should be totally ignored. ----- Original Message ---- From: "[email protected]" <[email protected]> To: [email protected] Sent: Tuesday, October 7, 2008 3:28:08 PM Subject: Unexpected connects and disconnects at the DB server. Guys, Solaris DBD Sybase 1.05 My co-workers code has a single dbh->connect. (he has a log/timestamp showing where he only calling it once.) The sybase sysaudits show repeated login/select/logouts. The perl code is believed to simply run multiple prepare/executes. The logouts are occurring 6 millisecs after the select statement yet his code does not have any explicit disconnect logic. Any ideas? Cory Sane Member of www.TeamSybase.com Certified Sybase Associate DBA for ASE 15.0 --0-1133879684-1223418531=:86540 Content-Type: text/html; charset=us-ascii <html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:courier,monaco,monospace,sans-serif;font-size:10pt">Could be running an invalid command or something that would cause a disconnect. Put Ribo inbetween the server and the perl script. You should be able to see who disconnects first and why.<br><div> </div>Jason L. Froebe<br><br><div>Tech log http://www.froebe.net/blog<br>MyDatabases (free) magazine: http://froebe.net/blog/category/databases/my-databases/<br>Froebe Fibers http://www.froebe-fibers.com</div><br><br><div>The opinions expressed within are the sole rantings of a raving lunatic and in no way reflect the rantings, fits, tantrums, errors, corrections, allocutions, or aimless thoughts of Sybase or its employees o r of TeamSybase or ISUG. Any resemblence to reasonable thought, or any official or published opinion of Sybase, TeamSybase or ISUG is merely coincidental, and should be totally ignored.<br><div><br></div><div style="font-family: courier,monaco,monospace,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: "[email protected]" <[email protected]><br>To: [email protected]<br>Sent: Tuesday, October 7, 2008 3:28:08 PM<br>Subject: Unexpected connects and disconnects at the DB server.<br><br> <br><font face="sans-serif" size="2">Guys,</font> <br> <br><font face="sans-serif" size="2">Solaris</font> <br><font face="sans-serif" size="2">DBD Sybase 1.05</font> <br> <br><font face="sans-serif" size="2">My co-workers code has a single dbh->connect. </font> <br><font face="sans-serif" size="2">(he has a log/timestamp showing where he only calling it once.)</font> <br> <br><font face="sans-serif" size="2">The sybase sysaudits show repeated login/select/logouts.</font> <br><font face="sans-serif" size="2">The perl code is believed to simply run multiple prepare/executes.</font> <br> <br><font face="sans-serif" size="2">The logouts are occurring 6 millisecs after the select statement yet his code does not have any explicit disconnect logic.</font> <br> <br><font face="sans-serif" size="2">Any ideas?</font> <br><font face="sans-serif" size="2"><br> Cory Sane<br> Member of <a target="_blank" href="http://www.TeamSybase.com">www.TeamSybase.com</a><br> Certified Sybase Associate DBA for ASE 15.0</font> </div></div></div></div></body></html> --0-1133879684-1223418531=:86540--