Saving to CSV on large number of rows only exports partial rows

[cmabastar]

Hi,

Was wondering if there's a way to fix my csv export. I use the pspg to export to csv via F9, save as CSV. But whenever the query have a row count 100k+ it only exports partial of the rows like 500 only to the file.

Any tips?

[okbob]

Hi

pá 2. 6. 2023 v 18:15 odesílatel starlord @.***> napsal:

Hi,

Was wondering if there's a way to fix my csv export. I use the pspg to export to csv via F9, save as CSV. But whenever the query have a row count 100k+ it only exports partial of the rows like 500 only to the file.

I'll look at this issue. There are probably some bugs. For this size is much better to export to CSV by COPY statements or \copy from psql

Any tips?

— Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4ZAQXUDXNRRJPMJXDDXJIGSJANCNFSM6AAAAAAYYQRMWM . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[okbob]

I tested it and it is working without problems on my com. Can you check pspg from master branch?

Can you write data generator, that generates data, that can force this issue?

[cmabastar]

I used the latest version.

I have the test data here. test.csv

It seems it's working on Save (getting all the keywords) but not Save as CSV

I also tried copy to clipboard, it only gets like 500 item out of the 200k

[okbob]

Copy to clipboard can be limited by some o.s. limits. But on my Fedora 38, copy to clipboard and pasting to gnome text edit is ok (on my comp). I tested open your file and save it as csv, and it is working without problems too.

There can be some dependencies on a) configuration - can you show your .pspgconf file? b) operation system - what is result of pspg --info c) can you show log - you can run pspg with option log like pspg -f test.csv --log=mylog.txt ?

[cmabastar]

Hi Thanks!

I'm using this: a> pgpgconf.txt . I tried removing it but it still doesn't work. b>

❯ pspg --info
pspg-5.7.6
with readline (version: 0x0802)
with integrated menu
ncurses version: 6.4, patch: 20221231
ncurses with wide char support
ncurses widechar num: 0
wchar_t width: 4, max: 2147483647
with ncurses extended functions support no: 20221231
without ncurses extended colors
with postgres client integration
without inotify support
with kqueue support
Darwin starlord.local 20.6.0 Darwin Kernel Version 20.6.0: Thu Mar  9 20:39:26 PST 2023; root:xnu-7195.141.49.700.6~1/RELEASE_X86_64 x86_64

c>

