[JENKINS-46577] JdbcSQLException: Table "MAVEN_ARTIFACT" not found - Jenkins Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Component/s: pipeline-maven-plugin
Labels:
None

Similar Issues:

Show

Description

Run make run in this directory and after the scheduled triggers start the job using withMaven, I get

... org.jenkinsci.plugins.pipeline.maven.GlobalPipelineMavenConfig getDao
WARNING: Exception creating database dao, skip
org.jenkinsci.plugins.pipeline.maven.util.RuntimeSqlException: org.h2.jdbc.JdbcSQLException: Table "MAVEN_ARTIFACT" not found; SQL statement:
SELECT count(*) FROM MAVEN_ARTIFACT [42102-196]
	at org.jenkinsci.plugins.pipeline.maven.dao.PipelineMavenPluginH2Dao.testDatabase(PipelineMavenPluginH2Dao.java:390)
	at org.jenkinsci.plugins.pipeline.maven.dao.PipelineMavenPluginH2Dao.<init>(PipelineMavenPluginH2Dao.java:69)
	at org.jenkinsci.plugins.pipeline.maven.GlobalPipelineMavenConfig.getDao(GlobalPipelineMavenConfig.java:82)
	at org.jenkinsci.plugins.pipeline.maven.listeners.DownstreamPipelineTriggerRunListener.onCompleted(DownstreamPipelineTriggerRunListener.java:66)
	at org.jenkinsci.plugins.pipeline.maven.listeners.DownstreamPipelineTriggerRunListener.onCompleted(DownstreamPipelineTriggerRunListener.java:46)
	at hudson.model.listeners.RunListener.fireCompleted(RunListener.java:211)
	at org.jenkinsci.plugins.workflow.job.WorkflowRun.finish(WorkflowRun.java:664)
	at org.jenkinsci.plugins.workflow.job.WorkflowRun.access$1400(WorkflowRun.java:135)
	at org.jenkinsci.plugins.workflow.job.WorkflowRun$GraphL.onNewHead(WorkflowRun.java:967)
	at org.jenkinsci.plugins.workflow.cps.CpsFlowExecution.notifyListeners(CpsFlowExecution.java:1221)
	at org.jenkinsci.plugins.workflow.cps.CpsThreadGroup$3.run(CpsThreadGroup.java:407)
	at org.jenkinsci.plugins.workflow.cps.CpsVmExecutorService$1.run(CpsVmExecutorService.java:35)
	at hudson.remoting.SingleLaneExecutorService$1.run(SingleLaneExecutorService.java:112)
	at jenkins.util.ContextResettingExecutorService$1.run(ContextResettingExecutorService.java:28)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: Table "MAVEN_ARTIFACT" not found; SQL statement:
SELECT count(*) FROM MAVEN_ARTIFACT [42102-196]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.command.Parser.readTableOrView(Parser.java:5552)
	at org.h2.command.Parser.readTableFilter(Parser.java:1266)
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1946)
	at org.h2.command.Parser.parseSelectSimple(Parser.java:2095)
	at org.h2.command.Parser.parseSelectSub(Parser.java:1940)
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1755)
	at org.h2.command.Parser.parseSelect(Parser.java:1743)
	at org.h2.command.Parser.parsePrepared(Parser.java:449)
	at org.h2.command.Parser.parse(Parser.java:321)
	at org.h2.command.Parser.parse(Parser.java:293)
	at org.h2.command.Parser.prepareCommand(Parser.java:258)
	at org.h2.engine.Session.prepareLocal(Session.java:578)
	at org.h2.engine.Session.prepareCommand(Session.java:519)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
	at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:73)
	at org.jenkinsci.plugins.pipeline.maven.dao.PipelineMavenPluginH2Dao.testDatabase(PipelineMavenPluginH2Dao.java:379)
	... 18 more

Not fatal.

Attachments

Issue Links

is duplicated by

JENKINS-47558 pipeline-maven-plugin does not connect to / initialize h2 database

Closed

