#lvmamastudy
eclipse windows perf maven user settings config
svn connector installation
maven svn checkout thursday
hide pom.xml in thursday
import maven projects in thursday
download tomcat 7
config jdk 7
use dubbo ,zookeeper, jms package and startup zk, dubbo, jms
in eclipse startup module in tomcat server, set timeout to 1200
for example : set vst_back/src/main/config/dubbo.properties
dubbo.application.name=vst_back
dubbo.registry.protocol=zookeeper
dubbo.registry.address=127.0.0.1:2181
dubbo.protocol.port=20880
dubbo.monitor.address=127.0.0.1:7070
use this page:
http://192.168.0.106:8080/prism-web/zk+
to register service into local zk
http://localhost:8082/applications.html
to see if the local provider is registered
if login is needed, can comment following block:
//if (isNeedCheck) { 验证是否登录 //PermUser user = (PermUser) ServletUtil.getSession(req, res, BaseActionSupport.SESSION_BACK_USER); //if(isDebug){ //LOG.debug("user login {}",new Object[]{user!=null}); //} //if (user == null //|| !user.getPermUserPass() //|| uri.equalsIgnoreCase(req.getContextPath()) //|| uri.equalsIgnoreCase("/")) { //res.sendRedirect("/pet_back/login.do"); //return; //} 验证权限 //if(isPermRefused(req,user)){ //if(isDebug){ //LOG.debug("isPermRefused true"); //} //res.sendRedirect("/pet_back/permError.jsp?from=" //+ URLEncoder.encode(req.getRequestURI(),"UTF-8") //+ "&userId=" + String.valueOf(user.getUserId())); //return; //} //}
in file : vst_comm/src/main/java/com/lvmama/vst/comm/filter/PermissionFilter.java
ubuntu sudo apt-get update issue
solution:
sudo rm /var/cache/apt/archives/lock
sudo rm /var/lib/dpkg/lock
intellj 2016 license:
43B4A73YYJ-eyJsaWNlbnNlSWQiOiI0M0I0QTczWVlKIiwibGljZW5zZWVOYW1lIjoibGFuIHl1IiwiYXNzaWduZWVOYW1lIjoiIiwiYXNzaWduZWVFbWFpbCI6IiIsImxpY2Vuc2VSZXN0cmljdGlvbiI6IkZvciBlZHVjYXRpb25hbCB1c2Ugb25seSIsImNoZWNrQ29uY3VycmVudFVzZSI6ZmFsc2UsInByb2R1Y3RzIjpbeyJjb2RlIjoiSUkiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJBQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IkRQTiIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlBTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiRE0iLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJDTCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJTMCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJDIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiUEMiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJSTSIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IldTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiREIiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJEQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9XSwiaGFzaCI6IjMzOTgyOTkvMCIsImdyYWNlUGVyaW9kRGF5cyI6MCwiYXV0b1Byb2xvbmdhdGVkIjpmYWxzZSwiaXNBdXRvUHJvbG9uZ2F0ZWQiOmZhbHNlfQ==-keaxIkRgXPKE4BR/ZTs7s7UkP92LBxRe57HvWamu1EHVXTcV1B4f/KNQIrpOpN6dgpjig5eMVMPmo7yMPl+bmwQ8pTZaCGFuLqCHD1ngo6ywHKIQy0nR249sAUVaCl2wGJwaO4JeOh1opUx8chzSBVRZBMz0/MGyygi7duYAff9JQqfH3p/BhDTNM8eKl6z5tnneZ8ZG5bG1XvqFTqWk4FhGsEWdK7B+He44hPjBxKQl2gmZAodb6g9YxfTHhVRKQY5hQ7KPXNvh3ikerHkoaL5apgsVBZJOTDE2KdYTnGLmqxghFx6L0ofqKI6hMr48ergMyflDk6wLNGWJvYHLWw==-MIIEPjCCAiagAwIBAgIBBTANBgkqhkiG9w0BAQsFADAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBMB4XDTE1MTEwMjA4MjE0OFoXDTE4MTEwMTA4MjE0OFowETEPMA0GA1UEAwwGcHJvZDN5MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxcQkq+zdxlR2mmRYBPzGbUNdMN6OaXiXzxIWtMEkrJMO/5oUfQJbLLuMSMK0QHFmaI37WShyxZcfRCidwXjot4zmNBKnlyHodDij/78TmVqFl8nOeD5+07B8VEaIu7c3E1N+e1doC6wht4I4+IEmtsPAdoaj5WCQVQbrI8KeT8M9VcBIWX7fD0fhexfg3ZRt0xqwMcXGNp3DdJHiO0rCdU+Itv7EmtnSVq9jBG1usMSFvMowR25mju2JcPFp1+I4ZI+FqgR8gyG8oiNDyNEoAbsR3lOpI7grUYSvkB/xVy/VoklPCK2h0f0GJxFjnye8NT1PAywoyl7RmiAVRE/EKwIDAQABo4GZMIGWMAkGA1UdEwQCMAAwHQYDVR0OBBYEFGEpG9oZGcfLMGNBkY7SgHiMGgTcMEgGA1UdIwRBMD+AFKOetkhnQhI2Qb1t4Lm0oFKLl/GzoRykGjAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBggkA0myxg7KDeeEwEwYDVR0lBAwwCgYIKwYBBQUHAwEwCwYDVR0PBAQDAgWgMA0GCSqGSIb3DQEBCwUAA4ICAQC9WZuYgQedSuOc5TOUSrRigMw4/+wuC5EtZBfvdl4HT/8vzMW/oUlIP4YCvA0XKyBaCJ2iX+ZCDKoPfiYXiaSiH+HxAPV6J79vvouxKrWg2XV6ShFtPLP+0gPdGq3x9R3+kJbmAm8w+FOdlWqAfJrLvpzMGNeDU14YGXiZ9bVzmIQbwrBA+c/F4tlK/DV07dsNExihqFoibnqDiVNTGombaU2dDup2gwKdL81ua8EIcGNExHe82kjF4zwfadHk3bQVvbfdAwxcDy4xBjs3L4raPLU3yenSzr/OEur1+jfOxnQSmEcMXKXgrAQ9U55gwjcOFKrgOxEdek/Sk1VfOjvS+nuM4eyEruFMfaZHzoQiuw4IqgGc45ohFH0UUyjYcuFxxDSU9lMCv8qdHKm+wnPRb0l9l5vXsCBDuhAGYD6ss+Ga+aDY6f/qXZuUCEUOH3QUNbbCUlviSz6+GiRnt1kA9N2Qachl+2yBfaqUqr8h7Z2gsx5LcIf5kYNsqJ0GavXTVyWh7PYiKX4bs354ZQLUwwa/cG++2+wNWP+HtBhVxMRNTdVhSm38AknZlD+PTAsWGu9GyLmhti2EnVwGybSD2Dxmhxk3IPCkhKAK+pl0eWYGZWG3tJ9mZ7SowcXLWDFAk0lRJnKGFMTggrWjV8GYpw5bq23VmIqqDLgkNzuoog==
sync_super_jdbc.username=lvmama_super
sync_super_jdbc.password=oU7Reu3nLh
sync_super_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2
sync_pet_jdbc.username=lvmama_pet
sync_pet_jdbc.password=hJn4B90rPO
sync_pet_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2
sync_vst_jdbc.username=lvmama_ver
sync_vst_jdbc.password=nPH3g7yVgn
sync_vst_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2
workflow 由订单创建启动
影响 comAudit, comMessage 两个表
主流程 -> 子流程
分支有listener notify 方法注入控制变量
仿真环境账号
bbbbbb1,111111
前台下单
后台财务管理->线下支付管理->测试付款->VST+订单查询->付款
vst_order,vst_workflow分别在192.168.0.184,10.2.2.38上面
http://ebooking.lvmama.com/
账号:lv9224 密码:lv9224
供应商登录后发现有待确定的订单,确定资源
仿真环境的主机IP基于全仿真工程分配图_2016版_V1.0_20160105(1)
有所变化
192.168.X.X保持不变
10.0.2.x ==> 10.200.1.x
10.2.2.x ==> 10.200.2.x
状态: 失败 -测试失败: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
状态: 失败 -测试失败: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
陈国红 - 用户体验组 2016-08-18 10:33:15
http://super.lvmama.com/vst_back/biz/category/findObjectList.do?code=242bf46a04018ed4ef00d78cb141761b
不知道你有没有权限查
陈国红 - 用户体验组 2016-08-18 10:33:39
如果没有权限,只能写好SQL找DBA查
陈国红 - 用户体验组 2016-08-18 10:33:51
拉分支
陈国红 - 用户体验组 2016-08-18 10:33:59
现在可以拉,之后可能拉不了
陈炜 - 出境业务开发组 2016-08-18 10:35:25
明白了
陈国红 - 用户体验组 2016-08-18 10:36:45
测试申请写一下
陈国红 - 用户体验组 2016-08-18 10:36:58
分支名字发下给梁石
调试vst_ebooking时候登录不了(zookeeper 配置游玩人后置2已经完毕3个依赖包已经导入本地zookeeper)
|--> vst_order
|--> vst_pet
|--> vst_back
|--> pet_public
1.
说是memcache配置问题
原先的memcached.properties 修改成
cache.server=10.200.3.144:12000
session.cache.server=10.200.3.144:12000
cache.enable=true
vst_ebkService 中copy vst_ebooking 的 dubbo.properties到 vst_ebkService中
启动在另外一个tomcat server 看一下eclipse 启动tomcat的参数配置,而不是tomcat本身的配置
128数据库
128数据库:用户名 密码
lvmama_super RM1cp5H8
lvmama_pet HgQz5Ncl
lvmama_report lvmama_report
lvmama yh9TlXkj
lvmama_ver YDUXtDDZ
LVMAMA_WORKFLOW Ry3ex1mp
#url :jdbc:mysql://10.200.3.188:3306/lvmama_user
#user :lvmama_user_ro
#password:8ZV0Y2GMSHz
8月24日图形验证码没有显示时下单不成问题
反思了昨天bug:
路径依赖的变量必须都核实是否要改动判断条件,我当时是知道有这个变量是路径依赖的,但是不太敢动,想测试出问题了再改
拖延了
测试依赖,结果当时让邢智宇提供不需要图形验证码的手机号,他没有及时回应,让我把链接发给他,我发了,他说可以,我就
以为是没问题,也把这个消息告诉陈国红了,结果造成其实测试依赖也没有落实。
8月25日开始有2个项目,其中workflow是在分支上开发
本地环境备忘:
本地intellj基于Thursday 建立git repo并和oschina作为远端备份,作为开发环境便于代码版本管理,已经在git 基础上建立了workflow分支
本地在working目录下建立Thursday , workflow的目录作为代码checkin的环境 到时候比较1.intellj 和 2.working/Thursday or workflow 的差异
将需要提交的文件copy 覆盖到working 目录下提交注意避免文件覆盖错误
检查子订单资源审核 信息审核是否enable
auditMap 中下面2个值
RESOURCE_AUDIT
INFO_AUDIT
检查工作流实时instance
select * from act_ru_execution t where t.order_id_ ='';
select * from act_ru_variable ;
select * from act_ge_bytearray b where b.id_='1743';
检查实时工作流图
主订单
http://super.lvmama.com/vst_workflow/page/order/20022648
子订单 子订单生命周期短,完事后就查不到流程图了
http://super.lvmama.com/vst_workflow/page/item/30000326547/approve
$ git config --global core.quotepath false # 显示 status 编码
$ git config --global gui.encoding utf-8 # 图形界面编码
$ git config --global i18n.commit.encoding utf-8 # 提交信息编码
$ git config --global i18n.logoutputencoding utf-8 # 输出 log 编码
$ export LESSCHARSET=utf-8
最后一条命令是因为 git log 默认使用 less 分页,所以需要 bash 对 less 命令进行 utf-8 编码
select * from act_re_procdef where resource_name_ ='order_prepaid_main_process.bpmn' order by update_time_ desc ;
select * from ACT_RE_DEPLOYMENT order by deploy_time_ desc, update_time_ desc ;
144:
ls -al restart*.sh |gawk '{ print "./"$9"&" }'
sudo ./restart_memcache.sh nohup&
sudo ./restart_activemq_5.13.0.sh nohup&
sudo ./restart_cmt_front.sh nohup&
sudo ./restart_other.sh nohup&
sudo ./restart_pet_service.sh nohup&
sudo ./restart_seo_back.sh nohup&
sudo ./restart_tnt_front.sh nohup&
sudo ./restart_tnt_service.sh nohup&
sudo ./restart_back.sh nohup&
sudo ./restart_cmt_service.sh nohup&
sudo ./restart_payment.sh nohup&
sudo ./restart_pic.sh nohup&
sudo ./restart_seo_dist.sh nohup&
sudo ./restart_tnt_order.sh nohup&
sudo ./restart_tomcat.sh nohup&
sudo ./restart_channel_server.sh nohup&
sudo ./restart_front.sh nohup&
sudo ./restart_pc.sh nohup&
sudo ./restart_report.sh nohup&
sudo ./restart_super_service.sh nohup&
sudo ./restart_tnt_platform.sh nohup&
sudo ./restart_user.sh nohup&
sudo ./restart_cmt_back.sh nohup&
sudo ./restart_ocs.sh nohup&
sudo ./restart_pet_finfront.sh nohup&
sudo ./restart_sales_service.sh nohup&
sudo ./restart_tnt_back.sh nohup&
sudo ./restart_tnt_sback.sh nohup&
145:
sudo ./restart_cms_content.sh nohup&
sudo ./restart_dest_bridge_schedule.sh nohup&
sudo ./restart_dest_hotel_dock.sh nohup&
sudo ./restart_dest_service.sh nohup&
sudo ./restart_o2o_back.sh nohup&
sudo ./restart_o2o_front.sh nohup&
sudo ./restart_supp.sh nohup&
sudo ./restart_tomcat.sh nohup&
sudo ./restart_vst_allocation.sh nohup&
sudo ./restart_vst_back.sh nohup&
sudo ./restart_vst_ebkService.sh nohup&
sudo ./restart_vst_ebooking.sh nohup&
sudo ./restart_vst_front.sh nohup&
sudo ./restart_vst_interfacePlatform.sh nohup&
sudo ./restart_vst_order.sh nohup&
sudo ./restart_vst_passport.sh nohup&
sudo ./restart_vst_pet.sh nohup&
sudo ./restart_vst_prodcal.sh nohup&
sudo ./restart_vst_prom.sh nohup&
sudo ./restart_vst_rest.sh nohup&
sudo ./restart_vst_search.sh nohup&
sudo ./restart_vst_ticket.sh nohup&
sudo ./restart_vst_workflow.sh nohup&
sudo ./restart_dest_bridge_schedule.sh nohup&
sudo ./restart_dest_hotel_dock.sh nohup&
sudo ./restart_dest_service.sh nohup&
更改工作流bpmn文件后部署上去后要配置人员清缓存memcache
独立环境里面缓存在10.200.3.144上 kill memche的进程
从新启动各个服务
10.200.3.145
restart_memcache.sh
144&145 独立环境下数据库
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.maxActive=10
jdbc.maxIdle=1
jdbc.maxWait=10000
jdbc.initSize=1
jdbc.username=lvmama_ver
jdbc.password=nPH3g7yVgn
jdbc.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1
jdbc.readonly.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.readonly.maxActive=10
jdbc.readonly.maxIdle=1
jdbc.readonly.maxWait=10000
jdbc.readonly.initSize=1
jdbc.readonly.username=lvmama_ver
jdbc.readonly.password=nPH3g7yVgn
jdbc.readonly.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1
datasource.hold.enabled=false
jdbc.r1.username=lvmama_ver
jdbc.r1.password=nPH3g7yVgn
jdbc.r1.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1
DB_SYNC_SECOND=2
checkWriteInReadonly=true
\vst_front\src\main\webapp\js\visa\bookVisa.js 闫冬全修改的前端图形码优化显示
在添加Tomcat之前,需要修改一下Tomcat中的catalina.bat文件。否则在项目启动一段时间后会出现:
java.lang.OutOfMemoryError: PermGen space错误(内存溢出),这是因为存放class信息的PermGen space
区域不会在主程序运行期被清理,如果load很多class的话,就很可能出现PermGen space错误。
文件位置:安装tomcat目录下的bin目录下。我的是在:D:\develop\apache-tomcat-6.0.36\bin下。
打开catalina.bat文件,找到:echo Using CATALINA_BASE: "%CATALINA_BASE%"。在其上面位置
添加:set JAVA_OPTS=%JAVA_OPTS% -server -XX:PermSize=128M -XX:MaxPermSize=512m
下面这句sql外面包裹了一层分页逻辑
SELECT * FROM (SELECT P_T.*,ROWNUM AS RN FROM (
select
ORDERSTOCK.MESSAGE_ID ,
ORDERSTOCK.PRODUCT_ID,
ORDERSTOCK.PRODUCT_NAME,
ORDERSTOCK.VISIT_TIME,
ORDERSTOCK.SUPPLIER_ID,
ORDERSTOCK.LATEST_PAYMENT_TIME,
MSG.CONTENT
from EBK_MESSAGE MSG , EBK_MESSAGE_ORDER_STOCK ORDERSTOCK
where MSG.message_id = ORDERSTOCK.message_id
and
ORDERSTOCK.PRODUCT_ID = 1000
and
MSG.SUPPLIER_ID = 3410
AND MSG.EXPIRY_DATE > sysdate
) P_T ) WHERE RN BETWEEN 1 AND 5;
workflow 改动总结
executeTask的时候可以往context即execution里面塞环境变量
dubbo调用,跨jvm的module往往用dubbo调用,如果已经声明过的service,那么只需要查看是否需要添加接口定义
可以尝试一下用listener来往execution里面塞环境变量 -- 可行
BizEnum.category_route_group(15L,"跟团游"),
alter session set NLS_COMP=ANSI;
alter session set NLS_SORT=BINARY_CI;
SELECT owner, table_name FROM all_tables where owner = 'LVMAMA_VER' and table_name like '%HOTEL%';
SELECT owner, table_name FROM all_tables where owner = 'LVMAMA_VER';
发现用ExecutionListener后在一次测试中当vst_order service不正常时,workflow能够继续走,觉得用listener 后把需要串行的流程变成并行导致有可能出现变量尚未被设置到activiti的context中而流程已经走到需要判断变量以决定走哪个分支的阶段。 有风险,提出缓提交。
解决方法:还是用原来的task模式查询出控制变量设置到activiti的context中
数据库表设计模式和实践方面的好书要重点补充阅读
9月22日把workflow的代码更新成Thursday的最新版
然后把originworkflow/workflow2的代码合并修改到workflow目录里面然后提交
陈洁电话:15900867030
ebooking供应商登录帐号
ceshichanpin 111111q
SELECT table_name
FROM all_tab_cols
WHERE column_name like'%attachment'
grep -n ...
awk 'NR >= 9222600 && NR <= 9222800' catalina.out-2016-09-26 | more
awk 'NR >= 4384102 && NR <= 4384902' 172.20.9.169/catalina.out-2016-09-26|more
查询code
D:\working\workflow\vst_comm\src\main\java\com\lvmama\vst\comm\utils\DESCoder.java
的main函数生成 比如:
3a59d74f3b28cf173f5f5fd711de3f43
delete from PROD_TRAFFIC_FLIGHT
where FLIGHT_ID IN
#{flightId}
where 1 != 1