| chat.freenode.net #tryton log beginning Thu 10 Oct 2019 12:00:01 AM CEST | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 22:42 | |
| -!- yangoon(~mathiasb@107-160-142-46.pool.kielnet.net) has joined #tryton | 02:27 | |
| -!- nminix__(~greta@123-243-101-209.static.tpgi.com.au) has joined #tryton | 02:49 | |
| -!- thaneor1(~lenovo3@r179-24-118-65.dialup.adsl.anteldata.net.uy) has joined #tryton | 03:38 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 04:37 | |
| -!- odicha(~odicha@91.142.107.66) has joined #tryton | 05:16 | |
| -!- hedererjs(~hedererjs@81.56.169.23) has joined #tryton | 05:38 | |
| -!- nminix__(~greta@123-243-101-209.static.tpgi.com.au) has left #tryton | 05:50 | |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 06:22 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 06:25 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 06:54 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:08 | |
| -!- thaneor(~lenovo3@r179-24-118-65.dialup.adsl.anteldata.net.uy) has joined #tryton | 07:26 | |
| mrichez | hi, after a pull update on trytond test installation, i launch command trytond-admin -c ... -d .... --all -vvv ... it seems blocked... here's the last query displayed: | 07:38 |
|---|---|---|
| mrichez | https://pastebin.com/4L278Ver | 07:38 |
| mrichez | how to know which module is faulty for this blocked query ? | 07:39 |
| mrichez | after ctrl-break... i retry same command with -u country ... the problems seems there | 07:40 |
| semarie | mrichez: which trytond version ? what is the process state for trytond-admin or postgresql processes ? busy, locked, idle ? | 07:45 |
| mrichez | semarie: trytond tip (5.3); don't know the state (100% cpu used) running | 07:48 |
| mrichez | infinite loop or query ? | 07:49 |
| semarie | here, I am fine with effd37625813 (tryton-env) | 07:59 |
| semarie | but we might not using the same modules | 07:59 |
| mrichez | semarie: indeed, will retry with fresh install (but got same problem on 2 different installations) | 08:00 |
| -!- nicoe(~nicoe@2a02:2788:54:5a3:7e2a:31ff:fe5e:b25d) has joined #tryton | 08:16 | |
| mrichez | hi, following previous discussion, i'm retrying on a fresh install 5.3 dev,... activating country and currency modules... executing first script to import countries, got this error: https://pastebin.com/59pDn3Jy | 09:09 |
| -!- Timitos(~kpreisler@2001:a61:5a4:b101:762b:62ff:fe84:ed7e) has joined #tryton | 09:10 | |
| pokoli | mrichez: You should report this as a bug | 09:31 |
| mrichez | pokoli: ok | 09:31 |
| pokoli | mrichez: it will be great to know which pycountry version you have installed | 09:35 |
| mrichez | pokoli: pycountry 19.8.18 | 09:36 |
| pokoli | mrichez: have you tested with previous pycountry version? | 09:36 |
| mrichez | pokoli: no | 09:37 |
| pokoli | mrichez: as it seems that the problem is data related (but probably the script should not fail in such case), using the previous version may fix the issue | 09:37 |
| mrichez | semarie: and concerning my previous problem with query blocked, it is solved after a "Synchronize Translations" | 09:38 |
| mrichez | pokoli: will retry with a previous version | 09:38 |
| pokoli | ACTION checking with an older version | 09:39 |
| pokoli | mrichez: no error with pycountry==18.5.26 | 09:39 |
| mrichez | pokoli: ok, will check with 19.7.15 | 09:40 |
| mrichez | pokoli: still not working with 19.7.15 | 09:44 |
| mrichez | pokoli: another error with 18.12.8 : https://pastebin.com/Qd7P0a72 | 09:45 |
| mrichez | pokoli: same error with 18.5.26 : https://pastebin.com/Qd7P0a72 but maybe because i've already executed script ??? | 09:47 |
| pokoli | mrichez: this context error is strang and it should no happen | 09:48 |
| pokoli | mrichez: I tested creating a new database with only country module and executing the script | 09:48 |
| mrichez | pokoli: will scratch my db and retry | 09:57 |
| mrichez | pokoli: working on fresh database with 18.5.26 | 10:01 |
| mrichez | pokoli: working on fresh database with 18.12.8 | 10:07 |
| -!- udono(~udono@205-056-210-188.ip-addr.inexio.net) has joined #tryton | 10:11 | |
| mrichez | pokoli: error on fresh database with 19.7.15 : https://pastebin.com/fky976hY | 10:11 |
| cedk | it should be fixed with https://codereview.tryton.org/258231002 | 10:14 |
| cedk | pycountry has a strange management of parent_code and new version has more sub-subdivisions | 10:15 |
| mrichez | cedk: ok thanks :-) | 10:19 |
| cedk | indeed what happens is that pycountry append in parent_code always the country code but on the second level of the tree the country code is added twice | 10:24 |
| -!- hedererjs(~hedererjs@81.56.169.23) has joined #tryton | 11:22 | |
| mrichez | cedk: working with patch with pycountry 19.7.15 | 11:24 |
| -!- mrichez(~Maxime@mail.saluc.com) has joined #tryton | 11:45 | |
| -!- mariomop(~quassel@181.90.109.107) has joined #tryton | 11:51 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:19 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 12:54 | |
| -!- sebste(~sebste@x4db64f85.dyn.telefonica.de) has joined #tryton | 14:54 | |
| -!- smorillo(250f660a@gateway/web/cgi-irc/kiwiirc.com/ip.37.15.102.10) has joined #tryton | 14:58 | |
| sebste | cedk: Good evening! You there? | 15:15 |
| pokoli | sebste: good evening, I'm hereee :) | 15:21 |
| sebste | pokoli: Oh, hi! That's also awesome! :-D | 15:21 |
| sebste | Not sure if you followed the discussion last time... cedk suggested to rename the _temp_month column .... | 15:23 |
| sebste | in account_invoice_payment_term_line_delta | 15:23 |
| pokoli | sebste: yes, I've read it and I remember | 15:23 |
| sebste | appearently trytond-admin did not finish the update | 15:23 |
| sebste | So I managed to do that. | 15:24 |
| sebste | When I rerun trytond-admin -c /etc/tryton/trytond.conf -d /home/tryton_sys/tryton5_lcc_db --all I run into another problem (maybe the initial one | 15:24 |
| sebste | ) | 15:24 |
| sebste | It fails with: sqlite3.OperationalError: index account_invoice_payment_term_line_delta__history_id_index already exists | 15:25 |
| sebste | After that, the same _temp_mont column is bach in the schema | 15:25 |
| sebste | any pointers on how to chase such a failing update down? Problem is I don't even understand how trytond-admin does these db updates | 15:27 |
| sebste | or where to start looking | 15:27 |
| pokoli | mmm it seems that it fails when creating an index on hte __history table | 15:27 |
| pokoli | the __history table is there to save all the modifications done to the payment_term_line_delta table | 15:28 |
| pokoli | sebste: probably manually removing the index (and the temp column) should fix it | 15:28 |
| sebste | pokoli: ok? so how would i remove the index? | 15:30 |
| sebste | pokoli: sorry for bothering you with probably basic questions. | 15:31 |
| pokoli | sebste: https://www.sqlite.org/lang_dropindex.html | 15:32 |
| sebste | pokoli: so basically :DROP INDEX account_invoice_payment_term_line_delta__history_id_index; ? | 15:34 |
| pokoli | pokoli: drop the index, drop the column and execute tryton-admin another time | 15:35 |
| pokoli | sebste: tryton-admin checks the database structure and creates the missing fields, executes migrations and so one | 15:35 |
| sebste | pokoli: thanks. That worked!!! You are awesome! | 15:39 |
| pokoli | sebste: indeed you did all the work which was finding the root cause of the problem | 15:39 |
| -!- rpit(~rpit@p4FF497C4.dip0.t-ipconnect.de) has joined #tryton | 15:40 | |
| sebste | pokoli: yea, but I dod not know what I lokked at :-D | 15:40 |
| sebste | By the way... can I ask another question? What would be the proper way to switch from minimal chart of accounts to another one like say SKR03? | 15:42 |
| pokoli | sebste: indeed your case is very strange | 15:42 |
| pokoli | sebste: you can install the new module and then create the new chart of accounts | 15:42 |
| pokoli | sebste: you will get a warning about a duplicate chat but you can ingnore it | 15:43 |
| pokoli | sebste: and then it's a mather of removing the miniaml account data | 15:43 |
| pokoli | sebste: did you have any account_moves on the system? | 15:43 |
| sebste | yes, for testing, generated by invoices, i guess, but nothing relevant | 15:44 |
| -!- smorillo(250f660a@gateway/web/cgi-irc/kiwiirc.com/ip.37.15.102.10) has joined #tryton | 15:45 | |
| pokoli | sebste: if you only have testing data probably it's worth to remove the database and start with a fresh one | 15:45 |
| pokoli | sebste: in this case you can also switch from sqlite to postgresql | 15:46 |
| sebste | pokoli: yes, I was thinking about that... thing is I already invested in a lot of configuration / translation which I would have to redo. If there is a way around that I would not be angy. | 15:47 |
| sebste | Was also thinking of migrating the existing db to postgresql. Though I like the lightness of sqlite and performance will not be an issue. | 15:49 |
| pokoli | sebste: we have a script to migrate from sqlite to postgresql: http://hg.tryton.org/tryton-tools/file/f7c83f70489f/sqlite2pg.py | 15:55 |
| pokoli | sebste: but i've never used it | 15:56 |
| pokoli | sebste: if you want to keep the existing data is a mather of removing the data from the invoices, accounting, and all the chart configuration | 15:56 |
| pokoli | sebste: there are some models that should be deleted | 15:56 |
| sebste | pokoli: Oh, that's cool! I'll have a look, thanks | 15:57 |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 21:21 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!