Home › Forums › Users › General User's Discussion ›

Restoring documents table

Submitted by Guest on Mon, 22/06/2015 - 16:00
in

 

Has anyone tried to restore a backup and had any drams with the documents table? i dont seem to be able to import it back in. All the other tables are fine. The error in MySQL relates to it timing out so i have increased the properties suggested

max_allowed_packet

read_buffer_size

 

but still no luck, im wondering if its the actual data stored but the file is 300mb so it doesn't like being opened/edited.

 

any suggestions?

‹ Best Practice Configuration under 1.8 templates for Vaccines and managing stock eml Documents ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Restoring documents table

Submitted by tony on Mon, 22/06/2015 - 16:02.

Hi,

Typically this is due to having your max_allowed_packet too small for the size of the blobs that are stored in the documents table.  What size did you set for this Mysql parameter ?

Cheers Tony

Re: Restoring documents table

Submitted by evilanf (not verified) on Mon, 22/06/2015 - 16:04.

i tried all sorts of sizes on it, i went right up to a few gigs. The process information in task manager doesnt reach very high either before it aborts. Maybe a couple of hundred megs.

 

Re: Restoring documents table

Submitted by tanderson on Mon, 22/06/2015 - 16:14.

What are the values for wait_timeout and interactive_timeout?

E.g.:

mysql>  show global variables like '%timeout%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| connect_timeout            | 10    |
| delayed_insert_timeout     | 300   |
| innodb_lock_wait_timeout   | 50    |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout        | 28800 |
| net_read_timeout           | 30    |
| net_write_timeout          | 60    |
| slave_net_timeout          | 3600  |
| table_lock_wait_timeout    | 50    |
| wait_timeout               | 28800 |
+----------------------------+-------+

 

 

Re: Restoring documents table

Submitted by tony on Mon, 22/06/2015 - 16:19.

Hi,

Have you confirmed the max_allowed_packet is properly set in the mysql server setup.  

i.e in mysql command line do

SHOW VARIABLES like 'max_allowed_packet';

What OS are you on and what file are you editing to change this setting ?

Cheers Tony

Re: Restoring documents table

Submitted by evilanf (not verified) on Mon, 22/06/2015 - 16:31.

 

im on Windows 7, im using the MySQL workbench to edit the files, ill output the results and send them when i get back in the office, wasnt expecting the very prompt reply :)

 

Re: Restoring documents table

Submitted by evilanf (not verified) on Mon, 22/06/2015 - 20:33.

something wasnt right with the server, came back, service wasnt started and i couldnt get it running. So reinstalled and tried the document table import again and all good :)

 

thanks for the help

Syndicate content