is related to

JENKINS-47558 pipeline-maven-plugin does not connect to / initialize h2 database

Closed

Activity

Ascending order - Click to sort in descending order

Jesse Glick created issue - 2017-08-31 21:00

Hide

Permalink

Cyrille Le Clerc added a comment - 2017-08-31 22:27

On MacOSX, I get the following exception, I'm investigating

docker volume create --name=m2repo
m2repo
sudo chmod a+rw $(docker volume inspect -f '{{.Mountpoint}}' m2repo)
chmod: /var/lib/docker/volumes/m2repo/_data: No such file or directory
make: *** [volume] Error 1

https://gist.github.com/cyrille-leclerc/96a2e0cdfc1873d38baf98f7d045dcbf

Show

Cyrille Le Clerc added a comment - 2017-08-31 22:27 On MacOSX, I get the following exception, I'm investigating docker volume create --name=m2repo m2repo sudo chmod a+rw $(docker volume inspect -f '{{.Mountpoint}}' m2repo) chmod: /var/lib/docker/volumes/m2repo/_data: No such file or directory make: *** [volume] Error 1 https://gist.github.com/cyrille-leclerc/96a2e0cdfc1873d38baf98f7d045dcbf

Hide

Permalink

Jesse Glick added a comment - 2017-09-11 19:33

I would not expect the demo to work as is with the weird Docker setup on Mac OS X, since the mountpoint would be inside the Linux VM.

Show

Jesse Glick added a comment - 2017-09-11 19:33 I would not expect the demo to work as is with the weird Docker setup on Mac OS X, since the mountpoint would be inside the Linux VM.

Alvaro Lobato made changes - 2017-10-05 10:40

Field	Original Value	New Value
Assignee	Alvaro Lobato [ alobato ]

Cyrille Le Clerc made changes - 2017-10-23 07:31

Link

This issue is related to ~~JENKINS-47558~~ [ ~~JENKINS-47558~~ ]

Cyrille Le Clerc made changes - 2017-10-23 11:53

Link

This issue is duplicated by ~~JENKINS-47558~~ [ ~~JENKINS-47558~~ ]

Hide

Permalink

Cyrille Le Clerc added a comment - 2017-12-09 16:18 - edited

The cause is that on this environment, "Thread.currentThread().getContextClassLoader().getResourceAsStream("sql/h2/01_migration.sql")" returns "null".

https://github.com/jenkinsci/pipeline-maven-plugin/blob/pipeline-maven-3.0.5/jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java#L331

Show

Cyrille Le Clerc added a comment - 2017-12-09 16:18 - edited The cause is that on this environment, " Thread.currentThread().getContextClassLoader().getResourceAsStream("sql/h2/01_migration.sql") " returns " null ". https://github.com/jenkinsci/pipeline-maven-plugin/blob/pipeline-maven-3.0.5/jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java#L331

Hide

Permalink

SCM/JIRA link daemon added a comment - 2017-12-09 17:04

Code changed in jenkins
User: Cyrille Le Clerc
Path:
jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java
http://jenkins-ci.org/commit/pipeline-maven-plugin/98677c47b60c4dc7a61a363d76f2606adfa26632
Log:
~~JENKINS-46577~~ Better detection of plugin loading issues

Show

SCM/JIRA link daemon added a comment - 2017-12-09 17:04 Code changed in jenkins User: Cyrille Le Clerc Path: jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java http://jenkins-ci.org/commit/pipeline-maven-plugin/98677c47b60c4dc7a61a363d76f2606adfa26632 Log: JENKINS-46577 Better detection of plugin loading issues

Hide

Permalink

SCM/JIRA link daemon added a comment - 2017-12-09 18:33

Code changed in jenkins
User: Cyrille Le Clerc
Path:
jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java
http://jenkins-ci.org/commit/pipeline-maven-plugin/a57a33b321dc642340427cb0ebaa6b0793d3b0e9
Log:
Merge pull request #113 from jenkinsci/~~JENKINS-46577~~

