Subject | cannot restore db (time and timestamp) |
---|---|
Author | pablosanchezuy |
Post date | 2012-06-27T20:22:39Z |
I have converted 2 attributes on table from timestamp to time format, yesterday . Engine didn't complain on that .
I'm trying to restore last night backup from Flamerobin and getting the following error:
Database restore canceled 01:43:40 PM due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -833
expression evaluation not supported
Engine Code : 335544912
Engine Message :
value exceeds the range for a valid time
gds_$send failed
Production server is ubuntu 10.04 linux/amd64, firebird classic v 2.1 ( 2.1.3.18185-0.ds1-6build1 ) .
I'm trying to run un update of both fields to null, but query never gets back (after 12 minutes, i suspended it) . I'm using to restore v 2.5.1.26351 .
Is there any way this can be fixed or should start looking to other alternatives right now?
Regards
Pablo
I'm trying to restore last night backup from Flamerobin and getting the following error:
Database restore canceled 01:43:40 PM due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -833
expression evaluation not supported
Engine Code : 335544912
Engine Message :
value exceeds the range for a valid time
gds_$send failed
Production server is ubuntu 10.04 linux/amd64, firebird classic v 2.1 ( 2.1.3.18185-0.ds1-6build1 ) .
I'm trying to run un update of both fields to null, but query never gets back (after 12 minutes, i suspended it) . I'm using to restore v 2.5.1.26351 .
Is there any way this can be fixed or should start looking to other alternatives right now?
Regards
Pablo