[Netarchivesuite-users] Exception when starting a new job

[Søren Vejrup Carlsen]

Hi Nicolas.

NAS has write access to your database, otherwise you wouldn't be able to create a harvest definition.

But the problem may lie either the MySQL privileges given to the NAS user. Because when creating the harvest jobs, it needs to create temporary tables, and you may not have allowed the NAS user to do so.

 

See MySQLSpecifics.getJobConfigsTmpTable

 

 

regards

Søren

 

 

Fra: netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk [mailto:netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk] På vegne af nicolas.giraud at bnf.fr
Sendt: 23. april 2009 15:49
Til: netarchivesuite-users at lists.gforge.statsbiblioteket.dk
Emne: [Netarchivesuite-users] Exception when starting a new job

 


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/8a078773/attachment.html