~whynothugo

The Netherlands

https://whynothugo.nl

Trackers

~whynothugo/vdirsyncer-rs

Last active 5 days ago

~whynothugo/dotfiles

Last active a month ago

~whynothugo/shotman

Last active a month ago

~whynothugo/lsp_lines.nvim

Last active 3 months ago

~whynothugo/xendmail

Last active 7 months ago

~whynothugo/systemd-lock-handler

Last active 9 months ago

~whynothugo/docker-makepkg

Last active 11 months ago

~whynothugo/clipmon

Last active 1 year, 25 days ago

~whynothugo/wdisplays-ng

Last active 1 year, 6 months ago

~whynothugo/himitsu-mutt

Last active 1 year, 9 months ago
View more

#45 Use generic storage for vstorage::sync 5 days ago

Ticket created by ~whynothugo on ~whynothugo/vdirsyncer-rs

vstorage::sync ought to use generic storage types, rather than Arc<dyn Storage>.

A concrete user that needs an Arc can use it as the generic parameter. Users that don't need it won't use it.

This needs some review to ensure that it's entirely feasible, given that a Pair clones the Arc. It might need to consume the storage instead (consuming an Arc<Storage> would be fine.

#25 Mobroute: User-Reported Good & Problematic GTFS Datafeed MDBIDs 29 days ago

on ~mil/mobroute-tickets

Thanks for mentioning ~whynothugo - have added 1077 to the above list

#25 Mobroute: User-Reported Good & Problematic GTFS Datafeed MDBIDs 30 days ago

Comment by ~whynothugo on ~mil/mobroute-tickets

Worth mentioning 1077 from https://todo.sr.ht/~mil/mobroute-tickets/39 here.

#39 Transito: no such function: acos 30 days ago

Comment by ~whynothugo on ~mil/mobroute-tickets

I'd recommend testing with smaller (non-aggregate sources).

This is the only source that I've found for The Netherlands (checked here https://mdb.lrdu.org/ ). I follow https://todo.sr.ht/~mil/mobroute-tickets/19, feel free to close this if it feels like a duplicate.

#39 Transito: no such function: acos a month ago

Comment by ~whynothugo on ~mil/mobroute-tickets

On Alpine Linux. I previously built with go build.

I now built with go build -v -tags=sqlite_math_functions and I've made further progress.

  • I picked a From location as Amsterdam Centraal
  • I picked a To location as Utrecht Centraal.
  • I clicked Route and the timer started running.

It ran for a couple of hours writing to an sqlite repository until it ran out of memory.

> ./transito
2024/03/12 17:33:32 Set savestatefile: /home/hugo/.config/transito/transito_savestate.json
2024/03/12 17:33:39 Applied filter ({  "mdbid": [    1077  ]}) matched 1 Mobility DB GTFS sources: [1077]
2024/03/12 17:33:39 Running SourcesetStatus against 1 sources
2024/03/12 17:33:39 Running SourcesetStatus against 1 sources ok
2024/03/12 17:33:50 Applied filter ({  "mdbid": [    1077  ]}) matched 1 Mobility DB GTFS sources: [1077]
2024/03/12 17:33:50 Running SourcesetStatus against 1 sources
2024/03/12 17:33:50 Running SourcesetStatus against 1 sources ok
2024/03/12 17:33:50 Running Load against 1 sources
2024/03/12 17:33:50 Loading mdbid 1077 (1 of 1)
2024/03/12 17:33:50 Loading /home/hugo/.cache/mobroute/gtfs_1077_236f70a5f23c7ec24ee83b71a2cbc4ca4ecb8fdd9299d4e54ae77e972a8351ed.zip to DB with source name: 1077
2024/03/12 17:43:42 Loaded /home/hugo/.cache/mobroute/gtfs_1077_236f70a5f23c7ec24ee83b71a2cbc4ca4ecb8fdd9299d4e54ae77e972a8351ed.zip to DB with source name: 1077 ok
2024/03/12 17:43:42 Loading mdbid 1077 ok; used cache for URL download (true)
2024/03/12 17:43:42 Running Load against 1 sources ok
2024/03/12 17:43:42 Running Compute against 1 sources
2024/03/12 17:43:42 Computed table _cvconnd for source (1077 <nil>) out of date - updating ('' vs '1077:routes:C_0M_89416cd9a3df4286d22843504b1a04276e3dbb41e1927a1c953edff2819cfd0c,1077:stop_times:C_723M_ed70627b371444a8ba3e829d97f8026886f25a7bf32eca7fd7f58b66687156e9,1077:stops:C_4M_a9184b7e5adce38a68d169c327b34a7b73dafb14adbbba9b003c8f6a8baf01dd,1077:trips:C_51M_4453732f479178dbaed6b59c8d0e2495d14df77e16ad6cbbe15712c1b878572f')
2024/03/12 18:25:02 Computed table _cvstopparent for source (1077 <nil>) out of date - updating ('' vs '1077:stops:C_4M_a9184b7e5adce38a68d169c327b34a7b73dafb14adbbba9b003c8f6a8baf01dd')
2024/03/12 18:48:02 Computed table _cvtransfersgen for source (1077 <nil>) out of date - updating ('' vs '1077:stops:C_4M_a9184b7e5adce38a68d169c327b34a7b73dafb14adbbba9b003c8f6a8baf01dd')
2024/03/12 19:22:40 Running Compute against 1 sources ok
2024/03/12 19:22:41 Loading 
				select c.* from 
					_cvconnd c
					where from_stop_time between ? and ?
					and source || '_' || c.service_id in (
						select source || '_' || service_id
						from _vcaltoservice
							where service_date = ? and source in (?)
					)
					order by from_stop_time asc
			([63230 77630 20240312 1077]) to memory
