[arsenalsuite] Database problems

[Zsolt Czigléczki]

Hi All,

I compiled assburner, pyabsubmit, assfreezer recently using the latest
version of arsenalsuite (hg 102:cfc6bcef14bc Tue Jun 29 16:52:46 2010
+1000).

I have some problems with the database.

Here is what I do:

$ psql -U spirit blur -f /home/spirit/src/arsenalsuite/sql/blur_starter_db.sql

$ grep spirit /etc/passwd | python
/jobs/Global/app/arsenalsuite/Fedora11/usr/local/python/scripts/import_users.py
create user spirit

$ /jobs/Global/app/arsenalsuite/SuSE10/usr/local/bin/assfreezer

AF builds this query:

SELECT HostStatus."fkeyhost", HostStatus."slavestatus",
HostStatus."laststatuschange", HostStatus."keyhoststatus",
HostStatus."slavepulse", HostStatus."online",
HostStatus."activeassignmentcount", HostStatus."lastassignmentchange",
HostStatus."availablememory" FROM ONLY HostStatus WHERE fkeyhost in
();

$ /jobs/Global/app/arsenalsuite/Fedora11/usr/local/bin/assburner
-config ab.ini -auto-register -nogui

Fixes the previous problem.

$ python /jobs/Global/app/arsenalsuite/Fedora11/usr/local/python/scripts/manager.py
-dbconfig ab.ini

I found in postgresql log:
ERROR: relation "jobmentalray2011" does not exist

$ /jobs/Global/app/arsenalsuite/Fedora11/usr/local/bin/classmaker -s
/home/spirit/src/arsenalsuite/cpp/lib/classes/schema.xml

Clicking on 'Create Database' gives error messages and cannot fix the database.

It seems to me:
* a table cannot be created,
* missing columns are not added to the table.

Is there a more recent version of the database dump?

I have Qt 4.5.3 installed.

Thanks,
Zsolt

[Viet Nguyen]

$ /jobs/Global/app/arsenalsuite/Fedora11/usr/local/bin/classmaker -s
/home/spirit/src/arsenalsuite/cpp/lib/classes/schema.xml

Clicking on 'Create Database' gives error messages and cannot fix the database.

It seems to me:
* a table cannot be created,
* missing columns are not added to the table.

Ah yes. The classmaker has a known bug such that it can't actually generate tables. This would normally be the way you should do it though. I'm not sure what the timetable is in fixing that since we've just been relying on the database dumps to create tables. Or in the extreme case I might create them manually.
 

Is there a more recent version of the database dump?

 

Unfortunately I'm not actually using this build of arsenal so my database wouldn't work for you. I think Barry is the man to help you out with that.
 

-V

[Barry Robison]

Apologies Zsolt, I am generating a fresh starter_db.sql for you now.

I'll send you something by tomorrow.


cheers,
-barry