Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MSSQL Repairing database error #228

Open
mesteele opened this issue Jul 7, 2023 · 1 comment
Open

MSSQL Repairing database error #228

mesteele opened this issue Jul 7, 2023 · 1 comment
Assignees
@NathanGibbs3
Labels
bug Something isn't working DB Database Issues DB-MsSQL Issues related to Ms SQL Server DB invalid This doesn't seem right LCB-TechDebt Issue exists in Legacy Code Base. We inherited it. Prod Observed in Production Environment. Stability Issue impacts or is related to App Stability.

Comments

@mesteele
Copy link

mesteele commented Jul 7, 2023 •
edited
Loading

Item | Description
-----| When I select to repair either the Alert or Archive gets an error. It also shows a DB: Not Enabled.
File(s): |
Class: |
Function: |
Similar Issues: |
Depends on Issue(s): |
Dependency Type: |
Misc. Info.: |

Expected Behavior:
Current Behavior:

Repair Alert database but there are no events are in the Alert tables.

Log:
Alert_error.log
Repair_Tables_Alert
@NathanGibbs3 NathanGibbs3 added bug Something isn't working Prod Observed in Production Environment. LCB-TechDebt Issue exists in Legacy Code Base. We inherited it. DB Database Issues DB-MsSQL Issues related to Ms SQL Server DB invalid This doesn't seem right Stability Issue impacts or is related to App Stability. labels Jul 7, 2023
@NathanGibbs3
Copy link
Owner

Repair tables uses the BASE setup code to initialize the BASE portion of the DB, a corner of the codebase that I haven't even gotten to yet.

The index creation errors are an MsSQL specific issue based on how the indexes are created in the setup code for MsSQL DB's.

The DB not enabled messages are in reference to RI functionality not being enabled at the DB level.

It would be interesting to see how repair tables misbehaves for empty DB's on other DB servers. ( MySQL / PostgreSQL ).

@NathanGibbs3 NathanGibbs3 mentioned this issue Jul 7, 2023
Open
@NathanGibbs3 NathanGibbs3 self-assigned this Jul 14, 2023
This was referenced Jul 14, 2023
Open
Open
NathanGibbs3 added a commit that referenced this issue Nov 14, 2024
@NathanGibbs3
20241114 Closes #228 Closes #229 Closes #230. Better Close for #226.
caeeb05 
         Work on #216 & #231.
         Code Cleanup.

     File(s): admin/index.php
            : base_conf.php.dist
            : base_user.php
            : includes/base_constants.inc.php
            : includes/base_include.inc.php
            : includes/base_log_timing.inc.php
            : includes/base_output_html.inc.php
            : includes/base_template.php
            : includes/base_user.inc.php
            : index.php
            : languages/index.php
            : setup/base_conf_contents.php
              Code Cleanup.
     File(s): base_db_common.php
            : includes/base_log_error.inc.php
              Code Cleanup.
    Issue(s): #226
     File(s): base_maintenance.php
              Code Cleanup.
    Issue(s): #229
     File(s): base_stat_common.php
              Code Cleanup.
    Issue(s): #230
     File(s): includes/base_db.inc.php
              Code Cleanup.
    Issue(s): #231
              Additional logging to debug this.
     File(s): includes/base_krnl.php
              Bumped Kernel Version to 0.0.8.
              Code Cleanup.
     File(s): includes/base_rtl.php
              Bumped RTL Version to 0.0.13.
              Code Cleanup.
     File(s): phpcs.xml.dist
            : tests/phpunit.sh
            : tests/setuptestdb.php
            : tests/singletest.sh
            : tests/teardowntestdb.php
              Local & CI Test system adjustments.
     File(s): setup/setup_db.inc.php
    Issue(s): #228
     File(s): tests/setupdb.sh
    Issue(s): #216
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@NathanGibbs3 NathanGibbs3

Labels
bug Something isn't working DB Database Issues DB-MsSQL Issues related to Ms SQL Server DB invalid This doesn't seem right LCB-TechDebt Issue exists in Legacy Code Base. We inherited it. Prod Observed in Production Environment. Stability Issue impacts or is related to App Stability.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@NathanGibbs3 @mesteele