Thanks for testing and sharing your results Liridon! Can you also test the case if the usage records have the correct time according to configured timezone (in global settings) if you're using a non-UTC timezone?
I'll add the db.usage.url.paramsl as well in the PR. Regards, Rohit Yadav Software Architect, ShapeBlue https://www.shapeblue.com ________________________________ From: Ismaili, Liridon (SWISS TXT) <liridon.isma...@swisstxt.ch> Sent: Monday, May 4, 2020 15:38 To: dev@cloudstack.apache.org <dev@cloudstack.apache.org>; andrija.pa...@gmail.com <andrija.pa...@gmail.com>; us...@cloudstack.apache.org <us...@cloudstack.apache.org> Subject: Re: [VOTE] Apache CloudStack 4.14.0.0 RC1 Hi Rohit That did the trick! I did remove all the timezone information on my.cnf and only added the timezone information on the db.properties file. So I can confirm it fixes the issue. If you are using the usage service too you will also need to specify the timezone information for the usage DB: "db.usage.url.params=" in the /etc/cloudstack/management/db.properties file. Otherwise the usage service won't be able to start. This did also fix my issue and all my dates inside the db are now in the correct time zone! I'll also update the Github PR so we can track it there. Many thanks and Regards Liridon rohit.ya...@shapeblue.com www.shapeblue.com 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK @shapeblue -----Original Message----- From: "Ismaili, Liridon (SWISS TXT)" <liridon.isma...@swisstxt.ch<mailto:%22Ismaili,%20liridon%20%28swiss%20txt%29%22%20%3cliridon.isma...@swisstxt.ch%3e>> Reply-To: us...@cloudstack.apache.org<mailto:us...@cloudstack.apache.org> To: dev@cloudstack.apache.org <dev@cloudstack.apache.org<mailto:%22...@cloudstack.apache.org%22%20%3c...@cloudstack.apache.org%3e>>, andrija.pa...@gmail.com <andrija.pa...@gmail.com<mailto:%22andrija.pa...@gmail.com%22%20%3candrija.pa...@gmail.com%3e>>, us...@cloudstack.apache.org <us...@cloudstack.apache.org<mailto:%22us...@cloudstack.apache.org%22%20%3cus...@cloudstack.apache.org%3e>> Subject: Re: [VOTE] Apache CloudStack 4.14.0.0 RC1 Date: Mon, 04 May 2020 09:53:35 +0000 Hi Rohit I'll test that and let you know. Regards Liridon -----Original Message----- From: Rohit Yadav < <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com <mailto: <mailto:rohit%20yadav%20%3crohit.ya...@shapeblue.com> rohit%20yadav%20%3crohit.ya...@shapeblue.com %3e>> Reply-To: <mailto:dev@cloudstack.apache.org> dev@cloudstack.apache.org <mailto: <mailto:dev@cloudstack.apache.org> dev@cloudstack.apache.org > To: Andrija Panic < <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com <mailto: <mailto:andrija%20panic%20%3candrija.pa...@gmail.com> andrija%20panic%20%3candrija.pa...@gmail.com %3e>>, users < <mailto:us...@cloudstack.apache.org> us...@cloudstack.apache.org <mailto: <mailto:users%20%3cus...@cloudstack.apache.org> users%20%3cus...@cloudstack.apache.org %3e>>, <mailto:dev@cloudstack.apache.org> dev@cloudstack.apache.org < <mailto:dev@cloudstack.apache.org> dev@cloudstack.apache.org <mailto: <mailto:%22...@cloudstack.apache.org> %22...@cloudstack.apache.org <mailto:%22%20%3c...@cloudstack.apache.org> %22%20%3c...@cloudstack.apache.org %3e>> Subject: Re: [VOTE] Apache CloudStack 4.14.0.0 RC1 Date: Mon, 04 May 2020 09:50:10 +0000 Hi Andrija, all, While adding support for Java 11, the mysql-connector 8.x java dependency was introduced from previous 5.7x version. According to < <https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html> https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html > <https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html> https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html it seems we can specify the server time in connection parameters. Can any users test this workaround and confirm if it fixes their issue in their test/upgrade environments by adding "&serverTimezone=UTC" to the "db.cloud.url.params=" in the /etc/cloudstack/management/db.properties file, revert changes for mysql server and restart the management server. Draft PR proposed: < <https://github.com/apache/cloudstack/pull/4055/files> https://github.com/apache/cloudstack/pull/4055/files > <https://github.com/apache/cloudstack/pull/4055/files> https://github.com/apache/cloudstack/pull/4055/files We may then either discuss to either include the above PR or document this in our release/upgrade notes. Thanks. Regards, Rohit Yadav Software Architect, ShapeBlue < <https://www.shapeblue.com> https://www.shapeblue.com > <https://www.shapeblue.com> https://www.shapeblue.com ________________________________ From: Andrija Panic < <mailto: <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com > <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com Sent: Friday, May 1, 2020 22:38 To: users < <mailto: <mailto:us...@cloudstack.apache.org> us...@cloudstack.apache.org > <mailto:us...@cloudstack.apache.org> us...@cloudstack.apache.org ; Rohit Yadav < <mailto: <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com > <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com Subject: Re: [VOTE] Apache CloudStack 4.14.0.0 RC1 @Rohit Yadav<mailto: <mailto: <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com > <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com can you possibly advice on the time zone issue? I've seen this on another ML thread as well. We are mostly in UTC (test envs) so this might be the reason we didn't see this...could be just a documentation update that is needed. @Robert is there any specifics to your NFS server (i.e. a forbidden NFSv3 or similar)? Also, can you please open a GitHub issue and provide the same there? So we can track it and collaborate - I've not seen this one before. What packages did you use for the installation? On the issue you'll raise, please also include the relevant output from the /var/log/cloud.log from inside the SSVM Also not sure what is the relation between MySQL and JRE at all - they should have nothing in common? Thanks! Andrija <mailto: <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com > <mailto:rohit.ya...@shapeblue.com> rohit.ya...@shapeblue.com < <http://www.shapeblue.com> http://www.shapeblue.com > <http://www.shapeblue.com> www.shapeblue.com<http://www.shapeblue.com> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK @shapeblue On Fri, 1 May 2020 at 17:49, Robert Ward < <mailto: <mailto:rww...@gmail.com> rww...@gmail.com > <mailto:rww...@gmail.com> rww...@gmail.com <mailto: <mailto: <mailto:rww...@gmail.com> rww...@gmail.com > <mailto:rww...@gmail.com> rww...@gmail.com wrote: Hi all, I too have run into an issues while performing a clean install: Centos 7, MySQL 5.6, JRE 11 JRE 11 and MySQL 5.6 don't see to play well on two points: Installing JRE before MySQL causes MYSQL to "lockup" on startup. I have found that if I install JRE after MySQL that issue is resolved. MySQL chokes with timezone error @ cloudstack-setup-management. In my case MySQL doesn't like "EDT" as a timezone. Resolved by adding this to etc/my.cnf: default-time-zone= "-05:00" On my last point CS has difficulty with mounting secondary storage. I have clipped the logs to the point where I think the problem lies: 2020-05-01 10:55:07,871 DEBUG [c.c.h.o.r.Ovm3HypervisorGuru] (StatsCollector-5:ctx-35c593ba) (logid:aad9ed2a) getCommandHostDelegation: class com.cloud.agent.api.GetStorageStatsCommand 2020-05-01 10:55:07,871 DEBUG [c.c.h.XenServerGuru] (StatsCollector-5:ctx-35c593ba) (logid:aad9ed2a) We are returning the default host to execute commands because the command is not of Copy type. 2020-05-01 10:55:07,910 DEBUG [c.c.a.t.Request] (AgentManager-Handler-8:null) (logid:) Seq 2-4356951164504244991: Processing: { Ans: , MgmtId: 144345337593, via: 2, Ver: v1, Flags: 10, [{"com.cloud.agent.api.Answer":{"result":false,"details":"com.cloud.utils.exception.CloudRuntimeException: GetRootDir for nfs://192.168.25.1/export/secondary< < <http://192.168.25.1/export/secondary> http://192.168.25.1/export/secondary > <http://192.168.25.1/export/secondary> http://192.168.25.1/export/secondary failed due to com.cloud.utils.exception.CloudRuntimeException: Unable to mount 192.168.25.1:/export/secondary at /mnt/SecStorage/b7e9e158-ed80-3a62-a5d7-1992c991d829 due to mount.nfs: requested NFS version or transport protocol is not supported\n\tat org.apache.cloudstack.storage.resource.NfsSecondaryStorageResource.getRootDir(NfsSecondaryStorageResource.java:2458)\n\tat org.apache.cloudstack.storage.resource.NfsSecondaryStorageResource.execute(NfsSecondaryStorageResource.java:2208)\n\tat org.apache.cloudstack.storage.resource.NfsSecondaryStorageResource.executeRequest(NfsSecondaryStorageResource.java:292)\n\tat com.cloud.storage.resource.PremiumSecondaryStorageResource.defaultAction(PremiumSecondaryStorageResource.java:64)\n\tat com.cloud.storage.resource.PremiumSecondaryStorageResource.executeRequest(PremiumSecondaryStorageResource.java:60)\n\tat com.cloud.agent.Agent.processRequest(Agent.java:644)\n\tat com.cloud.agent.Agent$AgentRequestHandler.doTask(Agent.java:1057)\n\tat com.cloud.utils.nio.Task.call(Task.java:83)\n\tat com.cloud.utils.nio.Task.call(Task.java:29)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n","wait":0}}] } My troubleshooting steps: restart SSVM restart MS restart agent verify I can manually mount secondary storage on agent and navigate through all directories. change secondary storage version from null to V4 in CS global settings Any input is greatly appreciated on how to resolve. Thanks, Robert On 2020/04/29 14:38:44, Andrija Panic < <mailto: <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com > <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com <mailto: <mailto: <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com > <mailto:andrija.pa...@gmail.com> andrija.pa...@gmail.com wrote: Hi All, I've created a 4.14.0.0 release (RC1), with the following artefacts up for testing and a vote: Git Branch and Commit SH: < <https://gitbox.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.14.0.0-RC20200429T1355> https://gitbox.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.14.0.0-RC20200429T1355 > <https://gitbox.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.14.0.0-RC20200429T1355> https://gitbox.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.14.0.0-RC20200429T1355 Commit: 2c39b7180a9fb40cbdcad5e6a58be64a86913771 Source release (checksums and signatures are available at the same location): < <https://dist.apache.org/repos/dist/dev/cloudstack/4.14.0.0/> https://dist.apache.org/repos/dist/dev/cloudstack/4.14.0.0/ > <https://dist.apache.org/repos/dist/dev/cloudstack/4.14.0.0/> https://dist.apache.org/repos/dist/dev/cloudstack/4.14.0.0/ PGP release keys (signed using 3DC01AE8): < <https://dist.apache.org/repos/dist/release/cloudstack/KEYS> https://dist.apache.org/repos/dist/release/cloudstack/KEYS > <https://dist.apache.org/repos/dist/release/cloudstack/KEYS> https://dist.apache.org/repos/dist/release/cloudstack/KEYS The vote will be open until Wednesday 06.May.2020. For sanity in tallying the vote, can PMC members please be sure to indicate "(binding)" with their vote? [ ] +1 approve [ ] +0 no opinion [ ] -1 disapprove (and reason why) Additional information: For users' convenience, I've built packages from 2c39b7180a9fb40cbdcad5e6a58be64a86913771 and published RC1 repository here (CentOS 7 and Debian/generic): < <http://packages.shapeblue.com/testing/41400rc1/> http://packages.shapeblue.com/testing/41400rc1/ > <http://packages.shapeblue.com/testing/41400rc1/> http://packages.shapeblue.com/testing/41400rc1/ and here (Ubuntu 18.04 specific, thanks to Gabriel): < <https://download.cloudstack.org/testing/4.14.0.0-RC20200429T1355/ubuntu/bionic/> https://download.cloudstack.org/testing/4.14.0.0-RC20200429T1355/ubuntu/bionic/ > <https://download.cloudstack.org/testing/4.14.0.0-RC20200429T1355/ubuntu/bionic/> https://download.cloudstack.org/testing/4.14.0.0-RC20200429T1355/ubuntu/bionic/ The release notes are still work-in-progress, but for the upgrade instructions (including new systemVM templates) you may refer the following URL: < <https://acs-www.shapeblue.com/docs/WIP-PROOFING/pr87/upgrading/index.html> https://acs-www.shapeblue.com/docs/WIP-PROOFING/pr87/upgrading/index.html > <https://acs-www.shapeblue.com/docs/WIP-PROOFING/pr87/upgrading/index.html> https://acs-www.shapeblue.com/docs/WIP-PROOFING/pr87/upgrading/index.html 4.14.0.0 systemVM templates are available from here: < <http://download.cloudstack.org/systemvm/4.14/> http://download.cloudstack.org/systemvm/4.14/ > <http://download.cloudstack.org/systemvm/4.14/> http://download.cloudstack.org/systemvm/4.14/ Regards, Andrija Panić -- Andrija Panić
