ATDB How to use ATDB     Preferences     Subscribe     Tips & Q&A 
You're not logged on
Username:
Password:

18.97.9.174
Visitor - restrictions apply[ AeroFinder ] [ QueryBuilder ] [ QueryEvents ] [ QueryNews ] [ Help ]

Session limits exceeded for this week
Please subscribe for immediate access

TRACES:


timeline.php
get: operatorID value: 41271
any_sql: set names 'utf8'
->

Entering cookie2php for ATDB5logon: no cookie exists
ATDB5logon cookie values:
env[]=
Entering racf_check memory=2511376
Deadlock Detector - processes:
Array
(
    [0] => Array
        (
            [0] => 11676336
            [1] => aerotran_DBuser
            [2] => localhost
            [3] => aerotran_atdb6
            [4] => Query
            [5] => 0
            [6] => starting
            [7] => show full processlist
            [8] => 0.000
        )

)
Deadlock Detector - continue=true
racf 1: ATDB5logon cookie not found
getIP found IP=18.97.9.174
racf 2: Current IP is 18.97.9.174
racf 2.1: currentIP=18.97.9.174, currentIPmask=18.97.9., previousIP=unknown
racf 3: No logon cookie could be used for this session: First visit, cookie erased or previous logon failed
any_sql: select ifnull(max(logon),'') from atdb5_sessions where ip_address='18.97.9.174' and (to_days(current_date) - to_days(logon) < 7) union all select ifnull(max(logon),'') from atdb5_sessions where ip_address like '18.97.9.%' and (date_add(logon, interval 1 hour) > '2024-12-05 23:09:12') order by 1 desc limit 1
-> 2024-12-03 23:01:06

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 PRIMARY atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 2 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address atdb5_sessions_ip_address 137   3 Using index condition; Using where
  UNION RESULT ALL           Using filesort


racf 3.3: A record was found in session_table for IP=18.97.9.174 within last 7 days or last hour
any_sql: select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address='18.97.9.174' and logon='2024-12-03 23:01:06' union all select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address like '18.97.9.%' and logon='2024-12-03 23:01:06' order by 1 desc limit 1
-> 1733440025097018&V00000000

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 PRIMARY atdb5_sessions ref|filter atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_ip_address|atdb5_sessions_logon 137|8 const 2 (0%) Using index condition; Using where; Using rowid filter
2 UNION atdb5_sessions range|filter atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_ip_address|atdb5_sessions_logon 137|8   3 (0%) Using index condition; Using where; Using rowid filter
  UNION RESULT ALL           Using filesort


writeLogonInfo entered - fcode=c,currentIP=18.97.9.174,customerID=none
writeLogonInfo - Generated keys: IP=18.97.9.174 -> New SessionID=1733440152097018
writeLogonInfo - now=1733440152 , now2=2024-12-05 23:09:12 , cookieExpiry=1733699352
writeLogonInfo - writing cookie:
sid=1733440152097018&custID=none&logon=1733440152&profile=V00000000&ip1=018&ip2=097&userIP=18.97.9.174&racf=4108050209
ccdomain=.aerotransport.org
racf 3.3.1: Wrote new cookie, new SID=1733440152097018 profile=V00000000
any_sql: update atdb5_sessions /* s12 */ set session_id='1733440152097018' where session_id='1733440025097018'
-> 1

racf 3.3.2: Session table updated old SID=1733440025097018 -> new SID=1733440152097018 for IP 18.97.9.174
racf 3 completed
checkCPU entered: IP=18.97.9.174,SID=1733440152097018,userid=,profile=V00000000
any_sql: select concat(sum(queries),'&',sum(requests),'&',sum(sql_cpu),'&',sum(sql_rows),'&',min(substring(profile,1,1))) from atdb5_sessions where ip_address='18.97.9.174' /* and customer_id='none' */ and (to_days(current_date) - to_days(logon) < 7) limit 1
-> 10&36&0.14&195&V

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 SIMPLE atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 2 Using index condition; Using where


checkCPU for this visitor: used_queries=10, used_requests=36, used_cpu=0.14, used_rows=195, profile=V

Entering htmlHeader, HTML length=90
getIP found IP=18.97.9.174
htmlTopBanner: ID=, username=, profile=V00000000
Entering racf_account - SID=1733440152097018, query=
Used for this page: Query=1 Requests=0, Rows=0, CPU=0
No request issued, no resources used
racf_account completed

