На тестовом сервере зашли через админку в отчеты по пользователю-> счета->счет за текущий месяц->корректировка позиций счета, нажали ОК, ядро ушло в задумчивость на 1143.435 sec.... Чего оно там делало с базой- непонятно... повторяемо на 100% пользователей
Код: Выделить всё
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM15print_backtraceEv+0x40) [0xb0aa10]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_bNS_6Logger5LevelE+0x96) [0x54c286]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM15DBAGenericErrorC2ERKSsbNS_6Logger5LevelE+0x51) [0x54c371]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess22get_archive_table_nameEiNS_15archive_table_tERSs+0x2e2) [0x96ca22]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess19__get_invoices_listEiPSt3mapIiNS_7InvoiceESt4lessIiESaISt4pairIKiS2_EEEiillb+0x255) [0x9f2b85]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess17get_invoices_listEiPSt3mapIiNS_7InvoiceESt4lessIiESaISt4pairIKiS2_EEEiillb+0x6b) [0x8035cb]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess11get_invoiceEi+0x6e) [0x9f657e]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_Z29rpcf_get_doc_invoices_entriesPv+0x140) [0x840750]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM7RPCConn7processEv+0xfb7) [0x6bc6a7]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /netup/utm5/bin/utm5_core(_ZN3UTM17__rpcconn_wrapperEPv+0x47a) [0x6acd8a]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /lib/x86_64-linux-gnu/libpthread.so.0(+0x6b50) [0x7f22e4a5db50]
Aug 31 10:48:01 ?Trace : db0f0700 trace: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f22e366d95d]
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: SELECT id,ext_num,invoice_date,payment_transaction_id,expire_date,is_payed,is_printed,uid,account_id,arrearage,period_start,period_end,balance_on_set,version,sup_id,user_invoice_date FROM invoices WHERE account_id>'0' AND id='403886' AND invoice_date >='0' AND invoice_date<='2000000000' AND is_deleted='0'
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: 1 rows in 0.001 sec
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='legacy_invoices'
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: 0 rows in 0.000 sec
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: SELECT id,time_range_id,dont_save,local_traf_policy,t_class_name,graph_color,is_display,is_fill FROM t_class WHERE is_deleted='0'
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: 9 rows in 0.001 sec
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: SELECT name,slink_id,discount_period_id,qnt,base_cost,sum_cost,tax_amount,service_type,id,version,alt_amount FROM invoice_entry WHERE invoice_id='403886' AND is_deleted='0'
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: 1 rows in 0.001 sec
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: SELECT type,value FROM invoice_entry_details WHERE entry_id='815679' AND is_deleted='0'
Aug 31 10:48:01 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc028230> SQL SELECT query: 0 rows in 0.027 sec
Aug 31 10:48:01 ?Debug : db0f0700 DBAInvoice: invoice_id <403886> has 1 rows
Aug 31 10:48:01 ?Debug : db0f0700 DBConnectionPoolImpl: [2]: connection <0x15465f0> is pushed back
Aug 31 10:48:01 ?Debug : db0f0700 RPCConn[SSL]<andrey_1@192.168.84.254>: Call 0x7040 (rpcf_get_doc_invoices_entries) finished in 0.10 sec
Aug 31 10:48:01 ?Debug : db0f0700 RPCConn[SSL]<andrey_1@192.168.84.254>: Stream cleared
Aug 31 10:48:04 ?Debug : db0f0700 RPCConn[SSL]<andrey_1@192.168.84.254>: URFA ping received, sending reply
Aug 31 10:48:04 ?Debug : db0f0700 RPCConn[SSL]<andrey_1@192.168.84.254>: Call: 0x7041 (rpcf_reverse_invoice_entry)
Aug 31 10:48:04 ?Debug : db0f0700 RPCConn[SSL]<andrey_1@192.168.84.254>: Real Call: 0x7041 (rpcf_reverse_invoice_entry)
Aug 31 10:48:04 ?Debug : db0f0700 DBConnectionPoolImpl: [2]: connection <0x7f22dc021430> is popped
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT discount_period_id, sum_cost, slink_id, invoice_id, tax_amount FROM invoice_entry WHERE id='815679' AND is_deleted='0'
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 1 rows in 0.000 sec
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT account_id FROM invoices WHERE id='403886' AND is_deleted='0'
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 1 rows in 0.000 sec
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT start_date FROM discount_periods WHERE id='9472'
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 1 rows in 0.000 sec
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT archive_id,start_date,end_date FROM archives ORDER BY id
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 252 rows in 0.020 sec
Aug 31 10:48:04 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT MAX(id) FROM discount_transactions_all WHERE discount_period_id='9472' AND slink_id='204709' AND charge_type='2'
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 1 rows in 1143.435 sec
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: SELECT discount FROM discount_transactions_all WHERE id = '547415242'
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL SELECT query: 1 rows in 0.024 sec
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL query: UPDATE discount_transactions_all SET discount=discount+'0', discount_with_tax=discount_with_tax+'0', outgoing_rest=outgoing_rest-'0' WHERE id = '547415242'
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL query takes 0.000 sec
Aug 31 11:07:08 ?Debug : db0f0700 DBConnection_mysql: <0x7f22dc02ead0> SQL query: UPDATE discount_transactions_all SET incoming_rest=incoming_rest-'0', outgoing_rest=outgoing_rest-'0' WHERE id>'547415242' AND account_id='11069'