免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › 数据库技术 › Informix › informix7.3.1UD5备份问题
12下一页
最近访问板块 发新帖
查看: 6219 | 回复: 10
打印 上一主题 下一主题

informix7.3.1UD5备份问题 [复制链接]

fringker

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2011-01-10 12:56 |只看该作者 |倒序浏览
数据库版本7.3.1 UD5 ，操作系统HPUX11.11 双机MC,采用DP做数据备份。 逻辑日志满了后自动备份。
刚开始的时候好好的，逻辑日志和0级备份都没问题，后来随着数据量越来越大，会出现有时候0级备份无法做的问题，但有时候就能成功。

下面是onbar（bar_act.log）相关日志。

0级备份能做成功的时候的日志:
  1. 2011-01-03 01:17:29 5526  5524 /usr/informix/bin/onbar_d -b -L 0
  2. 2011-01-03 01:17:30 5526  5524 Begin level 0 backup rootdbs.
  3. 2011-01-03 01:17:30 5526  5524 Successfully connected to Storage Manager.
  4. 2011-01-03 01:20:39 5526  5524 Completed level 0 backup rootdbs.
  5. 2011-01-03 01:20:42 9234  5526 Process 9234  5526 successfully forked.
  6. 2011-01-03 01:20:43 9233  5526 Process 9233  5526 successfully forked.
  7. 2011-01-03 01:20:43 9234  5526 Begin level 0 backup workdbs.
  8. 2011-01-03 01:20:43 9234  5526 Successfully connected to Storage Manager.
  9. 2011-01-03 01:20:44 9233  5526 Begin level 0 backup logdbs.
  10. 2011-01-03 01:20:44 9233  5526 Successfully connected to Storage Manager.
  11. 2011-01-03 01:20:44 9233  5526 Completed level 0 backup logdbs.
  12. 2011-01-03 01:20:46 9233  5526 Process 9233  5526 completed.
  13. 2011-01-03 02:26:11 9234  5526 Completed level 0 backup workdbs.
  14. 2011-01-03 02:26:15 9234  5526 Process 9234  5526 completed.
复制代码
fringker

论坛徽章:
0
2楼 [报告]
发表于 2011-01-10 12:58 |只看该作者
本帖最后由 fringker 于 2011-01-10 13:02 编辑

