Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Could not allocate space for object 'patient' in database 'DMART' because the 'FG2' filegroup is...


Could not allocate space for object 'patient' in database 'DMART' because the 'FG2' filegroup is full..

Author
Message
Stamey
Stamey
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 999
I'm out of ideas here. When I was first alerted to this situation on a legacy SQL 2000 box I inherited, I found that the data files on it had auto-growth turned off. I turned it on for 2 additional data files, with 500MB increment for auto growth. We then attempted the same data load process that generated that error and got the same thing. I grew the files manually so that the file in the file group in question now has 4.1G free but I still get the same error.
The disk has about 100G free on it. Al files are stored on the same LUN and the DB is online and working.
I also tried to shrinkfile and empty that extra filegroup, but I got a variation of the same thing:
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'rxRej_Excep' in database 'DMART_MACAID' because the 'FG2' filegroup is full.

CheckDB and CheckFileGroup yielded no errors. UpdateUsage on this DB made a lot of updates, as no regular maintenance is scheduled, but it made no difference in the errors.
I have run out of ideas on this one.
name fileid filegroup size maxsize growth usage
DMART 1 PRIMARY 458037248 KB Unlimited 2097152 KB data only
DMART_log 2 NULL 504 KB Unlimited 102400 KB log only
DMART_Data2 3 PRIMARY 26624000 KB Unlimited 512000 KB data only
FG2Data 4 FG2 26624000 KB Unlimited 512000 KB data only


I plan to bounce the server this evening, to see if that makes a difference. I tried just taking it offline and bringing it back on but it had no effect.
Any ideas?

Thanks,
Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Stamey
Stamey
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 999
Bouncing the server made no difference. Still the same error. I am testing with
DBCC ShrinkFile(FG2Data, EmptyFile)
rather than attempting the data load every time.

Thanks,
Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Wayne Evans-440401
Wayne Evans-440401
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 272
A real longshot.

If you back it up and restore to a new named database (leave the original alone) on the same server, same instance same disk, but different folder, will it let you insert a few thousand lines into a new table.

To me it sounds like the area where it keeps its definitions about the database has got corrupt somehow

Wayne



Wayne

Did you get access denied? Great the security works.

Stamey
Stamey
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 999
That's my suspicion, that the file group was corrupted somehow and DBCC doesn't catch the problem. My fix for this was to script out each table on that file group and recreate on the Primary file group then copy all of the data over and rename the tables. The data loads to the new tables went well and I'm getting ready to drop the old table and remove that file group once it is empty.

Thanks,
Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Wayne Evans-440401
Wayne Evans-440401
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 272
Ouch!



Wayne

Did you get access denied? Great the security works.

Stamey
Stamey
SSC Veteran
SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)SSC Veteran (239 reputation)

Group: General Forum Members
Points: 239 Visits: 999
It worked. Once I copied all tables over to the primary files group I dropped the old tables and then that file, from the DB In the primary file group it is able to expand as needed.


Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search