Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

The Table 'Tbl_Employee' is full - MySQL Database error

Posted on 2014-08-26
7
Medium Priority
?
426 Views
Last Modified: 2014-09-10
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
0
Comment
Question by:sqldba2013
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:Joseph OLoughlin
ID: 40285800
Is the database server host physical or virtual (what are the constraints / free space)
What file system is in use?
0
 

Author Comment

by:sqldba2013
ID: 40285837
its hosted on virtual .

there is enough free space is availble.
0
 
LVL 11

Expert Comment

by:Joseph OLoughlin
ID: 40285868
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sqldba2013
ID: 40285923
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
0
 

Author Comment

by:sqldba2013
ID: 40285965
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
0
 
LVL 11

Accepted Solution

by:
Joseph OLoughlin earned 1500 total points
ID: 40287275
Given that the records are dynamic, see the explanation and solution at
http://dev.mysql.com/doc/refman/4.1/en/full-table.html
0
 

Author Closing Comment

by:sqldba2013
ID: 40314728
Thanks, I have resolved issue with the help of above URL.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question