0级备份不能成功的时候的日志，有几种情况：
  1. 2011-01-03 20:25:01 8547  8545 /usr/informix/bin/onbar_d -b -L 0
  2. 2011-01-03 20:25:03 8547  8545 Begin level 0 backup rootdbs.
  3. 2011-01-03 20:25:03 8547  8545 Successfully connected to Storage Manager.
  4. 2011-01-03 20:27:49 8547  8545 Completed level 0 backup rootdbs.
  5. 2011-01-03 20:27:51 11571  8547 Process 11571  8547 successfully forked.
  6. 2011-01-03 20:27:52 11571  8547 Begin level 0 backup logdbs.
  7. 2011-01-03 20:27:52 11571  8547 Successfully connected to Storage Manager.
  8. 2011-01-03 20:27:52 11571  8547 Completed level 0 backup logdbs.
  9. 2011-01-03 20:27:53 11572  8547 Process 11572  8547 successfully forked.
  10. [color=Red] 2011-01-03 20:27:55 11572  8547 Begin level 0 backup workdbs.
  11. 2011-01-03 20:27:55 11572  8547 Successfully connected to Storage Manager.
  12. 2011-01-03 20:27:55 11571  8547 Process 11571  8547 completed.
  13. [color=Red]2011-01-03 22:46:03 8547  8545 Process 8547 received signal 3. Process will exit after cleanup.[/color]
  14. 2011-01-03 22:46:03 11572  8547 Process 11572 received signal 3. Process will exit after cleanup.
  15. 2011-01-03 22:46:03 11572  8547 Process 11639 received signal 3. Process will exit after cleanup.
  16. 2011-01-03 22:46:05 8547  8545 Process 8547 received signal 15. Process will exit after cleanup.[/color]
  17. 2011-01-03 23:45:13 12901  12899 /usr/informix/bin/onbar_d -l
  18. 2011-01-03 23:45:14 12901  12899 Begin backup logical log 50491.
  19. 2011-01-03 23:45:14 12901  12899 Successfully connected to Storage Manager.
  20. 2011-01-03 23:59:55 27977  27975 /usr/informix/bin/onbar_d -l
  21. 2011-01-03 23:59:55 27977  27975 WARNING: A log backup is already running. Can't start another.
  22. 2011-01-04 00:00:00 27977  27975 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  23. 2011-01-04 00:10:16 8428  8426 /usr/informix/bin/onbar_d -l
  24. 2011-01-04 00:10:16 8428  8426 WARNING: A log backup is already running. Can't start another.
  25. 2011-01-04 00:10:21 8428  8426 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  26. 2011-01-04 00:16:29 14168  14166 /usr/informix/bin/onbar_d -l
  27. 2011-01-04 00:16:29 14168  14166 WARNING: A log backup is already running. Can't start another.
  28. 2011-01-04 00:16:34 14168  14166 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  29. 2011-01-04 00:19:41 16701  16695 /usr/informix/bin/onbar_d -l
  30. 2011-01-04 00:19:41 16701  16695 WARNING: A log backup is already running. Can't start another.
  31. 2011-01-04 00:19:46 16701  16695 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  32. 2011-01-04 00:23:59 21631  21629 /usr/informix/bin/onbar_d -l
  33. 2011-01-04 00:23:59 21631  21629 WARNING: A log backup is already running. Can't start another.
  34. 2011-01-04 00:24:04 21631  21629 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  35. 2011-01-04 00:24:34 22195  22193 /usr/informix/bin/onbar_d -l
  36. 2011-01-04 00:24:34 22195  22193 WARNING: A log backup is already running. Can't start another.
  37. 2011-01-04 00:24:39 22195  22193 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  38. 2011-01-04 00:24:59 22682  22680 /usr/informix/bin/onbar_d -l
  39. 2011-01-04 00:25:00 22682  22680 WARNING: A log backup is already running. Can't start another.
  40. 2011-01-04 00:25:05 22682  22680 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  41. [color=Red] 2011-01-04 00:45:41 12901  12899 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.[/color]
  42. 2011-01-04 00:45:46 12901  12899 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  43. 2011-01-04 00:51:10 21572  21570 /usr/informix/bin/onbar_d -l
  44. 2011-01-04 00:51:10 21572  21570 Begin backup logical log 50491.
  45. 2011-01-04 00:51:10 21572  21570 Successfully connected to Storage Manager.
  46. 2011-01-04 01:51:37 21572  21570 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  47. 2011-01-04 01:51:42 21572  21570 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  48. 2011-01-04 04:18:49 13962  13960 /usr/informix/bin/onbar_d -b -L 0
  49. 2011-01-04 04:18:51 13962  13960 Begin level 0 backup rootdbs.
  50. 2011-01-04 04:18:51 13962  13960 Successfully connected to Storage Manager.
  51. 2011-01-04 04:22:38 18279  18277 /usr/informix/bin/onbar_d -l
  52. 2011-01-04 04:22:38 18279  18277 Begin backup logical log 50491.
  53. 2011-01-04 04:22:38 18279  18277 Successfully connected to Storage Manager.
  54. 2011-01-04 04:22:51 13962  13960 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  55. 2011-01-04 04:22:52 13962  13960 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  56. 2011-01-04 05:23:05 18279  18277 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  57. 2011-01-04 05:23:11 18279  18277 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  58. 2011-01-04 08:45:45 11582  11579 /usr/informix/bin/onbar_d -l
  59. 2011-01-04 08:45:46 11582  11579 Begin backup logical log 50491.
  60. 2011-01-04 08:45:46 11582  11579 Successfully connected to Storage Manager.
  61. 2011-01-04 08:59:28 26827  26825 /usr/informix/bin/onbar_d -l
  62. 2011-01-04 08:59:29 26827  26825 WARNING: A log backup is already running. Can't start another.
  63. 2011-01-04 08:59:34 26827  26825 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  64. 2011-01-04 09:40:14 13197  13195 /usr/informix/bin/onbar_d -l
  65. [color=Red] 2011-01-04 09:40:14 13197  13195 WARNING: A log backup is already running. Can't start another.
  66. 2011-01-04 09:40:19 13197  13195 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  67. 2011-01-04 09:46:14 11582  11579 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.[/color]
  68. 2011-01-04 09:46:19 11582  11579 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  69. 2011-01-04 10:02:09 8213  8211 /usr/informix/bin/onbar_d -l
  70. 2011-01-04 10:02:09 8213  8211 Begin backup logical log 50491.
  71. 2011-01-04 10:02:09 8213  8211 Successfully connected to Storage Manager.
  72. 2011-01-04 10:48:35 124  122 /usr/informix/bin/onbar_d -l
  73. 2011-01-04 10:48:35 124  122 WARNING: A log backup is already running. Can't start another.
  74. 2011-01-04 10:48:40 124  122 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  75. 2011-01-04 11:02:36 8213  8211 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  76. 2011-01-04 11:02:41 8213  8211 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  77. 2011-01-04 11:11:18 25071  25069 /usr/informix/bin/onbar_d -l
  78. 2011-01-04 11:11:19 25071  25069 Begin backup logical log 50491.
  79. 2011-01-04 11:11:19 25071  25069 Successfully connected to Storage Manager.
  80. 2011-01-04 11:43:50 29272  29270 /usr/informix/bin/onbar_d -l
  81. 2011-01-04 11:43:50 29272  29270 WARNING: A log backup is already running. Can't start another.
  82. 2011-01-04 11:43:55 29272  29270 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  83. 2011-01-04 12:11:46 25071  25069 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  84. 2011-01-04 12:11:51 25071  25069 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  85. 2011-01-04 12:19:28 4369  4367 /usr/informix/bin/onbar_d -l
  86. 2011-01-04 12:19:28 4369  4367 Begin backup logical log 50491.
  87. 2011-01-04 12:19:28 4369  4367 Successfully connected to Storage Manager.
  88. 2011-01-04 12:31:49 17128  17126 /usr/informix/bin/onbar_d -l
  89. 2011-01-04 12:31:49 17128  17126 WARNING: A log backup is already running. Can't start another.
  90. 2011-01-04 12:31:54 17128  17126 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  91. 2011-01-04 12:43:41 29813  29811 /usr/informix/bin/onbar_d -l
  92. 2011-01-04 12:43:42 29813  29811 WARNING: A log backup is already running. Can't start another.
  93. 2011-01-04 12:43:47 29813  29811 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  94. 2011-01-04 13:06:29 25008  25003 /usr/informix/bin/onbar_d -l
  95. 2011-01-04 13:06:29 25008  25003 WARNING: A log backup is already running. Can't start another.
  96. 2011-01-04 13:06:34 25008  25003 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  97. 2011-01-04 13:19:55 4369  4367 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  98. 2011-01-04 13:20:00 4369  4367 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  99. 2011-01-04 14:25:43 19152  19150 /usr/informix/bin/onbar_d -l
  100. 2011-01-04 14:25:44 19152  19150 Begin backup logical log 50491.
  101. 2011-01-04 14:25:44 19152  19150 Successfully connected to Storage Manager.
  102. 2011-01-04 15:02:53 26320  26318 /usr/informix/bin/onbar_d -l
  103. 2011-01-04 15:02:53 26320  26318 WARNING: A log backup is already running. Can't start another.
  104. 2011-01-04 15:02:58 26320  26318 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  105. 2011-01-04 15:26:11 19152  19150 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  106. 2011-01-04 15:26:16 19152  19150 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  107. 2011-01-04 15:29:26 23305  23303 /usr/informix/bin/onbar_d -l
  108. 2011-01-04 15:29:26 23305  23303 Begin backup logical log 50491.
  109. 2011-01-04 15:29:26 23305  23303 Successfully connected to Storage Manager.
  110. 2011-01-04 15:55:35 21701  21699 /usr/informix/bin/onbar_d -l
  111. 2011-01-04 15:55:35 21701  21699 WARNING: A log backup is already running. Can't start another.
  112. 2011-01-04 15:55:40 21701  21699 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  113. 2011-01-04 16:15:11 14583  14581 /usr/informix/bin/onbar_d -l
  114. 2011-01-04 16:15:11 14583  14581 WARNING: A log backup is already running. Can't start another.
  115. 2011-01-04 16:15:16 14583  14581 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  116. 2011-01-04 16:29:53 23305  23303 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  117. 2011-01-04 16:29:58 23305  23303 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  118. 2011-01-04 16:39:08 15889  15887 /usr/informix/bin/onbar_d -l
  119. 2011-01-04 16:39:10 15889  15887 Begin backup logical log 50491.
  120. 2011-01-04 16:39:10 15889  15887 Successfully connected to Storage Manager.
  121. 2011-01-04 17:00:20 12556  12554 /usr/informix/bin/onbar_d -l
  122. 2011-01-04 17:00:20 12556  12554 WARNING: A log backup is already running. Can't start another.
  123. 2011-01-04 17:00:25 12556  12554 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  124. 2011-01-04 17:39:37 15889  15887 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  125. 2011-01-04 17:39:45 15889  15887 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  126. 2011-01-04 17:46:55 9428  9426 /usr/informix/bin/onbar_d -l
  127. 2011-01-04 17:46:55 9428  9426 Begin backup logical log 50491.
  128. 2011-01-04 17:46:55 9428  9426 Successfully connected to Storage Manager.
  129. 2011-01-04 18:47:22 9428  9426 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  130. 2011-01-04 18:47:27 9428  9426 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  131. 2011-01-04 19:18:38 14383  14381 /usr/informix/bin/onbar_d -l
  132. 2011-01-04 19:18:38 14383  14381 Begin backup logical log 50491.
  133. 2011-01-04 19:18:38 14383  14381 Successfully connected to Storage Manager.
  134. 2011-01-04 20:19:05 14383  14381 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  135. 2011-01-04 20:19:10 14383  14381 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  136. 2011-01-04 20:46:41 19116  19114 /usr/informix/bin/onbar_d -b -L 0
  137. 2011-01-04 20:46:42 19116  19114 Begin level 0 backup rootdbs.
  138. 2011-01-04 20:46:42 19116  19114 Successfully connected to Storage Manager.
  139. 2011-01-04 20:50:42 19116  19114 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  140. 2011-01-04 20:50:43 19116  19114 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  141. 2011-01-04 22:03:56 11400  11397 /usr/informix/bin/onbar_d -l
  142. 2011-01-04 22:03:56 11400  11397 Begin backup logical log 50491.
  143. 2011-01-04 22:03:56 11400  11397 Successfully connected to Storage Manager.
  144. 2011-01-04 23:04:23 11400  11397 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  145. 2011-01-04 23:04:28 11400  11397 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  146. 2011-01-04 23:11:33 21463  21461 /usr/informix/bin/onbar_d -l
  147. 2011-01-04 23:11:34 21463  21461 Begin backup logical log 50491.
  148. 2011-01-04 23:11:34 21463  21461 Successfully connected to Storage Manager.
  149. 2011-01-04 23:12:40 22783  22781 /usr/informix/bin/onbar_d -l
  150. 2011-01-04 23:12:40 22783  22781 WARNING: A log backup is already running. Can't start another.
  151. 2011-01-04 23:12:45 22783  22781 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  152. 2011-01-04 23:13:58 24377  24375 /usr/informix/bin/onbar_d -l
  153. 2011-01-04 23:13:58 24377  24375 WARNING: A log backup is already running. Can't start another.
  154. 2011-01-04 23:14:03 24377  24375 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  155. 2011-01-04 23:14:14 24702  24700 /usr/informix/bin/onbar_d -l
  156. 2011-01-04 23:14:14 24702  24700 WARNING: A log backup is already running. Can't start another.
  157. 2011-01-04 23:14:19 24702  24700 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  158. 2011-01-04 23:21:30 2631  2625 /usr/informix/bin/onbar_d -l
  159. 2011-01-04 23:21:30 2631  2625 WARNING: A log backup is already running. Can't start another.
  160. 2011-01-04 23:21:35 2631  2625 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  161. 2011-01-04 23:21:57 3148  3146 /usr/informix/bin/onbar_d -l
  162. 2011-01-04 23:21:57 3148  3146 WARNING: A log backup is already running. Can't start another.
  163. 2011-01-04 23:22:02 3148  3146 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  164. 2011-01-04 23:39:37 22553  22551 /usr/informix/bin/onbar_d -l
  165. 2011-01-04 23:39:37 22553  22551 WARNING: A log backup is already running. Can't start another.
  166. 2011-01-04 23:39:42 22553  22551 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  167. 2011-01-05 00:12:01 21463  21461 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  168. 2011-01-05 00:12:07 21463  21461 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  169. 2011-01-05 02:07:51 6086  6084 /usr/informix/bin/onbar_d -b -L 0
  170. 2011-01-05 02:07:52 6086  6084 Begin level 0 backup rootdbs.
  171. 2011-01-05 02:07:52 6086  6084 Successfully connected to Storage Manager.
  172. 2011-01-05 02:11:52 6086  6084 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  173. 2011-01-05 02:11:53 6086  6084 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  174. 2011-01-05 02:17:55 17171  17169 /usr/informix/bin/onbar_d -l
  175. 2011-01-05 02:17:55 17171  17169 Begin backup logical log 50491.
  176. 2011-01-05 02:17:55 17171  17169 Successfully connected to Storage Manager.
  177. 2011-01-05 02:19:37 18798  18796 /usr/informix/bin/onbar_d -l
  178. 2011-01-05 02:19:37 18798  18796 WARNING: A log backup is already running. Can't start another.
  179. 2011-01-05 02:19:42 18798  18796 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  180. 2011-01-05 04:01:26 17171  17169 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  181. 2011-01-05 04:01:31 17171  17169 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  182. 2011-01-05 08:48:09 28586  28584 /usr/informix/bin/onbar_d -l
  183. 2011-01-05 08:48:10 28586  28584 Begin backup logical log 50491.
  184. 2011-01-05 08:48:11 28586  28584 Successfully connected to Storage Manager.
  185. 2011-01-05 09:26:57 9810  9808 /usr/informix/bin/onbar_d -l
  186. 2011-01-05 09:26:58 9810  9808 WARNING: A log backup is already running. Can't start another.
  187. 2011-01-05 09:27:03 9810  9808 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  188. 2011-01-05 09:48:38 28586  28584 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  189. 2011-01-05 09:48:43 28586  28584 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  190. 2011-01-05 10:22:03 8551  8549 /usr/informix/bin/onbar_d -l
  191. 2011-01-05 10:22:03 8551  8549 Begin backup logical log 50491.
  192. 2011-01-05 10:22:03 8551  8549 Successfully connected to Storage Manager.
  193. 2011-01-05 10:59:27 11572  8547 Process 11572  8547 completed.
  194. 2011-01-05 10:59:27 8547  8545 The ON-Bar process 11572 exited with a problem (exit code 141 (0x8d), signal 0).
  195. 2011-01-05 10:59:27 8547  8545 /usr/informix/bin/onbar_d: process exit 141 (0x8d)
  196. 2011-01-05 10:59:47 8551  8549 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  197. 2011-01-05 10:59:52 8551  8549 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  198. 2011-01-05 11:01:31 20174  20172 /usr/informix/bin/onbar_d -l
  199. 2011-01-05 11:01:31 20174  20172 Begin backup logical log 50491.
  200. 2011-01-05 11:01:31 20174  20172 Successfully connected to Storage Manager.
  201. [color=Red] 2011-01-05 11:04:26 20174  20172 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.[/color]
  202. 2011-01-05 11:04:31 20174  20172 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  203. [color=Red] 2011-01-05 11:05:53 24891  24889 /usr/informix/bin/onbar_d -l[/color]
  204. 2011-01-05 11:05:53 24891  24889 Begin backup logical log 50491.
  205. 2011-01-05 11:05:53 24891  24889 Successfully connected to Storage Manager.
  206. 2011-01-05 11:09:11 24891  24889 Completed backup logical log 50491.
  207. ……这之间的逻辑日志备份都成功
