On Sat, Jan 23, 2016 at 9:41 AM, Martin Schwedhelm silo...@yahoo.com
[firebird-support] wrote:
>
>
> I have multiple (8) databases where no connection is possible and gfix
> prints the above message.
>
> Firebird version: 2.5.2
> Operating system: Windows 2003 -
On Tue, Mar 1, 2016 at 6:02 AM, jojecodewo...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> My firebird database got corrupted and I am trying to retrieve it. For
> retrieving database I tried using *gfix.exe* and its commands and got my
> tables back but
On Tue, Mar 15, 2016 at 8:04 AM, Tim Ward t...@telensa.com
[firebird-support] wrote:
>
>
> Now, I seem to recall seeing somewhere that actually a primary key (and
> any other unique index?) is independent of transactions, so the following:
>
> (1) Transaction A
On Mon, Mar 14, 2016 at 5:30 PM, setysvar setys...@gmail.com
[firebird-support] wrote:
>
>
> Hi Karol! At the risk of this being confusing or even incorrect (I trust
> Dmitry or Ann will correct if it is incorrect).
>
> >SELECT * FROM dbo.XXX X WHERE X.A BETWEEN
On Mon, Mar 14, 2016 at 3:41 AM, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> W dniu 2016-03-14 08:36:40 użytkownik Dmitry Yemanov
> dim...@users.sourceforge.net [firebird-support] <
> firebird-support@yahoogroups.com> napisał:
>
>
> >
On Thu, Apr 7, 2016 at 11:28 AM, korkl...@yahoo.it [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> hi, i'm trying to repair a corrupted db for firebird 2.5.2, the database
> file is of about 30 gb.
>
> i have disconnected all the user, i did a copy of the file and then i
>
On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com
[firebird-support] wrote:
> 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl
> [firebird-support] írta:
> >
> >
> > For a join (inner join), the rows must exist in both
On Thu, Apr 7, 2016 at 3:41 PM, Ann Harrison
wrote:
> On Thu, Apr 7, 2016 at 2:27 PM, Gabor Boros gaborbo...@yahoo.com
> [firebird-support] wrote:
>
>> 2016. 04. 07. 19:31 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl
>>
On Thu, Mar 24, 2016 at 7:24 AM, brucedickin...@wp.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> I have two procedures:
>
> 1. PROC_A
> 2. PROC_B - which is using internally PROC_A.
>
> Now, I've made some changes in PROC_A, do I need to recompile PROC_B as
> well?
>
On Thu, Mar 24, 2016 at 5:13 PM, 'Wodzu' brucedickin...@wp.pl
[firebird-support] wrote:
>
>
> I would have to dig in for example o that behavior, maybe it only seemed
> to me that this has occurred.
>
Don't bother digging, but if it happens again, take notes.
On Thu, Mar 3, 2016 at 11:16 AM, 'Checkmail' check_m...@satron.de
[firebird-support] wrote:
>
>
>
> I’ve postet my problems with the new odbc driver and firebird 2.5 cs, the
> slow queries and all other issus. Now I have installed the firebird 3.0
> rc2, the
On Fri, Mar 4, 2016 at 3:22 AM, 'Checkmail' check_m...@satron.de
[firebird-support] wrote:
>
>
>
> If I must go back tot he 2.5 version of firebird, how can I gbak the new
> backup-file to the old version?
>
If you haven't used V3 features in data definitions
On Mon, Apr 4, 2016 at 2:41 AM, 'Andrew Zenz' and...@aimsoftware.com.au
[firebird-support] wrote:
...
>
>
> I am using WI-V2.5.3.26780 Firebird 2.5 ODS 11.2
>
> ...
>
> For both databases while running gbak:
>
> gbak -user sysdba -password masterkey -b -ig -l
On Thu, Apr 28, 2016 at 9:19 AM, Gabor Boros gaborbo...@yahoo.com
[firebird-support] wrote:
> 2016. 04. 28. 14:55 keltezéssel, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] írta:
> > 28.04.2016 13:41, Gabor Boros gaborbo...@yahoo.com
On Thu, Apr 28, 2016 at 11:39 AM, Ann Harrison
wrote:
A lot of stuff including:
> In ancient history, even in read-committed mode, Firebird blocked
> transactions from updating records if the most recent version was created
> by a concurrent transaction. At the time,
Sergio asked why this statement
update stock set actualizar = 0 where 1=1
doesn't update all records in the stock table. First, the clause "where
1=1" is unnecessary. The update statement does not requires a where clause
and in the absence of a where clause, it affects all records
On Mon, Apr 18, 2016 at 10:03 AM, 'Thomas Steinmaurer' t...@iblogmanager.com
[firebird-support] wrote:
> > On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer'
> > t...@iblogmanager.com [firebird-support] >
> >
On Thu, Apr 14, 2016 at 3:17 AM, Luigi Siciliano luigi...@tiscalinet.it
[firebird-support] wrote:
>
>If a user try to connect from two or more PC with same username,
> Firebird accepts the connection but is safe without problems or is best
> to avoid like
On Thu, Apr 28, 2016 at 2:16 PM, Gabor Boros gaborbo...@yahoo.com
[firebird-support] wrote:
> ...
>
> Try to utilize WITH LOCK because I need many unique number generators in
> a table field. Like a generator/sequence but under transaction control.
>
Okay...
On Fri, May 6, 2016 at 2:05 AM, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> He wrote:
>
> all records inserted by tr2 are not updated if tr1 is e.g. snapshot
> or during tr1 update there are inserts.
>
> I wrote:
>
> Actually, that's
On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar
[firebird-support] wrote:
>
> Hello! I have a FB 2.5 database with a tabla "invoices". I need to add a
> field in that table which will be null most of the times. Lefts say, that
> 90% of the records
On Mon, Jul 4, 2016 at 2:52 PM, 'Steffen Heil (Mailinglisten)'
li...@steffen-heil.de [firebird-support]
wrote:
Late, but I was away...
>
> I have a database on a hard drive which is failing. The hard drive already
> has some bad sectors and we are about to
> On Feb 15, 2017, at 6:31 PM, setysvar setys...@gmail.com [firebird-support]
> wrote:
>
>
>
> Den 15.02.2017 17:07, skrev 'Walter R. Ojeda Valiente'
> sistemas2000profesio...@gmail.com [firebird-support]:
>> Hello everybody
>>
>> If I connect to a
> On Feb 28, 2017, at 3:07 PM, Aldo Caruso wrote:
>
> I'm trying to understand interactions between transactions with
> different isolation levels.
The problem is not mixed isolation levels. You would get the same behavior if
all transactions were Snapshot
The scenario (described below in
> On Mar 1, 2017, at 9:53 AM, Aldo Caruso wrote:
>
>
>
> Ann,
>
> Thanks for your detailed answer.
>
> But this leads me to the following question: If snapshot transactions
> have their own copy of the Transaction Inventory Pages ( TIP ), taken when
> the transaction started,
Does the error happen on file creation or after some data has been written?
> On Aug 30, 2016, at 4:36 PM, Nick Upson n...@telensa.com [firebird-support]
> wrote:
>
>
>
> no, not a file name collision and plenty of disk space
>
> this just started
On Fri, Sep 9, 2016 at 8:30 AM, 'Djordje Radovanovic' softsis...@sbb.rs
[firebird-support] wrote:
>
> I tried query with subquery in where clause and found big issue for this
> type of subquery.
>
> select * from orders where orders.partid in (select
I wrote
> > select o.*
> > from orders o
> > inner join partners p
> >
> * where p.partid = o.opartid > and p.country = 'Spain*';
>
> Helen suggests the more correct:
> select o.*
> from orders o
> inner join partners p
> * on p.partid =
On Nov 22, 2016, at 6:56 AM, kragh.tho...@yahoo.com [firebird-support]
wrote:
>
> Pagesize is 16384 and pagebuffers is 256. Servermode is superclassic.
> If I drop the primary key/index everything works as expected.
>
Interesting. GUIDs produce really fat
Do you see the same behavior if the guid field is not indexed?
> On Nov 22, 2016, at 3:09 AM, tiberiu_horv...@yahoo.com [firebird-support]
> wrote:
>
>
>
> All right, thank you all for your time !
>
> I have code that uses temporary tables in at least 30
> On Nov 24, 2016, at 2:59 PM, fabia...@itbizolutions.com.au [firebird-support]
> wrote:
>
> Just wondering can my app start a transaction with Begin Transaction and
> then call a stored procedure that contains the SUSPEND sentence at the end
> while the
> On Nov 15, 2016, at 3:58 PM, 'Some One' anotherpersonsomewh...@mail.com
> [firebird-support] wrote:
>
> I am trying to add new auto-increment primary keys for existing table.
> .
> select rdb$db_key
> from mytable
> into :dbkey
> .
As several
> On Nov 19, 2016, at 11:20 PM, Dalton Calford dcalf...@distributel.ca
> [firebird-support] wrote:
>
>
>
> Every time you do not define a domain when creating a column in a table,
> firebird creates a new domain ... So, you perform a backup and it
> On Oct 13, 2016, at 4:37 AM, Urs Liska fireb...@openlilylib.org
> [firebird-support] wrote:
>
>> Am 13.10.2016 um 10:18 schrieb Elmar Haneke el...@haneke.de
>> [firebird-support]:
>>
>> > 1)
>> > I assume on LInux (Debian based Mint version and an Ubuntu
On Wed, Jan 4, 2017 at 9:41 AM, Nico Speleers - Carfac BVBA
nico.spele...@carfac.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
We want to create table- and fieldnames (Firebird 3) in camelcase. If we
> want to write a select statement we have to use quotes around a tablename.
On Thu, Jan 5, 2017 at 9:54 PM, trsk...@yahoo.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
> As you know, on a single connection, Firebird's cpu utilization calculate
> by 100% / no of cores.
>
That's not an arbitrary limit. Firebird is not capable of running a single
ebird-support/conversations/topics/111668
>
> Aldo Caruso
>
>> El 07/03/17 a las 15:52, Ann Harrison aharri...@ibphoenix.com
>> [firebird-support] escribió:
>> > On Mar 7, 2017, at 10:30 AM, Aldo Caruso
>> > aldo.car...@arge
> On Mar 7, 2017, at 10:30 AM, Aldo Caruso aldo.car...@argencasas.com wrote:
>
> Supposing a connection only needs to read from a database. Which are the
> benefits of starting a read only transaction ?
>
I doubt that there is any difference in performance that you could measure.
On Tue, Jun 27, 2017 at 1:39 PM, Tomasz Tyrakowski
t.tyrakow...@sol-system.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:
> ,
>
> Is it possible to change the collation of a varchar column in place
> (without making a temporary column, copying data, dropping the original
>
On Fri, Jun 30, 2017 at 5:37 AM, Köditz, Martin martin.koed...@it-syn.de
[firebird-support] wrote:
>
> In 2014 I was at the FB conference in Prague. If I remember correctly, Ann
> Harrison told the audience that there are no advantages when using SMALLINT
> or
On Fri, Jun 30, 2017 at 10:30 AM, Slavomir Skopalik skopa...@elektlabs.cz
[firebird-support] wrote:
>
> advantage of SmallInt vs INT vs BIGINT is data density (keep record
> shortest as possible).
>
> If you have one column, it is irrelevant, if you have ten
On Sat, Jul 1, 2017 at 6:23 AM, Köditz, Martin martin.koed...@it-syn.de
[firebird-support] wrote:
>
>
> what do you mean with alignment?
>
It varies from machine to machine, but generally in order to add or compare
two integers
they must be aligned on a
On Sun, Jul 2, 2017 at 1:50 PM, Slavomir Skopalik skopa...@elektlabs.cz
[firebird-support] wrote:
>
>
> I test general impact of compression and I found that for FB 2.5 and FB3
> is critical to take another DB page from cache.
>
Sure.
OK, you're considering
> Apr 25, 2017, at 12:21 PM, Lester Caine les...@lsces.co.uk
> [firebird-support] wrote:
>
> On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>> The SQL standard is quite clear at what needs to happen: adding a new
>> column
> On May 9, 2017, at 9:10 AM, Freddy Ertl f.e...@speexx.com [firebird-support]
> wrote
>
> that's the question, that I have: How to find out what causes the deadlock
> scans. I have thousands of transactions per minutes, doing all possible kind
> of things.
On Mon, Jun 19, 2017 at 1:21 PM, Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] wrote:
> ,
> >
> > Can someone show me example when it is usefull to have different field
> > type in [referenced and referencing keys of a foreign key relationship]?
>
> On Oct 19, 2017, at 11:45 PM, gn7s...@gmail.com [firebird-support]
> wrote:
>
>
>
> Hi!
> I'm going to develop a commercial program with Firebird2.1, in Delphi7.
>
As noted, 2.1 is obsolete.
> I want to know whether the following index is picked by the
In addtion to Mark Rotteveel’s description of the system tables, you might want
to look at the code in isql which supports the -x command. It should include
everything to create a complete DDL script from the system tables.
Good luck,
Ann
Hi Everyone,
Adding just a bit more detail to the description of garbage collection
in Firebird.
For those who know little about Firebird, when a record is updated,
Firebird
does not replace the old version with the new. Instead, it creates a new
version
and chains the old version
On Wed, Sep 5, 2018 at 10:07 AM, Gabor Boros mlngl...@bgss.hu
[firebird-support] wrote:
> 2018. 09. 02. 17:03 keltezéssel, 'Christian Giesen' ch...@xt.co.za
> [firebird-support] írta:
>
> >
> > I have a need to generate unique sequential invoice/credit note numbers..
> > I fully understand the
> On Sep 3, 2018, at 6:00 AM, 'River~~' river14ap...@gmail.com
> [firebird-support] wrote:
>
> Two ideas that should work on any SQL database so long as you never delete
> invoices
Remember that a transaction can roll back, so delete is not your only
challenge.
>
> I amNot a guru for
On Thu, Sep 20, 2018 at 5:30 AM Georgiy Kovalov g...@liconic.com
[firebird-support] wrote:
>
>
> At the time of backup firebird database (gbak -g -ig) I have the following
> error:
>
> gbak:writing data for table ORDERS
> gbak: ERROR:message length error (encountered 532, expected 528)
>
> On Jun 20, 2019, at 11:10 AM, Nick Upson n...@telensa.com [firebird-support]
> wrote:
>
>
>
> Hi
>
> I have a large 100Gb+ firebird 2.5 database and I'm trying to deal with some
> performance issues.
>
> One indicator I have found is that several large tables have indexes with a
>
On Mon, May 13, 2019 at 5:08 AM Rustam rusta...@ukr.net [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> Important notice: modified rows in that 'dead' transaction remains locked
> along this TA existence. So, your another connections will get 'lock
> conflict' errors ('no
> On Aug 28, 2019, at 12:54 AM, Kjell Rilbe kjell.ri...@marknadsinformation..se
> [firebird-support] wrote:
>
> Den 2019-08-05 kl. 13:20, skrev mohamed hamza medh...@hotmail.com
> [firebird-support]:
>>
>> Hi All,
>>
>> I am new to sql, I am coming from Xbase system .
>> I want to
> On Nov 12, 2019, at 10:44 PM, Richard Damon rich...@damon-family.org
> [firebird-support] wrote:
>
>> On 11/12/19 12:38 PM, cte...@gmail.com [firebird-support] wrote:
>>
>>
>> What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR
>> consumes less space. Anything thing else
> On Nov 13, 2019, at 10:01 AM, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
>
> 13.11.2019 15:51, blackfalconsoftw...@outlook.com [firebird-support] wrote:
>> However, internally, the CHAR field definition is more efficient as the
>> database does not
>> have to
> On Nov 17, 2019, at 6:22 AM, jerz...@o2.pl [firebird-support]
> wrote:
>
> On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>
In Release Notes for these versions.
Maximum size of record was not changed.
>
>
>>> This is a
On Fri, Nov 22, 2019 at 11:47 AM rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
>
>
> Recently I ran a "Database statistics" with ibexpert on one of our dbs,
> and there were a lot of tables marked in yellow, with the tooltip saying
> "Table xxx Is fragmented"
>
>
>
> I couldn't quite
> On Nov 19, 2019, at 7:27 AM, kok...@yahoo.com [firebird-support]
> wrote:
> I upgraded production database, let it working for some weeks, then i
> realized that due some limitations (upadte of system tables) i am not able to
> use it with 3.0
>
What direct system table updates are you
On Tue, Nov 26, 2019 at 3:26 PM lucassch...@gmail.com [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
> I'm having a problem while running manually sweep, it's not increasing OIT
> as expected.
>
As you mentioned in your bug report, the problem was a transaction stuck in
limbo -
> On Jan 11, 2020, at 7:37 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se
> [firebird-support] wrote:
>
> Does gfix -v -full detect all kinds of database corruption? Or are there
> corruptions that cannot be detected
Gfix finds only errors in the physical structure of the database.
101 - 162 of 162 matches
Mail list logo