FWD: Handles Leak HELP!!! :-)

FWD: Handles Leak HELP!!! :-)

am 23.08.2002 14:02:42 von Richard Morton

Hi,

I am having difficulty with MySQL, and I have now been informed that it is =
likely to be caused by MyODBC...

Can anybody please comment on this. I am looking for a swift resolution to this =
issue. If this is to do with MyODBC can you comment when a fix will be issued.

I have an application consuming 300 000 in a day, along with the memory to =
track the handles. (see emails below)

Once I have this information I can make a judgement on purchasing a Support =
Agreement. I have contacted Kerry Ancheta already, but I have not been told if =
"MySQL" thinks it is a problem with "MySQL"'s code...

Please help...

Thanks

Richard





---------- Forwarded Message ----------

FROM: "euro.support"
TO: "Richard Morton" , "Kerry Ancheta" =

DATE: Fri, 23 Aug 2002 09:13:09 +0200

RE: RE: re[2]: Support Contracts

Hi Richard,

The problem that you are having with MySQL's odbc drivers is caused by an =
un-thread-safe implementation of the driver that causes a memory leak. =
(Recreatable outside of Envox easily)
This problem is in no way related to Envox support (nor development) so, please =
do not send us these email correspondence and await reply.
We have been investigting this issue and have come to the conclusion that the =
source of error is in MySQL code which is out of our control.
Please don't CC us in this email correspondence.

Thanks and regards,
Jens Collin



-----Original Message-----
From: Richard Morton [mailto:richard.e.morton@virgin.net]
Sent: den 22 augusti 2002 17:29
To: Kerry Ancheta
Cc: sales@mysql.com; euro.support
Subject: FWD: re[2]: Support Contracts


Hi,

I have not had a reply to this email.

Briefly, my questions are:



1. I am looking to purchase a support agreement so as to rectify a problem I=20
have discovered with MySQL, a handles leak. I have been told it is a problem=20
with MySQL by Envox ( www.envox.com ), however I have not had confirmation of=20
this by MySQL. Can you confirm that it is a MySQL issue?

2. Can you confirm that version 4.1 will rectify this fault.

3. Can you indicate roughly which quarter version 4.1 will be released

4 a Can you confirm that you would fix the issue if I purchase a support=20
contract? Possibly under the heading in your support information called "Custom =
Binaries"

4 b. What will the support agreement cost?


I wait eagerly for a reply.

Thanks in advance

Richard





---------- Forwarded Message ----------

FROM: Richard Morton
TO: Kerry Ancheta
DATE: Tue, 20 Aug 2002 23:10:07 +0100

RE: re[2]: Support Contracts

Kerry,

Apologies for emailing Monty, this was cause I have the wrong email address=20
attached to the MySQL file. Oops. and apologies again.

That is great news about the possibility of fixing the handles leak, however... =
I will need to know that you will fix the problem if I purchase support. I=20
cannot, at this time, justify purchasing a support contract, unless a form of=20
assurance is provided that you will resolve the issue.

The issue is to do with MySQL and I am using Envox 4.0.07 through MyODBC3.51.03
running Win2kPro SP2

Also connected is the JDBC driver (the older version, not connector/J) and we=20
are running Tomcat.

The app is a product, and we are in the final phases of debugging, this is the=20
last major bug to be fixed. If we cannot receive assurances/commitment of=20
resolution, then we will have to deploy on M$....

We are going to purchase licenses for MySQL and supply them with each product=20
shipped.

Does the JDBC driver license come at "no extra charge" when purchasing MySQL=20
licenses? is this what your "license email" was indicating?

Thanks for your reply, and I look forward to any help/info you can provide.

Richard





>> Richard,
>> Sorry, this was the first I've seen of your support inquiry, but I did
>> respond to your JDBC inquiry. Please don't send emails directly to Monty,
>> instead please use sales@ or info@ for assistance or you can contact me.

>> I suspect we can assist you with an Entry Level Support contract for
>> $1500.
>> You can simply order the support here: =
https://order.mysql.com/?ref=3DKerry
>> and fax or email the PO to me. You can also use a credit card.