复制代码
下续
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fringker

论坛徽章:
0
3楼 [报告]
发表于 2011-01-10 12:59 |只看该作者

  2. 2011-01-05 20:31:01 1507  1505 /usr/informix/bin/onbar_d -b -L 0
  3. 2011-01-05 20:31:05 1507  1505 Begin level 0 backup rootdbs.
  4. 2011-01-05 20:31:05 1507  1505 Successfully connected to Storage Manager.
  5. 2011-01-05 21:46:01 19879  19877 /usr/informix/bin/onbar_d -l
  6. 2011-01-05 21:46:03 19879  19877 Begin backup logical log 50548.
  7. 2011-01-05 21:46:03 19879  19877 Successfully connected to Storage Manager.
  8. 2011-01-05 21:46:33 20457  20455 /usr/informix/bin/onbar_d -l
  9. 2011-01-05 21:46:33 20457  20455 WARNING: A log backup is already running. Can't start another.
  10. 2011-01-05 21:46:38 20457  20455 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  11. 2011-01-05 21:47:21 21133  21131 /usr/informix/bin/onbar_d -l
  12. 2011-01-05 21:47:21 21133  21131 WARNING: A log backup is already running. Can't start another.
  13. 2011-01-05 21:47:27 21133  21131 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  14. 2011-01-05 22:36:34 1507  1505 Process 1507 received signal 3. Process will exit after cleanup.
  15. 2011-01-05 22:36:37 1507  1505 Process 1507 received signal 15. Process will exit after cleanup.
  16. 2011-01-05 22:46:31 19879  19877 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  17. 2011-01-05 22:46:36 19879  19877 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  18. 2011-01-05 23:51:54 980  976 /usr/informix/bin/onbar_d -l
  19. 2011-01-05 23:51:54 980  976 Begin backup logical log 50548.
  20. 2011-01-05 23:51:54 980  976 Successfully connected to Storage Manager.
  21. 2011-01-06 00:05:31 14272  14270 /usr/informix/bin/onbar_d -l
  22. 2011-01-06 00:05:31 14272  14270 WARNING: A log backup is already running. Can't start another.
  23. 2011-01-06 00:05:36 14272  14270 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  24. 2011-01-06 00:06:54 16107  16105 /usr/informix/bin/onbar_d -l
  25. 2011-01-06 00:06:55 16107  16105 WARNING: A log backup is already running. Can't start another.
  26. 2011-01-06 00:07:00 16107  16105 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  27. 2011-01-06 00:08:11 17645  17639 /usr/informix/bin/onbar_d -l
  28. 2011-01-06 00:08:11 17645  17639 WARNING: A log backup is already running. Can't start another.
  29. 2011-01-06 00:08:16 17645  17639 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  30. 2011-01-06 00:08:38 18245  18243 /usr/informix/bin/onbar_d -l
  31. 2011-01-06 00:08:38 18245  18243 WARNING: A log backup is already running. Can't start another.
  32. 2011-01-06 00:08:43 18245  18243 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  33. 2011-01-06 00:11:34 21328  21326 /usr/informix/bin/onbar_d -l
  34. 2011-01-06 00:11:34 21328  21326 WARNING: A log backup is already running. Can't start another.
  35. 2011-01-06 00:11:39 21328  21326 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  36. 2011-01-06 00:12:08 21963  21961 /usr/informix/bin/onbar_d -l
  37. 2011-01-06 00:12:08 21963  21961 WARNING: A log backup is already running. Can't start another.
  38. 2011-01-06 00:12:13 21963  21961 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  39. 2011-01-06 00:12:34 22428  22425 /usr/informix/bin/onbar_d -l
  40. 2011-01-06 00:12:35 22428  22425 WARNING: A log backup is already running. Can't start another.
  41. 2011-01-06 00:12:40 22428  22425 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  42. 2011-01-06 00:13:08 22988  22986 /usr/informix/bin/onbar_d -l
  43. 2011-01-06 00:13:08 22988  22986 WARNING: A log backup is already running. Can't start another.
  44. 2011-01-06 00:13:13 22988  22986 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  45. 2011-01-06 00:14:10 23735  23733 /usr/informix/bin/onbar_d -l
  46. 2011-01-06 00:14:10 23735  23733 WARNING: A log backup is already running. Can't start another.
  47. 2011-01-06 00:14:15 23735  23733 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  48. 2011-01-06 00:36:29 17818  17811 /usr/informix/bin/onbar_d -l
  49. 2011-01-06 00:36:29 17818  17811 WARNING: A log backup is already running. Can't start another.
  50. 2011-01-06 00:36:34 17818  17811 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  51. 2011-01-06 00:50:44 3301  3299 /usr/informix/bin/onbar_d -l
  52. 2011-01-06 00:50:47 3301  3299 WARNING: A log backup is already running. Can't start another.
  53. 2011-01-06 00:50:52 3301  3299 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  54. 2011-01-06 00:52:21 980  976 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  55. 2011-01-06 00:52:27 980  976 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  56. ……之间的逻辑日志备份都是这样的提示，到下次0级备份的时候，又有了新情况。
