[firebird-support] concat a integer variable to a varchar
Re: [firebird-support] concat a integer variable to a varchar
04.01.2019 11:26, leaw...@gmx.de [firebird-support] wrote: > that does not work - Unknown Column error -206 RTFM Language Reference. In SQL queries PSQL variables must be used with colon. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Aw: Re: [firebird-support] concat a integer variable to a varchar
[firebird-support] How safe is the restart of Firebird 3.0 Windows service/Nix daemon?
Hi! Sometimes I need to alter procedures on running Firebird 3.0 database and I need to disconnect all the users for doing that (there is 'procedure in use' control exception, there is no similar control for triggers). Sometimes I have no other option than to restart Firebird Windows service/Nix daemon and then run alter procedure script. So - my question is - how safe is the usual restart of Windows service/Nix daemon? Can I rely that Firebird gracefully makes all the pending writes to the disk, releases all the necesary resources and (the most important part of my quetion) that the restart can not lead to the gds inconsistency check errors?
[firebird-support] Re: How safe is the restart of Firebird 3.0 Windows service/Nix daemon?
Especially - what happens to the SQL (especially update) commands that are running during the restart of the service? I know that service is not waiting for the completion of those commands. I fear that some interrupted commands can introduce gds corruption errors, that is my greated concern in the case of routine use of service restart.
Re: [firebird-support] How safe is the restart of Firebird 3.0 Windows service/Nix daemon?
04.01.2019 14:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I need to alter procedures on running Firebird 3.0 database and I need to > disconnect all > the users for doing that (there is 'procedure in use' control exception You just must perform ALTER in WAIT transaction. If it is not enough, use database shutdown with force disconnect of ordinary users. In both cases there is no need to restart server. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Possible problem garbage collector in 32bit 2.5.8
I have a few customers still working on XP with Firebird 2.5.8 32 bit. And it seems that a problem is introduced in 2.5.7 or 2.5.8. In semi regular periods, the Firebird server hangs (hogs CPU). This reappears after a restart of the Firebird server and accessing the database again. Only solution is making a backup, without Garbage collection, and restore. I can deliver databases with the problem for reproduction.
Re: [firebird-support] Possible problem garbage collector in 32bit 2.5.8
[firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
I tested a few problematic databases with gfix: Number of record level errors : 1 Number of database page errors : 374 Number of record level errors : 2 Number of database page errors : 67 Number of record level errors : 2 Because some customers have a bad habit when switching of computers, I register abnormal termination of my program. I can also detect power failures etc with this feature. But it seems normal.
Re: [firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
04.01.2019 19:50, dam...@wxs.nl [firebird-support] wrote: > Because some customers have a bad habit when switching of computers, I > register abnormal > termination of my program. I can also detect power failures etc with this > feature. But it > seems normal. But the databases definitely got corrupted. Do they have forced writes on? -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
Transactions don't seem to cause the problems: Database header page information: Flags 0 Checksum12345 Generation 1399534 Page size 16384 ODS version 11.2 Oldest transaction 1399407 Oldest active 1399491 Oldest snapshot 1399491 Next transaction1399516 Bumped transaction 1 Sequence number 0 Next attachment ID 261181 Implementation ID 16 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation date Nov 7, 2018 18:06:33 Attributes force write Variable header data: Sweep interval: 2 *END*
[firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
I tested a few databases with gfix: Number of record level errors : 1 Number of database page errors : 374 Number of record level errors : 2 Number of database page errors : 67 Number of record level errors : 2 So there are problems in the database. I have added a feature in my software for the usage and termination registration. It seems al normal. So no bad behaviour or power failures. Maybe it is the hardware. But suddenly a large increase of problems with a few different customers puts my suspicion also on the latest Firebird 2.5.8 self.
Re: [firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
[firebird-support] Re: Possible problem garbage collector in 32bit 2.5.8
Yes, I have shutdown Firebird (via Services) and copied the FDB file. After restart of the Firebird service and restart of my own program, Firebird "hangs" again. I took the FDB file to my own computer (Firebird 2.5.8 64 bit) and did run gstat on it.