Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Elenui
    @ellenui_twitter
    ```
    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
    Fabien
    @fclemens_gitlab
    Hi, I’ve upgrade to 7.2 some days ago and rudder is constantly restarting. Today I’ve count 24 start in the logs. What could cause that, i see no errors in the logs.
    7 replies
    sr57
    @sr57
    Good morning.
    I have a physical server that I upgraded from Ubuntu 18 to Ubuntu 22. I was forced to restart it from my backup to Ubuntu 18, but now after 2 days, Rudder (server 7.2 – agent 7.2.1) still shows Ubuntu 22 (in addition Rudder reports the name as « aabb » but hostname is « aa_bb » - don’t remember if I had this behavior before upgrade).
    Maybe there is st to check before trying to solve this pb (relaunch inventory, reset, recreate node)
    18 replies
    Nicolas E
    @necar_gitlab
    Hello everyone. Though I've searched in the doc and in this chat, I didn't find this answer : I'm deploying hook scripts that are setting nodes property, which I'm then using to decide things. This is working fine. In the doc, I've read that the hooks are ran on a daily basis, which is also fine for me. But in case I want to quickly test one change, I thought I could just run "rudder agent inventory" and the hooks were to be ran. I'm not sure that this is the case, but anyway, I'm witnessing that the properties of the tested node are not changing. Is there a way to speed things up manually, in this precise case of a test?
    5 replies
    Nicolas Charles
    @ncharles
    Dear community !We want to better understand who are the Rudder users are and what their needs are. You can help us by filling out this survey https://rudder.limesurvey.net/618177