topic Re: How do I know which version of ThingWorx is stable? in ThingWorx Developers

How do I know which version of ThingWorx is stable?

Do1 — Tue, 07 Mar 2017 07:55:59 GMT

I have come across several (diverse) issues with the ThingWorx Platform which seems mainly related to the H2 version, but I have also found problems with the PostgresSQL version.

I always use Ubuntu 14.04 LTS since it is certified and the prescribed versions of Java, Tomcat and PostgresSQL.

I appreciate that there is a lot of development and we all contribute towards logging issues and squashing bugs.

However, when needing to deploy a production build, how do we know which version and combinations of Java / Tomcat / OS is MOST stable?

This becomes even more challenging if we start adding extensions and the EMS.

I would appreciate some guidance or even a rule of thumb if someone has found one that is reasonably reliable.

Thanks!

Re: How do I know which version of ThingWorx is stable?

CarlesColl — Tue, 07 Mar 2017 08:01:17 GMT

Not for now,

We had been stick on 6.5.13 for one year and a half, and doing a lot of tests in order to move on 7.X for 6 months - starting at 7.0, we expect to move on 7.3.3 when it's released....

Neither 6.5.13 on Neo4j was super stable, Yesterday we moved on 6.5.3 PostgreSQL

Carles.

Re: How do I know which version of ThingWorx is stable?

Do1 — Tue, 07 Mar 2017 08:04:29 GMT

Thanks Charles,

Can you elaborate on OS, PSQL, Tomcat and Java versions that you are running on 6.5.3?

Re: How do I know which version of ThingWorx is stable?

CarlesColl — Tue, 07 Mar 2017 08:22:05 GMT

Well we are on TW Cloud Services, then I don't know, I suppose the recomended ones.

On my local tests ( Development, Testing and Performance Tuning - I know Windows XP x64 it's not supported but it works and starts in a sweep ):

Performance Tests on Migration from 6.5.13 Neo4j to 7.X PostgreSQL

Hardware Configuration:

Virtual Machine
- Oracle VM VirtualBox
- 3Gb RAM
- 1CPU ( no CPU Cap )
- Enable I/O APIC ON
- Paravirtualization Interface: Legacy
- Hardware Virtualization: ON Enable Nested Paging
- No Encryption
Host Machine
- MacBook Pro ( 8.2 )
- Intel Core i7-2675QM
- CPU 2,2Ghz <-> 3,1Ghz
- 1 CPU x 4 Cores
- 16Gb RAM ( 1333Mhz DDR3 )
- HD: Samsung SSD 850 EVO 500Gb over SATA
  - HFS+ with register
  - No encryption

Software Configuration:

Virtual Machine
- Windows XP x64 SP2
Host Machine
- Mac OS X El Capitan 10.11.6

Configuration 1: TW 6.5.13 + Neo4j

Operation Configuration:

Java 1.8.0.112-b15
- Configuration:
  - -Dd64
  - -Dfile.encoding=UTF-8
  - -Xms2g
  - -Xmx2g
  - -XX:+UseG1GC
Tomcat 8.0.39
Neo4j 2.1.8
ThingWorx
- Logging
  - ApplicationLog = WARN
  - CommunicationLog = WARN
  - ConfigurationLog = INFO
  - ScriptLog = INFO
  - SecurityLog = WARN

Configuration 1: TW 6.5.13 + PostgreSQL

Operation Configuration:

Java 1.8.0.112-b15
- Configuration:
  - -Dd64
  - -Dfile.encoding=UTF-8
  - -Xms2g
  - -Xmx2g
  - -XX:+UseG1GC
Tomcat 8.0.39
PostgreSQL 9.4.10
Rhino Version 1.7R5
ThingWorx
- Logging
  - ApplicationLog = WARN
  - CommunicationLog = WARN
  - ConfigurationLog = INFO
  - ScriptLog = INFO
  - SecurityLog = WARN

Configuration 2: TW 7.2.6 + Neo4j

Operation Configuration:

Java 1.8.0.112-b15
- Configuration:
  - -Dd64
  - -Dfile.encoding=UTF-8
  - -Xms2g
  - -Xmx2g
  - -XX:+UseG1GC
Tomcat 8.0.39
Neo4j 2.1.8
Rhino Version 1.7R5
ThingWorx
- Logging
  - ApplicationLog = INFO
  - CommunicationLog = WARN
  - ConfigurationLog = INFO
  - ScriptLog = INFO
  - SecurityLog = WARN

Configuration 3: TW 7.3 + PostgreSQL

Operation Configuration:

Java 1.8.0.112-b15
- Configuration:
  - -Dd64
  - -Dfile.encoding=UTF-8
  - -Xms2g
  - -Xmx2g
  - -XX:+UseG1GC
Tomcat 8.0.39
PostgreSQL 9.4.10
Rhino Version 1.7R5
ThingWorx
- Logging
  - ApplicationLog = WARN
  - CommunicationLog = WARN
  - ConfigurationLog = INFO
  - ScriptLog = INFO
  - SecurityLog = WARN

Re: How do I know which version of ThingWorx is stable?

Do1 — Tue, 07 Mar 2017 08:31:08 GMT

Thank you for posting the details! Very interesting!

I notice you specify Rhino Version 1.7R5.... Why is this? Do you install it separately? I have never seen it referenced in any of the install guides, can you please elaborate?

Thanks

Re: How do I know which version of ThingWorx is stable?

CarlesColl — Tue, 07 Mar 2017 08:39:59 GMT

We where doing a lot of performance tests comparing Neo4j and PostgreSQL, also we have a performance test platform were we record Performance Test results, we want to know everything that can affect performance, that's the reason to record Rhino Version, then if they change it we could measure the difference.

Re: How do I know which version of ThingWorx is stable?

Do1 — Tue, 07 Mar 2017 08:42:37 GMT

That makes a lot of sense.... can you elaborate on what tools you use for performance testing?

Re: How do I know which version of ThingWorx is stable?

CarlesColl — Tue, 07 Mar 2017 09:03:18 GMT

It's our own tool which mostly measures services execution performance, this is how it looks like

And this is the comparison between different Platform Configurations:

Re: How do I know which version of ThingWorx is stable?

Do1 — Tue, 07 Mar 2017 09:07:31 GMT

Wow!!!

Nice work!