Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DatasetsIT.java broken in develop #5722

Closed
matthew-a-dunlap opened this issue Apr 3, 2019 · 16 comments
Closed

DatasetsIT.java broken in develop #5722

matthew-a-dunlap opened this issue Apr 3, 2019 · 16 comments

Comments

@matthew-a-dunlap
Copy link
Contributor

matthew-a-dunlap commented Apr 3, 2019

Current broken tests:

[INFO] Results:
[INFO] 
[ERROR] Errors: 
[ERROR]   DatasetsIT.testCreateDataset:110 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testExport:407 » IllegalArgument Cannot get property 'id' on null o...
[ERROR]   DatasetsIT.testFileChecksum:1016 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testPrivateUrl:682 » IllegalArgument Cannot get property 'id' on nu...
[ERROR]   DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle:632 » IllegalArgument
[ERROR]   DatasetsIT.testUpdatePIDMetadataAPI:1641 » IllegalArgument Cannot get property...
[INFO] 
[ERROR] Tests run: 89, Failures: 0, Errors: 6, Skipped: 2
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3:33.978s
[INFO] Finished at: Wed Apr 03 20:42:00 UTC 2019
[INFO] Final Memory: 60M/469M
[INFO] ------------------------------------------------------------------------

Tests run: 14, Failures: 0, Errors: 6, Skipped: 0, Time elapsed: 35.558 s <<< FAILURE! - in DatasetsIT
testSequentialNumberAsIdentifierGenerationStyle  Time elapsed: 1.094 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle(DatasetsIT.java:632)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle(DatasetsIT.java:632)

testUpdatePIDMetadataAPI  Time elapsed: 0.885 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testUpdatePIDMetadataAPI(DatasetsIT.java:1641)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testUpdatePIDMetadataAPI(DatasetsIT.java:1641)

testCreateDataset  Time elapsed: 0.516 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testCreateDataset(DatasetsIT.java:110)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testCreateDataset(DatasetsIT.java:110)

testFileChecksum  Time elapsed: 0.535 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testFileChecksum(DatasetsIT.java:1016)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testFileChecksum(DatasetsIT.java:1016)

testExport  Time elapsed: 0.448 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testExport(DatasetsIT.java:407)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testExport(DatasetsIT.java:407)

testPrivateUrl  Time elapsed: 0.481 s  <<< ERROR!
java.lang.IllegalArgumentException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testPrivateUrl(DatasetsIT.java:682)
Caused by: java.lang.NullPointerException: Cannot get property 'id' on null object
	at edu.harvard.iq.dataverse.api.DatasetsIT.testPrivateUrl(DatasetsIT.java:682)
@pdurbin
Copy link
Member

pdurbin commented Apr 4, 2019

What's weird is that phoenix isn't showing any errors on develop: https://build.hmdc.harvard.edu:8443/job/phoenix.dataverse.org-apitest-develop/353/testReport/

That was as of 08ded44 which is the tip of develop right now. 🤷‍♂️

@pdurbin
Copy link
Member

pdurbin commented Apr 4, 2019

Huh, sure enough, develop is broken when I test 08ded44 on EC2 (so someone needs to look into phoenix):

[INFO] Results:
[INFO] 
[ERROR] Errors: 
[ERROR]   DatasetsIT.testCreateDataset:110 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testExport:407 » IllegalArgument Cannot get property 'id' on null o...
[ERROR]   DatasetsIT.testFileChecksum:1016 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testPrivateUrl:682 » IllegalArgument Cannot get property 'id' on nu...
[ERROR]   DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle:632 » IllegalArgument
[ERROR]   DatasetsIT.testUpdatePIDMetadataAPI:1641 » IllegalArgument Cannot get property...
[INFO] 
[ERROR] Tests run: 88, Failures: 0, Errors: 6, Skipped: 2
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3:10.680s
[INFO] Finished at: Thu Apr 04 14:01:40 UTC 2019
[INFO] Final Memory: 62M/483M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.0:test (default-test) on project dataverse: There are test failures.
[ERROR] 
[ERROR] Please refer to /tmp/dataverse/target/surefire-reports for the individual test results.
[ERROR] Please refer to dump files (if any exist) [date]-jvmRun[N].dump, [date].dumpstream and [date]-jvmRun[N].dumpstream.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[root@ip-172-31-40-222 dataverse]# 

