Skip to content

Console Output

+ env
JENKINS_UI_SERVICE_PORT=80
GIT_COMMIT=d2e299a217ebb86ea8ec783612b5ece885e20694
RUN_DISPLAY_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/39/display/redirect
GITLAB_OBJECT_KIND=none
JENKINS_URL=https://ci.eclipse.org/eclipselink/
M2_HOME=/home/jenkins/extension.lib.external/apache-maven-3.6.0
EXECUTOR_NUMBER=0
JENKINS_DISCOVERY_SERVICE_PORT=50000
JENKINS_DISCOVERY_PORT_50000_TCP_PROTO=tcp
_=/usr/bin/env
BUILD_ID=39
HOSTNAME=el-master-agent-pod-kvs59-g1slg
OLDPWD=/
RUN_CHANGES_DISPLAY_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/39/display/redirect?page=changes
NOTIFICATION_ADDRESS=eclipselink-dev@eclipse.org
JENKINS_DISCOVERY_PORT_50000_TCP_PORT=50000
JENKINS_NODE_COOKIE=c7a6aea8-25ba-48ee-b8a5-e70e8a6fc371
TEST_DB_PASSWORD=root
JAVA_HOME=/opt/tools/java/adoptopenjdk/hotspot-jdk-11/latest
JOB_BASE_NAME=eclipselink-cb-2.7_test
WORKSPACE_TMP=/home/jenkins/agent/workspace/eclipselink-cb-2.7_test@tmp
KUBERNETES_PORT_443_TCP_PROTO=tcp
CI=true
GIT_URL=https://github.com/rfelcman/eclipselink.git
CLASSPATH=
KUBERNETES_PORT_443_TCP_ADDR=10.30.0.1
SSH_CREDENTIALS_ID=github-bot-ssh
BUILD_RESULTS_TARGET_DIR=/home/data/httpd/download.eclipse.org/rt/eclipselink/nightly.test
POD_CONTAINER=el-build
BUILD_NUMBER=39
CONTINUOUS_BUILD=true
JENKINS_UI_SERVICE_PORT_HTTP=80
JENKINS_UI_PORT_80_TCP_ADDR=10.30.39.21
KUBERNETES_PORT=tcp://10.30.0.1:443
WORKSPACE=/home/jenkins/agent/workspace/eclipselink-cb-2.7_test
PWD=/home/jenkins/agent/workspace/eclipselink-cb-2.7_test
HUDSON_URL=https://ci.eclipse.org/eclipselink/
HOME=/home/jenkins
NODE_NAME=el-master-agent-pod-kvs59-g1slg
JENKINS_DISCOVERY_PORT_50000_TCP=tcp://10.30.185.78:50000
JENKINS_DISCOVERY_SERVICE_PORT_JNLP=50000
HUDSON_SERVER_COOKIE=1b8a48d8fd2f6d5f
JENKINS_HOME=/var/jenkins
JENKINS_UI_PORT=tcp://10.30.39.21:80
JOB_NAME=eclipselink-cb-2.7_test
RUN_TESTS_DISPLAY_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/39/display/redirect?page=tests
KUBERNETES_SERVICE_PORT_HTTPS=443
TEST_RESULTS_TARGET_DIR=/home/data/httpd/download.eclipse.org/rt/eclipselink/nightly.test
KUBERNETES_PORT_443_TCP_PORT=443
GIT_PREVIOUS_COMMIT=d2e299a217ebb86ea8ec783612b5ece885e20694
HUDSON_HOME=/var/jenkins
JOB_DISPLAY_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/display/redirect
KUBERNETES_PORT_443_TCP=tcp://10.30.0.1:443
P2REPO_RESULTS_TARGET_DIR=/home/data/httpd/download.eclipse.org/rt/eclipselink/nightly-updates
RUN_ARTIFACTS_DISPLAY_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/39/display/redirect?page=artifacts
GIT_REPOSITORY_URL=https://github.com/rfelcman/eclipselink.git
JENKINS_DISCOVERY_SERVICE_HOST=10.30.185.78
JENKINS_DISCOVERY_PORT=tcp://10.30.185.78:50000
bind_address=0.0.0.0
BUILD_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/39/
TERM=xterm
STAGE_NAME=MySQL Check
JOB_URL=https://ci.eclipse.org/eclipselink/job/eclipselink-cb-2.7_test/
BUILD_DISPLAY_NAME=#39
NSS_SDB_USE_CACHE=no
TEST_DB_USERNAME=root
JENKINS_UI_PORT_80_TCP_PORT=80
SHLVL=3
JENKINS_DISCOVERY_PORT_50000_TCP_ADDR=10.30.185.78
GIT_BRANCH=origin/jenkins_mysql_diagnostic_2.7
TEST_DB_URL=jdbc:mysql://127.0.0.1:3306/ecltests?allowPublicKeyRetrieval=true
BUILD_TAG=jenkins-eclipselink-cb-2.7_test-39
KUBERNETES_SERVICE_PORT=443
NODE_LABELS=el-master-agent-pod el-master-agent-pod-kvs59-g1slg
JENKINS_UI_SERVICE_HOST=10.30.39.21
ANT_HOME=/opt/java/apache-ant-1.10.13
PATH=/opt/tools/java/adoptopenjdk/hotspot-jdk-11/latest/bin:/opt/tools/java/adoptopenjdk/hotspot-jdk-11/latest/bin:/opt/java/openjdk/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
GIT_PREVIOUS_SUCCESSFUL_COMMIT=940c87e6aa08ce888cfa2f1ae93ab740200c8113
KUBERNETES_SERVICE_HOST=10.30.0.1
JENKINS_UI_PORT_80_TCP_PROTO=tcp
JENKINS_SERVER_COOKIE=durable-5571396608983870910386e1e3aa3c29a5c049bda3a9b844779b1e564440611d
JENKINS_UI_PORT_80_TCP=tcp://10.30.39.21:80
+ ping -c 3 localhost
PING localhost(localhost (::1)) 56 data bytes
64 bytes from localhost (::1): icmp_seq=1 ttl=64 time=0.033 ms
64 bytes from localhost (::1): icmp_seq=2 ttl=64 time=0.032 ms
64 bytes from localhost (::1): icmp_seq=3 ttl=64 time=0.033 ms