Tue Jun  6 09:20:01 2023 [36090] started
Tue Jun  6 09:20:01 2023 [36090] with utf8 support
Tue Jun  6 09:20:01 2023 [36090] esc delay = -1
Tue Jun  6 09:20:01 2023 [36090] read input 243717 rows
Tue Jun  6 09:20:01 2023 [36090] terminal size by TIOCGWINSZ rows: 44, cols: 178
Tue Jun  6 09:20:01 2023 [36090] ncurses started
Tue Jun  6 09:20:01 2023 [36090] kmous=\E[<, TERM=xterm-256color
Tue Jun  6 09:20:01 2023 [36090] xterm mouse mode 1002 will be used
Tue Jun  6 09:20:01 2023 [36090] xterm mouse mode 1002 activated
Tue Jun  6 09:20:01 2023 [36090] initial stdscr size - maxy: 44, maxx: 178
Tue Jun  6 09:20:03 2023 [36090] process command: CursorLastRow
Tue Jun  6 09:20:03 2023 [36090] new screen size 44 178
Tue Jun  6 09:20:03 2023 [36090] releasing cmd bar
Tue Jun  6 09:20:03 2023 [36090] process command: CursorFirstRow
Tue Jun  6 09:20:03 2023 [36090] new screen size 44 178
Tue Jun  6 09:20:03 2023 [36090] releasing cmd bar
Tue Jun  6 09:20:04 2023 [36090] process command: CursorFirstRow
Tue Jun  6 09:20:08 2023 [36090] process command: CursorLastRow
Tue Jun  6 09:20:08 2023 [36090] new screen size 44 178
Tue Jun  6 09:20:08 2023 [36090] releasing cmd bar
Tue Jun  6 09:20:10 2023 [36090] process command: CursorFirstRow
Tue Jun  6 09:20:10 2023 [36090] new screen size 44 178
Tue Jun  6 09:20:10 2023 [36090] releasing cmd bar
Tue Jun  6 09:20:10 2023 [36090] process command: CursorFirstRow
Tue Jun  6 09:20:20 2023 [36090] process command: Quit
Tue Jun  6 09:20:20 2023 [36090] releasing cmd bar before end
Tue Jun  6 09:20:20 2023 [36090] xterm mouse mode 1002 is deactivated
Tue Jun  6 09:20:20 2023 [36090] ncurses ended
Tue Jun  6 09:20:20 2023 [36090] correct quit

[okbob]

please, can you apply patch 49624f3 and can me resend new log? and you should to try to use "save as csv". Your previous log doesn't contains any info about command SaveAsCSV. Now there should be some like

Tue Jun  6 03:47:07 2023 [322614] process command: SaveAsCSV
Tue Jun  6 03:47:07 2023 [322614] history loaded
Tue Jun  6 03:47:07 2023 [322614] input string prompt - "save to CSV file: "
Tue Jun  6 03:47:07 2023 [322614] xterm mouse mode 1002 is deactivated
Tue Jun  6 03:47:12 2023 [322614] xterm mouse mode 1002 activated
Tue Jun  6 03:47:12 2023 [322614] input string - "~/xx.7"
Tue Jun  6 03:47:12 2023 [322614] exported 243714 rows with result 1

[cmabastar]

ok i tried it:

Tue Jun  6 11:50:44 2023 [39695] started
Tue Jun  6 11:50:44 2023 [39695] with utf8 support
Tue Jun  6 11:50:44 2023 [39695] esc delay = -1
Tue Jun  6 11:50:44 2023 [39695] read input 243717 rows
Tue Jun  6 11:50:44 2023 [39695] terminal size by TIOCGWINSZ rows: 44, cols: 178
Tue Jun  6 11:50:44 2023 [39695] ncurses started
Tue Jun  6 11:50:44 2023 [39695] without xterm mouse mode support
Tue Jun  6 11:50:44 2023 [39695] initial stdscr size - maxy: 44, maxx: 178
Tue Jun  6 11:50:46 2023 [39695] process command: CursorLastRow
Tue Jun  6 11:50:46 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:46 2023 [39695] releasing cmd bar
Tue Jun  6 11:50:46 2023 [39695] process command: CursorFirstRow
Tue Jun  6 11:50:46 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:46 2023 [39695] releasing cmd bar
Tue Jun  6 11:50:46 2023 [39695] process command: CursorFirstRow
Tue Jun  6 11:50:47 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:47 2023 [39695] releasing cmd bar
Tue Jun  6 11:50:47 2023 [39695] process command: ShowMenu
Tue Jun  6 11:50:47 2023 [39695] init menu
Tue Jun  6 11:50:49 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:49 2023 [39695] releasing cmd bar
Tue Jun  6 11:50:49 2023 [39695] process command: SaveAsCSV
Tue Jun  6 11:50:49 2023 [39695] history loaded
Tue Jun  6 11:50:49 2023 [39695] input string prompt - "save to CSV file: "
Tue Jun  6 11:50:49 2023 [39695] xterm mouse mode 1002 is not active
Tue Jun  6 11:50:52 2023 [39695] xterm mouse mode 1002 is not activated
Tue Jun  6 11:50:52 2023 [39695] input string - "~/Downloads/t1.csv"
Tue Jun  6 11:50:52 2023 [39695] exported 243714 rows with result 1
Tue Jun  6 11:50:52 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:52 2023 [39695] releasing cmd bar
Tue Jun  6 11:50:53 2023 [39695] process command: Quit
Tue Jun  6 11:50:53 2023 [39695] releasing cmd bar before end
Tue Jun  6 11:50:53 2023 [39695] releasing menu bar before end
Tue Jun  6 11:50:53 2023 [39695] xterm mouse mode 1002 is not active
Tue Jun  6 11:50:53 2023 [39695] ncurses ended
Tue Jun  6 11:50:53 2023 [39695] correct quit

[okbob]

Then it should to work. From the log should be clean so export wrote 243714 lines

Tue Jun  6 11:50:52 2023 [39695] xterm mouse mode 1002 is not activated
Tue Jun  6 11:50:52 2023 [39695] input string - "~/Downloads/t1.csv"
Tue Jun  6 11:50:52 2023 [39695] exported 243714 rows with result 1
Tue Jun  6 11:50:52 2023 [39695] new screen size 44 178
Tue Jun  6 11:50:52 2023 [39695] releasing cmd bar

It is really strange.

[cmabastar]

i tried it, strange as well. but when i connect to my RDS server. it still truncated to around 500 lines.

Is there a way to add a log in in the .psqlrc e.g. \setenv PAGER "pspg --log=~/mylog.txt" ?

[okbob]

út 6. 6. 2023 v 6:44 odesílatel starlord @.***> napsal:

i tried it, strange as well. but when i connect to my RDS server. it still truncated to around 500 lines.

Is there a way to add a log in in the .psqlrc e.g. \setenv PAGER "pspg --log=~/mylog.txt" ?

you can try

\setenv PSQL_PAGER pspg \setenv PSPG "--log=/mylog.txt"

—

Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223#issuecomment-1577896484, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4Y4BCAAEFA6ZRN4ECTXJ2YTHANCNFSM6AAAAAAYYQRMWM . You are receiving this because you commented.Message ID: @.***>

[cmabastar]

ok here's the new log with connecting to my RDS.

Tue Jun  6 15:34:29 2023 [51412] started
Tue Jun  6 15:34:29 2023 [51412] with utf8 support
Tue Jun  6 15:34:29 2023 [51412] esc delay = -1
Tue Jun  6 15:34:29 2023 [51412] DataDesc is initialized
Tue Jun  6 15:34:29 2023 [51412] next row will be data row
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 500
Tue Jun  6 15:34:29 2023 [51412] read input 500 rows
Tue Jun  6 15:34:29 2023 [51412] terminal size by TIOCGWINSZ rows: 44, cols: 178
Tue Jun  6 15:34:29 2023 [51412] ncurses started
Tue Jun  6 15:34:29 2023 [51412] without xterm mouse mode support
Tue Jun  6 15:34:29 2023 [51412] initial stdscr size - maxy: 44, maxx: 178
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 2500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 2500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 4500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 4500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 6500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 6500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 8500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 8500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 10500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 10500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 12500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 12500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 14500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 14500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 16500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 16500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 18500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 18500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 20500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 20500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 22500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 22500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 24500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 24500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 26500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 26500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 28500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 28500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 30500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 30500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 32500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 32500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 34500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 34500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 36500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 36500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 38500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 38500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 40500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 40500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 42500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 42500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 44500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 44500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 46500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 46500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 48500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 48500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 50500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 50500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 52500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 52500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 54500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 54500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 56500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 56500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 58500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 58500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 60500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 60500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 62500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 62500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 64500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 64500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 66500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 66500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 68500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 68500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 70500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 70500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 72500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 72500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 74500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 74500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 76500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 76500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 78500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 78500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 80500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 80500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 82500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 82500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 84500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 84500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 86500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 86500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 88500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 88500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 90500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 90500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 92500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 92500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 94500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 94500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 96500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 96500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 98500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 98500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 100500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 100500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 102500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 102500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 104500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 104500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 106500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 106500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 108500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 108500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 110500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 110500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 112500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 112500
Tue Jun  6 15:34:29 2023 [51412] process command: Invalid
Tue Jun  6 15:34:29 2023 [51412] progressive load stop on 114500 row
Tue Jun  6 15:34:29 2023 [51412] read rows 114500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 116500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 116500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 118500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 118500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 120500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 120500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 122500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 122500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 124500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 124500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 126500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 126500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 128500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 128500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 130500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 130500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 132500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 132500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 134500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 134500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 136500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 136500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 138500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 138500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 140500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 140500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 142500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 142500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 144500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 144500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 146500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 146500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 148500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 148500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 150500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 150500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 152500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 152500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 154500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 154500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 156500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 156500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 158500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 158500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 160500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 160500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 162500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 162500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 164500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 164500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 166500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 166500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 168500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 168500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 170500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 170500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 172500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 172500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 174500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 174500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 176500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 176500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 178500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 178500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 180500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 180500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 182500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 182500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 184500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 184500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 186500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 186500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 188500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 188500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 190500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 190500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 192500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 192500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 194500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 194500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 196500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 196500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 198500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 198500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 200500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 200500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 202500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 202500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 204500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 204500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 206500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 206500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 208500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 208500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 210500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 210500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 212500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 212500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 214500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 214500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 216500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 216500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 218500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 218500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 220500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 220500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 222500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 222500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 224500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 224500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 226500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 226500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 228500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 228500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 230500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 230500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 232500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 232500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 234500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 234500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 236500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 236500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 238500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 238500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 240500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 240500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] progressive load stop on 242500 row
Tue Jun  6 15:34:30 2023 [51412] read rows 242500
Tue Jun  6 15:34:30 2023 [51412] process command: Invalid
Tue Jun  6 15:34:30 2023 [51412] read rows 243718
Tue Jun  6 15:34:31 2023 [51412] process command: Invalid
Tue Jun  6 15:34:32 2023 [51412] process command: Invalid
Tue Jun  6 15:34:32 2023 [51412] process command: CursorLastRow
Tue Jun  6 15:34:32 2023 [51412] new screen size 44 178
Tue Jun  6 15:34:32 2023 [51412] releasing cmd bar
Tue Jun  6 15:34:50 2023 [51412] process command: Invalid
Tue Jun  6 15:34:51 2023 [51412] process command: CursorFirstRow
Tue Jun  6 15:34:51 2023 [51412] new screen size 44 178
Tue Jun  6 15:34:51 2023 [51412] releasing cmd bar
Tue Jun  6 15:34:51 2023 [51412] process command: CursorFirstRow
Tue Jun  6 15:34:51 2023 [51412] new screen size 44 178
Tue Jun  6 15:34:51 2023 [51412] releasing cmd bar
Tue Jun  6 15:34:51 2023 [51412] process command: ShowMenu
Tue Jun  6 15:34:51 2023 [51412] init menu
Tue Jun  6 15:34:53 2023 [51412] new screen size 44 178
Tue Jun  6 15:34:53 2023 [51412] releasing cmd bar
Tue Jun  6 15:34:53 2023 [51412] process command: SaveAsCSV
Tue Jun  6 15:34:53 2023 [51412] history loaded
Tue Jun  6 15:34:53 2023 [51412] input string prompt - "save to CSV file: "
Tue Jun  6 15:34:53 2023 [51412] xterm mouse mode 1002 is not active
Tue Jun  6 15:35:00 2023 [51412] xterm mouse mode 1002 is not activated
Tue Jun  6 15:35:00 2023 [51412] input string - "~/test.csv"
Tue Jun  6 15:35:00 2023 [51412] exported 498 rows with result 1
Tue Jun  6 15:35:00 2023 [51412] new screen size 44 178
Tue Jun  6 15:35:00 2023 [51412] releasing cmd bar

