Re: blob issue - Mark Mchugh - 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:	Mark Mchugh (mark...@yahoo.com)
Date:	04/18/2005 08:45:38 AM
List:	com.mysql.lists.win32

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, on

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 to 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:

-- Daniel da Veiga Computer Operator - RS - Brazil

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