Re: [Observium] errors on upgrade

13 Apr 2016


      So starting with a 100% new db I’m still getting these errors
mysql> CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘*******';
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
You have new mail in /var/spool/mail/root
[root@sjc-corp-net01 observium]# ./discovery.php -u
MySQL Error 1045: Access denied for user 'observium'@'localhost' (using password: YES)
[root@sjc-corp-net01 observium]# vi config.php
[root@sjc-corp-net01 observium]# ./discovery.php -u
___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |__ |  __/| |    \ V / | || |_| || | | | | |
 ___/ |_.__/ |___/ ___||_|     _/  |_| __,_||_| |_| |_|
                         Observium Professional 0.16.4.7747
                                   http://www.observium.org
Install initial database schema ... FALSE.
-- Updating database/file schema
000 -> 001 ... (db) done.
001 -> 002 ... (db) done (13 errors).
002 -> 003 ... (db) done (6 errors).
003 -> 004 ... (db) done (22 errors).
004 -> 005 ... (db) done (8 errors).
005 -> 006 ... (db) done (2 errors).
006 -> 007 ... (db) done.
007 -> 008 ... (db) done (1 errors).
008 -> 009 ... (db) done (9 errors).
009 -> 010 ... (db) done (1 errors).
010 -> 011 ... (db) done.
011 -> 012 ... (db) done.
012 -> 013 ... (db) done (1 errors).
013 -> 014 ... (db) done.
014 -> 015 ... (db) done (1 errors).
015 -> 016 ... (db) done (5 errors).
016 -> 017 ... (db) done (1 errors).
017 -> 018 ... (db) done (3 errors).
018 -> 019 ... (db) done.
019 -> 020 ... (db) done (6 errors).
020 -> 021 ... (db) done (3 errors).
021 -> 022 ... (db) done (1 errors).
022 -> 023 ... (db) done (2 errors).
023 -> 024 ... (db) done (2 errors).
024 -> 025 ... (db) done (8 errors).
025 -> 026 ... (db) done.
026 -> 027 ... (db) done (1 errors).
027 -> 028 ... (db) done (8 errors).
028 -> 029 ... (db) done.
029 -> 030 ... (db) done.
030 -> 031 ... (db) done (1 errors).
031 -> 032 ... (db) done (2 errors).
032 -> 033 ... (db) done.
033 -> 034 ... (db) done.
034 -> 035 ... (db) done.
035 -> 036 ... (db) done (1 errors).
036 -> 037 ... (db) done (2 errors).
037 -> 038 ... (db) done (1 errors).
038 -> 039 ... (db) done (1 errors).
039 -> 040 ... (db) done.
040 -> 041 ... (db) done.
041 -> 042 ... (db) done (3 errors).
042 -> 043 ... (db) done (7 errors).
043 -> 044 ... (db) done (2 errors).
044 -> 045 ... (db) done (2 errors).
045 -> 046 ... (db) done.
046 -> 047 ... (db) done.
047 -> 048 ... (db) done (1 errors).
048 -> 049 ... (db) done (1 errors).
049 -> 050 ... (db) done (1 errors).
050 -> 051 ... (db) done.
051 -> 052 ... (db) done (1 errors).
052 -> 053 ... (db) done (1 errors).
053 -> 054 ... (db) done (1 errors).
054 -> 055 ... (db) done (3 errors).
055 -> 056 ... (db) done (1 errors).
056 -> 057 ... (db) done (1 errors).
057 -> 058 ... (db) done (1 errors).
058 -> 059 ... (db) done (2 errors).
059 -> 060 ... (db) done (1 errors).
060 -> 061 ... (db) done (1 errors).
061 -> 062 ... (db) done (1 errors).
062 -> 063 ... (db) done (5 errors).
063 -> 064 ... (db) done (3 errors).
064 -> 065 ... (db) done (2 errors).
065 -> 066 ... (db) done (1 errors).
066 -> 067 ... (db) done (1 errors).
067 -> 068 ... (db) done (2 errors).
068 -> 069 ... (db) done (4 errors).
069 -> 070 ... (db) done (2 errors).
070 -> 071 ... (db) done (1 errors).
071 -> 072 ... (db) done (1 errors).
072 -> 073 ... (db) done.
073 -> 074 ... (php) Updating netscaler service RRDs
074 -> 075 ... (db) done (1 errors).
075 -> 076 ... (db) done (1 errors).
076 -> 077 ... (db) done (3 errors).
077 -> 078 ... (db) done.
078 -> 079 ... (db) done.
079 -> 080 ... (db) done (35 errors).
080 -> 081 ... (db) done (2 errors).
081 -> 082 ... (db) done (9 errors).
082 -> 083 ... (db) done.
083 -> 084 ... (db) done (2 errors).
084 -> 085 ... (db) done (3 errors).
085 -> 086 ... (db) done (1 errors).
086 -> 087 ... (db) done (2 errors).
087 -> 088 ... (db) done (1 errors).
088 -> 089 ... (db) done (5 errors).
089 -> 090 ... (db) done (3 errors).
090 -> 091 ... (db) done (1 errors).
091 -> 092 ... (db) done (1 errors).
092 -> 093 ... (db) done (3 errors).
093 -> 094 ... (db) done (1 errors).
094 -> 095 ... (php) Converting alert serialize() arrays to JSON:
095 -> 096 ... (db) done (1 errors).
096 -> 097 ... (db) done.
097 -> 098 ... (db) done (1 errors).
098 -> 099 ... (db) done (1 errors).
099 -> 100 ... (db) done (1 errors).
100 -> 101 ... (db) done (1 errors).
101 -> 102 ... (db) done (1 errors).
102 -> 103 ... (db) done (1 errors).
103 -> 104 ... (db) done (2 errors).
104 -> 105 ... (db) done.
105 -> 106 ... (db) done (2 errors).
106 -> 107 ... (db) done (1 errors).
107 -> 108 ... (db) done (1 errors).
108 -> 109 ... (db) done (1 errors).
109 -> 110 ... (db) done (3 errors).
110 -> 111 ... (db) done.
111 -> 112 ... (db) done.
112 -> 113 ... (db) done.
113 -> 114 ... (db) done (1 errors).
114 -> 115 ... (db) done (1 errors).
115 -> 116 ... (db) done (1 errors).
116 -> 117 ... (db) done.
117 -> 118 ... (db) done (1 errors).
118 -> 119 ... (db) done (19 errors).
119 -> 120 ... (db) done (1 errors).
120 -> 121 ... (db) done.
121 -> 122 ... (db) done (3 errors).
122 -> 123 ... (db) done (4 errors).
123 -> 124 ... (db) done.
124 -> 125 ... (db) done.
125 -> 126 ... (db) done (2 errors).
126 -> 127 ... (php) Converting FDB count RRD ds fdb->value:
127 -> 128 ... (php) Rename old storage RRDs and DB:
128 -> 129 ... (php) Rename old mempools RRDs and DB:
129 -> 130 ... (db) done.
130 -> 131 ... (db) done (1 errors).
131 -> 132 ... (db) done (1 errors).
132 -> 133 ... (db) done.
133 -> 134 ... (db) done (1 errors).
134 -> 135 ... (db) done (1 errors).
135 -> 136 ... (db) done (1 errors).
136 -> 137 ... (db) done.
137 -> 138 ... (db) done.
138 -> 139 ... (db) done (5 errors).
139 -> 140 ... (db) done (1 errors).
140 -> 141 ... (db) done (3 errors).
141 -> 142 ... (db) done (4 errors).
142 -> 143 ... (db) done (2 errors).
143 -> 144 ... (db) done (1 errors).
144 -> 145 ... (db) done.
145 -> 146 ... (db) done (1 errors).
146 -> 147 ... (db) done (1 errors).
147 -> 148 ... (db) done (3 errors).
148 -> 149 ... (db) done (3 errors).
149 -> 150 ... (db) done (7 errors).
150 -> 151 ... (db) done.
151 -> 152 ... (db) done.
152 -> 153 ... (php)
153 -> 154 ... (db) done.
154 -> 155 ... (db) done (1 errors).
155 -> 156 ... (db) done.
156 -> 157 ... (db) done (1 errors).
157 -> 158 ... (db) done (4 errors).
158 -> 159 ... (db) done (1 errors).
159 -> 160 ... (db) done (1 errors).
160 -> 161 ... (db) done.
161 -> 162 ... (db) done.
162 -> 163 ... (db) done (1 errors).
163 -> 164 ... (php) Superseded by update 165
164 -> 165 ... (php) Adding MIN RRA to very old RRD files:
  * hr_processes:
  * hr_users:
  * ucd_contexts:
  * ucd_load:
  * ucd_interrupts:
