Re: [firebird-support] Bad performance of Firebird in Windows Server 2012
Re: [firebird-support] Firebird backup on virtual machine
W dniu 2015-08-28 o 18:11, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] pisze: > You still need to run the test I outlined... > > Otherwise, you are making several assumptions. The first, is that I am > not a blithering idiot who is spouting nonsense! For now "assumptions" that's all I have. I'm still waiting for some test environment and when I get access to it, it'll be probably too late Macma1 ++ 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] Firebird backup on virtual machine
Hi, > Veeam should not create file corruptions, but rather the backup of the > database could have data from uncommitted transactions, although > present in the db file, would be ignored by the engine (might show up > in the log file). > My biggest concern was that after restore form Veeam backup firebird database file could be damage. If not there is nothing I can worry about. I'm just want to be sure that when someone restore full vmdk file my system will work and survive such operation. Thanks for Your help. Best regards, macma1 ++ 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] Firebird backup on virtual machine
Hi, I have to run Firebird 2.5 in Windows 2012R2 on VMware cluster. All VM machines will be regularly backup with Veeam Backup. I red that such backups could cause database file corruption (inconsistency) within the backup. Is there any method to prevent it? May by there is some way to use nbackup lock future with windows shadow copy to support such solution. Are there any plans to support VSS on Windows in Firebird? I can do regular backup with gbak but i look for some smarter solution to. Any help would be appreciated. macma1 ++ 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] Query stop working after upgrade from 2.1.5 to 2.1.6
Hi, I overcome this issue with this query select ke.I_ID_GRUPY, ke.C_SYMBOL, ( select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS = cs.I_ID_CENY_OKRS) where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA)) ) as C_OPIS_X, sum(ke.N_VALUE) as N_VALUE_SUMA, sum(ke.N_VATIN) as N_VATIN_SUMA, sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA, sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA, ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, ke.SI_CURRENCYPERVALUE from R_KOSZTY k left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY) left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY = ko.I_ID_KOSZT_OKRESY) where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA) group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE order by max(ke.I_ORDER_INDEX) I have to change "where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY" to "kk.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA)". Best Regards, macma ++ 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] Query stop working after upgrade from 2.1.5 to 2.1.6
W dniu 2014-09-03 o 08:51, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] pisze: > > > >Hi, > > > >I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my > >query stop working with error "Dynamic SQL Error SQL error code = -104 > >Invalid expression in the select list (not contained in either an > >aggregate function or the GROUP BY clause)". The same error occur on > 2.5.3 > > > >select > > ke.I_ID_GRUPY, > > ke.C_SYMBOL, > > ( > > select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs > > left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS = > >cs.I_ID_CENY_OKRS) > > where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select > >I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY) > > group by cs.C_OPIS > > ) as C_OPIS_X, > > sum(ke.N_VALUE) as N_VALUE_SUMA, > > sum(ke.N_VATIN) as N_VATIN_SUMA, > > sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA, > > sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA, > > ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, > >ke.SI_CURRENCYPERVALUE > >from > > R_KOSZTY k > > left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY) > > left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY = > >ko.I_ID_KOSZT_OKRESY) > >where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from > >IDY_DO_ZAPYTANIA) > >group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, > >SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE > >order by max(ke.I_ORDER_INDEX) > > > >Any idea how to overcome this issue? > > Hi Macma! > > I would have tried this query (I've assumed that ID is the primary key > of IDY_DO_ZAPYTANIA) and checked whether the result was as desired > (admittedly, I'm not used to using MIN in a subselect): > > select > ke.I_ID_GRUPY, > ke.C_SYMBOL, > (select min(cs.C_OPIS) > from T_CENY_SKLADNIKI as cs > join T_CENY_W_OKRESIE as cwo > on cwo.I_ID_CENY_OKRS = cs.I_ID_CENY_OKRS > join R_KOSZTY kk on cwo.I_ID_CENNIKA = kk.I_ID_CENNIKA > where cs.C_SYMBOL = ke.C_SYMBOL > and kk.I_ID_KOSZTY = ko.I_ID_KOSZTY) as C_OPIS_X, > sum(ke.N_VALUE) as N_VALUE_SUMA, > sum(ke.N_VATIN) as N_VATIN_SUMA, > sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA, > sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA, > ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, > ke.SI_CURRENCYPERVALUE, > max(ke.I_ORDER_INDEX) I_ORDER > from R_KOSZTY k > join R_KOSZT_OKRESY as ko on ko.I_ID_KOSZTY = k.I_ID_KOSZTY > join R_KOSZT_ELEMENTY as ke on ke.I_ID_KOSZT_OKRESY = ko.I_ID_KOSZT_OKRESY > join IDY_DO_ZAPYTANIA z on k.I_ID_KOSZTY = z.ID > where ke.SI_USEINSUMMARY = 1 > group by ke.I_ID_GRUPY, ke.C_SYMBOL, 3, SI_WYKLADNIK, SI_IDJEDNOSTKA, > SI_STPOTYPE, SI_CURRENCYPERVALUE > order by 12 > I get the same error with Your query > > I don't know whether your error is a result of grouping by C_OPIS_X (I > didn't think it was allowed), ordering by a field you do not select (I > added it to the output, change back if this isn't the problem) or > something else. Using LEFT JOIN as opposed to [INNER] JOIN reduces the > options for the optimizer - it is sometimes useful as part of > optimization, but only after experiencing the original query being slow. > > If this doesn't solve your problem, please tell us more about your > table definitions - I've no clue which fields are unique or having > lots of duplicates in your tables, nor which indexes/keys you've > defined and that limits the possible modifications I (and others on > this list) can do to your query. > Here You can download sample database https://sydel.technicon.com.pl/~grzegorz/tmp/EKONOMICZNA.zip I've check that this problem also occur when upgrading from 2.5.2 to 2.5.3 Best Regards, macma > > HTH, > Set > > PS! I've never used Fb 2.1 myself, only 0.9.4, 1.5 and 2.5. > > ++ 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] Re: Query stop working after upgrade from 2.1.5 to 2.1.6
W dniu 2014-09-03 o 08:31, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] pisze: > 03.09.2014 09:44, Macma wrote: >> I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my >> query stop working with error "Dynamic SQL Error SQL error code = -104 >> Invalid expression in the select list (not contained in either an >> aggregate function or the GROUP BY clause)". The same error occur on 2.5.3 > Interesting. The stricter checks were not really intended, it looks like > an indirect result of some bugfix. I hope this issue doesn't reject > formally correct queries. > >> select >>ke.I_ID_GRUPY, >>ke.C_SYMBOL, >>( >>select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs >>left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS = >> cs.I_ID_CENY_OKRS) >>where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select >> I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY) >>group by cs.C_OPIS > Out of curiosity, why both "FIRST 1 cs.C_OPIS" and "GROUP BY cs.C_OPIS"? > The grouping looks redundant here. Because I have to sum all element with the same "ke.C_SYMBOL" and description of that symbol are changing over time i need to display first found. But You right that "group by cs.C_OPIS" are not necessary. >>) as C_OPIS_X, >>sum(ke.N_VALUE) as N_VALUE_SUMA, >>sum(ke.N_VATIN) as N_VATIN_SUMA, >>sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA, >>sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA, >>ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, >> ke.SI_CURRENCYPERVALUE >> from >>R_KOSZTY k >>left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY) >>left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY = >> ko.I_ID_KOSZT_OKRESY) >> where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from >> IDY_DO_ZAPYTANIA) >> group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, >> SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE >> order by max(ke.I_ORDER_INDEX) >> >> Any idea how to overcome this issue? > Instead of grouping on the subquery, you need to group on its > dependencies. At the first glance, there are two of them: ke.C_SYMBOL > and ko.I_ID_KOSZTY. The latter one is missing in the GROUP BY list. When I add "ko.I_ID_KOSZTY" to GROUP BY list the results are not what I expected because I get partial sum for every "ke.C_SYMBOL" and "ko.I_ID_KOSZTY" insted of partial sum of elements with different "ke.C_SYMBOL" only. I share sample database here https://sydel.technicon.com.pl/~grzegorz/tmp/EKONOMICZNA.zip Best Regards, macma > > > > > > > > > ++ > > 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 > > > ++ 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] Query stop working after upgrade from 2.1.5 to 2.1.6
Hi, I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my query stop working with error "Dynamic SQL Error SQL error code = -104 Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)". The same error occur on 2.5.3 select ke.I_ID_GRUPY, ke.C_SYMBOL, ( select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS = cs.I_ID_CENY_OKRS) where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select I_ID_CENNIKA from R_KOSZTY as kk where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY) group by cs.C_OPIS ) as C_OPIS_X, sum(ke.N_VALUE) as N_VALUE_SUMA, sum(ke.N_VATIN) as N_VATIN_SUMA, sum(ke.N_COSTNETTO) as N_COSTNETTO_SUMA, sum(ke.N_COSTBRUTTO) as N_COSTBRUTTO_SUMA, ke.SI_WYKLADNIK, ke.SI_IDJEDNOSTKA, ke.SI_STPOTYPE, ke.SI_CURRENCYPERVALUE from R_KOSZTY k left join R_KOSZT_OKRESY as ko on (ko.I_ID_KOSZTY = k.I_ID_KOSZTY) left join R_KOSZT_ELEMENTY as ke on (ke.I_ID_KOSZT_OKRESY = ko.I_ID_KOSZT_OKRESY) where ke.SI_USEINSUMMARY = 1 and k.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA) group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE order by max(ke.I_ORDER_INDEX) Any idea how to overcome this issue? Best Regards, macma ++ 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/
