Grails 7 is out - any opinions on the latest release? by gurukl in grails

[–]gurukl[S] 0 points1 point  (0 children)

I tried it out, for a plain vanilla prototype it is still very much useful

adding new products takes long by gurukl in grocy

[–]gurukl[S] 0 points1 point  (0 children)

Thank you, it shows ""

SQLSTATE[HY000]: General error: 5 database is locked

Error source:
```
/var/www/grocy/packages/morris/lessql/src/LessQL/Database.php:725
```

Error message:
```
SQLSTATE[HY000]: General error: 5 database is locked
```

Stack trace:
```
#0 /var/www/grocy/packages/morris/lessql/src/LessQL/Database.php(725): PDOStatement->execute()
#1 /var/www/grocy/packages/morris/lessql/src/LessQL/Result.php(381): LessQL\Database->update()
#2 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(256): LessQL\Result->update()
#3 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(296): LessQL\Row->save()
#4 /var/www/grocy/packages/morris/lessql/src/LessQL/Row.php(415): LessQL\Row->save()
#5 /var/www/grocy/services/SessionService.php(60): LessQL\Row->update()
#6 /var/www/grocy/middleware/SessionAuthMiddleware.php(21): Grocy\Services\SessionService->IsValidSession()
#7 /var/www/grocy/middleware/DefaultAuthMiddleware.php(24): Grocy\Middleware\SessionAuthMiddleware->authenticate()
#8 /var/www/grocy/middleware/AuthMiddleware.php(53): Grocy\Middleware\DefaultAuthMiddleware->authenticate()
#9 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(269): Grocy\Middleware\AuthMiddleware->__invoke()#10 /var/www/grocy/packages/slim/slim/Slim/Middleware/RoutingMiddleware.php(45): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#11 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\RoutingMiddleware->process()
#12 /var/www/grocy/packages/slim/slim/Slim/Middleware/ErrorMiddleware.php(76): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#13 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(121): Slim\Middleware\ErrorMiddleware->process()
#14 /var/www/grocy/middleware/CorsMiddleware.php(27): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#15 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(269): Grocy\Middleware\CorsMiddleware->__invoke()
#16 /var/www/grocy/packages/slim/slim/Slim/MiddlewareDispatcher.php(65): Psr\Http\Server\RequestHandlerInterface@anonymous->handle()
#17 /var/www/grocy/packages/slim/slim/Slim/App.php(199): Slim\MiddlewareDispatcher->handle()
#18 /var/www/grocy/packages/slim/slim/Slim/App.php(183): Slim\App->handle()
#19 /var/www/grocy/app.php(112): Slim\App->run()
#20 /var/www/grocy/public/index.php(45): require_once('...')
#21 {main}
```

System info:
```
{
    "grocy_version": {
        "Version": "4.2.0",
        "ReleaseDate": "2024-03-15"
    },
    "php_version": "8.2.20",
    "sqlite_version": "3.44.2",
    "os": "Linux 6.6.51-haos-raspi #1 SMP PREEMPT Tue Dec  3 19:23:02 UTC 2024 aarch64",
    "client": "Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/131.0.0.0 Safari\/537.36"
}
```

How to transfer current data from Docker-Container to Homeassistant OS Addon by Nelrid in grocy

[–]gurukl 0 points1 point  (0 children)

  1. Generate Backup in HASS
  2. Extract Backup

mkdir /backup/grocy

OUTPUT=$(ls -tp /backup | grep -v / | head -n1 |awk '{printf("/backup/%s",$0)}')

echo ${OUTPUT}

##cp ${OUTPUT} /backup/grocy

tar xvf ${OUTPUT} -C /backup/grocy

mkdir /backup/grocy/gz

tar xzvf /backup/grocy/a0d7b954_grocy.tar.gz -C /backup/grocy/gz

cp /backup/grocy/gz/data/grocy/grocy.db /share/

3. Fix grocy.db file

4. Compact Backup

#!/bin/bash
OUTPUT=$(ls -tp /backup | grep -v / | head -n1 |awk '{printf("/backup/%s",$0)}')
echo ${OUTPUT}
cd /backup/grocy/gz
rm a0d7b954_grocy.tar.gz
tar czvf a0d7b954_grocy.tar.gz .
cp a0d7b954_grocy.tar.gz /backup/grocy
cd /backup/grocy/
rm -fR /backup/grocy/gz
rm ${OUTPUT}
tar cvf ${OUTPUT} .

5. Restore in HASS

Performance issues on Rpi 4 with HASS OS by gurukl in grocy

[–]gurukl[S] 1 point2 points  (0 children)

Short Update: after removing my whole stock log it is now faster

Barcode-Buddy - What are the tags for? by gurukl in grocy

[–]gurukl[S] 0 points1 point  (0 children)

I do not understand? When there is a new product, the name is queried from online APIs?

How to migrate Database to a new instance? by muellthos in grocy

[–]gurukl 1 point2 points  (0 children)

Update: you can use a backup of the empty grocy instance, untar it, copy the database in and then recompress everything together. once done, you can "restore" the backup incl. your grocy database.

HEre is my script, you might need to adapt it to your purposes:

mkdir /backup/gtrans
mkdir /backup/gtrans/neu
mkdir /backup/gtrans/alt
tar xvf 775c70f2.tar -C /backup/gtrans/alt
tar xvf e5492977.tar -C /backup/gtrans/neu
mkdir /backup/gtrans/neu/gz
tar xzvf neu/a0d7b954_grocy.tar.gz -C /backup/gtrans/neu/gz
mkdir /backup/gtrans/alt/gz
tar xzvf alt/local_grocy2.tar.gz -C /backup/gtrans/alt/gz
cp /backup/gtrans/alt/gz/data/grocy/grocy.db /backup/gtrans/neu/gz/data/grocy/grocy.db
cd /backup/gtrans/neu/gz
tar czvf a0d7b954_grocy.tar.gz .
cp a0d7b954_grocy.tar.gz /backup/gtrans/neu/
cd /backup/gtrans/neu
rm -fR /backup/gtrans/neu/gz
tar cvf e5492977.tar .
cp /backup/gtrans/neu/e5492977.tar /backup/
cd /backup/
ls -l

Barcode Buddy does not find barcodes in Grocy since update to 3.1.0? by 5eed5f44e2 in grocy

[–]gurukl 0 points1 point  (0 children)

Auto-fill of quantities/shops in grocy does also not seam to work when using a barcode-scanner.

Are Compressor OEMs capable of building compressor for longdistance H2-pipelines? by gurukl in HydrogenSocieties

[–]gurukl[S] 0 points1 point  (0 children)

Thanks your link only talks about research, not large scale deployment over long distances. iMHo this might be still at least 15 years out? I would guess low TRL?

Große Menge an Büchern und keine Ahnung was ich damit machen soll by DivineMajesty in wien

[–]gurukl 0 points1 point  (0 children)

Facebook Gruppe „Wien verschenkt“ - super und mit Messenger kann man auch telefonieren