Re: blob issue - Daniel da Veiga - com.mysql.lists.win32

13 messages in com.mysql.lists.win32Re: blob issue

From	Sent On	Attachments
Mark Mchugh	15 Apr 2005 08:13
Daniel da Veiga	15 Apr 2005 09:11
Daniel da Veiga	18 Apr 2005 08:10
Mark Mchugh	18 Apr 2005 08:19
Mark Mchugh	18 Apr 2005 08:45
Daniel da Veiga	18 Apr 2005 09:07
Mark Mchugh	18 Apr 2005 09:14
Daniel da Veiga	18 Apr 2005 09:21
Mark Mchugh	18 Apr 2005 09:33
Armin Schöffmann	18 Apr 2005 10:19
Daniel da Veiga	18 Apr 2005 10:22
Mark Mchugh	19 Apr 2005 06:37
Daniel da Veiga	19 Apr 2005 06:44

Subject:	Re: blob issue
From:	Daniel da Veiga (dani...@gmail.com)
Date:	04/18/2005 09:21:08 AM
List:	com.mysql.lists.win32

Yeah it should, but hey, at least now you moved into a new MySQL Manual section :) that is A.2.9. Check it out. Well, I did it, noticed that this variable, as you stated before, must be set BOTH client and server side... So, now you should discover wich one (client or server) is sending you the message (or just set the variable in both) :)

More information? Check this out:

http://dev.mysql.com/doc/mysql/en/packet-too-large.html

Good luck, again...

On 4/18/05, Mark Mchugh <mark...@yahoo.com> wrote:

its strange, fromt he server i get this for max_allowed_packet = 104856576

that should be big enought for a 16M file?

--- Daniel da Veiga <dani...@gmail.com> wrote:

Try setting the package in bytes, I mean 33554432 bytes :) Dunno, but the error message is very clear to me, seems your're getting some odd issue setting the value, so, try bytes, and do a 'show global variables like '%package%'' at your console to see the exact value of the variable.

Good luck,

On 4/18/05, Mark Mchugh <mark...@yahoo.com> wrote:

I have an update, the error message i am now getting is

"got packet bigger than 'max_allowed_packet'"

i wonder is this a client problem? i ahve added the following into the my.ini

[client] max_allowed_packet=32M

--- Daniel da Veiga <dani...@gmail.com> wrote:

Well, I did some research on you error (mostly google and mysql manual) and the most common causes of this error includes your problems (so, you should have found this :P). I'll work with the R T Fine M *lol*

http://dev.mysql.com/doc/mysql/en/gone-away.html

It happens that your client is sending large packets to the server, as eva2000 stated at the Vbulleting Forum:

"You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row"

Try this and let me know if it works. Good luck.

On 4/18/05, Mark Mchugh <mark...@yahoo.com>

wrote:

Hi Daniel, Have tried that, still the same, this is odd?

Mark

--- Daniel da Veiga <dani...@gmail.com>

wrote:

If it takes some times for your app to load

and

use

the file data, the server considers this idle time, and thus disconnect you after a few seconds, try setting a higher value for "wait_timeout" and "interactive_timeout", or rebuild your code to connect and insert the data only after all processing of the file is complete. So, your rs.Open would be executed only AFTER mystream.LoadFromFile, avoiding idle time.

Hope that helps,

On 4/15/05, Mark Mchugh <mark...@yahoo.com>

wrote:

hi, I am trying to add files to my database,

the

server

max_allowed_packet = 1073741824

and i am using the following code..

sqlstr = "select * from files where 1=0;"

rs.Open sqlstr, connMySQL, adOpenStatic, adLockOptimistic rs.AddNew mystream.Open Debug.Print strFileName mystream.LoadFromFile strFileName rs!file_name = "All Scanned" rs!Fromp = CatDir rs!Desc1 = ronsnotes rs!file_size = mystream.Size rs!policyid = fdesc rs!file = mystream.Read rs.Update mystream.Close rs.Close

i get the error message "lost connection

mysql

server during query"

any ideas?

thanks

__________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:

http://lists.mysql.com/win32?unsub=dani...@gmail.com

-- Daniel da Veiga Computer Operator - RS - Brazil

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:

=== message truncated ===