Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4018) - 28 March 2024
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
ImportCumulusFile error
Moderator: mcrossley
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
ImportCumulusFile error
hi all im trying to put all my Monthly file in SQL database but the fist one goes in with a error
Running from web server
Script start: 29/06/18 - 15:45:35
Importing file: ./data/Aug17log.txt, To table: Monthly ...
Connected to database OK.
Set MySQL TZ OK.
Processing monthfile...
Table 'Monthly' does not exist, creating it...
Table 'Monthly' created OK.
Prepared SQL statement OK.
Inserting data...
Error: Failed to insert data, error is: Disk is full writing './cumulus/Monthly.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
End.
then i look at the data base and i see it in there but i dont understand why is saying about Disk is full ive got 2.8tb left
so if i go and do a nother inport it just sit there saying
Inserting data...
any help plz
Running from web server
Script start: 29/06/18 - 15:45:35
Importing file: ./data/Aug17log.txt, To table: Monthly ...
Connected to database OK.
Set MySQL TZ OK.
Processing monthfile...
Table 'Monthly' does not exist, creating it...
Table 'Monthly' created OK.
Prepared SQL statement OK.
Inserting data...
Error: Failed to insert data, error is: Disk is full writing './cumulus/Monthly.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
End.
then i look at the data base and i see it in there but i dont understand why is saying about Disk is full ive got 2.8tb left
so if i go and do a nother inport it just sit there saying
Inserting data...
any help plz
- mcrossley
- Posts: 12695
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: ImportCumulusFile error
This looks a likely candidate...
We have experienced similar issue, and the problem was MySQL used /tmp directory for its needs (it's default configuration). And /tmp was located on its own partition, that had too few space for big MySQL requests.
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
lol what candidate mean
-
- Posts: 3215
- Joined: Sat 13 Aug 2011 9:33 am
- Weather Station: Ecowitt HP2551
- Operating System: Windows 10 64bit
- Location: Burnham-on-Sea
- Contact:
Re: ImportCumulusFile error
He mean this may be your problem. It is trying to set up the database in /tmp which is running out of space.
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
i just look in a temp dir and it ok what temp dir it go in for the nas drive
- mcrossley
- Posts: 12695
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: ImportCumulusFile error
MySQL uses the tmp folder by default on some installs for its working files. On Linux try looking at the output from
> df -h
and see if any of your partitions are full?
> df -h
and see if any of your partitions are full?
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
%root% 54.2M 33.9M 17.5M 66% /
/dev/ram0 54.2M 33.9M 17.5M 66% /
mdev 251.2M 32.0K 251.2M 0% /dev
/dev/sda3 975.9M 192.2M 716.5M 21% /boot
/dev/sda7 976.2M 352.0K 949.7M 0% /usr/local/config
/dev/loop0 92.4M 92.4M 0 100% /usr/local/modules
tmpfs 1.0M 0 1.0M 0% /mnt
tmpfs 40.0M 2.8M 37.2M 7% /var/log
tmpfs 100.0M 4.8M 95.2M 5% /tmp
/dev/sda4 928.9M 912.9M 4.0K 100% /mnt/HD_a4
/dev/sda2 2.7T 1.3G 2.6T 0% /mnt/HD/HD_a2
/dev/ram0 54.2M 33.9M 17.5M 66% /
mdev 251.2M 32.0K 251.2M 0% /dev
/dev/sda3 975.9M 192.2M 716.5M 21% /boot
/dev/sda7 976.2M 352.0K 949.7M 0% /usr/local/config
/dev/loop0 92.4M 92.4M 0 100% /usr/local/modules
tmpfs 1.0M 0 1.0M 0% /mnt
tmpfs 40.0M 2.8M 37.2M 7% /var/log
tmpfs 100.0M 4.8M 95.2M 5% /tmp
/dev/sda4 928.9M 912.9M 4.0K 100% /mnt/HD_a4
/dev/sda2 2.7T 1.3G 2.6T 0% /mnt/HD/HD_a2
- mcrossley
- Posts: 12695
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: ImportCumulusFile error
So you have two partitions that are full - 100%, sorry no idea what they are being used for, but /usr/local/modules being full doesn't sound good.
Code: Select all
%root% 54.2M 33.9M 17.5M 66% /
/dev/ram0 54.2M 33.9M 17.5M 66% /
mdev 251.2M 32.0K 251.2M 0% /dev
/dev/sda3 975.9M 192.2M 716.5M 21% /boot
/dev/sda7 976.2M 352.0K 949.7M 0% /usr/local/config
/dev/loop0 92.4M 92.4M 0 100% /usr/local/modules
tmpfs 1.0M 0 1.0M 0% /mnt
tmpfs 40.0M 2.8M 37.2M 7% /var/log
tmpfs 100.0M 4.8M 95.2M 5% /tmp
/dev/sda4 928.9M 912.9M 4.0K 100% /mnt/HD_a4
/dev/sda2 2.7T 1.3G 2.6T 0% /mnt/HD/HD_a2
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
ok thank u i think i know my plans are for to night
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
hang on cant i move the temp dir to some were eles?
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
hi all ive fix the error about the disk full and ive done it again and the fist one went in to the data base ok but then i did a other one and it just says
Running from web server
Script start: 01/07/18 - 11:48:38
Importing file: ./data/Feb18log, To table: Monthly ...
Error: Failed to open file: './data/Feb18log'
Script complete: 01/07/18 - 11:48:38
Execution time: 0 secs
and i look in the sql and it not in there?
Running from web server
Script start: 01/07/18 - 11:48:38
Importing file: ./data/Feb18log, To table: Monthly ...
Error: Failed to open file: './data/Feb18log'
Script complete: 01/07/18 - 11:48:38
Execution time: 0 secs
and i look in the sql and it not in there?
- mcrossley
- Posts: 12695
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: ImportCumulusFile error
Error: Failed to open file: './data/Feb18log'
Isn't that filename missing the ".txt" off the end?
Isn't that filename missing the ".txt" off the end?
- dazza1223
- Posts: 860
- Joined: Sun 25 Jan 2015 8:41 pm
- Weather Station: Davis Vantage Pro 2 plus
- Operating System: Raspberry pi 4 (4gb)
- Location: Worthing
- Contact:
Re: ImportCumulusFile error
hi mark thank for geting back to me but ive spent most off to night debugging errors out on that Feb log file and ive fix it thanks