[Refdb-devel] [ refdb-Bugs-1550516 ] Import of multiple files does not resume correctly after err

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Bugs item #1550516, was opened at 2006-09-01 15:20
Message generated for change (Comment added) made by mhoenicka
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1550516&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Nobody/Anonymous (nobody)
Summary: Import of multiple files does not resume correctly after err

Initial Comment:
SELECT VERSION()
BEGIN
LOCK TABLES t_refdb WRITE, t_author WRITE, t_keyword
WRITE, t_periodical WRITE, t_user WRITE, t_xauthor
WRITE, t_xkeyword WRITE, t_xuser WRITE, t_note WRITE,
t_xnote WRITE, t_link WRITE, t_xlink WRITE,
refdb.t_journal_words WRITE
INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES
('DUMMY','DUMMYaare5779')
SELECT user_id FROM t_user WHERE user_name='dominik'
INSERT INTO t_xuser (user_id, refdb_id) VALUES (1,2349)
SELECT refdb_id, refdb_citekey FROM t_refdb WHERE
refdb_id=2349
SELECT note_id, note_user_id from t_note WHERE
note_key='dominik-dominik'
SELECT refdb_id from t_refdb WHERE
refdb_citekey='DUMMYaare5779'
SELECT xnote_id FROM t_xnote WHERE note_id=1 AND
xnote_type='REFERENCE' AND xref_id=2349
INSERT INTO t_xnote (note_id, xref_id, xnote_type)
VALUES (1, 2349, 'REFERENCE')
unknown token:TY  - JOUR<<-17:-69:-65:84:89:32<<

SELECT author_id FROM t_author WHERE
author_name='Abdulla,F.A.'
INSERT INTO t_xauthor (author_id, refdb_id,
xauthor_type, xauthor_position, xauthor_role) VALUES
(3854, 2349, 'primary', 0, '')
SELECT author_id FROM t_author WHERE
author_name='Lettenmaier,D.P.'
INSERT INTO t_xauthor (author_id, refdb_id,
xauthor_type, xauthor_position, xauthor_role) VALUES
(2509, 2349, 'primary', 1, '')
SELECT name FROM refdb.t_journal_words WHERE name='J.'
SELECT name FROM refdb.t_journal_words WHERE name='HYDROL.'
UPDATE t_xuser SET xuser_notes='bd swurve' WHERE
refdb_id=2349 AND user_id=1
SELECT link_id FROM t_link WHERE
link_url='http://www.sciencedirect.com/science/article/B6V6C-3T7JKM3-13/1/6f09c19663404326d3bf427ccf0b30da'
INSERT INTO t_xlink (link_id, xref_id, xlink_type,
xlink_source) VALUES (1002, 2349, 'URL', 'REFERENCE')
SELECT periodical_id FROM t_periodical WHERE
periodical_name='Journal of Hydrology'
SELECT periodical_name, periodical_abbrev,
periodical_custabbrev1, periodical_custabbrev2 FROM
t_periodical WHERE periodical_id=9
UPDATE t_periodical SET periodical_name='Journal of
Hydrology' WHERE periodical_id = 9
UPDATE t_periodical SET periodical_abbrev='J. Hydrol.'
WHERE periodical_id = 9
UPDATE t_refdb SET refdb_periodical_id=9 WHERE refdb_id
= 2349
UPDATE t_xuser SET xuser_reprint = 'NOT IN FILE' WHERE
refdb_id=2349 AND user_id=1
outbuffer went to: Abdulla<<
SELECT refdb_id FROM t_refdb WHERE
refdb_citekey='Abdulla1997'
406:1:Abdulla1997

