Power break
once more, at about 8:00. And again, Diana didn’t startup, and I have no idea why not. But a manual power cycle (wait a few seconds before powering up) at about 18:30 showed nothing was wrong at all: it came up as it should. Probably it is some trouble with the HSZ50 controller that has to initialize properly, before the Alpha system would try to catch up? Who knows. This proves a UPS is “required hardware” !
>Web trouble
That is: some. The webs I uploaded yesterday (using JAlbum’s UPLOAD facility) have one flaw: the back link to the index page is wrong. This has been manually adjusted and now it’s allright.
>Log scan
has worked properly last night, after I adjusted the commandfile yesterday. So all spam from 2007 up to (including) yesterday is now logged.
>MySQL crashed
because the database wasn’t closed properly. This mail was entered by when trying to access the site, MySQL went down on an Access Violation:
InnoDB: Thread 107565824 stopped in file MYSQL_ROOT:[innobase.include]sync0sync.
ic;1 line 111
InnoDB: Thread 87995136 stopped in file MYSQL_ROOT:[innobase.os]os0sync.c;1 line
%CMA-F-EXIT_THREAD, current thread has been requested to exit
%TRACE-F-TRACEBACK, symbolic stack dump follows
image module routine line rel PC abs PC
PTHREAD$RTL 0 000000000004381C FFFFFFFF80A6181C
PTHREAD$RTL 0 000000000006EB58 FFFFFFFF80A8CB58
DECC$SHR_EV56 0 00000000001D0D54 FFFFFFFF80C64D54
DECC$SHR_EV56 0 00000000001D0A1C FFFFFFFF80C64A1C
----- above condition handler called with exception 0000000C:
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=000000000000
0000, PC=000000000028CDE4, PS=0000001B
----- end of exception message
mysqld FIL0FIL fil_io 44926 000000000000E4C4 000000000028CDE4
mysqld BUF0FLU buf_flush_buffered_writes
39815 0000000000001094 0000000000256CA4
mysqld BUF0FLU buf_flush_batch 40426 0000000000002E74 0000000000258A84

but looking into the logfile, I think the recovery, or the initialisation of logfiles failed:

070112 18:36:31 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 18391400.
InnoDB: Doing recovery: scanned up to log sequence number 0 18391400
InnoDB: Last MySQL binlog file position 0 407933, file name ./diana-bin.000034
070112 18:36:31 InnoDB: Flushing modified pages from the buffer pool...
070112 18:36:31 InnoDB: Started; log sequence number 0 18391400
070112 18:36:31 [ERROR] After InnoDB crash recovery, checking if the binary log
'./diana-bin.000034' contains rolled back transactions which must be removed fro
m it...
/$116$DKA100/000000/WEB/MYSQL/MYSQL/VMS/BIN/mysqld.exe: ready for connections.
Version: '4.1.14-log' socket: '' port: 3306 Source distribution
070112 20:30:09 InnoDB: Error: Write to file /database/mysql41/ibdata1 failed a
t offset 0 1048576.
InnoDB: 212992 bytes should have been written, only -1 were written.
InnoDB: Operating system error number 12.

Somewhere in the code, it seems -1 (MINUS one) bytes were written.

InnoDB: Check that your OS and file system support files of this size.

I don’t think there is any OS able to write that number of bytes!

InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 12 means 'not enough core'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
070112 20:30:09InnoDB: Assertion failure in thread 88093440 in file MYSQL_ROOT:[
innobase.fil]fil0fil.c;1 line 3922
InnoDB: Failing assertion: ret
InnoDB: We intentionally generate a memory trap.

Well, MySQL wants an error report:

InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

and they will get it – after I have contacted Jean-Francois Pieronne (who ported MySQL to VMS)


Windows Update Woes
I have some trouble with an Windows Update. Not downloading and installing it, but getting it off the list. The one keeps up appearing as an update to be installed, and by no means I can get rid of it. I asked Microsoft support, the sent me a list of actions to perform, and at some point, the problem seemed solved – but the very next update, trouble re-appeared: I had even two hidden updates, I brought them into view again and behold: I can redo all actions once again. It doesn’t seem to be very troublesome, it’s just annoying, but it’s now what it should be!
Logging issues
Found out that scanning the logfiles for SMTP messages (due to spam attemps) seemed to have failed since 30-Dec-2006. At least, the latest entries in a daily updated list are of that date. What’s the point: I installed VMS 8.3 and that implied TCPIP 5.6. And it seems that the message format has changed:
Scanning on SPAM attempts on SYS$SYSROOT:[SYSMGR]OPERATOR.LOG;1141
Expected TCPIP-W-SMTP, got %TCPIP-W-SMTP_CLNTINRBL, client IP address 69.133.66
No OPCOM line found, got ***************

That means I have to check the scanning procedure. This was not in the relase notes, gentlemen!
Greek hike
The album has been completed and can be visisted at this location.


Power failure
This morning, a power failure of about 3 hours caused all machines to stop. I had to reset Diana completely – it didn’t restart normally. This is unexpected and undesirable behaviour, but simetimes, this just happens. Reset didn’t help, I had to cycle power. But by that, boot went flawlessly and it looks that all went well. DNS worked fine, the blog and forums are fine….

“Members” on the forums

Apart from the ususal spam, nothing really weird happenend lately.
But it’s good to check the forum’s memberlist now and than. I already removed a number of (non-Dutch) guests on my OpenVMS forums that can’t possibly have an real interest. Given the fact that they refer to non-existing e-mail accounts, or websites full of junk (if not worse), these have been removed.
On one of the Windows machines, howver, I have a problem with a patch that keeps re-appearing after install. According Microsoft support, it may have to do with seettings within Internet Explorer, the cach of it, cookies, firewall settings…I have to follow 7 steps to see if the problem gets away – inclusing messing with security. IF such is really the case, WindowsXP is worse than I thought…
However, I could get around the annoying pop-up that tells me that “New updates are available” by swithcing auto-update off all toegther. Not exactly what I want, but that is workable for the moment. But I’ll need to sit and work on that some day. (an evening is too short). I wonder if they think I have all day to repair the junk they make of it ;(