Link to home
Start Free TrialLog in
Avatar of sqldba2013
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.BatchUpdateException;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
Avatar of Joseph O'Loughlin
Joseph O'Loughlin
Flag of Ireland image

Is the database server host physical or virtual (what are the constraints / free space)
What file system is in use?
Avatar of sqldba2013
sqldba2013

ASKER

its hosted on virtual .

there is enough free space is availble.
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
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
ASKER CERTIFIED SOLUTION
Avatar of Joseph O'Loughlin
Joseph O'Loughlin
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, I have resolved issue with the help of above URL.