Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Database [build] has reached or exceeded the threshold size

Hi,
We use buildforge to do daily build, we meet an database issue which is as below:

8/1/11 4:22 PM System WarningCRRBF0570I: Database has reached or exceeded the threshold size of , currently .

I find that projects' status are "waiting", evenif I restart them, how can I fix this issue?

Could anyone help me? Thank you!!

0 votes



5 answers

Permanent link
Hi,
We use buildforge to do daily build, we meet an database issue which is as below:

8/1/11 4:22 PM System WarningCRRBF0570I: Database has reached or exceeded the threshold size of , currently .

I find that projects' status are "waiting", evenif I restart them, how can I fix this issue?

Could anyone help me? Thank you!!


Hi,

The database threshold check just results in a warning message and possibly email if that has been configured. It will not have any effects on the running of jobs. You can increase the threshold size at which the warning occurs by navigating in the UI to Administration -> System -> 'Database Size Threshold'.

I think something else must be going on that is causing jobs to remain in waiting state, although database performance due to its size might be a factor. Other things to check might be server max jobs, project run limits, run queue size, and max console procs.

Brent Ulbricht
RTC Build Lead

0 votes


Permanent link
server max jobs: 100

I think other things will not affect the project, because I just have 3 projects running, where's the log I can see to check why projects' status are always be "waiting"????

It's curious, my projects are running well before....

0 votes


Permanent link
server max jobs: 100

I think other things will not affect the project, because I just have 3 projects running, where's the log I can see to check why projects' status are always be "waiting"????

It's curious, my projects are running well before....


The "waiting" job can not be cancel.... I don't know how to delete them.

0 votes


Permanent link
If jobs are always waiting verify that the buildforge process is running. There also should be a bfproject process for each running build. If you do not have the bfproject processes they may be left over builds from a start of build forge. Run the following query to cancel the builds:

UPDATE BF_BUILDS SET BF_STATE='C' WHERE BF_TAG='build_tag_of_job';
COMMIT:

0 votes


Permanent link
If jobs are always waiting verify that the buildforge process is running. There also should be a bfproject process for each running build. If you do not have the bfproject processes they may be left over builds from a start of build forge. Run the following query to cancel the builds:

UPDATE BF_BUILDS SET BF_STATE='C' WHERE BF_TAG='build_tag_of_job';
COMMIT:


I think this is a bug, isn't it? Hope you will fix that.
I restart buildforge and db2 then the waiting projects can be canceled.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 01 '11, 9:16 p.m.

Question was seen: 7,665 times

Last updated: Aug 01 '11, 9:16 p.m.

Confirmation Cancel Confirm