--- localhost ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2056ms
rtt min/avg/max/mdev = 0.032/0.032/0.033/0.006 ms
+ ping -c 3 127.0.0.1
PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data.
64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.032 ms
64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.027 ms
64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.025 ms

--- 127.0.0.1 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2045ms
rtt min/avg/max/mdev = 0.025/0.028/0.032/0.003 ms
+ tracepath -b localhost
 1?: [LOCALHOST]                        0.006ms pmtu 65536
 1:  localhost (::1)                                       0.043ms reached
 1:  localhost (::1)                                       0.022ms reached
     Resume: pmtu 65536 hops 1 back 1 
+ tracepath -b 127.0.0.1
 1:  localhost (127.0.0.1)                                 0.044ms reached
     Resume: pmtu 65535 hops 1 back 1 
+ export bind_address=0.0.0.0
+ bind_address=0.0.0.0
+ /opt/bin/mysql-start.sh
[07.12.2023 15:00:53] -[ Starting MySQL Database ]------------------------------
[07.12.2023 15:00:53] --[ Waiting for MySQL Database to come up ]---------------
. done
+ ps aux
+ grep mysql
jenkins       53 64.0  0.1 2110996 389848 ?      Sl   15:00   0:00 mysqld
jenkins      107  0.0  0.0   9216  1152 ?        S    15:00   0:00 grep mysql
+ cat /var/log/mysqld.log
2023-01-23T19:52:03.049387Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.32) initializing of server in progress as process 224
2023-01-23T19:52:03.054708Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-23T19:52:03.428538Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-23T19:52:04.409705Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 9meg*FbcjUjq
2023-01-23T19:52:07.167098Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 276
2023-01-23T19:52:07.172376Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-01-23T19:52:07.242854Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-01-23T19:52:07.345741Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-01-23T19:52:07.345788Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-01-23T19:52:07.361894Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2023-01-23T19:52:07.361979Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-01-23T19:52:08.028816Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.32).
2023-01-23T19:52:08.896497Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32)  MySQL Community Server - GPL.
2023-12-07T15:00:53.413009Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 53
2023-12-07T15:00:53.421479Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-12-07T15:00:53.599817Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-12-07T15:00:53.860882Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-12-07T15:00:53.860938Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-12-07T15:00:53.885351Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-12-07T15:00:53.885501Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
+ mysql -u root -proot -h localhost -P 3306 -D ecltests -e status
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
mysql  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:		9
Current database:	ecltests
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.0.32 MySQL Community Server - GPL
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			1 sec

