869: The table 'mw_delivery_server_usage_log' is full

[Pierre]

Hi all,

I need to change my MW server and my database.sql file is 2.5Go .

I have an error message when importing data :

869: The table 'mw_delivery_server_usage_log' is full
44 2510M 44 1116M 0 0 713k 0 1:00:03 0:26:42 0:33:21 1777k
curl: (23) Failed writing body (3137 != 16384)

For information, my Delivery server usage log : Displaying 1-60 of 16263306 results.
I deleted all the old users campaigns (3Go for database.sql before).

how to solve this problem?

Thx.

 

[twisted1919]

This happens because the linux partition where the mysql data is stored, is not big enough and you run out of space.
See http://dba.stackexchange.com/questi...-the-table-is-full-with-innodb-file-per-table and maybe http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full

 

[Pierre]

Hi,

I add this line but ever a problem :

tmp_table_size=512M max_heap_table_size=512M
innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size=5120M

Result :

Enter password: % Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 1781M 0 1199 0 0 22076 0 23:29:58 --:--:-- 23:29:58 21800
66 1781M 66 1189M 0 0 1137k 0 0:26:43 0:17:51 0:08:52 809kERROR 1114 (HY000) at line 3385: The table 'mw_list_field_value' is full
66 1781M 66 1191M 0 0 1136k 0 0:26:44 0:17:53 0:08:51 897k
curl: (23) Failed writing body (10377 != 16384)

 

[twisted1919]

There's really nothing i can personally do for this, the error is pretty clear, the space available on the disk...

 

[Pierre]

Hi

I changed the size of my partitions and it's working now .

Thank you for your help ; )