Bug 29630

Summary: Failure on selenium 01-installation.t
Product: Koha Reporter: Fridolin Somers <fridolin.somers>
Component: Test SuiteAssignee: Fridolin Somers <fridolin.somers>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, tomascohen
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on:    
Bug Blocks: 25551    

Description Fridolin Somers 2021-12-03 10:03:57 UTC
Jenkins build with Selenium failed :
https://jenkins.koha-community.org/view/master/job/Koha_Master/1848/

koha_1       | t/db_dependent/selenium/00-onboarding.t .. ok
koha_1       | All tests successful.
koha_1       | Files=1, Tests=2, 34 wallclock secs ( 0.04 usr  0.03 sys +  2.85 cusr  0.53 csys =  3.45 CPU)
koha_1       | Result: PASS
koha_1       | Restarting Apache httpd web server: apache2.
koha_1       | Restarting Koha ILS: koha-commonStopping Plack daemon for kohadev:.
db_1         | 2021-12-03  7:45:12 31 [Warning] Aborted connection 31 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.21.0.6' (Got an error reading communication packets)
koha_1       | Stopping Z39.50/SRU daemon for kohadev:.
koha_1       | Stopping Koha worker daemon for kohadev:.
koha_1       | Stopping Koha indexing daemon for kohadev:.
db_1         | 2021-12-03  7:45:13 34 [Warning] Aborted connection 34 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.21.0.6' (Got an error reading communication packets)
koha_1       | Starting Plack daemon for kohadev:.
koha_1       | Starting Z39.50/SRU daemon for kohadev:DBD::mysql::st execute failed: Table 'koha_kohadev.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | DBD::mysql::st execute failed: Table 'koha_kohadev.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | DBD::mysql::db selectall_arrayref failed: Table 'koha_kohadev.marc_subfield_structure' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | DBD::mysql::st execute failed: Table 'koha_kohadev.authorised_values' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | .
koha_1       | Starting Koha worker daemon for kohadev:.
koha_1       | Starting Koha indexing daemon for kohadev:.
koha_1       | .
selenium_1   | 07:45:25.238 INFO [ActiveSessionFactory.apply] - Capabilities are: {
selenium_1   |   "acceptSslCerts": true,
selenium_1   |   "browserName": "firefox",
selenium_1   |   "javascriptEnabled": true,
selenium_1   |   "version": ""
selenium_1   | }
selenium_1   | 07:45:25.240 INFO [ActiveSessionFactory.lambda$apply$11] - Matched factory org.openqa.selenium.grid.session.remote.ServicedSession$Factory (provider: org.openqa.selenium.firefox.GeckoDriverService)
selenium_1   | 1638517525267	geckodriver	INFO	Listening on 127.0.0.1:27348
selenium_1   | 1638517525305	mozrunner::runner	INFO	Running command: "/usr/bin/firefox" "--marionette" "-foreground" "-no-remote" "-profile" "/tmp/rust_mozprofileJXkgVd"
selenium_1   | [GFX1-]: glxtest: libpci missing
selenium_1   | [GFX1-]: glxtest: libEGL missing
selenium_1   | 1638517527025	Marionette	INFO	Marionette enabled
selenium_1   | console.warn: SearchSettings: "get: No settings file exists, new profile?" (new NotFoundError("Could not open the file at /tmp/rust_mozprofileJXkgVd/search.json.mozlz4", (void 0)))
selenium_1   | 1638517531931	Marionette	INFO	Listening on port 33539
selenium_1   | 07:45:32.097 INFO [ProtocolHandshake.createSession] - Detected dialect: W3C
selenium_1   | 07:45:32.098 INFO [RemoteSession$Factory.lambda$performHandshake$0] - Started new session 7bd2cfd4-18c4-47c2-b441-bcded48340d4 (org.openqa.selenium.firefox.GeckoDriverService)
koha_1       | 
koha_1       | STRACE:	/usr/share/perl5/Try/Tiny.pm:123 in Selenium::Remote::Driver::catch {...} 
koha_1       | 	/usr/local/share/perl/5.28.1/Selenium/Remote/Driver.pm:361 in Try::Tiny::try
koha_1       | 	(eval 358):1 in Selenium::Remote::Driver::__ANON__
koha_1       | 	(eval 360):2 in Selenium::Remote::Driver::__ANON__
koha_1       | 	/usr/local/share/perl/5.28.1/Selenium/Remote/Driver.pm:1340 in Selenium::Remote::Driver::_execute_command
koha_1       | 	/usr/local/share/perl/5.28.1/Selenium/Remote/Driver.pm:1340 in (eval)
koha_1       | 	t/db_dependent/selenium/01-installation.t:99 in Selenium::Remote::Driver::find_element
koha_1       | 
selenium_1   | 1638517555349	Marionette	INFO	Stopped listening on port 33539
selenium_1   | JavaScript error: resource:///modules/Interactions.jsm, line 230: NS_ERROR_FAILURE: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIUserIdleService.removeIdleObserver]
selenium_1   | 07:45:56.645 INFO [ActiveSessions$1.onStop] - Removing session 7bd2cfd4-18c4-47c2-b441-bcded48340d4 (org.openqa.selenium.firefox.GeckoDriverService)
koha_1       | Error while executing command: no such element: Unable to locate element: //div[@class="alert alert-success"] at /usr/local/share/perl/5.28.1/Selenium/Remote/Driver.pm line 411.
koha_1       |  at /usr/local/share/perl/5.28.1/Selenium/Remote/Driver.pm line 356.
koha_1       | # Looks like your test exited with 255 before it could output anything.
koha_1       | [07:45:56] t/db_dependent/selenium/01-installation.t ............................... 
koha_1       | Dubious, test returned 255 (wstat 65280, 0xff00)
koha_1       | Failed 2/2 subtests 
koha_1       | DBD::mysql::st execute failed: Table 'koha_kohadev.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
koha_1       | DBD::mysql::st execute failed: Table 'koha_kohadev.systempreferences' doesn't exist at /kohadevbox/koha/Koha/Database.pm line 152.
selenium_1   | 07:46:01.517 INFO [ActiveSessionFactory.apply] - Capabilities are: {
selenium_1   |   "acceptSslCerts": true,
selenium_1   |   "browserName": "firefox",
selenium_1   |   "javascriptEnabled": true,
selenium_1   |   "version": ""
selenium_1   | }
selenium_1   | 07:46:01.518 INFO [ActiveSessionFactory.lambda$apply$11] - Matched factory org.openqa.selenium.grid.session.remote.ServicedSession$Factory (provider: org.openqa.selenium.firefox.GeckoDriverService)
selenium_1   | 1638517561540	geckodriver	INFO	Listening on 127.0.0.1:12870
selenium_1   | 1638517561579	mozrunner::runner	INFO	Running command: "/usr/bin/firefox" "--marionette" "-foreground" "-no-remote" "-profile" "/tmp/rust_mozprofileYsufal"
selenium_1   | [GFX1-]: glxtest: libpci missing
selenium_1   | [GFX1-]: glxtest: libEGL missing
selenium_1   | 1638517563733	Marionette	INFO	Marionette enabled
selenium_1   | console.warn: SearchSettings: "get: No settings file exists, new profile?" (new NotFoundError("Could not open the file at /tmp/rust_mozprofileYsufal/search.json.mozlz4", (void 0)))
selenium_1   | 1638517569405	Marionette	INFO	Listening on port 44107
selenium_1   | 07:46:09.556 INFO [ProtocolHandshake.createSession] - Detected dialect: W3C
selenium_1   | 07:46:09.557 INFO [RemoteSession$Factory.lambda$performHandshake$0] - Started new session ac595bfb-83ee-4401-94bb-177f9b39f638 (org.openqa.selenium.firefox.GeckoDriverService)
Comment 1 Fridolin Somers 2021-12-03 10:06:06 UTC
Looks like db creation or connection had a problem
Comment 2 Fridolin Somers 2021-12-04 06:47:59 UTC
Next run whas OK :
https://jenkins.koha-community.org/view/master/job/Koha_Master/1849/
Comment 3 Fridolin Somers 2022-01-05 00:46:42 UTC
Same for
https://jenkins.koha-community.org/view/master/job/Koha_Master/1877/
Comment 4 Jonathan Druart 2023-01-31 14:51:12 UTC
Koha_Master/2365 on Docker_7.
Selenium tests must run on D3, D4 and D8 only (for now).
Comment 5 Jonathan Druart 2023-03-30 12:07:01 UTC
12:55:25 koha_1       | Error while executing command: no such element: Unable to locate element: //div[@class="alert alert-success"] at /usr/share/perl5/Selenium/Remote/Driver.pm line 411.

Koha_Master/2447 on Docker_3