[firebird-support] page 2226658, page type 5 lock denied (216)

2012-09-27 Thread Nick Upson
Hi, (firebird 2.1.5, centos) I got this message in the firebird log and the client (running locally) got error code - 335544336 and subsequent retry of the same operation on the same data had no problems.This system runs 24/7 so I don't have a simple way to run gfix, backups are taken ok and they

[firebird-support] Talks for Firebird Conference 2012 and Last Chance for Early Bird registration

2012-09-27 Thread Alexey Kovyazin
Hello All, Topics for Firebird Conference 2012 are available: http://firebirdsql.org/en/firebird-conference-2012/ More details about most interesting topics (with announces) will be published soon too. And, Early Bird Registration ends October 1, so today and tomorrow are last days to

Re: [firebird-support] page 2226658, page type 5 lock denied (216)

2012-09-27 Thread Jesus Garcia
El 27/09/2012, a las 17:08, Ann Harrison aharri...@ibphoenix.com escribió: Page type 5 is a data page. What you ran into was an internal deadlock that was recognized and your process lost. The problem was entirely in memory, so no, I wouldn't worry about datbase corruption. In theory,

[firebird-support] FB-2.5.1, Trigger isn using a index for the update-statment or

2012-09-27 Thread simonsays768
Hallo, i have two update statements(example): update a (4000 records / one record to update) set aid = 2 where id = 1 update b (4 records / one record to update) set bid = 2 where id = 1 if i let them run, they will both update the data in ~30ms. now, i want to create a trigger with the