Thank you very much for your answer.
Aldo Caruso
El 7/8/19 a las 07:27, 'pcisar' pci...@ibphoenix.cz [firebird-support]
escribió:
Hi,
The FDB driver has no direct support for either connection pool or
"persistent connection". However, such functionality is often provided
by Python web
Hi,
I'm currently using Firebird 3.0 for a web development using PHP 7.2
with Apache 2.4 on Ubuntu 18.04
I'm evaluating a new development with Python 3.6 using a
microframework like Bottle or Flash.
I've been using fdb Python package ( python-fdb 1.6 ) for Python
scripts ( not for
Thanks ! It worked well with the switch -ch "UTF-8"
El 20/12/18 a las 16:03, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escribió:
> 20.12.2018 19:10, Aldo Caruso aldo.car...@argencasas.com [firebird-support]
> wrote:
>> The sql script is coded in UTF-8
Hello,
How is defined the chartset used in a COMMENT ON statement ?
I'm getting into trouble when I execute a sql script containing
COMMENT ON statements, using isql-fb -input
I created a ticket: http://tracker.firebirdsql.org/browse/CORE-5938
Thanks !
El 06/10/18 a las 10:45, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escribió:
> > On which page is it possible to suggest for improvements ?
>
> Create a ticket on the tracker
Thank you Mark.
Why isn't a way to define a specific sequence ? i.e.
>>
>> GRANT ALTER SEQUENCE TO ROLE
>Because that wasn't considered when this was implemented; consider
>filing an improvement request.
On which page is it possible to suggest for improvements ?
Thanks again.
Aldo Caruso
> select gen_id(GEN_AGENDA_NRO, 287390 - gen_id(GEN_AGENDA_NRO , 0)) from
> rdb$database
An ugly hack, I agree, but works.
>This does make you wonder if maybe RESTART WITH shouldn't fall under
>USAGE instead of the ALTER privilege (or alternatively if using gen_id
>with anything other than
Hello,
I'm migrating from Firebird 2 to Firebird 3
When setting a generator, I get the following error:
SET GENERATOR GEN_AGENDA_NRO to 287390;
unsuccessful metadata update
SET GENERATOR GEN_AGENDA_NRO failed
no permission for ALTER access to GENERATOR GEN_AGENDA_NRO
The same
Thanks !
El 14/09/18 a las 06:11, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escribió:
On 13-9-2018 22:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hello,
>
> Is there any issue having two aliases pointing to the same physical
> file ?
Thanks for your answer.
I'm renaming aliases for code refactoring purposes, so during some
transitional time some scripts and programs will be accessing via the
old alias while others via the new one.
I only wanted to know if under that situation the server still realizes
that they both
Hello,
Is there any issue having two aliases pointing to the same physical
file ?
Example:
old_alias = /var/lib/firebird/2.5/data/mydb.fdb
new_alias = /var/lib/firebird/2.5/data/mydb.fdb
Some clients connect using the "old_alias", while others "new_alias".
Thanks
Aldo
I'm running Firebird on Ubuntu, but also I'have run it on Debian for
many years with no problems in either case.
Regards,
Aldo Caruso
no
database, I have to use security3.db.
Is it dangerous to use this database to add users ?
Aldo
El 12/07/18 a las 17:06, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escribió:
On 12-7-2018 21:24, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> tha
Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hello,
>
> The gsec utility still exists in Firebird 3.0.2 ( Ubuntu 18.04
> distribution ), although its man page states that it is deprecated.
> I tested it and works. I have some scripts that use it in
Hello,
The gsec utility still exists in Firebird 3.0.2 ( Ubuntu 18.04
distribution ), although its man page states that it is deprecated.
I tested it and works. I have some scripts that use it in order to
add users.
Is it still reliable to use it or should I have to rewrite those
Hi András,
if your file system has barrier enabled ( ext4 by default has it ),
ant you set forced writes ON, then massive updates will be very slow.
You should decide between setting FW On or using a file system with
barrier activated.
There has been a thread in this forum about this
I'm running Firebird on Linux since many years, with the following
environment:
1. Ubuntu 14.04 ( I've also run it on Debian 6.0 )
2. ext4
3. Journaling
4. Firebird 2.5.2
Aldo Caruso
El 16/05/18 a las 20:43, Javier Cintron fcintr...@yahoo.com
[firebird-support] escribió:
Firebird ver
Hello Helen,
One of the most dangerous consequences of forgetting to update
values of the new added field, when it has constraints, is that, when
recovering a database from a backup, errors are risen and the recover
process aborts. Although backups are done raising no error, that doesn't
Dmitry,
Thanks for your answer.
Also note that when a not null field is created with a default
value ( test4 ), not only any select returns its default value but also
the engine considers it in compare statements as if it contained the
default value.
This is also true if you
Helen,
Thank you very much for you advices.
As a matter of fact, I had been changing table structures and
stored procedures while other clients were connected since many years
with no problems. Nevertheless, what you say is indeed true and can give
rise potentially to trouble.
Hello Helen,
I saw your answer after I had replied to Dimitry. It is clear that
there is no automatic filling and I'm responsible to fill fields with
not null constraint.
Your last advice concerns me a bit. Is it also valid for changing
stored procedures or triggers ?
Should I have
in the combination not null and no default
value. It is returned as a 0 for selects but treated as a NULL when
comparing.
Thanks for any answer.
Aldo Caruso
El 10/02/18 a las 13:48, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escribió:
> 10.02.2018 16:32, Aldo Caruso aldo.
Hello,
I discovered that when a field is added to a table with a NOT NULL
constraint and a default value, it is automatically filled with that
default value. Example:
alter table table1 add field1 integer default 1 not null;
commit;
select distinct field1 from table1;
FIELD1
Hello
Normally I use isql-fb with -x switch to extract metadata in order
to compare the database development structure with the database
production structure and figure out the changes I must apply to the latter.
Both outputs are redirected to files, and I use diff command to
, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escribió:
On 17-7-2017 14:08, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> I have the same problem running Firebird super server on Linux (
> Ubuntu 14.04 ). Sadly, the only solution I found was to restart
Fi
I have the same problem running Firebird super server on Linux (
Ubuntu 14.04 ). Sadly, the only solution I found was to restart Firebird
service.
I wrote a bash script that attempts to connect to the database. If
it could not establish a connection, it restarts Firebird service. This
Bieniaszewski
- Reply message -
Od: "Aldo Caruso aldo.car...@argencasas.com [firebird-support]"
<firebird-support@yahoogroups.com>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Connection rejected by remote interface
Data: pt., cze 23, 2017 14:03
Hi Mark,
thanks for your answer.
Nevertheless, I looked up for crashed server errors in
/var/log/syslog as well as in /var/log/firebird2.5.log and found none.
The server did not crash, it simply began to refuse local connections
suddenly.
Also, I ran the server for many years
Hi,
I have Firebird 2.5 running since many years under the following
environment
OS: Ubuntu 14.04 Server
Firebird Superserver 2.5.2.26540
Web server: apache2 2.4.7
Today connections from local PHP scripts could not be established.
I tried to attach from Flamerobin.
The
Hello,
I discovered that a read only transaction can increment a generator.
Is that right ?
Thanks
Aldo
Thanks for your answer.
Regarding the "blob not found" error, there is a thread about this issue [1]
Nevertheless, I believe that RO/RC transactions are assigned a unique
ID, because as I start them the next transaction ID keeps incrementing.
[1]
Hello,
Supposing a connection only needs to read from a database.
Which are the benefits of starting a read only transaction ?
Thanks,
Aldo Caruso
Ann,
thank you very much for your answer.
Aldo
El 01/03/17 a las 11:44, Ann Harrison aharri...@ibphoenix.com
[firebird-support] escribió:
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
Ann,
Thanks for your detailed answer.
I agree with you: the only isolation level which each transaction
takes care of is its own isolation level. So this behavior happens
because A isolation level is snapshot ( regardless of the isolation
level of B or C ).
Also I suspected your
Hello,
I'm trying to understand interactions between transactions with
different isolation levels.
My environment is Firebird Super Server 2.5 (v. 2.5.2) on Linux
Ubuntu 14.04
I'm testing by opening two consoles and running isql-fb on both consoles.
On the first one I start a
Paul,
thanks for your answer.
I see two firebird processes, and I'm sure there is no real user
connected, as apache server is down.
How could I find out whether CACHE_WRITER and GARBAGE_COLLECTOR
processes are active ?
Thanks
Aldo
El 10/01/17 a las 11:50, 'Paul Beach'
and firebird structures size kept in RAM be of
the same order of magnitude as databse size in the worst case ?
Aldo
El 10/01/17 a las 11:32, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escribió:
> 10.01.2017 14:03, Aldo Caruso aldo.car...@argencasas.com [firebird-support]
>
per Server or it was designed this way ?
Thanks,
Aldo Caruso
El 08/01/17 a las 17:12, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] escribió:
Hi,
I'm using Firebird 2.5 Super server, PHP 5.5 and Apache2 on Ubuntu 14.04
As I start apache server, and the web site gets visits, apache
Hi,
I'm using Firebird 2.5 Super server, PHP 5.5 and Apache2 on Ubuntu 14.04
As I start apache server, and the web site gets visits, apache
processes start to grow as well as firebird processes ( one per second
), nearly without limit. The memory consumption also increases. After a
few
Hi,
I'm using firebird 2.5 superserver, php5 and apache2 on a Linux server.
I noticed an increase in memory ( 50 MB / day ) in the last months,
that forced me to periodically restart apache server (once every two or
three weeks).
Yesterday, after an apache restart, memory
My advice is to create that field in the invoices table.
You will always have this field at hand without resorting to an outer
join with another table that only has two fields ( the invoice ID and
this field ) each time you need to inspect it.
Aldo
El 25/07/16 a las 18:51,
The third option is the best.
If you can create now a backup and no errors are shown, and you can
restore it to a new host with a reliable HD, and no errors are show, you
can be sure that it is ok.
Aldo Caruso
El 04/07/16 a las 15:52, 'Steffen Heil (Mailinglisten)'
li...@steffen-heil.de
Hello,
I noticed that the plan a stored procedure uses can be inspected if
it is a selectable stored procedure, whereas if it is a stored procedure
that is not selectable (i.e. it contains no suspend clause ) its plan
cannot be inspected.
Is there a way to inspect the plan in that
Thank you very much for your answer.
El 26/07/15 a las 19:13, Ann Harrison aharri...@ibphoenix.com
[firebird-support] escibió:
On Sun, Jul 26, 2015 at 3:19 PM, Aldo Caruso
aldo.car...@argencasas.com mailto:aldo.car...@argencasas.com
[firebird-support] firebird-support@yahoogroups.com
Thanks for your answer.
I'm a bit confused by your two final phrases.
Why do you say that All but SQL are now dead and BLR is an artifact
without benefit ?
And, if BLR doesn't include datatype information, why do you say that I
have to recompile triggers and SP anyway ?
Aldo
El 26/07/15 a
So, to be conservative, let's use the original process as recommended by
the book.
Thank you.
El 25/07/15 a las 05:45, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escibió:
On 24-7-2015 21:37, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
In the process
Pretty clear.
Thank you.
El 23/07/15 a las 05:54, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escibió:
On Wed, 22 Jul 2015 21:09:12 -0300, Aldo Caruso
aldo.car...@argencasas.com
[firebird-support] firebird-support@yahoogroups.com wrote:
Raffaele,
thanks for your answer
Stefan,
thanks for your answer.
I think that passing through a temporary field by filling it with a
cast to octets of the original field has the same effect that assuming
that the original field had been filled with ISO8859_1 character set.
See my answer to Raffaele.
Regards,
a complete
backup of the database.
---Messaggio originale---
Da: Aldo Caruso aldo.car...@argencasas.com [firebird-support]
Data: 21/07/2015 18.38.39
A: firebird-support@yahoogroups.com
Oggetto: [firebird-support] Chararacter set NONE to ISO8859_1
Hi,
I have some VARCHAR fields whose
Hi,
I have some VARCHAR fields whose character set were incorrectly
defined as NONE. I would like to use ISO8859_1 instead.
I read on The Firebird Book that in order to do so you must add a
new temporary field, with the right character set, fill it with the data
from the original
Hi,
I created a table with a numeric non null field. Afterwards I
realized that it could be a calculated field, so I dropped the field and
recreated it accordingly.
Before:
NETO CURRENCY NOT NULL,
IVA CURRENCY NOT NULL,
TOTAL CURRENCY NOT NULL
After:
NETO CURRENCY NOT NULL,
IVA
Hi,
I have defined the following domain :
CREATE DOMAIN CURRENCY AS decimal(9,2)
I would like to alter it as the following :
ALTER DOMAIN CURRENCY AS decimal(18,2)
I have many fields in tables that depend on this domain and they
are filled with values.
Will they be
Ann,
thank you very much for your clear explanation.
Aldo
El 16/06/15 a las 12:44, Ann Harrison aharri...@ibphoenix.com
[firebird-support] escibió:
On Tue, Jun 16, 2015 at 11:15 AM, Aldo Caruso
aldo.car...@argencasas.com mailto:aldo.car...@argencasas.com
[firebird-support]
Caruso aldo.car...@argencasas.com
[firebird-support] firebird-support@yahoogroups.com wrote:
No one has answered, so I'll offer a not-very interesting suggestion.
I have a table with four check constraints, which basically check
logical conditions between its fields.
In order to enforce those
Hi,
I have a table with four check constraints, which basically check
logical conditions between its fields.
In order to enforce those constraints, Firebird creates behind the
scenes two triggers for each one of them (I suppose one for update and
the other for insert operation). So in this
Hi,
I'm inserting records from PHP / Apache / Ubuntu in a Firebird
table. This table has an integer non null field, and a before insert
trigger which takes care of setting it to the next integer value in case
the user attempts to set this field to null.
If this field is set to any
...@lawinegevaar.nl
[firebird-support] escibió:
On 9-12-2014 21:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
I'm inserting records from PHP / Apache / Ubuntu in a Firebird
table. This table has an integer non null field, and a before insert
trigger which takes care of setting
Hello,
Given a populated database with default character set = None.
Some fields have character set = None while others have character
set = ISO8859_1
1) Which is the best way to modify those field definitions which
have character set = None to character set = ISO8859_1 (there
The hard truth is that the only _absolute guarantee_ to prevent
database corruption is FW = ON.
Provided that the file system also has barrier enabled ...
Regards,
Aldo
You can check whether forced writes status is on or off submitting on a
FB console the following command
SHOW DATABASE
In order to set it on / off, you shoud run
gfix -user [user_name] -password [psw] -w [sync | async] [database_name]
Regards,
Aldo
Ann,
thanks for the correction. I erroneously missinterpreted that file
system barriers were also necessary.
Aldo
++
Visit
Sean,
thanks for your answer.
Aldo
El 18/08/14 a las 15:59, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] escibió:
Given this scenario my questions are the following:
1) Does it makes sense to activate forced writes on Linux ?
Different versions of Linux file systems
:
On 2014-08-18 14:51, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
After that I noticed that some massive updates ( 100K records ) took
nearly 5 minutes, whereas with async writes it used to take 10 seconds.
Of course, we don't know how much work actually took place during
Dmitry,
Your guess is correct: Super Server architecture.
Reliability in this context means for me having no database
corruption after a power failure or kernel panic.
Aldo Caruso
El 19/08/14 a las 06:12, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] escibió:
Carlos,
I agree with you. The performance degradation was very high on an
ext4 file system ( which has barrier enabled by default ). On the other
hand, I found no noticiable performance degradation on an ext3 file
system ( which has barrier disabled by default ).
Having barrier
Hello,
For reliability reasons, I decided to turn on forced writes on a
database running on Linux.
After that I noticed that some massive updates ( 100K records ) took
nearly 5 minutes, whereas with async writes it used to take 10 seconds.
One solution is, of course, disabling sync
Mark,
thanks for your answer. (the page number I mentioned was on the first
edition ).
Aldo Caruso
El 04/08/14 a las 11:50, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escibió:
On 4-8-2014 16:42, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
Hello
Hello,
I have three questions relating CONTAINING predicate.
In The Firebird Book I read on page 318 that indexes are used
also on search conditions against CONTAING predicates. I did some test
and, inspecting its PLAN, I found that it uses NATURAL order instead of
using an index.
Hello,
In a select statement there are two tables joined by a single
matching field, with search conditions in both of them. One of them has
roughly 13 records, while the other has 600.
Inspecting the plan generated by the optimizer, I realized that it
uses the shorter one as
Sean and Carlos,
thanks for your answer.
Although the statistics are up to date the optimizer still chooses
the shorter stream as the controller.
Nevertheless, I found a workaround using a subquery on the shorter
table instead of a join.
This forced the optimizer to traverse the
order
see you !
Em 1/8/2014 18:09, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] escreveu:
Sean and Carlos,
thanks for your answer.
Although the statistics are up to date the optimizer still chooses
the shorter stream as the controller.
Nevertheless, I found
71 matches
Mail list logo