· 4 years ago · Jun 28, 2021, 07:44 AM
1postgres:@jdbc:postgresql://localhost:5432//cdm
2Jun 28, 2021 3:28:33 PM groovy.sql.Sql execute
3WARNING: Failed to execute:
4 CREATE TABLE IF NOT EXISTS "CDM_DOCUMENTS" (
5 "DOC_ID" SERIAL PRIMARY KEY,
6 "FILENAME" VARCHAR(255) NOT NULL,
7 "PATH" VARCHAR(255) NOT NULL,
8 "DOC_TYPE" VARCHAR(255) NOT NULL,
9 "NAME" varchar(255),
10 "IS_DEFAULT" bool NOT NULL DEFAULT false,
11 "ORG" varchar(255) NOT NULL DEFAULT 'TORO'::character varying,
12 "USER_ID" int4 NOT NULL DEFAULT 0,
13 "DATE_ADDED" TIMESTAMPTZ DEFAULT NOW(),
14 "LAST_MODIFIED" TIMESTAMPTZ DEFAULT NOW()
15 );
16
17 CREATE TABLE IF NOT EXISTS "MANIFEST" (
18 "ID" SERIAL PRIMARY KEY,
19 "MANIFEST_NAME" VARCHAR(255) NOT NULL,
20 "MANIFEST_FILENAME" VARCHAR(255) NOT NULL,
21 "MANIFEST_PATH" TEXT NOT NULL,
22 "MANIFEST_FOLDER" VARCHAR(255),
23 "DESCRIPTION" text,
24 "IS_DEFAULT" bool NOT NULL DEFAULT FALSE,
25 "ORG" varchar(255) NOT NULL DEFAULT 'TORO'::character varying,
26 "USER_ID" INT4 NOT NULL DEFAULT 0,
27 "DATE_ADDED" TIMESTAMPTZ DEFAULT NOW(),
28 "LAST_MODIFIED" TIMESTAMPTZ DEFAULT NOW()
29 );
30
31 CREATE TABLE IF NOT EXISTS "ENTITIES" (
32 "ID" SERIAL PRIMARY KEY,
33 "ENTITY_NAME" VARCHAR(255) NOT NULL,
34 "ENTITY_FILENAME" VARCHAR(255) NOT NULL,
35 "ENTITY_PATH" VARCHAR(255) NOT NULL,
36 "ENTITY_FOLDER" VARCHAR(255) DEFAULT 'None'::character varying,
37 "TYPE" VARCHAR(255),
38 "IS_DEFAULT" bool NOT NULL DEFAULT FALSE,
39 "ORG" VARCHAR(255) NOT NULL DEFAULT 'TORO'::character varying,
40 "USER_ID" INT4 NOT NULL DEFAULT 0,
41 "DATE_ADDED" TIMESTAMPTZ DEFAULT NOW(),
42 "LAST_MODIFIED" TIMESTAMPTZ DEFAULT NOW(),
43 "EXTENDS_ENTITY_ID" int4,
44 "CONTENT" json
45 );
46
47 CREATE TABLE IF NOT EXISTS "ENTITY_REL" (
48 "MANIFEST_ID" INT4 NOT NULL,
49 "ENTITY_ID" INT4 NOT NULL,
50 PRIMARY KEY("MANIFEST_ID", "ENTITY_ID"),
51 CONSTRAINT fk_manifest FOREIGN KEY ("MANIFEST_ID") REFERENCES "MANIFEST" ("ID") ON DELETE CASCADE
52 );
53
54 CREATE TABLE IF NOT EXISTS "SUBMANIFEST_REL" (
55 "MANIFEST_ID" INT4 NOT NULL,
56 "SUBMANIFEST_ID" INT4 NOT NULL,
57 PRIMARY KEY("MANIFEST_ID", "SUBMANIFEST_ID"),
58 CONSTRAINT fk_manifest FOREIGN KEY ("MANIFEST_ID") REFERENCES "MANIFEST" ("ID") ON DELETE CASCADE
59 );
60
61 CREATE TABLE IF NOT EXISTS "PACKAGES" (
62 "id" SERIAL PRIMARY KEY,
63 "org" varchar(255) NOT NULL DEFAULT 'TORO'::character varying,
64 "user_id" int4 NOT NULL,
65 "guid" varchar(255) NOT NULL,
66 "manifest_name" varchar(255) NOT NULL,
67 "status" varchar(255) NOT NULL DEFAULT 'FAILED'::character varying,
68 "manifest_path" text NOT NULL,
69 "is_default" bool NOT NULL DEFAULT false,
70 "date_added" TIMESTAMPTZ DEFAULT NOW(),
71 "date_updated" TIMESTAMPTZ DEFAULT NOW(),
72 "manifest_id" int4,
73 "latest_version" varchar(255)
74 );
75
76 CREATE TABLE IF NOT EXISTS "PACKAGE_VERSION" (
77 "ID" SERIAL PRIMARY KEY,
78 "PACKAGE_ID" int4 NOT NULL,
79 "VERSION" varchar(255) NOT NULL
80 );
81
82 CREATE TABLE IF NOT EXISTS "PACKAGE_CONTENT" (
83 "version_id" int4 NOT NULL,
84 "content" bytea NOT NULL,
85 "date_added" TIMESTAMPTZ DEFAULT NOW(),
86 PRIMARY KEY ("version_id")
87 );
88
89 CREATE TABLE IF NOT EXISTS "ENTITY_ATTRIBUTE_REL" (
90 "ENTITY_ATTRIBUTE_ID" int4 NOT NULL,
91 "ENTITY_ID" int4 NOT NULL,
92 "TARGET_ENTITY_ATTRIBUTE" varchar(255) NOT NULL,
93 "FOREIGN_KEY_TYPE_ATTRIBUTE" varchar(255) NOT NULL,
94 "FOREIGN_KEY_DATA_TYPE" varchar(255) NOT NULL,
95 "DESCRIPTION" text,
96 "SIMPLE" bool NOT NULL DEFAULT false,
97 "FOREIGN_KEY_PURPOSE" varchar(255) DEFAULT 'identifiedBy'::character varying,
98 "TARGET_ENTITY_TRAIT_REF" varchar(255) DEFAULT 'is.identifiedBy'::character varying,
99 PRIMARY KEY ("ENTITY_ATTRIBUTE_ID","ENTITY_ID")
100 );
101
102 CREATE TABLE IF NOT EXISTS "ORGANISATION" (
103 "ID" SERIAL PRIMARY KEY,
104 "CODE" varchar(255) NOT NULL,
105 "NAME" varchar(255) NOT NULL
106 );
107
108 CREATE INDEX IF NOT EXISTS entity_name_idx ON "ENTITIES"("ENTITY_NAME");
109 because: ERROR: no schema has been selected to create in
110 Position: 32
11128/06/21 15:28:34.102 ERROR [Martini] gloopStackTrace = [gloopStackTrace{
112key = null
113serviceName = SetupCdmUiDatabase
114stepName = InvokeCode
115target = null
116lineNumber = 12
117}]
118io.toro.gloop.exception.GloopException: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
119 Position: 32
120 at ui.services.conf.SetupCdmUiDatabase.InvokeCode(ui.services.conf.SetupCdmUiDatabase.gloop:12)
121
122Caused by: org.postgresql.util.PSQLException: ERROR: no schema has been selected to create in
123 Position: 32
124 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
125 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
126 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
127 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
128 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
129 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)
130 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)
131 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)
132 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)
133 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
134 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
135 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
136 at java.lang.reflect.Method.invoke(Method.java:498)
137 at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
138 at com.sun.proxy.$Proxy82.execute(Unknown Source)
139 at groovy.sql.Sql.execute(Sql.java:2333)
140 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
141 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
142 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
143 at java.lang.reflect.Method.invoke(Method.java:498)
144 at org.codehaus.groovy.runtime.callsite.PlainObjectMetaMethodSite.doInvoke(PlainObjectMetaMethodSite.java:43)
145 at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:214)
146 at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
147 at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
148 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
149 at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:139)
150 at (ui_services_conf_SetupCdmUiDatabase_gloop_12)_c_$_run_closure1.doCall((ui.services.conf.SetupCdmUiDatabase.gloop:12)[c].groovy:3)
151 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
152 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
153 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
154 at java.lang.reflect.Method.invoke(Method.java:498)
155 at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:107)
156 at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:323)
157 at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:263)
158 at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1026)
159 at groovy.lang.Closure.call(Closure.java:412)
160 at groovy.lang.Closure.call(Closure.java:428)
161 at io.toro.martini.SqlMethods.sql(SqlMethods.java:121)
162 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
163 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
164 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
165 at java.lang.reflect.Method.invoke(Method.java:498)
166 at io.toro.gloop.service.step.invoke.decorate.GloopAnnotationCodeDecorator.invoke(GloopAnnotationCodeDecorator.groovy:231)
167 at io.toro.gloop.service.step.invoke.util.InvokeCodeUtils.invoke(InvokeCodeUtils.groovy:103)
168 at io.toro.gloop.service.step.invoke.InvokeCodeStep.invoke(InvokeCodeStep.groovy:151)
169 at io.toro.gloop.engine.GloopEngine.invokeStep(GloopEngine.groovy:73)
170 at io.toro.gloop.engine.GloopEngine.runStep(GloopEngine.groovy:120)
171 at io.toro.gloop.engine.GloopEngine.runService(GloopEngine.groovy:97)
172 at io.toro.gloop.service.GloopService.invokeService(GloopService.groovy:93)
173 at io.toro.martini.invoker.GloopService.execute(GloopService.java:88)
174 at io.toro.martini.invoker.InterceptedService.execute(InterceptedService.java:31)
175 at io.toro.martini.invoker.DelegatingService.execute(DelegatingService.java:32)
176 at io.toro.martini.invoker.HaltingService.execute(HaltingService.java:38)
177 at io.toro.martini.invoker.StartupShutdownServiceInvokerLifeCycleListener.execute(StartupShutdownServiceInvokerLifeCycleListener.java:81)
178 at io.toro.martini.invoker.StartupShutdownServiceInvokerLifeCycleListener.after(StartupShutdownServiceInvokerLifeCycleListener.java:50)
179 at io.toro.martini.ipackage.DefaultPackageLifeCycleEventPublisher.publishAfter(DefaultPackageLifeCycleEventPublisher.java:48)
180 at io.toro.martini.ipackage.PackageLifeCycle.onStart(PackageLifeCycle.java:586)
181 at io.toro.martini.ipackage.PackageLifeCycle.lambda$start$3(PackageLifeCycle.java:335)
182 at io.toro.martini.ipackage.PackageLifeCycle.setState(PackageLifeCycle.java:549)
183 at io.toro.martini.ipackage.PackageLifeCycle.start(PackageLifeCycle.java:438)
184 at io.toro.martini.ipackage.DefaultPackageLifeCycleManager.start(DefaultPackageLifeCycleManager.java:75)
185 at io.toro.martini.ipackage.DefaultPackageManager.internalStart(DefaultPackageManager.java:546)
186 at io.toro.martini.ipackage.DefaultPackageManager.startPackage(DefaultPackageManager.java:464)
187 at io.toro.martini.ipackage.PackageStartupRunnable.run_aroundBody0(PackageStartupRunnable.java:49)
188 at io.toro.martini.ipackage.PackageStartupRunnable$AjcClosure1.run(PackageStartupRunnable.java:1)
189 at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
190 at io.toro.martini.aspect.advice.MethodInterceptorService.executeJoinpoint(MethodInterceptorService.java:80)
191 at io.toro.martini.aspect.advice.MethodInterceptorService.advice(MethodInterceptorService.java:72)
192 at io.toro.martini.ipackage.PackageStartupRunnable.run(PackageStartupRunnable.java:30)
193 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
194 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
195 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
196 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
197 at java.lang.Thread.run(Thread.java:748)
19828/06/21 15:28:34.182 INFO [EndpointAutoLifeCyclePackageListener] Starting package 'cdm-client' endpoints
19928/06/21 15:28:34.183 INFO [EndpointAutoLifeCyclePackageListener] Completed starting package 'cdm-client' endpoints
20028/06/21 15:28:34.183 INFO [DefaultPackageManager] Martini Package 'cdm-client' started
20128/06/21 15:28:34.184 INFO [DefaultPackageManager] Loading Martini Package 'examples'
20228/06/21 15:28:34.989 INFO [DefaultPackageManager] Martini Package 'examples' loaded
20328/06/21 15:28:34.990 INFO [DefaultPackageManager] Starting Martini Package 'examples'
20428/06/21 15:28:35.152 INFO [LocalSolrClient] Starting core: 'movie-core'
20528/06/21 15:28:35.153 INFO [LocalSolrClient] Starting core: 'movie-core' completed
20628/06/21 15:28:35.815 INFO [TomcatContext] Creating default Web app for Martini Package 'examples', since '/Users/ericjamesdaluz/martini-desktop-workspace/.metadata/.plugins/io.toro.martini.runtime.embedded/martini-runtime/packages/examples/web/WEB-INF/web.xml' is not found, but has a web directory
20728/06/21 15:28:38.293 INFO [EndpointAutoLifeCyclePackageListener] Starting package 'examples' endpoints
20828/06/21 15:28:38.303 INFO [EndpointAutoLifeCyclePackageListener] Starting endpoint 'WebsocketListener'
20928/06/21 15:28:38.336 INFO [EndpointAutoLifeCyclePackageListener] Completed starting endpoint 'WebsocketListener'
21028/06/21 15:28:38.336 INFO [EndpointAutoLifeCyclePackageListener] Completed starting package 'examples' endpoints
21128/06/21 15:28:38.337 INFO [DefaultPackageManager] Martini Package 'examples' started
212