@pdurbin
Copy link
Member

pdurbin commented Apr 4, 2019

Here's a handy link to the first line with a failure:

Integer datasetId = UtilIT.getDatasetIdFromResponse(createDatasetResponse);

It's as if the dataset can't be created? Not sure.

I'm curious to know if the tests are passing in docker-aio or not.

@pdurbin
Copy link
Member

pdurbin commented Apr 4, 2019

The tests pass in docker-aio:

[INFO] Tests run: 7, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.349 s - in SwordIT
[INFO] 
[INFO] Results:
[INFO] 
[WARNING] Tests run: 88, Failures: 0, Errors: 0, Skipped: 2
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 03:42 min
[INFO] Finished at: 2019-04-04T12:16:15-04:00
[INFO] Final Memory: 66M/820M
[INFO] ------------------------------------------------------------------------
murphy:dataverse pdurbin$ git log --oneline | head -1
08ded4499 Merge pull request #5714 from QualitativeDataRepository/IQSS/5713-creationData_metadata_for_files_in_API
murphy:dataverse pdurbin$ 

Very strange. To summarize:

  • @matthew-a-dunlap 's laptop: failures
  • ec2 instance: failures
  • phoenix: passing
  • docker-aio: passing

Why? 🤔

@sekmiller
Copy link
Contributor

@pdurbin with the modification to the MailServiceBean to avoid the timing out, the current develop is passing on my machine.

@pdurbin
Copy link
Member

pdurbin commented Apr 8, 2019

I had to get off my branch to help with some merge conflicts so I stopped by "develop" (edf1f6d) on my way back and got a crazy error when running the tests on DatasetsIT:

testPrivateUrl Time elapsed: 2.351 s <<< ERROR!
java.lang.ClassFormatError: Absent Code attribute in method that is not native or abstract in class file edu/harvard/iq/dataverse/authorization/RoleAssignee
at edu.harvard.iq.dataverse.api.DatasetsIT.testPrivateUrl(DatasetsIT.java:873)

Very strange. Here's how it looks in Netbeans:

Screen Shot 2019-04-08 at 2 59 15 PM

@pdurbin
Copy link
Member

pdurbin commented Apr 8, 2019

Ok, I don't know what was going on with my dev environment with regard to that ClassFormatError but I did a clean and build and I'm still on edf1f6d and I just ran DatasetsIT.java 5 times in a row with no errors.

@matthew-a-dunlap did you say you can reproduced this on your laptop? Do you want to give it another try?

Here's the current summary as I understand it:

@matthew-a-dunlap
Copy link
Contributor Author

I'll have to run this either later tonight or tomorrow, sorry!

@pdurbin
Copy link
Member

pdurbin commented Apr 9, 2019

On a377d33 on EC2, I just tried setting siteUrl but I'm still seeing failures:

[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.474 s - in SearchIT
[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Errors: 
[ERROR]   DatasetsIT.testCreateDataset:110 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testExport:407 » IllegalArgument Cannot get property 'id' on null o...
[ERROR]   DatasetsIT.testFileChecksum:1016 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testPrivateUrl:682 » IllegalArgument Cannot get property 'id' on nu...
[ERROR]   DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle:632 » IllegalArgument
[ERROR]   DatasetsIT.testUpdatePIDMetadataAPI:1641 » IllegalArgument Cannot get property...
[INFO] 
[ERROR] Tests run: 88, Failures: 0, Errors: 6, Skipped: 2
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3:37.453s
[INFO] Finished at: Tue Apr 09 16:07:51 UTC 2019
[INFO] Final Memory: 61M/471M
[INFO] ------------------------------------------------------------------------

My next thought is to try also setting fqdn to a real value. As you can see in the diff below where I added siteUrl, it's still set to the default from dataverse-ansible (dataverse.yourinstitution.edu):

[root@ip-172-31-85-63 dataverse]# diff -u /usr/local/glassfish4/glassfish/domains/domain1/config/domain.xml.orig /usr/local/glassfish4/glassfish/domains/domain1/config/domain.xml
--- /usr/local/glassfish4/glassfish/domains/domain1/config/domain.xml.orig	2019-04-09 15:51:19.647363125 +0000
+++ /usr/local/glassfish4/glassfish/domains/domain1/config/domain.xml	2019-04-09 15:57:53.044610888 +0000
@@ -216,6 +216,7 @@
         <jvm-options>-Ddataverse.rserve.user=rserve</jvm-options>
         <jvm-options>-Ddataverse.rserve.password=${ALIAS=rserve_password_alias}</jvm-options>
         <jvm-options>-Ddataverse.fqdn=dataverse.yourinstitution.edu</jvm-options>
+        <jvm-options>-Ddataverse.siteUrl=http://ec2-54-173-227-55.compute-1.amazonaws.com:8080</jvm-options>
         <jvm-options>-Ddataverse.auth.password-reset-timeout-in-minutes=60</jvm-options>
         <jvm-options>-Ddoi.username=testaccount</jvm-options>
         <jvm-options>-Ddoi.password=${ALIAS=doi_password_alias}</jvm-options>
@@ -490,4 +491,4 @@
       </module>
     </application>
   </applications>
-</domain>
\ No newline at end of file
+</domain>
[root@ip-172-31-85-63 dataverse]# 

Longer term, we should get rid of fqdn as a JVM option and only use siteUrl.

@pdurbin
Copy link
Member

pdurbin commented Apr 9, 2019

My next thought is to try also setting fqdn to a real value.

Same result on EC2. Tests failing:

[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 14.359 s - in SearchIT
[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Errors: 
[ERROR]   DatasetsIT.testCreateDataset:110 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testExport:407 » IllegalArgument Cannot get property 'id' on null o...
[ERROR]   DatasetsIT.testFileChecksum:1016 » IllegalArgument Cannot get property 'id' on...
[ERROR]   DatasetsIT.testPrivateUrl:682 » IllegalArgument Cannot get property 'id' on nu...
[ERROR]   DatasetsIT.testSequentialNumberAsIdentifierGenerationStyle:632 » IllegalArgument
[ERROR]   DatasetsIT.testUpdatePIDMetadataAPI:1641 » IllegalArgument Cannot get property...
[INFO] 
[ERROR] Tests run: 88, Failures: 0, Errors: 6, Skipped: 2
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3:25.662s
[INFO] Finished at: Tue Apr 09 17:21:04 UTC 2019
[INFO] Final Memory: 59M/469M
[INFO] ------------------------------------------------------------------------

@matthew-a-dunlap
Copy link
Contributor Author

Fails for me on 4.12 as well. I seem to be having failures creating datasets via api, something is failing deeply inside the commands. I think its environmental

@matthew-a-dunlap
Copy link
Contributor Author

I'm still struggling to see what is actually blowing up, but I found this error when rooting around the commandException being passed back to execCommand:

Exception occurred in target VM: 
Internal Exception: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Error Code: 0
Call: SELECT ID, INFO, REASON, STARTTIME, DATASET_ID, USER_ID FROM DATASETLOCK WHERE (USER_ID = ?)
	bind => [1 parameter bound]
Query: ReadAllQuery(name="datasetLocks" referenceClass=DatasetLock sql="SELECT ID, INFO, REASON, STARTTIME, DATASET_ID, USER_ID FROM DATASETLOCK WHERE (USER_ID = ?)") 
org.eclipse.persistence.exceptions.DatabaseException: 
Internal Exception: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Error Code: 0
Call: SELECT ID, INFO, REASON, STARTTIME, DATASET_ID, USER_ID FROM DATASETLOCK WHERE (USER_ID = ?)
	bind => [1 parameter bound]
Query: ReadAllQuery(name="datasetLocks" referenceClass=DatasetLock sql="SELECT ID, INFO, REASON, STARTTIME, DATASET_ID, USER_ID FROM DATASETLOCK WHERE (USER_ID = ?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1611)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:674)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2738)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2691)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:495)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1168)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1127)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:403)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1215)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
	at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:129)
	at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiateForUnitOfWorkValueHolder(QueryBasedValueHolder.java:144)
	at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:160)
	at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:234)
	at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:89)
	at org.eclipse.persistence.indirection.IndirectList.buildDelegate(IndirectList.java:252)
	at org.eclipse.persistence.indirection.IndirectList.getDelegate(IndirectList.java:423)
	at org.eclipse.persistence.indirection.IndirectList.size(IndirectList.java:761)
	at edu.harvard.iq.dataverse.api.AbstractApiBean.execCommand(AbstractApiBean.java:571)
	at edu.harvard.iq.dataverse.api.Dataverses.createDataset(Dataverses.java:237)
	at sun.reflect.GeneratedMethodAccessor575.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy660.createDataset(Unknown Source)
	at edu.harvard.iq.dataverse.api.__EJB31_Generated__Dataverses__Intf____Bean__.createDataset(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor575.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:152)
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:387)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:331)
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:103)
	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:271)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
	at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:297)
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:254)
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1028)
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:372)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:381)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:344)
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:221)
	at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:344)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at org.ocpsoft.rewrite.servlet.RewriteFilter.doFilter(RewriteFilter.java:226)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at edu.harvard.iq.dataverse.api.ApiBlockingFilter.doFilter(ApiBlockingFilter.java:162)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at edu.harvard.iq.dataverse.api.ApiRouter.doFilter(ApiRouter.java:30)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:873)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:739)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:575)
	at org.apache.catalina.core.ApplicationDispatcher.doDispatch(ApplicationDispatcher.java:546)
	at org.apache.catalina.core.ApplicationDispatcher.dispatch(ApplicationDispatcher.java:428)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:378)
	at edu.harvard.iq.dataverse.api.ApiRouter.doFilter(ApiRouter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:316)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
	at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
	at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
	at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:415)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:282)
	at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
	at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
	at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:201)
	at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:175)
	at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
	at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:284)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:201)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:133)
	at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:112)
	at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
	at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:561)
	at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
	at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)
	at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
	at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
	at com.sun.proxy.$Proxy325.executeQuery(Unknown Source)
	at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)
	... 131 more