>> When will you be deploying your app?

>> Kerry
>> --
>> Mr. Kerry Ancheta
>> MySQL AB, Senior Account Executive
>> W +1 206-281-8448 | M +1 206-353-1188
>> www.mysql.com | F +1 425-671-0771

>> MySQL BEATS Microsoft
>> http://www.eweek.com/article/0,3658,s=3D708&a=3D23115,00.asp

>> > -----Original Message-----
>> > From: Richard Morton [mailto:richard.e.morton@virgin.net]
>> > Sent: Tuesday, August 20, 2002 1:55 AM
>> > To: monty@mysql.com; Monty@Mysql. Com
>> > Subject: FWD: Support Contracts
>> >
>> >
>> >
>> > Hello,
>> >
>> > I sent this mail recently... I have not received a
>> > response.could somebody please enlighten me???
>> >
>> > Thanks
>> >
>> > Richard
>> >
>> >
>> > ---------- Forwarded Message ----------
>> >
>> > FROM: Richard Morton
>> > TO: Monty Widenius
>> > DATE: Mon, 12 Aug 2002 10:30:01 +0100
>> >
>> > RE: Support Contracts
>> >
>> > Hi,
>> >
>> > I have a small problem with MySQL. I am looking to purchase a
>> > support contract to ensure I get the solution I require.
>> > However, this problem, as far as I know, is known to MySQL and
>> > has not been fixed to date....
>> >
>> > I am using 4.0.1-nt-Alpha. I am using MyODBC3.51.03, using
>> > MyISAM and I have a handles leak.
>> >
>> > A bit of a major one really. 10000 handles seem to be consumed
>> > in an hour.
>> >
>> >
>> > If I purchase a support contract, could this be fixed under the
>> > heading of "custom binaries" and if so, which level of support
>> > would I need to purchase?
>> >
>> > My company is finishing the development of its first product,
>> > and as such is still a fledgling organisation with small
>> > resources. The product however, has been well received and are
>> > looking to purchase many MySQL licences.
>> >
>> > If there are other ways to fix this I would be grateful of the
>> > advise (e.g. using InnoDB).
>> >
>> > Thanks in advance.
>> >
>> > Richard
>> >
>> >
>> >
>> > Regards,
>> >
>> > Richard Morton
>> >
Filter Fodder : SQL, Query
How to repeat:

------------------------------------------------------------ ---------
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 bugs-thread12399@lists.mysql.com
To unsubscribe, e-mail

FWD: Handles Leak HELP!!! :-)

am 23.08.2002 16:33:44 von Jani Tolonen

Hi Richard,

Richard Morton writes:
>
> Hi,
>
> I am having difficulty with MySQL, and I have now been informed that
> it is likely to be caused by MyODBC...
>
> Can anybody please comment on this. I am looking for a swift
> resolution to this issue. If this is to do with MyODBC can you
> comment when a fix will be issued.
>
> I have an application consuming 300 000 in a day, along with the
> memory to track the handles. (see emails below)
>
> Once I have this information I can make a judgement on purchasing a
> Support Agreement. I have contacted Kerry Ancheta already, but I
> have not been told if "MySQL" thinks it is a problem with "MySQL"'s
> code...

Please note that bugs@lists.mysql.com is a public list and is meant
for only fully repeatable test cases of bugs.

In your email it does not come clear what the problem is exactly, we
need a test case or some output that reveals the nature of the
bug. Please read once through this chapter:

http://www.mysql.com/documentation/mysql/bychapter/manual_In troduction.html#Bug_reports

and then jump to:

http://www.mysql.com/documentation/mysql/bychapter/manual_Cl ients.html#ODBC_Problems

By reading these chapters time will be saved for both parties
and you will get quicker help.

If there is a bug in MyODBC or in MySQL and there is a clear
indication of that or a test case, we will fix it.

Since you have already talked with our sales team, you may send
detailed information of the bug to support@mysql.com.

Thank you.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jani Tolonen
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.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 bugs-thread12401@lists.mysql.com
To unsubscribe, e-mail