Markus Hoenicka wrote:
> There is indeed nothing unusual here. In fact, I use a (far from
> perfect) test harness here which is a shell script like yours. It
> creates databases, inserts, updates, picks, unpicks, deletes
> references and notes. I have never seen any difference between running
> a command from the command line or from within a script.
Suddenly, it just started doing the same thing from the command line.
Then I exited from a few applications and tried again and it worked. So
I guess the problem wasn't really caused by running refdbc from a
script, it was just that the extra overhead of another shell instance
created a lack of system resources.
In any case, when it fails, addref produces this output:
233:1
414:1
233:2
414:2
233:3
414:3
233:4
414:4
233:5
414:5 ...
Whereas when it succeeds it produces output like this (showing my
citation keys):
406:1:RFC3492
408:1
406:2:GAC2006GAC-PRINCIPLES-
408:2
406:3:SMITH2001TAKING-DELIBERA
408:3
406:4:NYGH1995CONFLICT-OF-LAW
408:4
406:5:MUELLER2006A-FUNNY-THING-H
408:5
406:6:MUELLER2005WHAT-TO-DO-ABOU ...
> The only way to bump into this problem is to cause refdbd to stop
> inserting data before it updates the citation key of a newly created
> dataset. This would create an incomplete dataset with that particular
> dummy citation key. This problem also requires lack of transaction
> support, as otherwise the rollback (or the missing commit in case of a
> crash) would cause MySQL to remove the dataset again. I don't see how
> running refdbc from a script could cause this problem, but it seems to
> be a fact. Could you please do the following:
>
> - check the MySQL log for additional hints
> - create a SQL dump of your thesis database after your script ran
> unsuccessfully. Please include the refdbd log of that particular run
> as I'd like to compare the process IDs involved.
Sending MySQL log, database dump and refdbd log privately.
--
Jeremy Malcolm LLB (Hons) B Com
Internet and Open Source lawyer, IT consultant, actor
host -t NAPTR 1.0.8.0.3.1.2.9.8.1.6.e164.org|awk -F! '{print $3}'
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
|