~~JENKINS-46577~~ Better detection of plugin loading issues

Compare: https://github.com/jenkinsci/pipeline-maven-plugin/compare/ddf7842b37a2...a57a33b321dc

Show

SCM/JIRA link daemon added a comment - 2017-12-09 18:33 Code changed in jenkins User: Cyrille Le Clerc Path: jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java http://jenkins-ci.org/commit/pipeline-maven-plugin/a57a33b321dc642340427cb0ebaa6b0793d3b0e9 Log: Merge pull request #113 from jenkinsci/ JENKINS-46577 JENKINS-46577 Better detection of plugin loading issues Compare: https://github.com/jenkinsci/pipeline-maven-plugin/compare/ddf7842b37a2...a57a33b321dc

Hide

Permalink

SCM/JIRA link daemon added a comment - 2017-12-10 15:24

Code changed in jenkins
User: Cyrille Le Clerc
Path:
jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java
jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/util/ClassUtils.java
jenkins-plugin/src/test/java/org/jenkinsci/plugins/pipeline/maven/util/ClassUtilsTest.java
jenkins-plugin/src/test/resources/org/jenkinsci/plugins/pipeline/maven/util/classutils-test-1.txt
http://jenkins-ci.org/commit/pipeline-maven-plugin/76e6db899cc954f42e120a5e31c2e747f2e3fb16
Log:
~~JENKINS-46577~~ More robust resource loading strategy

Show

SCM/JIRA link daemon added a comment - 2017-12-10 15:24 Code changed in jenkins User: Cyrille Le Clerc Path: jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/util/ClassUtils.java jenkins-plugin/src/test/java/org/jenkinsci/plugins/pipeline/maven/util/ClassUtilsTest.java jenkins-plugin/src/test/resources/org/jenkinsci/plugins/pipeline/maven/util/classutils-test-1.txt http://jenkins-ci.org/commit/pipeline-maven-plugin/76e6db899cc954f42e120a5e31c2e747f2e3fb16 Log: JENKINS-46577 More robust resource loading strategy

Hide

Permalink

SCM/JIRA link daemon added a comment - 2017-12-10 15:41

Code changed in jenkins
User: Cyrille Le Clerc
Path:
jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java
http://jenkins-ci.org/commit/pipeline-maven-plugin/ef3d4cbfa21011b7e781e68bbd08fcba4e962275
Log:
~~JENKINS-46577~~ cleanup logging

Show

SCM/JIRA link daemon added a comment - 2017-12-10 15:41 Code changed in jenkins User: Cyrille Le Clerc Path: jenkins-plugin/src/main/java/org/jenkinsci/plugins/pipeline/maven/dao/PipelineMavenPluginH2Dao.java http://jenkins-ci.org/commit/pipeline-maven-plugin/ef3d4cbfa21011b7e781e68bbd08fcba4e962275 Log: JENKINS-46577 cleanup logging

Hide

Permalink

Cyrille Le Clerc added a comment - 2017-12-10 23:13

Fixed in 3.0.6-beta-1

Show

Cyrille Le Clerc added a comment - 2017-12-10 23:13 Fixed in 3.0.6-beta-1

Cyrille Le Clerc made changes - 2017-12-10 23:13

Assignee		Cyrille Le Clerc [ cleclerc ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Hide

Permalink

Cyrille Le Clerc added a comment - 2017-12-11 07:10

Jesse Glick PR submitted https://github.com/jglick/jk--/pull/1

Show

Cyrille Le Clerc added a comment - 2017-12-11 07:10 Jesse Glick PR submitted https://github.com/jglick/jk--/pull/1

Cyrille Le Clerc made changes - 2017-12-23 14:46

Status

Resolved [ 5 ]

Closed [ 6 ]

People

Assignee:: Cyrille Le Clerc

Reporter:: Jesse Glick

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2017-08-31 21:00

Updated:: 2017-12-23 14:46

Resolved:: 2017-12-10 23:13