So I was redirected to the list to discuss
http://tracker.firebirdsql.org/browse/CORE-4467.
What I can add is that it occurred to me to run a validation on the database
after I get the error (I keep a copy, just in case backup/restore goes wrong).
Result is :
Summary of validation errors
on a file
"broken" by the issue I`ve described in the core).
2014-06-21 0:02 GMT+03:00 Jesus Garcia jeg...@gmail.com [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
>
>
> El 20/06/2014, a las 21:33, "Ivan Arabadzhiev intelru...@yahoo.com
> [fir
Well, when I say "recently" I actually mean that it happened 3 times this
month (bad weather). Perhaps I should`ve mentioned that I noticed the exact
same error two more times in the last year. Apparently only some of the
workstations were active at the time and they just retried till there was
no
Hi, I just saw CCH mentioned and figured I`d pitch in -
http://tracker.firebirdsql.org/browse/CORE-4467 . I was basically told it
was most probably bad hardware but the error happens only under major loads
(in short - a transacation does a million or so updates and in the mean
time a few others are
I`ve been using SSDs for quite some time - had major issues with a Kingston
model a while back, so I`ve kept away from them. Most my servers are with
Corsair Force 3 drives and doing fine (they are UPS protected, so power
outages don`t happen all that often) - haven`t had a corruption during
normal
Better yet, use
fbsvcmgr remotehost:service_mgr -user sysdba -password XXX
action_backup -dbname some.fdb -bkp_file stdout >some.fbk
2014-10-13 16:18 GMT+03:00 Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] :
>
>
> > > > >
> > I run the backup automatically each night (Windows s
The fbsvcmgr method requires fb 2.5.2. The upside is you can run it
remotely :)
2014-10-14 10:01 GMT+03:00 'Marius Labuschagne'
mjlabuscha...@turnkey-is.co.za [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
> From: firebird-support@yahoogroups.com [mailto:
> firebird-support@yahoogrou
I did some reconfiguration on a database yesterday, so I`m monitoring the
logs for any issues and I noticed something strange :
Mon Oct 27 16:54:25 2014
Sweep is started by SYSDBA
Database "orbis-aton"
OIT 21080, OAT 21081, OST 20456, Next 44177
(yes, I know it`s a b
I`m not sure if running a 24/7 trace is a good idea (database is under
relatively heavy load). Anything else I could do to help?
btw I am noticing that the unexpected sweep is about 27000-3
transactions after the scheduled one. I could send a log if that helps in
any way. I set the interval to
Well, I`ve done two things since the last post
1 I set the sweep interval to 10 (I assume I`m far from reaching that
on a normal day)
No change - Yesterday, another unexpected sweep at 5:08:03 pm
2 I started a trace session with the suggested config (changing only DB
alias, as instructed - I
Trace config :
enabled true
print_perf true
log_sweep true
exclude_filter %RDB$%
time_threshold 0
enabled true
log_services true
include_filter "Repair Database"
Cron calls a simple bash script with the following command for each of the
databases :
/opt/firebird/bin/gfix -user sysdba -passwo
Thanks. I`ve fixed the config and started a new trace session. Now we wait
again :)
2014-10-29 21:31 GMT+02:00 Thomas Steinmaurer t...@iblogmanager.com
[firebird-support] :
>
>
> > Trace config :
> >
> >
> > enabled true
> > print_perf true
> > log_sweep true
> > exclude_filter %RDB$%
> > time_t
Well, first of all - thank you for your time.
Trace log still showed nothing but I finally noticed a pattern and talked
to one of the devs (who didn`t know but has access to the source) -
apparently I`m going to have to strangle someone who has never seen the
size of a production database :)
2014-
Is the udf linked properly (meaning externally linked to the proper
ib_util_malloc) ?
2014-11-10 0:01 GMT+02:00 sboyd...@gmail.com [firebird-support] <
firebird-support@yahoogroups.com>:
>
>
> I have a UDF DLL that has been running for years. I recently tried to
> upgrade a site from FB 2.0 to F
http://tracker.firebirdsql.org/browse/CORE-1937
Meaning that`s the first version to actually check :) The question is *how*
is it linked. To be honest - I`m not sure how you`d link internally if you
wanted to, but I can`t think of another reason why the engine would be
complaining.
Any chance you
Well, it`s hard to help without code but I understand. Personally, I`d try
to refactor things so GetResultBfr isn`t static (but my gut has been wrong
before ...)
There are opensource UDFs out there - ask google and try to compile one on
your own (just in case there is something wrong elsewhere).
Technically speaking, there are things out there like
http://www.ex-parrot.com/pdw/Mail-RFC822-Address.html (just to show, that
very very few people do an actually 100% correct email validation)
2014-11-25 15:39 GMT+02:00 Tim Ward t...@telensa.com [firebird-support] <
firebird-support@yahoogroups.
Just my opinion on the subject but direct db access from a mobile device is
a bad idea. For a number of reasons - shaky connections, extra care while
doing local sync (if you do), longer transactions (while the server waits
for the app and network latency) - to name a few.
If you have a choice - go
I have used Ruby (Sinatra) in the past (though I`m not too excited about
the Firebird support, it is working), which does provide a rather easy
start. Currently going with Clojure, which achieves results with even less
code/effort (once you get over the lisp concepts) and offers a single .jar
file
Don`t think that would change the answers above too much.
Depending on the amount of data the device needs, you mind find it simpler
to simply get a full 'packet' of data once you unload whatever info you
have locally. Keeping in sync is generally a pain in the ass and not always
worth it. If you w
Hi,
Don`t know about specific transactions (can`t imagine the client suddenly
trying to use an externally closed transaction), but you could use the
monitoring tables and kill attachments, which have transactions that were
started too long ago. I expect the other applications can handle network
iss
Last time I used http://fbexport.sourceforge.net/ and it worked like a charm
2015-06-12 19:22 GMT+03:00 Jack Mason jackma...@mindspring.com
[firebird-support] :
>
>
> Thanks. That sounds much easier and faster than exporting everything,
> which has proven sort of unreliable in the past. Know wh
22 matches
Mail list logo