复制代码
下续
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fringker

论坛徽章:
0
4楼 [报告]
发表于 2011-01-10 13:00 |只看该作者

  2. 2011-01-06 02:34:45 25198  25196 /usr/informix/bin/onbar_d -b -L 0
  3. [color=Red] 2011-01-06 02:34:47 25198  25196 ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.
  4. 2011-01-06 02:34:47 25198  25196 SQL     -408        Invalid message type received from the sqlexec process.[/color]
  5. 2011-01-06 02:34:47 25198  25196 /usr/informix/bin/onbar_d: process exit 131 (0x83)
  6. 2011-01-06 03:26:49 16456  16454 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  7. 2011-01-06 03:26:56 16456  16454 /usr/informix/bin/onbar_d: process exit 3 (0x03)
  8. 2011-01-06 08:57:07 23957  23955 /usr/informix/bin/onbar_d -l
  9. 2011-01-06 08:57:07 23957  23955 Begin backup logical log 50548.
  10. 2011-01-06 08:57:07 23957  23955 Successfully connected to Storage Manager.
  11. 2011-01-06 09:16:13 12002  12000 /usr/informix/bin/onbar_d -l
  12. 2011-01-06 09:16:13 12002  12000 WARNING: A log backup is already running. Can't start another.
  13. 2011-01-06 09:16:18 12002  12000 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  14. 2011-01-06 09:48:49 13471  13469 /usr/informix/bin/onbar_d -l
  15. 2011-01-06 09:48:50 13471  13469 WARNING: A log backup is already running. Can't start another.
  16. 2011-01-06 09:48:55 13471  13469 /usr/informix/bin/onbar_d: process exit 152 (0x98)
  17. 2011-01-06 09:57:34 23957  23955 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
  18. 2011-01-06 09:57:39 23957  23955 /usr/informix/bin/onbar_d: process exit 3 (0x03)
