Lot's of crashes since i use Mysql

Hi Brian,

I experience a lot of crashes during the nighttime.
Everytime when i check WD in the morning it’s crashed with this error :

The only programs running beside weather display are :

Apache
Mysql server

Any idea’s ?

Jeroen[/img]

hi
sounds like an array going out of range
must be to do with data in the clientraw.txt file
i.e, after it has crashed, email me that file, before you restart wd again (from the webfiles folder)
i will also review the code to see if i can spot why)
will be interesting to see if any other reports
also, i will set it updating here myself

actualy, i have a problem at the moment with the mysql updates:
its goes OK until I go to view WD, then it crashes
weird
some memory conflict
others?
I will write a separate .exe program for the msql update…that will be better me thinks
10.15y has option to only update at different rates, the mysql database

This was exactly what i had.

App running perfectly untill onclick event fired and klaboom…

Using version .W now and still problems…

Regards,

Jeroen

hi
10.15z beta is OK
as the mysql updates are being done via a separate program, wdmysql.exe
:wink:
as i could not fingure out why that was happening…some memory conflict…so the best thing was to have it as a separate program

so i recommend 10.15z beta

been working just dandy for me all night long :slight_smile:

Hi Brian,

I can only download .W ? Thats under beta ?
I guess something went wrong updating the files… :slight_smile:

:signthanks:
Jeroen

Now it’s .Z i guess my proxy server has some hickups !

But as i said :

:headbang:

Jeroen

hi
i see your data stopped at 6:07 am?
do you have set to set vp time (i.e ticked do daily) in the data logger setup?
try unticking that
as that has caused problems…but its ok for me…

Hi Brian,

Your an early bird :slight_smile:
But your right. It did hang with exact the same error message.

Hmm i will try that option with the datalogger.
But when i restart WD after the crash wd doesn’t use my data from the datalogger but shows a gap from six till now…

Greetz,

Jeroen

hi
the data extract should be working…is does for me…
is the time on the console the same as the pc (and the date?)
did the exctract dialog come up and show a status bar?
was the file vptemplog.txt updated?

Ok so the temp time and date are the same.

Temp file did get an update (file date en time changed at restart).

Contents :

255 18 9 118 2 134 2 134 2 130 2 0 0 0 0 133 115 255 127 172 2 4 3 64 90 0 2 11 6 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 188 2 137 2 137 2 134 2 0 0 0 0 132 115 255 127 172 2 2 3 64 89 0 3 10 10 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 218 2 140 2 140 2 137 2 0 0 0 0 135 115 255 127 172 2 2 3 64 89 0 4 6 10 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 32 3 148 2 148 2 140 2 0 0 0 0 136 115 255 127 172 2 4 3 64 88 1 10 10 10 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
4 18 9 62 3 156 2 156 2 148 2 0 0 0 0 136 115 255 127 172 2 4 3 64 86 1 7 11 10 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 132 3 173 2 173 2 156 2 0 0 0 0 149 115 255 127 172 2 5 3 64 83 1 10 10 11 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 162 3 181 2 181 2 173 2 0 0 0 0 153 115 255 127 171 2 7 3 64 80 3 14 9 11 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 18 9 232 3 196 2 196 2 181 2 0 0 0 0 161 115 255 127 172 2 11 3 63 76 4 14 13 11 255 0 255 127 255 192 255 255 255 255 255 255 255 255 0 255 255 160 255 255 255 255 255 0
255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 0

The datalogger windows shows on startup but uses current time as if it was the last time it did an update. My screen looks like this :

As you can see a gap of 4 hours… Whe the crash happens before midnight it doesnt do the daily reset.

Greets,

Jeroen

hi
please email that file, vptemplog.txt
also, what is the data logging interval of the data logger?

hi
the data has only every 30 minute logging interval
that is the problem
idealy you need to set the data logger to every 1 minute logging interval
or if not, then set the data pad out to match the data logging interval of the data logger (i.e maybe the data logger logging interval was set to 30 minutes and you didnt realise (maybe by wlink?))

Brian,

I still experience crashed memory exeptions etc.
All above is corrected but without result.

Regards,

Jeroen

Hi
note that with 10.16, the mysql update is now handled by the separate wdmysql
are you still getting problems with that version?

sorry for the delay in getting back to you,. i have been away for the last 36 hours

Brian,
I’m using version 10.16 and getting the same exception thrown as above. I don’t see a clientraw.txt file in my webfiles.

Every morning when I wake up the program crashed between 3 and 5 am. I restart the program and it works properly all day.

Bosco[/img]

hi
you can tell the time of the crash by checking the logfile, 82004lg.txt
and the last entry there…let me know the exact time, as that will help…
maybe email me your settings:
wdsiplay.ini from c:\windows or c:\winnt and wdisplayftp.reg from the folder databackup, after going action, back up register entry now

hi jeroenm
i see you are getting crashes still:
my I suggest:
install WD to a new directory
then create a file there called 2wd.txt
(i.e save a file with notepad.exe so its called 2wd)
then start wd there
it will then start up like brand new
and then copy the datafiles over and logfiles
then configure what you need to get going again
and then see how it goes (there might be some settings you have on that are not working too good
i notice you had a stop in your data at 9am local…thats when the all day animated web cam is created.

i see its still updating for you jeroenm and its 5:30 am your time, so it has survived the night
so thats good

i see it stopped at 6:06am
thats when wd sets the time on the VP console to the PC time
so, untick to do that daily, in the datalogger setup (see under control panel, data logger )
this does not cause any problems for me…with my davis VP…i wonder if its some european time/date issue…