I have done the upgrade without any error, but just notice one thing on database size different after the upgradecheck few new/old tickets it seems to be fineAny idea why is that?screenShots

Your asking why your database size changed after the upgrade?You could have had attachments or images that were waiting to be deleted that were cleaned up.

so it's normal to see database size larger on the Admin portal?Since I have been using the osTicket, I am doing a daily backup and I have been checking that size always increased never decreased, I just did a backup of the database before and after the upgrade, they both are just about same.It seems like the database info is not updating on the admin panel.something I missed?Thanks for your help

@[deleted]It appears from your screenshots that your database size was slightly lowered hence the drop in the "Space Used" setting. (this is a good thing)As for the drop in the "Space for Attachments" setting, we improved the query in the below commit (added in 1.10.4):https://github.com/osTicket/osTicket/commit/5b5e8c9867eeb9bfc7810513610864d12c6e3857This will get the sum of all the data in the `ost_file_chunk` table, giving you the amount of space your attachments are taking up in the db."Space for Attachments" should actually read "Space Used For Attachments" imo lolCheers.

So is database size should change too?

Database size show about 665 MiB

Space used was 167 MiB to 145 MiB

Space for Attachments was 519 MiB to 129 MiB

Should database size be about 265 MiB ?

Thanks

@KevinTheJedior something should be running daily to clean up temps/cache from databases?Thank you

@[deleted]it's about 3 days since I have upgraded to 1.10.4about 60 new tickets created plus reply with few attachments, but no changes to space used/attachmentsthe system seems to be working just fine Database: 622.9 MB as of 9.28.2018 (lowered because of improved the query in the new version)638 MB 9.24.2018on Admin panel info:Space Used 145.20 MiB (not changed a bit since upgraded)Space for Attachments 129.52 MiB (not changed a bit since upgraded)strange, I did not see upgrade screen so I manually ran the upgrader and it said "Nothing to do! System already upgraded to v1.10.4 with no pending patches to apply"see the screenshot for detailsScreenShotServer InformationosTicket Version v1.10.4 (035fd0a) —  Up to dateWeb Server Software ApacheMySQL Version 5.7.23PHP Version 7.0.32-0ubuntu0.16.04.1

There is no direct database changes between the two versions so you would not get the upgrader.

any reason why Space used info not changing on the Admin panel?Thanks

@[deleted]Idk, I'd have to look at the Space Used query.Cheers.

@[deleted]I have set up the v1.11.0-rc1 (e321982) on the same server and that shows the correct info on the admin panelso, that kind of tells me something not refreshing, because everything working fineThanks

2 months later

Update: I set up on a local test and it shows correct size

Write a Reply...