2024/03/12 19:22:50 Loaded 
				select c.* from 
					_cvconnd c
					where from_stop_time between ? and ?
					and source || '_' || c.service_id in (
						select source || '_' || service_id
						from _vcaltoservice
							where service_date = ? and source in (?)
					)
					order by from_stop_time asc
			([63230 77630 20240312 1077]) to memory ok (len=359619)
2024/03/12 19:22:50 Loading select
				*, 
				-- In order of priority:
				-- A) use min_transfer_time (for t transfers this will be non null)
				-- B) use seconds based on generated dist_km (dist_km calculated for both t & g transfers)
				-- C) (A/B nil || < param), then use minimum transfer secs from params
				max(coalesce(min_transfer_time, cast(dist_km / ? * 60 * 60 as uint), ?), ?) as transfer_time
			from
				(select * from _cvtransfersgen union all select * from _vtransferstbl) g
			where
				((source = ? and source_pair = ?)) and (transfer_time < ?) and transfer_category in (? , ?)
			([4.5 180 180 1077 1077 1200 t g]) to memory
zsh: killed     ./transito

A second attempt died much faster (in a minute or two). Exit code 137.

#39 Transito: no such function: acos a month ago

Comment by ~whynothugo on ~mil/mobroute-tickets

Using some different MDBID (e.g.: 1898) has the same result.

#39 Transito: no such function: acos a month ago

Ticket created by ~whynothugo on ~mil/mobroute-tickets

I built Transito from source (2f6e03830b88d4d5d0f3d5bf7826532b35305dfb). I searched for two places which I defined as From and To. This worked fine.

I then configured 1077 as a Source MDBID.

After switching back to the Route, clicking on the Route button, I get an error:

Error: Request to Mobroute API failed
(Raw error: Failed to initialize db connection: Error translating mobsql filter to sourceset: no such function: acos

If I go back to the search tab, I now get a similar error when searching for places:

Nominatim Fetch error: Error translating mobsql filter to sourceset: no such function: acos

Restarting the application does not fix it. If I delete the entry that I added to "Source MDBIDs", the search works again.

#21 zsh: Allow things like `cd ...` a month ago

Comment by ~whynothugo on ~whynothugo/dotfiles

Hugo Osvaldo Barrera referenced this ticket in commit fefbf10.

REPORTED RESOLVED FIXED

#21 zsh: Allow things like `cd ...` a month ago

Comment by ~whynothugo on ~whynothugo/dotfiles

#32 Sandboxing notes and ideas a month ago

Ticket created by ~whynothugo on ~whynothugo/dotfiles

#Narrowing down accessible files

  • Generate list of files based on the package and its dependencies.
  • Generate scripts based on that. It should only expose required binaries and nothing else. (BUT: what about optional dependencies?).