[Netarchivesuite-users] Exception when starting a new job

[nicolas.giraud at bnf.fr]

Hi,

Whenever starting a new job (either from a selective harvest or snapshot 
harvest), I get the error attached below. The harvest is the deactivated. 
I don't understand why, and I can connect to the DB.

Any insight?

Thx,
Nicolas

----- Réacheminé par Nicolas GIRAUD/ETS/BnF le 23/04/2009 15:46 -----







Message de : nicolas.giraud at bnf.fr 
                      23/04/2009 15:48


Pour
nicolas.giraud at bnf.fr
Copie

Objet
Netarkivet error: Exception while schedulingharvestdefinition 'Vanadiel'. 
The harvestdefinition has been deactivated!



acheron1.bnf.fr
dk.netarkivet.harvester.datamodel.HarvestDefinitionDAO$1.run(HarvestDefinitionDAO.java:245)
Exception while schedulingharvestdefinition 'Vanadiel'. The 
harvestdefinition has been deactivated!
dk.netarkivet.common.exceptions.IOFailure: SQL error creating job Job 2 
(state = NEW, HD = 1, priority = HIGHPRIORITY, forcemaxcount = -1, 
forcemaxbytes = -1, orderxml = default_obeyrobots, numconfigs = 1) in 
database
SQLException trace:
SQL State:42000
Error Code:1044
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied 
for user 'nas_bnf_test'@'localhost' to database 'nas_bnf_test'
                 at 
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                 at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
                 at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                 at 
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
                 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                 at com.mysql.jdbc.Util.getInstance(Util.java:381)
                 at 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
                 at 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                 at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
                 at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
                 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
                 at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
                 at 
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
                 at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
                 at 
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
                 at 
dk.netarkivet.harvester.datamodel.MySQLSpecifics.getJobConfigsTmpTable(MySQLSpecifics.java:81)
                 at 
dk.netarkivet.harvester.datamodel.JobDBDAO.createJobConfigsEntries(JobDBDAO.java:198)
                 at 
dk.netarkivet.harvester.datamodel.JobDBDAO.create(JobDBDAO.java:163)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinition.makeJobs(HarvestDefinition.java:346)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinition.createJobs(HarvestDefinition.java:309)
                 at 
dk.netarkivet.harvester.datamodel.PartialHarvest.createJobs(PartialHarvest.java:162)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinitionDAO$1.run(HarvestDefinitionDAO.java:228)
End of SQLException trace
                 at 
dk.netarkivet.harvester.datamodel.JobDBDAO.create(JobDBDAO.java:170)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinition.makeJobs(HarvestDefinition.java:346)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinition.createJobs(HarvestDefinition.java:309)
                 at 
dk.netarkivet.harvester.datamodel.PartialHarvest.createJobs(PartialHarvest.java:162)
                 at 
dk.netarkivet.harvester.datamodel.HarvestDefinitionDAO$1.run(HarvestDefinitionDAO.java:228)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Access denied for user 'nas_bnf_test'@'localhost' to database 
'nas_bnf_test'
                 at 
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                 at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
                 at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                 at 
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
                 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                 at com.mysql.jdbc.Util.getInstance(Util.java:381)
                 at 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
                 at 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
                 at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
                 at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
                 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
                 at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
                 at 
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
                 at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
                 at 
com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
                 at 
dk.netarkivet.harvester.datamodel.MySQLSpecifics.getJobConfigsTmpTable(MySQLSpecifics.java:81)
                 at 
dk.netarkivet.harvester.datamodel.JobDBDAO.createJobConfigsEntries(JobDBDAO.java:198)
                 at 
dk.netarkivet.harvester.datamodel.JobDBDAO.create(JobDBDAO.java:163)
                 ... 4 more






Avant d'imprimer, pensez à l'environnement. 
Consider the environment before printing this mail.   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.gforge.statsbiblioteket.dk/pipermail/netarchivesuite-users/attachments/20090423/713d06b9/attachment.html