UPDATE t_refdb SET refdb_pubyear=1997, refdb_secyear=0,
refdb_pyother_info='/10/01/', refdb_secother_info=NULL,
refdb_citekey='Abdulla1997', refdb_user1=NULL,
refdb_user2='schaeffli', refdb_user3=NULL,
refdb_user4=NULL, refdb_user5=NULL, refdb_misc1=NULL,
refdb_misc2=NULL, refdb_misc3=NULL, refdb_issn=NULL,
refdb_issue='1-4', refdb_publisher=NULL,
refdb_city=NULL, refdb_volume='197',
refdb_endpage='257', refdb_startpage='230',
refdb_type=GEN, refdb_abstract='A methodology for
developing regional parameter estimation equations,
designed for application to continental scale river
basins, is described. The approach, which is applied to
the two-layer Variable Infiltration Capacity (VIC-2L)
land surface hydrologic model, uses a set of 34
unregulated calibration or \"training\" catchments
(drainage areas 102-104&nbsp;km2) distributed
throughout the Arkansas-Red River basin of the south
central U.S. For each of these catchments, parameters
were determined by: a) prior estimation of two of the
model parameters (saturated hydraulic conductivity and
pore size distribution index) from the U.S. Soil
Conservation Service State Soil Geographic Data Base
(STATSGO) data base; and b) estimation of the remaining
seven parameters via a search procedure that minimizes
the sum of squares of differences between predicted and
observed streamflow. The catchment parameters were then
related to 11 ancillary distributed land surface
characteristics extracted from STATSGO, and 17
variables derived from station meteorological data. The
seven regression equations explained from 54 to 76% of
the variance of the parameters. The most frequently
occurring ancillary variables were the average
permeability, saturated hydraulic conductivity, and SCS
hydrologic Group B (typically soils with moderately
high infiltration rates) fraction derived from STATSGO,
and the average temperature and standard deviation of
fall precipitation. The method was tested by comparing
simulations using the regional (regression equation)
parameters for six unregulated catchments not in the
parameter estimation set. The model performance using
the regional parameters was quite good for most of the
calibration and validation catchments, which were humid
and semi-humid. The model did not perform as well for
the smaller number of arid to semi-arid catchments.',
refdb_title='Development of regional parameter
estimation equations for a macroscale hydrologic model'
WHERE refdb_id=2349
1054: Unknown column 'GEN' in 'field list'
inserting reference data failed
COMMIT
ROLLBACK
UNLOCK TABLES
failed processing dataset
BEGIN
LOCK TABLES t_refdb WRITE, t_author WRITE, t_keyword
WRITE, t_periodical WRITE, t_user WRITE, t_xauthor
WRITE, t_xkeyword WRITE, t_xuser WRITE, t_note WRITE,
t_xnote WRITE, t_link WRITE, t_xlink WRITE,
refdb.t_journal_words WRITE
INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES
('DUMMY','DUMMYaare5779')
1062: Duplicate entry 'DUMMYaare5779' for key 2
inserting reference data failed
ROLLBACK
UNLOCK TABLES
failed processing dataset
BEGIN
LOCK TABLES t_refdb WRITE, t_author WRITE, t_keyword
WRITE, t_periodical WRITE, t_user WRITE, t_xauthor
WRITE, t_xkeyword WRITE, t_xuser WRITE, t_note WRITE,
t_xnote WRITE, t_link WRITE, t_xlink WRITE,
refdb.t_journal_words WRITE
INSERT INTO t_refdb (refdb_type,refdb_citekey) VALUES
('DUMMY','DUMMYaare5779')
1062: Duplicate entry 'DUMMYaare5779' for key 2
inserting reference data failed
ROLLBACK
UNLOCK TABLES
failed processing dataset

and so on...

----------------------------------------------------------------------

>Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-09-02 02:28

Message:
Logged In: YES 
user_id=85809

This error report exposes two unrelated bugs:

1) the default type "GEN" which is used if the dataset
erroneously lacks a type info needs to be quoted

2) in case of an error the transaction was committed before
a rollback was attempted

Both problems are fixed in the current SVN version (revision
159).

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1550516&group_id=26091