165 -> 166 ... (db) done (1 errors).
166 -> 167 ... (db) done (2 errors).
167 -> 168 ... (db) done.
168 -> 169 ... (db) done (2 errors).
169 -> 170 ... (php) Move old GEO data if exist:
170 -> 171 ... (db) done (1 errors).
171 -> 172 ... (db) done.
172 -> 173 ... (db) done (1 errors).
173 -> 174 ... (db) done (3 errors).
174 -> 175 ... (db) done (2 errors).
175 -> 176 ... (php) Clean incorrect syslog entries:
176 -> 177 ... (php) Clean incorrect manual geolocation:
177 -> 178 ... (db) done (7 errors).
178 -> 179 ... (db) done (2 errors).
179 -> 180 ... (db) done.
180 -> 181 ... (db) done (1 errors).
181 -> 182 ... (db) done.
182 -> 183 ... (db) done.
183 -> 184 ... (db) done (17 errors).
184 -> 185 ... (db) done.
185 -> 186 ... (db) done (10 errors).
186 -> 187 ... (php)
187 -> 188 ... (db) done (2 errors).
188 -> 189 ... (db) done (2 errors).
189 -> 190 ... (db) done (1 errors).
190 -> 191 ... (php) Migrating state sensors to status entries:
191 -> 192 ... (db) done (3 errors).
192 -> 193 ... (db) done (1 errors).
193 -> 194 ... (db) done (1 errors).
194 -> 195 ... (db) done.
195 -> 196 ... (db) done (2 errors).
196 -> 197 ... (db) done (1 errors).
197 -> 198 ... (db) done (1 errors).
198 -> 199 ... (db) done.
199 -> 200 ... (db) done (6 errors).
200 -> 201 ... (db) done (1 errors).
201 -> 202 ... (db) done (7 errors).
202 -> 203 ... (db) done.
203 -> 204 ... (db) done.
204 -> 205 ... (db) done.
205 -> 206 ... (db) done.
206 -> 207 ... (db) done.
207 -> 208 ... (db) done (1 errors).
208 -> 209 ... (db) done (7 errors).
209 -> 210 ... (php)
210 -> 211 ... (db) done (1 errors).
211 -> 212 ... (php)
212 -> 213 ... (db) done (3 errors).
213 -> 214 ... (db) done (1 errors).
214 -> 215 ... (db) done.
215 -> 216 ... (db) done (1 errors).
216 -> 217 ... (db) done.
217 -> 218 ... (db) done.
218 -> 219 ... (db) done.
219 -> 220 ... (db) done (1 errors).
220 -> 221 ... (db) done (1 errors).
221 -> 222 ... (db) done.
222 -> 223 ... (db) done (1 errors).
223 -> 224 ... (db) done.
224 -> 225 ... (db) done (2 errors).
225 -> 226 ... (db) done.
226 -> 227 ... (db) done (2 errors).
227 -> 228 ... (db) done (10 errors).
228 -> 229 ... (db) done.
229 -> 230 ... (db) done (1 errors).
230 -> 231 ... (db) done (1 errors).
231 -> 232 ... (db) done (1 errors).
232 -> 233 ... (db) done (2 errors).
233 -> 234 ... (db) done (1 errors).
234 -> 235 ... (db) done (2 errors).
235 -> 236 ... (db) done.
236 -> 237 ... (db) done.
237 -> 238 ... (db) done.
238 -> 239 ... (db) done (1 errors).
239 -> 240 ... (db) done (1 errors).
240 -> 241 ... (db) done.
241 -> 242 ... (db) done.
242 -> 243 ... (db) done.
243 -> 244 ... (db) done.
244 -> 245 ... (db) done (1 errors).
245 -> 246 ... (db) done.
246 -> 247 ... (db) done (1 errors).
247 -> 248 ... (db) done.
248 -> 249 ... (db) done (1 errors).
249 -> 250 ... (db) done (1 errors).
250 -> 251 ... (db) done.
251 -> 252 ... (db) done (5 errors).
252 -> 253 ... (db) done (1 errors).
253 -> 254 ... (db) done (1 errors).
254 -> 255 ... (db) done.
255 -> 256 ... (php)
256 -> 257 ... (php)
257 -> 258 ... (php)
258 -> 259 ... (db) done.
259 -> 260 ... (php)
260 -> 261 ... (db) done (5 errors).
261 -> 262 ... (php)
262 -> 263 ... (db) done (1 errors).
263 -> 264 ... (db) done (9 errors).
264 -> 265 ... (db) done.
265 -> 266 ... (db) done.
266 -> 267 ... (db) done (1 errors).
267 -> 268 ... (php)
268 -> 269 ... (php)
269 -> 270 ... (db) done.
270 -> 271 ... (db) done (3 errors).
271 -> 272 ... (db) done.
272 -> 273 ... (db) done (1 errors).
273 -> 274 ... (php)
-- Done.
[root@sjc-corp-net01 observium]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_sjccorpnet01-lv_root
                       50G  3.9G   43G   9% /
