Кто сталкивался с подобным?
Архивированы все таблицы однотипно, даты в "квартальных таблицах" - одинаковые, ниже показан только тип 5.
Код: Выделить всё
mysql> SELECT * FROM archives WHERE table_type='5';
+----+------------+------------+-----------------------------------+------------+------------+
| id | archive_id | table_type | table_name | start_date | end_date |
+----+------------+------------+-----------------------------------+------------+------------+
| 23 | 21 | 5 | UTM5_arch.dhs_sessions_log_2007 | 1196246824 | 1199134640 |
| 28 | 26 | 5 | UTM5_arch.dhs_sessions_log_2008_1 | 1199134800 | 1206993599 |
| 33 | 31 | 5 | UTM5_arch.dhs_sessions_log_2008_2 | 1206993683 | 1214855999 |
| 38 | 36 | 5 | UTM5_arch.dhs_sessions_log_2008_3 | 1214856289 | 1222804799 |
| 43 | 41 | 5 | UTM5_arch.dhs_sessions_log_2008_4 | 1214857340 | 1230757199 |
| 48 | 46 | 5 | UTM5_arch.dhs_sessions_log_2009_1 | 1230757613 | 1238529599 |
| 53 | 51 | 5 | UTM5_arch.dhs_sessions_log_2009_2 | 1238530104 | 1246391999 |
| 58 | 56 | 5 | UTM5_arch.dhs_sessions_log_2009_3 | 1246392318 | 1254340799 |
| 63 | 61 | 5 | UTM5_arch.dhs_sessions_log_2009_4 | 1254340800 | 1262293199 |
+----+------------+------------+-----------------------------------+------------+------------+
9 rows in set (0.00 sec)
Код: Выделить всё
?Debug : Feb 09 03:46:26 RPCConn[SSL]<---admin-host--->: Call: 0x5015 (__rpcs_get_dhs_report)
?Debug : Feb 09 03:46:26 RPCConn[SSL]<---admin-host--->: Real Call: 0x5015 (__rpcs_get_dhs_report)
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT archive_id,start_date,end_date FROM archives ORDER BY id
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <11> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <12> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <13> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <14> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <15> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <16> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <17> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <18> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <44> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <45> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <46> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <47> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <48> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <49> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <50> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <51> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <52> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <53> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <54> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <55> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <56> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <57> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <58> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <59> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <60> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <61> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <62> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: archive ID <63> case: start <= per_start && end >= per_end
?Debug : Feb 09 03:46:26 UTM5 DBA: start(1230757200) < r(1262293199) < end(1267390800), adding non-archive table into report
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='11' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 11
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='12' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 12
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='13' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 13
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='14' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 14
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='15' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 15
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='16' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 16
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='17' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 17
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='18' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 18
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='44' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 44
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='45' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 45
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='46' AND table_type='5'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='46' AND table_type='6'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_detail not exists in archive_id 46
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='47' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 47
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='48' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 48
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='49' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 49
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='50' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 50
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='51' AND table_type='5'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='51' AND table_type='6'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_detail not exists in archive_id 51
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='52' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 52
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='53' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 53
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='54' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 54
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='55' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 55
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='56' AND table_type='5'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='56' AND table_type='6'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_detail not exists in archive_id 56
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='57' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 57
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='58' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 58
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='59' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 59
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='60' AND table_type='5'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='58' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 58
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='59' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 59
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='60' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 60
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='61' AND table_type='5'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='61' AND table_type='6'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_detail not exists in archive_id 61
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='62' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 62
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT table_name FROM archives WHERE archive_id='63' AND table_type='5'
?Debug : Feb 09 03:46:26 UTM5 DBA: table dhs_sessions_log not exists in archive_id 63
ERROR : Feb 09 03:46:26 DBAStringError: table not exists in this archive
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT id,account_id,slink_id,recv_date,last_update_date,Framed_IP_Address,NAS_Port,
Acct_Session_Id,NAS_Port_Type,User_Name,Service_Type,Framed_Protocol,
NAS_IP_Address,NAS_Id,Acct_Status_Type,Acct_Input_Packets,Acct_Input_Octets,
Acct_Output_Packets,Acct_Output_Octets,Acct_Session_Time,Called_Station_Id,
Calling_Station_Id,Acct_Input_Gigawords,Acct_Output_Gigawords,Acct_Terminate_Cause
FROM dhs_sessions_log
WHERE last_update_date>='1262293199' AND last_update_date<='1267390800' AND account_id='3364'
?Debug : Feb 09 03:46:26 DBCtx: <680568832> SQL SELECT query: SELECT dhs_sess_id,recv_date,account_id,trange_id,duration,base_cost,sum_cost FROM dhs_sessions_detail WHERE recv_date>='1262293199' AND recv_date<='1267390800' AND account_id='3364'
?Debug : Feb 09 03:46:27 UTM5 DBA: dhs_access_log disabled, set access_log_write=1 in the utm5_settings to enable
?Debug : Feb 09 03:46:27 RPCConn[SSL]<---admin-host--->: Call 0x5015 (__rpcs_get_dhs_report) finished...