END TRACES
ENV:
Array
(
    [debug] => 1
    [trace] => 
    [maxDebugMinutes] => 45
    [V] => 6
    [charset] => UTF-8
    [serverURL] => Array
        (
            [0] => aerotransport.org
            [1] => atdb.aero
            [2] => aerotran.o2switch.net
            [3] => aavrane.free.fr
        )

    [root] => https://www.aerotransport.org/
    [home] => https://www.aerotransport.org
    [base] => https://www.aerotransport.org/php/go.php
    [spooled] => ../spooled/
    [DBAemail] => aerotransport@gmail.com
    [DBAdomain] => *.o2switch.net
    [emergencyMirror] => www2.aerotransport.org
    [allowVisitors] => 1
    [DBAonly] => 0
    [server_archive] => 1
    [archiveURL] => http://aavrane.free.fr/aerotransport/V5/
    [maxMemory] => 400000000
    [price_U12] => 104
    [price_E12] => 147
    [price_P1] => 165
    [price_P12] => 1660
    [price_R12] => 2140
    [blackFriday] => 
    [price_U12_regular] => 104
    [price_E12_regular] => 147
    [price_P1_regular] => 165
    [price_P12_regular] => 1660
    [price_R12_regular] => 2140
    [u] => 
    [p] => 
    [profile] => V00000000
    [userid] => 
    [username] => 
    [sid] => 1733440152097018
    [userIP] => unknown
    [lang] => EN
    [client_os] => 
    [client_cpu] => 
    [client_browser] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [maxHTMLrows] => 35
    [maxXLSrows] => 10000
    [maxpictures] => 50
    [partners] => *AJPEHFCSDNMBRX
    [maxSessionHours] => 72
    [maxSessionQueries] => 400
    [maxSessionRequests] => 900
    [maxSessionRows] => 9000
    [thisQueryRequests] => 0
    [thisQueryRows] => 0
    [thisQueryCPU] => 0
    [maxSavedQueries] => 40
    [thisUserQueries] => 0
    [maxTrialQueries] => 3500
    [maxTrialRequests] => 6000
    [maxTrialRows] => 30000
    [maxTrialThreshold] => 0.7
    [maxQuotaU] => 25000
    [maxQuotaE] => 40000
    [maxWeeklyQueries] => 9
    [maxWeeklyRequests] => 50
    [maxWeeklyRows] => 300
    [old2news] => 150
    [warningExpiry] => 12
    [graceDays] => 1
    [logonRetryCount] => 0
    [logonRetryMax] => 5
    [logonRetrySleep] => 20
    [logonRetryLast] => 0
    [maxDomainsWarning] => 3
    [maxDomainsReset] => 5
    [allowHotlinks] => 1
    [allowForeignFrames] => 0
    [automaticPasswordReset] => 1
    [automaticRevoke] => 1
    [enableLogs] => 1
    [enableEncryption] => 1
    [savedQueries] => 300
    [savedVisitorsQueries] => 30
    [blacklist] => erased
    [blackdomains] => Array
        (
            [0] => flightglobal.com
            [1] => rbi.co.uk
            [2] => rbinet.co.uk
            [3] => airclaims
            [4] => impots.gouv.fr
            [5] => cirium.com
            [6] => hwclouds-dns.com
            [7] => petalsearch.com
            [8] => mts-internet.net
        )

    [sampleSpreadsheet] => extant MD-11 in Europe
    [dd_maxFleetSize] => 30
    [] => 
    [pref_bgcolor] => #ffffff
    [pref_fsize] => x-small
    [pref_dateformat] => Y-m-d
    [pref_xpl_built] => 0
    [pref_target] => target=_self
    [pref_maxrecords] => 35
    [pref_partners] => 1
    [pref_no2pict] => 0
    [pref_no2regs] => 0
    [pref_no2safe] => 0
    [pref_unit] => kg
    [ru00_mode] => 21
    [ru10_x_forwarded_for] => 
    [ru20_remote_addr] => 18.97.9.174
    [ru30_http_client_ip] => 
    [ru40_x_forwarded_for] => 
    [ru50_remote_addr] => 
    [ru60_http_client_ip] => 18.97.9.174
    [default_fsize] => x-small
    [phone] => 0
)

memory at end: 2527608

V6 © 1997-2024 AeroTransport Data Bank