ERROR: The partition with /var/lib/mysql is too full!

Question

The matrix below has column totals under the red line. The pivoted column group columns are highlighted in yellow to the right of the vertical red line. The columns in the white to the left are not pivoted.

So it looks like the totals under the pivoted yellow columns are correct,

but the totals under the regular columns are totally wrong.

Those are simple =Sum(Fields!columnX.Value) totals in a group total row.

Matrix design is as follows (wherever you see "Expr" it is simply that Sum multiplied by a temporarily used constant 1, except where I deleted that from pour_weight for simplicity):

It appears that SSRS totals the left columns BEFORE pivoting the right columns, which is a total disaster.

What am I doing wrong?

Solution

You can check the amount of free space on your partition with the command: df You can also check which partition holds the directory /var/lib/mysql for example with the mount command.

Many distributions have their /var directory in the original root partition which is not made big enough by default to hold real-life data. They usually create separate partition for /usr with tons of space, so your easiest solution would be to stop mysql, copy /var/lib/mysql to /usr/lib/mysql (or /usr/local/lib/mysql no real difference), delete the original and make a symbolic link in the old place with:

ln -s /usr/lib/mysql /var/lib/mysql

Of course check that the destination directory have the right permissions.

Comments

[Andrew Cooper]

Looks like you're out of space

[Admin]

I think you need to upgrade to a server with more database space. But, I would start by looking at some disk usages to identify which tables are the culprits and check whether those were supposed to grow like that. If not, then there is more to look for.

[alexanderzhirov]

@WhiteFang34 which files i should delete???

[Alnitak]

the ones you don't need!

[alexanderzhirov]

I tried many of the log files but its making no difference

[user9517]

Please add the output of df -h to your question.

[ajeh]

What on Earth does that drive-by downvote mean? No comment, no attempt to answer... If you are such a smart ass (as in 'donkey'), put it writing, will you?

[Dominic Ceraso]

How do I check that with the mount command? What is the command?