B4J Question [SOLVED] WEB App with ABMaterial on GCE problem

magi6162

Well-Known Member
Licensed User
Longtime User
Starting the web app on a VM in GCE.
When I click on the "ACCESS" button, the VM console writes this:

java -jar JWVAL.jar
init mysql Feb 17, 2018 11:12:19 AM com.mchange.v2.log.MLog INFO: MLog clients using java 1.4+ standard logging. Feb 17, 2018 11:12:19 AM com.mchange.v2.c3p0.C3P0Registry INFO: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10] Collegamento al database loading /home/magi6162: copymewithjar.needs... GZipping HTML, JavaScript and CSS files...Optimizing new and updated PNG files...Building core.min.1518865939044.css...2018-02-17 11:12:20.326:INFO::main: Logging initialized @1469ms to org.eclipse.jetty.util.log.StdErrLog2018-02-17 11:12:20.594:INFO:eek:ejs.Server:main: jetty-9.4.z-SNAPSHOT2018-02-17 11:12:20.648:INFO:eek:ejs.session:main: DefaultSessionIdManager workerName=node02018-02-17 11:12:20.648:INFO:eek:ejs.session:main: No SessionScavenger set, using defaults2018-02-17 11:12:20.650:INFO:eek:ejs.session:main: Scavenging every 600000ms2018-02-17 11:12:20.701:INFO:eek:ejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@568bf312{/,file:///home/magi6162/www/,AVAILABLE}2018-02-17 11:12:20.709:INFO:eek:ejs.AbstractNCSARequestLog:main: Opened /home/magi6162/logs/b4j-2018_02_17.request.log2018-02-17 11:12:20.735:INFO:eek:ejs.AbstractConnector:main: Started ServerConnector@1d548a08{HTTP/1.1,[http/1.1]}{0.0.0.0:51045}2018-02-17 11:12:20.736:INFO:eek:ejs.Server:main: Started @1880ms2018-02-17 11:12:20.751:INFO:eek:ejs.AbstractConnector:main: Stopped ServerConnector@1d548a08{HTTP/1.1,[http/1.1]}{0.0.0.0:51045}2018-02-17 11:12:20.751:INFO:eek:ejs.session:main: Stopped scavenging2018-02-17 11:12:20.757:INFO:eek:ejsh.ContextHandler:main: Stopped o.e.j.s.ServletContextHandler@568bf312{/,file:///home/magi6162/www/,UNAVAILABLE}2018-02-17 11:12:20.765:INFO:eek:ejs.Server:main: jetty-9.4.z-SNAPSHOT2018-02-17 11:12:20.784:INFO:eek:ejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@568bf312{/,file:///home/magi6162/www/,AVAILABLE}2018-02-17 11:12:20.785:INFO:eek:ejs.AbstractNCSARequestLog:main: Opened /home/magi6162/logs/b4j-2018_02_17.request.log2018-02-17 11:12:20.785:INFO:eek:ejs.session:main: DefaultSessionIdManager workerName=node02018-02-17 11:12:20.785:INFO:eek:ejs.session:main: No SessionScavenger set, using defaults2018-02-17 11:12:20.785:INFO:eek:ejs.session:main: Scavenging every 600000ms2018-02-17 11:12:20.787:INFO:eek:ejs.AbstractConnector:main: Started ServerConnector@1d548a08{HTTP/1.1,[http/1.1]}{0.0.0.0:51045}2018-02-17 11:12:20.788:INFO:eek:ejs.Server:main: Started @1932ms2018-02-17 11:12:20.788:INFO:eek:ejs.session:main: Scavenging every 990000msFeb 17, 2018 11:13:05 AM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource INFO: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 2x1csi9t19csxym1bcrghi|2f333739, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2x1csi9t19csxym1bcrghi|2f333739, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://XXX.XXX.XXX.XXX:3306/jwval_org?useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 100, maxStatements -> 150, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]Feb 17, 2018 11:13:36 AM com.mchange.v2.resourcepool.BasicResourcePool WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6458dd6f -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.GeneratedConstructorAccessor11.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor8.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

precise that everything works fine on the development machine.

can I ask for help?

PS.
I followed the tutorial https://www.b4x.com/android/forum/threads/gce-for-noobs-part-1-intro.85727/
for creating and configuring the VM.
 

Attachments

  • upload_2018-2-16_20-31-39.png
    upload_2018-2-16_20-31-39.png
    57 KB · Views: 153
Last edited:
Top