Upgrade to 5.3.3 fails to recognize database table fields

[Joe Kirchner]

Hi

I am upgrading to Portofino 5.3.3. Note this is on a new computer, so the installation is new, but using the data in my existing Postgresql database.

Here are the steps that I amportofino-blocked-field.png taking:

1. Log in with admin/admin
2. Fill in the details of the connection parameters page
3. Click next and select "public"
4. Click next and choose the Users, Groups and User-Group tables
5. The remaining fields cannot be accessed. Clicking on them produces a gray box that cannot be typed in.

Note: Portofino has established the connection to the database because in step 4, when I select these tables, I am selecting from the full list of that database. 

The only field that is selectable is Encryption Algorithm. The admin group name isn't "selectable" but, as always, I can type in the name.

I am running on:

•  Linux 6.0.2-76060002-generic x86_64 
•  Pop!_OS 22.04 LTS

Here is the tail of my log:

2022-11-20 08:33:30,815 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH010002: C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/mydb
2022-11-20 08:33:30,815 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001001: Connection properties: {password=****, user=*****}
2022-11-20 08:33:30,815 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001003: Autocommit mode: false
2022-11-20 08:33:30,833 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001007: JDBC isolation level: <unknown>
2022-11-20 08:33:30,834 INFO  c.m.v.c.i.AbstractPoolBackedDataSource   admin /api/portofino-upstairs/database/connections/mydb/schemas Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@d865a359 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@8e3a7331 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> z8kfsxas15c33035tmsmp|47207b77, idleConnectionTestPeriod -> 60, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@6866ea26 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> z8kfsxas15c33035tmsmp|302099fb, jdbcUrl -> jdbc:postgresql://localhost:5432/mydb, properties -> {password=******, user=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> z8kfsxas15c33035tmsmp|15e3c764, numHelperThreads -> 3 ]
2022-11-20 08:33:30,889 INFO  c.m.portofino.persistence.Persistence    admin /api/portofino-upstairs/database/connections/mydb/schemas Initializing connection provider for database mydb
2022-11-20 08:33:30,901 INFO  c.m.p.model.database.ConnectionProvider  admin /api/portofino-upstairs/database/connections/mydb/schemas Added DECIMAL type as an alias of NUMERIC
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_1
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_2
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_3
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_4
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_5
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_6
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_7
2022-11-20 08:33:30,902 WARN  c.m.p.p.hibernate.SessionFactoryBuilder  admin /api/portofino-upstairs/database/connections/mydb/schemas Skipping table without primary key: mydb.public.unused_table_8
2022-11-20 08:33:30,923 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH010002: C3P0 using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/mydb
u2022-11-20 08:33:30,923 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001001: Connection properties: {password=****, user=*****}
2022-11-20 08:33:30,923 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001003: Autocommit mode: false
2022-11-20 08:33:30,946 INFO  o.h.c3p0.internal.C3P0ConnectionProvider admin /api/portofino-upstairs/database/connections/mydb/schemas HHH10001007: JDBC isolation level: <unknown>
2022-11-20 08:33:30,948 INFO  c.m.v.c.i.AbstractPoolBackedDataSource   admin /api/portofino-upstairs/database/connections/mydb/schemas Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@a514a2ac [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@dc4bccf0 [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, identityToken -> z8kfsxas15c33035tmsmp|6b0e5ffa, idleConnectionTestPeriod -> 60, initialPoolSize -> 1, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@99d6bbc6 [ description -> null, driverClass -> null, factoryClassLocation -> null, forceUseNamedDriverClass -> false, identityToken -> z8kfsxas15c33035tmsmp|79ab770d, jdbcUrl -> jdbc:postgresql://localhost:5432/mydb, properties -> {password=******, user=******} ], preferredTestQuery -> null, privilegeSpawnedThreads -> false, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> z8kfsxas15c33035tmsmp|45ab413e, numHelperThreads -> 3 ]
2022-11-20 08:33:31,023 INFO  c.m.portofino.persistence.Persistence    admin /api/portofino-upstairs/database/connections/mydb/schemas Saved xml model to directory: /opt/portofino-5.3.3/apache-tomcat-9.0.68/webapps/ROOT/WEB-INF/portofino-model
2022-11-20 08:33:31,023 INFO  c.m.portofino.config.ConfigurationSource admin /api/portofino-upstairs/database/connections/mydb/schemas Saved configuration file /opt/portofino-5.3.3/apache-tomcat-9.0.68/webapps/ROOT/WEB-INF/portofino.properties
2022-11-20 08:33:31,023 INFO  c.m.p.u.a.d.c.ConnectionsAction          admin /api/portofino-upstairs/database/connections/mydb/schemas Schemas for database mydb updated
2022-11-20 08:35:40,003 INFO  c.m.portofino.shiro.SecurityClassRealm     Refreshing Portofino Realm Delegate instance (Security.groovy)

Note the reference to tables that I am not using that do not have a primary key. These have never caused a problem in the past, so I assume they are just ignored.

I don't know what Autocommit mode: false refers to. Could that be the problem?

Then there is the two very long lines. I did not think there is anything wrong there.

Joe

[Alessio Stalla]

Right. We usually test the wizard manually before release but this one was a bit rushed and this slipped through.

I've already fixed it and it'll be released in 5.3.4 in a few weeks at most. Sorry for the inconvenience.

Out of curiosity, what version are you upgrading from?

Alessio

--
You received this message because you are subscribed to the Google Groups "manydesigns-portofino" group.
To unsubscribe from this group and stop receiving emails from it, send an email to manydesigns-port...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/manydesigns-portofino/70d5e039-8dfa-48f3-93df-d5eabe835af0n%40googlegroups.com.

[Joe Kirchner]

I am upgrading from version of 5.30. But that computer is no longer operational.

In any case, I am very pleased to see the level 5 documentation. 

[Alessio Stalla]

5.3.4 just came out and it should fix your issue!

Have fun,

Alessio