Hi,
first, this was not good concept to use -mend, as you can loos data. If you
have a copy before this operation bring it back and run gfix without it.
If this is realy index problem you can fix it with simple command Alter index
indexName active;
This will rebuild your index
Regards,Karol Bieni
Hi Dimitry,
is this true? I read many times that this is not safe. I remember that i read
this also on this group and noone say something different. Especially one
thread read some portion of data when another try to retrive different portion
i know that there is statement id, transaction id, co
Hi,
no, you must use separate connection fo this. fbclient.dll is thread safe, but
thinking about thread safe in a level of connection or transaction is not
releated here.
If something was changed in Fb3 i am realy interested.
Regards,Karol Bieniaszewski
null
Do you mean remote connection or local maybe embeded connection?
Regards,Karol Bieniaszewski
null
Hi,
thank you András, but this is what we do already. I mention this in my first
post."Currently we lock customer record and only one user can do
update/insert/delete operation at a time."
But this cause serialisation of operations, only one "user" at same time.This
cause that our server sleep i
Hi,
but this require to have table with all dates. 365 rows per year per customer.
This is not possible solution. This sample with customers was only
simplification. But extend this sample to meeting time date with time. This
table will be too huge...
Regards,Karol Bieniaszewski
null
Hi,
is there a good way to prevent overlaping dates to be inserted to the table?
You know DATE_FROM, DATE_TO and you can have
2018-09-10 to 2018-09-20
and
2018-09-15 to 2018-09-22
they ovelap on 15,16,17,18,19 and 20
No my real sample but simple to understand is:
customer and meeting pla
Hi,
is there a good way to prevent overlaping dates to be inserted to the table?
You know DATE_FROM, DATE_TO and you can have
2018-09-10 to 2018-09-20
and
2018-09-15 to 2018-09-22
they ovelap on 15,16,17,18,19 and 20
No my real sample but simple to understand is:
customer and meeting pla
Hi,
how to identify that connection use WireCompression effectively?
I need to get that info:
1. from client application side
2. from server side
regards,
Karol Bieniaszewski
Hi,
"As far as I remember, aggregate functions also do
not use indexes and will get progressively slower over time."
for min/max index is used if you have ascending for MIN and descending for MAX.
About topic itself. I always use numbering table and i raly on transaction
conflicts.You know if yo
Hi,
Change your table declaration to include separator e.g. line break.
(IP_Address CHAR(15),Myln char(1));
If you have windows style linebreak change myln to 2 chars.
External table is a fastest way, but you must define what do you mean in your
scenario as "large".
Regards,Karol Bieniaszewski
nu
Hi,
may i ask what is the purpose of this hash?
Regards,Karol Bieniaszewski
null
Hi,
i suppose you have name longer in your particular select statement. This can be
e.g. in aliasing a field
Select a.x as veryLongAliasedNameLongerThen31 from ...
But only you can tell in what exact place you got this error
Regards,Karol Bieniaszewski
null
>>I suggest you take this question to the firebird-devel mailing list as
>>it concerns an unreleased version. Questions on FB4 are off topic here.
>>Mark
Yes, but as local_time and local_timestamp was forwarded to FB3 it is important
to know if we need also Local_date as replacement to Current
>>ANSI standard compliance is the answer for all questions
What about last question LOCAL_DATE missed?
Regards,Karol Bieniaszewski
null
Hi,
as this is forwarded to FB3 i ask on support group not devel.
Now we have CURRENT_TIME, CURRENT_TIMESTAMP which get time from server whitout
timezone.
Why you breake backward compatibility in FB4 (FB3 is still ok)?
In FB4 "old" FB3 identifiers
CURRENT_TIME will be LOCAL_TIME
CURRENT_TIME
Hi,
are you sure that you are the only one attachment to the database?Check this by
mon$attachments if present in Fb1.5...You can try to change database file name
if it is changed succesfully then you are the only one.
Try to add some delay after disconnect.
But your real cure is Firebird3.
Regar
I understand that data from real database are restricted.But what is the query
plan for my CTE?Do you have an index on column id_parent?
I am really interested about it in your environment i use it every day.
Regards,Karol Bieniaszewski
null
Hi,
can you show some sample?And what indexes have you created?Can you show plan
for both queries and real queries itself?What filter "where" are you using?
I am really interested because i have compared both queries with much more
populated tables and i have got better results time, fetches and
Hi,
Two questions 1. Why do you remove all FK?2. Why do you still use such old
Firebird version?
Many things was fixed since FB1.5 and i suppose that only real fix to your
problem is using recent FB.
You can try disconnect after every FK.You can also try do select count(*) from
updated tables bu
niu 2018-05-30 10:47:57 użytkownik Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] napisał:
> 30.05.2018 10:45, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
> wrote:
> > it redirect info to the file but errors are not redirected - why?
>
>You forgot &
Hi,
how to redirect output of gbak to the file?
"%FB_DIR%\gbak" -service 127.0.0.1:service_mgr -c -v -BUFFERS 0 -STATISTICS TD
-user SYSDBA -password masterkey %FB_BACKUP%\security3.bak
%FB_RESTORE%\security3.fdb.restored 2>&1 %FB_RESTORE%\rest.security3.rep
> the blob field is a ISC_QUADPtr
> ISC_QUAD = array [1..2] of Integer;
> ISC_QUADPtr = ^ISC_QUAD;
>
> --
> Norbert Saint Georges
> http://tetrasys.fi
Hi,
thank you
in the meantime i have found this:
https://github.com/FirebirdSQL/firebird/blob/master/doc/Using_OO_API.html
i do not know why t
Hi,
can you help me fix below problem?
when connected user try to select on SEC$ for data
he got an error:
find/display record error
no permission for SELECT access to TABLE PLG$SRP.
-
e.g.
SELECT
U.SEC$USER_NAME
, (SELECT UA.SEC$V
>>It is not clear why you included a COLLATE clause in an ALTER DOMAIN
>>statement. You can't change the COLLATE property of a domain, which
>>is why you got the error: COLLATE is not expected in an ALTER DOMAIN
>>statement. But you were not trying to change that, anyway.
>>HB
The question is why i
Hi,
when we create dommain we can do:
CREATE DOMAIN XXX TYPE VARCHAR(50) COLLATE PXW_PLK;
but how to alter this domain to have still collation?
ALTER DOMAIN XXX TYPE VARCHAR(150) COLLATE PXW_PLK;
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unk
Hi,
thank you. I see that in FB3 this is the only way :(This break logic in our
application. Regular user ca not have privileges to change db structure but
with RDB$Admin role he can :(I see that this is implemented only in
FB4tracker.firebird.org/browse/CORE-2557
Regards,Karol Bieniaszewski
n
>It depends on information in IMessageMetadata.
>
> > I have tried:
> > ss: Array[0..199] of Char;
> > ss: Array[0..199] of Byte;
> > ss: Array[0..199] of AnsiChar;
>
>This is a right declaration for CHAR(200).
>
OK
> > ss: String[200];
> >
> > with last string[200] i got result pref
Hi,
how can i grant select on MON$Attachements to normal user
that he/she can see all attachements not only self?
I use Firebird 3.
regards,
Karol Bieniaszewski
Hi,
i do not suppose that this is possible and especially that you should do this.
Better then look at queries and addapt it to real situation.
Regards,Karol Bieniaszewski
null
Hi,
to "backup" statistics you can run query on rdb$indices and rdb$index_segment
tables. And save result to the file.
About table statistics - here is really fine concept that you do not need to
recalculate anything. Table pages count and record size is taken in calc. In
fb3 also record compres
>>Either some GTT was used or temporary >>blob storage was requested. Why do
>>you want it to be prevented?
RAM is fast disc is slow and i have plenty of free RAM. Also i have bigger
cache then database pages count and this operations can be all done in memory.
>>In SS, it will be closed/deleted
Ar you sure that your answers are true?You say that win10 is only a clien and
then that when you restore to update 1709 you see that fb is listen. I suppose
you have Firebird installed on this Win10 machine and it serve client and
server in the same time. Is this true or your config os different
Yes, you have right
but i really try to avoid RAM disc which consume memory always i prefer if some
resource free memory it is available to be consumed by any process.
Do you know why this file is created at all and especially why its handle is
still active in firebird process few days?
Regards
Hi,
can i ask why monitoring tables have not any indexes? Any left join go into
natural scan as we have not hash/merge for outer join (core-4823).
Regards,Karol Bieniaszewski
Hi,
Thank you for the suggestion. We will consider RAM disc uses but first we must
be sure how big it should be to catch all cases.
It should be docummented how temp tables work (maybe it is somwhere?) with temp
files.
Regards,Karol Bieniaszewski
null
Ok, i understand temp file caching but why Firebird create this temp file at
all and how to prevent this?
And second question, why file handle is still active? Is this file for
particular temporary table or it is a buffor for all temporary tables?
Regards,Karol Bieniaszewski
null
>> No, caching is left up to OS.
i do not understand above. I have dissabled os caching in firebird.conf. Also
file is created by Firebird not OS. Can you explain this more?
Regards,Karol Bieniaszewski
null
Thank you for the info
Is there particular settings to go always into RAM or some buffer settings
which i can increase to avoid going to disc?
I have nowTempCacheLimit = 800MMentioned file is 29MB in size and dated 2 days
old and its handle is still in use by Firebird process
Regards,Karol Bienia
Hi,
what is the purpose of temp file named e.g.fb_table_yfz4x5?I use FB3
regards,Karol Bieniaszewski
Ach now it is clear.
All work ok. You got false for char(5) because it work the same way as it is
working for LIKE with char.
TrySelect cast('ABCD' as char(5)) like 'ABCD' from rdb$database
Regards,Karol Bieniaszewski
null
Hi,
It is false for meBut i put '=' in single quote with double it does not work. I
use FB3.0.4.32954 dialect 3
Regards,Karol Bieniaszewski
null
Hi,
I need to add Field not null constraint with my custom name.
in previous versions of Firebird we can do:
1. ALTER TABLE XXX ADD FIELDX INTEGER CONSTRAINT NK_XXX__FIELDX NOT NULL;
2. UPDATE TABLE XXX SET FIELDX=some calculations;
Now in Firebird 3 this is prohibited on table with data.
Hi,
I do not work with linux buDid you compiled it as 64bit? And is your Firebird
server 64bit?
Regards,Karol Bieniaszewski
null
Hi Steve,
can you point me into one example about sentence mentioned by you"Firebird's
implementation of SQL is a very strict implementation of the SQL-92 Standard.
As a result, this makes Firebird-SQL not only very limited in what it can do
when compared to other SQL dialects but extremely fru
Hi,
What if you do not ommit servername on server side? Is this working? If not
then service is not running or fbconfig have only local connections plugin set
(if it is Firebird 3)
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "dco...@sympatico.ca
[firebird-support]" Dat
Hi,
can someone point me how can i map windows group to the Firebird role?I have
tried already
CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group
'rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY
I have also tested with prefix xcorp\rFirebird... mapping was created but
-3-2018 14:29, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> My firebird.conf settings are:
>> Auth_Server = Srp
>> AuthClient = Srp, Win_Sspi, Legacy_Auth
>> User_Manager = Srp
It is also UserManager, not User_Manager.
>> What more should i
rt windows auth?
Regards,Karol Bieniaszewski
Oryginalna wiadomość ----Od: "liviuslivius
liviusliv...@poczta.onet.pl [firebird-support]"
Data: 26.03.2018 11:23 (GMT+01:00) Do:
firebird-support@yahoogroups.com Temat: [firebird-support] Fire
Hi,
in Firebird 2.5 there was Autentication parameter in Firebird.conf. It have
values like NATIVE, MIXED or TRUSTED. I do not see it in Firebird3
firebird.conf. Can someone point me to the right config?
Regards,Karol Bieniaszewski
Hi,
Firebird uses carefull writes but this have less importance today bacause below
are array buffers, disc buffers and system buffers. But what was in
firebird.log when you run gfix -validate -full on that database before you
backup it and restore?
Regards,Karol Bieniaszewski
null
Hi,
One transaction have benefits like integrity. If your process must be
accomplished as a whole it is only good way for this. Your statments are
executed serial. For parallel you will need many connections at the same time.
Regards,Karol Bieniaszewski
null
Yes, limiting number of inserts can help but.
What kind of connectivity components are you using? If firedac, then look at
array dml. It make prepared execute block for you and i can get performance e.g
200 000 records per second.
You have small record sets to import, then write insert one by one
Hi.
Your trigger set FK_ID not PK_ID
Regards,Karol Bieniaszewski
null
Show query plans for both situatios fk an index.
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "antoedinchar...@gmail.com
[firebird-support]" Data: 24.02.2018 11:40
(GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-support]
Foreign Key & Query Perform
Hi,
How to add permission to login into security3.fdb?
regards,Karol Bieniaszewski
And if i understand corectly you can have different users acros databases and
different users properties
Regards,Karol Bieniaszewski
null
Check your system32 or syswow64 for firebird client versions and look if you
have not some conflict with Interbase installed with Delphi
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "craig_...@coxcolvin.com
[firebird-support]" Data: 16.02.2018 23:38
(GMT+01:00) Do: fi
Hi,
Did you know if there is some formating which can be included in report
submited to Firebird bug tracker? Some bb-code or something like that?
Pozdrawiam,Karol Bieniaszewski
Hi,
Yes, but source of one column is ommitedVAREFRVSTR_DETAIL.LAENGDE_NAVNYou
group by VAREFRVSTR.LAENGDE_NAVN
Change your group by or change source of column in subquery
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk
[firebird-support]" Da
Hi,
Your bolded subquery need to have value e.g. VAREPLU_ID but you not group by
this field and server do not know its value then
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "michael.vilhelm...@microcom.dk
[firebird-support]" Data: 07.02.2018 22:24
(GMT+01:00) Do: fi
Hi,
what do you mean by maintain here? Do you have custom user information table or
not? If not then what do you need to store in this context var?
I supposed that you have custom user information table and you need to match
your user record with server user to know who is logged into the server.
Hi.
I see no difference. You join your custom table with MON$Attachments and you
are safe here because if user is not logged you have not row in mon$table.
E.g. you have tableWorker with fieldsIdName Age...User_name
And you join
Select * from mon$attachments A inner join workers W where
A.mon$us
Hi,
i see no problem until your particular views do not include some order by
features
But as always, doing tests self is the best way.
Regards,Karol Bieniaszewski
null
Hi,
what do you suppose we can do with your email without any example?
Regards,Karol Bieniaszewski
null
Hi,
1. Show us stats from gstat -h from working system i do not belrve that you
have 3 transactions working whole the time. I suppose here that you have
transaction management problem - i guess2. Consider bigger page size but i do
not know how your insert/update scenario looks like and if this n
Hi,
Please show how exactly resultset should be because i now do not understand
your needs. Query return path and return in order a before b what more?
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "josef.gschwendt...@quattro-soft.de
[firebird-support]" Data: 07.11.2017
Hi,
What is the order of cascade firing for foreign key. How to gain control to it?
Eg. 3 tables 2 reference 13 referece 1 and 2
How can i fire update on table 1 cascade in the correct order to avoid
violation of keys?
Regards,Karol Bieniaszewski
Hi,
You can also look at sample at
http://itstop.pl/pl-pl/porady/Firebird/FAQ1/czas-ostatniej-modyfikacji-tabeli
It is in PL lang but triggers are fully descriptive. I prefer generator based
approach
Regards,Karol Bieniaszewski
null
Hi,
use triggers on tables for this.
Regards,Karol Bieniaszewski
null
Please define "set"
Regards,Karol Bieniaszewski
null
Hi,
group by + havingis your friend.E.g.Select field1, field2, count(*)From
tablexGroup by field1, field2Having count(*)>1
But in your scenario i do not know if this is the solution. Question is if
record was changed and in next update "restored" and once again changed is this
duplicate or no?If
Yes,
You must first impersonate user for the current thread and then you can login
to fb from that thread
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "'Nikolaus Kern' parzival1...@gmx.at
[firebird-support]" Data: 20.09.2017 17:10
(GMT+01:00) Do: firebird-support@yaho
Hi,
It is possible but you must change current thread credentials. I do not
remember now api call but look in the google for changing credential for the
thread
Regards,Karol Bieniaszewski
null
No. I only point you how to check this.
From your header you can read that oldest active and next transaction have only
5 transactions gap. Other numbers you can progress by running sweep.
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "shg_siste...@yahoo.com.ar
[firebird
Hi,
Run Select * from mos$transactions
Then you will see if you have long running
Regards,Karol Bieniaszewski
null
Hi,
For point 4 simply start readonly transactionIf it raise exception you got info
about reason.Also it is good to start transaction and rollback it if you
doesn't need to modify something
Regards,Karol Bieniaszewski
Wysłano z mojego smartfonu w PLAY
Oryginalna wiadomość Od:
Hi,
This whole discussion is strange to me.Rename table while are pending inserts
to it?How. If statment like rename table exsist then after name has changed all
applications must be recompiled to take this new name into account. This looks
to me that discussion is not about real problem. Only a
Hi,
Is there a way to detect throught mon$ tables or trace or other way disk
operations caused by query? I see only page_reads and page_writes, page_marks,
page_fetches but how to distinguish which one:1. Page is read because missed in
cache2. Page is read/write beacause of big sort operation3.
Hi Dmitry,
current snapshot: WI-V3.0.2.32691 Firebird 3.0
CREATE UNIQUE DESCENDING INDEX IXDU_SENSOR_DATA__ID ON SENSOR_DATA (ID);
ID bigint
selectivity
PK_SENSOR ASC ID 0.25
UK_SENSOR__SENSOR_UID ASC SENSOR_UID 0.25
FK_SENSOR_DATA__SENSOR ASC ID_SENSOR 0.25
IXDU_SENSOR_DATA_
Hi,
Firebird3
SELECT FIRST 1 S.SENSOR_UID, S.NAZWA, SD.ID, SD.ID_SENSOR, SD.DT, SD.WARTOSC,
SD.FLAGS
FROM SENSOR_DATA SD
INNER JOIN SENSOR S ON S.ID=SD.ID_SENSOR
WHERE S.ID=1
ORDER BY SD.ID DESC
plan is "wrong"
PLAN SORT (JOIN (S INDEX (PK_SENSOR), SD INDEX (FK_SENSOR_DATA__SENSOR)))
Execut
Good point about expression index :)
but i am talking generally (ommit expression index)
regards,
karol Bieniaszewski
W dniu 2017-02-03 08:05:45 użytkownik ma_go...@yahoo.com [firebird-support]
napisał:
Hi!
You cannt have expression in unique key, but you can have expression index with
un
Do you have also Interbase instaled there?
regards,
Karol Bieniaszewski
W dniu 2017-02-01 19:44:48 użytkownik 'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support] napisał:
Please send your question to the Firebird-java list instead. If you do that,
make sure to include more informati
Hi,
this is offtopic but...
Is there any particular reason to not use always unique constraint instead of
unique index?
Some overhead? Some speed difference in insert,update,delete?
Or this is only to disable creating FK on such fields included in index but not
as constraint?
regards,
Karol
Hi,
have you something like QuickStartGuide? :)
regards,
Karol Bieniaszewski
W dniu 2017-01-16 18:29:50 użytkownik peshk...@mail.ru [firebird-support]
napisał:
FB 3.0.0: http://web.firebirdsql.org/download/prerelease/android/
Not new but should be enough to begin
Carlos,
it was not tested because people do not know about it.
We are really interested in :)
Please announce it on the page ad you will see how big interest it take :)
regards,
Karol Bieniaszewski
W dniu 2017-01-16 15:05:06 użytkownik 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-s
Hi,
dbClick on IBTransaction component and you got Transaction editor - and there
you have all values
google for each value
regards,
Karol Bieniaszewski
W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
I am using TIBSQL, TIBDatabas
Hi,
rather simple operation but can take very long time if database is big.
You can write stored procedure - or EXECUTE BLOCK
and inside iterate by system tables RDB$RELATIONS and RDB$RELATION_FIELDS
and do EXECUTE STATEMENT with where condition
and return back sum of fields '||' and table name w
Hi,
"case" is function and operate on row data.
If you have 7 rows then you got 7 rows after case
To reduce rows you need to "group by"
regards,
Karol Bieniaszewki
W dniu 2017-01-05 13:12:10 użytkownik 'Stef' s...@autotech.co.za
[firebird-support] napisał:
Good day everybody,
I
Hi,
when you migrate something and this is reserved word you name it with quotes,
and also if it contain space
but i prefer in that migration to change the name instead using double quotes.
But another place where it is vital to have double quotes supported is
select field as "some name for fiel
Hi,
did you mean rollback? not commit?
regards,
Karol Bieniaszewski
W dniu 2016-12-14 17:44:16 użytkownik Jaume Llunell Gómez
jaumellun...@gmail.com [firebird-support]
napisał:
Hi,
is it possible to commit a transaction that is hanged in the MON$TRANSACTION
table by ID?
I've seen th
Hi,
this is only for info if someone is worry about FB3 stability.
I run very big deletion statement in concurrent env - i clear 90% of old
historical data from database
and FB run without any problem this big command :)
below are stats:
Executing statement...
Statement executed (elapsed tim
Hi
i do not read your whole info but maybe you need to use case statement
e.g your 3 update statements can be changed fro:
Update table set prio = newprio(1) where id = 20;
Update table set prio = prio – 1 where prio < newprio;
Update table set prio = prio + 1 where prio > newprio;
to one:
Hi,
i agree with you
i suppose that time spend by GC should be measured and if it take to much time
then stop GC and try again leter.
E.g. when i do delete from milions_table
and then do SELECT COUNT(*) form milions_table
it should not clear whole garbages and stop query until GC finished.
e.g.
hi,
do this in packets.delete 10 commit and then count. sleep and once again
until finished.
bu check also on Firebird 3 and tell us if your issue is still there
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "kragh.tho...@yahoo.com [firebird-support]"
Data: 2
simple session id maitenanceread about
read also about No SQL databases
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "Alain Bastien alainbast...@gmail.com [firebird-support]"
Data: 28.10.2016 12:00 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: {
No - you can have aplication server between to serve data to web server
and it e.g. run limited number of connection (espessialy 1 connection to
database)
and login and password can be not the db user only application user (table of
users and paswsword hash)
regards,
Karol Bieniaszewski
W
hi,
maybe MERGE is your answer
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "ehmmm.fireb...@seznam.cz [firebird-support]"
Data: 19.10.2016 09:34 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebird-support] Optimizer request
W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] napisał:
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS
Hi,
i know
Cast('XXX' AS Integer)
but is there
try_Cast('XXX' AS Integer)
like in MSSQL?
you know if something can not by converted then return null.
regards,
Karol Bieniaszewski
101 - 200 of 313 matches
Mail list logo