Caused by: org.postgresql.util.PSQLException: ERROR: function generateidentifierassequentialnumber() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 15
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
	at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
	at com.sun.proxy.$Proxy719.execute(Unknown Source)
	at com.sun.gjc.spi.base.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:508)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.execute(DatabaseAccessor.java:987)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:626)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
	at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1751)
	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
	at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:316)
	at edu.harvard.iq.dataverse.DatasetServiceBean.generateIdentifierAsSequentialNumber(DatasetServiceBean.java:235)
	at edu.harvard.iq.dataverse.DatasetServiceBean.generateDatasetIdentifier(DatasetServiceBean.java:214)
	at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy604.generateDatasetIdentifier(Unknown Source)
	at edu.harvard.iq.dataverse.__EJB31_Generated__DatasetServiceBean__Intf____Bean__.generateDatasetIdentifier(Unknown Source)
	at edu.harvard.iq.dataverse.engine.command.impl.AbstractCreateDatasetCommand.execute(AbstractCreateDatasetCommand.java:71)
	at edu.harvard.iq.dataverse.engine.command.impl.AbstractCreateDatasetCommand.execute(AbstractCreateDatasetCommand.java:26)
	at edu.harvard.iq.dataverse.EjbDataverseEngine.submit(EjbDataverseEngine.java:236)
	at sun.reflect.GeneratedMethodAccessor540.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
	at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
	at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
	at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
	at sun.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
	at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
	at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
	at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
	at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
	at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
	at com.sun.proxy.$Proxy683.submit(Unknown Source)
	at edu.harvard.iq.dataverse.__EJB31_Generated__EjbDataverseEngine__Intf____Bean__.submit(Unknown Source)
	at edu.harvard.iq.dataverse.api.AbstractApiBean.execCommand(AbstractApiBean.java:556)
	... 104 more

also this

