CR50iNG SFOS 17.5.15 MR-15 Logs Stopped Working

Hi,

i have a problem with logs, they are not updated live. I cant see any logs any more, support say to me maybe harddrive failure or capacity filled up, i try to purge all old logs but it doesnt work either,

console> sys dia show disk

Partition       Utilization(%)

===============================

configuration       18%

content             31%

report              17%

console>

any ideas how i can fix this ?



Edited TAGs
[edited by: emmosophos at 8:36 PM (GMT -7) on 5 Apr 2021]
Parents
  • Hi ,

    Thank you for reaching out to Sophos Community.

    Please ensure that logging is enabled for required modules.

    Click here to find more information on "How to enable logging".

    Also, confirm that on-box reporting is enabled.

    ==> Login to SSH > 4. Device Console

    console> show on-box-reports
    Local Reporting : on

    To enable it: console> set on-box-reports on

    Check whether garner service is in running state or not.

    ==> Login to SSH > 5. Device Management > 3. Advanced Shell

    # service -S | grep garner

    Thanks,
    Yash Kothari
    Community Support Engineer | Sophos Technical Support
    Sophos Support Videos | Product Documentation | @SophosSupport | Sign up for SMS Alerts
    If a post solves your question, use the 'Verify Answer' link.
  • Sophos Firmware Version SFOS 17.5.15 MR-15

    console> show on-box-reports
    Local Reporting : on

    console> set on-box-reports on
    console>


    CR50iNG_AM03_SFOS 17.5.15 MR-15# service -S|grep garner
    garner               RUNNING
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

    nothing changed.

  • Can you please share output of the below commands?

    17.5.15 MR-15# ls -lahr /var/cores

    17.5.15 MR-15# service -S | grep postgres

    17.5.15 MR-15# service -S | grep reportdb

    17.5.15 MR-15# tail -n 30 /log/postgres.log

    17.5.15 MR-15# tail -n 30 /log/garner.log

    17.5.15 MR-15# tail -n 30 /log/reportdb.log

    Thanks,
    Yash Kothari
    Community Support Engineer | Sophos Technical Support
    Sophos Support Videos | Product Documentation | @SophosSupport | Sign up for SMS Alerts
    If a post solves your question, use the 'Verify Answer' link.
  • CR50iNG_AM03_SFOS 17.5.15 MR-15# ls -lahr /var/cores
    -rw-------    1 root     0         302.7M Jun  7  2018 core.EpollWorker_01
    -rw-------    1 root     0         192.6M Feb  1  2019 core.EpollWorker_00
    drwxr-xr-x   43 root     0           4.0K Apr  5 00:56 ..
    drwxrwxrwx    2 root     0           4.0K Apr 17  2018 .
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

    CR50iNG_AM03_SFOS 17.5.15 MR-15# service -S|grep postgres
    postgres             RUNNING
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

    CR50iNG_AM03_SFOS 17.5.15 MR-15# service -S|grep reportdb
    reportdb             RUNNING
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

    CR50iNG_AM03_SFOS 17.5.15 MR-15# tail -n 30 /log/postgres.log
    985 2021-03-25 14:20:20.286 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.286 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.287 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.403 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.403 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.407 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.407 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.502 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.502 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.502 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.502 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.503 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.503 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.801 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.801 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.801 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.801 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.802 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.914 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.914 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.915 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.915 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.915 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.950 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    985 2021-03-25 14:20:20.950 GMTLOG:  could not write temporary statistics file "/tmp/pgstat.tmp": No space left on device
    981 2021-03-25 14:20:21.371 GMTLOG:  shutting down
    981 2021-03-25 14:20:21.395 GMTLOG:  database system is shut down
    980 2021-03-25 14:21:02.277 GMTLOG:  database system was shut down at 2021-03-25 14:20:21 GMT
    979 2021-03-25 14:21:02.814 GMTLOG:  database system is ready to accept connections
    984 2021-03-25 14:21:02.814 GMTLOG:  autovacuum launcher started

    CR50iNG_AM03_SFOS 17.5.15 MR-15# tail -n 30 /log/garner.log
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:sfeventsfts_insert_data failed
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:sfeventsfts_insert_data failed
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:sfeventsfts_insert_data failed
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    Error: no such table: tbllog
    SFEVENTSFTS: Apr 05 11:01:02:create_table: execute_sqlite_query(creating table) failed
    SFEVENTSFTS: Apr 05 11:01:02:sqlite_db_insert_data: table 'tbllog' couldn't created
    SFEVENTSFTS: Apr 05 11:01:02:sfeventsfts_insert_data failed
    SFEVENTSFTS: Apr 05 11:01:02:execute_sqlite_prepared_stmt: stmt execution failed: fts5: error creating shadow table tbllog_docsize: table 'tbllog_docsize' already exists
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

    CR50iNG_AM03_SFOS 17.5.15 MR-15# tail -n 30 /log/reportdb.log
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    11248 2021-04-05 07:30:35.554 GMTSTATEMENT:   Select  event_proc_010();
    8388 2021-04-05 07:43:03.423 GMTERROR:  value too long for type character varying(512)
    8388 2021-04-05 07:43:03.423 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210775 UNION ALL Select *,4 as tmp from available_event_datav6_1617263104 UNION ALL Select *,5 as tmp from available_event_datav6_1617293401 UNION ALL Select *,6 as tmp from available_event_datav6_1617267005 UNION ALL Select *,7 as tmp from available_event_datav6_1617071701 UNION ALL Select *,8 as tmp from available_event_datav6_1617268034 UNION ALL Select *,9 as tmp from available_event_datav6_1617084326 UNION ALL Select *,10 as tmp from available_event_datav6_1617299102 UNION ALL Select *,11 as tmp from available_event_datav6_1617262801 UNION ALL Select *,12 as tmp from available_event_datav6_1617209701 UNION ALL Select *,13 as tmp from available_event_datav6_1617291967 UNION ALL Select *,14 as tmp from available_event_datav6_1617261301 UNION ALL Select *,15 as tmp from available_event_datav6_1617290882 UNION ALL Select *,16 as tmp from available_event_datav6_1617292501 UNION ALL Select *,17 as tmp from available_event_datav6_1617300601 UNION ALL Select *,18 as tmp from available_event_datav6_1617297001 UNION ALL Select *,19 as tmp from available_event_datav6_1617293701 UNION ALL Select *,20 as tmp from available_event_datav6_1617296721 UNION ALL Select *,21 as tmp from available_event_datav6_1617294901 UNION ALL Select *,22 as tmp from available_event_datav6_1617295501 UNION ALL Select *,23 as tmp from available_event_datav6_1617295801 UNION ALL Select *,24 as tmp from available_event_datav6_1617299403 UNION ALL Select *,25 as tmp from available_event_datav6_1617296101 UNION ALL Select *,26 as tmp from available_event_datav6_1617584101 UNION ALL Select *,27 as tmp from available_event_datav6_1617297301 UNION ALL Select *,28 as tmp from available_event_datav6_1617301801 UNION ALL Select *,29 as tmp from available_event_datav6_1617584402 UNION ALL Select *,30 as tmp from available_event_datav6_1617584701 UNION ALL Select *,31 as tmp from available_event_datav6_1617585001 UNION ALL Select *,32 as tmp from available_event_datav6_1617297624 UNION ALL Select *,33 as tmp from available_event_datav6_1617585302 UNION ALL Select *,34 as tmp from available_event_datav6_1617262516 UNION ALL Select *,35 as tmp from available_event_datav6_1617585749 UNION ALL Select *,36 as tmp from available_event_datav6_1617585902 UNION ALL Select *,37 as tmp from available_event_datav6_1617586202 UNION ALL Select *,38 as tmp from available_event_datav6_1617297900 UNION ALL Select *,39 as tmp from available_event_datav6_1617299701 UNION ALL Select *,40 as tmp from available_event_datav6_1617586501 UNION ALL Select *,41 as tmp from available_event_datav6_1617300901 UNION ALL Select *,42 as tmp from available_event_datav6_1617291057 UNION ALL Select *,43 as tmp from available_event_datav6_1617586802 UNION ALL Select *,44 as tmp from available_event_datav6_1617587102 UNION ALL Select *,45 as tmp from available_event_datav6_1617298201 UNION ALL Select *,46 as tmp from available_event_datav6_1617587402 UNION ALL Select *,47 as tmp from available_event_datav6_1617587701 UNION ALL Select *,48 as tmp from available_event_datav6_1617294613 UNION ALL Select *,49 as tmp from available_event_datav6_1617588230 UNION ALL Select *,50 as tmp from available_event_datav6_1617588367 UNION ALL Select *,51 as tmp from available_event_datav6_1617588602 UNION ALL Select *,52 as tmp from available_event_datav6_1617588979 UNION ALL Select *,53 as tmp from available_event_datav6_1617298501 UNION ALL Select *,54 as tmp from available_event_datav6_1617300002 UNION ALL Select *,55 as tmp from available_event_datav6_1617209401 UNION ALL Select *,56 as tmp from available_event_datav6_1617589219 UNION ALL Select *,57 as tmp from available_event_datav6_1617589501 UNION ALL Select *,58 as tmp from available_event_datav6_1617073202 UNION ALL Select *,59 as tmp from available_event_datav6_1617589802  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    8388 2021-04-05 07:43:03.423 GMTSTATEMENT:   Select  event_proc_010();
    14398 2021-04-05 07:50:39.601 GMTERROR:  value too long for type character varying(512)
    14398 2021-04-05 07:50:39.601 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210775 UNION ALL Select *,4 as tmp from available_event_datav6_1617263104 UNION ALL Select *,5 as tmp from available_event_datav6_1617293401 UNION ALL Select *,6 as tmp from available_event_datav6_1617267005 UNION ALL Select *,7 as tmp from available_event_datav6_1617071701 UNION ALL Select *,8 as tmp from available_event_datav6_1617268034 UNION ALL Select *,9 as tmp from available_event_datav6_1617084326 UNION ALL Select *,10 as tmp from available_event_datav6_1617299102 UNION ALL Select *,11 as tmp from available_event_datav6_1617262801 UNION ALL Select *,12 as tmp from available_event_datav6_1617209701 UNION ALL Select *,13 as tmp from available_event_datav6_1617291967 UNION ALL Select *,14 as tmp from available_event_datav6_1617261301 UNION ALL Select *,15 as tmp from available_event_datav6_1617290882 UNION ALL Select *,16 as tmp from available_event_datav6_1617292501 UNION ALL Select *,17 as tmp from available_event_datav6_1617300601 UNION ALL Select *,18 as tmp from available_event_datav6_1617297001 UNION ALL Select *,19 as tmp from available_event_datav6_1617293701 UNION ALL Select *,20 as tmp from available_event_datav6_1617296721 UNION ALL Select *,21 as tmp from available_event_datav6_1617294901 UNION ALL Select *,22 as tmp from available_event_datav6_1617295501 UNION ALL Select *,23 as tmp from available_event_datav6_1617295801 UNION ALL Select *,24 as tmp from available_event_datav6_1617299403 UNION ALL Select *,25 as tmp from available_event_datav6_1617296101 UNION ALL Select *,26 as tmp from available_event_datav6_1617584101 UNION ALL Select *,27 as tmp from available_event_datav6_1617297301 UNION ALL Select *,28 as tmp from available_event_datav6_1617301801 UNION ALL Select *,29 as tmp from available_event_datav6_1617584402 UNION ALL Select *,30 as tmp from available_event_datav6_1617584701 UNION ALL Select *,31 as tmp from available_event_datav6_1617585001 UNION ALL Select *,32 as tmp from available_event_datav6_1617297624 UNION ALL Select *,33 as tmp from available_event_datav6_1617585302 UNION ALL Select *,34 as tmp from available_event_datav6_1617262516 UNION ALL Select *,35 as tmp from available_event_datav6_1617585749 UNION ALL Select *,36 as tmp from available_event_datav6_1617585902 UNION ALL Select *,37 as tmp from available_event_datav6_1617586202 UNION ALL Select *,38 as tmp from available_event_datav6_1617297900 UNION ALL Select *,39 as tmp from available_event_datav6_1617299701 UNION ALL Select *,40 as tmp from available_event_datav6_1617586501 UNION ALL Select *,41 as tmp from available_event_datav6_1617300901 UNION ALL Select *,42 as tmp from available_event_datav6_1617291057 UNION ALL Select *,43 as tmp from available_event_datav6_1617586802 UNION ALL Select *,44 as tmp from available_event_datav6_1617587102 UNION ALL Select *,45 as tmp from available_event_datav6_1617298201 UNION ALL Select *,46 as tmp from available_event_datav6_1617587402 UNION ALL Select *,47 as tmp from available_event_datav6_1617587701 UNION ALL Select *,48 as tmp from available_event_datav6_1617294613 UNION ALL Select *,49 as tmp from available_event_datav6_1617588230 UNION ALL Select *,50 as tmp from available_event_datav6_1617588367 UNION ALL Select *,51 as tmp from available_event_datav6_1617588602 UNION ALL Select *,52 as tmp from available_event_datav6_1617588979 UNION ALL Select *,53 as tmp from available_event_datav6_1617298501 UNION ALL Select *,54 as tmp from available_event_datav6_1617300002 UNION ALL Select *,55 as tmp from available_event_datav6_1617209401 UNION ALL Select *,56 as tmp from available_event_datav6_1617589219 UNION ALL Select *,57 as tmp from available_event_datav6_1617589501 UNION ALL Select *,58 as tmp from available_event_datav6_1617073202 UNION ALL Select *,59 as tmp from available_event_datav6_1617589802  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    14398 2021-04-05 07:50:39.601 GMTSTATEMENT:   Select  event_proc_010();
    22756 2021-04-05 07:51:06.615 GMTERROR:  value too long for type character varying(512)
    22756 2021-04-05 07:51:06.615 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210001 UNION ALL Select *,4 as tmp from available_event_datav6_1617261918 UNION ALL Select *,5 as tmp from available_event_datav6_1617293100 UNION ALL Select *,6 as tmp from available_event_datav6_1617291107 UNION ALL Select *,7 as tmp from available_event_datav6_1617070201 UNION ALL Select *,8 as tmp from available_event_datav6_1617292802 UNION ALL Select *,9 as tmp from available_event_datav6_1617294001 UNION ALL Select *,10 as tmp from available_event_datav6_1617294300 UNION ALL Select *,11 as tmp from available_event_datav6_1617295201 UNION ALL Select *,12 as tmp from available_event_datav6_1617296401 UNION ALL Select *,13 as tmp from available_event_datav6_1617261601 UNION ALL Select *,14 as tmp from available_event_datav6_1617583802 UNION ALL Select *,15 as tmp from available_event_datav6_1617291301 UNION ALL Select *,16 as tmp from available_event_datav6_1617599237 UNION ALL Select *,17 as tmp from available_event_datav6_1617601618 UNION ALL Select *,18 as tmp from available_event_datav6_1617210775 UNION ALL Select *,19 as tmp from available_event_datav6_1617263104 UNION ALL Select *,20 as tmp from available_event_datav6_1617293401 UNION ALL Select *,21 as tmp from available_event_datav6_1617267005 UNION ALL Select *,22 as tmp from available_event_datav6_1617071701 UNION ALL Select *,23 as tmp from available_event_datav6_1617268034 UNION ALL Select *,24 as tmp from available_event_datav6_1617084326 UNION ALL Select *,25 as tmp from available_event_datav6_1617299102 UNION ALL Select *,26 as tmp from available_event_datav6_1617262801 UNION ALL Select *,27 as tmp from available_event_datav6_1617209701 UNION ALL Select *,28 as tmp from available_event_datav6_1617291967 UNION ALL Select *,29 as tmp from available_event_datav6_1617261301 UNION ALL Select *,30 as tmp from available_event_datav6_1617290882 UNION ALL Select *,31 as tmp from available_event_datav6_1617292501 UNION ALL Select *,32 as tmp from available_event_datav6_1617300601 UNION ALL Select *,33 as tmp from available_event_datav6_1617297001 UNION ALL Select *,34 as tmp from available_event_datav6_1617293701 UNION ALL Select *,35 as tmp from available_event_datav6_1617296721 UNION ALL Select *,36 as tmp from available_event_datav6_1617294901 UNION ALL Select *,37 as tmp from available_event_datav6_1617295501 UNION ALL Select *,38 as tmp from available_event_datav6_1617295801 UNION ALL Select *,39 as tmp from available_event_datav6_1617299403 UNION ALL Select *,40 as tmp from available_event_datav6_1617296101 UNION ALL Select *,41 as tmp from available_event_datav6_1617584101 UNION ALL Select *,42 as tmp from available_event_datav6_1617297301 UNION ALL Select *,43 as tmp from available_event_datav6_1617301801 UNION ALL Select *,44 as tmp from available_event_datav6_1617584402 UNION ALL Select *,45 as tmp from available_event_datav6_1617584701 UNION ALL Select *,46 as tmp from available_event_datav6_1617585001 UNION ALL Select *,47 as tmp from available_event_datav6_1617297624 UNION ALL Select *,48 as tmp from available_event_datav6_1617585302 UNION ALL Select *,49 as tmp from available_event_datav6_1617262516 UNION ALL Select *,50 as tmp from available_event_datav6_1617585749 UNION ALL Select *,51 as tmp from available_event_datav6_1617585902 UNION ALL Select *,52 as tmp from available_event_datav6_1617586202 UNION ALL Select *,53 as tmp from available_event_datav6_1617297900 UNION ALL Select *,54 as tmp from available_event_datav6_1617299701 UNION ALL Select *,55 as tmp from available_event_datav6_1617586501 UNION ALL Select *,56 as tmp from available_event_datav6_1617300901 UNION ALL Select *,57 as tmp from available_event_datav6_1617291057 UNION ALL Select *,58 as tmp from available_event_datav6_1617586802 UNION ALL Select *,59 as tmp from available_event_datav6_1617587102  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    22756 2021-04-05 07:51:06.616 GMTSTATEMENT:   Select  event_proc_010();
    22866 2021-04-05 07:51:07.128 GMTERROR:  value too long for type character varying(512)
    22866 2021-04-05 07:51:07.128 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617210001 UNION ALL Select *,1 as tmp from available_event_datav6_1617261918 UNION ALL Select *,2 as tmp from available_event_datav6_1617293100 UNION ALL Select *,3 as tmp from available_event_datav6_1617291107 UNION ALL Select *,4 as tmp from available_event_datav6_1617070201 UNION ALL Select *,5 as tmp from available_event_datav6_1617292802 UNION ALL Select *,6 as tmp from available_event_datav6_1617294001 UNION ALL Select *,7 as tmp from available_event_datav6_1617294300 UNION ALL Select *,8 as tmp from available_event_datav6_1617295201 UNION ALL Select *,9 as tmp from available_event_datav6_1617296401 UNION ALL Select *,10 as tmp from available_event_datav6_1617261601 UNION ALL Select *,11 as tmp from available_event_datav6_1617583802 UNION ALL Select *,12 as tmp from available_event_datav6_1617291301 UNION ALL Select *,13 as tmp from available_event_datav6_1617599237 UNION ALL Select *,14 as tmp from available_event_datav6_1617601618 UNION ALL Select *,15 as tmp from available_event_datav6_1617298801 UNION ALL Select *,16 as tmp from available_event_datav6_1617300301 UNION ALL Select *,17 as tmp from available_event_datav6_1617301501 UNION ALL Select *,18 as tmp from available_event_datav6_1617210775 UNION ALL Select *,19 as tmp from available_event_datav6_1617263104 UNION ALL Select *,20 as tmp from available_event_datav6_1617293401 UNION ALL Select *,21 as tmp from available_event_datav6_1617267005 UNION ALL Select *,22 as tmp from available_event_datav6_1617071701 UNION ALL Select *,23 as tmp from available_event_datav6_1617268034 UNION ALL Select *,24 as tmp from available_event_datav6_1617084326 UNION ALL Select *,25 as tmp from available_event_datav6_1617299102 UNION ALL Select *,26 as tmp from available_event_datav6_1617262801 UNION ALL Select *,27 as tmp from available_event_datav6_1617209701 UNION ALL Select *,28 as tmp from available_event_datav6_1617291967 UNION ALL Select *,29 as tmp from available_event_datav6_1617261301 UNION ALL Select *,30 as tmp from available_event_datav6_1617290882 UNION ALL Select *,31 as tmp from available_event_datav6_1617292501 UNION ALL Select *,32 as tmp from available_event_datav6_1617300601 UNION ALL Select *,33 as tmp from available_event_datav6_1617297001 UNION ALL Select *,34 as tmp from available_event_datav6_1617293701 UNION ALL Select *,35 as tmp from available_event_datav6_1617296721 UNION ALL Select *,36 as tmp from available_event_datav6_1617294901 UNION ALL Select *,37 as tmp from available_event_datav6_1617295501 UNION ALL Select *,38 as tmp from available_event_datav6_1617295801 UNION ALL Select *,39 as tmp from available_event_datav6_1617299403 UNION ALL Select *,40 as tmp from available_event_datav6_1617296101 UNION ALL Select *,41 as tmp from available_event_datav6_1617584101 UNION ALL Select *,42 as tmp from available_event_datav6_1617297301 UNION ALL Select *,43 as tmp from available_event_datav6_1617301801 UNION ALL Select *,44 as tmp from available_event_datav6_1617584402 UNION ALL Select *,45 as tmp from available_event_datav6_1617584701 UNION ALL Select *,46 as tmp from available_event_datav6_1617585001 UNION ALL Select *,47 as tmp from available_event_datav6_1617297624 UNION ALL Select *,48 as tmp from available_event_datav6_1617585302 UNION ALL Select *,49 as tmp from available_event_datav6_1617262516 UNION ALL Select *,50 as tmp from available_event_datav6_1617585749 UNION ALL Select *,51 as tmp from available_event_datav6_1617585902 UNION ALL Select *,52 as tmp from available_event_datav6_1617586202 UNION ALL Select *,53 as tmp from available_event_datav6_1617297900 UNION ALL Select *,54 as tmp from available_event_datav6_1617299701 UNION ALL Select *,55 as tmp from available_event_datav6_1617586501 UNION ALL Select *,56 as tmp from available_event_datav6_1617300901 UNION ALL Select *,57 as tmp from available_event_datav6_1617291057 UNION ALL Select *,58 as tmp from available_event_datav6_1617586802 UNION ALL Select *,59 as tmp from available_event_datav6_1617587102  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    22866 2021-04-05 07:51:07.128 GMTSTATEMENT:   Select  event_proc_010();
    23045 2021-04-05 07:51:08.068 GMTERROR:  value too long for type character varying(512)
    23045 2021-04-05 07:51:08.068 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210001 UNION ALL Select *,4 as tmp from available_event_datav6_1617261918 UNION ALL Select *,5 as tmp from available_event_datav6_1617293100 UNION ALL Select *,6 as tmp from available_event_datav6_1617291107 UNION ALL Select *,7 as tmp from available_event_datav6_1617070201 UNION ALL Select *,8 as tmp from available_event_datav6_1617292802 UNION ALL Select *,9 as tmp from available_event_datav6_1617294001 UNION ALL Select *,10 as tmp from available_event_datav6_1617294300 UNION ALL Select *,11 as tmp from available_event_datav6_1617295201 UNION ALL Select *,12 as tmp from available_event_datav6_1617296401 UNION ALL Select *,13 as tmp from available_event_datav6_1617261601 UNION ALL Select *,14 as tmp from available_event_datav6_1617583802 UNION ALL Select *,15 as tmp from available_event_datav6_1617291301 UNION ALL Select *,16 as tmp from available_event_datav6_1617599237 UNION ALL Select *,17 as tmp from available_event_datav6_1617601618 UNION ALL Select *,18 as tmp from available_event_datav6_1617608749 UNION ALL Select *,19 as tmp from available_event_datav6_1617609064 UNION ALL Select *,20 as tmp from available_event_datav6_1617210775 UNION ALL Select *,21 as tmp from available_event_datav6_1617263104 UNION ALL Select *,22 as tmp from available_event_datav6_1617293401 UNION ALL Select *,23 as tmp from available_event_datav6_1617267005 UNION ALL Select *,24 as tmp from available_event_datav6_1617071701 UNION ALL Select *,25 as tmp from available_event_datav6_1617268034 UNION ALL Select *,26 as tmp from available_event_datav6_1617084326 UNION ALL Select *,27 as tmp from available_event_datav6_1617299102 UNION ALL Select *,28 as tmp from available_event_datav6_1617262801 UNION ALL Select *,29 as tmp from available_event_datav6_1617209701 UNION ALL Select *,30 as tmp from available_event_datav6_1617291967 UNION ALL Select *,31 as tmp from available_event_datav6_1617261301 UNION ALL Select *,32 as tmp from available_event_datav6_1617290882 UNION ALL Select *,33 as tmp from available_event_datav6_1617292501 UNION ALL Select *,34 as tmp from available_event_datav6_1617300601 UNION ALL Select *,35 as tmp from available_event_datav6_1617297001 UNION ALL Select *,36 as tmp from available_event_datav6_1617293701 UNION ALL Select *,37 as tmp from available_event_datav6_1617296721 UNION ALL Select *,38 as tmp from available_event_datav6_1617294901 UNION ALL Select *,39 as tmp from available_event_datav6_1617295501 UNION ALL Select *,40 as tmp from available_event_datav6_1617295801 UNION ALL Select *,41 as tmp from available_event_datav6_1617299403 UNION ALL Select *,42 as tmp from available_event_datav6_1617296101 UNION ALL Select *,43 as tmp from available_event_datav6_1617584101 UNION ALL Select *,44 as tmp from available_event_datav6_1617297301 UNION ALL Select *,45 as tmp from available_event_datav6_1617301801 UNION ALL Select *,46 as tmp from available_event_datav6_1617584402 UNION ALL Select *,47 as tmp from available_event_datav6_1617584701 UNION ALL Select *,48 as tmp from available_event_datav6_1617585001 UNION ALL Select *,49 as tmp from available_event_datav6_1617297624 UNION ALL Select *,50 as tmp from available_event_datav6_1617585302 UNION ALL Select *,51 as tmp from available_event_datav6_1617262516 UNION ALL Select *,52 as tmp from available_event_datav6_1617585749 UNION ALL Select *,53 as tmp from available_event_datav6_1617585902 UNION ALL Select *,54 as tmp from available_event_datav6_1617586202 UNION ALL Select *,55 as tmp from available_event_datav6_1617297900 UNION ALL Select *,56 as tmp from available_event_datav6_1617299701 UNION ALL Select *,57 as tmp from available_event_datav6_1617586501 UNION ALL Select *,58 as tmp from available_event_datav6_1617300901 UNION ALL Select *,59 as tmp from available_event_datav6_1617291057  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    23045 2021-04-05 07:51:08.068 GMTSTATEMENT:   Select  event_proc_010();
    14358 2021-04-05 07:55:49.316 GMTERROR:  value too long for type character varying(512)
    14358 2021-04-05 07:55:49.316 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210775 UNION ALL Select *,4 as tmp from available_event_datav6_1617263104 UNION ALL Select *,5 as tmp from available_event_datav6_1617293401 UNION ALL Select *,6 as tmp from available_event_datav6_1617267005 UNION ALL Select *,7 as tmp from available_event_datav6_1617071701 UNION ALL Select *,8 as tmp from available_event_datav6_1617268034 UNION ALL Select *,9 as tmp from available_event_datav6_1617084326 UNION ALL Select *,10 as tmp from available_event_datav6_1617299102 UNION ALL Select *,11 as tmp from available_event_datav6_1617262801 UNION ALL Select *,12 as tmp from available_event_datav6_1617209701 UNION ALL Select *,13 as tmp from available_event_datav6_1617291967 UNION ALL Select *,14 as tmp from available_event_datav6_1617261301 UNION ALL Select *,15 as tmp from available_event_datav6_1617290882 UNION ALL Select *,16 as tmp from available_event_datav6_1617292501 UNION ALL Select *,17 as tmp from available_event_datav6_1617300601 UNION ALL Select *,18 as tmp from available_event_datav6_1617297001 UNION ALL Select *,19 as tmp from available_event_datav6_1617293701 UNION ALL Select *,20 as tmp from available_event_datav6_1617296721 UNION ALL Select *,21 as tmp from available_event_datav6_1617294901 UNION ALL Select *,22 as tmp from available_event_datav6_1617295501 UNION ALL Select *,23 as tmp from available_event_datav6_1617295801 UNION ALL Select *,24 as tmp from available_event_datav6_1617299403 UNION ALL Select *,25 as tmp from available_event_datav6_1617296101 UNION ALL Select *,26 as tmp from available_event_datav6_1617584101 UNION ALL Select *,27 as tmp from available_event_datav6_1617297301 UNION ALL Select *,28 as tmp from available_event_datav6_1617301801 UNION ALL Select *,29 as tmp from available_event_datav6_1617584402 UNION ALL Select *,30 as tmp from available_event_datav6_1617584701 UNION ALL Select *,31 as tmp from available_event_datav6_1617585001 UNION ALL Select *,32 as tmp from available_event_datav6_1617297624 UNION ALL Select *,33 as tmp from available_event_datav6_1617585302 UNION ALL Select *,34 as tmp from available_event_datav6_1617262516 UNION ALL Select *,35 as tmp from available_event_datav6_1617585749 UNION ALL Select *,36 as tmp from available_event_datav6_1617585902 UNION ALL Select *,37 as tmp from available_event_datav6_1617586202 UNION ALL Select *,38 as tmp from available_event_datav6_1617297900 UNION ALL Select *,39 as tmp from available_event_datav6_1617299701 UNION ALL Select *,40 as tmp from available_event_datav6_1617586501 UNION ALL Select *,41 as tmp from available_event_datav6_1617300901 UNION ALL Select *,42 as tmp from available_event_datav6_1617291057 UNION ALL Select *,43 as tmp from available_event_datav6_1617586802 UNION ALL Select *,44 as tmp from available_event_datav6_1617587102 UNION ALL Select *,45 as tmp from available_event_datav6_1617298201 UNION ALL Select *,46 as tmp from available_event_datav6_1617587402 UNION ALL Select *,47 as tmp from available_event_datav6_1617587701 UNION ALL Select *,48 as tmp from available_event_datav6_1617294613 UNION ALL Select *,49 as tmp from available_event_datav6_1617588230 UNION ALL Select *,50 as tmp from available_event_datav6_1617588367 UNION ALL Select *,51 as tmp from available_event_datav6_1617588602 UNION ALL Select *,52 as tmp from available_event_datav6_1617588979 UNION ALL Select *,53 as tmp from available_event_datav6_1617298501 UNION ALL Select *,54 as tmp from available_event_datav6_1617300002 UNION ALL Select *,55 as tmp from available_event_datav6_1617209401 UNION ALL Select *,56 as tmp from available_event_datav6_1617589219 UNION ALL Select *,57 as tmp from available_event_datav6_1617589501 UNION ALL Select *,58 as tmp from available_event_datav6_1617073202 UNION ALL Select *,59 as tmp from available_event_datav6_1617589802  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    14358 2021-04-05 07:55:49.316 GMTSTATEMENT:   Select  event_proc_010();
    3907 2021-04-05 08:02:09.083 GMTERROR:  value too long for type character varying(512)
    3907 2021-04-05 08:02:09.083 GMTCONTEXT:  SQL statement "INSERT INTO event_a_b_c_d_e_futfv6_24hr_ts_202104 SELECT to_timestamp(time), CASE WHEN eventtype = 16 then 'HA' WHEN eventtype = 17 then 'Foreign Host' WHEN eventtype = 18 then 'IPMAC Filter' WHEN eventtype = 19 then 'IP Spoof' WHEN eventtype = 20 then 'GUI' WHEN eventtype = 21 then 'CLI' WHEN eventtype = 22 then 'Console' WHEN eventtype = 23 then 'Central Management' WHEN eventtype = 24 then 'IM' WHEN eventtype = 25 then 'IPSec' WHEN eventtype = 26 then 'L2TP' WHEN eventtype = 27 then 'PPTP' WHEN eventtype = 28 then 'SSL VPN' WHEN eventtype = 29 then 'Firewall Authentication' WHEN eventtype = 30 then 'VPN Authentication' WHEN eventtype = 31 then 'SSL VPN Authentication' WHEN eventtype = 32 then 'My AccountAuthentication' WHEN eventtype = 33 then 'Appliance' WHEN eventtype = 34 then 'DHCP Server' WHEN eventtype = 35 then 'Interface' WHEN eventtype = 36 then 'Gateway' WHEN eventtype = 37 then 'DDNS' WHEN eventtype = 38 then 'WebCat' WHEN eventtype = 39 then 'IPS' WHEN eventtype = 40 then 'AV' WHEN eventtype = 41 then 'Dial-In Authentication' WHEN eventtype = 42 then 'Dial-In' WHEN eventtype = 43 then 'Quarantine' WHEN eventtype = 44 then 'Application Filter' WHEN eventtype = 45 then 'Landing Page' WHEN eventtype = 46 then 'WLAN' WHEN eventtype = 47 then 'ARP Flood' WHEN eventtype = 48 then 'HTTPS' WHEN eventtype = 49 then 'Guest User' WHEN eventtype = 50 then 'WAF' WHEN eventtype = 51 then 'Virtual Host' END , message, severity , srcipipv6,CASE WHEN status = 1 then 'Allowed' WHEN status = 2 then 'Denied' WHEN status = 5 then 'Successful' WHEN status = 6 then 'Failed' WHEN status = 7 then 'Established' WHEN status = 8 then 'Terminated' WHEN status = 9 then 'Renew' WHEN status = 10 then 'Release' WHEN status = 11 then 'Expire' ELSE '-' End,username,1 as count,logsubtype,eduusergroup,msg_id FROM ( Select *,0 as tmp from available_event_datav6_1617298801 UNION ALL Select *,1 as tmp from available_event_datav6_1617300301 UNION ALL Select *,2 as tmp from available_event_datav6_1617301501 UNION ALL Select *,3 as tmp from available_event_datav6_1617210775 UNION ALL Select *,4 as tmp from available_event_datav6_1617263104 UNION ALL Select *,5 as tmp from available_event_datav6_1617293401 UNION ALL Select *,6 as tmp from available_event_datav6_1617267005 UNION ALL Select *,7 as tmp from available_event_datav6_1617071701 UNION ALL Select *,8 as tmp from available_event_datav6_1617268034 UNION ALL Select *,9 as tmp from available_event_datav6_1617084326 UNION ALL Select *,10 as tmp from available_event_datav6_1617299102 UNION ALL Select *,11 as tmp from available_event_datav6_1617262801 UNION ALL Select *,12 as tmp from available_event_datav6_1617209701 UNION ALL Select *,13 as tmp from available_event_datav6_1617291967 UNION ALL Select *,14 as tmp from available_event_datav6_1617261301 UNION ALL Select *,15 as tmp from available_event_datav6_1617290882 UNION ALL Select *,16 as tmp from available_event_datav6_1617292501 UNION ALL Select *,17 as tmp from available_event_datav6_1617300601 UNION ALL Select *,18 as tmp from available_event_datav6_1617297001 UNION ALL Select *,19 as tmp from available_event_datav6_1617293701 UNION ALL Select *,20 as tmp from available_event_datav6_1617296721 UNION ALL Select *,21 as tmp from available_event_datav6_1617294901 UNION ALL Select *,22 as tmp from available_event_datav6_1617295501 UNION ALL Select *,23 as tmp from available_event_datav6_1617295801 UNION ALL Select *,24 as tmp from available_event_datav6_1617299403 UNION ALL Select *,25 as tmp from available_event_datav6_1617296101 UNION ALL Select *,26 as tmp from available_event_datav6_1617584101 UNION ALL Select *,27 as tmp from available_event_datav6_1617297301 UNION ALL Select *,28 as tmp from available_event_datav6_1617301801 UNION ALL Select *,29 as tmp from available_event_datav6_1617584402 UNION ALL Select *,30 as tmp from available_event_datav6_1617584701 UNION ALL Select *,31 as tmp from available_event_datav6_1617585001 UNION ALL Select *,32 as tmp from available_event_datav6_1617297624 UNION ALL Select *,33 as tmp from available_event_datav6_1617585302 UNION ALL Select *,34 as tmp from available_event_datav6_1617262516 UNION ALL Select *,35 as tmp from available_event_datav6_1617585749 UNION ALL Select *,36 as tmp from available_event_datav6_1617585902 UNION ALL Select *,37 as tmp from available_event_datav6_1617586202 UNION ALL Select *,38 as tmp from available_event_datav6_1617297900 UNION ALL Select *,39 as tmp from available_event_datav6_1617299701 UNION ALL Select *,40 as tmp from available_event_datav6_1617586501 UNION ALL Select *,41 as tmp from available_event_datav6_1617300901 UNION ALL Select *,42 as tmp from available_event_datav6_1617291057 UNION ALL Select *,43 as tmp from available_event_datav6_1617586802 UNION ALL Select *,44 as tmp from available_event_datav6_1617587102 UNION ALL Select *,45 as tmp from available_event_datav6_1617298201 UNION ALL Select *,46 as tmp from available_event_datav6_1617587402 UNION ALL Select *,47 as tmp from available_event_datav6_1617587701 UNION ALL Select *,48 as tmp from available_event_datav6_1617294613 UNION ALL Select *,49 as tmp from available_event_datav6_1617588230 UNION ALL Select *,50 as tmp from available_event_datav6_1617588367 UNION ALL Select *,51 as tmp from available_event_datav6_1617588602 UNION ALL Select *,52 as tmp from available_event_datav6_1617588979 UNION ALL Select *,53 as tmp from available_event_datav6_1617298501 UNION ALL Select *,54 as tmp from available_event_datav6_1617300002 UNION ALL Select *,55 as tmp from available_event_datav6_1617209401 UNION ALL Select *,56 as tmp from available_event_datav6_1617589219 UNION ALL Select *,57 as tmp from available_event_datav6_1617589501 UNION ALL Select *,58 as tmp from available_event_datav6_1617073202 UNION ALL Select *,59 as tmp from available_event_datav6_1617589802  ) as unionTable  where msg_id not in (18036)"
            PL/pgSQL function event_proc_010() line 54 at EXECUTE statement
    3907 2021-04-05 08:02:09.083 GMTSTATEMENT:   Select  event_proc_010();
    CR50iNG_AM03_SFOS 17.5.15 MR-15#

  • Hi,

    when was the last time you restarted you XG?

    Ian

     
    V18.0.x - e3-1225v5 6gb ram with 4 ports - 20w. 
    3 AP55s and 2 APX120s having a holiday until software update is released.
    If a post solves your question use the 'This helped me' link.
  • problem still continue from 2021-02-24 22:32:54

    last restarted time:

    Running for 10 day(s), 17 hour(s), 57 minute(s)

  • It seems to be an issue with the database. Could you please open a service request and share the case ID via PM?

    Thanks,
    Yash Kothari
    Community Support Engineer | Sophos Technical Support
    Sophos Support Videos | Product Documentation | @SophosSupport | Sign up for SMS Alerts
    If a post solves your question, use the 'Verify Answer' link.
Reply Children
No Data