[okbob]

út 6. 6. 2023 v 9:36 odesílatel starlord @.***> napsal:

ok here's the new log with connecting to my RDS.

Tue Jun 6 15:34:29 2023 [51412] started Tue Jun 6 15:34:29 2023 [51412] with utf8 support Tue Jun 6 15:34:29 2023 [51412] esc delay = -1 Tue Jun 6 15:34:29 2023 [51412] DataDesc is initialized Tue Jun 6 15:34:29 2023 [51412] next row will be data row Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 500 row Tue Jun 6 15:34:29 2023 [51412] read rows 500 Tue Jun 6 15:34:29 2023 [51412] read input 500 rows Tue Jun 6 15:34:29 2023 [51412] terminal size by TIOCGWINSZ rows: 44, cols: 178 Tue Jun 6 15:34:29 2023 [51412] ncurses started Tue Jun 6 15:34:29 2023 [51412] without xterm mouse mode support Tue Jun 6 15:34:29 2023 [51412] initial stdscr size - maxy: 44, maxx: 178 Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 2500 row Tue Jun 6 15:34:29 2023 [51412] read rows 2500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 4500 row Tue Jun 6 15:34:29 2023 [51412] read rows 4500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 6500 row Tue Jun 6 15:34:29 2023 [51412] read rows 6500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 8500 row Tue Jun 6 15:34:29 2023 [51412] read rows 8500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 10500 row Tue Jun 6 15:34:29 2023 [51412] read rows 10500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 12500 row Tue Jun 6 15:34:29 2023 [51412] read rows 12500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 14500 row Tue Jun 6 15:34:29 2023 [51412] read rows 14500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 16500 row Tue Jun 6 15:34:29 2023 [51412] read rows 16500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 18500 row Tue Jun 6 15:34:29 2023 [51412] read rows 18500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 20500 row Tue Jun 6 15:34:29 2023 [51412] read rows 20500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 22500 row Tue Jun 6 15:34:29 2023 [51412] read rows 22500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 24500 row Tue Jun 6 15:34:29 2023 [51412] read rows 24500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 26500 row Tue Jun 6 15:34:29 2023 [51412] read rows 26500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 28500 row Tue Jun 6 15:34:29 2023 [51412] read rows 28500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 30500 row Tue Jun 6 15:34:29 2023 [51412] read rows 30500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 32500 row Tue Jun 6 15:34:29 2023 [51412] read rows 32500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 34500 row Tue Jun 6 15:34:29 2023 [51412] read rows 34500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 36500 row Tue Jun 6 15:34:29 2023 [51412] read rows 36500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 38500 row Tue Jun 6 15:34:29 2023 [51412] read rows 38500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 40500 row Tue Jun 6 15:34:29 2023 [51412] read rows 40500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 42500 row Tue Jun 6 15:34:29 2023 [51412] read rows 42500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 44500 row Tue Jun 6 15:34:29 2023 [51412] read rows 44500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 46500 row Tue Jun 6 15:34:29 2023 [51412] read rows 46500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 48500 row Tue Jun 6 15:34:29 2023 [51412] read rows 48500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 50500 row Tue Jun 6 15:34:29 2023 [51412] read rows 50500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 52500 row Tue Jun 6 15:34:29 2023 [51412] read rows 52500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 54500 row Tue Jun 6 15:34:29 2023 [51412] read rows 54500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 56500 row Tue Jun 6 15:34:29 2023 [51412] read rows 56500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 58500 row Tue Jun 6 15:34:29 2023 [51412] read rows 58500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 60500 row Tue Jun 6 15:34:29 2023 [51412] read rows 60500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 62500 row Tue Jun 6 15:34:29 2023 [51412] read rows 62500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 64500 row Tue Jun 6 15:34:29 2023 [51412] read rows 64500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 66500 row Tue Jun 6 15:34:29 2023 [51412] read rows 66500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 68500 row Tue Jun 6 15:34:29 2023 [51412] read rows 68500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 70500 row Tue Jun 6 15:34:29 2023 [51412] read rows 70500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 72500 row Tue Jun 6 15:34:29 2023 [51412] read rows 72500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 74500 row Tue Jun 6 15:34:29 2023 [51412] read rows 74500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 76500 row Tue Jun 6 15:34:29 2023 [51412] read rows 76500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 78500 row Tue Jun 6 15:34:29 2023 [51412] read rows 78500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 80500 row Tue Jun 6 15:34:29 2023 [51412] read rows 80500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 82500 row Tue Jun 6 15:34:29 2023 [51412] read rows 82500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 84500 row Tue Jun 6 15:34:29 2023 [51412] read rows 84500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 86500 row Tue Jun 6 15:34:29 2023 [51412] read rows 86500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 88500 row Tue Jun 6 15:34:29 2023 [51412] read rows 88500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 90500 row Tue Jun 6 15:34:29 2023 [51412] read rows 90500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 92500 row Tue Jun 6 15:34:29 2023 [51412] read rows 92500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 94500 row Tue Jun 6 15:34:29 2023 [51412] read rows 94500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 96500 row Tue Jun 6 15:34:29 2023 [51412] read rows 96500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 98500 row Tue Jun 6 15:34:29 2023 [51412] read rows 98500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 100500 row Tue Jun 6 15:34:29 2023 [51412] read rows 100500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 102500 row Tue Jun 6 15:34:29 2023 [51412] read rows 102500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 104500 row Tue Jun 6 15:34:29 2023 [51412] read rows 104500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 106500 row Tue Jun 6 15:34:29 2023 [51412] read rows 106500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 108500 row Tue Jun 6 15:34:29 2023 [51412] read rows 108500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 110500 row Tue Jun 6 15:34:29 2023 [51412] read rows 110500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 112500 row Tue Jun 6 15:34:29 2023 [51412] read rows 112500 Tue Jun 6 15:34:29 2023 [51412] process command: Invalid Tue Jun 6 15:34:29 2023 [51412] progressive load stop on 114500 row Tue Jun 6 15:34:29 2023 [51412] read rows 114500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 116500 row Tue Jun 6 15:34:30 2023 [51412] read rows 116500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 118500 row Tue Jun 6 15:34:30 2023 [51412] read rows 118500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 120500 row Tue Jun 6 15:34:30 2023 [51412] read rows 120500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 122500 row Tue Jun 6 15:34:30 2023 [51412] read rows 122500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 124500 row Tue Jun 6 15:34:30 2023 [51412] read rows 124500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 126500 row Tue Jun 6 15:34:30 2023 [51412] read rows 126500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 128500 row Tue Jun 6 15:34:30 2023 [51412] read rows 128500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 130500 row Tue Jun 6 15:34:30 2023 [51412] read rows 130500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 132500 row Tue Jun 6 15:34:30 2023 [51412] read rows 132500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 134500 row Tue Jun 6 15:34:30 2023 [51412] read rows 134500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 136500 row Tue Jun 6 15:34:30 2023 [51412] read rows 136500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 138500 row Tue Jun 6 15:34:30 2023 [51412] read rows 138500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 140500 row Tue Jun 6 15:34:30 2023 [51412] read rows 140500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 142500 row Tue Jun 6 15:34:30 2023 [51412] read rows 142500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 144500 row Tue Jun 6 15:34:30 2023 [51412] read rows 144500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 146500 row Tue Jun 6 15:34:30 2023 [51412] read rows 146500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 148500 row Tue Jun 6 15:34:30 2023 [51412] read rows 148500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 150500 row Tue Jun 6 15:34:30 2023 [51412] read rows 150500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 152500 row Tue Jun 6 15:34:30 2023 [51412] read rows 152500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 154500 row Tue Jun 6 15:34:30 2023 [51412] read rows 154500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 156500 row Tue Jun 6 15:34:30 2023 [51412] read rows 156500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 158500 row Tue Jun 6 15:34:30 2023 [51412] read rows 158500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 160500 row Tue Jun 6 15:34:30 2023 [51412] read rows 160500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 162500 row Tue Jun 6 15:34:30 2023 [51412] read rows 162500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 164500 row Tue Jun 6 15:34:30 2023 [51412] read rows 164500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 166500 row Tue Jun 6 15:34:30 2023 [51412] read rows 166500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 168500 row Tue Jun 6 15:34:30 2023 [51412] read rows 168500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 170500 row Tue Jun 6 15:34:30 2023 [51412] read rows 170500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 172500 row Tue Jun 6 15:34:30 2023 [51412] read rows 172500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 174500 row Tue Jun 6 15:34:30 2023 [51412] read rows 174500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 176500 row Tue Jun 6 15:34:30 2023 [51412] read rows 176500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 178500 row Tue Jun 6 15:34:30 2023 [51412] read rows 178500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 180500 row Tue Jun 6 15:34:30 2023 [51412] read rows 180500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 182500 row Tue Jun 6 15:34:30 2023 [51412] read rows 182500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 184500 row Tue Jun 6 15:34:30 2023 [51412] read rows 184500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 186500 row Tue Jun 6 15:34:30 2023 [51412] read rows 186500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 188500 row Tue Jun 6 15:34:30 2023 [51412] read rows 188500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 190500 row Tue Jun 6 15:34:30 2023 [51412] read rows 190500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 192500 row Tue Jun 6 15:34:30 2023 [51412] read rows 192500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 194500 row Tue Jun 6 15:34:30 2023 [51412] read rows 194500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 196500 row Tue Jun 6 15:34:30 2023 [51412] read rows 196500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 198500 row Tue Jun 6 15:34:30 2023 [51412] read rows 198500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 200500 row Tue Jun 6 15:34:30 2023 [51412] read rows 200500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 202500 row Tue Jun 6 15:34:30 2023 [51412] read rows 202500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 204500 row Tue Jun 6 15:34:30 2023 [51412] read rows 204500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 206500 row Tue Jun 6 15:34:30 2023 [51412] read rows 206500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 208500 row Tue Jun 6 15:34:30 2023 [51412] read rows 208500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 210500 row Tue Jun 6 15:34:30 2023 [51412] read rows 210500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 212500 row Tue Jun 6 15:34:30 2023 [51412] read rows 212500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 214500 row Tue Jun 6 15:34:30 2023 [51412] read rows 214500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 216500 row Tue Jun 6 15:34:30 2023 [51412] read rows 216500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 218500 row Tue Jun 6 15:34:30 2023 [51412] read rows 218500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 220500 row Tue Jun 6 15:34:30 2023 [51412] read rows 220500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 222500 row Tue Jun 6 15:34:30 2023 [51412] read rows 222500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 224500 row Tue Jun 6 15:34:30 2023 [51412] read rows 224500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 226500 row Tue Jun 6 15:34:30 2023 [51412] read rows 226500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 228500 row Tue Jun 6 15:34:30 2023 [51412] read rows 228500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 230500 row Tue Jun 6 15:34:30 2023 [51412] read rows 230500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 232500 row Tue Jun 6 15:34:30 2023 [51412] read rows 232500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 234500 row Tue Jun 6 15:34:30 2023 [51412] read rows 234500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 236500 row Tue Jun 6 15:34:30 2023 [51412] read rows 236500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 238500 row Tue Jun 6 15:34:30 2023 [51412] read rows 238500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 240500 row Tue Jun 6 15:34:30 2023 [51412] read rows 240500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] progressive load stop on 242500 row Tue Jun 6 15:34:30 2023 [51412] read rows 242500 Tue Jun 6 15:34:30 2023 [51412] process command: Invalid Tue Jun 6 15:34:30 2023 [51412] read rows 243718 Tue Jun 6 15:34:31 2023 [51412] process command: Invalid Tue Jun 6 15:34:32 2023 [51412] process command: Invalid Tue Jun 6 15:34:32 2023 [51412] process command: CursorLastRow Tue Jun 6 15:34:32 2023 [51412] new screen size 44 178 Tue Jun 6 15:34:32 2023 [51412] releasing cmd bar Tue Jun 6 15:34:50 2023 [51412] process command: Invalid Tue Jun 6 15:34:51 2023 [51412] process command: CursorFirstRow Tue Jun 6 15:34:51 2023 [51412] new screen size 44 178 Tue Jun 6 15:34:51 2023 [51412] releasing cmd bar Tue Jun 6 15:34:51 2023 [51412] process command: CursorFirstRow Tue Jun 6 15:34:51 2023 [51412] new screen size 44 178 Tue Jun 6 15:34:51 2023 [51412] releasing cmd bar Tue Jun 6 15:34:51 2023 [51412] process command: ShowMenu Tue Jun 6 15:34:51 2023 [51412] init menu Tue Jun 6 15:34:53 2023 [51412] new screen size 44 178 Tue Jun 6 15:34:53 2023 [51412] releasing cmd bar Tue Jun 6 15:34:53 2023 [51412] process command: SaveAsCSV Tue Jun 6 15:34:53 2023 [51412] history loaded Tue Jun 6 15:34:53 2023 [51412] input string prompt - "save to CSV file: " Tue Jun 6 15:34:53 2023 [51412] xterm mouse mode 1002 is not active Tue Jun 6 15:35:00 2023 [51412] xterm mouse mode 1002 is not activated Tue Jun 6 15:35:00 2023 [51412] input string - "~/test.csv" Tue Jun 6 15:35:00 2023 [51412] exported 498 rows with result 1 Tue Jun 6 15:35:00 2023 [51412] new screen size 44 178 Tue Jun 6 15:35:00 2023 [51412] releasing cmd bar

this is interesting - it looks so this issue depends on progressive load

— Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223#issuecomment-1578088085, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4Z2L34HM7Z3QNMAUPDXJ3MYBANCNFSM6AAAAAAYYQRMWM . You are receiving this because you commented.Message ID: @.***>

[okbob]

I found it. The temporary workaround is setting border \pset border 2

[cmabastar]

OK here's the log.

mylog.txt

[cmabastar]

tried the border change but didn't work.

[okbob]

st 7. 6. 2023 v 4:56 odesílatel starlord @.***> napsal:

OK here's the log.

mylog.txt https://github.com/okbob/pspg/files/11672062/mylog.txt

this issue is related to reading one column data in progressive mode without outside borders.

— Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223#issuecomment-1579790820, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO47WDYT35PZGFDKJZOLXJ7UU5ANCNFSM6AAAAAAYYQRMWM . You are receiving this because you commented.Message ID: @.***>

[okbob]

st 7. 6. 2023 v 5:00 odesílatel starlord @.***> napsal:

tried the border change but didn't work.

Maybe there are other dependencies, but it is working on my computer. I'll try to fix what I investigated and after it we can investigated others

— Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223#issuecomment-1579793332, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4ZH4KT7BFJ5ANY2XCLXJ7VD7ANCNFSM6AAAAAAYYQRMWM . You are receiving this because you commented.Message ID: @.***>

[okbob]

can you try --no-progressive-load option?

[cmabastar]

mylog.txt

Still not working, not sure if that option worked when i added in my PSPG

\setenv PSPG "--log=~/mylog.txt --no-progressive-load"

[okbob]

please, can you check 9042608 commit?

The disadvantage of your issue is usage probably border 1 and one column result. In this case, the pspg missing some indices necessary to correctly detect all attributes of format. The unicode border lines and border format 2 are much safer combination, there are enough (and partially redundant) information about table structure.

[cmabastar]

mylog.txt

@okbob thanks! This patch seems to be work!

[okbob]

čt 8. 6. 2023 v 6:45 odesílatel starlord @.***> napsal:

mylog.txt https://github.com/okbob/pspg/files/11684104/mylog.txt

@okbob https://github.com/okbob thanks! This patch seems to be work!

great

— Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/223#issuecomment-1581883480, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO452X7ROZUCRZN5SYFLXKFKFLANCNFSM6AAAAAAYYQRMWM . You are receiving this because you were mentioned.Message ID: @.***>