Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Patrick AUDON
    @astropat73_gitlab

    1°) no other error in webapp log file
    2°) service restarted and the problem is still present with same error in the log

    So, no idea how to resolve my problem ?

    Elenui
    @ellenui_twitter
    hey guys I may have found a small problem with the doc but i'm not about it. Since the update (to 7.2) we experience some latency on our master node. And we take a look to the Maintenance procedures in order to vaccums tables.
    And it appear there is no table named "rudder"
    Maybe the right name is ruddersysevents ?
    ```
    udder=# \dt
                        Liste des relations
     Schéma |            Nom             | Type  | Propriétaire 
    --------+----------------------------+-------+--------------
     public | archivednodecompliance     | table | rudder
     public | archivednodeconfigurations | table | rudder
     public | archivedruddersysevents    | table | rudder
     public | campaignevents             | table | rudder
     public | changerequest              | table | rudder
     public | eventlog                   | table | rudder
     public | gitcommit                  | table | rudder
     public | migrationeventlog          | table | rudder
     public | nodecompliance             | table | rudder
     public | nodecompliancelevels       | table | rudder
     public | nodeconfigurations         | table | rudder
     public | nodes_info                 | table | rudder
     public | reportsexecution           | table | rudder
     public | rudderproperties           | table | rudder
     public | ruddersysevents            | table | rudder
     public | statusupdate               | table | rudder
     public | workflow                   | table | rudder
    rudder=# select relname, pg_size_pretty(pg_total_relation_size(relname::regclass)) as full_size, pg_size_pretty(pg_relation_size(relname::regclass)) as table_size, pg_size_pretty(pg_total_relation_size(relname::regclass) - pg_relation_size(relname::regclass)) as index_size from pg_stat_user_tables order by pg_total_relation_size(relname::regclass) desc limit 10;
           relname        | full_size | table_size | index_size 
    ----------------------+-----------+------------+------------
     ruddersysevents      | 12 GB     | 9525 MB    | 2734 MB
     nodecompliancelevels | 1873 MB   | 1000 MB    | 873 MB
     reportsexecution     | 120 MB    | 51 MB      | 69 MB
     eventlog             | 53 MB     | 32 MB      | 21 MB
     nodeconfigurations   | 19 MB     | 864 kB     | 18 MB
     gitcommit            | 952 kB    | 496 kB     | 456 kB
     nodes_info           | 640 kB    | 544 kB     | 96 kB
     rudderproperties     | 64 kB     | 8192 bytes | 56 kB
     statusupdate         | 64 kB     | 8192 bytes | 56 kB
     nodecompliance       | 40 kB     | 0 bytes    | 40 kB
    We suppose it's ruddersysevents since it's the biggest one
    fanf42
    @fanf42:matrix.org
    [m]
    @astropat73_gitlab: ok, so likely, what is happening:
    • for some reason, the performance of your LDAP server are degraded. So typically, when it tries to "delete" a node, what happens is - don't forget that by default, nodes are moved to "deleted" branch, not really erase -: start of deletion process, node entries are moved to deleted branchs ; that stalls; the next node deletion tasks are started, like changing the node certificate status - but the node entry is not yet commited ; that fails.
      What you can do:
    • change the property "rudder.nodes.delete.defaultMode" to "erase" so that nodes are really deleted ;
    • try to understand why that LDAP is so slow. There is no standard process for that unfortunatly
    9 replies
    Alexis Mousset
    @amousset
    @ellenui_twitter yes it's ruddersysevents
    Elenui
    @ellenui_twitter
    Should I open a issue
    to fix the doc ?
    Alexis Mousset
    @amousset
    it would be great!
    Elenui
    @ellenui_twitter
    let's gooo :D
    fanf42
    @fanf42:matrix.org
    [m]
    @ellenui_twitter: yes.
    We identified a pb with a new feature that cause bad postgresql performances. The request select id, executiondate, ruleid, directiveid, nodeid, reportid, component, keyvalue, executiontimestamp, eventtype, msg from ruddersysevents where 1=1 and id >= '0' and (eventtype='report_json') order by id asc limit 1000;.
    A first workaround seems to be adding an index, and we are looking for a definitive solution: "event_report_json_idx" btree (id) WHERE eventtype = 'report_json'::text
    Elenui
    @ellenui_twitter
    Ohhh you're a life savior
    as always ^ ^
    Cause we get almost 1Go/s Read on our rudder XD
    thanks VSAN
    Elenui
    @ellenui_twitter
    it work @fanf42:matrix.org thanks :D
    sr57
    @sr57
    Hi all, is there a simple way to move one action between 2 directives from the same technique (for instance "File content")? I have 1 file that I want to move from 1 directive to the other.
    fanf42
    @fanf42:matrix.org
    [m]
    hello @sr57 , I'm not sure I understand. You have two directives derived from the same "file content" technique, and you would like to ? Move a definition block for check on file from one directive to the other ?
    fanf42
    @fanf42:matrix.org
    [m]
    if it's that, there is no way by UI, and only complicated way by API. The simplest would be to just open the two directives and copy/paste
    sr57
    @sr57
    Hello @fanf42:matrix.org , yes it was that. Copy/paste per field, not easy when you can't open 2 tabs for the GUI, isn'it?
    fanf42
    @fanf42:matrix.org
    [m]
    you can't open two tab ?
    oh, you must not go through the login page, else other session get disconnected
    sr57
    @sr57
    Which browser? I use firefox.
    fanf42
    @fanf42:matrix.org
    [m]
    same
    sr57
    @sr57
    oh, you must not go through the login page ... Ok how do you do?
    fanf42
    @fanf42:matrix.org
    [m]
    I just did -^
    sr57
    @sr57
    I was not used to this option, before I just copied/pasted the url ... so went to the login page. Thanks for your browser (firefox) lesson, it works.
    fanf42
    @fanf42:matrix.org
    [m]
    else you can also "middle-click" to open a new tab, and then drag the tab out of the line of firefox open tabs, it will transform the tab into a window
    happy to have helped !
    Alexis Mousset
    @amousset
    we actually remove the login form redirection from base URL when already corrected in 7.3. Maybe we could backport this as a bugfix https://issues.rudder.io/issues/21807.
    H3ROE
    @H3ROE
    Hello all, incredibly new here. I am trying to get rudder installed on RHEL9. I followed the guide (https://docs.rudder.io/reference/7.2/installation/server/rhel.html#_initial_configuration) but it does not mention executing the rudder-init script. That is not correct, is it?
    Alexis Mousset
    @amousset
    Hi @H3ROE, running rudder-init manually was required only in (really) old Rudder versions, it's not needed anymore. Where did you see this?
    H3ROE
    @H3ROE
    I found it while googling other issues I was having with getting it running, I cannot find it now, thats why I asked lol
    Alexis Mousset
    @amousset
    Ok :+1:, what are these issues then ?
    H3ROE
    @H3ROE
    Was not able to access the webpage before, but now I am. So I guess I came in here to look like a fool :D
    fanf42
    @fanf42:matrix.org
    [m]
    @H3ROE: not at all, you came here to say hello, and we are very glad to meet you. Happy rudder! Don't hesitate to ask if needed.
    Jim Sloan
    @jsloan1_gitlab
    QQ can you use plugins without having an account?
    Elenui
    @ellenui_twitter
    I don't recall how but you can download free plugin from https://github.com/Normation/rudder-plugins and install it from cli
    you don't need an account
    Elenui
    @ellenui_twitter
    @amousset thanks a lot for your answer on my issue. <3
    Jim Sloan
    @jsloan1_gitlab
    @ellenui_twitter Yeah, I already cloned that github repo, but can't find any pkgs, only the source
    2 replies
    Tanguy PELADO
    @tpelado
    Good day all, is there a way to reduce rudder clients log output? Makes the syslog file nearly unusable.
    8 replies
    palmar
    @palmar
    Good day, after upgrading to 7.2 (from 6.2) everything works fine but all reporting seems to not work. The log is constantly throwing this error: "column ruddersysevents.reportid does not exist" - I can't tell if this is a known or novel issue. Didn't find anything in the documentation
    4 replies