Mauro Michielon michimau
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 5/8/2019 12:15:07 PM PREFIX a: <http://www.eea.europa.eu/portal_types/Data#> | |
| 5/8/2019 12:15:07 PMPREFIX dt: <http://www.eea.europa.eu/portal_types/DataTable#> | |
| 5/8/2019 12:15:07 PMPREFIX org: <http://www.eea.europa.eu/portal_types/Organisation#> | |
| 5/8/2019 12:15:07 PMPREFIX dct: <http://purl.org/dc/terms/> | |
| 5/8/2019 12:15:07 PMPREFIX ecodp: <http://open-data.europa.eu/ontologies/ec-odp#> | |
| 5/8/2019 12:15:07 PMPREFIX dcat: <http://www.w3.org/ns/dcat#> | |
| 5/8/2019 12:15:07 PMPREFIX owl: <http://www.w3.org/2002/07/owl#> | |
| 5/8/2019 12:15:07 PMPREFIX xsd: <http://www.w3.org/2001/XMLSchema#> | |
| 5/8/2019 12:15:07 PMPREFIX datafilelink: <http://www.eea.europa.eu/portal_types/DataFileLi | |
| 5/8/2019 12:15:07 PM PREFIX a: <http://www.eea.europa.eu/portal_types/Data#> |
michimau
/ memory corruption
Created
May 8, 2019 12:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 5/8/2019 2:15:20 PM*** Error in `/usr/bin/virtuoso-t': malloc(): memory corruption: 0x00007fa76c60bc90 *** | |
| 5/8/2019 2:15:20 PM======= Backtrace: ========= | |
| 5/8/2019 2:15:20 PM/lib64/libc.so.6(+0x72435)[0x7fa807776435] | |
| 5/8/2019 2:15:20 PM/lib64/libc.so.6(+0x7cf6e)[0x7fa807780f6e] | |
| 5/8/2019 2:15:20 PM/lib64/libc.so.6(__libc_malloc+0x59)[0x7fa807782ab9] | |
| 5/8/2019 2:15:20 PM/usr/bin/virtuoso-t[0x7b799f] | |
| 5/8/2019 2:15:20 PM/usr/bin/virtuoso-t[0x7a2b2d] | |
| 5/8/2019 2:15:20 PM/usr/bin/virtuoso-t[0x7a3111] | |
| 5/8/2019 2:15:20 PM/usr/bin/virtuoso-t[0x7a3bb3] | |
| 5/8/2019 2:15:20 PM/usr/bin/virtuoso-t[0x53b62e] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [2019-05-16 11:29:21.583] - INFO --- rg.springframework.test.context.support.DefaultTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@19539731, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@d67714, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5dea8ad6, org.springframework.test.context.support.DirtiesContextTestExecutionListener@230e0fbd, org.springframework.test.context.transaction.TransactionalTestExecutionListener@2661fef2, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@153c53fd] - (DefaultTestContextBootstrapper.java:187) | |
| [WARNING] Tests run: 1, Failures: 0, Errors: 0, Skipped: 1, Time elapsed: 0 s - in eionet.cr.harvest.UnauthorizedHarvestIT | |
| [INFO] | |
| [INFO] Results: | |
| [INFO] | |
| [ERROR] Errors: | |
| [ERROR] GeneralConfigTest.testGetIntPropertyCorrect » IllegalState Failed to load Appl... | |
| [ERROR] GeneralConfigTest.testGetIntPropertyNotExisti |
michimau
/ materialized view Antognazza
Created
June 7, 2019 15:49
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE MATERIALIZED VIEW clrtap_nec_unfccc.running_total_and_target ( | |
| year, | |
| country_code, | |
| pollutant_name, | |
| sector_code, | |
| emissions, | |
| target, | |
| running_total) | |
| AS | |
| SELECT source.year, |
michimau
/ query Antognazza
Created
June 7, 2019 15:50
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| source.year, | |
| source.country_code, | |
| source.pollutant_name, | |
| source.sector_code, | |
| source.emissions | |
| FROM | |
| clrtap_nec_unfccc.clrtap_nfr09_gf source, | |
| ( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PYDIO_URL=my.pydio.cells | |
| MYSQL_ROOT_PASSWORD=rootPassword | |
| MYSQL_DATABASE=pydio | |
| MYSQL_USER=cells | |
| MYSQL_PASSWORD=password |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <VirtualHost *:80> | |
| ServerAdmin mypydio.com | |
| AllowEncodedSlashes On | |
| RewriteEngine On | |
| ProxyPassMatch "/ws/(.*)" ws://cells:8080/ws/$1 nocanon | |
| ProxyPass / http://cells:8080/ nocanon | |
| ProxyPassReverse / http://cells:8080/ nocanon |
michimau
/ gist:e054e2d17dfc51b9204d322826ecec3c
Last active
July 14, 2019 12:10
pydio_docker-compose
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: '2' | |
| services: | |
| cells: | |
| image: pydio/cells:latest | |
| restart: always | |
| volumes: | |
| - data:/root/.config/pydio/cells/data | |
| ports: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * depends on bootstrap | |
| * | |
| * html { box-sizing: border-box; } | |
| * body { background: #fff; } | |
| * p { margin-top:0; margin-bottom:1rem; } | |
| * | |
| **/ | |
| /** |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with ns as ( | |
| select ARRAY[ARRAY['xlink', 'http://www.w3.org/1999/xlink'], ARRAY['gmd', 'http://www.isotc211.org/2005/gmd'], ARRAY['gco', 'http://www.isotc211.org/2005/gco']] as n | |
| ) | |
| SELECT uuid, changedate, | |
| unnest(xpath('//gmd:identifier[*]/gmd:MD_Identifier[*]/gmd:code[*]/gco:CharacterString[1]/text()', XMLPARSE(DOCUMENT data), n)) as dataset_id, | |
| changedate as datestamp, | |
| unnest(xpath('//gmd:referenceSystemIdentifier[*]', XMLPARSE(DOCUMENT data), n)) as crs, | |
| unnest(xpath('//gmd:citation[*]/gmd:CI_Citation[*]/gmd:title[*]/gco:CharacterString[1]/text()', XMLPARSE(DOCUMENT data), n)) as title, |