环境准备
Oracle和MySQL环境准备
1-- 创建专用网络
2docker network create --subnet=172.72.7.0/24 ora-network
3
4
5
6-- oracle 压测工具
7docker pull lhrbest/lhrdbbench:1.0
8
9docker rm -f lhrdbbench
10docker run -d --name lhrdbbench -h lhrdbbench \
11 --net=ora-network --ip 172.72.7.26 \
12 -v /sys/fs/cgroup:/sys/fs/cgroup \
13 --privileged=true lhrbest/lhrdbbench:1.0 \
14 /usr/sbin/init
15
16
17
18-- Oracle 12c
19docker rm -f lhrora1221
20docker run -itd --name lhrora1221 -h lhrora1221 \
21 --net=ora-network --ip 172.72.7.34 \
22 -p 1526:1521 -p 3396:3389 \
23 --privileged=true \
24 lhrbest/oracle_12cr2_ee_lhr_12.2.0.1:2.0 init
25
26
27
28-- mysql
29docker rm -f mysql8027
30docker run -d --name mysql8027 -h mysql8027 -p 3418:3306 \
31 --net=ora-network --ip 172.72.7.35 \
32 -v /etc/mysql/mysql8027/conf:/etc/mysql/conf.d \
33 -e MYSQL_ROOT_PASSWORD=lhr -e TZ=Asia/Shanghai \
34 mysql:8.0.27
35
36
37cat > /etc/mysql/mysql8027/conf/my.cnf << "EOF"
38[mysqld]
39default-time-zone = '+8:00'
40log_timestamps = SYSTEM
41skip-name-resolve
42log-bin
43server_id=80273418
44character_set_server=utf8mb4
45default_authentication_plugin=mysql_native_password
46EOF
47
48mysql -uroot -plhr -h 172.72.7.35
49create database lhrdb;
50
51
52
53
54-- 业务用户
55CREATE USER lhr identified by lhr;
56alter user lhr identified by lhr;
57GRANT DBA to lhr ;
58grant SELECT ANY DICTIONARY to lhr;
59GRANT EXECUTE ON SYS.DBMS_LOCK TO lhr;
60
61
62
63-- 启动监听
64vi /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
65lsnrctl start
66lsnrctl status复制
kettle环境准备
1docker rm -f lhrkettle
2docker run -itd --name lhrkettle -h lhrkettle \
3 --net=ora-network --ip 172.72.7.88 \
4 -p 7390:3389 \
5 -v /sys/fs/cgroup:/sys/fs/cgroup \
6 --privileged=true lhrbest/kettle:1.0 \
7 /usr/sbin/init复制
Oracle端数据初始化
1-- 源端数据初始化
2/usr/local/swingbench/bin/oewizard -s -create -c /usr/local/swingbench/wizardconfigs/oewizard.xml -create \
3-version 2.0 -cs //172.72.7.34/lhrsdb -dba "sys as sysdba" -dbap lhr -dt thin \
4-ts users -u lhr -p lhr -allindexes -scale 0.0001 -tc 16 -v -cl
5
6
7col TABLE_NAME format a30
8SELECT a.table_name,a.num_rows FROM dba_tables a where a.OWNER='LHR' ;
9select object_type,count(*) from dba_objects where owner='LHR' group by object_type;
10select object_type,status,count(*) from dba_objects where owner='LHR' group by object_type,status;
11select sum(bytes)/1024/1024 from dba_segments where owner='LHR';
12
13-- 检查键是否正确：https://www.xmmup.com/ogg-01296-biaoyouzhujianhuoweiyijiandanshirengranshiyongquanbulielaijiexixing.html
14-- 否则OGG启动后，会报错：OGG-01296、OGG-06439、OGG-01169 Encountered an update where all key columns for target table LHR.ORDER_ITEMS are not present.
15select owner, constraint_name, constraint_type, status, validated
16from dba_constraints
17where owner='LHR'
18and VALIDATED='NOT VALIDATED';
19
20select 'alter table lhr.'||TABLE_NAME||' enable validate constraint '||CONSTRAINT_NAME||';'
21from dba_constraints
22where owner='LHR'
23and VALIDATED='NOT VALIDATED';
24
25
26-- 删除外键
27SELECT 'ALTER TABLE LHR.'|| D.TABLE_NAME ||' DROP constraint '|| D.CONSTRAINT_NAME||';'
28FROM DBA_constraints d where owner='LHR' and d.CONSTRAINT_TYPE='R';
29
30
31
32
33sqlplus lhr/lhr@172.72.7.34:1521/lhrsdb
34
35@/oggoracle/demo_ora_create.sql
36@/oggoracle/demo_ora_insert.sql
37
38
39SQL> select * from tcustmer;
40
41CUST NAME CITY ST
42---- ------------------------------ -------------------- --
43WILL BG SOFTWARE CO. SEATTLE WA
44JANE ROCKY FLYER INC. DENVER CO
45
46
47-- 创建2个clob和blob类型的表
48sqlplus lhr/lhr@172.72.7.34:1521/lhrsdb @/oggoracle/demo_ora_lob_create.sql
49exec testing_lobs;
50select * from lhr.TSRSLOB;
51
52drop table IMAGE_LOB;
53CREATE TABLE IMAGE_LOB (
54 T_ID VARCHAR2 (5) NOT NULL,
55 T_IMAGE BLOB,
56 T_CLOB CLOB
57 );
58
59-- 插入blob文件
60CREATE OR REPLACE DIRECTORY D1 AS '/home/oracle/';
61grant all on DIRECTORY D1 TO PUBLIC;
62CREATE OR REPLACE NONEDITIONABLE PROCEDURE IMG_INSERT(TID VARCHAR2,
63 FILENAME VARCHAR2,
64 name VARCHAR2) AS
65 F_LOB BFILE;
66 B_LOB BLOB;
67BEGIN
68 INSERT INTO IMAGE_LOB
69 (T_ID, T_IMAGE,T_CLOB)
70 VALUES
71 (TID, EMPTY_BLOB(),name) RETURN T_IMAGE INTO B_LOB;
72 F_LOB := BFILENAME('D1', FILENAME);
73 DBMS_LOB.FILEOPEN(F_LOB, DBMS_LOB.FILE_READONLY);
74 DBMS_LOB.LOADFROMFILE(B_LOB, F_LOB, DBMS_LOB.GETLENGTH(F_LOB));
75 DBMS_LOB.FILECLOSE(F_LOB);
76 COMMIT;
77END;
78/
79
80
81BEGIN
82 IMG_INSERT('1','1.jpg','xmmup.com');
83 IMG_INSERT('2','2.jpg','www.xmmup.com');
84 END;
85/
86
87
88select * from IMAGE_LOB;
89
90
91
92
93
94----- oracle所有表
95SQL> select * from tab;
96
97TNAME TABTYPE CLUSTERID
98------------------------------ ------- ----------
99ADDRESSES TABLE
100CARD_DETAILS TABLE
101CUSTOMERS TABLE
102IMAGE_LOB TABLE
103INVENTORIES TABLE
104LOGON TABLE
105ORDERENTRY_METADATA TABLE
106ORDERS TABLE
107ORDER_ITEMS TABLE
108PRODUCTS VIEW
109PRODUCT_DESCRIPTIONS TABLE
110PRODUCT_INFORMATION TABLE
111PRODUCT_PRICES VIEW
112TCUSTMER TABLE
113TCUSTORD TABLE
114TSRSLOB TABLE
115TTRGVAR TABLE
116WAREHOUSES TABLE
117
11818 rows selected.
119
120
121
122SELECT COUNT(*) FROM LHR.ADDRESSES UNION ALL
123SELECT COUNT(*) FROM LHR.CARD_DETAILS UNION ALL
124SELECT COUNT(*) FROM LHR.CUSTOMERS UNION ALL
125SELECT COUNT(*) FROM LHR.IMAGE_LOB UNION ALL
126SELECT COUNT(*) FROM LHR.INVENTORIES UNION ALL
127SELECT COUNT(*) FROM LHR.LOGON UNION ALL
128SELECT COUNT(*) FROM LHR.ORDERENTRY_METADATA UNION ALL
129SELECT COUNT(*) FROM LHR.ORDERS UNION ALL
130SELECT COUNT(*) FROM LHR.ORDER_ITEMS UNION ALL
131SELECT COUNT(*) FROM LHR.PRODUCT_DESCRIPTIONS UNION ALL
132SELECT COUNT(*) FROM LHR.PRODUCT_INFORMATION UNION ALL
133SELECT COUNT(*) FROM LHR.TCUSTMER UNION ALL
134SELECT COUNT(*) FROM LHR.TCUSTORD UNION ALL
135SELECT COUNT(*) FROM LHR.TSRSLOB UNION ALL
136SELECT COUNT(*) FROM LHR.TTRGVAR UNION ALL
137SELECT COUNT(*) FROM LHR.WAREHOUSES
138;
139
140 COUNT(*)
141----------
142 281
143 281
144 231
145 4
146 900724
147 575
148 4
149 424
150 1642
151 1000
152 1000
153 2
154 2
155 1
156 0
157 1000
158
15916 rows selected.复制
最终，在Oracle端共包括16张表，2个视图，其中2个表TSRSLOB和IMAGE_LOB包括了blob和clob字段。
kettle配置全量同步
连接到kettle远程桌面：mstsc
用户名和密码：root/lhr
启动kettle图形界面：
1sh /usr/local/data-integration/spoon.sh &复制
新建Oracle和MySQL的连接，如下：
完成后，会自动生成如下的执行树：
点击run，开始执行即可：
经过15分钟后，迁移完成：
数据校验
1SELECT COUNT(*) FROM lhrdb.ADDRESSES UNION ALL
2SELECT COUNT(*) FROM lhrdb.CARD_DETAILS UNION ALL
3SELECT COUNT(*) FROM lhrdb.CUSTOMERS UNION ALL
4SELECT COUNT(*) FROM lhrdb.IMAGE_LOB UNION ALL
5SELECT COUNT(*) FROM lhrdb.INVENTORIES UNION ALL
6SELECT COUNT(*) FROM lhrdb.LOGON UNION ALL
7SELECT COUNT(*) FROM lhrdb.ORDERENTRY_METADATA UNION ALL
8SELECT COUNT(*) FROM lhrdb.ORDERS UNION ALL
9SELECT COUNT(*) FROM lhrdb.ORDER_ITEMS UNION ALL
10SELECT COUNT(*) FROM lhrdb.PRODUCT_DESCRIPTIONS UNION ALL
11SELECT COUNT(*) FROM lhrdb.PRODUCT_INFORMATION UNION ALL
12SELECT COUNT(*) FROM lhrdb.TCUSTMER UNION ALL
13SELECT COUNT(*) FROM lhrdb.TCUSTORD UNION ALL
14SELECT COUNT(*) FROM lhrdb.TSRSLOB UNION ALL
15SELECT COUNT(*) FROM lhrdb.TTRGVAR UNION ALL
16SELECT COUNT(*) FROM lhrdb.WAREHOUSES
17;复制
全量数据迁移完成。
对于blob和clob查看：
可以看到，数据也能正常同步！！！
kettle优化
由于INVENTORIES有90万条的数据，未优化之前需要13分钟，所以，我们可以配置多线程写入，这里配置8个线程写入，发现大约1分钟就可以同步完成：
命令行运行
生成文件后，可以直接在命令行运行：
1mysql> drop database lhrdb;
2Query OK, 16 rows affected (2.32 sec)
3
4mysql> create database lhrdb;
5Query OK, 1 row affected (0.10 sec)
6
7
8/usr/local/data-integration/kitchen.sh -file=/root/Desktop/kettle_o2m/job_o2m.kjb
9/usr/local/data-integration/pan.sh -file=/root/Desktop/kettle_o2m/inventories.ktr复制
日志：
1[root@lhrkettle lib]# /usr/local/data-integration/kitchen.sh -file=/root/Desktop/kettle_o2m/job_o2m.kjb
216:29:29,545 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
316:29:29,670 INFO [KarafInstance]
4*******************************************************************************
5*** Karaf Instance Number: 1 at /usr/local/data-integration/./system/karaf/ ***
6*** caches/kitchen/data-1 ***
7*** Karaf Port:8802 ***
8*** OSGI Service Port:9051 ***
9*******************************************************************************
10七月 05, 2022 4:29:31 下午 org.apache.karaf.main.Main$KarafLockCallback lockAcquired
11信息: Lock acquired. Setting startlevel to 100
122022/07/05 16:29:31 - Kitchen - Start of run.
13七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
14信息: Registered provider org.eclipse.jetty.http.Http1FieldPreEncoder of service org.eclipse.jetty.http.HttpFieldPreEncoder in bundle org.eclipse.jetty.http
15七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
16信息: Registered provider org.eclipse.jetty.security.jaspi.JaspiAuthenticatorFactory of service org.eclipse.jetty.security.Authenticator$Factory in bundle org.eclipse.jetty.security.jaspi
17七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
18信息: Registered provider org.eclipse.jetty.websocket.common.extensions.identity.IdentityExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
19七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
20信息: Registered provider org.eclipse.jetty.websocket.common.extensions.fragment.FragmentExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
21七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
22信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
23七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
24信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.DeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
25七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
26信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.XWebkitDeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
27七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
28信息: Registered provider org.eclipse.jetty.websocket.jsr356.JettyClientContainerProvider of service javax.websocket.ContainerProvider in bundle org.eclipse.jetty.websocket.javax.websocket
29七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
30信息: Registered provider org.eclipse.jetty.websocket.jsr356.server.deploy.WebSocketServerContainerInitializer of service javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.javax.websocket.server
31七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
32信息: Registered provider org.eclipse.jetty.websocket.jsr356.server.ContainerDefaultConfigurator of service javax.websocket.server.ServerEndpointConfig$Configurator in bundle org.eclipse.jetty.websocket.javax.websocket.server
33七月 05, 2022 4:29:34 下午 org.apache.aries.spifly.BaseActivator log
34信息: Registered provider org.eclipse.jetty.websocket.server.NativeWebSocketServletContainerInitializer of service javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.server
352022-07-05 16:29:34.796:INFO::FelixStartLevel: Logging initialized @8790ms to org.eclipse.jetty.util.log.StdErrLog
36七月 05, 2022 4:29:34 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
37信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (128) [org.apache.cxf.management.InstrumentationManager]
38七月 05, 2022 4:29:34 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
39信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (133) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
40七月 05, 2022 4:29:34 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
41信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (135) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
42七月 05, 2022 4:29:35 下午 org.apache.cxf.transport.http.osgi.ServletExporter updated
43信息: Registering new instance of "/cxf" servlet
44七月 05, 2022 4:29:35 下午 org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
45信息: New Caching Service registered
4616:29:35,815 INFO [DriverManager] Installing driver kars.
4716:29:35,819 INFO [DriverManager] 0 drivers will be installed.
4816:29:35,823 INFO [DriverManager] Finished installing drivers kars.
492022-07-05 16:29:35.999:INFO:oejws.WebSocketServerFactory:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
502022-07-05 16:29:36.161:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): DefaultSessionIdManager workerName=node0
512022-07-05 16:29:36.161:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No SessionScavenger set, using defaults
522022-07-05 16:29:36.162:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): node0 Scavenging every 660000ms
532022-07-05 16:29:36.224:INFO:oejsh.ContextHandler:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.apache.cxf.cxf-rt-transports-http [135], contextID=default]}
542022-07-05 16:29:36.237:INFO:oejs.Server:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): jetty-9.4.18.v20190429; built: 2021-06-30T11:07:22.254Z; git: 526006ecfa3af7f1a27ef3a288e2bef7ea9dd7e8; jvm 1.8.0_332-b09
552022-07-05 16:29:36.317:INFO:oejs.AbstractConnector:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started default@13c27b3{HTTP/1.1, (http/1.1)}{0.0.0.0:9051}
562022-07-05 16:29:36.317:INFO:oejs.Server:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started @10312ms
57七月 05, 2022 4:29:36 下午 org.apache.cxf.endpoint.ServerImpl initDestination
58信息: Setting the server's publish address to be /i18n
592022-07-05 16:29:36.839:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
602022-07-05 16:29:36.847:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-i18n-webservice-bundle [218], contextID=default]}
612022-07-05 16:29:38.663:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
622022-07-05 16:29:38.674:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.pentaho.requirejs-manager-impl [248], contextID=default]}
63七月 05, 2022 4:29:39 下午 org.apache.cxf.endpoint.ServerImpl initDestination
64信息: Setting the server's publish address to be /marketplace
652022-07-05 16:29:39.545:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
662022-07-05 16:29:39.552:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular [250], contextID=default]}
672022-07-05 16:29:39.910:INFO:oejws.WebSocketServerFactory:FelixDispatchQueue: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
682022-07-05 16:29:39.924:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
692022-07-05 16:29:39.926:INFO:oejsh.ContextHandler:FelixDispatchQueue: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-marketplace-di [249], contextID=default]}
702022-07-05 16:29:39.928:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-animate [251], contextID=default]}
712022-07-05 16:29:39.969:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
722022-07-05 16:29:39.976:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-route [252], contextID=default]}
732022-07-05 16:29:39.991:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
742022-07-05 16:29:40.000:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-sanitize [253], contextID=default]}
752022-07-05 16:29:40.017:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
762022-07-05 16:29:40.022:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-translate [254], contextID=default]}
772022-07-05 16:29:40.039:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
782022-07-05 16:29:40.043:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-ui-bootstrap-bower [255], contextID=default]}
792022-07-05 16:29:40.062:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
802022-07-05 16:29:40.067:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-jquery [256], contextID=default]}
812022-07-05 16:29:40.086:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
822022-07-05 16:29:40.091:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-underscore [257], contextID=default]}
832022/07/05 16:29:40 - job_o2m - 开始执行任务
842022/07/05 16:29:40 - job_o2m - 开始项[创建表 [PRODUCT_INFORMATION]]
85Tue Jul 05 16:29:41 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
862022/07/05 16:29:41 - job_o2m - 开始项[复制数据到 [PRODUCT_INFORMATION]]
872022/07/05 16:29:42 - 复制数据到 [PRODUCT_INFORMATION] - Running transformation using the Kettle execution engine
882022/07/05 16:29:42 - 复制到_ora12cproduct_information_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12cproduct_information_到_mysql8]
89Tue Jul 05 16:29:42 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
902022/07/05 16:29:42 - 写到 [PRODUCT_INFORMATION].0 - Connected to database [mysql8] (commit=100)
912022/07/05 16:29:43 - 从 [PRODUCT_INFORMATION].0 - Finished reading query, closing connection
922022/07/05 16:29:43 - 从 [PRODUCT_INFORMATION].0 - 完成处理 (I=1000, O=0, R=0, W=1000, U=0, E=0)
932022/07/05 16:29:44 - 写到 [PRODUCT_INFORMATION].0 - 完成处理 (I=0, O=1000, R=1000, W=1000, U=0, E=0)
942022/07/05 16:29:44 - Carte - Installing timer to purge stale objects after 1440 minutes.
952022/07/05 16:29:44 - job_o2m - 开始项[创建表 [PRODUCT_DESCRIPTIONS]]
96Tue Jul 05 16:29:44 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
972022/07/05 16:29:45 - job_o2m - 开始项[复制数据到 [PRODUCT_DESCRIPTIONS]]
982022/07/05 16:29:45 - 复制数据到 [PRODUCT_DESCRIPTIONS] - Running transformation using the Kettle execution engine
992022/07/05 16:29:45 - 复制到_ora12cproduct_descriptions_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12cproduct_descriptions_到_mysql8]
100Tue Jul 05 16:29:45 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1012022/07/05 16:29:45 - 写到 [PRODUCT_DESCRIPTIONS].0 - Connected to database [mysql8] (commit=100)
1022022/07/05 16:29:45 - 从 [PRODUCT_DESCRIPTIONS].0 - Finished reading query, closing connection
1032022/07/05 16:29:45 - 从 [PRODUCT_DESCRIPTIONS].0 - 完成处理 (I=1000, O=0, R=0, W=1000, U=0, E=0)
1042022/07/05 16:29:46 - 写到 [PRODUCT_DESCRIPTIONS].0 - 完成处理 (I=0, O=1000, R=1000, W=1000, U=0, E=0)
1052022/07/05 16:29:46 - job_o2m - 开始项[创建表 [CARD_DETAILS]]
106Tue Jul 05 16:29:46 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1072022/07/05 16:29:46 - job_o2m - 开始项[复制数据到 [CARD_DETAILS]]
1082022/07/05 16:29:46 - 复制数据到 [CARD_DETAILS] - Running transformation using the Kettle execution engine
1092022/07/05 16:29:46 - 复制到_ora12ccard_details_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12ccard_details_到_mysql8]
110Tue Jul 05 16:29:46 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1112022/07/05 16:29:47 - 写到 [CARD_DETAILS].0 - Connected to database [mysql8] (commit=100)
1122022/07/05 16:29:47 - 从 [CARD_DETAILS].0 - Finished reading query, closing connection
1132022/07/05 16:29:47 - 从 [CARD_DETAILS].0 - 完成处理 (I=281, O=0, R=0, W=281, U=0, E=0)
1142022/07/05 16:29:47 - 写到 [CARD_DETAILS].0 - 完成处理 (I=0, O=281, R=281, W=281, U=0, E=0)
1152022/07/05 16:29:47 - job_o2m - 开始项[创建表 [TSRSLOB]]
116Tue Jul 05 16:29:47 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1172022/07/05 16:29:47 - job_o2m - 开始项[复制数据到 [TSRSLOB]]
1182022/07/05 16:29:47 - 复制数据到 [TSRSLOB] - Running transformation using the Kettle execution engine
1192022/07/05 16:29:47 - 复制到_ora12ctsrslob_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12ctsrslob_到_mysql8]
120Tue Jul 05 16:29:47 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1212022/07/05 16:29:47 - 写到 [TSRSLOB].0 - Connected to database [mysql8] (commit=100)
1222022/07/05 16:29:48 - 从 [TSRSLOB].0 - Finished reading query, closing connection
1232022/07/05 16:29:48 - 从 [TSRSLOB].0 - 完成处理 (I=1, O=0, R=0, W=1, U=0, E=0)
1242022/07/05 16:29:48 - 写到 [TSRSLOB].0 - 完成处理 (I=0, O=1, R=1, W=1, U=0, E=0)
1252022/07/05 16:29:48 - job_o2m - 开始项[创建表 [IMAGE_LOB]]
126Tue Jul 05 16:29:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1272022/07/05 16:29:48 - job_o2m - 开始项[复制数据到 [IMAGE_LOB]]
1282022/07/05 16:29:48 - 复制数据到 [IMAGE_LOB] - Running transformation using the Kettle execution engine
1292022/07/05 16:29:48 - 复制到_ora12cimage_lob_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12cimage_lob_到_mysql8]
130Tue Jul 05 16:29:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1312022/07/05 16:29:48 - 写到 [IMAGE_LOB].0 - Connected to database [mysql8] (commit=100)
1322022/07/05 16:29:48 - 从 [IMAGE_LOB].0 - Finished reading query, closing connection
1332022/07/05 16:29:48 - 从 [IMAGE_LOB].0 - 完成处理 (I=4, O=0, R=0, W=4, U=0, E=0)
1342022/07/05 16:29:48 - 写到 [IMAGE_LOB].0 - 完成处理 (I=0, O=4, R=4, W=4, U=0, E=0)
1352022/07/05 16:29:48 - job_o2m - 开始项[创建表 [ORDERENTRY_METADATA]]
136Tue Jul 05 16:29:48 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1372022/07/05 16:29:49 - job_o2m - 开始项[复制数据到 [ORDERENTRY_METADATA]]
1382022/07/05 16:29:49 - 复制数据到 [ORDERENTRY_METADATA] - Running transformation using the Kettle execution engine
1392022/07/05 16:29:49 - 复制到_ora12corderentry_metadata_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12corderentry_metadata_到_mysql8]
140Tue Jul 05 16:29:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1412022/07/05 16:29:49 - 写到 [ORDERENTRY_METADATA].0 - Connected to database [mysql8] (commit=100)
1422022/07/05 16:29:49 - 从 [ORDERENTRY_METADATA].0 - Finished reading query, closing connection
1432022/07/05 16:29:49 - 从 [ORDERENTRY_METADATA].0 - 完成处理 (I=4, O=0, R=0, W=4, U=0, E=0)
1442022/07/05 16:29:49 - 写到 [ORDERENTRY_METADATA].0 - 完成处理 (I=0, O=4, R=4, W=4, U=0, E=0)
1452022/07/05 16:29:49 - job_o2m - 开始项[创建表 [LOGON]]
146Tue Jul 05 16:29:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1472022/07/05 16:29:49 - job_o2m - 开始项[复制数据到 [LOGON]]
1482022/07/05 16:29:49 - 复制数据到 [LOGON] - Running transformation using the Kettle execution engine
1492022/07/05 16:29:49 - 复制到_ora12clogon_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12clogon_到_mysql8]
150Tue Jul 05 16:29:49 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1512022/07/05 16:29:49 - 写到 [LOGON].0 - Connected to database [mysql8] (commit=100)
1522022/07/05 16:29:50 - 从 [LOGON].0 - Finished reading query, closing connection
1532022/07/05 16:29:50 - 从 [LOGON].0 - 完成处理 (I=575, O=0, R=0, W=575, U=0, E=0)
1542022/07/05 16:29:50 - 写到 [LOGON].0 - 完成处理 (I=0, O=575, R=575, W=575, U=0, E=0)
1552022/07/05 16:29:50 - job_o2m - 开始项[创建表 [ORDER_ITEMS]]
156Tue Jul 05 16:29:50 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1572022/07/05 16:29:51 - job_o2m - 开始项[复制数据到 [ORDER_ITEMS]]
1582022/07/05 16:29:51 - 复制数据到 [ORDER_ITEMS] - Running transformation using the Kettle execution engine
1592022/07/05 16:29:51 - 复制到_ora12corder_items_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12corder_items_到_mysql8]
160Tue Jul 05 16:29:51 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1612022/07/05 16:29:51 - 写到 [ORDER_ITEMS].0 - Connected to database [mysql8] (commit=100)
1622022/07/05 16:29:51 - 从 [ORDER_ITEMS].0 - Finished reading query, closing connection
1632022/07/05 16:29:51 - 从 [ORDER_ITEMS].0 - 完成处理 (I=1642, O=0, R=0, W=1642, U=0, E=0)
1642022/07/05 16:29:53 - 写到 [ORDER_ITEMS].0 - 完成处理 (I=0, O=1642, R=1642, W=1642, U=0, E=0)
1652022/07/05 16:29:53 - job_o2m - 开始项[创建表 [WAREHOUSES]]
166Tue Jul 05 16:29:53 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1672022/07/05 16:29:53 - job_o2m - 开始项[复制数据到 [WAREHOUSES]]
1682022/07/05 16:29:53 - 复制数据到 [WAREHOUSES] - Running transformation using the Kettle execution engine
1692022/07/05 16:29:53 - 复制到_ora12cwarehouses_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12cwarehouses_到_mysql8]
170Tue Jul 05 16:29:53 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1712022/07/05 16:29:53 - 写到 [WAREHOUSES].0 - Connected to database [mysql8] (commit=100)
1722022/07/05 16:29:53 - 从 [WAREHOUSES].0 - Finished reading query, closing connection
1732022/07/05 16:29:53 - 从 [WAREHOUSES].0 - 完成处理 (I=1000, O=0, R=0, W=1000, U=0, E=0)
1742022/07/05 16:29:55 - 写到 [WAREHOUSES].0 - 完成处理 (I=0, O=1000, R=1000, W=1000, U=0, E=0)
1752022/07/05 16:29:55 - job_o2m - 开始项[创建表 [CUSTOMERS]]
176Tue Jul 05 16:29:55 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1772022/07/05 16:29:55 - job_o2m - 开始项[复制数据到 [CUSTOMERS]]
1782022/07/05 16:29:55 - 复制数据到 [CUSTOMERS] - Running transformation using the Kettle execution engine
1792022/07/05 16:29:55 - 复制到_ora12ccustomers_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12ccustomers_到_mysql8]
180Tue Jul 05 16:29:55 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1812022/07/05 16:29:55 - 写到 [CUSTOMERS].0 - Connected to database [mysql8] (commit=100)
1822022/07/05 16:29:55 - 从 [CUSTOMERS].0 - Finished reading query, closing connection
1832022/07/05 16:29:55 - 从 [CUSTOMERS].0 - 完成处理 (I=231, O=0, R=0, W=231, U=0, E=0)
1842022/07/05 16:29:56 - 写到 [CUSTOMERS].0 - 完成处理 (I=0, O=231, R=231, W=231, U=0, E=0)
1852022/07/05 16:29:56 - job_o2m - 开始项[创建表 [TCUSTORD]]
186Tue Jul 05 16:29:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1872022/07/05 16:29:56 - job_o2m - 开始项[复制数据到 [TCUSTORD]]
1882022/07/05 16:29:56 - 复制数据到 [TCUSTORD] - Running transformation using the Kettle execution engine
1892022/07/05 16:29:56 - 复制到_ora12ctcustord_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12ctcustord_到_mysql8]
190Tue Jul 05 16:29:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1912022/07/05 16:29:56 - 写到 [TCUSTORD].0 - Connected to database [mysql8] (commit=100)
1922022/07/05 16:29:56 - 从 [TCUSTORD].0 - Finished reading query, closing connection
1932022/07/05 16:29:56 - 从 [TCUSTORD].0 - 完成处理 (I=2, O=0, R=0, W=2, U=0, E=0)
1942022/07/05 16:29:56 - 写到 [TCUSTORD].0 - 完成处理 (I=0, O=2, R=2, W=2, U=0, E=0)
1952022/07/05 16:29:56 - job_o2m - 开始项[创建表 [TTRGVAR]]
196Tue Jul 05 16:29:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
1972022/07/05 16:29:57 - job_o2m - 开始项[复制数据到 [TTRGVAR]]
1982022/07/05 16:29:57 - 复制数据到 [TTRGVAR] - Running transformation using the Kettle execution engine
1992022/07/05 16:29:57 - 复制到_ora12cttrgvar_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12cttrgvar_到_mysql8]
200Tue Jul 05 16:29:57 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2012022/07/05 16:29:57 - 写到 [TTRGVAR].0 - Connected to database [mysql8] (commit=100)
2022022/07/05 16:29:57 - 从 [TTRGVAR].0 - Finished reading query, closing connection
2032022/07/05 16:29:57 - job_o2m - 开始项[创建表 [ORDERS]]
204Tue Jul 05 16:29:57 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2052022/07/05 16:29:57 - job_o2m - 开始项[复制数据到 [ORDERS]]
2062022/07/05 16:29:57 - 复制数据到 [ORDERS] - Running transformation using the Kettle execution engine
2072022/07/05 16:29:57 - 复制到_ora12corders_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12corders_到_mysql8]
208Tue Jul 05 16:29:57 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2092022/07/05 16:29:57 - 写到 [ORDERS].0 - Connected to database [mysql8] (commit=100)
2102022/07/05 16:29:58 - 从 [ORDERS].0 - Finished reading query, closing connection
2112022/07/05 16:29:58 - 从 [ORDERS].0 - 完成处理 (I=424, O=0, R=0, W=424, U=0, E=0)
2122022/07/05 16:29:58 - 写到 [ORDERS].0 - 完成处理 (I=0, O=424, R=424, W=424, U=0, E=0)
2132022/07/05 16:29:58 - job_o2m - 开始项[创建表 [INVENTORIES]]
214Tue Jul 05 16:29:58 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2152022/07/05 16:29:59 - job_o2m - 开始项[创建表 [ADDRESSES]]
216Tue Jul 05 16:29:59 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2172022/07/05 16:29:59 - job_o2m - 开始项[复制数据到 [ADDRESSES]]
2182022/07/05 16:29:59 - 复制数据到 [ADDRESSES] - Running transformation using the Kettle execution engine
2192022/07/05 16:29:59 - 复制到_ora12caddresses_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12caddresses_到_mysql8]
220Tue Jul 05 16:29:59 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2212022/07/05 16:29:59 - 写到 [ADDRESSES].0 - Connected to database [mysql8] (commit=100)
2222022/07/05 16:29:59 - 从 [ADDRESSES].0 - Finished reading query, closing connection
2232022/07/05 16:29:59 - 从 [ADDRESSES].0 - 完成处理 (I=281, O=0, R=0, W=281, U=0, E=0)
2242022/07/05 16:30:00 - 写到 [ADDRESSES].0 - 完成处理 (I=0, O=281, R=281, W=281, U=0, E=0)
2252022/07/05 16:30:00 - job_o2m - 开始项[创建表 [TCUSTMER]]
226Tue Jul 05 16:30:00 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2272022/07/05 16:30:00 - job_o2m - 开始项[复制数据到 [TCUSTMER]]
2282022/07/05 16:30:00 - 复制数据到 [TCUSTMER] - Running transformation using the Kettle execution engine
2292022/07/05 16:30:00 - 复制到_ora12ctcustmer_到_mysql8 - 为了转换解除补丁开始 [复制到_ora12ctcustmer_到_mysql8]
230Tue Jul 05 16:30:00 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
2312022/07/05 16:30:00 - 写到 [TCUSTMER].0 - Connected to database [mysql8] (commit=100)
2322022/07/05 16:30:00 - 从 [TCUSTMER].0 - Finished reading query, closing connection
2332022/07/05 16:30:00 - 从 [TCUSTMER].0 - 完成处理 (I=2, O=0, R=0, W=2, U=0, E=0)
2342022/07/05 16:30:00 - 写到 [TCUSTMER].0 - 完成处理 (I=0, O=2, R=2, W=2, U=0, E=0)
2352022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [TCUSTMER]] (结果=[true])
2362022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [TCUSTMER]] (结果=[true])
2372022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [ADDRESSES]] (结果=[true])
2382022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [ADDRESSES]] (结果=[true])
2392022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [INVENTORIES]] (结果=[true])
2402022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [ORDERS]] (结果=[true])
2412022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [ORDERS]] (结果=[true])
2422022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [TTRGVAR]] (结果=[true])
2432022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [TTRGVAR]] (结果=[true])
2442022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [TCUSTORD]] (结果=[true])
2452022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [TCUSTORD]] (结果=[true])
2462022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [CUSTOMERS]] (结果=[true])
2472022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [CUSTOMERS]] (结果=[true])
2482022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [WAREHOUSES]] (结果=[true])
2492022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [WAREHOUSES]] (结果=[true])
2502022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [ORDER_ITEMS]] (结果=[true])
2512022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [ORDER_ITEMS]] (结果=[true])
2522022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [LOGON]] (结果=[true])
2532022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [LOGON]] (结果=[true])
2542022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [ORDERENTRY_METADATA]] (结果=[true])
2552022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [ORDERENTRY_METADATA]] (结果=[true])
2562022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [IMAGE_LOB]] (结果=[true])
2572022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [IMAGE_LOB]] (结果=[true])
2582022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [TSRSLOB]] (结果=[true])
2592022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [TSRSLOB]] (结果=[true])
2602022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [CARD_DETAILS]] (结果=[true])
2612022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [CARD_DETAILS]] (结果=[true])
2622022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [PRODUCT_DESCRIPTIONS]] (结果=[true])
2632022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [PRODUCT_DESCRIPTIONS]] (结果=[true])
2642022/07/05 16:30:00 - job_o2m - 完成作业项[复制数据到 [PRODUCT_INFORMATION]] (结果=[true])
2652022/07/05 16:30:00 - job_o2m - 完成作业项[创建表 [PRODUCT_INFORMATION]] (结果=[true])
2662022/07/05 16:30:00 - job_o2m - 任务执行完毕
2672022/07/05 16:30:00 - Kitchen - Finished!
2682022/07/05 16:30:00 - Kitchen - Start=2022/07/05 16:29:40.710, Stop=2022/07/05 16:30:00.642
2692022/07/05 16:30:00 - Kitchen - Processing ended after 19 seconds.
270[root@lhrkettle lib]#
271[root@lhrkettle lib]# /usr/local/data-integration/pan.sh -file=/root/Desktop/kettle_o2m/inventories.ktr
27216:30:44,730 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
27316:30:44,832 INFO [KarafInstance]
274*******************************************************************************
275*** Karaf Instance Number: 2 at /usr/local/data-integration/./system/karaf/ ***
276*** caches/pan/data-1 ***
277*** Karaf Port:8803 ***
278*** OSGI Service Port:9052 ***
279*******************************************************************************
280七月 05, 2022 4:30:46 下午 org.apache.karaf.main.Main$KarafLockCallback lockAcquired
281信息: Lock acquired. Setting startlevel to 100
282七月 05, 2022 4:30:47 下午 org.apache.felix.fileinstall.internal.Util$DefaultLogger log
283信息: Updating configuration {org.apache.karaf.shell} from /usr/local/data-integration/system/karaf/etc/org.apache.karaf.shell.cfg
284七月 05, 2022 4:30:47 下午 org.apache.felix.fileinstall.internal.Util$DefaultLogger log
285信息: Updating configuration {org.ops4j.pax.web} from /usr/local/data-integration/system/karaf/etc/org.ops4j.pax.web.cfg
286七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
287信息: Registered provider org.eclipse.jetty.http.Http1FieldPreEncoder of service org.eclipse.jetty.http.HttpFieldPreEncoder in bundle org.eclipse.jetty.http
288七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
289信息: Registered provider org.eclipse.jetty.security.jaspi.JaspiAuthenticatorFactory of service org.eclipse.jetty.security.Authenticator$Factory in bundle org.eclipse.jetty.security.jaspi
290七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
291信息: Registered provider org.eclipse.jetty.websocket.common.extensions.identity.IdentityExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
292七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
293信息: Registered provider org.eclipse.jetty.websocket.common.extensions.fragment.FragmentExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
294七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
295信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
296七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
297信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.DeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
298七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
299信息: Registered provider org.eclipse.jetty.websocket.common.extensions.compress.XWebkitDeflateFrameExtension of service org.eclipse.jetty.websocket.api.extensions.Extension in bundle org.eclipse.jetty.websocket.common
300七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
301信息: Registered provider org.eclipse.jetty.websocket.jsr356.JettyClientContainerProvider of service javax.websocket.ContainerProvider in bundle org.eclipse.jetty.websocket.javax.websocket
302七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
303信息: Registered provider org.eclipse.jetty.websocket.jsr356.server.deploy.WebSocketServerContainerInitializer of service javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.javax.websocket.server
304七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
305信息: Registered provider org.eclipse.jetty.websocket.jsr356.server.ContainerDefaultConfigurator of service javax.websocket.server.ServerEndpointConfig$Configurator in bundle org.eclipse.jetty.websocket.javax.websocket.server
306七月 05, 2022 4:30:49 下午 org.apache.aries.spifly.BaseActivator log
307信息: Registered provider org.eclipse.jetty.websocket.server.NativeWebSocketServletContainerInitializer of service javax.servlet.ServletContainerInitializer in bundle org.eclipse.jetty.websocket.server
3082022-07-05 16:30:49.464:INFO::FelixStartLevel: Logging initialized @7977ms to org.eclipse.jetty.util.log.StdErrLog
309七月 05, 2022 4:30:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
310信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (128) [org.apache.cxf.management.InstrumentationManager]
311七月 05, 2022 4:30:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
312信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-rs-service-description (133) [org.apache.cxf.jaxrs.model.wadl.WadlGenerator]
313七月 05, 2022 4:30:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
314信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (135) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
315七月 05, 2022 4:30:50 下午 org.apache.cxf.transport.http.osgi.ServletExporter updated
316信息: Registering new instance of "/cxf" servlet
317七月 05, 2022 4:30:50 下午 org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
318信息: New Caching Service registered
31916:30:50,906 INFO [DriverManager] Installing driver kars.
32016:30:50,910 INFO [DriverManager] 0 drivers will be installed.
32116:30:50,912 INFO [DriverManager] Finished installing drivers kars.
3222022-07-05 16:30:50.983:INFO:oejws.WebSocketServerFactory:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3232022-07-05 16:30:51.167:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): DefaultSessionIdManager workerName=node0
3242022-07-05 16:30:51.167:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): No SessionScavenger set, using defaults
3252022-07-05 16:30:51.169:INFO:oejs.session:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): node0 Scavenging every 660000ms
3262022-07-05 16:30:51.225:INFO:oejsh.ContextHandler:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.apache.cxf.cxf-rt-transports-http [135], contextID=default]}
3272022-07-05 16:30:51.235:INFO:oejs.Server:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): jetty-9.4.18.v20190429; built: 2021-06-30T11:07:22.254Z; git: 526006ecfa3af7f1a27ef3a288e2bef7ea9dd7e8; jvm 1.8.0_332-b09
3282022-07-05 16:30:51.300:INFO:oejs.AbstractConnector:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started default@2e2310de{HTTP/1.1, (http/1.1)}{0.0.0.0:9052}
3292022-07-05 16:30:51.300:INFO:oejs.Server:CM Configuration Updater (ManagedService Update: pid=[org.apache.cxf.osgi]): Started @9814ms
330七月 05, 2022 4:30:51 下午 org.apache.cxf.endpoint.ServerImpl initDestination
331信息: Setting the server's publish address to be /i18n
3322022-07-05 16:30:51.977:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3332022-07-05 16:30:51.985:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-i18n-webservice-bundle [218], contextID=default]}
3342022-07-05 16:30:53.810:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3352022-07-05 16:30:53.817:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=org.pentaho.requirejs-manager-impl [248], contextID=default]}
336七月 05, 2022 4:30:54 下午 org.apache.cxf.endpoint.ServerImpl initDestination
337信息: Setting the server's publish address to be /marketplace
3382022-07-05 16:30:54.584:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3392022-07-05 16:30:54.588:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular [250], contextID=default]}
3402022-07-05 16:30:54.603:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3412022-07-05 16:30:54.609:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-animate [251], contextID=default]}
3422022-07-05 16:30:54.980:INFO:oejws.WebSocketServerFactory:FelixDispatchQueue: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3432022-07-05 16:30:54.997:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3442022-07-05 16:30:54.998:INFO:oejsh.ContextHandler:FelixDispatchQueue: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-marketplace-di [249], contextID=default]}
3452022-07-05 16:30:55.004:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-route [252], contextID=default]}
3462022-07-05 16:30:55.022:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3472022-07-05 16:30:55.034:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-sanitize [253], contextID=default]}
3482022-07-05 16:30:55.050:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3492022-07-05 16:30:55.055:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-translate [254], contextID=default]}
3502022-07-05 16:30:55.071:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3512022-07-05 16:30:55.076:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-angular-ui-bootstrap-bower [255], contextID=default]}
3522022-07-05 16:30:55.095:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3532022-07-05 16:30:55.100:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-jquery [256], contextID=default]}
3542022-07-05 16:30:55.118:INFO:oejws.WebSocketServerFactory:FelixStartLevel: No DecoratedObjectFactory provided, using new org.eclipse.jetty.util.DecoratedObjectFactory[decorators=1]
3552022-07-05 16:30:55.122:INFO:oejsh.ContextHandler:FelixStartLevel: Started HttpServiceContext{httpContext=DefaultHttpContext [bundle=pentaho-webjars-underscore [257], contextID=default]}
3562022/07/05 16:30:55 - Pan - Start of run.
3572022/07/05 16:30:55 - 复制到_ora12cinventories_到_mysql8 - Dispatching started for transformation [复制到_ora12cinventories_到_mysql8]
358Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
359Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
360Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
361Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
362Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
363Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
364Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
365Tue Jul 05 16:30:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
3662022/07/05 16:30:56 - 写到 [INVENTORIES].1 - Connected to database [mysql8] (commit=10000)
3672022/07/05 16:30:56 - 写到 [INVENTORIES].6 - Connected to database [mysql8] (commit=10000)
3682022/07/05 16:30:56 - 写到 [INVENTORIES].0 - Connected to database [mysql8] (commit=10000)
3692022/07/05 16:30:56 - 写到 [INVENTORIES].3 - Connected to database [mysql8] (commit=10000)
3702022/07/05 16:30:56 - 写到 [INVENTORIES].5 - Connected to database [mysql8] (commit=10000)
3712022/07/05 16:30:56 - 写到 [INVENTORIES].2 - Connected to database [mysql8] (commit=10000)
3722022/07/05 16:30:56 - 写到 [INVENTORIES].7 - Connected to database [mysql8] (commit=10000)
3732022/07/05 16:30:56 - 写到 [INVENTORIES].4 - Connected to database [mysql8] (commit=10000)
3742022/07/05 16:30:58 - 从 [INVENTORIES].0 - linenr 50000
3752022/07/05 16:30:59 - 从 [INVENTORIES].0 - linenr 100000
3762022/07/05 16:31:00 - 从 [INVENTORIES].0 - linenr 150000
3772022/07/05 16:31:06 - 从 [INVENTORIES].0 - linenr 200000
3782022/07/05 16:31:09 - 从 [INVENTORIES].0 - linenr 250000
3792022/07/05 16:31:10 - 从 [INVENTORIES].0 - linenr 300000
3802022/07/05 16:31:13 - 从 [INVENTORIES].0 - linenr 350000
3812022/07/05 16:31:14 - 从 [INVENTORIES].0 - linenr 400000
3822022/07/05 16:31:16 - 从 [INVENTORIES].0 - linenr 450000
3832022/07/05 16:31:18 - 写到 [INVENTORIES].0 - linenr 50000
3842022/07/05 16:31:18 - 写到 [INVENTORIES].1 - linenr 50000
3852022/07/05 16:31:18 - 写到 [INVENTORIES].5 - linenr 50000
3862022/07/05 16:31:18 - 写到 [INVENTORIES].7 - linenr 50000
3872022/07/05 16:31:18 - 写到 [INVENTORIES].4 - linenr 50000
3882022/07/05 16:31:18 - 写到 [INVENTORIES].3 - linenr 50000
3892022/07/05 16:31:18 - 写到 [INVENTORIES].2 - linenr 50000
3902022/07/05 16:31:18 - 写到 [INVENTORIES].6 - linenr 50000
3912022/07/05 16:31:19 - 从 [INVENTORIES].0 - linenr 500000
3922022/07/05 16:31:20 - 从 [INVENTORIES].0 - linenr 550000
3932022/07/05 16:31:23 - 从 [INVENTORIES].0 - linenr 600000
3942022/07/05 16:31:25 - 从 [INVENTORIES].0 - linenr 650000
3952022/07/05 16:31:26 - 从 [INVENTORIES].0 - linenr 700000
3962022/07/05 16:31:29 - 从 [INVENTORIES].0 - linenr 750000
3972022/07/05 16:31:30 - 从 [INVENTORIES].0 - linenr 800000
3982022/07/05 16:31:31 - 从 [INVENTORIES].0 - linenr 850000
3992022/07/05 16:31:33 - 写到 [INVENTORIES].0 - linenr 100000
4002022/07/05 16:31:33 - 写到 [INVENTORIES].1 - linenr 100000
4012022/07/05 16:31:33 - 写到 [INVENTORIES].5 - linenr 100000
4022022/07/05 16:31:33 - 写到 [INVENTORIES].7 - linenr 100000
4032022/07/05 16:31:33 - 写到 [INVENTORIES].2 - linenr 100000
4042022/07/05 16:31:33 - 写到 [INVENTORIES].4 - linenr 100000
4052022/07/05 16:31:33 - 写到 [INVENTORIES].3 - linenr 100000
4062022/07/05 16:31:33 - 写到 [INVENTORIES].6 - linenr 100000
4072022/07/05 16:31:34 - 从 [INVENTORIES].0 - linenr 900000
4082022/07/05 16:31:34 - 从 [INVENTORIES].0 - Finished reading query, closing connection
4092022/07/05 16:31:34 - 从 [INVENTORIES].0 - Finished processing (I=900724, O=0, R=0, W=900724, U=0, E=0)
4102022/07/05 16:31:37 - 写到 [INVENTORIES].1 - Finished processing (I=0, O=112591, R=112591, W=112591, U=0, E=0)
4112022/07/05 16:31:37 - 写到 [INVENTORIES].0 - Finished processing (I=0, O=112591, R=112591, W=112591, U=0, E=0)
4122022/07/05 16:31:37 - 写到 [INVENTORIES].5 - Finished processing (I=0, O=112590, R=112590, W=112590, U=0, E=0)
4132022/07/05 16:31:37 - 写到 [INVENTORIES].7 - Finished processing (I=0, O=112590, R=112590, W=112590, U=0, E=0)
4142022/07/05 16:31:37 - 写到 [INVENTORIES].6 - Finished processing (I=0, O=112590, R=112590, W=112590, U=0, E=0)
4152022/07/05 16:31:37 - 写到 [INVENTORIES].4 - Finished processing (I=0, O=112590, R=112590, W=112590, U=0, E=0)
4162022/07/05 16:31:38 - 写到 [INVENTORIES].2 - Finished processing (I=0, O=112591, R=112591, W=112591, U=0, E=0)
4172022/07/05 16:31:38 - 写到 [INVENTORIES].3 - Finished processing (I=0, O=112591, R=112591, W=112591, U=0, E=0)
4182022/07/05 16:31:38 - Carte - Installing timer to purge stale objects after 1440 minutes.
4192022/07/05 16:31:38 - Pan - Finished!
4202022/07/05 16:31:38 - Pan - Start=2022/07/05 16:30:55.896, Stop=2022/07/05 16:31:38.063
4212022/07/05 16:31:38 - Pan - Processing ended after 42 seconds.
4222022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 -
4232022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 从 [INVENTORIES].0 ended successfully, processed 900724 lines. ( 21445 lines/s)
4242022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].0 ended successfully, processed 112591 lines. ( 2680 lines/s)
4252022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].1 ended successfully, processed 112591 lines. ( 2680 lines/s)
4262022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].2 ended successfully, processed 112591 lines. ( 2680 lines/s)
4272022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].3 ended successfully, processed 112591 lines. ( 2680 lines/s)
4282022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].4 ended successfully, processed 112590 lines. ( 2680 lines/s)
4292022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].5 ended successfully, processed 112590 lines. ( 2680 lines/s)
4302022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].6 ended successfully, processed 112590 lines. ( 2680 lines/s)
4312022/07/05 16:31:38 - 复制到_ora12cinventories_到_mysql8 - Step 写到 [INVENTORIES].7 ended successfully, processed 112590 lines. ( 2680 lines/s)复制
总结
1、全量初始化比较快，BLOB和CLOB也可以同步。
2、问题：开启并行复制后，偶尔发现有数据丢失的问题，我大概定位到是由于插入之前没有手工做“清空表的操作”，而是让kettle做清空表的动作，大概率跟这个有关系。大家若有大表单独导入，请在导入之前，手工执行truncate操作。
3、“工具->向导->复制多表向导”或快捷键“ctrl+f10”复制会同时复制表结构，然后在MySQL中对不正确的结构做修改后，可以从MySQL导出DDL语句，后续同步，只需要同步数据，而不用同步表结构了。
文章转载自DB宝，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
相关阅读
Oracle RAC 一键安装翻车？手把手教你如何排错！
Lucifer三思而后行
548次阅读
2025-04-15 17:24:06
【纯干货】Oracle 19C RU 19.27 发布，如何快速升级和安装？
Lucifer三思而后行
469次阅读
2025-04-18 14:18:38
【MySQL 30周年庆】MySQL 8.0 OCP考试限时免费！教你免费领考券
墨天轮小教习
450次阅读
2025-04-25 18:53:11
Oracle SQL 执行计划分析与优化指南
Digital Observer
446次阅读
2025-04-01 11:08:44
XTTS跨版本迁移升级方案（11g to 19c RAC for Linux）
zwtian
445次阅读
2025-04-08 09:12:48
墨天轮个人数说知识点合集
JiekeXu
443次阅读
2025-04-01 15:56:03
【ORACLE】记录一些ORACLE的merge into语句的BUG
DarkAthena
438次阅读
2025-04-22 00:20:37
MySQL数据库当前和历史事务分析
听见风的声音
426次阅读
2025-04-01 08:47:17
【ORACLE】你以为的真的是你以为的么?--ORA-38104: Columns referenced in the ON Clause cannot be updated
DarkAthena
414次阅读
2025-04-22 00:13:51
Oracle数据库一键巡检并生成HTML结果，免费脚本速来下载!
陈举超
411次阅读
2025-04-20 10:07:02