tmpfs                 127G     0  127G   0% /dev/shm
/dev/sda1             477M   68M  384M  15% /boot
/dev/mapper/vg_sjccorpnet01-lv_home
                      359G  282G   60G  83% /home
[root@sjc-corp-net01 observium]#
From: observium <observium-bounces@observium.orgmailto:observium-bounces@observium.org> on behalf of Adam Armstrong <adama@memetic.orgmailto:adama@memetic.org>
Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org>
Date: Tuesday, April 12, 2016 at 11:48 PM
To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org>
Subject: Re: [Observium] errors on upgrade
Yes. That looks like everything failed, and your database is probably now not something observium can properly interact with.
Adam.
Sent from BlueMailhttp://www.bluemail.me/r
On Apr 13, 2016, at 07:46, Jeffrey d'Ambly <jeffrey.dambly@jasper.commailto:jeffrey.dambly@jasper.com> wrote:
Should I be worried about these errors?
[root@sjc-corp-net01 observium]# ./discovery.php -u
___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |__ |  __/| |    \ V / | || |_| || | | | | |
 ___/ |_.__/ |___/ ___||_|     _/  |_| __,_||_| |_| |_|
                         Observium Professional 0.16.4.7747
                                   http://www.observium.org
-- Updating database/file schema
195 -> 196 ... (db) done.
196 -> 197 ... (db) done.
197 -> 198 ... (db) done.
198 -> 199 ... (db) done.
199 -> 200 ... (db) done.
200 -> 201 ... (db) done.
201 -> 202 ... (db) done (1 errors).
202 -> 203 ... (db) done.
203 -> 204 ... (db) done.
204 -> 205 ... (db) done.
205 -> 206 ... (db) done.
206 -> 207 ... (db) done.
207 -> 208 ... (db) done.
208 -> 209 ... (db) done (4 errors).
209 -> 210 ... (php)
210 -> 211 ... (db) done (5 errors).
211 -> 212 ... (php)
212 -> 213 ... (db) done (11 errors).
213 -> 214 ... (db) done (2 errors).
214 -> 215 ... (db) done (3 errors).
215 -> 216 ... (db) done (1 errors).
216 -> 217 ... (db) done (1 errors).
217 -> 218 ... (db) done (1 errors).
218 -> 219 ... (db) done (1 errors).
219 -> 220 ... (db) done (4 errors).
220 -> 221 ... (db) done (1 errors).
221 -> 222 ... (db) done.
222 -> 223 ... (db) done (1 errors).
223 -> 224 ... (db) done.
224 -> 225 ... (db) done (2 errors).
225 -> 226 ... (db) done.
226 -> 227 ... (db) done (2 errors).
227 -> 228 ... (db) done (10 errors).
228 -> 229 ... (db) done (3 errors).
229 -> 230 ... (db) done (1 errors).
230 -> 231 ... (db) done (1 errors).
231 -> 232 ... (db) done (1 errors).
232 -> 233 ... (db) done (2 errors).
233 -> 234 ... (db) done (1 errors).
234 -> 235 ... (db) done (3 errors).
235 -> 236 ... (db) done (1 errors).
236 -> 237 ... (db) done.
237 -> 238 ... (db) done (1 errors).
238 -> 239 ... (db) done (1 errors).
239 -> 240 ... (db) done (3 errors).
240 -> 241 ... (db) done (1 errors).
241 -> 242 ... (db) done (4 errors).
242 -> 243 ... (db) done (1 errors).
243 -> 244 ... (db) done (6 errors).
244 -> 245 ... (db) done (1 errors).
245 -> 246 ... (db) done (1 errors).
246 -> 247 ... (db) done (2 errors).
247 -> 248 ... (db) done (2 errors).
248 -> 249 ... (db) done (1 errors).
249 -> 250 ... (db) done (1 errors).
250 -> 251 ... (db) done (1 errors).
251 -> 252 ... (db) done (5 errors).
252 -> 253 ... (db) done.
253 -> 254 ... (db) done.
254 -> 255 ... (db) done (2 errors).
255 -> 256 ... (php)
256 -> 257 ... (php)
257 -> 258 ... (php)
258 -> 259 ... (db) done.
259 -> 260 ... (php)
260 -> 261 ... (db) done (6 errors).
261 -> 262 ... (php)
262 -> 263 ... (db) done (1 errors).
263 -> 264 ... (db) done (9 errors).
264 -> 265 ... (db) done (1 errors).
265 -> 266 ... (db) done (2 errors).
266 -> 267 ... (db) done (1 errors).
267 -> 268 ... (php)
268 -> 269 ... (php)
269 -> 270 ... (db) done (1 errors).
270 -> 271 ... (db) done (10 errors).
271 -> 272 ... (db) done (5 errors).
272 -> 273 ... (db) done (2 errors).
273 -> 274 ... (php)
-- Done.
You have new mail in /var/spool/mail/root
[root@sjc-corp-net01 observium]#
________________________________
observium mailing list
observium@observium.orgmailto:observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium