Код:
07-03/01:15:26 ERROR [event-proc-p-2-t-1] DefaultServerSetup - Many statements was open at connection close:
com.mysql.jdbc.ServerPreparedStatement[6468] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=335 AND contractId=6698 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6494] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6698 AND product.accountId=335 AND period.contractId=6698 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6520] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=479 AND contractId=6717 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6521] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6717 AND product.accountId=479 AND period.contractId=6717 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6560] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=383 AND contractId=6746 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6561] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6746 AND product.accountId=383 AND period.contractId=6746 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6568] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=441 AND contractId=6749 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6569] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6749 AND product.accountId=441 AND period.contractId=6749 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6576] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=468 AND contractId=6752 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6577] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6752 AND product.accountId=468 AND period.contractId=6752 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6582] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=431 AND contractId=6754 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6583] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6754 AND product.accountId=431 AND period.contractId=6754 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6608] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=333 AND contractId=6770 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6609] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6770 AND product.accountId=333 AND period.contractId=6770 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6614] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=735 AND contractId=6771 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6615] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6771 AND product.accountId=735 AND period.contractId=6771 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:23' OR (product.timeTo<='2015-07-03 01:15:23' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6647] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=363 AND contractId=6807 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6648] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6807 AND product.accountId=363 AND period.contractId=6807 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6657] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=341 AND contractId=6815 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6658] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6815 AND product.accountId=341 AND period.contractId=6815 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6685] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=349 AND contractId=6838 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6686] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6838 AND product.accountId=349 AND period.contractId=6838 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6695] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=351 AND contractId=6844 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6696] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6844 AND product.accountId=351 AND period.contractId=6844 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6711] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=740 AND contractId=6858 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6712] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6858 AND product.accountId=740 AND period.contractId=6858 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6727] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=369 AND contractId=6867 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6728] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6867 AND product.accountId=369 AND period.contractId=6867 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6735] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=690 AND contractId=6870 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6736] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6870 AND product.accountId=690 AND period.contractId=6870 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6743] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=404 AND contractId=6874 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6744] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6874 AND product.accountId=404 AND period.contractId=6874 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6759] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=719 AND contractId=6885 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6760] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6885 AND product.accountId=719 AND period.contractId=6885 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6765] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=729 AND contractId=6886 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6766] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6886 AND product.accountId=729 AND period.contractId=6886 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6773] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=731 AND contractId=6889 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6774] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6889 AND product.accountId=731 AND period.contractId=6889 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6785] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=723 AND contractId=6901 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6786] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6901 AND product.accountId=723 AND period.contractId=6901 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6809] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=399 AND contractId=6922 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6810] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6922 AND product.accountId=399 AND period.contractId=6922 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6823] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=397 AND contractId=6936 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6824] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6936 AND product.accountId=397 AND period.contractId=6936 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6839] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=401 AND contractId=6949 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6840] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6949 AND product.accountId=401 AND period.contractId=6949 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6868] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=408 AND contractId=6968 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6869] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6968 AND product.accountId=408 AND period.contractId=6968 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6892] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=410 AND contractId=6985 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6893] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=6985 AND product.accountId=410 AND period.contractId=6985 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6932] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=422 AND contractId=7020 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6933] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7020 AND product.accountId=422 AND period.contractId=7020 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6940] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=425 AND contractId=7022 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6941] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7022 AND product.accountId=425 AND period.contractId=7022 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6960] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=781 AND contractId=7039 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6961] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7039 AND product.accountId=781 AND period.contractId=7039 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[6990] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=437 AND contractId=7064 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[6991] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7064 AND product.accountId=437 AND period.contractId=7064 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7000] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=439 AND contractId=7067 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7001] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7067 AND product.accountId=439 AND period.contractId=7067 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7038] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=459 AND contractId=7096 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7039] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7096 AND product.accountId=459 AND period.contractId=7096 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7054] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=447 AND contractId=7105 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7055] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7105 AND product.accountId=447 AND period.contractId=7105 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7066] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=767 AND contractId=7109 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7067] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7109 AND product.accountId=767 AND period.contractId=7109 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7082] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=776 AND contractId=7115 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7083] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7115 AND product.accountId=776 AND period.contractId=7115 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7098] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=481 AND contractId=7126 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7099] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7126 AND product.accountId=481 AND period.contractId=7126 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7141] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=466 AND contractId=7174 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7142] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7174 AND product.accountId=466 AND period.contractId=7174 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7173] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=763 AND contractId=7197 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7174] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7197 AND product.accountId=763 AND period.contractId=7197 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:24' OR (product.timeTo<='2015-07-03 01:15:24' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7197] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=477 AND contractId=7217 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7198] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7217 AND product.accountId=477 AND period.contractId=7217 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7209] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=530 AND contractId=7221 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7210] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7221 AND product.accountId=530 AND period.contractId=7221 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7306] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=658 AND contractId=7325 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7307] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7325 AND product.accountId=658 AND period.contractId=7325 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7344] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=706 AND contractId=7355 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7345] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7355 AND product.accountId=706 AND period.contractId=7355 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7390] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=518 AND contractId=7393 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7391] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7393 AND product.accountId=518 AND period.contractId=7393 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7414] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=534 AND contractId=7411 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7415] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7411 AND product.accountId=534 AND period.contractId=7411 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7430] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=747 AND contractId=7422 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7431] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7422 AND product.accountId=747 AND period.contractId=7422 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7466] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=660 AND contractId=7450 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7467] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7450 AND product.accountId=660 AND period.contractId=7450 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7476] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=650 AND contractId=7455 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7477] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7455 AND product.accountId=650 AND period.contractId=7455 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7508] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=668 AND contractId=7478 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7509] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7478 AND product.accountId=668 AND period.contractId=7478 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7516] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=676 AND contractId=7480 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7517] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7480 AND product.accountId=676 AND period.contractId=7480 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
com.mysql.jdbc.ServerPreparedStatement[7599] - SELECT id, deviceId, deviceState, deviceOptions FROM tv_account_22 WHERE id=699 AND contractId=7541 FOR UPDATE
com.mysql.jdbc.ServerPreparedStatement[7600] - SELECT period.id, period.activationTime, period.timeFrom, period.timeTo, period.flags, product.id, product.productSpecId, product.activationModeId, product.activationTime, product.activationPrice, product.timeFrom, product.timeTo, product.deviceState FROM inv_product as product LEFT JOIN inv_product_period as period ON period.productId=product.id WHERE product.contractId=7541 AND product.accountId=699 AND period.contractId=7541 AND period.flags=1 AND (period.timeTo<='2015-07-03 01:15:25' OR (product.timeTo<='2015-07-03 01:15:25' AND period.timeTo>product.timeTo)) AND product.id IS NOT NULL LOCK IN SHARE MODE
java.lang.RuntimeException
at ru.bitel.bgbilling.server.util.DefaultServerSetup$2$1.close(DefaultServerSetup.java:417)
at ru.bitel.bgbilling.server.util.PoolGuardConnectionWrapper.close(PoolGuardConnectionWrapper.java:48)
at ru.bitel.common.sql.ConnectionSet.recycle(ConnectionSet.java:272)
at ru.bitel.bgbilling.kernel.container.managed.ServerContext.recycle(ServerContext.java:370)
at ru.bitel.common.worker.WorkerTask.run(WorkerTask.java:103)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
at ru.bitel.common.worker.WorkerThread.run(WorkerThread.java:46)