Red Gate forums :: View topic - Error 'Unhandled BLOB type for 231.'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Error 'Unhandled BLOB type for 231.'

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
albsilva



Joined: 01 Jun 2006
Posts: 2

PostPosted: Thu Jun 01, 2006 12:28 pm    Post subject: Error 'Unhandled BLOB type for 231.' Reply with quote

Hi,
I'm getting this error when trying to recover some dropped tables.

I've managed to recover smaller tables (up to 20 records) but with others I get always this error.

I'm using version 1.1.0.229

Thanks,
Alberto Silva
Back to top
View user's profile Send private message
Neil Davidson



Joined: 08 Sep 2004
Posts: 223

PostPosted: Sat Jun 03, 2006 6:12 pm    Post subject: Reply with quote

Hi,

Is there any chance we can get hold of your live database file, transaction log, and any backups you're attaching?

If so, can you e-mail them to support@red-gate.com

- Neil
_________________
- Neil Davidson
Red Gate Software Ltd
Back to top
View user's profile Send private message
albsilva



Joined: 01 Jun 2006
Posts: 2

PostPosted: Sun Jun 04, 2006 11:04 pm    Post subject: Reply with quote

Hi Neil,
I will attend the MEDC Europe this week and the following week I'll send you the files.

Thanks,
Alberto Silva
Back to top
View user's profile Send private message
kevin@anexeon.com



Joined: 03 Oct 2006
Posts: 1

PostPosted: Tue Oct 03, 2006 10:57 am    Post subject: I am getting this error as well Reply with quote

I have gotten all but one table in my database. One table where this error occurred finally worked however there is one that this error continues to appear on.
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6577

PostPosted: Wed Oct 04, 2006 1:00 pm    Post subject: Reply with quote

I think this can happen if there is a significant schema change in a table. Basically, the backup file indicates that the BLOB column is one type (say, an TEXT) and then you change the column to another (say, NTEXT). Log Rescue will then try to retrieve this column as TEXT when it is not.

I don't see any workaround for this. We will definitely look into making Log Rescue more happy about schema changes. If you start with a more recent full backup and compare some more recent logs, I'd imagine that Log Rescue would work just fine.
Back to top
View user's profile Send private message
ringersma



Joined: 23 Feb 2007
Posts: 1

PostPosted: Fri Feb 23, 2007 7:27 pm    Post subject: Solved yet ? Reply with quote

We're also having a problem that a BLOB 231 error is generated.
Has there been anyone who has come up with a workaround solution ?

Annoying also that shift-click for selecting multiple lines doesn't work in the interface so either full select or one-by-one. Tedious work Sad
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group