search

rammpeter / panorama

Tool for monitoring performance issues of Oracle databases
GNU General Public License v3.0
16 stars 5 forks source link

LoginClick - "Argument Error: comparison of Integer with String failed" #17

Closed thomas-de-ac closed 10 months ago

thomas-de-ac commented 10 months ago

Hallo Peter Ramm, seit Jahren stolpere ich immer wieder mal über Panorama, jetzt will ich es endlich mal probieren und bin v.a. gespannt auf den Sampler als ASH-Ersatz. Die genutzte Testumgebung ist Windows10 mit Oracle 19.19 SE2 mit lokaler DB und Panorama.jar 2.17.09.

Leider habe ich es nur bis zum Login geschafft :( Sobald ich den Button "Login" im Anmelde-Dialog klicke, kommt im hochfahrenden grauen Bereich:

Error connecting to database
Argument Error: comparison of Integer with String failed
JDBC URL: 'jdbc:oracle:thin:@NB01451:1521:SET19N01'
Client Timezone: "Europe/Berlin", Mitteleuropäische Zeit

Dasselbe passiert bei beliebigen Angaben für SID/HOST/POST und auch bei Verwendung einer tnsnames.

Im Konsolen-Output wird kein Fehler vermerkt, weitere log-Dateien, stacktraces, o.ä. finde ich nicht.

Probiert habe ich mit

Immer dasselbe Fehlerbild - Argument Error: comparison of Integer with String failed.

Ich bin ratlos und weiß nicht, was ich noch probieren könnte oder wo die Ursache des Verhalten liegen könnte. Für eine Tipp bin ich dankbar.

Viele Grüße, Thomas


------------------------------ 
:: Mit Java 1.8 aus dem ORACLE_HOME der Server-Installation
:: D:\panorama>java -version
:: java version "1.8.0_361"
:: Java(TM) SE Runtime Environment (build 1.8.0_361-b09)
:: Java HotSpot(TM) 64-Bit Server VM (build 25.361-b09, mixed mode)
------------------------------ Console-Output

D:\panorama>set PATH=C:\ora64\product\19.0.0\19se2\jdk\jre\bin;%PATH%
D:\panorama>SET JAVA_HOME=C:\ora64\product\19.0.0\19se2\jdk\jre
D:\panorama>set TNS_ADMIN=D:\panorama
D:\panorama>set TEMP=D:\panorama\tmp
D:\panorama>set TMP=D:\panorama\tmp
D:\panorama>set MAX_CONNECTION_POOL_SIZE=100
D:\panorama>set PANORAMA_VAR_HOME=D:\panorama\var
D:\panorama>set PANORAMA_LOG_LEVEL=debug
D:\panorama>java -jar -Xmx4096m Panorama.jar

Extracting files from D:/panorama/Panorama.jar to D:\panorama\tmp\09ccf7a2-7a52-4955-99ae-912662e85371
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_int
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_f
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/nokogiri-1.15.4-java/lib/nokogiri/xml/node.rb:1007: warning: method redefined; discarding old attr
Panorama for Oracle: Release 2.17.09 ( 2023/08/28 )
Panorama writes server side info to D:\panorama\var
=> Booting Puma
=> Rails 6.1.7.6 application starting in production
=> Run `bin/rails server --help` for more startup options
[2023-09-14 11:16:07.505] WARN  (4120 EnvHelper.secret_key_base): Neither SECRET_KEY_BASE nor SECRET_KEY_BASE_FILE provided nor file exists at default location D:\panorama\var/secret_key_base!
[2023-09-14 11:16:07.508] WARN  (4120 EnvHelper.secret_key_base): Encryption key for SECRET_KEY_BASE is initially generated and stored at D:\panorama\var/secret_key_base!
[2023-09-14 11:16:07.544] INFO  (4120): [ActiveJob] Enqueued InitializationJob (Job ID: 4ece36f6-de36-4a92-bddb-468905b05756) to Async(default) at 2023-09-14 09:16:08 UTC
[2023-09-14 11:16:07.547] INFO  (4120): [ActiveJob] Enqueued ConnectionTerminateJob (Job ID: d3172589-208d-4e23-bb36-0d93d25ba089) to Async(default) at 2023-09-14 09:16:17 UTC
[2023-09-14 11:16:08.578] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Performing InitializationJob (Job ID: 4ece36f6-de36-4a92-bddb-468905b05756) from Async(default) enqueued at 2023-09-14T09:16:07Z
[2023-09-14 11:16:08.581] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Memory resources:
[2023-09-14 11:16:08.585] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Total OS Memory (GB)     :
[2023-09-14 11:16:08.586] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Available OS Memory (GB) :
[2023-09-14 11:16:08.586] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Free Memory OS (GB)      :
[2023-09-14 11:16:08.587] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Total OS Swap (GB)       :
[2023-09-14 11:16:08.587] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Free OS Swap (GB)        :
[2023-09-14 11:16:08.589] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Initial Java Heap (GB)   : 0.496
[2023-09-14 11:16:08.590] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Maximum Java Heap (GB)   : 3.556
[2023-09-14 11:16:08.593] INFO  (4148): [ActiveJob] [InitializationJob] [4ece36f6-de36-4a92-bddb-468905b05756] Performed InitializationJob (Job ID: 4ece36f6-de36-4a92-bddb-468905b05756) from Async(default) in 14.46ms
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/09ccf7a2-7a52-4955-99ae-912662e85371/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
The signal USR2 is in use by the JVM and will not work correctly on this platform
The signal HUP is in use by the JVM and will not work correctly on this platform
Puma starting in single mode...
* Puma version: 5.6.7 (jruby 9.4.3.0 - ruby 3.1.4) ("Birdie's Version")
*  Min threads: 5
*  Max threads: 100
*  Environment: production
*          PID: 9296
* Listening on http://[::]:8080
Use Ctrl-C to stop
[2023-09-14 11:16:17.560] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [d3172589-208d-4e23-bb36-0d93d25ba089] Performing ConnectionTerminateJob (Job ID: d3172589-208d-4e23-bb36-0d93d25ba089) from Async(default) enqueued at 2023-09-14T09:16:07Z
[2023-09-14 11:16:17.564] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [d3172589-208d-4e23-bb36-0d93d25ba089] Enqueued ConnectionTerminateJob (Job ID: 4e01f1fa-06ca-473e-95be-a39fffad7994) to Async(default) at 2023-09-14 10:16:18 UTC
[2023-09-14 11:16:17.567] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [d3172589-208d-4e23-bb36-0d93d25ba089] Local directory for client-info store is D:\panorama\var/client_info.store
[2023-09-14 11:16:17.571] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [d3172589-208d-4e23-bb36-0d93d25ba089] Performed ConnectionTerminateJob (Job ID: d3172589-208d-4e23-bb36-0d93d25ba089) from Async(default) in 10.01ms
[2023-09-14 11:16:41.687] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] Started GET "/" for 0:0:0:0:0:0:0:1 at 2023-09-14 11:16:41 +0200
[2023-09-14 11:16:41.709] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] Processing by EnvController#index as HTML
[2023-09-14 11:16:41.723] ERROR (4176 EnvHelper.initialize_client_key_cookie): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] Exception ActiveSupport::MessageEncryptor::InvalidMessage while database_helper_decrypt_value(cookies['client_key'])
[2023-09-14 11:16:41.751] DEBUG (4176 ApplicationHelper.read_from_client_info_store): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] read_from_client_info_store: No data found in client_info_store while looking for key=browser_tab_ids
[2023-09-14 11:16:41.808] DEBUG (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendering layout layouts/default.html.erb
[2023-09-14 11:16:41.809] DEBUG (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendering env/index.html.erb within layouts/default
[2023-09-14 11:16:41.813] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendered env/index.html.erb within layouts/default (Duration: 3.2ms | Allocations: 0)
[2023-09-14 11:16:41.880] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-14 11:16:41.925] DEBUG (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendered env/_licensing.html.erb (Duration: 3.9ms | Allocations: 0)
[2023-09-14 11:16:41.926] DEBUG (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendered env/_start_screen_before_login.en.html.erb (Duration: 19.8ms | Allocations: 0)
[2023-09-14 11:16:41.929] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef]   Rendered layout layouts/default.html.erb (Duration: 120.0ms | Allocations: 0)
[2023-09-14 11:16:41.931] INFO  (4176): [31e30ba1-6be6-4b04-aa31-2a4248be0aef] Completed 200 OK in 222ms (Views: 131.6ms | Allocations: 0)
[2023-09-14 11:16:42.120] INFO  (4204): [76d01245-3931-41f6-8fd8-5183948bb177] Started GET "/env/get_tnsnames_content?target_object=database" for 0:0:0:0:0:0:0:1 at 2023-09-14 11:16:42 +0200
[2023-09-14 11:16:42.124] INFO  (4204): [76d01245-3931-41f6-8fd8-5183948bb177] Processing by EnvController#get_tnsnames_content as */*
[2023-09-14 11:16:42.125] INFO  (4204): [76d01245-3931-41f6-8fd8-5183948bb177]   Parameters: {"target_object"=>"database"}
[2023-09-14 11:16:42.129] INFO  (4204): [76d01245-3931-41f6-8fd8-5183948bb177] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-14 11:16:42.133] INFO  (4204): [76d01245-3931-41f6-8fd8-5183948bb177] Completed 200 OK in 8ms (Views: 0.4ms | Allocations: 0)
[2023-09-14 11:18:31.836] INFO  (4216): [460cd870-5b25-4f4e-8b47-09b7d9df216e] Started POST "/env/set_database_by_params" for 0:0:0:0:0:0:0:1 at 2023-09-14 11:18:31 +0200
[2023-09-14 11:18:31.847] INFO  (4216): [460cd870-5b25-4f4e-8b47-09b7d9df216e] Processing by EnvController#set_database_by_params as HTML
[2023-09-14 11:18:31.847] INFO  (4216): [460cd870-5b25-4f4e-8b47-09b7d9df216e]   Parameters: {"database"=>{"modus"=>"host", "tns"=>"SE.ENTW.22208", "host"=>"NB01451", "port"=>"1521", "sid_usage"=>"SID", "sid"=>"SET19N01", "user"=>"system", "password"=>"[FILTERED]", "authorization"=>"", "privilege"=>"normal", "query_timeout"=>"300"}, "browser_tab_id"=>"1", "commit"=>"Login"}
[2023-09-14 11:18:31.908] INFO  (4216): [460cd870-5b25-4f4e-8b47-09b7d9df216e] Completed 200 OK in 59ms (Views: 0.5ms | Allocations: 0)
[2023-09-14 11:19:11.974] INFO  (4228): [b25a0e6d-c361-432e-a2cb-238fcc6a8bee] Started POST "/env/set_database_by_params" for 0:0:0:0:0:0:0:1 at 2023-09-14 11:19:11 +0200
[2023-09-14 11:19:11.980] INFO  (4228): [b25a0e6d-c361-432e-a2cb-238fcc6a8bee] Processing by EnvController#set_database_by_params as HTML
[2023-09-14 11:19:11.981] INFO  (4228): [b25a0e6d-c361-432e-a2cb-238fcc6a8bee]   Parameters: {"database"=>{"modus"=>"host", "tns"=>"SE.ENTW.22208", "host"=>"NB01451", "port"=>"1521", "sid_usage"=>"SID", "sid"=>"SET19N01", "user"=>"system", "password"=>"[FILTERED]", "authorization"=>"", "privilege"=>"normal", "query_timeout"=>"2000"}, "browser_tab_id"=>"1", "commit"=>"Login"}
[2023-09-14 11:19:12.009] INFO  (4228): [b25a0e6d-c361-432e-a2cb-238fcc6a8bee] Completed 200 OK in 27ms (Views: 0.3ms | Allocations: 0)
- Gracefully stopping, waiting for requests to finish
=== puma shutdown: 2023-09-14 11:19:59 +0200 ===
- Goodbye!
Exiting

2023-09-14 13_03_32-D__panorama

rammpeter commented 10 months ago

Hallo Thomas, Vielen Dank für die Probleminfo. Ich schau mir das zeitnah an. Sollte auf alle Fälle lösbar sein. viele Grüße Peter

rammpeter commented 10 months ago

thomas-de-ac

Hallo Thomas, kannst Du bitte den Connect-Versuch nochmal wiederholen mit dem Release 2.17.10. Das Problem ist noch nicht wirklich identifiziert, allerdings ist das Logging im betroffenen Bereich jetzt so erweitert, dass die Ursache lokalisiert werden kann. Nachvollziehen konnte ich das Problem selber nicht unter Windows, aber mit diesem Schritt sollte die Ursache erkennbar sein. Viele Grüße Peter

thomas-de-ac commented 10 months ago

Hallo Peter, ich sag schonmal Danke für deine extrem schnelle Reaktion und Hilfe! Ich habe erst am Sonntagabend Zeit, das neue Release zu probieren.

Bis dahin ein schönes Wochenende, Thomas

thomas-de-ac commented 10 months ago

Hallo Peter, ich habe 2 Versuche mit 2.17.10 gemacht. Das Verhalten ist natürlich unverändert, der Login gelingt nicht. Ich poste mal den Output und hoffe, dass das bei der weiteren Analyse hilft. Viele Grüße, Thomas

1. Versuch, Verzeichnisse %TEMP% (D:\panorama\tmp) und %PANORAMA_VAR_HOME% (D:\panorama\var) vorher geleert

D:\panorama>startup.cmd
D:\panorama>set PATH=C:\ora64\product\19.0.0\19se2\jdk\jre\bin;%PATH%
D:\panorama>SET JAVA_HOME=C:\ora64\product\19.0.0\19se2\jdk\jre
D:\panorama>set TNS_ADMIN=D:\panorama
D:\panorama>set TEMP=D:\panorama\tmp
D:\panorama>set TMP=D:\panorama\tmp
D:\panorama>set MAX_CONNECTION_POOL_SIZE=100
D:\panorama>set PANORAMA_VAR_HOME=D:\panorama\var
D:\panorama>set PANORAMA_LOG_LEVEL=debug

D:\panorama>java -jar -Xmx4096m Panorama.jar
Extracting files from D:/panorama/Panorama.jar to D:\panorama\tmp\f533be8b-4820-4d51-a1aa-3dd5e0f28a05
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_int
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_f
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/nokogiri-1.15.4-java/lib/nokogiri/xml/node.rb:1007: warning: method redefined; discarding old attr
Panorama for Oracle: Release 2.17.10 ( 2023/09/15 )
Panorama writes server side info to D:\panorama\var
=> Booting Puma
=> Rails 6.1.7.6 application starting in production
=> Run `bin/rails server --help` for more startup options
[2023-09-18 07:21:30.728] WARN  (4120 EnvHelper.secret_key_base): Neither SECRET_KEY_BASE nor SECRET_KEY_BASE_FILE provided nor file exists at default location D:\panorama\var/secret_key_base!
[2023-09-18 07:21:30.728] WARN  (4120 EnvHelper.secret_key_base): Encryption key for SECRET_KEY_BASE is initially generated and stored at D:\panorama\var/secret_key_base!
[2023-09-18 07:21:30.766] INFO  (4120): [ActiveJob] Enqueued InitializationJob (Job ID: 25543de6-5324-45eb-adc6-7a03957460d5) to Async(default) at 2023-09-18 05:21:31 UTC
[2023-09-18 07:21:30.766] INFO  (4120): [ActiveJob] Enqueued ConnectionTerminateJob (Job ID: 85d65e2f-1df2-4d7d-940c-e5f33a5037d7) to Async(default) at 2023-09-18 05:21:40 UTC
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
[2023-09-18 07:21:31.794] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Performing InitializationJob (Job ID: 25543de6-5324-45eb-adc6-7a03957460d5) from Async(default) enqueued at 2023-09-18T05:21:30Z
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
[2023-09-18 07:21:31.794] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Memory resources:
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Total OS Memory (GB)     :
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Available OS Memory (GB) :
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Free Memory OS (GB)      :
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Total OS Swap (GB)       :
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Free OS Swap (GB)        :
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Initial Java Heap (GB)   : 0.496
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Maximum Java Heap (GB)   : 3.556
[2023-09-18 07:21:31.810] INFO  (4148): [ActiveJob] [InitializationJob] [25543de6-5324-45eb-adc6-7a03957460d5] Performed InitializationJob (Job ID: 25543de6-5324-45eb-adc6-7a03957460d5) from Async(default) in 9.06ms
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
The signal USR2 is in use by the JVM and will not work correctly on this platform
The signal HUP is in use by the JVM and will not work correctly on this platform
Puma starting in single mode...
* Puma version: 5.6.7 (jruby 9.4.3.0 - ruby 3.1.4) ("Birdie's Version")
*  Min threads: 5
*  Max threads: 100
*  Environment: production
*          PID: 7648
* Listening on http://[::]:8080
Use Ctrl-C to stop
[2023-09-18 07:21:33.634] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69] Started GET "/" for 127.0.0.1 at 2023-09-18 07:21:33 +0200
[2023-09-18 07:21:33.655] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69] Processing by EnvController#index as HTML
[2023-09-18 07:21:33.655] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69] Local directory for client-info store is D:\panorama\var/client_info.store
[2023-09-18 07:21:33.671] ERROR (4172 EnvHelper.initialize_client_key_cookie): [de102029-eb86-4262-ba7c-031c6a4a6e69] Exception ActiveSupport::MessageEncryptor::InvalidMessage while database_helper_decrypt_value(cookies['client_key'])
[2023-09-18 07:21:33.705] DEBUG (4172 ApplicationHelper.read_from_client_info_store): [de102029-eb86-4262-ba7c-031c6a4a6e69] read_from_client_info_store: No data found in client_info_store while looking for key=browser_tab_ids
[2023-09-18 07:21:33.755] DEBUG (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendering layout layouts/default.html.erb
[2023-09-18 07:21:33.755] DEBUG (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendering env/index.html.erb within layouts/default
[2023-09-18 07:21:33.771] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendered env/index.html.erb within layouts/default (Duration: 3.3ms | Allocations: 0)
[2023-09-18 07:21:33.833] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-18 07:21:33.871] DEBUG (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendered env/_licensing.html.erb (Duration: 4.3ms | Allocations: 0)
[2023-09-18 07:21:33.871] DEBUG (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendered env/_start_screen_before_login.en.html.erb (Duration: 19.0ms | Allocations: 0)
[2023-09-18 07:21:33.871] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69]   Rendered layout layouts/default.html.erb (Duration: 119.2ms | Allocations: 0)
[2023-09-18 07:21:33.871] INFO  (4172): [de102029-eb86-4262-ba7c-031c6a4a6e69] Completed 200 OK in 224ms (Views: 128.9ms | Allocations: 0)
[2023-09-18 07:21:34.087] INFO  (4172): [d6b6c62e-b324-44ac-bda6-32303b331659] Started GET "/env/get_tnsnames_content?target_object=database" for 127.0.0.1 at 2023-09-18 07:21:34 +0200
[2023-09-18 07:21:34.087] INFO  (4172): [d6b6c62e-b324-44ac-bda6-32303b331659] Processing by EnvController#get_tnsnames_content as */*
[2023-09-18 07:21:34.087] INFO  (4172): [d6b6c62e-b324-44ac-bda6-32303b331659]   Parameters: {"target_object"=>"database"}
[2023-09-18 07:21:34.087] INFO  (4172): [d6b6c62e-b324-44ac-bda6-32303b331659] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-18 07:21:34.087] INFO  (4172): [d6b6c62e-b324-44ac-bda6-32303b331659] Completed 200 OK in 6ms (Views: 0.3ms | Allocations: 0)
[2023-09-18 07:21:40.789] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [85d65e2f-1df2-4d7d-940c-e5f33a5037d7] Performing ConnectionTerminateJob (Job ID: 85d65e2f-1df2-4d7d-940c-e5f33a5037d7) from Async(default) enqueued at 2023-09-18T05:21:30Z
[2023-09-18 07:21:40.804] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [85d65e2f-1df2-4d7d-940c-e5f33a5037d7] Enqueued ConnectionTerminateJob (Job ID: cd94dc1a-5896-43ce-9a8e-5cbfced661c1) to Async(default) at 2023-09-18 06:21:41 UTC
[2023-09-18 07:21:40.804] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [85d65e2f-1df2-4d7d-940c-e5f33a5037d7] Performed ConnectionTerminateJob (Job ID: 85d65e2f-1df2-4d7d-940c-e5f33a5037d7) from Async(default) in 18.8ms
[2023-09-18 07:23:02.832] INFO  (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Started POST "/env/set_database_by_params" for 0:0:0:0:0:0:0:1 at 2023-09-18 07:23:02 +0200
[2023-09-18 07:23:02.840] INFO  (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Processing by EnvController#set_database_by_params as HTML
[2023-09-18 07:23:02.841] INFO  (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b]   Parameters: {"database"=>{"modus"=>"host", "tns"=>"SE.ENTW.22208", "host"=>"NB01451", "port"=>"1521", "sid_usage"=>"SID", "sid"=>"SET19N01", "user"=>"system", "password"=>"[FILTERED]", "authorization"=>"", "privilege"=>"normal", "query_timeout"=>"300"}, "browser_tab_id"=>"1", "commit"=>"Login"}
[2023-09-18 07:23:02.870] DEBUG (4208 EnvController.set_database): [27a195cf-1f57-4933-bd21-56f2feaa531b] Error connecting to database: ArgumentError: comparison of Integer with String failed
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Memory resources:
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Total OS Memory (GB)     :
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Available OS Memory (GB) :
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Free Memory OS (GB)      :
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Total OS Swap (GB)       :
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Free OS Swap (GB)        :
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Initial Java Heap (GB)   : 0.496
[2023-09-18 07:23:02.870] DEBUG (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Maximum Java Heap (GB)   : 3.556
[2023-09-18 07:23:02.870] DEBUG (4208 ExceptionHelper.log_exception_backtrace): [27a195cf-1f57-4933-bd21-56f2feaa531b] Stack-Trace for ArgumentError:
org/jruby/RubyFixnum.java:1128:in `>='
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/app_root/app/models/panorama_connection.rb:712:in `retrieve_from_pool_or_create_new_connection'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/app_root/app/models/panorama_connection.rb:648:in `check_for_open_connection'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/app_root/app/controllers/env_controller.rb:392:in `set_database'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/app_root/app/controllers/env_controller.rb:277:in `set_database_by_params'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/base.rb:228:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/rendering.rb:30:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/callbacks.rb:106:in `run_callbacks'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/callbacks.rb:41:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/rescue.rb:22:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/instrumentation.rb:34:in `block in process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications.rb:203:in `block in instrument'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications.rb:203:in `instrument'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/instrumentation.rb:33:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/params_wrapper.rb:249:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/activerecord-6.1.7.6/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
D:/panorama/tmp/f533be8b-4820-4d51-a1aa-3dd5e0f28a05/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/base.rb:165:in `process'

[2023-09-18 07:23:02.886] INFO  (4208): [27a195cf-1f57-4933-bd21-56f2feaa531b] Completed 200 OK in 47ms (Views: 0.4ms | Allocations: 0)
- Gracefully stopping, waiting for requests to finish
=== puma shutdown: 2023-09-18 07:23:19 +0200 ===
- Goodbye!
Exiting
Batchvorgang abbrechen (J/N)? j

2. Versuch, Neustart von panorama.jar

D:\panorama>startup.cmd
D:\panorama>set PATH=C:\ora64\product\19.0.0\19se2\jdk\jre\bin;%PATH%
D:\panorama>SET JAVA_HOME=C:\ora64\product\19.0.0\19se2\jdk\jre
D:\panorama>set TNS_ADMIN=D:\panorama
D:\panorama>set TEMP=D:\panorama\tmp
D:\panorama>set TMP=D:\panorama\tmp
D:\panorama>set MAX_CONNECTION_POOL_SIZE=100
D:\panorama>set PANORAMA_VAR_HOME=D:\panorama\var
D:\panorama>set PANORAMA_LOG_LEVEL=debug

D:\panorama>java -jar -Xmx4096m Panorama.jar
Extracting files from D:/panorama/Panorama.jar to D:\panorama\tmp\0f0b441a-9b10-49c4-8a6c-b0faa4754ebe
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_int
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/concurrent-ruby-1.2.2/lib/concurrent-ruby/concurrent/executor/java_thread_pool_executor.rb:13: warning: method redefined; discarding old to_f
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/nokogiri-1.15.4-java/lib/nokogiri/xml/node.rb:1007: warning: method redefined; discarding old attr
Panorama for Oracle: Release 2.17.10 ( 2023/09/15 )
Panorama writes server side info to D:\panorama\var
=> Booting Puma
=> Rails 6.1.7.6 application starting in production
=> Run `bin/rails server --help` for more startup options
[2023-09-18 07:24:04.597] INFO  (4120 EnvHelper.secret_key_base): Secret key base read from default file location 'D:\panorama\var/secret_key_base' (128 chars)
[2023-09-18 07:24:04.630] INFO  (4120): [ActiveJob] Enqueued InitializationJob (Job ID: b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438) to Async(default) at 2023-09-18 05:24:05 UTC
[2023-09-18 07:24:04.630] INFO  (4120): [ActiveJob] Enqueued ConnectionTerminateJob (Job ID: ad334b6d-d577-47df-9281-2350dc7b9180) to Async(default) at 2023-09-18 05:24:14 UTC
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Performing InitializationJob (Job ID: b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438) from Async(default) enqueued at 2023-09-18T05:24:04Z
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Memory resources:
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Total OS Memory (GB)     :
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Available OS Memory (GB) :
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Free Memory OS (GB)      :
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Total OS Swap (GB)       :
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Free OS Swap (GB)        :
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Initial Java Heap (GB)   : 0.496
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Maximum Java Heap (GB)   : 3.556
[2023-09-18 07:24:05.647] INFO  (4148): [ActiveJob] [InitializationJob] [b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438] Performed InitializationJob (Job ID: b82f2a9f-7e6c-4cf0-aab7-9681aa9e6438) from Async(default) in 11.86ms
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/dependencies.rb:332: warning: parentheses after method name is interpreted as an argument list, not a decomposed argument
The signal USR2 is in use by the JVM and will not work correctly on this platform
The signal HUP is in use by the JVM and will not work correctly on this platform
Puma starting in single mode...
* Puma version: 5.6.7 (jruby 9.4.3.0 - ruby 3.1.4) ("Birdie's Version")
*  Min threads: 5
*  Max threads: 100
*  Environment: production
*          PID: 15196
* Listening on http://[::]:8080
Use Ctrl-C to stop
[2023-09-18 07:24:14.634] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [ad334b6d-d577-47df-9281-2350dc7b9180] Performing ConnectionTerminateJob (Job ID: ad334b6d-d577-47df-9281-2350dc7b9180) from Async(default) enqueued at 2023-09-18T05:24:04Z
[2023-09-18 07:24:14.650] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [ad334b6d-d577-47df-9281-2350dc7b9180] Enqueued ConnectionTerminateJob (Job ID: d191407f-3e6e-4ef7-b714-49478450c8fb) to Async(default) at 2023-09-18 06:24:15 UTC
[2023-09-18 07:24:14.656] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [ad334b6d-d577-47df-9281-2350dc7b9180] Local directory for client-info store is D:\panorama\var/client_info.store
[2023-09-18 07:24:14.656] INFO  (4148): [ActiveJob] [ConnectionTerminateJob] [ad334b6d-d577-47df-9281-2350dc7b9180] Performed ConnectionTerminateJob (Job ID: ad334b6d-d577-47df-9281-2350dc7b9180) from Async(default) in 21.2ms
[2023-09-18 07:24:23.223] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39] Started GET "/" for 0:0:0:0:0:0:0:1 at 2023-09-18 07:24:23 +0200
[2023-09-18 07:24:23.240] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39] Processing by EnvController#index as HTML
[2023-09-18 07:24:23.319] DEBUG (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendering layout layouts/default.html.erb
[2023-09-18 07:24:23.320] DEBUG (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendering env/index.html.erb within layouts/default
[2023-09-18 07:24:23.328] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendered env/index.html.erb within layouts/default (Duration: 3.3ms | Allocations: 0)
[2023-09-18 07:24:23.400] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-18 07:24:23.439] DEBUG (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendered env/_licensing.html.erb (Duration: 4.6ms | Allocations: 0)
[2023-09-18 07:24:23.440] DEBUG (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendered env/_start_screen_before_login.en.html.erb (Duration: 15.3ms | Allocations: 0)
[2023-09-18 07:24:23.443] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39]   Rendered layout layouts/default.html.erb (Duration: 122.8ms | Allocations: 0)
[2023-09-18 07:24:23.446] INFO  (4176): [e747956d-d6d7-4eee-a2ea-52b264a93c39] Completed 200 OK in 203ms (Views: 133.3ms | Allocations: 0)
[2023-09-18 07:24:23.625] INFO  (4204): [38290d80-5206-4238-bec5-d64d24d69351] Started GET "/env/get_tnsnames_content?target_object=database" for 0:0:0:0:0:0:0:1 at 2023-09-18 07:24:23 +0200
[2023-09-18 07:24:23.628] INFO  (4204): [38290d80-5206-4238-bec5-d64d24d69351] Processing by EnvController#get_tnsnames_content as */*
[2023-09-18 07:24:23.628] INFO  (4204): [38290d80-5206-4238-bec5-d64d24d69351]   Parameters: {"target_object"=>"database"}
[2023-09-18 07:24:23.633] INFO  (4204): [38290d80-5206-4238-bec5-d64d24d69351] Using tnsnames-file at D:\panorama/tnsnames.ora
[2023-09-18 07:24:23.638] INFO  (4204): [38290d80-5206-4238-bec5-d64d24d69351] Completed 200 OK in 9ms (Views: 0.3ms | Allocations: 0)
[2023-09-18 07:25:20.650] INFO  (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Started POST "/env/set_database_by_params" for 0:0:0:0:0:0:0:1 at 2023-09-18 07:25:20 +0200
[2023-09-18 07:25:20.654] INFO  (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Processing by EnvController#set_database_by_params as HTML
[2023-09-18 07:25:20.654] INFO  (4216): [dccd9b69-c058-437c-bb24-45c730a5c220]   Parameters: {"database"=>{"modus"=>"host", "tns"=>"SE.ENTW.22208", "host"=>"NB01451", "port"=>"1521", "sid_usage"=>"SID", "sid"=>"SET19N01", "user"=>"system", "password"=>"[FILTERED]", "authorization"=>"", "privilege"=>"normal", "query_timeout"=>"300"}, "browser_tab_id"=>"2", "commit"=>"Login"}
[2023-09-18 07:25:20.685] DEBUG (4216 EnvController.set_database): [dccd9b69-c058-437c-bb24-45c730a5c220] Error connecting to database: ArgumentError: comparison of Integer with String failed
[2023-09-18 07:25:20.685] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Memory resources:
[2023-09-18 07:25:20.685] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Total OS Memory (GB)     :
[2023-09-18 07:25:20.685] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Available OS Memory (GB) :
[2023-09-18 07:25:20.692] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Free Memory OS (GB)      :
[2023-09-18 07:25:20.692] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Total OS Swap (GB)       :
[2023-09-18 07:25:20.692] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Free OS Swap (GB)        :
[2023-09-18 07:25:20.692] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Initial Java Heap (GB)   : 0.496
[2023-09-18 07:25:20.692] DEBUG (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Maximum Java Heap (GB)   : 3.556
[2023-09-18 07:25:20.692] DEBUG (4216 ExceptionHelper.log_exception_backtrace): [dccd9b69-c058-437c-bb24-45c730a5c220] Stack-Trace for ArgumentError:
org/jruby/RubyFixnum.java:1128:in `>='
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/app_root/app/models/panorama_connection.rb:712:in `retrieve_from_pool_or_create_new_connection'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/app_root/app/models/panorama_connection.rb:648:in `check_for_open_connection'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/app_root/app/controllers/env_controller.rb:392:in `set_database'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/app_root/app/controllers/env_controller.rb:277:in `set_database_by_params'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/base.rb:228:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/rendering.rb:30:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/callbacks.rb:106:in `run_callbacks'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/callbacks.rb:41:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/rescue.rb:22:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/instrumentation.rb:34:in `block in process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications.rb:203:in `block in instrument'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activesupport-6.1.7.6/lib/active_support/notifications.rb:203:in `instrument'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/instrumentation.rb:33:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/action_controller/metal/params_wrapper.rb:249:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/activerecord-6.1.7.6/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
D:/panorama/tmp/0f0b441a-9b10-49c4-8a6c-b0faa4754ebe/gems/jruby/3.1.0/gems/actionpack-6.1.7.6/lib/abstract_controller/base.rb:165:in `process'

[2023-09-18 07:25:20.692] INFO  (4216): [dccd9b69-c058-437c-bb24-45c730a5c220] Completed 200 OK in 47ms (Views: 0.3ms | Allocations: 0)
- Gracefully stopping, waiting for requests to finish
=== puma shutdown: 2023-09-18 07:25:35 +0200 ===
- Goodbye!
Exiting
Batchvorgang abbrechen (J/N)? j
rammpeter commented 10 months ago

Hallo Thomas, vielen Dank für die Unterstützung. Das Problem wird ausgelöst durch das explizite Setzen von MAX_CONNECTION_POOL_SIZE=100, hier liegt mein Fehler und eine fehlender Testfall. Wenn Du diese Environment-Variable weglässt sollte der Start funktionieren (Default für diesen Wert ist auch 100). Wird natürlich trotzdem gefixt. Auf weiteren Erfahrungen im Einsatz des Panorama-Sampler wäre ich sehr gespannt. Viele Grüße Peter

thomas-de-ac commented 10 months ago

Hallo Peter, tatsächlich - sobald ich MAX_CONNECTION_POOL_SIZE weglasse funktioniert der Login und es geht mit der License-Frage nach dem Diagnostic-Pack weiter. Ich höre allerdings aktuell auf, weiter zu probieren, werde das aber in den kommenden Tagen tun.

Da ich ausschließlich SE2-DBs nutze, will ich den Sampler aktivieren. Mal schauen ob das gut funktioniert. Erfahrungen damit werde ich als neue Issues (oder Discussion?) hier posten.

Dieses Issue schließe ich jetzt mit diesem Kommentar :)

Und dir nochmal vielen Dank dir für die schnelle Hilfe. Liebe Grüße, Thomas

rammpeter commented 10 months ago

Fixed with Rel. 2.17.11