复制代码
可以看到，在做workdbs的0级备份的时候，有个提示：8545 Process 8547 received signal 3. Process will exit after cleanup.然后后面的逻辑日志备份和0级备份都无法成功，一直到1月5日11:05:53，再次做逻辑日志的备份的时候才成功。晚上20:31分作0级备份又不成功，无尽的WARNING: A log backup is already running. Can't start another.提示。最后到XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session然后退出进程。后来的新情况就是ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL     -408        Invalid message type received from the sqlexec process.这样的提示，不知道这是什么原因造成的，可以保证的是，中间没什么误操作，都是通过脚本完成的，脚本是以前早就写好的，刚开始数据量不大的时候是没问题的，而且以前数据库是可以手工dbexport出来的，现在根本没办法做出来，遇到那几个大表的时候就死在那，不动了。请各位大牛们帮小弟分析下，多谢~~
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
liaosnet

论坛徽章:
11
金牛座 日期:2015-03-19 16:56:22数据库技术版块每日发帖之星 日期:2016-08-02 06:20:00数据库技术版块每日发帖之星 日期:2016-04-24 06:20:00数据库技术版块每日发帖之星 日期:2016-04-13 06:20:00IT运维版块每日发帖之星 日期:2016-04-13 06:20:00数据库技术版块每日发帖之星 日期:2016-02-03 06:20:00数据库技术版块每日发帖之星 日期:2015-08-06 06:20:00季节之章：春 日期:2015-03-27 15:54:57羊年新春福章 日期:2015-03-27 15:54:37戌狗 日期:2015-03-19 16:56:41数据库技术版块每日发帖之星 日期:2016-08-18 06:20:00
5楼 [报告]
发表于 2011-01-10 13:58 |只看该作者
逻辑日志备份建议使用ALARMPROGRAM指定脚本做～
WARNING: A log backup is already running. Can't start another.