Threads: 2  Questions: 5  Slow queries: 0  Opens: 120  Flush tables: 3  Open tables: 39  Queries per second avg: 5.000
--------------

+ mysql -u root -proot -h 127.0.0.1 -P 3306 -D ecltests -e status
mysql: [Warning] Using a password on the command line interface can be insecure.
--------------
mysql  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:		10
Current database:	ecltests
Current user:		root@localhost
SSL:			Cipher in use is TLS_AES_256_GCM_SHA384
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.0.32 MySQL Community Server - GPL
Protocol version:	10
Connection:		127.0.0.1 via TCP/IP
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
TCP port:		3306
Uptime:			1 sec

Threads: 2  Questions: 10  Slow queries: 0  Opens: 120  Flush tables: 3  Open tables: 39  Queries per second avg: 10.000
--------------

+ mysql -u root -proot -h localhost -P 3306 -D ecltests -e 'SHOW TABLES;'
mysql: [Warning] Using a password on the command line interface can be insecure.
+ mysql -u root -proot -h localhost -P 3306 -D ecltests -e 'SELECT User FROM mysql.user;'
mysql: [Warning] Using a password on the command line interface can be insecure.
User
mysql.infoschema
mysql.session
mysql.sys
root
+ wget -nc https://repo1.maven.org/maven2/com/mysql/mysql-connector-j/8.2.0/mysql-connector-j-8.2.0.jar -O mysql-connector-j-8.2.0.jar
--2023-12-07 15:00:54--  https://repo1.maven.org/maven2/com/mysql/mysql-connector-j/8.2.0/mysql-connector-j-8.2.0.jar
Resolving repo1.maven.org (repo1.maven.org)... 151.101.136.209, 2a04:4e42:20::209
Connecting to repo1.maven.org (repo1.maven.org)|151.101.136.209|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2489850 (2.4M) [application/java-archive]
Saving to: 'mysql-connector-j-8.2.0.jar'

     0K .......... .......... .......... .......... ..........  2% 10.0M 0s
    50K .......... .......... .......... .......... ..........  4% 17.2M 0s
   100K .......... .......... .......... .......... ..........  6% 49.9M 0s
   150K .......... .......... .......... .......... ..........  8% 68.9M 0s
   200K .......... .......... .......... .......... .......... 10% 18.3M 0s
   250K .......... .......... .......... .......... .......... 12%  123M 0s
   300K .......... .......... .......... .......... .......... 14%  109M 0s
   350K .......... .......... .......... .......... .......... 16% 77.3M 0s
   400K .......... .......... .......... .......... .......... 18%  109M 0s
   450K .......... .......... .......... .......... .......... 20% 18.5M 0s
   500K .......... .......... .......... .......... .......... 22% 90.5M 0s
   550K .......... .......... .......... .......... .......... 24%  101M 0s
   600K .......... .......... .......... .......... .......... 26% 89.1M 0s
   650K .......... .......... .......... .......... .......... 28% 81.5M 0s
   700K .......... .......... .......... .......... .......... 30% 91.6M 0s
   750K .......... .......... .......... .......... .......... 32%  124M 0s
   800K .......... .......... .......... .......... .......... 34% 86.5M 0s
   850K .......... .......... .......... .......... .......... 37% 89.9M 0s
   900K .......... .......... .......... .......... .......... 39% 99.2M 0s
   950K .......... .......... .......... .......... .......... 41% 76.4M 0s
  1000K .......... .......... .......... .......... .......... 43%  121M 0s
  1050K .......... .......... .......... .......... .......... 45%  125M 0s
  1100K .......... .......... .......... .......... .......... 47% 94.3M 0s
  1150K .......... .......... .......... .......... .......... 49%  121M 0s
  1200K .......... .......... .......... .......... .......... 51% 86.7M 0s
  1250K .......... .......... .......... .......... .......... 53%  116M 0s
  1300K .......... .......... .......... .......... .......... 55%  100M 0s
  1350K .......... .......... .......... .......... .......... 57% 86.0M 0s
  1400K .......... .......... .......... .......... .......... 59%  116M 0s
  1450K .......... .......... .......... .......... .......... 61% 89.5M 0s
  1500K .......... .......... .......... .......... .......... 63%  104M 0s
  1550K .......... .......... .......... .......... .......... 65%  104M 0s
  1600K .......... .......... .......... .......... .......... 67%  122M 0s
  1650K .......... .......... .......... .......... .......... 69% 93.1M 0s
  1700K .......... .......... .......... .......... .......... 71% 96.1M 0s
  1750K .......... .......... .......... .......... .......... 74% 74.7M 0s
  1800K .......... .......... .......... .......... .......... 76%  137M 0s
  1850K .......... .......... .......... .......... .......... 78%  106M 0s
  1900K .......... .......... .......... .......... .......... 80%  104M 0s
  1950K .......... .......... .......... .......... .......... 82% 91.2M 0s
  2000K .......... .......... .......... .......... .......... 84%  126M 0s
  2050K .......... .......... .......... .......... .......... 86%  101M 0s
  2100K .......... .......... .......... .......... .......... 88% 95.8M 0s
  2150K .......... .......... .......... .......... .......... 90%  101M 0s
  2200K .......... .......... .......... .......... .......... 92%  112M 0s
  2250K .......... .......... .......... .......... .......... 94% 74.0M 0s
  2300K .......... .......... .......... .......... .......... 96%  130M 0s
  2350K .......... .......... .......... .......... .......... 98%  126M 0s
  2400K .......... .......... .......... .                    100% 70.6M=0.04s