Internal Exception: org.postgresql.util.PSQLException: ERROR: function generateidentifierassequentialnumber() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 15
Error Code: 0
Call: {?= CALL generateIdentifierAsSequentialNumber()}
        bind => [1 parameter bound]
Query: ResultSetMappingQuery(name="Dataset.generateIdentifierAsSequentialNumber" )
        at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:378)
        at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
        at org.eclipse.persistence.internal.jpa.StoredProcedureQueryImpl.execute(StoredProcedureQueryImpl.java:316)
        at edu.harvard.iq.dataverse.DatasetServiceBean.generateIdentifierAsSequentialNumber(DatasetServiceBean.java:235)
        at edu.harvard.iq.dataverse.DatasetServiceBean.generateDatasetIdentifier(DatasetServiceBean.java:214)
        at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
        at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
        at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4786)
        at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
        at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
        at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
        at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46)
        at org.jboss.weld.ejb.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:52)
        at sun.reflect.GeneratedMethodAccessor504.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
        at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
        at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
        at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
        at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
        at sun.reflect.GeneratedMethodAccessor505.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:883)
        at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:822)
        at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:369)
        at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4758)
        at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4746)
        at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
        ... 142 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: function generateidentifierassequentialnumber() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 15
Error Code: 0
Call: {?= CALL generateIdentifierAsSequentialNumber()}
        bind => [1 parameter bound]
Query: ResultSetMappingQuery(name="Dataset.generateIdentifierAsSequentialNumber" )
        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:682)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
        at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
        at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
        at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.execute(DatasourceCallQueryMechanism.java:220)
        at org.eclipse.persistence.queries.ResultSetMappingQuery.executeDatabaseQuery(ResultSetMappingQuery.java:312)
        at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
        at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)
        at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
        at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1751)
        at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
        ... 173 more
Caused by: org.postgresql.util.PSQLException: ERROR: function generateidentifierassequentialnumber() does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 15
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
        at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)
        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)
        at sun.reflect.GeneratedMethodAccessor626.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.postgresql.ds.PGPooledConnection$StatementHandler.invoke(PGPooledConnection.java:428)
        at com.sun.proxy.$Proxy719.execute(Unknown Source)
        at com.sun.gjc.spi.base.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:508)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.execute(DatabaseAccessor.java:987)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:626)
        ... 187 more
]]

@pdurbin
Copy link
Member

pdurbin commented Apr 11, 2019

I think I said at standup that I'd run the phoenix test suite again and I just did. Looking good:

Screen Shot 2019-04-11 at 4 25 23 PM

I also said I'd try the test suite in Vagrant but my setup didn't "just work" when I tried it just now ("Timed out while waiting for the machine to boot.")

I'm planning on working more on running the test suite on EC2 some day. I'd like there to be a Jenkins job at https://github.com/IQSS/dataverse-jenkins for this (see also #5725). For things first though. As the README in that other repo says, the next step is to get the war file built on https://jenkins.dataverse.org deployed to EC2. That is to say, I think we'll naturally resolve the EC2 errors in the future. I'm ok closing this issue.

@kcondon
Copy link
Contributor

kcondon commented Apr 16, 2019

Seems like maybe the errors have returned on the Phoenix run of 4.13:
https://build.hmdc.harvard.edu:8443/job/phoenix.dataverse.org-apitest-develop/359/

Test Result (6 failures / +6)
edu.harvard.iq.dataverse.api.DatasetsIT.testCreatePublishDestroyDataset
edu.harvard.iq.dataverse.api.DatasetsIT.testExcludeEmail
edu.harvard.iq.dataverse.api.DatasetsIT.testUpdatePIDMetadataAPI
edu.harvard.iq.dataverse.api.DatasetsIT.testExport
edu.harvard.iq.dataverse.api.SearchIT.testSearchPermisions
edu.harvard.iq.dataverse.api.SearchIT.testSubtreePermissions

@landreev
Copy link
Contributor

This issue has a lot of noise (like some info above that was only relevant to Matthew's build environment. etc.)
Can we close it, and open a new one for the current issues?

@djbrooke
Copy link
Contributor

Sure, I'll do the honors.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants