sqldba2013
asked on
The Table 'Tbl_Employee' is full - MySQL Database error
Hi Experts,
We are getting below error in one of our PROD server while executing Insert statement. We have tried to resolve error from our end but issue is still persist.
Please advise on below error.
Error:
The Table 'Tbl_Employee' is full ; nested exception is java.sql.BatchUpdateExcept ion;The Table 'Tbl_Employee' is full
Sharing more information on Table Tbl_Employee
1. show global variables like 'innodb_data_file_path';
Output:
Variable Name Value
-------------------------- ---------- ---------
innodb_data_file_path ibdata1:12M:autoextend
2. SHOW TABLE STATUS LIKE 'Tbl_Employee';
Please find the attached output file.
3. Tbl_Employee structure
Please find the attached file.
Thanks in advance
Table-Status.xls
Tbl-Employee.sql
We are getting below error in one of our PROD server while executing Insert statement. We have tried to resolve error from our end but issue is still persist.
Please advise on below error.
Error:
The Table 'Tbl_Employee' is full ; nested exception is java.sql.BatchUpdateExcept
Sharing more information on Table Tbl_Employee
1. show global variables like 'innodb_data_file_path';
Output:
Variable Name Value
--------------------------
innodb_data_file_path ibdata1:12M:autoextend
2. SHOW TABLE STATUS LIKE 'Tbl_Employee';
Please find the attached output file.
3. Tbl_Employee structure
Please find the attached file.
Thanks in advance
Table-Status.xls
Tbl-Employee.sql
ASKER
its hosted on virtual .
there is enough free space is availble.
there is enough free space is availble.
And the file system is?
http://dev.mysql.com/doc/refman/4.1/en/full-table.html
http://dev.mysql.com/doc/refman/4.1/en/full-table.html
ASKER
Filesystem Type 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg_reflectc-lv _root
ext4 107106040 14614712 87075736 15% /
tmpfs tmpfs 16440280 72 16440208 1% /dev/shm
/dev/sda1 ext4 495844 60814 409430 13% /boot
1k-block
/dev/mapper/vg_reflectc-lv
ext4 107106040 14614712 87075736 15% /
tmpfs tmpfs 16440280 72 16440208 1% /dev/shm
/dev/sda1 ext4 495844 60814 409430 13% /boot
1k-block
ASKER
Space details:
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg_reflectc-lv _root
106079852 50658252 50070644 51% /
proc 0 0 0 - /proc
sysfs 0 0 0 - /sys
devpts 0 0 0 - /dev/pts
tmpfs 16440528 72 16440456 1% /dev/shm
/dev/sda1 495844 60811 409433 13% /boot
none 0 0 0 - /proc/sys/fs/binfmt_misc
sunrpc 0 0 0 - /var/lib/nfs/rpc_pipefs
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/vg_reflectc-lv
106079852 50658252 50070644 51% /
proc 0 0 0 - /proc
sysfs 0 0 0 - /sys
devpts 0 0 0 - /dev/pts
tmpfs 16440528 72 16440456 1% /dev/shm
/dev/sda1 495844 60811 409433 13% /boot
none 0 0 0 - /proc/sys/fs/binfmt_misc
sunrpc 0 0 0 - /var/lib/nfs/rpc_pipefs
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I have resolved issue with the help of above URL.
What file system is in use?