2023-12-07 15:00:54 (66.6 MB/s) - 'mysql-connector-j-8.2.0.jar' saved [2489850/2489850]

+ pwd
/home/jenkins/agent/workspace/eclipselink-cb-2.7_test
+ df -h
Filesystem                        Size  Used Avail Use% Mounted on
overlay                            32G  193M   32G   1% /
tmpfs                              64M     0   64M   0% /dev
tmpfs                             126G     0  126G   0% /sys/fs/cgroup
shm                                64M     0   64M   0% /dev/shm
tmpfs                              51G   65M   51G   1% /etc/hostname
bambam:/home/data/cbi/buildtools   22T  5.1T   17T  24% /opt/tools
/dev/sda4                         894G  384G  511G  43% /etc/hosts
tmpfs                              16G  4.0K   16G   1% /home/jenkins/.m2/settings-security.xml
tmpfs                              16G  4.0K   16G   1% /home/jenkins/.m2/settings.xml
tmpfs                              16G   32K   16G   1% /run/secrets/kubernetes.io/serviceaccount
tmpfs                             126G     0  126G   0% /proc/acpi
tmpfs                             126G     0  126G   0% /proc/scsi
tmpfs                             126G     0  126G   0% /sys/firmware
+ javac TestJDBC.java
+ java -cp .:mysql-connector-j-8.2.0.jar TestJDBC
jdbc:mysql://127.0.0.1:3306/ecltests?allowPublicKeyRetrieval=true	root	root
java.sql.SQLSyntaxErrorException: Unknown table 'ecltests.TEST_JDBC_TAB'
1 aaa