Re: [firebird-support] Number of Firebird Users
It has Windows 2003 R2 Server 6 x 18 GB SCSI Raid 4-5 *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > > > > How many concurrent users may be created and connect to a FireBird > > database on such a Server ? > > > > Compaq Proliant ML 370 G1 > > > > Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache > > Without a sense of the load/activity which would be placed on the server > it is impossible to know. > > Also, details about OS and the storage system (IDE HDD, Raid x??) to be > used are required. > > IMO: You are really talking about a system with a very low performance > profile. After all the system would be 15-16 years old!!! > > > Sean > > >
RE: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Thomas, > > For some reason they both have the new value and I can't figure out why. > > If I didn't misread all the articles, I've found, completely, then > > they should be different, shouldn't they? > > > > > > I'm using Firebird 2.5.2.26539. > > Any chance that another trigger is changing the value? I was thinking that myself, but Patrick said that it was the "old" value which was being changed to the "new" value. Another trigger (a BEFORE UPDATE trigger), in a single update operation/chain, can only change the "new" value, nothing should be able to change the "old" value. Sean
Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Hi, > shouldn't the values of new.somefield and old.somefield be different in > an after update trigger, when the value of that field has definitely > changed? > > > For some reason they both have the new value and I can't figure out why. > If I didn't misread all the articles, I've found, completely, then they > should be different, shouldn't they? > > > I'm using Firebird 2.5.2.26539. Any chance that another trigger is changing the value? You might use the Trace API to find out what's going on ... -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
RE: [firebird-support] Number of Firebird Users
> How many concurrent users may be created and connect to a FireBird > database on such a Server ? > > Compaq Proliant ML 370 G1 > > Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache Without a sense of the load/activity which would be placed on the server it is impossible to know. Also, details about OS and the storage system (IDE HDD, Raid x??) to be used are required. IMO: You are really talking about a system with a very low performance profile. After all the system would be 15-16 years old!!! Sean
[firebird-support] Number of Firebird Users
How many concurrent users may be created and connect to a FireBird database on such a Server * ?* *Compaq Proliant ML 370 G1* *Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache * *Kind Regards* *Alain Bastien* *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230 5 719 30 30* *Skype:alainbastien* *Viber: 7320143* On Fri, Aug 19, 2016 at 4:06 PM, Jack Cane jwc...@icloud.com [firebird-support] wrote: > > > Pleaea excuse if this is a repeated submission. I sent the eralier one > p;rior to approval as a member of this list. > > This long-time FireBird user is just returning to active use after some > years' absence. Having a degree of difficulty remembering old techniques > and routines. > > Currently trying to create FDB on the iMac using FlameRobin and RazorSQL. > > Some of my SQL scripts are failing but the causes are not clearly > indicated. System seems to invite user to inspect syntax and make required > changes. I'm reduced to guesswork: try this and see if it fixes the > problem, etc. I guess what I am missing is a deZign-like tool that will > create an error-free SQL script in the Apple-OSX environment, similarly to > deZign in Windows. Alternatively, I'm wondering if there are other, better > editing tools, 3rd-party products for use under OSX, i.e., "smart", > "SQL-aware", etc., editors that guide/prompt the user toward acceptable SQL > syntax. > > I also have a vmWare Virtual Machine (Windows-7) running on the Mac, > containing Firebird, FlameRobin, deZign, etc. Am trying a dual-track > approach (i.e., Windows & OSX) to determine the best envronment to support > my project. For other reasons it is a very attractive alternative to be > able to generate/maintain the FDB on my Mac, if this can be made to work. > > Any ideas appreciated. > > Best, > jwc > >
Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Would it be possible that the original update triggered a second update on the same record, hence the value of new and old are the same? For instance a trigger after update calls a procedure to update the same record, the first run of the trigger will have old <> new, but perhaps on the second run, triggered by the SP, the value of old would be the new value on the first execution of the trigger, and the value of new on the second execution may be the same as old if that field has not changed on the SP. Is that possible? - Original Message - From: patrick_mar...@yahoo.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Saturday, August 27, 2016 8:04 PM Subject: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield Hello, shouldn't the values of new.somefield and old.somefield be different in an after update trigger, when the value of that field has definitely changed? For some reason they both have the new value and I can't figure out why. If I didn't misread all the articles, I've found, completely, then they should be different, shouldn't they? I'm using Firebird 2.5.2.26539. Best regards, Patrick
Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
> Use "IS DISTINCT" instead of "<>". I've tried this too already - still no difference... Some other comparisons with other fields in the same trigger seem to work fine even with '<>', this one doesn't...
Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
27.08.2016 12:04, patrick_mar...@yahoo.com [firebird-support] wrote: > For some reason they both have the new value and I can't figure out why. Use "IS DISTINCT" instead of "<>". -- 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/
Re: [firebird-support] Getting INET/inet_error: read errno = 10054
Thanks. Very usefull feedback. 27. aug. 2016 8.45 a.m. skrev "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" : > > > On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no > [firebird-support] wrote: > > We are running fb 2.5.6 and are getting the INET erorr regularily. > > The error has been there before as well with earlier versions of fb. > > > > Is this something I should be conserned about and what can I do about it? > > Error 10054 is "Connection reset by peer", which means that the server > tried to do something with the network connection from a client, and it > was already closed. This can happen due to network problems, or the > application was terminated abruptly. However the usual main cause is > that connections aren't properly closed, either by your applications (eg > you never close connections, and they are eventually terminated by the > garbage collector), or maybe by the driver you use (eg because its > implementation of a connection close is wrong). > > > Another issue is that when I list transactions I have a transaction that > > is "stuck" back in time but that has no attachemnt associated with it. > > Is this normal? > > > > This is the row from the MON$TRANSACTIONS that have no corresponding > > MON$ATTACHMENTS row: > > 648583083 84322 0 26.08.2016, 19:11:47.489 648583083 648563078 649285961 > > 2 -1 1 0 1 26 0023:0004 > > Assuming the normal order of columns in MON$ATTACHMENTS: > This is transaction 648583083 of attachment 84322, in state 0 (active), > it has READ_COMMITTED_VERSION isolation, wait without timeout (AFAIK), > read-only, no autocommit, with autoundo. > > Maybe the associated attachment got terminated abruptly and Firebird > hasn't yet detected this and rolled back the transaction (or in this > case as it is read only: committed it). If you want to speed it up: a > restart of the Firebird server process would mark it as such IIRC. > > Mark > -- > Mark Rotteveel > >
[firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Hello, shouldn't the values of new.somefield and old.somefield be different in an after update trigger, when the value of that field has definitely changed? For some reason they both have the new value and I can't figure out why. If I didn't misread all the articles, I've found, completely, then they should be different, shouldn't they? I'm using Firebird 2.5.2.26539. Best regards, Patrick
Re: [firebird-support] Getting INET/inet_error: read errno = 10054
Great, Thanks! Sent from Yahoo Mail. Get the app On Saturday, August 27, 2016 7:45 AM, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote: On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support] wrote: > We are running fb 2.5.6 and are getting the INET erorr regularily. > The error has been there before as well with earlier versions of fb. > > Is this something I should be conserned about and what can I do about it? Error 10054 is "Connection reset by peer", which means that the server tried to do something with the network connection from a client, and it was already closed. This can happen due to network problems, or the application was terminated abruptly. However the usual main cause is that connections aren't properly closed, either by your applications (eg you never close connections, and they are eventually terminated by the garbage collector), or maybe by the driver you use (eg because its implementation of a connection close is wrong). > Another issue is that when I list transactions I have a transaction that > is "stuck" back in time but that has no attachemnt associated with it. > Is this normal? > > This is the row from the MON$TRANSACTIONS that have no corresponding > MON$ATTACHMENTS row: > 648583083 84322 0 26.08.2016, 19:11:47.489 648583083 648563078 649285961 > 2 -1 1 0 1 26 0023:0004 Assuming the normal order of columns in MON$ATTACHMENTS: This is transaction 648583083 of attachment 84322, in state 0 (active), it has READ_COMMITTED_VERSION isolation, wait without timeout (AFAIK), read-only, no autocommit, with autoundo. Maybe the associated attachment got terminated abruptly and Firebird hasn't yet detected this and rolled back the transaction (or in this case as it is read only: committed it). If you want to speed it up: a restart of the Firebird server process would mark it as such IIRC. Mark -- Mark Rotteveel #yiv0999123258 #yiv0999123258 -- #yiv0999123258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0999123258 #yiv0999123258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258ads {margin-bottom:10px;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad {padding:0 0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad p {margin:0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad a {color:#ff;text-decoration:none;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc {font-family:Arial;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc #yiv0999123258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc .yiv0999123258ad {margin-bottom:10px;padding:0 0;}#yiv0999123258 #yiv0999123258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0999123258 #yiv0999123258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0999123258 #yiv0999123258activity span {font-weight:700;}#yiv0999123258 #yiv0999123258activity span:first-child {text-transform:uppercase;}#yiv0999123258 #yiv0999123258activity span a {color:#5085b6;text-decoration:none;}#yiv0999123258 #yiv0999123258activity span span {color:#ff7900;}#yiv0999123258 #yiv0999123258activity span .yiv0999123258underline {text-decoration:underline;}#yiv0999123258 .yiv0999123258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0999123258 .yiv0999123258attach div a {text-decoration:none;}#yiv0999123258 .yiv0999123258attach img {border:none;padding-right:5px;}#yiv0999123258 .yiv0999123258attach label {display:block;margin-bottom:5px;}#yiv0999123258 .yiv0999123258attach label a {text-decoration:none;}#yiv0999123258 blockquote {margin:0 0 0 4px;}#yiv0999123258 .yiv0999123258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0999123258 .yiv0999123258bold a {text-decoration:none;}#yiv0999123258 dd.yiv0999123258last p a {font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span.yiv0999123258yshortcuts {margin-right:0;}#yiv0999123258 div.yiv0999123258attach-table div div a {text-decoration:none;}#yiv0999123258 div.yiv0999123258attach-table {width:400px;}#yiv0999123258 div.yiv0999123258file-title a, #yiv0999123258 div.yiv0999123258file-title a:active, #yiv0999123258 div.yiv0999123258file-title a:hover, #yiv0999123258 div.yiv0999123258file-title a:visited {text-decoration:none;}#yiv0999123258 div.yiv0999123258photo-title a, #yiv0999123258 div.yiv0999123258photo-title a:active, #yiv0999123258 div.yiv0999123258photo-title a:hover, #yiv0999123258 div.yiv0999123258photo-title a:visited {text