Hi,
Seems that mySql sometime write Querys to Log but does
not execute them. I found folling in the MySql Log-File.
Comments made by me are signed with "->".
Maybe some one has a solution for that ?
# at 5636748
#021216 15:27:38 server id 1 Intvar
SET INSERT_ID = 189612;
# at 5636770
#021216 15:27:38 server id 1 Query thread_id=18485 exec_time=0 error_code=0
SET TIMESTAMP=1040048858;
insert into billing_iteminfo (`bid_id`, `user_id`, `order_id`, `item_x`, `item_id`,
`item_txt`, `item_quant`, `auction_profile`, `auction_seller`, `auction_name`,
`auction_itemid`, `bidder_alias`, `bidder_email`, `org_price`, `org_currency`,
`usr_price`, `usr_single`, `usr_currency`, `cust_price`, `cust_single`,
`cust_currency`) VALUES ('200375', '12345', '988-14230/100369DE', '1', '0',
'VALENTINO', '1', 'STANDARD', 'winner', 'Nowhere', '488', 'kefgdfggish',
'yoman@nowhere', '79', '~@', '79.00', '79.00', 'EUR', '79.00', '79.00', 'EUR');
-> this is ok !!!
# at 5637404
#021216 15:27:38 server id 1 Query thread_id=18485 exec_time=0 error_code=0
SET TIMESTAMP=1040048858;
update bidder_bidinfo set chk_buy='1', order_id='992600446488-14230/100369DE',
order_dat=NOW() where user_id='100369' and bid_id='200375';
-> this is ok !!!
# at 5637576
#021216 15:27:38 server id 1 Intvar
SET INSERT_ID = 189613;
# at 5637598
#021216 15:27:38 server id 1 Query thread_id=18485 exec_time=0 error_code=0
SET TIMESTAMP=1040048858;
insert into billing_iteminfo (`bid_id`, `user_id`, `order_id`, `item_x`, `item_id`,
`item_txt`, `item_quant`, `auction_profile`, `auction_seller`, `auction_name`,
`auction_itemid`, `bidder_alias`, `bidder_email`, `org_price`, `org_currency`,
`usr_price`, `usr_single`, `usr_currency`, `cust_price`, `cust_single`,
`cust_currency`) VALUES ('200377', '12345', '988-14230/100369DE', '1', '0',
'VALENTINO', '1', 'STANDARD', 'winner', 'Nowhere', '488', 'kefgdfggish',
'yoman@nowhere', '79', '~@', '79.00', '79.00', 'EUR', '79.00', '79.00', 'EUR');
-> this data cannot be found in Database. Dataset "189613" ist still missing
-> (AutoInc-Row: 189611, 189612, 189614, ...) !!!
# at 5638232
#021216 15:27:38 server id 1 Query thread_id=18485 exec_time=0 error_code=0
SET TIMESTAMP=1040048858;
update bidder_bidinfo set chk_buy='1', order_id='992600446488-14230/100369DE',
order_dat=NOW() where user_id='100369' and bid_id='200377';
-> this is ok !!!
# at 5638404
#021216 15:27:38 server id 1 Intvar
Regards,
Bjoern Mueller
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
