Skip to content

Instantly share code, notes, and snippets.

Avatar

Marcello Verona marciuz

View GitHub Profile
@marciuz
marciuz / .gitignore
Created Jan 25, 2023
Drupal 9 .gitignore
View .gitignore
### macOS ###
# General
.DS_Store
.AppleDouble
.LSOverride
### Windows ###
# Windows thumbnail cache files
Thumbs.db
Thumbs.db:encryptable
View Error metabase
[cda8ce5f-16c4-4f7d-8d04-12aefcbbad3f] 2021-03-05T14:53:56+01:00 ERROR metabase.sync.util Error fingerprinting Table 154 'widget_tracker_dett'
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at metabase.driver.sql_jdbc.execute$fn__77477.invokeStatic(execute.clj:155)
at metabase.driver.sql_jdbc.execute$fn__77477.invoke(execute.clj:153)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)
View Metabase log with error in 0.35.4 -> 0.36.x with MB_DB_AUTOMIGRATE=FALSE
mar 04 19:38:50 patato02 java[3069882]: WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
mar 04 19:38:51 patato02 java[3069882]: 2021-03-04 19:38:51,139 INFO metabase.util :: Maximum memory available to JVM: 512.0 MB
mar 04 19:38:57 patato02 systemd-resolved[552]: Server returned error NXDOMAIN, mitigating potential DNS violation DVE-2018-0001, retrying transaction with reduced feature level UDP.
mar 04 19:38:59 patato02 java[3069882]: 2021-03-04 19:38:59,324 INFO util.encryption :: Saved credentials encryption is ENABLED for this Metabase instance. 🔐
mar 04 19:38:59 patato02 java[3069882]: For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
mar 04 19:39:03 patato02 java[3069882]: 2021-03-04 19:39:03,318 INFO metabase.core ::
mar 04 19:39:03 patato02 java[3069882]: Metabase v0.38.1 (79ef63a release-x.38.x)
mar 04 19:39:03 patato02 java[3069882]: Copyright © 2021 Metabase, Inc.
mar 04 19:39:03 patato
View Metabase log with error in 0.35.4 -> 0.36.x
mar 04 10:41:25 patato02 java[3007061]: 03-04 10:41:25 INFO metabase.util :: Loading Metabase...
mar 04 10:41:25 patato02 java[3007061]: 03-04 10:41:25 INFO metabase.util :: Maximum memory available to JVM: 512.0 MB
mar 04 10:41:33 patato02 java[3007061]: WARNING: not-empty already refers to: #'clojure.core/not-empty in namespace: metabase.mbql.schema, being replaced by: #'metabase.mbql.schema/not-empty
mar 04 10:41:33 patato02 java[3007061]: 03-04 10:41:33 INFO util.encryption :: Saved credentials encryption is ENABLED for this Metabase instance. 🔐
mar 04 10:41:33 patato02 java[3007061]: For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
mar 04 10:45:56 patato02 java[3007061]: 03-04 10:45:56 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
mar 04 10:45:56 patato02 java[3007061]: 03-04 10:45:56 INFO metabase.core :: Starting Metabase in STANDALONE mode
mar 04 10:45:56 p
@marciuz
marciuz / syslog-extract.log
Created Nov 19, 2019
Syslog error Metabase start
View syslog-extract.log
Nov 19 23:01:52 epeems systemd[1]: Stopping Metabase application service...
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.core#033[0m :: Metabase Shutting Down ...
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.server#033[0m :: Shutting Down Embedded Jetty Webserver
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.core#033[0m :: Metabase Shutdown COMPLETE
Nov 19 23:01:52 epeems systemd[1]: metabase.service: Main process exited, code=exited, status=143/n/a
Nov 19 23:01:52 epeems systemd[1]: metabase.service: Failed with result 'exit-code'.
Nov 19 23:01:52 epeems systemd[1]: Stopped Metabase application service.
Nov 19 23:01:56 epeems postfix/smtpd[12677]: connect from unknown[185.234.219.64]
Nov 19 23:01:56 epeems postfix/smtpd[12677]: lost connection after AUTH from unknown[185.234.219.64]
Nov 19 23:01:56 epeems postfix/smtpd[12677]: disconnect from unknown[185.234.219.64] ehlo=1 auth=0/1 commands=1/2
@marciuz
marciuz / syslog-extract.log
Created Nov 19, 2019
Syslog error Metabase start
View syslog-extract.log
Nov 19 23:01:52 epeems systemd[1]: Stopping Metabase application service...
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.core#033[0m :: Metabase Shutting Down ...
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.server#033[0m :: Shutting Down Embedded Jetty Webserver
Nov 19 23:01:52 epeems java[12157]: 11-19 23:01:52 #033[1mINFO metabase.core#033[0m :: Metabase Shutdown COMPLETE
Nov 19 23:01:52 epeems systemd[1]: metabase.service: Main process exited, code=exited, status=143/n/a
Nov 19 23:01:52 epeems systemd[1]: metabase.service: Failed with result 'exit-code'.
Nov 19 23:01:52 epeems systemd[1]: Stopped Metabase application service.
Nov 19 23:01:56 epeems postfix/smtpd[12677]: connect from unknown[185.234.219.64]
Nov 19 23:01:56 epeems postfix/smtpd[12677]: lost connection after AUTH from unknown[185.234.219.64]
Nov 19 23:01:56 epeems postfix/smtpd[12677]: disconnect from unknown[185.234.219.64] ehlo=1 auth=0/1 commands=1/2
@marciuz
marciuz / highchart-european-union.js
Created Oct 2, 2019
Preset for Highcharts/Highmaps for the European Union (28 countries)
View highchart-european-union.js
Highcharts.maps["custom/european-union"] = {
"title": "European Union",
"version": "1.1.2",
"type": "FeatureCollection",
"copyright": "Copyright (c) 2015 Highsoft AS, Based on data from Natural Earth",
"copyrightShort": "Natural Earth",
"copyrightUrl": "http://www.naturalearthdata.com",
"crs": {
"type": "name",
"properties": {
@marciuz
marciuz / highchart-european-union.js
Created Oct 2, 2019
Preset for Highcharts/Highmaps for the European Union (28 countries)
View highchart-european-union.js
Highcharts.maps["custom/european-union"] = {
"title": "European Union",
"version": "1.1.2",
"type": "FeatureCollection",
"copyright": "Copyright (c) 2015 Highsoft AS, Based on data from Natural Earth",
"copyrightShort": "Natural Earth",
"copyrightUrl": "http://www.naturalearthdata.com",
"crs": {
"type": "name",
"properties": {
@marciuz
marciuz / mysql-eu-countries
Created Oct 2, 2019 — forked from naskobulgaria/mysql-eu-countries
Sql dump of all the European Countries.
View mysql-eu-countries
/**
* Countries MySQL Tables
* Compiled by Atanas Bozhinov, 2015
*/
CREATE TABLE `eucountries` (
`country_id` int(11) NOT NULL AUTO_INCREMENT,
`code` char(2) NOT NULL COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
`name` varchar(64) NOT NULL COMMENT 'English country name',
`full_name` varchar(128) NOT NULL COMMENT 'Full English country name',
@marciuz
marciuz / harvest.sh
Created Dec 22, 2017
Script per l'harvesting di Dati.gov.it
View harvest.sh
#!/bin/sh
# File harvest.sh
# Esegue l'harvest del parametro $1, inviato come argomento
# Il parametro è del tipo "dati_trentino", cioè il machine name di DKAN.
#
# Ultima modifica: 08/05/2017 - <marcelloverona@gmail.com>
#
# document root di DKAN