Just curious whether this is normal:
I very frequently get strange transaction numbers, that aren't
monotonically increasing. For example, on a server that has only had
a few statements go by:
...
2007-12-19 10:00:42,215 [INFO] pILS Commit transaction 113
2007-12-19 10:00:42,296 [INFO] pILS B 562949953421407
2007-12-19 10:00:42,296 [INFO] pILS S 562949953421407 562949953421407
select ...
2007-12-19 10:00:42,364 [INFO] pILS C 562949953421407
2007-12-19 10:00:42,477 [INFO] pILS W 115 115 insert into foo (bar)
values (1)
2007-12-19 10:00:42,534 [INFO] pILS B 562949953421408
2007-12-19 10:00:42,535 [INFO] pILS W 562949953421408 562949953421408
insert into foo (bar) values (2)
2007-12-19 10:00:42,559 [INFO] pILS W 562949953421408 562949953421408
insert into foo (bar) values (2)
2007-12-19 10:00:42,585 [INFO] pILS Commit transaction 115
2007-12-19 10:00:42,650 [INFO] pILS C 562949953421408
...
I've truncated the sql statements for clarity. In this case, I have
two RAIDb-1 servers for the same vdb, each receiving traffic from a
number of clients simultaneously. This is part of the log for just
one server. Note that I never actually see a "B 115" or a "C 115" on
this host, which I would expect, but I do see it on the other host,
and likewise, on the other host I never see a log message saying "B
562949953421408" or "C 562949953421408". Maybe that's normal. It's
almost like one host is using a different starting point for
transaction numbers than the other...
1. Are the strange transaction numbers normal?
2. It is normal to see writes twice in my logs, right? The request
comes in from the client, which gets logged, and then the request is
broadcast to everyone include the sender, which receives it and logs
it again.
I can provide more details if necessary.
Thanks,
Chris
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