在做逻辑日志备份时，若有别的程序已经启动了逻辑日志备份，再启一个备份程序时就会报这个错误。。这个怀疑是跟你的脚本相关。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
george002

论坛徽章:
0
6楼 [报告]
发表于 2011-01-10 16:48 |只看该作者
onbar备份逻辑日志只有一个onbar进程，如果上一个逻辑日志没有备份完成下一个逻辑日志满了启动onbar备份就会提示
WARNING: A log backup is already running. Can't start another.
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fringker

论坛徽章:
0
7楼 [报告]
发表于 2011-01-11 10:25 |只看该作者
感谢两位的回复，也就是说，当前正在备份一个逻辑日志的时候，另外一个逻辑日志满了，会启动自动备份，但是由于只能启动一个进程，所以会提示：WARNING: A log backup is already running. Can't start another.那么，当前正在做的这个逻辑日志备份完毕后，会按照顺序继续下一个已满的逻辑日志的备份吧？

另外，打个比方，如果id为30的逻辑日志备份在备份的时候，由于数据量大或者操作量大，31之后的逻辑日志迅速写满，需要备份，那么会报那个错，但是如果30之后的迅速写满需要备份的逻辑日志太多了，会不会导致意外结果？会导致这个
XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.报错出现吗？

再有，如果正在备份当前一个逻辑日志的时候，此时启动了0级备份，会不会由于0级备份会先备份所有的逻辑日志，而由于当前正存在一个正在备份的逻辑日志进程，就会导致0级备份由于等待逻辑日志备份而时间很长，最后报XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.不成功？

