Skip to content

database: media table: use bigint instead of integer#1579

Merged
BareosBot merged 10 commits intobareos:masterfrom
pstorz:dev/pstorz/master/mediatable-integer-to-bigint
Nov 6, 2023
Merged

database: media table: use bigint instead of integer#1579
BareosBot merged 10 commits intobareos:masterfrom
pstorz:dev/pstorz/master/mediatable-integer-to-bigint

Conversation

@pstorz
Copy link
Member

@pstorz pstorz commented Oct 26, 2023

Thank you for contributing to the Bareos Project!

This PR aims to fix an integer out of range in media table which may occur in rare consistencies where the volume is reused in a very high frequency.

It include fixes to allow using PG16 as database backend for bareos 23+

#OP5292

  • Short description and the purpose of this PR is present _above this paragraph
  • Your name is present in the AUTHORS file (optional)

If you have any questions or problems, please give a comment in the PR.

Helpful documentation and best practices

Checklist for the reviewer of the PR (will be processed by the Bareos team)

Make sure you check/merge the PR using devtools/pr-tool to have some simple automated checks run and a proper changelog record added.

General
  • Is the PR title usable as CHANGELOG entry?
  • Purpose of the PR is understood
  • Commit descriptions are understandable and well formatted
Source code quality
  • Source code changes are understandable
  • Variable and function names are meaningful
  • Code comments are correct (logically and spelling)
  • Required documentation changes are present and part of the PR

Copy link
Contributor

@bruno-at-bareos bruno-at-bareos left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

First round of review looks ok (build,systemtest) but see remarks.

Copy link
Contributor

@bruno-at-bareos bruno-at-bareos left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Nicely done, Approved.
btw I've just reformatted the indexes of BaseJobs.

@bruno-at-bareos bruno-at-bareos force-pushed the dev/pstorz/master/mediatable-integer-to-bigint branch from 8f825cf to 698c5c4 Compare October 30, 2023 12:57
@arogge arogge force-pushed the dev/pstorz/master/mediatable-integer-to-bigint branch from 698c5c4 to d83884b Compare November 6, 2023 13:13
@bruno-at-bareos bruno-at-bareos force-pushed the dev/pstorz/master/mediatable-integer-to-bigint branch from 949ac2d to 74f437b Compare November 6, 2023 14:09
Copy link
Contributor

@bruno-at-bareos bruno-at-bareos left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for the good work. I approve this PR for master.
Local build, tests controls are all green.
Let finish Jenkins.

pstorz and others added 10 commits November 6, 2023 17:01
Unfortunately, psql returns with OK even in case of error when the
transaction was rolled back.

To make sure the update was correctly performed, we now only have one
transaction during update from 2210_2230 and verify afterwards that the
version was updated.
- fix OP#5573

Signed-off-by: Bruno Friedmann <bruno.friedmann@bareos.com>
(cherry picked from commit 292285a)
@BareosBot BareosBot force-pushed the dev/pstorz/master/mediatable-integer-to-bigint branch from d2c8613 to 740dd49 Compare November 6, 2023 17:01
@BareosBot BareosBot merged commit bcfcfd6 into bareos:master Nov 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants