search for: max_allowed_packet

Hi I am using rails 2.3.8 with mysql 5.1. In my attachment model the validation was validates_attachment_size :attachment, :less_than => 2.megabytes, :message => "Upload file size should not exceeds 2 MB" And my /etc/my.ini has max_allowed_packet = 16M The above worked perfectly. But now I need file limit size as 10 MB instead of 2 MB. So I changed validation like validates_attachment_size :attachment, :less_than => 10.megabytes, :message => "Upload file size should not exceeds 10 MB" And now when I tried to at...

...sqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking bind-address = 0.0.0.0 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M [mysqldump] quick quo...

...f8; CREATE USER ''dashboard''@''localhost'' IDENTIFIED BY ''dbpassword''; GRANT ALL PRIVILEGES ON dashboard.* TO ''dashboard''@''localhost''; I''ve added the following line to the /etc/mysql/my.cnf file. max_allowed_packet = 32M And executed ''set max_allowed_packet = 33554432;'' in the MySQL workbench. I then ran the following within the /usr/share/puppet-dashboard/ directory. > rake RAILS_ENV=production db:migrate I got the following error message. rake aborted! undefined method `sourc...

I''m uploading files to a mysql database, using a mediumblob size. Following the wiki here: http://wiki.rubyonrails.org/rails/pages/HowtoUploadFiles , I got past the first mysql 500kb limitation with the max_allowed_packet = xM trick, setting it to 1000M. However, as the person at the very bottom of the wiki notes, I too cannot upload more than around 10mb. I also tried the suggested workaround: <%= hidden_field ''value'', ''1000000'' %> in the same form as my binary file_field....

Nothing I have done so far seems to work # cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_allowed_packet=2MB [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-query=/var/log/mysql-query.log empty and then I added to /etc/init.d/mysqld get_mysql_option mysqld_safe log "/var/log/mysqld-query.log" querylogfile="$result" -and- start(){ touc...

hi, i''m sure some of you had come across this problem before, but i was unable to find the answer after spending quite some time searching. i have a basic file uploader, code similar to rails recipe (or rails manual). problem occurs when i try to upload files (images) greater than 500KB. the largest file i could upload was 493KB and i''ve uploaded a bunch files under 490KB and

Hi I am trying to upload 30mb files with attachment-fu, these seem to just hang. (works file for small image files) I am using mongrel cluster and nginx... Does anyone have any advice? Thanks Richard --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group,

Hi, I am using Ruby - 1.8.6 and Rails- 1.2.6. When I trying to upload data using the .sql file through my code I got "Mysql::Error: Lost connection to MySQL server during query: rollback;" File size is 6 MB. The code I have used is like: numberOfRecord = ActiveRecord::Base.connection.update(File.open(fileName).read) Please let me know how I upload data using huge .sql file. If

I''ve created file upload functionality based on the wiki HowtoUploadFiles. I''m in development mode running the newest version of rails and ruby. I''m using the development WEBRICK web server. The database is MySQL 4.1. I''ve updated the max_allowed_packet setting=32M. The problem is that file uploads get stuck at sizes of 8mb or greater. Sizes below 8mb work fine. Are there other settings I should look for besides the MySQL my.ini settings? If anyone has any clues, they''d be greatly appreciated. Regards, Todd

I have a problem uploading files into a MySQL database (4.1.18) using Lighttpd (1.4.11) and the MySQL C api (2.7). All the files that I upload are truncated at about 65K, though, the temp file is the correct length. No errors are thrown and the max_allowed_packet is set to 10GB. I''m running on OSX. Any thoughts or pointers are much appreciated. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to...

I''m struggling with activerecord and mysql blobs (uploading files)... blobs over 400K-ish cause the below exception... ActiveRecord::StatementInvalid in File#upload Mysql::Error: Lost connection to MySQL server during query: I''ve tried blob, mediumblob, and longblob... I''m using windows xp for development - and have not installed the mysql gem... simlar google

...ts) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] #wait_timeout=28800 #interactive_timeout = 28800 max_allowed_packet=512M #General Query Log general_log_file = /var/log/mysql/mysql_query.log general_log = 1 #Error Log log_error = /var/log/mysql/mysql_error.log #Slow Query Log slow_query_log = 1 slow_query_log_file = /var/log/mysql/my...

...mysql3.sock pid-file=/usr/local/mysql/sock/mysql3.pid datadir=/data/mysqldata3/mydata tmpdir =/data/mysqldata3/tmpdir skip-locking skip-name-resolve back_log=100 interactive_timeout=172800 default-storage-engine = INNODB default-character-set = utf8 max_connections = 500 max_connect_errors=100000 max_allowed_packet = 4M max_heap_table_size = 1024M max_length_for_sort_data = 4096 net_buffer_length = 8K sort_buffer_size = 8M join_buffer_size = 16M #if lock memory #memlock table_cache = 1024 thread_cache_size = 512 thread_concurrency = 8 query_cache_type=0 #memory table max size tmp_table_size = 128M #***...

I''m seeing a "marshal data too short" error with an ActiveRecord store for my session data. Other posts say that this happens when the size of the session data exceeds the size of the "data" column in the sessions table. But my "data" column is a TEXT field so it seems unlikely that I could have blown it out. Has anyone else seen "marshal data too

...ll do: INSERT INTO `PRODUCT` COLUMNS(NAME, PRICE, FILE) VALUES(''PROD1'', 4.56, X''00DEF033423023220'') All is hunky dory for as long as my BLOB is not too big. If the blob is say 8MB (not that big actually),there is a problem: The buffer used by the mysql server(max_allowed_packet) to hold the commands must be at least 16MB (two bytes for hexadecimal representation). This is an unecessarily huge number for holding SQL commands. Is there a way to tell ruby to use a host variable in the SQL statement (i.e. VALUES(''PROD1'', 4.56, :blobvar) instead of the liter...

...the, "idle-timeout", to a really high number, but that didn''t work. BUT, like I said before, I wasn''t having problems before I switch to the DB style of storage. So I looked into DB-related issues. The closest thing I found was a recommendation to increase the "max_allowed_packet" param in mysql. I increased it to 52427776, but that didn''t fix the problem either. I really don''t know what else to look into. I''ve included what I''m seeing on the console when the problem occurs at the bottom of this post. Does anyone have any sugges...