[firebird-support] Backup error
Hi, Does anybody have any idea what could cause the following error on backup using FB2.5 regards Si *** IBPP::SQLException *** Context: ServiceImpl::Wait Message: isc_service_query failed SQL Message : -902 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements Engine Code: 335544333 Engine Message : internal Firebird consistency check (wrong record length (183), file: vio.cpp line: 1139) gds_$receive failed
Re: [firebird-support] Backup error
Hello, This is a database corruption, most likely caused by bad RAM. Another reason could be accessing Firebird database with wrong version of engine (InterBase? old Firebird?). Download free FBFirstAID version, check your database and send log for free investigation to our support team: support at ib-aid.com.com We'll check it. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) > Hi, > > Does anybody have any idea what could cause the following error on > backup using FB2.5 > > regards > > Si > > *** IBPP::SQLException *** > Context: ServiceImpl::Wait > Message: isc_service_query failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes > successful execution of subsequent statements > > Engine Code : 335544333 > Engine Message : > internal Firebird consistency check (wrong record length (183), file: > vio.cpp line: 1139) > gds_$receive failed > > [Non-text portions of this message have been removed]
Re: [firebird-support] Re: fb server crash
On 16 January 2012 19:12, Dmitry Yemanov wrote: > 16.01.2012 18:42, Nick Upson wrote: > > > I've just found http://tracker.firebirdsql.org/browse/CORE-2630 > > > > which leads to http://tracker.firebirdsql.org/browse/CORE-2993 which > says > > its fixed in 2.1.4 > > They're unrelated, I believe. And once again, I suggest you to avoid > using nbackup. > > > Dmitry > please could you expand on that advice, what is the problem with nbackup in 2.1.4? Nick Upson [Non-text portions of this message have been removed]
Re: [firebird-support] Re: fb server crash
> > They're unrelated, I believe. And once again, I suggest you to avoid > using nbackup. > > > Dmitry Avoid using nbackup or nbackup before 2.5? Jesus
[firebird-support] Re: fb server crash
17.01.2012 15:00, Jesús García wrote: > > Avoid using nbackup or nbackup before 2.5? The latter, if you use Classic under high load. Dmitry
[firebird-support] Hiow to corrupt a Firebird database
Hi, I was under the impression that copying a database that is currently in use can cause a corruption because windows xcopy might deny the Firebird server access to that file momentarily. I was looking for an official statement on this for a customer of mine and found this: http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html but it doesn't include the copying/zipping of a live database. Is the documentation out of date, or is it not an issue any more? Regards Maya PS. Similarly, in the past, I have also been advise to keep connection strings exactly the same from all client connections, but I can't see anything on that either [Non-text portions of this message have been removed]
[firebird-support] Re: fb server crash
17.01.2012 14:06, Nick Upson wrote: > please could you expand on that advice, what is the problem with nbackup in > 2.1.4? It's really hard to explain briefly, but nbackup has some known issues that may manifest themselves under high load with the Classic architecture. Lock manager problems are one of those visible effects. In order to solve them, there was a major redesign of the whole nbackup subsystem in v2.5 and so far we don't known about any known problems there in this regard. Dmitry
Re: [firebird-support] Hiow to corrupt a Firebird database
On Tue, 17 Jan 2012 11:44:53 +, Maya Opperman wrote: > Hi, > > I was under the impression that copying a database that is currently in > use can cause a corruption because windows xcopy might deny the Firebird > server access to that file momentarily. I was looking for an official > statement on this for a customer of mine and found this: > > http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html > > but it doesn't include the copying/zipping of a live database. Is the > documentation out of date, or is it not an issue any more? > > Regards > Maya > > PS. Similarly, in the past, I have also been advise to keep connection > strings exactly the same from all client connections, but I can't see > anything on that either I actually believe (but I am not sure) it is not the original database that you can corrupt this way, but the copy is very likely to get corrupted as it will have an inconsistent view of the database content. I do not think that the (x)copy locks the file when performing the copy. Mark
[firebird-support] alter column drop default (firebird 2.x)
Hi, If I want to drop a column-level default, in firebird 2.x I can do ALTER TABLE tablename ALTER [COLUMN] colname DROP DEFAULT But, if [COLUMN] has not a default value setting, that statement raise an error. The question is, How can I to know if a field has set a default value? Query against system tables? Which one? Thanks in advance Maxi.
Re: [firebird-support] alter column drop default (firebird 2.x)
> If I want to drop a column-level default, in firebird 2.x I can do > > ALTER TABLE tablename ALTER [COLUMN] colname DROP DEFAULT > > But, if [COLUMN] has not a default value setting, that statement raise > an error. > The question is, How can I to know if a field has set a default value? > > Query against system tables? Which one? The following gives you all fields for a given relation and a separate field if the field has a default value. Change the query for your needs. select rf.rdb$relation_name , rf.rdb$field_name , case when f.rdb$default_value is not null then 1 else 0 end has_default from rdb$fields f join rdb$relation_fields rf on f.rdb$field_name = rf.rdb$field_source where rf.rdb$relation_name = Hope this helps. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ http://www.firebirdsql.org/en/firebird-foundation/ > Thanks in advance > Maxi. > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++ > Yahoo! Groups Links > > >
Re: [firebird-support] Hiow to corrupt a Firebird database
Hello Maya, Not everything is listed there. More details can be found here: "Firebird and InterBase corruptions reasons" http://ib-aid.com/articles/item70 Regards, Alexey Kovyazin IBSurgeon > Hi, > > I was under the impression that copying a database that is currently > in use can cause a corruption because windows xcopy might deny the > Firebird server access to that file momentarily. I was looking for an > official statement on this for a customer of mine and found this: > > http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html > > but it doesn't include the copying/zipping of a live database. Is the > documentation out of date, or is it not an issue any more? > > Regards > Maya > > PS. Similarly, in the past, I have also been advise to keep connection > strings exactly the same from all client connections, but I can't see > anything on that either > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]
Re: [firebird-support] Backup error
Thanks, I will look into this rgds Si On 17 January 2012 08:30, Alexey Kovyazin wrote: >Hello, > > This is a database corruption, most likely caused by bad RAM. > Another reason could be accessing Firebird database with wrong version of > engine (InterBase? old Firebird?). > > Download free FBFirstAID version, check your database and send log for > free investigation to our support team: support at ib-aid.com.com > We'll check it. > > Regards, > Alexey Kovyazin > IBSurgeon (www.ib-aid.com) > > > > > Hi, > > Does anybody have any idea what could cause the following error on > backup using FB2.5 > > regards > > Si > > *** IBPP::SQLException *** > Context: ServiceImpl::Wait > Message: isc_service_query failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes > successful execution of subsequent statements > > Engine Code : 335544333 > Engine Message : > internal Firebird consistency check (wrong record length (183), file: > vio.cpp line: 1139) > gds_$receive failed > > > > [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Hiow to corrupt a Firebird database
> I was under the impression that copying a database that is currently in use > can cause a corruption because windows xcopy might deny the Firebird server > access to that file momentarily. I was looking for an official statement on > this for a customer of mine and found this: > > http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html > > but it doesn't include the copying/zipping of a live database. Is the > documentation out of date, or is it not an issue any more? Others have replied on that already. > Regards > Maya > > PS. Similarly, in the past, I have also been advise to keep connection > strings exactly the same from all client connections, but I can't see > anything on that either AFAIR, this was an issue in InterBase 6 (or even pre V6?) which has been fixed in Firebird 1.0. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ http://www.firebirdsql.org/en/firebird-foundation/
RE: [firebird-support] Hiow to corrupt a Firebird database
>> I was under the impression that copying a database that is currently >> in use can cause a corruption because windows xcopy might deny the >> Firebird server access to that file momentarily. I was looking for an >> official statement on this for a customer of mine and found this: >> http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html >> but it doesn't include the copying/zipping of a live database. Is the >> documentation out of date, or is it not an issue any more? >Not everything is listed there. >More details can be found here: "Firebird and InterBase corruptions reasons" >http://ib-aid.com/articles/item70 Oooo, lovely, thanks!
[firebird-support] stored procedure with list of values as input parameter
how to create a stored procedure having a list of values as input parameter? I need to retrieve result for query looking like select field1, field2 from table1 where field3 in (1, 2, 3, 4); is there a way to give list of values as input parameter? but sometimes there could be just one value for input. so it should work also for select field1, field2 from table1 where field3 in (1);
Re: [firebird-support] Re: fb server crash
thanks, thats great Nick Upson On 17 January 2012 12:00, Dmitry Yemanov wrote: > ** > > > 17.01.2012 14:06, Nick Upson wrote: > > > please could you expand on that advice, what is the problem with nbackup > in > > 2.1.4? > > It's really hard to explain briefly, but nbackup has some known issues > that may manifest themselves under high load with the Classic > architecture. Lock manager problems are one of those visible effects. In > order to solve them, there was a major redesign of the whole nbackup > subsystem in v2.5 and so far we don't known about any known problems > there in this regard. > > Dmitry > > > [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[firebird-support] stored procedure with list of values as input parameter
(my previous post appeared under another thread, as I did reply. I write again to start new thread - sorry if someone gets 2 times). how to create a stored procedure having a list of values as input parameter? I need to retrieve result for query looking like select field1, field2 from table1 where field3 in (1, 2, 3, 4); is there a way to give list of values as input parameter? but sometimes there could be just one value for input. so it should work also for select field1, field2 from table1 where field3 in (1); thank you.
Re: [firebird-support] stored procedure with list of values as input parameter
Hi,
Maybe someone will come up with a more elegant solution, but if not,
here's a simple trick.
Pass your list of values as a string, separating values with commas
(take care not to add extra spaces between values etc.). Suppose the
parameter name in the procedure is par_list and the string
"7,9,34,2,372" was passed as the actual argument.
Then, inside the procedure, you add extra delimiters at the beginning
and end of the parameter:
par_list = ','||par_list||',';
to make sure each value has commas on both sides (we'll need it to
prevent e.g. 7 to be matched with 17).
Then you compose your select this way:
select field1, field2 from table1
where :param_list like '%,'||field3||',%'
If field3=34, the condition is satisfied (',7,9,34,2,372,' is like
'%,34,%'). If, on the other hand, field3=37, the condition is not
satisfied (',7,9,34,2,372,' is not like '%,37,%').
You can use :param_list containing ','||field3||',' as well.
I know it's not very sophisticated, but I've used it on some occasions
and it does the job. However, alternative solutions are welcome.
regards
Tomasz
on 2012-01-17 17:44, Net Newbie wrote:
> (my previous post appeared under another thread, as I did reply. I write
> again to start new thread - sorry if someone gets 2 times).
>
> how to create a stored procedure having a list of values as input parameter?
> I need to retrieve result for query looking like
>
> select field1, field2 from table1 where field3 in (1, 2, 3, 4);
>
> is there a way to give list of values as input parameter? but sometimes
> there could be just one value for input. so it should work also for
> select field1, field2 from table1 where field3 in (1);
>
> thank you.
>
--
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__
Re: [firebird-support] stored procedure with list of values as input parameter
On Tue, Jan 17, 2012 at 11:44 AM, Net Newbie wrote: > > how to create a stored procedure having a list of values as input parameter? Its not simple, but it can be done using a string parameter (e.g. "1, 2, 3, 4") and creating a SQL string that you feed to EXECUTE STATEMENT. > I need to retrieve result for query looking like > > select field1, field2 from table1 where field3 in (1, 2, 3, 4); > Good luck, Ann
[firebird-support] MS Access ODBC to Firebird
Hello, A cli e nt recently had their application changed to run firebird rather than paradox . It worked fine, with MS Access apps connecting to provide data feeds from firebird. It is version 1.5 I am told. Then it was moved to a windows server 2008. I can no longer get MS Access to connect to the the firebird tables. The problem seems to be in the ODBC setup, I can't run an effective test that sets up and stores the user name and password. The connection to the MS Access dbs is via remote desktop as well, in case that matters. My questions are these. What ODBC driver should I install on the server, and should it be under remote desktop session or directly form eth console.? Firebird is version 1.5 I am told, what ODBC driver is best.? Should it be 32 bit or 64 bit driver? Is there any other clues you may be bale to offer to get this connected? there eseems to be an issue in how the path to the data source is described, it workd sometimes as " localhost: p:\ dir1\dir2zapp.xyz", and sometimes without the localhost bit, which i think relates to it being a remote connection. Any help greatly appreciated. Best Peter Marshall [Non-text portions of this message have been removed]
