Thread 'exporting stats problem'

Message boards : Server programs : exporting stats problem
Message board moderation

To post messages, you must log in.

AuthorMessage
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52257 - Posted: 1 Feb 2014, 11:50:59 UTC

I have the latest boinc server software running on Ubuntu 12.04

bin/db_dump -d 2 -dump_spec db_dump_spec.xml gives me

2014-02-01 12:34:12.2504 db_dump starting
2014-02-01 12:34:12.2507 Starting
2014-02-01 12:34:12.2527 [CRITICAL] Couldn't open ../html/stats_tmp/user for output
Segmentation fault (core dumped)

..html/stats and ..html/stats_tmp folder have chmod 02775. Where is the problem?
ID: 52257 · Report as offensive
Juha
Volunteer developer
Volunteer tester
Help desk expert

Send message
Joined: 20 Nov 12
Posts: 801
Finland
Message 52260 - Posted: 1 Feb 2014, 12:28:47 UTC - in response to Message 52257.  
Last modified: 1 Feb 2014, 12:34:08 UTC

You are trying to run it in root of the project directory (or whatever it's called) and apparently it's expecting to be run in bin directory.

edit: Of course you can edit the directories in db_dump_spec.xml. edit2: But then again, when run as cron job, it's run in bin so maybe you don't want to edit the directories.
ID: 52260 · Report as offensive
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52272 - Posted: 1 Feb 2014, 15:58:03 UTC - in response to Message 52260.  
Last modified: 1 Feb 2014, 16:14:05 UTC

You are trying to run it in root of the project directory (or whatever it's called) and apparently it's expecting to be run in bin directory.

edit: Of course you can edit the directories in db_dump_spec.xml. edit2: But then again, when run as cron job, it's run in bin so maybe you don't want to edit the directories.


Should be ok with the root dir but perhaps a bug somewhere? With sudo command I got the same error.

Edit:
Got it, I have changed all the files from ../html to html/
ID: 52272 · Report as offensive
Juha
Volunteer developer
Volunteer tester
Help desk expert

Send message
Joined: 20 Nov 12
Posts: 801
Finland
Message 52275 - Posted: 1 Feb 2014, 17:08:20 UTC - in response to Message 52272.  
Last modified: 1 Feb 2014, 17:08:34 UTC

You are trying to run it in root of the project directory (or whatever it's called) and apparently it's expecting to be run in bin directory.

edit: Of course you can edit the directories in db_dump_spec.xml. edit2: But then again, when run as cron job, it's run in bin so maybe you don't want to edit the directories.


Should be ok with the root dir but perhaps a bug somewhere? With sudo command I got the same error.

Edit:
Got it, I have changed all the files from ../html to html/

Do notice that it very likely will not work as cron job/periodic task anymore. See config.xml how it's started.
ID: 52275 · Report as offensive
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52277 - Posted: 1 Feb 2014, 17:42:39 UTC - in response to Message 52275.  


Do notice that it very likely will not work as cron job/periodic task anymore. See config.xml how it's started.


Yes, thats correct, only needed for creating stats the first time but the cron job isnt working, tried bin/start --cron.
ID: 52277 · Report as offensive
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52280 - Posted: 1 Feb 2014, 20:52:56 UTC

I have made a deeper look into the cronjob. All my modifications are correct but it still doesnt work.

bin/db_dump -d 2 -dump_spec db_dump_spec.xml -->update my stats

test.cronjob refers to test root

0,5,10,15,20,25,30,35,40,45,50,55 * * * * cd /home/boincadm/projects/test ; /home/boincadm/projects/test/bin/start --cron

db_dump_spec.xml is looking into html folder

<output_dir>html/stats_tmp</output_dir>
<archive_dir>html/stats_archive</archive_dir>
<final_output_dir>html/stats</final_output_dir>

from the config.xml
<task>
<cmd>db_dump -d 2 -dump_spec db_dump_spec.xml</cmd>
<period>5 minutes</period>
<output>db_dump.out</output>
<disabled>0</disabled>
</task>

the <cmd> should be executed from cronjob (starts from project root "test")

bin/status is ok, tells me update every 5min.

5 minutes 2014/02/01 21:44:24 unlocked no
db_dump -d 2 -dump_spec db_dump_spec.xml

But somewhere I have a mistake??? Any help is much appreciated!
ID: 52280 · Report as offensive
ChristianB
Volunteer developer
Volunteer tester

Send message
Joined: 4 Jul 12
Posts: 321
Germany
Message 52281 - Posted: 1 Feb 2014, 21:21:09 UTC

The default supplied db_dump_spec.xml should work out of the box and require no changes. The output of the daemon can be found in the log_HOSTNAME/db_dump.out any errors will be there.

When executing db_dump manually you should first cd into the bin directory and then execute the cmd as specified in config.xml

You should check overall permissions and ownership of the directories in question.
ID: 52281 · Report as offensive
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52282 - Posted: 1 Feb 2014, 21:38:23 UTC - in response to Message 52281.  
Last modified: 1 Feb 2014, 21:52:54 UTC

The default supplied db_dump_spec.xml should work out of the box and require no changes. The output of the daemon can be found in the log_HOSTNAME/db_dump.out any errors will be there.

When executing db_dump manually you should first cd into the bin directory and then execute the cmd as specified in config.xml

You should check overall permissions and ownership of the directories in question.


Thx, ChristianB, was looking for the logfile but now found it. If I do manually bin/start --cron its working now but automatically every 5min its seems that the cronjob isnt starting or crashing.

With bin/status I can see "NOW" running but never stopped and no new update?!

Edit:
With bin/start --cron every is fine, without it its still stucking in running now mode but seems to be crashed without any log. This I can reproduce.
ID: 52282 · Report as offensive
ChristianB
Volunteer developer
Volunteer tester

Send message
Joined: 4 Jul 12
Posts: 321
Germany
Message 52286 - Posted: 2 Feb 2014, 9:25:25 UTC
Last modified: 2 Feb 2014, 9:26:03 UTC

I would say this is a permission/owner problem. What user are you? Are the directories within /home/boincadm/projects/test owned by boincadm is the cronjob within the boincadm crontab and are you logged in as boincadm? You should answer all of this with yes. See Groups and permissions
ID: 52286 · Report as offensive
rebirther
Avatar

Send message
Joined: 21 Jun 06
Posts: 156
Germany
Message 52287 - Posted: 2 Feb 2014, 14:49:05 UTC

Solution:
crontab -e was missing, thx for help ChristianB!
ID: 52287 · Report as offensive

Message boards : Server programs : exporting stats problem

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.