Closed zhuangsen closed 1 year ago
This is the expected behavior when that table does not exist. Is the message correct, ie is the table missing in the configured database?
This is the expected behavior when that table does not exist. Is the message correct, ie is the table missing in the configured database?
Isn't it possible to create tables automatically?
Yes, moqui-framework does this automatically if the add missing on start setting is enabled, the entity_add_missing_startup
env var. I'd recommend reading through the logs since start to see if there are errors, or if it is not adding missing because it is disabled.
I checked entity_add_missing_startup env var, it’s true but problem also happens.
I compared the master branch with tag v3.0.0 I found one place that could cause this problem So I tested it and found that it worked. Here is the difference in code between the two branches:
master: tableSet = dbData.getTables(con.getCatalog(), schemaName, "%", types)
tag v3.0.0: tableSet = dbData.getTables(null, schemaName, "%", types)
There may indeed be a problem here, and I don't know about others but I need more information to have an idea about what is going on, or even better to be able to reproduce the issue.
Which database are you using? What does the startup log say, are there errors in creating tables?
For some things to consider when submitting an issue (or a pull request regarding an issue), please see:
https://moqui.org/m/docs/moqui/Issue+and+Pull+Request+Guide#bugs-and-general-issues
moqui version: tags: v3.0.0 mysql version: 8.0.26
logs info:
Using temporary directory: /Users/madison/Workspace/moqui/moqui-framework-release/execwartmp
Determined runtime from Java system property: runtime
Canonicalized runtimePath: /Users/madison/Workspace/moqui/moqui-framework-release/runtime
Determined conf from Java system property: conf/MoquiDevConf.xml
Starting ElasticSearch install found in /Users/madison/Workspace/moqui/moqui-framework-release/runtime/elasticsearch, pid file not found (JDK: /Library/Java/JavaVirtualMachines/jdk-11.0.16.1.jdk/Contents/Home)
Running Jetty server on port 8080 max threads 100 with args [{}]
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
warning: no-jdk distributions that do not bundle a JDK are deprecated and will be removed in a future release
Unexpected problem occured during version sanity check
Reported exception:
java.lang.AbstractMethodError: Receiver class org.apache.logging.slf4j.SLF4JServiceProvider does not define or inherit an implementation of the resolved method abstract getRequestedApiVersion()Ljava/lang/String; of interface org.slf4j.spi.SLF4JServiceProvider.
at org.slf4j.LoggerFactory.versionSanityCheck(LoggerFactory.java:297)
at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:141)
at org.slf4j.LoggerFactory.getProvider(LoggerFactory.java:421)
at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:407)
at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:356)
at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:382)
at org.eclipse.jetty.util.component.AbstractLifeCycle.<clinit>(AbstractLifeCycle.java:35)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at MoquiStart.main(MoquiStart.java:221)
warning: no-jdk distributions that do not bundle a JDK are deprecated and will be removed in a future release
Creating Jetty FileSessionDataStore with directory /Users/madison/Workspace/moqui/moqui-framework-release/runtime/sessions
Jetty min threads 8, max threads 100
23:21:52.419 INFO main o.eclipse.j.s.Server jetty-10.0.9; built: 2022-03-30T16:46:32.527Z; git: a9eaf8d5d73369acf610ce88f850c0d56c4b1113; jvm 11.0.16.1+1-LTS-1
23:21:52.475 INFO main .eclipse.j.s.s.DefaultSessionIdManager Session workerName=node0
23:21:54.668 INFO main clipse.j.w.StandardDescriptorProcessor NO JSP Support for /, did not find org.eclipse.jetty.jsp.JettyJspServlet
23:21:55.088 INFO main o.moqui.i.w.MoquiContextListener Loading Webapp 'webroot' (Moqui Root Webapp) on ROOT, located at: /Users/madison/Workspace/moqui/moqui-framework-release/execwartmp/ROOT/webapp
23:21:55.189 INFO main .moqui.i.c.ExecutionContextFactoryImpl Initializing Moqui Framework version 3.0.0
- runtime directory: /Users/madison/Workspace/moqui/moqui-framework-release/runtime
- runtime config: /Users/madison/Workspace/moqui/moqui-framework-release/runtime/conf/MoquiDevConf.xml
23:21:55.189 INFO main .moqui.i.c.ExecutionContextFactoryImpl Running on Java 11.0.16.1 VM 11.0.16.1+1-LTS-1 Runtime 11.0.16.1+1-LTS-1
23:21:55.573 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component tools at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/base-component/tools
23:21:55.583 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component webroot at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/base-component/webroot
23:21:55.586 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component HiveMind at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/HiveMind
23:21:55.587 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component MarbleERP at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/MarbleERP
23:21:55.589 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component PopCommerce at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/PopCommerce
23:21:55.591 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component PopRestStore at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/PopRestStore
23:21:55.593 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component SimpleScreens at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/SimpleScreens
23:21:55.595 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component mantle-udm at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/mantle-udm
23:21:55.597 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component mantle-usl at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/mantle-usl
23:21:55.599 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component moqui-fop at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/moqui-fop
23:21:55.603 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added component moqui-hazelcast at file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/moqui-hazelcast
23:21:55.603 INFO main .moqui.i.c.ExecutionContextFactoryImpl Components after depends-on sort: [tools, webroot, moqui-fop, mantle-udm, mantle-usl, SimpleScreens, HiveMind, MarbleERP, PopCommerce, PopRestStore, moqui-hazelcast]
23:21:55.613 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component tools
23:21:55.628 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component moqui-fop
23:21:55.639 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component mantle-udm
23:21:55.643 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component SimpleScreens
23:21:55.655 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component HiveMind
23:21:55.656 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component MarbleERP
23:21:55.661 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component PopCommerce
23:21:55.664 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component PopRestStore
23:21:55.667 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging MoquiConf.xml file from component moqui-hazelcast
23:21:55.680 INFO main .moqui.i.c.ExecutionContextFactoryImpl Merging runtime configuration at /Users/madison/Workspace/moqui/moqui-framework-release/runtime/conf/MoquiDevConf.xml
23:21:55.690 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property instance_purpose from default with value [dev]
23:21:55.691 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property default_locale from default with value [zh_CN.UTF-8]
23:21:55.692 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property default_time_zone from default with value [Asia/Shanghai]
23:21:55.693 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property database_time_zone from default with value [Asia/Shanghai]
23:21:55.693 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_https_enabled from default with value [false]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_allow_origins from default with value [*]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_handle_cors from default with value [true]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_status_ips from default with value [127.0.0.1]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_require_session_token from default with value [true]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property webapp_upload_executable_allow from default with value [false]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_db_conf from default with value [mysql8]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_host from default with value [127.0.0.1]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_port from default with value [3306]
23:21:55.694 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_database from default with value [moqui]
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_url from default with value [jdbc:h2:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/db/h2/moqui;lock_timeout=30000]
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_user from default with value [moqui]
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting pw/key property entity_ds_password from default
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting pw/key property entity_ds_crypt_pass from default
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting pw/key property entity_ds_crypt_pass_old from default
23:21:55.706 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_add_missing_runtime from default with value [false]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_add_missing_startup from default with value [true]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_lock_track from default with value [true]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_statement_timeout from default with value [false]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_empty_db_load from default with value [all]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_c1_disabled from default with value [true]
23:21:55.707 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property entity_ds_c1_db_conf from default with value [mysql]
23:21:55.708 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property scheduled_job_check_time from default with value [60]
23:21:55.708 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property elasticsearch_url from default with value [http://127.0.0.1:9200]
23:21:55.708 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property kibana_host from default with value [127.0.0.1]
23:21:55.708 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property kibana_port from default with value [5601]
23:21:55.709 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_group_name from default with value [moqui_h4]
23:21:55.709 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_multicast_enabled from default with value [false]
23:21:55.709 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_multicast_group from default with value [224.2.2.3]
23:21:55.711 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_multicast_port from default with value [54327]
23:21:55.712 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_tcp_ip_enabled from default with value [false]
23:21:55.712 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_aws_enabled from default with value [false]
23:21:55.713 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_aws_host_header from default with value [ec2.amazonaws.com]
23:21:55.713 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_aws_hz_port from default with value [5701]
23:21:55.713 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_interfaces_enabled from default with value [false]
23:21:55.713 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_k8s_enabled from default with value [false]
23:21:55.714 INFO main .moqui.i.c.ExecutionContextFactoryImpl Setting property hazelcast_k8s_zone_aware from default with value [false]
23:21:55.714 INFO main .moqui.i.c.ExecutionContextFactoryImpl Found default_time_zone Asia/Shanghai: sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=31,lastRule=null]
23:21:55.715 INFO main .moqui.i.c.ExecutionContextFactoryImpl Default locale zh_CN.UTF-8, time zone sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=31,lastRule=null]
Java HotSpot(TM) 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release.
23:21:55.771 INFO main .moqui.i.c.ExecutionContextFactoryImpl Initializing worker ThreadPoolExecutor: queue limit 65535, pool-core 16, pool-max 24, pool-alive 60s
23:21:55.782 INFO main .moqui.i.c.ExecutionContextFactoryImpl Initializing MClassLoader context MoquiStart$StartClassLoader cur class MoquiStart$StartClassLoader system null
Starting MClassLoader with parent MoquiStart$StartClassLoader
23:21:55.810 INFO main .moqui.i.c.ExecutionContextFactoryImpl Initialized MClassLoader with parent MoquiStart$StartClassLoader
23:21:55.851 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added JAR from runtime/lib: mysql-connector-java-8.0.30.jar
23:21:55.922 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added JARs from component moqui-fop: [antlr4-runtime-4.5.3.jar, avalon-framework-api-4.3.1.jar, avalon-framework-impl-4.3.1.jar, barcode4j-2.1.jar, barcode4j-fop-ext-2.1.jar, batik-anim-1.14.jar, batik-awt-util-1.14.jar, batik-bridge-1.14.jar, batik-constants-1.14.jar, batik-css-1.14.jar, batik-dom-1.14.jar, batik-ext-1.14.jar, batik-extension-1.14.jar, batik-gvt-1.14.jar, batik-i18n-1.14.jar, batik-parser-1.14.jar, batik-script-1.14.jar, batik-shared-resources-1.14.jar, batik-svg-dom-1.14.jar, batik-svggen-1.14.jar, batik-transcoder-1.14.jar, batik-util-1.14.jar, batik-xml-1.14.jar, cssbox-4.17.jar, cssbox-pdf-1.0-SNAPSHOT.jar, fontbox-2.0.26.jar, fop-core-2.7.jar, fop-events-2.7.jar, fop-util-2.7.jar, jstyleparser-3.5.jar, moqui-fop-1.1.3.jar, nekohtml-1.9.22.jar, pdfbox-2.0.26.jar, qdox-1.12.jar, unbescape-1.1.6.RELEASE.jar, xercesImpl-2.12.2.jar, xml-apis-1.4.01.jar, xml-apis-ext-1.3.04.jar, xmlgraphics-commons-2.7.jar]
23:21:55.936 INFO main .moqui.i.c.ExecutionContextFactoryImpl Added JARs from component moqui-hazelcast: [hazelcast-all-4.0.2.jar, moqui-hazelcast-1.1.3.jar]
23:21:55.936 INFO main .moqui.i.c.ExecutionContextFactoryImpl Initialized ClassLoaders in 162ms
23:21:55.940 INFO main .moqui.i.c.ExecutionContextFactoryImpl Not loading disabled ToolFactory with class: org.moqui.impl.tools.JackrabbitRunToolFactory
23:21:55.941 INFO main .moqui.i.c.ExecutionContextFactoryImpl Not loading disabled ToolFactory with class: org.moqui.impl.tools.SubEthaSmtpToolFactory
23:21:55.944 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.impl.tools.MCacheToolFactory
23:21:55.954 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.hazelcast.HazelcastToolFactory
23:21:55.963 INFO main o.moqui.h.HazelcastToolFactory Starting Hazelcast with hazelcast.xml from classpath
10月 16, 2022 11:21:57 下午 com.hazelcast.instance.impl.HazelcastInstanceFactory
WARNING: Hazelcast is starting in a Java modular environment (Java 9 and newer) but without proper access to required Java packages. Use additional Java arguments to provide Hazelcast access to Java internal API. The internal API access is used to get the best performance results. Arguments to be used:
--add-modules java.se --add-exports java.base/jdk.internal.ref=ALL-UNNAMED --add-opens java.base/java.lang=ALL-UNNAMED --add-opens java.base/java.nio=ALL-UNNAMED --add-opens java.base/sun.nio.ch=ALL-UNNAMED --add-opens java.management/sun.management=ALL-UNNAMED --add-opens jdk.management/com.sun.management.internal=ALL-UNNAMED
23:21:57.683 INFO main c.hazelcast.i.AddressPicker [LOCAL] [moqui_h4] [4.0.2] Prefer IPv4 stack is true, prefer IPv6 addresses is false
23:21:57.699 INFO main c.hazelcast.i.AddressPicker [LOCAL] [moqui_h4] [4.0.2] Picked [10.8.0.2]:5701, using socket ServerSocket[addr=/0:0:0:0:0:0:0:0,localport=5701], bind any local is true
23:21:57.737 INFO main c.hazelcast.system [10.8.0.2]:5701 [moqui_h4] [4.0.2] Hazelcast 4.0.2 (20200702 - 2de3027) starting at [10.8.0.2]:5701
23:21:57.737 INFO main c.hazelcast.system [10.8.0.2]:5701 [moqui_h4] [4.0.2] Copyright (c) 2008-2020, Hazelcast, Inc. All Rights Reserved.
23:21:58.130 INFO main azelcast.s.i.o.i.BackpressureRegulator [10.8.0.2]:5701 [moqui_h4] [4.0.2] Backpressure is disabled
23:21:58.603 WARN main c.hazelcast.c.CPSubsystem [10.8.0.2]:5701 [moqui_h4] [4.0.2] CP Subsystem is not enabled. CP data structures will operate in UNSAFE mode! Please note that UNSAFE mode will not provide strong consistency guarantees.
23:21:59.115 INFO main azelcast.s.i.o.i.OperationExecutorImpl [10.8.0.2]:5701 [moqui_h4] [4.0.2] Starting 4 partition threads and 3 generic threads (1 dedicated for priority tasks)
23:21:59.116 INFO main c.hazelcast.i.d.Diagnostics [10.8.0.2]:5701 [moqui_h4] [4.0.2] Diagnostics disabled. To enable add -Dhazelcast.diagnostics.enabled=true to the JVM arguments.
23:21:59.122 INFO main c.hazelcast.c.LifecycleService [10.8.0.2]:5701 [moqui_h4] [4.0.2] [10.8.0.2]:5701 is STARTING
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.hazelcast.internal.networking.nio.SelectorOptimizer (file:/Users/madison/Workspace/moqui/moqui-framework-release/runtime/component/moqui-hazelcast/lib/hazelcast-all-4.0.2.jar) to field sun.nio.ch.SelectorImpl.selectedKeys
WARNING: Please consider reporting this to the maintainers of com.hazelcast.internal.networking.nio.SelectorOptimizer
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
23:21:59.195 WARN main c.hazelcast.i.i.Node [10.8.0.2]:5701 [moqui_h4] [4.0.2] No join method is enabled! Starting standalone.
23:21:59.212 INFO main c.hazelcast.c.LifecycleService [10.8.0.2]:5701 [moqui_h4] [4.0.2] [10.8.0.2]:5701 is STARTED
23:21:59.213 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.hazelcast.HazelcastCacheToolFactory
23:21:59.268 INFO main o.moqui.h.HazelcastCacheToolFactory Initialized Hazelcast CacheManager for instance moqui
23:21:59.268 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.hazelcast.HazelcastDciTopicToolFactory
23:21:59.274 INFO main o.moqui.h.HazelcastDciTopicToolFactory Getting Entity Cache Invalidate Hazelcast Topic and registering MessageListener
23:21:59.337 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.hazelcast.HazelcastExecutorToolFactory
23:21:59.344 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.hazelcast.HazelcastNotificationTopicToolFactory
23:21:59.353 INFO main .HazelcastNotificationTopicToolFactory Getting Notification Message Hazelcast Topic and registering MessageListener
23:21:59.361 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.impl.tools.H2ServerToolFactory
23:21:59.370 INFO main .moqui.i.c.ExecutionContextFactoryImpl Loading ToolFactory with class: org.moqui.fop.FopToolFactory
23:21:59.383 INFO main .moqui.i.c.ExecutionContextFactoryImpl Cache Facade initialized
23:21:59.797 INFO main o.moqui.i.c.ResourceFacadeImpl Using xsl-fo-handler-factory FOP (org.moqui.fop.FopToolFactory)
23:21:59.797 INFO main .moqui.i.c.ExecutionContextFactoryImpl Resource Facade initialized
23:21:59.845 WARN main b.tm.Configuration Cannot get the unique server ID for this JVM ('bitronix.tm.serverId'). Make sure it is configured and you use only US-ASCII characters. Will use IP address instead (unsafe for production usage!).
23:22:00.004 INFO main o.moqui.i.c.TransactionFacadeImpl Internal transaction manager initialized: UserTransaction class bitronix.tm.BitronixTransactionManager, TransactionManager class bitronix.tm.BitronixTransactionManager
23:22:00.004 INFO main .moqui.i.c.ExecutionContextFactoryImpl Transaction Facade initialized
23:22:00.096 INFO main o.moqui.i.e.EntityFacadeImpl Database time zone is sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=31,lastRule=null]
23:22:00.633 INFO main .moqui.i.c.TransactionInternalBitronix Initializing DataSource transactional_DS (mysql8) with properties: [databaseName:moqui, port:3306, allowPublicKeyRetrieval:true, serverName:127.0.0.1, pinGlobalTxToPhysicalConnection:true, serverTimezone:Asia/Shanghai, autoReconnectForPools:true, useCursorFetch:true, user:moqui, useSSL:false]
23:22:01.529 INFO main .moqui.i.c.TransactionInternalBitronix Init DataSource transactional_DS (mysql8) isolation READ_COMMITTED (2), max pool 140
23:22:01.537 INFO main o.moqui.i.e.EntityFacadeImpl Skipping disabled datasource transactional#clone1
23:22:01.541 INFO main o.moqui.i.e.EntityCache Entity Cache initialized, distributed cache invalidate enabled: true
23:22:01.551 INFO main .moqui.i.c.ExecutionContextFactoryImpl Entity Facade initialized
23:22:01.639 INFO main o.moqui.i.s.RestApi Loaded REST API from moqui.rest.xml (76 paths, 86 methods)
23:22:01.686 INFO main o.moqui.i.s.RestApi Loaded REST API from mantle.rest.xml (392 paths, 416 methods)
23:22:01.710 INFO main o.moqui.i.s.RestApi Loaded REST API from pop.rest.xml (43 paths, 42 methods)
23:22:01.710 INFO main o.moqui.i.s.RestApi Loaded REST API files, 3 roots, in 122ms
23:22:01.710 INFO main .moqui.i.c.ExecutionContextFactoryImpl Service Facade initialized
23:22:01.728 INFO main .moqui.i.c.ExecutionContextFactoryImpl Screen Facade initialized
23:22:01.728 INFO main o.moqui.i.e.EntityFacadeImpl Loading entity definitions
23:22:01.958 INFO main o.moqui.i.e.EntityFacadeImpl Found entities in 42 files in 230ms
[2022-10-16T23:22:02,664][INFO ][o.e.n.Node ] [iMac.local] version[7.10.2], pid[14628], build[oss/tar/747e1cc71def077253878a59143c1f785afa92b9/2021-01-13T00:42:12.435326Z], OS[Mac OS X/12.4/x86_64], JVM[Oracle Corporation/Java HotSpot(TM) 64-Bit Server VM/11.0.16.1/11.0.16.1+1-LTS-1]
23:22:02.664 ERROR main o.moqui.i.w.MoquiContextListener Error initializing webapp context: java.lang.reflect.InvocationTargetException
java.lang.reflect.InvocationTargetException: null
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[?:?]
at org.moqui.Moqui.dynamicInit(Moqui.java:62) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.webapp.MoquiContextListener.contextInitialized(MoquiContextListener.groovy:68) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1043) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:624) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:978) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:705) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:392) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304) ~[moqui_temp15852450090215024745execlib_jetty-webapp-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:895) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532) ~[moqui_temp15852450090215024745execlib_jetty-webapp-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:220) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.Server.start(Server.java:469) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.Server.doStart(Server.java:414) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at MoquiStart.main(MoquiStart.java:301) ~[moqui.war:?]
Caused by: org.moqui.impl.entity.EntitySqlException: Error finding list of DbViewEntity by null [42S02]
at org.moqui.impl.entity.EntityFindBase.listInternal(EntityFindBase.groovy:1150) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.list(EntityFindBase.groovy:999) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityFacadeImpl.groovy:528) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.postFacadeInit(EntityFacadeImpl.groovy:162) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.postFacadeInit(ExecutionContextFactoryImpl.groovy:585) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.<init>(ExecutionContextFactoryImpl.groovy:237) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
at org.moqui.Moqui.dynamicInit(Moqui.java:62) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.webapp.MoquiContextListener.contextInitialized(MoquiContextListener.groovy:68) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
... 1 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'moqui.db_view_entity' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:582) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavaProxy.executeQuery(PreparedStatementJavaProxy.java:102) ~[moqui_temp7864149576869635363WEB-INF_lib_btm-3.0.0-20161020.jar.:3.0.0-SNAPSHOT]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:109) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityQueryBuilder.executeQuery(EntityQueryBuilder.java:138) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindImpl.iteratorExtended(EntityFindImpl.java:150) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.listInternal(EntityFindBase.groovy:1149) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.list(EntityFindBase.groovy:999) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityFacadeImpl.groovy:528) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.postFacadeInit(EntityFacadeImpl.groovy:162) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.postFacadeInit(ExecutionContextFactoryImpl.groovy:585) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.<init>(ExecutionContextFactoryImpl.groovy:237) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
... 32 more
23:22:02.682 WARN main o.eclipse.j.w.WebAppContext Failed startup of context o.e.j.w.WebAppContext@7a9c84a5{Moqui Root Webapp,/,file:///Users/madison/Workspace/moqui/moqui-framework-release/execwartmp/ROOT/webapp/,UNAVAILABLE}{file:/Users/madison/Workspace/moqui/moqui-framework-release/moqui.war}
java.lang.reflect.InvocationTargetException: null
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[?:?]
at org.moqui.Moqui.dynamicInit(Moqui.java:62) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.webapp.MoquiContextListener.contextInitialized(MoquiContextListener.groovy:68) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1043) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:624) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:978) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:705) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:392) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304) ~[moqui_temp15852450090215024745execlib_jetty-webapp-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:895) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306) ~[moqui_temp7722185136833080241execlib_jetty-servlet-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532) ~[moqui_temp15852450090215024745execlib_jetty-webapp-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:220) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.Server.start(Server.java:469) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.server.Server.doStart(Server.java:414) ~[moqui_temp11225541739725828341execlib_jetty-server-10.0.9.jar.:10.0.9]
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93) ~[moqui_temp10487632049594666690WEB-INF_lib_jetty-util-10.0.9.jar.:10.0.9]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at MoquiStart.main(MoquiStart.java:301) ~[moqui.war:?]
Caused by: org.moqui.impl.entity.EntitySqlException: Error finding list of DbViewEntity by null [42S02]
at org.moqui.impl.entity.EntityFindBase.listInternal(EntityFindBase.groovy:1150) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.list(EntityFindBase.groovy:999) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityFacadeImpl.groovy:528) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.postFacadeInit(EntityFacadeImpl.groovy:162) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.postFacadeInit(ExecutionContextFactoryImpl.groovy:585) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.<init>(ExecutionContextFactoryImpl.groovy:237) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
at org.moqui.Moqui.dynamicInit(Moqui.java:62) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.webapp.MoquiContextListener.contextInitialized(MoquiContextListener.groovy:68) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
... 1 more
Caused by: java.sql.SQLSyntaxErrorException: Table 'moqui.db_view_entity' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[?:?]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[?:?]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[?:?]
at com.mysql.cj.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:582) ~[?:?]
at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavaProxy.executeQuery(PreparedStatementJavaProxy.java:102) ~[moqui_temp7864149576869635363WEB-INF_lib_btm-3.0.0-20161020.jar.:3.0.0-SNAPSHOT]
at org.moqui.impl.entity.EntityQueryBuilder.run(EntityQueryBuilder.java:109) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityQueryBuilder.executeQuery(EntityQueryBuilder.java:138) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindImpl.iteratorExtended(EntityFindImpl.java:150) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.listInternal(EntityFindBase.groovy:1149) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFindBase.list(EntityFindBase.groovy:999) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.loadAllEntityLocations(EntityFacadeImpl.groovy:528) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.entity.EntityFacadeImpl.postFacadeInit(EntityFacadeImpl.groovy:162) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.postFacadeInit(ExecutionContextFactoryImpl.groovy:585) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
at org.moqui.impl.context.ExecutionContextFactoryImpl.<init>(ExecutionContextFactoryImpl.groovy:237) ~[moqui_temp18402245854023938947WEB-INF_lib_moqui-framework-3.0.0.jar.:3.0.0]
... 32 more
[2022-10-16T23:22:02,695][INFO ][o.e.n.Node ] [iMac.local] JVM home [/Library/Java/JavaVirtualMachines/jdk-11.0.16.1.jdk/Contents/Home]
23:22:02.704 INFO main o.eclipse.j.s.AbstractConnector Started ServerConnector@73163d48{HTTP/1.1, (http/1.1)}{0.0.0.0:8080}
23:22:02.706 INFO main o.eclipse.j.s.Server Started Server@751d3241{STARTING}[10.0.9,sto=30000] @12571ms
Did you find a solution to this?
I ran the latest from moqui-framework against MySQL 8 (using the mysql8 config as it looks like you are using, from the log). The initial create tables worked fine, and after loading data and all a startup against the existing database also worked fine.
It doesn't seem to be a problem with using mysql8, so it's something else, and so far based on the information here I haven't come up with other possibilities of what it might be, ie what might be different in your configuration, code, deployment details, etc.
I use moqui-framework version 3.0.0, It has problems. the latest version seems work fine
This should be the solution
That would make sense, if you have a MySQL server with multiple databases init then it would have symptoms like you described... or rather another detail that is important for that issue was that it only happened when there were multiple databases on the server because when looking to see if a table exists it would see the table in another database and think it exists.
moqui version: v3.0.0, mysql: 8.0
Caused by: java.sql.SQLSyntaxErrorException: Table 'moqui.db_view_entity' doesn't exist