Demo server session_write_close(): Write failed: No space left on device (28)

[M393]

Demo server seems to have run out of disk space.
https://demo.phpmyadmin.net/master-config/public/

[ibennetch]

Thanks for the report. I cleaned up a few things to make some space and it's working for now, but it's still pretty tight so I'm going to leave this open for a bit longer.

[williamdes]

Maybe we could use a tmpfs for sessions, so that never happens for a long time
that said the build script would still fail

[MauricioFauth]

@williamdes is the full git repository needed for the build? It's about 2Gb currently

[williamdes]

@williamdes is the full git repository needed for the build? It's about 2Gb currently

No not at all, but we need the QA branch and the main branch to be able to git worktree them
That's a bit more complicated to get without a full clone.
Maybe there is a command to trim the history, or we could download tarballs from GitHub directly?

[ibennetch]

I also wondered if a shallow clone would work for this, but I agree that the history could get difficult with all the branches. I haven’t tested this scenario but it might help us.

[williamdes]

I also wondered if a shallow clone would work for this, but I agree that
the history could get difficult with all the branches. I haven’t tested
this scenario but it might help us.

In fact multi shallow clone did seem to be equal or grater than the size of one repo using worktrees and sharing the same git objects.
The CI could build us tarballs that we install on the server afterwards.

[OlafvdSpek]

Is getting bigger disks an option?

[M393]

git gc --aggressive takes a lot of time to run, but brings the .git folder size from ~2.3 GiB to ~600 MiB

If after a few pulls the size is growing too large again, git gc --aggressive --keep-largest-pack will bring it down.

[williamdes]

Is getting bigger disks an option?

I tried for years to ask for this move, so not an option.

I am working on a split of the demo installer script into building on the snapshot VM and installing on the demo machine.
It should make the process work "for ever"

[williamdes]

git gc --aggressive takes a lot of time to run, but brings the .git folder size from ~2.3 GiB to ~600 MiB

If after a few pulls the size is growing too large again, git gc --aggressive --keep-largest-pack will bring it down.

/mnt/storage/phpmyadmin-composer.git$ git gc --aggressive --keep-largest-pack
Enumerating objects: 976975, done.
Counting objects: 100% (2311/2311), done.
Delta compression using up to 4 threads
Compressing objects: 100% (2250/2250), done.
Writing objects: 100% (2311/2311), done.
Total 2311 (delta 1586), reused 344 (delta 0), pack-reused 0 (from 0)
/mnt/storage/phpmyadmin-composer.git$ du -sh /mnt/storage/phpmyadmin-composer.git/
1.4G	/mnt/storage/phpmyadmin-composer.git/

/mnt/storage/phpmyadmin.git$ du -sh .
2.5G	.
/mnt/storage/phpmyadmin.git$ git gc --aggressive --keep-largest-pack
Enumerating objects: 873664, done.
Counting objects: 100% (1979/1979), done.
Delta compression using up to 4 threads
Compressing objects: 100% (1972/1972), done.
Writing objects: 100% (1979/1979), done.
Total 1979 (delta 1407), reused 337 (delta 0), pack-reused 0 (from 0)
/mnt/storage/phpmyadmin.git$ du -sh .
2.4G	.

[M393]

The largest file is generally the one which is created when cloning, then with each pull a new one is created.
With the --keep-largest-pack option git does not change the largest .pack file in .git/objects/pack/, so it should be run without that option once.

[williamdes]

Indeed

/mnt/storage/phpmyadmin.git$ git gc --aggressive 
Enumerating objects: 873664, done.
Counting objects: 100% (873664/873664), done.
Delta compression using up to 4 threads
Compressing objects: 100% (870043/870043), done.
Writing objects: 100% (873664/873664), done.
Total 873664 (delta 704759), reused 160755 (delta 0), pack-reused 0 (from 0)
/mnt/storage/phpmyadmin.git$ du -sh .
659M	.

[williamdes]

/mnt/storage/phpmyadmin-composer.git$ git gc --aggressive
Enumerating objects: 976975, done.
Counting objects: 100% (976975/976975), done.
Delta compression using up to 4 threads
Compressing objects:  79% (732672/922787)
Compressing objects: 100% (922787/922787), done.
Writing objects: 100% (976975/976975), done.
Total 976975 (delta 748657), reused 227919 (delta 0), pack-reused 0 (from 0)
/mnt/storage/phpmyadmin-composer.git$ du -sh
1.3G	.

Down ~100MB

[williamdes]

It should work fine now