API tools faq
paste
Guest User

Untitled

a guest
Jun 3rd, 2018
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 102.24 KB | None | 0 0
raw download clone embed print report
  1. 16:28:26,258 (DBWorkload.java:126) INFO - **********************************************************************************
  2. 16:28:26,261 (DBWorkload.java:134) INFO - Configuration file: mysql_exp/wmbl/mst_seats.xml
  3. 16:28:26,273 (DBWorkload.java:147) INFO - DB Type = MYSQL
  4. 16:28:26,273 (DBWorkload.java:148) INFO - Driver = com.mysql.jdbc.Driver
  5. 16:28:26,274 (DBWorkload.java:149) INFO - URL = jdbc:mysql://ec2-50-16-99-183.compute-1.amazonaws.com:3306/seats
  6. 16:28:26,274 (DBWorkload.java:150) INFO - Isolation mode = TRANSACTION_SERIALIZABLE [DEFAULT]
  7. 16:28:26,451 (DBWorkload.java:191) INFO - Benchmark: seats {Class: com.oltpbenchmark.benchmarks.seats.SEATSBenchmark}
  8. 16:28:26,783 (FileUtil.java:232) DEBUG - Reading in the contents of 'seats-ddl.sql'
  9. 16:28:26,789 (Catalog.java:298) DEBUG - Original Table Names:
  10. CUSTOMER: CUSTOMER
  11. CONFIG_HISTOGRAMS: CONFIG_HISTOGRAMS
  12. FLIGHT: FLIGHT
  13. COUNTRY: COUNTRY
  14. CONFIG_PROFILE: CONFIG_PROFILE
  15. AIRPORT_DISTANCE: AIRPORT_DISTANCE
  16. FREQUENT_FLYER: FREQUENT_FLYER
  17. RESERVATION: RESERVATION
  18. AIRLINE: AIRLINE
  19. AIRPORT: AIRPORT
  20.  
  21. 16:28:26,791 (BenchmarkModule.java:206) DEBUG - Executing script 'seats-ddl.sql'
  22. 16:28:26,792 (ScriptRunner.java:135) DEBUG - --
  23. 16:28:26,792 (ScriptRunner.java:141) DEBUG - --
  24. 16:28:26,792 (ScriptRunner.java:135) DEBUG - -- CONFIG_PROFILE
  25. 16:28:26,793 (ScriptRunner.java:141) DEBUG - -- CONFIG_PROFILE
  26. 16:28:26,793 (ScriptRunner.java:135) DEBUG - --
  27. 16:28:26,794 (ScriptRunner.java:141) DEBUG - --
  28. 16:28:26,794 (ScriptRunner.java:135) DEBUG - CREATE TABLE CONFIG_PROFILE (
  29. 16:28:26,795 (ScriptRunner.java:135) DEBUG - CFP_SCALE_FACTOR FLOAT NOT NULL,
  30. 16:28:26,795 (ScriptRunner.java:135) DEBUG - CFP_AIPORT_MAX_CUSTOMER VARCHAR(10001) NOT NULL,
  31. 16:28:26,795 (ScriptRunner.java:135) DEBUG - CFP_FLIGHT_START TIMESTAMP NOT NULL,
  32. 16:28:26,796 (ScriptRunner.java:135) DEBUG - CFP_FLIGHT_UPCOMING TIMESTAMP NOT NULL,
  33. 16:28:26,796 (ScriptRunner.java:135) DEBUG - CFP_FLIGHT_PAST_DAYS INT NOT NULL,
  34. 16:28:26,797 (ScriptRunner.java:135) DEBUG - CFP_FLIGHT_FUTURE_DAYS INT NOT NULL,
  35. 16:28:26,797 (ScriptRunner.java:135) DEBUG - CFP_FLIGHT_OFFSET INT,
  36. 16:28:26,798 (ScriptRunner.java:135) DEBUG - CFP_RESERVATION_OFFSET INT,
  37. 16:28:26,798 (ScriptRunner.java:135) DEBUG - CFP_NUM_RECORDS VARCHAR(10002) NOT NULL,
  38. 16:28:26,798 (ScriptRunner.java:135) DEBUG - CFP_CODE_IDS_XREFS VARCHAR(16004) NOT NULL
  39. 16:28:26,799 (ScriptRunner.java:135) DEBUG - );
  40. 16:28:26,805 (ScriptRunner.java:135) DEBUG -
  41. 16:28:26,805 (ScriptRunner.java:135) DEBUG - --
  42. 16:28:26,805 (ScriptRunner.java:141) DEBUG - --
  43. 16:28:26,806 (ScriptRunner.java:135) DEBUG - -- CONFIG_HISTOGRAMS
  44. 16:28:26,806 (ScriptRunner.java:141) DEBUG - -- CONFIG_HISTOGRAMS
  45. 16:28:26,807 (ScriptRunner.java:135) DEBUG - --
  46. 16:28:26,807 (ScriptRunner.java:141) DEBUG - --
  47. 16:28:26,807 (ScriptRunner.java:135) DEBUG - CREATE TABLE CONFIG_HISTOGRAMS (
  48. 16:28:26,808 (ScriptRunner.java:135) DEBUG - CFH_NAME VARCHAR(128) NOT NULL,
  49. 16:28:26,808 (ScriptRunner.java:135) DEBUG - CFH_DATA VARCHAR(10005) NOT NULL,
  50. 16:28:26,808 (ScriptRunner.java:135) DEBUG - CFH_IS_AIRPORT TINYINT DEFAULT 0,
  51. 16:28:26,809 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (CFH_NAME)
  52. 16:28:26,809 (ScriptRunner.java:135) DEBUG - );
  53. 16:28:26,810 (ScriptRunner.java:135) DEBUG -
  54. 16:28:26,811 (ScriptRunner.java:135) DEBUG - --
  55. 16:28:26,811 (ScriptRunner.java:141) DEBUG - --
  56. 16:28:26,811 (ScriptRunner.java:135) DEBUG - -- COUNTRY
  57. 16:28:26,812 (ScriptRunner.java:141) DEBUG - -- COUNTRY
  58. 16:28:26,812 (ScriptRunner.java:135) DEBUG - --
  59. 16:28:26,812 (ScriptRunner.java:141) DEBUG - --
  60. 16:28:26,813 (ScriptRunner.java:135) DEBUG - CREATE TABLE COUNTRY (
  61. 16:28:26,813 (ScriptRunner.java:135) DEBUG - CO_ID BIGINT NOT NULL,
  62. 16:28:26,813 (ScriptRunner.java:135) DEBUG - CO_NAME VARCHAR(64) NOT NULL,
  63. 16:28:26,814 (ScriptRunner.java:135) DEBUG - CO_CODE_2 VARCHAR(2) NOT NULL,
  64. 16:28:26,814 (ScriptRunner.java:135) DEBUG - CO_CODE_3 VARCHAR(3) NOT NULL,
  65. 16:28:26,814 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (CO_ID)
  66. 16:28:26,815 (ScriptRunner.java:135) DEBUG - );
  67. 16:28:26,816 (ScriptRunner.java:135) DEBUG -
  68. 16:28:26,817 (ScriptRunner.java:135) DEBUG - --
  69. 16:28:26,817 (ScriptRunner.java:141) DEBUG - --
  70. 16:28:26,817 (ScriptRunner.java:135) DEBUG - -- AIRPORT
  71. 16:28:26,818 (ScriptRunner.java:141) DEBUG - -- AIRPORT
  72. 16:28:26,818 (ScriptRunner.java:135) DEBUG - --
  73. 16:28:26,818 (ScriptRunner.java:141) DEBUG - --
  74. 16:28:26,819 (ScriptRunner.java:135) DEBUG - CREATE TABLE AIRPORT (
  75. 16:28:26,819 (ScriptRunner.java:135) DEBUG - AP_ID BIGINT NOT NULL,
  76. 16:28:26,819 (ScriptRunner.java:135) DEBUG - AP_CODE VARCHAR(3) NOT NULL,
  77. 16:28:26,819 (ScriptRunner.java:135) DEBUG - AP_NAME VARCHAR(128) NOT NULL,
  78. 16:28:26,820 (ScriptRunner.java:135) DEBUG - AP_CITY VARCHAR(64) NOT NULL,
  79. 16:28:26,820 (ScriptRunner.java:135) DEBUG - AP_POSTAL_CODE VARCHAR(12),
  80. 16:28:26,820 (ScriptRunner.java:135) DEBUG - AP_CO_ID BIGINT NOT NULL REFERENCES COUNTRY (CO_ID),
  81. 16:28:26,821 (ScriptRunner.java:135) DEBUG - AP_LONGITUDE FLOAT,
  82. 16:28:26,821 (ScriptRunner.java:135) DEBUG - AP_LATITUDE FLOAT,
  83. 16:28:26,821 (ScriptRunner.java:135) DEBUG - AP_GMT_OFFSET FLOAT,
  84. 16:28:26,822 (ScriptRunner.java:135) DEBUG - AP_WAC BIGINT,
  85. 16:28:26,822 (ScriptRunner.java:135) DEBUG - AP_IATTR00 BIGINT,
  86. 16:28:26,822 (ScriptRunner.java:135) DEBUG - AP_IATTR01 BIGINT,
  87. 16:28:26,823 (ScriptRunner.java:135) DEBUG - AP_IATTR02 BIGINT,
  88. 16:28:26,823 (ScriptRunner.java:135) DEBUG - AP_IATTR03 BIGINT,
  89. 16:28:26,823 (ScriptRunner.java:135) DEBUG - AP_IATTR04 BIGINT,
  90. 16:28:26,823 (ScriptRunner.java:135) DEBUG - AP_IATTR05 BIGINT,
  91. 16:28:26,824 (ScriptRunner.java:135) DEBUG - AP_IATTR06 BIGINT,
  92. 16:28:26,824 (ScriptRunner.java:135) DEBUG - AP_IATTR07 BIGINT,
  93. 16:28:26,824 (ScriptRunner.java:135) DEBUG - AP_IATTR08 BIGINT,
  94. 16:28:26,825 (ScriptRunner.java:135) DEBUG - AP_IATTR09 BIGINT,
  95. 16:28:26,825 (ScriptRunner.java:135) DEBUG - AP_IATTR10 BIGINT,
  96. 16:28:26,825 (ScriptRunner.java:135) DEBUG - AP_IATTR11 BIGINT,
  97. 16:28:26,825 (ScriptRunner.java:135) DEBUG - AP_IATTR12 BIGINT,
  98. 16:28:26,826 (ScriptRunner.java:135) DEBUG - AP_IATTR13 BIGINT,
  99. 16:28:26,826 (ScriptRunner.java:135) DEBUG - AP_IATTR14 BIGINT,
  100. 16:28:26,826 (ScriptRunner.java:135) DEBUG - AP_IATTR15 BIGINT,
  101. 16:28:26,827 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (AP_ID)
  102. 16:28:26,827 (ScriptRunner.java:135) DEBUG - );
  103. 16:28:26,830 (ScriptRunner.java:135) DEBUG -
  104. 16:28:26,830 (ScriptRunner.java:135) DEBUG - --
  105. 16:28:26,830 (ScriptRunner.java:141) DEBUG - --
  106. 16:28:26,830 (ScriptRunner.java:135) DEBUG - -- AIRPORT_DISTANCE
  107. 16:28:26,831 (ScriptRunner.java:141) DEBUG - -- AIRPORT_DISTANCE
  108. 16:28:26,831 (ScriptRunner.java:135) DEBUG - --
  109. 16:28:26,831 (ScriptRunner.java:141) DEBUG - --
  110. 16:28:26,831 (ScriptRunner.java:135) DEBUG - CREATE TABLE AIRPORT_DISTANCE (
  111. 16:28:26,832 (ScriptRunner.java:135) DEBUG - D_AP_ID0 BIGINT NOT NULL REFERENCES AIRPORT (AP_ID),
  112. 16:28:26,832 (ScriptRunner.java:135) DEBUG - D_AP_ID1 BIGINT NOT NULL REFERENCES AIRPORT (AP_ID),
  113. 16:28:26,832 (ScriptRunner.java:135) DEBUG - D_DISTANCE FLOAT NOT NULL,
  114. 16:28:26,833 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (D_AP_ID0, D_AP_ID1)
  115. 16:28:26,833 (ScriptRunner.java:135) DEBUG - );
  116. 16:28:26,834 (ScriptRunner.java:135) DEBUG -
  117. 16:28:26,835 (ScriptRunner.java:135) DEBUG - --
  118. 16:28:26,835 (ScriptRunner.java:141) DEBUG - --
  119. 16:28:26,835 (ScriptRunner.java:135) DEBUG - -- AIRLINE
  120. 16:28:26,835 (ScriptRunner.java:141) DEBUG - -- AIRLINE
  121. 16:28:26,836 (ScriptRunner.java:135) DEBUG - --
  122. 16:28:26,836 (ScriptRunner.java:141) DEBUG - --
  123. 16:28:26,836 (ScriptRunner.java:135) DEBUG - CREATE TABLE AIRLINE (
  124. 16:28:26,837 (ScriptRunner.java:135) DEBUG - AL_ID BIGINT NOT NULL,
  125. 16:28:26,837 (ScriptRunner.java:135) DEBUG - AL_IATA_CODE VARCHAR(3),
  126. 16:28:26,837 (ScriptRunner.java:135) DEBUG - AL_ICAO_CODE VARCHAR(3),
  127. 16:28:26,837 (ScriptRunner.java:135) DEBUG - AL_CALL_SIGN VARCHAR(32),
  128. 16:28:26,838 (ScriptRunner.java:135) DEBUG - AL_NAME VARCHAR(128) NOT NULL,
  129. 16:28:26,838 (ScriptRunner.java:135) DEBUG - AL_CO_ID BIGINT NOT NULL REFERENCES COUNTRY (CO_ID),
  130. 16:28:26,838 (ScriptRunner.java:135) DEBUG - AL_IATTR00 BIGINT,
  131. 16:28:26,838 (ScriptRunner.java:135) DEBUG - AL_IATTR01 BIGINT,
  132. 16:28:26,839 (ScriptRunner.java:135) DEBUG - AL_IATTR02 BIGINT,
  133. 16:28:26,839 (ScriptRunner.java:135) DEBUG - AL_IATTR03 BIGINT,
  134. 16:28:26,839 (ScriptRunner.java:135) DEBUG - AL_IATTR04 BIGINT,
  135. 16:28:26,839 (ScriptRunner.java:135) DEBUG - AL_IATTR05 BIGINT,
  136. 16:28:26,840 (ScriptRunner.java:135) DEBUG - AL_IATTR06 BIGINT,
  137. 16:28:26,840 (ScriptRunner.java:135) DEBUG - AL_IATTR07 BIGINT,
  138. 16:28:26,840 (ScriptRunner.java:135) DEBUG - AL_IATTR08 BIGINT,
  139. 16:28:26,840 (ScriptRunner.java:135) DEBUG - AL_IATTR09 BIGINT,
  140. 16:28:26,841 (ScriptRunner.java:135) DEBUG - AL_IATTR10 BIGINT,
  141. 16:28:26,841 (ScriptRunner.java:135) DEBUG - AL_IATTR11 BIGINT,
  142. 16:28:26,841 (ScriptRunner.java:135) DEBUG - AL_IATTR12 BIGINT,
  143. 16:28:26,842 (ScriptRunner.java:135) DEBUG - AL_IATTR13 BIGINT,
  144. 16:28:26,842 (ScriptRunner.java:135) DEBUG - AL_IATTR14 BIGINT,
  145. 16:28:26,842 (ScriptRunner.java:135) DEBUG - AL_IATTR15 BIGINT,
  146. 16:28:26,842 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (AL_ID)
  147. 16:28:26,843 (ScriptRunner.java:135) DEBUG - );
  148. 16:28:26,845 (ScriptRunner.java:135) DEBUG -
  149. 16:28:26,845 (ScriptRunner.java:135) DEBUG - --
  150. 16:28:26,845 (ScriptRunner.java:141) DEBUG - --
  151. 16:28:26,846 (ScriptRunner.java:135) DEBUG - -- CUSTOMER
  152. 16:28:26,846 (ScriptRunner.java:141) DEBUG - -- CUSTOMER
  153. 16:28:26,846 (ScriptRunner.java:135) DEBUG - --
  154. 16:28:26,846 (ScriptRunner.java:141) DEBUG - --
  155. 16:28:26,847 (ScriptRunner.java:135) DEBUG - CREATE TABLE CUSTOMER (
  156. 16:28:26,847 (ScriptRunner.java:135) DEBUG - C_ID BIGINT NOT NULL,
  157. 16:28:26,847 (ScriptRunner.java:135) DEBUG - C_ID_STR VARCHAR(64) UNIQUE NOT NULL,
  158. 16:28:26,848 (ScriptRunner.java:135) DEBUG - C_BASE_AP_ID BIGINT REFERENCES AIRPORT (AP_ID),
  159. 16:28:26,848 (ScriptRunner.java:135) DEBUG - C_BALANCE FLOAT NOT NULL,
  160. 16:28:26,848 (ScriptRunner.java:135) DEBUG - C_SATTR00 VARCHAR(32),
  161. 16:28:26,848 (ScriptRunner.java:135) DEBUG - C_SATTR01 VARCHAR(8),
  162. 16:28:26,849 (ScriptRunner.java:135) DEBUG - C_SATTR02 VARCHAR(8),
  163. 16:28:26,849 (ScriptRunner.java:135) DEBUG - C_SATTR03 VARCHAR(8),
  164. 16:28:26,849 (ScriptRunner.java:135) DEBUG - C_SATTR04 VARCHAR(8),
  165. 16:28:26,849 (ScriptRunner.java:135) DEBUG - C_SATTR05 VARCHAR(8),
  166. 16:28:26,850 (ScriptRunner.java:135) DEBUG - C_SATTR06 VARCHAR(8),
  167. 16:28:26,850 (ScriptRunner.java:135) DEBUG - C_SATTR07 VARCHAR(8),
  168. 16:28:26,850 (ScriptRunner.java:135) DEBUG - C_SATTR08 VARCHAR(8),
  169. 16:28:26,850 (ScriptRunner.java:135) DEBUG - C_SATTR09 VARCHAR(8),
  170. 16:28:26,851 (ScriptRunner.java:135) DEBUG - C_SATTR10 VARCHAR(8),
  171. 16:28:26,851 (ScriptRunner.java:135) DEBUG - C_SATTR11 VARCHAR(8),
  172. 16:28:26,851 (ScriptRunner.java:135) DEBUG - C_SATTR12 VARCHAR(8),
  173. 16:28:26,851 (ScriptRunner.java:135) DEBUG - C_SATTR13 VARCHAR(8),
  174. 16:28:26,852 (ScriptRunner.java:135) DEBUG - C_SATTR14 VARCHAR(8),
  175. 16:28:26,852 (ScriptRunner.java:135) DEBUG - C_SATTR15 VARCHAR(8),
  176. 16:28:26,852 (ScriptRunner.java:135) DEBUG - C_SATTR16 VARCHAR(8),
  177. 16:28:26,853 (ScriptRunner.java:135) DEBUG - C_SATTR17 VARCHAR(8),
  178. 16:28:26,853 (ScriptRunner.java:135) DEBUG - C_SATTR18 VARCHAR(8),
  179. 16:28:26,853 (ScriptRunner.java:135) DEBUG - C_SATTR19 VARCHAR(8),
  180. 16:28:26,853 (ScriptRunner.java:135) DEBUG - C_IATTR00 BIGINT,
  181. 16:28:26,854 (ScriptRunner.java:135) DEBUG - C_IATTR01 BIGINT,
  182. 16:28:26,854 (ScriptRunner.java:135) DEBUG - C_IATTR02 BIGINT,
  183. 16:28:26,854 (ScriptRunner.java:135) DEBUG - C_IATTR03 BIGINT,
  184. 16:28:26,854 (ScriptRunner.java:135) DEBUG - C_IATTR04 BIGINT,
  185. 16:28:26,855 (ScriptRunner.java:135) DEBUG - C_IATTR05 BIGINT,
  186. 16:28:26,855 (ScriptRunner.java:135) DEBUG - C_IATTR06 BIGINT,
  187. 16:28:26,855 (ScriptRunner.java:135) DEBUG - C_IATTR07 BIGINT,
  188. 16:28:26,855 (ScriptRunner.java:135) DEBUG - C_IATTR08 BIGINT,
  189. 16:28:26,856 (ScriptRunner.java:135) DEBUG - C_IATTR09 BIGINT,
  190. 16:28:26,856 (ScriptRunner.java:135) DEBUG - C_IATTR10 BIGINT,
  191. 16:28:26,856 (ScriptRunner.java:135) DEBUG - C_IATTR11 BIGINT,
  192. 16:28:26,857 (ScriptRunner.java:135) DEBUG - C_IATTR12 BIGINT,
  193. 16:28:26,857 (ScriptRunner.java:135) DEBUG - C_IATTR13 BIGINT,
  194. 16:28:26,857 (ScriptRunner.java:135) DEBUG - C_IATTR14 BIGINT,
  195. 16:28:26,857 (ScriptRunner.java:135) DEBUG - C_IATTR15 BIGINT,
  196. 16:28:26,857 (ScriptRunner.java:135) DEBUG - C_IATTR16 BIGINT,
  197. 16:28:26,858 (ScriptRunner.java:135) DEBUG - C_IATTR17 BIGINT,
  198. 16:28:26,858 (ScriptRunner.java:135) DEBUG - C_IATTR18 BIGINT,
  199. 16:28:26,858 (ScriptRunner.java:135) DEBUG - C_IATTR19 BIGINT,
  200. 16:28:26,858 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (C_ID)
  201. 16:28:26,859 (ScriptRunner.java:135) DEBUG - );
  202. 16:28:26,862 (ScriptRunner.java:135) DEBUG -
  203. 16:28:26,862 (ScriptRunner.java:135) DEBUG - --
  204. 16:28:26,862 (ScriptRunner.java:141) DEBUG - --
  205. 16:28:26,862 (ScriptRunner.java:135) DEBUG - -- FREQUENT_FLYER
  206. 16:28:26,863 (ScriptRunner.java:141) DEBUG - -- FREQUENT_FLYER
  207. 16:28:26,863 (ScriptRunner.java:135) DEBUG - --
  208. 16:28:26,863 (ScriptRunner.java:141) DEBUG - --
  209. 16:28:26,863 (ScriptRunner.java:135) DEBUG - CREATE TABLE FREQUENT_FLYER (
  210. 16:28:26,864 (ScriptRunner.java:135) DEBUG - FF_C_ID BIGINT NOT NULL REFERENCES CUSTOMER (C_ID),
  211. 16:28:26,864 (ScriptRunner.java:135) DEBUG - FF_AL_ID BIGINT NOT NULL REFERENCES AIRLINE (AL_ID),
  212. 16:28:26,864 (ScriptRunner.java:135) DEBUG - FF_C_ID_STR VARCHAR(64) NOT NULL,
  213. 16:28:26,864 (ScriptRunner.java:135) DEBUG - FF_SATTR00 VARCHAR(32),
  214. 16:28:26,865 (ScriptRunner.java:135) DEBUG - FF_SATTR01 VARCHAR(32),
  215. 16:28:26,865 (ScriptRunner.java:135) DEBUG - FF_SATTR02 VARCHAR(32),
  216. 16:28:26,865 (ScriptRunner.java:135) DEBUG - FF_SATTR03 VARCHAR(32),
  217. 16:28:26,865 (ScriptRunner.java:135) DEBUG - FF_IATTR00 BIGINT,
  218. 16:28:26,866 (ScriptRunner.java:135) DEBUG - FF_IATTR01 BIGINT,
  219. 16:28:26,866 (ScriptRunner.java:135) DEBUG - FF_IATTR02 BIGINT,
  220. 16:28:26,866 (ScriptRunner.java:135) DEBUG - FF_IATTR03 BIGINT,
  221. 16:28:26,866 (ScriptRunner.java:135) DEBUG - FF_IATTR04 BIGINT,
  222. 16:28:26,867 (ScriptRunner.java:135) DEBUG - FF_IATTR05 BIGINT,
  223. 16:28:26,867 (ScriptRunner.java:135) DEBUG - FF_IATTR06 BIGINT,
  224. 16:28:26,867 (ScriptRunner.java:135) DEBUG - FF_IATTR07 BIGINT,
  225. 16:28:26,867 (ScriptRunner.java:135) DEBUG - FF_IATTR08 BIGINT,
  226. 16:28:26,868 (ScriptRunner.java:135) DEBUG - FF_IATTR09 BIGINT,
  227. 16:28:26,868 (ScriptRunner.java:135) DEBUG - FF_IATTR10 BIGINT,
  228. 16:28:26,868 (ScriptRunner.java:135) DEBUG - FF_IATTR11 BIGINT,
  229. 16:28:26,868 (ScriptRunner.java:135) DEBUG - FF_IATTR12 BIGINT,
  230. 16:28:26,869 (ScriptRunner.java:135) DEBUG - FF_IATTR13 BIGINT,
  231. 16:28:26,869 (ScriptRunner.java:135) DEBUG - FF_IATTR14 BIGINT,
  232. 16:28:26,869 (ScriptRunner.java:135) DEBUG - FF_IATTR15 BIGINT,
  233. 16:28:26,869 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (FF_C_ID, FF_AL_ID)
  234. 16:28:26,870 (ScriptRunner.java:135) DEBUG - );
  235. 16:28:26,872 (ScriptRunner.java:135) DEBUG - CREATE INDEX IDX_FF_CUSTOMER_ID ON FREQUENT_FLYER (FF_C_ID_STR);
  236. 16:28:26,872 (ScriptRunner.java:135) DEBUG -
  237. 16:28:26,873 (ScriptRunner.java:135) DEBUG - --
  238. 16:28:26,873 (ScriptRunner.java:141) DEBUG - --
  239. 16:28:26,873 (ScriptRunner.java:135) DEBUG - -- FLIGHT
  240. 16:28:26,873 (ScriptRunner.java:141) DEBUG - -- FLIGHT
  241. 16:28:26,874 (ScriptRunner.java:135) DEBUG - --
  242. 16:28:26,874 (ScriptRunner.java:141) DEBUG - --
  243. 16:28:26,874 (ScriptRunner.java:135) DEBUG - CREATE TABLE FLIGHT (
  244. 16:28:26,874 (ScriptRunner.java:135) DEBUG - F_ID BIGINT NOT NULL,
  245. 16:28:26,875 (ScriptRunner.java:135) DEBUG - F_AL_ID BIGINT NOT NULL REFERENCES AIRLINE (AL_ID),
  246. 16:28:26,875 (ScriptRunner.java:135) DEBUG - F_DEPART_AP_ID BIGINT NOT NULL REFERENCES AIRPORT (AP_ID),
  247. 16:28:26,875 (ScriptRunner.java:135) DEBUG - F_DEPART_TIME TIMESTAMP NOT NULL,
  248. 16:28:26,875 (ScriptRunner.java:135) DEBUG - F_ARRIVE_AP_ID BIGINT NOT NULL REFERENCES AIRPORT (AP_ID),
  249. 16:28:26,876 (ScriptRunner.java:135) DEBUG - F_ARRIVE_TIME TIMESTAMP NOT NULL,
  250. 16:28:26,876 (ScriptRunner.java:135) DEBUG - F_STATUS BIGINT NOT NULL,
  251. 16:28:26,876 (ScriptRunner.java:135) DEBUG - F_BASE_PRICE FLOAT NOT NULL,
  252. 16:28:26,876 (ScriptRunner.java:135) DEBUG - F_SEATS_TOTAL BIGINT NOT NULL,
  253. 16:28:26,877 (ScriptRunner.java:135) DEBUG - F_SEATS_LEFT BIGINT NOT NULL,
  254. 16:28:26,877 (ScriptRunner.java:135) DEBUG - F_IATTR00 BIGINT,
  255. 16:28:26,877 (ScriptRunner.java:135) DEBUG - F_IATTR01 BIGINT,
  256. 16:28:26,877 (ScriptRunner.java:135) DEBUG - F_IATTR02 BIGINT,
  257. 16:28:26,878 (ScriptRunner.java:135) DEBUG - F_IATTR03 BIGINT,
  258. 16:28:26,878 (ScriptRunner.java:135) DEBUG - F_IATTR04 BIGINT,
  259. 16:28:26,878 (ScriptRunner.java:135) DEBUG - F_IATTR05 BIGINT,
  260. 16:28:26,878 (ScriptRunner.java:135) DEBUG - F_IATTR06 BIGINT,
  261. 16:28:26,879 (ScriptRunner.java:135) DEBUG - F_IATTR07 BIGINT,
  262. 16:28:26,879 (ScriptRunner.java:135) DEBUG - F_IATTR08 BIGINT,
  263. 16:28:26,879 (ScriptRunner.java:135) DEBUG - F_IATTR09 BIGINT,
  264. 16:28:26,879 (ScriptRunner.java:135) DEBUG - F_IATTR10 BIGINT,
  265. 16:28:26,880 (ScriptRunner.java:135) DEBUG - F_IATTR11 BIGINT,
  266. 16:28:26,880 (ScriptRunner.java:135) DEBUG - F_IATTR12 BIGINT,
  267. 16:28:26,880 (ScriptRunner.java:135) DEBUG - F_IATTR13 BIGINT,
  268. 16:28:26,880 (ScriptRunner.java:135) DEBUG - F_IATTR14 BIGINT,
  269. 16:28:26,881 (ScriptRunner.java:135) DEBUG - F_IATTR15 BIGINT,
  270. 16:28:26,881 (ScriptRunner.java:135) DEBUG - F_IATTR16 BIGINT,
  271. 16:28:26,881 (ScriptRunner.java:135) DEBUG - F_IATTR17 BIGINT,
  272. 16:28:26,881 (ScriptRunner.java:135) DEBUG - F_IATTR18 BIGINT,
  273. 16:28:26,882 (ScriptRunner.java:135) DEBUG - F_IATTR19 BIGINT,
  274. 16:28:26,882 (ScriptRunner.java:135) DEBUG - F_IATTR20 BIGINT,
  275. 16:28:26,882 (ScriptRunner.java:135) DEBUG - F_IATTR21 BIGINT,
  276. 16:28:26,882 (ScriptRunner.java:135) DEBUG - F_IATTR22 BIGINT,
  277. 16:28:26,883 (ScriptRunner.java:135) DEBUG - F_IATTR23 BIGINT,
  278. 16:28:26,883 (ScriptRunner.java:135) DEBUG - F_IATTR24 BIGINT,
  279. 16:28:26,883 (ScriptRunner.java:135) DEBUG - F_IATTR25 BIGINT,
  280. 16:28:26,883 (ScriptRunner.java:135) DEBUG - F_IATTR26 BIGINT,
  281. 16:28:26,884 (ScriptRunner.java:135) DEBUG - F_IATTR27 BIGINT,
  282. 16:28:26,884 (ScriptRunner.java:135) DEBUG - F_IATTR28 BIGINT,
  283. 16:28:26,884 (ScriptRunner.java:135) DEBUG - F_IATTR29 BIGINT,
  284. 16:28:26,884 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (F_ID)
  285. 16:28:26,885 (ScriptRunner.java:135) DEBUG - );
  286. 16:28:26,888 (ScriptRunner.java:135) DEBUG -
  287. 16:28:26,889 (ScriptRunner.java:135) DEBUG - --
  288. 16:28:26,889 (ScriptRunner.java:141) DEBUG - --
  289. 16:28:26,889 (ScriptRunner.java:135) DEBUG - -- RESERVATION
  290. 16:28:26,889 (ScriptRunner.java:141) DEBUG - -- RESERVATION
  291. 16:28:26,889 (ScriptRunner.java:135) DEBUG - --
  292. 16:28:26,890 (ScriptRunner.java:141) DEBUG - --
  293. 16:28:26,890 (ScriptRunner.java:135) DEBUG - CREATE TABLE RESERVATION (
  294. 16:28:26,890 (ScriptRunner.java:135) DEBUG - R_ID BIGINT NOT NULL,
  295. 16:28:26,890 (ScriptRunner.java:135) DEBUG - R_C_ID BIGINT NOT NULL REFERENCES CUSTOMER (C_ID),
  296. 16:28:26,891 (ScriptRunner.java:135) DEBUG - R_F_ID BIGINT NOT NULL REFERENCES FLIGHT (F_ID),
  297. 16:28:26,891 (ScriptRunner.java:135) DEBUG - R_SEAT BIGINT NOT NULL,
  298. 16:28:26,891 (ScriptRunner.java:135) DEBUG - R_PRICE FLOAT NOT NULL,
  299. 16:28:26,891 (ScriptRunner.java:135) DEBUG - R_IATTR00 BIGINT,
  300. 16:28:26,892 (ScriptRunner.java:135) DEBUG - R_IATTR01 BIGINT,
  301. 16:28:26,892 (ScriptRunner.java:135) DEBUG - R_IATTR02 BIGINT,
  302. 16:28:26,892 (ScriptRunner.java:135) DEBUG - R_IATTR03 BIGINT,
  303. 16:28:26,892 (ScriptRunner.java:135) DEBUG - R_IATTR04 BIGINT,
  304. 16:28:26,893 (ScriptRunner.java:135) DEBUG - R_IATTR05 BIGINT,
  305. 16:28:26,893 (ScriptRunner.java:135) DEBUG - R_IATTR06 BIGINT,
  306. 16:28:26,893 (ScriptRunner.java:135) DEBUG - R_IATTR07 BIGINT,
  307. 16:28:26,893 (ScriptRunner.java:135) DEBUG - R_IATTR08 BIGINT,
  308. 16:28:26,894 (ScriptRunner.java:135) DEBUG - UNIQUE (R_F_ID, R_SEAT),
  309. 16:28:26,894 (ScriptRunner.java:135) DEBUG - PRIMARY KEY (R_ID, R_C_ID, R_F_ID)
  310. 16:28:26,894 (ScriptRunner.java:135) DEBUG - );
  311. 16:28:26,931 (Catalog.java:149) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,AIRLINE,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  312. 16:28:26,932 (Catalog.java:153) DEBUG - ORIG:AIRLINE -> CATALOG:AIRLINE
  313. 16:28:26,933 (Catalog.java:161) DEBUG - Retrieving COLUMN information for AIRLINE
  314. 16:28:27,019 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_ID [BIGINT / -5]
  315. 16:28:27,019 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATA_CODE [VARCHAR / 12]
  316. 16:28:27,020 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_ICAO_CODE [VARCHAR / 12]
  317. 16:28:27,020 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_CALL_SIGN [VARCHAR / 12]
  318. 16:28:27,021 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_NAME [VARCHAR / 12]
  319. 16:28:27,021 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_CO_ID [BIGINT / -5]
  320. 16:28:27,022 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR00 [BIGINT / -5]
  321. 16:28:27,022 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR01 [BIGINT / -5]
  322. 16:28:27,022 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR02 [BIGINT / -5]
  323. 16:28:27,023 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR03 [BIGINT / -5]
  324. 16:28:27,023 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR04 [BIGINT / -5]
  325. 16:28:27,024 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR05 [BIGINT / -5]
  326. 16:28:27,024 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR06 [BIGINT / -5]
  327. 16:28:27,024 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR07 [BIGINT / -5]
  328. 16:28:27,025 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR08 [BIGINT / -5]
  329. 16:28:27,025 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR09 [BIGINT / -5]
  330. 16:28:27,025 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR10 [BIGINT / -5]
  331. 16:28:27,026 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR11 [BIGINT / -5]
  332. 16:28:27,026 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR12 [BIGINT / -5]
  333. 16:28:27,027 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR13 [BIGINT / -5]
  334. 16:28:27,027 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR14 [BIGINT / -5]
  335. 16:28:27,027 (Catalog.java:180) DEBUG - Adding AIRLINE.AL_IATTR15 [BIGINT / -5]
  336. 16:28:27,028 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for AIRLINE
  337. 16:28:27,029 (Catalog.java:198) DEBUG - PKEY[01]: AIRLINE.AL_ID
  338. 16:28:27,030 (Catalog.java:206) DEBUG - Retrieving INDEX information for AIRLINE
  339. 16:28:27,034 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,AIRLINE,false,PUBLIC,SYS_IDX_SYS_PK_10072_10073,3,1,AL_ID,A,null,0,null,null]
  340. 16:28:27,036 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,AIRLINE,true,PUBLIC,SYS_IDX_10074,3,1,AL_CO_ID,A,null,0,null,null]
  341. 16:28:27,037 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for AIRLINE
  342. 16:28:27,039 (Catalog.java:239) DEBUG - AIRLINE => ROW[01] -> [PUBLIC,PUBLIC,COUNTRY,CO_ID,PUBLIC,PUBLIC,AIRLINE,AL_CO_ID,1,3,3,SYS_FK_10071,SYS_REF_SYS_FK_10071_10075,0]
  343. 16:28:27,040 (Catalog.java:149) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,AIRPORT,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  344. 16:28:27,041 (Catalog.java:153) DEBUG - ORIG:AIRPORT -> CATALOG:AIRPORT
  345. 16:28:27,041 (Catalog.java:161) DEBUG - Retrieving COLUMN information for AIRPORT
  346. 16:28:27,042 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_ID [BIGINT / -5]
  347. 16:28:27,043 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_CODE [VARCHAR / 12]
  348. 16:28:27,043 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_NAME [VARCHAR / 12]
  349. 16:28:27,043 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_CITY [VARCHAR / 12]
  350. 16:28:27,044 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_POSTAL_CODE [VARCHAR / 12]
  351. 16:28:27,044 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_CO_ID [BIGINT / -5]
  352. 16:28:27,044 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_LONGITUDE [DOUBLE / 8]
  353. 16:28:27,045 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_LATITUDE [DOUBLE / 8]
  354. 16:28:27,045 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_GMT_OFFSET [DOUBLE / 8]
  355. 16:28:27,046 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_WAC [BIGINT / -5]
  356. 16:28:27,046 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR00 [BIGINT / -5]
  357. 16:28:27,046 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR01 [BIGINT / -5]
  358. 16:28:27,047 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR02 [BIGINT / -5]
  359. 16:28:27,047 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR03 [BIGINT / -5]
  360. 16:28:27,047 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR04 [BIGINT / -5]
  361. 16:28:27,048 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR05 [BIGINT / -5]
  362. 16:28:27,048 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR06 [BIGINT / -5]
  363. 16:28:27,049 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR07 [BIGINT / -5]
  364. 16:28:27,049 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR08 [BIGINT / -5]
  365. 16:28:27,049 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR09 [BIGINT / -5]
  366. 16:28:27,050 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR10 [BIGINT / -5]
  367. 16:28:27,050 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR11 [BIGINT / -5]
  368. 16:28:27,050 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR12 [BIGINT / -5]
  369. 16:28:27,051 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR13 [BIGINT / -5]
  370. 16:28:27,051 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR14 [BIGINT / -5]
  371. 16:28:27,052 (Catalog.java:180) DEBUG - Adding AIRPORT.AP_IATTR15 [BIGINT / -5]
  372. 16:28:27,052 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for AIRPORT
  373. 16:28:27,053 (Catalog.java:198) DEBUG - PKEY[01]: AIRPORT.AP_ID
  374. 16:28:27,053 (Catalog.java:206) DEBUG - Retrieving INDEX information for AIRPORT
  375. 16:28:27,054 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,AIRPORT,false,PUBLIC,SYS_IDX_SYS_PK_10053_10054,3,1,AP_ID,A,null,0,null,null]
  376. 16:28:27,054 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,AIRPORT,true,PUBLIC,SYS_IDX_10055,3,1,AP_CO_ID,A,null,0,null,null]
  377. 16:28:27,054 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for AIRPORT
  378. 16:28:27,055 (Catalog.java:239) DEBUG - AIRPORT => ROW[01] -> [PUBLIC,PUBLIC,COUNTRY,CO_ID,PUBLIC,PUBLIC,AIRPORT,AP_CO_ID,1,3,3,SYS_FK_10052,SYS_REF_SYS_FK_10052_10056,0]
  379. 16:28:27,056 (Catalog.java:149) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,AIRPORT_DISTANCE,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  380. 16:28:27,056 (Catalog.java:153) DEBUG - ORIG:AIRPORT_DISTANCE -> CATALOG:AIRPORT_DISTANCE
  381. 16:28:27,056 (Catalog.java:161) DEBUG - Retrieving COLUMN information for AIRPORT_DISTANCE
  382. 16:28:27,067 (Catalog.java:180) DEBUG - Adding AIRPORT_DISTANCE.D_AP_ID0 [BIGINT / -5]
  383. 16:28:27,067 (Catalog.java:180) DEBUG - Adding AIRPORT_DISTANCE.D_AP_ID1 [BIGINT / -5]
  384. 16:28:27,068 (Catalog.java:180) DEBUG - Adding AIRPORT_DISTANCE.D_DISTANCE [DOUBLE / 8]
  385. 16:28:27,068 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for AIRPORT_DISTANCE
  386. 16:28:27,069 (Catalog.java:198) DEBUG - PKEY[01]: AIRPORT_DISTANCE.D_AP_ID0
  387. 16:28:27,069 (Catalog.java:198) DEBUG - PKEY[02]: AIRPORT_DISTANCE.D_AP_ID1
  388. 16:28:27,069 (Catalog.java:206) DEBUG - Retrieving INDEX information for AIRPORT_DISTANCE
  389. 16:28:27,070 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,AIRPORT_DISTANCE,false,PUBLIC,SYS_IDX_SYS_PK_10062_10063,3,1,D_AP_ID0,A,null,0,null,null]
  390. 16:28:27,071 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,AIRPORT_DISTANCE,false,PUBLIC,SYS_IDX_SYS_PK_10062_10063,3,2,D_AP_ID1,A,null,0,null,null]
  391. 16:28:27,071 (Catalog.java:210) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,AIRPORT_DISTANCE,true,PUBLIC,SYS_IDX_10064,3,1,D_AP_ID0,A,null,0,null,null]
  392. 16:28:27,072 (Catalog.java:210) DEBUG - ROW[04] -> [PUBLIC,PUBLIC,AIRPORT_DISTANCE,true,PUBLIC,SYS_IDX_10066,3,1,D_AP_ID1,A,null,0,null,null]
  393. 16:28:27,072 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for AIRPORT_DISTANCE
  394. 16:28:27,073 (Catalog.java:239) DEBUG - AIRPORT_DISTANCE => ROW[01] -> [PUBLIC,PUBLIC,AIRPORT,AP_ID,PUBLIC,PUBLIC,AIRPORT_DISTANCE,D_AP_ID0,1,3,3,SYS_FK_10058,SYS_REF_SYS_FK_10058_10065,0]
  395. 16:28:27,073 (Catalog.java:239) DEBUG - AIRPORT_DISTANCE => ROW[02] -> [PUBLIC,PUBLIC,AIRPORT,AP_ID,PUBLIC,PUBLIC,AIRPORT_DISTANCE,D_AP_ID1,1,3,3,SYS_FK_10060,SYS_REF_SYS_FK_10060_10067,0]
  396. 16:28:27,074 (Catalog.java:149) DEBUG - ROW[04] -> [PUBLIC,PUBLIC,CONFIG_HISTOGRAMS,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  397. 16:28:27,074 (Catalog.java:153) DEBUG - ORIG:CONFIG_HISTOGRAMS -> CATALOG:CONFIG_HISTOGRAMS
  398. 16:28:27,074 (Catalog.java:161) DEBUG - Retrieving COLUMN information for CONFIG_HISTOGRAMS
  399. 16:28:27,082 (Catalog.java:180) DEBUG - Adding CONFIG_HISTOGRAMS.CFH_NAME [VARCHAR / 12]
  400. 16:28:27,082 (Catalog.java:180) DEBUG - Adding CONFIG_HISTOGRAMS.CFH_DATA [VARCHAR / 12]
  401. 16:28:27,083 (Catalog.java:180) DEBUG - Adding CONFIG_HISTOGRAMS.CFH_IS_AIRPORT [TINYINT / -6]
  402. 16:28:27,083 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for CONFIG_HISTOGRAMS
  403. 16:28:27,084 (Catalog.java:198) DEBUG - PKEY[01]: CONFIG_HISTOGRAMS.CFH_NAME
  404. 16:28:27,084 (Catalog.java:206) DEBUG - Retrieving INDEX information for CONFIG_HISTOGRAMS
  405. 16:28:27,085 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,CONFIG_HISTOGRAMS,false,PUBLIC,SYS_IDX_SYS_PK_10039_10040,3,1,CFH_NAME,A,null,0,null,null]
  406. 16:28:27,085 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for CONFIG_HISTOGRAMS
  407. 16:28:27,086 (Catalog.java:149) DEBUG - ROW[05] -> [PUBLIC,PUBLIC,CONFIG_PROFILE,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  408. 16:28:27,086 (Catalog.java:153) DEBUG - ORIG:CONFIG_PROFILE -> CATALOG:CONFIG_PROFILE
  409. 16:28:27,087 (Catalog.java:161) DEBUG - Retrieving COLUMN information for CONFIG_PROFILE
  410. 16:28:27,094 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_SCALE_FACTOR [DOUBLE / 8]
  411. 16:28:27,095 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_AIPORT_MAX_CUSTOMER [VARCHAR / 12]
  412. 16:28:27,095 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_FLIGHT_START [TIMESTAMP / 93]
  413. 16:28:27,096 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_FLIGHT_UPCOMING [TIMESTAMP / 93]
  414. 16:28:27,096 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_FLIGHT_PAST_DAYS [INTEGER / 4]
  415. 16:28:27,096 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_FLIGHT_FUTURE_DAYS [INTEGER / 4]
  416. 16:28:27,097 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_FLIGHT_OFFSET [INTEGER / 4]
  417. 16:28:27,097 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_RESERVATION_OFFSET [INTEGER / 4]
  418. 16:28:27,097 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_NUM_RECORDS [VARCHAR / 12]
  419. 16:28:27,098 (Catalog.java:180) DEBUG - Adding CONFIG_PROFILE.CFP_CODE_IDS_XREFS [VARCHAR / 12]
  420. 16:28:27,098 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for CONFIG_PROFILE
  421. 16:28:27,098 (Catalog.java:206) DEBUG - Retrieving INDEX information for CONFIG_PROFILE
  422. 16:28:27,099 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for CONFIG_PROFILE
  423. 16:28:27,100 (Catalog.java:149) DEBUG - ROW[06] -> [PUBLIC,PUBLIC,COUNTRY,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  424. 16:28:27,100 (Catalog.java:153) DEBUG - ORIG:COUNTRY -> CATALOG:COUNTRY
  425. 16:28:27,101 (Catalog.java:161) DEBUG - Retrieving COLUMN information for COUNTRY
  426. 16:28:27,102 (Catalog.java:180) DEBUG - Adding COUNTRY.CO_ID [BIGINT / -5]
  427. 16:28:27,102 (Catalog.java:180) DEBUG - Adding COUNTRY.CO_NAME [VARCHAR / 12]
  428. 16:28:27,102 (Catalog.java:180) DEBUG - Adding COUNTRY.CO_CODE_2 [VARCHAR / 12]
  429. 16:28:27,103 (Catalog.java:180) DEBUG - Adding COUNTRY.CO_CODE_3 [VARCHAR / 12]
  430. 16:28:27,103 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for COUNTRY
  431. 16:28:27,104 (Catalog.java:198) DEBUG - PKEY[01]: COUNTRY.CO_ID
  432. 16:28:27,104 (Catalog.java:206) DEBUG - Retrieving INDEX information for COUNTRY
  433. 16:28:27,105 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,COUNTRY,false,PUBLIC,SYS_IDX_SYS_PK_10045_10046,3,1,CO_ID,A,null,0,null,null]
  434. 16:28:27,105 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for COUNTRY
  435. 16:28:27,106 (Catalog.java:149) DEBUG - ROW[07] -> [PUBLIC,PUBLIC,CUSTOMER,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  436. 16:28:27,106 (Catalog.java:153) DEBUG - ORIG:CUSTOMER -> CATALOG:CUSTOMER
  437. 16:28:27,106 (Catalog.java:161) DEBUG - Retrieving COLUMN information for CUSTOMER
  438. 16:28:27,108 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_ID [BIGINT / -5]
  439. 16:28:27,108 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_ID_STR [VARCHAR / 12]
  440. 16:28:27,109 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_BASE_AP_ID [BIGINT / -5]
  441. 16:28:27,109 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_BALANCE [DOUBLE / 8]
  442. 16:28:27,109 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR00 [VARCHAR / 12]
  443. 16:28:27,110 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR01 [VARCHAR / 12]
  444. 16:28:27,110 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR02 [VARCHAR / 12]
  445. 16:28:27,110 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR03 [VARCHAR / 12]
  446. 16:28:27,111 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR04 [VARCHAR / 12]
  447. 16:28:27,111 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR05 [VARCHAR / 12]
  448. 16:28:27,111 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR06 [VARCHAR / 12]
  449. 16:28:27,111 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR07 [VARCHAR / 12]
  450. 16:28:27,112 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR08 [VARCHAR / 12]
  451. 16:28:27,112 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR09 [VARCHAR / 12]
  452. 16:28:27,112 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR10 [VARCHAR / 12]
  453. 16:28:27,113 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR11 [VARCHAR / 12]
  454. 16:28:27,113 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR12 [VARCHAR / 12]
  455. 16:28:27,113 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR13 [VARCHAR / 12]
  456. 16:28:27,114 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR14 [VARCHAR / 12]
  457. 16:28:27,114 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR15 [VARCHAR / 12]
  458. 16:28:27,114 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR16 [VARCHAR / 12]
  459. 16:28:27,115 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR17 [VARCHAR / 12]
  460. 16:28:27,115 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR18 [VARCHAR / 12]
  461. 16:28:27,115 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_SATTR19 [VARCHAR / 12]
  462. 16:28:27,116 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR00 [BIGINT / -5]
  463. 16:28:27,116 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR01 [BIGINT / -5]
  464. 16:28:27,116 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR02 [BIGINT / -5]
  465. 16:28:27,117 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR03 [BIGINT / -5]
  466. 16:28:27,117 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR04 [BIGINT / -5]
  467. 16:28:27,117 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR05 [BIGINT / -5]
  468. 16:28:27,118 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR06 [BIGINT / -5]
  469. 16:28:27,118 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR07 [BIGINT / -5]
  470. 16:28:27,118 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR08 [BIGINT / -5]
  471. 16:28:27,119 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR09 [BIGINT / -5]
  472. 16:28:27,119 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR10 [BIGINT / -5]
  473. 16:28:27,119 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR11 [BIGINT / -5]
  474. 16:28:27,120 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR12 [BIGINT / -5]
  475. 16:28:27,120 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR13 [BIGINT / -5]
  476. 16:28:27,120 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR14 [BIGINT / -5]
  477. 16:28:27,120 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR15 [BIGINT / -5]
  478. 16:28:27,121 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR16 [BIGINT / -5]
  479. 16:28:27,121 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR17 [BIGINT / -5]
  480. 16:28:27,121 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR18 [BIGINT / -5]
  481. 16:28:27,122 (Catalog.java:180) DEBUG - Adding CUSTOMER.C_IATTR19 [BIGINT / -5]
  482. 16:28:27,122 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for CUSTOMER
  483. 16:28:27,123 (Catalog.java:198) DEBUG - PKEY[01]: CUSTOMER.C_ID
  484. 16:28:27,123 (Catalog.java:206) DEBUG - Retrieving INDEX information for CUSTOMER
  485. 16:28:27,124 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,CUSTOMER,false,PUBLIC,SYS_IDX_SYS_PK_10081_10082,3,1,C_ID,A,null,0,null,null]
  486. 16:28:27,124 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,CUSTOMER,false,PUBLIC,SYS_IDX_SYS_CT_10077_10083,3,1,C_ID_STR,A,null,0,null,null]
  487. 16:28:27,124 (Catalog.java:210) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,CUSTOMER,true,PUBLIC,SYS_IDX_10084,3,1,C_BASE_AP_ID,A,null,0,null,null]
  488. 16:28:27,125 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for CUSTOMER
  489. 16:28:27,126 (Catalog.java:239) DEBUG - CUSTOMER => ROW[01] -> [PUBLIC,PUBLIC,AIRPORT,AP_ID,PUBLIC,PUBLIC,CUSTOMER,C_BASE_AP_ID,1,3,3,SYS_FK_10079,SYS_REF_SYS_FK_10079_10085,0]
  490. 16:28:27,126 (Catalog.java:149) DEBUG - ROW[08] -> [PUBLIC,PUBLIC,FLIGHT,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  491. 16:28:27,126 (Catalog.java:153) DEBUG - ORIG:FLIGHT -> CATALOG:FLIGHT
  492. 16:28:27,126 (Catalog.java:161) DEBUG - Retrieving COLUMN information for FLIGHT
  493. 16:28:27,128 (Catalog.java:180) DEBUG - Adding FLIGHT.F_ID [BIGINT / -5]
  494. 16:28:27,128 (Catalog.java:180) DEBUG - Adding FLIGHT.F_AL_ID [BIGINT / -5]
  495. 16:28:27,129 (Catalog.java:180) DEBUG - Adding FLIGHT.F_DEPART_AP_ID [BIGINT / -5]
  496. 16:28:27,129 (Catalog.java:180) DEBUG - Adding FLIGHT.F_DEPART_TIME [TIMESTAMP / 93]
  497. 16:28:27,129 (Catalog.java:180) DEBUG - Adding FLIGHT.F_ARRIVE_AP_ID [BIGINT / -5]
  498. 16:28:27,130 (Catalog.java:180) DEBUG - Adding FLIGHT.F_ARRIVE_TIME [TIMESTAMP / 93]
  499. 16:28:27,130 (Catalog.java:180) DEBUG - Adding FLIGHT.F_STATUS [BIGINT / -5]
  500. 16:28:27,130 (Catalog.java:180) DEBUG - Adding FLIGHT.F_BASE_PRICE [DOUBLE / 8]
  501. 16:28:27,131 (Catalog.java:180) DEBUG - Adding FLIGHT.F_SEATS_TOTAL [BIGINT / -5]
  502. 16:28:27,131 (Catalog.java:180) DEBUG - Adding FLIGHT.F_SEATS_LEFT [BIGINT / -5]
  503. 16:28:27,131 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR00 [BIGINT / -5]
  504. 16:28:27,132 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR01 [BIGINT / -5]
  505. 16:28:27,132 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR02 [BIGINT / -5]
  506. 16:28:27,132 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR03 [BIGINT / -5]
  507. 16:28:27,133 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR04 [BIGINT / -5]
  508. 16:28:27,133 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR05 [BIGINT / -5]
  509. 16:28:27,133 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR06 [BIGINT / -5]
  510. 16:28:27,134 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR07 [BIGINT / -5]
  511. 16:28:27,134 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR08 [BIGINT / -5]
  512. 16:28:27,134 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR09 [BIGINT / -5]
  513. 16:28:27,135 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR10 [BIGINT / -5]
  514. 16:28:27,135 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR11 [BIGINT / -5]
  515. 16:28:27,135 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR12 [BIGINT / -5]
  516. 16:28:27,136 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR13 [BIGINT / -5]
  517. 16:28:27,136 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR14 [BIGINT / -5]
  518. 16:28:27,136 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR15 [BIGINT / -5]
  519. 16:28:27,137 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR16 [BIGINT / -5]
  520. 16:28:27,137 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR17 [BIGINT / -5]
  521. 16:28:27,137 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR18 [BIGINT / -5]
  522. 16:28:27,138 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR19 [BIGINT / -5]
  523. 16:28:27,138 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR20 [BIGINT / -5]
  524. 16:28:27,138 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR21 [BIGINT / -5]
  525. 16:28:27,139 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR22 [BIGINT / -5]
  526. 16:28:27,139 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR23 [BIGINT / -5]
  527. 16:28:27,140 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR24 [BIGINT / -5]
  528. 16:28:27,140 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR25 [BIGINT / -5]
  529. 16:28:27,140 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR26 [BIGINT / -5]
  530. 16:28:27,141 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR27 [BIGINT / -5]
  531. 16:28:27,141 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR28 [BIGINT / -5]
  532. 16:28:27,141 (Catalog.java:180) DEBUG - Adding FLIGHT.F_IATTR29 [BIGINT / -5]
  533. 16:28:27,142 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for FLIGHT
  534. 16:28:27,142 (Catalog.java:198) DEBUG - PKEY[01]: FLIGHT.F_ID
  535. 16:28:27,143 (Catalog.java:206) DEBUG - Retrieving INDEX information for FLIGHT
  536. 16:28:27,144 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,FLIGHT,false,PUBLIC,SYS_IDX_SYS_PK_10110_10111,3,1,F_ID,A,null,0,null,null]
  537. 16:28:27,144 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,FLIGHT,true,PUBLIC,SYS_IDX_10112,3,1,F_AL_ID,A,null,0,null,null]
  538. 16:28:27,144 (Catalog.java:210) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,FLIGHT,true,PUBLIC,SYS_IDX_10114,3,1,F_DEPART_AP_ID,A,null,0,null,null]
  539. 16:28:27,145 (Catalog.java:210) DEBUG - ROW[04] -> [PUBLIC,PUBLIC,FLIGHT,true,PUBLIC,SYS_IDX_10116,3,1,F_ARRIVE_AP_ID,A,null,0,null,null]
  540. 16:28:27,145 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for FLIGHT
  541. 16:28:27,146 (Catalog.java:239) DEBUG - FLIGHT => ROW[01] -> [PUBLIC,PUBLIC,AIRLINE,AL_ID,PUBLIC,PUBLIC,FLIGHT,F_AL_ID,1,3,3,SYS_FK_10099,SYS_REF_SYS_FK_10099_10113,0]
  542. 16:28:27,146 (Catalog.java:239) DEBUG - FLIGHT => ROW[02] -> [PUBLIC,PUBLIC,AIRPORT,AP_ID,PUBLIC,PUBLIC,FLIGHT,F_DEPART_AP_ID,1,3,3,SYS_FK_10101,SYS_REF_SYS_FK_10101_10115,0]
  543. 16:28:27,146 (Catalog.java:239) DEBUG - FLIGHT => ROW[03] -> [PUBLIC,PUBLIC,AIRPORT,AP_ID,PUBLIC,PUBLIC,FLIGHT,F_ARRIVE_AP_ID,1,3,3,SYS_FK_10104,SYS_REF_SYS_FK_10104_10117,0]
  544. 16:28:27,147 (Catalog.java:149) DEBUG - ROW[09] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  545. 16:28:27,147 (Catalog.java:153) DEBUG - ORIG:FREQUENT_FLYER -> CATALOG:FREQUENT_FLYER
  546. 16:28:27,147 (Catalog.java:161) DEBUG - Retrieving COLUMN information for FREQUENT_FLYER
  547. 16:28:27,157 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_C_ID [BIGINT / -5]
  548. 16:28:27,157 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_AL_ID [BIGINT / -5]
  549. 16:28:27,158 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_C_ID_STR [VARCHAR / 12]
  550. 16:28:27,158 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_SATTR00 [VARCHAR / 12]
  551. 16:28:27,158 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_SATTR01 [VARCHAR / 12]
  552. 16:28:27,159 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_SATTR02 [VARCHAR / 12]
  553. 16:28:27,159 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_SATTR03 [VARCHAR / 12]
  554. 16:28:27,159 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR00 [BIGINT / -5]
  555. 16:28:27,160 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR01 [BIGINT / -5]
  556. 16:28:27,160 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR02 [BIGINT / -5]
  557. 16:28:27,160 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR03 [BIGINT / -5]
  558. 16:28:27,161 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR04 [BIGINT / -5]
  559. 16:28:27,161 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR05 [BIGINT / -5]
  560. 16:28:27,161 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR06 [BIGINT / -5]
  561. 16:28:27,162 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR07 [BIGINT / -5]
  562. 16:28:27,162 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR08 [BIGINT / -5]
  563. 16:28:27,162 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR09 [BIGINT / -5]
  564. 16:28:27,163 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR10 [BIGINT / -5]
  565. 16:28:27,163 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR11 [BIGINT / -5]
  566. 16:28:27,163 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR12 [BIGINT / -5]
  567. 16:28:27,164 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR13 [BIGINT / -5]
  568. 16:28:27,164 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR14 [BIGINT / -5]
  569. 16:28:27,164 (Catalog.java:180) DEBUG - Adding FREQUENT_FLYER.FF_IATTR15 [BIGINT / -5]
  570. 16:28:27,164 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for FREQUENT_FLYER
  571. 16:28:27,165 (Catalog.java:198) DEBUG - PKEY[01]: FREQUENT_FLYER.FF_C_ID
  572. 16:28:27,165 (Catalog.java:198) DEBUG - PKEY[02]: FREQUENT_FLYER.FF_AL_ID
  573. 16:28:27,165 (Catalog.java:206) DEBUG - Retrieving INDEX information for FREQUENT_FLYER
  574. 16:28:27,166 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,false,PUBLIC,SYS_IDX_SYS_PK_10091_10092,3,1,FF_C_ID,A,null,0,null,null]
  575. 16:28:27,167 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,false,PUBLIC,SYS_IDX_SYS_PK_10091_10092,3,2,FF_AL_ID,A,null,0,null,null]
  576. 16:28:27,167 (Catalog.java:210) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,true,PUBLIC,SYS_IDX_10093,3,1,FF_C_ID,A,null,0,null,null]
  577. 16:28:27,167 (Catalog.java:210) DEBUG - ROW[04] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,true,PUBLIC,SYS_IDX_10095,3,1,FF_AL_ID,A,null,0,null,null]
  578. 16:28:27,168 (Catalog.java:210) DEBUG - ROW[05] -> [PUBLIC,PUBLIC,FREQUENT_FLYER,true,PUBLIC,IDX_FF_CUSTOMER_ID,3,1,FF_C_ID_STR,A,null,0,null,null]
  579. 16:28:27,168 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for FREQUENT_FLYER
  580. 16:28:27,169 (Catalog.java:239) DEBUG - FREQUENT_FLYER => ROW[01] -> [PUBLIC,PUBLIC,AIRLINE,AL_ID,PUBLIC,PUBLIC,FREQUENT_FLYER,FF_AL_ID,1,3,3,SYS_FK_10089,SYS_REF_SYS_FK_10089_10096,0]
  581. 16:28:27,169 (Catalog.java:239) DEBUG - FREQUENT_FLYER => ROW[02] -> [PUBLIC,PUBLIC,CUSTOMER,C_ID,PUBLIC,PUBLIC,FREQUENT_FLYER,FF_C_ID,1,3,3,SYS_FK_10087,SYS_REF_SYS_FK_10087_10094,0]
  582. 16:28:27,170 (Catalog.java:149) DEBUG - ROW[10] -> [PUBLIC,PUBLIC,RESERVATION,TABLE,null,null,null,null,null,null,MEMORY,false,null]
  583. 16:28:27,170 (Catalog.java:153) DEBUG - ORIG:RESERVATION -> CATALOG:RESERVATION
  584. 16:28:27,170 (Catalog.java:161) DEBUG - Retrieving COLUMN information for RESERVATION
  585. 16:28:27,171 (Catalog.java:180) DEBUG - Adding RESERVATION.R_ID [BIGINT / -5]
  586. 16:28:27,172 (Catalog.java:180) DEBUG - Adding RESERVATION.R_C_ID [BIGINT / -5]
  587. 16:28:27,172 (Catalog.java:180) DEBUG - Adding RESERVATION.R_F_ID [BIGINT / -5]
  588. 16:28:27,172 (Catalog.java:180) DEBUG - Adding RESERVATION.R_SEAT [BIGINT / -5]
  589. 16:28:27,173 (Catalog.java:180) DEBUG - Adding RESERVATION.R_PRICE [DOUBLE / 8]
  590. 16:28:27,173 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR00 [BIGINT / -5]
  591. 16:28:27,173 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR01 [BIGINT / -5]
  592. 16:28:27,174 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR02 [BIGINT / -5]
  593. 16:28:27,174 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR03 [BIGINT / -5]
  594. 16:28:27,174 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR04 [BIGINT / -5]
  595. 16:28:27,174 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR05 [BIGINT / -5]
  596. 16:28:27,175 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR06 [BIGINT / -5]
  597. 16:28:27,175 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR07 [BIGINT / -5]
  598. 16:28:27,175 (Catalog.java:180) DEBUG - Adding RESERVATION.R_IATTR08 [BIGINT / -5]
  599. 16:28:27,176 (Catalog.java:187) DEBUG - Retrieving PRIMARY KEY information for RESERVATION
  600. 16:28:27,176 (Catalog.java:198) DEBUG - PKEY[01]: RESERVATION.R_ID
  601. 16:28:27,177 (Catalog.java:198) DEBUG - PKEY[02]: RESERVATION.R_C_ID
  602. 16:28:27,177 (Catalog.java:198) DEBUG - PKEY[03]: RESERVATION.R_F_ID
  603. 16:28:27,177 (Catalog.java:206) DEBUG - Retrieving INDEX information for RESERVATION
  604. 16:28:27,178 (Catalog.java:210) DEBUG - ROW[01] -> [PUBLIC,PUBLIC,RESERVATION,false,PUBLIC,SYS_IDX_SYS_PK_10126_10127,3,1,R_ID,A,null,0,null,null]
  605. 16:28:27,178 (Catalog.java:210) DEBUG - ROW[02] -> [PUBLIC,PUBLIC,RESERVATION,false,PUBLIC,SYS_IDX_SYS_PK_10126_10127,3,2,R_C_ID,A,null,0,null,null]
  606. 16:28:27,179 (Catalog.java:210) DEBUG - ROW[03] -> [PUBLIC,PUBLIC,RESERVATION,false,PUBLIC,SYS_IDX_SYS_PK_10126_10127,3,3,R_F_ID,A,null,0,null,null]
  607. 16:28:27,179 (Catalog.java:210) DEBUG - ROW[04] -> [PUBLIC,PUBLIC,RESERVATION,false,PUBLIC,SYS_IDX_SYS_CT_10125_10132,3,1,R_F_ID,A,null,0,null,null]
  608. 16:28:27,179 (Catalog.java:210) DEBUG - ROW[05] -> [PUBLIC,PUBLIC,RESERVATION,false,PUBLIC,SYS_IDX_SYS_CT_10125_10132,3,2,R_SEAT,A,null,0,null,null]
  609. 16:28:27,180 (Catalog.java:210) DEBUG - ROW[06] -> [PUBLIC,PUBLIC,RESERVATION,true,PUBLIC,SYS_IDX_10128,3,1,R_C_ID,A,null,0,null,null]
  610. 16:28:27,180 (Catalog.java:210) DEBUG - ROW[07] -> [PUBLIC,PUBLIC,RESERVATION,true,PUBLIC,SYS_IDX_10130,3,1,R_F_ID,A,null,0,null,null]
  611. 16:28:27,180 (Catalog.java:234) DEBUG - Retrieving FOREIGN KEY information for RESERVATION
  612. 16:28:27,181 (Catalog.java:239) DEBUG - RESERVATION => ROW[01] -> [PUBLIC,PUBLIC,CUSTOMER,C_ID,PUBLIC,PUBLIC,RESERVATION,R_C_ID,1,3,3,SYS_FK_10120,SYS_REF_SYS_FK_10120_10129,0]
  613. 16:28:27,182 (Catalog.java:239) DEBUG - RESERVATION => ROW[02] -> [PUBLIC,PUBLIC,FLIGHT,F_ID,PUBLIC,PUBLIC,RESERVATION,R_F_ID,1,3,3,SYS_FK_10122,SYS_REF_SYS_FK_10122_10131,0]
  614. 16:28:27,186 (Catalog.java:254) DEBUG - Foreign Key Mappings:
  615. CUSTOMER: C_BASE_AP_ID: <AIRPORT, AP_ID>
  616. CONFIG_HISTOGRAMS:
  617. FLIGHT: F_ARRIVE_AP_ID: <AIRPORT, AP_ID>
  618. F_AL_ID: <AIRLINE, AL_ID>
  619. F_DEPART_AP_ID: <AIRPORT, AP_ID>
  620. COUNTRY:
  621. CONFIG_PROFILE:
  622. AIRPORT_DISTANCE: D_AP_ID0: <AIRPORT, AP_ID>
  623. D_AP_ID1: <AIRPORT, AP_ID>
  624. FREQUENT_FLYER: FF_AL_ID: <AIRLINE, AL_ID>
  625. FF_C_ID: <CUSTOMER, C_ID>
  626. RESERVATION: R_C_ID: <CUSTOMER, C_ID>
  627. R_F_ID: <FLIGHT, F_ID>
  628. AIRPORT: AP_CO_ID: <COUNTRY, CO_ID>
  629. AIRLINE: AL_CO_ID: <COUNTRY, CO_ID>
  630.  
  631. 16:28:27,186 (Catalog.java:274) DEBUG - CUSTOMER.C_BASE_AP_ID -> AIRPORT.AP_ID
  632. 16:28:27,187 (Catalog.java:274) DEBUG - FLIGHT.F_ARRIVE_AP_ID -> AIRPORT.AP_ID
  633. 16:28:27,187 (Catalog.java:274) DEBUG - FLIGHT.F_AL_ID -> AIRLINE.AL_ID
  634. 16:28:27,187 (Catalog.java:274) DEBUG - FLIGHT.F_DEPART_AP_ID -> AIRPORT.AP_ID
  635. 16:28:27,187 (Catalog.java:274) DEBUG - AIRPORT_DISTANCE.D_AP_ID0 -> AIRPORT.AP_ID
  636. 16:28:27,188 (Catalog.java:274) DEBUG - AIRPORT_DISTANCE.D_AP_ID1 -> AIRPORT.AP_ID
  637. 16:28:27,188 (Catalog.java:274) DEBUG - FREQUENT_FLYER.FF_AL_ID -> AIRLINE.AL_ID
  638. 16:28:27,188 (Catalog.java:274) DEBUG - FREQUENT_FLYER.FF_C_ID -> CUSTOMER.C_ID
  639. 16:28:27,189 (Catalog.java:274) DEBUG - RESERVATION.R_C_ID -> CUSTOMER.C_ID
  640. 16:28:27,189 (Catalog.java:274) DEBUG - RESERVATION.R_F_ID -> FLIGHT.F_ID
  641. 16:28:27,189 (Catalog.java:274) DEBUG - AIRPORT.AP_CO_ID -> COUNTRY.CO_ID
  642. 16:28:27,190 (Catalog.java:274) DEBUG - AIRLINE.AL_CO_ID -> COUNTRY.CO_ID
  643. 16:28:27,191 (BenchmarkModule.java:172) WARN - Failed to find SQL Dialect XML file 'seats-dialects.xml'
  644. 16:28:27,192 (StatementDialects.java:61) WARN - DatabaseType is null. Not loading StatementDialect XML
  645. 16:28:27,208 (DBWorkload.java:222) DEBUG - Using the following transaction types: [Invalid/00, DeleteReservation/01, FindFlights/02, FindOpenSeats/03, NewReservation/04, UpdateCustomer/05, UpdateReservation/06]
  646. 16:28:27,208 (DBWorkload.java:235) DEBUG - Skipping creating benchmark database tables
  647. 16:28:27,208 (DBWorkload.java:245) DEBUG - Skipping creating benchmark database tables
  648. 16:28:27,209 (DBWorkload.java:256) DEBUG - Skipping loading benchmark database records
  649. 16:28:27,209 (DBWorkload.java:327) DEBUG - CommandLine has option 'execute'. Checking whether set to true
  650. 16:28:27,209 (DBWorkload.java:329) DEBUG - CommandLine execute => true
  651. 16:28:27,209 (DBWorkload.java:301) INFO - Creating 1 virtual terminals ..
  652. 16:28:27,445 (Procedure.java:44) DEBUG - Initialized Invalid with 0 SQLStmts: []
  653. 16:28:27,447 (Procedure.java:44) DEBUG - Initialized DeleteReservation with 7 SQLStmts: [UpdateCustomer, GetCustomerByIdStr, GetCustomerReservation, UpdateFrequentFlyer, DeleteReservation, UpdateFlight, GetCustomerByFFNumber]
  654. 16:28:27,448 (Procedure.java:44) DEBUG - Initialized FindFlights with 5 SQLStmts: [GetFlights1, GetFlights2, GetFlights3, GetAirportInfo, GetNearbyAirports]
  655. 16:28:27,449 (Procedure.java:44) DEBUG - Initialized FindOpenSeats with 2 SQLStmts: [GetFlight, GetSeats]
  656. 16:28:27,449 (Procedure.java:44) DEBUG - Initialized NewReservation with 8 SQLStmts: [InsertReservation, UpdateCustomer, CheckCustomer, GetFlight, GetCustomer, UpdateFrequentFlyer, CheckSeat, UpdateFlight]
  657. 16:28:27,450 (Procedure.java:44) DEBUG - Initialized UpdateCustomer with 6 SQLStmts: [UpdateCustomer, GetCustomer, GetCustomerIdStr, UpdatFrequentFlyers, GetFrequentFlyers, GetBaseAirport]
  658. 16:28:27,451 (Procedure.java:44) DEBUG - Initialized UpdateReservation with 6 SQLStmts: [ReserveSeat2, ReserveSeat1, ReserveSeat3, CheckCustomer, CheckSeat, ReserveSeat0]
  659. 16:28:27,456 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  660. 16:28:27,456 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  661. 16:28:27,457 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  662. 16:28:27,457 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  663. 16:28:27,457 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  664. 16:28:27,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  665. 16:28:27,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  666. 16:28:27,458 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  667. 16:28:27,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  668. 16:28:27,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  669. 16:28:27,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  670. 16:28:27,459 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  671. 16:28:27,460 (DBWorkload.java:304) INFO - Launching the seats Benchmark with 1 Phases...
  672. [Starting Phase] [Time= 60] [Rate= 30] [Ratios= [10.0, 10.0, 35.0, 20.0, 10.0, 15.0]]
  673. 16:28:27,480 (SEATSProfile.java:290) DEBUG - Loading SEATSProfile for the first time
  674. 16:28:27,527 (SEATSProfile.java:347) DEBUG - Loaded CONFIG_PROFILE data
  675. 16:28:27,840 (SEATSProfile.java:368) DEBUG - Loaded CONFIG_HISTOGRAMS data
  676. 16:28:27,846 (SEATSProfile.java:379) DEBUG - Loaded 248 xrefs for CO_CODE_3 -> CO_ID
  677. 16:28:27,852 (SEATSProfile.java:379) DEBUG - Loaded 286 xrefs for AP_CODE -> AP_ID
  678. 16:28:27,892 (SEATSProfile.java:379) DEBUG - Loaded 971 xrefs for AL_IATA_CODE -> AL_ID
  679. 16:28:39,420 (SEATSProfile.java:391) DEBUG - Loaded 9999 cached FlightIds
  680. 16:28:39,421 (SEATSProfile.java:182) DEBUG - Added COUNTRY mapping from Code Column 'CO_CODE_3' to Id Column 'CO_ID'
  681. 16:28:39,421 (SEATSProfile.java:182) DEBUG - Added AIRPORT mapping from Code Column 'AP_CODE' to Id Column 'AP_ID'
  682. 16:28:39,421 (SEATSProfile.java:182) DEBUG - Added AIRLINE mapping from Code Column 'AL_IATA_CODE' to Id Column 'AL_ID'
  683. 16:28:39,422 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from CUSTOMER.C_BASE_AP_ID to AIRPORT.AP_ID
  684. 16:28:39,422 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_AL_ID to AIRLINE.AL_ID
  685. 16:28:39,422 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_DEPART_AP_ID to AIRPORT.AP_ID
  686. 16:28:39,422 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FLIGHT.F_ARRIVE_AP_ID to AIRPORT.AP_ID
  687. 16:28:39,423 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID0 to AIRPORT.AP_ID
  688. 16:28:39,423 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT_DISTANCE.D_AP_ID1 to AIRPORT.AP_ID
  689. 16:28:39,423 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from FREQUENT_FLYER.FF_AL_ID to AIRLINE.AL_ID
  690. 16:28:39,424 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRPORT.AP_CO_ID to COUNTRY.CO_ID
  691. 16:28:39,424 (SEATSProfile.java:199) DEBUG - Added ForeignKey mapping from AIRLINE.AL_CO_ID to COUNTRY.CO_ID
  692. 16:28:39,459 (FindOpenSeats.java:123) DEBUG - Flight 2475010032858694537 - SQL[334.40] <-> JAVA[334.40] [basePrice=330.000000, total=150, left=148]
  693. 16:28:39,460 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475010032858694537 / rid 8300452 / seat 0
  694. 16:28:39,460 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475010032858694537 / rid 8300453 / seat 1
  695. 16:28:39,466 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=905,depart=18,arrive=131,date=8793} [totalPendingInserts=148]
  696. 16:28:39,467 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  697. 16:28:39,493 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  698. 16:28:39,550 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  699. 16:28:39,550 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  700. 16:28:39,551 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  701. 16:28:39,551 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=148]
  702. 16:28:39,600 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580798695 [seatsLeft=147]
  703. 16:28:39,601 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  704. 16:28:39,601 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  705. 16:28:39,658 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  706. 16:28:39,658 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  707. 16:28:39,658 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=147]
  708. 16:28:39,695 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580794525 [seatsLeft=146]
  709. 16:28:39,696 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  710. 16:28:39,696 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  711. 16:28:39,697 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=753,depart=143,arrive=245,date=8798} as look up in FindFlights: 2476417897376711409 / 2013-01-20
  712. 16:28:46,102 (FindFlights.java:184) DEBUG - Flight 2467410698121970328 / Interair South Africa / JFK -> SFO / 2013-01-20
  713. 16:28:46,104 (FindFlights.java:184) DEBUG - Flight 2467692173098680381 / Air India Express / JFK -> SFO / 2013-01-20
  714. 16:28:46,106 (FindFlights.java:184) DEBUG - Flight 2467692173098681469 / TAAG Angola Airlines / JFK -> SFO / 2013-01-20
  715. 16:28:46,107 (FindFlights.java:184) DEBUG - Flight 2469381022958944975 / KLM / JFK -> SFO / 2013-01-20
  716. 16:28:46,109 (FindFlights.java:184) DEBUG - Flight 2469943972912365975 / Champion Air / JFK -> SFO / 2013-01-20
  717. 16:28:46,111 (FindFlights.java:184) DEBUG - Flight 2470225447889077135 / Pacific East Asia Cargo Airlines / JFK -> SFO / 2013-01-20
  718. 16:28:46,112 (FindFlights.java:184) DEBUG - Flight 2470225447889077463 / Xiamen Airlines / JFK -> SFO / 2013-01-20
  719. 16:28:46,114 (FindFlights.java:184) DEBUG - Flight 2470788397842498226 / JAL Express / JFK -> SFO / 2013-01-20
  720. 16:28:46,116 (FindFlights.java:184) DEBUG - Flight 2471351347795919981 / Transavia Holland / JFK -> SFO / 2013-01-20
  721. 16:28:46,117 (FindFlights.java:184) DEBUG - Flight 2474166097563026041 / Hemus Air / JFK -> SFO / 2013-01-20
  722. 16:28:46,119 (FindFlights.java:184) DEBUG - Flight 2474447572539736834 / Lebanese Air Transport / JFK -> SFO / 2013-01-21
  723. 16:28:46,121 (FindFlights.java:184) DEBUG - Flight 2475291997469868296 / Air Madagascar / JFK -> SFO / 2013-01-21
  724. 16:28:46,122 (FindFlights.java:184) DEBUG - Flight 2475291997469868477 / Condor Flugdienst / JFK -> SFO / 2013-01-21
  725. 16:28:46,124 (FindFlights.java:184) DEBUG - Flight 2476136422400000262 / Air Luxor / JFK -> SFO / 2013-01-21
  726. 16:28:46,126 (FindFlights.java:184) DEBUG - Flight 2476136422400000547 / Faso Airways / JFK -> SFO / 2013-01-21
  727. 16:28:46,127 (FindFlights.java:184) DEBUG - Flight 2476417897376711021 / Brussels Airlines / JFK -> SFO / 2013-01-21
  728. 16:28:46,129 (FindFlights.java:184) DEBUG - Flight 2476417897376711409 / LACSA / JFK -> SFO / 2013-01-21
  729. 16:28:46,150 (FindFlights.java:184) DEBUG - Flight 2476417897376711531 / Northwestern Air / JFK -> SFO / 2013-01-21
  730. 16:28:46,152 (FindFlights.java:184) DEBUG - Flight 2476417897376711615 / RAK Airways / JFK -> SFO / 2013-01-21
  731. 16:28:46,154 (FindFlights.java:184) DEBUG - Flight 2476980847330133119 / Tradewind Aviation / JFK -> SFO / 2013-01-21
  732. 16:28:46,155 (FindFlights.java:184) DEBUG - Flight 2477262322306843830 / VRG Linhas Aereas / JFK -> SFO / 2013-01-21
  733. 16:28:46,157 (FindFlights.java:184) DEBUG - Flight 2477825272260264603 / Interisland Airways Limited / JFK -> SFO / 2013-01-21
  734. 16:28:46,159 (FindFlights.java:184) DEBUG - Flight 2478106747236975337 / Kuwait Airways / JFK -> SFO / 2013-01-21
  735. 16:28:46,160 (FindFlights.java:184) DEBUG - Flight 2478669697190396575 / Interstate Airline / JFK -> SFO / 2013-01-21
  736. 16:28:46,161 (FindFlights.java:189) DEBUG - Flight Information:
  737. [[Ljava.lang.Object;@427be8c2, [Ljava.lang.Object;@54ee3aa7, [Ljava.lang.Object;@644cd580, [Ljava.lang.Object;@7054f9f1, [Ljava.lang.Object;@5ae576d4, [Ljava.lang.Object;@edc86eb, [Ljava.lang.Object;@301db5ec, [Ljava.lang.Object;@6e92b1a1, [Ljava.lang.Object;@60cbf9bd, [Ljava.lang.Object;@6f7918f0, [Ljava.lang.Object;@77546dbc, [Ljava.lang.Object;@47f08ed8, [Ljava.lang.Object;@2322bce, [Ljava.lang.Object;@2bd9e282, [Ljava.lang.Object;@6da5db4b, [Ljava.lang.Object;@23e0512a, [Ljava.lang.Object;@5bf0aecc, [Ljava.lang.Object;@1664023c, [Ljava.lang.Object;@7fcebc9f, [Ljava.lang.Object;@5dc1ac46, [Ljava.lang.Object;@561557c0, [Ljava.lang.Object;@13342a67, [Ljava.lang.Object;@45cbda0a, [Ljava.lang.Object;@4a57ea52]
  738. 16:28:46,161 (SEATSWorker.java:591) DEBUG - Added 9 out of 24 FlightIds to local cache
  739. 16:28:46,186 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  740. 16:28:46,187 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  741. 16:28:46,187 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=146]
  742. 16:28:46,215 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580797629 [seatsLeft=145]
  743. 16:28:46,216 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  744. 16:28:46,216 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  745. 16:28:46,261 (DeleteReservation.java:158) DEBUG - Deleted reservation on flight 2475010032858694537 for customer 5066549580797629 [seatsLeft=146]
  746. 16:28:46,262 (SEATSWorker.java:415) DEBUG - Executed a new invocation of DeleteReservation
  747. 16:28:46,262 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  748. 16:28:46,305 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  749. 16:28:46,305 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  750. 16:28:46,306 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=146]
  751. 16:28:46,332 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580796685 [seatsLeft=145]
  752. 16:28:46,332 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  753. 16:28:46,333 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  754. 16:28:46,346 (SEATSWorker.java:409) DEBUG - UpdateReservation Aborted
  755. com.oltpbenchmark.api.Procedure$UserAbortException: E0004 Customer 2475010032858694537 does not have an existing reservation on flight #5066549580796685
  756. at com.oltpbenchmark.benchmarks.seats.procedures.UpdateReservation.run(UpdateReservation.java:113)
  757. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.executeUpdateReservation(SEATSWorker.java:801)
  758. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.executeWork(SEATSWorker.java:401)
  759. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.doWork(SEATSWorker.java:354)
  760. at com.oltpbenchmark.api.Worker.run(Worker.java:128)
  761. at java.lang.Thread.run(Thread.java:636)
  762. 16:28:46,347 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  763. 16:28:46,359 (FindOpenSeats.java:123) DEBUG - Flight 2476135859755352794 - SQL[773.12] <-> JAVA[773.12] [basePrice=768.000000, total=150, left=149]
  764. 16:28:46,359 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476135859755352794 / rid 8315010 / seat 0
  765. 16:28:46,367 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=730,depart=83,arrive=114,date=8797} [totalPendingInserts=294]
  766. 16:28:46,368 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  767. 16:28:46,368 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  768. 16:28:46,370 (FindOpenSeats.java:123) DEBUG - Flight 2475854041186959746 - SQL[260.00] <-> JAVA[260.00] [basePrice=260.000000, total=150, left=150]
  769. 16:28:46,374 (SEATSWorker.java:666) DEBUG - Stored 150 pending inserts for FlightId{airline=386,depart=170,arrive=34,date=8796} [totalPendingInserts=444]
  770. 16:28:46,374 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  771. 16:28:46,374 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  772. 16:28:46,375 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  773. 16:28:46,375 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  774. 16:28:46,381 (FindOpenSeats.java:123) DEBUG - Flight 2474447525286773252 - SQL[413.00] <-> JAVA[413.00] [basePrice=413.000000, total=150, left=150]
  775. 16:28:46,389 (SEATSWorker.java:666) DEBUG - Stored 150 pending inserts for FlightId{airline=516,depart=16,arrive=234,date=8791} [totalPendingInserts=594]
  776. 16:28:46,389 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  777. 16:28:46,390 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  778. 16:28:46,391 (FindOpenSeats.java:123) DEBUG - Flight 2475009796644406256 - SQL[988.55] <-> JAVA[988.55] [basePrice=982.000000, total=150, left=149]
  779. 16:28:46,391 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475009796644406256 / rid 8317831 / seat 0
  780. 16:28:46,395 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=1008,depart=154,arrive=76,date=8793} [totalPendingInserts=743]
  781. 16:28:46,396 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  782. 16:28:46,396 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  783. 16:28:46,404 (FindOpenSeats.java:123) DEBUG - Flight 2476417300380123639 - SQL[513.76] <-> JAVA[513.76] [basePrice=507.000000, total=150, left=148]
  784. 16:28:46,404 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417300380123639 / rid 8316380 / seat 0
  785. 16:28:46,404 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417300380123639 / rid 8316381 / seat 1
  786. 16:28:46,411 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=503,depart=202,arrive=106,date=8798} [totalPendingInserts=891]
  787. 16:28:46,411 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  788. 16:28:46,412 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  789. 16:28:52,812 (FindFlights.java:184) DEBUG - Flight 381680424914387990 / Syrian Arab Airlines / MSN -> DTW / 2012-03-17
  790. 16:28:52,813 (FindFlights.java:184) DEBUG - Flight 388154349378732929 / Ostfriesische Lufttransport / MSN -> DTW / 2012-03-18
  791. 16:28:52,815 (FindFlights.java:184) DEBUG - Flight 389843199238996629 / Insel Air International / MSN -> DTW / 2012-03-18
  792. 16:28:52,817 (FindFlights.java:184) DEBUG - Flight 390124674215706715 / Aegean Airlines / MSN -> DTW / 2012-03-18
  793. 16:28:52,818 (FindFlights.java:184) DEBUG - Flight 390687624169128789 / Navegacion Servicios Aereos Canarios SA / MSN -> DTW / 2012-03-18
  794. 16:28:52,819 (FindFlights.java:189) DEBUG - Flight Information:
  795. [[Ljava.lang.Object;@747917a, [Ljava.lang.Object;@6b9fe451, [Ljava.lang.Object;@4e46b90a, [Ljava.lang.Object;@51e67ac, [Ljava.lang.Object;@f284fd4]
  796. 16:28:52,819 (SEATSWorker.java:591) DEBUG - Added 4 out of 5 FlightIds to local cache
  797. 16:28:52,844 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  798. 16:28:52,844 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  799. 16:28:52,845 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=891]
  800. 16:28:52,863 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580796904 [seatsLeft=144]
  801. 16:28:52,864 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  802. 16:28:52,864 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  803. 16:28:52,865 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=917,depart=202,arrive=12,date=8795} as look up in FindFlights: 2475572471723066261 / 2013-01-20
  804. 16:28:59,268 (FindFlights.java:184) DEBUG - Flight 2462343147817665303 / Luhansk / ORD -> ALB / 2013-01-19
  805. 16:28:59,269 (FindFlights.java:184) DEBUG - Flight 2464594947631349842 / ABX Air / ORD -> ALB / 2013-01-19
  806. 16:28:59,271 (FindFlights.java:184) DEBUG - Flight 2468254122328588602 / Aero-Charter Ukraine / ORD -> ALB / 2013-01-20
  807. 16:28:59,272 (FindFlights.java:184) DEBUG - Flight 2469380022235431410 / East African Safari Air / ORD -> ALB / 2013-01-20
  808. 16:28:59,274 (FindFlights.java:184) DEBUG - Flight 2469380022235432123 / Volga Aviaexpress / ORD -> ALB / 2013-01-20
  809. 16:28:59,276 (FindFlights.java:184) DEBUG - Flight 2469661497212142023 / Corsairfly / ORD -> ALB / 2013-01-20
  810. 16:28:59,277 (FindFlights.java:184) DEBUG - Flight 2469942972188853143 / Pan American Airways / ORD -> ALB / 2013-01-20
  811. 16:28:59,279 (FindFlights.java:184) DEBUG - Flight 2471631822049116165 / Aero Asia International / ORD -> ALB / 2013-01-20
  812. 16:28:59,279 (FindFlights.java:189) DEBUG - Flight Information:
  813. [[Ljava.lang.Object;@1f90ef12, [Ljava.lang.Object;@643f96ee, [Ljava.lang.Object;@ace16ad, [Ljava.lang.Object;@6032bd65, [Ljava.lang.Object;@2330633a, [Ljava.lang.Object;@3dc286e2, [Ljava.lang.Object;@2e257f1b, [Ljava.lang.Object;@1fbbdd48]
  814. 16:28:59,279 (SEATSWorker.java:591) DEBUG - Added 3 out of 8 FlightIds to local cache
  815. 16:28:59,305 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  816. 16:28:59,305 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  817. 16:28:59,306 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  818. 16:28:59,306 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=1090,depart=18,arrive=192,date=8793} as look up in FindFlights: 2475010294851699778 / 2013-01-20
  819. 16:29:05,778 (FindFlights.java:189) DEBUG - Flight Information:
  820. []
  821. 16:29:05,804 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  822. 16:29:05,804 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  823. 16:29:05,806 (FindOpenSeats.java:123) DEBUG - Flight 2474447602611192458 - SQL[268.26] <-> JAVA[268.26] [basePrice=263.000000, total=150, left=147]
  824. 16:29:05,807 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447602611192458 / rid 8321339 / seat 0
  825. 16:29:05,807 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447602611192458 / rid 8321340 / seat 1
  826. 16:29:05,807 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447602611192458 / rid 8321341 / seat 2
  827. 16:29:05,811 (SEATSWorker.java:666) DEBUG - Stored 147 pending inserts for FlightId{airline=650,depart=245,arrive=252,date=8791} [totalPendingInserts=1037]
  828. 16:29:05,811 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  829. 16:29:05,812 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  830. 16:29:05,814 (FindOpenSeats.java:123) DEBUG - Flight 2476417583847309505 - SQL[284.89] <-> JAVA[284.89] [basePrice=283.000000, total=150, left=149]
  831. 16:29:05,814 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417583847309505 / rid 8300196 / seat 0
  832. 16:29:05,818 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=193,depart=192,arrive=172,date=8798} [totalPendingInserts=1186]
  833. 16:29:05,818 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  834. 16:29:05,819 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  835. 16:29:05,835 (FindOpenSeats.java:123) DEBUG - Flight 2475010200374870457 - SQL[425.34] <-> JAVA[425.34] [basePrice=417.000000, total=150, left=147]
  836. 16:29:05,835 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475010200374870457 / rid 8320941 / seat 0
  837. 16:29:05,835 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475010200374870457 / rid 8320942 / seat 1
  838. 16:29:05,835 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475010200374870457 / rid 8320943 / seat 2
  839. 16:29:05,841 (SEATSWorker.java:666) DEBUG - Stored 147 pending inserts for FlightId{airline=441,depart=208,arrive=170,date=8793} [totalPendingInserts=1333]
  840. 16:29:05,841 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  841. 16:29:05,841 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  842. 16:29:05,844 (DeleteReservation.java:158) DEBUG - Deleted reservation on flight 2475010032858694537 for customer 5066549580796904 [seatsLeft=145]
  843. 16:29:05,845 (SEATSWorker.java:415) DEBUG - Executed a new invocation of DeleteReservation
  844. 16:29:05,845 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  845. 16:29:05,846 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  846. 16:29:05,846 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  847. 16:29:05,847 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=589,depart=148,arrive=44,date=8792} as look up in FindFlights: 2474728184228348493 / 2013-01-20
  848. 16:29:12,248 (FindFlights.java:184) DEBUG - Flight 2460654435392816190 / Slovak Airlines / LAS -> BUR / 2013-01-19
  849. 16:29:12,250 (FindFlights.java:184) DEBUG - Flight 2462906235206501329 / Royal Air Force of Oman / LAS -> BUR / 2013-01-19
  850. 16:29:12,252 (FindFlights.java:184) DEBUG - Flight 2463469185159922656 / Ryanair / LAS -> BUR / 2013-01-19
  851. 16:29:12,253 (FindFlights.java:184) DEBUG - Flight 2463750660136632859 / Executive Airlines / LAS -> BUR / 2013-01-19
  852. 16:29:12,255 (FindFlights.java:184) DEBUG - Flight 2464313610090054611 / Royal Airlines / LAS -> BUR / 2013-01-19
  853. 16:29:12,257 (FindFlights.java:184) DEBUG - Flight 2464595085066764910 / Hawkair / LAS -> BUR / 2013-01-19
  854. 16:29:12,258 (FindFlights.java:184) DEBUG - Flight 2464595085066765480 / Volga-Dnepr Airlines / LAS -> BUR / 2013-01-19
  855. 16:29:12,260 (FindFlights.java:184) DEBUG - Flight 2467409834833871860 / Safair / LAS -> BUR / 2013-01-20
  856. 16:29:12,262 (FindFlights.java:184) DEBUG - Flight 2467691309810581809 / Aircompany Yakutia / LAS -> BUR / 2013-01-20
  857. 16:29:12,264 (FindFlights.java:184) DEBUG - Flight 2467691309810582194 / JAL Express / LAS -> BUR / 2013-01-20
  858. 16:29:12,265 (FindFlights.java:184) DEBUG - Flight 2467972784787292423 / Air Mauritius / LAS -> BUR / 2013-01-20
  859. 16:29:12,267 (FindFlights.java:184) DEBUG - Flight 2467972784787293108 / Primaris Airlines / LAS -> BUR / 2013-01-20
  860. 16:29:12,268 (FindFlights.java:184) DEBUG - Flight 2468535734740714550 / SkyKing Turks and Caicos Airways / LAS -> BUR / 2013-01-20
  861. 16:29:12,270 (FindFlights.java:184) DEBUG - Flight 2468817209717425063 / Phoenix Airways / LAS -> BUR / 2013-01-20
  862. 16:29:12,272 (FindFlights.java:184) DEBUG - Flight 2469098684694135711 / Pegasus Airlines / LAS -> BUR / 2013-01-20
  863. 16:29:12,273 (FindFlights.java:184) DEBUG - Flight 2469380159670845996 / First Cambodia Airlines / LAS -> BUR / 2013-01-20
  864. 16:29:12,275 (FindFlights.java:184) DEBUG - Flight 2469661634647556764 / Interlink Airlines / LAS -> BUR / 2013-01-20
  865. 16:29:12,277 (FindFlights.java:184) DEBUG - Flight 2469661634647557335 / Xiamen Airlines / LAS -> BUR / 2013-01-20
  866. 16:29:12,280 (FindFlights.java:184) DEBUG - Flight 2469943109624267365 / Haiti Ambassador Airlines / LAS -> BUR / 2013-01-20
  867. 16:29:12,282 (FindFlights.java:184) DEBUG - Flight 2470787534554399305 / Gambia International Airlines / LAS -> BUR / 2013-01-20
  868. 16:29:12,283 (FindFlights.java:184) DEBUG - Flight 2471069009531110507 / Taquan Air Services / LAS -> BUR / 2013-01-20
  869. 16:29:12,284 (FindFlights.java:189) DEBUG - Flight Information:
  870. [[Ljava.lang.Object;@6e5a3923, [Ljava.lang.Object;@655d616e, [Ljava.lang.Object;@55a7b0bf, [Ljava.lang.Object;@7444f787, [Ljava.lang.Object;@5bd6fbb3, [Ljava.lang.Object;@7f26d3df, [Ljava.lang.Object;@4e2016b0, [Ljava.lang.Object;@1cb1a4e2, [Ljava.lang.Object;@52c00025, [Ljava.lang.Object;@3b49a794, [Ljava.lang.Object;@609903f4, [Ljava.lang.Object;@5dd2b9b7, [Ljava.lang.Object;@359ecd80, [Ljava.lang.Object;@4cc5aa00, [Ljava.lang.Object;@451c0d60, [Ljava.lang.Object;@34b23d12, [Ljava.lang.Object;@21c783c5, [Ljava.lang.Object;@319c0bd6, [Ljava.lang.Object;@7bcd280b, [Ljava.lang.Object;@5a0029ac, [Ljava.lang.Object;@40b0095d]
  871. 16:29:12,284 (SEATSWorker.java:591) DEBUG - Added 11 out of 21 FlightIds to local cache
  872. 16:29:12,309 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  873. 16:29:12,310 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  874. 16:29:12,314 (FindOpenSeats.java:123) DEBUG - Flight 2474447250417582428 - SQL[672.47] <-> JAVA[672.47] [basePrice=655.000000, total=150, left=146]
  875. 16:29:12,314 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447250417582428 / rid 8317687 / seat 0
  876. 16:29:12,314 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447250417582428 / rid 8317688 / seat 1
  877. 16:29:12,315 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447250417582428 / rid 8317689 / seat 2
  878. 16:29:12,315 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474447250417582428 / rid 8317690 / seat 3
  879. 16:29:12,319 (SEATSWorker.java:666) DEBUG - Stored 146 pending inserts for FlightId{airline=348,depart=149,arrive=170,date=8791} [totalPendingInserts=1480]
  880. 16:29:12,320 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  881. 16:29:12,320 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  882. 16:29:12,321 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  883. 16:29:12,321 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=1480]
  884. 16:29:12,358 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580792893 [seatsLeft=144]
  885. 16:29:12,359 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  886. 16:29:12,359 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  887. 16:29:12,381 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  888. 16:29:12,381 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  889. 16:29:12,417 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  890. 16:29:12,418 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  891. 16:29:12,433 (FindOpenSeats.java:123) DEBUG - Flight 2476136340800012298 - SQL[654.16] <-> JAVA[654.16] [basePrice=629.000000, total=150, left=144]
  892. 16:29:12,433 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313370 / seat 0
  893. 16:29:12,434 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313371 / seat 1
  894. 16:29:12,434 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313372 / seat 2
  895. 16:29:12,434 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313373 / seat 3
  896. 16:29:12,434 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313374 / seat 4
  897. 16:29:12,434 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136340800012298 / rid 8313375 / seat 5
  898. 16:29:12,439 (SEATSWorker.java:666) DEBUG - Stored 144 pending inserts for FlightId{airline=10,depart=210,arrive=226,date=8797} [totalPendingInserts=1623]
  899. 16:29:12,440 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  900. 16:29:12,440 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  901. 16:29:12,442 (FindOpenSeats.java:123) DEBUG - Flight 2475291271622034174 - SQL[517.43] <-> JAVA[517.43] [basePrice=514.000000, total=150, left=149]
  902. 16:29:12,442 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291271622034174 / rid 8318200 / seat 0
  903. 16:29:12,447 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=766,depart=168,arrive=76,date=8794} [totalPendingInserts=1772]
  904. 16:29:12,447 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  905. 16:29:12,447 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  906. 16:29:12,449 (FindOpenSeats.java:123) DEBUG - Flight 2475854152845689506 - SQL[458.03] <-> JAVA[458.03] [basePrice=452.000000, total=150, left=148]
  907. 16:29:12,449 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475854152845689506 / rid 8311793 / seat 0
  908. 16:29:12,449 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475854152845689506 / rid 8311794 / seat 1
  909. 16:29:12,456 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=674,depart=11,arrive=60,date=8796} [totalPendingInserts=1920]
  910. 16:29:12,457 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  911. 16:29:12,457 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  912. 16:29:12,469 (FindOpenSeats.java:123) DEBUG - Flight 2474446709247050569 - SQL[205.00] <-> JAVA[205.00] [basePrice=205.000000, total=150, left=150]
  913. 16:29:12,483 (SEATSWorker.java:666) DEBUG - Stored 150 pending inserts for FlightId{airline=841,depart=78,arrive=44,date=8791} [totalPendingInserts=2070]
  914. 16:29:12,483 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  915. 16:29:12,483 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  916. 16:29:12,484 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=275,depart=18,arrive=126,date=8796} as look up in FindFlights: 2475854436313989395 / 2013-01-20
  917. 16:29:18,954 (FindFlights.java:184) DEBUG - Flight 2467973136966091515 / LTU International / AUS -> HOU / 2013-01-20
  918. 16:29:18,956 (FindFlights.java:184) DEBUG - Flight 2468536086919513100 / Saudi Arabian Airlines / AUS -> HOU / 2013-01-20
  919. 16:29:18,957 (FindFlights.java:184) DEBUG - Flight 2469380511849645122 / Sterling Airlines / AUS -> HOU / 2013-01-20
  920. 16:29:18,959 (FindFlights.java:184) DEBUG - Flight 2471069361709908119 / Airlines of Tasmania / AUS -> HOU / 2013-01-20
  921. 16:29:18,960 (FindFlights.java:184) DEBUG - Flight 2471069361709909173 / Virgin Blue / AUS -> HOU / 2013-01-20
  922. 16:29:18,962 (FindFlights.java:184) DEBUG - Flight 2475854436313989395 / Aerolineas Sosa / AUS -> HOU / 2013-01-21
  923. 16:29:18,964 (FindFlights.java:184) DEBUG - Flight 2475854436313990250 / Trans American Airlines / AUS -> HOU / 2013-01-21
  924. 16:29:18,965 (FindFlights.java:184) DEBUG - Flight 2476417386267411516 / Sierra National Airlines / AUS -> HOU / 2013-01-21
  925. 16:29:18,967 (FindFlights.java:184) DEBUG - Flight 2476980336220832648 / PB Air / AUS -> HOU / 2013-01-21
  926. 16:29:18,967 (FindFlights.java:189) DEBUG - Flight Information:
  927. [[Ljava.lang.Object;@5159e154, [Ljava.lang.Object;@63d87b85, [Ljava.lang.Object;@19958bf9, [Ljava.lang.Object;@2918958e, [Ljava.lang.Object;@d02b2b6, [Ljava.lang.Object;@2c22d166, [Ljava.lang.Object;@21e1962d, [Ljava.lang.Object;@614a75bb, [Ljava.lang.Object;@5f7779e3]
  928. 16:29:18,967 (SEATSWorker.java:591) DEBUG - Added 5 out of 9 FlightIds to local cache
  929. 16:29:18,993 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  930. 16:29:18,993 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  931. 16:29:18,993 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  932. 16:29:19,028 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  933. 16:29:19,029 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  934. 16:29:19,030 (FindOpenSeats.java:123) DEBUG - Flight 2474446833796842244 - SQL[658.67] <-> JAVA[658.67] [basePrice=650.000000, total=150, left=148]
  935. 16:29:19,031 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474446833796842244 / rid 8301657 / seat 0
  936. 16:29:19,031 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474446833796842244 / rid 8301658 / seat 1
  937. 16:29:19,036 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=772,depart=13,arrive=73,date=8791} [totalPendingInserts=2218]
  938. 16:29:19,036 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  939. 16:29:19,036 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  940. 16:29:19,037 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  941. 16:29:19,048 (FindOpenSeats.java:123) DEBUG - Flight 2475291310266778243 - SQL[135.20] <-> JAVA[135.20] [basePrice=130.000000, total=150, left=144]
  942. 16:29:19,049 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319790 / seat 0
  943. 16:29:19,049 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319791 / seat 1
  944. 16:29:19,049 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319792 / seat 2
  945. 16:29:19,049 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319793 / seat 3
  946. 16:29:19,049 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319794 / seat 4
  947. 16:29:19,050 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778243 / rid 8319795 / seat 5
  948. 16:29:19,054 (SEATSWorker.java:666) DEBUG - Stored 144 pending inserts for FlightId{airline=643,depart=16,arrive=85,date=8794} [totalPendingInserts=2362]
  949. 16:29:19,055 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  950. 16:29:19,055 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  951. 16:29:19,057 (FindOpenSeats.java:123) DEBUG - Flight 2476136465356882798 - SQL[691.58] <-> JAVA[691.58] [basePrice=687.000000, total=150, left=149]
  952. 16:29:19,057 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476136465356882798 / rid 8301843 / seat 0
  953. 16:29:19,066 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=878,depart=253,arrive=255,date=8797} [totalPendingInserts=2511]
  954. 16:29:19,067 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  955. 16:29:19,067 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  956. 16:29:19,096 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  957. 16:29:19,096 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  958. 16:29:19,098 (FindOpenSeats.java:123) DEBUG - Flight 2475291997472686567 - SQL[362.40] <-> JAVA[362.40] [basePrice=360.000000, total=150, left=149]
  959. 16:29:19,098 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291997472686567 / rid 8303814 / seat 0
  960. 16:29:19,103 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=487,depart=186,arrive=245,date=8794} [totalPendingInserts=2660]
  961. 16:29:19,104 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  962. 16:29:19,104 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  963. 16:29:19,105 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  964. 16:29:19,105 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  965. 16:29:19,105 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=2660]
  966. 16:29:19,134 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580792276 [seatsLeft=143]
  967. 16:29:19,135 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  968. 16:29:19,135 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  969. 16:29:19,136 (FindOpenSeats.java:123) DEBUG - Flight 2474446850976908142 - SQL[580.64] <-> JAVA[580.64] [basePrice=573.000000, total=150, left=148]
  970. 16:29:19,137 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474446850976908142 / rid 8313956 / seat 0
  971. 16:29:19,137 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2474446850976908142 / rid 8313957 / seat 1
  972. 16:29:19,142 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=878,depart=16,arrive=77,date=8791} [totalPendingInserts=2807]
  973. 16:29:19,143 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  974. 16:29:19,143 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  975. 16:29:19,144 (FindOpenSeats.java:123) DEBUG - Flight 2476417820069593549 - SQL[119.87] <-> JAVA[119.87] [basePrice=116.000000, total=150, left=145]
  976. 16:29:19,144 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321973 / seat 0
  977. 16:29:19,145 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321974 / seat 1
  978. 16:29:19,145 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321975 / seat 2
  979. 16:29:19,145 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321976 / seat 3
  980. 16:29:19,145 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321977 / seat 4
  981. 16:29:19,151 (SEATSWorker.java:666) DEBUG - Stored 145 pending inserts for FlightId{airline=461,depart=178,arrive=227,date=8798} [totalPendingInserts=2952]
  982. 16:29:19,151 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  983. 16:29:19,151 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  984. 16:29:19,152 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  985. 16:29:19,152 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=1117,depart=252,arrive=250,date=8794} as look up in FindFlights: 2475292018951849053 / 2013-01-20
  986. 16:29:25,580 (FindFlights.java:184) DEBUG - Flight 2460936795139605717 / Wuhan Airlines / SLC -> SJC / 2013-01-19
  987. 16:29:25,582 (FindFlights.java:184) DEBUG - Flight 2462907119976579909 / Moskovia Airlines / SLC -> SJC / 2013-01-19
  988. 16:29:25,584 (FindFlights.java:184) DEBUG - Flight 2468536619510792891 / Jazeera Airways / SLC -> SJC / 2013-01-20
  989. 16:29:25,585 (FindFlights.java:184) DEBUG - Flight 2471069894301188120 / Air Gabon / SLC -> SJC / 2013-01-20
  990. 16:29:25,587 (FindFlights.java:184) DEBUG - Flight 2471069894301188829 / Khors Aircompany / SLC -> SJC / 2013-01-20
  991. 16:29:25,587 (FindFlights.java:189) DEBUG - Flight Information:
  992. [[Ljava.lang.Object;@175bc6c8, [Ljava.lang.Object;@a578073, [Ljava.lang.Object;@76b20352, [Ljava.lang.Object;@20f8395f, [Ljava.lang.Object;@87e9ce2]
  993. 16:29:25,588 (SEATSWorker.java:591) DEBUG - Added 5 out of 5 FlightIds to local cache
  994. 16:29:25,613 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  995. 16:29:25,613 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  996. 16:29:25,642 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  997. 16:29:25,642 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  998. 16:29:25,643 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  999. 16:29:25,645 (FindOpenSeats.java:123) DEBUG - Flight 2475573094485197460 - SQL[617.09] <-> JAVA[617.09] [basePrice=613.000000, total=150, left=149]
  1000. 16:29:25,645 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475573094485197460 / rid 8306870 / seat 0
  1001. 16:29:25,658 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=660,depart=78,arrive=157,date=8795} [totalPendingInserts=3101]
  1002. 16:29:25,659 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1003. 16:29:25,659 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1004. 16:29:25,661 (FindOpenSeats.java:123) DEBUG - Flight 2475291310266778133 - SQL[388.57] <-> JAVA[388.57] [basePrice=386.000000, total=150, left=149]
  1005. 16:29:25,661 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475291310266778133 / rid 8301785 / seat 0
  1006. 16:29:25,667 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=533,depart=16,arrive=85,date=8794} [totalPendingInserts=3250]
  1007. 16:29:25,667 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1008. 16:29:25,668 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  1009. 16:29:25,668 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1010. 16:29:25,670 (FindOpenSeats.java:123) DEBUG - Flight 2474165302989817042 - SQL[382.00] <-> JAVA[382.00] [basePrice=382.000000, total=150, left=150]
  1011. 16:29:25,677 (SEATSWorker.java:666) DEBUG - Stored 150 pending inserts for FlightId{airline=1234,depart=78,arrive=60,date=8790} [totalPendingInserts=3400]
  1012. 16:29:25,678 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1013. 16:29:25,678 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1014. 16:29:25,678 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3400]
  1015. 16:29:25,683 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580792268 [seatsLeft=142]
  1016. 16:29:25,684 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1017. 16:29:25,684 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1018. 16:29:25,684 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3399]
  1019. 16:29:25,707 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580796265 [seatsLeft=141]
  1020. 16:29:25,708 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1021. 16:29:25,708 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1022. 16:29:25,710 (FindOpenSeats.java:123) DEBUG - Flight 2476417940328153341 - SQL[366.83] <-> JAVA[366.83] [basePrice=362.000000, total=150, left=148]
  1023. 16:29:25,710 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417940328153341 / rid 8299966 / seat 0
  1024. 16:29:25,711 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417940328153341 / rid 8299967 / seat 1
  1025. 16:29:25,717 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=253,depart=170,arrive=255,date=8798} [totalPendingInserts=3546]
  1026. 16:29:25,717 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1027. 16:29:25,717 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  1028. 16:29:25,718 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1029. 16:29:25,720 (FindOpenSeats.java:123) DEBUG - Flight 2475854556574122130 - SQL[702.24] <-> JAVA[702.24] [basePrice=693.000000, total=150, left=148]
  1030. 16:29:25,720 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475854556574122130 / rid 8307380 / seat 0
  1031. 16:29:25,720 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2475854556574122130 / rid 8307381 / seat 1
  1032. 16:29:25,727 (SEATSWorker.java:666) DEBUG - Stored 148 pending inserts for FlightId{airline=146,depart=34,arrive=154,date=8796} [totalPendingInserts=3694]
  1033. 16:29:25,727 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1034. 16:29:25,727 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  1035. 16:29:25,728 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  1036. 16:29:25,777 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  1037. 16:29:25,777 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1038. 16:29:25,777 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3694]
  1039. 16:29:25,796 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580793732 [seatsLeft=140]
  1040. 16:29:25,797 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1041. 16:29:25,797 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1042. 16:29:25,797 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3693]
  1043. 16:29:25,802 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580792259 [seatsLeft=139]
  1044. 16:29:25,803 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1045. 16:29:25,803 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  1046. 16:29:25,804 (SEATSWorker.java:375) DEBUG - Executing UpdateCustomer
  1047. 16:29:25,816 (SEATSWorker.java:415) DEBUG - Executed a new invocation of UpdateCustomer
  1048. 16:29:25,816 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1049. 16:29:25,816 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3692]
  1050. 16:29:25,829 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580793952 [seatsLeft=138]
  1051. 16:29:25,830 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1052. 16:29:25,830 (SEATSWorker.java:375) DEBUG - Executing DeleteReservation
  1053. 16:29:25,838 (DeleteReservation.java:158) DEBUG - Deleted reservation on flight 2475010032858694537 for customer 5066549580793732 [seatsLeft=139]
  1054. 16:29:25,838 (SEATSWorker.java:415) DEBUG - Executed a new invocation of DeleteReservation
  1055. 16:29:25,838 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1056. 16:29:25,840 (FindOpenSeats.java:123) DEBUG - Flight 2476417820069593549 - SQL[119.87] <-> JAVA[119.87] [basePrice=116.000000, total=150, left=145]
  1057. 16:29:25,840 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321973 / seat 0
  1058. 16:29:25,840 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321974 / seat 1
  1059. 16:29:25,841 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321975 / seat 2
  1060. 16:29:25,841 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321976 / seat 3
  1061. 16:29:25,841 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417820069593549 / rid 8321977 / seat 4
  1062. 16:29:25,848 (SEATSWorker.java:666) DEBUG - Stored 145 pending inserts for FlightId{airline=461,depart=178,arrive=227,date=8798} [totalPendingInserts=3837]
  1063. 16:29:25,848 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1064. 16:29:25,848 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1065. 16:29:25,849 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3837]
  1066. 16:29:25,854 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580797037 [seatsLeft=138]
  1067. 16:29:25,854 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1068. 16:29:25,855 (SEATSWorker.java:375) DEBUG - Executing FindOpenSeats
  1069. 16:29:25,856 (FindOpenSeats.java:123) DEBUG - Flight 2476417815771480553 - SQL[862.71] <-> JAVA[862.71] [basePrice=857.000000, total=150, left=149]
  1070. 16:29:25,856 (FindOpenSeats.java:132) DEBUG - Reserved Seat: fid 2476417815771480553 / rid 8316848 / seat 0
  1071. 16:29:25,863 (SEATSWorker.java:666) DEBUG - Stored 149 pending inserts for FlightId{airline=489,depart=130,arrive=226,date=8798} [totalPendingInserts=3985]
  1072. 16:29:25,864 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindOpenSeats
  1073. 16:29:25,864 (SEATSWorker.java:375) DEBUG - Executing NewReservation
  1074. 16:29:25,864 (SEATSWorker.java:689) DEBUG - Attempting to get a new pending insert Reservation [totalPendingInserts=3985]
  1075. 16:29:25,880 (NewReservation.java:203) DEBUG - Reserved new seat on flight 2475010032858694537 for customer 5066549580792509 [seatsLeft=137]
  1076. 16:29:25,880 (SEATSWorker.java:415) DEBUG - Executed a new invocation of NewReservation
  1077. 16:29:25,881 (SEATSWorker.java:375) DEBUG - Executing UpdateReservation
  1078. 16:29:25,882 (SEATSWorker.java:409) DEBUG - UpdateReservation Aborted
  1079. com.oltpbenchmark.api.Procedure$UserAbortException: E0004 Customer 2475010032858694537 does not have an existing reservation on flight #5066549580797037
  1080. at com.oltpbenchmark.benchmarks.seats.procedures.UpdateReservation.run(UpdateReservation.java:113)
  1081. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.executeUpdateReservation(SEATSWorker.java:801)
  1082. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.executeWork(SEATSWorker.java:401)
  1083. at com.oltpbenchmark.benchmarks.seats.SEATSWorker.doWork(SEATSWorker.java:354)
  1084. at com.oltpbenchmark.api.Worker.run(Worker.java:128)
  1085. at java.lang.Thread.run(Thread.java:636)
  1086. 16:29:25,883 (SEATSWorker.java:375) DEBUG - Executing FindFlights
  1087. 16:29:25,883 (SEATSWorker.java:565) DEBUG - Using FlightId{airline=943,depart=69,arrive=202,date=8798} as look up in FindFlights: 2476417712688268207 / 2013-01-20
  1088. 16:29:27,558 (BenchmarkState.java:104) DEBUG - .
  1089. [Terminate] Waiting for all terminals to finish ..
  1090. 16:29:32,273 (FindFlights.java:184) DEBUG - Flight 2468536413340369346 / Continental Express / CVG -> ORD / 2013-01-20
  1091. 16:29:32,275 (FindFlights.java:184) DEBUG - Flight 2469380838270500966 / Ariana Afghan Airlines / CVG -> ORD / 2013-01-20
  1092. 16:29:32,276 (FindFlights.java:184) DEBUG - Flight 2469662313247211997 / Deer Jet / CVG -> ORD / 2013-01-20
  1093. 16:29:32,278 (FindFlights.java:184) DEBUG - Flight 2474165912874582485 / DHL International / CVG -> ORD / 2013-01-20
  1094. 16:29:32,279 (FindFlights.java:184) DEBUG - Flight 2474165912874582678 / InteliJet Airways / CVG -> ORD / 2013-01-21
  1095. 16:29:32,281 (FindFlights.java:184) DEBUG - Flight 2474447387851293511 / Mount Cook Airlines / CVG -> ORD / 2013-01-21
  1096. 16:29:32,282 (FindFlights.java:184) DEBUG - Flight 2475291812781425888 / Zip / CVG -> ORD / 2013-01-21
  1097. 16:29:32,284 (FindFlights.java:184) DEBUG - Flight 2475573287758135662 / Binter Canarias / CVG -> ORD / 2013-01-21
  1098. 16:29:32,285 (FindFlights.java:184) DEBUG - Flight 2475854762734847190 / XL Airways France / CVG -> ORD / 2013-01-21
  1099. 16:29:32,287 (FindFlights.java:184) DEBUG - Flight 2476136237711557307 / Jazeera Airways / CVG -> ORD / 2013-01-21
  1100. 16:29:32,289 (FindFlights.java:184) DEBUG - Flight 2476417712688267289 / Air Japan / CVG -> ORD / 2013-01-21
  1101. 16:29:32,290 (FindFlights.java:184) DEBUG - Flight 2476417712688268207 / Porter Airlines / CVG -> ORD / 2013-01-21
  1102. 16:29:32,292 (FindFlights.java:184) DEBUG - Flight 2476699187664978861 / Polynesian Airlines / CVG -> ORD / 2013-01-21
  1103. 16:29:32,293 (FindFlights.java:184) DEBUG - Flight 2477825087571821517 / Rossiya / CVG -> ORD / 2013-01-21
  1104. 16:29:32,295 (FindFlights.java:184) DEBUG - Flight 2478106562548531416 / Aero Airlines / CVG -> ORD / 2013-01-21
  1105. 16:29:32,296 (FindFlights.java:184) DEBUG - Flight 2478388037525241921 / Air Niugini / CVG -> ORD / 2013-01-21
  1106. 16:29:32,297 (FindFlights.java:189) DEBUG - Flight Information:
  1107. [[Ljava.lang.Object;@5567d7fb, [Ljava.lang.Object;@1494cb8b, [Ljava.lang.Object;@34bf1d3b, [Ljava.lang.Object;@6f18278a, [Ljava.lang.Object;@1acc0e01, [Ljava.lang.Object;@4aab7165, [Ljava.lang.Object;@3da1c42f, [Ljava.lang.Object;@47570945, [Ljava.lang.Object;@2321b59a, [Ljava.lang.Object;@7a19a37a, [Ljava.lang.Object;@293bdd36, [Ljava.lang.Object;@19381960, [Ljava.lang.Object;@3209fa8f, [Ljava.lang.Object;@2d20dbf3, [Ljava.lang.Object;@484845aa, [Ljava.lang.Object;@d5c0f9]
  1108. 16:29:32,297 (SEATSWorker.java:591) DEBUG - Added 8 out of 16 FlightIds to local cache
  1109. 16:29:32,322 (SEATSWorker.java:415) DEBUG - Executed a new invocation of FindFlights
  1110. 16:29:32,322 (BenchmarkState.java:104) DEBUG - .
  1111. 16:29:32,360 (DBWorkload.java:308) INFO - **********************************************************************************
  1112. 16:29:32,361 (DBWorkload.java:309) INFO - Rate limited reqs/s: Results(nanoSeconds=60040006479, measuredRequests=120) = 1.9986673392843823 requests/sec
  1113. 16:29:32,361 (DBWorkload.java:265) INFO - **********************************************************************************
  1114. 16:29:32,361 (DBWorkload.java:269) INFO - Output into file: /tmp/seats.res
  1115. 16:29:32,361 (DBWorkload.java:272) INFO - Output Raw data into file: /tmp/seats.raw
  1116. 16:29:32,362 (DBWorkload.java:277) INFO - Grouped into Buckets of 1 seconds
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!