下面的这个报错又是怎么回事呢？
ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL     -408        Invalid message type received from the sqlexec process.
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fringker

论坛徽章:
0
8楼 [报告]
发表于 2011-01-11 10:28 |只看该作者
使用ALARMPROGRAM指定脚本来做也可以，但在DP里应该怎么设置呢？
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
liaosnet

论坛徽章:
11
金牛座 日期:2015-03-19 16:56:22数据库技术版块每日发帖之星 日期:2016-08-02 06:20:00数据库技术版块每日发帖之星 日期:2016-04-24 06:20:00数据库技术版块每日发帖之星 日期:2016-04-13 06:20:00IT运维版块每日发帖之星 日期:2016-04-13 06:20:00数据库技术版块每日发帖之星 日期:2016-02-03 06:20:00数据库技术版块每日发帖之星 日期:2015-08-06 06:20:00季节之章：春 日期:2015-03-27 15:54:57羊年新春福章 日期:2015-03-27 15:54:37戌狗 日期:2015-03-19 16:56:41数据库技术版块每日发帖之星 日期:2016-08-18 06:20:00
9楼 [报告]
发表于 2011-01-11 11:19 |只看该作者
感谢两位的回复，也就是说，当前正在备份一个逻辑日志的时候，另外一个逻辑日志满了，会启动自动备份，但是 ...
fringker 发表于 2011-01-11 10:25



    DP这个不知道～～
    只是提醒下，使用ALARMPROGRAM，在逻辑日志满的会自动备份。
即便是报了已经启动了另外一个逻辑日志备份程序的话，这权当是个警示，在下次逻辑日志备份的时候总会备份的。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
fringker

论坛徽章:
0
10楼 [报告]
发表于 2011-01-11 11:48 |只看该作者
现在也是没办法啊，用DP备份恢复还是比较方便的，最起码什么都不用去记，用了另外的备份方法到时候还要记得什么时候备份的，备份文件在哪儿等等，所以如果有其他方法还是想纳入DP的。
liaosnet大神，这两个报错有研究嘛？
ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL     -408        Invalid message type received from the sqlexec process.
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
12下一页
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP