refs/heads/dev-parth @ c267923
← Dashboard
[build_instance] Creating MySQL database: clevara_rb_dev_parth_c267923
mysql: [Warning] Using a password on the command line interface can be insecure.
[build_instance] Setting up Python venv
[build_instance] Running migrations
Error during missing tables bootstrapping: (pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_DATE, \n\tpayment_type VARCHAR(16) NOT NULL, \n\tpartner_type VARCHAR(16), \n' at line 4")
[SQL:
CREATE TABLE account_payments (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(64),
date DATE DEFAULT CURRENT_DATE,
payment_type VARCHAR(16) NOT NULL,
partner_type VARCHAR(16),
partner_id INTEGER,
amount FLOAT NOT NULL,
currency_id INTEGER,
journal_id INTEGER NOT NULL,
payment_method_line_id INTEGER,
state VARCHAR(16),
move_id INTEGER,
ref VARCHAR(255),
memo TEXT,
is_reconciled BOOL DEFAULT '0',
is_matched BOOL DEFAULT '0',
partner_bank_id INTEGER,
source_payment_id INTEGER,
qr_code_data TEXT,
tenant_id INTEGER,
company_id INTEGER,
branch_id INTEGER,
create_date DATETIME DEFAULT (now()),
write_date DATETIME DEFAULT (now()),
active BOOL NOT NULL,
create_uid INTEGER,
write_uid INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(partner_id) REFERENCES contacts (id),
FOREIGN KEY(currency_id) REFERENCES res_currency (id),
FOREIGN KEY(journal_id) REFERENCES account_journals (id),
FOREIGN KEY(payment_method_line_id) REFERENCES account_payment_method_lines (id) ON DELETE SET NULL,
FOREIGN KEY(move_id) REFERENCES account_moves (id),
FOREIGN KEY(partner_bank_id) REFERENCES res_partner_banks (id) ON DELETE SET NULL,
FOREIGN KEY(source_payment_id) REFERENCES account_payments (id) ON DELETE SET NULL,
FOREIGN KEY(tenant_id) REFERENCES tenants (id),
FOREIGN KEY(company_id) REFERENCES companies (id),
FOREIGN KEY(branch_id) REFERENCES branches (id),
FOREIGN KEY(create_uid) REFERENCES users (id),
FOREIGN KEY(write_uid) REFERENCES users (id)
)
]
(Background on this error at: https://sqlalche.me/e/20/f405)
Traceback (most recent call last):
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
cursor.execute(statement, parameters)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 159, in execute
result = self._query(query)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 330, in _query
conn.query(q)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 582, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 847, in _read_query_result
result.read()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 1245, in read
first_packet = self.connection._read_packet()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 803, in _read_packet
packet.raise_for_error()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/err.py", line 154, in raise_mysql_exception
raise errorclass(errno, errval, sqlstate=sqlstate)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_DATE, \n\tpayment_type VARCHAR(16) NOT NULL, \n\tpartner_type VARCHAR(16), \n' at line 4")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/app/db/migrations/auto_migrate.py", line 45, in create_missing_tables
Base.metadata.create_all(bind=conn)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/schema.py", line 5930, in create_all
bind._run_ddl_visitor(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2469, in _run_ddl_visitor
).traverse_single(element)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 661, in traverse_single
return meth(obj, **kw)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 985, in visit_metadata
self.traverse_single(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/visitors.py", line 661, in traverse_single
return meth(obj, **kw)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 1023, in visit_table
)._invoke_with(self.connection)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 322, in _invoke_with
return bind.execute(self)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1421, in execute
return meth(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/sql/ddl.py", line 188, in _execute_on_connection
return connection._execute_ddl(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1532, in _execute_ddl
ret = self._execute_context(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2365, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
cursor.execute(statement, parameters)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 159, in execute
result = self._query(query)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 330, in _query
conn.query(q)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 582, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 847, in _read_query_result
result.read()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 1245, in read
first_packet = self.connection._read_packet()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/connections.py", line 803, in _read_packet
packet.raise_for_error()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error
err.raise_mysql_exception(self._data)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/pymysql/err.py", line 154, in raise_mysql_exception
raise errorclass(errno, errval, sqlstate=sqlstate)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_DATE, \n\tpayment_type VARCHAR(16) NOT NULL, \n\tpartner_type VARCHAR(16), \n' at line 4")
[SQL:
CREATE TABLE account_payments (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(64),
date DATE DEFAULT CURRENT_DATE,
payment_type VARCHAR(16) NOT NULL,
partner_type VARCHAR(16),
partner_id INTEGER,
amount FLOAT NOT NULL,
currency_id INTEGER,
journal_id INTEGER NOT NULL,
payment_method_line_id INTEGER,
state VARCHAR(16),
move_id INTEGER,
ref VARCHAR(255),
memo TEXT,
is_reconciled BOOL DEFAULT '0',
is_matched BOOL DEFAULT '0',
partner_bank_id INTEGER,
source_payment_id INTEGER,
qr_code_data TEXT,
tenant_id INTEGER,
company_id INTEGER,
branch_id INTEGER,
create_date DATETIME DEFAULT (now()),
write_date DATETIME DEFAULT (now()),
active BOOL NOT NULL,
create_uid INTEGER,
write_uid INTEGER,
PRIMARY KEY (id),
FOREIGN KEY(partner_id) REFERENCES contacts (id),
FOREIGN KEY(currency_id) REFERENCES res_currency (id),
FOREIGN KEY(journal_id) REFERENCES account_journals (id),
FOREIGN KEY(payment_method_line_id) REFERENCES account_payment_method_lines (id) ON DELETE SET NULL,
FOREIGN KEY(move_id) REFERENCES account_moves (id),
FOREIGN KEY(partner_bank_id) REFERENCES res_partner_banks (id) ON DELETE SET NULL,
FOREIGN KEY(source_payment_id) REFERENCES account_payments (id) ON DELETE SET NULL,
FOREIGN KEY(tenant_id) REFERENCES tenants (id),
FOREIGN KEY(company_id) REFERENCES companies (id),
FOREIGN KEY(branch_id) REFERENCES branches (id),
FOREIGN KEY(create_uid) REFERENCES users (id),
FOREIGN KEY(write_uid) REFERENCES users (id)
)
]
(Background on this error at: https://sqlalche.me/e/20/f405)
Could not upgrade to 1d32aac02330: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
Could not upgrade to 90c24c7ef982: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)
MIGRATIONS_OK
[build_instance] Bootstrapping tenant/company/superuser
(trapped) error reading bcrypt version
Traceback (most recent call last):
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 620, in _load_backend_mixin
version = _bcrypt.__about__.__version__
AttributeError: module 'bcrypt' has no attribute '__about__'
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/scripts/bootstrap_instance.py", line 91, in main
password_hash=hash_password(superuser_password),
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/app/shared/security.py", line 6, in hash_password
return pwd_context.hash(password)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/context.py", line 2258, in hash
return record.hash(secret, **kwds)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 779, in hash
self.checksum = self._calc_checksum(secret)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 591, in _calc_checksum
self._stub_requires_backend()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2254, in _stub_requires_backend
cls.set_backend()
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2156, in set_backend
return owner.set_backend(name, dryrun=dryrun)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2163, in set_backend
return cls.set_backend(name, dryrun=dryrun)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2188, in set_backend
cls._set_backend(name, dryrun)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2311, in _set_backend
super(SubclassBackendMixin, cls)._set_backend(name, dryrun)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 2224, in _set_backend
ok = loader(**kwds)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 626, in _load_backend_mixin
return mixin_cls._finalize_backend_mixin(name, dryrun)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 421, in _finalize_backend_mixin
if detect_wrap_bug(IDENT_2A):
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 380, in detect_wrap_bug
if verify(secret, bug_hash):
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/utils/handlers.py", line 792, in verify
return consteq(self._calc_checksum(secret), chk)
File "/var/lib/clevara-runbot/builds/dev-parth-c267923/src/backend/venv/lib/python3.10/site-packages/passlib/handlers/bcrypt.py", line 655, in _calc_checksum
hash = _bcrypt.hashpw(secret, config)
ValueError: password cannot be longer than 72 bytes, truncate manually if necessary (e.g. my_password[:72])
=== Build dev-parth-c267923 started ===